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 (178548, 175914, 174355, 171926, 170040, 167095, 164223, 163768, 162901, 162229, 161866, 159974, 154244, 151711, 151436, 150514, 143830, 143829, 142776, 141876, 135094, 134678, 133519, 132822, 131173, 124553, 122665, 122217, 117252, 108474, 108246, 105882, 105854, 104487, 100952, 100413, 99860, 96826, 93926, 93202, 91239, 86853, 84782, 84332, 82124, 81236, 81029, 81017, 81009, 80976, 79493, 78558, 75563, 74367, 73907, 73694, 72927, 72653, 69033, 68304, 68227, 64480, 60003, 59954, 53952, 52928, 52820, 51126, 43219, 41659, 40983, 30785, 29336, 25610, 21469, 4867, 4611, 4801, 1989, 1447))
Run Time: 0.051016
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 80 | 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: 388, 0, 1716643078, {"thread-178548":["thread",178548],"thread-175914":["thread",175914],"thread-174355":["thread",174355],"thread-171926":["thread",171926],"thread-170040":["thread",170040],"thread-167095":["thread",167095],"thread-164223":["thread",164223],"thread-163768":["thread",163768],"thread-162901":["thread",162901],"thread-162229":["thread",162229],"thread-161866":["thread",161866],"thread-159974":["thread",159974],"thread-154244":["thread",154244],"thread-151711":["thread",151711],"thread-151436":["thread",151436],"thread-150514":["thread",150514],"thread-143830":["thread",143830],"thread-143829":["thread",143829],"thread-142776":["thread",142776],"thread-141876":["thread",141876],"thread-135094":["thread",135094],"thread-134678":["thread",134678],"thread-133519":["thread",133519],"thread-132822":["thread",132822],"thread-131173":["thread",131173],"thread-124553":["thread",124553],"thread-122665":["thread",122665],"thread-122217":["thread",122217],"thread-117252":["thread",117252],"thread-108474":["thread",108474],"thread-108246":["thread",108246],"thread-105882":["thread",105882],"thread-105854":["thread",105854],"thread-104487":["thread",104487],"thread-100952":["thread",100952],"thread-100413":["thread",100413],"thread-99860":["thread",99860],"thread-96826":["thread",96826],"thread-93926":["thread",93926],"thread-93202":["thread",93202],"thread-91239":["thread",91239],"thread-86853":["thread",86853],"thread-84782":["thread",84782],"thread-84332":["thread",84332],"thread-82124":["thread",82124],"thread-81236":["thread",81236],"thread-81029":["thread",81029],"thread-81017":["thread",81017],"thread-81009":["thread",81009],"thread-80976":["thread",80976],"thread-79493":["thread",79493],"thread-78558":["thread",78558],"thread-75563":["thread",75563],"thread-74367":["thread",74367],"thread-73907":["thread",73907],"thread-73694":["thread",73694],"thread-72927":["thread",72927],"thread-72653":["thread",72653],"thread-69033":["thread",69033],"thread-68304":["thread",68304],"thread-68227":["thread",68227],"thread-64480":["thread",64480],"thread-60003":["thread",60003],"thread-59954":["thread",59954],"thread-53952":["thread",53952],"thread-52928":["thread",52928],"thread-52820":["thread",52820],"thread-51126":["thread",51126],"thread-43219":["thread",43219],"thread-41659":["thread",41659],"thread-40983":["thread",40983],"thread-30785":["thread",30785],"thread-29336":["thread",29336],"thread-25610":["thread",25610],"thread-21469":["thread",21469],"thread-4867":["thread",4867],"thread-4611":["thread",4611],"thread-4801":["thread",4801],"thread-1989":["thread",1989],"thread-1447":["thread",1447]}, , 1716639478
Run Time: 0.000686
- 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