SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id as images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id 
  AND cscart_common_descriptions.object_holder = 'images' 
  AND cscart_common_descriptions.lang_code = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    220318, 
    215376, 
    215377, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    223749, 
    223750, 
    223751, 
    223752, 
    223753, 
    223754, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    224224, 
    224225, 
    224226, 
    228384, 
    228385, 
    228386, 
    240805, 
    240801, 
    240802, 
    240804, 
    240816, 
    240807, 
    240808, 
    240806, 
    240813, 
    240809, 
    240810, 
    240811, 
    240812, 
    240815, 
    242312, 
    242282, 
    242283, 
    242284, 
    242285, 
    242286, 
    242287, 
    242315, 
    242316, 
    242288, 
    242317, 
    242289, 
    242290, 
    242291, 
    242292, 
    242293, 
    242318, 
    242294, 
    242295, 
    242296, 
    242297, 
    242298, 
    242299, 
    242300, 
    242301, 
    242319, 
    242302, 
    242320, 
    242303, 
    242304, 
    242944, 
    242305, 
    242306, 
    242321, 
    242430, 
    242433, 
    242434, 
    242310, 
    242311, 
    242349, 
    242322, 
    242323, 
    242324, 
    242325, 
    242326, 
    242327, 
    242350, 
    242351, 
    242328, 
    242352, 
    242329, 
    242330, 
    242331, 
    242332, 
    242333, 
    242353, 
    242334, 
    242335, 
    242336, 
    242337, 
    242338, 
    242339, 
    242340, 
    242341, 
    242354, 
    242342, 
    242355, 
    242343, 
    242344, 
    242949, 
    242345, 
    242346, 
    242356, 
    242431, 
    242435, 
    242436, 
    242347, 
    242348, 
    242384, 
    242359, 
    242357, 
    242358, 
    242360, 
    242361, 
    242362, 
    242385, 
    242386, 
    242363, 
    242387, 
    242364, 
    242365, 
    242366, 
    242367, 
    242368, 
    242388, 
    242369, 
    242370, 
    242371, 
    242372, 
    242373, 
    242374, 
    242375, 
    242376, 
    242389, 
    242377, 
    242390, 
    242378, 
    242379, 
    242945, 
    242380, 
    242381, 
    242391, 
    242432, 
    242382, 
    242383, 
    242419, 
    242392, 
    242393, 
    242394, 
    242395, 
    242396, 
    242397, 
    242420, 
    242421, 
    242398, 
    242422, 
    242399, 
    242400, 
    242401, 
    242402, 
    242403, 
    242423, 
    242404, 
    242405, 
    242406, 
    242407, 
    242408, 
    242409, 
    242410, 
    242411, 
    242424, 
    242412, 
    242425, 
    242413, 
    242414, 
    242948, 
    242415, 
    242416, 
    242426, 
    242417, 
    242418, 
    242463, 
    242462, 
    242438, 
    242439, 
    242437, 
    242440, 
    242441, 
    242442, 
    242466, 
    242467, 
    242443, 
    242468, 
    242444, 
    242445, 
    242446, 
    242447, 
    242448, 
    242469, 
    242449, 
    242450, 
    242451, 
    242452, 
    242453, 
    242454, 
    242455, 
    242456, 
    242470, 
    242457, 
    242471, 
    242458, 
    242459, 
    242946, 
    242460, 
    242461, 
    242472, 
    242499, 
    242498, 
    242474, 
    242475, 
    242473, 
    242476, 
    242477, 
    242478, 
    242502, 
    242503, 
    242479, 
    242504, 
    242480, 
    242481, 
    242482, 
    242483, 
    242484, 
    242505, 
    242485, 
    242486, 
    242487, 
    242488, 
    242489, 
    242490, 
    242491, 
    242492, 
    242506, 
    242493, 
    242507, 
    242494, 
    242495, 
    242947, 
    242496, 
    242497, 
    242508
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00269

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 274,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220318,215376,215377,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,223749,223750,223751,223752,223753,223754,223755,223756,223757,223758,223759,223760,223761,223762,224224,224225,224226,228384,228385,228386,240805,240801,240802,240804,240816,240807,240808,240806,240813,240809,240810,240811,240812,240815,242312,242282,242283,242284,242285,242286,242287,242315,242316,242288,242317,242289,242290,242291,242292,242293,242318,242294,242295,242296,242297,242298,242299,242300,242301,242319,242302,242320,242303,242304,242944,242305,242306,242321,242430,242433,242434,242310,242311,242349,242322,242323,242324,242325,242326,242327,242350,242351,242328,242352,242329,242330,242331,242332,242333,242353,242334,242335,242336,242337,242338,242339,242340,242341,242354,242342,242355,242343,242344,242949,242345,242346,242356,242431,242435,242436,242347,242348,242384,242359,242357,242358,242360,242361,242362,242385,242386,242363,242387,242364,242365,242366,242367,242368,242388,242369,242370,242371,242372,242373,242374,242375,242376,242389,242377,242390,242378,242379,242945,242380,242381,242391,242432,242382,242383,242419,242392,242393,242394,242395,242396,242397,242420,242421,242398,242422,242399,242400,242401,242402,242403,242423,242404,242405,242406,242407,242408,242409,242410,242411,242424,242412,242425,242413,242414,242948,242415,242416,242426,242417,242418,242463,242462,242438,242439,242437,242440,242441,242442,242466,242467,242443,242468,242444,242445,242446,242447,242448,242469,242449,242450,242451,242452,242453,242454,242455,242456,242470,242457,242471,242458,242459,242946,242460,242461,242472,242499,242498,242474,242475,242473,242476,242477,242478,242502,242503,242479,242504,242480,242481,242482,242483,242484,242505,242485,242486,242487,242488,242489,242490,242491,242492,242506,242493,242507,242494,242495,242947,242496,242497,242508)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["cscart_migrate.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_type show_gallery gallery_category_id image_path alt image_x image_y images_image_id
33339 215376 variant_image 45572 0 V 0 D 0 0
33340 215377 variant_image 45573 0 V 0 D 0 0
37901 219238 variant_image 50134 0 V 0 D 0 0
37904 219241 variant_image 50137 0 V 0 D 0 0
37912 219249 variant_image 50145 0 V 0 D 0 0
37913 219250 variant_image 50146 0 V 0 D 0 0
37915 219252 variant_image 50148 0 V 0 D 0 0
37916 219253 variant_image 50149 0 V 0 D 0 0
37917 219254 variant_image 50150 0 V 0 D 0 0
37918 219255 variant_image 50151 0 V 0 D 0 0
37919 219256 variant_image 50152 0 V 0 D 0 0
37920 219257 variant_image 50153 0 V 0 D 0 0
37921 219258 variant_image 50154 0 V 0 D 0 0
37922 219259 variant_image 50155 0 V 0 D 0 0
38738 219237 variant_image 50971 0 V 0 D 0 0
42039 223756 variant_image 54272 0 V 0 D 0 0
42040 223757 variant_image 54273 0 V 0 D 0 0
42041 223758 variant_image 54274 0 V 0 D 0 0
42042 223759 variant_image 54275 0 V 0 D 0 0
42043 223761 variant_image 54276 0 V 0 D 0 0
42044 223762 variant_image 54277 0 V 0 D 0 0
49791 219239 variant_image 62024 0 V 0 D 0 0
70266 240801 variant_image 82499 0 V 0 D 0 0
70267 240802 variant_image 82500 0 V 0 D 0 0
70269 240804 variant_image 82502 0 V 0 D 0 0
70292 240816 variant_image 82525 0 V 0 D 0 0
70293 240808 variant_image 82526 0 V 0 D 0 0
70294 240806 variant_image 82527 0 V 0 D 0 0
71845 242282 variant_image 84078 0 V 0 D 0 0
71846 242283 variant_image 84079 0 V 0 D 0 0
71847 242284 variant_image 84080 0 V 0 D 0 0
71848 242285 variant_image 84081 0 V 0 D 0 0
71849 242286 variant_image 84082 0 V 0 D 0 0
71850 242287 variant_image 84083 0 V 0 D 0 0
71851 242288 variant_image 84084 0 V 0 D 0 0
71852 242289 variant_image 84085 0 V 0 D 0 0
71853 242290 variant_image 84086 0 V 0 D 0 0
71854 242291 variant_image 84087 0 V 0 D 0 0
71855 242292 variant_image 84088 0 V 0 D 0 0
71856 242293 variant_image 84089 0 V 0 D 0 0
71857 242294 variant_image 84090 0 V 0 D 0 0
71858 242295 variant_image 84091 0 V 0 D 0 0
71859 242296 variant_image 84092 0 V 0 D 0 0
71860 242297 variant_image 84093 0 V 0 D 0 0
71861 242298 variant_image 84094 0 V 0 D 0 0
71862 242299 variant_image 84095 0 V 0 D 0 0
71863 242300 variant_image 84096 0 V 0 D 0 0
71864 242301 variant_image 84097 0 V 0 D 0 0
71865 242302 variant_image 84098 0 V 0 D 0 0
71866 242303 variant_image 84099 0 V 0 D 0 0
71867 242304 variant_image 84100 0 V 0 D 0 0
71868 242305 variant_image 84101 0 V 0 D 0 0
71869 242306 variant_image 84102 0 V 0 D 0 0
71873 242310 variant_image 84106 0 V 0 D 0 0
71874 242311 variant_image 84107 0 V 0 D 0 0
71877 242315 variant_image 84110 0 V 0 D 0 0
71878 242316 variant_image 84111 0 V 0 D 0 0
71879 242317 variant_image 84112 0 V 0 D 0 0
71880 242318 variant_image 84113 0 V 0 D 0 0
71881 242319 variant_image 84114 0 V 0 D 0 0
71882 242320 variant_image 84115 0 V 0 D 0 0
71883 242321 variant_image 84116 0 V 0 D 0 0
71884 242322 variant_image 84117 0 V 0 D 0 0
71885 242323 variant_image 84118 0 V 0 D 0 0
71886 242324 variant_image 84119 0 V 0 D 0 0
71887 242325 variant_image 84120 0 V 0 D 0 0
71888 242326 variant_image 84121 0 V 0 D 0 0
71889 242327 variant_image 84122 0 V 0 D 0 0
71890 242328 variant_image 84123 0 V 0 D 0 0
71891 242329 variant_image 84124 0 V 0 D 0 0
71892 242330 variant_image 84125 0 V 0 D 0 0
71893 242331 variant_image 84126 0 V 0 D 0 0
71894 242332 variant_image 84127 0 V 0 D 0 0
71895 242333 variant_image 84128 0 V 0 D 0 0
71896 242334 variant_image 84129 0 V 0 D 0 0
71897 242335 variant_image 84130 0 V 0 D 0 0
71898 242336 variant_image 84131 0 V 0 D 0 0
71899 242337 variant_image 84132 0 V 0 D 0 0
71900 242338 variant_image 84133 0 V 0 D 0 0
71901 242339 variant_image 84134 0 V 0 D 0 0
71902 242340 variant_image 84135 0 V 0 D 0 0
71903 242341 variant_image 84136 0 V 0 D 0 0
71904 242342 variant_image 84137 0 V 0 D 0 0
71905 242343 variant_image 84138 0 V 0 D 0 0
71906 242344 variant_image 84139 0 V 0 D 0 0
71907 242345 variant_image 84140 0 V 0 D 0 0
71908 242346 variant_image 84141 0 V 0 D 0 0
71909 242347 variant_image 84142 0 V 0 D 0 0
71910 242348 variant_image 84143 0 V 0 D 0 0
71911 242350 variant_image 84144 0 V 0 D 0 0
71912 242351 variant_image 84145 0 V 0 D 0 0
71913 242352 variant_image 84146 0 V 0 D 0 0
71914 242353 variant_image 84147 0 V 0 D 0 0
71915 242354 variant_image 84148 0 V 0 D 0 0
71916 242355 variant_image 84149 0 V 0 D 0 0
71917 242356 variant_image 84150 0 V 0 D 0 0
71918 242357 variant_image 84151 0 V 0 D 0 0
71919 242358 variant_image 84152 0 V 0 D 0 0
71920 242359 variant_image 84153 0 V 0 D 0 0
71921 242360 variant_image 84154 0 V 0 D 0 0
71922 242361 variant_image 84155 0 V 0 D 0 0
71923 242362 variant_image 84156 0 V 0 D 0 0
71924 242363 variant_image 84157 0 V 0 D 0 0
71925 242364 variant_image 84158 0 V 0 D 0 0
71926 242365 variant_image 84159 0 V 0 D 0 0
71927 242366 variant_image 84160 0 V 0 D 0 0
71928 242367 variant_image 84161 0 V 0 D 0 0
71929 242368 variant_image 84162 0 V 0 D 0 0
71930 242369 variant_image 84163 0 V 0 D 0 0
71931 242370 variant_image 84164 0 V 0 D 0 0
71932 242371 variant_image 84165 0 V 0 D 0 0
71933 242372 variant_image 84166 0 V 0 D 0 0
71934 242373 variant_image 84167 0 V 0 D 0 0
71935 242374 variant_image 84168 0 V 0 D 0 0
71936 242375 variant_image 84169 0 V 0 D 0 0
71937 242376 variant_image 84170 0 V 0 D 0 0
71938 242377 variant_image 84171 0 V 0 D 0 0
71939 242378 variant_image 84172 0 V 0 D 0 0
71940 242379 variant_image 84173 0 V 0 D 0 0
71941 242380 variant_image 84174 0 V 0 D 0 0
71942 242381 variant_image 84175 0 V 0 D 0 0
71943 242382 variant_image 84176 0 V 0 D 0 0
71944 242383 variant_image 84177 0 V 0 D 0 0
71945 242385 variant_image 84178 0 V 0 D 0 0
71946 242386 variant_image 84179 0 V 0 D 0 0
71947 242387 variant_image 84180 0 V 0 D 0 0
71948 242388 variant_image 84181 0 V 0 D 0 0
71949 242389 variant_image 84182 0 V 0 D 0 0
71950 242390 variant_image 84183 0 V 0 D 0 0
71951 242391 variant_image 84184 0 V 0 D 0 0
71952 242392 variant_image 84185 0 V 0 D 0 0
71953 242393 variant_image 84186 0 V 0 D 0 0
71954 242394 variant_image 84187 0 V 0 D 0 0
71955 242395 variant_image 84188 0 V 0 D 0 0
71956 242396 variant_image 84189 0 V 0 D 0 0
71957 242397 variant_image 84190 0 V 0 D 0 0
71958 242398 variant_image 84191 0 V 0 D 0 0
71959 242399 variant_image 84192 0 V 0 D 0 0
71960 242400 variant_image 84193 0 V 0 D 0 0
71961 242401 variant_image 84194 0 V 0 D 0 0
71962 242402 variant_image 84195 0 V 0 D 0 0
71963 242403 variant_image 84196 0 V 0 D 0 0
71964 242404 variant_image 84197 0 V 0 D 0 0
71965 242405 variant_image 84198 0 V 0 D 0 0
71966 242406 variant_image 84199 0 V 0 D 0 0
71967 242407 variant_image 84200 0 V 0 D 0 0
71968 242408 variant_image 84201 0 V 0 D 0 0
71969 242409 variant_image 84202 0 V 0 D 0 0
71970 242410 variant_image 84203 0 V 0 D 0 0
71971 242411 variant_image 84204 0 V 0 D 0 0
71972 242412 variant_image 84205 0 V 0 D 0 0
71973 242413 variant_image 84206 0 V 0 D 0 0
71974 242414 variant_image 84207 0 V 0 D 0 0
71975 242415 variant_image 84208 0 V 0 D 0 0
71976 242416 variant_image 84209 0 V 0 D 0 0
71977 242417 variant_image 84210 0 V 0 D 0 0
71978 242418 variant_image 84211 0 V 0 D 0 0
71979 242420 variant_image 84212 0 V 0 D 0 0
71980 242421 variant_image 84213 0 V 0 D 0 0
71981 242422 variant_image 84214 0 V 0 D 0 0
71982 242423 variant_image 84215 0 V 0 D 0 0
71983 242424 variant_image 84216 0 V 0 D 0 0
71984 242425 variant_image 84217 0 V 0 D 0 0
71985 242426 variant_image 84218 0 V 0 D 0 0
72022 242430 variant_image 84255 0 V 0 D 0 0
72023 242431 variant_image 84256 0 V 0 D 0 0
72024 242432 variant_image 84257 0 V 0 D 0 0
72030 242433 variant_image 84263 0 V 0 D 0 0
72031 242434 variant_image 84264 0 V 0 D 0 0
72032 242435 variant_image 84265 0 V 0 D 0 0
72033 242436 variant_image 84266 0 V 0 D 0 0
72034 242437 variant_image 84267 0 V 0 D 0 0
72035 242438 variant_image 84268 0 V 0 D 0 0
72036 242439 variant_image 84269 0 V 0 D 0 0
72037 242440 variant_image 84270 0 V 0 D 0 0
72038 242441 variant_image 84271 0 V 0 D 0 0
72039 242442 variant_image 84272 0 V 0 D 0 0
72040 242443 variant_image 84273 0 V 0 D 0 0
72041 242444 variant_image 84274 0 V 0 D 0 0
72042 242445 variant_image 84275 0 V 0 D 0 0
72043 242446 variant_image 84276 0 V 0 D 0 0
72044 242447 variant_image 84277 0 V 0 D 0 0
72045 242448 variant_image 84278 0 V 0 D 0 0
72046 242449 variant_image 84279 0 V 0 D 0 0
72047 242450 variant_image 84280 0 V 0 D 0 0
72048 242451 variant_image 84281 0 V 0 D 0 0
72049 242452 variant_image 84282 0 V 0 D 0 0
72050 242453 variant_image 84283 0 V 0 D 0 0
72051 242454 variant_image 84284 0 V 0 D 0 0
72052 242455 variant_image 84285 0 V 0 D 0 0
72053 242456 variant_image 84286 0 V 0 D 0 0
72054 242457 variant_image 84287 0 V 0 D 0 0
72055 242458 variant_image 84288 0 V 0 D 0 0
72056 242459 variant_image 84289 0 V 0 D 0 0
72057 242460 variant_image 84290 0 V 0 D 0 0
72058 242461 variant_image 84291 0 V 0 D 0 0
72059 242462 variant_image 84292 0 V 0 D 0 0
72062 242466 variant_image 84295 0 V 0 D 0 0
72063 242467 variant_image 84296 0 V 0 D 0 0
72064 242468 variant_image 84297 0 V 0 D 0 0
72065 242469 variant_image 84298 0 V 0 D 0 0
72066 242470 variant_image 84299 0 V 0 D 0 0
72067 242471 variant_image 84300 0 V 0 D 0 0
72068 242472 variant_image 84301 0 V 0 D 0 0
72069 242473 variant_image 84302 0 V 0 D 0 0
72070 242474 variant_image 84303 0 V 0 D 0 0
72071 242475 variant_image 84304 0 V 0 D 0 0
72072 242476 variant_image 84305 0 V 0 D 0 0
72073 242477 variant_image 84306 0 V 0 D 0 0
72074 242478 variant_image 84307 0 V 0 D 0 0
72075 242479 variant_image 84308 0 V 0 D 0 0
72076 242480 variant_image 84309 0 V 0 D 0 0
72077 242481 variant_image 84310 0 V 0 D 0 0
72078 242482 variant_image 84311 0 V 0 D 0 0
72079 242483 variant_image 84312 0 V 0 D 0 0
72080 242484 variant_image 84313 0 V 0 D 0 0
72081 242485 variant_image 84314 0 V 0 D 0 0
72082 242486 variant_image 84315 0 V 0 D 0 0
72083 242487 variant_image 84316 0 V 0 D 0 0
72084 242488 variant_image 84317 0 V 0 D 0 0
72085 242489 variant_image 84318 0 V 0 D 0 0
72086 242490 variant_image 84319 0 V 0 D 0 0
72087 242491 variant_image 84320 0 V 0 D 0 0
72088 242492 variant_image 84321 0 V 0 D 0 0
72089 242493 variant_image 84322 0 V 0 D 0 0
72090 242494 variant_image 84323 0 V 0 D 0 0
72091 242495 variant_image 84324 0 V 0 D 0 0
72092 242496 variant_image 84325 0 V 0 D 0 0
72093 242497 variant_image 84326 0 V 0 D 0 0
72094 242498 variant_image 84327 0 V 0 D 0 0
72097 242502 variant_image 84330 0 V 0 D 0 0
72098 242503 variant_image 84331 0 V 0 D 0 0
72099 242504 variant_image 84332 0 V 0 D 0 0
72100 242505 variant_image 84333 0 V 0 D 0 0
72101 242506 variant_image 84334 0 V 0 D 0 0
72102 242507 variant_image 84335 0 V 0 D 0 0
72103 242508 variant_image 84336 0 V 0 D 0 0
72566 242944 variant_image 84799 0 V 0 D 0 0
72567 242945 variant_image 84800 0 V 0 D 0 0
72568 242946 variant_image 84801 0 V 0 D 0 0
72569 242947 variant_image 84802 0 V 0 D 0 0
72570 242948 variant_image 84803 0 V 0 D 0 0
72571 242949 variant_image 84804 0 V 0 D 0 0
72617 242973 variant_image 84850 0 V 0 D 0 0