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 (14513, 14297, 14296, 14295, 14096, 13794, 13793, 13726, 13497, 13381, 13214, 13041, 12853, 12828, 12538, 12433, 12085, 12014, 11796, 11726, 11585, 11518, 11517, 11446, 11430, 11383, 11347, 11340, 11295, 11167, 11121, 11080, 11022, 10942, 10899, 10897, 10872, 10794, 10702, 10695, 10685, 10677, 10661, 10649, 10646, 10576, 10550, 10534, 10532, 10521, 10520, 10503, 10482, 10480, 10473, 10468, 10466, 10447, 10444, 10438, 10424, 10423, 10412, 10365, 10364, 10357, 10356, 10261, 10260, 10259, 10207, 10205, 10169, 10157, 10101, 10076, 10043, 10041, 9671, 9337, 9331, 9227, 9202, 9170, 9136, 9073, 8835, 8762, 8669, 8652, 8640, 8615, 8580, 8566, 8565, 8537, 8506, 8502, 8500, 8481, 8462, 8399, 8384, 8350, 8334, 8320, 8271, 8251, 8232, 8209, 8147, 8146, 8053, 7929, 7928, 7871, 7846, 7845, 7839, 7838, 7756, 7742, 6925, 6891, 6699, 6674, 6581, 6570, 6491, 6392, 6388, 6371, 6355, 6278, 6275, 6161, 6156, 6144, 6134, 6106, 6090, 6053, 6037, 6033, 6008, 5942, 5923, 5921, 5918, 5804, 5802, 5777, 5719, 5718, 5710, 5582, 5036, 4971, 4892, 4865, 4809, 4770, 4763, 4451, 4368, 4288, 4210, 4182, 4161, 4134, 4109, 4106, 4105, 4083, 4065, 4049, 4040, 4021, 4017, 4011, 4009, 4008, 4007, 3995, 3987, 3986, 3982, 3981, 3975, 3974, 3973, 3958, 3957, 3956, 3953, 3949, 3948, 3947, 3942, 3939))
Run Time: 0.003319
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 | foru_12.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foru_12.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 31, 0, 1715591926, {"thread-14513":["thread",14513],"thread-14297":["thread",14297],"thread-14296":["thread",14296],"thread-14295":["thread",14295],"thread-14096":["thread",14096],"thread-13794":["thread",13794],"thread-13793":["thread",13793],"thread-13726":["thread",13726],"thread-13497":["thread",13497],"thread-13381":["thread",13381],"thread-13214":["thread",13214],"thread-13041":["thread",13041],"thread-12853":["thread",12853],"thread-12828":["thread",12828],"thread-12538":["thread",12538],"thread-12433":["thread",12433],"thread-12085":["thread",12085],"thread-12014":["thread",12014],"thread-11796":["thread",11796],"thread-11726":["thread",11726],"thread-11585":["thread",11585],"thread-11518":["thread",11518],"thread-11517":["thread",11517],"thread-11446":["thread",11446],"thread-11430":["thread",11430],"thread-11383":["thread",11383],"thread-11347":["thread",11347],"thread-11340":["thread",11340],"thread-11295":["thread",11295],"thread-11167":["thread",11167],"thread-11121":["thread",11121],"thread-11080":["thread",11080],"thread-11022":["thread",11022],"thread-10942":["thread",10942],"thread-10899":["thread",10899],"thread-10897":["thread",10897],"thread-10872":["thread",10872],"thread-10794":["thread",10794],"thread-10685":["thread",10685],"thread-10677":["thread",10677],"thread-10661":["thread",10661],"thread-10649":["thread",10649],"thread-10646":["thread",10646],"thread-10576":["thread",10576],"thread-10550":["thread",10550],"thread-10534":["thread",10534],"thread-10521":["thread",10521],"thread-10520":["thread",10520],"thread-10503":["thread",10503],"thread-10482":["thread",10482],"thread-10480":["thread",10480],"thread-10473":["thread",10473],"thread-10468":["thread",10468],"thread-10466":["thread",10466],"thread-10447":["thread",10447],"thread-10444":["thread",10444],"thread-10438":["thread",10438],"thread-10424":["thread",10424],"thread-10423":["thread",10423],"thread-10412":["thread",10412],"thread-10365":["thread",10365],"thread-10364":["thread",10364],"thread-10357":["thread",10357],"thread-10356":["thread",10356],"thread-10261":["thread",10261],"thread-10260":["thread",10260],"thread-10259":["thread",10259],"thread-10207":["thread",10207],"thread-10205":["thread",10205],"thread-10169":["thread",10169],"thread-10101":["thread",10101],"thread-10076":["thread",10076],"thread-10043":["thread",10043],"thread-10041":["thread",10041],"thread-9671":["thread",9671],"thread-9337":["thread",9337],"thread-9331":["thread",9331],"thread-9227":["thread",9227],"thread-9202":["thread",9202],"thread-9170":["thread",9170],"thread-9136":["thread",9136],"thread-9073":["thread",9073],"thread-8835":["thread",8835],"thread-8762":["thread",8762],"thread-8669":["thread",8669],"thread-8640":["thread",8640],"thread-8615":["thread",8615],"thread-8580":["thread",8580],"thread-8566":["thread",8566],"thread-8565":["thread",8565],"thread-8537":["thread",8537],"thread-8506":["thread",8506],"thread-8502":["thread",8502],"thread-8500":["thread",8500],"thread-8481":["thread",8481],"thread-8462":["thread",8462],"thread-8399":["thread",8399],"thread-8384":["thread",8384],"thread-8350":["thread",8350],"thread-8334":["thread",8334],"thread-8320":["thread",8320],"thread-8271":["thread",8271],"thread-8251":["thread",8251],"thread-8232":["thread",8232],"thread-8209":["thread",8209],"thread-8147":["thread",8147],"thread-8146":["thread",8146],"thread-8053":["thread",8053],"thread-7929":["thread",7929],"thread-7928":["thread",7928],"thread-7871":["thread",7871],"thread-7846":["thread",7846],"thread-7845":["thread",7845],"thread-7839":["thread",7839],"thread-7838":["thread",7838],"thread-7756":["thread",7756],"thread-7742":["thread",7742],"thread-6925":["thread",6925],"thread-6891":["thread",6891],"thread-6699":["thread",6699],"thread-6674":["thread",6674],"thread-6581":["thread",6581],"thread-6570":["thread",6570],"thread-6491":["thread",6491],"thread-6392":["thread",6392],"thread-6388":["thread",6388],"thread-6371":["thread",6371],"thread-6355":["thread",6355],"thread-6278":["thread",6278],"thread-6275":["thread",6275],"thread-6161":["thread",6161],"thread-6156":["thread",6156],"thread-6134":["thread",6134],"thread-6106":["thread",6106],"thread-6090":["thread",6090],"thread-6053":["thread",6053],"thread-6037":["thread",6037],"thread-6033":["thread",6033],"thread-6008":["thread",6008],"thread-5942":["thread",5942],"thread-5923":["thread",5923],"thread-5921":["thread",5921],"thread-5918":["thread",5918],"thread-5804":["thread",5804],"thread-5802":["thread",5802],"thread-5777":["thread",5777],"thread-5719":["thread",5719],"thread-5710":["thread",5710],"thread-5582":["thread",5582],"thread-5036":["thread",5036],"thread-4971":["thread",4971],"thread-4892":["thread",4892],"thread-4865":["thread",4865],"thread-4809":["thread",4809],"thread-4770":["thread",4770],"thread-4763":["thread",4763],"thread-4451":["thread",4451],"thread-4368":["thread",4368],"thread-4288":["thread",4288],"thread-4210":["thread",4210],"thread-4182":["thread",4182],"thread-4161":["thread",4161],"thread-4134":["thread",4134],"thread-4109":["thread",4109],"thread-4106":["thread",4106],"thread-4105":["thread",4105],"thread-4083":["thread",4083],"thread-4065":["thread",4065],"thread-4049":["thread",4049],"thread-4040":["thread",4040],"thread-4021":["thread",4021],"thread-4017":["thread",4017],"thread-4011":["thread",4011],"thread-4009":["thread",4009],"thread-4008":["thread",4008],"thread-4007":["thread",4007],"thread-3995":["thread",3995],"thread-3987":["thread",3987],"thread-3986":["thread",3986],"thread-3982":["thread",3982],"thread-3981":["thread",3981],"thread-3975":["thread",3975],"thread-3974":["thread",3974],"thread-3973":["thread",3973],"thread-3958":["thread",3958],"thread-3957":["thread",3957],"thread-3956":["thread",3956],"thread-3953":["thread",3953],"thread-3949":["thread",3949],"thread-3948":["thread",3948],"thread-3947":["thread",3947],"thread-3942":["thread",3942],"thread-3939":["thread",3939]}, NULL, 1715588326
Run Time: 0.000386
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20