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 (
    218476, 
    215713, 
    215714, 
    215715, 
    215716, 
    215738, 
    215731, 
    237036, 
    237037, 
    215717, 
    242135, 
    241141, 
    215718, 
    215719, 
    215720, 
    215721, 
    215722, 
    241142, 
    215723, 
    215724, 
    215725, 
    215726, 
    215727, 
    215728, 
    215729, 
    215730, 
    241143, 
    215732, 
    241144, 
    215733, 
    215734, 
    215735, 
    242136, 
    242137, 
    215736, 
    215737, 
    242138, 
    241145, 
    220319, 
    219225, 
    219227, 
    242997, 
    219229, 
    222695, 
    222693, 
    222694, 
    222698, 
    222696, 
    222697, 
    222699, 
    222700, 
    222701, 
    222704, 
    222691, 
    222692, 
    222708, 
    222705, 
    222706, 
    222709, 
    222710, 
    222711, 
    222726, 
    222712, 
    222713, 
    222714, 
    222715, 
    222716, 
    222717, 
    222718, 
    222719, 
    222720, 
    222721, 
    222722, 
    222723, 
    222724, 
    222725, 
    243091, 
    243092, 
    243093, 
    243094, 
    222727, 
    222728, 
    222729, 
    222760, 
    222730, 
    222731, 
    222732, 
    222733, 
    222755, 
    222748, 
    237240, 
    237241, 
    222734, 
    242916, 
    241700, 
    222735, 
    222736, 
    222737, 
    222738, 
    222739, 
    241701, 
    222740, 
    222741, 
    222742, 
    222743, 
    222744, 
    222745, 
    222746, 
    222747, 
    241702, 
    222749, 
    241703, 
    222750, 
    222751, 
    242917, 
    242918, 
    222752, 
    222753, 
    222754, 
    242919, 
    241704, 
    222761, 
    222762, 
    222763, 
    222805, 
    222764, 
    222765, 
    222766, 
    222767, 
    222770, 
    222768, 
    222769, 
    222771, 
    222772, 
    222773, 
    222774, 
    222775, 
    222776, 
    222777, 
    222778, 
    222779, 
    222780, 
    222781, 
    241746, 
    222804, 
    222782, 
    222783, 
    222784, 
    222785, 
    241747, 
    222786, 
    222787, 
    222788, 
    222789, 
    222790, 
    222791, 
    222792, 
    222793, 
    241748, 
    222794, 
    241749, 
    222795, 
    222796, 
    222797, 
    222798, 
    241750, 
    222799, 
    222800, 
    222801, 
    222802, 
    222803, 
    222806, 
    222807, 
    222808, 
    222809, 
    222810, 
    230424, 
    230425, 
    230426, 
    239207, 
    239178, 
    239179, 
    239180, 
    239181, 
    239182, 
    239183, 
    239205, 
    239206, 
    239184, 
    242908, 
    241736, 
    239185, 
    239186, 
    239187, 
    239188, 
    239189, 
    241737, 
    239190, 
    239191, 
    239192, 
    239193, 
    239194, 
    239195, 
    239196, 
    239197, 
    241738, 
    239198, 
    241739, 
    239199, 
    239200, 
    242909, 
    242910, 
    239201, 
    239202, 
    242911, 
    241740, 
    239235, 
    239208, 
    239209, 
    239210, 
    239211, 
    239212, 
    239213, 
    239238, 
    239239, 
    239214, 
    242912, 
    241741, 
    239215, 
    239216, 
    239217, 
    239218, 
    239219, 
    241742, 
    239220, 
    239221, 
    239222, 
    239223, 
    239224, 
    239225, 
    239226, 
    239227, 
    241743, 
    239228, 
    241744, 
    239229, 
    239230, 
    242913, 
    242914, 
    239231, 
    239232, 
    242915, 
    241745, 
    239233, 
    239234
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00291

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": 255,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (218476,215713,215714,215715,215716,215738,215731,237036,237037,215717,242135,241141,215718,215719,215720,215721,215722,241142,215723,215724,215725,215726,215727,215728,215729,215730,241143,215732,241144,215733,215734,215735,242136,242137,215736,215737,242138,241145,220319,219225,219227,242997,219229,222695,222693,222694,222698,222696,222697,222699,222700,222701,222704,222691,222692,222708,222705,222706,222709,222710,222711,222726,222712,222713,222714,222715,222716,222717,222718,222719,222720,222721,222722,222723,222724,222725,243091,243092,243093,243094,222727,222728,222729,222760,222730,222731,222732,222733,222755,222748,237240,237241,222734,242916,241700,222735,222736,222737,222738,222739,241701,222740,222741,222742,222743,222744,222745,222746,222747,241702,222749,241703,222750,222751,242917,242918,222752,222753,222754,242919,241704,222761,222762,222763,222805,222764,222765,222766,222767,222770,222768,222769,222771,222772,222773,222774,222775,222776,222777,222778,222779,222780,222781,241746,222804,222782,222783,222784,222785,241747,222786,222787,222788,222789,222790,222791,222792,222793,241748,222794,241749,222795,222796,222797,222798,241750,222799,222800,222801,222802,222803,222806,222807,222808,222809,222810,230424,230425,230426,239207,239178,239179,239180,239181,239182,239183,239205,239206,239184,242908,241736,239185,239186,239187,239188,239189,241737,239190,239191,239192,239193,239194,239195,239196,239197,241738,239198,241739,239199,239200,242909,242910,239201,239202,242911,241740,239235,239208,239209,239210,239211,239212,239213,239238,239239,239214,242912,241741,239215,239216,239217,239218,239219,241742,239220,239221,239222,239223,239224,239225,239226,239227,241743,239228,241744,239229,239230,242913,242914,239231,239232,242915,241745,239233,239234)"
        }
      }
    },
    "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
33888 215713 variant_image 46121 0 V 0 D 0 0
33889 215714 variant_image 46122 0 V 0 D 0 0
33890 215715 variant_image 46123 0 V 0 D 0 0
33891 215716 variant_image 46124 0 V 0 D 0 0
33892 215738 variant_image 46125 0 V 0 D 0 0
33893 215731 variant_image 46126 0 V 0 D 0 0
33894 215717 variant_image 46127 0 V 0 D 0 0
33895 215718 variant_image 46128 0 V 0 D 0 0
33896 215719 variant_image 46129 0 V 0 D 0 0
33897 215720 variant_image 46130 0 V 0 D 0 0
33898 215721 variant_image 46131 0 V 0 D 0 0
33899 215722 variant_image 46132 0 V 0 D 0 0
33900 215723 variant_image 46133 0 V 0 D 0 0
33901 215724 variant_image 46134 0 V 0 D 0 0
33902 215725 variant_image 46135 0 V 0 D 0 0
33903 215726 variant_image 46136 0 V 0 D 0 0
33904 215727 variant_image 46137 0 V 0 D 0 0
33905 215728 variant_image 46138 0 V 0 D 0 0
33906 215729 variant_image 46139 0 V 0 D 0 0
33907 215730 variant_image 46140 0 V 0 D 0 0
33908 215732 variant_image 46141 0 V 0 D 0 0
33909 215733 variant_image 46142 0 V 0 D 0 0
33910 215734 variant_image 46143 0 V 0 D 0 0
33911 215735 variant_image 46144 0 V 0 D 0 0
33912 215736 variant_image 46145 0 V 0 D 0 0
33913 215737 variant_image 46146 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
38008 219225 variant_image 50241 0 V 0 D 0 0
41026 222693 variant_image 53259 0 V 0 D 0 0
41027 222694 variant_image 53260 0 V 0 D 0 0
41028 222696 variant_image 53261 0 V 0 D 0 0
41029 222697 variant_image 53262 0 V 0 D 0 0
41030 222700 variant_image 53263 0 V 0 D 0 0
41031 222701 variant_image 53264 0 V 0 D 0 0
41034 222705 variant_image 53267 0 V 0 D 0 0
41035 222706 variant_image 53268 0 V 0 D 0 0
41037 222712 variant_image 53270 0 V 0 D 0 0
41038 222713 variant_image 53271 0 V 0 D 0 0
41039 222714 variant_image 53272 0 V 0 D 0 0
41040 222715 variant_image 53273 0 V 0 D 0 0
41041 222716 variant_image 53274 0 V 0 D 0 0
41042 222717 variant_image 53275 0 V 0 D 0 0
41043 222718 variant_image 53276 0 V 0 D 0 0
41044 222719 variant_image 53277 0 V 0 D 0 0
41045 222720 variant_image 53278 0 V 0 D 0 0
41046 222721 variant_image 53279 0 V 0 D 0 0
41047 222722 variant_image 53280 0 V 0 D 0 0
41048 222723 variant_image 53281 0 V 0 D 0 0
41049 222724 variant_image 53282 0 V 0 D 0 0
41050 222725 variant_image 53283 0 V 0 D 0 0
41051 222728 variant_image 53284 0 V 0 D 0 0
41052 222729 variant_image 53285 0 V 0 D 0 0
41053 222730 variant_image 53286 0 V 0 D 0 0
41054 222731 variant_image 53287 0 V 0 D 0 0
41055 222732 variant_image 53288 0 V 0 D 0 0
41056 222733 variant_image 53289 0 V 0 D 0 0
41057 222734 variant_image 53290 0 V 0 D 0 0
41058 222735 variant_image 53291 0 V 0 D 0 0
41059 222736 variant_image 53292 0 V 0 D 0 0
41060 222737 variant_image 53293 0 V 0 D 0 0
41061 222738 variant_image 53294 0 V 0 D 0 0
41062 222739 variant_image 53295 0 V 0 D 0 0
41063 222740 variant_image 53296 0 V 0 D 0 0
41064 222741 variant_image 53297 0 V 0 D 0 0
41065 222742 variant_image 53298 0 V 0 D 0 0
41066 222743 variant_image 53299 0 V 0 D 0 0
41067 222744 variant_image 53300 0 V 0 D 0 0
41068 222745 variant_image 53301 0 V 0 D 0 0
41069 222746 variant_image 53302 0 V 0 D 0 0
41070 222747 variant_image 53303 0 V 0 D 0 0
41071 222748 variant_image 53304 0 V 0 D 0 0
41072 222749 variant_image 53305 0 V 0 D 0 0
41073 222750 variant_image 53306 0 V 0 D 0 0
41074 222751 variant_image 53307 0 V 0 D 0 0
41075 222752 variant_image 53308 0 V 0 D 0 0
41076 222753 variant_image 53309 0 V 0 D 0 0
41077 222754 variant_image 53310 0 V 0 D 0 0
41078 222755 variant_image 53311 0 V 0 D 0 0
41083 222762 variant_image 53316 0 V 0 D 0 0
41084 222763 variant_image 53317 0 V 0 D 0 0
41088 222764 variant_image 53321 0 V 0 D 0 0
41089 222765 variant_image 53322 0 V 0 D 0 0
41090 222766 variant_image 53323 0 V 0 D 0 0
41091 222767 variant_image 53324 0 V 0 D 0 0
41092 222768 variant_image 53325 0 V 0 D 0 0
41093 222769 variant_image 53326 0 V 0 D 0 0
41094 222770 variant_image 53327 0 V 0 D 0 0
41095 222771 variant_image 53328 0 V 0 D 0 0
41096 222772 variant_image 53329 0 V 0 D 0 0
41097 222773 variant_image 53330 0 V 0 D 0 0
41098 222774 variant_image 53331 0 V 0 D 0 0
41099 222775 variant_image 53332 0 V 0 D 0 0
41100 222776 variant_image 53333 0 V 0 D 0 0
41101 222777 variant_image 53334 0 V 0 D 0 0
41102 222778 variant_image 53335 0 V 0 D 0 0
41103 222779 variant_image 53336 0 V 0 D 0 0
41104 222780 variant_image 53337 0 V 0 D 0 0
41105 222781 variant_image 53338 0 V 0 D 0 0
41106 222782 variant_image 53339 0 V 0 D 0 0
41107 222783 variant_image 53340 0 V 0 D 0 0
41108 222784 variant_image 53341 0 V 0 D 0 0
41109 222785 variant_image 53342 0 V 0 D 0 0
41110 222786 variant_image 53343 0 V 0 D 0 0
41111 222787 variant_image 53344 0 V 0 D 0 0
41112 222788 variant_image 53345 0 V 0 D 0 0
41113 222789 variant_image 53346 0 V 0 D 0 0
41114 222790 variant_image 53347 0 V 0 D 0 0
41115 222791 variant_image 53348 0 V 0 D 0 0
41116 222792 variant_image 53349 0 V 0 D 0 0
41117 222793 variant_image 53350 0 V 0 D 0 0
41118 222794 variant_image 53351 0 V 0 D 0 0
41119 222795 variant_image 53352 0 V 0 D 0 0
41120 222796 variant_image 53353 0 V 0 D 0 0
41121 222797 variant_image 53354 0 V 0 D 0 0
41122 222798 variant_image 53355 0 V 0 D 0 0
41123 222799 variant_image 53356 0 V 0 D 0 0
41124 222800 variant_image 53357 0 V 0 D 0 0
41125 222801 variant_image 53358 0 V 0 D 0 0
41126 222802 variant_image 53359 0 V 0 D 0 0
41127 222803 variant_image 53360 0 V 0 D 0 0
41128 222804 variant_image 53361 0 V 0 D 0 0
41129 222807 variant_image 53362 0 V 0 D 0 0
41130 222808 variant_image 53363 0 V 0 D 0 0
41131 222809 variant_image 53364 0 V 0 D 0 0
41132 222810 variant_image 53365 0 V 0 D 0 0
49159 230425 variant_image 61392 0 V 0 D 0 0
49160 230426 variant_image 61393 0 V 0 D 0 0
59782 237036 variant_image 72015 0 V 0 D 0 0
59783 237037 variant_image 72016 0 V 0 D 0 0
59993 237240 variant_image 72226 0 V 0 D 0 0
59994 237241 variant_image 72227 0 V 0 D 0 0
64928 239178 variant_image 77161 0 V 0 D 0 0
64929 239179 variant_image 77162 0 V 0 D 0 0
64930 239180 variant_image 77163 0 V 0 D 0 0
64931 239181 variant_image 77164 0 V 0 D 0 0
64932 239182 variant_image 77165 0 V 0 D 0 0
64933 239183 variant_image 77166 0 V 0 D 0 0
64934 239184 variant_image 77167 0 V 0 D 0 0
64935 239185 variant_image 77168 0 V 0 D 0 0
64936 239186 variant_image 77169 0 V 0 D 0 0
64937 239187 variant_image 77170 0 V 0 D 0 0
64938 239188 variant_image 77171 0 V 0 D 0 0
64939 239189 variant_image 77172 0 V 0 D 0 0
64940 239190 variant_image 77173 0 V 0 D 0 0
64941 239191 variant_image 77174 0 V 0 D 0 0
64942 239192 variant_image 77175 0 V 0 D 0 0
64943 239193 variant_image 77176 0 V 0 D 0 0
64944 239194 variant_image 77177 0 V 0 D 0 0
64945 239195 variant_image 77178 0 V 0 D 0 0
64946 239196 variant_image 77179 0 V 0 D 0 0
64947 239197 variant_image 77180 0 V 0 D 0 0
64948 239198 variant_image 77181 0 V 0 D 0 0
64949 239199 variant_image 77182 0 V 0 D 0 0
64950 239200 variant_image 77183 0 V 0 D 0 0
64951 239201 variant_image 77184 0 V 0 D 0 0
64952 239202 variant_image 77185 0 V 0 D 0 0
64955 239205 variant_image 77188 0 V 0 D 0 0
64956 239206 variant_image 77189 0 V 0 D 0 0
64957 239208 variant_image 77190 0 V 0 D 0 0
64958 239209 variant_image 77191 0 V 0 D 0 0
64959 239210 variant_image 77192 0 V 0 D 0 0
64960 239211 variant_image 77193 0 V 0 D 0 0
64961 239212 variant_image 77194 0 V 0 D 0 0
64962 239213 variant_image 77195 0 V 0 D 0 0
64963 239214 variant_image 77196 0 V 0 D 0 0
64964 239215 variant_image 77197 0 V 0 D 0 0
64965 239216 variant_image 77198 0 V 0 D 0 0
64966 239217 variant_image 77199 0 V 0 D 0 0
64967 239218 variant_image 77200 0 V 0 D 0 0
64968 239219 variant_image 77201 0 V 0 D 0 0
64969 239220 variant_image 77202 0 V 0 D 0 0
64970 239221 variant_image 77203 0 V 0 D 0 0
64971 239222 variant_image 77204 0 V 0 D 0 0
64972 239223 variant_image 77205 0 V 0 D 0 0
64973 239224 variant_image 77206 0 V 0 D 0 0
64974 239225 variant_image 77207 0 V 0 D 0 0
64975 239226 variant_image 77208 0 V 0 D 0 0
64976 239227 variant_image 77209 0 V 0 D 0 0
64977 239228 variant_image 77210 0 V 0 D 0 0
64978 239229 variant_image 77211 0 V 0 D 0 0
64979 239230 variant_image 77212 0 V 0 D 0 0
64980 239231 variant_image 77213 0 V 0 D 0 0
64981 239232 variant_image 77214 0 V 0 D 0 0
64982 239233 variant_image 77215 0 V 0 D 0 0
64983 239234 variant_image 77216 0 V 0 D 0 0
64986 239238 variant_image 77219 0 V 0 D 0 0
64987 239239 variant_image 77220 0 V 0 D 0 0
70676 241141 variant_image 82909 0 V 0 D 0 0
70677 241142 variant_image 82910 0 V 0 D 0 0
70678 241143 variant_image 82911 0 V 0 D 0 0
70679 241144 variant_image 82912 0 V 0 D 0 0
70680 241145 variant_image 82913 0 V 0 D 0 0
71254 241700 variant_image 83487 0 V 0 D 0 0
71255 241701 variant_image 83488 0 V 0 D 0 0
71256 241702 variant_image 83489 0 V 0 D 0 0
71257 241703 variant_image 83490 0 V 0 D 0 0
71258 241704 variant_image 83491 0 V 0 D 0 0
71290 241736 variant_image 83523 0 V 0 D 0 0
71291 241737 variant_image 83524 0 V 0 D 0 0
71292 241738 variant_image 83525 0 V 0 D 0 0
71293 241739 variant_image 83526 0 V 0 D 0 0
71294 241740 variant_image 83527 0 V 0 D 0 0
71295 241741 variant_image 83528 0 V 0 D 0 0
71296 241742 variant_image 83529 0 V 0 D 0 0
71297 241743 variant_image 83530 0 V 0 D 0 0
71298 241744 variant_image 83531 0 V 0 D 0 0
71299 241745 variant_image 83532 0 V 0 D 0 0
71300 241746 variant_image 83533 0 V 0 D 0 0
71301 241747 variant_image 83534 0 V 0 D 0 0
71302 241748 variant_image 83535 0 V 0 D 0 0
71303 241749 variant_image 83536 0 V 0 D 0 0
71304 241750 variant_image 83537 0 V 0 D 0 0
71698 242135 variant_image 83931 0 V 0 D 0 0
71699 242136 variant_image 83932 0 V 0 D 0 0
71700 242137 variant_image 83933 0 V 0 D 0 0
71701 242138 variant_image 83934 0 V 0 D 0 0
72517 242908 variant_image 84750 0 V 0 D 0 0
72518 242909 variant_image 84751 0 V 0 D 0 0
72519 242910 variant_image 84752 0 V 0 D 0 0
72520 242911 variant_image 84753 0 V 0 D 0 0
72521 242912 variant_image 84754 0 V 0 D 0 0
72522 242913 variant_image 84755 0 V 0 D 0 0
72523 242914 variant_image 84756 0 V 0 D 0 0
72524 242915 variant_image 84757 0 V 0 D 0 0
72525 242916 variant_image 84758 0 V 0 D 0 0
72526 242917 variant_image 84759 0 V 0 D 0 0
72527 242918 variant_image 84760 0 V 0 D 0 0
72528 242919 variant_image 84761 0 V 0 D 0 0
72641 242997 variant_image 84874 0 V 0 D 0 0
72807 243091 variant_image 85040 0 V 0 D 0 0
72808 243092 variant_image 85041 0 V 0 D 0 0
72809 243093 variant_image 85042 0 V 0 D 0 0
72810 243094 variant_image 85043 0 V 0 D 0 0