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 (
    218115, 218116, 218117, 220137, 217978, 
    217979, 217980, 217981, 217982, 217983, 
    237042, 237043, 217984, 242635, 241100, 
    217985, 217986, 217987, 217988, 217989, 
    241101, 217990, 217991, 217992, 217993, 
    217994, 217995, 217996, 217997, 241102, 
    217998, 241103, 217999, 218000, 242636, 
    242637, 218001, 218002, 218003, 242638, 
    241104, 218008, 218009, 218010, 218011, 
    218012, 220318, 215376, 215377
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00155

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": 49,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (218115,218116,218117,220137,217978,217979,217980,217981,217982,217983,237042,237043,217984,242635,241100,217985,217986,217987,217988,217989,241101,217990,217991,217992,217993,217994,217995,217996,217997,241102,217998,241103,217999,218000,242636,242637,218001,218002,218003,242638,241104,218008,218009,218010,218011,218012,220318,215376,215377)"
        }
      }
    },
    "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
33339 215376 variant_image 45572 0 V 0 D 0 0 socket-standard-e26.jpg Standard Bulb/E26 300 300 45572
33340 215377 variant_image 45573 0 V 0 D 0 0 socket-bi-pin-gu24.jpg GU24 Bi-Pin Socket 300 300 45573
36374 217978 variant_image 48607 0 V 0 D 0 0 finish-pc-100-black_h4rz-l8.jpg Black 300 300 48607
36375 217979 variant_image 48608 0 V 0 D 0 0 finish-pc-105-textured-black.jpg Textured Black 300 300 48608
36376 217980 variant_image 48609 0 V 0 D 0 0 finish-pc-200-white.jpg White 300 300 48609
36377 217981 variant_image 48610 0 V 0 D 0 0 finish-pc-300-dark-green.jpg Dark Green 300 300 48610
36378 217982 variant_image 48611 0 V 0 D 0 0 finish-pc-975-galvanized.jpg Galvanized 300 300 48611
36379 217983 variant_image 48612 0 V 0 D 0 0 finish-pc-605-textured-rust.jpg Textured Rust 300 300 48612
36380 217984 variant_image 48613 0 V 0 D 0 0 finish-pc-307-emerald-green.jpg Emerald Green 300 300 48613
36381 217985 variant_image 48614 0 V 0 D 0 0 finish-pc-370-mint.jpg Mint 300 300 48614
36382 217986 variant_image 48615 0 V 0 D 0 0 finish-pc-380-chartreuse.jpg Chartreuse 300 300 48615
36383 217987 variant_image 48616 0 V 0 D 0 0 finish-pc-390-teal.jpg Teal 300 300 48616
36384 217988 variant_image 48617 0 V 0 D 0 0 finish-pc-400-barn-red.jpg Barn Red 300 300 48617
36385 217989 variant_image 48618 0 V 0 D 0 0 finish-pc-420-orange.jpg Orange 300 300 48618
36386 217990 variant_image 48619 0 V 0 D 0 0 finish-pc-470-watermelon.jpg Watermelon 300 300 48619
36387 217991 variant_image 48620 0 V 0 D 0 0 finish-pc-480-blush-pink.jpg Blush Pink 300 300 48620
36388 217992 variant_image 48621 0 V 0 D 0 0 finish-pc-490-magenta.jpg Magenta 300 300 48621
36389 217993 variant_image 48622 0 V 0 D 0 0 finish-pc-495-sherbet-orange.jpg Sherbet Orange 300 300 48622
36390 217994 variant_image 48623 0 V 0 D 0 0 finish-pc-500-buttery-yellow.jpg Buttery Yellow 300 300 48623
36391 217995 variant_image 48624 0 V 0 D 0 0 finish-pc-570-sunflower.jpg Sunflower 300 300 48624
36392 217996 variant_image 48625 0 V 0 D 0 0 finish-pc-600-bronze.jpg Bronze 300 300 48625
36393 217997 variant_image 48626 0 V 0 D 0 0 finish-pc-601-chocolate.jpg Chocolate 300 300 48626
36394 217998 variant_image 48627 0 V 0 D 0 0 finish-pc-615-textured-bronze_rrnr-v0.jpg Oil-Rubbed Bronze 300 300 48627
36395 217999 variant_image 48628 0 V 0 D 0 0 finish-pc-700-royal-blue.jpg Royal Blue 300 300 48628
36396 218000 variant_image 48629 0 V 0 D 0 0 finish-pc-705-navy-blue.jpg Navy 300 300 48629
36397 218001 variant_image 48630 0 V 0 D 0 0 finish-pc-790-lavender.jpg Lavender 300 300 48630
36398 218002 variant_image 48631 0 V 0 D 0 0 finish-pc-800-industrial-grey.jpg Industrial Grey 300 300 48631
36399 218003 variant_image 48632 0 V 0 D 0 0 finish-pc-805-charcoal-granite.jpg Charcoal Granite 300 300 48632
36404 218008 variant_image 48637 0 V 0 D 0 0 finish-995-raw-copper.jpg Raw Copper 300 300 48637
36405 218009 variant_image 48638 0 V 0 D 0 0 finish-996-copper-weathered.jpg Weathered Copper 300 300 48638
36406 218010 variant_image 48639 0 V 0 D 0 0 finish-999-copper-oil-rubbed-alt2.jpg Oil-Rubbed Copper 300 300 48639
36407 218011 variant_image 48640 0 V 0 D 0 0 finish-997-brass-raw_ngxa-1z.jpg Raw Brass 300 300 48640
36408 218012 variant_image 48641 0 V 0 D 0 0 finish-998-brass-weathered_nu8h-of.jpg Weathered Brass 300 300 48641
59789 237042 variant_image 72022 0 V 0 D 0 0 finish-pc-106-Matte-Black_2ojy-zd.jpg Matte Black 300 300 72022
59790 237043 variant_image 72023 0 V 0 D 0 0 finish-pc-206-Matte-White_1v83-pj.jpg Matte White 300 300 72023
70635 241100 variant_image 82868 0 V 0 D 0 0 finish-pc-320-Fern-Green_1pus-wh.jpg Fern Green 300 300 82868
70636 241101 variant_image 82869 0 V 0 D 0 0 finish-pc-430-Soft-Clay_5thm-7r.jpg Soft Clay 300 300 82869
70637 241102 variant_image 82870 0 V 0 D 0 0 finish-pc-607-Taupe_ck5s-3r.jpg Taupe 300 300 82870
70638 241103 variant_image 82871 0 V 0 D 0 0 finish-pc-630-Beige_tmz4-ja.jpg Beige 300 300 82871
70639 241104 variant_image 82872 0 V 0 D 0 0 finish-pc-815-Light-Grey_4khn-ab.jpg Light Grey 300 300 82872
72245 242635 variant_image 84478 0 V 0 D 0 0 finish-pc-311-jadite.jpg Jadite 300 300 84478
72246 242636 variant_image 84479 0 V 0 D 0 0 finish-pc-710-cobalt-blue.jpg Cobalt Blue 300 300 84479
72247 242637 variant_image 84480 0 V 0 D 0 0 finish-pc-715-delphite.jpg Delphite Blue 300 300 84480
72248 242638 variant_image 84481 0 V 0 D 0 0 finish-pc-810-graphite.jpg Graphite 300 300 84481