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 (34479, 34478, 34477, 34476, 34475, 34447, 34446, 34445, 34413, 34394, 34375, 34374, 34373, 34242, 34241, 34154, 34146, 34113, 34099, 34098, 34097, 34084, 34080, 34079, 33960, 33941, 33937, 33926, 33860, 33831, 33807, 33806, 33769, 33751, 33732, 33671, 33541, 33344, 33261, 33181, 33180, 33098, 33082, 33080, 33079, 33078, 33077, 33075, 33074, 33061, 33060, 33038, 32993, 32992, 32854, 32808, 32779, 32708, 32707, 32586, 32525, 32330, 32321, 32320, 32311, 32310, 32140, 32031, 31904, 31892, 31891, 31889, 31888, 31711, 31584, 31517, 31180, 31090, 30862, 30412, 30270, 29864, 29605, 29604, 29485, 29484, 29483, 29482, 29481, 29480, 29479, 29478, 29477, 29466, 29462, 29458, 29431, 29402, 29322, 29321, 29320, 29314, 29298, 29297, 29296, 29284, 29283, 29282, 29281, 29280, 29279, 29278, 29277, 29276, 29275, 29274, 29273, 29272, 29271, 29270, 29269, 29268, 29267, 29234, 29233, 29226, 29225, 29224, 29223, 29222, 29221, 29220, 29219, 29218, 29217, 29216, 29215, 29213, 29212, 29211, 29210, 29209, 29208, 29207)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.002760
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY | PRIMARY | 4 | | 144 | 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: 64, 0, 1576338752, 1576342352, [["xengallery_media",34479],["xengallery_media",34478],["xengallery_media",34477],["xengallery_media",34476],["xengallery_media",34475],["xengallery_media",34447],["thread",56510],["xengallery_media",34446],["xengallery_media",34445],["xengallery_media",34413],["xengallery_media",34394],["thread",56479],["xengallery_media",34375],["xengallery_media",34374],["xengallery_media",34373],["xengallery_media",34242],["xengallery_media",34241],["thread",56428],["xengallery_media",34154],["xengallery_media",34146],["xengallery_media",34113],["thread",56358],["xengallery_media",34099],["xengallery_media",34098],["xengallery_media",34097],["xengallery_media",34084],["xengallery_media",34080],["xengallery_media",34079],["thread",56264],["xengallery_media",33960],["xengallery_media",33941],["xengallery_media",33937],["xengallery_media",33926],["xengallery_media",33860],["thread",56169],["xengallery_media",33831],["thread",56158],["thread",56138],["xengallery_media",33807],["xengallery_media",33806],["xengallery_media",33769],["thread",56132],["xengallery_media",33751],["xengallery_media",33732],["thread",56086],["xengallery_media",33671],["thread",56070],["thread",56062],["xengallery_media",33541],["thread",55948],["xengallery_media",33344],["xengallery_media",33261],["xengallery_media",33181],["xengallery_media",33180],["thread",55869],["xengallery_media",33098],["xengallery_media",33082],["thread",55841],["xengallery_media",33080],["xengallery_media",33079],["xengallery_media",33078],["xengallery_media",33077],["xengallery_media",33075],["xengallery_media",33074],["thread",55840],["thread",55837],["xengallery_media",33061],["xengallery_media",33060],["xengallery_media",33038],["xengallery_media",32993],["xengallery_media",32992],["thread",55821],["thread",55813],["thread",55735],["xengallery_media",32854],["thread",55495],["xengallery_media",32808],["thread",55370],["xengallery_media",32779],["xengallery_media",32708],["xengallery_media",32707],["thread",55184],["thread",54859],["xengallery_media",32586],["thread",54824],["thread",54800],["thread",54767],["xengallery_media",32525],["thread",54698],["thread",54617],["thread",54480],["xengallery_media",32330],["thread",54428],["xengallery_media",32321],["xengallery_media",32320],["thread",54420],["xengallery_media",32311],["xengallery_media",32310],["thread",54296],["thread",54282],["xengallery_media",32140],["thread",54216],["thread",54196],["xengallery_media",32031],["xengallery_media",31904],["thread",54125],["xengallery_media",31892],["xengallery_media",31891],["xengallery_media",31889],["xengallery_media",31888],["thread",54063],["thread",54040],["xengallery_media",31711],["xengallery_media",31584],["thread",53972],["thread",53955],["xengallery_media",31517],["thread",53905],["thread",53809],["xengallery_media",31180],["xengallery_media",31090],["thread",53741],["thread",53568],["xengallery_media",30862],["thread",53498],["thread",53473],["thread",53381],["thread",53275],["xengallery_media",30412],["thread",53262],["thread",53255],["thread",53167],["xengallery_media",30270],["thread",52938],["xengallery_media",29864],["xengallery_media",29605],["xengallery_media",29604],["thread",52785],["xengallery_media",29485],["xengallery_media",29484],["xengallery_media",29483],["xengallery_media",29482],["xengallery_media",29481],["xengallery_media",29480],["xengallery_media",29479],["xengallery_media",29478],["xengallery_media",29477],["xengallery_media",29466],["thread",52749],["xengallery_media",29462],["xengallery_media",29458],["thread",52745],["xengallery_media",29431],["xengallery_media",29402],["xengallery_media",29322],["xengallery_media",29321],["xengallery_media",29320],["xengallery_media",29314],["xengallery_media",29298],["xengallery_media",29297],["xengallery_media",29296],["xengallery_media",29284],["xengallery_media",29283],["xengallery_media",29282],["xengallery_media",29281],["xengallery_media",29280],["xengallery_media",29279],["xengallery_media",29278],["xengallery_media",29277],["xengallery_media",29276],["xengallery_media",29275],["xengallery_media",29274],["xengallery_media",29273],["xengallery_media",29272],["xengallery_media",29271],["xengallery_media",29270],["xengallery_media",29269],["xengallery_media",29268],["xengallery_media",29267],["xengallery_media",29234],["xengallery_media",29233],["xengallery_media",29226],["xengallery_media",29225],["xengallery_media",29224],["xengallery_media",29223],["xengallery_media",29222],["xengallery_media",29221],["xengallery_media",29220],["xengallery_media",29219],["xengallery_media",29218],["xengallery_media",29217],["xengallery_media",29216],["xengallery_media",29215],["xengallery_media",29213],["xengallery_media",29212],["xengallery_media",29211],["xengallery_media",29210],["xengallery_media",29209],["xengallery_media",29208],["xengallery_media",29207]]
Run Time: 0.001664