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 (179286, 179195, 178802, 178657, 176474, 176473, 176153, 176035, 176034, 175716, 173480, 173301, 173235, 173105, 171806, 171516, 170800, 170454, 170241, 170124, 168712, 164565, 164037, 163102, 162233, 159356, 158651, 157650, 156983, 156216, 155880, 155044, 153197, 152619, 152077, 122272, 120363, 120358, 120356, 120327, 120318, 120261, 120256, 120251, 120250, 120239, 120209, 120205, 120196, 120184, 120182, 120061, 120050, 120024, 119997, 119993, 119992, 119947, 119916, 119822, 119785, 119617, 119605, 119515, 119450, 119300, 118890, 118755, 118542, 118513, 118499, 118383, 118382, 118380, 118326, 118287, 118254, 118251, 118172, 118095, 118034, 118011, 118003, 117999, 117993, 117987, 117712, 117706, 117694, 117682, 117680, 117611, 117494, 117488, 117479, 117430, 117429, 117419, 117359, 117356, 117317, 117306, 117267, 117241, 117160, 117084, 117064, 116967, 116943, 116811, 116801, 116800, 116799, 116783, 116773, 116748, 116578, 116540, 116534, 116498, 116428, 116425, 116163, 116162, 116159, 116122, 116049, 116028, 116010, 115938, 115927, 115840, 115721, 115688, 115661, 115659, 115574, 115251, 115172, 115164, 115103, 115084, 114914, 114913, 114829, 114812, 114648, 114632, 114631, 114630, 114300, 114252, 114194, 113939, 113859, 113840, 113830, 113766, 113576, 113434, 113425, 113362, 113333, 113231, 113228, 113127, 113126, 113092, 113020, 112972, 112967, 112784, 112198, 112105, 112055, 112036, 112011, 111910, 111703, 111687, 111545, 111490, 111446, 111443, 111414, 111383, 111363, 111362, 111335, 111241, 111068, 110807, 110532, 110415, 110382, 110189, 110055, 110047, 109869, 109857))
Run Time: 0.116283
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 | 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: 3407, 0, 1715857557, {"thread-179286":["thread",179286],"thread-179195":["thread",179195],"thread-178802":["thread",178802],"thread-178657":["thread",178657],"thread-176474":["thread",176474],"thread-176473":["thread",176473],"thread-176153":["thread",176153],"thread-176035":["thread",176035],"thread-176034":["thread",176034],"thread-175716":["thread",175716],"thread-173301":["thread",173301],"thread-173235":["thread",173235],"thread-173105":["thread",173105],"thread-171806":["thread",171806],"thread-171516":["thread",171516],"thread-170800":["thread",170800],"thread-170454":["thread",170454],"thread-170241":["thread",170241],"thread-170124":["thread",170124],"thread-168712":["thread",168712],"thread-164037":["thread",164037],"thread-163102":["thread",163102],"thread-162233":["thread",162233],"thread-159356":["thread",159356],"thread-158651":["thread",158651],"thread-157650":["thread",157650],"thread-156983":["thread",156983],"thread-156216":["thread",156216],"thread-155880":["thread",155880],"thread-155044":["thread",155044],"thread-153197":["thread",153197],"thread-152619":["thread",152619],"thread-152077":["thread",152077],"thread-122272":["thread",122272],"thread-120363":["thread",120363],"thread-120358":["thread",120358],"thread-120356":["thread",120356],"thread-120327":["thread",120327],"thread-120318":["thread",120318],"thread-120261":["thread",120261],"thread-120256":["thread",120256],"thread-120251":["thread",120251],"thread-120250":["thread",120250],"thread-120239":["thread",120239],"thread-120209":["thread",120209],"thread-120205":["thread",120205],"thread-120196":["thread",120196],"thread-120184":["thread",120184],"thread-120182":["thread",120182],"thread-120061":["thread",120061],"thread-120050":["thread",120050],"thread-120024":["thread",120024],"thread-119997":["thread",119997],"thread-119993":["thread",119993],"thread-119992":["thread",119992],"thread-119947":["thread",119947],"thread-119916":["thread",119916],"thread-119822":["thread",119822],"thread-119785":["thread",119785],"thread-119617":["thread",119617],"thread-119605":["thread",119605],"thread-119515":["thread",119515],"thread-119450":["thread",119450],"thread-119300":["thread",119300],"thread-118890":["thread",118890],"thread-118755":["thread",118755],"thread-118542":["thread",118542],"thread-118513":["thread",118513],"thread-118499":["thread",118499],"thread-118383":["thread",118383],"thread-118382":["thread",118382],"thread-118380":["thread",118380],"thread-118326":["thread",118326],"thread-118287":["thread",118287],"thread-118254":["thread",118254],"thread-118251":["thread",118251],"thread-118172":["thread",118172],"thread-118095":["thread",118095],"thread-118034":["thread",118034],"thread-118011":["thread",118011],"thread-118003":["thread",118003],"thread-117999":["thread",117999],"thread-117993":["thread",117993],"thread-117987":["thread",117987],"thread-117712":["thread",117712],"thread-117706":["thread",117706],"thread-117694":["thread",117694],"thread-117682":["thread",117682],"thread-117680":["thread",117680],"thread-117611":["thread",117611],"thread-117494":["thread",117494],"thread-117488":["thread",117488],"thread-117479":["thread",117479],"thread-117430":["thread",117430],"thread-117429":["thread",117429],"thread-117419":["thread",117419],"thread-117359":["thread",117359],"thread-117356":["thread",117356],"thread-117317":["thread",117317],"thread-117306":["thread",117306],"thread-117267":["thread",117267],"thread-117241":["thread",117241],"thread-117160":["thread",117160],"thread-117084":["thread",117084],"thread-117064":["thread",117064],"thread-116967":["thread",116967],"thread-116943":["thread",116943],"thread-116811":["thread",116811],"thread-116801":["thread",116801],"thread-116800":["thread",116800],"thread-116799":["thread",116799],"thread-116783":["thread",116783],"thread-116773":["thread",116773],"thread-116748":["thread",116748],"thread-116578":["thread",116578],"thread-116540":["thread",116540],"thread-116534":["thread",116534],"thread-116498":["thread",116498],"thread-116428":["thread",116428],"thread-116425":["thread",116425],"thread-116163":["thread",116163],"thread-116162":["thread",116162],"thread-116159":["thread",116159],"thread-116122":["thread",116122],"thread-116049":["thread",116049],"thread-116028":["thread",116028],"thread-116010":["thread",116010],"thread-115938":["thread",115938],"thread-115927":["thread",115927],"thread-115840":["thread",115840],"thread-115721":["thread",115721],"thread-115688":["thread",115688],"thread-115661":["thread",115661],"thread-115659":["thread",115659],"thread-115574":["thread",115574],"thread-115251":["thread",115251],"thread-115172":["thread",115172],"thread-115164":["thread",115164],"thread-115103":["thread",115103],"thread-115084":["thread",115084],"thread-114914":["thread",114914],"thread-114913":["thread",114913],"thread-114829":["thread",114829],"thread-114812":["thread",114812],"thread-114648":["thread",114648],"thread-114632":["thread",114632],"thread-114631":["thread",114631],"thread-114630":["thread",114630],"thread-114300":["thread",114300],"thread-114252":["thread",114252],"thread-114194":["thread",114194],"thread-113939":["thread",113939],"thread-113859":["thread",113859],"thread-113840":["thread",113840],"thread-113830":["thread",113830],"thread-113766":["thread",113766],"thread-113576":["thread",113576],"thread-113434":["thread",113434],"thread-113425":["thread",113425],"thread-113362":["thread",113362],"thread-113333":["thread",113333],"thread-113231":["thread",113231],"thread-113228":["thread",113228],"thread-113127":["thread",113127],"thread-113126":["thread",113126],"thread-113092":["thread",113092],"thread-113020":["thread",113020],"thread-112972":["thread",112972],"thread-112967":["thread",112967],"thread-112784":["thread",112784],"thread-112198":["thread",112198],"thread-112105":["thread",112105],"thread-112055":["thread",112055],"thread-112036":["thread",112036],"thread-112011":["thread",112011],"thread-111910":["thread",111910],"thread-111703":["thread",111703],"thread-111687":["thread",111687],"thread-111545":["thread",111545],"thread-111490":["thread",111490],"thread-111446":["thread",111446],"thread-111443":["thread",111443],"thread-111414":["thread",111414],"thread-111383":["thread",111383],"thread-111363":["thread",111363],"thread-111362":["thread",111362],"thread-111335":["thread",111335],"thread-111241":["thread",111241],"thread-111068":["thread",111068],"thread-110807":["thread",110807],"thread-110532":["thread",110532],"thread-110415":["thread",110415],"thread-110382":["thread",110382],"thread-110189":["thread",110189],"thread-110055":["thread",110055],"thread-110047":["thread",110047],"thread-109869":["thread",109869],"thread-109857":["thread",109857]}, , 1715853957
Run Time: 0.000482
- 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