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 (182810, 176032, 171229, 169156, 168960, 168109, 167459, 163438, 162951, 162900, 162277, 160910, 159264, 156905, 156896, 156895, 156894, 154694, 152128, 151834, 150153, 149682, 149374, 149263, 149217, 148855, 148851, 147178, 146225, 146221, 143449, 143206, 142526, 141649, 141648, 141647, 141646, 141645, 139085, 139063, 138990, 138985, 138602, 138422, 137750, 136588, 136585, 132808, 129613, 124623, 124620))
Run Time: 0.023480
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 51 | 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: 30982, 0, 1716633746, {"thread-182810":["thread",182810],"ams_article-5282":["ams_article",5282],"ams_article-5279":["ams_article",5279],"ams_article-5163":["ams_article",5163],"ams_article-5162":["ams_article",5162],"thread-176032":["thread",176032],"ams_article-4901":["ams_article",4901],"thread-171229":["thread",171229],"thread-169156":["thread",169156],"thread-168960":["thread",168960],"ams_article-4790":["ams_article",4790],"ams_article-4783":["ams_article",4783],"thread-168109":["thread",168109],"ams_article-4753":["ams_article",4753],"thread-167459":["thread",167459],"ams_article-4618":["ams_article",4618],"ams_article-4617":["ams_article",4617],"ams_article-4616":["ams_article",4616],"ams_article-4548":["ams_article",4548],"ams_article-4537":["ams_article",4537],"thread-163438":["thread",163438],"ams_article-4521":["ams_article",4521],"thread-162951":["thread",162951],"thread-162900":["thread",162900],"thread-162277":["thread",162277],"ams_article-4449":["ams_article",4449],"thread-160910":["thread",160910],"thread-159264":["thread",159264],"thread-156905":["thread",156905],"thread-156896":["thread",156896],"thread-156895":["thread",156895],"thread-156894":["thread",156894],"ams_article-4157":["ams_article",4157],"thread-154694":["thread",154694],"ams_article-4095":["ams_article",4095],"ams_article-4000":["ams_article",4000],"ams_article-3952":["ams_article",3952],"thread-152128":["thread",152128],"thread-151834":["thread",151834],"thread-150153":["thread",150153],"thread-149682":["thread",149682],"ams_article-3763":["ams_article",3763],"thread-149374":["thread",149374],"thread-149263":["thread",149263],"thread-149217":["thread",149217],"thread-148855":["thread",148855],"thread-148851":["thread",148851],"ams_article-3650":["ams_article",3650],"ams_article-3636":["ams_article",3636],"ams_article-3618":["ams_article",3618],"thread-147178":["thread",147178],"ams_article-3578":["ams_article",3578],"ams_article-3550":["ams_article",3550],"ams_article-3523":["ams_article",3523],"ams_article-3518":["ams_article",3518],"ams_article-3514":["ams_article",3514],"ams_article-3508":["ams_article",3508],"thread-146225":["thread",146225],"thread-146221":["thread",146221],"thread-143449":["thread",143449],"thread-143206":["thread",143206],"thread-142526":["thread",142526],"thread-141649":["thread",141649],"thread-141648":["thread",141648],"thread-141647":["thread",141647],"thread-141646":["thread",141646],"thread-141645":["thread",141645],"ams_article-3193":["ams_article",3193],"ams_article-3146":["ams_article",3146],"thread-139085":["thread",139085],"thread-139063":["thread",139063],"thread-138990":["thread",138990],"thread-138985":["thread",138985],"thread-138602":["thread",138602],"thread-138422":["thread",138422],"thread-137750":["thread",137750],"thread-136588":["thread",136588],"thread-136585":["thread",136585],"thread-132808":["thread",132808],"thread-129613":["thread",129613],"thread-124623":["thread",124623],"thread-124620":["thread",124620]}, , 1716630146
Run Time: 0.000714
- 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