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 (167730, 167594, 154062, 132509, 132503, 122687, 122000, 121967, 121898, 121854, 121836, 121831, 121797, 121596, 121576, 121570, 121520, 113224, 108631, 104765, 104578, 103886, 103655, 103141, 102013, 101913, 101324, 101281, 101170, 101079, 101070, 100997, 100989, 100394, 99724, 99721, 99635, 99526, 99429, 99427, 99041, 99010, 99007, 98989, 98968, 98774, 98746, 98744, 98667, 98660, 98659, 98658, 98641, 98411, 98408, 98336, 98292, 98247, 98245, 98227, 98154, 98119, 98052, 97245, 97231, 97131, 97130, 96291, 95982, 95974, 95927, 95887, 95386, 94548, 94440, 93878, 90946, 90916, 90840, 63032, 62689, 62129, 61689, 56149, 55940, 55840, 54873, 54415, 53561, 53487, 53444, 53379, 52721, 52399, 52076, 51667, 51654, 51643, 51509, 50893, 49687, 49167, 49166, 10279, 5201))
Run Time: 0.094005
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 105 | 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: 1641, 0, 1715406192, {"thread-167730":["thread",167730],"thread-167594":["thread",167594],"ams_article-4421":["ams_article",4421],"thread-154062":["thread",154062],"thread-132509":["thread",132509],"thread-132503":["thread",132503],"thread-122687":["thread",122687],"thread-122000":["thread",122000],"thread-121967":["thread",121967],"thread-121898":["thread",121898],"thread-121854":["thread",121854],"thread-121836":["thread",121836],"thread-121831":["thread",121831],"thread-121797":["thread",121797],"thread-121596":["thread",121596],"thread-121576":["thread",121576],"thread-121570":["thread",121570],"thread-121520":["thread",121520],"thread-113224":["thread",113224],"thread-108631":["thread",108631],"thread-104765":["thread",104765],"thread-104578":["thread",104578],"thread-103886":["thread",103886],"thread-103655":["thread",103655],"thread-103141":["thread",103141],"thread-102013":["thread",102013],"thread-101913":["thread",101913],"thread-101324":["thread",101324],"thread-101281":["thread",101281],"thread-101170":["thread",101170],"thread-101079":["thread",101079],"thread-101070":["thread",101070],"thread-100997":["thread",100997],"thread-100989":["thread",100989],"thread-100394":["thread",100394],"thread-99724":["thread",99724],"thread-99721":["thread",99721],"thread-99635":["thread",99635],"thread-99526":["thread",99526],"thread-99429":["thread",99429],"thread-99427":["thread",99427],"thread-99041":["thread",99041],"thread-99010":["thread",99010],"thread-99007":["thread",99007],"thread-98989":["thread",98989],"thread-98968":["thread",98968],"thread-98774":["thread",98774],"thread-98746":["thread",98746],"thread-98744":["thread",98744],"thread-98667":["thread",98667],"thread-98660":["thread",98660],"thread-98659":["thread",98659],"thread-98658":["thread",98658],"thread-98641":["thread",98641],"thread-98411":["thread",98411],"thread-98408":["thread",98408],"thread-98336":["thread",98336],"thread-98292":["thread",98292],"thread-98247":["thread",98247],"thread-98245":["thread",98245],"thread-98227":["thread",98227],"thread-98154":["thread",98154],"thread-98119":["thread",98119],"thread-98052":["thread",98052],"thread-97245":["thread",97245],"thread-97231":["thread",97231],"thread-97131":["thread",97131],"thread-97130":["thread",97130],"thread-96291":["thread",96291],"thread-95982":["thread",95982],"thread-95974":["thread",95974],"thread-95927":["thread",95927],"thread-95887":["thread",95887],"thread-95386":["thread",95386],"thread-94548":["thread",94548],"thread-94440":["thread",94440],"thread-93878":["thread",93878],"thread-90946":["thread",90946],"thread-90916":["thread",90916],"thread-90840":["thread",90840],"thread-63032":["thread",63032],"thread-62689":["thread",62689],"thread-62129":["thread",62129],"thread-61689":["thread",61689],"thread-56149":["thread",56149],"thread-55940":["thread",55940],"thread-55840":["thread",55840],"thread-54873":["thread",54873],"thread-54415":["thread",54415],"thread-53561":["thread",53561],"thread-53487":["thread",53487],"thread-53444":["thread",53444],"thread-53379":["thread",53379],"thread-52721":["thread",52721],"thread-52399":["thread",52399],"thread-52076":["thread",52076],"thread-51667":["thread",51667],"thread-51654":["thread",51654],"thread-51643":["thread",51643],"thread-51509":["thread",51509],"thread-50893":["thread",50893],"thread-49687":["thread",49687],"thread-49167":["thread",49167],"thread-49166":["thread",49166],"thread-10279":["thread",10279],"thread-5201":["thread",5201]}, , 1715402592
Run Time: 0.000269
- 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