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 (183449, 183441, 183400, 183348, 183337, 183326, 183280, 183247, 183203, 183156, 183147, 183114, 182905, 182841, 182731, 182729, 182405, 182306, 182286, 182073, 181982, 181687, 181237, 181131, 180891, 180885, 180844, 180750, 180721, 180514, 180435, 180188, 179699, 179641, 179435, 179408, 179198, 179127, 179090, 178999, 178833, 178721, 178460, 178458, 178437, 178359, 178230, 178159, 178147, 178125, 178006, 177298, 177264, 177204, 177102, 177044, 176568, 176375, 176268, 176122, 176039, 176032, 175973, 175932, 175808, 175709, 175695, 175624, 175402, 175365, 175360, 175339, 175263, 175221, 175203, 175063, 174983, 174802, 174707, 174689, 174666, 174616, 174594, 174583, 174565, 174545, 174458, 174440, 174151, 173939, 173904, 173849, 173845, 173816, 173801, 173710, 173384, 173284, 173279, 173213, 173158, 172976, 172951, 172919, 172864, 172838, 172764, 172497, 172414, 171908, 171851, 171566, 171535, 171338, 171211, 171046, 171035, 170983, 170951, 170811, 170801, 170617, 170601, 170525, 170145, 170131, 170035, 169662, 169564, 169310, 169170, 169123, 169083, 169024, 168915, 168876, 168838, 168791, 168769, 168715, 168708, 168694, 168674, 168428, 168411, 168270, 168255, 168188, 168156, 168020, 167952, 167683, 167538, 166489, 166181, 166159, 165821, 165292, 165291, 165090, 164833, 164774, 164465, 164331, 164191, 164047, 164013, 163824, 163514, 163466, 163438, 163142, 162995, 162653, 161523, 161462, 161411, 161318, 160530, 160392, 160176, 159810, 159115, 158769, 157621, 157478, 157426, 157063, 156954, 156406, 156285, 156238, 155884, 155679))
Run Time: 0.061507
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 194 | 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: 232, 0, 1715917856, {"thread-183449":["thread",183449],"thread-183441":["thread",183441],"ams_article-5360":["ams_article",5360],"thread-183400":["thread",183400],"thread-183348":["thread",183348],"thread-183337":["thread",183337],"thread-183326":["thread",183326],"thread-183280":["thread",183280],"thread-183247":["thread",183247],"thread-183203":["thread",183203],"thread-183156":["thread",183156],"thread-183147":["thread",183147],"thread-183114":["thread",183114],"thread-182905":["thread",182905],"thread-182841":["thread",182841],"thread-182731":["thread",182731],"thread-182729":["thread",182729],"thread-182405":["thread",182405],"thread-182306":["thread",182306],"thread-182286":["thread",182286],"thread-182073":["thread",182073],"thread-181982":["thread",181982],"thread-181687":["thread",181687],"thread-181237":["thread",181237],"thread-181131":["thread",181131],"thread-180891":["thread",180891],"thread-180885":["thread",180885],"thread-180844":["thread",180844],"thread-180750":["thread",180750],"thread-180721":["thread",180721],"thread-180514":["thread",180514],"thread-180435":["thread",180435],"thread-180188":["thread",180188],"thread-179699":["thread",179699],"thread-179641":["thread",179641],"thread-179435":["thread",179435],"thread-179408":["thread",179408],"thread-179198":["thread",179198],"thread-179127":["thread",179127],"thread-179090":["thread",179090],"thread-178999":["thread",178999],"thread-178833":["thread",178833],"thread-178721":["thread",178721],"thread-178460":["thread",178460],"thread-178458":["thread",178458],"thread-178437":["thread",178437],"thread-178359":["thread",178359],"thread-178230":["thread",178230],"thread-178159":["thread",178159],"thread-178147":["thread",178147],"thread-178125":["thread",178125],"thread-178006":["thread",178006],"thread-177298":["thread",177298],"thread-177264":["thread",177264],"thread-177204":["thread",177204],"thread-177102":["thread",177102],"thread-177044":["thread",177044],"thread-176568":["thread",176568],"thread-176375":["thread",176375],"thread-176268":["thread",176268],"thread-176122":["thread",176122],"thread-176039":["thread",176039],"thread-176032":["thread",176032],"ams_article-5089":["ams_article",5089],"thread-175973":["thread",175973],"thread-175932":["thread",175932],"thread-175808":["thread",175808],"thread-175709":["thread",175709],"thread-175695":["thread",175695],"thread-175624":["thread",175624],"thread-175402":["thread",175402],"thread-175365":["thread",175365],"thread-175360":["thread",175360],"thread-175339":["thread",175339],"thread-175263":["thread",175263],"thread-175221":["thread",175221],"thread-175203":["thread",175203],"thread-175063":["thread",175063],"thread-174983":["thread",174983],"thread-174802":["thread",174802],"thread-174707":["thread",174707],"thread-174689":["thread",174689],"thread-174666":["thread",174666],"thread-174616":["thread",174616],"thread-174594":["thread",174594],"thread-174583":["thread",174583],"thread-174565":["thread",174565],"thread-174545":["thread",174545],"thread-174458":["thread",174458],"thread-174440":["thread",174440],"thread-174151":["thread",174151],"thread-173939":["thread",173939],"thread-173904":["thread",173904],"thread-173849":["thread",173849],"thread-173845":["thread",173845],"thread-173816":["thread",173816],"thread-173801":["thread",173801],"thread-173710":["thread",173710],"thread-173384":["thread",173384],"thread-173284":["thread",173284],"thread-173279":["thread",173279],"thread-173213":["thread",173213],"thread-173158":["thread",173158],"thread-172976":["thread",172976],"thread-172951":["thread",172951],"thread-172919":["thread",172919],"thread-172864":["thread",172864],"thread-172838":["thread",172838],"thread-172764":["thread",172764],"thread-172497":["thread",172497],"thread-172414":["thread",172414],"thread-171908":["thread",171908],"thread-171851":["thread",171851],"thread-171566":["thread",171566],"thread-171535":["thread",171535],"thread-171338":["thread",171338],"thread-171211":["thread",171211],"thread-171046":["thread",171046],"thread-171035":["thread",171035],"thread-170983":["thread",170983],"thread-170951":["thread",170951],"thread-170811":["thread",170811],"thread-170801":["thread",170801],"thread-170617":["thread",170617],"thread-170601":["thread",170601],"thread-170525":["thread",170525],"thread-170145":["thread",170145],"thread-170131":["thread",170131],"thread-170035":["thread",170035],"thread-169662":["thread",169662],"thread-169564":["thread",169564],"thread-169310":["thread",169310],"thread-169170":["thread",169170],"thread-169123":["thread",169123],"thread-169083":["thread",169083],"thread-169024":["thread",169024],"thread-168915":["thread",168915],"thread-168876":["thread",168876],"thread-168838":["thread",168838],"thread-168791":["thread",168791],"thread-168769":["thread",168769],"thread-168715":["thread",168715],"thread-168708":["thread",168708],"thread-168694":["thread",168694],"thread-168674":["thread",168674],"thread-168428":["thread",168428],"thread-168411":["thread",168411],"thread-168270":["thread",168270],"thread-168255":["thread",168255],"thread-168188":["thread",168188],"thread-168156":["thread",168156],"thread-168020":["thread",168020],"thread-167952":["thread",167952],"thread-167683":["thread",167683],"thread-167538":["thread",167538],"thread-166489":["thread",166489],"thread-166181":["thread",166181],"thread-166159":["thread",166159],"thread-165821":["thread",165821],"thread-165292":["thread",165292],"thread-165291":["thread",165291],"thread-165090":["thread",165090],"thread-164833":["thread",164833],"thread-164774":["thread",164774],"thread-164465":["thread",164465],"thread-164331":["thread",164331],"thread-164191":["thread",164191],"thread-164047":["thread",164047],"thread-164013":["thread",164013],"thread-163824":["thread",163824],"ams_article-4546":["ams_article",4546],"thread-163514":["thread",163514],"ams_article-4543":["ams_article",4543],"thread-163466":["thread",163466],"thread-163438":["thread",163438],"thread-163142":["thread",163142],"thread-162995":["thread",162995],"thread-162653":["thread",162653],"thread-161523":["thread",161523],"thread-161462":["thread",161462],"thread-161411":["thread",161411],"thread-161318":["thread",161318],"thread-160530":["thread",160530],"thread-160392":["thread",160392],"thread-160176":["thread",160176],"thread-159810":["thread",159810],"thread-159115":["thread",159115],"thread-158769":["thread",158769],"ams_article-4298":["ams_article",4298],"thread-157621":["thread",157621],"thread-157478":["thread",157478],"thread-157426":["thread",157426],"thread-157063":["thread",157063],"thread-156954":["thread",156954],"thread-156406":["thread",156406],"thread-156285":["thread",156285],"thread-156238":["thread",156238],"thread-155884":["thread",155884],"thread-155679":["thread",155679]}, , 1715914256
Run Time: 0.000292
- 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