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 (182879, 180803, 171995, 167853, 167524, 161235, 153189, 138245, 134876, 130716, 129436, 128917, 128402, 128233, 127544, 124014, 123477, 122313, 122237, 121988, 121925, 121626, 121345, 120285, 118959, 118476, 117158, 117157, 115702, 112723, 112630, 110679, 109874, 109361, 108254, 105080, 101238, 100273, 95715, 95094, 93645, 92725, 92649, 91058, 89628, 86025, 85604, 85571, 78025, 69676, 50481, 49929, 49750, 46240, 42158, 32605, 26854, 15364, 14111))
Run Time: 0.037780
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: 2130, 0, 1716077955, {"thread-182879":["thread",182879],"thread-180803":["thread",180803],"thread-171995":["thread",171995],"thread-167853":["thread",167853],"thread-167524":["thread",167524],"thread-161235":["thread",161235],"thread-153189":["thread",153189],"thread-138245":["thread",138245],"thread-134876":["thread",134876],"thread-130716":["thread",130716],"thread-129436":["thread",129436],"thread-128917":["thread",128917],"thread-128402":["thread",128402],"thread-128233":["thread",128233],"thread-127544":["thread",127544],"thread-124014":["thread",124014],"thread-123477":["thread",123477],"thread-122313":["thread",122313],"thread-122237":["thread",122237],"thread-121988":["thread",121988],"thread-121925":["thread",121925],"thread-121626":["thread",121626],"thread-121345":["thread",121345],"thread-120285":["thread",120285],"thread-118959":["thread",118959],"thread-118476":["thread",118476],"thread-117158":["thread",117158],"thread-117157":["thread",117157],"thread-115702":["thread",115702],"thread-112723":["thread",112723],"thread-112630":["thread",112630],"thread-110679":["thread",110679],"thread-109874":["thread",109874],"thread-109361":["thread",109361],"thread-108254":["thread",108254],"thread-105080":["thread",105080],"thread-101238":["thread",101238],"thread-100273":["thread",100273],"thread-95715":["thread",95715],"thread-95094":["thread",95094],"thread-93645":["thread",93645],"thread-92725":["thread",92725],"thread-92649":["thread",92649],"thread-91058":["thread",91058],"thread-89628":["thread",89628],"thread-86025":["thread",86025],"thread-85604":["thread",85604],"thread-85571":["thread",85571],"thread-78025":["thread",78025],"thread-69676":["thread",69676],"thread-50481":["thread",50481],"thread-49929":["thread",49929],"thread-49750":["thread",49750],"thread-46240":["thread",46240],"thread-42158":["thread",42158],"thread-32605":["thread",32605],"thread-26854":["thread",26854],"thread-15364":["thread",15364],"thread-14111":["thread",14111]}, , 1716074355
Run Time: 0.000203
- 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