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 (1127, 1126, 1125, 1124, 1123, 1122, 1121, 1120, 1119, 1118, 1117, 1116, 1114, 1108, 1107, 1105, 1104, 1101, 1100, 1099, 1097, 1096, 1095, 1094, 1093, 1092, 1091, 1090, 1089, 1088, 1087, 1086, 1085, 1084, 1079, 1078, 1077, 1076, 1075, 1074, 1073, 1072, 1071, 1070, 1069, 1068, 1065, 1064, 1063, 1062, 1061, 1060, 1059, 1058, 1057, 1056, 1055, 1054, 1053, 1052, 1051, 1050, 1049, 1048, 1047, 1046, 1045, 1044, 1043, 1042, 1041, 1040, 1039, 1038, 1037, 1036, 1035, 1034, 1033, 1032, 1030, 1029, 1028, 1027, 1026, 1025, 1024, 1023, 1022, 1021, 1020, 1019, 1018, 1017, 1016, 1015, 1013, 1012, 1011, 1010, 1008, 1007, 1006, 1005, 1004, 1003, 1002, 1001, 1000, 999, 998, 997, 996, 994, 993, 992, 991, 990, 989, 988, 987, 986, 985, 984, 983, 982, 981, 980, 979, 978, 977, 976, 975, 974, 973, 972, 971, 970, 969, 968, 967, 966, 965, 964, 963, 962, 961, 960, 959, 958, 957, 956, 955, 954, 953, 952, 951, 950, 949, 948, 947, 946, 941, 940, 939, 938, 937, 936, 935, 934, 933, 932, 931, 930, 929, 928, 927, 926, 925, 924, 922, 921, 920, 919, 918, 917, 916, 915, 914, 913, 912, 911, 910, 909, 908, 907, 906, 905, 904, 903)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.007322
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 | dirty.media.album_id | 1 | Using where |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | dirty.album.album_id,const | 1 | |
SIMPLE | category | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dirty.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | dirty.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | dirty.media.attachment_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | dirty.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",1127],["xengallery_media",1126],["xengallery_media",1125],["xengallery_media",1124],["xengallery_media",1123],["xengallery_media",1122],["xengallery_media",1121],["xengallery_media",1120],["xengallery_media",1119],["xengallery_media",1118],["xengallery_media",1117],["xengallery_media",1116],["xengallery_media",1114],["xengallery_media",1108],["xengallery_media",1107],["xengallery_media",1105],["xengallery_media",1104],["xengallery_media",1101],["xengallery_media",1100],["xengallery_media",1099],["xengallery_media",1097],["xengallery_media",1096],["xengallery_media",1095],["xengallery_media",1094],["xengallery_media",1093],["xengallery_media",1092],["xengallery_media",1091],["xengallery_media",1090],["xengallery_media",1089],["xengallery_media",1088],["xengallery_media",1087],["xengallery_media",1086],["xengallery_media",1085],["xengallery_media",1084],["xengallery_media",1079],["xengallery_media",1078],["xengallery_media",1077],["xengallery_media",1076],["xengallery_media",1075],["xengallery_media",1074],["xengallery_media",1073],["xengallery_media",1072],["xengallery_media",1071],["xengallery_media",1070],["xengallery_media",1069],["xengallery_media",1068],["xengallery_media",1065],["xengallery_media",1064],["xengallery_media",1063],["xengallery_media",1062],["xengallery_media",1061],["xengallery_media",1060],["xengallery_media",1059],["xengallery_media",1058],["xengallery_media",1057],["xengallery_media",1056],["xengallery_media",1055],["xengallery_media",1054],["xengallery_media",1053],["xengallery_media",1052],["xengallery_media",1051],["xengallery_media",1050],["xengallery_media",1049],["xengallery_media",1048],["xengallery_media",1047],["xengallery_media",1046],["xengallery_media",1045],["xengallery_media",1044],["xengallery_media",1043],["xengallery_media",1042],["xengallery_media",1041],["xengallery_media",1040],["xengallery_media",1039],["xengallery_media",1038],["xengallery_media",1037],["xengallery_media",1036],["xengallery_media",1035],["xengallery_media",1034],["xengallery_media",1033],["xengallery_media",1032],["xengallery_media",1030],["xengallery_media",1029],["xengallery_media",1028],["xengallery_media",1027],["xengallery_media",1026],["xengallery_media",1025],["xengallery_media",1024],["xengallery_media",1023],["xengallery_media",1022],["xengallery_media",1021],["xengallery_media",1020],["xengallery_media",1019],["xengallery_media",1018],["xengallery_media",1017],["xengallery_media",1016],["xengallery_media",1015],["xengallery_media",1013],["xengallery_media",1012],["xengallery_media",1011],["xengallery_media",1010],["xengallery_media",1008],["xengallery_media",1007],["xengallery_media",1006],["xengallery_media",1005],["xengallery_media",1004],["xengallery_media",1003],["xengallery_media",1002],["xengallery_media",1001],["xengallery_media",1000],["xengallery_media",999],["xengallery_media",998],["xengallery_media",997],["xengallery_media",996],["xengallery_media",994],["xengallery_media",993],["xengallery_media",992],["xengallery_media",991],["xengallery_media",990],["xengallery_media",989],["xengallery_media",988],["xengallery_media",987],["xengallery_media",986],["xengallery_media",985],["xengallery_media",984],["xengallery_media",983],["xengallery_media",982],["xengallery_media",981],["xengallery_media",980],["xengallery_media",979],["xengallery_media",978],["xengallery_media",977],["xengallery_media",976],["xengallery_media",975],["xengallery_media",974],["xengallery_media",973],["xengallery_media",972],["xengallery_media",971],["xengallery_media",970],["xengallery_media",969],["xengallery_media",968],["xengallery_media",967],["xengallery_media",966],["xengallery_media",965],["xengallery_media",964],["xengallery_media",963],["xengallery_media",962],["xengallery_media",961],["xengallery_media",960],["xengallery_media",959],["xengallery_media",958],["xengallery_media",957],["xengallery_media",956],["xengallery_media",955],["xengallery_media",954],["xengallery_media",953],["xengallery_media",952],["xengallery_media",951],["xengallery_media",950],["xengallery_media",949],["xengallery_media",948],["xengallery_media",947],["xengallery_media",946],["xengallery_media",941],["xengallery_media",940],["xengallery_media",939],["xengallery_media",938],["xengallery_media",937],["xengallery_media",936],["xengallery_media",935],["xengallery_media",934],["xengallery_media",933],["xengallery_media",932],["xengallery_media",931],["xengallery_media",930],["xengallery_media",929],["xengallery_media",928],["xengallery_media",927],["xengallery_media",926],["xengallery_media",925],["xengallery_media",924],["xengallery_media",922],["xengallery_media",921],["xengallery_media",920],["xengallery_media",919],["xengallery_media",918],["xengallery_media",917],["xengallery_media",916],["xengallery_media",915],["xengallery_media",914],["xengallery_media",913],["xengallery_media",912],["xengallery_media",911],["xengallery_media",910],["xengallery_media",909],["xengallery_media",908],["xengallery_media",907],["xengallery_media",906],["xengallery_media",905],["xengallery_media",904],["xengallery_media",903]], 200, xengallery_media, , ["findNew"], date, 0, , [], 0, 1714179686, 36479db84cc074f46b51a4d21e63f89a
Run Time: 0.006102