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 (1045350, 1044683, 1042256, 1024289, 1017948, 1015786, 1013515, 1012255, 1012254, 1011799, 1011349, 1010715, 1008129, 1008123, 1000290, 998783, 998117, 998113, 993755, 992491, 989980, 989491, 982598, 980221, 977939, 977486, 976547, 974366, 973076, 973072, 971033, 970755, 970745, 970707, 970404, 961467, 959335, 956955, 956801, 952206, 141999, 944205, 940083, 936399, 933365, 930505, 918881, 917992, 915041, 907546, 898412, 896006, 894424, 890009, 889452, 881138, 880074, 879365, 876413, 874091, 870699, 869636, 866162, 863672, 862517, 859599, 859597, 859596, 857360, 855505, 851349, 849595, 845093, 837279, 836088, 836082, 834708, 832561, 831038, 825439, 818047, 809400, 807177, 807171, 798446, 798444, 787307, 786985, 786752, 786481, 782227, 781488, 781074, 779528, 778333, 776706, 770761, 769658, 766435, 759733, 758539, 754985, 753532, 748512, 744788, 744786, 744086, 739310, 734486, 724576, 722820, 711774, 710199, 701488, 697955, 686591, 683144, 673674, 673128, 670211, 665750, 656047, 649793, 649413, 646190, 646161, 644713, 644149, 642778, 639915, 638260, 634645, 631516, 629831, 625147, 621263, 618147, 616273, 615246, 610551, 604908, 602615, 601874, 582241, 593320, 589714, 574397, 569877, 568578, 559131, 556337, 551119, 550215, 550203, 549931, 545347, 541163, 537749, 535455, 526260, 526017, 523713, 518204, 517209, 516446, 515097, 508403, 507293, 498572, 493388, 491599, 487531, 483740, 469355, 467795, 463282, 461548, 458369, 454668, 453555, 446691, 441413, 437172, 436151, 431532, 427381, 426225, 425103, 424746, 420792, 416970, 395212, 394088, 394086, 393569, 392040, 390538, 374657, 369315, 369311, 366395, 363458, 363339, 361142, 359412, 349005, 344809, 341488, 339936, 338167, 336411, 328862, 328222, 327653, 326213, 321665, 321622, 316417, 313576, 310639, 305407, 297242, 287330, 286848, 285107, 275026, 273564, 263162, 258196, 258186, 255233, 254210, 252186, 239910, 238405, 232384, 224047, 221192, 210088, 208075, 205543, 195811, 202087, 130570, 115665, 237851, 187112, 35224, 251335, 11643, 49689))
Run Time: 0.010786
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 251 | 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