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 (
    218476, 
    215713, 
    215714, 
    215715, 
    215716, 
    215738, 
    215731, 
    237036, 
    237037, 
    215717, 
    242135, 
    241141, 
    215718, 
    215719, 
    215720, 
    215721, 
    215722, 
    241142, 
    215723, 
    215724, 
    215725, 
    215726, 
    215727, 
    215728, 
    215729, 
    215730, 
    241143, 
    215732, 
    241144, 
    215733, 
    215734, 
    215735, 
    242136, 
    242137, 
    215736, 
    215737, 
    242138, 
    241145, 
    222877, 
    222874, 
    222875, 
    222876, 
    222888, 
    222878, 
    222879, 
    222880, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    227161, 
    227152, 
    227153, 
    227154, 
    227194, 
    227195, 
    227196, 
    227197, 
    227353, 
    227354, 
    227355, 
    227356, 
    227357, 
    227358, 
    227359, 
    227360, 
    227361, 
    227392, 
    227362, 
    227363, 
    227364, 
    227365, 
    227366, 
    227367, 
    237060, 
    237061, 
    227368, 
    242744, 
    242009, 
    227369, 
    227370, 
    227371, 
    227372, 
    227373, 
    242010, 
    227374, 
    227375, 
    227376, 
    227377, 
    227378, 
    227379, 
    227380, 
    227381, 
    242011, 
    227382, 
    242012, 
    227383, 
    227384, 
    242745, 
    242746, 
    227385, 
    227386, 
    227387, 
    242747, 
    242013, 
    227857, 
    227858, 
    227859, 
    227860, 
    227861, 
    227863, 
    227864, 
    227865, 
    227866, 
    228383, 
    228348, 
    228349, 
    228350, 
    228351, 
    228352, 
    228353, 
    237238, 
    237239, 
    228354, 
    242029, 
    228355, 
    228356, 
    228357, 
    228358, 
    228359, 
    242030, 
    228360, 
    228361, 
    228362, 
    228363, 
    228364, 
    228365, 
    228366, 
    228367, 
    242031, 
    228368, 
    242032, 
    228369, 
    228370, 
    228371, 
    228372, 
    228373, 
    242033, 
    242789, 
    242790, 
    242791, 
    242792, 
    228378, 
    228379, 
    228380, 
    228381, 
    228382, 
    230828, 
    230827, 
    237449, 
    237418, 
    237419, 
    237420, 
    237421, 
    237422, 
    237423, 
    237424, 
    237425, 
    237450, 
    237451, 
    237426, 
    242139, 
    241226, 
    237427, 
    237428, 
    237429, 
    237430, 
    237431, 
    241227, 
    237432, 
    237433, 
    237434, 
    237435, 
    237436, 
    237437, 
    237438, 
    237439, 
    241228, 
    237440, 
    241229, 
    237441, 
    237442, 
    242140, 
    242141, 
    237443, 
    237444, 
    242142, 
    241230
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00273

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": 199,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (218476,215713,215714,215715,215716,215738,215731,237036,237037,215717,242135,241141,215718,215719,215720,215721,215722,241142,215723,215724,215725,215726,215727,215728,215729,215730,241143,215732,241144,215733,215734,215735,242136,242137,215736,215737,242138,241145,222877,222874,222875,222876,222888,222878,222879,222880,223755,223756,223757,223758,223759,227161,227152,227153,227154,227194,227195,227196,227197,227353,227354,227355,227356,227357,227358,227359,227360,227361,227392,227362,227363,227364,227365,227366,227367,237060,237061,227368,242744,242009,227369,227370,227371,227372,227373,242010,227374,227375,227376,227377,227378,227379,227380,227381,242011,227382,242012,227383,227384,242745,242746,227385,227386,227387,242747,242013,227857,227858,227859,227860,227861,227863,227864,227865,227866,228383,228348,228349,228350,228351,228352,228353,237238,237239,228354,242029,228355,228356,228357,228358,228359,242030,228360,228361,228362,228363,228364,228365,228366,228367,242031,228368,242032,228369,228370,228371,228372,228373,242033,242789,242790,242791,242792,228378,228379,228380,228381,228382,230828,230827,237449,237418,237419,237420,237421,237422,237423,237424,237425,237450,237451,237426,242139,241226,237427,237428,237429,237430,237431,241227,237432,237433,237434,237435,237436,237437,237438,237439,241228,237440,241229,237441,237442,242140,242141,237443,237444,242142,241230)"
        }
      }
    },
    "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
33888 215713 variant_image 46121 0 V 0 D 0 0
33889 215714 variant_image 46122 0 V 0 D 0 0
33890 215715 variant_image 46123 0 V 0 D 0 0
33891 215716 variant_image 46124 0 V 0 D 0 0
33892 215738 variant_image 46125 0 V 0 D 0 0
33893 215731 variant_image 46126 0 V 0 D 0 0
33894 215717 variant_image 46127 0 V 0 D 0 0
33895 215718 variant_image 46128 0 V 0 D 0 0
33896 215719 variant_image 46129 0 V 0 D 0 0
33897 215720 variant_image 46130 0 V 0 D 0 0
33898 215721 variant_image 46131 0 V 0 D 0 0
33899 215722 variant_image 46132 0 V 0 D 0 0
33900 215723 variant_image 46133 0 V 0 D 0 0
33901 215724 variant_image 46134 0 V 0 D 0 0
33902 215725 variant_image 46135 0 V 0 D 0 0
33903 215726 variant_image 46136 0 V 0 D 0 0
33904 215727 variant_image 46137 0 V 0 D 0 0
33905 215728 variant_image 46138 0 V 0 D 0 0
33906 215729 variant_image 46139 0 V 0 D 0 0
33907 215730 variant_image 46140 0 V 0 D 0 0
33908 215732 variant_image 46141 0 V 0 D 0 0
33909 215733 variant_image 46142 0 V 0 D 0 0
33910 215734 variant_image 46143 0 V 0 D 0 0
33911 215735 variant_image 46144 0 V 0 D 0 0
33912 215736 variant_image 46145 0 V 0 D 0 0
33913 215737 variant_image 46146 0 V 0 D 0 0
41176 222874 variant_image 53409 0 V 0 D 0 0
41177 222875 variant_image 53410 0 V 0 D 0 0
41178 222876 variant_image 53411 0 V 0 D 0 0
41179 222878 variant_image 53412 0 V 0 D 0 0
41180 222879 variant_image 53413 0 V 0 D 0 0
41181 222880 variant_image 53414 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
45339 227152 variant_image 57572 0 V 0 D 0 0
45340 227153 variant_image 57573 0 V 0 D 0 0
45341 227154 variant_image 57574 0 V 0 D 0 0
45365 227195 variant_image 57598 0 V 0 D 0 0
45366 227196 variant_image 57599 0 V 0 D 0 0
45367 227197 variant_image 57600 0 V 0 D 0 0
45512 227354 variant_image 57745 0 V 0 D 0 0
45513 227355 variant_image 57746 0 V 0 D 0 0
45514 227357 variant_image 57747 0 V 0 D 0 0
45515 227358 variant_image 57748 0 V 0 D 0 0
45516 227360 variant_image 57749 0 V 0 D 0 0
45517 227361 variant_image 57750 0 V 0 D 0 0
45518 227362 variant_image 57751 0 V 0 D 0 0
45519 227363 variant_image 57752 0 V 0 D 0 0
45520 227364 variant_image 57753 0 V 0 D 0 0
45521 227365 variant_image 57754 0 V 0 D 0 0
45522 227366 variant_image 57755 0 V 0 D 0 0
45523 227367 variant_image 57756 0 V 0 D 0 0
45524 227368 variant_image 57757 0 V 0 D 0 0
45525 227369 variant_image 57758 0 V 0 D 0 0
45526 227370 variant_image 57759 0 V 0 D 0 0
45527 227371 variant_image 57760 0 V 0 D 0 0
45528 227372 variant_image 57761 0 V 0 D 0 0
45529 227373 variant_image 57762 0 V 0 D 0 0
45530 227374 variant_image 57763 0 V 0 D 0 0
45531 227375 variant_image 57764 0 V 0 D 0 0
45532 227376 variant_image 57765 0 V 0 D 0 0
45533 227377 variant_image 57766 0 V 0 D 0 0
45534 227378 variant_image 57767 0 V 0 D 0 0
45535 227379 variant_image 57768 0 V 0 D 0 0
45536 227380 variant_image 57769 0 V 0 D 0 0
45537 227381 variant_image 57770 0 V 0 D 0 0
45538 227382 variant_image 57771 0 V 0 D 0 0
45539 227383 variant_image 57772 0 V 0 D 0 0
45540 227384 variant_image 57773 0 V 0 D 0 0
45541 227385 variant_image 57774 0 V 0 D 0 0
45542 227386 variant_image 57775 0 V 0 D 0 0
45543 227387 variant_image 57776 0 V 0 D 0 0
45971 227858 variant_image 58204 0 V 0 D 0 0
45972 227859 variant_image 58205 0 V 0 D 0 0
45973 227860 variant_image 58206 0 V 0 D 0 0
45974 227861 variant_image 58207 0 V 0 D 0 0
45976 227864 variant_image 58209 0 V 0 D 0 0
45977 227865 variant_image 58210 0 V 0 D 0 0
45978 227866 variant_image 58211 0 V 0 D 0 0
46474 228348 variant_image 58707 0 V 0 D 0 0
46475 228349 variant_image 58708 0 V 0 D 0 0
46476 228350 variant_image 58709 0 V 0 D 0 0
46477 228351 variant_image 58710 0 V 0 D 0 0
46478 228352 variant_image 58711 0 V 0 D 0 0
46479 228353 variant_image 58712 0 V 0 D 0 0
46480 228354 variant_image 58713 0 V 0 D 0 0
46481 228355 variant_image 58714 0 V 0 D 0 0
46482 228356 variant_image 58715 0 V 0 D 0 0
46483 228357 variant_image 58716 0 V 0 D 0 0
46484 228358 variant_image 58717 0 V 0 D 0 0
46485 228359 variant_image 58718 0 V 0 D 0 0
46486 228360 variant_image 58719 0 V 0 D 0 0
46487 228361 variant_image 58720 0 V 0 D 0 0
46488 228362 variant_image 58721 0 V 0 D 0 0
46489 228363 variant_image 58722 0 V 0 D 0 0
46490 228364 variant_image 58723 0 V 0 D 0 0
46491 228365 variant_image 58724 0 V 0 D 0 0
46492 228366 variant_image 58725 0 V 0 D 0 0
46493 228367 variant_image 58726 0 V 0 D 0 0
46494 228368 variant_image 58727 0 V 0 D 0 0
46495 228369 variant_image 58728 0 V 0 D 0 0
46496 228370 variant_image 58729 0 V 0 D 0 0
46497 228371 variant_image 58730 0 V 0 D 0 0
46498 228372 variant_image 58731 0 V 0 D 0 0
46499 228373 variant_image 58732 0 V 0 D 0 0
46504 228378 variant_image 58737 0 V 0 D 0 0
46505 228379 variant_image 58738 0 V 0 D 0 0
46506 228380 variant_image 58739 0 V 0 D 0 0
46507 228381 variant_image 58740 0 V 0 D 0 0
46508 228382 variant_image 58741 0 V 0 D 0 0
59782 237036 variant_image 72015 0 V 0 D 0 0
59783 237037 variant_image 72016 0 V 0 D 0 0
59807 237060 variant_image 72040 0 V 0 D 0 0
59808 237061 variant_image 72041 0 V 0 D 0 0
59989 237238 variant_image 72222 0 V 0 D 0 0
59990 237239 variant_image 72223 0 V 0 D 0 0
60449 237419 variant_image 72682 0 V 0 D 0 0
60450 237420 variant_image 72683 0 V 0 D 0 0
60451 237421 variant_image 72684 0 V 0 D 0 0
60452 237422 variant_image 72685 0 V 0 D 0 0
60453 237423 variant_image 72686 0 V 0 D 0 0
60454 237424 variant_image 72687 0 V 0 D 0 0
60455 237425 variant_image 72688 0 V 0 D 0 0
60456 237426 variant_image 72689 0 V 0 D 0 0
60457 237427 variant_image 72690 0 V 0 D 0 0
60458 237428 variant_image 72691 0 V 0 D 0 0
60459 237429 variant_image 72692 0 V 0 D 0 0
60460 237430 variant_image 72693 0 V 0 D 0 0
60461 237431 variant_image 72694 0 V 0 D 0 0
60462 237432 variant_image 72695 0 V 0 D 0 0
60463 237433 variant_image 72696 0 V 0 D 0 0
60464 237434 variant_image 72697 0 V 0 D 0 0
60465 237435 variant_image 72698 0 V 0 D 0 0
60466 237436 variant_image 72699 0 V 0 D 0 0
60467 237437 variant_image 72700 0 V 0 D 0 0
60468 237438 variant_image 72701 0 V 0 D 0 0
60469 237439 variant_image 72702 0 V 0 D 0 0
60470 237440 variant_image 72703 0 V 0 D 0 0
60471 237441 variant_image 72704 0 V 0 D 0 0
60472 237442 variant_image 72705 0 V 0 D 0 0
60473 237443 variant_image 72706 0 V 0 D 0 0
60474 237444 variant_image 72707 0 V 0 D 0 0
60479 237450 variant_image 72712 0 V 0 D 0 0
60480 237451 variant_image 72713 0 V 0 D 0 0
70676 241141 variant_image 82909 0 V 0 D 0 0
70677 241142 variant_image 82910 0 V 0 D 0 0
70678 241143 variant_image 82911 0 V 0 D 0 0
70679 241144 variant_image 82912 0 V 0 D 0 0
70680 241145 variant_image 82913 0 V 0 D 0 0
70761 241226 variant_image 82994 0 V 0 D 0 0
70762 241227 variant_image 82995 0 V 0 D 0 0
70763 241228 variant_image 82996 0 V 0 D 0 0
70764 241229 variant_image 82997 0 V 0 D 0 0
70765 241230 variant_image 82998 0 V 0 D 0 0
71562 242009 variant_image 83795 0 V 0 D 0 0
71563 242010 variant_image 83796 0 V 0 D 0 0
71564 242011 variant_image 83797 0 V 0 D 0 0
71565 242012 variant_image 83798 0 V 0 D 0 0
71566 242013 variant_image 83799 0 V 0 D 0 0
71582 242029 variant_image 83815 0 V 0 D 0 0
71583 242030 variant_image 83816 0 V 0 D 0 0
71584 242031 variant_image 83817 0 V 0 D 0 0
71585 242032 variant_image 83818 0 V 0 D 0 0
71586 242033 variant_image 83819 0 V 0 D 0 0
71698 242135 variant_image 83931 0 V 0 D 0 0
71699 242136 variant_image 83932 0 V 0 D 0 0
71700 242137 variant_image 83933 0 V 0 D 0 0
71701 242138 variant_image 83934 0 V 0 D 0 0
71702 242139 variant_image 83935 0 V 0 D 0 0
71703 242140 variant_image 83936 0 V 0 D 0 0
71704 242141 variant_image 83937 0 V 0 D 0 0
71705 242142 variant_image 83938 0 V 0 D 0 0
72353 242744 variant_image 84586 0 V 0 D 0 0
72354 242745 variant_image 84587 0 V 0 D 0 0
72355 242746 variant_image 84588 0 V 0 D 0 0
72356 242747 variant_image 84589 0 V 0 D 0 0
72398 242789 variant_image 84631 0 V 0 D 0 0
72399 242790 variant_image 84632 0 V 0 D 0 0
72400 242791 variant_image 84633 0 V 0 D 0 0
72401 242792 variant_image 84634 0 V 0 D 0 0