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 (142032, 127673, 127612, 127327, 127324, 127321, 92424, 91302, 90959, 90398, 89990, 89894, 83067, 83066, 83053, 83048, 82971, 82676, 82572, 82570, 82565, 82563, 81138, 80878, 80845, 80339, 80110, 80108, 80107, 78961, 78504, 77999, 77998, 77447, 77361, 77112, 77111, 76833, 76820, 76810, 76713, 76604, 76601, 76422, 76420, 76418, 76332, 76329, 76321, 76165, 76159, 76156, 75911, 75819, 74575, 74506, 74458, 74427, 73428))
Run Time: 0.029873
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: 14427, 0, 1715938039, {"thread-142032":["thread",142032],"thread-127673":["thread",127673],"thread-127612":["thread",127612],"thread-127327":["thread",127327],"thread-127324":["thread",127324],"thread-127321":["thread",127321],"thread-92424":["thread",92424],"thread-91302":["thread",91302],"thread-90959":["thread",90959],"thread-90398":["thread",90398],"thread-89990":["thread",89990],"thread-89894":["thread",89894],"thread-83067":["thread",83067],"thread-83066":["thread",83066],"thread-83053":["thread",83053],"thread-83048":["thread",83048],"thread-82971":["thread",82971],"thread-82676":["thread",82676],"thread-82572":["thread",82572],"thread-82570":["thread",82570],"thread-82565":["thread",82565],"thread-82563":["thread",82563],"thread-81138":["thread",81138],"thread-80878":["thread",80878],"thread-80845":["thread",80845],"thread-80339":["thread",80339],"thread-80110":["thread",80110],"thread-80108":["thread",80108],"thread-80107":["thread",80107],"thread-78961":["thread",78961],"thread-78504":["thread",78504],"thread-77999":["thread",77999],"thread-77998":["thread",77998],"thread-77447":["thread",77447],"thread-77361":["thread",77361],"thread-77112":["thread",77112],"thread-77111":["thread",77111],"thread-76833":["thread",76833],"thread-76820":["thread",76820],"thread-76810":["thread",76810],"thread-76713":["thread",76713],"thread-76604":["thread",76604],"thread-76601":["thread",76601],"thread-76422":["thread",76422],"thread-76420":["thread",76420],"thread-76418":["thread",76418],"thread-76332":["thread",76332],"thread-76329":["thread",76329],"thread-76321":["thread",76321],"thread-76165":["thread",76165],"thread-76159":["thread",76159],"thread-76156":["thread",76156],"thread-75911":["thread",75911],"thread-75819":["thread",75819],"thread-74575":["thread",74575],"thread-74506":["thread",74506],"thread-74458":["thread",74458],"thread-74427":["thread",74427],"thread-73428":["thread",73428]}, , 1715934439
Run Time: 0.000245
- 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