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 (181819, 179009, 178889, 178658, 177888, 177586, 177101, 176882, 176449, 170181, 169985, 169808, 169689, 167116, 166271, 165139, 165027, 163234, 162384, 159885, 159447, 159064, 158193, 157504, 154479, 147326, 139837, 133645, 131747, 130528, 129266, 127128, 126800, 126539, 126374, 125867, 125821, 125743, 122438, 120479, 119846, 119485, 116862, 112585, 112201, 111402, 110581, 109229, 108742, 108513, 108031, 107826, 102783, 102263, 100580, 99839, 99499, 99202, 98769, 97020, 95649, 94381, 93394, 91621, 87608, 86834, 86748, 82624, 82052, 79425, 76088, 75765, 72895, 71384, 69317, 68511, 67014, 64876, 62204, 61123, 59548, 59540, 54599, 54501, 52993, 52992, 52991, 40949, 39300, 38230, 36353, 36352, 32943, 32399, 27940, 25859, 25419, 23635, 19921, 18401, 5615, 2455, 922))
Run Time: 0.044371
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 103 | 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: 230, 0, 1714801779, {"thread-181819":["thread",181819],"thread-179009":["thread",179009],"thread-178889":["thread",178889],"thread-178658":["thread",178658],"thread-177888":["thread",177888],"thread-177586":["thread",177586],"thread-177101":["thread",177101],"thread-176882":["thread",176882],"thread-176449":["thread",176449],"thread-170181":["thread",170181],"thread-169985":["thread",169985],"thread-169808":["thread",169808],"thread-169689":["thread",169689],"thread-167116":["thread",167116],"thread-166271":["thread",166271],"thread-165139":["thread",165139],"thread-165027":["thread",165027],"tl_group-220":["tl_group",220],"thread-163234":["thread",163234],"thread-162384":["thread",162384],"thread-159885":["thread",159885],"thread-159447":["thread",159447],"thread-159064":["thread",159064],"thread-158193":["thread",158193],"thread-157504":["thread",157504],"thread-154479":["thread",154479],"thread-147326":["thread",147326],"thread-139837":["thread",139837],"thread-133645":["thread",133645],"thread-131747":["thread",131747],"thread-130528":["thread",130528],"thread-129266":["thread",129266],"thread-127128":["thread",127128],"thread-126800":["thread",126800],"thread-126539":["thread",126539],"thread-126374":["thread",126374],"thread-125867":["thread",125867],"thread-125821":["thread",125821],"thread-125743":["thread",125743],"thread-122438":["thread",122438],"thread-120479":["thread",120479],"thread-119846":["thread",119846],"thread-119485":["thread",119485],"thread-116862":["thread",116862],"thread-112585":["thread",112585],"thread-112201":["thread",112201],"thread-111402":["thread",111402],"thread-110581":["thread",110581],"thread-109229":["thread",109229],"thread-108742":["thread",108742],"thread-108513":["thread",108513],"thread-108031":["thread",108031],"thread-107826":["thread",107826],"thread-102783":["thread",102783],"thread-102263":["thread",102263],"thread-100580":["thread",100580],"thread-99839":["thread",99839],"thread-99499":["thread",99499],"thread-99202":["thread",99202],"thread-98769":["thread",98769],"thread-97020":["thread",97020],"thread-95649":["thread",95649],"thread-94381":["thread",94381],"thread-93394":["thread",93394],"thread-91621":["thread",91621],"thread-87608":["thread",87608],"thread-86834":["thread",86834],"thread-86748":["thread",86748],"thread-82624":["thread",82624],"thread-82052":["thread",82052],"thread-79425":["thread",79425],"thread-76088":["thread",76088],"thread-75765":["thread",75765],"thread-72895":["thread",72895],"thread-71384":["thread",71384],"thread-69317":["thread",69317],"thread-68511":["thread",68511],"thread-67014":["thread",67014],"thread-64876":["thread",64876],"thread-62204":["thread",62204],"thread-61123":["thread",61123],"thread-59548":["thread",59548],"thread-59540":["thread",59540],"thread-54599":["thread",54599],"thread-54501":["thread",54501],"thread-52993":["thread",52993],"thread-52992":["thread",52992],"thread-52991":["thread",52991],"thread-40949":["thread",40949],"thread-39300":["thread",39300],"thread-38230":["thread",38230],"thread-36353":["thread",36353],"thread-36352":["thread",36352],"thread-32943":["thread",32943],"thread-32399":["thread",32399],"thread-27940":["thread",27940],"thread-25859":["thread",25859],"thread-25419":["thread",25419],"thread-23635":["thread",23635],"thread-19921":["thread",19921],"thread-18401":["thread",18401],"thread-5615":["thread",5615],"thread-2455":["thread",2455],"thread-922":["thread",922]}, , 1714798179
Run Time: 0.000311
- 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