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 (182398, 181808, 156255, 155568, 146285, 145587, 145366, 145357, 142458, 142256, 142254, 142253, 142252, 142251, 142250, 142249, 142248, 142247, 141651, 141462, 141171, 141075, 141053, 140916, 140890, 140863, 140498, 140480, 139965, 124168, 123961, 123960, 123946, 120443, 120081, 111616, 110962, 107782, 82504, 82063, 76351, 76227, 74753, 74357, 65369, 65342, 65251, 62910, 62415, 61866, 57198, 54104, 53072, 50826, 27217, 25668))
Run Time: 0.025417
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 56 | 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: 3350, 0, 1717231159, {"thread-182398":["thread",182398],"thread-181808":["thread",181808],"thread-156255":["thread",156255],"thread-155568":["thread",155568],"thread-146285":["thread",146285],"thread-145587":["thread",145587],"thread-145366":["thread",145366],"thread-145357":["thread",145357],"thread-142458":["thread",142458],"thread-142256":["thread",142256],"thread-142254":["thread",142254],"thread-142253":["thread",142253],"thread-142252":["thread",142252],"thread-142251":["thread",142251],"thread-142250":["thread",142250],"thread-142249":["thread",142249],"thread-142248":["thread",142248],"thread-142247":["thread",142247],"thread-141651":["thread",141651],"thread-141462":["thread",141462],"thread-141171":["thread",141171],"thread-141075":["thread",141075],"thread-141053":["thread",141053],"thread-140916":["thread",140916],"thread-140890":["thread",140890],"thread-140863":["thread",140863],"thread-140498":["thread",140498],"thread-140480":["thread",140480],"thread-139965":["thread",139965],"thread-124168":["thread",124168],"thread-123961":["thread",123961],"thread-123960":["thread",123960],"thread-123946":["thread",123946],"thread-120443":["thread",120443],"thread-120081":["thread",120081],"thread-111616":["thread",111616],"thread-110962":["thread",110962],"thread-107782":["thread",107782],"thread-82504":["thread",82504],"thread-82063":["thread",82063],"thread-76351":["thread",76351],"thread-76227":["thread",76227],"thread-74753":["thread",74753],"thread-74357":["thread",74357],"thread-65369":["thread",65369],"thread-65342":["thread",65342],"thread-65251":["thread",65251],"thread-62910":["thread",62910],"thread-62415":["thread",62415],"thread-61866":["thread",61866],"thread-57198":["thread",57198],"thread-54104":["thread",54104],"thread-53072":["thread",53072],"thread-50826":["thread",50826],"thread-27217":["thread",27217],"thread-25668":["thread",25668]}, , 1717227559
Run Time: 0.000167
- 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