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 (7203357, 7197442, 7196181, 7192926, 7192454, 7190617, 7189456, 7185158, 7185068, 7184094, 7183812, 7182306, 7176689, 7176037, 7173025, 7171237, 7159000, 7157040, 7156374, 7149898, 7144692, 7139773, 7138903, 7134466, 7132272, 7122813, 7120149, 7117009, 7115771, 7115590, 7112660, 7103888, 7099245, 7099077, 7093240, 7090604, 7089397, 7086296, 7086089, 7084103, 7083240, 7072627, 7072145, 7052251, 7041544, 7039976, 7025128, 7002550, 7001274, 6996910, 6983688, 6973384, 6972151, 6969076, 6957326, 6956905, 6956185, 6810464, 6640775, 231638, 220183, 214621, 13425, 12915, 11294, 11264, 9595, 9559, 6635, 6363, 4917, 3914, 3065, 2170, 758, 657, 519, 141))
Run Time: 0.005400
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 78 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 133, 0, 1715002657, {"thread-7203357":["thread",7203357],"thread-7197442":["thread",7197442],"thread-7196181":["thread",7196181],"thread-7192926":["thread",7192926],"thread-7192454":["thread",7192454],"thread-7190617":["thread",7190617],"thread-7189456":["thread",7189456],"thread-7185158":["thread",7185158],"thread-7185068":["thread",7185068],"thread-7184094":["thread",7184094],"thread-7183812":["thread",7183812],"thread-7182306":["thread",7182306],"thread-7176689":["thread",7176689],"thread-7176037":["thread",7176037],"thread-7173025":["thread",7173025],"thread-7171237":["thread",7171237],"thread-7159000":["thread",7159000],"thread-7157040":["thread",7157040],"thread-7156374":["thread",7156374],"thread-7149898":["thread",7149898],"thread-7144692":["thread",7144692],"thread-7139773":["thread",7139773],"thread-7138903":["thread",7138903],"thread-7134466":["thread",7134466],"thread-7132272":["thread",7132272],"thread-7122813":["thread",7122813],"thread-7120149":["thread",7120149],"thread-7117009":["thread",7117009],"thread-7115771":["thread",7115771],"thread-7115590":["thread",7115590],"thread-7112660":["thread",7112660],"thread-7103888":["thread",7103888],"thread-7099245":["thread",7099245],"thread-7099077":["thread",7099077],"thread-7093240":["thread",7093240],"thread-7090604":["thread",7090604],"thread-7089397":["thread",7089397],"thread-7086296":["thread",7086296],"thread-7086089":["thread",7086089],"thread-7084103":["thread",7084103],"thread-7083240":["thread",7083240],"thread-7072627":["thread",7072627],"thread-7072145":["thread",7072145],"thread-7052251":["thread",7052251],"thread-7041544":["thread",7041544],"thread-7039976":["thread",7039976],"thread-7025128":["thread",7025128],"thread-7002550":["thread",7002550],"thread-7001274":["thread",7001274],"thread-6996910":["thread",6996910],"thread-6983688":["thread",6983688],"thread-6973384":["thread",6973384],"thread-6972151":["thread",6972151],"thread-6969076":["thread",6969076],"thread-6957326":["thread",6957326],"thread-6956905":["thread",6956905],"thread-6956185":["thread",6956185],"thread-6810464":["thread",6810464],"thread-6640775":["thread",6640775],"thread-231638":["thread",231638],"thread-220183":["thread",220183],"thread-214621":["thread",214621],"thread-13425":["thread",13425],"thread-12915":["thread",12915],"thread-11294":["thread",11294],"thread-11264":["thread",11264],"thread-9595":["thread",9595],"thread-9559":["thread",9559],"thread-6635":["thread",6635],"thread-6363":["thread",6363],"thread-4917":["thread",4917],"thread-3914":["thread",3914],"thread-3065":["thread",3065],"thread-2170":["thread",2170],"thread-758":["thread",758],"thread-657":["thread",657],"thread-519":["thread",519],"thread-141":["thread",141]}, NULL, 1714999057
Run Time: 0.000454
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20