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 (182604, 182503, 181761, 181473, 181437, 181201, 180931, 180805, 180467, 178829, 178583, 178292, 177854, 177675, 177521, 176305, 175535, 175527, 175519, 174814, 173006, 171790, 170510, 169437, 169221, 167919, 167899, 167789, 166498, 165862, 163746, 163399, 163007, 162940, 162897, 162705, 161715, 161558, 161080, 160843, 160828, 160583, 160311, 160068, 160065, 160056, 159375, 159374, 159306, 158908, 158571, 157127, 157109, 156960, 156249, 155946, 155658, 155652, 154605, 154027, 153537, 153450, 153237, 152992, 152268, 152231, 152190, 152015, 136958, 135807, 133700, 133030, 133026, 132136, 131175, 128774, 127056, 121673, 119105, 118980, 116748, 115516, 113068, 112219, 111697, 111013, 108855, 108373, 107053, 106583, 104170, 101865, 100866, 98648, 96569, 94905, 94775, 94437, 93649, 92217, 91855, 90906, 88925, 78613, 78420, 71151, 65690, 60197, 57243, 48804, 46557, 45181, 44379, 30924, 28854, 24471, 21394, 17071, 15852, 14860))
Run Time: 0.084898
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 120 | 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: 2191, 0, 1715934450, {"thread-182604":["thread",182604],"thread-182503":["thread",182503],"thread-181761":["thread",181761],"thread-181473":["thread",181473],"thread-181437":["thread",181437],"thread-181201":["thread",181201],"thread-180931":["thread",180931],"thread-180805":["thread",180805],"thread-180467":["thread",180467],"thread-178829":["thread",178829],"thread-178583":["thread",178583],"thread-178292":["thread",178292],"thread-177854":["thread",177854],"thread-177675":["thread",177675],"thread-177521":["thread",177521],"thread-176305":["thread",176305],"thread-175535":["thread",175535],"thread-175527":["thread",175527],"thread-175519":["thread",175519],"thread-174814":["thread",174814],"thread-173006":["thread",173006],"thread-171790":["thread",171790],"thread-170510":["thread",170510],"thread-169437":["thread",169437],"thread-169221":["thread",169221],"thread-167919":["thread",167919],"thread-167899":["thread",167899],"thread-167789":["thread",167789],"thread-166498":["thread",166498],"thread-165862":["thread",165862],"thread-163746":["thread",163746],"thread-163399":["thread",163399],"thread-163007":["thread",163007],"thread-162940":["thread",162940],"thread-162897":["thread",162897],"thread-162705":["thread",162705],"thread-161715":["thread",161715],"thread-161558":["thread",161558],"thread-161080":["thread",161080],"thread-160843":["thread",160843],"thread-160828":["thread",160828],"thread-160583":["thread",160583],"thread-160311":["thread",160311],"thread-160068":["thread",160068],"thread-160065":["thread",160065],"thread-160056":["thread",160056],"thread-159375":["thread",159375],"thread-159374":["thread",159374],"thread-159306":["thread",159306],"thread-158908":["thread",158908],"thread-158571":["thread",158571],"thread-157127":["thread",157127],"thread-157109":["thread",157109],"thread-156960":["thread",156960],"thread-156249":["thread",156249],"thread-155946":["thread",155946],"thread-155658":["thread",155658],"thread-155652":["thread",155652],"thread-154605":["thread",154605],"thread-154027":["thread",154027],"thread-153537":["thread",153537],"thread-153450":["thread",153450],"thread-153237":["thread",153237],"thread-152992":["thread",152992],"thread-152268":["thread",152268],"thread-152231":["thread",152231],"thread-152190":["thread",152190],"thread-152015":["thread",152015],"thread-136958":["thread",136958],"thread-135807":["thread",135807],"thread-133700":["thread",133700],"thread-133030":["thread",133030],"thread-133026":["thread",133026],"thread-132136":["thread",132136],"thread-131175":["thread",131175],"thread-128774":["thread",128774],"thread-127056":["thread",127056],"thread-121673":["thread",121673],"thread-119105":["thread",119105],"thread-118980":["thread",118980],"thread-116748":["thread",116748],"thread-115516":["thread",115516],"thread-113068":["thread",113068],"thread-112219":["thread",112219],"thread-111697":["thread",111697],"thread-111013":["thread",111013],"thread-108855":["thread",108855],"thread-108373":["thread",108373],"thread-107053":["thread",107053],"thread-106583":["thread",106583],"thread-104170":["thread",104170],"thread-101865":["thread",101865],"thread-100866":["thread",100866],"thread-98648":["thread",98648],"thread-96569":["thread",96569],"thread-94905":["thread",94905],"thread-94775":["thread",94775],"thread-94437":["thread",94437],"thread-93649":["thread",93649],"thread-92217":["thread",92217],"thread-91855":["thread",91855],"thread-90906":["thread",90906],"thread-88925":["thread",88925],"thread-78613":["thread",78613],"thread-78420":["thread",78420],"thread-71151":["thread",71151],"thread-65690":["thread",65690],"thread-60197":["thread",60197],"thread-57243":["thread",57243],"thread-48804":["thread",48804],"thread-46557":["thread",46557],"thread-45181":["thread",45181],"thread-44379":["thread",44379],"thread-30924":["thread",30924],"thread-28854":["thread",28854],"thread-24471":["thread",24471],"thread-21394":["thread",21394],"thread-17071":["thread",17071],"thread-15852":["thread",15852],"thread-14860":["thread",14860]}, , 1715930850
Run Time: 0.000224
- 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