SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 26 | Using where |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 2 | Using where |
SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT data_value FROM xf_data_registry WHERE data_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT user.* , user_profile.*, user_option.*, user_privacy.*, 0 AS following_0, 0 AS friends_0 ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,2,4,5,6,8)) as positive_rating_count , (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,2,4,5,6,8)), 0)) as positive_rating_count_incl_likes ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (3)) as neutral_rating_count ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count ,snog_socialgroups.socialgroups,snog_socialgroups.groupmoderator,snog_pendinggroups.pendinggroups FROM xf_user AS user LEFT JOIN xf_user_profile AS user_profile ON (user_profile.user_id = user.user_id) LEFT JOIN xf_user_option AS user_option ON (user_option.user_id = user.user_id) LEFT JOIN xf_user_privacy AS user_privacy ON (user_privacy.user_id = user.user_id) LEFT JOIN xf_snog_socialgroup_members AS snog_socialgroups ON (snog_socialgroups.user_id = user.user_id) LEFT JOIN xf_snog_socialgroup_members_pending AS snog_pendinggroups ON (snog_pendinggroups.user_id = user.user_id) WHERE user.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
PRIMARY | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | snog_socialgroups | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
PRIMARY | snog_pendinggroups | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 1 | |
DEPENDENT SUBQUERY | no matching row in const table | |||||||
DEPENDENT SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | 6 | Using index condition | |
DEPENDENT SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | 6 | Using index condition |
SELECT trophy.*, user_trophy.award_date FROM xf_user_trophy AS user_trophy INNER JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id) WHERE user_trophy.user_id = ? ORDER BY user_trophy.award_date DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | user_id_award_date | 4 | const | 1 | Using where; Using index |
SIMPLE | trophy | eq_ref | PRIMARY | PRIMARY | 4 | thevog_net.user_trophy.trophy_id | 1 |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
INSERT INTO xf_session_activity (user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date), robot_key = VALUES(robot_key)
SELECT * FROM classifieds_items WHERE starts >= 1614211200 AND active=1 AND status <> 2 AND feespaid = 1 ORDER BY starts DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | classifieds_items | range | starts | starts | 4 | 3 | Using index condition; Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('home', 'snog_socialgroups_groups', 'classifieds_forsale')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | 3 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('classifieds_at')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('MicroClassifieds_navbar')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('page_nav', 'wf_widget_wrapper', 'wf_widget_threads', 'member_trophies', 'EWRporta_Navtabs', 'snog_socialgroups_navlinks', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_navbar_template', 'MicroClassifieds_navigation_tabs', 'EWRatendo_Navtabs', 'wf_hook_moderator_bar', 'wf_revealer', 'findme', 'waindigo_you_are_using_as_user_loginasuser', 'waindigo_moderator_bar_loginasuser', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'sonnb_xengallery_nav_visitor', 'PAGE_CONTAINER') AND style_id = ? AND language_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | 31 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('events')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('wfc__1_member_trophies')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('wfc_cce42e7684f61092ee48c')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
INSERT INTO xf_data_registry (data_key, data_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
SELECT * FROM xf_node ORDER BY lft ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | ALL | 382 | Using filesort |
SELECT content_id, cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = 'node'
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 820 | Using where |
SELECT thread.* , user.gender, user.avatar_date, user.gravatar,snog_socialgroup.groupid, snog_socialgroup.owner_id, snog_socialgroup.name, snog_socialgroup.privategroup, snog_socialgroup.privatehide, snog_socialgroup.hasdiscussion, snog_socialgroup.hasforum, snog_socialgroup.hasalbum, snog_socialgroup.albumview, snog_socialgroup.discussionview, snog_socialgroup.postview, snog_socialgroup.groupavatar, snog_socialgroup.groupbanner, snog_socialgroup.category_id, snog_socialgroup.album_id FROM xf_thread AS thread LEFT JOIN xf_user AS user ON (user.user_id = thread.user_id) LEFT JOIN xf_snog_socialgroup AS snog_socialgroup ON (snog_socialgroup.node_id = thread.node_id) WHERE (((thread.node_id IN (256, 257, 258, 259, 260, 261, 6, 262, 7, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 294, 295, 296, 297, 306, 310, 311, 324, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 185, 186, 187, 188, 189, 190, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 8, 149, 487, 94, 91, 386, 99, 485, 100, 101, 104, 293, 105, 92, 385, 360, 363, 361, 362, 322, 321, 320, 319, 318, 391, 336, 335, 334, 315, 314, 313, 93, 106, 369, 370, 371, 107, 332, 333, 108, 433, 441, 109, 110, 111, 112, 337, 338, 339, 340, 113, 191, 114, 115, 387, 116, 117, 118, 358, 359, 119, 120, 103, 121, 122, 123, 124, 125, 146, 126, 389, 390, 481, 127, 102, 382, 493, 128, 129, 130, 364, 367, 366, 365, 354, 353, 352, 351, 350, 132, 393, 401, 409, 131, 133, 134, 135, 346, 347, 136, 137, 138, 417, 425, 348, 349, 139, 140, 141, 142, 477, 479, 147, 143, 388, 356, 357, 355, 145, 144, 148, 489, 491, 316, 465, 473, 95, 184, 325, 326, 97, 317, 98, 96, 342, 343, 344, 205, 150, 298, 307, 81, 59, 29, 31, 32, 33, 299, 30, 27, 383, 330, 312, 82, 35, 44, 45, 88, 79, 61, 80, 26, 20, 75, 34, 37, 43, 74, 300, 63, 475, 65, 309, 85, 86, 87, 64, 66, 67, 68, 69, 70, 71, 72, 73, 308, 84, 301, 47, 48, 302, 36, 303, 76, 77, 78, 304, 341, 90, 483, 328, 345, 327, 329, 368, 372, 373, 384, 374, 375, 376, 377, 378, 379, 380, 381, 305, 449, 60, 38, 39, 40, 22, 23, 24, 41, 42, 49)) AND (thread.discussion_state IN ('visible')))) AND (thread.post_date > 1612205014) ORDER BY thread.view_count DESC LIMIT 15
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | thread | range | node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | 195 | Using index condition; Using where; Using filesort | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thevog_net.thread.user_id | 1 | |
SIMPLE | snog_socialgroup | ref | node_id | node_id | 4 | thevog_net.thread.node_id | 1 |
SELECT node.*, forum.* FROM xf_forum AS forum INNER JOIN xf_node AS node ON (node.node_id = forum.node_id) WHERE node.node_id IN (63, 60, 30, 27, 27, 60, 27, 63, 36, 35, 30, 29, 75, 44, 30)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | 9 | Using where | |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | thevog_net.node.node_id | 1 |
INSERT INTO xf_data_registry (data_key, data_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
INSERT INTO xf_data_registry (data_key, data_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
SELECT data_value FROM xf_data_registry WHERE data_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT * FROM `xf_ads` WHERE `active` = 1 ORDER BY `xf_ads`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_ads | ALL | 11 | Using where; Using filesort |
SELECT data_value FROM xf_data_registry WHERE data_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('nat_bodyjs') AND style_id = ? AND language_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 |