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 (45047, 45046, 44966, 44938, 44919, 44851, 43628, 43223, 43110, 43109, 43005, 42882, 42880, 42831, 42783, 42755, 42683, 42577, 42518, 42397, 42391, 42320, 42291, 42079, 41837, 41822, 41129, 40960, 40902, 40894, 40492, 40427, 40256, 40198, 40112, 39859, 39662, 39195, 38985, 38941, 38801, 38082, 37630, 37544, 37488, 37424, 37419, 37300, 37286, 36890, 36876, 36775, 36774, 36591, 35879, 35868, 35333, 35295, 35215, 34995, 34362, 34336, 34279, 33835, 33730, 33127, 33000, 32931, 32914, 32735, 32250, 31584, 31161, 31026, 30670, 30669, 30668, 30667, 30641, 30634, 30542, 30316, 30310, 30193, 29891, 29635, 29471, 29430, 29220, 28909, 28451, 27921, 27876, 27867, 27506, 27247, 27088, 26809, 26395, 26046, 26004, 25913, 25478, 25102, 24966, 24862, 24209, 24138, 23793, 23467, 22917, 22551, 22215, 22004, 21863, 21745, 21733, 21395, 21019, 20172, 20100, 20077, 19968, 19672, 18470, 18386, 17719, 16366, 16238, 15468, 15031, 14842, 14739, 14578, 14265, 12939, 12133, 11950, 11791, 11784, 11402, 10867, 10691, 9936, 8433, 8413, 8329, 8312, 7837, 7788, 7735, 6924, 6509, 6498, 6490, 6287, 5919, 5849, 5622, 5533, 5075, 4805, 4780, 4724, 4657, 4646, 4255, 4151, 3554, 3265, 2868, 2712, 2305, 2213, 1835, 1758, 1594, 229))
Run Time: 0.067675
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 178 | 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: 444, 0, 1715464272, {"thread-45047":["thread",45047],"thread-45046":["thread",45046],"thread-44966":["thread",44966],"thread-44938":["thread",44938],"thread-43628":["thread",43628],"thread-43223":["thread",43223],"thread-43110":["thread",43110],"thread-43109":["thread",43109],"thread-43005":["thread",43005],"thread-42882":["thread",42882],"thread-42755":["thread",42755],"thread-42683":["thread",42683],"thread-42577":["thread",42577],"thread-42397":["thread",42397],"thread-42391":["thread",42391],"thread-42320":["thread",42320],"thread-42291":["thread",42291],"thread-42079":["thread",42079],"thread-41822":["thread",41822],"thread-41129":["thread",41129],"thread-40960":["thread",40960],"thread-40902":["thread",40902],"thread-40894":["thread",40894],"thread-40492":["thread",40492],"thread-40427":["thread",40427],"thread-40256":["thread",40256],"thread-40198":["thread",40198],"thread-40112":["thread",40112],"thread-39859":["thread",39859],"thread-39662":["thread",39662],"thread-39195":["thread",39195],"thread-38985":["thread",38985],"thread-38941":["thread",38941],"thread-38801":["thread",38801],"thread-38082":["thread",38082],"thread-37630":["thread",37630],"thread-37544":["thread",37544],"thread-37488":["thread",37488],"thread-37424":["thread",37424],"thread-37419":["thread",37419],"thread-37300":["thread",37300],"thread-36890":["thread",36890],"thread-36876":["thread",36876],"thread-36775":["thread",36775],"thread-36774":["thread",36774],"thread-36591":["thread",36591],"thread-35879":["thread",35879],"thread-35868":["thread",35868],"thread-35333":["thread",35333],"thread-35295":["thread",35295],"thread-35215":["thread",35215],"thread-34995":["thread",34995],"thread-34362":["thread",34362],"thread-34336":["thread",34336],"thread-34279":["thread",34279],"thread-33835":["thread",33835],"thread-33730":["thread",33730],"thread-33127":["thread",33127],"thread-33000":["thread",33000],"thread-32931":["thread",32931],"thread-32914":["thread",32914],"thread-32250":["thread",32250],"thread-31584":["thread",31584],"thread-31161":["thread",31161],"thread-31026":["thread",31026],"thread-30667":["thread",30667],"thread-30641":["thread",30641],"thread-30634":["thread",30634],"thread-30542":["thread",30542],"thread-30316":["thread",30316],"thread-30310":["thread",30310],"thread-30193":["thread",30193],"thread-29891":["thread",29891],"thread-29635":["thread",29635],"thread-29430":["thread",29430],"thread-29220":["thread",29220],"thread-28909":["thread",28909],"thread-28451":["thread",28451],"thread-27921":["thread",27921],"thread-27876":["thread",27876],"thread-27867":["thread",27867],"thread-27506":["thread",27506],"thread-27247":["thread",27247],"thread-27088":["thread",27088],"thread-26809":["thread",26809],"thread-26395":["thread",26395],"thread-26046":["thread",26046],"thread-26004":["thread",26004],"thread-25913":["thread",25913],"thread-25478":["thread",25478],"thread-25102":["thread",25102],"thread-24966":["thread",24966],"thread-24862":["thread",24862],"thread-24209":["thread",24209],"thread-23793":["thread",23793],"thread-23467":["thread",23467],"thread-22917":["thread",22917],"thread-22551":["thread",22551],"thread-22215":["thread",22215],"thread-22004":["thread",22004],"thread-21863":["thread",21863],"thread-21745":["thread",21745],"thread-21733":["thread",21733],"thread-21395":["thread",21395],"thread-21019":["thread",21019],"thread-20172":["thread",20172],"thread-20100":["thread",20100],"thread-20077":["thread",20077],"thread-19968":["thread",19968],"thread-19672":["thread",19672],"thread-18470":["thread",18470],"thread-18386":["thread",18386],"thread-17719":["thread",17719],"thread-16366":["thread",16366],"thread-16238":["thread",16238],"thread-15468":["thread",15468],"thread-15031":["thread",15031],"thread-14842":["thread",14842],"thread-14739":["thread",14739],"thread-14265":["thread",14265],"thread-12939":["thread",12939],"thread-12133":["thread",12133],"thread-11950":["thread",11950],"thread-11791":["thread",11791],"thread-11784":["thread",11784],"thread-11402":["thread",11402],"thread-10867":["thread",10867],"thread-10691":["thread",10691],"thread-9936":["thread",9936],"thread-8433":["thread",8433],"thread-8413":["thread",8413],"thread-8329":["thread",8329],"thread-8312":["thread",8312],"thread-7837":["thread",7837],"thread-7788":["thread",7788],"thread-7735":["thread",7735],"thread-6924":["thread",6924],"thread-6509":["thread",6509],"thread-6498":["thread",6498],"thread-6490":["thread",6490],"thread-6287":["thread",6287],"thread-5919":["thread",5919],"thread-5849":["thread",5849],"thread-5622":["thread",5622],"thread-5533":["thread",5533],"thread-5075":["thread",5075],"thread-4805":["thread",4805],"thread-4780":["thread",4780],"thread-4724":["thread",4724],"thread-4657":["thread",4657],"thread-4646":["thread",4646],"thread-4255":["thread",4255],"thread-4151":["thread",4151],"thread-3554":["thread",3554],"thread-3265":["thread",3265],"thread-2868":["thread",2868],"thread-2712":["thread",2712],"thread-2305":["thread",2305],"thread-2213":["thread",2213],"thread-1835":["thread",1835],"thread-1758":["thread",1758],"thread-1594":["thread",1594],"thread-229":["thread",229]}, NULL, 1715460672
Run Time: 0.000562
- 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