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 (7216326, 7215546, 7215236, 7215030, 7214368, 7213663, 7212741, 7210523, 7210152, 7208468, 7208233, 7207008, 7194612, 7194355, 7192926, 7192841, 7191446, 7185852, 7184094, 7183540, 7176687, 7176094, 7176037, 7174538, 7174537, 7173851, 7173069, 7173036, 7168988, 7166114, 7165073, 7164410, 7163309, 7159563, 7159498, 7157455, 7154006, 7149867, 7149769, 7143098, 7142232, 7139783, 7137726, 7137225, 7136813, 7130580, 7129976, 7121346, 7118490, 7117211, 7112004, 7109179, 7108861, 7108803, 7107016, 7106769, 7104032, 7096207, 7096203, 7095143, 7090855, 7090656, 7086139, 7084747, 7079704, 7076110, 7070719, 7063916, 7062586, 7061629, 7061627, 7061624, 7054843, 7048766, 7045562, 7033974, 7033100, 7032545, 7031448, 7030562, 7030349, 7029783, 7029586, 7029333, 7026678, 7022389, 7016938, 7014426, 7007768, 6992790, 6988549, 6982475, 6981317, 6980855, 6978653, 6977283, 6977282, 6975447, 6974286, 6958909, 234711, 225408, 213240, 205001, 200147, 199104, 191576, 178407, 178167, 177665, 176386, 171019, 164248, 163564, 161919, 161837, 160947, 13854, 13743, 13647, 13618, 13601, 13421, 13401, 13328, 13309, 13289, 13155, 13017, 12967, 12921, 12902, 12775, 12551, 12525, 12329, 12273, 12166, 12030, 11906, 11816, 11513, 11424, 11420, 10990, 10837, 10805, 10637, 10619, 10606, 10565, 10559, 10285, 10075, 9994, 9628, 9603, 9040, 8902, 8793, 8517, 8318, 8046, 8026, 7951, 7580, 7574, 7460, 7414, 7101, 7059, 6562, 6534, 6497, 5997, 5889, 5498, 5442, 5351, 5350, 5348, 5347, 5109, 4975, 4695, 4593, 4518, 4383, 4285, 4040, 4019, 4005, 3513, 3389, 3331, 2986, 2975, 2677, 2456, 2361))
Run Time: 0.011680
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 418, 0, 1714632893, {"thread-7216326":["thread",7216326],"thread-7215546":["thread",7215546],"thread-7215236":["thread",7215236],"thread-7215030":["thread",7215030],"thread-7214368":["thread",7214368],"thread-7213663":["thread",7213663],"thread-7212741":["thread",7212741],"thread-7210523":["thread",7210523],"thread-7210152":["thread",7210152],"thread-7208468":["thread",7208468],"thread-7208233":["thread",7208233],"thread-7207008":["thread",7207008],"thread-7194612":["thread",7194612],"thread-7194355":["thread",7194355],"thread-7192926":["thread",7192926],"thread-7192841":["thread",7192841],"thread-7191446":["thread",7191446],"thread-7185852":["thread",7185852],"thread-7184094":["thread",7184094],"thread-7183540":["thread",7183540],"thread-7176687":["thread",7176687],"thread-7176094":["thread",7176094],"thread-7176037":["thread",7176037],"thread-7174538":["thread",7174538],"thread-7174537":["thread",7174537],"thread-7173851":["thread",7173851],"thread-7173069":["thread",7173069],"thread-7173036":["thread",7173036],"thread-7168988":["thread",7168988],"thread-7166114":["thread",7166114],"thread-7165073":["thread",7165073],"thread-7164410":["thread",7164410],"thread-7163309":["thread",7163309],"thread-7159563":["thread",7159563],"thread-7159498":["thread",7159498],"thread-7157455":["thread",7157455],"thread-7154006":["thread",7154006],"thread-7149867":["thread",7149867],"thread-7149769":["thread",7149769],"thread-7143098":["thread",7143098],"thread-7142232":["thread",7142232],"thread-7139783":["thread",7139783],"thread-7137726":["thread",7137726],"thread-7137225":["thread",7137225],"thread-7136813":["thread",7136813],"thread-7130580":["thread",7130580],"thread-7129976":["thread",7129976],"thread-7121346":["thread",7121346],"thread-7118490":["thread",7118490],"thread-7117211":["thread",7117211],"thread-7112004":["thread",7112004],"thread-7109179":["thread",7109179],"thread-7108861":["thread",7108861],"thread-7108803":["thread",7108803],"thread-7107016":["thread",7107016],"thread-7106769":["thread",7106769],"thread-7104032":["thread",7104032],"thread-7096207":["thread",7096207],"thread-7096203":["thread",7096203],"thread-7095143":["thread",7095143],"thread-7090855":["thread",7090855],"thread-7090656":["thread",7090656],"thread-7086139":["thread",7086139],"thread-7084747":["thread",7084747],"thread-7079704":["thread",7079704],"thread-7076110":["thread",7076110],"thread-7070719":["thread",7070719],"thread-7063916":["thread",7063916],"thread-7062586":["thread",7062586],"thread-7061629":["thread",7061629],"thread-7061627":["thread",7061627],"thread-7061624":["thread",7061624],"thread-7054843":["thread",7054843],"thread-7048766":["thread",7048766],"thread-7045562":["thread",7045562],"thread-7033974":["thread",7033974],"thread-7033100":["thread",7033100],"thread-7032545":["thread",7032545],"thread-7031448":["thread",7031448],"thread-7030562":["thread",7030562],"thread-7030349":["thread",7030349],"thread-7029783":["thread",7029783],"thread-7029586":["thread",7029586],"thread-7029333":["thread",7029333],"thread-7026678":["thread",7026678],"thread-7022389":["thread",7022389],"thread-7016938":["thread",7016938],"thread-7014426":["thread",7014426],"thread-7007768":["thread",7007768],"thread-6992790":["thread",6992790],"thread-6988549":["thread",6988549],"thread-6982475":["thread",6982475],"thread-6981317":["thread",6981317],"thread-6980855":["thread",6980855],"thread-6978653":["thread",6978653],"thread-6977283":["thread",6977283],"thread-6977282":["thread",6977282],"thread-6975447":["thread",6975447],"thread-6974286":["thread",6974286],"thread-6958909":["thread",6958909],"thread-234711":["thread",234711],"thread-225408":["thread",225408],"thread-213240":["thread",213240],"thread-205001":["thread",205001],"thread-200147":["thread",200147],"thread-199104":["thread",199104],"thread-191576":["thread",191576],"thread-178167":["thread",178167],"thread-177665":["thread",177665],"thread-176386":["thread",176386],"thread-171019":["thread",171019],"thread-164248":["thread",164248],"thread-163564":["thread",163564],"thread-161919":["thread",161919],"thread-161837":["thread",161837],"thread-160947":["thread",160947],"thread-13854":["thread",13854],"thread-13743":["thread",13743],"thread-13647":["thread",13647],"thread-13618":["thread",13618],"thread-13601":["thread",13601],"thread-13421":["thread",13421],"thread-13401":["thread",13401],"thread-13328":["thread",13328],"thread-13309":["thread",13309],"thread-13289":["thread",13289],"thread-13155":["thread",13155],"thread-13017":["thread",13017],"thread-12967":["thread",12967],"thread-12921":["thread",12921],"thread-12902":["thread",12902],"thread-12775":["thread",12775],"thread-12551":["thread",12551],"thread-12525":["thread",12525],"thread-12329":["thread",12329],"thread-12273":["thread",12273],"thread-12166":["thread",12166],"thread-12030":["thread",12030],"thread-11906":["thread",11906],"thread-11816":["thread",11816],"thread-11513":["thread",11513],"thread-11424":["thread",11424],"thread-11420":["thread",11420],"thread-10990":["thread",10990],"thread-10837":["thread",10837],"thread-10805":["thread",10805],"thread-10637":["thread",10637],"thread-10619":["thread",10619],"thread-10606":["thread",10606],"thread-10565":["thread",10565],"thread-10559":["thread",10559],"thread-10285":["thread",10285],"thread-10075":["thread",10075],"thread-9994":["thread",9994],"thread-9628":["thread",9628],"thread-9603":["thread",9603],"thread-9040":["thread",9040],"thread-8902":["thread",8902],"thread-8793":["thread",8793],"thread-8517":["thread",8517],"thread-8318":["thread",8318],"thread-8046":["thread",8046],"thread-8026":["thread",8026],"thread-7951":["thread",7951],"thread-7580":["thread",7580],"thread-7574":["thread",7574],"thread-7460":["thread",7460],"thread-7414":["thread",7414],"thread-7101":["thread",7101],"thread-7059":["thread",7059],"thread-6562":["thread",6562],"thread-6534":["thread",6534],"thread-6497":["thread",6497],"thread-5997":["thread",5997],"thread-5889":["thread",5889],"thread-5498":["thread",5498],"thread-5442":["thread",5442],"thread-5351":["thread",5351],"thread-5350":["thread",5350],"thread-5348":["thread",5348],"thread-5347":["thread",5347],"thread-5109":["thread",5109],"thread-4975":["thread",4975],"thread-4695":["thread",4695],"thread-4593":["thread",4593],"thread-4518":["thread",4518],"thread-4383":["thread",4383],"thread-4285":["thread",4285],"thread-4040":["thread",4040],"thread-4019":["thread",4019],"thread-4005":["thread",4005],"thread-3513":["thread",3513],"thread-3389":["thread",3389],"thread-3331":["thread",3331],"thread-2986":["thread",2986],"thread-2975":["thread",2975],"thread-2677":["thread",2677],"thread-2456":["thread",2456],"thread-2361":["thread",2361]}, NULL, 1714629293
Run Time: 0.000585
- 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