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 (176691, 168714, 167189, 164330, 164329, 155078, 155039, 155020, 155019, 154977, 154971, 154969, 154961, 154945, 154944, 154927, 154922, 154914, 154895, 154894, 154874, 154872, 154842, 154834, 154829, 154826, 154791, 154778, 154771, 154770, 154763, 154744, 154743, 154720, 154714, 154697, 154694, 154686, 154685, 154684, 154675, 154673, 154670, 154668, 154666, 154661, 154645, 154634, 154614, 154602, 154594, 154593, 154591, 154590, 154584, 154577, 154572, 154568, 154515, 154508, 154501, 154478, 154457, 154453, 154448, 154428, 154422, 154413, 154412, 154395, 154388, 154361, 154359, 154342, 154336, 154329, 154327, 154318, 154292, 154282, 154281, 154280, 154259, 154250, 154245, 154222, 154215, 154202, 154193, 154192, 154189, 154168, 154147, 154145, 154119, 154114, 154112, 154089, 154085, 154080, 154078, 154068, 154035, 154032, 154024, 153999, 153963, 153927, 153922, 153918, 153908, 153907, 153902, 153898, 153895, 153893, 153885, 153869, 153861, 153858, 153857, 153854, 153842, 153826, 153801, 153793, 153792, 153768, 153751, 153750, 153726, 153720, 153711, 153710, 153692, 153689, 153685, 153680, 153674, 153660, 153655, 153626, 153610, 153597, 153587, 153579, 153569, 153544, 153543, 153522, 153518, 153514, 153503, 153497, 153489, 153487, 153473, 153435, 153430, 153419, 153407, 153406, 153362, 153311, 153305, 153299, 153280, 153273, 153252, 153251, 153247, 153245, 153227, 153226, 153223, 153210, 153206, 153193, 153190, 153187, 153170, 153161, 153156, 153135, 153126, 153117, 153107, 153096, 153090, 153074, 153064, 153062, 153061, 153060, 153044, 153041, 153039, 153029, 153021, 153013))
Run Time: 0.120487
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 2408, 0, 1714807864, {"thread-176691":["thread",176691],"thread-168714":["thread",168714],"thread-167189":["thread",167189],"thread-164330":["thread",164330],"thread-164329":["thread",164329],"thread-155078":["thread",155078],"thread-155039":["thread",155039],"thread-155020":["thread",155020],"thread-155019":["thread",155019],"thread-154977":["thread",154977],"thread-154971":["thread",154971],"thread-154969":["thread",154969],"thread-154961":["thread",154961],"thread-154945":["thread",154945],"thread-154944":["thread",154944],"thread-154927":["thread",154927],"thread-154922":["thread",154922],"thread-154914":["thread",154914],"thread-154895":["thread",154895],"thread-154894":["thread",154894],"thread-154874":["thread",154874],"thread-154872":["thread",154872],"thread-154842":["thread",154842],"thread-154834":["thread",154834],"thread-154829":["thread",154829],"thread-154826":["thread",154826],"thread-154791":["thread",154791],"thread-154778":["thread",154778],"thread-154771":["thread",154771],"thread-154770":["thread",154770],"thread-154763":["thread",154763],"thread-154744":["thread",154744],"thread-154743":["thread",154743],"thread-154720":["thread",154720],"thread-154697":["thread",154697],"thread-154694":["thread",154694],"thread-154686":["thread",154686],"thread-154685":["thread",154685],"thread-154684":["thread",154684],"thread-154675":["thread",154675],"thread-154673":["thread",154673],"thread-154670":["thread",154670],"thread-154668":["thread",154668],"thread-154666":["thread",154666],"thread-154661":["thread",154661],"thread-154645":["thread",154645],"thread-154634":["thread",154634],"thread-154614":["thread",154614],"thread-154602":["thread",154602],"thread-154594":["thread",154594],"thread-154593":["thread",154593],"thread-154591":["thread",154591],"thread-154590":["thread",154590],"thread-154584":["thread",154584],"thread-154577":["thread",154577],"thread-154572":["thread",154572],"thread-154568":["thread",154568],"thread-154515":["thread",154515],"thread-154508":["thread",154508],"thread-154501":["thread",154501],"thread-154478":["thread",154478],"thread-154457":["thread",154457],"thread-154453":["thread",154453],"thread-154448":["thread",154448],"thread-154428":["thread",154428],"thread-154413":["thread",154413],"thread-154412":["thread",154412],"thread-154395":["thread",154395],"thread-154388":["thread",154388],"thread-154361":["thread",154361],"thread-154359":["thread",154359],"thread-154342":["thread",154342],"thread-154336":["thread",154336],"thread-154329":["thread",154329],"thread-154327":["thread",154327],"thread-154318":["thread",154318],"thread-154292":["thread",154292],"thread-154282":["thread",154282],"thread-154281":["thread",154281],"thread-154280":["thread",154280],"thread-154259":["thread",154259],"thread-154250":["thread",154250],"thread-154245":["thread",154245],"thread-154222":["thread",154222],"thread-154215":["thread",154215],"thread-154202":["thread",154202],"thread-154193":["thread",154193],"thread-154192":["thread",154192],"thread-154189":["thread",154189],"thread-154168":["thread",154168],"thread-154147":["thread",154147],"thread-154145":["thread",154145],"thread-154119":["thread",154119],"thread-154114":["thread",154114],"thread-154112":["thread",154112],"thread-154085":["thread",154085],"thread-154080":["thread",154080],"thread-154078":["thread",154078],"thread-154068":["thread",154068],"thread-154035":["thread",154035],"thread-154032":["thread",154032],"thread-154024":["thread",154024],"thread-153999":["thread",153999],"thread-153963":["thread",153963],"thread-153927":["thread",153927],"thread-153922":["thread",153922],"thread-153918":["thread",153918],"thread-153908":["thread",153908],"thread-153907":["thread",153907],"thread-153902":["thread",153902],"thread-153898":["thread",153898],"thread-153895":["thread",153895],"thread-153893":["thread",153893],"thread-153885":["thread",153885],"thread-153869":["thread",153869],"thread-153861":["thread",153861],"thread-153858":["thread",153858],"thread-153854":["thread",153854],"thread-153842":["thread",153842],"thread-153826":["thread",153826],"thread-153801":["thread",153801],"thread-153793":["thread",153793],"thread-153792":["thread",153792],"thread-153768":["thread",153768],"thread-153751":["thread",153751],"thread-153750":["thread",153750],"thread-153726":["thread",153726],"thread-153720":["thread",153720],"thread-153711":["thread",153711],"thread-153710":["thread",153710],"thread-153692":["thread",153692],"thread-153689":["thread",153689],"thread-153685":["thread",153685],"thread-153680":["thread",153680],"thread-153674":["thread",153674],"thread-153660":["thread",153660],"thread-153655":["thread",153655],"thread-153610":["thread",153610],"thread-153597":["thread",153597],"thread-153587":["thread",153587],"thread-153579":["thread",153579],"thread-153569":["thread",153569],"thread-153544":["thread",153544],"thread-153543":["thread",153543],"thread-153518":["thread",153518],"thread-153497":["thread",153497],"thread-153489":["thread",153489],"thread-153487":["thread",153487],"thread-153473":["thread",153473],"thread-153435":["thread",153435],"thread-153430":["thread",153430],"thread-153419":["thread",153419],"thread-153407":["thread",153407],"thread-153406":["thread",153406],"thread-153362":["thread",153362],"thread-153311":["thread",153311],"thread-153305":["thread",153305],"thread-153299":["thread",153299],"thread-153280":["thread",153280],"thread-153273":["thread",153273],"thread-153252":["thread",153252],"thread-153251":["thread",153251],"thread-153247":["thread",153247],"thread-153245":["thread",153245],"thread-153227":["thread",153227],"thread-153226":["thread",153226],"thread-153223":["thread",153223],"thread-153210":["thread",153210],"thread-153206":["thread",153206],"thread-153193":["thread",153193],"thread-153190":["thread",153190],"thread-153187":["thread",153187],"thread-153170":["thread",153170],"thread-153161":["thread",153161],"thread-153156":["thread",153156],"thread-153135":["thread",153135],"thread-153126":["thread",153126],"thread-153117":["thread",153117],"thread-153107":["thread",153107],"thread-153096":["thread",153096],"thread-153090":["thread",153090],"thread-153074":["thread",153074],"thread-153064":["thread",153064],"thread-153062":["thread",153062],"thread-153061":["thread",153061],"thread-153060":["thread",153060],"thread-153044":["thread",153044],"thread-153041":["thread",153041],"thread-153039":["thread",153039],"thread-153029":["thread",153029],"thread-153021":["thread",153021],"thread-153013":["thread",153013]}, , 1714804264
Run Time: 0.000445
- 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