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 (172537, 171561, 171487, 171450, 170879, 169893, 169830, 169594, 169416, 169395, 168477, 168348, 168278, 167985, 167974, 167730, 167594, 167147, 166861, 166672, 166545, 166490, 166465, 166361, 166273, 166143, 165914, 165767, 165766, 165687, 165675, 165514, 164824, 164797, 164581, 164512, 164491, 164163, 163970, 163893, 163780, 163489, 163315, 163108, 163073, 162799, 162581, 162488, 162370, 162188, 161464, 160891, 160883, 160859, 160611, 160358, 160295, 160231, 159922, 159625, 159418, 159201, 158997, 158903, 158703, 158667, 158615, 158545, 158541, 158490, 158102, 158101, 157921, 157879, 157857, 157854, 157743, 157621, 157225, 157090, 157054, 156968, 156887, 156868, 156566, 156475, 156101, 156085, 156016, 155985, 155930, 155897, 155824))
Run Time: 0.064566
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 93 | 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: 38388, 0, 1715011432, {"thread-172537":["thread",172537],"ams_article-4898":["ams_article",4898],"thread-171561":["thread",171561],"thread-171487":["thread",171487],"thread-171450":["thread",171450],"thread-170879":["thread",170879],"thread-169893":["thread",169893],"ams_article-4815":["ams_article",4815],"thread-169830":["thread",169830],"thread-169594":["thread",169594],"thread-169416":["thread",169416],"thread-169395":["thread",169395],"thread-168477":["thread",168477],"thread-168348":["thread",168348],"ams_article-4769":["ams_article",4769],"thread-168278":["thread",168278],"thread-167985":["thread",167985],"thread-167974":["thread",167974],"thread-167730":["thread",167730],"thread-167594":["thread",167594],"ams_article-4741":["ams_article",4741],"ams_article-4739":["ams_article",4739],"ams_article-4736":["ams_article",4736],"thread-167147":["thread",167147],"thread-166861":["thread",166861],"thread-166672":["thread",166672],"thread-166545":["thread",166545],"thread-166490":["thread",166490],"thread-166465":["thread",166465],"thread-166361":["thread",166361],"thread-166273":["thread",166273],"ams_article-4706":["ams_article",4706],"thread-166143":["thread",166143],"thread-165914":["thread",165914],"thread-165767":["thread",165767],"thread-165766":["thread",165766],"thread-165687":["thread",165687],"thread-165675":["thread",165675],"ams_article-4691":["ams_article",4691],"thread-165514":["thread",165514],"thread-164824":["thread",164824],"thread-164797":["thread",164797],"ams_article-4641":["ams_article",4641],"thread-164581":["thread",164581],"thread-164512":["thread",164512],"thread-164491":["thread",164491],"ams_article-4591":["ams_article",4591],"ams_article-4590":["ams_article",4590],"ams_article-4585":["ams_article",4585],"ams_article-4583":["ams_article",4583],"thread-164163":["thread",164163],"ams_article-4569":["ams_article",4569],"ams_article-4564":["ams_article",4564],"thread-163970":["thread",163970],"thread-163893":["thread",163893],"thread-163780":["thread",163780],"ams_article-4558":["ams_article",4558],"thread-163489":["thread",163489],"thread-163315":["thread",163315],"thread-163108":["thread",163108],"thread-163073":["thread",163073],"thread-162799":["thread",162799],"thread-162581":["thread",162581],"thread-162488":["thread",162488],"thread-162370":["thread",162370],"ams_article-4483":["ams_article",4483],"ams_article-4479":["ams_article",4479],"thread-162188":["thread",162188],"ams_article-4463":["ams_article",4463],"thread-161464":["thread",161464],"ams_article-4446":["ams_article",4446],"thread-160891":["thread",160891],"thread-160883":["thread",160883],"thread-160859":["thread",160859],"ams_article-4438":["ams_article",4438],"thread-160611":["thread",160611],"thread-160358":["thread",160358],"thread-160295":["thread",160295],"thread-160231":["thread",160231],"thread-159922":["thread",159922],"ams_article-4398":["ams_article",4398],"thread-159625":["thread",159625],"thread-159418":["thread",159418],"ams_article-4374":["ams_article",4374],"thread-159201":["thread",159201],"ams_article-4359":["ams_article",4359],"thread-158997":["thread",158997],"thread-158903":["thread",158903],"thread-158703":["thread",158703],"thread-158667":["thread",158667],"thread-158615":["thread",158615],"thread-158545":["thread",158545],"thread-158541":["thread",158541],"thread-158490":["thread",158490],"ams_article-4331":["ams_article",4331],"thread-158102":["thread",158102],"thread-158101":["thread",158101],"ams_article-4321":["ams_article",4321],"ams_article-4320":["ams_article",4320],"thread-157921":["thread",157921],"thread-157879":["thread",157879],"thread-157857":["thread",157857],"thread-157854":["thread",157854],"thread-157743":["thread",157743],"ams_article-4298":["ams_article",4298],"thread-157621":["thread",157621],"thread-157225":["thread",157225],"thread-157090":["thread",157090],"ams_article-4272":["ams_article",4272],"thread-157054":["thread",157054],"ams_article-4268":["ams_article",4268],"ams_article-4267":["ams_article",4267],"thread-156968":["thread",156968],"thread-156887":["thread",156887],"thread-156868":["thread",156868],"ams_article-4263":["ams_article",4263],"ams_article-4252":["ams_article",4252],"thread-156566":["thread",156566],"thread-156475":["thread",156475],"thread-156101":["thread",156101],"thread-156085":["thread",156085],"thread-156016":["thread",156016],"thread-155985":["thread",155985],"ams_article-4211":["ams_article",4211],"thread-155930":["thread",155930],"thread-155897":["thread",155897],"thread-155824":["thread",155824]}, , 1715007832
Run Time: 0.000384
- 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