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 (
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    223650, 
    223620, 
    223621, 
    223622, 
    223623, 
    223624, 
    244420, 
    223625, 
    237192, 
    237193, 
    223626, 
    242239, 
    241433, 
    223627, 
    223628, 
    223629, 
    223630, 
    223631, 
    241434, 
    223632, 
    223633, 
    223634, 
    223635, 
    223636, 
    223637, 
    223638, 
    223639, 
    241435, 
    223640, 
    241436, 
    223641, 
    223642, 
    242240, 
    242241, 
    223643, 
    223644, 
    223645, 
    242242, 
    241437, 
    223749, 
    223750, 
    223751, 
    223752, 
    223753, 
    223754, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    243113, 
    243117, 
    243118, 
    243119, 
    244311, 
    244285, 
    244286, 
    244287, 
    244288, 
    244310, 
    244303, 
    244312, 
    244313, 
    244289, 
    244314, 
    244290, 
    244291, 
    244292, 
    244293, 
    244294, 
    244315, 
    244295, 
    244296, 
    244297, 
    244298, 
    244299, 
    244300, 
    244301, 
    244302, 
    244316, 
    244317, 
    244304, 
    244305, 
    244306, 
    244307, 
    244308, 
    244309, 
    244318, 
    244319, 
    244320, 
    244321, 
    244322, 
    244354, 
    244330, 
    244328, 
    244329, 
    244331, 
    244353, 
    244346, 
    244355, 
    244356, 
    244332, 
    244357, 
    244333, 
    244334, 
    244335, 
    244336, 
    244337, 
    244358, 
    244338, 
    244339, 
    244340, 
    244341, 
    244342, 
    244343, 
    244344, 
    244345, 
    244359, 
    244360, 
    244347, 
    244348, 
    244349, 
    244350, 
    244351, 
    244352, 
    244361, 
    244362, 
    244363, 
    244364, 
    244365, 
    244404, 
    244405, 
    244406, 
    244407, 
    244379, 
    244408, 
    244380, 
    244381, 
    244382, 
    244383, 
    244409, 
    244410, 
    244384, 
    244411, 
    244385, 
    244386, 
    244387, 
    244388, 
    244389, 
    244412, 
    244390, 
    244391, 
    244392, 
    244393, 
    244394, 
    244395, 
    244396, 
    244397, 
    244413, 
    244398, 
    244399, 
    244414, 
    244400, 
    244401, 
    244402, 
    244403, 
    244415, 
    244416, 
    244417, 
    244418, 
    244419, 
    244454, 
    244455, 
    244456, 
    244457
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00242

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": 197,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,223650,223620,223621,223622,223623,223624,244420,223625,237192,237193,223626,242239,241433,223627,223628,223629,223630,223631,241434,223632,223633,223634,223635,223636,223637,223638,223639,241435,223640,241436,223641,223642,242240,242241,223643,223644,223645,242242,241437,223749,223750,223751,223752,223753,223754,223755,223756,223757,223758,223759,223760,223761,223762,243113,243117,243118,243119,244311,244285,244286,244287,244288,244310,244303,244312,244313,244289,244314,244290,244291,244292,244293,244294,244315,244295,244296,244297,244298,244299,244300,244301,244302,244316,244317,244304,244305,244306,244307,244308,244309,244318,244319,244320,244321,244322,244354,244330,244328,244329,244331,244353,244346,244355,244356,244332,244357,244333,244334,244335,244336,244337,244358,244338,244339,244340,244341,244342,244343,244344,244345,244359,244360,244347,244348,244349,244350,244351,244352,244361,244362,244363,244364,244365,244404,244405,244406,244407,244379,244408,244380,244381,244382,244383,244409,244410,244384,244411,244385,244386,244387,244388,244389,244412,244390,244391,244392,244393,244394,244395,244396,244397,244413,244398,244399,244414,244400,244401,244402,244403,244415,244416,244417,244418,244419,244454,244455,244456,244457)"
        }
      }
    },
    "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
33513 215556 variant_image 45746 0 V 0 D 0 0
33514 215557 variant_image 45747 0 V 0 D 0 0
33515 215558 variant_image 45748 0 V 0 D 0 0
33516 215559 variant_image 45749 0 V 0 D 0 0
33517 215560 variant_image 45750 0 V 0 D 0 0
33518 215561 variant_image 45751 0 V 0 D 0 0
33519 215562 variant_image 45752 0 V 0 D 0 0
33520 215563 variant_image 45753 0 V 0 D 0 0
33521 215564 variant_image 45754 0 V 0 D 0 0
33522 215565 variant_image 45755 0 V 0 D 0 0
33523 215566 variant_image 45756 0 V 0 D 0 0
33524 215567 variant_image 45757 0 V 0 D 0 0
33525 215568 variant_image 45758 0 V 0 D 0 0
33526 215569 variant_image 45759 0 V 0 D 0 0
41894 223620 variant_image 54127 0 V 0 D 0 0
41895 223621 variant_image 54128 0 V 0 D 0 0
41896 223622 variant_image 54129 0 V 0 D 0 0
41897 223623 variant_image 54130 0 V 0 D 0 0
41898 223624 variant_image 54131 0 V 0 D 0 0
41899 223625 variant_image 54132 0 V 0 D 0 0
41900 223626 variant_image 54133 0 V 0 D 0 0
41901 223627 variant_image 54134 0 V 0 D 0 0
41902 223628 variant_image 54135 0 V 0 D 0 0
41903 223629 variant_image 54136 0 V 0 D 0 0
41904 223630 variant_image 54137 0 V 0 D 0 0
41905 223631 variant_image 54138 0 V 0 D 0 0
41906 223632 variant_image 54139 0 V 0 D 0 0
41907 223633 variant_image 54140 0 V 0 D 0 0
41908 223634 variant_image 54141 0 V 0 D 0 0
41909 223635 variant_image 54142 0 V 0 D 0 0
41910 223636 variant_image 54143 0 V 0 D 0 0
41911 223637 variant_image 54144 0 V 0 D 0 0
41912 223638 variant_image 54145 0 V 0 D 0 0
41913 223639 variant_image 54146 0 V 0 D 0 0
41914 223640 variant_image 54147 0 V 0 D 0 0
41915 223641 variant_image 54148 0 V 0 D 0 0
41916 223642 variant_image 54149 0 V 0 D 0 0
41917 223643 variant_image 54150 0 V 0 D 0 0
41918 223644 variant_image 54151 0 V 0 D 0 0
41919 223645 variant_image 54152 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
59939 237192 variant_image 72172 0 V 0 D 0 0
59940 237193 variant_image 72173 0 V 0 D 0 0
70968 241433 variant_image 83201 0 V 0 D 0 0
70969 241434 variant_image 83202 0 V 0 D 0 0
70970 241435 variant_image 83203 0 V 0 D 0 0
70971 241436 variant_image 83204 0 V 0 D 0 0
70972 241437 variant_image 83205 0 V 0 D 0 0
71802 242239 variant_image 84035 0 V 0 D 0 0
71803 242240 variant_image 84036 0 V 0 D 0 0
71804 242241 variant_image 84037 0 V 0 D 0 0
71805 242242 variant_image 84038 0 V 0 D 0 0
72819 243103 variant_image 85052 0 V 0 D 0 0
72820 243104 variant_image 85053 0 V 0 D 0 0
72821 243105 variant_image 85054 0 V 0 D 0 0
72822 243106 variant_image 85055 0 V 0 D 0 0
74012 244285 variant_image 86245 0 V 0 D 0 0
74013 244286 variant_image 86246 0 V 0 D 0 0
74014 244287 variant_image 86247 0 V 0 D 0 0
74015 244288 variant_image 86248 0 V 0 D 0 0
74016 244289 variant_image 86249 0 V 0 D 0 0
74017 244290 variant_image 86250 0 V 0 D 0 0
74018 244291 variant_image 86251 0 V 0 D 0 0
74019 244292 variant_image 86252 0 V 0 D 0 0
74020 244293 variant_image 86253 0 V 0 D 0 0
74021 244294 variant_image 86254 0 V 0 D 0 0
74022 244295 variant_image 86255 0 V 0 D 0 0
74023 244296 variant_image 86256 0 V 0 D 0 0
74024 244297 variant_image 86257 0 V 0 D 0 0
74025 244298 variant_image 86258 0 V 0 D 0 0
74026 244299 variant_image 86259 0 V 0 D 0 0
74027 244300 variant_image 86260 0 V 0 D 0 0
74028 244301 variant_image 86261 0 V 0 D 0 0
74029 244302 variant_image 86262 0 V 0 D 0 0
74030 244303 variant_image 86263 0 V 0 D 0 0
74031 244304 variant_image 86264 0 V 0 D 0 0
74032 244305 variant_image 86265 0 V 0 D 0 0
74033 244306 variant_image 86266 0 V 0 D 0 0
74034 244307 variant_image 86267 0 V 0 D 0 0
74035 244308 variant_image 86268 0 V 0 D 0 0
74036 244309 variant_image 86269 0 V 0 D 0 0
74037 244310 variant_image 86270 0 V 0 D 0 0
74038 244312 variant_image 86271 0 V 0 D 0 0
74039 244313 variant_image 86272 0 V 0 D 0 0
74040 244314 variant_image 86273 0 V 0 D 0 0
74041 244315 variant_image 86274 0 V 0 D 0 0
74042 244316 variant_image 86275 0 V 0 D 0 0
74043 244317 variant_image 86276 0 V 0 D 0 0
74044 244318 variant_image 86277 0 V 0 D 0 0
74045 244319 variant_image 86278 0 V 0 D 0 0
74046 244320 variant_image 86279 0 V 0 D 0 0
74047 244321 variant_image 86280 0 V 0 D 0 0
74048 244322 variant_image 86281 0 V 0 D 0 0
74054 244328 variant_image 86287 0 V 0 D 0 0
74055 244329 variant_image 86288 0 V 0 D 0 0
74056 244330 variant_image 86289 0 V 0 D 0 0
74057 244331 variant_image 86290 0 V 0 D 0 0
74058 244332 variant_image 86291 0 V 0 D 0 0
74059 244333 variant_image 86292 0 V 0 D 0 0
74060 244334 variant_image 86293 0 V 0 D 0 0
74061 244335 variant_image 86294 0 V 0 D 0 0
74062 244336 variant_image 86295 0 V 0 D 0 0
74063 244337 variant_image 86296 0 V 0 D 0 0
74064 244338 variant_image 86297 0 V 0 D 0 0
74065 244339 variant_image 86298 0 V 0 D 0 0
74066 244340 variant_image 86299 0 V 0 D 0 0
74067 244341 variant_image 86300 0 V 0 D 0 0
74068 244342 variant_image 86301 0 V 0 D 0 0
74069 244343 variant_image 86302 0 V 0 D 0 0
74070 244344 variant_image 86303 0 V 0 D 0 0
74071 244345 variant_image 86304 0 V 0 D 0 0
74072 244346 variant_image 86305 0 V 0 D 0 0
74073 244347 variant_image 86306 0 V 0 D 0 0
74074 244348 variant_image 86307 0 V 0 D 0 0
74075 244349 variant_image 86308 0 V 0 D 0 0
74076 244350 variant_image 86309 0 V 0 D 0 0
74077 244351 variant_image 86310 0 V 0 D 0 0
74078 244352 variant_image 86311 0 V 0 D 0 0
74079 244353 variant_image 86312 0 V 0 D 0 0
74080 244355 variant_image 86313 0 V 0 D 0 0
74081 244356 variant_image 86314 0 V 0 D 0 0
74082 244357 variant_image 86315 0 V 0 D 0 0
74083 244358 variant_image 86316 0 V 0 D 0 0
74084 244359 variant_image 86317 0 V 0 D 0 0
74085 244360 variant_image 86318 0 V 0 D 0 0
74086 244361 variant_image 86319 0 V 0 D 0 0
74087 244362 variant_image 86320 0 V 0 D 0 0
74088 244363 variant_image 86321 0 V 0 D 0 0
74089 244364 variant_image 86322 0 V 0 D 0 0
74090 244365 variant_image 86323 0 V 0 D 0 0
74121 244379 variant_image 86354 0 V 0 D 0 0
74122 244380 variant_image 86355 0 V 0 D 0 0
74123 244381 variant_image 86356 0 V 0 D 0 0
74124 244382 variant_image 86357 0 V 0 D 0 0
74125 244383 variant_image 86358 0 V 0 D 0 0
74126 244384 variant_image 86359 0 V 0 D 0 0
74127 244385 variant_image 86360 0 V 0 D 0 0
74128 244386 variant_image 86361 0 V 0 D 0 0
74129 244387 variant_image 86362 0 V 0 D 0 0
74130 244388 variant_image 86363 0 V 0 D 0 0
74131 244389 variant_image 86364 0 V 0 D 0 0
74132 244390 variant_image 86365 0 V 0 D 0 0
74133 244391 variant_image 86366 0 V 0 D 0 0
74134 244392 variant_image 86367 0 V 0 D 0 0
74135 244393 variant_image 86368 0 V 0 D 0 0
74136 244394 variant_image 86369 0 V 0 D 0 0
74137 244395 variant_image 86370 0 V 0 D 0 0
74138 244396 variant_image 86371 0 V 0 D 0 0
74139 244397 variant_image 86372 0 V 0 D 0 0
74140 244398 variant_image 86373 0 V 0 D 0 0
74141 244399 variant_image 86374 0 V 0 D 0 0
74142 244400 variant_image 86375 0 V 0 D 0 0
74143 244401 variant_image 86376 0 V 0 D 0 0
74144 244402 variant_image 86377 0 V 0 D 0 0
74145 244403 variant_image 86378 0 V 0 D 0 0
74146 244405 variant_image 86379 0 V 0 D 0 0
74147 244406 variant_image 86380 0 V 0 D 0 0
74148 244407 variant_image 86381 0 V 0 D 0 0
74149 244408 variant_image 86382 0 V 0 D 0 0
74150 244409 variant_image 86383 0 V 0 D 0 0
74151 244410 variant_image 86384 0 V 0 D 0 0
74152 244411 variant_image 86385 0 V 0 D 0 0
74153 244412 variant_image 86386 0 V 0 D 0 0
74154 244413 variant_image 86387 0 V 0 D 0 0
74155 244414 variant_image 86388 0 V 0 D 0 0
74156 244415 variant_image 86389 0 V 0 D 0 0
74157 244416 variant_image 86390 0 V 0 D 0 0
74158 244417 variant_image 86391 0 V 0 D 0 0
74159 244418 variant_image 86392 0 V 0 D 0 0
74160 244419 variant_image 86393 0 V 0 D 0 0
74162 244420 variant_image 86395 0 V 0 D 0 0
74193 244455 variant_image 86426 0 V 0 D 0 0
74194 244456 variant_image 86427 0 V 0 D 0 0
74195 244457 variant_image 86428 0 V 0 D 0 0