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 (19567, 13429, 11672, 4262, 4261, 4260, 4259, 4258, 4257, 4256, 4255, 4254, 4253, 4252, 4251, 4250, 4249, 4248, 4247, 4246, 4245, 4244, 4243, 4242, 4241, 4240, 4239, 4238, 4237, 4236, 4235, 4234, 4233, 4232, 4231, 4230, 4229, 4228, 4227, 4226, 4225, 4224, 4223, 4222, 4221, 4220, 4219, 4218, 4217, 4216, 4215, 4214, 4213, 4212, 4211, 4210, 4209, 4208, 4207, 4206, 4205, 4204, 4203, 4202, 4201, 4200, 4199, 4198, 4197, 4196, 4195, 4194, 4193, 4192, 4191, 4190, 4189, 4188, 4187, 4186, 4185, 4184, 4183, 4182, 4181, 4180, 4179, 4178, 4177, 4176, 4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4165, 4164, 4163, 4162, 4161, 4152, 4151, 4150, 4149, 4148, 4147, 4146, 4145, 4144, 4143, 4142, 4141, 4140, 4139, 4138, 4137, 4136, 4135, 4134, 4133, 4132, 4131, 4130, 4129, 4128, 4127, 4126, 4125, 4124, 4123, 4122, 4121, 4120, 4119, 4118, 4117, 4116, 4115, 4114, 4113, 4112, 4111, 4110, 4109, 4108, 4107, 4106, 4105, 4104, 4103, 4102, 4101, 4100, 4099, 4098, 4097, 4096, 4095, 4094, 4093, 4092, 4091, 4090, 4089, 4088, 4087, 4086, 4085, 4084, 4083, 4082, 4081, 4080, 4079, 4078, 4077, 4076, 4075, 4074, 4073, 4072, 4071, 4070, 4069, 4068, 4067, 4066, 4065, 4064, 4063, 4062, 4061, 4060, 4059, 4058)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.003384
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: 1628, 0, 1610784135, 1610787735, [["xengallery_media",19567],["xengallery_media",13429],["xengallery_media",11672],["xengallery_media",4262],["xengallery_media",4261],["xengallery_media",4260],["xengallery_media",4259],["xengallery_media",4258],["xengallery_media",4257],["xengallery_media",4256],["xengallery_media",4255],["xengallery_media",4254],["xengallery_media",4253],["xengallery_media",4252],["xengallery_media",4251],["xengallery_media",4250],["xengallery_media",4249],["xengallery_media",4248],["xengallery_media",4247],["xengallery_media",4246],["xengallery_media",4245],["xengallery_media",4244],["xengallery_media",4243],["xengallery_media",4242],["xengallery_media",4241],["xengallery_media",4240],["xengallery_media",4239],["xengallery_media",4238],["xengallery_media",4237],["xengallery_media",4236],["xengallery_media",4235],["xengallery_media",4234],["xengallery_media",4233],["xengallery_media",4232],["xengallery_media",4231],["xengallery_media",4230],["xengallery_media",4229],["xengallery_media",4228],["xengallery_media",4227],["xengallery_media",4226],["xengallery_media",4225],["xengallery_media",4224],["xengallery_media",4223],["xengallery_media",4222],["xengallery_media",4221],["xengallery_media",4220],["xengallery_media",4219],["xengallery_media",4218],["xengallery_media",4217],["xengallery_media",4216],["xengallery_media",4215],["xengallery_media",4214],["xengallery_media",4213],["xengallery_media",4212],["xengallery_media",4211],["xengallery_media",4210],["xengallery_media",4209],["xengallery_media",4208],["xengallery_media",4207],["xengallery_media",4206],["xengallery_media",4205],["xengallery_media",4204],["xengallery_media",4203],["xengallery_media",4202],["xengallery_media",4201],["xengallery_media",4200],["xengallery_media",4199],["xengallery_media",4198],["xengallery_media",4197],["xengallery_media",4196],["xengallery_media",4195],["xengallery_media",4194],["xengallery_media",4193],["xengallery_media",4192],["xengallery_media",4191],["xengallery_media",4190],["xengallery_media",4189],["xengallery_media",4188],["xengallery_media",4187],["xengallery_media",4186],["xengallery_media",4185],["xengallery_media",4184],["xengallery_media",4183],["xengallery_media",4182],["xengallery_media",4181],["xengallery_media",4180],["xengallery_media",4179],["xengallery_media",4178],["xengallery_media",4177],["xengallery_media",4176],["xengallery_media",4175],["xengallery_media",4174],["xengallery_media",4173],["xengallery_media",4172],["xengallery_media",4171],["xengallery_media",4170],["xengallery_media",4169],["xengallery_media",4168],["xengallery_media",4167],["xengallery_media",4166],["xengallery_media",4165],["xengallery_media",4164],["xengallery_media",4163],["xengallery_media",4162],["xengallery_media",4161],["xengallery_media",4152],["xengallery_media",4151],["xengallery_media",4150],["xengallery_media",4149],["xengallery_media",4148],["xengallery_media",4147],["xengallery_media",4146],["xengallery_media",4145],["xengallery_media",4144],["xengallery_media",4143],["xengallery_media",4142],["xengallery_media",4141],["xengallery_media",4140],["xengallery_media",4139],["xengallery_media",4138],["xengallery_media",4137],["xengallery_media",4136],["xengallery_media",4135],["xengallery_media",4134],["xengallery_media",4133],["xengallery_media",4132],["xengallery_media",4131],["xengallery_media",4130],["xengallery_media",4129],["xengallery_media",4128],["xengallery_media",4127],["xengallery_media",4126],["xengallery_media",4125],["xengallery_media",4124],["xengallery_media",4123],["xengallery_media",4122],["xengallery_media",4121],["xengallery_media",4120],["xengallery_media",4119],["xengallery_media",4118],["xengallery_media",4117],["xengallery_media",4116],["xengallery_media",4115],["xengallery_media",4114],["xengallery_media",4113],["xengallery_media",4112],["xengallery_media",4111],["xengallery_media",4110],["xengallery_media",4109],["xengallery_media",4108],["xengallery_media",4107],["xengallery_media",4106],["xengallery_media",4105],["xengallery_media",4104],["xengallery_media",4103],["xengallery_media",4102],["xengallery_media",4101],["xengallery_media",4100],["xengallery_media",4099],["xengallery_media",4098],["xengallery_media",4097],["xengallery_media",4096],["xengallery_media",4095],["xengallery_media",4094],["xengallery_media",4093],["xengallery_media",4092],["xengallery_media",4091],["xengallery_media",4090],["xengallery_media",4089],["xengallery_media",4088],["xengallery_media",4087],["xengallery_media",4086],["xengallery_media",4085],["xengallery_media",4084],["xengallery_media",4083],["xengallery_media",4082],["xengallery_media",4081],["xengallery_media",4080],["xengallery_media",4079],["xengallery_media",4078],["xengallery_media",4077],["xengallery_media",4076],["xengallery_media",4075],["xengallery_media",4074],["xengallery_media",4073],["xengallery_media",4072],["xengallery_media",4071],["xengallery_media",4070],["xengallery_media",4069],["xengallery_media",4068],["xengallery_media",4067],["xengallery_media",4066],["xengallery_media",4065],["xengallery_media",4064],["xengallery_media",4063],["xengallery_media",4062],["xengallery_media",4061],["xengallery_media",4060],["xengallery_media",4059],["xengallery_media",4058]]
Run Time: 0.001830