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 (1047276, 1045880, 1045576, 1045350, 1041261, 1040424, 1039478, 1036879, 1036873, 1035869, 1035229, 1034496, 1032826, 1030597, 1030424, 1030422, 1030053, 1029857, 1025130, 1025107, 1025101, 1024291, 1024289, 1028286, 1023350, 1023255, 1022927, 1022780, 1022516, 1022476, 1022278, 1021529, 1021527, 1021524, 1021465, 1021226, 1021188, 1021150, 1021127, 1020871, 1020659, 1020658, 1020657, 1020656, 1020655, 1020654, 1020593, 1020591, 1020588, 1020545, 1020284, 1020283, 1020085, 1020033, 1019715, 1019526, 1019525, 1019487, 1019486, 1019467, 1019463, 1019462, 1019354, 1019332, 1019331, 1018773, 1018713, 1018454, 1018394, 1018127, 1018126, 1018121, 1018117, 1018116, 1018099, 1018098, 826793, 1017989, 1017988, 1017987, 1017980, 1017979, 1017978, 1017939, 1017898, 1017856, 1017798, 1017585, 1017584, 1017575, 1017518, 1017480, 1017299, 1017224, 1017220, 1017217, 1017216, 1017139, 1017138, 1017136, 1016882, 1016878, 1016873, 1016871, 1016827, 1016814, 1016813, 1016756, 1016755, 1016734, 1016682, 1016679, 1016645, 1016491, 1016490, 1016434, 1016427, 1016346, 1016207, 1016205, 1016141, 1016135, 1016134, 1016133, 1016132, 1016119, 1016118, 1016069, 1016068, 1015692, 1015622, 1015619, 1015570, 1015550, 1015383, 1015339, 1015338, 1015320, 1015306, 1015254, 1015037, 1015017, 1015015, 1014889, 1014884, 1014878, 1014750, 1014748, 1014685, 1014684, 1014615, 1014557, 1014555, 1014516, 1014509, 1014508, 1014428, 1014427, 1014387, 1014379, 1014246, 1014245, 1014243, 1014228, 1014109, 1014045, 1014042, 1013770, 988127, 1013732, 1013690, 1013689, 1013666, 1013392, 1013342, 1013339, 1013277, 1013227, 1013023, 1013019, 1013016, 1013012, 994639, 1012715, 1012667, 1012511, 797662, 1012255, 1012254, 1012253, 1012251, 1012250, 1012230, 1012227, 1012225, 1012123, 1012122, 1012120, 1012117, 1012116, 1012115, 1011940, 1011938, 1011936, 1011935, 1011916, 1011890, 1011813, 1011650, 1011619, 1011618, 1011617, 1011615, 1011613, 1011612, 1011350, 1011349, 1011304, 1011303, 1011295, 1011241, 1011239, 1011218, 1011073, 1011072, 1011070, 1011068, 1010860, 1010856, 1010722, 1010717, 1010715, 1010712, 1010710, 891459, 1010701, 1010700, 1010698, 1010684, 1010683, 1010680, 1010679, 1010640, 1010394, 1010376, 1010371, 1010369, 1010364, 1010363, 1010362, 1010361, 1010350, 1010347, 1010276, 1010015, 1009988, 1009851, 1009847, 1009779, 1009768, 1009763, 1009750, 1009505, 1009490, 1009489, 1009403, 1009360, 1009358, 1009355, 1009313, 1009312, 1009076, 1009058, 1008780, 1008484, 1008219, 1008179, 1008175, 1008174, 1008173, 1008129, 1008128, 1008123, 1008075, 1008069, 1007817, 1007697, 1007481, 1007436, 1007433, 1007432, 1007431, 1007428, 1007377, 1007004, 1006847, 1006743, 1006738, 1006485, 1006484, 1006483, 1006482, 1006422, 1006257, 1006212, 1006211, 1006129, 1005929, 1005928, 1005927, 1005924, 1005923, 1005920, 1005777, 1005491, 1005193, 1004995, 1004927, 1004862, 1004652, 1004346, 1004333, 1004331, 1004263, 1004246, 1004245, 1004244, 1004242, 1004241, 1004240, 1004188, 1004187, 1004184, 1004183, 1004137, 1004136, 1004133, 1003944, 1003931, 1003919, 1003657, 1003656, 1003548, 1003546, 1003545, 1003544, 1003543, 1003542, 1003473, 1003398, 1003359, 1003324, 1003321, 1003230, 1003228, 1003227, 1003226, 1003225, 1003104, 1003015, 1002973, 1002969, 1002923, 1002922, 1002921, 1002919, 1002916, 1002913, 1002682, 1002678, 1002674, 1002673, 1002628, 1002626, 1002587, 1002552, 1002514, 1002393, 1002387, 1002386, 1002301, 1002227, 1002058, 985098, 1001920, 1001727, 1001670, 1001666, 1001625, 1001380, 1001379, 1001376, 1001375, 1001370, 1001369, 1001363, 1001359, 1001358, 1001356, 1001352, 1001351, 1001339, 1001314, 839989, 1001311, 1001310, 1001309, 1001308, 1001274, 1001273, 1001270, 1001136, 1001081, 1001030, 1001021, 1000982, 1000981, 1000980, 1000885, 1000800, 1000764, 1000711, 1000710, 1000656, 1000619, 1000618, 1005490, 1000612, 1000609, 1000608, 1000606, 1000605, 1000337, 1000331, 1000330, 1000329, 973525, 1000292, 1000291, 1000290, 1000289, 1000288, 1000285, 1000284, 1000281, 1000248, 999997, 831322, 999995, 999991, 999987, 999939, 875280, 999845, 999827, 999617, 999525, 999524, 999522, 999520, 999216, 999120, 999119, 999116, 999084, 976439, 998795, 998792, 998788, 998783, 998776, 998746, 998745, 998725, 998232, 998117, 998116, 998113, 998087, 997978, 999450, 997566, 997564, 997410, 997359, 997301, 996859, 996858, 996661, 996576, 987760, 996574, 996352, 996260, 995471, 995455, 995376, 994970, 994871, 994862))
Run Time: 0.026891
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