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 (29325, 29324, 29323, 29322, 29320, 29319, 29318, 29317, 29316, 29315, 29314, 29313, 29312, 29311, 29310, 29309, 29308, 29307, 29306, 29305, 29304, 29303, 29302, 29301, 29300, 29299, 29298, 29297, 29296, 29295, 29293, 29292, 29291, 29290, 29289, 29288, 29287, 29286, 29285, 29284, 29283, 29282, 29281, 29280, 29279, 29278, 29277, 29276, 29275, 29274, 29273, 29272, 29271, 29270, 29269, 29268, 29267, 29266, 29265, 29263, 29262, 29261, 29260, 29259, 29258, 29257, 29255, 29254, 29253, 29252, 29251, 29250, 29249, 29248, 29247, 29246, 29245, 29244, 29243, 29242, 29241, 29240, 29239, 29238, 29237, 29236, 29235, 29234, 29233, 29232, 29231, 29230, 29229, 29228, 29227, 29226, 29225, 29224, 29223, 29222, 29221, 29220, 29219, 29218, 29217, 29216, 29215, 29214, 29213, 29212, 29211, 29210, 29209, 29208, 29207, 29206, 29205, 29204, 29203, 29202, 29201, 29200, 29199, 29198, 29197, 29196, 29195, 29194, 29193, 29192, 29191, 29190, 29189, 29188, 29187, 29186, 29185, 29184, 29183, 29182, 29181, 29180, 29179, 29178, 29177, 29176, 29175, 29174, 29173, 29172, 29171, 29170, 29169, 29168, 29167, 29166, 29165, 29164, 29163, 29162, 29161, 29160, 29159, 29158, 29157, 29156, 29155, 29154, 29153, 29152, 29151, 29150, 29149, 29148, 29144, 29143, 29142, 29141, 29140, 29139, 29138, 29137, 29136, 29135, 29134, 29133, 29132, 29131, 29130, 29129, 29128, 29127, 29126, 29125, 29124, 29123, 29122, 29120, 29119, 29117)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.004575
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: 88, 0, 1619027400, 1619031000, [["xengallery_media",29325],["xengallery_media",29324],["xengallery_media",29323],["xengallery_media",29322],["xengallery_media",29320],["xengallery_media",29319],["xengallery_media",29318],["xengallery_media",29317],["xengallery_media",29316],["xengallery_media",29315],["xengallery_media",29314],["xengallery_media",29313],["xengallery_media",29312],["xengallery_media",29311],["xengallery_media",29310],["xengallery_media",29309],["xengallery_media",29308],["xengallery_media",29307],["xengallery_media",29306],["xengallery_media",29305],["xengallery_media",29304],["xengallery_media",29303],["xengallery_media",29302],["xengallery_media",29301],["xengallery_media",29300],["xengallery_media",29299],["xengallery_media",29298],["xengallery_media",29297],["xengallery_media",29296],["xengallery_media",29295],["xengallery_media",29293],["xengallery_media",29292],["xengallery_media",29291],["xengallery_media",29290],["xengallery_media",29289],["xengallery_media",29288],["xengallery_media",29287],["xengallery_media",29286],["xengallery_media",29285],["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",29266],["xengallery_media",29265],["xengallery_media",29263],["xengallery_media",29262],["xengallery_media",29261],["xengallery_media",29260],["xengallery_media",29259],["xengallery_media",29258],["xengallery_media",29257],["xengallery_media",29255],["xengallery_media",29254],["xengallery_media",29253],["xengallery_media",29252],["xengallery_media",29251],["xengallery_media",29250],["xengallery_media",29249],["xengallery_media",29248],["xengallery_media",29247],["xengallery_media",29246],["xengallery_media",29245],["xengallery_media",29244],["xengallery_media",29243],["xengallery_media",29242],["xengallery_media",29241],["xengallery_media",29240],["xengallery_media",29239],["xengallery_media",29238],["xengallery_media",29237],["xengallery_media",29236],["xengallery_media",29235],["xengallery_media",29234],["xengallery_media",29233],["xengallery_media",29232],["xengallery_media",29231],["xengallery_media",29230],["xengallery_media",29229],["xengallery_media",29228],["xengallery_media",29227],["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",29214],["xengallery_media",29213],["xengallery_media",29212],["xengallery_media",29211],["xengallery_media",29210],["xengallery_media",29209],["xengallery_media",29208],["xengallery_media",29207],["xengallery_media",29206],["xengallery_media",29205],["xengallery_media",29204],["xengallery_media",29203],["xengallery_media",29202],["xengallery_media",29201],["xengallery_media",29200],["xengallery_media",29199],["xengallery_media",29198],["xengallery_media",29197],["xengallery_media",29196],["xengallery_media",29195],["xengallery_media",29194],["xengallery_media",29193],["xengallery_media",29192],["xengallery_media",29191],["xengallery_media",29190],["xengallery_media",29189],["xengallery_media",29188],["xengallery_media",29187],["xengallery_media",29186],["xengallery_media",29185],["xengallery_media",29184],["xengallery_media",29183],["xengallery_media",29182],["xengallery_media",29181],["xengallery_media",29180],["xengallery_media",29179],["xengallery_media",29178],["xengallery_media",29177],["xengallery_media",29176],["xengallery_media",29175],["xengallery_media",29174],["xengallery_media",29173],["xengallery_media",29172],["xengallery_media",29171],["xengallery_media",29170],["xengallery_media",29169],["xengallery_media",29168],["xengallery_media",29167],["xengallery_media",29166],["xengallery_media",29165],["xengallery_media",29164],["xengallery_media",29163],["xengallery_media",29162],["xengallery_media",29161],["xengallery_media",29160],["xengallery_media",29159],["xengallery_media",29158],["xengallery_media",29157],["xengallery_media",29156],["xengallery_media",29155],["xengallery_media",29154],["xengallery_media",29153],["xengallery_media",29152],["xengallery_media",29151],["xengallery_media",29150],["xengallery_media",29149],["xengallery_media",29148],["xengallery_media",29144],["xengallery_media",29143],["xengallery_media",29142],["xengallery_media",29141],["xengallery_media",29140],["xengallery_media",29139],["xengallery_media",29138],["xengallery_media",29137],["xengallery_media",29136],["xengallery_media",29135],["xengallery_media",29134],["xengallery_media",29133],["xengallery_media",29132],["xengallery_media",29131],["xengallery_media",29130],["xengallery_media",29129],["xengallery_media",29128],["xengallery_media",29127],["xengallery_media",29126],["xengallery_media",29125],["xengallery_media",29124],["xengallery_media",29123],["xengallery_media",29122],["xengallery_media",29120],["xengallery_media",29119],["xengallery_media",29117]]
Run Time: 0.001539