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 (1045880, 1045576, 1045350, 1041261, 1040424, 1039478, 1035869, 1034496, 1032826, 1028097, 1025101, 1024291, 1028286, 1022927, 1022516, 1022476, 1021529, 1021527, 1021465, 1021226, 1021188, 1020871, 1020659, 1020658, 1020657, 1020655, 1020593, 1020588, 1020283, 1019487, 1019486, 1019467, 1019463, 1019462, 1019332, 1019094, 1018773, 1018454, 1018126, 1018121, 1018117, 1018098, 1017989, 1017939, 1017898, 1017585, 1017584, 1017575, 1017480, 1017299, 1017224, 1017139, 1017138, 1016878, 1016873, 1016734, 1016682, 1016679, 1016491, 1016490, 1016207, 1016141, 1016135, 1016134, 1016133, 1016132, 1016119, 1016069, 1015622, 1015619, 1015570, 1015339, 1015338, 1015037, 1015015, 1014922, 1014878, 1014750, 1014748, 1014685, 1014557, 1014555, 1014516, 1014428, 1014427, 1014387, 1014379, 1014243, 1014228, 1014109, 1014045, 1014042, 1013770, 1013342, 1013339, 1013227, 1013019, 1013016, 1012715, 1012253, 1012251, 1012225, 1012117, 1012116, 1012115, 1011940, 1011938, 1011935, 1011890, 1011813, 1011650, 1011619, 1011618, 1011617, 1011615, 1011613, 1011349, 1011304, 1011303, 1011302, 1011241, 1011239, 1011218, 1010717, 1010715, 1010710, 891459, 1010701, 1010698, 1010684, 1010680, 1010640, 1010394, 1010369, 1010361, 1010350, 1010347, 1010276, 1009779, 1009403, 1009360, 1009358, 1009355, 1009313, 1009312, 1009058, 1008780, 1008484, 1008219, 1008179, 1008175, 1008174, 1008173, 1008129, 1008128, 1008075, 1007481, 1007432, 1007377, 1007004, 1006847, 1006743, 1006485, 1006483, 1006422, 1006257, 1006211, 1005928, 1005894, 1005193, 1004995, 1004927, 1004346, 1004333, 1004331, 1004246, 1004244, 1004241, 1004187, 1004184, 1004183, 1004137, 1004133, 1003944, 1003919, 1003657, 1003548, 1003544, 1003359, 1003324, 1003229, 1003226, 1003104, 1002973, 1002919, 1002916, 1002913, 1002681, 1002678, 1002677, 1002674, 1002673, 1002628, 1002626, 1002552, 1002514, 1002387, 1002386, 1002301, 1002058, 1001920, 1001727, 1001670, 1001625, 1001379, 1001376, 1001375, 1001370, 1001369, 1001363, 1001359, 1001358, 1001352, 1001351, 1001339, 839989, 1001311, 1001308, 1001274, 1001081, 1001030, 1000982, 1000980, 1000885, 1000800, 1000764, 1000711, 1000656, 1000619, 1000618, 1000610, 1000606, 1000330, 973525, 1000292, 1000290, 1000289, 1000288, 999997, 831322, 999995, 999985, 999939, 875280, 999827, 999617, 999525, 999524, 999522, 999119, 999116, 998795, 998783, 998394, 998232, 998117, 998113, 997978, 997440, 997410, 997359, 997301, 996858, 996576, 996574, 996359, 996352, 996258, 995471, 995456, 995376, 994970, 994862, 994850, 994649, 994638, 994621, 994613, 994318, 994185, 994170, 994056, 993940, 993938, 993889, 993531, 976870, 992983, 992842, 992828, 992581, 992498, 992492, 992491, 992489, 992488, 992484, 992453, 992442, 992210, 992084, 992038, 992001, 991952, 991718, 991510, 991498, 990997, 990957, 989739, 989498, 989492, 989491, 989478, 989443, 989316, 988687, 988452, 988451, 868354, 988285, 988284, 988282, 988247, 988096, 988073, 987561, 987456, 987455, 987453, 987053, 987049, 987033, 986895, 986886, 986779, 986749, 986582, 986244, 986239, 986200, 985932, 985891, 985547, 985546, 985346, 985186, 985175, 985086, 985074, 984966, 984151, 983935, 983816, 983747, 983685, 983554, 983553, 983552, 983550, 983549, 983446, 983344, 983323, 983288, 983269, 983115, 983075, 982833, 982726, 982712, 982658, 982599, 982362, 982361, 982357, 982314, 982310, 982309, 982307, 981913, 981748, 981689, 981674, 990218, 981537, 981321, 981131, 981070, 980863, 980860, 980859, 980855, 980801, 980642, 980640, 980595, 980591, 980586, 980578, 980576, 980363, 980359, 980358, 980351, 980303, 980298, 980095, 979752, 979613, 979470, 979453, 979428, 978900, 978804, 978803, 978802, 978801, 978794, 978755, 978718, 978654, 978510, 978341, 978134, 978070, 977939, 977796, 977795, 977754, 977751, 977748, 977656, 977518, 977508, 977502, 977496, 977475, 977471, 977469, 977356, 977347, 977118, 976943, 976753, 976690, 976547, 971107, 976361, 976353, 976280, 976063, 976062, 984891, 975963, 975901, 975676, 975633, 975622, 975114, 974983, 974952, 974951, 974812, 974810, 974804, 974699, 974655, 974465, 974416, 974415, 974366, 974315, 974033, 973831, 973826, 973500, 973193, 973072, 961605, 972307, 972020, 971700, 971687, 971674, 971365, 971290, 971289, 971279, 971225))
Run Time: 0.031490
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