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, 
    220229, 
    217138, 
    217139, 
    217140, 
    217141, 
    220258, 
    218968, 
    218969, 
    218970, 
    220259, 
    218978, 
    218979, 
    218980, 
    220260, 
    218988, 
    218989, 
    218990, 
    220318, 
    215376, 
    215377, 
    230564, 
    230565, 
    230566, 
    230567, 
    230568, 
    230569, 
    233387, 
    233355, 
    233356, 
    233357, 
    233358, 
    233359, 
    233360, 
    238319, 
    238320, 
    233361, 
    241909, 
    233362, 
    233363, 
    233364, 
    233365, 
    233366, 
    241910, 
    233367, 
    233368, 
    233369, 
    233370, 
    233371, 
    233372, 
    233373, 
    233374, 
    241911, 
    233375, 
    241912, 
    233376, 
    233377, 
    233378, 
    233379, 
    233380, 
    241913, 
    233385, 
    233386, 
    242171, 
    242172, 
    242173, 
    242174, 
    233417, 
    233388, 
    233389, 
    233390, 
    233391, 
    233392, 
    233393, 
    233394, 
    238321, 
    238322, 
    233395, 
    241924, 
    233396, 
    233397, 
    233398, 
    233399, 
    233400, 
    241925, 
    233401, 
    233402, 
    233403, 
    233404, 
    233405, 
    233406, 
    233407, 
    233408, 
    241926, 
    233409, 
    241927, 
    233410, 
    233411, 
    233412, 
    233413, 
    233414, 
    241928, 
    233415, 
    233416, 
    242183, 
    242184, 
    242185, 
    242186, 
    233546, 
    233547, 
    233548, 
    233549, 
    240413, 
    240444, 
    240414, 
    240415, 
    240416, 
    240417, 
    240418, 
    240419, 
    240420, 
    241919, 
    240421, 
    240422, 
    240423, 
    240424, 
    240425, 
    241920, 
    240426, 
    240427, 
    240428, 
    240429, 
    240430, 
    240431, 
    240432, 
    240433, 
    241921, 
    240434, 
    241922, 
    240435, 
    240436, 
    240437, 
    240438, 
    240439, 
    241923, 
    240445, 
    240446, 
    242179, 
    242180, 
    242181, 
    242182
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00305

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": 169,
          "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,220229,217138,217139,217140,217141,220258,218968,218969,218970,220259,218978,218979,218980,220260,218988,218989,218990,220318,215376,215377,230564,230565,230566,230567,230568,230569,233387,233355,233356,233357,233358,233359,233360,238319,238320,233361,241909,233362,233363,233364,233365,233366,241910,233367,233368,233369,233370,233371,233372,233373,233374,241911,233375,241912,233376,233377,233378,233379,233380,241913,233385,233386,242171,242172,242173,242174,233417,233388,233389,233390,233391,233392,233393,233394,238321,238322,233395,241924,233396,233397,233398,233399,233400,241925,233401,233402,233403,233404,233405,233406,233407,233408,241926,233409,241927,233410,233411,233412,233413,233414,241928,233415,233416,242183,242184,242185,242186,233546,233547,233548,233549,240413,240444,240414,240415,240416,240417,240418,240419,240420,241919,240421,240422,240423,240424,240425,241920,240426,240427,240428,240429,240430,240431,240432,240433,241921,240434,241922,240435,240436,240437,240438,240439,241923,240445,240446,242179,242180,242181,242182)"
        }
      }
    },
    "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
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
35343 217138 variant_image 47576 0 V 0 D 0 0
35344 217139 variant_image 47577 0 V 0 D 0 0
35345 217140 variant_image 47578 0 V 0 D 0 0
35346 217141 variant_image 47579 0 V 0 D 0 0
37481 218968 variant_image 49714 0 V 0 D 0 0
37482 218969 variant_image 49715 0 V 0 D 0 0
37483 218970 variant_image 49716 0 V 0 D 0 0
37491 218978 variant_image 49724 0 V 0 D 0 0
37492 218979 variant_image 49725 0 V 0 D 0 0
37493 218980 variant_image 49726 0 V 0 D 0 0
37501 218988 variant_image 49734 0 V 0 D 0 0
37502 218989 variant_image 49735 0 V 0 D 0 0
37503 218990 variant_image 49736 0 V 0 D 0 0
53880 233355 variant_image 66113 0 V 0 D 0 0
53881 233356 variant_image 66114 0 V 0 D 0 0
53882 233357 variant_image 66115 0 V 0 D 0 0
53883 233358 variant_image 66116 0 V 0 D 0 0
53884 233359 variant_image 66117 0 V 0 D 0 0
53885 233360 variant_image 66118 0 V 0 D 0 0
53886 233361 variant_image 66119 0 V 0 D 0 0
53887 233362 variant_image 66120 0 V 0 D 0 0
53888 233363 variant_image 66121 0 V 0 D 0 0
53889 233364 variant_image 66122 0 V 0 D 0 0
53890 233365 variant_image 66123 0 V 0 D 0 0
53891 233366 variant_image 66124 0 V 0 D 0 0
53892 233367 variant_image 66125 0 V 0 D 0 0
53893 233368 variant_image 66126 0 V 0 D 0 0
53894 233369 variant_image 66127 0 V 0 D 0 0
53895 233370 variant_image 66128 0 V 0 D 0 0
53896 233371 variant_image 66129 0 V 0 D 0 0
53897 233372 variant_image 66130 0 V 0 D 0 0
53898 233373 variant_image 66131 0 V 0 D 0 0
53899 233374 variant_image 66132 0 V 0 D 0 0
53900 233375 variant_image 66133 0 V 0 D 0 0
53901 233376 variant_image 66134 0 V 0 D 0 0
53902 233377 variant_image 66135 0 V 0 D 0 0
53903 233378 variant_image 66136 0 V 0 D 0 0
53904 233379 variant_image 66137 0 V 0 D 0 0
53905 233380 variant_image 66138 0 V 0 D 0 0
53910 233385 variant_image 66143 0 V 0 D 0 0
53911 233386 variant_image 66144 0 V 0 D 0 0
53912 233389 variant_image 66145 0 V 0 D 0 0
53913 233390 variant_image 66146 0 V 0 D 0 0
53914 233391 variant_image 66147 0 V 0 D 0 0
53915 233392 variant_image 66148 0 V 0 D 0 0
53916 233393 variant_image 66149 0 V 0 D 0 0
53917 233394 variant_image 66150 0 V 0 D 0 0
53918 233395 variant_image 66151 0 V 0 D 0 0
53919 233396 variant_image 66152 0 V 0 D 0 0
53920 233397 variant_image 66153 0 V 0 D 0 0
53921 233398 variant_image 66154 0 V 0 D 0 0
53922 233399 variant_image 66155 0 V 0 D 0 0
53923 233400 variant_image 66156 0 V 0 D 0 0
53924 233401 variant_image 66157 0 V 0 D 0 0
53925 233402 variant_image 66158 0 V 0 D 0 0
53926 233403 variant_image 66159 0 V 0 D 0 0
53927 233404 variant_image 66160 0 V 0 D 0 0
53928 233405 variant_image 66161 0 V 0 D 0 0
53929 233406 variant_image 66162 0 V 0 D 0 0
53930 233407 variant_image 66163 0 V 0 D 0 0
53931 233408 variant_image 66164 0 V 0 D 0 0
53932 233409 variant_image 66165 0 V 0 D 0 0
53933 233410 variant_image 66166 0 V 0 D 0 0
53934 233411 variant_image 66167 0 V 0 D 0 0
53935 233412 variant_image 66168 0 V 0 D 0 0
53936 233413 variant_image 66169 0 V 0 D 0 0
53937 233414 variant_image 66170 0 V 0 D 0 0
53938 233415 variant_image 66171 0 V 0 D 0 0
53939 233416 variant_image 66172 0 V 0 D 0 0
54104 233547 variant_image 66337 0 V 0 D 0 0
54105 233548 variant_image 66338 0 V 0 D 0 0
54106 233549 variant_image 66339 0 V 0 D 0 0
62278 238319 variant_image 74511 0 V 0 D 0 0
62279 238320 variant_image 74512 0 V 0 D 0 0
62280 238321 variant_image 74513 0 V 0 D 0 0
62281 238322 variant_image 74514 0 V 0 D 0 0
69198 240414 variant_image 81431 0 V 0 D 0 0
69199 240415 variant_image 81432 0 V 0 D 0 0
69200 240416 variant_image 81433 0 V 0 D 0 0
69201 240417 variant_image 81434 0 V 0 D 0 0
69202 240418 variant_image 81435 0 V 0 D 0 0
69203 240419 variant_image 81436 0 V 0 D 0 0
69204 240420 variant_image 81437 0 V 0 D 0 0
69205 240421 variant_image 81438 0 V 0 D 0 0
69206 240422 variant_image 81439 0 V 0 D 0 0
69207 240423 variant_image 81440 0 V 0 D 0 0
69208 240424 variant_image 81441 0 V 0 D 0 0
69209 240425 variant_image 81442 0 V 0 D 0 0
69210 240426 variant_image 81443 0 V 0 D 0 0
69211 240427 variant_image 81444 0 V 0 D 0 0
69212 240428 variant_image 81445 0 V 0 D 0 0
69213 240429 variant_image 81446 0 V 0 D 0 0
69214 240430 variant_image 81447 0 V 0 D 0 0
69215 240431 variant_image 81448 0 V 0 D 0 0
69216 240432 variant_image 81449 0 V 0 D 0 0
69217 240433 variant_image 81450 0 V 0 D 0 0
69218 240434 variant_image 81451 0 V 0 D 0 0
69219 240435 variant_image 81452 0 V 0 D 0 0
69220 240436 variant_image 81453 0 V 0 D 0 0
69221 240437 variant_image 81454 0 V 0 D 0 0
69222 240438 variant_image 81455 0 V 0 D 0 0
69223 240439 variant_image 81456 0 V 0 D 0 0
69228 240446 variant_image 81461 0 V 0 D 0 0
69229 240445 variant_image 81462 0 V 0 D 0 0
71462 241909 variant_image 83695 0 V 0 D 0 0
71463 241910 variant_image 83696 0 V 0 D 0 0
71464 241911 variant_image 83697 0 V 0 D 0 0
71465 241912 variant_image 83698 0 V 0 D 0 0
71466 241913 variant_image 83699 0 V 0 D 0 0
71472 241919 variant_image 83705 0 V 0 D 0 0
71473 241920 variant_image 83706 0 V 0 D 0 0
71474 241921 variant_image 83707 0 V 0 D 0 0
71475 241922 variant_image 83708 0 V 0 D 0 0
71476 241923 variant_image 83709 0 V 0 D 0 0
71477 241924 variant_image 83710 0 V 0 D 0 0
71478 241925 variant_image 83711 0 V 0 D 0 0
71479 241926 variant_image 83712 0 V 0 D 0 0
71480 241927 variant_image 83713 0 V 0 D 0 0
71481 241928 variant_image 83714 0 V 0 D 0 0
71734 242171 variant_image 83967 0 V 0 D 0 0
71735 242172 variant_image 83968 0 V 0 D 0 0
71736 242173 variant_image 83969 0 V 0 D 0 0
71737 242174 variant_image 83970 0 V 0 D 0 0
71740 242179 variant_image 83973 0 V 0 D 0 0
71741 242180 variant_image 83974 0 V 0 D 0 0
71742 242181 variant_image 83975 0 V 0 D 0 0
71743 242182 variant_image 83976 0 V 0 D 0 0
71746 242183 variant_image 83979 0 V 0 D 0 0
71747 242184 variant_image 83980 0 V 0 D 0 0
71748 242185 variant_image 83981 0 V 0 D 0 0
71749 242186 variant_image 83982 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