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 (183478, 183266, 183060, 182853, 182782, 182357, 182356, 182138, 182135, 182089, 182069, 181166, 180371, 179991, 179140, 179064, 178792, 178074, 177865, 177780, 177420, 177024, 176797, 175963, 175804, 175543, 175290, 175262, 174768, 174636, 174452, 174297, 174141, 174111, 173453, 172916, 171945, 171779, 171713, 171430, 171189, 170967, 170864, 170457, 170300, 170164, 169856, 169683, 168944, 168258, 168013, 167362, 167180, 166985, 166698, 166542, 166107, 165655, 165584, 165568, 165444, 165355, 165135, 165046, 164954, 164767, 164566, 164434, 164208, 164003, 164000, 162970, 162825, 162630, 162059, 162035, 161906, 161766, 161683, 161508, 161213, 160285, 159854, 159843, 159093, 158782, 158238, 157809, 157199, 157125, 157093, 156453, 156405, 156299, 156015, 155886, 155854, 155260, 155246, 155193, 154979, 154941, 154677, 154543, 154518, 154401, 152944, 152770, 152742, 152645, 152608, 152417, 152127, 152067, 151685, 112707, 77913))
Run Time: 0.055422
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 117 | 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: 15838, 0, 1716100126, {"thread-183478":["thread",183478],"thread-183266":["thread",183266],"thread-183060":["thread",183060],"thread-182853":["thread",182853],"thread-182782":["thread",182782],"thread-182357":["thread",182357],"thread-182356":["thread",182356],"thread-182138":["thread",182138],"thread-182135":["thread",182135],"thread-182089":["thread",182089],"thread-182069":["thread",182069],"thread-181166":["thread",181166],"thread-180371":["thread",180371],"thread-179991":["thread",179991],"thread-179140":["thread",179140],"thread-179064":["thread",179064],"thread-178792":["thread",178792],"thread-178074":["thread",178074],"thread-177865":["thread",177865],"thread-177780":["thread",177780],"thread-177420":["thread",177420],"thread-177024":["thread",177024],"thread-176797":["thread",176797],"thread-175963":["thread",175963],"thread-175804":["thread",175804],"thread-175543":["thread",175543],"thread-175290":["thread",175290],"thread-175262":["thread",175262],"thread-174768":["thread",174768],"thread-174636":["thread",174636],"thread-174452":["thread",174452],"thread-174297":["thread",174297],"thread-174141":["thread",174141],"thread-174111":["thread",174111],"thread-173453":["thread",173453],"thread-172916":["thread",172916],"thread-171945":["thread",171945],"thread-171779":["thread",171779],"thread-171713":["thread",171713],"thread-171430":["thread",171430],"thread-171189":["thread",171189],"thread-170967":["thread",170967],"thread-170864":["thread",170864],"thread-170457":["thread",170457],"thread-170300":["thread",170300],"thread-170164":["thread",170164],"thread-169856":["thread",169856],"thread-169683":["thread",169683],"thread-168944":["thread",168944],"thread-168258":["thread",168258],"thread-168013":["thread",168013],"thread-167362":["thread",167362],"thread-167180":["thread",167180],"thread-166985":["thread",166985],"thread-166698":["thread",166698],"thread-166542":["thread",166542],"thread-166107":["thread",166107],"thread-165655":["thread",165655],"thread-165584":["thread",165584],"thread-165568":["thread",165568],"thread-165444":["thread",165444],"thread-165355":["thread",165355],"thread-165135":["thread",165135],"thread-165046":["thread",165046],"thread-164954":["thread",164954],"thread-164767":["thread",164767],"thread-164566":["thread",164566],"thread-164434":["thread",164434],"thread-164208":["thread",164208],"thread-164003":["thread",164003],"thread-164000":["thread",164000],"thread-162970":["thread",162970],"thread-162825":["thread",162825],"thread-162630":["thread",162630],"thread-162059":["thread",162059],"thread-162035":["thread",162035],"thread-161906":["thread",161906],"thread-161766":["thread",161766],"thread-161683":["thread",161683],"thread-161508":["thread",161508],"thread-161213":["thread",161213],"thread-160285":["thread",160285],"thread-159854":["thread",159854],"thread-159093":["thread",159093],"thread-158782":["thread",158782],"thread-158238":["thread",158238],"thread-157809":["thread",157809],"thread-157199":["thread",157199],"thread-157125":["thread",157125],"thread-157093":["thread",157093],"thread-156453":["thread",156453],"thread-156405":["thread",156405],"thread-156299":["thread",156299],"thread-156015":["thread",156015],"thread-155886":["thread",155886],"thread-155854":["thread",155854],"thread-155260":["thread",155260],"thread-155246":["thread",155246],"thread-155193":["thread",155193],"thread-154979":["thread",154979],"thread-154941":["thread",154941],"thread-154677":["thread",154677],"thread-154543":["thread",154543],"thread-154518":["thread",154518],"thread-154401":["thread",154401],"thread-152944":["thread",152944],"thread-152770":["thread",152770],"thread-152742":["thread",152742],"thread-152645":["thread",152645],"thread-152608":["thread",152608],"thread-152417":["thread",152417],"thread-152127":["thread",152127],"thread-152067":["thread",152067],"thread-151685":["thread",151685],"thread-112707":["thread",112707],"thread-77913":["thread",77913]}, , 1716096526
Run Time: 0.000196
- 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