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_id IN (1389, 1388, 1387, 1386, 1385, 1384, 1383, 1382, 1381, 1380, 1379, 1378, 1377, 1376, 1375, 1374, 1373, 1372, 1371, 1370, 1369, 1368, 1367, 1366, 1365, 1364, 1363, 1362, 1361, 1360, 1359, 1358, 1357, 1356, 1355, 1354, 1353, 1352, 1351, 1350, 1349, 1348, 1347, 1346, 1345, 1344, 1343, 1342, 1341, 1340, 1339, 1338, 1337, 1336, 1335, 1334, 1333, 1332, 1331, 1330, 1329, 1328, 1327, 1326, 1325, 1324, 1323, 1322, 1321, 1320, 1319, 1318, 1317, 1316, 1315, 1314, 1313, 1312, 1311, 1310, 1309, 1308, 1307, 1306, 1305, 1304, 1303, 1302, 1300, 1299, 1298, 1297, 1296, 1295, 1294, 1293, 1292, 1291, 1290, 1289, 1288, 1287, 1286, 1285, 1284, 1283, 1282, 1281, 1280, 1279, 1278, 1277, 1276, 1275, 1274, 1273, 1272, 1271, 1270, 1269, 1268, 1267, 1266, 1265, 1264, 1263, 1262, 1261, 1260, 1259, 1258, 1257, 1256, 1255, 1254, 1253, 1252, 1251, 1250, 1249, 1248, 1247, 1246, 1245, 1244, 1243, 1242, 1241, 1240, 1239, 1238, 1237, 1236, 1235, 1234, 1233, 1232, 1231, 1230, 1229, 1228, 1227, 1226, 1225, 1224, 1223, 1222, 1221, 1220, 1219, 1218, 1217, 1216, 1215, 1214, 1213, 1212, 1211, 1210, 1209, 1208, 1207, 1206, 1205, 1204, 1203, 1202, 1201, 1200, 1199, 1198, 1197, 1196, 1195, 1194, 1193, 1192, 1191, 1190, 1189)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.007095
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 | gkxenforo.media.album_id | 1 | Using where |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | gkxenforo.album.album_id,const | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | gkxenforo.media.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | gkxenforo.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | gkxenforo.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | gkxenforo.media.attachment_id | 1 | |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | gkxenforo.attachment.data_id | 1 | |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["xengallery_media",1389],["xengallery_media",1388],["xengallery_media",1387],["xengallery_media",1386],["xengallery_media",1385],["xengallery_media",1384],["xengallery_media",1383],["xengallery_media",1382],["xengallery_media",1381],["xengallery_media",1380],["xengallery_media",1379],["xengallery_media",1378],["xengallery_media",1377],["xengallery_media",1376],["xengallery_media",1375],["xengallery_media",1374],["xengallery_media",1373],["xengallery_media",1372],["xengallery_media",1371],["xengallery_media",1370],["xengallery_media",1369],["xengallery_media",1368],["xengallery_media",1367],["xengallery_media",1366],["xengallery_media",1365],["xengallery_media",1364],["xengallery_media",1363],["xengallery_media",1362],["xengallery_media",1361],["xengallery_media",1360],["xengallery_media",1359],["xengallery_media",1358],["xengallery_media",1357],["xengallery_media",1356],["xengallery_media",1355],["xengallery_media",1354],["xengallery_media",1353],["xengallery_media",1352],["xengallery_media",1351],["xengallery_media",1350],["xengallery_media",1349],["xengallery_media",1348],["xengallery_media",1347],["xengallery_media",1346],["xengallery_media",1345],["xengallery_media",1344],["xengallery_media",1343],["xengallery_media",1342],["xengallery_media",1341],["xengallery_media",1340],["xengallery_media",1339],["xengallery_media",1338],["xengallery_media",1337],["xengallery_media",1336],["xengallery_media",1335],["xengallery_media",1334],["xengallery_media",1333],["xengallery_media",1332],["xengallery_media",1331],["xengallery_media",1330],["xengallery_media",1329],["xengallery_media",1328],["xengallery_media",1327],["xengallery_media",1326],["xengallery_media",1325],["xengallery_media",1324],["xengallery_media",1323],["xengallery_media",1322],["xengallery_media",1321],["xengallery_media",1320],["xengallery_media",1319],["xengallery_media",1318],["xengallery_media",1317],["xengallery_media",1316],["xengallery_media",1315],["xengallery_media",1314],["xengallery_media",1313],["xengallery_media",1312],["xengallery_media",1311],["xengallery_media",1310],["xengallery_media",1309],["xengallery_media",1308],["xengallery_media",1307],["xengallery_media",1306],["xengallery_media",1305],["xengallery_media",1304],["xengallery_media",1303],["xengallery_media",1302],["xengallery_media",1300],["xengallery_media",1299],["xengallery_media",1298],["xengallery_media",1297],["xengallery_media",1296],["xengallery_media",1295],["xengallery_media",1294],["xengallery_media",1293],["xengallery_media",1292],["xengallery_media",1291],["xengallery_media",1290],["xengallery_media",1289],["xengallery_media",1288],["xengallery_media",1287],["xengallery_media",1286],["xengallery_media",1285],["xengallery_media",1284],["xengallery_media",1283],["xengallery_media",1282],["xengallery_media",1281],["xengallery_media",1280],["xengallery_media",1279],["xengallery_media",1278],["xengallery_media",1277],["xengallery_media",1276],["xengallery_media",1275],["xengallery_media",1274],["xengallery_media",1273],["xengallery_media",1272],["xengallery_media",1271],["xengallery_media",1270],["xengallery_media",1269],["xengallery_media",1268],["xengallery_media",1267],["xengallery_media",1266],["xengallery_media",1265],["xengallery_media",1264],["xengallery_media",1263],["xengallery_media",1262],["xengallery_media",1261],["xengallery_media",1260],["xengallery_media",1259],["xengallery_media",1258],["xengallery_media",1257],["xengallery_media",1256],["xengallery_media",1255],["xengallery_media",1254],["xengallery_media",1253],["xengallery_media",1252],["xengallery_media",1251],["xengallery_media",1250],["xengallery_media",1249],["xengallery_media",1248],["xengallery_media",1247],["xengallery_media",1246],["xengallery_media",1245],["xengallery_media",1244],["xengallery_media",1243],["xengallery_media",1242],["xengallery_media",1241],["xengallery_media",1240],["xengallery_media",1239],["xengallery_media",1238],["xengallery_media",1237],["xengallery_media",1236],["xengallery_media",1235],["xengallery_media",1234],["xengallery_media",1233],["xengallery_media",1232],["xengallery_media",1231],["xengallery_media",1230],["xengallery_media",1229],["xengallery_media",1228],["xengallery_media",1227],["xengallery_media",1226],["xengallery_media",1225],["xengallery_media",1224],["xengallery_media",1223],["xengallery_media",1222],["xengallery_media",1221],["xengallery_media",1220],["xengallery_media",1219],["xengallery_media",1218],["xengallery_media",1217],["xengallery_media",1216],["xengallery_media",1215],["xengallery_media",1214],["xengallery_media",1213],["xengallery_media",1212],["xengallery_media",1211],["xengallery_media",1210],["xengallery_media",1209],["xengallery_media",1208],["xengallery_media",1207],["xengallery_media",1206],["xengallery_media",1205],["xengallery_media",1204],["xengallery_media",1203],["xengallery_media",1202],["xengallery_media",1201],["xengallery_media",1200],["xengallery_media",1199],["xengallery_media",1198],["xengallery_media",1197],["xengallery_media",1196],["xengallery_media",1195],["xengallery_media",1194],["xengallery_media",1193],["xengallery_media",1192],["xengallery_media",1191],["xengallery_media",1190],["xengallery_media",1189]], 200, xengallery_media, , ["findNew"], date, 0, , [], 0, 1716128298, 36479db84cc074f46b51a4d21e63f89a
Run Time: 0.003772