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.image_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 (
    220319, 219225, 219227, 242997, 219229, 
    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
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00115

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": 68,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220319,219225,219227,242997,219229,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)"
        }
      }
    },
    "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.image_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.image_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
37889 219227 variant_image 50122 0 V 0 D 0 0 R1-2-Small-LED-bulbs-ST19-Clear-Spiral-250-Lumens-2100K-on-GreenCreative.jpg LED Clear ST19 300 300 50122
37891 219229 variant_image 50124 0 V 0 D 0 0 R1-4-Small-LED-bulbs-ST19-Smoky-Spiral-150-Lumens-4000K-on-GreenCreative_erg9-mz.jpg LED Smoky ST19 300 300 50124
38008 219225 variant_image 50241 0 V 0 D 0 0 bulb-edison-r1-1-small-none.jpg None 300 300 50241
41037 222712 variant_image 53270 0 V 0 D 0 0 cord-standard-black.jpg Standard Black 300 300 53270
41038 222713 variant_image 53271 0 V 0 D 0 0 cord-standard-white.jpg Standard White 300 300 53271
41039 222714 variant_image 53272 0 V 0 D 0 0 cord-black-cloth.jpg Black Cloth 300 300 53272
41040 222715 variant_image 53273 0 V 0 D 0 0 cord-silver-cloth.jpg Silver Cloth 300 300 53273
41041 222716 variant_image 53274 0 V 0 D 0 0 cord-creme-cloth.jpg Creme Cloth 300 300 53274
41042 222717 variant_image 53275 0 V 0 D 0 0 cord-blush-pink-cloth.jpg Blush Pink Cloth 300 300 53275
41043 222718 variant_image 53276 0 V 0 D 0 0 cord-confetti-cloth.jpg Confetti Cloth 300 300 53276
41044 222719 variant_image 53277 0 V 0 D 0 0 cord-rust-cloth.jpg Rust Cloth 300 300 53277
41045 222720 variant_image 53278 0 V 0 D 0 0 cord-barn-red-swirl.jpg Barn Red & Black Swirl Cloth 300 300 53278
41046 222721 variant_image 53279 0 V 0 D 0 0 cord-orange-cloth.jpg Orange Cloth 300 300 53279
41047 222722 variant_image 53280 0 V 0 D 0 0 cord-buttery-yellow-cloth.jpg Buttery Yellow Cloth 300 300 53280
41048 222723 variant_image 53281 0 V 0 D 0 0 cord-neon-green-cloth.jpg Neon Green Cloth 300 300 53281
41049 222724 variant_image 53282 0 V 0 D 0 0 cord-emerald-green-cloth.jpg Emerald Green Cloth 300 300 53282
41050 222725 variant_image 53283 0 V 0 D 0 0 cord-fern-green-chevron.jpg Fern Green Chevron Cloth 300 300 53283
41051 222728 variant_image 53284 0 V 0 D 0 0 mounting-accessory-plug-in-black-alt.jpg Black 300 300 53284
41052 222729 variant_image 53285 0 V 0 D 0 0 mounting-accessory-plug-in-white-alt.jpg White 300 300 53285
41053 222730 variant_image 53286 0 V 0 D 0 0 finish-pc-100-black_4cgx-j8.jpg Black 300 300 53286
41054 222731 variant_image 53287 0 V 0 D 0 0 finish-pc-105-textured-black_3zmq-50.jpg Textured Black 300 300 53287
41055 222732 variant_image 53288 0 V 0 D 0 0 finish-pc-200-white_nn7z-sz.jpg White 300 300 53288
41056 222733 variant_image 53289 0 V 0 D 0 0 finish-pc-300-dark-green_d4yt-hf.jpg Dark Green 300 300 53289
41057 222734 variant_image 53290 0 V 0 D 0 0 finish-pc-307-emerald-green_64qs-vw.jpg Emerald Green 300 300 53290
41058 222735 variant_image 53291 0 V 0 D 0 0 finish-pc-370-mint_ue1x-sj.jpg Mint 300 300 53291
41059 222736 variant_image 53292 0 V 0 D 0 0 finish-pc-380-chartreuse_ktt7-9l.jpg Chartreuse 300 300 53292
41060 222737 variant_image 53293 0 V 0 D 0 0 finish-pc-390-teal_wml3-06.jpg Teal 300 300 53293
41061 222738 variant_image 53294 0 V 0 D 0 0 finish-pc-400-barn-red_1p18-n2.jpg Barn Red 300 300 53294
41062 222739 variant_image 53295 0 V 0 D 0 0 finish-pc-420-orange_zt7q-l2.jpg Orange 300 300 53295
41063 222740 variant_image 53296 0 V 0 D 0 0 finish-pc-470-watermelon_mdk6-d2.jpg Watermelon 300 300 53296
41064 222741 variant_image 53297 0 V 0 D 0 0 finish-pc-480-blush-pink_icyy-an.jpg Blush Pink 300 300 53297
41065 222742 variant_image 53298 0 V 0 D 0 0 finish-pc-490-magenta_wndu-um.jpg Magenta 300 300 53298
41066 222743 variant_image 53299 0 V 0 D 0 0 finish-pc-495-sherbet-orange_mhkb-9n.jpg Sherbet Orange 300 300 53299
41067 222744 variant_image 53300 0 V 0 D 0 0 finish-pc-500-buttery-yellow_8shr-tr.jpg Buttery Yellow 300 300 53300
41068 222745 variant_image 53301 0 V 0 D 0 0 finish-pc-570-sunflower_5hrq-o4.jpg Sunflower 300 300 53301
41069 222746 variant_image 53302 0 V 0 D 0 0 finish-pc-600-bronze_t6hr-5s.jpg Bronze 300 300 53302
41070 222747 variant_image 53303 0 V 0 D 0 0 finish-pc-601-chocolate_j26a-a0.jpg Chocolate 300 300 53303
41071 222748 variant_image 53304 0 V 0 D 0 0 finish-pc-605-textured-rust_pirz-lb.jpg Textured Rust 300 300 53304
41072 222749 variant_image 53305 0 V 0 D 0 0 finish-pc-615-textured-bronze_qpq4-ek.jpg Oil-Rubbed Bronze 300 300 53305
41073 222750 variant_image 53306 0 V 0 D 0 0 finish-pc-700-royal-blue_fnad-0b.jpg Royal Blue 300 300 53306
41074 222751 variant_image 53307 0 V 0 D 0 0 finish-pc-705-navy-blue_21w7-vc.jpg Navy 300 300 53307
41075 222752 variant_image 53308 0 V 0 D 0 0 finish-pc-790-lavender_1y77-it.jpg Lavender 300 300 53308
41076 222753 variant_image 53309 0 V 0 D 0 0 finish-pc-800-industrial-grey_1sfq-gt.jpg Industrial Grey 300 300 53309
41077 222754 variant_image 53310 0 V 0 D 0 0 finish-pc-805-charcoal-granite_8ekr-nm.jpg Charcoal Granite 300 300 53310
41078 222755 variant_image 53311 0 V 0 D 0 0 finish-pc-975-galvanized_1zuh-zu.jpg Galvanized 300 300 53311
41083 222762 variant_image 53316 0 V 0 D 0 0 finish-pc-975-galvanized_rneh-2w.jpg Galvanized 300 300 53316
41084 222763 variant_image 53317 0 V 0 D 0 0 finish-997-brass-raw.jpg Raw Brass 300 300 53317
59993 237240 variant_image 72226 0 V 0 D 0 0 finish-pc-106-Matte-Black_5wta-v5.jpg Matte Black 300 300 72226
59994 237241 variant_image 72227 0 V 0 D 0 0 finish-pc-206-Matte-White_amhw-ik.jpg Matte White 300 300 72227
71254 241700 variant_image 83487 0 V 0 D 0 0 finish-pc-320-Fern-Green_8rm3-mc.jpg Fern Green 300 300 83487
71255 241701 variant_image 83488 0 V 0 D 0 0 finish-pc-430-Soft-Clay_v8z0-qh.jpg Soft Clay 300 300 83488
71256 241702 variant_image 83489 0 V 0 D 0 0 finish-pc-607-Taupe_5238-3e.jpg Taupe 300 300 83489
71257 241703 variant_image 83490 0 V 0 D 0 0 finish-pc-630-Beige_mez2-02.jpg Beige 300 300 83490
71258 241704 variant_image 83491 0 V 0 D 0 0 finish-pc-815-Light-Grey_yetf-6g.jpg Light Grey 300 300 83491
72525 242916 variant_image 84758 0 V 0 D 0 0 finish-pc-311-jadite_70km-b2.jpg Jadite 300 300 84758
72526 242917 variant_image 84759 0 V 0 D 0 0 finish-pc-710-cobalt-blue_o70x-hx.jpg Cobalt Blue 300 300 84759
72527 242918 variant_image 84760 0 V 0 D 0 0 finish-pc-715-delphite_prfe-20.jpg Delphite Blue 300 300 84760
72528 242919 variant_image 84761 0 V 0 D 0 0 finish-pc-810-graphite_3ceo-ew.jpg Graphite 300 300 84761
72641 242997 variant_image 84874 0 V 0 D 0 0 R1-3-Small-LED-bulbs-ST19-Amber-Spiral-250-Lumens-2000K-on-GreenCreative_eevf-ik.jpg LED Amber ST19 300 300 84874
72807 243091 variant_image 85040 0 V 0 D 0 0 cord-seafoam-cloth_fyy8-73.jpg Seafoam Cloth 300 300 85040
72808 243092 variant_image 85041 0 V 0 D 0 0 cord-sky-blue-cloth_02rw-56.jpg Sky Blue Cloth 300 300 85041
72809 243093 variant_image 85042 0 V 0 D 0 0 cord-royal-blue-cloth_kbeg-cn.jpg Royal Blue Cloth 300 300 85042
72810 243094 variant_image 85043 0 V 0 D 0 0 cord-navy-cloth_qhn5-ub.jpg Navy Cloth 300 300 85043