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 (7216469, 7215346, 7214628, 7214227, 7213068, 7212602, 7212077, 7211760, 7210287, 7207713, 7207569, 7206241, 7205756, 7205195, 7203837, 7199610, 7199291, 7199207, 7195591, 7195415, 7194596, 7194130, 7193960, 7193822, 7182384, 7178228, 7177770, 7177676, 7177620, 7176837, 7176268, 7169095, 7165307, 7162311, 7161638, 7153303, 7150903, 7148519, 7147938, 7147788, 7144215, 7144022, 7143822, 7142081, 7141905, 7139214, 7137983, 7135827, 7134160, 7129865, 7125599, 7125594, 7125410, 7109962, 7100504, 7098195, 7094611, 7094310, 7093522, 7093484, 7092387, 7092297, 7091788, 7090038, 7089363, 7088715, 7087379, 7086473, 7083988, 7083638, 7082715, 7080214, 7079872, 7078042, 7071071, 7068734, 7068678, 7067072, 7065462, 7060209, 7056222, 7055654, 7051669, 7051435, 7047165, 7040152, 7037767, 7037445, 7033565, 7032500, 7029849, 7028844, 7015532, 7007857, 7007855, 7005545, 7002856, 7002550, 7001419, 7001395, 7000992, 6999722, 6999655, 6999536, 6992564, 6990678, 6986432, 6985729, 6982059, 6975824, 6970818, 6970537, 6970168, 6968378, 6965731, 6960644, 6958484, 6956185, 223449, 219229, 165420, 165330))
Run Time: 0.006472
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 122 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 8502, 0, 1714804681, {"thread-7216469":["thread",7216469],"thread-7215346":["thread",7215346],"thread-7214628":["thread",7214628],"thread-7214227":["thread",7214227],"thread-7213068":["thread",7213068],"thread-7212602":["thread",7212602],"thread-7212077":["thread",7212077],"thread-7211760":["thread",7211760],"thread-7210287":["thread",7210287],"thread-7207713":["thread",7207713],"thread-7207569":["thread",7207569],"thread-7206241":["thread",7206241],"thread-7205756":["thread",7205756],"thread-7205195":["thread",7205195],"thread-7203837":["thread",7203837],"thread-7199610":["thread",7199610],"thread-7199291":["thread",7199291],"thread-7199207":["thread",7199207],"thread-7195591":["thread",7195591],"thread-7195415":["thread",7195415],"thread-7194596":["thread",7194596],"thread-7194130":["thread",7194130],"thread-7193960":["thread",7193960],"thread-7193822":["thread",7193822],"thread-7182384":["thread",7182384],"thread-7178228":["thread",7178228],"thread-7177770":["thread",7177770],"thread-7177676":["thread",7177676],"thread-7177620":["thread",7177620],"thread-7176837":["thread",7176837],"thread-7176268":["thread",7176268],"thread-7169095":["thread",7169095],"thread-7165307":["thread",7165307],"thread-7162311":["thread",7162311],"thread-7161638":["thread",7161638],"thread-7153303":["thread",7153303],"thread-7150903":["thread",7150903],"thread-7148519":["thread",7148519],"thread-7147938":["thread",7147938],"thread-7147788":["thread",7147788],"thread-7144215":["thread",7144215],"thread-7144022":["thread",7144022],"thread-7143822":["thread",7143822],"thread-7142081":["thread",7142081],"thread-7141905":["thread",7141905],"thread-7139214":["thread",7139214],"thread-7137983":["thread",7137983],"thread-7135827":["thread",7135827],"thread-7134160":["thread",7134160],"thread-7129865":["thread",7129865],"thread-7125599":["thread",7125599],"thread-7125594":["thread",7125594],"thread-7125410":["thread",7125410],"thread-7109962":["thread",7109962],"thread-7100504":["thread",7100504],"thread-7098195":["thread",7098195],"thread-7094611":["thread",7094611],"thread-7094310":["thread",7094310],"thread-7093522":["thread",7093522],"thread-7093484":["thread",7093484],"thread-7092387":["thread",7092387],"thread-7092297":["thread",7092297],"thread-7091788":["thread",7091788],"thread-7090038":["thread",7090038],"thread-7089363":["thread",7089363],"thread-7088715":["thread",7088715],"thread-7087379":["thread",7087379],"thread-7086473":["thread",7086473],"thread-7083988":["thread",7083988],"thread-7083638":["thread",7083638],"thread-7082715":["thread",7082715],"thread-7080214":["thread",7080214],"thread-7079872":["thread",7079872],"thread-7078042":["thread",7078042],"thread-7071071":["thread",7071071],"thread-7068734":["thread",7068734],"thread-7068678":["thread",7068678],"thread-7067072":["thread",7067072],"thread-7065462":["thread",7065462],"thread-7060209":["thread",7060209],"thread-7056222":["thread",7056222],"thread-7055654":["thread",7055654],"thread-7051669":["thread",7051669],"thread-7051435":["thread",7051435],"thread-7047165":["thread",7047165],"thread-7040152":["thread",7040152],"thread-7037767":["thread",7037767],"thread-7037445":["thread",7037445],"thread-7033565":["thread",7033565],"thread-7032500":["thread",7032500],"thread-7029849":["thread",7029849],"thread-7028844":["thread",7028844],"thread-7015532":["thread",7015532],"thread-7007857":["thread",7007857],"thread-7007855":["thread",7007855],"thread-7005545":["thread",7005545],"thread-7002856":["thread",7002856],"thread-7002550":["thread",7002550],"thread-7001419":["thread",7001419],"thread-7001395":["thread",7001395],"thread-7000992":["thread",7000992],"thread-6999722":["thread",6999722],"thread-6999655":["thread",6999655],"thread-6999536":["thread",6999536],"thread-6992564":["thread",6992564],"thread-6990678":["thread",6990678],"thread-6986432":["thread",6986432],"thread-6985729":["thread",6985729],"thread-6982059":["thread",6982059],"thread-6975824":["thread",6975824],"thread-6970818":["thread",6970818],"thread-6970537":["thread",6970537],"thread-6970168":["thread",6970168],"xfmg_media-1843":["xfmg_media",1843],"thread-6968378":["thread",6968378],"thread-6965731":["thread",6965731],"thread-6960644":["thread",6960644],"thread-6958484":["thread",6958484],"thread-6956185":["thread",6956185],"thread-223449":["thread",223449],"thread-219229":["thread",219229],"thread-165420":["thread",165420],"thread-165330":["thread",165330]}, NULL, 1714801081
Run Time: 0.000386
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20