SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 39 | 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 tag_id FROM xf_tag WHERE use_count >= ? ORDER BY use_count DESC LIMIT 625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag | range | use_count | use_count | 4 | 1953 | Using where; Using index |
SELECT `xf_tag`.* FROM `xf_tag` WHERE (`xf_tag`.`tag_id` IN (13, 16, 75, 10, 12, 337, 25, 26, 911, 76, 716, 143, 1049, 120, 764, 705, 4, 892, 17, 1315, 1417, 11, 682, 1876, 490, 803, 72, 43, 30, 188, 770, 1354, 1006, 2350, 24, 54, 914, 397, 79, 683, 284, 2025, 14, 1382, 777, 295, 15, 1886, 329, 763, 762, 1019, 338, 1383, 780, 775, 2322, 1740, 496, 1351, 965, 609, 423, 39, 1714, 123, 113, 304, 162, 2152, 9, 605, 82, 204, 2428, 2327, 90, 1816, 118, 285, 606, 33, 18, 2436, 1656, 1177, 721, 47, 1992, 2288, 567, 2624, 822, 67, 203, 2300, 1600, 956, 457, 109, 2158, 1679, 400, 163, 2473, 502, 189, 124, 1858, 177, 173, 99, 1140, 172, 455, 1682, 1068, 927, 719, 641, 362, 274, 202, 45, 2129, 1098, 720, 417, 1521, 1513, 498, 2705, 2476, 2150, 1688, 1231, 711, 669, 587, 390, 1074, 495, 2453, 953, 2461, 1133, 889, 776, 418, 2619, 2574, 1859, 690, 2556, 2104, 1136, 1048, 800, 614, 403, 255, 105, 2561, 2091, 2089, 2058, 1730, 1512, 1020, 989, 884, 311, 298, 96, 51, 2368, 1824, 1168, 718, 454, 208, 95, 2123, 2008, 1715, 1663, 100, 2121, 1037, 963, 802, 190, 1883, 1818, 1731, 1705, 1403, 1298, 1287, 1081, 352, 2557, 2552, 2369, 1652, 1395, 1342, 1334, 1038, 772, 469, 148, 2549, 2225, 2151, 1904, 1884, 1853, 1171, 1104, 1013, 851, 823, 245, 101, 93, 2526, 2430, 2371, 2180, 1892, 1801, 1554, 1348, 346, 275, 1931, 1360, 1027, 443, 439, 151, 81, 71, 2586, 1808, 1712, 932, 779, 623, 598, 375, 244, 1, 2617, 2017, 1946, 1828, 1756, 1576, 1252, 1215, 978, 887, 837, 636, 548, 488, 407, 319, 2472, 2342, 1986, 1882, 1823, 1556, 1317, 1184, 1172, 1108, 1088, 1004, 794, 698, 689, 680, 616, 302, 80, 2539, 2223, 2019, 1803, 1544, 1391, 1335, 1167, 1147, 967, 912, 852, 627, 420, 330, 267, 110, 27, 2697, 2410, 2313, 2185, 2182, 2106, 2100, 2074, 1947, 1339, 1142, 710, 697, 629, 622, 588, 465, 273, 201, 122, 92, 91, 2326, 2277, 2009, 1950, 1865, 1839, 1833, 1812, 1419, 1368, 1353, 1285, 850, 470, 456, 408, 283, 254, 2742, 2457, 2367, 2274, 2128, 2047, 2020, 2003, 1982, 1959, 1742, 1701, 1547, 1546, 1349, 1085, 1069, 1054, 1040, 1021, 958, 925, 592, 480, 467, 328, 310, 138, 116, 74, 64, 44, 2710, 2695, 2423, 2372, 2358, 2309, 2290, 2107, 1984, 1923, 1794, 1340, 1266, 1052, 1046, 1030, 1022, 954, 856, 849, 848, 731, 677, 500, 468, 336, 270, 2846, 2668, 2615, 2593, 2540, 2530, 2376, 2359, 2357, 2354, 2286, 2186, 2075, 1948, 1915, 1692, 1577, 1169, 1141, 1097, 923, 855, 815, 476, 466, 442, 421, 396, 349, 323, 316, 268, 246, 42, 3, 2831, 2781, 2765, 2531, 2485, 2245, 2162, 2063, 2057, 1862, 1857, 1797, 1709, 1425, 1302, 1301, 1284, 1269, 1216, 1093, 1089, 894, 854, 787, 739, 737, 671, 662, 579, 478, 412, 277, 191, 171, 114, 5, 2918, 2789, 2780, 2594, 2569, 2533, 2532, 2508, 2456, 2445, 2433, 2421, 2370, 2366, 2250, 2213, 2142, 2097, 2096, 2081, 2079, 2010, 1967, 1949, 1926, 1900, 1881, 1835, 1793, 1765, 1729, 1669, 1528, 1522, 1426, 1408, 1374, 1331, 1255, 1205, 1103, 1078, 1018, 906, 729, 582, 458, 447, 383, 296, 278, 164, 104, 2819, 2709, 2658, 2657, 2655, 2648, 2642, 2641, 2568, 2555, 2522, 2506, 2474, 2460, 2432, 2418, 2392, 2352, 2295, 2292, 2287, 2265, 2229, 2080, 2021, 1995, 1924, 1917, 1889, 1856, 1834, 1737, 1727, 1606, 1584, 1583, 1548, 1440, 1421, 1418, 1407, 1396, 1306, 1228, 1214, 1191, 1170, 1152, 1144, 1115, 1105, 1091, 1090, 1051, 1050, 1026, 1015, 988, 959, 898, 885, 828, 733, 695, 693, 611, 542, 444, 410, 388, 387, 331, 306, 290, 266, 187, 133, 108, 106, 31, 2924, 2921, 2776, 2686, 2683, 2671, 2660, 2636, 2548, 2501, 2462, 2420, 2341, 2337, 2331)) ORDER BY `xf_tag`.`tag` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag | ALL | PRIMARY | 2176 | Using where; Using filesort |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 |
-- XFDB=noForceAllWrite REPLACE INTO xf_session_activity ( ip, controller_name, controller_action, view_state, params, view_date, robot_key, user_id, unique_key ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('ld_search_links', 'ld_search_link_comments', 'search_threads', 'xfrm_search_resources')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | 4 | Using where |
SELECT position FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT token FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT to_available_langs, display, display_mobile FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT display, display_mobile, hide_icon FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT * FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT display, display_mobile FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT position, display, display_mobile FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT position FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
SELECT `xf_siropu_chat_room`.* FROM `xf_siropu_chat_room` WHERE (`xf_siropu_chat_room`.`room_id` IN (1)) AND (`xf_siropu_chat_room`.`room_state` = 'visible')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_siropu_chat_room | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_siropu_chat_message`.*, `xf_user_User_1`.* FROM `xf_siropu_chat_message` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_siropu_chat_message`.`message_user_id`) WHERE (`xf_siropu_chat_message`.`message_room_id` = 1) AND (`xf_siropu_chat_message`.`message_is_ignored` IN (0, 0)) ORDER BY `xf_siropu_chat_message`.`message_id` DESC LIMIT 50
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_siropu_chat_message | ref | message_room_id,message_is_ignored | message_room_id | 4 | const | 9783 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspi_webdb_backup.xf_siropu_chat_message.message_user_id | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`siropu_chat_last_activity` >= 1713476015) AND (`xf_user`.`siropu_chat_room_id` IN (1)) ORDER BY `xf_user`.`siropu_chat_last_activity` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | range | siropu_chat_room_id,siropu_chat_last_activity | siropu_chat_last_activity | 4 | 26 | Using index condition; 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 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 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 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_key, data_value FROM xf_data_registry WHERE data_key IN ('svContentRatingsRT')
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 ('svContentRatingsRTC')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23973) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
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 `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23974) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23976) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23979) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
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 `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23980) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23981) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23982) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23983) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23984) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23985) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23986) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23988) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23989) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23990) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23991) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23992) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23993) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
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 `xf_unfurl_result`.* FROM `xf_unfurl_result` WHERE (`xf_unfurl_result`.`url_hash` = '3d518a2f435cfcd132451242f325fc93') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_unfurl_result | const | url_hash | url_hash | 34 | const | 1 |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23994) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('mvb_tooltip_description')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
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 `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23995) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23996) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23997) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23998) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 23999) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 24000) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.* FROM `xf_reaction_content` LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 24001) AND (`xf_reaction_content`.`reaction_user_id` = 0) ORDER BY `xf_reaction_content`.`reaction_date` ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | no matching row in const table |
SELECT display, display_mobile FROM xf_fox_ultimate_translator
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_fox_ultimate_translator | ALL | 1 |
bytes_sent | 45735 |
bytes_received | 2084101 |
packets_sent | 670 |
packets_received | 4074 |
protocol_overhead_in | 16296 |
protocol_overhead_out | 2680 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1728 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 583 |
bytes_received_prepare_response_packet | 169696 |
bytes_received_change_user_packet | 1909679 |
packets_sent_command | 334 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 192 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 113 |
packets_received_prepare_response | 2097 |
packets_received_change_user | 1559 |
result_set_queries | 110 |
non_result_set_queries | 3 |
no_index_used | 20 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 110 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 110 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 1449 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 1449 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 1449 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 1055 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1999 |
proto_binary_fetched_int24 | 380 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 5545 |
proto_binary_fetched_decimal | 87 |
proto_binary_fetched_float | 76 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 31 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 2529 |
proto_binary_fetched_blob | 768 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 111 |
com_stmt_execute | 111 |
com_stmt_send_long_data | 0 |
com_stmt_close | 110 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 1896113 |