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 (182193, 178064, 177373, 173027, 172947, 171866, 170277, 168537, 161824, 159641, 157832, 156685, 155452, 153208, 139695, 139616, 137292, 136630, 133125, 133124, 133100, 132667, 132522, 132500, 132399, 130477, 130363, 130188, 130158, 129946, 125314, 125271, 125255, 120925, 120042, 119767, 117668, 109896, 108389, 105791, 105755, 102835, 95563, 94813, 85883, 85754, 81562, 81065, 80169, 73947, 73938, 72657, 72560, 72547, 72488, 71342, 70897, 70523, 70354, 69238, 68191, 68035, 67884, 66995, 66417, 66345, 65675, 65674, 62687, 61942, 61185, 60869, 58410, 57795, 53901, 50508, 48355, 48217, 45739, 42925, 42449, 41786, 41221, 39521, 39300, 38852, 38310, 38190, 37655, 36510, 35745, 35634, 34805, 34686, 34663, 34510, 31560, 26076, 24071, 16598, 2976, 2487))
Run Time: 0.056045
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: 655, 0, 1716123435, {"thread-182193":["thread",182193],"ams_article-5266":["ams_article",5266],"thread-178064":["thread",178064],"thread-177373":["thread",177373],"thread-173027":["thread",173027],"thread-172947":["thread",172947],"thread-171866":["thread",171866],"thread-170277":["thread",170277],"thread-168537":["thread",168537],"thread-161824":["thread",161824],"ams_article-4412":["ams_article",4412],"thread-159641":["thread",159641],"ams_article-4342":["ams_article",4342],"thread-157832":["thread",157832],"ams_article-4269":["ams_article",4269],"thread-156685":["thread",156685],"thread-155452":["thread",155452],"ams_article-4027":["ams_article",4027],"ams_article-4015":["ams_article",4015],"thread-153208":["thread",153208],"ams_article-3599":["ams_article",3599],"thread-139695":["thread",139695],"thread-139616":["thread",139616],"thread-137292":["thread",137292],"thread-136630":["thread",136630],"thread-133125":["thread",133125],"thread-133124":["thread",133124],"thread-133100":["thread",133100],"thread-132667":["thread",132667],"thread-132522":["thread",132522],"thread-132500":["thread",132500],"thread-132399":["thread",132399],"thread-130477":["thread",130477],"thread-130363":["thread",130363],"thread-130188":["thread",130188],"thread-130158":["thread",130158],"thread-129946":["thread",129946],"thread-125314":["thread",125314],"thread-125271":["thread",125271],"thread-125255":["thread",125255],"thread-120925":["thread",120925],"thread-120042":["thread",120042],"thread-119767":["thread",119767],"thread-117668":["thread",117668],"thread-109896":["thread",109896],"thread-108389":["thread",108389],"thread-105791":["thread",105791],"thread-105755":["thread",105755],"thread-102835":["thread",102835],"thread-95563":["thread",95563],"thread-94813":["thread",94813],"thread-85883":["thread",85883],"thread-85754":["thread",85754],"thread-81562":["thread",81562],"thread-81065":["thread",81065],"thread-80169":["thread",80169],"thread-73947":["thread",73947],"thread-73938":["thread",73938],"thread-72657":["thread",72657],"thread-72560":["thread",72560],"thread-72547":["thread",72547],"thread-72488":["thread",72488],"thread-71342":["thread",71342],"thread-70897":["thread",70897],"thread-70523":["thread",70523],"thread-70354":["thread",70354],"thread-69238":["thread",69238],"thread-68191":["thread",68191],"thread-68035":["thread",68035],"thread-67884":["thread",67884],"thread-66995":["thread",66995],"thread-66417":["thread",66417],"thread-66345":["thread",66345],"thread-65675":["thread",65675],"thread-65674":["thread",65674],"thread-62687":["thread",62687],"thread-61942":["thread",61942],"thread-61185":["thread",61185],"thread-60869":["thread",60869],"thread-58410":["thread",58410],"thread-57795":["thread",57795],"thread-53901":["thread",53901],"thread-50508":["thread",50508],"thread-48355":["thread",48355],"thread-48217":["thread",48217],"thread-45739":["thread",45739],"thread-42925":["thread",42925],"thread-42449":["thread",42449],"thread-41786":["thread",41786],"thread-41221":["thread",41221],"thread-39521":["thread",39521],"thread-39300":["thread",39300],"thread-38852":["thread",38852],"thread-38310":["thread",38310],"thread-38190":["thread",38190],"thread-37655":["thread",37655],"thread-36510":["thread",36510],"thread-35745":["thread",35745],"thread-35634":["thread",35634],"thread-34805":["thread",34805],"thread-34686":["thread",34686],"thread-34663":["thread",34663],"thread-34510":["thread",34510],"thread-31560":["thread",31560],"thread-26076":["thread",26076],"thread-24071":["thread",24071],"thread-16598":["thread",16598],"thread-2976":["thread",2976],"thread-2487":["thread",2487]}, , 1716119835
Run Time: 0.000367
- 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