SELECT media.*
,
album.*, albumviewperm.*,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, media.username, user.username) AS username,
attachment.attachment_id, attachment.data_id, attachment.attach_date,data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xengallery_media AS media
LEFT JOIN xengallery_album AS album ON
(album.album_id = media.album_id)
LEFT JOIN xengallery_album_permission as albumviewperm ON
(album.album_id = albumviewperm.album_id AND albumviewperm.permission = 'view')
LEFT JOIN xengallery_category AS category ON
(category.category_id = media.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = media.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = media.user_id)
LEFT JOIN xf_attachment AS attachment ON
(attachment.content_type = 'xengallery_media' AND attachment.attachment_id = media.attachment_id)
LEFT JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE (
media.media_privacy = 'public'
OR IF(media.category_id > 0, media.category_id IN (1, 2, 500, 501, 502, 504, 505, 506, 507, 508, 509, 510, 511, 512, 515, 516, 519, 522, 523, 525, 529, 530, 533, 546, 548, 549, 550, 551, 552, 553, 554, 556, 565, 567, 569, 573, 583, 590, 592, 593, 600, 608, 611, 616, 620, 668), NULL)) AND (media.media_id IN (28885, 26105, 25807, 24465, 23904, 23903, 23902, 23417, 23272, 23271, 22127, 21101, 21041, 21005, 20942, 20938, 20773, 20670, 20492, 20365, 19814, 19776, 19747, 19734, 19641, 19535, 19474, 19362, 19107, 19038, 19001, 18988, 18969, 18824, 18726, 18723, 18673, 18671, 18532, 18528, 18219, 18203, 18195, 18178, 18101, 18100, 17994, 17981, 17814, 17498, 17497, 17492, 17463, 17456, 17432, 17426, 17352, 17183, 17172, 17165, 17078, 16980, 16976, 16966, 16867, 16447, 16365, 16313, 16311, 16292, 16290, 16213, 16212, 16159, 16154, 16117, 16111, 15952, 15926, 15856, 15834, 15533, 15480, 15436, 15419, 15414, 15201, 15167, 15135, 15081, 15076, 15057, 15047, 15017, 14885, 14884, 14830, 14706, 14675, 14557, 14556, 14555, 14554, 14136, 14130, 14117, 14083, 14081, 14060, 14057, 14027, 14014, 14013, 13976, 13975, 13961, 13929, 13928, 13903, 13790, 13788, 13787, 13732, 13701, 13651, 13648, 13647, 13646, 13645, 13644, 13643, 13642, 13633, 13613, 13578, 13567, 13558, 13538, 13533, 13520, 13519, 13432, 13378, 13158, 12833, 12802, 12767, 12730, 12719, 12713, 12642, 12641, 12561, 12538, 12534, 12531, 12432, 12431, 12375, 12358, 12260, 12195, 12124, 12090, 12080, 12078, 12062, 11879, 11749, 11623, 11619, 11617, 11468, 11428, 11426, 11423, 11383, 11319, 11265, 11262, 11202, 11146, 11121, 11108, 11105, 11099, 11086, 11063, 11062, 11045, 11044, 11033, 11027, 10919, 10878, 10876, 10873, 10813, 10740, 10739)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.004370
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | xen.media.album_id | 1 | Using where |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | xen.album.album_id,const | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | xen.media.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xen.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | xen.media.attachment_id | 1 | |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xen.attachment.data_id | 1 | |
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: 69, 0, 1753452867, 1753456467, [["xengallery_media",28885],["xengallery_media",26105],["xengallery_media",25807],["xengallery_media",24465],["xengallery_media",23904],["xengallery_media",23903],["xengallery_media",23902],["xengallery_media",23417],["xengallery_media",23272],["xengallery_media",23271],["xengallery_media",22127],["xengallery_media",21101],["xengallery_media",21041],["xengallery_media",21005],["xengallery_media",20942],["xengallery_media",20938],["xengallery_media",20773],["xengallery_media",20670],["xengallery_media",20492],["xengallery_media",20365],["xengallery_media",19814],["xengallery_media",19776],["xengallery_media",19747],["xengallery_media",19734],["xengallery_media",19641],["xengallery_media",19535],["xengallery_media",19474],["xengallery_media",19362],["xengallery_media",19107],["xengallery_media",19038],["xengallery_media",19001],["xengallery_media",18988],["xengallery_media",18969],["xengallery_media",18824],["xengallery_media",18726],["xengallery_media",18723],["xengallery_media",18673],["xengallery_media",18671],["xengallery_media",18532],["xengallery_media",18528],["xengallery_media",18219],["xengallery_media",18203],["xengallery_media",18195],["xengallery_media",18178],["xengallery_media",18101],["xengallery_media",18100],["xengallery_media",17994],["xengallery_media",17981],["xengallery_media",17814],["xengallery_media",17498],["xengallery_media",17497],["xengallery_media",17492],["xengallery_media",17463],["xengallery_media",17456],["xengallery_media",17432],["xengallery_media",17426],["xengallery_media",17352],["xengallery_media",17183],["xengallery_media",17172],["xengallery_media",17165],["xengallery_media",17078],["xengallery_media",16980],["xengallery_media",16976],["xengallery_media",16966],["xengallery_media",16867],["xengallery_media",16447],["xengallery_media",16365],["xengallery_media",16313],["xengallery_media",16311],["xengallery_media",16292],["xengallery_media",16290],["xengallery_media",16213],["xengallery_media",16212],["xengallery_media",16159],["xengallery_media",16154],["xengallery_media",16117],["xengallery_media",16111],["xengallery_media",15952],["xengallery_media",15926],["xengallery_media",15856],["xengallery_media",15834],["xengallery_media",15533],["xengallery_media",15480],["xengallery_media",15436],["xengallery_media",15419],["xengallery_media",15414],["xengallery_media",15201],["xengallery_media",15167],["xengallery_media",15135],["xengallery_media",15081],["xengallery_media",15076],["xengallery_media",15057],["xengallery_media",15047],["xengallery_media",15017],["xengallery_media",14885],["xengallery_media",14884],["xengallery_media",14830],["xengallery_media",14706],["xengallery_media",14675],["xengallery_media",14557],["xengallery_media",14556],["xengallery_media",14555],["xengallery_media",14554],["xengallery_media",14136],["xengallery_media",14130],["xengallery_media",14117],["xengallery_media",14083],["xengallery_media",14081],["xengallery_media",14060],["xengallery_media",14057],["xengallery_media",14027],["xengallery_media",14014],["xengallery_media",14013],["xengallery_media",13976],["xengallery_media",13975],["xengallery_media",13961],["xengallery_media",13929],["xengallery_media",13928],["xengallery_media",13903],["xengallery_media",13790],["xengallery_media",13788],["xengallery_media",13787],["xengallery_media",13732],["xengallery_media",13701],["xengallery_media",13651],["xengallery_media",13648],["xengallery_media",13647],["xengallery_media",13646],["xengallery_media",13645],["xengallery_media",13644],["xengallery_media",13643],["xengallery_media",13642],["xengallery_media",13633],["xengallery_media",13613],["xengallery_media",13578],["xengallery_media",13567],["xengallery_media",13558],["xengallery_media",13538],["xengallery_media",13533],["xengallery_media",13520],["xengallery_media",13519],["xengallery_media",13432],["xengallery_media",13378],["xengallery_media",13158],["xengallery_media",12833],["xengallery_media",12802],["xengallery_media",12767],["xengallery_media",12730],["xengallery_media",12719],["xengallery_media",12713],["xengallery_media",12642],["xengallery_media",12641],["xengallery_media",12561],["xengallery_media",12538],["xengallery_media",12534],["xengallery_media",12531],["xengallery_media",12432],["xengallery_media",12431],["xengallery_media",12375],["xengallery_media",12358],["xengallery_media",12260],["xengallery_media",12195],["xengallery_media",12124],["xengallery_media",12090],["xengallery_media",12080],["xengallery_media",12078],["xengallery_media",12062],["xengallery_media",11879],["xengallery_media",11749],["xengallery_media",11623],["xengallery_media",11619],["xengallery_media",11617],["xengallery_media",11468],["xengallery_media",11428],["xengallery_media",11426],["xengallery_media",11423],["xengallery_media",11383],["xengallery_media",11319],["xengallery_media",11265],["xengallery_media",11262],["xengallery_media",11202],["xengallery_media",11146],["xengallery_media",11121],["xengallery_media",11108],["xengallery_media",11105],["xengallery_media",11099],["xengallery_media",11086],["xengallery_media",11063],["xengallery_media",11062],["xengallery_media",11045],["xengallery_media",11044],["xengallery_media",11033],["xengallery_media",11027],["xengallery_media",10919],["xengallery_media",10878],["xengallery_media",10876],["xengallery_media",10873],["xengallery_media",10813],["xengallery_media",10740],["xengallery_media",10739]]
Run Time: 0.000970