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 (19406, 18874, 18451, 18450, 18244, 18179, 18139, 17995, 17994, 17905, 17904, 17896, 17895, 17890, 17889, 17837, 17592, 17591, 17553, 17347, 17227, 16632, 16154, 16067, 15412, 15411, 15141, 15120, 15119, 14971, 14929, 14868, 14563, 14434, 13955, 13941, 13904, 13057, 12689, 12439, 12431, 12415, 12356, 12329, 12316, 12308, 12285, 12037, 11961, 11918, 11864, 11853, 11805, 11804, 11758, 11747, 11732, 11698, 11643, 11607, 11564, 11554, 11506, 11473, 11391, 11354, 11314, 11306, 11305, 11299, 11248, 11241, 11103, 10937, 10935, 10903, 10896, 10880, 10879, 10878, 10877, 10866, 10853, 10789, 10782, 10746, 10695, 10691, 10653, 10625, 10622, 10596, 10520, 10496, 10468, 10461, 10439, 10418, 10407, 10395, 10298, 10270, 10238, 10174, 10131, 10092, 10064, 10063, 10058, 10049, 9877, 9871, 9805, 9801, 9796, 9750, 9734, 9722, 9721, 9720, 9719, 9718, 9697, 9694, 9685, 9658, 9653, 9615, 9613, 9610, 9597, 9596, 9546, 9545, 9511, 9493, 9481, 9475, 9473, 9396, 9373, 9371, 9351, 9335, 9333, 9330, 9310, 9299, 9294, 9292, 9286, 9281, 9262, 9257, 9251, 9241, 9231, 9211, 9203, 9180, 9175, 9162, 9147, 9137, 9124, 9077, 9075, 9073, 9057, 9049, 9048, 9043, 9021, 9001, 8997, 8994, 8993, 8984, 8980, 8973, 8950, 8942, 8921, 8903, 8897, 8889, 8866, 8849, 8799, 8789, 8757, 8754, 8729, 8628, 8609))
Run Time: 0.004567
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 195 | 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: 2137, 0, 1716094786, {"resource-19406":["resource",19406],"resource-18874":["resource",18874],"resource-18451":["resource",18451],"resource-18450":["resource",18450],"resource-18244":["resource",18244],"thread-16362":["thread",16362],"resource-18179":["resource",18179],"resource-18139":["resource",18139],"resource-17995":["resource",17995],"resource-17994":["resource",17994],"resource-17905":["resource",17905],"resource-17904":["resource",17904],"resource-17896":["resource",17896],"resource-17895":["resource",17895],"resource-17890":["resource",17890],"resource-17889":["resource",17889],"resource-17837":["resource",17837],"resource-17592":["resource",17592],"resource-17591":["resource",17591],"resource-17553":["resource",17553],"resource-17347":["resource",17347],"resource-17227":["resource",17227],"thread-15767":["thread",15767],"resource-16632":["resource",16632],"resource-16154":["resource",16154],"resource-16067":["resource",16067],"thread-15243":["thread",15243],"resource-15412":["resource",15412],"resource-15411":["resource",15411],"resource-15141":["resource",15141],"resource-15120":["resource",15120],"resource-15119":["resource",15119],"resource-14971":["resource",14971],"resource-14929":["resource",14929],"resource-14868":["resource",14868],"resource-14563":["resource",14563],"resource-14434":["resource",14434],"resource-13955":["resource",13955],"resource-13941":["resource",13941],"resource-13904":["resource",13904],"thread-14268":["thread",14268],"resource-13057":["resource",13057],"resource-12689":["resource",12689],"resource-12439":["resource",12439],"resource-12431":["resource",12431],"resource-12415":["resource",12415],"resource-12356":["resource",12356],"resource-12329":["resource",12329],"resource-12316":["resource",12316],"resource-12308":["resource",12308],"resource-12285":["resource",12285],"resource-12037":["resource",12037],"resource-11961":["resource",11961],"resource-11918":["resource",11918],"resource-11864":["resource",11864],"resource-11853":["resource",11853],"resource-11805":["resource",11805],"resource-11804":["resource",11804],"resource-11758":["resource",11758],"resource-11747":["resource",11747],"resource-11732":["resource",11732],"resource-11698":["resource",11698],"resource-11643":["resource",11643],"resource-11607":["resource",11607],"resource-11564":["resource",11564],"resource-11554":["resource",11554],"resource-11506":["resource",11506],"resource-11473":["resource",11473],"resource-11391":["resource",11391],"resource-11354":["resource",11354],"resource-11314":["resource",11314],"resource-11306":["resource",11306],"resource-11305":["resource",11305],"resource-11299":["resource",11299],"resource-11248":["resource",11248],"resource-11241":["resource",11241],"resource-11103":["resource",11103],"resource-10937":["resource",10937],"resource-10935":["resource",10935],"resource-10903":["resource",10903],"resource-10896":["resource",10896],"resource-10880":["resource",10880],"resource-10879":["resource",10879],"resource-10878":["resource",10878],"resource-10877":["resource",10877],"resource-10866":["resource",10866],"resource-10853":["resource",10853],"resource-10789":["resource",10789],"resource-10782":["resource",10782],"resource-10746":["resource",10746],"resource-10695":["resource",10695],"resource-10691":["resource",10691],"resource-10653":["resource",10653],"resource-10625":["resource",10625],"resource-10622":["resource",10622],"resource-10596":["resource",10596],"resource-10520":["resource",10520],"resource-10496":["resource",10496],"resource-10468":["resource",10468],"resource-10461":["resource",10461],"resource-10439":["resource",10439],"resource-10418":["resource",10418],"resource-10407":["resource",10407],"resource-10395":["resource",10395],"resource-10298":["resource",10298],"resource-10270":["resource",10270],"resource-10238":["resource",10238],"resource-10174":["resource",10174],"resource-10131":["resource",10131],"thread-12376":["thread",12376],"resource-10092":["resource",10092],"resource-10064":["resource",10064],"resource-10063":["resource",10063],"resource-10058":["resource",10058],"resource-10049":["resource",10049],"resource-9877":["resource",9877],"resource-9871":["resource",9871],"resource-9805":["resource",9805],"resource-9801":["resource",9801],"resource-9796":["resource",9796],"resource-9750":["resource",9750],"resource-9734":["resource",9734],"resource-9722":["resource",9722],"resource-9721":["resource",9721],"resource-9720":["resource",9720],"resource-9719":["resource",9719],"resource-9718":["resource",9718],"resource-9697":["resource",9697],"resource-9694":["resource",9694],"resource-9685":["resource",9685],"resource-9658":["resource",9658],"resource-9653":["resource",9653],"resource-9615":["resource",9615],"resource-9613":["resource",9613],"resource-9610":["resource",9610],"resource-9597":["resource",9597],"resource-9596":["resource",9596],"resource-9546":["resource",9546],"resource-9545":["resource",9545],"resource-9511":["resource",9511],"resource-9493":["resource",9493],"resource-9481":["resource",9481],"resource-9475":["resource",9475],"resource-9473":["resource",9473],"resource-9396":["resource",9396],"resource-9373":["resource",9373],"resource-9371":["resource",9371],"resource-9351":["resource",9351],"resource-9335":["resource",9335],"resource-9333":["resource",9333],"resource-9330":["resource",9330],"resource-9310":["resource",9310],"resource-9299":["resource",9299],"resource-9294":["resource",9294],"resource-9292":["resource",9292],"resource-9286":["resource",9286],"resource-9281":["resource",9281],"resource-9262":["resource",9262],"resource-9257":["resource",9257],"resource-9251":["resource",9251],"resource-9241":["resource",9241],"resource-9231":["resource",9231],"resource-9211":["resource",9211],"resource-9203":["resource",9203],"resource-9180":["resource",9180],"resource-9175":["resource",9175],"resource-9162":["resource",9162],"resource-9147":["resource",9147],"resource-9137":["resource",9137],"resource-9124":["resource",9124],"resource-9077":["resource",9077],"resource-9075":["resource",9075],"resource-9073":["resource",9073],"resource-9057":["resource",9057],"resource-9049":["resource",9049],"resource-9048":["resource",9048],"resource-9043":["resource",9043],"resource-9021":["resource",9021],"resource-9001":["resource",9001],"resource-8997":["resource",8997],"resource-8994":["resource",8994],"resource-8993":["resource",8993],"resource-8984":["resource",8984],"resource-8980":["resource",8980],"resource-8973":["resource",8973],"resource-8950":["resource",8950],"resource-8942":["resource",8942],"resource-8921":["resource",8921],"resource-8903":["resource",8903],"resource-8897":["resource",8897],"resource-8889":["resource",8889],"resource-8866":["resource",8866],"resource-8849":["resource",8849],"resource-8799":["resource",8799],"resource-8789":["resource",8789],"resource-8757":["resource",8757],"resource-8754":["resource",8754],"resource-8729":["resource",8729],"resource-8628":["resource",8628],"resource-8609":["resource",8609]}, NULL, 1716091186
Run Time: 0.000474
- 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