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 (7216454, 7216452, 7214006, 7213646, 7210323, 7208338, 7206580, 7205247, 7204972, 7195567, 7191102, 7186343, 7184276, 7181892, 7180787, 7180616, 7180520, 7177535, 7177400, 7171858, 7168536, 7158623, 7153922, 7153567, 7151178, 7150223, 7149674, 7144620, 7142313, 7137582, 7137581, 7134959, 7132989, 7132565, 7131917, 7131193, 7123565, 7116253, 7114305, 7109749, 7107242, 7092068, 7087923, 7086672, 7083386, 7069259, 7061536, 7060406, 7051632, 7045906, 7040503, 7023348, 7018545, 7018469, 7017838, 7017677, 7014511, 7005646, 7001801, 7001164, 6996332, 6990313, 6984420, 6983671, 6982262, 6965367, 6960601))
Run Time: 0.003155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 67 | 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: 10193, 0, 1714676455, {"thread-7216454":["thread",7216454],"thread-7216452":["thread",7216452],"thread-7214006":["thread",7214006],"thread-7213646":["thread",7213646],"thread-7210323":["thread",7210323],"thread-7208338":["thread",7208338],"thread-7206580":["thread",7206580],"thread-7205247":["thread",7205247],"thread-7204972":["thread",7204972],"thread-7195567":["thread",7195567],"thread-7191102":["thread",7191102],"thread-7186343":["thread",7186343],"thread-7184276":["thread",7184276],"thread-7181892":["thread",7181892],"thread-7180787":["thread",7180787],"thread-7180616":["thread",7180616],"thread-7180520":["thread",7180520],"thread-7177535":["thread",7177535],"thread-7177400":["thread",7177400],"thread-7171858":["thread",7171858],"thread-7168536":["thread",7168536],"thread-7158623":["thread",7158623],"thread-7153922":["thread",7153922],"thread-7153567":["thread",7153567],"thread-7151178":["thread",7151178],"thread-7150223":["thread",7150223],"thread-7149674":["thread",7149674],"thread-7144620":["thread",7144620],"thread-7142313":["thread",7142313],"thread-7137582":["thread",7137582],"thread-7137581":["thread",7137581],"thread-7134959":["thread",7134959],"thread-7132989":["thread",7132989],"thread-7132565":["thread",7132565],"thread-7131917":["thread",7131917],"thread-7131193":["thread",7131193],"thread-7123565":["thread",7123565],"thread-7116253":["thread",7116253],"thread-7114305":["thread",7114305],"thread-7109749":["thread",7109749],"thread-7107242":["thread",7107242],"thread-7092068":["thread",7092068],"thread-7087923":["thread",7087923],"thread-7086672":["thread",7086672],"thread-7083386":["thread",7083386],"thread-7069259":["thread",7069259],"thread-7061536":["thread",7061536],"thread-7060406":["thread",7060406],"thread-7051632":["thread",7051632],"thread-7045906":["thread",7045906],"thread-7040503":["thread",7040503],"thread-7023348":["thread",7023348],"thread-7018545":["thread",7018545],"thread-7018469":["thread",7018469],"thread-7017838":["thread",7017838],"thread-7017677":["thread",7017677],"thread-7014511":["thread",7014511],"thread-7005646":["thread",7005646],"thread-7001801":["thread",7001801],"thread-7001164":["thread",7001164],"thread-6996332":["thread",6996332],"thread-6990313":["thread",6990313],"thread-6984420":["thread",6984420],"thread-6983671":["thread",6983671],"thread-6982262":["thread",6982262],"thread-6965367":["thread",6965367],"thread-6960601":["thread",6960601]}, NULL, 1714672855
Run Time: 0.000414
- 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