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, 
    220144, 
    215513, 
    215516, 
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    229164, 
    229165, 
    229166, 
    237859, 
    237829, 
    237830, 
    237831, 
    237832, 
    237833, 
    237834, 
    237860, 
    237861, 
    237835, 
    237855, 
    241488, 
    237836, 
    237837, 
    237838, 
    237839, 
    237840, 
    241489, 
    237841, 
    237842, 
    237843, 
    237844, 
    237845, 
    237846, 
    237847, 
    237848, 
    241490, 
    237849, 
    241491, 
    237850, 
    237851, 
    237857, 
    237852, 
    237853, 
    237854, 
    241492, 
    237892, 
    237862, 
    237863, 
    237864, 
    237865, 
    237866, 
    237867, 
    237893, 
    237894, 
    237868, 
    237888, 
    241493, 
    237869, 
    237870, 
    237871, 
    237872, 
    237873, 
    241494, 
    237874, 
    237875, 
    237876, 
    237877, 
    237878, 
    237879, 
    237880, 
    237881, 
    241495, 
    237882, 
    241496, 
    237883, 
    237884, 
    237890, 
    237885, 
    237886, 
    237887, 
    241497, 
    237901, 
    237895, 
    237896, 
    237897, 
    237905, 
    237902, 
    237903, 
    237904, 
    237936, 
    237906, 
    237907, 
    237908, 
    237909, 
    237910, 
    237911, 
    237937, 
    237938, 
    237912, 
    237932, 
    241655, 
    237913, 
    237914, 
    237915, 
    237916, 
    237917, 
    241656, 
    237918, 
    237919, 
    237920, 
    237921, 
    237922, 
    237923, 
    237924, 
    237925, 
    241657, 
    237926, 
    241658, 
    237927, 
    237928, 
    237934, 
    237929, 
    237930, 
    237931, 
    241659, 
    238002, 
    237972, 
    237973, 
    237974, 
    237975, 
    237976, 
    237977, 
    238003, 
    238004, 
    237978, 
    237998, 
    241650, 
    237979, 
    237980, 
    237981, 
    237982, 
    237983, 
    241651, 
    237984, 
    237985, 
    237986, 
    237987, 
    237988, 
    237989, 
    237990, 
    237991, 
    241652, 
    237992, 
    241653, 
    237993, 
    237994, 
    238000, 
    237995, 
    237996, 
    237997, 
    241654
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00256

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": 215,
          "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,220144,215513,215516,220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,229164,229165,229166,237859,237829,237830,237831,237832,237833,237834,237860,237861,237835,237855,241488,237836,237837,237838,237839,237840,241489,237841,237842,237843,237844,237845,237846,237847,237848,241490,237849,241491,237850,237851,237857,237852,237853,237854,241492,237892,237862,237863,237864,237865,237866,237867,237893,237894,237868,237888,241493,237869,237870,237871,237872,237873,241494,237874,237875,237876,237877,237878,237879,237880,237881,241495,237882,241496,237883,237884,237890,237885,237886,237887,241497,237901,237895,237896,237897,237905,237902,237903,237904,237936,237906,237907,237908,237909,237910,237911,237937,237938,237912,237932,241655,237913,237914,237915,237916,237917,241656,237918,237919,237920,237921,237922,237923,237924,237925,241657,237926,241658,237927,237928,237934,237929,237930,237931,241659,238002,237972,237973,237974,237975,237976,237977,238003,238004,237978,237998,241650,237979,237980,237981,237982,237983,241651,237984,237985,237986,237987,237988,237989,237990,237991,241652,237992,241653,237993,237994,238000,237995,237996,237997,241654)"
        }
      }
    },
    "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
33513 215556 variant_image 45746 0 V 0 D 0 0
33514 215557 variant_image 45747 0 V 0 D 0 0
33515 215558 variant_image 45748 0 V 0 D 0 0
33516 215559 variant_image 45749 0 V 0 D 0 0
33517 215560 variant_image 45750 0 V 0 D 0 0
33518 215561 variant_image 45751 0 V 0 D 0 0
33519 215562 variant_image 45752 0 V 0 D 0 0
33520 215563 variant_image 45753 0 V 0 D 0 0
33521 215564 variant_image 45754 0 V 0 D 0 0
33522 215565 variant_image 45755 0 V 0 D 0 0
33523 215566 variant_image 45756 0 V 0 D 0 0
33524 215567 variant_image 45757 0 V 0 D 0 0
33525 215568 variant_image 45758 0 V 0 D 0 0
33526 215569 variant_image 45759 0 V 0 D 0 0
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
59782 237036 variant_image 72015 0 V 0 D 0 0
59783 237037 variant_image 72016 0 V 0 D 0 0
60995 237829 variant_image 73228 0 V 0 D 0 0
60996 237830 variant_image 73229 0 V 0 D 0 0
60997 237831 variant_image 73230 0 V 0 D 0 0
60998 237832 variant_image 73231 0 V 0 D 0 0
60999 237833 variant_image 73232 0 V 0 D 0 0
61000 237834 variant_image 73233 0 V 0 D 0 0
61001 237835 variant_image 73234 0 V 0 D 0 0
61002 237836 variant_image 73235 0 V 0 D 0 0
61003 237837 variant_image 73236 0 V 0 D 0 0
61004 237838 variant_image 73237 0 V 0 D 0 0
61005 237839 variant_image 73238 0 V 0 D 0 0
61006 237840 variant_image 73239 0 V 0 D 0 0
61007 237841 variant_image 73240 0 V 0 D 0 0
61008 237842 variant_image 73241 0 V 0 D 0 0
61009 237843 variant_image 73242 0 V 0 D 0 0
61010 237844 variant_image 73243 0 V 0 D 0 0
61011 237845 variant_image 73244 0 V 0 D 0 0
61012 237846 variant_image 73245 0 V 0 D 0 0
61013 237847 variant_image 73246 0 V 0 D 0 0
61014 237848 variant_image 73247 0 V 0 D 0 0
61015 237849 variant_image 73248 0 V 0 D 0 0
61016 237850 variant_image 73249 0 V 0 D 0 0
61017 237851 variant_image 73250 0 V 0 D 0 0
61018 237852 variant_image 73251 0 V 0 D 0 0
61019 237853 variant_image 73252 0 V 0 D 0 0
61020 237854 variant_image 73253 0 V 0 D 0 0
61021 237855 variant_image 73254 0 V 0 D 0 0
61023 237857 variant_image 73256 0 V 0 D 0 0
61025 237860 variant_image 73258 0 V 0 D 0 0
61026 237861 variant_image 73259 0 V 0 D 0 0
61027 237862 variant_image 73260 0 V 0 D 0 0
61028 237863 variant_image 73261 0 V 0 D 0 0
61029 237864 variant_image 73262 0 V 0 D 0 0
61030 237865 variant_image 73263 0 V 0 D 0 0
61031 237866 variant_image 73264 0 V 0 D 0 0
61032 237867 variant_image 73265 0 V 0 D 0 0
61033 237868 variant_image 73266 0 V 0 D 0 0
61034 237869 variant_image 73267 0 V 0 D 0 0
61035 237870 variant_image 73268 0 V 0 D 0 0
61036 237871 variant_image 73269 0 V 0 D 0 0
61037 237872 variant_image 73270 0 V 0 D 0 0
61038 237873 variant_image 73271 0 V 0 D 0 0
61039 237874 variant_image 73272 0 V 0 D 0 0
61040 237875 variant_image 73273 0 V 0 D 0 0
61041 237876 variant_image 73274 0 V 0 D 0 0
61042 237877 variant_image 73275 0 V 0 D 0 0
61043 237878 variant_image 73276 0 V 0 D 0 0
61044 237879 variant_image 73277 0 V 0 D 0 0
61045 237880 variant_image 73278 0 V 0 D 0 0
61046 237881 variant_image 73279 0 V 0 D 0 0
61047 237882 variant_image 73280 0 V 0 D 0 0
61048 237883 variant_image 73281 0 V 0 D 0 0
61049 237884 variant_image 73282 0 V 0 D 0 0
61050 237885 variant_image 73283 0 V 0 D 0 0
61051 237886 variant_image 73284 0 V 0 D 0 0
61052 237887 variant_image 73285 0 V 0 D 0 0
61053 237888 variant_image 73286 0 V 0 D 0 0
61055 237890 variant_image 73288 0 V 0 D 0 0
61057 237893 variant_image 73290 0 V 0 D 0 0
61058 237894 variant_image 73291 0 V 0 D 0 0
61059 237895 variant_image 73292 0 V 0 D 0 0
61060 237896 variant_image 73293 0 V 0 D 0 0
61061 237897 variant_image 73294 0 V 0 D 0 0
61065 237902 variant_image 73298 0 V 0 D 0 0
61066 237903 variant_image 73299 0 V 0 D 0 0
61067 237904 variant_image 73300 0 V 0 D 0 0
61068 237906 variant_image 73301 0 V 0 D 0 0
61069 237907 variant_image 73302 0 V 0 D 0 0
61070 237908 variant_image 73303 0 V 0 D 0 0
61071 237909 variant_image 73304 0 V 0 D 0 0
61072 237910 variant_image 73305 0 V 0 D 0 0
61073 237911 variant_image 73306 0 V 0 D 0 0
61074 237912 variant_image 73307 0 V 0 D 0 0
61075 237913 variant_image 73308 0 V 0 D 0 0
61076 237914 variant_image 73309 0 V 0 D 0 0
61077 237915 variant_image 73310 0 V 0 D 0 0
61078 237916 variant_image 73311 0 V 0 D 0 0
61079 237917 variant_image 73312 0 V 0 D 0 0
61080 237918 variant_image 73313 0 V 0 D 0 0
61081 237919 variant_image 73314 0 V 0 D 0 0
61082 237920 variant_image 73315 0 V 0 D 0 0
61083 237921 variant_image 73316 0 V 0 D 0 0
61084 237922 variant_image 73317 0 V 0 D 0 0
61085 237923 variant_image 73318 0 V 0 D 0 0
61086 237924 variant_image 73319 0 V 0 D 0 0
61087 237925 variant_image 73320 0 V 0 D 0 0
61088 237926 variant_image 73321 0 V 0 D 0 0
61089 237927 variant_image 73322 0 V 0 D 0 0
61090 237928 variant_image 73323 0 V 0 D 0 0
61091 237929 variant_image 73324 0 V 0 D 0 0
61092 237930 variant_image 73325 0 V 0 D 0 0
61093 237931 variant_image 73326 0 V 0 D 0 0
61094 237932 variant_image 73327 0 V 0 D 0 0
61096 237934 variant_image 73329 0 V 0 D 0 0
61098 237937 variant_image 73331 0 V 0 D 0 0
61099 237938 variant_image 73332 0 V 0 D 0 0
61132 237972 variant_image 73365 0 V 0 D 0 0
61133 237973 variant_image 73366 0 V 0 D 0 0
61134 237974 variant_image 73367 0 V 0 D 0 0
61135 237975 variant_image 73368 0 V 0 D 0 0
61136 237976 variant_image 73369 0 V 0 D 0 0
61137 237977 variant_image 73370 0 V 0 D 0 0
61138 237978 variant_image 73371 0 V 0 D 0 0
61139 237979 variant_image 73372 0 V 0 D 0 0
61140 237980 variant_image 73373 0 V 0 D 0 0
61141 237981 variant_image 73374 0 V 0 D 0 0
61142 237982 variant_image 73375 0 V 0 D 0 0
61143 237983 variant_image 73376 0 V 0 D 0 0
61144 237984 variant_image 73377 0 V 0 D 0 0
61145 237985 variant_image 73378 0 V 0 D 0 0
61146 237986 variant_image 73379 0 V 0 D 0 0
61147 237987 variant_image 73380 0 V 0 D 0 0
61148 237988 variant_image 73381 0 V 0 D 0 0
61149 237989 variant_image 73382 0 V 0 D 0 0
61150 237990 variant_image 73383 0 V 0 D 0 0
61151 237991 variant_image 73384 0 V 0 D 0 0
61152 237992 variant_image 73385 0 V 0 D 0 0
61153 237993 variant_image 73386 0 V 0 D 0 0
61154 237994 variant_image 73387 0 V 0 D 0 0
61155 237995 variant_image 73388 0 V 0 D 0 0
61156 237996 variant_image 73389 0 V 0 D 0 0
61157 237997 variant_image 73390 0 V 0 D 0 0
61158 237998 variant_image 73391 0 V 0 D 0 0
61160 238000 variant_image 73393 0 V 0 D 0 0
61162 238003 variant_image 73395 0 V 0 D 0 0
61163 238004 variant_image 73396 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
71027 241488 variant_image 83260 0 V 0 D 0 0
71028 241489 variant_image 83261 0 V 0 D 0 0
71029 241490 variant_image 83262 0 V 0 D 0 0
71030 241491 variant_image 83263 0 V 0 D 0 0
71031 241492 variant_image 83264 0 V 0 D 0 0
71032 241493 variant_image 83265 0 V 0 D 0 0
71033 241494 variant_image 83266 0 V 0 D 0 0
71034 241495 variant_image 83267 0 V 0 D 0 0
71035 241496 variant_image 83268 0 V 0 D 0 0
71036 241497 variant_image 83269 0 V 0 D 0 0
71204 241650 variant_image 83437 0 V 0 D 0 0
71205 241651 variant_image 83438 0 V 0 D 0 0
71206 241652 variant_image 83439 0 V 0 D 0 0
71207 241653 variant_image 83440 0 V 0 D 0 0
71208 241654 variant_image 83441 0 V 0 D 0 0
71209 241655 variant_image 83442 0 V 0 D 0 0
71210 241656 variant_image 83443 0 V 0 D 0 0
71211 241657 variant_image 83444 0 V 0 D 0 0
71212 241658 variant_image 83445 0 V 0 D 0 0
71213 241659 variant_image 83446 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
72819 243103 variant_image 85052 0 V 0 D 0 0
72820 243104 variant_image 85053 0 V 0 D 0 0
72821 243105 variant_image 85054 0 V 0 D 0 0
72822 243106 variant_image 85055 0 V 0 D 0 0