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 (182944, 173314, 173301, 169957, 168653, 166413, 166411, 166398, 166397, 166312, 166311, 165390, 165388, 165386, 165385, 165384, 165383, 164054, 161748, 158569, 156734, 156733, 156732, 156708, 156707, 156700, 156699, 156697, 156695, 156694, 156395, 155898, 155433, 155432, 155429, 155428, 155420, 155419, 155418, 155417, 155416, 155415, 155414, 155413, 155412, 155411, 155410, 155409, 155408, 155407, 155406, 129971))
Run Time: 0.014563
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 52 | 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: 33312, 0, 1715895058, {"thread-182944":["thread",182944],"thread-173314":["thread",173314],"thread-173301":["thread",173301],"thread-169957":["thread",169957],"thread-168653":["thread",168653],"thread-166413":["thread",166413],"thread-166411":["thread",166411],"thread-166398":["thread",166398],"thread-166397":["thread",166397],"thread-166312":["thread",166312],"thread-166311":["thread",166311],"thread-165390":["thread",165390],"thread-165388":["thread",165388],"thread-165386":["thread",165386],"thread-165385":["thread",165385],"thread-165384":["thread",165384],"thread-165383":["thread",165383],"thread-164054":["thread",164054],"thread-161748":["thread",161748],"thread-158569":["thread",158569],"thread-156734":["thread",156734],"thread-156733":["thread",156733],"thread-156732":["thread",156732],"thread-156708":["thread",156708],"thread-156707":["thread",156707],"thread-156700":["thread",156700],"thread-156699":["thread",156699],"thread-156697":["thread",156697],"thread-156695":["thread",156695],"thread-156694":["thread",156694],"thread-156395":["thread",156395],"thread-155898":["thread",155898],"thread-155433":["thread",155433],"thread-155432":["thread",155432],"thread-155429":["thread",155429],"thread-155428":["thread",155428],"thread-155420":["thread",155420],"thread-155419":["thread",155419],"thread-155418":["thread",155418],"thread-155417":["thread",155417],"thread-155416":["thread",155416],"thread-155415":["thread",155415],"thread-155414":["thread",155414],"thread-155413":["thread",155413],"thread-155412":["thread",155412],"thread-155411":["thread",155411],"thread-155410":["thread",155410],"thread-155409":["thread",155409],"thread-155408":["thread",155408],"thread-155407":["thread",155407],"thread-155406":["thread",155406],"thread-129971":["thread",129971]}, , 1715891458
Run Time: 0.000383
- 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