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 (19098, 19079, 18936, 18920, 18635, 18602, 18596, 18550, 18538, 18525, 18419, 18383, 18323, 18190, 18180, 18179, 18171, 18163, 18071, 18044, 18022, 17931, 17720, 17549, 17496, 17494, 17448, 17446, 17138, 16846, 16827, 14735, 13812, 12431, 12336, 12275, 12261, 12260, 12259, 12185, 12045, 11919, 11879, 11805, 11747, 11728, 11659, 11529, 11528, 11517, 11516, 11506, 11481, 11480, 11475, 11473, 11429, 11302, 11141, 10941, 10937, 10919, 10918, 10897, 10866, 10840, 10749, 10747, 10688, 10687, 10686, 10685, 10684, 10683, 10682, 10681, 10679, 10678, 10513, 10512, 10511, 10510, 10509, 10508, 10468, 10461, 10460, 10448, 10447, 10446, 10445, 10444, 10443, 10427, 10426, 10425, 10418, 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, 10331, 10313, 10202, 10123, 10122, 10121, 10114, 10113, 10112, 10099, 10098, 10097, 10082, 10081, 10080, 10073, 10072, 10071, 10063, 10062, 10061, 10060, 10057, 10056, 10055, 10052, 10037, 10035, 9853, 9841, 9726, 9694, 9691, 9690, 9685, 9684, 9661, 9659, 9647, 9636, 9584, 9534, 9515, 9512, 9511, 9490, 9472, 9402, 9400, 9378, 9336, 9333, 9332, 9307, 9161, 9014, 9001, 8954, 8921, 8833, 8801, 8799, 8716, 8707, 8703))
Run Time: 0.004154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 2639, 0, 1716093637, {"resource-19098":["resource",19098],"resource-19079":["resource",19079],"resource-18936":["resource",18936],"resource-18920":["resource",18920],"resource-18635":["resource",18635],"resource-18602":["resource",18602],"resource-18596":["resource",18596],"resource-18550":["resource",18550],"resource-18538":["resource",18538],"resource-18525":["resource",18525],"resource-18419":["resource",18419],"resource-18383":["resource",18383],"resource-18323":["resource",18323],"resource-18190":["resource",18190],"resource-18180":["resource",18180],"resource-18179":["resource",18179],"resource-18171":["resource",18171],"resource-18163":["resource",18163],"resource-18071":["resource",18071],"resource-18044":["resource",18044],"resource-18022":["resource",18022],"resource-17931":["resource",17931],"resource-17720":["resource",17720],"resource-17549":["resource",17549],"resource-17496":["resource",17496],"resource-17494":["resource",17494],"resource-17448":["resource",17448],"resource-17446":["resource",17446],"resource-17138":["resource",17138],"resource-16846":["resource",16846],"resource-16827":["resource",16827],"resource-14735":["resource",14735],"resource-13812":["resource",13812],"resource-12431":["resource",12431],"resource-12336":["resource",12336],"resource-12275":["resource",12275],"resource-12261":["resource",12261],"resource-12260":["resource",12260],"resource-12259":["resource",12259],"resource-12185":["resource",12185],"resource-12045":["resource",12045],"resource-11919":["resource",11919],"resource-11879":["resource",11879],"resource-11805":["resource",11805],"resource-11747":["resource",11747],"resource-11728":["resource",11728],"resource-11659":["resource",11659],"resource-11529":["resource",11529],"resource-11528":["resource",11528],"resource-11517":["resource",11517],"resource-11516":["resource",11516],"resource-11506":["resource",11506],"resource-11481":["resource",11481],"resource-11480":["resource",11480],"resource-11475":["resource",11475],"resource-11473":["resource",11473],"resource-11429":["resource",11429],"resource-11302":["resource",11302],"resource-11141":["resource",11141],"resource-10941":["resource",10941],"resource-10937":["resource",10937],"resource-10919":["resource",10919],"resource-10918":["resource",10918],"resource-10897":["resource",10897],"resource-10866":["resource",10866],"resource-10840":["resource",10840],"resource-10749":["resource",10749],"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-10513":["resource",10513],"resource-10512":["resource",10512],"resource-10511":["resource",10511],"resource-10510":["resource",10510],"resource-10509":["resource",10509],"resource-10508":["resource",10508],"resource-10468":["resource",10468],"resource-10461":["resource",10461],"resource-10460":["resource",10460],"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-10418":["resource",10418],"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-10331":["resource",10331],"resource-10313":["resource",10313],"resource-10202":["resource",10202],"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-10063":["resource",10063],"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-10037":["resource",10037],"resource-10035":["resource",10035],"resource-9853":["resource",9853],"resource-9841":["resource",9841],"resource-9726":["resource",9726],"resource-9694":["resource",9694],"resource-9691":["resource",9691],"resource-9690":["resource",9690],"resource-9685":["resource",9685],"resource-9684":["resource",9684],"resource-9661":["resource",9661],"resource-9659":["resource",9659],"resource-9647":["resource",9647],"resource-9636":["resource",9636],"resource-9584":["resource",9584],"resource-9534":["resource",9534],"resource-9515":["resource",9515],"resource-9512":["resource",9512],"resource-9511":["resource",9511],"resource-9490":["resource",9490],"resource-9472":["resource",9472],"resource-9402":["resource",9402],"resource-9400":["resource",9400],"resource-9378":["resource",9378],"resource-9336":["resource",9336],"resource-9333":["resource",9333],"resource-9332":["resource",9332],"resource-9307":["resource",9307],"resource-9161":["resource",9161],"resource-9014":["resource",9014],"resource-9001":["resource",9001],"resource-8954":["resource",8954],"resource-8921":["resource",8921],"resource-8833":["resource",8833],"resource-8801":["resource",8801],"resource-8799":["resource",8799],"resource-8716":["resource",8716],"resource-8707":["resource",8707],"resource-8703":["resource",8703]}, NULL, 1716090037
Run Time: 0.000394
- 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