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 (35237, 35236, 35235, 35234, 35233, 35232, 35230, 35229, 35228, 35227, 35220, 35215, 35211, 35207, 35206, 35205, 35203, 35201, 35180, 35165, 35164, 35163, 35162, 35161, 35160, 35159, 35152, 35151, 35149, 35146, 35143, 35142, 35141, 35140, 35139, 35138, 35131, 35110, 35108, 35107, 35103, 35102, 35094, 35088, 35086, 35085, 35077, 35076, 35075, 35074, 35073, 35072, 35052, 35026, 35025, 35024, 35023, 35022, 35021, 35020, 35019, 35018, 35015, 34998, 34986, 34985, 34984, 34981, 34980, 34979, 34978, 34977, 34976, 34975, 34974, 34971, 34970, 34969, 34968, 34967, 34966, 34965, 34964, 34963, 34962, 34961, 34960, 34952, 34924, 34923, 34922, 34921, 34920, 34919, 34918, 34917, 34916, 34915, 34910, 34909, 34886, 34883, 34882, 34881, 34880, 34879, 34878, 34877, 34876, 34874, 34873, 34872, 34871, 34865, 34864, 34859, 34858, 34857, 34856, 34854, 34853, 34843, 34842, 34834, 34833, 34832, 34831, 34830, 34828, 34797, 34796, 34795, 34794, 34793, 34792, 34791, 34789, 34786, 34785, 34784, 34782, 34780, 34779, 34778, 34777, 34776, 34775, 34774, 34773, 34764, 34761, 34760, 34755, 34753, 34752, 34751, 34750, 34749, 34748, 34747, 34746, 34744, 34728, 34683, 34682, 34655, 34640, 34611, 34595, 34589, 34561, 34535, 34534, 34533, 34532, 34526, 34522, 34521, 34520, 34519, 34518, 34497, 34496, 34472, 34471, 34470, 34465, 34464, 34463, 34462)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.008668
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY | PRIMARY | 4 | | 190 | 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: 40, 0, 1618053956, 1618057556, [["xengallery_media",35237],["xengallery_media",35236],["xengallery_media",35235],["xengallery_media",35234],["xengallery_media",35233],["xengallery_media",35232],["xengallery_media",35230],["xengallery_media",35229],["xengallery_media",35228],["xengallery_media",35227],["xengallery_media",35220],["xengallery_media",35215],["xengallery_media",35211],["xengallery_media",35207],["xengallery_media",35206],["xengallery_media",35205],["xengallery_media",35203],["xengallery_media",35201],["xengallery_media",35180],["xengallery_media",35165],["xengallery_media",35164],["xengallery_media",35163],["xengallery_media",35162],["xengallery_media",35161],["xengallery_media",35160],["xengallery_media",35159],["xengallery_media",35152],["xengallery_media",35151],["xengallery_media",35149],["xengallery_media",35146],["xengallery_media",35143],["xengallery_media",35142],["xengallery_media",35141],["xengallery_media",35140],["xengallery_media",35139],["xengallery_media",35138],["xengallery_media",35131],["xengallery_media",35110],["xengallery_media",35108],["xengallery_media",35107],["xengallery_media",35103],["xengallery_media",35102],["xengallery_media",35094],["xengallery_media",35088],["xengallery_media",35086],["xengallery_media",35085],["xengallery_media",35077],["xengallery_media",35076],["xengallery_media",35075],["xengallery_media",35074],["xengallery_media",35073],["xengallery_media",35072],["thread",56681],["xengallery_media",35052],["xengallery_media",35026],["xengallery_media",35025],["xengallery_media",35024],["xengallery_media",35023],["xengallery_media",35022],["xengallery_media",35021],["xengallery_media",35020],["xengallery_media",35019],["xengallery_media",35018],["xengallery_media",35015],["xengallery_media",34998],["thread",56649],["xengallery_media",34986],["xengallery_media",34985],["xengallery_media",34984],["xengallery_media",34981],["xengallery_media",34980],["xengallery_media",34979],["xengallery_media",34978],["xengallery_media",34977],["xengallery_media",34976],["xengallery_media",34975],["xengallery_media",34974],["xengallery_media",34971],["xengallery_media",34970],["xengallery_media",34969],["xengallery_media",34968],["xengallery_media",34967],["xengallery_media",34966],["xengallery_media",34965],["xengallery_media",34964],["xengallery_media",34963],["xengallery_media",34962],["xengallery_media",34961],["xengallery_media",34960],["xengallery_media",34952],["thread",56625],["xengallery_media",34924],["xengallery_media",34923],["xengallery_media",34922],["xengallery_media",34921],["xengallery_media",34920],["xengallery_media",34919],["xengallery_media",34918],["xengallery_media",34917],["xengallery_media",34916],["xengallery_media",34915],["thread",56615],["xengallery_media",34910],["xengallery_media",34909],["xengallery_media",34886],["xengallery_media",34883],["xengallery_media",34882],["xengallery_media",34881],["xengallery_media",34880],["xengallery_media",34879],["xengallery_media",34878],["xengallery_media",34877],["xengallery_media",34876],["xengallery_media",34874],["xengallery_media",34873],["xengallery_media",34872],["xengallery_media",34871],["xengallery_media",34865],["xengallery_media",34864],["xengallery_media",34859],["xengallery_media",34858],["xengallery_media",34857],["xengallery_media",34856],["xengallery_media",34854],["xengallery_media",34853],["xengallery_media",34843],["thread",56602],["xengallery_media",34842],["xengallery_media",34834],["xengallery_media",34833],["xengallery_media",34832],["xengallery_media",34831],["xengallery_media",34830],["xengallery_media",34828],["xengallery_media",34797],["xengallery_media",34796],["xengallery_media",34795],["xengallery_media",34794],["xengallery_media",34793],["xengallery_media",34792],["xengallery_media",34791],["xengallery_media",34789],["xengallery_media",34786],["xengallery_media",34785],["xengallery_media",34784],["xengallery_media",34782],["xengallery_media",34780],["xengallery_media",34779],["xengallery_media",34778],["xengallery_media",34777],["xengallery_media",34776],["xengallery_media",34775],["xengallery_media",34774],["xengallery_media",34773],["xengallery_media",34764],["xengallery_media",34761],["xengallery_media",34760],["xengallery_media",34755],["xengallery_media",34753],["xengallery_media",34752],["xengallery_media",34751],["xengallery_media",34750],["xengallery_media",34749],["xengallery_media",34748],["xengallery_media",34747],["xengallery_media",34746],["xengallery_media",34744],["xengallery_media",34728],["xengallery_media",34683],["xengallery_media",34682],["thread",56571],["xengallery_media",34655],["xengallery_media",34640],["xengallery_media",34611],["xengallery_media",34595],["xengallery_media",34589],["thread",56560],["thread",56557],["thread",56555],["xengallery_media",34561],["xengallery_media",34535],["xengallery_media",34534],["xengallery_media",34533],["xengallery_media",34532],["xengallery_media",34526],["thread",56539],["xengallery_media",34522],["xengallery_media",34521],["xengallery_media",34520],["xengallery_media",34519],["xengallery_media",34518],["xengallery_media",34497],["xengallery_media",34496],["xengallery_media",34472],["xengallery_media",34471],["xengallery_media",34470],["xengallery_media",34465],["xengallery_media",34464],["xengallery_media",34463],["xengallery_media",34462]]
Run Time: 0.001531