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 (44894, 43633, 43535, 43331, 43294, 43177, 42986, 42837, 42745, 42734, 42731, 42521, 42390, 42375, 42342, 42307, 42085, 41823, 41740, 41600, 41321, 41307, 41276, 41119, 41110, 40884, 40607, 40587, 40521, 40386, 40221, 40182, 39929, 39685, 39264, 38871, 38596, 38561, 38358, 37921, 37797, 37249, 36968, 36819, 36521, 36511, 36416, 36243, 36139, 35958, 35353, 35328, 35062, 34898, 34834, 34731, 34491, 34093, 34084, 34064, 33989, 33977, 33758, 33314, 32900, 32884, 32836, 32681, 32410, 32240, 32235, 32026, 31665, 31576, 31141, 31132, 30962, 30922, 30835, 29429, 29252, 29008, 28809, 28672, 28651, 28558, 28499, 28108, 28098, 27873, 27679, 27663, 27540, 27398, 27139, 26949, 26945, 26944, 26912, 26739, 26597, 26402, 26350, 26336, 26025, 25962, 25843, 25730, 25706, 25461, 25330, 25156, 25013, 24982, 24948, 24921, 24318, 24133, 24128, 24055, 23229, 22223, 22041, 21834, 20415, 19614, 17255, 16704, 15171, 15164, 15045, 15044, 14736, 14390, 12540, 12507, 12125, 12078, 11177, 11088, 10779, 18655, 10167, 9875, 3441, 2914, 281, 83))
Run Time: 0.059483
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 148 | 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: 83, 0, 1716090662, {"thread-44894":["thread",44894],"thread-43331":["thread",43331],"thread-43294":["thread",43294],"thread-43177":["thread",43177],"thread-42986":["thread",42986],"thread-42837":["thread",42837],"thread-42745":["thread",42745],"thread-42734":["thread",42734],"thread-42731":["thread",42731],"thread-42521":["thread",42521],"thread-42307":["thread",42307],"thread-42085":["thread",42085],"thread-41823":["thread",41823],"thread-41740":["thread",41740],"thread-41600":["thread",41600],"thread-41321":["thread",41321],"thread-41307":["thread",41307],"thread-41276":["thread",41276],"thread-41119":["thread",41119],"thread-41110":["thread",41110],"thread-40884":["thread",40884],"thread-40607":["thread",40607],"thread-40587":["thread",40587],"thread-40521":["thread",40521],"thread-40386":["thread",40386],"thread-40221":["thread",40221],"thread-39929":["thread",39929],"thread-39685":["thread",39685],"thread-39264":["thread",39264],"thread-38871":["thread",38871],"thread-38358":["thread",38358],"thread-37921":["thread",37921],"thread-37797":["thread",37797],"thread-37249":["thread",37249],"thread-36968":["thread",36968],"thread-36819":["thread",36819],"thread-36521":["thread",36521],"thread-36511":["thread",36511],"thread-36416":["thread",36416],"thread-36243":["thread",36243],"thread-36139":["thread",36139],"thread-35958":["thread",35958],"thread-35353":["thread",35353],"thread-35328":["thread",35328],"thread-35062":["thread",35062],"thread-34898":["thread",34898],"thread-34834":["thread",34834],"thread-34731":["thread",34731],"thread-34491":["thread",34491],"thread-34093":["thread",34093],"thread-34084":["thread",34084],"thread-34064":["thread",34064],"thread-33989":["thread",33989],"thread-33977":["thread",33977],"thread-33758":["thread",33758],"thread-33314":["thread",33314],"thread-32900":["thread",32900],"thread-32884":["thread",32884],"thread-32836":["thread",32836],"thread-32681":["thread",32681],"thread-32410":["thread",32410],"thread-32240":["thread",32240],"thread-32235":["thread",32235],"thread-32026":["thread",32026],"thread-31665":["thread",31665],"thread-31576":["thread",31576],"thread-31141":["thread",31141],"thread-31132":["thread",31132],"thread-30962":["thread",30962],"thread-30922":["thread",30922],"thread-30835":["thread",30835],"thread-29429":["thread",29429],"thread-29252":["thread",29252],"thread-29008":["thread",29008],"thread-28809":["thread",28809],"thread-28651":["thread",28651],"thread-28558":["thread",28558],"thread-28499":["thread",28499],"thread-28108":["thread",28108],"thread-28098":["thread",28098],"thread-27873":["thread",27873],"thread-27679":["thread",27679],"thread-27663":["thread",27663],"thread-27540":["thread",27540],"thread-27398":["thread",27398],"thread-27139":["thread",27139],"thread-26949":["thread",26949],"thread-26945":["thread",26945],"thread-26944":["thread",26944],"thread-26912":["thread",26912],"thread-26739":["thread",26739],"thread-26597":["thread",26597],"thread-26402":["thread",26402],"thread-26350":["thread",26350],"thread-26336":["thread",26336],"thread-26025":["thread",26025],"thread-25962":["thread",25962],"thread-25843":["thread",25843],"thread-25730":["thread",25730],"thread-25706":["thread",25706],"thread-25461":["thread",25461],"thread-25156":["thread",25156],"thread-25013":["thread",25013],"thread-24982":["thread",24982],"thread-24948":["thread",24948],"thread-24921":["thread",24921],"thread-24318":["thread",24318],"thread-24133":["thread",24133],"thread-24128":["thread",24128],"thread-24055":["thread",24055],"thread-23229":["thread",23229],"thread-22223":["thread",22223],"thread-22041":["thread",22041],"thread-21834":["thread",21834],"thread-20415":["thread",20415],"thread-19614":["thread",19614],"thread-17255":["thread",17255],"thread-16704":["thread",16704],"thread-15171":["thread",15171],"thread-15164":["thread",15164],"thread-15045":["thread",15045],"thread-15044":["thread",15044],"thread-14736":["thread",14736],"thread-14390":["thread",14390],"thread-12540":["thread",12540],"thread-12507":["thread",12507],"thread-12125":["thread",12125],"thread-12078":["thread",12078],"thread-11177":["thread",11177],"thread-11088":["thread",11088],"thread-10779":["thread",10779],"thread-18655":["thread",18655],"thread-10167":["thread",10167],"thread-9875":["thread",9875],"thread-3441":["thread",3441],"thread-2914":["thread",2914],"thread-281":["thread",281],"thread-83":["thread",83]}, NULL, 1716087062
Run Time: 0.002754
- 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