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 (182331, 182263, 182184, 181834, 180958, 180664, 179727, 179685, 179545, 179130, 179098, 178816, 178556, 178385, 178364, 177908, 177452, 177294, 177190, 176990, 176645, 176097, 176020, 175030, 174973, 174561, 174201, 174136, 173922, 173878, 173856, 173801, 173717, 173567, 172992, 172909, 172312, 172088, 172063, 172042, 172041, 171536, 171510, 171508, 171068, 170717, 170371, 170055, 169868, 169171, 169156, 169072, 168982, 168925, 168866, 167935, 167893, 167234, 167070, 167035, 166889, 166726, 165674, 165436, 165060, 165048, 164620, 164016, 163503, 163434, 158592, 158544, 158420, 151853, 151692))
Run Time: 0.044912
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 75 | 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: 37454, 0, 1716049077, {"thread-182331":["thread",182331],"thread-182263":["thread",182263],"thread-182184":["thread",182184],"thread-181834":["thread",181834],"thread-180958":["thread",180958],"thread-180664":["thread",180664],"thread-179727":["thread",179727],"thread-179685":["thread",179685],"thread-179545":["thread",179545],"thread-179130":["thread",179130],"thread-179098":["thread",179098],"ams_article-5161":["ams_article",5161],"thread-178816":["thread",178816],"thread-178556":["thread",178556],"thread-178385":["thread",178385],"thread-178364":["thread",178364],"thread-177908":["thread",177908],"thread-177452":["thread",177452],"thread-177294":["thread",177294],"thread-177190":["thread",177190],"thread-176990":["thread",176990],"thread-176645":["thread",176645],"thread-176097":["thread",176097],"thread-176020":["thread",176020],"thread-175030":["thread",175030],"thread-174973":["thread",174973],"thread-174561":["thread",174561],"thread-174201":["thread",174201],"thread-174136":["thread",174136],"thread-173922":["thread",173922],"thread-173878":["thread",173878],"thread-173856":["thread",173856],"thread-173801":["thread",173801],"thread-173717":["thread",173717],"thread-173567":["thread",173567],"thread-172992":["thread",172992],"thread-172909":["thread",172909],"thread-172312":["thread",172312],"ams_article-4900":["ams_article",4900],"thread-172088":["thread",172088],"thread-172063":["thread",172063],"thread-172042":["thread",172042],"thread-172041":["thread",172041],"thread-171536":["thread",171536],"thread-171510":["thread",171510],"thread-171508":["thread",171508],"ams_article-4862":["ams_article",4862],"thread-171068":["thread",171068],"thread-170717":["thread",170717],"ams_article-4830":["ams_article",4830],"thread-170371":["thread",170371],"thread-170055":["thread",170055],"thread-169868":["thread",169868],"thread-169171":["thread",169171],"thread-169156":["thread",169156],"thread-169072":["thread",169072],"thread-168982":["thread",168982],"thread-168925":["thread",168925],"thread-168866":["thread",168866],"thread-167935":["thread",167935],"thread-167893":["thread",167893],"thread-167234":["thread",167234],"ams_article-4731":["ams_article",4731],"thread-167070":["thread",167070],"thread-167035":["thread",167035],"thread-166889":["thread",166889],"thread-166726":["thread",166726],"thread-165674":["thread",165674],"thread-165436":["thread",165436],"thread-165060":["thread",165060],"thread-165048":["thread",165048],"thread-164620":["thread",164620],"ams_article-4578":["ams_article",4578],"thread-164016":["thread",164016],"ams_article-4544":["ams_article",4544],"thread-163503":["thread",163503],"thread-163434":["thread",163434],"ams_article-4417":["ams_article",4417],"thread-158592":["thread",158592],"thread-158544":["thread",158544],"thread-158420":["thread",158420],"thread-151853":["thread",151853],"thread-151692":["thread",151692]}, , 1716045477
Run Time: 0.000410
- 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