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 (121704, 120009, 119301, 113568, 111143, 111141, 108329, 108231, 108057, 107548, 107514, 107460, 107017, 106993, 106805, 106692, 106676, 106433, 106293, 106267, 106037, 105864, 105438, 104903, 104812, 104559, 103583, 103581, 103248, 103247, 103240, 103049, 102901, 100567, 100498, 100334, 100186, 100060, 99754, 99700, 99255, 98993, 98964, 98881, 95464, 92800, 92732, 92645, 91596, 90407, 65735))
Run Time: 0.032044
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: 12115, 0, 1717083700, {"thread-121704":["thread",121704],"thread-120009":["thread",120009],"thread-119301":["thread",119301],"thread-113568":["thread",113568],"thread-111143":["thread",111143],"thread-111141":["thread",111141],"thread-108329":["thread",108329],"thread-108231":["thread",108231],"thread-108057":["thread",108057],"thread-107548":["thread",107548],"thread-107514":["thread",107514],"thread-107460":["thread",107460],"thread-107017":["thread",107017],"thread-106993":["thread",106993],"thread-106805":["thread",106805],"thread-106692":["thread",106692],"thread-106676":["thread",106676],"thread-106433":["thread",106433],"thread-106293":["thread",106293],"thread-106267":["thread",106267],"thread-106037":["thread",106037],"thread-105864":["thread",105864],"thread-105438":["thread",105438],"thread-104903":["thread",104903],"thread-104812":["thread",104812],"thread-104559":["thread",104559],"thread-103583":["thread",103583],"thread-103581":["thread",103581],"thread-103248":["thread",103248],"thread-103247":["thread",103247],"thread-103240":["thread",103240],"thread-103049":["thread",103049],"thread-102901":["thread",102901],"thread-100567":["thread",100567],"thread-100498":["thread",100498],"thread-100334":["thread",100334],"thread-100186":["thread",100186],"thread-100060":["thread",100060],"thread-99754":["thread",99754],"thread-99700":["thread",99700],"thread-99255":["thread",99255],"thread-98993":["thread",98993],"thread-98964":["thread",98964],"thread-98881":["thread",98881],"thread-95464":["thread",95464],"thread-92800":["thread",92800],"thread-92732":["thread",92732],"thread-92645":["thread",92645],"thread-91596":["thread",91596],"thread-90407":["thread",90407],"thread-65735":["thread",65735]}, , 1717080100
Run Time: 0.001213
- 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