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 (7205881, 7199591, 7199304, 7189128, 7177554, 7176276, 7174453, 7155738, 7140965, 7119587, 7116413, 7107656, 7090030, 7080657, 7050535, 7046626, 6986232, 6977286, 6977283, 6977282, 6373818, 6358984, 6322324, 6312491, 6312483, 6312478, 6312473, 6312468, 6297637, 6266664, 239426, 230605, 224028, 222835, 219768, 215108, 213702, 209003, 208628, 208498, 208426, 208114, 207927, 207096, 202860, 193002, 192712, 190629, 190565, 188790, 188677, 182427, 179294, 178435, 178407, 178167, 177894, 176759, 176546, 176458, 176420, 175646, 175630, 173897, 160917, 160912, 160911, 160385, 160361, 160356, 13761, 13627, 13500, 13430, 13415, 13026, 12468, 12438, 12183, 12126, 11783, 11666, 11402, 11147, 11094, 11061, 10875, 10454, 10366, 10260, 10045, 10031, 9941, 9704, 9593, 9519, 9341, 9317, 9253, 9102, 9040, 9036, 8978, 8877, 8734, 8499, 8442, 8360, 7986, 7978, 7934, 7517, 7511, 7157, 7156, 6832, 6781, 6734, 6556, 6536, 5968, 5956, 5857, 5748, 5394, 5078, 4925, 4612, 4607, 4548, 4301, 3969, 3676, 3625, 3550, 3104, 2975, 2674, 2415, 2263, 2086, 1809, 1747, 1628, 1560, 1254, 1216, 1170, 944, 897, 828, 724, 665, 534, 444, 129))
Run Time: 0.010996
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 156 | 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: 105, 0, 1714341475, {"thread-7205881":["thread",7205881],"thread-7199591":["thread",7199591],"thread-7199304":["thread",7199304],"thread-7189128":["thread",7189128],"thread-7177554":["thread",7177554],"thread-7176276":["thread",7176276],"thread-7174453":["thread",7174453],"thread-7155738":["thread",7155738],"thread-7140965":["thread",7140965],"thread-7119587":["thread",7119587],"thread-7116413":["thread",7116413],"thread-7107656":["thread",7107656],"thread-7090030":["thread",7090030],"thread-7080657":["thread",7080657],"thread-7050535":["thread",7050535],"thread-6986232":["thread",6986232],"thread-6977286":["thread",6977286],"thread-6977283":["thread",6977283],"thread-6977282":["thread",6977282],"thread-6358984":["thread",6358984],"thread-6297637":["thread",6297637],"thread-6266664":["thread",6266664],"thread-230605":["thread",230605],"thread-222835":["thread",222835],"thread-215108":["thread",215108],"thread-213702":["thread",213702],"thread-208628":["thread",208628],"thread-208498":["thread",208498],"thread-208426":["thread",208426],"thread-208114":["thread",208114],"thread-207927":["thread",207927],"thread-207096":["thread",207096],"thread-202860":["thread",202860],"thread-193002":["thread",193002],"thread-190629":["thread",190629],"thread-188677":["thread",188677],"thread-182427":["thread",182427],"thread-179294":["thread",179294],"thread-178435":["thread",178435],"thread-178167":["thread",178167],"thread-177894":["thread",177894],"thread-176458":["thread",176458],"thread-176420":["thread",176420],"thread-175646":["thread",175646],"thread-175630":["thread",175630],"thread-173897":["thread",173897],"thread-160385":["thread",160385],"thread-160361":["thread",160361],"thread-160356":["thread",160356],"thread-13761":["thread",13761],"thread-13627":["thread",13627],"thread-13500":["thread",13500],"thread-13430":["thread",13430],"thread-13415":["thread",13415],"thread-13026":["thread",13026],"thread-12468":["thread",12468],"thread-12438":["thread",12438],"thread-12183":["thread",12183],"thread-12126":["thread",12126],"thread-11783":["thread",11783],"thread-11666":["thread",11666],"thread-11402":["thread",11402],"thread-11147":["thread",11147],"thread-11094":["thread",11094],"thread-11061":["thread",11061],"thread-10875":["thread",10875],"thread-10454":["thread",10454],"thread-10366":["thread",10366],"thread-10260":["thread",10260],"thread-10045":["thread",10045],"thread-10031":["thread",10031],"thread-9941":["thread",9941],"thread-9704":["thread",9704],"thread-9593":["thread",9593],"thread-9519":["thread",9519],"thread-9341":["thread",9341],"thread-9317":["thread",9317],"thread-9253":["thread",9253],"thread-9102":["thread",9102],"thread-9040":["thread",9040],"thread-9036":["thread",9036],"thread-8978":["thread",8978],"thread-8877":["thread",8877],"thread-8734":["thread",8734],"thread-8499":["thread",8499],"thread-8442":["thread",8442],"thread-8360":["thread",8360],"thread-7986":["thread",7986],"thread-7978":["thread",7978],"thread-7934":["thread",7934],"thread-7517":["thread",7517],"thread-7511":["thread",7511],"thread-7157":["thread",7157],"thread-7156":["thread",7156],"thread-6832":["thread",6832],"thread-6781":["thread",6781],"thread-6734":["thread",6734],"thread-6556":["thread",6556],"thread-6536":["thread",6536],"thread-5968":["thread",5968],"thread-5956":["thread",5956],"thread-5857":["thread",5857],"thread-5748":["thread",5748],"thread-5394":["thread",5394],"thread-5078":["thread",5078],"thread-4925":["thread",4925],"thread-4612":["thread",4612],"thread-4607":["thread",4607],"thread-4548":["thread",4548],"thread-4301":["thread",4301],"thread-3969":["thread",3969],"thread-3676":["thread",3676],"thread-3625":["thread",3625],"thread-3550":["thread",3550],"thread-3104":["thread",3104],"thread-2975":["thread",2975],"thread-2674":["thread",2674],"thread-2415":["thread",2415],"thread-2263":["thread",2263],"thread-2086":["thread",2086],"thread-1809":["thread",1809],"thread-1747":["thread",1747],"thread-1628":["thread",1628],"thread-1560":["thread",1560],"thread-1254":["thread",1254],"thread-1216":["thread",1216],"thread-1170":["thread",1170],"thread-944":["thread",944],"thread-897":["thread",897],"thread-828":["thread",828],"thread-724":["thread",724],"thread-665":["thread",665],"thread-534":["thread",534],"thread-444":["thread",444],"thread-129":["thread",129]}, NULL, 1714337875
Run Time: 0.000619
- 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