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 (182935, 182869, 182226, 182192, 181759, 181585, 181341, 181078, 181063, 181033, 180938, 180902, 180635, 180061, 179432, 179341, 179327, 177941, 176380, 176340, 175921, 175920, 175837, 175672, 174818, 174196, 173952, 173896, 173205, 172671, 172655, 172640, 171907, 171906, 171584, 171579, 168952, 168844, 168811, 168794, 168793, 168777, 168316, 167998, 167907, 167558, 167515, 167299, 166192, 164573, 164021, 163814, 163784, 163536, 162571, 162038, 161646, 161129, 161087, 161079, 160988, 160954, 160952, 160944, 160939, 160907, 158914, 158901, 158458, 158344, 158298, 158149, 158085, 157943, 157778, 156043, 155935, 155920, 155903, 155817, 155760, 155455, 155090, 154787, 154417, 154185, 152805, 152746, 152744, 152499, 152444, 151872, 150653, 150034, 149632, 149613, 148504, 148458, 148140, 148004, 147069, 146890, 145150))
Run Time: 0.064499
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 103 | 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: 36713, 0, 1715932569, {"thread-182935":["thread",182935],"thread-182869":["thread",182869],"thread-182226":["thread",182226],"thread-182192":["thread",182192],"thread-181759":["thread",181759],"thread-181585":["thread",181585],"thread-181341":["thread",181341],"thread-181078":["thread",181078],"thread-181063":["thread",181063],"thread-181033":["thread",181033],"thread-180938":["thread",180938],"thread-180902":["thread",180902],"thread-180635":["thread",180635],"thread-180061":["thread",180061],"thread-179432":["thread",179432],"thread-179341":["thread",179341],"thread-179327":["thread",179327],"thread-177941":["thread",177941],"thread-176380":["thread",176380],"thread-176340":["thread",176340],"thread-175921":["thread",175921],"thread-175920":["thread",175920],"thread-175837":["thread",175837],"thread-175672":["thread",175672],"thread-174818":["thread",174818],"thread-174196":["thread",174196],"thread-173952":["thread",173952],"thread-173896":["thread",173896],"thread-173205":["thread",173205],"thread-172671":["thread",172671],"thread-172655":["thread",172655],"thread-172640":["thread",172640],"thread-171907":["thread",171907],"thread-171906":["thread",171906],"thread-171584":["thread",171584],"thread-171579":["thread",171579],"thread-168952":["thread",168952],"thread-168844":["thread",168844],"thread-168811":["thread",168811],"thread-168794":["thread",168794],"thread-168793":["thread",168793],"thread-168777":["thread",168777],"thread-168316":["thread",168316],"thread-167998":["thread",167998],"thread-167907":["thread",167907],"thread-167558":["thread",167558],"thread-167515":["thread",167515],"thread-167299":["thread",167299],"thread-166192":["thread",166192],"thread-164573":["thread",164573],"thread-164021":["thread",164021],"thread-163814":["thread",163814],"thread-163784":["thread",163784],"thread-163536":["thread",163536],"thread-162571":["thread",162571],"thread-162038":["thread",162038],"thread-161646":["thread",161646],"thread-161129":["thread",161129],"thread-161087":["thread",161087],"thread-161079":["thread",161079],"thread-160988":["thread",160988],"thread-160954":["thread",160954],"thread-160952":["thread",160952],"thread-160944":["thread",160944],"thread-160939":["thread",160939],"thread-160907":["thread",160907],"thread-158914":["thread",158914],"thread-158901":["thread",158901],"thread-158458":["thread",158458],"thread-158344":["thread",158344],"thread-158298":["thread",158298],"thread-158149":["thread",158149],"thread-158085":["thread",158085],"thread-157943":["thread",157943],"thread-157778":["thread",157778],"thread-156043":["thread",156043],"thread-155935":["thread",155935],"thread-155920":["thread",155920],"thread-155903":["thread",155903],"thread-155817":["thread",155817],"thread-155760":["thread",155760],"thread-155455":["thread",155455],"thread-155090":["thread",155090],"thread-154787":["thread",154787],"thread-154417":["thread",154417],"thread-154185":["thread",154185],"thread-152805":["thread",152805],"thread-152746":["thread",152746],"thread-152744":["thread",152744],"thread-152499":["thread",152499],"thread-152444":["thread",152444],"thread-151872":["thread",151872],"thread-150653":["thread",150653],"thread-150034":["thread",150034],"thread-149632":["thread",149632],"thread-149613":["thread",149613],"thread-148504":["thread",148504],"thread-148458":["thread",148458],"thread-148140":["thread",148140],"thread-148004":["thread",148004],"thread-147069":["thread",147069],"thread-146890":["thread",146890],"thread-145150":["thread",145150]}, , 1715928969
Run Time: 0.000277
- 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