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 (182020, 181473, 180969, 180968, 180845, 179788, 177681, 177665, 177432, 172953, 172952, 172926, 172121, 170139, 169899, 169415, 168873, 167446, 165513, 160729, 160394, 159089, 159003, 159001, 158931, 158927, 158518, 158119, 148534, 142817, 132778, 129625, 118024, 115075, 112777, 110097, 110010, 109596, 107853, 107709, 105938, 96958, 96816, 95954, 95933, 95878, 95743, 95719, 90383, 90136, 88655, 76076, 72863, 65640, 61942, 56746, 56035, 51824, 51778, 51771, 42152, 39682, 39257, 39218, 35105, 29520, 16430, 16324, 16261, 1274))
Run Time: 0.034263
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: 318, 0, 1714318452, {"thread-182020":["thread",182020],"thread-181473":["thread",181473],"thread-180969":["thread",180969],"thread-180968":["thread",180968],"thread-180845":["thread",180845],"thread-179788":["thread",179788],"thread-177681":["thread",177681],"thread-177665":["thread",177665],"thread-177432":["thread",177432],"thread-172953":["thread",172953],"thread-172952":["thread",172952],"thread-172926":["thread",172926],"thread-172121":["thread",172121],"thread-170139":["thread",170139],"thread-169899":["thread",169899],"thread-169415":["thread",169415],"ams_article-4802":["ams_article",4802],"thread-168873":["thread",168873],"thread-167446":["thread",167446],"thread-165513":["thread",165513],"thread-160729":["thread",160729],"thread-160394":["thread",160394],"ams_article-4419":["ams_article",4419],"ams_article-4377":["ams_article",4377],"thread-159089":["thread",159089],"thread-159003":["thread",159003],"thread-159001":["thread",159001],"thread-158931":["thread",158931],"thread-158927":["thread",158927],"tl_group-153":["tl_group",153],"thread-158518":["thread",158518],"thread-158119":["thread",158119],"ams_article-3768":["ams_article",3768],"thread-148534":["thread",148534],"ams_article-3658":["ams_article",3658],"ams_article-3592":["ams_article",3592],"thread-142817":["thread",142817],"ams_article-3074":["ams_article",3074],"ams_article-3058":["ams_article",3058],"ams_article-2974":["ams_article",2974],"thread-132778":["thread",132778],"thread-129625":["thread",129625],"thread-118024":["thread",118024],"thread-115075":["thread",115075],"thread-112777":["thread",112777],"thread-110097":["thread",110097],"thread-110010":["thread",110010],"thread-109596":["thread",109596],"thread-107853":["thread",107853],"thread-107709":["thread",107709],"thread-105938":["thread",105938],"thread-96958":["thread",96958],"thread-96816":["thread",96816],"thread-95954":["thread",95954],"thread-95933":["thread",95933],"thread-95878":["thread",95878],"thread-95743":["thread",95743],"thread-95719":["thread",95719],"thread-90383":["thread",90383],"thread-90136":["thread",90136],"thread-88655":["thread",88655],"thread-76076":["thread",76076],"thread-72863":["thread",72863],"thread-65640":["thread",65640],"thread-61942":["thread",61942],"thread-56746":["thread",56746],"thread-56035":["thread",56035],"thread-51824":["thread",51824],"thread-51778":["thread",51778],"thread-51771":["thread",51771],"thread-42152":["thread",42152],"thread-39682":["thread",39682],"thread-39257":["thread",39257],"thread-39218":["thread",39218],"thread-35105":["thread",35105],"thread-29520":["thread",29520],"thread-16430":["thread",16430],"thread-16324":["thread",16324],"thread-16261":["thread",16261],"thread-1274":["thread",1274]}, , 1714314852
Run Time: 0.000518
- 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