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 (182802, 178934, 178334, 176664, 176053, 175989, 175987, 175980, 174422, 174370, 174167, 174040, 173498, 173051, 169806, 169240, 169110, 166358, 164267, 163134, 162763, 162597, 156358, 153884, 153636, 152627, 152184, 141652, 140922, 136267, 129545, 129180, 129179, 129178, 129030, 128850, 128283, 128166, 126525, 125246, 122872, 122475, 121859, 121698, 121209, 121124, 119665, 118966, 112288, 107330, 104408, 101781, 101276, 98914, 98512, 97151, 95407, 91093, 89956, 89955, 84740, 83393, 83392, 82818, 79750, 78357, 73319, 68730, 68665, 65905, 65512, 65072, 62964, 60783, 59108, 58704, 57213, 55795, 55597, 54170, 54166, 53743, 51540, 50655, 48350, 28725))
Run Time: 0.052567
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 86 | 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: 3888, 0, 1716359234, {"thread-182802":["thread",182802],"thread-178934":["thread",178934],"thread-178334":["thread",178334],"thread-176664":["thread",176664],"thread-176053":["thread",176053],"thread-175989":["thread",175989],"thread-175987":["thread",175987],"thread-175980":["thread",175980],"thread-174422":["thread",174422],"thread-174370":["thread",174370],"thread-174167":["thread",174167],"thread-174040":["thread",174040],"thread-173498":["thread",173498],"thread-173051":["thread",173051],"thread-169806":["thread",169806],"thread-169240":["thread",169240],"thread-169110":["thread",169110],"thread-166358":["thread",166358],"thread-164267":["thread",164267],"thread-163134":["thread",163134],"thread-162763":["thread",162763],"thread-162597":["thread",162597],"thread-156358":["thread",156358],"thread-153884":["thread",153884],"thread-153636":["thread",153636],"thread-152627":["thread",152627],"thread-152184":["thread",152184],"thread-141652":["thread",141652],"thread-140922":["thread",140922],"thread-136267":["thread",136267],"thread-129545":["thread",129545],"thread-129180":["thread",129180],"thread-129179":["thread",129179],"thread-129178":["thread",129178],"thread-129030":["thread",129030],"thread-128850":["thread",128850],"thread-128283":["thread",128283],"thread-128166":["thread",128166],"thread-126525":["thread",126525],"thread-125246":["thread",125246],"thread-122872":["thread",122872],"thread-122475":["thread",122475],"thread-121859":["thread",121859],"thread-121698":["thread",121698],"thread-121209":["thread",121209],"thread-121124":["thread",121124],"thread-119665":["thread",119665],"thread-118966":["thread",118966],"thread-112288":["thread",112288],"thread-107330":["thread",107330],"thread-104408":["thread",104408],"thread-101781":["thread",101781],"thread-101276":["thread",101276],"thread-98914":["thread",98914],"thread-98512":["thread",98512],"thread-97151":["thread",97151],"thread-95407":["thread",95407],"thread-91093":["thread",91093],"thread-89956":["thread",89956],"thread-89955":["thread",89955],"thread-84740":["thread",84740],"thread-83393":["thread",83393],"thread-83392":["thread",83392],"thread-82818":["thread",82818],"thread-79750":["thread",79750],"thread-78357":["thread",78357],"thread-73319":["thread",73319],"thread-68730":["thread",68730],"thread-68665":["thread",68665],"thread-65905":["thread",65905],"thread-65512":["thread",65512],"thread-65072":["thread",65072],"thread-62964":["thread",62964],"thread-60783":["thread",60783],"thread-59108":["thread",59108],"thread-58704":["thread",58704],"thread-57213":["thread",57213],"thread-55795":["thread",55795],"thread-55597":["thread",55597],"thread-54170":["thread",54170],"thread-54166":["thread",54166],"thread-53743":["thread",53743],"thread-51540":["thread",51540],"thread-50655":["thread",50655],"thread-48350":["thread",48350],"thread-28725":["thread",28725]}, , 1716355634
Run Time: 0.000681
- 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