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 grp.*, user.*, guser.* FROM xf_snog_socialgroup AS grp LEFT JOIN xf_user AS user ON (user.user_id = grp.owner_id) LEFT JOIN xf_snog_socialgroup_members AS guser ON (guser.user_id = grp.owner_id) WHERE grp.groupid = 49
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | grp | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | guser | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT node.* FROM xf_node AS node WHERE node.node_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT * FROM xf_thread WHERE node_id = ? ORDER BY last_post_date DESC LIMIT 3
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | const | 1 | Using where |
SELECT discussion.*, user.* FROM xf_snog_socialgroup_discussions as discussion LEFT JOIN xf_user AS user ON (user.user_id = discussion.user_id) WHERE discussion.groupid = ? AND discussion.parent_id = 0 AND state = "visible" ORDER BY discussion.last_post_date DESC LIMIT 5
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | discussion | index_merge | parent_id,groupid | groupid,parent_id | 4,4 | 1 | Using intersect(groupid,parent_id); Using where; Using filesort | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thevog_net.discussion.user_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', 'snog_socialgroups_group', '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_64eaa44ff9f694d0cbf0d')
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_2eee109cab149245eff8a')
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 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 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 > 1612200983) 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 |