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 (126100, 121242, 117210, 110303, 108901, 108704, 108702, 108620, 108574, 108554, 108194, 107528, 107288, 107278, 107216, 107091, 107057, 107055, 107024, 106895, 106825, 106769, 106760, 106559, 106555, 106503, 106469, 106443, 106382, 106372, 106367, 106051, 106049, 106044, 105958, 105948, 105895, 105509, 105213, 105189, 105172, 105160, 105096, 105094, 105066, 104794, 104719, 104549, 104438, 104073, 104071, 103557, 102357, 102341))
Run Time: 0.030921
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 54 | 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: 23793, 0, 1714354106, {"thread-126100":["thread",126100],"thread-121242":["thread",121242],"thread-117210":["thread",117210],"thread-110303":["thread",110303],"thread-108901":["thread",108901],"thread-108704":["thread",108704],"thread-108702":["thread",108702],"thread-108620":["thread",108620],"thread-108574":["thread",108574],"thread-108554":["thread",108554],"thread-108194":["thread",108194],"thread-107528":["thread",107528],"thread-107288":["thread",107288],"thread-107278":["thread",107278],"thread-107216":["thread",107216],"thread-107091":["thread",107091],"thread-107057":["thread",107057],"thread-107055":["thread",107055],"thread-107024":["thread",107024],"thread-106895":["thread",106895],"thread-106825":["thread",106825],"thread-106769":["thread",106769],"thread-106760":["thread",106760],"thread-106559":["thread",106559],"thread-106555":["thread",106555],"thread-106503":["thread",106503],"thread-106469":["thread",106469],"thread-106443":["thread",106443],"thread-106382":["thread",106382],"thread-106372":["thread",106372],"thread-106367":["thread",106367],"thread-106051":["thread",106051],"thread-106049":["thread",106049],"thread-106044":["thread",106044],"thread-105958":["thread",105958],"thread-105948":["thread",105948],"thread-105895":["thread",105895],"thread-105509":["thread",105509],"thread-105213":["thread",105213],"thread-105189":["thread",105189],"thread-105172":["thread",105172],"thread-105160":["thread",105160],"thread-105096":["thread",105096],"thread-105094":["thread",105094],"thread-105066":["thread",105066],"thread-104794":["thread",104794],"thread-104719":["thread",104719],"thread-104549":["thread",104549],"thread-104438":["thread",104438],"thread-104073":["thread",104073],"thread-104071":["thread",104071],"thread-103557":["thread",103557],"thread-102357":["thread",102357],"thread-102341":["thread",102341]}, , 1714350506
Run Time: 0.000297
- 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