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 (182859, 182855, 182812, 182563, 182546, 182510, 182336, 182295, 182053, 181338, 181184, 181049, 181006, 180813, 180747, 180492, 180365, 180212, 180083, 179826, 179384, 179056, 178563, 178513, 177957, 177946, 177934, 177922, 177506, 176096, 175956, 175946, 175930, 175761, 175754, 175751, 175646, 175253, 175251, 175162, 175120, 175011, 175006, 174937, 174570, 174401, 174098, 174013, 174005, 173090, 172697, 172544, 172459, 172439, 171872, 171816, 171742, 171703, 171433, 171115, 171058, 171026, 170817, 170489, 170291, 170269, 169834, 169635, 169452, 169402, 169192, 169044, 168706, 168625, 168345, 168073, 168024, 167489, 167461, 167202, 167098, 167096, 167073, 166730, 165672, 163796, 161305, 156181, 154881, 151919, 127704, 116256, 112609, 104388, 86660, 86358, 85145, 84686, 82302, 81462, 80510, 80252))
Run Time: 0.053371
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 102 | 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: 16543, 0, 1714713642, {"thread-182859":["thread",182859],"thread-182855":["thread",182855],"thread-182812":["thread",182812],"thread-182563":["thread",182563],"thread-182546":["thread",182546],"thread-182510":["thread",182510],"thread-182336":["thread",182336],"thread-182295":["thread",182295],"thread-182053":["thread",182053],"thread-181338":["thread",181338],"thread-181184":["thread",181184],"thread-181049":["thread",181049],"thread-181006":["thread",181006],"thread-180813":["thread",180813],"thread-180747":["thread",180747],"thread-180492":["thread",180492],"ams_article-5228":["ams_article",5228],"thread-180365":["thread",180365],"thread-180212":["thread",180212],"thread-180083":["thread",180083],"thread-179826":["thread",179826],"thread-179384":["thread",179384],"thread-179056":["thread",179056],"thread-178563":["thread",178563],"thread-178513":["thread",178513],"thread-177957":["thread",177957],"thread-177946":["thread",177946],"thread-177934":["thread",177934],"thread-177922":["thread",177922],"thread-177506":["thread",177506],"thread-176096":["thread",176096],"thread-175956":["thread",175956],"thread-175946":["thread",175946],"thread-175930":["thread",175930],"ams_article-5087":["ams_article",5087],"thread-175761":["thread",175761],"thread-175754":["thread",175754],"thread-175751":["thread",175751],"thread-175646":["thread",175646],"thread-175253":["thread",175253],"thread-175251":["thread",175251],"thread-175162":["thread",175162],"thread-175120":["thread",175120],"thread-175011":["thread",175011],"thread-175006":["thread",175006],"thread-174937":["thread",174937],"thread-174570":["thread",174570],"thread-174401":["thread",174401],"thread-174098":["thread",174098],"thread-174013":["thread",174013],"thread-174005":["thread",174005],"thread-173090":["thread",173090],"thread-172697":["thread",172697],"thread-172544":["thread",172544],"thread-172459":["thread",172459],"thread-172439":["thread",172439],"thread-171872":["thread",171872],"thread-171816":["thread",171816],"thread-171742":["thread",171742],"thread-171703":["thread",171703],"thread-171433":["thread",171433],"ams_article-4865":["ams_article",4865],"ams_article-4864":["ams_article",4864],"thread-171115":["thread",171115],"thread-171058":["thread",171058],"thread-171026":["thread",171026],"thread-170817":["thread",170817],"thread-170489":["thread",170489],"thread-170291":["thread",170291],"thread-170269":["thread",170269],"thread-169834":["thread",169834],"thread-169635":["thread",169635],"thread-169452":["thread",169452],"thread-169402":["thread",169402],"thread-169192":["thread",169192],"thread-169044":["thread",169044],"ams_article-4782":["ams_article",4782],"thread-168706":["thread",168706],"thread-168625":["thread",168625],"thread-168345":["thread",168345],"ams_article-4762":["ams_article",4762],"thread-168073":["thread",168073],"thread-168024":["thread",168024],"ams_article-4756":["ams_article",4756],"ams_article-4744":["ams_article",4744],"thread-167489":["thread",167489],"thread-167461":["thread",167461],"thread-167202":["thread",167202],"thread-167098":["thread",167098],"thread-167096":["thread",167096],"thread-167073":["thread",167073],"thread-166730":["thread",166730],"thread-165672":["thread",165672],"thread-163796":["thread",163796],"thread-161305":["thread",161305],"thread-156181":["thread",156181],"thread-154881":["thread",154881],"tl_group-107":["tl_group",107],"thread-151919":["thread",151919],"tl_group-12":["tl_group",12],"thread-127704":["thread",127704],"thread-116256":["thread",116256],"thread-112609":["thread",112609],"thread-104388":["thread",104388],"thread-86660":["thread",86660],"thread-86358":["thread",86358],"thread-85145":["thread",85145],"thread-84686":["thread",84686],"thread-82302":["thread",82302],"thread-81462":["thread",81462],"thread-80510":["thread",80510],"thread-80252":["thread",80252]}, , 1714710042
Run Time: 0.000725
- 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