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, 
    220543, 
    245134, 
    245135, 
    245136, 
    245137, 
    245138, 
    245139, 
    245140, 
    245141, 
    220555, 
    220556, 
    220557, 
    220558, 
    220559, 
    220560, 
    236876, 
    236877, 
    220561, 
    245439, 
    242034, 
    220562, 
    220563, 
    220564, 
    220565, 
    220566, 
    242035, 
    220567, 
    220568, 
    220569, 
    220570, 
    220571, 
    220572, 
    220573, 
    220574, 
    242036, 
    220575, 
    242037, 
    220576, 
    220577, 
    245440, 
    245441, 
    220578, 
    220579, 
    245442, 
    242038, 
    220622, 
    220623, 
    245475, 
    245476, 
    245477, 
    245478, 
    245479, 
    245480, 
    245481, 
    245482, 
    220637, 
    220638, 
    220639, 
    220640, 
    220641, 
    220642, 
    220643, 
    220644, 
    220645, 
    236936, 
    236937, 
    220646, 
    245483, 
    242120, 
    220647, 
    220648, 
    220649, 
    220650, 
    220651, 
    242121, 
    220652, 
    220653, 
    220654, 
    220655, 
    220656, 
    220657, 
    220658, 
    220659, 
    242122, 
    220660, 
    242123, 
    220661, 
    220662, 
    245484, 
    245485, 
    220663, 
    220664, 
    245486, 
    242124, 
    220677, 
    220678, 
    220679, 
    220680, 
    220681, 
    220682, 
    220683, 
    236880, 
    236881, 
    220684, 
    245447, 
    242039, 
    220685, 
    220686, 
    220687, 
    220688, 
    220689, 
    242040, 
    220690, 
    220691, 
    220692, 
    220693, 
    220694, 
    220695, 
    220696, 
    220697, 
    242041, 
    220698, 
    242042, 
    220699, 
    220700, 
    245448, 
    245449, 
    220701, 
    220702, 
    220703, 
    245450, 
    242043, 
    220704, 
    245431, 
    245432, 
    245433, 
    245434, 
    245435, 
    245436, 
    245437, 
    245438, 
    220760, 
    220761, 
    220762, 
    220763, 
    220764, 
    220765, 
    220766, 
    220767, 
    220768, 
    220776, 
    220777, 
    220778, 
    220779, 
    220787, 
    220788, 
    220789, 
    220790, 
    220798, 
    220799, 
    220800, 
    220801, 
    220820, 
    220821, 
    220822, 
    220823, 
    220824, 
    220999, 
    221000, 
    221001
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00331

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": 173,
          "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,220543,245134,245135,245136,245137,245138,245139,245140,245141,220555,220556,220557,220558,220559,220560,236876,236877,220561,245439,242034,220562,220563,220564,220565,220566,242035,220567,220568,220569,220570,220571,220572,220573,220574,242036,220575,242037,220576,220577,245440,245441,220578,220579,245442,242038,220622,220623,245475,245476,245477,245478,245479,245480,245481,245482,220637,220638,220639,220640,220641,220642,220643,220644,220645,236936,236937,220646,245483,242120,220647,220648,220649,220650,220651,242121,220652,220653,220654,220655,220656,220657,220658,220659,242122,220660,242123,220661,220662,245484,245485,220663,220664,245486,242124,220677,220678,220679,220680,220681,220682,220683,236880,236881,220684,245447,242039,220685,220686,220687,220688,220689,242040,220690,220691,220692,220693,220694,220695,220696,220697,242041,220698,242042,220699,220700,245448,245449,220701,220702,220703,245450,242043,220704,245431,245432,245433,245434,245435,245436,245437,245438,220760,220761,220762,220763,220764,220765,220766,220767,220768,220776,220777,220778,220779,220787,220788,220789,220790,220798,220799,220800,220801,220820,220821,220822,220823,220824,220999,221000,221001)"
        }
      }
    },
    "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
39046 220555 variant_image 51279 0 V 0 D 0 0
39047 220556 variant_image 51280 0 V 0 D 0 0
39048 220557 variant_image 51281 0 V 0 D 0 0
39049 220558 variant_image 51282 0 V 0 D 0 0
39050 220559 variant_image 51283 0 V 0 D 0 0
39051 220560 variant_image 51284 0 V 0 D 0 0
39052 220561 variant_image 51285 0 V 0 D 0 0
39053 220562 variant_image 51286 0 V 0 D 0 0
39054 220563 variant_image 51287 0 V 0 D 0 0
39055 220564 variant_image 51288 0 V 0 D 0 0
39056 220565 variant_image 51289 0 V 0 D 0 0
39057 220566 variant_image 51290 0 V 0 D 0 0
39058 220567 variant_image 51291 0 V 0 D 0 0
39059 220568 variant_image 51292 0 V 0 D 0 0
39060 220569 variant_image 51293 0 V 0 D 0 0
39061 220570 variant_image 51294 0 V 0 D 0 0
39062 220571 variant_image 51295 0 V 0 D 0 0
39063 220572 variant_image 51296 0 V 0 D 0 0
39064 220573 variant_image 51297 0 V 0 D 0 0
39065 220574 variant_image 51298 0 V 0 D 0 0
39066 220575 variant_image 51299 0 V 0 D 0 0
39067 220576 variant_image 51300 0 V 0 D 0 0
39068 220577 variant_image 51301 0 V 0 D 0 0
39069 220578 variant_image 51302 0 V 0 D 0 0
39070 220579 variant_image 51303 0 V 0 D 0 0
39125 220639 variant_image 51358 0 V 0 D 0 0
39126 220640 variant_image 51359 0 V 0 D 0 0
39127 220641 variant_image 51360 0 V 0 D 0 0
39128 220642 variant_image 51361 0 V 0 D 0 0
39129 220643 variant_image 51362 0 V 0 D 0 0
39130 220644 variant_image 51363 0 V 0 D 0 0
39131 220645 variant_image 51364 0 V 0 D 0 0
39132 220646 variant_image 51365 0 V 0 D 0 0
39133 220647 variant_image 51366 0 V 0 D 0 0
39134 220648 variant_image 51367 0 V 0 D 0 0
39135 220649 variant_image 51368 0 V 0 D 0 0
39136 220650 variant_image 51369 0 V 0 D 0 0
39137 220651 variant_image 51370 0 V 0 D 0 0
39138 220652 variant_image 51371 0 V 0 D 0 0
39139 220653 variant_image 51372 0 V 0 D 0 0
39140 220654 variant_image 51373 0 V 0 D 0 0
39141 220655 variant_image 51374 0 V 0 D 0 0
39142 220656 variant_image 51375 0 V 0 D 0 0
39143 220657 variant_image 51376 0 V 0 D 0 0
39144 220658 variant_image 51377 0 V 0 D 0 0
39145 220659 variant_image 51378 0 V 0 D 0 0
39146 220660 variant_image 51379 0 V 0 D 0 0
39147 220661 variant_image 51380 0 V 0 D 0 0
39148 220662 variant_image 51381 0 V 0 D 0 0
39149 220663 variant_image 51382 0 V 0 D 0 0
39150 220664 variant_image 51383 0 V 0 D 0 0
39159 220678 variant_image 51392 0 V 0 D 0 0
39160 220679 variant_image 51393 0 V 0 D 0 0
39161 220680 variant_image 51394 0 V 0 D 0 0
39162 220681 variant_image 51395 0 V 0 D 0 0
39163 220682 variant_image 51396 0 V 0 D 0 0
39164 220683 variant_image 51397 0 V 0 D 0 0
39165 220684 variant_image 51398 0 V 0 D 0 0
39166 220685 variant_image 51399 0 V 0 D 0 0
39167 220686 variant_image 51400 0 V 0 D 0 0
39168 220687 variant_image 51401 0 V 0 D 0 0
39169 220688 variant_image 51402 0 V 0 D 0 0
39170 220689 variant_image 51403 0 V 0 D 0 0
39171 220690 variant_image 51404 0 V 0 D 0 0
39172 220691 variant_image 51405 0 V 0 D 0 0
39173 220692 variant_image 51406 0 V 0 D 0 0
39174 220693 variant_image 51407 0 V 0 D 0 0
39175 220694 variant_image 51408 0 V 0 D 0 0
39176 220695 variant_image 51409 0 V 0 D 0 0
39177 220696 variant_image 51410 0 V 0 D 0 0
39178 220697 variant_image 51411 0 V 0 D 0 0
39179 220698 variant_image 51412 0 V 0 D 0 0
39180 220699 variant_image 51413 0 V 0 D 0 0
39181 220700 variant_image 51414 0 V 0 D 0 0
39182 220701 variant_image 51415 0 V 0 D 0 0
39183 220702 variant_image 51416 0 V 0 D 0 0
39184 220703 variant_image 51417 0 V 0 D 0 0
39257 220761 variant_image 51490 0 V 0 D 0 0
39258 220762 variant_image 51491 0 V 0 D 0 0
39259 220763 variant_image 51492 0 V 0 D 0 0
39260 220764 variant_image 51493 0 V 0 D 0 0
39261 220766 variant_image 51494 0 V 0 D 0 0
39262 220767 variant_image 51495 0 V 0 D 0 0
39263 220768 variant_image 51496 0 V 0 D 0 0
39271 220777 variant_image 51504 0 V 0 D 0 0
39272 220778 variant_image 51505 0 V 0 D 0 0
39280 220788 variant_image 51513 0 V 0 D 0 0
39281 220789 variant_image 51514 0 V 0 D 0 0
39282 220790 variant_image 51515 0 V 0 D 0 0
39290 220779 variant_image 51523 0 V 0 D 0 0
39291 220799 variant_image 51524 0 V 0 D 0 0
39292 220800 variant_image 51525 0 V 0 D 0 0
39293 220801 variant_image 51526 0 V 0 D 0 0
39310 220821 variant_image 51543 0 V 0 D 0 0
39311 220822 variant_image 51544 0 V 0 D 0 0
39312 220823 variant_image 51545 0 V 0 D 0 0
39313 220824 variant_image 51546 0 V 0 D 0 0
59618 236876 variant_image 71851 0 V 0 D 0 0
59619 236877 variant_image 71852 0 V 0 D 0 0
59622 236880 variant_image 71855 0 V 0 D 0 0
59623 236881 variant_image 71856 0 V 0 D 0 0
59679 236936 variant_image 71912 0 V 0 D 0 0
59680 236937 variant_image 71913 0 V 0 D 0 0
71587 242034 variant_image 83820 0 V 0 D 0 0
71588 242035 variant_image 83821 0 V 0 D 0 0
71589 242036 variant_image 83822 0 V 0 D 0 0
71590 242037 variant_image 83823 0 V 0 D 0 0
71591 242038 variant_image 83824 0 V 0 D 0 0
71592 242039 variant_image 83825 0 V 0 D 0 0
71593 242040 variant_image 83826 0 V 0 D 0 0
71594 242041 variant_image 83827 0 V 0 D 0 0
71595 242042 variant_image 83828 0 V 0 D 0 0
71596 242043 variant_image 83829 0 V 0 D 0 0
71678 242120 variant_image 83911 0 V 0 D 0 0
71679 242121 variant_image 83912 0 V 0 D 0 0
71680 242122 variant_image 83913 0 V 0 D 0 0
71681 242123 variant_image 83914 0 V 0 D 0 0
71682 242124 variant_image 83915 0 V 0 D 0 0
74937 245134 variant_image 87170 0 V 0 D 0 0
74938 245135 variant_image 87171 0 V 0 D 0 0
74939 245136 variant_image 87172 0 V 0 D 0 0
74940 245137 variant_image 87173 0 V 0 D 0 0
74941 245138 variant_image 87174 0 V 0 D 0 0
74942 245139 variant_image 87175 0 V 0 D 0 0
74943 245140 variant_image 87176 0 V 0 D 0 0
74944 245141 variant_image 87177 0 V 0 D 0 0
75418 245431 variant_image 87651 0 V 0 D 0 0
75419 245432 variant_image 87652 0 V 0 D 0 0
75420 245433 variant_image 87653 0 V 0 D 0 0
75421 245434 variant_image 87654 0 V 0 D 0 0
75422 245435 variant_image 87655 0 V 0 D 0 0
75423 245436 variant_image 87656 0 V 0 D 0 0
75424 245437 variant_image 87657 0 V 0 D 0 0
75425 245438 variant_image 87658 0 V 0 D 0 0
75426 245439 variant_image 87659 0 V 0 D 0 0
75427 245440 variant_image 87660 0 V 0 D 0 0
75428 245441 variant_image 87661 0 V 0 D 0 0
75429 245442 variant_image 87662 0 V 0 D 0 0
75465 245447 variant_image 87698 0 V 0 D 0 0
75466 245448 variant_image 87699 0 V 0 D 0 0
75467 245449 variant_image 87700 0 V 0 D 0 0
75468 245450 variant_image 87701 0 V 0 D 0 0
75493 245475 variant_image 87726 0 V 0 D 0 0
75494 245476 variant_image 87727 0 V 0 D 0 0
75495 245477 variant_image 87728 0 V 0 D 0 0
75496 245478 variant_image 87729 0 V 0 D 0 0
75497 245479 variant_image 87730 0 V 0 D 0 0
75498 245480 variant_image 87731 0 V 0 D 0 0
75499 245481 variant_image 87732 0 V 0 D 0 0
75500 245482 variant_image 87733 0 V 0 D 0 0
75501 245483 variant_image 87734 0 V 0 D 0 0
75502 245484 variant_image 87735 0 V 0 D 0 0
75503 245485 variant_image 87736 0 V 0 D 0 0
75504 245486 variant_image 87737 0 V 0 D 0 0