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 (46709, 39882, 35331, 30177, 30062, 29585, 28859, 28524, 28398, 28288, 27317, 25227, 24884, 24883, 24875, 24833, 23796, 23592, 23427, 23395, 23291, 22947, 22831, 22327, 22072, 21617, 21401, 21394, 21253, 21178, 21004, 21002, 20292, 20160, 18818, 18788, 18776, 17868, 17805, 17801, 17790, 14973, 12851, 12847, 12845, 12749, 12745, 12743, 12740, 12654, 12501, 12346, 12313, 10227, 10176, 10058, 9113, 8440, 8383, 8305, 8303, 8251, 8247, 8065, 7442, 7365, 4426, 4425, 3960, 3959, 3958, 4352, 4351, 4670, 3055, 2651, 2650, 2046, 2019, 1881, 1383, 641, 639, 638))
Run Time: 0.049927
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 84 | 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: 821, 0, 1714976456, {"thread-46709":["thread",46709],"thread-39882":["thread",39882],"thread-35331":["thread",35331],"thread-30177":["thread",30177],"thread-30062":["thread",30062],"thread-29585":["thread",29585],"thread-28859":["thread",28859],"thread-28524":["thread",28524],"thread-28398":["thread",28398],"thread-28288":["thread",28288],"thread-27317":["thread",27317],"thread-25227":["thread",25227],"thread-24884":["thread",24884],"thread-24883":["thread",24883],"thread-24875":["thread",24875],"thread-24833":["thread",24833],"thread-23796":["thread",23796],"thread-23592":["thread",23592],"thread-23427":["thread",23427],"thread-23395":["thread",23395],"thread-23291":["thread",23291],"thread-22947":["thread",22947],"thread-22831":["thread",22831],"thread-22327":["thread",22327],"thread-22072":["thread",22072],"thread-21617":["thread",21617],"thread-21401":["thread",21401],"thread-21394":["thread",21394],"thread-21253":["thread",21253],"thread-21178":["thread",21178],"thread-21004":["thread",21004],"thread-21002":["thread",21002],"thread-20292":["thread",20292],"thread-20160":["thread",20160],"thread-18818":["thread",18818],"thread-18788":["thread",18788],"thread-18776":["thread",18776],"thread-17868":["thread",17868],"thread-17805":["thread",17805],"thread-17801":["thread",17801],"thread-17790":["thread",17790],"thread-14973":["thread",14973],"thread-12851":["thread",12851],"thread-12847":["thread",12847],"thread-12845":["thread",12845],"thread-12749":["thread",12749],"thread-12745":["thread",12745],"thread-12743":["thread",12743],"thread-12740":["thread",12740],"thread-12654":["thread",12654],"thread-12501":["thread",12501],"thread-12346":["thread",12346],"thread-12313":["thread",12313],"thread-10227":["thread",10227],"thread-10176":["thread",10176],"thread-10058":["thread",10058],"thread-9113":["thread",9113],"thread-8440":["thread",8440],"thread-8383":["thread",8383],"thread-8305":["thread",8305],"thread-8303":["thread",8303],"thread-8251":["thread",8251],"thread-8247":["thread",8247],"thread-8065":["thread",8065],"thread-7442":["thread",7442],"thread-7365":["thread",7365],"thread-4426":["thread",4426],"thread-4425":["thread",4425],"thread-3960":["thread",3960],"thread-3959":["thread",3959],"thread-3958":["thread",3958],"thread-4352":["thread",4352],"thread-4351":["thread",4351],"thread-4670":["thread",4670],"thread-3055":["thread",3055],"thread-2651":["thread",2651],"thread-2650":["thread",2650],"thread-2046":["thread",2046],"thread-2019":["thread",2019],"thread-1881":["thread",1881],"thread-1383":["thread",1383],"thread-641":["thread",641],"thread-639":["thread",639],"thread-638":["thread",638]}, , 1714972856
Run Time: 0.000439
- 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