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 (18974, 18940, 18924, 18917, 18901, 18883, 18856, 18845, 18844, 18841, 18830, 18820, 18802, 18728, 18709, 18689, 18685, 18684, 18675, 18601, 18432, 18394, 18327, 18315, 18264, 18263, 18249, 18238, 18231, 18217, 18200, 18154, 18087, 18086, 18073, 18050, 18049, 18009, 18008, 17914, 17850, 17837, 17831, 17823, 17822, 17821, 17803, 17769, 17731, 17728, 17726, 17723, 17722, 17698, 17670, 17665, 17664, 17652, 17648, 17645, 17639, 17638, 17634, 17631, 17628, 17621, 17562, 17560, 17543, 17484, 17439, 17389, 17357, 17356, 17267, 17001, 16994, 16929, 16912, 16866, 16864, 16551, 16532, 16485, 16410, 16366, 16348, 16137, 16093, 15923, 15872, 15863, 15785, 15729, 15706, 15705, 15666, 15634, 15496, 15493, 15226, 15122, 15113, 14727, 14697, 14613, 14607, 14604, 14598, 14326, 14200, 13641, 13465, 13411, 13205, 13107, 12898, 12853, 12846, 12808, 12708, 12611, 12519, 12517, 12415, 12323, 12322, 12070, 12068, 11961, 11864, 11804, 11564, 11529, 11528, 11513, 11462, 11391, 11246, 11203, 10946, 10637, 10596, 10461, 10460, 10269, 10153, 10118, 10106, 10066, 9853, 9661, 9659, 9636, 9629, 9509, 9496, 9479, 9472, 9396, 9363, 9315, 9281, 9270, 9257, 8783, 8744, 8728, 8377, 8275, 8161, 7964, 7692, 7639, 7537, 7518, 7503, 7430, 7357, 7260, 7237, 7224, 7101, 7092, 7091, 7065, 6995, 6988, 6700, 6616, 6578, 6464, 6463, 6418, 6414, 6384, 6382))
Run Time: 0.005926
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 197 | 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: 261, 0, 1711713680, {"resource-18974":["resource",18974],"resource-18940":["resource",18940],"resource-18924":["resource",18924],"resource-18917":["resource",18917],"resource-18901":["resource",18901],"resource-18883":["resource",18883],"resource-18856":["resource",18856],"resource-18845":["resource",18845],"resource-18844":["resource",18844],"resource-18841":["resource",18841],"thread-16638":["thread",16638],"resource-18830":["resource",18830],"resource-18820":["resource",18820],"resource-18802":["resource",18802],"resource-18728":["resource",18728],"resource-18709":["resource",18709],"resource-18689":["resource",18689],"resource-18685":["resource",18685],"resource-18684":["resource",18684],"resource-18675":["resource",18675],"resource-18601":["resource",18601],"resource-18432":["resource",18432],"resource-18394":["resource",18394],"resource-18327":["resource",18327],"resource-18315":["resource",18315],"resource-18264":["resource",18264],"resource-18263":["resource",18263],"resource-18249":["resource",18249],"resource-18238":["resource",18238],"resource-18231":["resource",18231],"resource-18217":["resource",18217],"resource-18200":["resource",18200],"resource-18154":["resource",18154],"resource-18087":["resource",18087],"resource-18086":["resource",18086],"resource-18073":["resource",18073],"resource-18050":["resource",18050],"resource-18049":["resource",18049],"resource-18009":["resource",18009],"resource-18008":["resource",18008],"resource-17914":["resource",17914],"resource-17850":["resource",17850],"resource-17837":["resource",17837],"resource-17831":["resource",17831],"resource-17823":["resource",17823],"resource-17822":["resource",17822],"resource-17821":["resource",17821],"resource-17803":["resource",17803],"resource-17769":["resource",17769],"resource-17731":["resource",17731],"resource-17728":["resource",17728],"resource-17726":["resource",17726],"resource-17723":["resource",17723],"resource-17722":["resource",17722],"resource-17698":["resource",17698],"resource-17670":["resource",17670],"resource-17665":["resource",17665],"resource-17664":["resource",17664],"resource-17652":["resource",17652],"resource-17648":["resource",17648],"resource-17645":["resource",17645],"resource-17639":["resource",17639],"resource-17638":["resource",17638],"resource-17634":["resource",17634],"resource-17631":["resource",17631],"resource-17628":["resource",17628],"resource-17621":["resource",17621],"resource-17562":["resource",17562],"resource-17560":["resource",17560],"resource-17543":["resource",17543],"resource-17484":["resource",17484],"resource-17439":["resource",17439],"resource-17389":["resource",17389],"resource-17357":["resource",17357],"resource-17356":["resource",17356],"resource-17267":["resource",17267],"resource-17001":["resource",17001],"resource-16994":["resource",16994],"resource-16929":["resource",16929],"resource-16912":["resource",16912],"resource-16866":["resource",16866],"resource-16864":["resource",16864],"resource-16551":["resource",16551],"resource-16532":["resource",16532],"resource-16485":["resource",16485],"resource-16410":["resource",16410],"resource-16366":["resource",16366],"resource-16348":["resource",16348],"resource-16137":["resource",16137],"resource-16093":["resource",16093],"resource-15923":["resource",15923],"resource-15872":["resource",15872],"resource-15863":["resource",15863],"resource-15785":["resource",15785],"resource-15729":["resource",15729],"resource-15706":["resource",15706],"resource-15705":["resource",15705],"resource-15666":["resource",15666],"resource-15634":["resource",15634],"resource-15496":["resource",15496],"resource-15493":["resource",15493],"resource-15226":["resource",15226],"resource-15122":["resource",15122],"resource-15113":["resource",15113],"thread-14997":["thread",14997],"resource-14727":["resource",14727],"resource-14697":["resource",14697],"resource-14613":["resource",14613],"resource-14607":["resource",14607],"resource-14604":["resource",14604],"resource-14598":["resource",14598],"resource-14326":["resource",14326],"resource-14200":["resource",14200],"resource-13641":["resource",13641],"resource-13465":["resource",13465],"resource-13411":["resource",13411],"resource-13205":["resource",13205],"resource-13107":["resource",13107],"resource-12898":["resource",12898],"resource-12853":["resource",12853],"resource-12846":["resource",12846],"resource-12808":["resource",12808],"resource-12708":["resource",12708],"resource-12611":["resource",12611],"resource-12519":["resource",12519],"resource-12517":["resource",12517],"resource-12415":["resource",12415],"resource-12323":["resource",12323],"resource-12322":["resource",12322],"resource-12070":["resource",12070],"resource-12068":["resource",12068],"resource-11961":["resource",11961],"resource-11864":["resource",11864],"resource-11804":["resource",11804],"resource-11564":["resource",11564],"resource-11529":["resource",11529],"resource-11528":["resource",11528],"resource-11513":["resource",11513],"resource-11462":["resource",11462],"resource-11391":["resource",11391],"resource-11246":["resource",11246],"resource-11203":["resource",11203],"resource-10946":["resource",10946],"resource-10637":["resource",10637],"resource-10596":["resource",10596],"resource-10461":["resource",10461],"resource-10460":["resource",10460],"thread-12570":["thread",12570],"resource-10269":["resource",10269],"resource-10153":["resource",10153],"resource-10118":["resource",10118],"resource-10106":["resource",10106],"resource-10066":["resource",10066],"resource-9853":["resource",9853],"resource-9661":["resource",9661],"resource-9659":["resource",9659],"resource-9636":["resource",9636],"resource-9629":["resource",9629],"resource-9509":["resource",9509],"resource-9496":["resource",9496],"resource-9479":["resource",9479],"resource-9472":["resource",9472],"resource-9396":["resource",9396],"resource-9363":["resource",9363],"resource-9315":["resource",9315],"resource-9281":["resource",9281],"resource-9270":["resource",9270],"resource-9257":["resource",9257],"resource-8783":["resource",8783],"resource-8744":["resource",8744],"resource-8728":["resource",8728],"resource-8377":["resource",8377],"resource-8275":["resource",8275],"resource-8161":["resource",8161],"resource-7964":["resource",7964],"resource-7692":["resource",7692],"resource-7639":["resource",7639],"resource-7537":["resource",7537],"resource-7518":["resource",7518],"resource-7503":["resource",7503],"resource-7430":["resource",7430],"resource-7357":["resource",7357],"resource-7260":["resource",7260],"resource-7237":["resource",7237],"resource-7224":["resource",7224],"resource-7101":["resource",7101],"resource-7092":["resource",7092],"resource-7091":["resource",7091],"resource-7065":["resource",7065],"resource-6995":["resource",6995],"resource-6988":["resource",6988],"resource-6700":["resource",6700],"resource-6616":["resource",6616],"resource-6578":["resource",6578],"resource-6464":["resource",6464],"resource-6463":["resource",6463],"resource-6418":["resource",6418],"resource-6414":["resource",6414],"resource-6384":["resource",6384],"resource-6382":["resource",6382]}, NULL, 1711710080
Run Time: 0.001041
- 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