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 (
    220144, 
    215513, 
    215516, 
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    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, 
    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, 
    220814, 
    220815, 
    220816, 
    220817, 
    220818, 
    220819, 
    220996, 
    220997, 
    220998, 
    221016, 
    221017, 
    221018, 
    221019, 
    221020, 
    221021, 
    221022, 
    221023, 
    236900, 
    236901, 
    221024, 
    245463, 
    242055, 
    221025, 
    221026, 
    221027, 
    221028, 
    221029, 
    242056, 
    221030, 
    221031, 
    221032, 
    221033, 
    221034, 
    221035, 
    221036, 
    221037, 
    242057, 
    221038, 
    242058, 
    221039, 
    221040, 
    245464, 
    245465, 
    221041, 
    221042, 
    221043, 
    245466, 
    242059, 
    221044, 
    221045, 
    245467, 
    245468, 
    245469, 
    245470, 
    245471, 
    245472, 
    245473, 
    245474
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00243

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": 196,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220144,215513,215516,220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,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,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,220814,220815,220816,220817,220818,220819,220996,220997,220998,221016,221017,221018,221019,221020,221021,221022,221023,236900,236901,221024,245463,242055,221025,221026,221027,221028,221029,242056,221030,221031,221032,221033,221034,221035,221036,221037,242057,221038,242058,221039,221040,245464,245465,221041,221042,221043,245466,242059,221044,221045,245467,245468,245469,245470,245471,245472,245473,245474)"
        }
      }
    },
    "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
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
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
39305 220815 variant_image 51538 0 V 0 D 0 0
39306 220816 variant_image 51539 0 V 0 D 0 0
39307 220817 variant_image 51540 0 V 0 D 0 0
39308 220818 variant_image 51541 0 V 0 D 0 0
39309 220819 variant_image 51542 0 V 0 D 0 0
39487 221018 variant_image 51720 0 V 0 D 0 0
39488 221019 variant_image 51721 0 V 0 D 0 0
39489 221020 variant_image 51722 0 V 0 D 0 0
39490 221021 variant_image 51723 0 V 0 D 0 0
39491 221022 variant_image 51724 0 V 0 D 0 0
39492 221023 variant_image 51725 0 V 0 D 0 0
39493 221024 variant_image 51726 0 V 0 D 0 0
39494 221025 variant_image 51727 0 V 0 D 0 0
39495 221026 variant_image 51728 0 V 0 D 0 0
39496 221027 variant_image 51729 0 V 0 D 0 0
39497 221028 variant_image 51730 0 V 0 D 0 0
39498 221029 variant_image 51731 0 V 0 D 0 0
39499 221030 variant_image 51732 0 V 0 D 0 0
39500 221031 variant_image 51733 0 V 0 D 0 0
39501 221032 variant_image 51734 0 V 0 D 0 0
39502 221033 variant_image 51735 0 V 0 D 0 0
39503 221034 variant_image 51736 0 V 0 D 0 0
39504 221035 variant_image 51737 0 V 0 D 0 0
39505 221036 variant_image 51738 0 V 0 D 0 0
39506 221037 variant_image 51739 0 V 0 D 0 0
39507 221038 variant_image 51740 0 V 0 D 0 0
39508 221039 variant_image 51741 0 V 0 D 0 0
39509 221040 variant_image 51742 0 V 0 D 0 0
39510 221041 variant_image 51743 0 V 0 D 0 0
39511 221042 variant_image 51744 0 V 0 D 0 0
39512 221043 variant_image 51745 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
59642 236900 variant_image 71875 0 V 0 D 0 0
59643 236901 variant_image 71876 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
71613 242055 variant_image 83846 0 V 0 D 0 0
71614 242056 variant_image 83847 0 V 0 D 0 0
71615 242057 variant_image 83848 0 V 0 D 0 0
71616 242058 variant_image 83849 0 V 0 D 0 0
71617 242059 variant_image 83850 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
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
75481 245463 variant_image 87714 0 V 0 D 0 0
75482 245464 variant_image 87715 0 V 0 D 0 0
75483 245465 variant_image 87716 0 V 0 D 0 0
75484 245466 variant_image 87717 0 V 0 D 0 0
75485 245467 variant_image 87718 0 V 0 D 0 0
75486 245468 variant_image 87719 0 V 0 D 0 0
75487 245469 variant_image 87720 0 V 0 D 0 0
75488 245470 variant_image 87721 0 V 0 D 0 0
75489 245471 variant_image 87722 0 V 0 D 0 0
75490 245472 variant_image 87723 0 V 0 D 0 0
75491 245473 variant_image 87724 0 V 0 D 0 0
75492 245474 variant_image 87725 0 V 0 D 0 0