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 (19329, 19326, 18960, 18846, 18845, 18713, 18418, 18018, 17850, 17837, 17735, 17734, 17733, 17732, 17731, 17730, 17729, 17728, 17727, 17726, 17725, 17724, 17723, 17722, 17684, 17683, 17682, 17681, 17680, 17679, 17678, 17677, 17676, 17675, 17674, 17673, 17672, 17671, 17670, 17669, 17668, 17667, 17666, 17665, 17664, 17663, 17662, 17661, 17660, 17659, 17658, 17657, 17656, 17655, 17654, 17653, 17652, 17651, 17650, 17649, 17648, 17647, 17646, 17645, 17644, 17643, 17642, 17635, 17634, 17633, 17632, 17631, 17630, 17629, 17628, 17627, 17626, 17625, 17624, 17623, 17622, 17621, 17620, 17619, 17618, 17609, 17348, 17335, 16770, 16759, 16752, 16662, 16568, 16504, 16234, 15873, 15331, 15149, 15121, 14378, 14211, 14186, 14185, 14165, 14150, 13935, 13548, 13487, 13078, 13064, 13011, 12906, 12898, 12897, 12846, 12828, 12827, 12674, 12661, 12658, 12578, 12513, 12497, 12488, 12438, 12408, 12407, 12403, 11513, 10782, 10627, 9718, 8846, 8783, 8654, 8418, 7769, 7744, 7579, 7244, 7206, 6972, 6627, 6422, 6036, 6035, 5512, 5033, 4513, 4512, 4481, 4475, 4474, 3888, 3740, 3729, 3726, 3329, 3328, 3227, 2913, 2905, 2618, 2589, 2333, 2296, 2195, 2078, 2077, 2076, 2075, 1830, 1828, 1827, 1819, 1621, 1578, 931, 882, 844, 829, 546, 545, 544, 543, 542, 453, 452))
Run Time: 0.006600
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 188 | 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: 721, 0, 1716268220, {"resource-19329":["resource",19329],"resource-19326":["resource",19326],"thread-16698":["thread",16698],"resource-18960":["resource",18960],"resource-18846":["resource",18846],"resource-18845":["resource",18845],"resource-18713":["resource",18713],"thread-16480":["thread",16480],"resource-18418":["resource",18418],"thread-16362":["thread",16362],"resource-18018":["resource",18018],"resource-17850":["resource",17850],"resource-17837":["resource",17837],"resource-17735":["resource",17735],"resource-17734":["resource",17734],"resource-17733":["resource",17733],"resource-17732":["resource",17732],"resource-17731":["resource",17731],"resource-17730":["resource",17730],"resource-17729":["resource",17729],"resource-17728":["resource",17728],"resource-17727":["resource",17727],"resource-17726":["resource",17726],"resource-17725":["resource",17725],"resource-17724":["resource",17724],"resource-17723":["resource",17723],"resource-17722":["resource",17722],"resource-17684":["resource",17684],"resource-17683":["resource",17683],"resource-17682":["resource",17682],"resource-17681":["resource",17681],"resource-17680":["resource",17680],"resource-17679":["resource",17679],"resource-17678":["resource",17678],"resource-17677":["resource",17677],"resource-17676":["resource",17676],"resource-17675":["resource",17675],"resource-17674":["resource",17674],"resource-17673":["resource",17673],"resource-17672":["resource",17672],"resource-17671":["resource",17671],"resource-17670":["resource",17670],"resource-17669":["resource",17669],"resource-17668":["resource",17668],"resource-17667":["resource",17667],"resource-17666":["resource",17666],"resource-17665":["resource",17665],"resource-17664":["resource",17664],"resource-17663":["resource",17663],"resource-17662":["resource",17662],"resource-17661":["resource",17661],"resource-17660":["resource",17660],"resource-17659":["resource",17659],"resource-17658":["resource",17658],"resource-17657":["resource",17657],"resource-17656":["resource",17656],"resource-17655":["resource",17655],"resource-17654":["resource",17654],"resource-17653":["resource",17653],"resource-17652":["resource",17652],"resource-17651":["resource",17651],"resource-17650":["resource",17650],"resource-17649":["resource",17649],"resource-17648":["resource",17648],"resource-17647":["resource",17647],"resource-17646":["resource",17646],"resource-17645":["resource",17645],"resource-17644":["resource",17644],"resource-17643":["resource",17643],"resource-17642":["resource",17642],"resource-17635":["resource",17635],"resource-17634":["resource",17634],"resource-17633":["resource",17633],"resource-17632":["resource",17632],"resource-17631":["resource",17631],"resource-17630":["resource",17630],"resource-17629":["resource",17629],"resource-17628":["resource",17628],"resource-17627":["resource",17627],"resource-17626":["resource",17626],"resource-17625":["resource",17625],"resource-17624":["resource",17624],"resource-17623":["resource",17623],"resource-17622":["resource",17622],"resource-17621":["resource",17621],"resource-17620":["resource",17620],"resource-17619":["resource",17619],"resource-17618":["resource",17618],"resource-17609":["resource",17609],"resource-17348":["resource",17348],"resource-17335":["resource",17335],"thread-15889":["thread",15889],"resource-16770":["resource",16770],"resource-16759":["resource",16759],"resource-16752":["resource",16752],"resource-16662":["resource",16662],"resource-16568":["resource",16568],"resource-16504":["resource",16504],"resource-16234":["resource",16234],"resource-15873":["resource",15873],"resource-15331":["resource",15331],"thread-15080":["thread",15080],"resource-15149":["resource",15149],"resource-15121":["resource",15121],"resource-14378":["resource",14378],"thread-14513":["thread",14513],"resource-14211":["resource",14211],"resource-14186":["resource",14186],"resource-14185":["resource",14185],"thread-14452":["thread",14452],"resource-14165":["resource",14165],"resource-14150":["resource",14150],"resource-13935":["resource",13935],"resource-13548":["resource",13548],"resource-13487":["resource",13487],"resource-13078":["resource",13078],"resource-13064":["resource",13064],"resource-13011":["resource",13011],"resource-12906":["resource",12906],"resource-12898":["resource",12898],"resource-12897":["resource",12897],"resource-12846":["resource",12846],"resource-12828":["resource",12828],"resource-12827":["resource",12827],"resource-12674":["resource",12674],"resource-12661":["resource",12661],"resource-12658":["resource",12658],"resource-12578":["resource",12578],"resource-12513":["resource",12513],"resource-12497":["resource",12497],"resource-12488":["resource",12488],"resource-12438":["resource",12438],"resource-12408":["resource",12408],"resource-12407":["resource",12407],"resource-12403":["resource",12403],"resource-11513":["resource",11513],"resource-10782":["resource",10782],"resource-10627":["resource",10627],"resource-9718":["resource",9718],"resource-8846":["resource",8846],"resource-8783":["resource",8783],"resource-8654":["resource",8654],"resource-8418":["resource",8418],"resource-7769":["resource",7769],"resource-7744":["resource",7744],"resource-7579":["resource",7579],"resource-7244":["resource",7244],"resource-7206":["resource",7206],"resource-6972":["resource",6972],"resource-6627":["resource",6627],"resource-6422":["resource",6422],"resource-6036":["resource",6036],"resource-6035":["resource",6035],"resource-5512":["resource",5512],"resource-4513":["resource",4513],"resource-4512":["resource",4512],"resource-4481":["resource",4481],"resource-4475":["resource",4475],"resource-4474":["resource",4474],"resource-3888":["resource",3888],"resource-3740":["resource",3740],"resource-3729":["resource",3729],"resource-3726":["resource",3726],"resource-3329":["resource",3329],"resource-3328":["resource",3328],"resource-3227":["resource",3227],"resource-2913":["resource",2913],"resource-2905":["resource",2905],"resource-2618":["resource",2618],"resource-2589":["resource",2589],"resource-2333":["resource",2333],"resource-2296":["resource",2296],"resource-2195":["resource",2195],"thread-2939":["thread",2939],"resource-2078":["resource",2078],"resource-2077":["resource",2077],"resource-2076":["resource",2076],"resource-2075":["resource",2075],"resource-1830":["resource",1830],"resource-1828":["resource",1828],"resource-1827":["resource",1827],"resource-1819":["resource",1819],"resource-1621":["resource",1621],"resource-1578":["resource",1578],"resource-931":["resource",931],"resource-882":["resource",882],"resource-844":["resource",844],"resource-829":["resource",829],"resource-546":["resource",546],"resource-545":["resource",545],"resource-544":["resource",544],"resource-543":["resource",543],"resource-542":["resource",542],"resource-453":["resource",453],"resource-452":["resource",452]}, NULL, 1716264620
Run Time: 0.000350
- 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