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 (129048, 68640, 68380, 68322, 67750, 67065, 66777, 66482, 66405, 63353, 61364, 61327, 61321, 60071, 59832, 59746, 59575, 59377, 59079, 58666, 58665, 58660, 58594, 58537, 58460, 58141, 57957, 57879, 57852, 57355, 57206, 55992, 55266, 55012, 54400, 54138, 54117, 53133, 52941, 52616, 52287, 52279, 51666, 51152, 51076, 50099, 49844, 49838, 49445, 49139, 48931, 48918, 48506, 48440, 47718, 47417, 47408, 47407, 47300, 47102, 47012, 46954, 46946, 46885, 46784, 46598, 46440, 46345, 46255, 46209, 46197, 45324, 45233, 45230, 44983, 44898, 44410, 44409, 44099, 43361, 43349, 43173, 43089, 43080, 43054, 40205, 38443, 29271, 21292, 19596, 15844, 14324, 14123))
Run Time: 0.062132
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 93 | 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: 2270, 0, 1715982710, {"ams_article-4101":["ams_article",4101],"thread-129048":["thread",129048],"thread-68640":["thread",68640],"thread-68380":["thread",68380],"thread-68322":["thread",68322],"thread-67750":["thread",67750],"thread-67065":["thread",67065],"thread-66777":["thread",66777],"thread-66482":["thread",66482],"thread-66405":["thread",66405],"thread-63353":["thread",63353],"thread-61364":["thread",61364],"thread-61327":["thread",61327],"thread-61321":["thread",61321],"thread-60071":["thread",60071],"thread-59832":["thread",59832],"thread-59746":["thread",59746],"thread-59575":["thread",59575],"thread-59377":["thread",59377],"thread-59079":["thread",59079],"thread-58666":["thread",58666],"thread-58665":["thread",58665],"thread-58660":["thread",58660],"thread-58594":["thread",58594],"thread-58537":["thread",58537],"thread-58460":["thread",58460],"thread-58141":["thread",58141],"thread-57957":["thread",57957],"thread-57879":["thread",57879],"thread-57852":["thread",57852],"thread-57355":["thread",57355],"thread-57206":["thread",57206],"thread-55992":["thread",55992],"thread-55266":["thread",55266],"thread-55012":["thread",55012],"thread-54400":["thread",54400],"thread-54138":["thread",54138],"thread-54117":["thread",54117],"thread-53133":["thread",53133],"thread-52941":["thread",52941],"thread-52616":["thread",52616],"thread-52287":["thread",52287],"thread-52279":["thread",52279],"thread-51666":["thread",51666],"thread-51152":["thread",51152],"thread-51076":["thread",51076],"thread-50099":["thread",50099],"thread-49844":["thread",49844],"thread-49838":["thread",49838],"thread-49445":["thread",49445],"thread-49139":["thread",49139],"thread-48931":["thread",48931],"thread-48918":["thread",48918],"thread-48506":["thread",48506],"thread-48440":["thread",48440],"thread-47718":["thread",47718],"thread-47417":["thread",47417],"thread-47408":["thread",47408],"thread-47407":["thread",47407],"thread-47300":["thread",47300],"thread-47102":["thread",47102],"thread-47012":["thread",47012],"thread-46954":["thread",46954],"thread-46946":["thread",46946],"thread-46885":["thread",46885],"thread-46784":["thread",46784],"thread-46598":["thread",46598],"thread-46440":["thread",46440],"thread-46345":["thread",46345],"thread-46255":["thread",46255],"thread-46209":["thread",46209],"thread-46197":["thread",46197],"thread-45324":["thread",45324],"thread-45233":["thread",45233],"thread-45230":["thread",45230],"thread-44983":["thread",44983],"thread-44898":["thread",44898],"thread-44410":["thread",44410],"thread-44409":["thread",44409],"thread-44099":["thread",44099],"thread-43361":["thread",43361],"thread-43349":["thread",43349],"thread-43173":["thread",43173],"thread-43089":["thread",43089],"thread-43080":["thread",43080],"thread-43054":["thread",43054],"thread-40205":["thread",40205],"thread-38443":["thread",38443],"thread-29271":["thread",29271],"thread-21292":["thread",21292],"thread-19596":["thread",19596],"thread-15844":["thread",15844],"thread-14324":["thread",14324],"thread-14123":["thread",14123]}, , 1715979110
Run Time: 0.000185
- 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