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 (19318, 19316, 19315, 19310, 19270, 19269, 19240, 19235, 19232, 19149, 19148, 19101, 19044, 18986, 18970, 18969, 18908, 18907, 18844, 18841, 18840, 18823, 18816, 18815, 18814, 18802, 18747, 18714, 18702, 18696, 18679, 18592, 18504, 18486, 18468, 18466, 18432, 18414, 18384, 18238, 18232, 18218, 18207, 18166, 18140, 18135, 18111, 18110, 18109, 18074, 18054, 18047, 18046, 17995, 17994, 17981, 17929, 17914, 17905, 17904, 17896, 17895, 17890, 17889, 17888, 17887, 17878, 17877, 17869, 17868, 17867, 17860, 17859, 17858, 17857, 17849, 17848, 17835, 17834, 17832, 17783, 17755, 17717, 17616, 17584, 17566, 17560, 17487, 17367, 17359, 17357, 17348, 17347, 17336, 17333, 17330, 17329, 17239, 17238, 17215, 17201, 17176, 17083, 17082, 17081, 17055, 17053, 17030, 16944, 16918, 16908, 16892, 16888, 16865, 16815, 16788, 16759, 16757, 16755, 16742, 16724, 16672, 16657, 16635, 16551, 16536, 16509, 16508, 16483, 16449, 16266, 16118, 16110, 16077, 16044, 16041, 15989, 15977, 15956, 15947, 15927, 15907, 15872, 15826, 15814, 15778, 15734, 15642, 15640, 15630, 15629, 15595, 15590, 15525, 15520, 15412, 15394, 15313, 15302, 15227, 15188, 15159, 15142, 15124, 15119, 15065, 15054, 14984, 14983, 14978, 14973, 14971, 14945, 14929, 14918, 14896, 14887, 14824, 14785, 14778, 14660, 14659, 14631, 14586, 14517, 14513, 14500, 14416, 14408, 14310, 14294, 14293, 14292, 14276, 14214, 14199))
Run Time: 0.004098
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: 442, 0, 1714983299, {"resource-19318":["resource",19318],"resource-19316":["resource",19316],"resource-19315":["resource",19315],"resource-19310":["resource",19310],"resource-19270":["resource",19270],"resource-19269":["resource",19269],"resource-19240":["resource",19240],"resource-19235":["resource",19235],"resource-19232":["resource",19232],"resource-19149":["resource",19149],"resource-19148":["resource",19148],"resource-19101":["resource",19101],"resource-19044":["resource",19044],"resource-18986":["resource",18986],"resource-18970":["resource",18970],"resource-18969":["resource",18969],"resource-18908":["resource",18908],"resource-18907":["resource",18907],"resource-18844":["resource",18844],"resource-18841":["resource",18841],"resource-18840":["resource",18840],"resource-18823":["resource",18823],"resource-18816":["resource",18816],"resource-18815":["resource",18815],"resource-18814":["resource",18814],"resource-18802":["resource",18802],"resource-18747":["resource",18747],"resource-18714":["resource",18714],"resource-18702":["resource",18702],"resource-18696":["resource",18696],"resource-18679":["resource",18679],"resource-18592":["resource",18592],"resource-18504":["resource",18504],"resource-18486":["resource",18486],"resource-18468":["resource",18468],"resource-18466":["resource",18466],"resource-18432":["resource",18432],"resource-18414":["resource",18414],"resource-18384":["resource",18384],"resource-18238":["resource",18238],"resource-18232":["resource",18232],"resource-18218":["resource",18218],"resource-18207":["resource",18207],"resource-18166":["resource",18166],"resource-18140":["resource",18140],"resource-18135":["resource",18135],"resource-18111":["resource",18111],"resource-18110":["resource",18110],"resource-18109":["resource",18109],"resource-18074":["resource",18074],"resource-18054":["resource",18054],"resource-18047":["resource",18047],"resource-18046":["resource",18046],"resource-17995":["resource",17995],"resource-17994":["resource",17994],"resource-17981":["resource",17981],"resource-17929":["resource",17929],"resource-17914":["resource",17914],"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-17888":["resource",17888],"resource-17887":["resource",17887],"resource-17878":["resource",17878],"resource-17877":["resource",17877],"resource-17869":["resource",17869],"resource-17868":["resource",17868],"resource-17867":["resource",17867],"resource-17860":["resource",17860],"resource-17859":["resource",17859],"resource-17858":["resource",17858],"resource-17857":["resource",17857],"resource-17849":["resource",17849],"resource-17848":["resource",17848],"resource-17835":["resource",17835],"resource-17834":["resource",17834],"resource-17832":["resource",17832],"resource-17783":["resource",17783],"resource-17755":["resource",17755],"resource-17717":["resource",17717],"thread-16138":["thread",16138],"resource-17616":["resource",17616],"resource-17584":["resource",17584],"resource-17566":["resource",17566],"resource-17560":["resource",17560],"resource-17487":["resource",17487],"resource-17367":["resource",17367],"resource-17359":["resource",17359],"resource-17357":["resource",17357],"resource-17348":["resource",17348],"resource-17347":["resource",17347],"resource-17336":["resource",17336],"resource-17333":["resource",17333],"resource-17330":["resource",17330],"resource-17329":["resource",17329],"resource-17239":["resource",17239],"resource-17238":["resource",17238],"resource-17215":["resource",17215],"resource-17201":["resource",17201],"resource-17176":["resource",17176],"resource-17083":["resource",17083],"resource-17082":["resource",17082],"resource-17081":["resource",17081],"resource-17055":["resource",17055],"resource-17053":["resource",17053],"resource-17030":["resource",17030],"resource-16944":["resource",16944],"resource-16918":["resource",16918],"resource-16908":["resource",16908],"resource-16892":["resource",16892],"resource-16888":["resource",16888],"resource-16865":["resource",16865],"resource-16815":["resource",16815],"resource-16788":["resource",16788],"resource-16759":["resource",16759],"resource-16757":["resource",16757],"resource-16755":["resource",16755],"resource-16742":["resource",16742],"resource-16724":["resource",16724],"resource-16672":["resource",16672],"resource-16657":["resource",16657],"resource-16635":["resource",16635],"resource-16551":["resource",16551],"resource-16536":["resource",16536],"resource-16509":["resource",16509],"resource-16508":["resource",16508],"resource-16483":["resource",16483],"resource-16449":["resource",16449],"resource-16266":["resource",16266],"thread-15561":["thread",15561],"resource-16118":["resource",16118],"resource-16110":["resource",16110],"resource-16077":["resource",16077],"resource-16044":["resource",16044],"resource-16041":["resource",16041],"resource-15989":["resource",15989],"resource-15977":["resource",15977],"resource-15956":["resource",15956],"resource-15947":["resource",15947],"resource-15927":["resource",15927],"resource-15907":["resource",15907],"resource-15872":["resource",15872],"resource-15826":["resource",15826],"resource-15814":["resource",15814],"resource-15778":["resource",15778],"resource-15734":["resource",15734],"resource-15642":["resource",15642],"resource-15640":["resource",15640],"resource-15630":["resource",15630],"resource-15629":["resource",15629],"resource-15595":["resource",15595],"resource-15590":["resource",15590],"resource-15525":["resource",15525],"resource-15520":["resource",15520],"resource-15412":["resource",15412],"resource-15394":["resource",15394],"resource-15313":["resource",15313],"resource-15302":["resource",15302],"resource-15227":["resource",15227],"resource-15188":["resource",15188],"resource-15159":["resource",15159],"resource-15142":["resource",15142],"resource-15124":["resource",15124],"resource-15119":["resource",15119],"resource-15065":["resource",15065],"resource-15054":["resource",15054],"resource-14984":["resource",14984],"resource-14983":["resource",14983],"resource-14978":["resource",14978],"resource-14973":["resource",14973],"resource-14971":["resource",14971],"resource-14945":["resource",14945],"resource-14929":["resource",14929],"thread-14916":["thread",14916],"resource-14918":["resource",14918],"resource-14896":["resource",14896],"resource-14887":["resource",14887],"resource-14824":["resource",14824],"resource-14785":["resource",14785],"resource-14778":["resource",14778],"resource-14660":["resource",14660],"resource-14659":["resource",14659],"resource-14631":["resource",14631],"resource-14586":["resource",14586],"resource-14517":["resource",14517],"resource-14513":["resource",14513],"resource-14500":["resource",14500],"resource-14416":["resource",14416],"resource-14408":["resource",14408],"thread-14591":["thread",14591],"resource-14310":["resource",14310],"resource-14294":["resource",14294],"resource-14293":["resource",14293],"resource-14292":["resource",14292],"resource-14276":["resource",14276],"resource-14214":["resource",14214],"resource-14199":["resource",14199]}, NULL, 1714979699
Run Time: 0.000345
- 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