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 (
    221133, 
    221134, 
    221135, 
    221136, 
    221137, 
    221138, 
    221139, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    229895, 
    245511, 
    245512, 
    245513, 
    245514, 
    245515, 
    245516, 
    245517, 
    245518, 
    229865, 
    229866, 
    229867, 
    229868, 
    229890, 
    229883, 
    237072, 
    237073, 
    229869, 
    241473, 
    229870, 
    229871, 
    229872, 
    229873, 
    229874, 
    241474, 
    229875, 
    229876, 
    229877, 
    229878, 
    229879, 
    229880, 
    229881, 
    229882, 
    241475, 
    229884, 
    241476, 
    229885, 
    229886, 
    229887, 
    229888, 
    229889, 
    241477, 
    242163, 
    242164, 
    242165, 
    242166, 
    229899, 
    229896, 
    229897, 
    229898, 
    229930, 
    229900, 
    229901, 
    229902, 
    229903, 
    229904, 
    229905, 
    237068, 
    237069, 
    229906, 
    242159, 
    241478, 
    229907, 
    229908, 
    229909, 
    229910, 
    229911, 
    241479, 
    229912, 
    229913, 
    229914, 
    229915, 
    229916, 
    229917, 
    229918, 
    229919, 
    241480, 
    229920, 
    241481, 
    229921, 
    229922, 
    242160, 
    242161, 
    229923, 
    229924, 
    229925, 
    242162, 
    241482, 
    229983, 
    229975, 
    229976, 
    229977, 
    229994, 
    229986, 
    229987, 
    229988, 
    230005, 
    229997, 
    229998, 
    229999, 
    230049, 
    230041, 
    230042, 
    230043, 
    230060, 
    230052, 
    230053, 
    230054, 
    230071, 
    230063, 
    230064, 
    230065, 
    230082, 
    230074, 
    230075, 
    230076, 
    230093, 
    230085, 
    230086, 
    230087, 
    230104, 
    230096, 
    230097, 
    230098, 
    230115, 
    230107, 
    230108, 
    230109, 
    230126, 
    230118, 
    230119, 
    230120, 
    230137, 
    230129, 
    230130, 
    230131, 
    230207, 
    230208, 
    230209, 
    230210, 
    230300, 
    230270, 
    230271, 
    230272, 
    230273, 
    230295, 
    230288, 
    237064, 
    237065, 
    230274, 
    242167, 
    241575, 
    230275, 
    230276, 
    230277, 
    230278, 
    230279, 
    241576, 
    230280, 
    230281, 
    230282, 
    230283, 
    230284, 
    230285, 
    230286, 
    230287, 
    241577, 
    230289, 
    241578, 
    230290, 
    230291, 
    242168, 
    242169, 
    230292, 
    230293, 
    230294, 
    242170, 
    241579, 
    230335, 
    245591, 
    245592, 
    245593, 
    245594, 
    245595, 
    245596, 
    245597, 
    245598, 
    230305, 
    230306, 
    230307, 
    230308, 
    230330, 
    230323, 
    237082, 
    237083, 
    230309, 
    242155, 
    241585, 
    230310, 
    230311, 
    230312, 
    230313, 
    230314, 
    241586, 
    230315, 
    230316, 
    230317, 
    230318, 
    230319, 
    230320, 
    230321, 
    230322, 
    241587, 
    230324, 
    241588, 
    230325, 
    230326, 
    242156, 
    242157, 
    230327, 
    230328, 
    230329, 
    242158, 
    241589, 
    230513, 
    230510, 
    230511, 
    230512, 
    230828, 
    230827
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00268

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": 242,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (221133,221134,221135,221136,221137,221138,221139,223755,223756,223757,223758,223759,229895,245511,245512,245513,245514,245515,245516,245517,245518,229865,229866,229867,229868,229890,229883,237072,237073,229869,241473,229870,229871,229872,229873,229874,241474,229875,229876,229877,229878,229879,229880,229881,229882,241475,229884,241476,229885,229886,229887,229888,229889,241477,242163,242164,242165,242166,229899,229896,229897,229898,229930,229900,229901,229902,229903,229904,229905,237068,237069,229906,242159,241478,229907,229908,229909,229910,229911,241479,229912,229913,229914,229915,229916,229917,229918,229919,241480,229920,241481,229921,229922,242160,242161,229923,229924,229925,242162,241482,229983,229975,229976,229977,229994,229986,229987,229988,230005,229997,229998,229999,230049,230041,230042,230043,230060,230052,230053,230054,230071,230063,230064,230065,230082,230074,230075,230076,230093,230085,230086,230087,230104,230096,230097,230098,230115,230107,230108,230109,230126,230118,230119,230120,230137,230129,230130,230131,230207,230208,230209,230210,230300,230270,230271,230272,230273,230295,230288,237064,237065,230274,242167,241575,230275,230276,230277,230278,230279,241576,230280,230281,230282,230283,230284,230285,230286,230287,241577,230289,241578,230290,230291,242168,242169,230292,230293,230294,242170,241579,230335,245591,245592,245593,245594,245595,245596,245597,245598,230305,230306,230307,230308,230330,230323,237082,237083,230309,242155,241585,230310,230311,230312,230313,230314,241586,230315,230316,230317,230318,230319,230320,230321,230322,241587,230324,241588,230325,230326,242156,242157,230327,230328,230329,242158,241589,230513,230510,230511,230512,230828,230827)"
        }
      }
    },
    "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
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
48464 229865 variant_image 60697 0 V 0 D 0 0
48465 229866 variant_image 60698 0 V 0 D 0 0
48466 229867 variant_image 60699 0 V 0 D 0 0
48467 229868 variant_image 60700 0 V 0 D 0 0
48468 229869 variant_image 60701 0 V 0 D 0 0
48469 229870 variant_image 60702 0 V 0 D 0 0
48470 229871 variant_image 60703 0 V 0 D 0 0
48471 229872 variant_image 60704 0 V 0 D 0 0
48472 229873 variant_image 60705 0 V 0 D 0 0
48473 229874 variant_image 60706 0 V 0 D 0 0
48474 229875 variant_image 60707 0 V 0 D 0 0
48475 229876 variant_image 60708 0 V 0 D 0 0
48476 229877 variant_image 60709 0 V 0 D 0 0
48477 229878 variant_image 60710 0 V 0 D 0 0
48478 229879 variant_image 60711 0 V 0 D 0 0
48479 229880 variant_image 60712 0 V 0 D 0 0
48480 229881 variant_image 60713 0 V 0 D 0 0
48481 229882 variant_image 60714 0 V 0 D 0 0
48482 229883 variant_image 60715 0 V 0 D 0 0
48483 229884 variant_image 60716 0 V 0 D 0 0
48484 229885 variant_image 60717 0 V 0 D 0 0
48485 229886 variant_image 60718 0 V 0 D 0 0
48486 229887 variant_image 60719 0 V 0 D 0 0
48487 229888 variant_image 60720 0 V 0 D 0 0
48488 229889 variant_image 60721 0 V 0 D 0 0
48489 229890 variant_image 60722 0 V 0 D 0 0
48494 229896 variant_image 60727 0 V 0 D 0 0
48495 229897 variant_image 60728 0 V 0 D 0 0
48496 229898 variant_image 60729 0 V 0 D 0 0
48567 229975 variant_image 60800 0 V 0 D 0 0
48568 229976 variant_image 60801 0 V 0 D 0 0
48569 229977 variant_image 60802 0 V 0 D 0 0
48577 229986 variant_image 60810 0 V 0 D 0 0
48578 229987 variant_image 60811 0 V 0 D 0 0
48579 229988 variant_image 60812 0 V 0 D 0 0
48587 229997 variant_image 60820 0 V 0 D 0 0
48588 229998 variant_image 60821 0 V 0 D 0 0
48589 229999 variant_image 60822 0 V 0 D 0 0
48627 230041 variant_image 60860 0 V 0 D 0 0
48628 230042 variant_image 60861 0 V 0 D 0 0
48629 230043 variant_image 60862 0 V 0 D 0 0
48637 230052 variant_image 60870 0 V 0 D 0 0
48638 230053 variant_image 60871 0 V 0 D 0 0
48639 230054 variant_image 60872 0 V 0 D 0 0
48647 230063 variant_image 60880 0 V 0 D 0 0
48648 230064 variant_image 60881 0 V 0 D 0 0
48649 230065 variant_image 60882 0 V 0 D 0 0
48657 230074 variant_image 60890 0 V 0 D 0 0
48658 230075 variant_image 60891 0 V 0 D 0 0
48659 230076 variant_image 60892 0 V 0 D 0 0
48667 230085 variant_image 60900 0 V 0 D 0 0
48668 230086 variant_image 60901 0 V 0 D 0 0
48669 230087 variant_image 60902 0 V 0 D 0 0
48677 230096 variant_image 60910 0 V 0 D 0 0
48678 230097 variant_image 60911 0 V 0 D 0 0
48679 230098 variant_image 60912 0 V 0 D 0 0
48687 230107 variant_image 60920 0 V 0 D 0 0
48688 230108 variant_image 60921 0 V 0 D 0 0
48689 230109 variant_image 60922 0 V 0 D 0 0
48697 230118 variant_image 60930 0 V 0 D 0 0
48698 230119 variant_image 60931 0 V 0 D 0 0
48699 230120 variant_image 60932 0 V 0 D 0 0
48707 230129 variant_image 60940 0 V 0 D 0 0
48708 230130 variant_image 60941 0 V 0 D 0 0
48709 230131 variant_image 60942 0 V 0 D 0 0
48783 230208 variant_image 61016 0 V 0 D 0 0
48784 230209 variant_image 61017 0 V 0 D 0 0
48785 230210 variant_image 61018 0 V 0 D 0 0
48837 230270 variant_image 61070 0 V 0 D 0 0
48838 230271 variant_image 61071 0 V 0 D 0 0
48839 230272 variant_image 61072 0 V 0 D 0 0
48840 230273 variant_image 61073 0 V 0 D 0 0
48841 230274 variant_image 61074 0 V 0 D 0 0
48842 230275 variant_image 61075 0 V 0 D 0 0
48843 230276 variant_image 61076 0 V 0 D 0 0
48844 230277 variant_image 61077 0 V 0 D 0 0
48845 230278 variant_image 61078 0 V 0 D 0 0
48846 230279 variant_image 61079 0 V 0 D 0 0
48847 230280 variant_image 61080 0 V 0 D 0 0
48848 230281 variant_image 61081 0 V 0 D 0 0
48849 230282 variant_image 61082 0 V 0 D 0 0
48850 230283 variant_image 61083 0 V 0 D 0 0
48851 230284 variant_image 61084 0 V 0 D 0 0
48852 230285 variant_image 61085 0 V 0 D 0 0
48853 230286 variant_image 61086 0 V 0 D 0 0
48854 230287 variant_image 61087 0 V 0 D 0 0
48855 230288 variant_image 61088 0 V 0 D 0 0
48856 230289 variant_image 61089 0 V 0 D 0 0
48857 230290 variant_image 61090 0 V 0 D 0 0
48858 230291 variant_image 61091 0 V 0 D 0 0
48859 230292 variant_image 61092 0 V 0 D 0 0
48860 230293 variant_image 61093 0 V 0 D 0 0
48861 230294 variant_image 61094 0 V 0 D 0 0
48862 230295 variant_image 61095 0 V 0 D 0 0
48887 230305 variant_image 61120 0 V 0 D 0 0
48888 230306 variant_image 61121 0 V 0 D 0 0
48889 230307 variant_image 61122 0 V 0 D 0 0
48890 230308 variant_image 61123 0 V 0 D 0 0
48891 230309 variant_image 61124 0 V 0 D 0 0
48892 230310 variant_image 61125 0 V 0 D 0 0
48893 230311 variant_image 61126 0 V 0 D 0 0
48894 230312 variant_image 61127 0 V 0 D 0 0
48895 230313 variant_image 61128 0 V 0 D 0 0
48896 230314 variant_image 61129 0 V 0 D 0 0
48897 230315 variant_image 61130 0 V 0 D 0 0
48898 230316 variant_image 61131 0 V 0 D 0 0
48899 230317 variant_image 61132 0 V 0 D 0 0
48900 230318 variant_image 61133 0 V 0 D 0 0
48901 230319 variant_image 61134 0 V 0 D 0 0
48902 230320 variant_image 61135 0 V 0 D 0 0
48903 230321 variant_image 61136 0 V 0 D 0 0
48904 230322 variant_image 61137 0 V 0 D 0 0
48905 230323 variant_image 61138 0 V 0 D 0 0
48906 230324 variant_image 61139 0 V 0 D 0 0
48907 230325 variant_image 61140 0 V 0 D 0 0
48908 230326 variant_image 61141 0 V 0 D 0 0
48909 230327 variant_image 61142 0 V 0 D 0 0
48910 230328 variant_image 61143 0 V 0 D 0 0
48911 230329 variant_image 61144 0 V 0 D 0 0
48912 230330 variant_image 61145 0 V 0 D 0 0
49241 230510 variant_image 61474 0 V 0 D 0 0
49242 230511 variant_image 61475 0 V 0 D 0 0
49243 230512 variant_image 61476 0 V 0 D 0 0
59811 237064 variant_image 72044 0 V 0 D 0 0
59812 237065 variant_image 72045 0 V 0 D 0 0
59819 237072 variant_image 72052 0 V 0 D 0 0
59820 237073 variant_image 72053 0 V 0 D 0 0
59829 237082 variant_image 72062 0 V 0 D 0 0
59830 237083 variant_image 72063 0 V 0 D 0 0
71008 241473 variant_image 83241 0 V 0 D 0 0
71009 241474 variant_image 83242 0 V 0 D 0 0
71010 241475 variant_image 83243 0 V 0 D 0 0
71011 241476 variant_image 83244 0 V 0 D 0 0
71012 241477 variant_image 83245 0 V 0 D 0 0
71129 241575 variant_image 83362 0 V 0 D 0 0
71130 241576 variant_image 83363 0 V 0 D 0 0
71131 241577 variant_image 83364 0 V 0 D 0 0
71132 241578 variant_image 83365 0 V 0 D 0 0
71133 241579 variant_image 83366 0 V 0 D 0 0
71139 241585 variant_image 83372 0 V 0 D 0 0
71140 241586 variant_image 83373 0 V 0 D 0 0
71141 241587 variant_image 83374 0 V 0 D 0 0
71142 241588 variant_image 83375 0 V 0 D 0 0
71143 241589 variant_image 83376 0 V 0 D 0 0
71718 242155 variant_image 83951 0 V 0 D 0 0
71719 242156 variant_image 83952 0 V 0 D 0 0
71720 242157 variant_image 83953 0 V 0 D 0 0
71721 242158 variant_image 83954 0 V 0 D 0 0
71726 242163 variant_image 83959 0 V 0 D 0 0
71727 242164 variant_image 83960 0 V 0 D 0 0
71728 242165 variant_image 83961 0 V 0 D 0 0
71729 242166 variant_image 83962 0 V 0 D 0 0
71730 242167 variant_image 83963 0 V 0 D 0 0
71731 242168 variant_image 83964 0 V 0 D 0 0
71732 242169 variant_image 83965 0 V 0 D 0 0
71733 242170 variant_image 83966 0 V 0 D 0 0
75529 245511 variant_image 87762 0 V 0 D 0 0
75530 245512 variant_image 87763 0 V 0 D 0 0
75531 245513 variant_image 87764 0 V 0 D 0 0
75532 245514 variant_image 87765 0 V 0 D 0 0
75533 245515 variant_image 87766 0 V 0 D 0 0
75534 245516 variant_image 87767 0 V 0 D 0 0
75535 245517 variant_image 87768 0 V 0 D 0 0
75536 245518 variant_image 87769 0 V 0 D 0 0
75718 245591 variant_image 87951 0 V 0 D 0 0
75719 245592 variant_image 87952 0 V 0 D 0 0
75720 245593 variant_image 87953 0 V 0 D 0 0
75721 245594 variant_image 87954 0 V 0 D 0 0
75722 245595 variant_image 87955 0 V 0 D 0 0
75723 245596 variant_image 87956 0 V 0 D 0 0
75724 245597 variant_image 87957 0 V 0 D 0 0
75725 245598 variant_image 87958 0 V 0 D 0 0