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 (44960, 43561, 42527, 40987, 40034, 39270, 39221, 39022, 38111, 38048, 37215, 36657, 36243, 36223, 35796, 34905, 34483, 34205, 34175, 33975, 33884, 33874, 33417, 33111, 32174, 31940, 31787, 31747, 31705, 31663, 31549, 31463, 31443, 31250, 30749, 30746, 30674, 30672, 30566, 30495, 30220, 30177, 30158, 29867, 29791, 29681, 29559, 29522, 29182, 28525, 28421, 28010, 27933, 27568, 27567, 26736, 26174, 26110, 25679, 25060, 24022, 23968, 23685, 23568, 23237, 22064, 21997, 21941, 19998, 19498, 19030, 18978, 18786, 18783, 18565, 17684, 17674, 17548, 17424, 16653, 16488, 16022, 15575, 14916, 14456, 12047, 12034, 11977, 11842, 11784, 10829, 10538, 8341, 8110, 7705, 7646, 7432, 7372, 6577, 6555, 5585, 5162, 4616, 4146, 3428, 3312, 3273, 2893, 2829, 2690, 2231, 2213, 2061, 2056, 1648, 1326, 959, 794, 682, 676, 662, 625, 576, 569, 279, 122, 65, 3))
Run Time: 0.049806
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 128 | 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: 137, 0, 1711630644, {"thread-44960":["thread",44960],"thread-43561":["thread",43561],"thread-42527":["thread",42527],"thread-40034":["thread",40034],"thread-39270":["thread",39270],"thread-39221":["thread",39221],"thread-39022":["thread",39022],"thread-38111":["thread",38111],"thread-38048":["thread",38048],"thread-37215":["thread",37215],"thread-36657":["thread",36657],"thread-36243":["thread",36243],"thread-36223":["thread",36223],"thread-35796":["thread",35796],"thread-34483":["thread",34483],"thread-34205":["thread",34205],"thread-34175":["thread",34175],"thread-33975":["thread",33975],"thread-33874":["thread",33874],"thread-33417":["thread",33417],"thread-33111":["thread",33111],"thread-32174":["thread",32174],"thread-31940":["thread",31940],"thread-31787":["thread",31787],"thread-31747":["thread",31747],"thread-31705":["thread",31705],"thread-31663":["thread",31663],"thread-31549":["thread",31549],"thread-31463":["thread",31463],"thread-31443":["thread",31443],"thread-31250":["thread",31250],"thread-30746":["thread",30746],"thread-30672":["thread",30672],"thread-30566":["thread",30566],"thread-30495":["thread",30495],"thread-30220":["thread",30220],"thread-30177":["thread",30177],"thread-30158":["thread",30158],"thread-29867":["thread",29867],"thread-29791":["thread",29791],"thread-29681":["thread",29681],"thread-29559":["thread",29559],"thread-29522":["thread",29522],"thread-29182":["thread",29182],"thread-28525":["thread",28525],"thread-28421":["thread",28421],"thread-28010":["thread",28010],"thread-27933":["thread",27933],"thread-27568":["thread",27568],"thread-27567":["thread",27567],"thread-26736":["thread",26736],"thread-26174":["thread",26174],"thread-26110":["thread",26110],"thread-25679":["thread",25679],"thread-25060":["thread",25060],"thread-24022":["thread",24022],"thread-23968":["thread",23968],"thread-23685":["thread",23685],"thread-23568":["thread",23568],"thread-23237":["thread",23237],"thread-22064":["thread",22064],"thread-21997":["thread",21997],"thread-21941":["thread",21941],"thread-19998":["thread",19998],"thread-19498":["thread",19498],"thread-19030":["thread",19030],"thread-18786":["thread",18786],"thread-18783":["thread",18783],"thread-18565":["thread",18565],"thread-17684":["thread",17684],"thread-17674":["thread",17674],"thread-17548":["thread",17548],"thread-16653":["thread",16653],"thread-16488":["thread",16488],"thread-16022":["thread",16022],"thread-15575":["thread",15575],"thread-14916":["thread",14916],"thread-14456":["thread",14456],"thread-12047":["thread",12047],"thread-12034":["thread",12034],"thread-11977":["thread",11977],"thread-11842":["thread",11842],"thread-11784":["thread",11784],"thread-10829":["thread",10829],"thread-10538":["thread",10538],"thread-8341":["thread",8341],"thread-8110":["thread",8110],"thread-7705":["thread",7705],"thread-7646":["thread",7646],"thread-7432":["thread",7432],"thread-7372":["thread",7372],"thread-6577":["thread",6577],"thread-6555":["thread",6555],"thread-5585":["thread",5585],"thread-5162":["thread",5162],"thread-4616":["thread",4616],"thread-4146":["thread",4146],"thread-3428":["thread",3428],"thread-3312":["thread",3312],"thread-3273":["thread",3273],"thread-2893":["thread",2893],"thread-2829":["thread",2829],"thread-2690":["thread",2690],"thread-2231":["thread",2231],"thread-2213":["thread",2213],"thread-2061":["thread",2061],"thread-2056":["thread",2056],"thread-1648":["thread",1648],"thread-1326":["thread",1326],"thread-959":["thread",959],"thread-794":["thread",794],"thread-682":["thread",682],"thread-676":["thread",676],"thread-662":["thread",662],"thread-625":["thread",625],"thread-576":["thread",576],"thread-569":["thread",569],"thread-279":["thread",279],"thread-122":["thread",122],"thread-65":["thread",65],"thread-3":["thread",3]}, NULL, 1711627044
Run Time: 0.001075
- 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