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 (15807, 15437, 15120, 14966, 14963, 14165, 9683, 8419, 6626, 6621, 5714, 3327, 3297, 3228, 3226, 2915, 2914, 2861, 2639, 2435, 2434, 2354, 2293, 2292, 2291, 2290, 2289, 2287, 2285, 2283, 2282, 2263, 2238, 2224, 2044, 1995, 1901, 1894, 1892, 1891, 1890, 1889, 1866, 1848, 1736, 1490, 1446, 1305, 1257, 1224, 1212, 1202, 1146, 1130, 1125, 1122, 1120, 1111, 1108, 1106, 1105, 1099, 957, 936, 922, 816, 724, 709, 672, 610, 590, 589, 570, 569, 568, 567, 566, 507, 499, 428, 427, 402, 401, 377, 376, 368, 360, 339, 337, 318, 317, 316, 315, 314, 312, 306, 305, 304, 302, 301, 300, 294, 292, 291, 290, 289, 288, 287, 286, 279, 278, 277, 270, 269, 268, 267, 266, 264, 263, 262, 257, 256, 254, 248, 246, 243, 240, 238, 237, 236, 235, 233, 232, 231, 230, 229, 228, 218, 217, 215, 214, 213, 208, 205, 204, 199, 198, 195))
Run Time: 0.005194
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 148 | 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: 390, 0, 1716009287, {"resource-15807":["resource",15807],"resource-15437":["resource",15437],"resource-15120":["resource",15120],"resource-14966":["resource",14966],"resource-14963":["resource",14963],"resource-14165":["resource",14165],"resource-9683":["resource",9683],"resource-8419":["resource",8419],"resource-6626":["resource",6626],"resource-6621":["resource",6621],"resource-5714":["resource",5714],"resource-3327":["resource",3327],"resource-3297":["resource",3297],"resource-3228":["resource",3228],"resource-3226":["resource",3226],"resource-2915":["resource",2915],"resource-2914":["resource",2914],"resource-2861":["resource",2861],"resource-2639":["resource",2639],"resource-2435":["resource",2435],"resource-2434":["resource",2434],"resource-2354":["resource",2354],"resource-2293":["resource",2293],"resource-2292":["resource",2292],"resource-2291":["resource",2291],"resource-2290":["resource",2290],"resource-2289":["resource",2289],"resource-2287":["resource",2287],"resource-2285":["resource",2285],"resource-2283":["resource",2283],"resource-2282":["resource",2282],"resource-2238":["resource",2238],"resource-2224":["resource",2224],"resource-2044":["resource",2044],"resource-1995":["resource",1995],"resource-1901":["resource",1901],"resource-1894":["resource",1894],"resource-1892":["resource",1892],"resource-1891":["resource",1891],"resource-1890":["resource",1890],"resource-1889":["resource",1889],"resource-1866":["resource",1866],"resource-1848":["resource",1848],"resource-1736":["resource",1736],"resource-1490":["resource",1490],"resource-1446":["resource",1446],"resource-1305":["resource",1305],"resource-1257":["resource",1257],"resource-1224":["resource",1224],"resource-1212":["resource",1212],"resource-1202":["resource",1202],"resource-1146":["resource",1146],"resource-1130":["resource",1130],"resource-1125":["resource",1125],"resource-1122":["resource",1122],"resource-1120":["resource",1120],"resource-1111":["resource",1111],"resource-1108":["resource",1108],"resource-1106":["resource",1106],"resource-1105":["resource",1105],"resource-1099":["resource",1099],"resource-957":["resource",957],"resource-936":["resource",936],"resource-922":["resource",922],"resource-816":["resource",816],"resource-724":["resource",724],"resource-709":["resource",709],"resource-672":["resource",672],"resource-610":["resource",610],"resource-590":["resource",590],"resource-589":["resource",589],"resource-570":["resource",570],"resource-569":["resource",569],"resource-568":["resource",568],"resource-567":["resource",567],"resource-566":["resource",566],"resource-507":["resource",507],"resource-499":["resource",499],"resource-428":["resource",428],"resource-427":["resource",427],"resource-402":["resource",402],"resource-401":["resource",401],"resource-377":["resource",377],"resource-376":["resource",376],"resource-368":["resource",368],"resource-360":["resource",360],"resource-339":["resource",339],"resource-337":["resource",337],"resource-318":["resource",318],"resource-317":["resource",317],"resource-316":["resource",316],"resource-315":["resource",315],"resource-314":["resource",314],"resource-312":["resource",312],"resource-306":["resource",306],"resource-305":["resource",305],"resource-304":["resource",304],"resource-302":["resource",302],"resource-301":["resource",301],"resource-300":["resource",300],"resource-294":["resource",294],"resource-292":["resource",292],"resource-291":["resource",291],"resource-290":["resource",290],"resource-289":["resource",289],"resource-288":["resource",288],"resource-287":["resource",287],"resource-286":["resource",286],"resource-279":["resource",279],"resource-278":["resource",278],"resource-277":["resource",277],"resource-270":["resource",270],"resource-269":["resource",269],"resource-268":["resource",268],"resource-267":["resource",267],"resource-266":["resource",266],"resource-264":["resource",264],"resource-263":["resource",263],"resource-262":["resource",262],"resource-257":["resource",257],"resource-256":["resource",256],"resource-254":["resource",254],"resource-248":["resource",248],"resource-246":["resource",246],"resource-243":["resource",243],"resource-240":["resource",240],"resource-238":["resource",238],"resource-237":["resource",237],"resource-236":["resource",236],"resource-235":["resource",235],"resource-233":["resource",233],"resource-232":["resource",232],"resource-231":["resource",231],"resource-230":["resource",230],"resource-229":["resource",229],"resource-228":["resource",228],"resource-218":["resource",218],"resource-217":["resource",217],"resource-215":["resource",215],"resource-214":["resource",214],"resource-213":["resource",213],"resource-208":["resource",208],"resource-205":["resource",205],"resource-204":["resource",204],"resource-199":["resource",199],"resource-198":["resource",198],"resource-195":["resource",195]}, NULL, 1716005687
Run Time: 0.000401
- 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