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 (182934, 182727, 182220, 180802, 180461, 180419, 179755, 179059, 177439, 176997, 176453, 175839, 175238, 175130, 175111, 172072, 171383, 170940, 170197, 170196, 169501, 168699, 168262, 167803, 166989, 165964, 165872, 165040, 165038, 163185, 162790, 160163, 159919, 158539, 157792, 157582, 157424, 157423, 156382, 156142, 155053, 155034, 154753, 154501, 154322, 152971, 152706, 129767, 127929, 124892, 98362, 95939, 60237, 54885, 48685))
Run Time: 0.029673
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 55 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 7473, 0, 1715435792, {"thread-182934":["thread",182934],"thread-182727":["thread",182727],"thread-182220":["thread",182220],"thread-180802":["thread",180802],"thread-180461":["thread",180461],"thread-180419":["thread",180419],"thread-179755":["thread",179755],"thread-179059":["thread",179059],"thread-177439":["thread",177439],"thread-176997":["thread",176997],"thread-176453":["thread",176453],"thread-175839":["thread",175839],"thread-175238":["thread",175238],"thread-175130":["thread",175130],"thread-175111":["thread",175111],"thread-172072":["thread",172072],"thread-171383":["thread",171383],"thread-170940":["thread",170940],"thread-170197":["thread",170197],"thread-170196":["thread",170196],"thread-169501":["thread",169501],"thread-168699":["thread",168699],"thread-168262":["thread",168262],"thread-167803":["thread",167803],"thread-166989":["thread",166989],"thread-165964":["thread",165964],"thread-165872":["thread",165872],"thread-165040":["thread",165040],"thread-165038":["thread",165038],"thread-163185":["thread",163185],"thread-162790":["thread",162790],"thread-160163":["thread",160163],"thread-159919":["thread",159919],"thread-158539":["thread",158539],"thread-157792":["thread",157792],"thread-157582":["thread",157582],"thread-157424":["thread",157424],"thread-157423":["thread",157423],"thread-156382":["thread",156382],"thread-156142":["thread",156142],"thread-155053":["thread",155053],"thread-155034":["thread",155034],"thread-154753":["thread",154753],"thread-154501":["thread",154501],"thread-154322":["thread",154322],"thread-152971":["thread",152971],"thread-152706":["thread",152706],"thread-129767":["thread",129767],"thread-127929":["thread",127929],"thread-124892":["thread",124892],"thread-98362":["thread",98362],"thread-95939":["thread",95939],"thread-60237":["thread",60237],"thread-54885":["thread",54885],"thread-48685":["thread",48685]}, , 1715432192
Run Time: 0.000363
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20