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 (19186, 19171, 19170, 19168, 18960, 18874, 18719, 18530, 18526, 18494, 18483, 18482, 18367, 18366, 18244, 18191, 18122, 18121, 18070, 18066, 18031, 17975, 17971, 17927, 17893, 17829, 17815, 17814, 17813, 17812, 17809, 17808, 17807, 17805, 17791, 17744, 17637, 17589, 17564, 17555, 17552, 17545, 17536, 17467, 17414, 17407, 17379, 17360, 17325, 17324, 17323, 17322, 17321, 17320, 17319, 17317, 17315, 17314, 17313, 17311, 17310, 17309, 17242, 17228, 17226, 17222, 17187, 17182, 17173, 17166, 17119, 17112, 17103, 17095, 17086, 17037, 16991, 16979, 16959, 16957, 16912, 16870, 16829, 16823, 16820, 16818, 16813, 16812, 16810, 16809, 16806, 16804, 16798, 16527, 16483, 16153, 16152, 16102, 15983, 15809, 15720, 15544, 15520, 15511, 15492, 15481, 15478, 15476, 15470, 15319, 15216, 15185, 15178, 15129, 15128, 15119, 15072, 15068, 14749, 14655, 14646, 14494, 14079, 13953, 13638, 13554, 13476, 13403, 13347, 13127, 13069, 13024, 13022, 13021, 12994, 12991, 12970, 12969, 12968, 12967, 12966, 12790, 12521, 12519, 12512, 12499, 12492, 12385, 12382, 12331, 12277, 12185, 12066, 11745, 11443, 11406, 10977, 10907, 10865, 10855, 10809, 10776, 10691, 10653, 10647, 10563, 10520, 10460, 10414, 10328, 10327, 10326, 10324, 10323, 10322, 10285, 10284, 10283, 10282))
Run Time: 0.004498
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 179 | 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: 188, 0, 1715142718, {"resource-19186":["resource",19186],"resource-19171":["resource",19171],"resource-19170":["resource",19170],"resource-19168":["resource",19168],"thread-16745":["thread",16745],"resource-18960":["resource",18960],"resource-18874":["resource",18874],"resource-18719":["resource",18719],"thread-16505":["thread",16505],"thread-16502":["thread",16502],"resource-18530":["resource",18530],"resource-18526":["resource",18526],"resource-18494":["resource",18494],"resource-18483":["resource",18483],"resource-18482":["resource",18482],"thread-16443":["thread",16443],"resource-18367":["resource",18367],"resource-18366":["resource",18366],"resource-18244":["resource",18244],"resource-18191":["resource",18191],"resource-18122":["resource",18122],"resource-18121":["resource",18121],"resource-18070":["resource",18070],"resource-18066":["resource",18066],"thread-16282":["thread",16282],"resource-18031":["resource",18031],"resource-17975":["resource",17975],"resource-17971":["resource",17971],"resource-17927":["resource",17927],"resource-17893":["resource",17893],"resource-17829":["resource",17829],"resource-17815":["resource",17815],"resource-17814":["resource",17814],"resource-17813":["resource",17813],"resource-17812":["resource",17812],"resource-17809":["resource",17809],"resource-17808":["resource",17808],"resource-17807":["resource",17807],"resource-17805":["resource",17805],"resource-17791":["resource",17791],"resource-17744":["resource",17744],"resource-17637":["resource",17637],"resource-17589":["resource",17589],"resource-17564":["resource",17564],"resource-17555":["resource",17555],"resource-17552":["resource",17552],"resource-17545":["resource",17545],"resource-17536":["resource",17536],"resource-17467":["resource",17467],"resource-17414":["resource",17414],"resource-17407":["resource",17407],"resource-17379":["resource",17379],"resource-17360":["resource",17360],"resource-17325":["resource",17325],"resource-17324":["resource",17324],"resource-17323":["resource",17323],"resource-17322":["resource",17322],"resource-17321":["resource",17321],"resource-17320":["resource",17320],"resource-17319":["resource",17319],"resource-17317":["resource",17317],"resource-17315":["resource",17315],"resource-17314":["resource",17314],"resource-17313":["resource",17313],"resource-17311":["resource",17311],"resource-17310":["resource",17310],"resource-17309":["resource",17309],"thread-16017":["thread",16017],"resource-17242":["resource",17242],"resource-17228":["resource",17228],"resource-17226":["resource",17226],"resource-17222":["resource",17222],"resource-17187":["resource",17187],"resource-17182":["resource",17182],"resource-17173":["resource",17173],"resource-17166":["resource",17166],"thread-15974":["thread",15974],"resource-17119":["resource",17119],"resource-17112":["resource",17112],"resource-17103":["resource",17103],"resource-17095":["resource",17095],"resource-17086":["resource",17086],"resource-17037":["resource",17037],"resource-16991":["resource",16991],"thread-15895":["thread",15895],"resource-16979":["resource",16979],"thread-15889":["thread",15889],"resource-16959":["resource",16959],"resource-16957":["resource",16957],"thread-15863":["thread",15863],"resource-16912":["resource",16912],"resource-16870":["resource",16870],"resource-16829":["resource",16829],"resource-16823":["resource",16823],"resource-16820":["resource",16820],"resource-16818":["resource",16818],"resource-16813":["resource",16813],"resource-16812":["resource",16812],"resource-16810":["resource",16810],"resource-16809":["resource",16809],"resource-16806":["resource",16806],"resource-16804":["resource",16804],"resource-16798":["resource",16798],"thread-15770":["thread",15770],"thread-15701":["thread",15701],"resource-16527":["resource",16527],"thread-15645":["thread",15645],"resource-16483":["resource",16483],"thread-15578":["thread",15578],"resource-16153":["resource",16153],"resource-16152":["resource",16152],"resource-16102":["resource",16102],"resource-15983":["resource",15983],"resource-15809":["resource",15809],"resource-15720":["resource",15720],"resource-15544":["resource",15544],"resource-15520":["resource",15520],"resource-15511":["resource",15511],"thread-15167":["thread",15167],"resource-15492":["resource",15492],"resource-15481":["resource",15481],"resource-15478":["resource",15478],"resource-15476":["resource",15476],"resource-15470":["resource",15470],"resource-15319":["resource",15319],"resource-15216":["resource",15216],"resource-15185":["resource",15185],"resource-15178":["resource",15178],"resource-15129":["resource",15129],"resource-15128":["resource",15128],"resource-15119":["resource",15119],"resource-15072":["resource",15072],"resource-15068":["resource",15068],"thread-14849":["thread",14849],"resource-14749":["resource",14749],"resource-14655":["resource",14655],"resource-14646":["resource",14646],"resource-14494":["resource",14494],"thread-14591":["thread",14591],"resource-14079":["resource",14079],"resource-13953":["resource",13953],"thread-14320":["thread",14320],"resource-13638":["resource",13638],"resource-13554":["resource",13554],"resource-13476":["resource",13476],"resource-13403":["resource",13403],"resource-13347":["resource",13347],"thread-14129":["thread",14129],"resource-13127":["resource",13127],"resource-13069":["resource",13069],"resource-13024":["resource",13024],"resource-13022":["resource",13022],"resource-13021":["resource",13021],"resource-12994":["resource",12994],"resource-12991":["resource",12991],"resource-12970":["resource",12970],"resource-12969":["resource",12969],"resource-12968":["resource",12968],"resource-12967":["resource",12967],"resource-12966":["resource",12966],"resource-12790":["resource",12790],"thread-13901":["thread",13901],"resource-12521":["resource",12521],"resource-12519":["resource",12519],"resource-12512":["resource",12512],"resource-12499":["resource",12499],"resource-12492":["resource",12492],"resource-12385":["resource",12385],"resource-12382":["resource",12382],"resource-12331":["resource",12331],"resource-12277":["resource",12277],"resource-12185":["resource",12185],"resource-12066":["resource",12066],"thread-13521":["thread",13521],"resource-11745":["resource",11745],"resource-11443":["resource",11443],"resource-11406":["resource",11406],"resource-10977":["resource",10977],"resource-10907":["resource",10907],"resource-10865":["resource",10865],"resource-10855":["resource",10855],"resource-10809":["resource",10809],"resource-10776":["resource",10776],"resource-10691":["resource",10691],"resource-10653":["resource",10653],"resource-10647":["resource",10647],"resource-10563":["resource",10563],"resource-10520":["resource",10520],"resource-10460":["resource",10460],"resource-10414":["resource",10414],"resource-10328":["resource",10328],"resource-10327":["resource",10327],"resource-10326":["resource",10326],"resource-10324":["resource",10324],"resource-10323":["resource",10323],"resource-10322":["resource",10322],"resource-10285":["resource",10285],"resource-10284":["resource",10284],"resource-10283":["resource",10283],"resource-10282":["resource",10282]}, NULL, 1715139118
Run Time: 0.000491
- 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