SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_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_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_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 (1047277, 1047276, 1045576, 1045350, 1043983, 1041261, 1034496, 1032826, 1031163, 1025101, 1028286, 1023229, 1022927, 1022516, 1022142, 1021529, 1021527, 1021526, 1021524, 1021523, 1021465, 1021463, 1021460, 1021445, 1021226, 1021188, 1021150, 1021127, 1020898, 1020871, 1020684, 1019715, 1019693, 1019354, 1019331, 1019301, 1018773, 1018440, 1018377, 1018376, 1018127, 1018121, 1018116, 1018099, 1018098, 1017978, 1017899, 1017518, 1017480, 1017220, 1017217, 1017139, 1017136, 1016882, 1016873, 1016872, 1016871, 1016827, 1016792, 1016756, 1016682, 1016490, 1016465, 1016346, 1016207, 1016205, 1016133, 1016068, 1015692, 1015622, 1015619, 1015570, 1015550, 1015383, 1015366, 1015320, 1015309, 1015306, 1015159, 1015018, 1015017, 1015015, 1014922, 1014884, 1014878, 1014684, 1014557, 1014555, 1014387, 1014246, 1014240, 1014228, 988127, 1013666, 1013392, 1013336, 1013275, 1013227, 1013049, 994639, 1012715, 1012511, 1012227, 1012055, 1011941, 1011938, 1011833, 1011650, 1011527, 1011350, 1011304, 1011303, 1011302, 1011280, 1011279, 1011241, 1011239, 1010722, 1010701, 1010700, 1010698, 1010681, 1010679, 1010373, 1010371, 1010369, 1010368, 1010365, 1010364, 1010363, 1010362, 1010361, 1010350, 1010348, 1010347, 1010171, 1009988, 1009851, 1009848, 1009847, 1009779, 1009777, 1009763, 1009750, 1009721, 1009490, 1009489, 1009359, 1009357, 1009355, 1009058, 1009035, 1008494, 1008481, 1008219, 1008173, 1008069, 1007856, 1007817, 1007815, 1007697, 1007436, 1007129, 1007004, 1006847, 1006765, 1006484, 1006483, 1006212, 1006211, 1005929, 1005923, 1005832, 1005231, 1005230, 1005172, 1004995, 1004862, 1004653, 1004651, 1004624, 1004609, 1004608, 1004243, 1003944, 1003931, 1003919, 1003547, 1003541, 1003473, 1003398, 1003326, 1003230, 1003229, 1003228, 1002918, 1002679, 1002677, 1002675, 1002302, 1002301, 1002059, 1002058, 1002036, 1001920, 1001839, 1001626, 1001625, 1001369, 1001314, 1001310, 1001308, 1001270, 1000982, 1000981, 1000818, 1000656, 1000619, 1000618, 1000605, 1000338, 1000337, 413063, 1000289, 1000280, 1000248, 999991, 999939, 999827, 999524, 998394, 998106, 998087, 997359, 997301, 996258, 995456, 995452, 994970, 994523, 994185, 994056, 993949, 993947, 993919, 993755, 993477, 976870, 992498, 968516, 992484, 992483, 992449, 992088, 992001, 991952, 991721, 991679, 991510, 991498, 991378, 991181, 990911, 990189, 988730, 988696, 988693, 988455, 988451, 868354, 988285, 988247, 988114, 987747, 987707, 987347, 987296, 987053, 986991, 986826, 986791, 986780, 986779, 986750, 986749, 986406, 986244, 986201, 986200, 986199, 985883, 985849, 985547, 985546, 985457, 985346, 985175, 985092, 979529, 980657, 985086, 985081, 985065, 984954, 984626, 984585, 984446, 984436, 984213, 983935, 983816, 983751, 975709, 983555, 983553, 983552, 983547, 983439, 983323, 983131, 983078, 983075, 983043, 982711, 982307, 944215, 982058, 1002622, 981893, 981748, 981330, 980855, 980854, 980826, 980640, 982543, 980277, 979752, 979745, 979673, 979613, 979453, 978902, 978804, 978801, 978555, 978505, 978501, 978423, 978142, 978140, 978070, 977939, 977804, 977794, 977656, 977499, 977491, 977486, 977465, 977347, 977345, 977344, 977118, 976943, 976757, 976753, 976745, 976547, 976379, 976370, 976363, 976313, 976280, 976047, 904698, 975746, 975343, 974896, 974816, 974813, 974811, 974810, 974703, 974702, 974488, 974485, 974463, 974462, 974439, 974370, 974361, 974224, 974222, 974220, 973882, 973831, 973829, 973072, 972252, 972093, 971990, 971700, 971358, 971290, 971289, 971283, 971279, 971005, 970826, 970707, 986614, 970699, 970497, 970362, 969624, 969618, 969519, 969396, 969293, 969291, 969288, 969236, 969233, 969217, 969216, 969214, 968963, 968936, 968928, 968838, 968748, 968638, 967905, 967827, 967735, 969468, 967670, 967668, 967616, 967455, 967330, 967175, 967139, 966960, 966741, 966735, 966673, 966436, 966422, 966368, 966118, 965699, 964727, 979469, 964548, 964417, 964158, 964045, 963999, 963904, 963805, 963641, 963623, 963493, 963490, 963044, 963037, 977364, 962681, 962674, 962479, 962456, 962412, 961921, 961356, 961243, 961179, 961083, 961043, 961031, 961028, 960881, 960707, 960694, 960602, 960592, 959973, 959967, 959889, 959863, 959858, 959856, 959673, 959671, 972504, 975118, 960299, 959542, 959416))
Run Time: 0.019450
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 500 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,board.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20