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 FORCE INDEX (PRIMARY) 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 (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58), NULL)) AND (media.media_id IN (99955, 99954, 99953, 99952, 99951, 96746, 94118, 94117, 94116, 93592, 78346, 78345, 61031, 61030, 61029, 51486, 51457, 51456, 51454, 51453, 51452, 50660)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))Run Time: 0.002994
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | media | range | PRIMARY | PRIMARY | 4 | | 22 | Using where |
| SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.album_id | 1 | Using where |
| SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | xf_michigan.album.album_id,const | 1 | Using where |
| SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.category_id | 1 | |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.user_id | 1 | |
| SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.user_id | 1 | |
| SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | xf_michigan.media.attachment_id | 1 | Using where |
| SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.attachment.data_id | 1 | |
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Tag, Tag, valid, tag_url=turkeys, 1524172083,
Run Time: 0.002879