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 (11846, 11173, 11138, 11072, 11071, 10989, 10876, 10818, 10554, 10553, 10546, 10493, 10411, 10069, 9913, 9843, 9627, 9600, 9520, 9500, 9365, 9356, 8747, 8528, 7961, 7154, 7042, 7030, 6960, 6933, 6662, 6319, 6198, 6152, 5931, 5809, 5457, 5453, 5437, 5386, 5369, 5205, 5177, 5168, 5041, 5016, 5008, 4950, 4898, 4788, 4744, 4713, 4553, 4471, 4466, 4349, 4340, 4322, 4307, 4204, 4010, 4001, 3989, 3919, 3896, 3809, 3712, 3632, 3581, 3579, 3568, 3537, 3459, 3376, 3243, 3206, 3195, 3150, 3116, 3087, 3064, 3044, 3037, 3030, 3020, 2988, 2983, 2933, 2892, 2879, 2666, 2652, 2629, 2626, 2595, 2560, 910, 905, 897, 889, 883, 861, 860, 856, 842, 833, 827, 815, 811, 803, 791, 754, 753, 752, 725, 721, 693, 686, 684, 668, 666, 660, 651, 633, 591, 576, 559, 558, 548, 527, 522, 476, 473, 461, 450, 417, 353, 319, 302, 300, 291, 264, 211, 206, 203, 186, 70))
Run Time: 0.004398
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 147 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xencybim.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: 148, 0, 1714622532, {"thread-11846":["thread",11846],"thread-11173":["thread",11173],"thread-11138":["thread",11138],"thread-11072":["thread",11072],"thread-11071":["thread",11071],"thread-10989":["thread",10989],"thread-10876":["thread",10876],"thread-10818":["thread",10818],"thread-10554":["thread",10554],"thread-10553":["thread",10553],"thread-10546":["thread",10546],"thread-10493":["thread",10493],"thread-10411":["thread",10411],"thread-10069":["thread",10069],"thread-9913":["thread",9913],"thread-9843":["thread",9843],"thread-9627":["thread",9627],"thread-9600":["thread",9600],"thread-9520":["thread",9520],"thread-9500":["thread",9500],"thread-9365":["thread",9365],"thread-9356":["thread",9356],"thread-8747":["thread",8747],"thread-8528":["thread",8528],"thread-7961":["thread",7961],"thread-7154":["thread",7154],"thread-7042":["thread",7042],"thread-7030":["thread",7030],"thread-6960":["thread",6960],"thread-6933":["thread",6933],"thread-6662":["thread",6662],"thread-6319":["thread",6319],"thread-6198":["thread",6198],"thread-6152":["thread",6152],"thread-5931":["thread",5931],"thread-5809":["thread",5809],"thread-5457":["thread",5457],"thread-5453":["thread",5453],"thread-5437":["thread",5437],"thread-5386":["thread",5386],"thread-5369":["thread",5369],"thread-5205":["thread",5205],"thread-5177":["thread",5177],"thread-5168":["thread",5168],"thread-5041":["thread",5041],"thread-5016":["thread",5016],"thread-5008":["thread",5008],"thread-4950":["thread",4950],"thread-4898":["thread",4898],"thread-4788":["thread",4788],"thread-4744":["thread",4744],"thread-4713":["thread",4713],"thread-4553":["thread",4553],"thread-4471":["thread",4471],"thread-4466":["thread",4466],"thread-4349":["thread",4349],"thread-4340":["thread",4340],"thread-4322":["thread",4322],"thread-4307":["thread",4307],"thread-4204":["thread",4204],"thread-4010":["thread",4010],"thread-4001":["thread",4001],"thread-3989":["thread",3989],"thread-3919":["thread",3919],"thread-3896":["thread",3896],"thread-3809":["thread",3809],"thread-3712":["thread",3712],"thread-3632":["thread",3632],"thread-3581":["thread",3581],"thread-3579":["thread",3579],"thread-3568":["thread",3568],"thread-3537":["thread",3537],"thread-3459":["thread",3459],"thread-3376":["thread",3376],"thread-3243":["thread",3243],"thread-3206":["thread",3206],"thread-3195":["thread",3195],"thread-3150":["thread",3150],"thread-3116":["thread",3116],"thread-3087":["thread",3087],"thread-3064":["thread",3064],"thread-3044":["thread",3044],"thread-3037":["thread",3037],"thread-3030":["thread",3030],"thread-3020":["thread",3020],"thread-2988":["thread",2988],"thread-2983":["thread",2983],"thread-2933":["thread",2933],"thread-2892":["thread",2892],"thread-2879":["thread",2879],"thread-2666":["thread",2666],"thread-2652":["thread",2652],"thread-2629":["thread",2629],"thread-2626":["thread",2626],"thread-2595":["thread",2595],"thread-2560":["thread",2560],"thread-910":["thread",910],"thread-905":["thread",905],"thread-897":["thread",897],"thread-889":["thread",889],"thread-883":["thread",883],"thread-861":["thread",861],"thread-860":["thread",860],"thread-856":["thread",856],"thread-842":["thread",842],"thread-833":["thread",833],"thread-827":["thread",827],"thread-815":["thread",815],"thread-811":["thread",811],"thread-803":["thread",803],"thread-791":["thread",791],"thread-754":["thread",754],"thread-753":["thread",753],"thread-752":["thread",752],"thread-725":["thread",725],"thread-721":["thread",721],"thread-693":["thread",693],"thread-686":["thread",686],"thread-684":["thread",684],"thread-668":["thread",668],"thread-666":["thread",666],"thread-660":["thread",660],"thread-651":["thread",651],"thread-633":["thread",633],"thread-591":["thread",591],"thread-576":["thread",576],"thread-559":["thread",559],"thread-558":["thread",558],"thread-548":["thread",548],"thread-527":["thread",527],"thread-522":["thread",522],"thread-476":["thread",476],"thread-473":["thread",473],"thread-461":["thread",461],"thread-450":["thread",450],"thread-417":["thread",417],"thread-353":["thread",353],"thread-319":["thread",319],"thread-302":["thread",302],"thread-300":["thread",300],"thread-291":["thread",291],"thread-264":["thread",264],"thread-211":["thread",211],"thread-206":["thread",206],"thread-203":["thread",203],"thread-186":["thread",186],"thread-70":["thread",70]}, , 1714618932
Run Time: 0.000280
- 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