SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (9, 902, 901, 911, 912, 275, 24, 778, 281, 711, 282, 277, 25, 284, 773, 285, 286, 287, 26, 898, 27, 685, 289, 899, 825, 278, 214, 907, 292, 495, 293, 28, 914, 915, 843, 916, 917, 295, 297, 906, 296, 316, 30, 908, 320, 298, 40, 303, 304, 29, 306, 307, 309, 310, 41, 312, 313, 566, 315, 321, 43, 323, 324, 325, 611, 612, 32, 327, 329, 44, 351, 330, 334, 332, 45, 335, 31, 340, 46, 33, 343, 35, 347, 47, 348, 37, 349, 34, 358, 350, 36, 38, 359, 48, 363, 360, 49, 361, 50, 438, 362, 51, 199, 81, 390, 82, 234, 85, 86, 87, 88, 89, 90, 91, 92, 94, 95, 96, 97, 98, 99, 100, 101, 243, 104, 105, 106, 107, 108, 109, 110, 151, 153, 155, 162, 233, 178, 180, 189, 193, 160, 194, 217, 223, 225, 226, 227, 228, 231, 236, 241, 250, 270, 370, 468, 513, 533, 564, 192, 63, 64, 65, 66, 120, 242, 681, 61, 203, 454, 62, 141, 170, 222, 67, 69, 70, 71, 72, 102, 127, 197, 514, 658))
Run Time: 0.000647
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 185 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_forum.last_thread_id | 1 | |
- 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/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 20
- XF\Repository\Node->getNodeList() in src/XF/Pub/Controller/Forum.php at line 54
- XF\Pub\Controller\Forum->actionList() 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_thread` FORCE INDEX (`last_post_date`)
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_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_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1713538413) AND (`xf_thread`.`node_id` IN (275, 24, 778, 281, 711, 282, 277, 25, 284, 773, 285, 286, 287, 26, 898, 27, 685, 289, 899, 825, 278, 214, 907, 292, 495, 298, 40, 303, 293, 28, 914, 915, 843, 916, 917, 295, 297, 906, 296, 304, 29, 306, 307, 309, 310, 41, 312, 313, 566, 315, 316, 30, 908, 320, 321, 43, 323, 324, 325, 611, 612, 32, 327, 329, 44, 351, 330, 332, 45, 335, 31, 340, 46, 33, 343, 35, 347, 47, 348, 37, 349, 34, 358, 350, 36, 38, 359, 48, 363, 360, 49, 361, 50, 438, 362, 51, 199))
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 10
Run Time: 0.001742
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 144 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,cmclubcom_xf2xx.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread.last_post_user_id | 1 | |
- 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/Widget/NewPosts.php at line 89
- XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_11_Widget_portal_new_post.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l5/s75/public/forum_list.php at line 216
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20