SELECT resource.*
,
category.*, category.last_update AS category_last_update, resource.last_update,
resource_update.message AS description,
version.version_string,
version.release_date,
version.download_url,
version.rating_count AS version_rating_count,
version.rating_sum AS version_rating_sum,
version.download_count AS version_download_count,
user.*, user_profile.*, IF(user.username IS NULL, resource.username, user.username) AS username,
permission.cache_value AS category_permission_cache
FROM xf_resource AS resource
LEFT JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_resource_update AS resource_update ON
(resource_update.resource_update_id = resource.description_update_id)
LEFT JOIN xf_resource_version AS version ON
(version.resource_version_id = resource.current_version_id)
LEFT JOIN xf_user AS user ON
(user.user_id = resource.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = resource.user_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'resource_category'
AND permission.content_id = resource.resource_category_id)
WHERE resource.resource_id IN (399, 397, 396, 395, 393, 392, 391, 389, 388, 387, 385, 384, 383, 382, 381, 380, 379, 377, 376, 375, 374, 373, 372, 371, 370, 369, 368, 367, 366, 365, 363, 362, 361, 360, 358, 357, 355, 353, 352, 348, 347, 346, 345, 344, 343, 342, 341, 340, 337, 335, 334, 333, 330, 328, 324, 323, 321, 319, 317, 314, 313, 312, 307, 306, 305, 302, 301, 300, 298, 296, 295, 294, 292, 291, 289, 288, 286, 285, 284, 282, 278, 275, 276, 274, 271, 270, 269, 268, 265, 262, 261, 260, 259, 256, 255, 254, 252, 250, 247, 245, 244, 243, 241, 237, 220, 218, 212, 195, 191, 185, 182, 181, 176, 169, 166, 164, 161, 155, 156, 151, 152, 148, 149, 145, 142, 141, 140, 139, 138, 136, 135)
Run Time: 0.010348
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | PRIMARY | | | | 148 | Using where |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.resource_category_id | 1 | Using where |
SIMPLE | resource_update | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.description_update_id | 1 | |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.user_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,psychopa_vanilla.resource.resource_category_id | 1 | Using where |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 53, 0, 1714822524, 1714826124, {"0":["resource",399],"1":["resource",397],"2":["resource",396],"3":["resource",395],"4":["resource",393],"5":["resource",392],"6":["resource",391],"7":["resource",389],"8":["resource",388],"9":["resource",387],"10":["resource",385],"11":["resource",384],"12":["resource",383],"13":["resource",382],"14":["resource",381],"15":["resource",380],"16":["resource",379],"17":["resource",377],"18":["resource",376],"19":["resource",375],"20":["resource",374],"21":["resource",373],"22":["resource",372],"23":["resource",371],"24":["resource",370],"25":["resource",369],"26":["resource",368],"27":["resource",367],"28":["resource",366],"29":["resource",365],"30":["resource",363],"31":["resource",362],"32":["resource",361],"33":["resource",360],"34":["resource",358],"35":["resource",357],"36":["resource",355],"37":["resource",353],"38":["resource",352],"40":["resource",347],"41":["resource",346],"42":["resource",345],"45":["resource",342],"46":["resource",341],"47":["resource",340],"48":["resource",337],"49":["resource",335],"50":["resource",334],"51":["resource",333],"52":["resource",330],"53":["resource",328],"54":["resource",324],"55":["resource",323],"56":["resource",321],"57":["resource",319],"58":["resource",317],"59":["resource",314],"60":["resource",313],"61":["resource",312],"62":["resource",307],"63":["resource",306],"64":["resource",305],"65":["resource",302],"66":["resource",301],"67":["resource",300],"68":["resource",298],"69":["resource",296],"70":["resource",295],"71":["resource",294],"72":["resource",292],"73":["resource",291],"74":["resource",289],"75":["resource",288],"76":["resource",286],"77":["resource",285],"78":["resource",284],"79":["resource",282],"80":["resource",278],"81":["resource",275],"82":["resource",276],"83":["resource",274],"84":["resource",271],"85":["resource",270],"86":["resource",269],"87":["resource",268],"88":["resource",265],"89":["resource",262],"90":["resource",261],"91":["resource",260],"92":["resource",259],"93":["resource",256],"94":["resource",255],"95":["resource",254],"96":["resource",252],"97":["resource",250],"98":["resource",247],"99":["resource",245],"100":["resource",244],"101":["resource",243],"102":["resource",241],"103":["resource",237],"104":["resource",220],"105":["resource",218],"106":["resource",212],"107":["resource",195],"108":["resource",191],"109":["resource",185],"110":["resource",182],"111":["resource",181],"112":["resource",176],"113":["resource",169],"114":["resource",166],"115":["resource",164],"116":["resource",161],"117":["resource",155],"118":["resource",156],"119":["resource",151],"120":["resource",152],"121":["resource",148],"122":["resource",149],"123":["resource",145],"124":["resource",142],"125":["resource",141],"126":["resource",140],"127":["resource",139],"128":["resource",138],"129":["resource",136],"130":["resource",135]}
Run Time: 0.001176