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 (45076, 45063, 44941, 44931, 44926, 43825, 43599, 43415, 43193, 43168, 42930, 42919, 42892, 42843, 42662, 42626, 42605, 42597, 42473, 42086, 41937, 41837, 41619, 41431, 41375, 41370, 41156, 41155, 41130, 40955, 40880, 40720, 40587, 40492, 40428, 40426, 40188, 40127, 39957, 39944, 39701, 39255, 39224, 39098, 39055, 39046, 38816, 38728, 38478, 38099, 37958, 37947, 37903, 37898, 37747, 37479, 37262, 37217, 37203, 37176, 37062, 37014, 37007, 36780, 36726, 36723, 36642, 36577, 36463, 36436, 36070, 35941, 35797, 35660, 35597, 35520, 35359, 35347, 35290, 35169, 34705, 34663, 33947, 33673, 33419, 33356, 33127, 33057, 33018, 33010, 32907, 32836, 32412, 32403, 32313, 32304, 31946, 31860, 31760, 31588, 31569, 31552, 31523, 31484, 31323, 30884, 30862, 30741, 30637, 30562, 30019, 29995, 29460, 29424, 29223, 29016, 28741, 28644, 28438, 28191, 28130, 28116, 28086, 27982, 27928, 27727, 27574, 27479, 27279, 26916, 26885, 26839, 26708, 26573, 26562, 26514, 26022, 25905, 25600, 25556, 25319, 25280, 25164, 25085, 24876, 24777, 24745, 24585, 24316, 24315, 24055, 23581, 23470, 23200, 22676, 22492, 22159, 22122, 21688, 21578, 21499, 21274, 21036, 21015, 20998, 20972, 20838, 20580, 20572, 20166, 19784, 19690, 19516, 19374, 19286, 18842, 18696, 18688, 18265, 18245, 18185, 18047, 17875, 17869, 17677, 17540, 17466, 17423, 16904, 16290, 16288, 16250, 16109, 16019, 15583, 14738, 14601, 14272, 12838, 12653, 12641, 12281, 12049, 11889, 11886, 11803, 11774, 11601, 11499, 11040, 10873, 10481, 10473, 10291, 10137, 10028, 8490, 8383, 8298, 8198, 8705, 7948, 6979, 6919, 6596, 6359, 5903, 5125, 3639, 3585, 3500, 3479, 3456, 3453, 3238, 2318, 2157, 1877, 1504, 1461, 1389, 1341, 1279, 1251, 1103, 801, 228, 126, 102))
Run Time: 0.130969
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 249 | 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: 218, 0, 1714288894, {"thread-45076":["thread",45076],"thread-45063":["thread",45063],"thread-44941":["thread",44941],"thread-44926":["thread",44926],"thread-43825":["thread",43825],"thread-43599":["thread",43599],"thread-43415":["thread",43415],"thread-43193":["thread",43193],"thread-43168":["thread",43168],"thread-42930":["thread",42930],"thread-42919":["thread",42919],"thread-42892":["thread",42892],"thread-42843":["thread",42843],"thread-42626":["thread",42626],"thread-42086":["thread",42086],"thread-41937":["thread",41937],"thread-41619":["thread",41619],"thread-41431":["thread",41431],"thread-41375":["thread",41375],"thread-41370":["thread",41370],"thread-41156":["thread",41156],"thread-41155":["thread",41155],"thread-41130":["thread",41130],"thread-40880":["thread",40880],"thread-40720":["thread",40720],"thread-40587":["thread",40587],"thread-40492":["thread",40492],"thread-40428":["thread",40428],"thread-40426":["thread",40426],"thread-40127":["thread",40127],"thread-39944":["thread",39944],"thread-39701":["thread",39701],"thread-39255":["thread",39255],"thread-39098":["thread",39098],"thread-38478":["thread",38478],"thread-38099":["thread",38099],"thread-37958":["thread",37958],"thread-37947":["thread",37947],"thread-37898":["thread",37898],"thread-37747":["thread",37747],"thread-37262":["thread",37262],"thread-37203":["thread",37203],"thread-37176":["thread",37176],"thread-37014":["thread",37014],"thread-37007":["thread",37007],"thread-36780":["thread",36780],"thread-36642":["thread",36642],"thread-36577":["thread",36577],"thread-36463":["thread",36463],"thread-36436":["thread",36436],"thread-36070":["thread",36070],"thread-35941":["thread",35941],"thread-35797":["thread",35797],"thread-35660":["thread",35660],"thread-35597":["thread",35597],"thread-35359":["thread",35359],"thread-35169":["thread",35169],"thread-34705":["thread",34705],"thread-34663":["thread",34663],"thread-33947":["thread",33947],"thread-33673":["thread",33673],"thread-33419":["thread",33419],"thread-33356":["thread",33356],"thread-33127":["thread",33127],"thread-33057":["thread",33057],"thread-33018":["thread",33018],"thread-32836":["thread",32836],"thread-32412":["thread",32412],"thread-32403":["thread",32403],"thread-32313":["thread",32313],"thread-32304":["thread",32304],"thread-31946":["thread",31946],"thread-31860":["thread",31860],"thread-31569":["thread",31569],"thread-31552":["thread",31552],"thread-31523":["thread",31523],"thread-31484":["thread",31484],"thread-31323":["thread",31323],"thread-30884":["thread",30884],"thread-30862":["thread",30862],"thread-30741":["thread",30741],"thread-30637":["thread",30637],"thread-30019":["thread",30019],"thread-29995":["thread",29995],"thread-29460":["thread",29460],"thread-28741":["thread",28741],"thread-28644":["thread",28644],"thread-28438":["thread",28438],"thread-28191":["thread",28191],"thread-28130":["thread",28130],"thread-28116":["thread",28116],"thread-28086":["thread",28086],"thread-27982":["thread",27982],"thread-27928":["thread",27928],"thread-27574":["thread",27574],"thread-27479":["thread",27479],"thread-27279":["thread",27279],"thread-26916":["thread",26916],"thread-26573":["thread",26573],"thread-26562":["thread",26562],"thread-26514":["thread",26514],"thread-26022":["thread",26022],"thread-25905":["thread",25905],"thread-25319":["thread",25319],"thread-25280":["thread",25280],"thread-25164":["thread",25164],"thread-25085":["thread",25085],"thread-24777":["thread",24777],"thread-24745":["thread",24745],"thread-24585":["thread",24585],"thread-24315":["thread",24315],"thread-24055":["thread",24055],"thread-23470":["thread",23470],"thread-23200":["thread",23200],"thread-22676":["thread",22676],"thread-22492":["thread",22492],"thread-22159":["thread",22159],"thread-22122":["thread",22122],"thread-21036":["thread",21036],"thread-20972":["thread",20972],"thread-20838":["thread",20838],"thread-20572":["thread",20572],"thread-19784":["thread",19784],"thread-19516":["thread",19516],"thread-19374":["thread",19374],"thread-19286":["thread",19286],"thread-18842":["thread",18842],"thread-18688":["thread",18688],"thread-18265":["thread",18265],"thread-18245":["thread",18245],"thread-17875":["thread",17875],"thread-17869":["thread",17869],"thread-17677":["thread",17677],"thread-17540":["thread",17540],"thread-17423":["thread",17423],"thread-16290":["thread",16290],"thread-16109":["thread",16109],"thread-16019":["thread",16019],"thread-15583":["thread",15583],"thread-14738":["thread",14738],"thread-14601":["thread",14601],"thread-12653":["thread",12653],"thread-12641":["thread",12641],"thread-12049":["thread",12049],"thread-11889":["thread",11889],"thread-11886":["thread",11886],"thread-11803":["thread",11803],"thread-11774":["thread",11774],"thread-11601":["thread",11601],"thread-11499":["thread",11499],"thread-11040":["thread",11040],"thread-10873":["thread",10873],"thread-10481":["thread",10481],"thread-10473":["thread",10473],"thread-10291":["thread",10291],"thread-10137":["thread",10137],"thread-8490":["thread",8490],"thread-8383":["thread",8383],"thread-8298":["thread",8298],"thread-8198":["thread",8198],"thread-8705":["thread",8705],"thread-7948":["thread",7948],"thread-6979":["thread",6979],"thread-6919":["thread",6919],"thread-6596":["thread",6596],"thread-6359":["thread",6359],"thread-5903":["thread",5903],"thread-5125":["thread",5125],"thread-3639":["thread",3639],"thread-3585":["thread",3585],"thread-3500":["thread",3500],"thread-3479":["thread",3479],"thread-3456":["thread",3456],"thread-3453":["thread",3453],"thread-3238":["thread",3238],"thread-2318":["thread",2318],"thread-2157":["thread",2157],"thread-1877":["thread",1877],"thread-1461":["thread",1461],"thread-1389":["thread",1389],"thread-1341":["thread",1341],"thread-1279":["thread",1279],"thread-1251":["thread",1251],"thread-1103":["thread",1103],"thread-801":["thread",801],"thread-228":["thread",228],"thread-126":["thread",126],"thread-102":["thread",102]}, NULL, 1714285294
Run Time: 0.000749
- 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