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 (45082, 45063, 45047, 44972, 44881, 44839, 43560, 43558, 43514, 43267, 43221, 43168, 43122, 43003, 42967, 42964, 42903, 42831, 42820, 42274, 42058, 41595, 41573, 41166, 41131, 41125, 40864, 40863, 40798, 40741, 40546, 40544, 40405, 40171, 39882, 39864, 39259, 39239, 39213, 39198, 39195, 39098, 39026, 39005, 39004, 38992, 38580, 38554, 38541, 38363, 38266, 38240, 38083, 38077, 38022, 37843, 37796, 37641, 37523, 37408, 37385, 37176, 36687, 36679, 36658, 36553, 36496, 36488, 36447, 36348, 36125, 35993, 35839, 35283, 35088, 35047, 34962, 34947, 34840, 34816, 34487, 34355, 34336, 34294, 34243, 34157, 34120, 33844, 33669, 33665, 33611, 32890, 32832, 32757, 32678, 32665, 32564, 32457, 32347, 32181, 32028, 31924, 31918, 31669, 31323, 31195, 30697, 30374, 30271, 29640, 29584, 29550, 29441, 29417, 29319, 29277, 29083, 29073, 28928, 28879, 28800, 28698, 28640, 28484, 28460, 28433, 28428, 28116, 28080, 28024, 27999, 27926, 27915, 27673, 27548, 27079, 26921, 26885, 26301, 26228, 25875, 25833, 25785, 25556, 25361, 25191, 24675, 24471, 24271, 24135, 24053, 22537, 21926, 21889, 21504, 21459, 21246, 20955, 20935, 20501, 20373, 19842, 19750, 19636, 19596, 19540, 19500, 19355, 19239, 19211, 19103, 19094, 19090, 18998, 18608, 18088, 18022, 18021, 16758, 16561, 16530, 16523, 16147, 15572, 15252, 15251, 15074, 14935, 14724, 14517, 14365, 14341, 14246, 14026, 12885, 12833, 11994, 11767, 11698, 11113, 10950, 10180, 9986, 9972, 8417, 8385, 8198, 7885, 7680, 7669, 7208, 6718, 6648, 6637, 6576, 6444, 6019, 5870, 5227, 4848, 4787, 4608, 3542, 3367, 3339, 2929, 1504, 1388, 1171, 1043, 894, 521, 331))
Run Time: 0.084474
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 233 | 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: 45, 0, 1714653782, {"thread-45082":["thread",45082],"thread-45063":["thread",45063],"thread-45047":["thread",45047],"thread-44972":["thread",44972],"thread-44881":["thread",44881],"thread-44839":["thread",44839],"thread-43558":["thread",43558],"thread-43514":["thread",43514],"thread-43221":["thread",43221],"thread-43168":["thread",43168],"thread-43122":["thread",43122],"thread-43003":["thread",43003],"thread-42274":["thread",42274],"thread-42058":["thread",42058],"thread-41166":["thread",41166],"thread-41131":["thread",41131],"thread-41125":["thread",41125],"thread-40864":["thread",40864],"thread-40863":["thread",40863],"thread-40544":["thread",40544],"thread-40171":["thread",40171],"thread-39259":["thread",39259],"thread-39239":["thread",39239],"thread-39213":["thread",39213],"thread-39198":["thread",39198],"thread-39195":["thread",39195],"thread-39098":["thread",39098],"thread-39026":["thread",39026],"thread-39005":["thread",39005],"thread-39004":["thread",39004],"thread-38992":["thread",38992],"thread-38580":["thread",38580],"thread-38554":["thread",38554],"thread-38541":["thread",38541],"thread-38363":["thread",38363],"thread-38266":["thread",38266],"thread-38240":["thread",38240],"thread-38083":["thread",38083],"thread-38077":["thread",38077],"thread-37843":["thread",37843],"thread-37796":["thread",37796],"thread-37641":["thread",37641],"thread-37408":["thread",37408],"thread-37385":["thread",37385],"thread-37176":["thread",37176],"thread-36687":["thread",36687],"thread-36553":["thread",36553],"thread-36496":["thread",36496],"thread-36488":["thread",36488],"thread-36447":["thread",36447],"thread-36125":["thread",36125],"thread-35993":["thread",35993],"thread-35839":["thread",35839],"thread-35283":["thread",35283],"thread-35047":["thread",35047],"thread-34962":["thread",34962],"thread-34947":["thread",34947],"thread-34336":["thread",34336],"thread-34243":["thread",34243],"thread-34157":["thread",34157],"thread-34120":["thread",34120],"thread-33844":["thread",33844],"thread-33669":["thread",33669],"thread-33665":["thread",33665],"thread-33611":["thread",33611],"thread-32890":["thread",32890],"thread-32832":["thread",32832],"thread-32757":["thread",32757],"thread-32678":["thread",32678],"thread-32665":["thread",32665],"thread-32564":["thread",32564],"thread-32457":["thread",32457],"thread-32347":["thread",32347],"thread-32028":["thread",32028],"thread-31918":["thread",31918],"thread-31323":["thread",31323],"thread-31195":["thread",31195],"thread-30697":["thread",30697],"thread-30374":["thread",30374],"thread-29584":["thread",29584],"thread-29550":["thread",29550],"thread-29441":["thread",29441],"thread-29417":["thread",29417],"thread-29277":["thread",29277],"thread-29073":["thread",29073],"thread-28879":["thread",28879],"thread-28800":["thread",28800],"thread-28698":["thread",28698],"thread-28640":["thread",28640],"thread-28484":["thread",28484],"thread-28433":["thread",28433],"thread-28428":["thread",28428],"thread-28116":["thread",28116],"thread-28080":["thread",28080],"thread-27999":["thread",27999],"thread-27926":["thread",27926],"thread-27915":["thread",27915],"thread-27548":["thread",27548],"thread-27079":["thread",27079],"thread-26921":["thread",26921],"thread-26301":["thread",26301],"thread-26228":["thread",26228],"thread-25875":["thread",25875],"thread-25833":["thread",25833],"thread-25785":["thread",25785],"thread-25191":["thread",25191],"thread-24471":["thread",24471],"thread-24271":["thread",24271],"thread-24135":["thread",24135],"thread-24053":["thread",24053],"thread-22537":["thread",22537],"thread-21926":["thread",21926],"thread-21889":["thread",21889],"thread-21459":["thread",21459],"thread-21246":["thread",21246],"thread-20955":["thread",20955],"thread-20935":["thread",20935],"thread-20501":["thread",20501],"thread-19842":["thread",19842],"thread-19596":["thread",19596],"thread-19540":["thread",19540],"thread-19500":["thread",19500],"thread-19355":["thread",19355],"thread-19211":["thread",19211],"thread-19103":["thread",19103],"thread-19094":["thread",19094],"thread-19090":["thread",19090],"thread-18998":["thread",18998],"thread-18608":["thread",18608],"thread-18022":["thread",18022],"thread-18021":["thread",18021],"thread-16758":["thread",16758],"thread-16561":["thread",16561],"thread-16530":["thread",16530],"thread-16523":["thread",16523],"thread-16147":["thread",16147],"thread-15572":["thread",15572],"thread-15252":["thread",15252],"thread-14935":["thread",14935],"thread-14724":["thread",14724],"thread-14517":["thread",14517],"thread-14365":["thread",14365],"thread-14246":["thread",14246],"thread-14026":["thread",14026],"thread-12885":["thread",12885],"thread-11994":["thread",11994],"thread-11767":["thread",11767],"thread-11698":["thread",11698],"thread-11113":["thread",11113],"thread-10950":["thread",10950],"thread-10180":["thread",10180],"thread-9986":["thread",9986],"thread-9972":["thread",9972],"thread-8417":["thread",8417],"thread-8385":["thread",8385],"thread-8198":["thread",8198],"thread-7885":["thread",7885],"thread-7680":["thread",7680],"thread-7669":["thread",7669],"thread-7208":["thread",7208],"thread-6718":["thread",6718],"thread-6648":["thread",6648],"thread-6637":["thread",6637],"thread-6576":["thread",6576],"thread-6444":["thread",6444],"thread-6019":["thread",6019],"thread-5870":["thread",5870],"thread-5227":["thread",5227],"thread-4848":["thread",4848],"thread-4787":["thread",4787],"thread-4608":["thread",4608],"thread-3542":["thread",3542],"thread-3367":["thread",3367],"thread-3339":["thread",3339],"thread-2929":["thread",2929],"thread-1388":["thread",1388],"thread-1171":["thread",1171],"thread-1043":["thread",1043],"thread-894":["thread",894],"thread-521":["thread",521],"thread-331":["thread",331]}, NULL, 1714650182
Run Time: 0.000485
- 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