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 (178723, 177904, 173295, 172927, 167112, 165371, 132005, 131107, 131064, 130351, 129985, 129746, 124930, 124274, 124202, 124059, 123641, 122397, 121261, 111223, 109845, 104699, 104510, 102390, 102239, 101400, 100085, 95485, 92201, 90667, 89987, 89426, 89136, 85915, 85620, 83838, 83791, 83698, 82690, 82535, 81851, 81720, 81470, 81284, 80612, 80035, 79667, 79666, 79635, 79549, 79497, 78335, 78199, 78075, 77703, 77424, 76922, 76812, 76621, 76620, 76430, 76340, 75895, 75676, 74480, 73963, 73612, 73347, 72886, 72473, 72169, 71917, 71843, 71835, 71780, 71157, 70888, 70834, 70769, 70743, 70732, 70507, 70334, 70081, 69450, 69280, 69044, 68674, 68488, 68192, 67935, 67471, 67384, 67155, 67066, 67010, 66987, 66975, 66919, 66916, 66883, 66852, 66724, 66541, 65981, 65445, 65384, 65362, 65035, 65030, 64869, 64691, 64564, 64472, 64405, 63924, 63708, 63273, 63016, 62845, 62477, 62136, 62042, 61790, 61764, 61484, 61183, 60992, 60984, 60948, 60863, 60796, 60771, 60756, 60461, 60445, 60099, 60082, 59665, 59621, 59555, 59528, 59268, 59070, 59065, 59012, 58748, 58703, 58678, 58032, 57963, 57953, 57910, 57895, 57514, 57495, 56931, 56895, 56837, 56813, 56628, 56226, 56138, 56072, 55859, 55777, 54769, 54654, 54106, 53990, 53494, 51885, 51562, 51469, 51422, 50868, 50858, 50856, 50855, 50493, 49730, 49416, 49288, 49100, 48914, 48854, 48686, 47884, 47324, 47164, 47084, 46953, 46609, 46529, 46447, 45772, 45728, 45589))
Run Time: 0.079066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 198 | 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: 44, 0, 1726880266, {"thread-178723":["thread",178723],"thread-177904":["thread",177904],"thread-173295":["thread",173295],"thread-172927":["thread",172927],"thread-167112":["thread",167112],"thread-165371":["thread",165371],"ams_article-3971":["ams_article",3971],"thread-132005":["thread",132005],"thread-131107":["thread",131107],"thread-131064":["thread",131064],"thread-130351":["thread",130351],"thread-129985":["thread",129985],"thread-129746":["thread",129746],"thread-124930":["thread",124930],"thread-124274":["thread",124274],"thread-124202":["thread",124202],"thread-124059":["thread",124059],"thread-123641":["thread",123641],"thread-122397":["thread",122397],"thread-121261":["thread",121261],"thread-111223":["thread",111223],"thread-109845":["thread",109845],"thread-104699":["thread",104699],"thread-104510":["thread",104510],"thread-102390":["thread",102390],"thread-102239":["thread",102239],"thread-101400":["thread",101400],"thread-100085":["thread",100085],"thread-95485":["thread",95485],"thread-92201":["thread",92201],"thread-90667":["thread",90667],"thread-89987":["thread",89987],"thread-89426":["thread",89426],"thread-89136":["thread",89136],"thread-85915":["thread",85915],"thread-85620":["thread",85620],"thread-83838":["thread",83838],"thread-83791":["thread",83791],"thread-83698":["thread",83698],"thread-82690":["thread",82690],"thread-82535":["thread",82535],"thread-81851":["thread",81851],"thread-81720":["thread",81720],"thread-81470":["thread",81470],"thread-81284":["thread",81284],"thread-80612":["thread",80612],"thread-80035":["thread",80035],"thread-79667":["thread",79667],"thread-79666":["thread",79666],"thread-79635":["thread",79635],"thread-79549":["thread",79549],"thread-79497":["thread",79497],"thread-78335":["thread",78335],"thread-78199":["thread",78199],"thread-78075":["thread",78075],"thread-77703":["thread",77703],"thread-77424":["thread",77424],"thread-76922":["thread",76922],"thread-76812":["thread",76812],"thread-76621":["thread",76621],"thread-76620":["thread",76620],"thread-76430":["thread",76430],"thread-76340":["thread",76340],"thread-75895":["thread",75895],"thread-75676":["thread",75676],"thread-74480":["thread",74480],"thread-73963":["thread",73963],"thread-73612":["thread",73612],"thread-73347":["thread",73347],"thread-72886":["thread",72886],"thread-72473":["thread",72473],"thread-72169":["thread",72169],"thread-71917":["thread",71917],"thread-71843":["thread",71843],"thread-71835":["thread",71835],"thread-71780":["thread",71780],"thread-71157":["thread",71157],"thread-70888":["thread",70888],"thread-70834":["thread",70834],"thread-70769":["thread",70769],"thread-70743":["thread",70743],"thread-70732":["thread",70732],"thread-70507":["thread",70507],"thread-70334":["thread",70334],"thread-70081":["thread",70081],"thread-69450":["thread",69450],"thread-69280":["thread",69280],"thread-69044":["thread",69044],"thread-68674":["thread",68674],"thread-68488":["thread",68488],"thread-68192":["thread",68192],"thread-67935":["thread",67935],"thread-67471":["thread",67471],"thread-67384":["thread",67384],"thread-67155":["thread",67155],"thread-67066":["thread",67066],"thread-67010":["thread",67010],"thread-66987":["thread",66987],"thread-66975":["thread",66975],"thread-66919":["thread",66919],"thread-66916":["thread",66916],"thread-66883":["thread",66883],"thread-66852":["thread",66852],"thread-66724":["thread",66724],"thread-66541":["thread",66541],"thread-65981":["thread",65981],"thread-65445":["thread",65445],"thread-65384":["thread",65384],"thread-65362":["thread",65362],"thread-65035":["thread",65035],"thread-65030":["thread",65030],"thread-64869":["thread",64869],"thread-64691":["thread",64691],"thread-64564":["thread",64564],"thread-64472":["thread",64472],"thread-64405":["thread",64405],"thread-63924":["thread",63924],"thread-63708":["thread",63708],"thread-63273":["thread",63273],"thread-63016":["thread",63016],"thread-62845":["thread",62845],"thread-62477":["thread",62477],"thread-62136":["thread",62136],"thread-62042":["thread",62042],"thread-61790":["thread",61790],"thread-61764":["thread",61764],"thread-61484":["thread",61484],"thread-61183":["thread",61183],"thread-60992":["thread",60992],"thread-60984":["thread",60984],"thread-60948":["thread",60948],"thread-60863":["thread",60863],"thread-60796":["thread",60796],"thread-60771":["thread",60771],"thread-60756":["thread",60756],"thread-60461":["thread",60461],"thread-60445":["thread",60445],"thread-60099":["thread",60099],"thread-60082":["thread",60082],"thread-59665":["thread",59665],"thread-59621":["thread",59621],"thread-59555":["thread",59555],"thread-59528":["thread",59528],"thread-59268":["thread",59268],"thread-59070":["thread",59070],"thread-59065":["thread",59065],"thread-59012":["thread",59012],"thread-58748":["thread",58748],"thread-58703":["thread",58703],"thread-58678":["thread",58678],"thread-58032":["thread",58032],"thread-57963":["thread",57963],"thread-57953":["thread",57953],"thread-57910":["thread",57910],"thread-57895":["thread",57895],"thread-57514":["thread",57514],"thread-57495":["thread",57495],"thread-56931":["thread",56931],"thread-56895":["thread",56895],"thread-56837":["thread",56837],"thread-56813":["thread",56813],"thread-56628":["thread",56628],"thread-56226":["thread",56226],"thread-56138":["thread",56138],"thread-56072":["thread",56072],"thread-55859":["thread",55859],"thread-55777":["thread",55777],"thread-54769":["thread",54769],"thread-54654":["thread",54654],"thread-54106":["thread",54106],"thread-53990":["thread",53990],"thread-53494":["thread",53494],"thread-51885":["thread",51885],"thread-51562":["thread",51562],"thread-51469":["thread",51469],"thread-51422":["thread",51422],"thread-50868":["thread",50868],"thread-50858":["thread",50858],"thread-50856":["thread",50856],"thread-50855":["thread",50855],"thread-50493":["thread",50493],"thread-49730":["thread",49730],"thread-49416":["thread",49416],"thread-49288":["thread",49288],"thread-49100":["thread",49100],"thread-48914":["thread",48914],"thread-48854":["thread",48854],"thread-48686":["thread",48686],"thread-47884":["thread",47884],"thread-47324":["thread",47324],"thread-47164":["thread",47164],"thread-47084":["thread",47084],"thread-46953":["thread",46953],"thread-46609":["thread",46609],"thread-46529":["thread",46529],"thread-46447":["thread",46447],"thread-45772":["thread",45772],"thread-45728":["thread",45728],"thread-45589":["thread",45589]}, , 1726876666
Run Time: 0.000183
- 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