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 (44859, 43430, 43286, 43180, 43128, 43035, 43021, 42990, 42967, 42964, 42898, 42857, 42587, 42406, 42253, 42039, 41751, 41447, 41041, 40978, 40898, 40829, 40818, 40429, 40039, 40034, 39629, 39588, 39587, 39575, 39461, 39404, 39163, 38838, 38809, 38672, 38418, 37810, 37680, 37554, 37511, 37279, 37176, 37063, 37007, 36978, 36688, 36640, 36356, 36125, 36022, 35692, 35473, 35450, 35305, 35126, 35067, 35065, 34830, 34270, 34187, 34159, 33956, 33724, 33650, 33280, 33231, 33184, 33080, 32829, 32653, 32635, 32346, 32289, 32129, 32025, 31960, 31831, 31688, 31251, 31094, 31032, 30862, 30645, 30547, 30344, 30124, 30064, 29849, 29610, 28793, 28751, 28347, 28261, 27931, 27697, 27542, 27482, 27480, 27246, 27170, 27071, 26897, 26837, 26832, 26678, 26590, 26487, 26446, 26418, 26347, 26106, 25925, 25822, 25639, 25570, 25440, 25422, 25271, 24855, 24758, 24627, 24421, 24331, 23801, 23765, 23100, 22887, 22744, 22280, 22088, 21604, 21561, 21515, 21414, 21340, 21337, 21264, 21064, 21063, 21009, 20978, 20389, 20352, 20344, 20140, 20074, 20024, 19758, 19692, 19651, 19601, 19451, 19101, 18827, 18688, 18400, 18260, 18177, 18009, 18008, 17376, 17330, 17148, 16730, 16599, 16277, 16165, 16027, 15947, 15825, 15767, 15717, 15483, 15210, 15013, 15001, 14881, 14617, 14455, 14453, 14296, 14282, 14262, 14259, 14244, 14139, 14086, 14074, 12849, 12567, 12559, 12546, 11678, 11608, 11567, 11471, 11406, 11080, 11052, 11047, 11045, 10969, 10595, 10545, 10505, 10487, 10170, 10168, 9973, 9860, 9857, 9804, 8430, 8341, 8176, 8152, 8044, 8003, 7923, 7864, 7764, 7463, 6843, 6466, 6337, 6181, 6036, 5922, 4981, 4925, 4719, 4209, 4141, 4133, 3296, 2893, 2682, 2139, 2087, 2024, 1740, 1674, 1423, 1397, 1202, 852, 692, 610, 243))
Run Time: 0.082025
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 250 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 2866
- 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 2483
- 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: 103, 0, 1715551209, {"thread-44859":["thread",44859],"thread-43430":["thread",43430],"thread-43286":["thread",43286],"thread-43021":["thread",43021],"thread-42857":["thread",42857],"thread-42587":["thread",42587],"thread-42406":["thread",42406],"thread-42253":["thread",42253],"thread-42039":["thread",42039],"thread-41447":["thread",41447],"thread-41041":["thread",41041],"thread-40978":["thread",40978],"thread-40898":["thread",40898],"thread-40829":["thread",40829],"thread-40429":["thread",40429],"thread-40039":["thread",40039],"thread-40034":["thread",40034],"thread-39629":["thread",39629],"thread-39575":["thread",39575],"thread-39163":["thread",39163],"thread-38838":["thread",38838],"thread-38809":["thread",38809],"thread-38418":["thread",38418],"thread-37680":["thread",37680],"thread-37554":["thread",37554],"thread-37511":["thread",37511],"thread-37279":["thread",37279],"thread-37176":["thread",37176],"thread-37063":["thread",37063],"thread-37007":["thread",37007],"thread-36978":["thread",36978],"thread-36688":["thread",36688],"thread-36640":["thread",36640],"thread-36356":["thread",36356],"thread-36125":["thread",36125],"thread-36022":["thread",36022],"thread-35692":["thread",35692],"thread-35473":["thread",35473],"thread-35450":["thread",35450],"thread-35305":["thread",35305],"thread-35126":["thread",35126],"thread-34830":["thread",34830],"thread-34270":["thread",34270],"thread-34187":["thread",34187],"thread-34159":["thread",34159],"thread-33956":["thread",33956],"thread-33724":["thread",33724],"thread-33650":["thread",33650],"thread-33280":["thread",33280],"thread-33231":["thread",33231],"thread-33080":["thread",33080],"thread-32829":["thread",32829],"thread-32635":["thread",32635],"thread-32346":["thread",32346],"thread-32289":["thread",32289],"thread-32129":["thread",32129],"thread-31831":["thread",31831],"thread-31688":["thread",31688],"thread-31251":["thread",31251],"thread-31094":["thread",31094],"thread-31032":["thread",31032],"thread-30862":["thread",30862],"thread-30645":["thread",30645],"thread-30344":["thread",30344],"thread-30064":["thread",30064],"thread-29849":["thread",29849],"thread-29610":["thread",29610],"thread-28793":["thread",28793],"thread-28751":["thread",28751],"thread-28347":["thread",28347],"thread-28261":["thread",28261],"thread-27931":["thread",27931],"thread-27697":["thread",27697],"thread-27542":["thread",27542],"thread-27246":["thread",27246],"thread-27170":["thread",27170],"thread-26897":["thread",26897],"thread-26837":["thread",26837],"thread-26832":["thread",26832],"thread-26678":["thread",26678],"thread-26590":["thread",26590],"thread-26487":["thread",26487],"thread-26446":["thread",26446],"thread-26418":["thread",26418],"thread-26347":["thread",26347],"thread-25822":["thread",25822],"thread-25639":["thread",25639],"thread-25570":["thread",25570],"thread-25422":["thread",25422],"thread-25271":["thread",25271],"thread-24855":["thread",24855],"thread-24627":["thread",24627],"thread-24421":["thread",24421],"thread-24331":["thread",24331],"thread-23801":["thread",23801],"thread-23765":["thread",23765],"thread-22887":["thread",22887],"thread-22744":["thread",22744],"thread-22280":["thread",22280],"thread-22088":["thread",22088],"thread-21604":["thread",21604],"thread-21561":["thread",21561],"thread-21515":["thread",21515],"thread-21414":["thread",21414],"thread-21340":["thread",21340],"thread-21337":["thread",21337],"thread-21264":["thread",21264],"thread-21063":["thread",21063],"thread-21009":["thread",21009],"thread-20978":["thread",20978],"thread-20389":["thread",20389],"thread-20352":["thread",20352],"thread-20344":["thread",20344],"thread-20140":["thread",20140],"thread-19692":["thread",19692],"thread-19651":["thread",19651],"thread-19601":["thread",19601],"thread-19451":["thread",19451],"thread-19101":["thread",19101],"thread-18827":["thread",18827],"thread-18688":["thread",18688],"thread-18260":["thread",18260],"thread-18177":["thread",18177],"thread-18009":["thread",18009],"thread-18008":["thread",18008],"thread-17376":["thread",17376],"thread-17330":["thread",17330],"thread-17148":["thread",17148],"thread-16730":["thread",16730],"thread-16599":["thread",16599],"thread-16165":["thread",16165],"thread-16027":["thread",16027],"thread-15947":["thread",15947],"thread-15825":["thread",15825],"thread-15767":["thread",15767],"thread-15717":["thread",15717],"thread-15210":["thread",15210],"thread-15013":["thread",15013],"thread-15001":["thread",15001],"thread-14881":["thread",14881],"thread-14455":["thread",14455],"thread-14453":["thread",14453],"thread-14296":["thread",14296],"thread-14282":["thread",14282],"thread-14262":["thread",14262],"thread-14259":["thread",14259],"thread-14244":["thread",14244],"thread-14139":["thread",14139],"thread-14086":["thread",14086],"thread-14074":["thread",14074],"thread-12849":["thread",12849],"thread-12559":["thread",12559],"thread-12546":["thread",12546],"thread-11678":["thread",11678],"thread-11608":["thread",11608],"thread-11567":["thread",11567],"thread-11471":["thread",11471],"thread-11406":["thread",11406],"thread-11080":["thread",11080],"thread-11052":["thread",11052],"thread-11047":["thread",11047],"thread-11045":["thread",11045],"thread-10969":["thread",10969],"thread-10595":["thread",10595],"thread-10545":["thread",10545],"thread-10505":["thread",10505],"thread-10487":["thread",10487],"thread-10170":["thread",10170],"thread-10168":["thread",10168],"thread-9973":["thread",9973],"thread-9860":["thread",9860],"thread-9857":["thread",9857],"thread-9804":["thread",9804],"thread-8430":["thread",8430],"thread-8341":["thread",8341],"thread-8176":["thread",8176],"thread-8152":["thread",8152],"thread-8044":["thread",8044],"thread-8003":["thread",8003],"thread-7923":["thread",7923],"thread-7864":["thread",7864],"thread-7764":["thread",7764],"thread-7463":["thread",7463],"thread-6843":["thread",6843],"thread-6466":["thread",6466],"thread-6337":["thread",6337],"thread-6181":["thread",6181],"thread-6036":["thread",6036],"thread-5922":["thread",5922],"thread-4981":["thread",4981],"thread-4925":["thread",4925],"thread-4719":["thread",4719],"thread-4209":["thread",4209],"thread-4141":["thread",4141],"thread-3296":["thread",3296],"thread-2893":["thread",2893],"thread-2682":["thread",2682],"thread-2087":["thread",2087],"thread-2024":["thread",2024],"thread-1740":["thread",1740],"thread-1674":["thread",1674],"thread-1423":["thread",1423],"thread-1397":["thread",1397],"thread-1202":["thread",1202],"thread-852":["thread",852],"thread-692":["thread",692],"thread-610":["thread",610],"thread-243":["thread",243]}, NULL, 1715547609
Run Time: 0.000557
- 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 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20