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 (112190, 106055, 105414, 105101, 100695, 91483, 90992, 90895, 90411, 85615, 79143, 77063, 76374, 76323, 75840, 75161, 74956, 74080, 74022, 73061, 71374, 68608, 68593, 68555, 68186, 64962, 64819, 64031, 63993, 62432, 61914, 61861, 61822, 61821, 61614, 61508, 61498, 61387, 61277, 60954, 60016, 59550, 59311, 59269, 59249, 59232, 58161, 58145, 58103, 58096, 57748, 57218, 56680, 56677, 56652, 56238))
Run Time: 0.036237
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: 9407, 0, 1715065813, {"thread-112190":["thread",112190],"thread-106055":["thread",106055],"thread-105414":["thread",105414],"thread-105101":["thread",105101],"thread-100695":["thread",100695],"thread-91483":["thread",91483],"thread-90992":["thread",90992],"thread-90895":["thread",90895],"thread-90411":["thread",90411],"thread-85615":["thread",85615],"thread-79143":["thread",79143],"thread-77063":["thread",77063],"thread-76374":["thread",76374],"thread-76323":["thread",76323],"thread-75840":["thread",75840],"thread-75161":["thread",75161],"thread-74956":["thread",74956],"thread-74080":["thread",74080],"thread-74022":["thread",74022],"thread-73061":["thread",73061],"thread-71374":["thread",71374],"thread-68608":["thread",68608],"thread-68593":["thread",68593],"thread-68555":["thread",68555],"thread-68186":["thread",68186],"thread-64962":["thread",64962],"thread-64819":["thread",64819],"thread-64031":["thread",64031],"thread-63993":["thread",63993],"thread-62432":["thread",62432],"thread-61914":["thread",61914],"thread-61861":["thread",61861],"thread-61822":["thread",61822],"thread-61821":["thread",61821],"thread-61614":["thread",61614],"thread-61508":["thread",61508],"thread-61498":["thread",61498],"thread-61387":["thread",61387],"thread-61277":["thread",61277],"thread-60954":["thread",60954],"thread-60016":["thread",60016],"thread-59550":["thread",59550],"thread-59311":["thread",59311],"thread-59269":["thread",59269],"thread-59249":["thread",59249],"thread-59232":["thread",59232],"thread-58161":["thread",58161],"thread-58145":["thread",58145],"thread-58103":["thread",58103],"thread-58096":["thread",58096],"thread-57748":["thread",57748],"thread-57218":["thread",57218],"thread-56680":["thread",56680],"thread-56677":["thread",56677],"thread-56652":["thread",56652],"thread-56238":["thread",56238]}, , 1715062213
Run Time: 0.000475
- 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