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 (180207, 120580, 119747, 103461, 100981, 98275, 93085, 88818, 88784, 88224, 87705, 87301, 87011, 86765, 85760, 85106, 83057, 82477, 82256, 81407, 81234, 80544, 80465, 76888, 76289, 72641, 71728, 71600, 71174, 70456, 69917, 67945, 66505, 66331, 65906, 65243, 64973, 64562, 58690, 58024, 57205, 56827, 56718, 56555, 56217, 54714, 54277, 54045, 53887, 53671, 52548, 51201, 50621, 50131, 49671, 47711, 46880, 45937, 45878, 44660, 44639, 44303, 43631, 39806, 34851, 32681, 30378, 30047, 29939, 25754, 11132, 10479, 10224))
Run Time: 0.034059
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 73 | 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: 1698, 0, 1716132645, {"thread-180207":["thread",180207],"thread-120580":["thread",120580],"thread-119747":["thread",119747],"thread-103461":["thread",103461],"thread-100981":["thread",100981],"thread-98275":["thread",98275],"thread-93085":["thread",93085],"thread-88818":["thread",88818],"thread-88784":["thread",88784],"thread-88224":["thread",88224],"thread-87705":["thread",87705],"thread-87301":["thread",87301],"thread-87011":["thread",87011],"thread-86765":["thread",86765],"thread-85760":["thread",85760],"thread-85106":["thread",85106],"thread-83057":["thread",83057],"thread-82477":["thread",82477],"thread-82256":["thread",82256],"thread-81407":["thread",81407],"thread-81234":["thread",81234],"thread-80544":["thread",80544],"thread-80465":["thread",80465],"thread-76888":["thread",76888],"thread-76289":["thread",76289],"thread-72641":["thread",72641],"thread-71728":["thread",71728],"thread-71600":["thread",71600],"thread-71174":["thread",71174],"thread-70456":["thread",70456],"thread-69917":["thread",69917],"thread-67945":["thread",67945],"thread-66505":["thread",66505],"thread-66331":["thread",66331],"thread-65906":["thread",65906],"thread-65243":["thread",65243],"thread-64973":["thread",64973],"thread-64562":["thread",64562],"thread-58690":["thread",58690],"thread-58024":["thread",58024],"thread-57205":["thread",57205],"thread-56827":["thread",56827],"thread-56718":["thread",56718],"thread-56555":["thread",56555],"thread-56217":["thread",56217],"thread-54714":["thread",54714],"thread-54277":["thread",54277],"thread-54045":["thread",54045],"thread-53887":["thread",53887],"thread-53671":["thread",53671],"thread-52548":["thread",52548],"thread-51201":["thread",51201],"thread-50621":["thread",50621],"thread-50131":["thread",50131],"thread-49671":["thread",49671],"thread-47711":["thread",47711],"thread-46880":["thread",46880],"thread-45937":["thread",45937],"thread-45878":["thread",45878],"thread-44660":["thread",44660],"thread-44639":["thread",44639],"thread-44303":["thread",44303],"thread-43631":["thread",43631],"thread-39806":["thread",39806],"thread-34851":["thread",34851],"thread-32681":["thread",32681],"thread-30378":["thread",30378],"thread-30047":["thread",30047],"thread-29939":["thread",29939],"thread-25754":["thread",25754],"thread-11132":["thread",11132],"thread-10479":["thread",10479],"thread-10224":["thread",10224]}, , 1716129045
Run Time: 0.000421
- 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