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 (178901, 170698, 167189, 155078, 155070, 155054, 155050, 155048, 155020, 154968, 154961, 154945, 154944, 154930, 154922, 154920, 154914, 154894, 154842, 154834, 154827, 154826, 154784, 154744, 154743, 154737, 154728, 154716, 154702, 154670, 154668, 154627, 154626, 154613, 154584, 154533, 154502, 154501, 154484, 154428, 154408, 154386, 154342, 154309, 154305, 154282, 154245, 154233, 154224, 154216, 154215, 154204, 154147, 154145, 154114, 154110, 154103, 154095, 154080, 154068, 154060, 154035, 154018, 153999, 153975, 153963, 153945, 153941, 153935, 153934, 153869, 153844, 153842, 153828, 153793, 153787, 153770, 153767, 153724, 153720, 153711, 153710, 153610, 153603, 153573, 153570, 153527, 153526, 153521, 153493, 153473, 153407, 153406, 153362, 153342, 153313, 153312, 153305, 153292, 153262, 153221, 153205, 153187, 153163, 153161, 153136, 153135, 153126, 153107, 153096, 153076, 153062, 153061, 153012, 152987, 152931, 152917, 152915, 152886, 152884, 152858, 152850, 152795, 152702, 152683, 152645, 152643, 152639, 152611, 152587, 152490, 152481, 152473, 152455, 152451, 152428, 152405, 152355, 152353, 152351, 152337, 152332, 152286, 152237, 152148, 152128, 152119, 152113, 151982, 151964, 151940, 151938, 151920, 151919, 151918, 151912, 151836, 151781, 151763, 151761, 151758, 151708, 151694, 121795, 121257, 112707, 100906, 94034, 87344, 85618, 80012, 80011, 79671, 77922, 77833, 70803, 62486, 49802, 37486))
Run Time: 0.081909
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 179 | 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: 5319, 0, 1715921977, {"thread-178901":["thread",178901],"thread-170698":["thread",170698],"thread-167189":["thread",167189],"thread-155078":["thread",155078],"thread-155070":["thread",155070],"thread-155054":["thread",155054],"thread-155050":["thread",155050],"thread-155048":["thread",155048],"thread-155020":["thread",155020],"thread-154968":["thread",154968],"thread-154961":["thread",154961],"thread-154945":["thread",154945],"thread-154944":["thread",154944],"thread-154930":["thread",154930],"thread-154922":["thread",154922],"thread-154920":["thread",154920],"thread-154914":["thread",154914],"thread-154894":["thread",154894],"thread-154842":["thread",154842],"thread-154834":["thread",154834],"thread-154827":["thread",154827],"thread-154826":["thread",154826],"thread-154784":["thread",154784],"thread-154744":["thread",154744],"thread-154743":["thread",154743],"thread-154737":["thread",154737],"thread-154728":["thread",154728],"thread-154716":["thread",154716],"thread-154702":["thread",154702],"thread-154670":["thread",154670],"thread-154668":["thread",154668],"thread-154627":["thread",154627],"thread-154626":["thread",154626],"thread-154613":["thread",154613],"thread-154584":["thread",154584],"thread-154533":["thread",154533],"thread-154502":["thread",154502],"thread-154501":["thread",154501],"thread-154484":["thread",154484],"thread-154428":["thread",154428],"thread-154408":["thread",154408],"thread-154386":["thread",154386],"thread-154342":["thread",154342],"thread-154309":["thread",154309],"thread-154305":["thread",154305],"thread-154282":["thread",154282],"thread-154245":["thread",154245],"thread-154233":["thread",154233],"thread-154224":["thread",154224],"thread-154216":["thread",154216],"thread-154215":["thread",154215],"thread-154204":["thread",154204],"thread-154147":["thread",154147],"thread-154145":["thread",154145],"thread-154114":["thread",154114],"thread-154110":["thread",154110],"thread-154103":["thread",154103],"thread-154095":["thread",154095],"thread-154080":["thread",154080],"thread-154068":["thread",154068],"thread-154060":["thread",154060],"thread-154035":["thread",154035],"thread-154018":["thread",154018],"thread-153999":["thread",153999],"thread-153975":["thread",153975],"thread-153963":["thread",153963],"thread-153945":["thread",153945],"thread-153941":["thread",153941],"thread-153935":["thread",153935],"thread-153934":["thread",153934],"thread-153869":["thread",153869],"thread-153844":["thread",153844],"thread-153842":["thread",153842],"thread-153828":["thread",153828],"thread-153793":["thread",153793],"thread-153787":["thread",153787],"thread-153770":["thread",153770],"thread-153767":["thread",153767],"thread-153724":["thread",153724],"thread-153720":["thread",153720],"thread-153711":["thread",153711],"thread-153710":["thread",153710],"thread-153610":["thread",153610],"thread-153603":["thread",153603],"thread-153573":["thread",153573],"thread-153570":["thread",153570],"thread-153527":["thread",153527],"thread-153526":["thread",153526],"thread-153521":["thread",153521],"thread-153493":["thread",153493],"thread-153473":["thread",153473],"thread-153407":["thread",153407],"thread-153406":["thread",153406],"thread-153362":["thread",153362],"thread-153342":["thread",153342],"thread-153313":["thread",153313],"thread-153312":["thread",153312],"thread-153305":["thread",153305],"thread-153292":["thread",153292],"thread-153262":["thread",153262],"thread-153221":["thread",153221],"thread-153205":["thread",153205],"thread-153187":["thread",153187],"thread-153163":["thread",153163],"thread-153161":["thread",153161],"thread-153136":["thread",153136],"thread-153135":["thread",153135],"thread-153126":["thread",153126],"thread-153107":["thread",153107],"thread-153096":["thread",153096],"thread-153076":["thread",153076],"thread-153062":["thread",153062],"thread-153061":["thread",153061],"thread-153012":["thread",153012],"thread-152987":["thread",152987],"thread-152931":["thread",152931],"thread-152917":["thread",152917],"thread-152915":["thread",152915],"thread-152886":["thread",152886],"thread-152884":["thread",152884],"thread-152858":["thread",152858],"thread-152850":["thread",152850],"thread-152795":["thread",152795],"thread-152702":["thread",152702],"thread-152683":["thread",152683],"thread-152645":["thread",152645],"thread-152643":["thread",152643],"thread-152639":["thread",152639],"thread-152611":["thread",152611],"thread-152587":["thread",152587],"thread-152490":["thread",152490],"thread-152481":["thread",152481],"thread-152473":["thread",152473],"thread-152455":["thread",152455],"thread-152451":["thread",152451],"thread-152428":["thread",152428],"thread-152405":["thread",152405],"thread-152355":["thread",152355],"thread-152353":["thread",152353],"thread-152351":["thread",152351],"thread-152337":["thread",152337],"thread-152332":["thread",152332],"thread-152286":["thread",152286],"thread-152237":["thread",152237],"thread-152148":["thread",152148],"thread-152128":["thread",152128],"thread-152119":["thread",152119],"thread-152113":["thread",152113],"thread-151982":["thread",151982],"thread-151964":["thread",151964],"thread-151940":["thread",151940],"thread-151938":["thread",151938],"thread-151920":["thread",151920],"thread-151919":["thread",151919],"thread-151918":["thread",151918],"thread-151912":["thread",151912],"thread-151836":["thread",151836],"thread-151781":["thread",151781],"thread-151763":["thread",151763],"thread-151761":["thread",151761],"thread-151758":["thread",151758],"thread-151708":["thread",151708],"thread-151694":["thread",151694],"thread-121795":["thread",121795],"thread-121257":["thread",121257],"thread-112707":["thread",112707],"thread-100906":["thread",100906],"thread-94034":["thread",94034],"thread-87344":["thread",87344],"thread-85618":["thread",85618],"thread-80012":["thread",80012],"thread-80011":["thread",80011],"thread-79671":["thread",79671],"thread-77922":["thread",77922],"thread-77833":["thread",77833],"thread-70803":["thread",70803],"thread-62486":["thread",62486],"thread-49802":["thread",49802],"thread-37486":["thread",37486]}, , 1715918377
Run Time: 0.001100
- 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