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 (183202, 182752, 182314, 182054, 181482, 181274, 180998, 179870, 179644, 179635, 179093, 178735, 178270, 177670, 177257, 177114, 176996, 176629, 176618, 176334, 176184, 175958, 175813, 175616, 175605, 175566, 175560, 175095, 175001, 174112, 171465, 170181, 169856, 169473, 169302, 166991, 166618, 166592, 166524, 166009, 165780, 165599, 165311, 164210, 164198, 164184, 163630, 163293, 162464, 162437, 162224, 161936, 161728, 160647, 160201, 160114, 159881, 159726, 158721, 157795, 157387, 156548, 155075, 154272, 153678, 153300, 152479, 152263, 89902, 78295, 69798, 49609, 37800, 31100))
Run Time: 0.035777
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 74 | 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: 4277, 0, 1716038574, {"thread-183202":["thread",183202],"thread-182752":["thread",182752],"thread-182314":["thread",182314],"thread-182054":["thread",182054],"thread-181482":["thread",181482],"thread-181274":["thread",181274],"thread-180998":["thread",180998],"thread-179870":["thread",179870],"thread-179644":["thread",179644],"thread-179635":["thread",179635],"thread-179093":["thread",179093],"thread-178735":["thread",178735],"thread-178270":["thread",178270],"thread-177670":["thread",177670],"thread-177257":["thread",177257],"thread-177114":["thread",177114],"thread-176996":["thread",176996],"thread-176629":["thread",176629],"thread-176618":["thread",176618],"thread-176334":["thread",176334],"thread-176184":["thread",176184],"thread-175958":["thread",175958],"thread-175813":["thread",175813],"thread-175616":["thread",175616],"thread-175605":["thread",175605],"thread-175566":["thread",175566],"thread-175560":["thread",175560],"thread-175095":["thread",175095],"thread-175001":["thread",175001],"thread-174112":["thread",174112],"thread-171465":["thread",171465],"thread-170181":["thread",170181],"thread-169856":["thread",169856],"thread-169473":["thread",169473],"thread-169302":["thread",169302],"thread-166991":["thread",166991],"thread-166618":["thread",166618],"thread-166592":["thread",166592],"thread-166524":["thread",166524],"thread-166009":["thread",166009],"thread-165780":["thread",165780],"thread-165599":["thread",165599],"thread-165311":["thread",165311],"thread-164210":["thread",164210],"thread-164198":["thread",164198],"thread-164184":["thread",164184],"thread-163630":["thread",163630],"thread-163293":["thread",163293],"thread-162464":["thread",162464],"thread-162437":["thread",162437],"thread-162224":["thread",162224],"thread-161936":["thread",161936],"thread-161728":["thread",161728],"thread-160647":["thread",160647],"thread-160201":["thread",160201],"thread-160114":["thread",160114],"thread-159881":["thread",159881],"thread-159726":["thread",159726],"thread-158721":["thread",158721],"thread-157795":["thread",157795],"thread-157387":["thread",157387],"thread-156548":["thread",156548],"thread-155075":["thread",155075],"thread-154272":["thread",154272],"thread-153678":["thread",153678],"thread-153300":["thread",153300],"thread-152479":["thread",152479],"thread-152263":["thread",152263],"thread-89902":["thread",89902],"thread-78295":["thread",78295],"thread-69798":["thread",69798],"thread-49609":["thread",49609],"thread-37800":["thread",37800],"thread-31100":["thread",31100]}, , 1716034974
Run Time: 0.000158
- 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