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 (58441, 58417, 58401, 58210, 57988, 57982, 57734, 57466, 57461, 57259, 56895, 56733, 56395, 55837, 55686, 55510, 55479, 54465, 53836, 53497, 53489, 53473, 53300, 53022, 52573, 52133, 52132, 51281, 51160, 51159, 51099, 50967, 50843, 50818, 50225, 49959, 49579, 49133, 48987, 48922, 48334, 47866, 47178, 46883, 46312, 44158, 43820, 43467, 43176, 43062, 41018, 40111, 40038, 39928, 39222, 38790, 38548, 38529, 37706, 37285, 37267, 35982, 34529, 33932, 33924, 33675, 33533, 33243, 33037, 32375, 32295, 32047, 31573, 31342, 31276, 31239, 31036, 31035, 30564, 30309, 30129, 28608, 28537, 28524, 28269, 27892, 27169, 26902, 25548, 25442, 24940, 24484, 23567, 23429, 23162, 22639, 22469, 21955, 21726, 21094, 20493, 20204, 19233, 19222, 18756, 18728, 17997, 17793, 17574, 17297, 17256, 17149, 16845, 16658, 15745, 15009, 14237, 14236, 14047, 14016, 13907, 13163, 13145, 13073, 12844, 12713, 12443, 12279, 12223, 12071, 11760, 11526, 11504, 11452, 11367, 11362, 11110, 10693, 9585, 9210, 8902, 8763, 8730, 8494, 7656, 6934, 6795, 6271, 5145, 4357, 4049, 3823, 3098))
Run Time: 0.029215
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 153 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dark_db13795.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2549
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- 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: 671, 0, 1716265716, {"thread-58441":["thread",58441],"thread-58417":["thread",58417],"thread-58401":["thread",58401],"thread-58210":["thread",58210],"thread-57988":["thread",57988],"thread-57982":["thread",57982],"thread-57734":["thread",57734],"thread-57466":["thread",57466],"thread-57461":["thread",57461],"thread-57259":["thread",57259],"thread-56895":["thread",56895],"thread-56733":["thread",56733],"thread-56395":["thread",56395],"thread-55837":["thread",55837],"thread-55686":["thread",55686],"thread-55510":["thread",55510],"thread-55479":["thread",55479],"thread-54465":["thread",54465],"thread-53836":["thread",53836],"thread-53497":["thread",53497],"thread-53489":["thread",53489],"thread-53473":["thread",53473],"thread-53300":["thread",53300],"thread-53022":["thread",53022],"thread-52573":["thread",52573],"thread-52133":["thread",52133],"thread-52132":["thread",52132],"thread-51281":["thread",51281],"thread-51160":["thread",51160],"thread-51159":["thread",51159],"thread-51099":["thread",51099],"thread-50967":["thread",50967],"thread-50843":["thread",50843],"thread-50818":["thread",50818],"thread-50225":["thread",50225],"thread-49959":["thread",49959],"thread-49579":["thread",49579],"thread-49133":["thread",49133],"thread-48987":["thread",48987],"thread-48922":["thread",48922],"thread-48334":["thread",48334],"thread-47866":["thread",47866],"thread-47178":["thread",47178],"thread-46883":["thread",46883],"thread-46312":["thread",46312],"thread-44158":["thread",44158],"thread-43820":["thread",43820],"thread-43467":["thread",43467],"thread-43176":["thread",43176],"thread-43062":["thread",43062],"thread-41018":["thread",41018],"thread-40111":["thread",40111],"thread-40038":["thread",40038],"thread-39928":["thread",39928],"thread-39222":["thread",39222],"thread-38790":["thread",38790],"thread-38548":["thread",38548],"thread-38529":["thread",38529],"thread-37706":["thread",37706],"thread-37285":["thread",37285],"thread-37267":["thread",37267],"thread-35982":["thread",35982],"thread-34529":["thread",34529],"thread-33932":["thread",33932],"thread-33924":["thread",33924],"thread-33675":["thread",33675],"thread-33533":["thread",33533],"thread-33243":["thread",33243],"thread-33037":["thread",33037],"thread-32375":["thread",32375],"thread-32295":["thread",32295],"thread-32047":["thread",32047],"thread-31573":["thread",31573],"thread-31342":["thread",31342],"thread-31276":["thread",31276],"thread-31239":["thread",31239],"thread-31036":["thread",31036],"thread-31035":["thread",31035],"thread-30564":["thread",30564],"thread-30309":["thread",30309],"thread-30129":["thread",30129],"thread-28608":["thread",28608],"thread-28537":["thread",28537],"thread-28524":["thread",28524],"thread-28269":["thread",28269],"thread-27892":["thread",27892],"thread-27169":["thread",27169],"thread-26902":["thread",26902],"thread-25548":["thread",25548],"thread-25442":["thread",25442],"thread-24940":["thread",24940],"thread-24484":["thread",24484],"thread-23567":["thread",23567],"thread-23429":["thread",23429],"thread-23162":["thread",23162],"thread-22639":["thread",22639],"thread-22469":["thread",22469],"thread-21955":["thread",21955],"thread-21726":["thread",21726],"thread-21094":["thread",21094],"thread-20493":["thread",20493],"thread-20204":["thread",20204],"thread-19233":["thread",19233],"thread-19222":["thread",19222],"thread-18756":["thread",18756],"thread-18728":["thread",18728],"thread-17997":["thread",17997],"thread-17793":["thread",17793],"thread-17574":["thread",17574],"thread-17297":["thread",17297],"thread-17256":["thread",17256],"thread-17149":["thread",17149],"thread-16845":["thread",16845],"thread-16658":["thread",16658],"thread-15745":["thread",15745],"thread-15009":["thread",15009],"thread-14237":["thread",14237],"thread-14236":["thread",14236],"thread-14047":["thread",14047],"thread-14016":["thread",14016],"thread-13907":["thread",13907],"thread-13163":["thread",13163],"thread-13145":["thread",13145],"thread-13073":["thread",13073],"thread-12844":["thread",12844],"thread-12713":["thread",12713],"thread-12443":["thread",12443],"thread-12279":["thread",12279],"thread-12223":["thread",12223],"thread-12071":["thread",12071],"thread-11760":["thread",11760],"thread-11526":["thread",11526],"thread-11504":["thread",11504],"thread-11452":["thread",11452],"thread-11367":["thread",11367],"thread-11362":["thread",11362],"thread-11110":["thread",11110],"thread-10693":["thread",10693],"thread-9585":["thread",9585],"thread-9210":["thread",9210],"thread-8902":["thread",8902],"thread-8763":["thread",8763],"thread-8730":["thread",8730],"thread-8494":["thread",8494],"thread-7656":["thread",7656],"thread-6934":["thread",6934],"thread-6795":["thread",6795],"thread-6271":["thread",6271],"thread-5145":["thread",5145],"thread-4357":["thread",4357],"thread-4049":["thread",4049],"thread-3823":["thread",3823],"thread-3098":["thread",3098]}, , 1716262116
Run Time: 0.001193
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 221
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1463
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1195
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20