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 (
    223749, 
    223750, 
    223751, 
    223752, 
    223753, 
    223754, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    230625, 
    230623, 
    230624, 
    232268, 
    232269, 
    232270, 
    232343, 
    232344, 
    232345, 
    232387, 
    244590, 
    244591, 
    244592, 
    244593, 
    244594, 
    244595, 
    244596, 
    244597, 
    232357, 
    232358, 
    232359, 
    232360, 
    232361, 
    232362, 
    237026, 
    237027, 
    232363, 
    245142, 
    241146, 
    232364, 
    232365, 
    232366, 
    232367, 
    232368, 
    241147, 
    232369, 
    232370, 
    232371, 
    232372, 
    232373, 
    232374, 
    232375, 
    232376, 
    241148, 
    232377, 
    241149, 
    232378, 
    232379, 
    245143, 
    245144, 
    232388, 
    232380, 
    232381, 
    245145, 
    241150, 
    232382, 
    232383, 
    232384, 
    232385, 
    232386, 
    232485, 
    244614, 
    244615, 
    244616, 
    244617, 
    244618, 
    244619, 
    244620, 
    244621, 
    232511, 
    232486, 
    232487, 
    232488, 
    232489, 
    232490, 
    232491, 
    237032, 
    237033, 
    232492, 
    245150, 
    241156, 
    232493, 
    232494, 
    232495, 
    232496, 
    232497, 
    241157, 
    232498, 
    232499, 
    232500, 
    232501, 
    232502, 
    232503, 
    232504, 
    232505, 
    241158, 
    232506, 
    241159, 
    232507, 
    232508, 
    245151, 
    245152, 
    232512, 
    232509, 
    232510, 
    245153, 
    241160, 
    234770, 
    234765, 
    234766, 
    235845, 
    235831, 
    244598, 
    244599, 
    244600, 
    244601, 
    244602, 
    244603, 
    244604, 
    244605, 
    235876, 
    235846, 
    235847, 
    235848, 
    235849, 
    235850, 
    235852, 
    237028, 
    237029, 
    235853, 
    241802, 
    235854, 
    235855, 
    235856, 
    235857, 
    235858, 
    241803, 
    235859, 
    235860, 
    235861, 
    235862, 
    235863, 
    235864, 
    235865, 
    235866, 
    241804, 
    235867, 
    241805, 
    235868, 
    235869, 
    240510, 
    235870, 
    241806, 
    235939, 
    235908, 
    235909, 
    235910, 
    235911, 
    235912, 
    235913, 
    235915, 
    237030, 
    237031, 
    235916, 
    241797, 
    235917, 
    235918, 
    235919, 
    235920, 
    235921, 
    241798, 
    235922, 
    235923, 
    235924, 
    235925, 
    235926, 
    235927, 
    235928, 
    235929, 
    241799, 
    235930, 
    241800, 
    235931, 
    235932, 
    240511, 
    235933, 
    241801, 
    235954, 
    244622, 
    244623, 
    244624, 
    244625, 
    244626, 
    244627, 
    244628, 
    244629, 
    235980, 
    235955, 
    235956, 
    235957, 
    235958, 
    235959, 
    235961, 
    237034, 
    237035, 
    235962, 
    241807, 
    235963, 
    235964, 
    235965, 
    235966, 
    235967, 
    241808, 
    235968, 
    235969, 
    235970, 
    235971, 
    235972, 
    235973, 
    235974, 
    235975, 
    241809, 
    235976, 
    241810, 
    235977, 
    235978, 
    240512, 
    235979, 
    241811
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00222

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": 243,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (223749,223750,223751,223752,223753,223754,223755,223756,223757,223758,223759,223760,223761,223762,230625,230623,230624,232268,232269,232270,232343,232344,232345,232387,244590,244591,244592,244593,244594,244595,244596,244597,232357,232358,232359,232360,232361,232362,237026,237027,232363,245142,241146,232364,232365,232366,232367,232368,241147,232369,232370,232371,232372,232373,232374,232375,232376,241148,232377,241149,232378,232379,245143,245144,232388,232380,232381,245145,241150,232382,232383,232384,232385,232386,232485,244614,244615,244616,244617,244618,244619,244620,244621,232511,232486,232487,232488,232489,232490,232491,237032,237033,232492,245150,241156,232493,232494,232495,232496,232497,241157,232498,232499,232500,232501,232502,232503,232504,232505,241158,232506,241159,232507,232508,245151,245152,232512,232509,232510,245153,241160,234770,234765,234766,235845,235831,244598,244599,244600,244601,244602,244603,244604,244605,235876,235846,235847,235848,235849,235850,235852,237028,237029,235853,241802,235854,235855,235856,235857,235858,241803,235859,235860,235861,235862,235863,235864,235865,235866,241804,235867,241805,235868,235869,240510,235870,241806,235939,235908,235909,235910,235911,235912,235913,235915,237030,237031,235916,241797,235917,235918,235919,235920,235921,241798,235922,235923,235924,235925,235926,235927,235928,235929,241799,235930,241800,235931,235932,240511,235933,241801,235954,244622,244623,244624,244625,244626,244627,244628,244629,235980,235955,235956,235957,235958,235959,235961,237034,237035,235962,241807,235963,235964,235965,235966,235967,241808,235968,235969,235970,235971,235972,235973,235974,235975,241809,235976,241810,235977,235978,240512,235979,241811)"
        }
      }
    },
    "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
42043 223761 variant_image 54276 0 V 0 D 0 0
42044 223762 variant_image 54277 0 V 0 D 0 0
49488 230623 variant_image 61721 0 V 0 D 0 0
49489 230624 variant_image 61722 0 V 0 D 0 0
52736 232344 variant_image 64969 0 V 0 D 0 0
52737 232345 variant_image 64970 0 V 0 D 0 0
52749 232357 variant_image 64982 0 V 0 D 0 0
52750 232358 variant_image 64983 0 V 0 D 0 0
52751 232359 variant_image 64984 0 V 0 D 0 0
52752 232360 variant_image 64985 0 V 0 D 0 0
52753 232361 variant_image 64986 0 V 0 D 0 0
52754 232362 variant_image 64987 0 V 0 D 0 0
52755 232363 variant_image 64988 0 V 0 D 0 0
52756 232364 variant_image 64989 0 V 0 D 0 0
52757 232365 variant_image 64990 0 V 0 D 0 0
52758 232366 variant_image 64991 0 V 0 D 0 0
52759 232367 variant_image 64992 0 V 0 D 0 0
52760 232368 variant_image 64993 0 V 0 D 0 0
52761 232369 variant_image 64994 0 V 0 D 0 0
52762 232370 variant_image 64995 0 V 0 D 0 0
52763 232371 variant_image 64996 0 V 0 D 0 0
52764 232372 variant_image 64997 0 V 0 D 0 0
52765 232373 variant_image 64998 0 V 0 D 0 0
52766 232374 variant_image 64999 0 V 0 D 0 0
52767 232375 variant_image 65000 0 V 0 D 0 0
52768 232376 variant_image 65001 0 V 0 D 0 0
52769 232377 variant_image 65002 0 V 0 D 0 0
52770 232378 variant_image 65003 0 V 0 D 0 0
52771 232379 variant_image 65004 0 V 0 D 0 0
52772 232380 variant_image 65005 0 V 0 D 0 0
52773 232381 variant_image 65006 0 V 0 D 0 0
52774 232382 variant_image 65007 0 V 0 D 0 0
52775 232383 variant_image 65008 0 V 0 D 0 0
52776 232384 variant_image 65009 0 V 0 D 0 0
52777 232385 variant_image 65010 0 V 0 D 0 0
52778 232386 variant_image 65011 0 V 0 D 0 0
52779 232388 variant_image 65012 0 V 0 D 0 0
52869 232486 variant_image 65102 0 V 0 D 0 0
52870 232487 variant_image 65103 0 V 0 D 0 0
52871 232488 variant_image 65104 0 V 0 D 0 0
52872 232489 variant_image 65105 0 V 0 D 0 0
52873 232490 variant_image 65106 0 V 0 D 0 0
52874 232491 variant_image 65107 0 V 0 D 0 0
52875 232492 variant_image 65108 0 V 0 D 0 0
52876 232493 variant_image 65109 0 V 0 D 0 0
52877 232494 variant_image 65110 0 V 0 D 0 0
52878 232495 variant_image 65111 0 V 0 D 0 0
52879 232496 variant_image 65112 0 V 0 D 0 0
52880 232497 variant_image 65113 0 V 0 D 0 0
52881 232498 variant_image 65114 0 V 0 D 0 0
52882 232499 variant_image 65115 0 V 0 D 0 0
52883 232500 variant_image 65116 0 V 0 D 0 0
52884 232501 variant_image 65117 0 V 0 D 0 0
52885 232502 variant_image 65118 0 V 0 D 0 0
52886 232503 variant_image 65119 0 V 0 D 0 0
52887 232504 variant_image 65120 0 V 0 D 0 0
52888 232505 variant_image 65121 0 V 0 D 0 0
52889 232506 variant_image 65122 0 V 0 D 0 0
52890 232507 variant_image 65123 0 V 0 D 0 0
52891 232508 variant_image 65124 0 V 0 D 0 0
52892 232509 variant_image 65125 0 V 0 D 0 0
52893 232510 variant_image 65126 0 V 0 D 0 0
52894 232512 variant_image 65127 0 V 0 D 0 0
55577 234765 variant_image 67810 0 V 0 D 0 0
55578 234766 variant_image 67811 0 V 0 D 0 0
57732 235846 variant_image 69965 0 V 0 D 0 0
57733 235847 variant_image 69966 0 V 0 D 0 0
57734 235848 variant_image 69967 0 V 0 D 0 0
57735 235849 variant_image 69968 0 V 0 D 0 0
57736 235850 variant_image 69969 0 V 0 D 0 0
57738 235852 variant_image 69971 0 V 0 D 0 0
57739 235853 variant_image 69972 0 V 0 D 0 0
57740 235854 variant_image 69973 0 V 0 D 0 0
57741 235855 variant_image 69974 0 V 0 D 0 0
57742 235856 variant_image 69975 0 V 0 D 0 0
57743 235857 variant_image 69976 0 V 0 D 0 0
57744 235858 variant_image 69977 0 V 0 D 0 0
57745 235859 variant_image 69978 0 V 0 D 0 0
57746 235860 variant_image 69979 0 V 0 D 0 0
57747 235861 variant_image 69980 0 V 0 D 0 0
57748 235862 variant_image 69981 0 V 0 D 0 0
57749 235863 variant_image 69982 0 V 0 D 0 0
57750 235864 variant_image 69983 0 V 0 D 0 0
57751 235865 variant_image 69984 0 V 0 D 0 0
57752 235866 variant_image 69985 0 V 0 D 0 0
57753 235867 variant_image 69986 0 V 0 D 0 0
57754 235868 variant_image 69987 0 V 0 D 0 0
57755 235869 variant_image 69988 0 V 0 D 0 0
57756 235870 variant_image 69989 0 V 0 D 0 0
57835 235955 variant_image 70068 0 V 0 D 0 0
57836 235956 variant_image 70069 0 V 0 D 0 0
57837 235957 variant_image 70070 0 V 0 D 0 0
57838 235958 variant_image 70071 0 V 0 D 0 0
57839 235959 variant_image 70072 0 V 0 D 0 0
57841 235961 variant_image 70074 0 V 0 D 0 0
57842 235962 variant_image 70075 0 V 0 D 0 0
57843 235963 variant_image 70076 0 V 0 D 0 0
57844 235964 variant_image 70077 0 V 0 D 0 0
57845 235965 variant_image 70078 0 V 0 D 0 0
57846 235966 variant_image 70079 0 V 0 D 0 0
57847 235967 variant_image 70080 0 V 0 D 0 0
57848 235968 variant_image 70081 0 V 0 D 0 0
57849 235969 variant_image 70082 0 V 0 D 0 0
57850 235970 variant_image 70083 0 V 0 D 0 0
57851 235971 variant_image 70084 0 V 0 D 0 0
57852 235972 variant_image 70085 0 V 0 D 0 0
57853 235973 variant_image 70086 0 V 0 D 0 0
57854 235974 variant_image 70087 0 V 0 D 0 0
57855 235975 variant_image 70088 0 V 0 D 0 0
57856 235976 variant_image 70089 0 V 0 D 0 0
57857 235977 variant_image 70090 0 V 0 D 0 0
57858 235978 variant_image 70091 0 V 0 D 0 0
57859 235979 variant_image 70092 0 V 0 D 0 0
59770 237026 variant_image 72003 0 V 0 D 0 0
59771 237027 variant_image 72004 0 V 0 D 0 0
59772 237028 variant_image 72005 0 V 0 D 0 0
59773 237029 variant_image 72006 0 V 0 D 0 0
59776 237032 variant_image 72009 0 V 0 D 0 0
59777 237033 variant_image 72010 0 V 0 D 0 0
59780 237034 variant_image 72013 0 V 0 D 0 0
59781 237035 variant_image 72014 0 V 0 D 0 0
69591 240510 variant_image 81824 0 V 0 D 0 0
69593 240512 variant_image 81826 0 V 0 D 0 0
70681 241146 variant_image 82914 0 V 0 D 0 0
70682 241147 variant_image 82915 0 V 0 D 0 0
70683 241148 variant_image 82916 0 V 0 D 0 0
70684 241149 variant_image 82917 0 V 0 D 0 0
70685 241150 variant_image 82918 0 V 0 D 0 0
70691 241156 variant_image 82924 0 V 0 D 0 0
70692 241157 variant_image 82925 0 V 0 D 0 0
70693 241158 variant_image 82926 0 V 0 D 0 0
70694 241159 variant_image 82927 0 V 0 D 0 0
70695 241160 variant_image 82928 0 V 0 D 0 0
71355 241802 variant_image 83588 0 V 0 D 0 0
71356 241803 variant_image 83589 0 V 0 D 0 0
71357 241804 variant_image 83590 0 V 0 D 0 0
71358 241805 variant_image 83591 0 V 0 D 0 0
71359 241806 variant_image 83592 0 V 0 D 0 0
71360 241807 variant_image 83593 0 V 0 D 0 0
71361 241808 variant_image 83594 0 V 0 D 0 0
71362 241809 variant_image 83595 0 V 0 D 0 0
71363 241810 variant_image 83596 0 V 0 D 0 0
71364 241811 variant_image 83597 0 V 0 D 0 0
74382 244590 variant_image 86615 0 V 0 D 0 0
74383 244591 variant_image 86616 0 V 0 D 0 0
74384 244592 variant_image 86617 0 V 0 D 0 0
74385 244593 variant_image 86618 0 V 0 D 0 0
74386 244594 variant_image 86619 0 V 0 D 0 0
74387 244595 variant_image 86620 0 V 0 D 0 0
74388 244596 variant_image 86621 0 V 0 D 0 0
74389 244597 variant_image 86622 0 V 0 D 0 0
74390 244598 variant_image 86623 0 V 0 D 0 0
74391 244599 variant_image 86624 0 V 0 D 0 0
74392 244600 variant_image 86625 0 V 0 D 0 0
74393 244601 variant_image 86626 0 V 0 D 0 0
74394 244602 variant_image 86627 0 V 0 D 0 0
74395 244603 variant_image 86628 0 V 0 D 0 0
74396 244604 variant_image 86629 0 V 0 D 0 0
74397 244605 variant_image 86630 0 V 0 D 0 0
74406 244614 variant_image 86639 0 V 0 D 0 0
74407 244615 variant_image 86640 0 V 0 D 0 0
74408 244616 variant_image 86641 0 V 0 D 0 0
74409 244617 variant_image 86642 0 V 0 D 0 0
74410 244618 variant_image 86643 0 V 0 D 0 0
74411 244619 variant_image 86644 0 V 0 D 0 0
74412 244620 variant_image 86645 0 V 0 D 0 0
74413 244621 variant_image 86646 0 V 0 D 0 0
74414 244622 variant_image 86647 0 V 0 D 0 0
74415 244623 variant_image 86648 0 V 0 D 0 0
74416 244624 variant_image 86649 0 V 0 D 0 0
74417 244625 variant_image 86650 0 V 0 D 0 0
74418 244626 variant_image 86651 0 V 0 D 0 0
74419 244627 variant_image 86652 0 V 0 D 0 0
74420 244628 variant_image 86653 0 V 0 D 0 0
74421 244629 variant_image 86654 0 V 0 D 0 0
74945 245142 variant_image 87178 0 V 0 D 0 0
74946 245143 variant_image 87179 0 V 0 D 0 0
74947 245144 variant_image 87180 0 V 0 D 0 0
74948 245145 variant_image 87181 0 V 0 D 0 0
74953 245150 variant_image 87186 0 V 0 D 0 0
74954 245151 variant_image 87187 0 V 0 D 0 0
74955 245152 variant_image 87188 0 V 0 D 0 0
74956 245153 variant_image 87189 0 V 0 D 0 0