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 (19138, 19137, 19135, 19120, 19095, 19093, 19092, 18870, 18740, 18730, 18629, 18618, 18606, 18605, 18604, 18592, 18441, 18438, 18430, 18425, 18421, 18420, 18402, 18400, 18397, 18367, 18366, 18251, 18217, 18195, 18191, 18141, 18138, 18137, 18122, 18121, 18118, 18070, 18044, 18031, 17996, 17975, 17966, 17965, 17952, 17927, 17924, 17898, 17893, 17886, 17830, 17829, 17801, 17791, 17766, 17748, 17744, 17637, 17614, 17587, 17564, 17562, 17561, 17560, 17558, 17555, 17552, 17545, 17536, 17487, 17467, 17449, 17414, 17382, 17379, 17360, 17352, 17341, 17336, 17332, 17331, 17242, 17226, 17187, 17184, 17178, 17177, 17166, 17164, 17127, 17119, 17106, 17095, 17094, 17086, 17078, 17068, 17064, 17061, 17037, 16993, 16992, 16972, 16951, 16912, 16897, 16886, 16859, 16822, 16799, 16782, 16779, 16774, 16768, 16766, 16748, 16747, 16731, 16725, 16723, 16676, 16650, 16649, 16640, 16638, 16626, 16616, 16615, 16584, 16572, 16568, 16547, 16530, 16519, 16500, 16499, 16498, 16485, 16479, 16478, 16477, 16475, 16470, 16431, 16425, 16423, 16422, 16415, 16414, 16381, 16379, 16367, 16350, 16332, 16312, 16295, 16261, 16255, 16251, 16240, 16239, 16232, 16190, 16179, 16172, 16167, 16157, 16150, 16149, 16136, 16128, 16109, 16104, 16100, 16099, 16093, 16081, 16075, 16061, 16060, 16055, 16052, 16023, 16014, 16005, 15995, 15983, 15976, 15952, 15931, 15928, 15910, 15816, 15809, 15797, 15733, 15600, 15528, 15511, 15486))
Run Time: 0.003939
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: 3337, 0, 1716178701, {"resource-19138":["resource",19138],"resource-19137":["resource",19137],"resource-19135":["resource",19135],"resource-19120":["resource",19120],"resource-19095":["resource",19095],"resource-19093":["resource",19093],"resource-19092":["resource",19092],"resource-18870":["resource",18870],"resource-18740":["resource",18740],"resource-18730":["resource",18730],"resource-18629":["resource",18629],"resource-18618":["resource",18618],"resource-18606":["resource",18606],"resource-18605":["resource",18605],"resource-18604":["resource",18604],"resource-18592":["resource",18592],"resource-18441":["resource",18441],"resource-18438":["resource",18438],"resource-18430":["resource",18430],"resource-18425":["resource",18425],"resource-18421":["resource",18421],"resource-18420":["resource",18420],"resource-18402":["resource",18402],"resource-18400":["resource",18400],"resource-18397":["resource",18397],"resource-18367":["resource",18367],"resource-18366":["resource",18366],"resource-18251":["resource",18251],"resource-18217":["resource",18217],"resource-18195":["resource",18195],"resource-18191":["resource",18191],"resource-18141":["resource",18141],"resource-18138":["resource",18138],"resource-18137":["resource",18137],"resource-18122":["resource",18122],"resource-18121":["resource",18121],"resource-18118":["resource",18118],"resource-18070":["resource",18070],"resource-18044":["resource",18044],"resource-18031":["resource",18031],"resource-17996":["resource",17996],"resource-17975":["resource",17975],"resource-17966":["resource",17966],"resource-17965":["resource",17965],"resource-17952":["resource",17952],"resource-17927":["resource",17927],"resource-17924":["resource",17924],"resource-17898":["resource",17898],"resource-17893":["resource",17893],"resource-17886":["resource",17886],"resource-17830":["resource",17830],"resource-17829":["resource",17829],"resource-17801":["resource",17801],"resource-17791":["resource",17791],"resource-17766":["resource",17766],"resource-17748":["resource",17748],"resource-17744":["resource",17744],"resource-17637":["resource",17637],"resource-17614":["resource",17614],"resource-17587":["resource",17587],"resource-17564":["resource",17564],"resource-17562":["resource",17562],"resource-17561":["resource",17561],"resource-17560":["resource",17560],"resource-17558":["resource",17558],"resource-17555":["resource",17555],"resource-17552":["resource",17552],"resource-17545":["resource",17545],"resource-17536":["resource",17536],"resource-17487":["resource",17487],"resource-17467":["resource",17467],"resource-17449":["resource",17449],"resource-17414":["resource",17414],"resource-17382":["resource",17382],"resource-17379":["resource",17379],"resource-17360":["resource",17360],"resource-17352":["resource",17352],"resource-17341":["resource",17341],"resource-17336":["resource",17336],"resource-17332":["resource",17332],"resource-17331":["resource",17331],"resource-17242":["resource",17242],"resource-17226":["resource",17226],"resource-17187":["resource",17187],"resource-17184":["resource",17184],"resource-17178":["resource",17178],"resource-17177":["resource",17177],"resource-17166":["resource",17166],"resource-17164":["resource",17164],"resource-17127":["resource",17127],"resource-17119":["resource",17119],"resource-17106":["resource",17106],"resource-17095":["resource",17095],"resource-17094":["resource",17094],"resource-17086":["resource",17086],"resource-17078":["resource",17078],"resource-17068":["resource",17068],"resource-17064":["resource",17064],"resource-17061":["resource",17061],"resource-17037":["resource",17037],"resource-16993":["resource",16993],"resource-16992":["resource",16992],"resource-16972":["resource",16972],"resource-16951":["resource",16951],"resource-16912":["resource",16912],"resource-16897":["resource",16897],"resource-16886":["resource",16886],"resource-16859":["resource",16859],"resource-16822":["resource",16822],"resource-16799":["resource",16799],"resource-16782":["resource",16782],"resource-16779":["resource",16779],"resource-16774":["resource",16774],"resource-16768":["resource",16768],"resource-16766":["resource",16766],"resource-16748":["resource",16748],"resource-16747":["resource",16747],"resource-16731":["resource",16731],"resource-16725":["resource",16725],"resource-16723":["resource",16723],"resource-16676":["resource",16676],"resource-16650":["resource",16650],"resource-16649":["resource",16649],"resource-16640":["resource",16640],"resource-16638":["resource",16638],"resource-16626":["resource",16626],"resource-16616":["resource",16616],"resource-16615":["resource",16615],"resource-16584":["resource",16584],"resource-16572":["resource",16572],"resource-16568":["resource",16568],"resource-16547":["resource",16547],"resource-16530":["resource",16530],"resource-16519":["resource",16519],"resource-16500":["resource",16500],"resource-16499":["resource",16499],"resource-16498":["resource",16498],"resource-16485":["resource",16485],"resource-16479":["resource",16479],"resource-16478":["resource",16478],"resource-16477":["resource",16477],"resource-16475":["resource",16475],"resource-16470":["resource",16470],"resource-16431":["resource",16431],"resource-16425":["resource",16425],"resource-16423":["resource",16423],"resource-16422":["resource",16422],"resource-16415":["resource",16415],"resource-16414":["resource",16414],"resource-16381":["resource",16381],"resource-16379":["resource",16379],"resource-16367":["resource",16367],"resource-16350":["resource",16350],"resource-16332":["resource",16332],"resource-16312":["resource",16312],"resource-16295":["resource",16295],"resource-16261":["resource",16261],"resource-16255":["resource",16255],"resource-16251":["resource",16251],"resource-16240":["resource",16240],"resource-16239":["resource",16239],"resource-16232":["resource",16232],"resource-16190":["resource",16190],"resource-16179":["resource",16179],"resource-16172":["resource",16172],"resource-16167":["resource",16167],"resource-16157":["resource",16157],"resource-16150":["resource",16150],"resource-16149":["resource",16149],"resource-16136":["resource",16136],"resource-16128":["resource",16128],"resource-16109":["resource",16109],"resource-16104":["resource",16104],"resource-16100":["resource",16100],"resource-16099":["resource",16099],"resource-16093":["resource",16093],"resource-16081":["resource",16081],"resource-16075":["resource",16075],"resource-16061":["resource",16061],"resource-16060":["resource",16060],"resource-16055":["resource",16055],"resource-16052":["resource",16052],"resource-16023":["resource",16023],"resource-16014":["resource",16014],"resource-16005":["resource",16005],"resource-15995":["resource",15995],"resource-15983":["resource",15983],"resource-15976":["resource",15976],"resource-15952":["resource",15952],"resource-15931":["resource",15931],"resource-15928":["resource",15928],"resource-15910":["resource",15910],"resource-15816":["resource",15816],"resource-15809":["resource",15809],"resource-15797":["resource",15797],"resource-15733":["resource",15733],"resource-15600":["resource",15600],"resource-15528":["resource",15528],"resource-15511":["resource",15511],"resource-15486":["resource",15486]}, NULL, 1716175101
Run Time: 0.000594
- 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