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 (177362, 170589, 169702, 166038, 162530, 162045, 161939, 161588, 161161, 160617, 160297, 160296, 152458, 132172, 132120, 129898, 127638, 125564, 124793, 124716, 121549, 120082, 111187, 110871, 106390, 106045, 103943, 103763, 103754, 102886, 102850, 102151, 101996, 101902, 101523, 99195, 94621, 94616, 94060, 89798, 86086, 84039, 83657, 83587, 83469, 82739, 79791, 70442, 67468, 64055, 63940, 61648, 61381, 61134, 60737, 60713, 60314, 60223, 60193, 60191, 60187, 60110, 60042, 59976, 59913, 59737, 59733, 59695, 59635, 59553, 59535, 59467, 59459, 59354, 59342, 59220, 59204, 59182, 59143, 59114, 59057, 58999, 58946, 57839, 57001, 44416, 12212, 8456))
Run Time: 0.040057
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 88 | 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: 1499, 0, 1715844052, {"thread-177362":["thread",177362],"thread-170589":["thread",170589],"thread-169702":["thread",169702],"thread-166038":["thread",166038],"thread-162530":["thread",162530],"thread-162045":["thread",162045],"thread-161939":["thread",161939],"thread-161588":["thread",161588],"thread-161161":["thread",161161],"thread-160617":["thread",160617],"thread-160297":["thread",160297],"thread-160296":["thread",160296],"thread-152458":["thread",152458],"thread-132172":["thread",132172],"thread-132120":["thread",132120],"thread-129898":["thread",129898],"thread-127638":["thread",127638],"thread-125564":["thread",125564],"thread-124793":["thread",124793],"thread-124716":["thread",124716],"thread-121549":["thread",121549],"thread-120082":["thread",120082],"thread-111187":["thread",111187],"thread-110871":["thread",110871],"thread-106390":["thread",106390],"thread-106045":["thread",106045],"thread-103943":["thread",103943],"thread-103763":["thread",103763],"thread-103754":["thread",103754],"thread-102886":["thread",102886],"thread-102850":["thread",102850],"thread-102151":["thread",102151],"thread-101996":["thread",101996],"thread-101902":["thread",101902],"thread-101523":["thread",101523],"thread-99195":["thread",99195],"thread-94621":["thread",94621],"thread-94616":["thread",94616],"thread-94060":["thread",94060],"thread-89798":["thread",89798],"thread-86086":["thread",86086],"thread-84039":["thread",84039],"thread-83657":["thread",83657],"thread-83587":["thread",83587],"thread-83469":["thread",83469],"thread-82739":["thread",82739],"thread-79791":["thread",79791],"thread-70442":["thread",70442],"thread-67468":["thread",67468],"thread-64055":["thread",64055],"thread-63940":["thread",63940],"thread-61648":["thread",61648],"thread-61381":["thread",61381],"thread-61134":["thread",61134],"thread-60737":["thread",60737],"thread-60713":["thread",60713],"thread-60314":["thread",60314],"thread-60223":["thread",60223],"thread-60193":["thread",60193],"thread-60191":["thread",60191],"thread-60187":["thread",60187],"thread-60110":["thread",60110],"thread-60042":["thread",60042],"thread-59976":["thread",59976],"thread-59913":["thread",59913],"thread-59737":["thread",59737],"thread-59733":["thread",59733],"thread-59695":["thread",59695],"thread-59635":["thread",59635],"thread-59553":["thread",59553],"thread-59535":["thread",59535],"thread-59467":["thread",59467],"thread-59459":["thread",59459],"thread-59354":["thread",59354],"thread-59342":["thread",59342],"thread-59220":["thread",59220],"thread-59204":["thread",59204],"thread-59182":["thread",59182],"thread-59143":["thread",59143],"thread-59114":["thread",59114],"thread-59057":["thread",59057],"thread-58999":["thread",58999],"thread-58946":["thread",58946],"thread-57839":["thread",57839],"thread-57001":["thread",57001],"thread-44416":["thread",44416],"thread-12212":["thread",12212],"thread-8456":["thread",8456]}, , 1715840452
Run Time: 0.000207
- 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