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, 19136, 19135, 19134, 19133, 19095, 19092, 19049, 19031, 19029, 19028, 18920, 18919, 18733, 18731, 18723, 18430, 18427, 18425, 18424, 18423, 18422, 18421, 18420, 18419, 18408, 18386, 18310, 18181, 18172, 18019, 18002, 17942, 17878, 17856, 17855, 17854, 17853, 17815, 17814, 17813, 17807, 17784, 17544, 17514, 17503, 17487, 17372, 17366, 17365, 17091, 17090, 17078, 16915, 16909, 16504, 16303, 16002, 16001, 15999, 15968, 15856, 15413, 15411, 15113, 14434, 13958, 13955, 13941, 13754, 13512, 13483, 12884, 12820, 12680, 12611, 11604, 11225, 11141, 10918, 10747, 10691, 10687, 10679, 10563, 10520, 10512, 10509, 10499, 10447, 10444, 10426, 10392, 10375, 10371, 10360, 10357, 10353, 10350, 10347, 10342, 10335, 10122, 10113, 10098, 10081, 10072, 10061, 10056, 10051, 10035, 9298, 9285, 7083, 5838, 5837, 5834, 5286, 4640, 4013, 3276, 2118, 2117, 1160, 1146, 1097, 922, 911, 833, 780, 711, 710, 709, 672, 648, 647, 592, 591, 590, 589, 584, 583, 582, 564, 563, 562, 561, 560, 559, 558, 557, 556, 555, 553, 552, 541, 467, 466, 465, 464, 461, 423, 406, 405, 404, 347, 160, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 142, 141, 140, 139, 138, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123))
Run Time: 0.005011
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: 123, 0, 1716101245, {"resource-19138":["resource",19138],"resource-19137":["resource",19137],"resource-19136":["resource",19136],"resource-19135":["resource",19135],"resource-19134":["resource",19134],"resource-19133":["resource",19133],"resource-19095":["resource",19095],"resource-19092":["resource",19092],"resource-19049":["resource",19049],"resource-19031":["resource",19031],"resource-19029":["resource",19029],"resource-19028":["resource",19028],"resource-18920":["resource",18920],"resource-18919":["resource",18919],"resource-18733":["resource",18733],"resource-18731":["resource",18731],"resource-18723":["resource",18723],"resource-18430":["resource",18430],"resource-18427":["resource",18427],"resource-18425":["resource",18425],"resource-18424":["resource",18424],"resource-18423":["resource",18423],"resource-18422":["resource",18422],"resource-18421":["resource",18421],"resource-18420":["resource",18420],"resource-18419":["resource",18419],"resource-18408":["resource",18408],"resource-18386":["resource",18386],"resource-18310":["resource",18310],"resource-18181":["resource",18181],"resource-18172":["resource",18172],"resource-18019":["resource",18019],"resource-18002":["resource",18002],"resource-17942":["resource",17942],"resource-17878":["resource",17878],"resource-17856":["resource",17856],"resource-17855":["resource",17855],"resource-17854":["resource",17854],"resource-17853":["resource",17853],"resource-17815":["resource",17815],"resource-17814":["resource",17814],"resource-17813":["resource",17813],"resource-17807":["resource",17807],"resource-17784":["resource",17784],"resource-17544":["resource",17544],"resource-17514":["resource",17514],"resource-17503":["resource",17503],"resource-17487":["resource",17487],"resource-17372":["resource",17372],"resource-17366":["resource",17366],"resource-17365":["resource",17365],"resource-17091":["resource",17091],"resource-17090":["resource",17090],"resource-17078":["resource",17078],"resource-16915":["resource",16915],"resource-16909":["resource",16909],"resource-16504":["resource",16504],"resource-16303":["resource",16303],"resource-16002":["resource",16002],"resource-16001":["resource",16001],"resource-15999":["resource",15999],"resource-15968":["resource",15968],"resource-15856":["resource",15856],"resource-15413":["resource",15413],"resource-15411":["resource",15411],"resource-15113":["resource",15113],"resource-14434":["resource",14434],"resource-13958":["resource",13958],"resource-13955":["resource",13955],"resource-13941":["resource",13941],"resource-13754":["resource",13754],"resource-13512":["resource",13512],"resource-13483":["resource",13483],"resource-12884":["resource",12884],"resource-12820":["resource",12820],"resource-12680":["resource",12680],"resource-12611":["resource",12611],"resource-11604":["resource",11604],"resource-11225":["resource",11225],"resource-11141":["resource",11141],"resource-10918":["resource",10918],"resource-10747":["resource",10747],"resource-10691":["resource",10691],"resource-10687":["resource",10687],"resource-10679":["resource",10679],"resource-10563":["resource",10563],"resource-10520":["resource",10520],"resource-10512":["resource",10512],"resource-10509":["resource",10509],"resource-10499":["resource",10499],"resource-10447":["resource",10447],"resource-10444":["resource",10444],"resource-10426":["resource",10426],"resource-10392":["resource",10392],"resource-10375":["resource",10375],"resource-10371":["resource",10371],"resource-10360":["resource",10360],"resource-10357":["resource",10357],"resource-10353":["resource",10353],"resource-10350":["resource",10350],"resource-10347":["resource",10347],"resource-10342":["resource",10342],"resource-10335":["resource",10335],"resource-10122":["resource",10122],"resource-10113":["resource",10113],"resource-10098":["resource",10098],"resource-10081":["resource",10081],"resource-10072":["resource",10072],"resource-10061":["resource",10061],"resource-10056":["resource",10056],"resource-10051":["resource",10051],"resource-10035":["resource",10035],"resource-9298":["resource",9298],"resource-9285":["resource",9285],"resource-7083":["resource",7083],"resource-5838":["resource",5838],"resource-5837":["resource",5837],"resource-5834":["resource",5834],"resource-5286":["resource",5286],"resource-4640":["resource",4640],"resource-4013":["resource",4013],"resource-3276":["resource",3276],"thread-3487":["thread",3487],"resource-2118":["resource",2118],"resource-2117":["resource",2117],"resource-1160":["resource",1160],"resource-1146":["resource",1146],"resource-1097":["resource",1097],"resource-922":["resource",922],"resource-911":["resource",911],"resource-833":["resource",833],"resource-780":["resource",780],"resource-711":["resource",711],"resource-710":["resource",710],"resource-709":["resource",709],"resource-672":["resource",672],"resource-648":["resource",648],"resource-647":["resource",647],"resource-592":["resource",592],"resource-591":["resource",591],"resource-590":["resource",590],"resource-589":["resource",589],"resource-584":["resource",584],"resource-583":["resource",583],"resource-582":["resource",582],"resource-564":["resource",564],"resource-563":["resource",563],"resource-562":["resource",562],"resource-561":["resource",561],"resource-560":["resource",560],"resource-559":["resource",559],"resource-558":["resource",558],"resource-557":["resource",557],"resource-556":["resource",556],"resource-555":["resource",555],"resource-553":["resource",553],"resource-552":["resource",552],"resource-541":["resource",541],"resource-467":["resource",467],"resource-466":["resource",466],"resource-465":["resource",465],"resource-464":["resource",464],"resource-461":["resource",461],"resource-423":["resource",423],"resource-406":["resource",406],"resource-405":["resource",405],"resource-404":["resource",404],"resource-347":["resource",347],"resource-160":["resource",160],"resource-153":["resource",153],"resource-152":["resource",152],"resource-151":["resource",151],"resource-150":["resource",150],"resource-149":["resource",149],"resource-148":["resource",148],"resource-147":["resource",147],"resource-146":["resource",146],"resource-145":["resource",145],"resource-144":["resource",144],"resource-143":["resource",143],"resource-142":["resource",142],"resource-141":["resource",141],"resource-140":["resource",140],"resource-139":["resource",139],"resource-138":["resource",138],"resource-137":["resource",137],"resource-136":["resource",136],"resource-135":["resource",135],"resource-134":["resource",134],"resource-133":["resource",133],"resource-132":["resource",132],"resource-131":["resource",131],"resource-130":["resource",130],"resource-129":["resource",129],"resource-128":["resource",128],"resource-127":["resource",127],"resource-126":["resource",126],"resource-125":["resource",125],"resource-124":["resource",124],"resource-123":["resource",123]}, NULL, 1716097645
Run Time: 0.000499
- 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