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 (45054, 44943, 43554, 43472, 43450, 43381, 43210, 43195, 43187, 42873, 42833, 42574, 42571, 42510, 42463, 42449, 42419, 42340, 42322, 42268, 41996, 41969, 41612, 41312, 41302, 41067, 40952, 40880, 40762, 40455, 40360, 39694, 39296, 39227, 39160, 39050, 39004, 38709, 38561, 38547, 38259, 37582, 37203, 37080, 36959, 36740, 36551, 36511, 36020, 35888, 35839, 35763, 35656, 34765, 34636, 34491, 34083, 34055, 33992, 33800, 33275, 33035, 33029, 32649, 32423, 32145, 32110, 31843, 31631, 31441, 31334, 31238, 31172, 30901, 30880, 30226, 30223, 30159, 30070, 29997, 29936, 29922, 29740, 29633, 29566, 29260, 29099, 29054, 28879, 28677, 28624, 28552, 28467, 28431, 28362, 28322, 28016, 27933, 27746, 27457, 27224, 27119, 26914, 26872, 26817, 26769, 26389, 26080, 26063, 25595, 25223, 24841, 24565, 24226, 23797, 23499, 23236, 23110, 23043, 22352, 21438, 21308, 21305, 20972, 19872, 19838, 19755, 19693, 19507, 19500, 19461, 19369, 19317, 19263, 19174, 19117, 19107, 17600, 16725, 16638, 15991, 15466, 14981, 14397, 14048, 13755, 13294, 12930, 12294, 12235, 12046, 11886, 11790, 11312, 10842, 10841, 8515, 7744, 7363, 9657, 7062, 6836, 6482, 5415, 4706, 4340, 3851, 3242, 2914, 2866, 1339, 869))
Run Time: 0.072351
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 172 | 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: 132, 0, 1716173582, {"thread-45054":["thread",45054],"thread-44943":["thread",44943],"thread-43554":["thread",43554],"thread-43472":["thread",43472],"thread-43450":["thread",43450],"thread-43210":["thread",43210],"thread-43195":["thread",43195],"thread-42833":["thread",42833],"thread-42571":["thread",42571],"thread-42510":["thread",42510],"thread-42463":["thread",42463],"thread-42449":["thread",42449],"thread-42419":["thread",42419],"thread-42340":["thread",42340],"thread-42322":["thread",42322],"thread-42268":["thread",42268],"thread-41996":["thread",41996],"thread-41969":["thread",41969],"thread-41612":["thread",41612],"thread-41312":["thread",41312],"thread-41302":["thread",41302],"thread-41067":["thread",41067],"thread-40952":["thread",40952],"thread-40880":["thread",40880],"thread-40455":["thread",40455],"thread-40360":["thread",40360],"thread-39694":["thread",39694],"thread-39296":["thread",39296],"thread-39227":["thread",39227],"thread-39050":["thread",39050],"thread-39004":["thread",39004],"thread-38709":["thread",38709],"thread-38547":["thread",38547],"thread-37582":["thread",37582],"thread-37203":["thread",37203],"thread-37080":["thread",37080],"thread-36740":["thread",36740],"thread-36551":["thread",36551],"thread-36511":["thread",36511],"thread-36020":["thread",36020],"thread-35888":["thread",35888],"thread-35839":["thread",35839],"thread-35763":["thread",35763],"thread-35656":["thread",35656],"thread-34636":["thread",34636],"thread-34491":["thread",34491],"thread-34083":["thread",34083],"thread-34055":["thread",34055],"thread-33992":["thread",33992],"thread-33800":["thread",33800],"thread-33275":["thread",33275],"thread-33035":["thread",33035],"thread-33029":["thread",33029],"thread-32649":["thread",32649],"thread-32145":["thread",32145],"thread-32110":["thread",32110],"thread-31631":["thread",31631],"thread-31334":["thread",31334],"thread-31172":["thread",31172],"thread-30901":["thread",30901],"thread-30880":["thread",30880],"thread-30226":["thread",30226],"thread-30223":["thread",30223],"thread-30159":["thread",30159],"thread-29997":["thread",29997],"thread-29936":["thread",29936],"thread-29922":["thread",29922],"thread-29740":["thread",29740],"thread-29566":["thread",29566],"thread-29260":["thread",29260],"thread-29099":["thread",29099],"thread-29054":["thread",29054],"thread-28879":["thread",28879],"thread-28624":["thread",28624],"thread-28552":["thread",28552],"thread-28431":["thread",28431],"thread-28362":["thread",28362],"thread-28322":["thread",28322],"thread-28016":["thread",28016],"thread-27933":["thread",27933],"thread-27746":["thread",27746],"thread-27457":["thread",27457],"thread-27224":["thread",27224],"thread-27119":["thread",27119],"thread-26914":["thread",26914],"thread-26817":["thread",26817],"thread-26769":["thread",26769],"thread-26080":["thread",26080],"thread-25595":["thread",25595],"thread-25223":["thread",25223],"thread-24841":["thread",24841],"thread-24565":["thread",24565],"thread-24226":["thread",24226],"thread-23797":["thread",23797],"thread-23499":["thread",23499],"thread-23236":["thread",23236],"thread-23110":["thread",23110],"thread-23043":["thread",23043],"thread-22352":["thread",22352],"thread-21438":["thread",21438],"thread-21308":["thread",21308],"thread-21305":["thread",21305],"thread-20972":["thread",20972],"thread-19872":["thread",19872],"thread-19838":["thread",19838],"thread-19755":["thread",19755],"thread-19507":["thread",19507],"thread-19500":["thread",19500],"thread-19461":["thread",19461],"thread-19369":["thread",19369],"thread-19317":["thread",19317],"thread-19263":["thread",19263],"thread-19174":["thread",19174],"thread-19117":["thread",19117],"thread-19107":["thread",19107],"thread-17600":["thread",17600],"thread-16725":["thread",16725],"thread-16638":["thread",16638],"thread-15991":["thread",15991],"thread-15466":["thread",15466],"thread-14981":["thread",14981],"thread-14397":["thread",14397],"thread-14048":["thread",14048],"thread-13755":["thread",13755],"thread-13294":["thread",13294],"thread-12930":["thread",12930],"thread-12294":["thread",12294],"thread-12235":["thread",12235],"thread-12046":["thread",12046],"thread-11886":["thread",11886],"thread-11790":["thread",11790],"thread-10842":["thread",10842],"thread-10841":["thread",10841],"thread-8515":["thread",8515],"thread-7744":["thread",7744],"thread-7363":["thread",7363],"thread-7062":["thread",7062],"thread-6836":["thread",6836],"thread-6482":["thread",6482],"thread-5415":["thread",5415],"thread-4706":["thread",4706],"thread-4340":["thread",4340],"thread-3851":["thread",3851],"thread-3242":["thread",3242],"thread-2914":["thread",2914],"thread-2866":["thread",2866],"thread-1339":["thread",1339],"thread-869":["thread",869]}, NULL, 1716169982
Run Time: 0.001279
- 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