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 (126065, 125861, 125818, 125433, 125409, 124575, 124008, 122953, 122443, 121787, 121363, 121355, 121298, 121201, 119605, 118149, 117845, 115178, 115100, 114653, 114407, 114383, 114076, 112585, 112035, 111365, 111355, 111314, 111297, 111270, 111263, 111226, 111225, 111224, 111139, 110328, 110272, 110233, 110055, 109976, 109975, 109932, 109543, 109457, 109318, 109317, 109306, 109305, 109193, 109191, 109093, 108533, 108508, 108504, 108399, 108391, 108389, 108209, 108207, 108206, 108204, 108171, 108114, 108103, 108079, 108054, 108043, 108042, 107975, 107970, 107951, 107949, 107926, 12684, 11161))
Run Time: 0.033873
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 75 | 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: 1796, 0, 1716106186, {"thread-126065":["thread",126065],"thread-125861":["thread",125861],"thread-125818":["thread",125818],"thread-125433":["thread",125433],"thread-125409":["thread",125409],"thread-124575":["thread",124575],"thread-124008":["thread",124008],"thread-122953":["thread",122953],"thread-122443":["thread",122443],"thread-121787":["thread",121787],"thread-121363":["thread",121363],"thread-121355":["thread",121355],"thread-121298":["thread",121298],"thread-121201":["thread",121201],"thread-119605":["thread",119605],"thread-118149":["thread",118149],"thread-117845":["thread",117845],"thread-115178":["thread",115178],"thread-115100":["thread",115100],"thread-114653":["thread",114653],"thread-114407":["thread",114407],"thread-114383":["thread",114383],"thread-114076":["thread",114076],"thread-112585":["thread",112585],"thread-112035":["thread",112035],"thread-111365":["thread",111365],"thread-111355":["thread",111355],"thread-111314":["thread",111314],"thread-111297":["thread",111297],"thread-111270":["thread",111270],"thread-111263":["thread",111263],"thread-111226":["thread",111226],"thread-111225":["thread",111225],"thread-111224":["thread",111224],"thread-111139":["thread",111139],"thread-110328":["thread",110328],"thread-110272":["thread",110272],"thread-110233":["thread",110233],"thread-110055":["thread",110055],"thread-109976":["thread",109976],"thread-109975":["thread",109975],"thread-109932":["thread",109932],"thread-109543":["thread",109543],"thread-109457":["thread",109457],"thread-109318":["thread",109318],"thread-109317":["thread",109317],"thread-109306":["thread",109306],"thread-109305":["thread",109305],"thread-109193":["thread",109193],"thread-109191":["thread",109191],"thread-109093":["thread",109093],"thread-108533":["thread",108533],"thread-108508":["thread",108508],"thread-108504":["thread",108504],"thread-108399":["thread",108399],"thread-108391":["thread",108391],"thread-108389":["thread",108389],"thread-108209":["thread",108209],"thread-108207":["thread",108207],"thread-108206":["thread",108206],"thread-108204":["thread",108204],"thread-108171":["thread",108171],"thread-108114":["thread",108114],"thread-108103":["thread",108103],"thread-108079":["thread",108079],"thread-108054":["thread",108054],"thread-108043":["thread",108043],"thread-108042":["thread",108042],"thread-107975":["thread",107975],"thread-107970":["thread",107970],"thread-107951":["thread",107951],"thread-107949":["thread",107949],"thread-107926":["thread",107926],"thread-12684":["thread",12684],"thread-11161":["thread",11161]}, , 1716102586
Run Time: 0.000202
- 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