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 (181403, 178875, 178662, 178383, 172492, 170706, 170321, 170302, 168438, 164594, 164421, 162268, 162181, 161877, 160085, 158744, 158718, 158716, 158714, 158489, 157798, 157651, 156420, 154177, 153110, 153044, 152285, 152031, 151727, 146674, 142256, 142254, 142253, 142252, 142251, 142250, 142249, 142248, 142247, 138748, 125917, 124899, 124897, 122462, 122225, 121203, 120853, 120258, 117741, 111249, 110495, 104262, 103980, 99550, 96390, 95479, 92523, 91657, 84724, 84654, 74729, 74436, 66900, 64229, 63417, 63364, 63356, 62928, 61257, 29907))
Run Time: 0.037141
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 70 | 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: 5609, 0, 1715747018, {"thread-181403":["thread",181403],"thread-178875":["thread",178875],"thread-178662":["thread",178662],"thread-178383":["thread",178383],"thread-172492":["thread",172492],"thread-170706":["thread",170706],"thread-170321":["thread",170321],"thread-170302":["thread",170302],"thread-168438":["thread",168438],"thread-164594":["thread",164594],"thread-164421":["thread",164421],"thread-162268":["thread",162268],"thread-162181":["thread",162181],"thread-161877":["thread",161877],"thread-160085":["thread",160085],"thread-158744":["thread",158744],"thread-158718":["thread",158718],"thread-158716":["thread",158716],"thread-158714":["thread",158714],"thread-158489":["thread",158489],"thread-157798":["thread",157798],"thread-157651":["thread",157651],"thread-156420":["thread",156420],"thread-154177":["thread",154177],"thread-153110":["thread",153110],"thread-153044":["thread",153044],"thread-152285":["thread",152285],"thread-152031":["thread",152031],"thread-151727":["thread",151727],"thread-146674":["thread",146674],"thread-142256":["thread",142256],"thread-142254":["thread",142254],"thread-142253":["thread",142253],"thread-142252":["thread",142252],"thread-142251":["thread",142251],"thread-142250":["thread",142250],"thread-142249":["thread",142249],"thread-142248":["thread",142248],"thread-142247":["thread",142247],"thread-138748":["thread",138748],"thread-125917":["thread",125917],"thread-124899":["thread",124899],"thread-124897":["thread",124897],"thread-122462":["thread",122462],"thread-122225":["thread",122225],"thread-121203":["thread",121203],"thread-120853":["thread",120853],"thread-120258":["thread",120258],"thread-117741":["thread",117741],"thread-111249":["thread",111249],"thread-110495":["thread",110495],"thread-104262":["thread",104262],"thread-103980":["thread",103980],"thread-99550":["thread",99550],"thread-96390":["thread",96390],"thread-95479":["thread",95479],"thread-92523":["thread",92523],"thread-91657":["thread",91657],"thread-84724":["thread",84724],"thread-84654":["thread",84654],"thread-74729":["thread",74729],"thread-74436":["thread",74436],"thread-66900":["thread",66900],"thread-64229":["thread",64229],"thread-63417":["thread",63417],"thread-63364":["thread",63364],"thread-63356":["thread",63356],"thread-62928":["thread",62928],"thread-61257":["thread",61257],"thread-29907":["thread",29907]}, , 1715743418
Run Time: 0.001656
- 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