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 (19058, 18961, 18654, 18390, 17735, 17734, 17733, 17732, 17731, 17730, 17729, 17728, 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, 17624, 17623, 17622, 17620, 17619, 17618, 17317, 17316, 17315, 17314, 17313, 17310, 17309, 17287, 17286, 17285, 17284, 17283, 17282, 17281, 17279, 17277, 17276, 17275, 17274, 16428, 16367, 16357, 16183, 16052, 15764, 15475, 15432, 15431, 15421, 14984, 14983, 14150, 14149, 14144, 14140, 12898, 9091, 5971, 5834, 5796, 5770, 5769, 5171, 4198, 3786, 3714, 3409, 2625, 2118, 2117, 1998, 1948, 1947, 1945, 1944, 1931, 1910, 1895, 1868, 1859, 1838, 1589, 1160, 1146, 1143, 1104, 1102, 1097, 1080, 952, 927, 926, 925, 922, 882, 827, 813, 780, 737, 711, 710, 709, 648, 647, 592, 591, 590, 589, 584, 583, 582, 564, 563, 562, 561, 560, 559, 558, 557, 556, 555, 553, 552, 435, 433, 421, 420, 419, 418, 417, 416, 415, 414, 413, 412, 411, 410, 409, 168, 101))
Run Time: 0.004541
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 194 | 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: 248, 0, 1716010913, {"resource-19058":["resource",19058],"resource-18961":["resource",18961],"resource-18654":["resource",18654],"resource-18390":["resource",18390],"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-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-17624":["resource",17624],"resource-17623":["resource",17623],"resource-17622":["resource",17622],"resource-17620":["resource",17620],"resource-17619":["resource",17619],"resource-17618":["resource",17618],"resource-17317":["resource",17317],"resource-17316":["resource",17316],"resource-17315":["resource",17315],"resource-17314":["resource",17314],"resource-17313":["resource",17313],"resource-17310":["resource",17310],"resource-17309":["resource",17309],"resource-17287":["resource",17287],"resource-17286":["resource",17286],"resource-17285":["resource",17285],"resource-17284":["resource",17284],"resource-17283":["resource",17283],"resource-17282":["resource",17282],"resource-17281":["resource",17281],"resource-17279":["resource",17279],"resource-17277":["resource",17277],"resource-17276":["resource",17276],"resource-17275":["resource",17275],"resource-17274":["resource",17274],"resource-16428":["resource",16428],"resource-16367":["resource",16367],"resource-16357":["resource",16357],"resource-16183":["resource",16183],"resource-16052":["resource",16052],"resource-15764":["resource",15764],"resource-15475":["resource",15475],"resource-15432":["resource",15432],"resource-15431":["resource",15431],"resource-15421":["resource",15421],"resource-14984":["resource",14984],"resource-14983":["resource",14983],"resource-14150":["resource",14150],"resource-14149":["resource",14149],"resource-14144":["resource",14144],"resource-14140":["resource",14140],"resource-12898":["resource",12898],"resource-9091":["resource",9091],"resource-5971":["resource",5971],"resource-5834":["resource",5834],"resource-5796":["resource",5796],"resource-5770":["resource",5770],"resource-5769":["resource",5769],"resource-5171":["resource",5171],"resource-4198":["resource",4198],"resource-3786":["resource",3786],"resource-3714":["resource",3714],"resource-3409":["resource",3409],"resource-2625":["resource",2625],"resource-2118":["resource",2118],"resource-2117":["resource",2117],"resource-1998":["resource",1998],"resource-1948":["resource",1948],"resource-1947":["resource",1947],"resource-1945":["resource",1945],"resource-1944":["resource",1944],"resource-1931":["resource",1931],"resource-1910":["resource",1910],"resource-1895":["resource",1895],"resource-1868":["resource",1868],"resource-1859":["resource",1859],"resource-1838":["resource",1838],"resource-1589":["resource",1589],"resource-1160":["resource",1160],"resource-1146":["resource",1146],"resource-1143":["resource",1143],"resource-1104":["resource",1104],"resource-1102":["resource",1102],"resource-1097":["resource",1097],"resource-1080":["resource",1080],"resource-952":["resource",952],"resource-927":["resource",927],"resource-926":["resource",926],"resource-925":["resource",925],"resource-922":["resource",922],"resource-882":["resource",882],"resource-827":["resource",827],"resource-813":["resource",813],"resource-780":["resource",780],"resource-737":["resource",737],"resource-711":["resource",711],"resource-710":["resource",710],"resource-709":["resource",709],"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-435":["resource",435],"resource-433":["resource",433],"resource-421":["resource",421],"resource-420":["resource",420],"resource-419":["resource",419],"resource-418":["resource",418],"resource-417":["resource",417],"resource-416":["resource",416],"resource-415":["resource",415],"resource-414":["resource",414],"resource-413":["resource",413],"resource-412":["resource",412],"resource-411":["resource",411],"resource-410":["resource",410],"resource-409":["resource",409],"resource-168":["resource",168],"resource-101":["resource",101]}, NULL, 1716007313
Run Time: 0.000390
- 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