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 (103990, 100754, 99272, 99263, 96061, 96019, 94993, 94693, 93591, 92158, 89856, 89698, 87013, 82610, 81631, 80575, 80207, 79827, 79072, 78784, 77392, 77035, 76783, 76731, 76482, 75108, 74670, 74653, 74122, 73987, 73966, 73438, 73408, 72907, 72837, 91458, 72392, 72389, 72381, 72377, 72370, 67636, 67611, 64638, 63737, 63594, 63587, 63358, 61865, 61633, 61401, 61157, 60792, 71680, 71840, 71855, 72046, 71800, 59301, 71701, 71679, 72057, 59003, 58173, 55895, 55862, 54455, 56212, 52486, 52168, 50814, 50468, 49409, 49169, 49034, 48713, 48060, 47215, 46962, 46848, 46230, 44679, 42927, 42790, 42666, 42367, 41913, 41714, 40688, 40557, 39851, 39688, 38763, 38150, 37906, 36149, 36146, 32644, 32531, 32031, 31514, 31191, 30321, 29091, 29047, 28851, 28814, 28798, 28481, 27986, 26551, 29318, 29314, 26317, 26041, 25796, 25002, 24954, 24516, 24512, 23753, 23642, 23634, 23633, 23632, 23117, 21540, 21537, 21366, 21176, 20711, 20619, 20478, 20458, 19904, 19796, 18820, 17553, 17333, 16243, 16155, 16008, 15472, 14238, 14229, 11895, 10741, 10729, 10663, 10650, 10644, 10184, 9797, 9784, 9556, 9538, 8907, 8476, 7628, 7218, 6439, 5942, 5709, 5102, 4979, 4743, 4564, 4048, 3906, 3536, 3030, 11177, 1483, 875, 796))
Run Time: 0.002683
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 175 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.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 2870
- 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 138
- 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 2487
- 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: 469, 0, 1715748200, {"thread-103990":["thread",103990],"thread-100754":["thread",100754],"thread-99272":["thread",99272],"thread-99263":["thread",99263],"thread-96061":["thread",96061],"thread-96019":["thread",96019],"thread-94993":["thread",94993],"thread-94693":["thread",94693],"thread-93591":["thread",93591],"thread-92158":["thread",92158],"thread-89856":["thread",89856],"thread-89698":["thread",89698],"thread-87013":["thread",87013],"thread-82610":["thread",82610],"thread-81631":["thread",81631],"thread-80575":["thread",80575],"thread-80207":["thread",80207],"thread-79827":["thread",79827],"thread-79072":["thread",79072],"thread-78784":["thread",78784],"thread-77392":["thread",77392],"thread-77035":["thread",77035],"thread-76783":["thread",76783],"thread-76731":["thread",76731],"thread-76482":["thread",76482],"thread-75108":["thread",75108],"thread-74670":["thread",74670],"thread-74653":["thread",74653],"thread-74122":["thread",74122],"thread-73987":["thread",73987],"thread-73966":["thread",73966],"thread-73438":["thread",73438],"thread-73408":["thread",73408],"thread-72907":["thread",72907],"thread-72837":["thread",72837],"thread-91458":["thread",91458],"thread-72392":["thread",72392],"thread-72389":["thread",72389],"thread-72381":["thread",72381],"thread-72377":["thread",72377],"thread-72370":["thread",72370],"thread-67636":["thread",67636],"thread-67611":["thread",67611],"thread-64638":["thread",64638],"thread-63737":["thread",63737],"thread-63594":["thread",63594],"thread-63587":["thread",63587],"thread-63358":["thread",63358],"thread-61865":["thread",61865],"thread-61633":["thread",61633],"thread-61401":["thread",61401],"thread-61157":["thread",61157],"thread-60792":["thread",60792],"thread-71680":["thread",71680],"thread-71840":["thread",71840],"thread-71855":["thread",71855],"thread-72046":["thread",72046],"thread-71800":["thread",71800],"thread-59301":["thread",59301],"thread-71701":["thread",71701],"thread-71679":["thread",71679],"thread-72057":["thread",72057],"thread-59003":["thread",59003],"thread-58173":["thread",58173],"thread-55895":["thread",55895],"thread-55862":["thread",55862],"thread-54455":["thread",54455],"thread-56212":["thread",56212],"thread-52486":["thread",52486],"thread-52168":["thread",52168],"thread-50814":["thread",50814],"thread-50468":["thread",50468],"thread-49409":["thread",49409],"thread-49169":["thread",49169],"thread-49034":["thread",49034],"thread-48713":["thread",48713],"thread-48060":["thread",48060],"thread-47215":["thread",47215],"thread-46962":["thread",46962],"thread-46848":["thread",46848],"thread-46230":["thread",46230],"thread-44679":["thread",44679],"thread-42927":["thread",42927],"thread-42790":["thread",42790],"thread-42666":["thread",42666],"thread-42367":["thread",42367],"thread-41913":["thread",41913],"thread-41714":["thread",41714],"thread-40688":["thread",40688],"thread-40557":["thread",40557],"thread-39851":["thread",39851],"thread-39688":["thread",39688],"thread-38763":["thread",38763],"thread-38150":["thread",38150],"thread-37906":["thread",37906],"thread-36149":["thread",36149],"thread-36146":["thread",36146],"thread-32644":["thread",32644],"thread-32531":["thread",32531],"thread-32031":["thread",32031],"thread-31514":["thread",31514],"thread-31191":["thread",31191],"thread-30321":["thread",30321],"thread-29091":["thread",29091],"thread-29047":["thread",29047],"thread-28851":["thread",28851],"thread-28814":["thread",28814],"thread-28798":["thread",28798],"thread-28481":["thread",28481],"thread-27986":["thread",27986],"thread-26551":["thread",26551],"thread-29318":["thread",29318],"thread-29314":["thread",29314],"thread-26317":["thread",26317],"thread-26041":["thread",26041],"thread-25796":["thread",25796],"thread-25002":["thread",25002],"thread-24954":["thread",24954],"thread-24516":["thread",24516],"thread-24512":["thread",24512],"thread-23753":["thread",23753],"thread-23642":["thread",23642],"thread-23634":["thread",23634],"thread-23633":["thread",23633],"thread-23632":["thread",23632],"thread-23117":["thread",23117],"thread-21540":["thread",21540],"thread-21537":["thread",21537],"thread-21366":["thread",21366],"thread-21176":["thread",21176],"thread-20711":["thread",20711],"thread-20619":["thread",20619],"thread-20478":["thread",20478],"thread-20458":["thread",20458],"thread-19904":["thread",19904],"thread-19796":["thread",19796],"thread-18820":["thread",18820],"thread-17553":["thread",17553],"thread-17333":["thread",17333],"thread-16243":["thread",16243],"thread-16155":["thread",16155],"thread-16008":["thread",16008],"thread-15472":["thread",15472],"thread-14238":["thread",14238],"thread-14229":["thread",14229],"thread-11895":["thread",11895],"thread-10741":["thread",10741],"thread-10729":["thread",10729],"thread-10663":["thread",10663],"thread-10650":["thread",10650],"thread-10644":["thread",10644],"thread-10184":["thread",10184],"thread-9797":["thread",9797],"thread-9784":["thread",9784],"thread-9556":["thread",9556],"thread-9538":["thread",9538],"thread-8907":["thread",8907],"thread-8476":["thread",8476],"thread-7628":["thread",7628],"thread-7218":["thread",7218],"thread-6439":["thread",6439],"thread-5942":["thread",5942],"thread-5709":["thread",5709],"thread-5102":["thread",5102],"thread-4979":["thread",4979],"thread-4743":["thread",4743],"thread-4564":["thread",4564],"thread-4048":["thread",4048],"thread-3906":["thread",3906],"thread-3536":["thread",3536],"thread-3030":["thread",3030],"thread-11177":["thread",11177],"thread-1483":["thread",1483],"thread-875":["thread",875],"thread-796":["thread",796]}, NULL, 1715744600
Run Time: 0.000104
- 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 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20