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 (
    227176, 
    227163, 
    227164, 
    227165, 
    227166, 
    227167, 
    227168, 
    227169, 
    227170, 
    227171, 
    227172, 
    227173, 
    227174, 
    232064, 
    232065, 
    232066, 
    232067, 
    232068, 
    232069, 
    233820, 
    244982, 
    244983, 
    244984, 
    244985, 
    244986, 
    244987, 
    244988, 
    244989, 
    233790, 
    233791, 
    233792, 
    233793, 
    233794, 
    233795, 
    236994, 
    236995, 
    233796, 
    241751, 
    233797, 
    233798, 
    233799, 
    233800, 
    233801, 
    241752, 
    233802, 
    233803, 
    233804, 
    233805, 
    233806, 
    233807, 
    233808, 
    233809, 
    241753, 
    233810, 
    241754, 
    233811, 
    233812, 
    233821, 
    233813, 
    233814, 
    241755, 
    233815, 
    233816, 
    233817, 
    233818, 
    233819, 
    233853, 
    233822, 
    233823, 
    233824, 
    233825, 
    233826, 
    233827, 
    233847, 
    233828, 
    236992, 
    236993, 
    233829, 
    241756, 
    233830, 
    233831, 
    233832, 
    233833, 
    233834, 
    241757, 
    233835, 
    233836, 
    233837, 
    233838, 
    233839, 
    233840, 
    233841, 
    233842, 
    241758, 
    233843, 
    241759, 
    233844, 
    233845, 
    233854, 
    233855, 
    233846, 
    241760, 
    233870, 
    233856, 
    244990, 
    244991, 
    244992, 
    244993, 
    244994, 
    244995, 
    244996, 
    244997, 
    233977, 
    233978, 
    233979, 
    234004, 
    234005, 
    234006, 
    234007, 
    234008, 
    234009, 
    234010, 
    234011, 
    234012, 
    234020, 
    234021, 
    234022, 
    234023, 
    234031, 
    234032, 
    234033, 
    234034, 
    234042, 
    234043, 
    234044, 
    234045, 
    234079, 
    234053, 
    234054, 
    234055, 
    234056, 
    234057, 
    234058, 
    236998, 
    236999, 
    234059, 
    241766, 
    234060, 
    234061, 
    234062, 
    234063, 
    234064, 
    241767, 
    234065, 
    234066, 
    234067, 
    234068, 
    234069, 
    234070, 
    234071, 
    234072, 
    241768, 
    234073, 
    241769, 
    234074, 
    234075, 
    234076, 
    234077, 
    234078, 
    241770, 
    234092, 
    245006, 
    245007, 
    245008, 
    245009, 
    245010, 
    245011, 
    245012, 
    245013, 
    234116, 
    234102, 
    245014, 
    245015, 
    245016, 
    245017, 
    245018, 
    245019, 
    245020, 
    245021, 
    234149, 
    234117, 
    234118, 
    234119, 
    234120, 
    234121, 
    234122, 
    234123, 
    234124, 
    234125, 
    241771, 
    234126, 
    234127, 
    234128, 
    234129, 
    234130, 
    241772, 
    234131, 
    234132, 
    234133, 
    234134, 
    234135, 
    234136, 
    234137, 
    234138, 
    241773, 
    234139, 
    241774, 
    234140, 
    234141, 
    234142, 
    234143, 
    241775, 
    234144, 
    234145, 
    234146, 
    234147, 
    234148, 
    234181, 
    234150, 
    234151, 
    234152, 
    234153, 
    234154, 
    234155, 
    234156, 
    234157, 
    241776, 
    234158, 
    234159, 
    234160, 
    234161, 
    234162, 
    241777, 
    234163, 
    234164, 
    234165, 
    234166, 
    234167, 
    234168, 
    234169, 
    234170, 
    241778, 
    234171, 
    241779, 
    234172, 
    234173, 
    234174, 
    234175, 
    241780, 
    234176, 
    234177, 
    234178, 
    234179, 
    234180, 
    234592, 
    234587, 
    234588, 
    234589, 
    234620, 
    234621, 
    234622, 
    234623, 
    234624, 
    234625
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00270

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": 274,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (227176,227163,227164,227165,227166,227167,227168,227169,227170,227171,227172,227173,227174,232064,232065,232066,232067,232068,232069,233820,244982,244983,244984,244985,244986,244987,244988,244989,233790,233791,233792,233793,233794,233795,236994,236995,233796,241751,233797,233798,233799,233800,233801,241752,233802,233803,233804,233805,233806,233807,233808,233809,241753,233810,241754,233811,233812,233821,233813,233814,241755,233815,233816,233817,233818,233819,233853,233822,233823,233824,233825,233826,233827,233847,233828,236992,236993,233829,241756,233830,233831,233832,233833,233834,241757,233835,233836,233837,233838,233839,233840,233841,233842,241758,233843,241759,233844,233845,233854,233855,233846,241760,233870,233856,244990,244991,244992,244993,244994,244995,244996,244997,233977,233978,233979,234004,234005,234006,234007,234008,234009,234010,234011,234012,234020,234021,234022,234023,234031,234032,234033,234034,234042,234043,234044,234045,234079,234053,234054,234055,234056,234057,234058,236998,236999,234059,241766,234060,234061,234062,234063,234064,241767,234065,234066,234067,234068,234069,234070,234071,234072,241768,234073,241769,234074,234075,234076,234077,234078,241770,234092,245006,245007,245008,245009,245010,245011,245012,245013,234116,234102,245014,245015,245016,245017,245018,245019,245020,245021,234149,234117,234118,234119,234120,234121,234122,234123,234124,234125,241771,234126,234127,234128,234129,234130,241772,234131,234132,234133,234134,234135,234136,234137,234138,241773,234139,241774,234140,234141,234142,234143,241775,234144,234145,234146,234147,234148,234181,234150,234151,234152,234153,234154,234155,234156,234157,241776,234158,234159,234160,234161,234162,241777,234163,234164,234165,234166,234167,234168,234169,234170,241778,234171,241779,234172,234173,234174,234175,241780,234176,234177,234178,234179,234180,234592,234587,234588,234589,234620,234621,234622,234623,234624,234625)"
        }
      }
    },
    "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
52343 232065 variant_image 64576 0 V 0 D 0 0
52344 232066 variant_image 64577 0 V 0 D 0 0
52345 232067 variant_image 64578 0 V 0 D 0 0
52346 232068 variant_image 64579 0 V 0 D 0 0
52347 232069 variant_image 64580 0 V 0 D 0 0
54415 233790 variant_image 66648 0 V 0 D 0 0
54416 233791 variant_image 66649 0 V 0 D 0 0
54417 233792 variant_image 66650 0 V 0 D 0 0
54418 233793 variant_image 66651 0 V 0 D 0 0
54419 233794 variant_image 66652 0 V 0 D 0 0
54420 233795 variant_image 66653 0 V 0 D 0 0
54421 233796 variant_image 66654 0 V 0 D 0 0
54422 233797 variant_image 66655 0 V 0 D 0 0
54423 233798 variant_image 66656 0 V 0 D 0 0
54424 233799 variant_image 66657 0 V 0 D 0 0
54425 233800 variant_image 66658 0 V 0 D 0 0
54426 233801 variant_image 66659 0 V 0 D 0 0
54427 233802 variant_image 66660 0 V 0 D 0 0
54428 233803 variant_image 66661 0 V 0 D 0 0
54429 233804 variant_image 66662 0 V 0 D 0 0
54430 233805 variant_image 66663 0 V 0 D 0 0
54431 233806 variant_image 66664 0 V 0 D 0 0
54432 233807 variant_image 66665 0 V 0 D 0 0
54433 233808 variant_image 66666 0 V 0 D 0 0
54434 233809 variant_image 66667 0 V 0 D 0 0
54435 233810 variant_image 66668 0 V 0 D 0 0
54436 233811 variant_image 66669 0 V 0 D 0 0
54437 233812 variant_image 66670 0 V 0 D 0 0
54438 233813 variant_image 66671 0 V 0 D 0 0
54439 233814 variant_image 66672 0 V 0 D 0 0
54440 233815 variant_image 66673 0 V 0 D 0 0
54441 233816 variant_image 66674 0 V 0 D 0 0
54442 233817 variant_image 66675 0 V 0 D 0 0
54443 233818 variant_image 66676 0 V 0 D 0 0
54444 233819 variant_image 66677 0 V 0 D 0 0
54445 233821 variant_image 66678 0 V 0 D 0 0
54446 233823 variant_image 66679 0 V 0 D 0 0
54447 233824 variant_image 66680 0 V 0 D 0 0
54448 233825 variant_image 66681 0 V 0 D 0 0
54449 233826 variant_image 66682 0 V 0 D 0 0
54450 233827 variant_image 66683 0 V 0 D 0 0
54451 233828 variant_image 66684 0 V 0 D 0 0
54452 233829 variant_image 66685 0 V 0 D 0 0
54453 233830 variant_image 66686 0 V 0 D 0 0
54454 233831 variant_image 66687 0 V 0 D 0 0
54455 233832 variant_image 66688 0 V 0 D 0 0
54456 233833 variant_image 66689 0 V 0 D 0 0
54457 233834 variant_image 66690 0 V 0 D 0 0
54458 233835 variant_image 66691 0 V 0 D 0 0
54459 233836 variant_image 66692 0 V 0 D 0 0
54460 233837 variant_image 66693 0 V 0 D 0 0
54461 233838 variant_image 66694 0 V 0 D 0 0
54462 233839 variant_image 66695 0 V 0 D 0 0
54463 233840 variant_image 66696 0 V 0 D 0 0
54464 233841 variant_image 66697 0 V 0 D 0 0
54465 233842 variant_image 66698 0 V 0 D 0 0
54466 233843 variant_image 66699 0 V 0 D 0 0
54467 233844 variant_image 66700 0 V 0 D 0 0
54468 233845 variant_image 66701 0 V 0 D 0 0
54469 233846 variant_image 66702 0 V 0 D 0 0
54470 233847 variant_image 66703 0 V 0 D 0 0
54476 233854 variant_image 66709 0 V 0 D 0 0
54477 233855 variant_image 66710 0 V 0 D 0 0
54611 234005 variant_image 66844 0 V 0 D 0 0
54612 234006 variant_image 66845 0 V 0 D 0 0
54613 234007 variant_image 66846 0 V 0 D 0 0
54614 234008 variant_image 66847 0 V 0 D 0 0
54615 234010 variant_image 66848 0 V 0 D 0 0
54616 234011 variant_image 66849 0 V 0 D 0 0
54617 234012 variant_image 66850 0 V 0 D 0 0
54625 234021 variant_image 66858 0 V 0 D 0 0
54626 234022 variant_image 66859 0 V 0 D 0 0
54627 234023 variant_image 66860 0 V 0 D 0 0
54635 234032 variant_image 66868 0 V 0 D 0 0
54636 234033 variant_image 66869 0 V 0 D 0 0
54637 234034 variant_image 66870 0 V 0 D 0 0
54645 234043 variant_image 66878 0 V 0 D 0 0
54646 234044 variant_image 66879 0 V 0 D 0 0
54647 234045 variant_image 66880 0 V 0 D 0 0
54655 234053 variant_image 66888 0 V 0 D 0 0
54656 234054 variant_image 66889 0 V 0 D 0 0
54657 234055 variant_image 66890 0 V 0 D 0 0
54658 234056 variant_image 66891 0 V 0 D 0 0
54659 234057 variant_image 66892 0 V 0 D 0 0
54660 234058 variant_image 66893 0 V 0 D 0 0
54661 234059 variant_image 66894 0 V 0 D 0 0
54662 234060 variant_image 66895 0 V 0 D 0 0
54663 234061 variant_image 66896 0 V 0 D 0 0
54664 234062 variant_image 66897 0 V 0 D 0 0
54665 234063 variant_image 66898 0 V 0 D 0 0
54666 234064 variant_image 66899 0 V 0 D 0 0
54667 234065 variant_image 66900 0 V 0 D 0 0
54668 234066 variant_image 66901 0 V 0 D 0 0
54669 234067 variant_image 66902 0 V 0 D 0 0
54670 234068 variant_image 66903 0 V 0 D 0 0
54671 234069 variant_image 66904 0 V 0 D 0 0
54672 234070 variant_image 66905 0 V 0 D 0 0
54673 234071 variant_image 66906 0 V 0 D 0 0
54674 234072 variant_image 66907 0 V 0 D 0 0
54675 234073 variant_image 66908 0 V 0 D 0 0
54676 234074 variant_image 66909 0 V 0 D 0 0
54677 234075 variant_image 66910 0 V 0 D 0 0
54678 234076 variant_image 66911 0 V 0 D 0 0
54679 234077 variant_image 66912 0 V 0 D 0 0
54680 234078 variant_image 66913 0 V 0 D 0 0
54717 234118 variant_image 66950 0 V 0 D 0 0
54718 234119 variant_image 66951 0 V 0 D 0 0
54719 234120 variant_image 66952 0 V 0 D 0 0
54720 234121 variant_image 66953 0 V 0 D 0 0
54721 234122 variant_image 66954 0 V 0 D 0 0
54722 234123 variant_image 66955 0 V 0 D 0 0
54723 234124 variant_image 66956 0 V 0 D 0 0
54724 234125 variant_image 66957 0 V 0 D 0 0
54725 234126 variant_image 66958 0 V 0 D 0 0
54726 234127 variant_image 66959 0 V 0 D 0 0
54727 234128 variant_image 66960 0 V 0 D 0 0
54728 234129 variant_image 66961 0 V 0 D 0 0
54729 234130 variant_image 66962 0 V 0 D 0 0
54730 234131 variant_image 66963 0 V 0 D 0 0
54731 234132 variant_image 66964 0 V 0 D 0 0
54732 234133 variant_image 66965 0 V 0 D 0 0
54733 234134 variant_image 66966 0 V 0 D 0 0
54734 234135 variant_image 66967 0 V 0 D 0 0
54735 234136 variant_image 66968 0 V 0 D 0 0
54736 234137 variant_image 66969 0 V 0 D 0 0
54737 234138 variant_image 66970 0 V 0 D 0 0
54738 234139 variant_image 66971 0 V 0 D 0 0
54739 234140 variant_image 66972 0 V 0 D 0 0
54740 234141 variant_image 66973 0 V 0 D 0 0
54741 234142 variant_image 66974 0 V 0 D 0 0
54742 234143 variant_image 66975 0 V 0 D 0 0
54743 234144 variant_image 66976 0 V 0 D 0 0
54744 234145 variant_image 66977 0 V 0 D 0 0
54745 234146 variant_image 66978 0 V 0 D 0 0
54746 234147 variant_image 66979 0 V 0 D 0 0
54747 234148 variant_image 66980 0 V 0 D 0 0
54748 234150 variant_image 66981 0 V 0 D 0 0
54749 234151 variant_image 66982 0 V 0 D 0 0
54750 234152 variant_image 66983 0 V 0 D 0 0
54751 234153 variant_image 66984 0 V 0 D 0 0
54752 234154 variant_image 66985 0 V 0 D 0 0
54753 234155 variant_image 66986 0 V 0 D 0 0
54754 234156 variant_image 66987 0 V 0 D 0 0
54755 234157 variant_image 66988 0 V 0 D 0 0
54756 234158 variant_image 66989 0 V 0 D 0 0
54757 234159 variant_image 66990 0 V 0 D 0 0
54758 234160 variant_image 66991 0 V 0 D 0 0
54759 234161 variant_image 66992 0 V 0 D 0 0
54760 234162 variant_image 66993 0 V 0 D 0 0
54761 234163 variant_image 66994 0 V 0 D 0 0
54762 234164 variant_image 66995 0 V 0 D 0 0
54763 234165 variant_image 66996 0 V 0 D 0 0
54764 234166 variant_image 66997 0 V 0 D 0 0
54765 234167 variant_image 66998 0 V 0 D 0 0
54766 234168 variant_image 66999 0 V 0 D 0 0
54767 234169 variant_image 67000 0 V 0 D 0 0
54768 234170 variant_image 67001 0 V 0 D 0 0
54769 234171 variant_image 67002 0 V 0 D 0 0
54770 234172 variant_image 67003 0 V 0 D 0 0
54771 234173 variant_image 67004 0 V 0 D 0 0
54772 234174 variant_image 67005 0 V 0 D 0 0
54773 234175 variant_image 67006 0 V 0 D 0 0
54774 234176 variant_image 67007 0 V 0 D 0 0
54775 234177 variant_image 67008 0 V 0 D 0 0
54776 234178 variant_image 67009 0 V 0 D 0 0
54777 234179 variant_image 67010 0 V 0 D 0 0
54778 234180 variant_image 67011 0 V 0 D 0 0
55146 234587 variant_image 67379 0 V 0 D 0 0
55147 234588 variant_image 67380 0 V 0 D 0 0
55148 234589 variant_image 67381 0 V 0 D 0 0
59736 236992 variant_image 71969 0 V 0 D 0 0
59737 236993 variant_image 71970 0 V 0 D 0 0
59738 236994 variant_image 71971 0 V 0 D 0 0
59739 236995 variant_image 71972 0 V 0 D 0 0
59742 236998 variant_image 71975 0 V 0 D 0 0
59743 236999 variant_image 71976 0 V 0 D 0 0
71305 241751 variant_image 83538 0 V 0 D 0 0
71306 241752 variant_image 83539 0 V 0 D 0 0
71307 241753 variant_image 83540 0 V 0 D 0 0
71308 241754 variant_image 83541 0 V 0 D 0 0
71309 241755 variant_image 83542 0 V 0 D 0 0
71310 241756 variant_image 83543 0 V 0 D 0 0
71311 241757 variant_image 83544 0 V 0 D 0 0
71312 241758 variant_image 83545 0 V 0 D 0 0
71313 241759 variant_image 83546 0 V 0 D 0 0
71314 241760 variant_image 83547 0 V 0 D 0 0
71320 241766 variant_image 83553 0 V 0 D 0 0
71321 241767 variant_image 83554 0 V 0 D 0 0
71322 241768 variant_image 83555 0 V 0 D 0 0
71323 241769 variant_image 83556 0 V 0 D 0 0
71324 241770 variant_image 83557 0 V 0 D 0 0
71325 241771 variant_image 83558 0 V 0 D 0 0
71326 241772 variant_image 83559 0 V 0 D 0 0
71327 241773 variant_image 83560 0 V 0 D 0 0
71328 241774 variant_image 83561 0 V 0 D 0 0
71329 241775 variant_image 83562 0 V 0 D 0 0
71330 241776 variant_image 83563 0 V 0 D 0 0
71331 241777 variant_image 83564 0 V 0 D 0 0
71332 241778 variant_image 83565 0 V 0 D 0 0
71333 241779 variant_image 83566 0 V 0 D 0 0
71334 241780 variant_image 83567 0 V 0 D 0 0
74774 244982 variant_image 87007 0 V 0 D 0 0
74775 244983 variant_image 87008 0 V 0 D 0 0
74776 244984 variant_image 87009 0 V 0 D 0 0
74777 244985 variant_image 87010 0 V 0 D 0 0
74778 244986 variant_image 87011 0 V 0 D 0 0
74779 244987 variant_image 87012 0 V 0 D 0 0
74780 244988 variant_image 87013 0 V 0 D 0 0
74781 244989 variant_image 87014 0 V 0 D 0 0
74782 244990 variant_image 87015 0 V 0 D 0 0
74783 244991 variant_image 87016 0 V 0 D 0 0
74784 244992 variant_image 87017 0 V 0 D 0 0
74785 244993 variant_image 87018 0 V 0 D 0 0
74786 244994 variant_image 87019 0 V 0 D 0 0
74787 244995 variant_image 87020 0 V 0 D 0 0
74788 244996 variant_image 87021 0 V 0 D 0 0
74789 244997 variant_image 87022 0 V 0 D 0 0
74798 245006 variant_image 87031 0 V 0 D 0 0
74799 245007 variant_image 87032 0 V 0 D 0 0
74800 245008 variant_image 87033 0 V 0 D 0 0
74801 245009 variant_image 87034 0 V 0 D 0 0
74802 245010 variant_image 87035 0 V 0 D 0 0
74803 245011 variant_image 87036 0 V 0 D 0 0
74804 245012 variant_image 87037 0 V 0 D 0 0
74805 245013 variant_image 87038 0 V 0 D 0 0
74806 245014 variant_image 87039 0 V 0 D 0 0
74807 245015 variant_image 87040 0 V 0 D 0 0
74808 245016 variant_image 87041 0 V 0 D 0 0
74809 245017 variant_image 87042 0 V 0 D 0 0
74810 245018 variant_image 87043 0 V 0 D 0 0
74811 245019 variant_image 87044 0 V 0 D 0 0
74812 245020 variant_image 87045 0 V 0 D 0 0
74813 245021 variant_image 87046 0 V 0 D 0 0