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 (182019, 182005, 181922, 180691, 180460, 180430, 180316, 180311, 176308, 164410, 161640, 161262, 156413, 156128, 135094, 122662, 122093, 121914, 121674, 119990, 116405, 97030, 93134, 81682, 81560, 81474, 81472, 81247, 81246, 81166, 81108, 81073, 81072, 81061, 80989, 80850, 80778, 80639, 79890, 79868, 79747, 79705, 79673, 79579, 79577, 79576, 79575, 79422, 73597, 71462, 69795, 68124, 67759, 67588, 61844, 61466, 61036, 61008, 60934, 60714, 60676, 60640, 60635, 59356, 59139, 59134, 59132, 59131, 59130, 58547, 57050, 56240, 56225, 55961, 55938, 55937, 55500, 54900, 54496, 54132, 53958, 53696, 53611, 53468, 53142, 52617, 52616, 52481, 52405, 52359, 52357, 52345, 52269, 52264, 52258, 51892, 51854, 51456, 51059, 51058, 51011, 50508, 50496, 50363, 50216, 50024, 50021, 49856, 49792, 49772, 49753, 49752, 49747, 49582, 49190, 49047, 49046, 49001, 48751, 48681, 48670, 48629, 48620, 48263, 48213, 48188, 48175, 48173, 48136, 48043, 47829, 47701, 47624, 47551, 47517, 47454, 47453, 47373, 47292, 47123, 47122, 47117, 47039, 46832, 46782, 46781, 46757, 46751, 46740, 46679, 46645, 46623, 46620, 46554, 46491, 46364, 46250, 46239, 46154, 46117, 45829, 45687, 45531, 45164, 45088, 44973, 44758, 44699, 44683, 44579, 44519, 44153, 44039, 44038, 43913, 24797, 16703, 16511, 16464, 15877, 10860, 10623, 10587, 10541, 10429, 10276, 3540, 3432, 2252, 1961))
Run Time: 0.110996
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 190 | 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: 544, 0, 1716097312, {"thread-182019":["thread",182019],"thread-182005":["thread",182005],"thread-181922":["thread",181922],"thread-180691":["thread",180691],"thread-180460":["thread",180460],"thread-180430":["thread",180430],"thread-180316":["thread",180316],"thread-180311":["thread",180311],"ams_article-5225":["ams_article",5225],"thread-176308":["thread",176308],"ams_article-4944":["ams_article",4944],"thread-164410":["thread",164410],"thread-161640":["thread",161640],"thread-161262":["thread",161262],"thread-156413":["thread",156413],"thread-156128":["thread",156128],"thread-135094":["thread",135094],"thread-122662":["thread",122662],"thread-122093":["thread",122093],"thread-121914":["thread",121914],"thread-121674":["thread",121674],"thread-119990":["thread",119990],"thread-116405":["thread",116405],"thread-97030":["thread",97030],"thread-93134":["thread",93134],"thread-81682":["thread",81682],"thread-81560":["thread",81560],"thread-81474":["thread",81474],"thread-81472":["thread",81472],"thread-81247":["thread",81247],"thread-81246":["thread",81246],"thread-81166":["thread",81166],"thread-81108":["thread",81108],"thread-81073":["thread",81073],"thread-81072":["thread",81072],"thread-81061":["thread",81061],"thread-80989":["thread",80989],"thread-80850":["thread",80850],"thread-80778":["thread",80778],"thread-80639":["thread",80639],"thread-79890":["thread",79890],"thread-79868":["thread",79868],"thread-79747":["thread",79747],"thread-79705":["thread",79705],"thread-79673":["thread",79673],"thread-79579":["thread",79579],"thread-79577":["thread",79577],"thread-79576":["thread",79576],"thread-79575":["thread",79575],"thread-79422":["thread",79422],"thread-73597":["thread",73597],"thread-71462":["thread",71462],"thread-69795":["thread",69795],"thread-68124":["thread",68124],"thread-67759":["thread",67759],"thread-67588":["thread",67588],"thread-61844":["thread",61844],"thread-61466":["thread",61466],"thread-61036":["thread",61036],"thread-61008":["thread",61008],"thread-60934":["thread",60934],"thread-60714":["thread",60714],"thread-60676":["thread",60676],"thread-60640":["thread",60640],"thread-60635":["thread",60635],"thread-59356":["thread",59356],"thread-59139":["thread",59139],"thread-59134":["thread",59134],"thread-59132":["thread",59132],"thread-59131":["thread",59131],"thread-59130":["thread",59130],"thread-58547":["thread",58547],"thread-56240":["thread",56240],"thread-56225":["thread",56225],"thread-55961":["thread",55961],"thread-55938":["thread",55938],"thread-55937":["thread",55937],"thread-55500":["thread",55500],"thread-54900":["thread",54900],"thread-54496":["thread",54496],"thread-54132":["thread",54132],"thread-53958":["thread",53958],"thread-53696":["thread",53696],"thread-53611":["thread",53611],"thread-53468":["thread",53468],"thread-53142":["thread",53142],"thread-52617":["thread",52617],"thread-52616":["thread",52616],"thread-52481":["thread",52481],"thread-52405":["thread",52405],"thread-52359":["thread",52359],"thread-52357":["thread",52357],"thread-52345":["thread",52345],"thread-52269":["thread",52269],"thread-52264":["thread",52264],"thread-52258":["thread",52258],"thread-51892":["thread",51892],"thread-51854":["thread",51854],"thread-51456":["thread",51456],"thread-51059":["thread",51059],"thread-51058":["thread",51058],"thread-51011":["thread",51011],"thread-50508":["thread",50508],"thread-50496":["thread",50496],"thread-50363":["thread",50363],"thread-50216":["thread",50216],"thread-50024":["thread",50024],"thread-50021":["thread",50021],"thread-49856":["thread",49856],"thread-49792":["thread",49792],"thread-49772":["thread",49772],"thread-49753":["thread",49753],"thread-49752":["thread",49752],"thread-49747":["thread",49747],"thread-49582":["thread",49582],"thread-49190":["thread",49190],"thread-49047":["thread",49047],"thread-49046":["thread",49046],"thread-49001":["thread",49001],"thread-48751":["thread",48751],"thread-48681":["thread",48681],"thread-48670":["thread",48670],"thread-48629":["thread",48629],"thread-48620":["thread",48620],"thread-48263":["thread",48263],"thread-48213":["thread",48213],"thread-48188":["thread",48188],"thread-48175":["thread",48175],"thread-48173":["thread",48173],"thread-48136":["thread",48136],"thread-48043":["thread",48043],"thread-47829":["thread",47829],"thread-47701":["thread",47701],"thread-47624":["thread",47624],"thread-47551":["thread",47551],"thread-47517":["thread",47517],"thread-47454":["thread",47454],"thread-47453":["thread",47453],"thread-47373":["thread",47373],"thread-47292":["thread",47292],"thread-47123":["thread",47123],"thread-47122":["thread",47122],"thread-47117":["thread",47117],"thread-47039":["thread",47039],"thread-46832":["thread",46832],"thread-46782":["thread",46782],"thread-46781":["thread",46781],"thread-46757":["thread",46757],"thread-46751":["thread",46751],"thread-46740":["thread",46740],"thread-46679":["thread",46679],"thread-46645":["thread",46645],"thread-46623":["thread",46623],"thread-46620":["thread",46620],"thread-46554":["thread",46554],"thread-46491":["thread",46491],"thread-46364":["thread",46364],"thread-46250":["thread",46250],"thread-46239":["thread",46239],"thread-46154":["thread",46154],"thread-46117":["thread",46117],"thread-45829":["thread",45829],"thread-45687":["thread",45687],"thread-45531":["thread",45531],"thread-45164":["thread",45164],"thread-45088":["thread",45088],"thread-44973":["thread",44973],"thread-44758":["thread",44758],"thread-44699":["thread",44699],"thread-44683":["thread",44683],"thread-44579":["thread",44579],"thread-44519":["thread",44519],"thread-44153":["thread",44153],"thread-44039":["thread",44039],"thread-44038":["thread",44038],"thread-43913":["thread",43913],"thread-24797":["thread",24797],"thread-16703":["thread",16703],"thread-16511":["thread",16511],"thread-16464":["thread",16464],"thread-15877":["thread",15877],"thread-10860":["thread",10860],"thread-10623":["thread",10623],"thread-10587":["thread",10587],"thread-10541":["thread",10541],"thread-10429":["thread",10429],"thread-10276":["thread",10276],"thread-3540":["thread",3540],"thread-3432":["thread",3432],"thread-2252":["thread",2252],"thread-1961":["thread",1961]}, , 1716093712
Run Time: 0.000166
- 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