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 (183240, 182672, 170343, 167399, 164062, 160180, 155403, 132723, 132044, 131978, 131965, 131757, 131688, 130968, 130549, 130499, 128770, 126671, 123467, 122732, 122706, 119778, 119694, 116976, 116927, 115744, 110476, 109633, 109438, 107936, 105676, 104369, 103773, 96738, 85187, 83862, 82773, 79348, 75356, 74324, 72742, 64396, 63353, 61942, 61466, 61238, 58131, 54332, 54107, 54049, 53299, 53297, 53253, 52108, 46442, 46441, 45767, 45409, 33224))
Run Time: 0.033373
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 59 | 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: 4661, 0, 1717068616, {"thread-183240":["thread",183240],"thread-182672":["thread",182672],"thread-170343":["thread",170343],"thread-167399":["thread",167399],"thread-164062":["thread",164062],"thread-160180":["thread",160180],"thread-155403":["thread",155403],"tl_group-114":["tl_group",114],"thread-132723":["thread",132723],"thread-132044":["thread",132044],"thread-131978":["thread",131978],"thread-131965":["thread",131965],"thread-131757":["thread",131757],"thread-131688":["thread",131688],"thread-130968":["thread",130968],"thread-130549":["thread",130549],"thread-130499":["thread",130499],"thread-128770":["thread",128770],"thread-126671":["thread",126671],"thread-123467":["thread",123467],"thread-122732":["thread",122732],"thread-122706":["thread",122706],"thread-119778":["thread",119778],"thread-119694":["thread",119694],"thread-116976":["thread",116976],"thread-116927":["thread",116927],"thread-115744":["thread",115744],"thread-110476":["thread",110476],"thread-109633":["thread",109633],"thread-109438":["thread",109438],"thread-107936":["thread",107936],"thread-105676":["thread",105676],"thread-104369":["thread",104369],"thread-103773":["thread",103773],"thread-96738":["thread",96738],"thread-85187":["thread",85187],"thread-83862":["thread",83862],"thread-82773":["thread",82773],"thread-79348":["thread",79348],"thread-75356":["thread",75356],"thread-74324":["thread",74324],"thread-72742":["thread",72742],"thread-64396":["thread",64396],"thread-63353":["thread",63353],"thread-61942":["thread",61942],"thread-61466":["thread",61466],"thread-61238":["thread",61238],"thread-58131":["thread",58131],"thread-54332":["thread",54332],"thread-54107":["thread",54107],"thread-54049":["thread",54049],"thread-53299":["thread",53299],"thread-53297":["thread",53297],"thread-53253":["thread",53253],"thread-52108":["thread",52108],"thread-46442":["thread",46442],"thread-46441":["thread",46441],"thread-45767":["thread",45767],"thread-45409":["thread",45409],"thread-33224":["thread",33224]}, , 1717065016
Run Time: 0.000221
- 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