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 (182405, 181972, 181951, 179889, 179696, 179581, 177611, 172118, 171896, 169178, 167681, 166429, 164976, 164503, 160062, 156736, 156735, 155914, 154993, 154289, 153827, 153796, 153748, 152830, 152538, 149425, 147142, 145794, 145263, 145102, 139362, 135353, 131034, 129854, 129290, 129209, 129064, 128925, 128790, 128789, 128266, 128207, 127645, 127482, 126476, 125948, 125864, 125621, 125433, 125425, 125424, 125221, 124814, 124705, 123452, 123315, 123202, 123177, 122748, 122616, 122537, 121599, 119010, 117819, 117311, 117034, 116864, 115919, 115918, 115876, 115875, 115871, 115212, 115111, 114894, 114294, 114239, 114045, 113579, 111543, 109343, 108834, 108579, 108208, 108193, 106968, 106711, 106244, 104660, 104625, 104565, 104174, 103805, 103731, 103524, 103362, 102640, 100820, 100790, 100735, 100729, 100715, 100468, 99820, 99629, 99552, 97237, 95905, 93914, 93758, 92892, 91517, 91495, 89803, 86190, 86147, 84917, 84916, 79357, 75857, 63733, 54631, 48425, 33239, 33212, 32756, 32748, 31123, 22072, 21835, 6795))
Run Time: 0.090888
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 131 | 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: 1267, 0, 1716006147, {"thread-182405":["thread",182405],"thread-181972":["thread",181972],"thread-181951":["thread",181951],"thread-179889":["thread",179889],"thread-179696":["thread",179696],"thread-179581":["thread",179581],"thread-177611":["thread",177611],"thread-172118":["thread",172118],"thread-171896":["thread",171896],"thread-169178":["thread",169178],"thread-167681":["thread",167681],"thread-166429":["thread",166429],"thread-164976":["thread",164976],"thread-164503":["thread",164503],"thread-160062":["thread",160062],"thread-156736":["thread",156736],"thread-156735":["thread",156735],"thread-155914":["thread",155914],"thread-154993":["thread",154993],"thread-154289":["thread",154289],"thread-153827":["thread",153827],"thread-153796":["thread",153796],"thread-152830":["thread",152830],"thread-152538":["thread",152538],"thread-149425":["thread",149425],"thread-147142":["thread",147142],"thread-145794":["thread",145794],"thread-145263":["thread",145263],"thread-145102":["thread",145102],"thread-139362":["thread",139362],"thread-135353":["thread",135353],"thread-131034":["thread",131034],"thread-129854":["thread",129854],"thread-129290":["thread",129290],"thread-129209":["thread",129209],"thread-129064":["thread",129064],"thread-128925":["thread",128925],"thread-128790":["thread",128790],"thread-128789":["thread",128789],"thread-128266":["thread",128266],"thread-128207":["thread",128207],"thread-127645":["thread",127645],"thread-127482":["thread",127482],"thread-126476":["thread",126476],"thread-125948":["thread",125948],"thread-125864":["thread",125864],"thread-125621":["thread",125621],"thread-125433":["thread",125433],"thread-125425":["thread",125425],"thread-125424":["thread",125424],"thread-125221":["thread",125221],"thread-124814":["thread",124814],"thread-124705":["thread",124705],"thread-123452":["thread",123452],"thread-123315":["thread",123315],"thread-123202":["thread",123202],"thread-123177":["thread",123177],"thread-122748":["thread",122748],"thread-122616":["thread",122616],"thread-122537":["thread",122537],"thread-121599":["thread",121599],"thread-119010":["thread",119010],"thread-117819":["thread",117819],"thread-117311":["thread",117311],"thread-117034":["thread",117034],"thread-116864":["thread",116864],"thread-115919":["thread",115919],"thread-115918":["thread",115918],"thread-115876":["thread",115876],"thread-115875":["thread",115875],"thread-115871":["thread",115871],"thread-115212":["thread",115212],"thread-115111":["thread",115111],"thread-114894":["thread",114894],"thread-114294":["thread",114294],"thread-114239":["thread",114239],"thread-114045":["thread",114045],"thread-113579":["thread",113579],"thread-111543":["thread",111543],"thread-109343":["thread",109343],"thread-108834":["thread",108834],"thread-108579":["thread",108579],"thread-108208":["thread",108208],"thread-108193":["thread",108193],"thread-106968":["thread",106968],"thread-106711":["thread",106711],"thread-106244":["thread",106244],"thread-104660":["thread",104660],"thread-104625":["thread",104625],"thread-104565":["thread",104565],"thread-104174":["thread",104174],"thread-103805":["thread",103805],"thread-103731":["thread",103731],"thread-103524":["thread",103524],"thread-103362":["thread",103362],"thread-102640":["thread",102640],"thread-100820":["thread",100820],"thread-100790":["thread",100790],"thread-100735":["thread",100735],"thread-100729":["thread",100729],"thread-100715":["thread",100715],"thread-100468":["thread",100468],"thread-99820":["thread",99820],"thread-99629":["thread",99629],"thread-99552":["thread",99552],"thread-97237":["thread",97237],"thread-95905":["thread",95905],"thread-93914":["thread",93914],"thread-93758":["thread",93758],"thread-92892":["thread",92892],"thread-91517":["thread",91517],"thread-91495":["thread",91495],"thread-89803":["thread",89803],"thread-86190":["thread",86190],"thread-86147":["thread",86147],"thread-84917":["thread",84917],"thread-84916":["thread",84916],"thread-79357":["thread",79357],"thread-75857":["thread",75857],"thread-63733":["thread",63733],"thread-54631":["thread",54631],"thread-48425":["thread",48425],"thread-33239":["thread",33239],"thread-33212":["thread",33212],"thread-32756":["thread",32756],"thread-32748":["thread",32748],"thread-31123":["thread",31123],"thread-22072":["thread",22072],"thread-21835":["thread",21835],"thread-6795":["thread",6795]}, , 1716002547
Run Time: 0.000236
- 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