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', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 36 | 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 `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.* FROM `xf_thread` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` = '30503') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_session_activity_Activity_5`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 30503) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | 3 | Using index condition; Using where; Using filesort | |
| SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_post.user_id | 1 | |
| SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_user_User_1.user_id | 1 | Using where |
| SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_user_User_1.user_id | 1 | Using where |
| SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_user_User_1.user_id | 1 | Using where |
| SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | nailclub_xfdb.xf_user_User_1.user_id,func | 1 | Using where |
INSERT INTO xf_thread_view (thread_id, total) VALUES (? , 1) ON DUPLICATE KEY UPDATE total = total + 1
-- XFDB=noForceAllWrite 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 `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_siropu_ads_manager_ad | ALL | type,status,status_display_order | 13 | Using where; Using filesort | |||
| SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_siropu_ads_manager_ad.package_id | 1 | |
| SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY RAND() ASC| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status | 102 | const | 8 | Using index condition; Using where; Using temporary; Using filesort |
| SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_siropu_ads_manager_ad.package_id | 1 |
SELECT `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`user_id` = 69558) AND (`xf_session_activity`.`unique_key` = '69558') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | Impossible WHERE noticed after reading const tables |
CREATE TEMPORARY TABLE xf_search_index_temp ( hit_position int unsigned not null PRIMARY KEY, content_type varbinary(25) not null, content_id int unsigned not null, user_id int unsigned not null, item_date int unsigned not null, discussion_id int unsigned not null )
INSERT INTO xf_search_index_temp (hit_position, content_type, content_id, user_id, item_date, discussion_id) VALUES (1, 'thread', 38396, 94758, 1612464569, 38396),(2, 'thread', 38211, 93963, 1578949129, 38211),(3, 'thread', 38210, 93963, 1578948564, 38210),(4, 'post', 1142142, 86470, 1554566837, 35931),(5, 'thread', 37561, 27962, 1504103560, 37561),(6, 'post', 1140593, 76565, 1540816855, 37334),(7, 'post', 1138374, 24868, 1527428881, 35533),(8, 'post', 1140132, 24868, 1537168570, 35533),(9, 'post', 1141937, 26567, 1552661820, 35931),(10, 'post', 1130024, 90674, 1499147534, 35533),(11, 'thread', 36340, 48387, 1462546728, 36340),(12, 'thread', 33965, 74307, 1420664628, 33965),(13, 'post', 1085414, 88219, 1450903874, 25259),(14, 'thread', 33664, 83260, 1415978090, 33664),(15, 'post', 1106888, 75262, 1467697197, 24296),(16, 'post', 1104694, 89560, 1465461104, 35963),(17, 'post', 1066651, 6561, 1439304480, 5099),(18, 'thread', 33104, 46437, 1407988374, 33104),(19, 'thread', 35098, 72679, 1437310998, 35098),(20, 'thread', 34162, 27950, 1422961917, 34162),(21, 'thread', 32613, 17954, 1399024348, 32613),(22, 'post', 1074632, 13172, 1444393588, 6033),(23, 'post', 1067189, 28985, 1439792827, 5099),(24, 'thread', 31884, 16953, 1391542630, 31884),(25, 'profile_post', 27464, 84049, 1420494822, 27464),(26, 'post', 1087200, 44777, 1452197095, 35926),(27, 'post', 1106180, 86470, 1467176484, 24296),(28, 'post', 1087940, 40661, 1452601096, 35533),(29, 'post', 1038196, 7217, 1422818964, 16579),(30, 'post', 1119586, 32633, 1481180458, 9092),(31, 'thread', 32832, 42755, 1402684262, 32832),(32, 'xfmg_comment', 498178, 11959, 1417939406, 66899),(33, 'post', 1033328, 63552, 1421016099, 25259),(34, 'post', 1106123, 75262, 1467112356, 24296),(35, 'thread', 34435, 56769, 1426751460, 34435),(36, 'post', 1033334, 83234, 1421019684, 25259),(37, 'thread', 31348, 76281, 1385012472, 31348),(38, 'post', 999649, 77403, 1401971204, 32795),(39, 'thread', 32547, 80193, 1398186057, 32547),(40, 'post', 1087046, 15708, 1452123379, 35933),(41, 'thread', 31144, 68025, 1382648107, 31144),(42, 'post', 1062825, 63558, 1435742077, 34469),(43, 'post', 1078176, 26688, 1446471113, 35650),(44, 'post', 1088667, 83681, 1452946550, 34398),(45, 'thread', 33177, 8125, 1409296849, 33177),(46, 'thread', 28995, 19537, 1361366629, 28995),(47, 'thread', 30549, 69935, 1377041782, 30549),(48, 'post', 983330, 30246, 1394904271, 31864),(49, 'thread', 33120, 73367, 1408356272, 33120),(50, 'post', 983552, 60728, 1395028644, 31864),(51, 'post', 1068217, 52938, 1440764953, 34792),(52, 'thread', 32190, 35752, 1394057263, 32190),(53, 'post', 939748, 9875, 1379413797, 9439),(54, 'thread', 31227, 17817, 1383747833, 31227),(55, 'post', 1037131, 82517, 1422342084, 25259),(56, 'post', 1087281, 44777, 1452247120, 35926),(57, 'thread', 27185, 59358, 1347268298, 27185),(58, 'thread', 27459, 67088, 1349765839, 27459),(59, 'thread', 28945, 67386, 1360865954, 28945),(60, 'post', 1068453, 29416, 1440958906, 34792),(61, 'post', 937866, 19257, 1378391207, 30454),(62, 'post', 995177, 79562, 1399805003, 25757),(63, 'thread', 27187, 38946, 1347271617, 27187),(64, 'post', 1069922, 28057, 1441786497, 17026),(65, 'thread', 27551, 59007, 1350623024, 27551),(66, 'thread', 24765, 15549, 1328628350, 24765),(67, 'post', 944804, 25877, 1381347480, 26614),(68, 'thread', 26530, 15363, 1340882508, 26530),(69, 'thread', 29329, 72191, 1364844261, 29329),(70, 'thread', 22814, 55167, 1315773416, 22814),(71, 'thread', 30167, 65042, 1372528171, 30167),(72, 'thread', 27836, 63673, 1353039838, 27836),(73, 'thread', 24670, 53201, 1328084731, 24670),(74, 'post', 983028, 40830, 1394745080, 31864),(75, 'thread', 29910, 55747, 1369765956, 29910),(76, 'thread', 24445, 39141, 1326489120, 24445),(77, 'thread', 23772, 56552, 1322120083, 23772),(78, 'thread', 24715, 42696, 1328339044, 24715),(79, 'post', 939705, 9875, 1379396592, 9439),(80, 'thread', 26902, 59007, 1344418821, 26902),(81, 'post', 930501, 33241, 1374756941, 14789),(82, 'thread', 25122, 38088, 1331040331, 25122),(83, 'thread', 25957, 64457, 1337250840, 25957),(84, 'post', 878241, 17097, 1360058568, 14789),(85, 'post', 982878, 79108, 1394718521, 4197),(86, 'post', 999655, 19399, 1401972129, 32793),(87, 'post', 982905, 41114, 1394728719, 4197),(88, 'thread', 22999, 44800, 1317197014, 22999),(89, 'thread', 22736, 53201, 1315169664, 22736),(90, 'thread', 24313, 59391, 1325519388, 24313),(91, 'thread', 28181, 15895, 1355002659, 28181),(92, 'post', 914016, 17910, 1369645288, 955),(93, 'thread', 22090, 15079, 1310283963, 22090),(94, 'thread', 23708, 47757, 1321782077, 23708),(95, 'thread', 21547, 30795, 1306006482, 21547),(96, 'thread', 28125, 39141, 1354622317, 28125),(97, 'post', 755045, 16200, 1329819442, 3229),(98, 'post', 854222, 68476, 1354627679, 28125),(99, 'post', 944091, 41240, 1381068495, 3690),(100, 'thread', 22841, 35875, 1316006913, 22841),(101, 'thread', 24654, 56552, 1327982940, 24654),(102, 'thread', 19770, 22547, 1292653695, 19770),(103, 'thread', 24815, 50625, 1328965085, 24815),(104, 'post', 929377, 53818, 1374351126, 8984),(105, 'post', 695232, 24959, 1317210886, 22376),(106, 'post', 778945, 10583, 1334262179, 21364),(107, 'post', 797649, 42977, 1339356338, 26172),(108, 'post', 635871, 37399, 1301461822, 20050),(109, 'thread', 27050, 66705, 1346057931, 27050),(110, 'post', 649990, 13495, 1305006566, 5115),(111, 'thread', 22991, 45233, 1317136087, 22991),(112, 'thread', 22897, 16801, 1316513954, 22897),(113, 'thread', 25355, 12672, 1332588021, 25355),(114, 'thread', 23433, 29205, 1320224415, 23433),(115, 'thread', 24061, 44433, 1323771055, 24061),(116, 'thread', 22405, 17951, 1312891530, 22405),(117, 'post', 653593, 6112, 1305986118, 21534),(118, 'post', 730349, 12084, 1324288986, 14466),(119, 'post', 690626, 35875, 1316084493, 22841),(120, 'thread', 18512, 39141, 1285152750, 18512),(121, 'post', 879739, 41661, 1360328138, 28359),(122, 'post', 876393, 59686, 1359676033, 28771),(123, 'thread', 21745, 36001, 1307539683, 21745),(124, 'post', 761335, 54990, 1330851106, 6033),(125, 'post', 869935, 59603, 1358093254, 10063),(126, 'thread', 25003, 8610, 1330177214, 25003),(127, 'thread', 26651, 5657, 1341915422, 26651),(128, 'post', 651724, 17795, 1305533179, 5115),(129, 'thread', 21674, 50881, 1306915642, 21674),(130, 'thread', 18941, 39572, 1287829008, 18941),(131, 'thread', 19842, 46235, 1293188471, 19842),(132, 'thread', 18597, 20918, 1285784218, 18597),(133, 'post', 685204, 8896, 1314799618, 10446),(134, 'post', 608901, 29416, 1295734067, 18876),(135, 'profile_post', 17756, 26600, 1275296892, 17756),(136, 'post', 827889, 63535, 1348064202, 3690),(137, 'post', 628053, 28985, 1299858836, 5099),(138, 'post', 535329, 38902, 1279485642, 10656),(139, 'post', 758926, 5015, 1330461263, 24905),(140, 'post', 583690, 44504, 1290100294, 2988),(141, 'post', 564280, 9591, 1286361424, 5115),(142, 'post', 799864, 61023, 1340039276, 6474),(143, 'post', 815403, 9187, 1344414369, 25757),(144, 'post', 589137, 31616, 1291047852, 9215),(145, 'post', 450239, 6561, 1264575360, 5099),(146, 'post', 572195, 37385, 1288039784, 18512),(147, 'post', 455062, 5015, 1265293815, 10400),(148, 'post', 417448, 10281, 1258788781, 13365),(149, 'post', 554810, 6853, 1284186660, 18335),(150, 'post', 494785, 28502, 1271271102, 15389),(151, 'post', 326278, 18824, 1243061573, 9483),(152, 'post', 346575, 17823, 1248040852, 11860),(153, 'post', 267842, 19057, 1233764088, 5099),(154, 'post', 405690, 27970, 1257327010, 10364),(155, 'post', 255879, 10379, 1231614179, 1024),(156, 'post', 267219, 19057, 1233665888, 5099),(157, 'post', 360291, 5845, 1251101305, 5086),(158, 'profile_post', 4882, 18736, 1236298896, 4882),(159, 'post', 540393, 39196, 1280758974, 16392),(160, 'post', 251037, 13824, 1230278105, 5337),(161, 'post', 669589, 8002, 1311070251, 19605),(162, 'post', 304543, 5172, 1239132784, 3955),(163, 'thread', 11221, 18963, 1242219841, 11221),(164, 'post', 433175, 12150, 1261365310, 13609),(165, 'post', 346966, 10278, 1248132297, 5086),(166, 'post', 435314, 14129, 1261721988, 13609),(167, 'post', 158248, 4245, 1204698890, 4027),(168, 'post', 634346, 49389, 1301143033, 2988),(169, 'post', 605496, 36044, 1294962479, 20006),(170, 'post', 134699, 7774, 1196266618, 4316),(171, 'post', 328071, 11070, 1243358917, 871),(172, 'post', 222678, 9070, 1223738412, 4402),(173, 'post', 152738, 11045, 1203087097, 5227),(174, 'post', 229297, 10415, 1225311185, 1691),(175, 'post', 270258, 15792, 1234128252, 8698),(176, 'post', 272275, 13288, 1234211177, 9092),(177, 'post', 205277, 13189, 1217664205, 6364),(178, 'post', 272852, 9575, 1234221319, 9217),(179, 'post', 223181, 12403, 1223852750, 5337),(180, 'post', 215355, 12109, 1221231094, 5337),(181, 'post', 275247, 8896, 1234365478, 9880),(182, 'post', 224485, 12403, 1224110813, 5337)
SELECT search_index.content_type, search_index.content_id FROM xf_search_index_temp AS search_index WHERE search_index.content_type = 'thread' ORDER BY search_index.hit_position ASC LIMIT 200
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | search_index | index | PRIMARY | 4 | 182 | Using where |
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_thread` LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` IN (38396, 38211, 38210, 37561, 36340, 33965, 33664, 33104, 35098, 34162, 32613, 31884, 32832, 34435, 31348, 32547, 31144, 33177, 28995, 30549, 33120, 32190, 31227, 27185, 27459, 28945, 27187, 27551, 24765, 26530, 29329, 22814, 30167, 27836, 24670, 29910, 24445, 23772, 24715, 26902, 25122, 25957, 22999, 22736, 24313, 28181, 22090, 23708, 21547, 28125, 22841, 24654, 19770, 24815, 27050, 22991, 22897, 25355, 23433, 24061, 22405, 18512, 21745, 25003, 26651, 21674, 18941, 19842, 18597, 11221))
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | 70 | Using where | |
| SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.node_id | 1 | |
| SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_forum_Forum_1.node_id | 1 | Using where |
| SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.first_post_id | 1 | |
| SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nailclub_xfdb.xf_node_Node_2.node_id | 1 | Using where |
BEGIN
INSERT INTO `xf_search` (`search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `warnings`, `query_hash`, `user_id`, `result_count`, `search_results`, `search_id`, `user_results`, `search_date`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
COMMIT
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.* FROM `xf_thread` LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` IN (38396, 38211, 38210, 37561, 36340, 33965, 33664, 33104, 35098, 34162, 32613, 31884, 32832, 34435, 31348, 32547, 31144, 33177, 28995, 30549, 33120, 32190, 31227, 27185, 27459, 28945, 27187, 27551, 24765, 26530, 29329, 22814, 30167, 27836, 24670, 29910, 24445, 23772, 24715, 26902, 25122, 25957, 22999, 22736, 24313, 28181, 22090, 23708, 21547, 28125, 22841, 24654, 19770, 24815, 27050, 22991, 22897, 25355, 23433, 24061, 22405, 18512, 21745, 25003, 26651, 21674, 18941, 19842, 18597, 11221))
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | 70 | Using where | |
| SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.node_id | 1 | |
| SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_forum_Forum_1.node_id | 1 | Using where |
| SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.first_post_id | 1 | |
| SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nailclub_xfdb.xf_node_Node_2.node_id | 1 | Using where |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 92777) LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`user_id` = 85517) LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`siropu_chat_last_activity` >= 1615272670)
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user | range | siropu_chat_last_activity | siropu_chat_last_activity | 4 | 1 | Using index condition |
| bytes_sent | 30034 |
| bytes_received | 783187 |
| packets_sent | 194 |
| packets_received | 2176 |
| protocol_overhead_in | 8704 |
| protocol_overhead_out | 776 |
| bytes_received_ok_packet | 0 |
| bytes_received_eof_packet | 0 |
| bytes_received_rset_header_packet | 396 |
| bytes_received_rset_field_meta_packet | 0 |
| bytes_received_rset_row_packet | 273 |
| bytes_received_prepare_response_packet | 152934 |
| bytes_received_change_user_packet | 628845 |
| packets_sent_command | 96 |
| packets_received_ok | 0 |
| packets_received_eof | 0 |
| packets_received_rset_header | 44 |
| packets_received_rset_field_meta | 0 |
| packets_received_rset_row | 35 |
| packets_received_prepare_response | 1741 |
| packets_received_change_user | 323 |
| result_set_queries | 26 |
| non_result_set_queries | 9 |
| no_index_used | 2 |
| bad_index_used | 0 |
| slow_queries | 0 |
| buffered_sets | 0 |
| unbuffered_sets | 0 |
| ps_buffered_sets | 26 |
| ps_unbuffered_sets | 0 |
| flushed_normal_sets | 0 |
| flushed_ps_sets | 0 |
| ps_prepared_never_executed | 0 |
| ps_prepared_once_executed | 30 |
| rows_fetched_from_server_normal | 0 |
| rows_fetched_from_server_ps | 297 |
| rows_buffered_from_client_normal | 0 |
| rows_buffered_from_client_ps | 297 |
| 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 | 297 |
| copy_on_write_saved | 0 |
| copy_on_write_performed | 0 |
| command_buffer_too_small | 1 |
| 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 | 1352 |
| proto_binary_fetched_tinyint | 0 |
| proto_binary_fetched_short | 2775 |
| proto_binary_fetched_int24 | 1018 |
| proto_binary_fetched_int | 0 |
| proto_binary_fetched_bigint | 9536 |
| proto_binary_fetched_decimal | 69 |
| proto_binary_fetched_float | 8 |
| proto_binary_fetched_double | 0 |
| proto_binary_fetched_date | 0 |
| 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 | 4320 |
| proto_binary_fetched_blob | 1653 |
| 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 | 4 |
| 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 | 31 |
| com_stmt_execute | 31 |
| com_stmt_send_long_data | 0 |
| com_stmt_close | 30 |
| 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 | 617599 |