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, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    224224, 
    224225, 
    224226, 
    226326, 
    226327, 
    226328, 
    226329, 
    226330, 
    226331, 
    226332, 
    226333, 
    226434, 
    226438, 
    226435, 
    226436, 
    226437, 
    226439, 
    226443, 
    226440, 
    226441, 
    226442, 
    226444, 
    226448, 
    226445, 
    226446, 
    226447, 
    226449, 
    226453, 
    226450, 
    226451, 
    226452, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    226576, 
    226546, 
    226547, 
    226548, 
    226549, 
    226571, 
    226564, 
    237098, 
    237099, 
    226550, 
    241305, 
    226551, 
    226552, 
    226553, 
    226554, 
    226555, 
    241306, 
    226556, 
    226557, 
    226558, 
    226559, 
    226560, 
    226561, 
    226562, 
    226563, 
    241307, 
    226565, 
    241308, 
    226566, 
    226567, 
    226568, 
    226569, 
    226570, 
    241309, 
    242517, 
    242518, 
    242519, 
    242520, 
    229781, 
    229782, 
    229783, 
    229784, 
    229785, 
    226866, 
    226831, 
    226832, 
    226833, 
    226834, 
    226835, 
    226836, 
    237164, 
    237165, 
    226837, 
    241345, 
    226838, 
    226839, 
    226840, 
    226841, 
    226842, 
    241346, 
    226843, 
    226844, 
    226845, 
    226846, 
    226847, 
    226848, 
    226849, 
    226850, 
    241347, 
    226851, 
    241348, 
    226852, 
    226853, 
    226854, 
    226855, 
    226856, 
    241349, 
    226861, 
    226862, 
    226863, 
    226864, 
    226865, 
    242561, 
    242562, 
    242563, 
    242564, 
    226880, 
    226867, 
    226869, 
    226871, 
    226873, 
    226875, 
    226877, 
    226908, 
    230589, 
    226905, 
    226906, 
    226907, 
    226921, 
    226910, 
    226912, 
    226914, 
    226916, 
    226918, 
    226920, 
    228217, 
    228218, 
    228219, 
    228252, 
    228256, 
    228253, 
    228254, 
    228255, 
    228257, 
    228261, 
    228258, 
    228259, 
    228260, 
    228262, 
    228263, 
    228264, 
    228295, 
    228299, 
    228296, 
    228297, 
    228298, 
    228300, 
    228304, 
    228301, 
    228302, 
    228303, 
    231712, 
    231710, 
    231711, 
    231715, 
    231713, 
    231714, 
    231718, 
    231716, 
    231717, 
    240924, 
    240894, 
    240895, 
    240896, 
    240897, 
    240898, 
    240918, 
    240899, 
    240929, 
    240930, 
    240900, 
    241320, 
    240901, 
    240902, 
    240903, 
    240904, 
    240905, 
    241321, 
    240906, 
    240907, 
    240908, 
    240909, 
    240910, 
    240911, 
    240912, 
    240913, 
    241322, 
    240914, 
    241323, 
    240915, 
    240916, 
    240931, 
    240917, 
    241324, 
    240919, 
    240920, 
    240921, 
    240922, 
    240923, 
    242529, 
    242530, 
    242531, 
    242532
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00246

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": 238,
          "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,223755,223756,223757,223758,223759,224224,224225,224226,226326,226327,226328,226329,226330,226331,226332,226333,226434,226438,226435,226436,226437,226439,226443,226440,226441,226442,226444,226448,226445,226446,226447,226449,226453,226450,226451,226452,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226576,226546,226547,226548,226549,226571,226564,237098,237099,226550,241305,226551,226552,226553,226554,226555,241306,226556,226557,226558,226559,226560,226561,226562,226563,241307,226565,241308,226566,226567,226568,226569,226570,241309,242517,242518,242519,242520,229781,229782,229783,229784,229785,226866,226831,226832,226833,226834,226835,226836,237164,237165,226837,241345,226838,226839,226840,226841,226842,241346,226843,226844,226845,226846,226847,226848,226849,226850,241347,226851,241348,226852,226853,226854,226855,226856,241349,226861,226862,226863,226864,226865,242561,242562,242563,242564,226880,226867,226869,226871,226873,226875,226877,226908,230589,226905,226906,226907,226921,226910,226912,226914,226916,226918,226920,228217,228218,228219,228252,228256,228253,228254,228255,228257,228261,228258,228259,228260,228262,228263,228264,228295,228299,228296,228297,228298,228300,228304,228301,228302,228303,231712,231710,231711,231715,231713,231714,231718,231716,231717,240924,240894,240895,240896,240897,240898,240918,240899,240929,240930,240900,241320,240901,240902,240903,240904,240905,241321,240906,240907,240908,240909,240910,240911,240912,240913,241322,240914,241323,240915,240916,240931,240917,241324,240919,240920,240921,240922,240923,242529,242530,242531,242532)"
        }
      }
    },
    "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
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
44525 226327 variant_image 56758 0 V 0 D 0 0
44526 226328 variant_image 56759 0 V 0 D 0 0
44527 226329 variant_image 56760 0 V 0 D 0 0
44528 226330 variant_image 56761 0 V 0 D 0 0
44622 226435 variant_image 56855 0 V 0 D 0 0
44623 226436 variant_image 56856 0 V 0 D 0 0
44624 226437 variant_image 56857 0 V 0 D 0 0
44625 226438 variant_image 56858 0 V 0 D 0 0
44626 226440 variant_image 56859 0 V 0 D 0 0
44627 226441 variant_image 56860 0 V 0 D 0 0
44628 226442 variant_image 56861 0 V 0 D 0 0
44629 226443 variant_image 56862 0 V 0 D 0 0
44630 226445 variant_image 56863 0 V 0 D 0 0
44631 226446 variant_image 56864 0 V 0 D 0 0
44632 226447 variant_image 56865 0 V 0 D 0 0
44633 226448 variant_image 56866 0 V 0 D 0 0
44634 226450 variant_image 56867 0 V 0 D 0 0
44635 226451 variant_image 56868 0 V 0 D 0 0
44636 226452 variant_image 56869 0 V 0 D 0 0
44637 226453 variant_image 56870 0 V 0 D 0 0
44638 226455 variant_image 56871 0 V 0 D 0 0
44640 226457 variant_image 56873 0 V 0 D 0 0
44645 226462 variant_image 56878 0 V 0 D 0 0
44648 226465 variant_image 56881 0 V 0 D 0 0
44649 226466 variant_image 56882 0 V 0 D 0 0
44653 226470 variant_image 56886 0 V 0 D 0 0
44655 226472 variant_image 56888 0 V 0 D 0 0
44657 226474 variant_image 56890 0 V 0 D 0 0
44660 226477 variant_image 56893 0 V 0 D 0 0
44661 226478 variant_image 56894 0 V 0 D 0 0
44664 226481 variant_image 56897 0 V 0 D 0 0
44666 226483 variant_image 56899 0 V 0 D 0 0
44720 226546 variant_image 56953 0 V 0 D 0 0
44721 226547 variant_image 56954 0 V 0 D 0 0
44722 226548 variant_image 56955 0 V 0 D 0 0
44723 226549 variant_image 56956 0 V 0 D 0 0
44724 226550 variant_image 56957 0 V 0 D 0 0
44725 226551 variant_image 56958 0 V 0 D 0 0
44726 226552 variant_image 56959 0 V 0 D 0 0
44727 226553 variant_image 56960 0 V 0 D 0 0
44728 226554 variant_image 56961 0 V 0 D 0 0
44729 226555 variant_image 56962 0 V 0 D 0 0
44730 226556 variant_image 56963 0 V 0 D 0 0
44731 226557 variant_image 56964 0 V 0 D 0 0
44732 226558 variant_image 56965 0 V 0 D 0 0
44733 226559 variant_image 56966 0 V 0 D 0 0
44734 226560 variant_image 56967 0 V 0 D 0 0
44735 226561 variant_image 56968 0 V 0 D 0 0
44736 226562 variant_image 56969 0 V 0 D 0 0
44737 226563 variant_image 56970 0 V 0 D 0 0
44738 226564 variant_image 56971 0 V 0 D 0 0
44739 226565 variant_image 56972 0 V 0 D 0 0
44740 226566 variant_image 56973 0 V 0 D 0 0
44741 226567 variant_image 56974 0 V 0 D 0 0
44742 226568 variant_image 56975 0 V 0 D 0 0
44743 226569 variant_image 56976 0 V 0 D 0 0
44744 226570 variant_image 56977 0 V 0 D 0 0
44745 226571 variant_image 56978 0 V 0 D 0 0
45002 226831 variant_image 57235 0 V 0 D 0 0
45003 226832 variant_image 57236 0 V 0 D 0 0
45004 226833 variant_image 57237 0 V 0 D 0 0
45005 226834 variant_image 57238 0 V 0 D 0 0
45006 226835 variant_image 57239 0 V 0 D 0 0
45007 226836 variant_image 57240 0 V 0 D 0 0
45008 226837 variant_image 57241 0 V 0 D 0 0
45009 226838 variant_image 57242 0 V 0 D 0 0
45010 226839 variant_image 57243 0 V 0 D 0 0
45011 226840 variant_image 57244 0 V 0 D 0 0
45012 226841 variant_image 57245 0 V 0 D 0 0
45013 226842 variant_image 57246 0 V 0 D 0 0
45014 226843 variant_image 57247 0 V 0 D 0 0
45015 226844 variant_image 57248 0 V 0 D 0 0
45016 226845 variant_image 57249 0 V 0 D 0 0
45017 226846 variant_image 57250 0 V 0 D 0 0
45018 226847 variant_image 57251 0 V 0 D 0 0
45019 226848 variant_image 57252 0 V 0 D 0 0
45020 226849 variant_image 57253 0 V 0 D 0 0
45021 226850 variant_image 57254 0 V 0 D 0 0
45022 226851 variant_image 57255 0 V 0 D 0 0
45023 226852 variant_image 57256 0 V 0 D 0 0
45024 226853 variant_image 57257 0 V 0 D 0 0
45025 226854 variant_image 57258 0 V 0 D 0 0
45026 226855 variant_image 57259 0 V 0 D 0 0
45027 226856 variant_image 57260 0 V 0 D 0 0
45032 226861 variant_image 57265 0 V 0 D 0 0
45033 226862 variant_image 57266 0 V 0 D 0 0
45034 226863 variant_image 57267 0 V 0 D 0 0
45035 226864 variant_image 57268 0 V 0 D 0 0
45036 226865 variant_image 57269 0 V 0 D 0 0
45045 226905 variant_image 57278 0 V 0 D 0 0
45046 226906 variant_image 57279 0 V 0 D 0 0
45047 226907 variant_image 57280 0 V 0 D 0 0
48300 228218 variant_image 60533 0 V 0 D 0 0
48301 228219 variant_image 60534 0 V 0 D 0 0
48302 228256 variant_image 60535 0 V 0 D 0 0
48303 228253 variant_image 60536 0 V 0 D 0 0
48304 228254 variant_image 60537 0 V 0 D 0 0
48305 228255 variant_image 60538 0 V 0 D 0 0
48306 228261 variant_image 60539 0 V 0 D 0 0
48307 228258 variant_image 60540 0 V 0 D 0 0
48308 228259 variant_image 60541 0 V 0 D 0 0
48309 228260 variant_image 60542 0 V 0 D 0 0
48310 228263 variant_image 60543 0 V 0 D 0 0
48311 228264 variant_image 60544 0 V 0 D 0 0
48312 228299 variant_image 60545 0 V 0 D 0 0
48313 228296 variant_image 60546 0 V 0 D 0 0
48314 228297 variant_image 60547 0 V 0 D 0 0
48315 228298 variant_image 60548 0 V 0 D 0 0
48316 228304 variant_image 60549 0 V 0 D 0 0
48317 228301 variant_image 60550 0 V 0 D 0 0
48318 228302 variant_image 60551 0 V 0 D 0 0
48319 228303 variant_image 60552 0 V 0 D 0 0
48334 229781 variant_image 60567 0 V 0 D 0 0
48335 229782 variant_image 60568 0 V 0 D 0 0
48336 229783 variant_image 60569 0 V 0 D 0 0
48337 229784 variant_image 60570 0 V 0 D 0 0
48338 229785 variant_image 60571 0 V 0 D 0 0
49321 230589 variant_image 61554 0 V 0 D 0 0
52025 231710 variant_image 64258 0 V 0 D 0 0
52026 231711 variant_image 64259 0 V 0 D 0 0
52027 231713 variant_image 64260 0 V 0 D 0 0
52028 231714 variant_image 64261 0 V 0 D 0 0
52029 231716 variant_image 64262 0 V 0 D 0 0
52030 231717 variant_image 64263 0 V 0 D 0 0
59845 237098 variant_image 72078 0 V 0 D 0 0
59846 237099 variant_image 72079 0 V 0 D 0 0
59911 237164 variant_image 72144 0 V 0 D 0 0
59912 237165 variant_image 72145 0 V 0 D 0 0
68285 239948 variant_image 80518 0 V 0 D 0 0
70393 240894 variant_image 82626 0 V 0 D 0 0
70394 240895 variant_image 82627 0 V 0 D 0 0
70395 240896 variant_image 82628 0 V 0 D 0 0
70396 240897 variant_image 82629 0 V 0 D 0 0
70397 240898 variant_image 82630 0 V 0 D 0 0
70398 240899 variant_image 82631 0 V 0 D 0 0
70399 240900 variant_image 82632 0 V 0 D 0 0
70400 240901 variant_image 82633 0 V 0 D 0 0
70401 240902 variant_image 82634 0 V 0 D 0 0
70402 240903 variant_image 82635 0 V 0 D 0 0
70403 240904 variant_image 82636 0 V 0 D 0 0
70404 240905 variant_image 82637 0 V 0 D 0 0
70405 240906 variant_image 82638 0 V 0 D 0 0
70406 240907 variant_image 82639 0 V 0 D 0 0
70407 240908 variant_image 82640 0 V 0 D 0 0
70408 240909 variant_image 82641 0 V 0 D 0 0
70409 240910 variant_image 82642 0 V 0 D 0 0
70410 240911 variant_image 82643 0 V 0 D 0 0
70411 240912 variant_image 82644 0 V 0 D 0 0
70412 240913 variant_image 82645 0 V 0 D 0 0
70413 240914 variant_image 82646 0 V 0 D 0 0
70414 240915 variant_image 82647 0 V 0 D 0 0
70415 240916 variant_image 82648 0 V 0 D 0 0
70416 240917 variant_image 82649 0 V 0 D 0 0
70417 240918 variant_image 82650 0 V 0 D 0 0
70418 240919 variant_image 82651 0 V 0 D 0 0
70419 240920 variant_image 82652 0 V 0 D 0 0
70420 240921 variant_image 82653 0 V 0 D 0 0
70421 240922 variant_image 82654 0 V 0 D 0 0
70422 240923 variant_image 82655 0 V 0 D 0 0
70427 240929 variant_image 82660 0 V 0 D 0 0
70428 240930 variant_image 82661 0 V 0 D 0 0
70429 240931 variant_image 82662 0 V 0 D 0 0
70840 241305 variant_image 83073 0 V 0 D 0 0
70841 241306 variant_image 83074 0 V 0 D 0 0
70842 241307 variant_image 83075 0 V 0 D 0 0
70843 241308 variant_image 83076 0 V 0 D 0 0
70844 241309 variant_image 83077 0 V 0 D 0 0
70855 241320 variant_image 83088 0 V 0 D 0 0
70856 241321 variant_image 83089 0 V 0 D 0 0
70857 241322 variant_image 83090 0 V 0 D 0 0
70858 241323 variant_image 83091 0 V 0 D 0 0
70859 241324 variant_image 83092 0 V 0 D 0 0
70880 241345 variant_image 83113 0 V 0 D 0 0
70881 241346 variant_image 83114 0 V 0 D 0 0
70882 241347 variant_image 83115 0 V 0 D 0 0
70883 241348 variant_image 83116 0 V 0 D 0 0
70884 241349 variant_image 83117 0 V 0 D 0 0
72112 242517 variant_image 84345 0 V 0 D 0 0
72113 242518 variant_image 84346 0 V 0 D 0 0
72114 242519 variant_image 84347 0 V 0 D 0 0
72115 242520 variant_image 84348 0 V 0 D 0 0
72124 242529 variant_image 84357 0 V 0 D 0 0
72125 242530 variant_image 84358 0 V 0 D 0 0
72126 242531 variant_image 84359 0 V 0 D 0 0
72127 242532 variant_image 84360 0 V 0 D 0 0
72156 242561 variant_image 84389 0 V 0 D 0 0
72157 242562 variant_image 84390 0 V 0 D 0 0
72158 242563 variant_image 84391 0 V 0 D 0 0
72159 242564 variant_image 84392 0 V 0 D 0 0
74008 244281 variant_image 86241 0 V 0 D 0 0
74009 244282 variant_image 86242 0 V 0 D 0 0