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 (19311, 19310, 19270, 19269, 19118, 19035, 19005, 18844, 18841, 18386, 18238, 17986, 17977, 17802, 17732, 17727, 17724, 17681, 17680, 17671, 17666, 17665, 17662, 17656, 17654, 17653, 17649, 17643, 17634, 17632, 17627, 17561, 17215, 16912, 16866, 16749, 16504, 16421, 16336, 16190, 16166, 16051, 15856, 15816, 15771, 15730, 15463, 15325, 15313, 15227, 15198, 15186, 15182, 15113, 15073, 14650, 14608, 14600, 14486, 14354, 14303, 14170, 13136, 12985, 12948, 12942, 12689, 12280, 12069, 11745, 11266, 10947, 10850, 10414, 10313, 9918, 9702, 9414, 9351, 9335, 9292, 9252, 9203, 9149, 9146, 9076, 9075, 9046, 9010, 9009, 9002, 8994, 8993, 8984, 8753, 8730, 8729, 8551, 8546, 8187, 8158, 7784, 7772, 7117, 7042, 6867, 6380, 6028, 5717, 5711, 5704, 5698, 5697, 5696, 5635, 5242, 4988, 4801, 4786, 4711, 4702, 4701, 4608, 4607, 3779, 3490, 3318, 3297, 2965, 2489, 2483, 2482, 2447, 2443, 2442, 2435, 2434, 2297, 2177, 2143, 2098, 2095, 2053, 2045, 2027, 2007, 2003, 1998, 1995, 1251, 1120, 748, 737, 724, 710, 709, 648, 647, 587, 583, 582, 563, 562, 561, 560, 558, 507, 502, 499, 485, 428, 427, 423, 406, 405, 404, 401, 393, 388, 353, 347, 346, 345, 344, 343, 342, 341, 340, 336, 334, 330, 317, 314, 311, 310, 309))
Run Time: 0.004607
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 196 | 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: 319, 0, 1715172467, {"resource-19311":["resource",19311],"resource-19310":["resource",19310],"resource-19270":["resource",19270],"resource-19269":["resource",19269],"resource-19118":["resource",19118],"resource-19035":["resource",19035],"resource-19005":["resource",19005],"resource-18844":["resource",18844],"resource-18841":["resource",18841],"resource-18386":["resource",18386],"resource-18238":["resource",18238],"resource-17986":["resource",17986],"resource-17977":["resource",17977],"resource-17802":["resource",17802],"resource-17732":["resource",17732],"resource-17727":["resource",17727],"resource-17724":["resource",17724],"resource-17681":["resource",17681],"resource-17680":["resource",17680],"resource-17671":["resource",17671],"resource-17666":["resource",17666],"resource-17665":["resource",17665],"resource-17662":["resource",17662],"resource-17656":["resource",17656],"resource-17654":["resource",17654],"resource-17653":["resource",17653],"resource-17649":["resource",17649],"resource-17643":["resource",17643],"resource-17634":["resource",17634],"resource-17632":["resource",17632],"resource-17627":["resource",17627],"resource-17561":["resource",17561],"resource-17215":["resource",17215],"thread-15889":["thread",15889],"resource-16912":["resource",16912],"resource-16866":["resource",16866],"resource-16749":["resource",16749],"thread-15701":["thread",15701],"resource-16504":["resource",16504],"resource-16421":["resource",16421],"resource-16336":["resource",16336],"resource-16190":["resource",16190],"resource-16166":["resource",16166],"resource-16051":["resource",16051],"resource-15856":["resource",15856],"resource-15816":["resource",15816],"resource-15771":["resource",15771],"resource-15730":["resource",15730],"resource-15463":["resource",15463],"resource-15325":["resource",15325],"resource-15313":["resource",15313],"resource-15227":["resource",15227],"resource-15198":["resource",15198],"resource-15186":["resource",15186],"resource-15182":["resource",15182],"resource-15113":["resource",15113],"resource-15073":["resource",15073],"resource-14650":["resource",14650],"resource-14608":["resource",14608],"resource-14600":["resource",14600],"resource-14486":["resource",14486],"resource-14354":["resource",14354],"resource-14303":["resource",14303],"resource-14170":["resource",14170],"resource-13136":["resource",13136],"resource-12985":["resource",12985],"resource-12948":["resource",12948],"resource-12942":["resource",12942],"resource-12689":["resource",12689],"resource-12280":["resource",12280],"resource-12069":["resource",12069],"resource-11745":["resource",11745],"resource-11266":["resource",11266],"resource-10947":["resource",10947],"resource-10850":["resource",10850],"resource-10414":["resource",10414],"resource-10313":["resource",10313],"resource-9918":["resource",9918],"resource-9702":["resource",9702],"resource-9414":["resource",9414],"resource-9351":["resource",9351],"resource-9335":["resource",9335],"resource-9292":["resource",9292],"resource-9252":["resource",9252],"resource-9203":["resource",9203],"resource-9149":["resource",9149],"resource-9146":["resource",9146],"resource-9076":["resource",9076],"resource-9075":["resource",9075],"resource-9046":["resource",9046],"resource-9010":["resource",9010],"resource-9009":["resource",9009],"resource-9002":["resource",9002],"resource-8994":["resource",8994],"resource-8993":["resource",8993],"resource-8984":["resource",8984],"resource-8753":["resource",8753],"resource-8730":["resource",8730],"resource-8729":["resource",8729],"resource-8551":["resource",8551],"resource-8546":["resource",8546],"resource-8187":["resource",8187],"resource-8158":["resource",8158],"resource-7784":["resource",7784],"resource-7772":["resource",7772],"resource-7117":["resource",7117],"thread-9402":["thread",9402],"resource-7042":["resource",7042],"resource-6867":["resource",6867],"resource-6380":["resource",6380],"resource-6028":["resource",6028],"resource-5717":["resource",5717],"resource-5711":["resource",5711],"resource-5704":["resource",5704],"resource-5698":["resource",5698],"resource-5697":["resource",5697],"resource-5696":["resource",5696],"resource-5635":["resource",5635],"resource-5242":["resource",5242],"resource-4988":["resource",4988],"resource-4801":["resource",4801],"resource-4786":["resource",4786],"resource-4711":["resource",4711],"resource-4702":["resource",4702],"resource-4701":["resource",4701],"resource-4608":["resource",4608],"resource-4607":["resource",4607],"resource-3779":["resource",3779],"resource-3490":["resource",3490],"resource-3318":["resource",3318],"resource-3297":["resource",3297],"resource-2965":["resource",2965],"resource-2489":["resource",2489],"resource-2483":["resource",2483],"resource-2482":["resource",2482],"resource-2447":["resource",2447],"resource-2443":["resource",2443],"resource-2442":["resource",2442],"resource-2435":["resource",2435],"resource-2434":["resource",2434],"resource-2297":["resource",2297],"resource-2177":["resource",2177],"resource-2143":["resource",2143],"resource-2098":["resource",2098],"resource-2095":["resource",2095],"resource-2053":["resource",2053],"resource-2045":["resource",2045],"resource-2027":["resource",2027],"resource-2007":["resource",2007],"resource-2003":["resource",2003],"resource-1998":["resource",1998],"resource-1995":["resource",1995],"thread-2100":["thread",2100],"resource-1251":["resource",1251],"resource-1120":["resource",1120],"resource-748":["resource",748],"resource-737":["resource",737],"resource-724":["resource",724],"resource-710":["resource",710],"resource-709":["resource",709],"resource-648":["resource",648],"resource-647":["resource",647],"resource-587":["resource",587],"resource-583":["resource",583],"resource-582":["resource",582],"resource-563":["resource",563],"resource-562":["resource",562],"resource-561":["resource",561],"resource-560":["resource",560],"resource-558":["resource",558],"resource-507":["resource",507],"resource-502":["resource",502],"resource-499":["resource",499],"resource-485":["resource",485],"resource-428":["resource",428],"resource-427":["resource",427],"resource-423":["resource",423],"resource-406":["resource",406],"resource-405":["resource",405],"resource-404":["resource",404],"resource-401":["resource",401],"resource-393":["resource",393],"resource-388":["resource",388],"resource-353":["resource",353],"resource-347":["resource",347],"resource-346":["resource",346],"resource-345":["resource",345],"resource-344":["resource",344],"resource-343":["resource",343],"resource-342":["resource",342],"resource-341":["resource",341],"resource-340":["resource",340],"resource-336":["resource",336],"resource-334":["resource",334],"resource-330":["resource",330],"resource-317":["resource",317],"resource-314":["resource",314],"resource-311":["resource",311],"resource-310":["resource",310],"resource-309":["resource",309]}, NULL, 1715168867
Run Time: 0.000447
- 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