SELECT `xf_rm_resource`.*, `xf_rm_category_Category_1`.*, `xf_user_User_2`.*, `xf_rm_resource_update_Description_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_1` ON (`xf_rm_category_Category_1`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_update` AS `xf_rm_resource_update_Description_3` ON (`xf_rm_resource_update_Description_3`.`resource_update_id` = `xf_rm_resource`.`description_update_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_rm_category_Category_1`.`resource_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_id` IN (19105, 19028, 18971, 18970, 18969, 18408, 18159, 17888, 17887, 17847, 17823, 17822, 17821, 17717, 16749, 16385, 16049, 16019, 15493, 15006, 14857, 14793, 14586, 14490, 14445, 14211, 14157, 14127, 14126, 14022, 14020, 14009, 14006, 13993, 13992, 13850, 12336, 12063, 12056, 11516, 11513, 11480, 11462, 11257, 11141, 10930, 10929, 10928, 10927, 10919, 10918, 10747, 10688, 10687, 10686, 10685, 10684, 10683, 10682, 10681, 10679, 10678, 10671, 10637, 10513, 10512, 10511, 10510, 10509, 10508, 10485, 10483, 10448, 10447, 10446, 10445, 10444, 10443, 10427, 10426, 10425, 10416, 10415, 10393, 10392, 10391, 10376, 10375, 10374, 10372, 10371, 10370, 10362, 10360, 10359, 10358, 10357, 10356, 10355, 10353, 10352, 10351, 10350, 10349, 10348, 10347, 10346, 10345, 10344, 10343, 10342, 10341, 10340, 10339, 10338, 10337, 10336, 10335, 10334, 10123, 10122, 10121, 10114, 10113, 10112, 10099, 10098, 10097, 10082, 10081, 10080, 10073, 10072, 10071, 10066, 10062, 10061, 10060, 10057, 10056, 10055, 10052, 10051, 10050, 10037, 9991, 9726, 9636, 8956, 8867, 8814, 8744, 8726, 8660, 8311, 8296, 8142, 8014, 7987, 7984, 7978, 7897, 7885, 7848, 7800, 7795, 7778, 7766, 7722, 7622, 7587, 7517, 7441, 7427, 7275, 7274, 7273, 6075, 5982, 5717, 5711, 5703, 5699, 5697, 5696, 5680, 5555, 4355, 4101, 3867, 3709, 2887, 1959, 1956, 1927, 1667, 1661, 1626, 1604))
Run Time: 0.004626
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 199 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | db624634433.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | db624634433.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_update_Description_3 | eq_ref | PRIMARY | PRIMARY | 4 | db624634433.xf_rm_resource.description_update_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db624634433.xf_rm_category_Category_1.resource_category_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 1392
- 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 2731
- 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 263
- 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 2353
- 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: 904, 0, 1716096685, {"resource-19105":["resource",19105],"resource-19028":["resource",19028],"resource-18971":["resource",18971],"resource-18970":["resource",18970],"resource-18969":["resource",18969],"thread-16480":["thread",16480],"resource-18408":["resource",18408],"resource-18159":["resource",18159],"resource-17888":["resource",17888],"resource-17887":["resource",17887],"resource-17847":["resource",17847],"resource-17823":["resource",17823],"resource-17822":["resource",17822],"resource-17821":["resource",17821],"resource-17717":["resource",17717],"resource-16749":["resource",16749],"resource-16385":["resource",16385],"resource-16049":["resource",16049],"resource-16019":["resource",16019],"resource-15493":["resource",15493],"resource-15006":["resource",15006],"resource-14857":["resource",14857],"resource-14793":["resource",14793],"resource-14586":["resource",14586],"resource-14490":["resource",14490],"resource-14445":["resource",14445],"resource-14211":["resource",14211],"resource-14157":["resource",14157],"resource-14127":["resource",14127],"resource-14126":["resource",14126],"resource-14022":["resource",14022],"resource-14020":["resource",14020],"resource-14009":["resource",14009],"resource-14006":["resource",14006],"resource-13993":["resource",13993],"resource-13992":["resource",13992],"resource-13850":["resource",13850],"resource-12336":["resource",12336],"resource-12063":["resource",12063],"resource-12056":["resource",12056],"resource-11516":["resource",11516],"resource-11513":["resource",11513],"resource-11480":["resource",11480],"resource-11462":["resource",11462],"resource-11257":["resource",11257],"resource-11141":["resource",11141],"resource-10930":["resource",10930],"resource-10929":["resource",10929],"resource-10928":["resource",10928],"resource-10927":["resource",10927],"resource-10919":["resource",10919],"resource-10918":["resource",10918],"resource-10747":["resource",10747],"resource-10688":["resource",10688],"resource-10687":["resource",10687],"resource-10686":["resource",10686],"resource-10685":["resource",10685],"resource-10684":["resource",10684],"resource-10683":["resource",10683],"resource-10682":["resource",10682],"resource-10681":["resource",10681],"resource-10679":["resource",10679],"resource-10678":["resource",10678],"resource-10671":["resource",10671],"resource-10637":["resource",10637],"resource-10513":["resource",10513],"resource-10512":["resource",10512],"resource-10511":["resource",10511],"resource-10510":["resource",10510],"resource-10509":["resource",10509],"resource-10508":["resource",10508],"resource-10485":["resource",10485],"resource-10483":["resource",10483],"resource-10448":["resource",10448],"resource-10447":["resource",10447],"resource-10446":["resource",10446],"resource-10445":["resource",10445],"resource-10444":["resource",10444],"resource-10443":["resource",10443],"resource-10427":["resource",10427],"resource-10426":["resource",10426],"resource-10425":["resource",10425],"resource-10416":["resource",10416],"resource-10415":["resource",10415],"resource-10393":["resource",10393],"resource-10392":["resource",10392],"resource-10391":["resource",10391],"resource-10376":["resource",10376],"resource-10375":["resource",10375],"resource-10374":["resource",10374],"resource-10372":["resource",10372],"resource-10371":["resource",10371],"resource-10370":["resource",10370],"resource-10362":["resource",10362],"resource-10360":["resource",10360],"resource-10359":["resource",10359],"resource-10358":["resource",10358],"resource-10357":["resource",10357],"resource-10356":["resource",10356],"resource-10355":["resource",10355],"resource-10353":["resource",10353],"resource-10352":["resource",10352],"resource-10351":["resource",10351],"resource-10350":["resource",10350],"resource-10349":["resource",10349],"resource-10348":["resource",10348],"resource-10347":["resource",10347],"resource-10346":["resource",10346],"resource-10345":["resource",10345],"resource-10344":["resource",10344],"resource-10343":["resource",10343],"resource-10342":["resource",10342],"resource-10341":["resource",10341],"resource-10340":["resource",10340],"resource-10339":["resource",10339],"resource-10338":["resource",10338],"resource-10337":["resource",10337],"resource-10336":["resource",10336],"resource-10335":["resource",10335],"resource-10334":["resource",10334],"resource-10123":["resource",10123],"resource-10122":["resource",10122],"resource-10121":["resource",10121],"resource-10114":["resource",10114],"resource-10113":["resource",10113],"resource-10112":["resource",10112],"resource-10099":["resource",10099],"resource-10098":["resource",10098],"resource-10097":["resource",10097],"resource-10082":["resource",10082],"resource-10081":["resource",10081],"resource-10080":["resource",10080],"resource-10073":["resource",10073],"resource-10072":["resource",10072],"resource-10071":["resource",10071],"resource-10066":["resource",10066],"resource-10062":["resource",10062],"resource-10061":["resource",10061],"resource-10060":["resource",10060],"resource-10057":["resource",10057],"resource-10056":["resource",10056],"resource-10055":["resource",10055],"resource-10052":["resource",10052],"resource-10051":["resource",10051],"resource-10050":["resource",10050],"resource-10037":["resource",10037],"resource-9991":["resource",9991],"resource-9726":["resource",9726],"resource-9636":["resource",9636],"resource-8956":["resource",8956],"resource-8867":["resource",8867],"resource-8814":["resource",8814],"resource-8744":["resource",8744],"resource-8726":["resource",8726],"resource-8660":["resource",8660],"resource-8311":["resource",8311],"resource-8296":["resource",8296],"resource-8142":["resource",8142],"resource-8014":["resource",8014],"resource-7987":["resource",7987],"resource-7984":["resource",7984],"resource-7978":["resource",7978],"resource-7897":["resource",7897],"resource-7885":["resource",7885],"resource-7848":["resource",7848],"resource-7800":["resource",7800],"resource-7795":["resource",7795],"resource-7778":["resource",7778],"resource-7766":["resource",7766],"resource-7722":["resource",7722],"resource-7622":["resource",7622],"resource-7587":["resource",7587],"resource-7517":["resource",7517],"resource-7441":["resource",7441],"resource-7427":["resource",7427],"resource-7275":["resource",7275],"resource-7274":["resource",7274],"resource-7273":["resource",7273],"resource-6075":["resource",6075],"resource-5982":["resource",5982],"resource-5717":["resource",5717],"resource-5711":["resource",5711],"resource-5703":["resource",5703],"resource-5699":["resource",5699],"resource-5697":["resource",5697],"resource-5696":["resource",5696],"resource-5680":["resource",5680],"resource-5555":["resource",5555],"resource-4355":["resource",4355],"resource-4101":["resource",4101],"resource-3867":["resource",3867],"resource-3709":["resource",3709],"resource-2887":["resource",2887],"resource-1959":["resource",1959],"resource-1956":["resource",1956],"resource-1927":["resource",1927],"resource-1667":["resource",1667],"resource-1661":["resource",1661],"resource-1626":["resource",1626],"resource-1604":["resource",1604]}, NULL, 1716093085
Run Time: 0.000341
- 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 223
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1516
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1248
- 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 263
- 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 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20