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 (
    219788, 
    219789, 
    219790, 
    220110, 
    219785, 
    219786, 
    219787, 
    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, 
    220151, 
    219791, 
    219792, 
    219793, 
    219794, 
    219795, 
    219796, 
    219797, 
    219798, 
    219799, 
    219800, 
    219801, 
    219802, 
    219803, 
    219804, 
    219805, 
    219806, 
    219807, 
    219808, 
    219809, 
    219810, 
    219811, 
    219812, 
    219813, 
    219814, 
    219815, 
    219816, 
    219817, 
    219818, 
    219819, 
    220195, 
    219317, 
    219318, 
    219319, 
    219320, 
    219321, 
    219322, 
    219323, 
    219324, 
    236872, 
    236873, 
    219325, 
    245317, 
    241080, 
    219326, 
    219327, 
    219328, 
    219329, 
    219330, 
    241081, 
    219331, 
    219332, 
    219333, 
    219334, 
    219335, 
    219336, 
    219337, 
    219338, 
    241082, 
    219339, 
    241083, 
    219340, 
    219341, 
    245318, 
    245319, 
    225916, 
    239537, 
    219342, 
    245320, 
    241084, 
    219343, 
    219344, 
    219345, 
    219346, 
    219347, 
    220196, 
    219348, 
    244942, 
    244943, 
    244944, 
    244945, 
    244946, 
    244947, 
    244948, 
    244949, 
    220197, 
    219362, 
    219363, 
    219364, 
    219365, 
    219366, 
    219367, 
    219368, 
    236874, 
    236875, 
    219369, 
    245321, 
    241085, 
    219370, 
    219371, 
    219372, 
    219373, 
    219374, 
    241086, 
    219375, 
    219376, 
    219377, 
    219378, 
    219379, 
    219380, 
    219381, 
    219382, 
    241087, 
    219383, 
    241088, 
    219384, 
    219385, 
    245322, 
    245323, 
    225915, 
    219386, 
    245324, 
    241089, 
    219387, 
    219388, 
    219389, 
    219390, 
    219391, 
    220304, 
    219543, 
    219544, 
    233535, 
    219545, 
    219546, 
    220305, 
    219547, 
    219548, 
    219549, 
    219550, 
    220306, 
    219551, 
    219552, 
    219553, 
    219554, 
    220318, 
    215376, 
    215377, 
    220319, 
    219225, 
    219227, 
    242997, 
    219229
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00237

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": 210,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (219788,219789,219790,220110,219785,219786,219787,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,220151,219791,219792,219793,219794,219795,219796,219797,219798,219799,219800,219801,219802,219803,219804,219805,219806,219807,219808,219809,219810,219811,219812,219813,219814,219815,219816,219817,219818,219819,220195,219317,219318,219319,219320,219321,219322,219323,219324,236872,236873,219325,245317,241080,219326,219327,219328,219329,219330,241081,219331,219332,219333,219334,219335,219336,219337,219338,241082,219339,241083,219340,219341,245318,245319,225916,239537,219342,245320,241084,219343,219344,219345,219346,219347,220196,219348,244942,244943,244944,244945,244946,244947,244948,244949,220197,219362,219363,219364,219365,219366,219367,219368,236874,236875,219369,245321,241085,219370,219371,219372,219373,219374,241086,219375,219376,219377,219378,219379,219380,219381,219382,241087,219383,241088,219384,219385,245322,245323,225915,219386,245324,241089,219387,219388,219389,219390,219391,220304,219543,219544,233535,219545,219546,220305,219547,219548,219549,219550,220306,219551,219552,219553,219554,220318,215376,215377,220319,219225,219227,242997,219229)"
        }
      }
    },
    "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
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
37889 219227 variant_image 50122 0 V 0 D 0 0
37891 219229 variant_image 50124 0 V 0 D 0 0
37978 219318 variant_image 50211 0 V 0 D 0 0
37979 219319 variant_image 50212 0 V 0 D 0 0
37980 219320 variant_image 50213 0 V 0 D 0 0
37981 219321 variant_image 50214 0 V 0 D 0 0
37982 219322 variant_image 50215 0 V 0 D 0 0
37983 219323 variant_image 50216 0 V 0 D 0 0
37984 219324 variant_image 50217 0 V 0 D 0 0
37985 219325 variant_image 50218 0 V 0 D 0 0
37986 219326 variant_image 50219 0 V 0 D 0 0
37987 219327 variant_image 50220 0 V 0 D 0 0
37988 219328 variant_image 50221 0 V 0 D 0 0
37989 219329 variant_image 50222 0 V 0 D 0 0
37990 219330 variant_image 50223 0 V 0 D 0 0
37991 219331 variant_image 50224 0 V 0 D 0 0
37992 219332 variant_image 50225 0 V 0 D 0 0
37993 219333 variant_image 50226 0 V 0 D 0 0
37994 219334 variant_image 50227 0 V 0 D 0 0
37995 219335 variant_image 50228 0 V 0 D 0 0
37996 219336 variant_image 50229 0 V 0 D 0 0
37997 219337 variant_image 50230 0 V 0 D 0 0
37998 219338 variant_image 50231 0 V 0 D 0 0
37999 219339 variant_image 50232 0 V 0 D 0 0
38000 219340 variant_image 50233 0 V 0 D 0 0
38001 219341 variant_image 50234 0 V 0 D 0 0
38002 219342 variant_image 50235 0 V 0 D 0 0
38003 219343 variant_image 50236 0 V 0 D 0 0
38004 219344 variant_image 50237 0 V 0 D 0 0
38005 219345 variant_image 50238 0 V 0 D 0 0
38006 219346 variant_image 50239 0 V 0 D 0 0
38007 219347 variant_image 50240 0 V 0 D 0 0
38008 219225 variant_image 50241 0 V 0 D 0 0
38022 219362 variant_image 50255 0 V 0 D 0 0
38023 219363 variant_image 50256 0 V 0 D 0 0
38024 219364 variant_image 50257 0 V 0 D 0 0
38025 219365 variant_image 50258 0 V 0 D 0 0
38026 219367 variant_image 50259 0 V 0 D 0 0
38027 219368 variant_image 50260 0 V 0 D 0 0
38028 219369 variant_image 50261 0 V 0 D 0 0
38029 219370 variant_image 50262 0 V 0 D 0 0
38030 219371 variant_image 50263 0 V 0 D 0 0
38031 219372 variant_image 50264 0 V 0 D 0 0
38032 219373 variant_image 50265 0 V 0 D 0 0
38033 219374 variant_image 50266 0 V 0 D 0 0
38034 219375 variant_image 50267 0 V 0 D 0 0
38035 219376 variant_image 50268 0 V 0 D 0 0
38036 219377 variant_image 50269 0 V 0 D 0 0
38037 219378 variant_image 50270 0 V 0 D 0 0
38038 219379 variant_image 50271 0 V 0 D 0 0
38039 219380 variant_image 50272 0 V 0 D 0 0
38040 219381 variant_image 50273 0 V 0 D 0 0
38041 219382 variant_image 50274 0 V 0 D 0 0
38042 219383 variant_image 50275 0 V 0 D 0 0
38043 219384 variant_image 50276 0 V 0 D 0 0
38044 219385 variant_image 50277 0 V 0 D 0 0
38045 219386 variant_image 50278 0 V 0 D 0 0
38046 219387 variant_image 50279 0 V 0 D 0 0
38047 219388 variant_image 50280 0 V 0 D 0 0
38048 219389 variant_image 50281 0 V 0 D 0 0
38049 219390 variant_image 50282 0 V 0 D 0 0
38050 219391 variant_image 50283 0 V 0 D 0 0
38206 219543 variant_image 50439 0 V 0 D 0 0
38207 219544 variant_image 50440 0 V 0 D 0 0
38208 219545 variant_image 50441 0 V 0 D 0 0
38209 219546 variant_image 50442 0 V 0 D 0 0
38210 219547 variant_image 50443 0 V 0 D 0 0
38211 219548 variant_image 50444 0 V 0 D 0 0
38212 219549 variant_image 50445 0 V 0 D 0 0
38213 219550 variant_image 50446 0 V 0 D 0 0
38214 219551 variant_image 50447 0 V 0 D 0 0
38215 219552 variant_image 50448 0 V 0 D 0 0
38216 219553 variant_image 50449 0 V 0 D 0 0
38217 219554 variant_image 50450 0 V 0 D 0 0
38434 219785 variant_image 50667 0 V 0 D 0 0
38435 219786 variant_image 50668 0 V 0 D 0 0
38436 219787 variant_image 50669 0 V 0 D 0 0
38437 219791 variant_image 50670 0 V 0 D 0 0
38438 219792 variant_image 50671 0 V 0 D 0 0
38439 219793 variant_image 50672 0 V 0 D 0 0
38440 219794 variant_image 50673 0 V 0 D 0 0
38441 219795 variant_image 50674 0 V 0 D 0 0
38442 219796 variant_image 50675 0 V 0 D 0 0
38443 219797 variant_image 50676 0 V 0 D 0 0
38444 219798 variant_image 50677 0 V 0 D 0 0
38445 219799 variant_image 50678 0 V 0 D 0 0
38446 219800 variant_image 50679 0 V 0 D 0 0
38447 219801 variant_image 50680 0 V 0 D 0 0
38448 219802 variant_image 50681 0 V 0 D 0 0
38449 219803 variant_image 50682 0 V 0 D 0 0
38450 219804 variant_image 50683 0 V 0 D 0 0
38451 219805 variant_image 50684 0 V 0 D 0 0
38452 219806 variant_image 50685 0 V 0 D 0 0
38453 219807 variant_image 50686 0 V 0 D 0 0
38454 219808 variant_image 50687 0 V 0 D 0 0
38455 219809 variant_image 50688 0 V 0 D 0 0
38456 219810 variant_image 50689 0 V 0 D 0 0
38457 219811 variant_image 50690 0 V 0 D 0 0
38458 219812 variant_image 50691 0 V 0 D 0 0
38459 219813 variant_image 50692 0 V 0 D 0 0
38460 219814 variant_image 50693 0 V 0 D 0 0
38461 219815 variant_image 50694 0 V 0 D 0 0
38462 219816 variant_image 50695 0 V 0 D 0 0
38463 219817 variant_image 50696 0 V 0 D 0 0
38464 219818 variant_image 50697 0 V 0 D 0 0
38465 219819 variant_image 50698 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
38557 219366 variant_image 50790 0 V 0 D 0 0
44124 225914 variant_image 56357 0 V 0 D 0 0
44125 225915 variant_image 56358 0 V 0 D 0 0
44126 225916 variant_image 56359 0 V 0 D 0 0
54093 233535 variant_image 66326 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
59614 236872 variant_image 71847 0 V 0 D 0 0
59615 236873 variant_image 71848 0 V 0 D 0 0
59616 236874 variant_image 71849 0 V 0 D 0 0
59617 236875 variant_image 71850 0 V 0 D 0 0
66569 239537 variant_image 78802 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
70615 241080 variant_image 82848 0 V 0 D 0 0
70616 241081 variant_image 82849 0 V 0 D 0 0
70617 241082 variant_image 82850 0 V 0 D 0 0
70618 241083 variant_image 82851 0 V 0 D 0 0
70619 241084 variant_image 82852 0 V 0 D 0 0
70620 241085 variant_image 82853 0 V 0 D 0 0
70621 241086 variant_image 82854 0 V 0 D 0 0
70622 241087 variant_image 82855 0 V 0 D 0 0
70623 241088 variant_image 82856 0 V 0 D 0 0
70624 241089 variant_image 82857 0 V 0 D 0 0
72641 242997 variant_image 84874 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
74734 244942 variant_image 86967 0 V 0 D 0 0
74735 244943 variant_image 86968 0 V 0 D 0 0
74736 244944 variant_image 86969 0 V 0 D 0 0
74737 244945 variant_image 86970 0 V 0 D 0 0
74738 244946 variant_image 86971 0 V 0 D 0 0
74739 244947 variant_image 86972 0 V 0 D 0 0
74740 244948 variant_image 86973 0 V 0 D 0 0
74741 244949 variant_image 86974 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
75121 245317 variant_image 87354 0 V 0 D 0 0
75122 245318 variant_image 87355 0 V 0 D 0 0
75123 245319 variant_image 87356 0 V 0 D 0 0
75124 245320 variant_image 87357 0 V 0 D 0 0
75125 245321 variant_image 87358 0 V 0 D 0 0
75126 245322 variant_image 87359 0 V 0 D 0 0
75127 245323 variant_image 87360 0 V 0 D 0 0
75128 245324 variant_image 87361 0 V 0 D 0 0