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 (183837, 183460, 182207, 181987, 180596, 180577, 180472, 180091, 180015, 179911, 179887, 179648, 179521, 179285, 178922, 178608, 178065, 177867, 177865, 177546, 177434, 177176, 177060, 176631, 176563, 176436, 176321, 176301, 176296, 176294, 176291, 175033, 174966, 174462, 174408, 174392, 173699, 173249, 172283, 172168, 171914, 171804, 171534, 170889, 170665, 170290, 170053, 169755, 169743, 169600, 168706, 167232, 167176, 166189, 166188, 166154, 166152, 165974, 165898, 165644, 165513, 164954, 164468, 164351, 164221, 163276, 163217, 162770, 162059, 161897, 161418, 161253, 161124, 160870, 160395, 159994, 159814, 159555, 158380, 157958, 157819, 157564, 157188, 156641, 156477, 156309, 156238, 156130, 155927, 155906, 155777, 155310, 154690, 154634, 154461, 154189, 153768, 153741, 153692, 153410, 153224, 153136, 153024, 152830, 152641, 152259, 152098, 152013, 151891, 151793, 108426, 77775))
Run Time: 0.048826
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 112 | 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: 15795, 0, 1716728492, {"thread-183837":["thread",183837],"thread-183460":["thread",183460],"thread-182207":["thread",182207],"thread-181987":["thread",181987],"thread-180596":["thread",180596],"thread-180577":["thread",180577],"thread-180472":["thread",180472],"thread-180091":["thread",180091],"thread-180015":["thread",180015],"thread-179911":["thread",179911],"thread-179887":["thread",179887],"thread-179648":["thread",179648],"thread-179521":["thread",179521],"thread-179285":["thread",179285],"thread-178922":["thread",178922],"thread-178608":["thread",178608],"thread-178065":["thread",178065],"thread-177867":["thread",177867],"thread-177865":["thread",177865],"thread-177546":["thread",177546],"thread-177434":["thread",177434],"thread-177176":["thread",177176],"thread-177060":["thread",177060],"thread-176631":["thread",176631],"thread-176563":["thread",176563],"thread-176436":["thread",176436],"thread-176321":["thread",176321],"thread-176301":["thread",176301],"thread-176296":["thread",176296],"thread-176294":["thread",176294],"thread-176291":["thread",176291],"thread-175033":["thread",175033],"thread-174966":["thread",174966],"thread-174462":["thread",174462],"thread-174408":["thread",174408],"thread-174392":["thread",174392],"thread-173699":["thread",173699],"thread-173249":["thread",173249],"thread-172283":["thread",172283],"thread-172168":["thread",172168],"thread-171914":["thread",171914],"thread-171804":["thread",171804],"thread-171534":["thread",171534],"thread-170889":["thread",170889],"thread-170665":["thread",170665],"thread-170290":["thread",170290],"thread-170053":["thread",170053],"thread-169755":["thread",169755],"thread-169743":["thread",169743],"thread-169600":["thread",169600],"thread-168706":["thread",168706],"thread-167232":["thread",167232],"thread-167176":["thread",167176],"thread-166189":["thread",166189],"thread-166188":["thread",166188],"thread-166154":["thread",166154],"thread-166152":["thread",166152],"thread-165974":["thread",165974],"thread-165898":["thread",165898],"thread-165644":["thread",165644],"thread-165513":["thread",165513],"thread-164954":["thread",164954],"thread-164468":["thread",164468],"thread-164351":["thread",164351],"thread-164221":["thread",164221],"thread-163276":["thread",163276],"thread-163217":["thread",163217],"thread-162770":["thread",162770],"thread-162059":["thread",162059],"thread-161897":["thread",161897],"thread-161418":["thread",161418],"thread-161253":["thread",161253],"thread-161124":["thread",161124],"thread-160870":["thread",160870],"thread-160395":["thread",160395],"thread-159994":["thread",159994],"thread-159814":["thread",159814],"thread-159555":["thread",159555],"thread-158380":["thread",158380],"thread-157958":["thread",157958],"thread-157819":["thread",157819],"thread-157564":["thread",157564],"thread-157188":["thread",157188],"thread-156641":["thread",156641],"thread-156477":["thread",156477],"thread-156309":["thread",156309],"thread-156238":["thread",156238],"thread-156130":["thread",156130],"thread-155927":["thread",155927],"thread-155906":["thread",155906],"thread-155777":["thread",155777],"thread-155310":["thread",155310],"thread-154690":["thread",154690],"thread-154634":["thread",154634],"thread-154461":["thread",154461],"thread-154189":["thread",154189],"thread-153768":["thread",153768],"thread-153741":["thread",153741],"thread-153692":["thread",153692],"thread-153410":["thread",153410],"thread-153224":["thread",153224],"thread-153136":["thread",153136],"thread-153024":["thread",153024],"thread-152830":["thread",152830],"thread-152641":["thread",152641],"thread-152098":["thread",152098],"thread-152013":["thread",152013],"thread-151891":["thread",151891],"thread-151793":["thread",151793],"thread-108426":["thread",108426],"thread-77775":["thread",77775]}, , 1716724892
Run Time: 0.000478
- 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