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 (34492, 34491, 34490, 34488, 34487, 34485, 34484, 34482, 34479, 34478, 34477, 34476, 34475, 34473, 34472, 34471, 34470, 34465, 34464, 34463, 34462, 34461, 34460, 34459, 34458, 34457, 34456, 34455, 34454, 34453, 34452, 34451, 34450, 34449, 34448, 34447, 34446, 34435, 34434, 34433, 34430, 34428, 34427, 34426, 34425, 34413, 34406, 34405, 34404, 34402, 34401, 34395, 34394, 34392, 34385, 34384, 34383, 34382, 34381, 34380, 34376, 34375, 34374, 34373, 34372, 34370, 34369, 34368, 34367, 34366, 34365, 34357, 34356, 34347, 34346, 34345, 34344, 34343, 34342, 34341, 34339, 34338, 34337, 34330, 34329, 34328, 34327, 34326, 34325, 34324, 34321, 34318, 34317, 34316, 34296, 34294, 34292, 34291, 34290, 34284, 34283, 34282, 34279, 34278, 34276, 34275, 34274, 34273, 34269, 34268, 34266, 34264, 34262, 34261, 34260, 34259, 34258, 34257, 34256, 34255, 34248, 34246, 34245, 34244, 34242, 34241, 34230, 34226, 34225, 34224, 34223, 34222, 34220, 34219, 34214, 34213, 34208, 34206, 34205, 34204, 34203, 34202, 34183, 34181, 34180, 34179, 34178, 34177, 34164, 34154, 34152, 34151, 34150, 34149, 34146, 34145, 34144, 34139, 34138, 34137, 34135, 34133, 34129, 34128, 34122, 34112, 34111, 34110, 34109, 34104, 34103, 34102, 34101, 34100, 34099, 34098, 34097, 34095, 34094, 34093, 34091, 34090, 34089, 34088, 34087, 34081)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.005763
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY | PRIMARY | 4 | | 186 | 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: 10423, 0, 1576338862, 1576342462, [["xengallery_media",34492],["xengallery_media",34491],["xengallery_media",34490],["xengallery_media",34488],["xengallery_media",34487],["xengallery_media",34485],["xengallery_media",34484],["xengallery_media",34482],["xengallery_media",34479],["xengallery_media",34478],["xengallery_media",34477],["xengallery_media",34476],["xengallery_media",34475],["xengallery_media",34473],["xengallery_media",34472],["xengallery_media",34471],["xengallery_media",34470],["xengallery_media",34465],["xengallery_media",34464],["xengallery_media",34463],["xengallery_media",34462],["xengallery_media",34461],["xengallery_media",34460],["xengallery_media",34459],["xengallery_media",34458],["xengallery_media",34457],["xengallery_media",34456],["xengallery_media",34455],["xengallery_media",34454],["xengallery_media",34453],["xengallery_media",34452],["xengallery_media",34451],["xengallery_media",34450],["xengallery_media",34449],["xengallery_media",34448],["xengallery_media",34447],["xengallery_media",34446],["xengallery_media",34435],["xengallery_media",34434],["xengallery_media",34433],["xengallery_media",34430],["xengallery_media",34428],["xengallery_media",34427],["xengallery_media",34426],["xengallery_media",34425],["xengallery_media",34413],["xengallery_media",34406],["xengallery_media",34405],["xengallery_media",34404],["xengallery_media",34402],["xengallery_media",34401],["xengallery_media",34395],["xengallery_media",34394],["thread",56485],["xengallery_media",34392],["xengallery_media",34385],["xengallery_media",34384],["xengallery_media",34383],["xengallery_media",34382],["xengallery_media",34381],["xengallery_media",34380],["thread",56479],["xengallery_media",34376],["xengallery_media",34375],["xengallery_media",34374],["xengallery_media",34373],["xengallery_media",34372],["xengallery_media",34370],["xengallery_media",34369],["thread",56478],["xengallery_media",34368],["xengallery_media",34367],["xengallery_media",34366],["xengallery_media",34365],["xengallery_media",34357],["thread",56473],["xengallery_media",34356],["xengallery_media",34347],["xengallery_media",34346],["xengallery_media",34345],["xengallery_media",34344],["xengallery_media",34343],["xengallery_media",34342],["xengallery_media",34341],["xengallery_media",34339],["thread",56467],["xengallery_media",34338],["xengallery_media",34337],["xengallery_media",34330],["thread",56465],["xengallery_media",34329],["xengallery_media",34328],["xengallery_media",34327],["xengallery_media",34326],["xengallery_media",34325],["xengallery_media",34324],["xengallery_media",34321],["xengallery_media",34318],["xengallery_media",34317],["xengallery_media",34316],["xengallery_media",34296],["xengallery_media",34294],["xengallery_media",34292],["xengallery_media",34291],["xengallery_media",34290],["xengallery_media",34284],["xengallery_media",34283],["xengallery_media",34282],["xengallery_media",34279],["xengallery_media",34278],["xengallery_media",34276],["xengallery_media",34275],["xengallery_media",34274],["xengallery_media",34273],["xengallery_media",34269],["xengallery_media",34268],["xengallery_media",34266],["xengallery_media",34264],["xengallery_media",34262],["xengallery_media",34261],["xengallery_media",34260],["xengallery_media",34259],["thread",56447],["xengallery_media",34258],["xengallery_media",34257],["xengallery_media",34256],["xengallery_media",34255],["thread",56444],["xengallery_media",34248],["xengallery_media",34246],["xengallery_media",34245],["xengallery_media",34244],["xengallery_media",34242],["xengallery_media",34241],["xengallery_media",34230],["thread",56432],["xengallery_media",34226],["xengallery_media",34225],["xengallery_media",34224],["xengallery_media",34223],["xengallery_media",34222],["xengallery_media",34220],["xengallery_media",34219],["xengallery_media",34214],["xengallery_media",34213],["xengallery_media",34208],["xengallery_media",34206],["thread",56420],["xengallery_media",34205],["xengallery_media",34204],["xengallery_media",34203],["xengallery_media",34202],["xengallery_media",34183],["xengallery_media",34181],["xengallery_media",34180],["xengallery_media",34179],["thread",56408],["xengallery_media",34178],["xengallery_media",34177],["xengallery_media",34164],["xengallery_media",34154],["xengallery_media",34152],["xengallery_media",34151],["xengallery_media",34150],["xengallery_media",34149],["xengallery_media",34146],["xengallery_media",34145],["xengallery_media",34144],["xengallery_media",34139],["xengallery_media",34138],["xengallery_media",34137],["xengallery_media",34135],["thread",56377],["thread",56376],["xengallery_media",34133],["xengallery_media",34129],["xengallery_media",34128],["xengallery_media",34122],["xengallery_media",34112],["xengallery_media",34111],["xengallery_media",34110],["xengallery_media",34109],["xengallery_media",34104],["xengallery_media",34103],["xengallery_media",34102],["xengallery_media",34101],["xengallery_media",34100],["xengallery_media",34099],["xengallery_media",34098],["xengallery_media",34097],["thread",56355],["xengallery_media",34095],["xengallery_media",34094],["xengallery_media",34093],["xengallery_media",34091],["xengallery_media",34090],["xengallery_media",34089],["xengallery_media",34088],["xengallery_media",34087],["xengallery_media",34081]]
Run Time: 0.001212