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 (181721, 151030, 128856, 126647, 121472, 121027, 121024, 121005, 120936, 120831, 120640, 120593, 120592, 119693, 119039, 118877, 118875, 118874, 118840, 118739, 118710, 118709, 117840, 117414, 115084, 115083, 115082, 114835, 114833, 114829, 114800, 114655, 114489, 114395, 114344, 114312, 114244, 114137, 114108, 114106, 114105, 111627, 110869, 110790, 110758, 110709, 109107, 108767, 107697, 105903, 105503, 105075, 104148, 103513, 103487, 103168, 100429, 100428, 97759, 85476, 75729, 55173, 43955, 30320, 18063, 14423, 11598, 11597, 11596, 10916, 5589, 4714, 4711))
Run Time: 0.045907
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 73 | 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: 1060, 0, 1715851302, {"thread-181721":["thread",181721],"thread-151030":["thread",151030],"thread-128856":["thread",128856],"thread-126647":["thread",126647],"thread-121472":["thread",121472],"thread-121027":["thread",121027],"thread-121024":["thread",121024],"thread-121005":["thread",121005],"thread-120936":["thread",120936],"thread-120831":["thread",120831],"thread-120640":["thread",120640],"thread-120593":["thread",120593],"thread-120592":["thread",120592],"thread-119693":["thread",119693],"thread-119039":["thread",119039],"thread-118877":["thread",118877],"thread-118875":["thread",118875],"thread-118874":["thread",118874],"thread-118840":["thread",118840],"thread-118739":["thread",118739],"thread-118710":["thread",118710],"thread-118709":["thread",118709],"thread-117840":["thread",117840],"thread-117414":["thread",117414],"thread-115084":["thread",115084],"thread-115083":["thread",115083],"thread-115082":["thread",115082],"thread-114835":["thread",114835],"thread-114833":["thread",114833],"thread-114829":["thread",114829],"thread-114800":["thread",114800],"thread-114655":["thread",114655],"thread-114489":["thread",114489],"thread-114395":["thread",114395],"thread-114344":["thread",114344],"thread-114312":["thread",114312],"thread-114244":["thread",114244],"thread-114137":["thread",114137],"thread-114108":["thread",114108],"thread-114106":["thread",114106],"thread-114105":["thread",114105],"thread-111627":["thread",111627],"thread-110869":["thread",110869],"thread-110790":["thread",110790],"thread-110758":["thread",110758],"thread-110709":["thread",110709],"thread-109107":["thread",109107],"thread-108767":["thread",108767],"thread-107697":["thread",107697],"thread-105903":["thread",105903],"thread-105503":["thread",105503],"thread-105075":["thread",105075],"thread-104148":["thread",104148],"thread-103513":["thread",103513],"thread-103487":["thread",103487],"thread-103168":["thread",103168],"thread-100429":["thread",100429],"thread-100428":["thread",100428],"thread-97759":["thread",97759],"thread-85476":["thread",85476],"thread-75729":["thread",75729],"thread-55173":["thread",55173],"thread-43955":["thread",43955],"thread-30320":["thread",30320],"thread-18063":["thread",18063],"thread-14423":["thread",14423],"thread-11598":["thread",11598],"thread-11597":["thread",11597],"thread-11596":["thread",11596],"thread-10916":["thread",10916],"thread-5589":["thread",5589],"thread-4714":["thread",4714],"thread-4711":["thread",4711]}, , 1715847702
Run Time: 0.000171
- 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