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 (
    220135, 
    244918, 
    244919, 
    244920, 
    244921, 
    244922, 
    244923, 
    244924, 
    244925, 
    217391, 
    217392, 
    217393, 
    217394, 
    217395, 
    217396, 
    236870, 
    236871, 
    217397, 
    245301, 
    241058, 
    219829, 
    217398, 
    217399, 
    217400, 
    217401, 
    241059, 
    217402, 
    217403, 
    217404, 
    217405, 
    217406, 
    217407, 
    217408, 
    217409, 
    241060, 
    217410, 
    241061, 
    217411, 
    217412, 
    245302, 
    245303, 
    225914, 
    217413, 
    217414, 
    245304, 
    241062, 
    217415, 
    217416, 
    217417, 
    217418, 
    217419, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    227107, 
    227103, 
    227104, 
    227106, 
    229803, 
    229800, 
    229801, 
    229802, 
    233773, 
    233774, 
    233775, 
    233777, 
    233744, 
    233778, 
    233745, 
    233746, 
    233747, 
    233748, 
    236924, 
    236925, 
    233749, 
    241386, 
    233750, 
    233751, 
    233752, 
    233753, 
    233754, 
    241387, 
    233755, 
    233756, 
    233757, 
    233758, 
    233759, 
    233760, 
    233761, 
    233762, 
    241388, 
    233763, 
    233764, 
    241389, 
    233765, 
    233766, 
    233767, 
    233768, 
    241390, 
    242203, 
    242204, 
    242205, 
    242206, 
    239949, 
    239950, 
    239951, 
    240507, 
    240506, 
    240508, 
    240509, 
    240536, 
    240514, 
    240515, 
    240516, 
    240517, 
    240518, 
    240526, 
    240535, 
    240519, 
    240520, 
    240521, 
    240522, 
    240523, 
    240524, 
    240525, 
    240527, 
    240528, 
    240529, 
    240530, 
    240559, 
    240537, 
    240538, 
    240539, 
    240540, 
    240541, 
    240549, 
    240558, 
    240542, 
    240543, 
    240544, 
    240545, 
    240546, 
    240547, 
    240548, 
    240550, 
    240551, 
    240552, 
    240553, 
    240582, 
    240560, 
    240561, 
    240562, 
    240563, 
    240564, 
    240572, 
    240581, 
    240565, 
    240566, 
    240567, 
    240568, 
    240569, 
    240570, 
    240571, 
    240573, 
    240574, 
    240575, 
    240576
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00251

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": 180,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220135,244918,244919,244920,244921,244922,244923,244924,244925,217391,217392,217393,217394,217395,217396,236870,236871,217397,245301,241058,219829,217398,217399,217400,217401,241059,217402,217403,217404,217405,217406,217407,217408,217409,241060,217410,241061,217411,217412,245302,245303,225914,217413,217414,245304,241062,217415,217416,217417,217418,217419,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,227107,227103,227104,227106,229803,229800,229801,229802,233773,233774,233775,233777,233744,233778,233745,233746,233747,233748,236924,236925,233749,241386,233750,233751,233752,233753,233754,241387,233755,233756,233757,233758,233759,233760,233761,233762,241388,233763,233764,241389,233765,233766,233767,233768,241390,242203,242204,242205,242206,239949,239950,239951,240507,240506,240508,240509,240536,240514,240515,240516,240517,240518,240526,240535,240519,240520,240521,240522,240523,240524,240525,240527,240528,240529,240530,240559,240537,240538,240539,240540,240541,240549,240558,240542,240543,240544,240545,240546,240547,240548,240550,240551,240552,240553,240582,240560,240561,240562,240563,240564,240572,240581,240565,240566,240567,240568,240569,240570,240571,240573,240574,240575,240576)"
        }
      }
    },
    "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
35604 217391 variant_image 47837 0 V 0 D 0 0
35605 217392 variant_image 47838 0 V 0 D 0 0
35606 217393 variant_image 47839 0 V 0 D 0 0
35607 217394 variant_image 47840 0 V 0 D 0 0
35608 217395 variant_image 47841 0 V 0 D 0 0
35609 217396 variant_image 47842 0 V 0 D 0 0
35610 217397 variant_image 47843 0 V 0 D 0 0
35611 217398 variant_image 47844 0 V 0 D 0 0
35612 217399 variant_image 47845 0 V 0 D 0 0
35613 217401 variant_image 47846 0 V 0 D 0 0
35614 217402 variant_image 47847 0 V 0 D 0 0
35615 217403 variant_image 47848 0 V 0 D 0 0
35616 217404 variant_image 47849 0 V 0 D 0 0
35617 217405 variant_image 47850 0 V 0 D 0 0
35618 217406 variant_image 47851 0 V 0 D 0 0
35619 217407 variant_image 47852 0 V 0 D 0 0
35620 217408 variant_image 47853 0 V 0 D 0 0
35621 217409 variant_image 47854 0 V 0 D 0 0
35622 217410 variant_image 47855 0 V 0 D 0 0
35623 217411 variant_image 47856 0 V 0 D 0 0
35624 217412 variant_image 47857 0 V 0 D 0 0
35625 217413 variant_image 47858 0 V 0 D 0 0
35626 217414 variant_image 47859 0 V 0 D 0 0
35627 217415 variant_image 47860 0 V 0 D 0 0
35628 217416 variant_image 47861 0 V 0 D 0 0
35629 217417 variant_image 47862 0 V 0 D 0 0
35630 217418 variant_image 47863 0 V 0 D 0 0
35631 217419 variant_image 47864 0 V 0 D 0 0
37901 219238 variant_image 50134 0 V 0 D 0 0
37904 219241 variant_image 50137 0 V 0 D 0 0
37912 219249 variant_image 50145 0 V 0 D 0 0
37913 219250 variant_image 50146 0 V 0 D 0 0
37915 219252 variant_image 50148 0 V 0 D 0 0
37916 219253 variant_image 50149 0 V 0 D 0 0
37917 219254 variant_image 50150 0 V 0 D 0 0
37918 219255 variant_image 50151 0 V 0 D 0 0
37919 219256 variant_image 50152 0 V 0 D 0 0
37920 219257 variant_image 50153 0 V 0 D 0 0
37921 219258 variant_image 50154 0 V 0 D 0 0
37922 219259 variant_image 50155 0 V 0 D 0 0
38476 217400 variant_image 50709 0 V 0 D 0 0
38489 219829 variant_image 50722 0 V 0 D 0 0
38738 219237 variant_image 50971 0 V 0 D 0 0
44124 225914 variant_image 56357 0 V 0 D 0 0
45293 227103 variant_image 57526 0 V 0 D 0 0
45294 227104 variant_image 57527 0 V 0 D 0 0
45296 227106 variant_image 57529 0 V 0 D 0 0
48392 229800 variant_image 60625 0 V 0 D 0 0
48393 229801 variant_image 60626 0 V 0 D 0 0
48394 229802 variant_image 60627 0 V 0 D 0 0
49791 219239 variant_image 62024 0 V 0 D 0 0
54370 233744 variant_image 66603 0 V 0 D 0 0
54371 233745 variant_image 66604 0 V 0 D 0 0
54372 233746 variant_image 66605 0 V 0 D 0 0
54373 233747 variant_image 66606 0 V 0 D 0 0
54374 233748 variant_image 66607 0 V 0 D 0 0
54375 233749 variant_image 66608 0 V 0 D 0 0
54376 233750 variant_image 66609 0 V 0 D 0 0
54377 233751 variant_image 66610 0 V 0 D 0 0
54378 233752 variant_image 66611 0 V 0 D 0 0
54379 233753 variant_image 66612 0 V 0 D 0 0
54380 233754 variant_image 66613 0 V 0 D 0 0
54381 233755 variant_image 66614 0 V 0 D 0 0
54382 233756 variant_image 66615 0 V 0 D 0 0
54383 233757 variant_image 66616 0 V 0 D 0 0
54384 233758 variant_image 66617 0 V 0 D 0 0
54385 233759 variant_image 66618 0 V 0 D 0 0
54386 233760 variant_image 66619 0 V 0 D 0 0
54387 233761 variant_image 66620 0 V 0 D 0 0
54388 233762 variant_image 66621 0 V 0 D 0 0
54389 233763 variant_image 66622 0 V 0 D 0 0
54390 233764 variant_image 66623 0 V 0 D 0 0
54391 233765 variant_image 66624 0 V 0 D 0 0
54392 233766 variant_image 66625 0 V 0 D 0 0
54393 233767 variant_image 66626 0 V 0 D 0 0
54394 233768 variant_image 66627 0 V 0 D 0 0
54399 233774 variant_image 66632 0 V 0 D 0 0
54400 233775 variant_image 66633 0 V 0 D 0 0
54402 233777 variant_image 66635 0 V 0 D 0 0
54403 233778 variant_image 66636 0 V 0 D 0 0
59612 236870 variant_image 71845 0 V 0 D 0 0
59613 236871 variant_image 71846 0 V 0 D 0 0
59666 236924 variant_image 71899 0 V 0 D 0 0
59667 236925 variant_image 71900 0 V 0 D 0 0
69896 240514 variant_image 82129 0 V 0 D 0 0
69897 240515 variant_image 82130 0 V 0 D 0 0
69898 240516 variant_image 82131 0 V 0 D 0 0
69899 240517 variant_image 82132 0 V 0 D 0 0
69900 240518 variant_image 82133 0 V 0 D 0 0
69901 240519 variant_image 82134 0 V 0 D 0 0
69902 240520 variant_image 82135 0 V 0 D 0 0
69903 240521 variant_image 82136 0 V 0 D 0 0
69904 240522 variant_image 82137 0 V 0 D 0 0
69905 240523 variant_image 82138 0 V 0 D 0 0
69906 240524 variant_image 82139 0 V 0 D 0 0
69907 240525 variant_image 82140 0 V 0 D 0 0
69908 240526 variant_image 82141 0 V 0 D 0 0
69909 240527 variant_image 82142 0 V 0 D 0 0
69910 240528 variant_image 82143 0 V 0 D 0 0
69911 240529 variant_image 82144 0 V 0 D 0 0
69912 240530 variant_image 82145 0 V 0 D 0 0
69917 240535 variant_image 82150 0 V 0 D 0 0
69918 240537 variant_image 82151 0 V 0 D 0 0
69919 240538 variant_image 82152 0 V 0 D 0 0
69920 240539 variant_image 82153 0 V 0 D 0 0
69921 240540 variant_image 82154 0 V 0 D 0 0
69922 240541 variant_image 82155 0 V 0 D 0 0
69923 240542 variant_image 82156 0 V 0 D 0 0
69924 240543 variant_image 82157 0 V 0 D 0 0
69925 240544 variant_image 82158 0 V 0 D 0 0
69926 240545 variant_image 82159 0 V 0 D 0 0
69927 240546 variant_image 82160 0 V 0 D 0 0
69928 240547 variant_image 82161 0 V 0 D 0 0
69929 240548 variant_image 82162 0 V 0 D 0 0
69930 240549 variant_image 82163 0 V 0 D 0 0
69931 240550 variant_image 82164 0 V 0 D 0 0
69932 240551 variant_image 82165 0 V 0 D 0 0
69933 240552 variant_image 82166 0 V 0 D 0 0
69934 240553 variant_image 82167 0 V 0 D 0 0
69939 240558 variant_image 82172 0 V 0 D 0 0
69940 240560 variant_image 82173 0 V 0 D 0 0
69941 240561 variant_image 82174 0 V 0 D 0 0
69942 240562 variant_image 82175 0 V 0 D 0 0
69943 240563 variant_image 82176 0 V 0 D 0 0
69944 240564 variant_image 82177 0 V 0 D 0 0
69945 240565 variant_image 82178 0 V 0 D 0 0
69946 240566 variant_image 82179 0 V 0 D 0 0
69947 240567 variant_image 82180 0 V 0 D 0 0
69948 240568 variant_image 82181 0 V 0 D 0 0
69949 240569 variant_image 82182 0 V 0 D 0 0
69950 240570 variant_image 82183 0 V 0 D 0 0
69951 240571 variant_image 82184 0 V 0 D 0 0
69952 240572 variant_image 82185 0 V 0 D 0 0
69953 240573 variant_image 82186 0 V 0 D 0 0
69954 240574 variant_image 82187 0 V 0 D 0 0
69955 240575 variant_image 82188 0 V 0 D 0 0
69956 240576 variant_image 82189 0 V 0 D 0 0
69961 240581 variant_image 82194 0 V 0 D 0 0
70593 241058 variant_image 82826 0 V 0 D 0 0
70594 241059 variant_image 82827 0 V 0 D 0 0
70595 241060 variant_image 82828 0 V 0 D 0 0
70596 241061 variant_image 82829 0 V 0 D 0 0
70597 241062 variant_image 82830 0 V 0 D 0 0
70921 241386 variant_image 83154 0 V 0 D 0 0
70922 241387 variant_image 83155 0 V 0 D 0 0
70923 241388 variant_image 83156 0 V 0 D 0 0
70924 241389 variant_image 83157 0 V 0 D 0 0
70925 241390 variant_image 83158 0 V 0 D 0 0
71766 242203 variant_image 83999 0 V 0 D 0 0
71767 242204 variant_image 84000 0 V 0 D 0 0
71768 242205 variant_image 84001 0 V 0 D 0 0
71769 242206 variant_image 84002 0 V 0 D 0 0
72617 242973 variant_image 84850 0 V 0 D 0 0
74710 244918 variant_image 86943 0 V 0 D 0 0
74711 244919 variant_image 86944 0 V 0 D 0 0
74712 244920 variant_image 86945 0 V 0 D 0 0
74713 244921 variant_image 86946 0 V 0 D 0 0
74714 244922 variant_image 86947 0 V 0 D 0 0
74715 244923 variant_image 86948 0 V 0 D 0 0
74716 244924 variant_image 86949 0 V 0 D 0 0
74717 244925 variant_image 86950 0 V 0 D 0 0
75103 245301 variant_image 87336 0 V 0 D 0 0
75104 245302 variant_image 87337 0 V 0 D 0 0
75105 245303 variant_image 87338 0 V 0 D 0 0
75106 245304 variant_image 87339 0 V 0 D 0 0