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 = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (64963, 61937, 62979, 64350) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00125

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 = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64963,61937,62979,64350)"
        }
      }
    },
    "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
18798 61937 product 0 30477 A 0 D 0 0 Downtown-Pendant-delphite-BWCT.jpg Downtown Minimalist Cord Pendant, 715-Delphite Blue, TWB-Black & White Twist Cord | Nostalgic Edison 40 Watt G30 Light Bulb 600 600 30477
23683 62979 product 0 35611 A 0 D 0 0 KAO-white-canopy-downtown-minimalist-crz-teal.jpg Kao Downtown Minimalist Pendant, Cup in 390-Teal, CRZ-Red Chevron Cord, Canopy in 200-White, 60W G25 Half-Chrome Bulb 600 600 35611
30458 64350 product 0 42690 A 0 D 0 0 downtown-stem-mount-pendant-red.jpg Downtown Minimalist Stem Mount Pendant, 400-Barn Red, Edison-Style Victorian Bulb 1000 1000 42690
49661 64963 product 0 61894 A 0 D 0 0 Glass-Ball-Pendant-Stem-8inch-Black-Clear-Glass-120V-40W-Bulb.jpg 8" Glass Ball Stem Mount Pendant, Clear Glass, 100-Black, 40W 1910 Era Edison Bulb 1000 1000 61894
23681 62979 product 0 35609 A 1 D 0 0 KAO-jadeite-canopy-downtown-minimalist-crz-jadeite.jpg Kao Downtown Minimalist Pendant, Cup in 311-Jadite, CRZ-Red Chevron Cord, Canopy in 311-Jadite, Nostalgic Edison-Style 1890 Era 40W Light Bulb 600 600 35609
29944 61937 product 0 42167 A 1 D 0 0 minimalist-copper-g40-csbw.jpg Downtown Minimalist Copper Pendant, 995-Natural Raw Copper, CSBW-Black & White Cloth Cord, G40 Bulb 600 600 42167
53512 64963 product 0 65745 A 1 D 0 0 Glass-Ball-Pendant-Stem-16inch-Lavender-Opaque-Glass.jpg 16" Glass Ball Stem Mount Pendant, Opaque Glass, 790-Lavender 1000 1000 65745
71041 64350 product 0 83274 A 1 D 0 0 Downtown-Minimalist-Stem-Mount-Pendant-Raw-Brass-Tala-Bulb-6W-2700k-Porcelain-II.jpg Shown with Porcelain II Tala Lamp 1000 1000 83274
18796 61937 product 0 30475 A 2 D 0 0 Downtown-Pendant-burnt-orange.jpg Downtown Minimalist Cord Pendant, 420-Orange, SWH-Standard White Cord | Nostalgic Edison 40 Watt G30 Light Bulb 600 600 30475
23682 62979 product 0 35610 A 2 D 0 0 KAO-white-canopy-downtown-minimalist-swh-orange.jpg Kao Downtown Minimalist Pendant, Cup in 420-Orange, SWH-Standard White Cord, Canopy in 200-White, 40W G30 Edison Bulb 600 600 35610
30459 64350 product 0 42691 A 2 D 0 0 downtown-stem-mount-pendant-white.jpg Downtown Minimalist Stem Mount Pendant, 200-White, Edison-Style Victorian Bulb 1000 1000 42691
53513 64963 product 0 65746 A 2 D 0 0 Glass-Ball-Pendant-Stem-12inch-Barn-Red-Clear-Glass-120V-40W-Bulb.jpg 12" Glass Ball Stem Mount Pendant, Clear Glass, 400-Barn Red, 40W 1910 Era Edison Bulb 1000 1000 65746
25607 61937 product 0 37744 A 3 D 0 0 Downtown-Pendant-black.jpg Downtown Minimalist Cord Pendant, 100-Black, CSBW-Black & White Cloth Cord | Nostalgic Edison-Style 1890 Era 40 Watt Light Bulb 600 600 37744
32587 64350 product 0 44820 A 3 D 0 0 downtown-stem-mount-pendant-chartreuse.jpg Downtown Minimalist Stem Mount Pendant, 380-Chartreuse, Edison-Style Victorian Bulb 1000 1000 44820
33282 62979 product 0 45515 A 3 C 0 0 bare_bulb_pendant_lighting-512x768.jpeg Kao Downtown Minimalist Pendant, Cup in 997-Natural Raw Brass, CSGW-Gold & White Cloth Cord, , 40W G30 Edison Bulb 512 768 45515
53514 64963 product 0 65747 A 3 D 0 0 Glass-Ball-Pendant-Stem-8inch-Galvanized-Opaque-Glass.jpg 8" Glass Ball Stem Mount Pendant, Opaque Glass, 975-Galvanized 1000 1000 65747
30461 64350 product 0 42693 A 4 D 0 0 downtown-stem-mount-pendant-galvanized.jpg Downtown Minimalist Stem Mount Pendant, 975-Galvanized, Edison-Style Victorian Bulb 1000 1000 42693
32585 61937 product 0 44818 A 4 D 0 0 Downtown-Minimalist-Cord-Hung-Pendant-Navy-Black-White-Chevron-Cord-Tala-Bulb-3W-2200k-Lurra.jpg Downtown Minimalist Cord Pendant, 705-Navy, CSBW-Black & White Cloth Cord | Shown with Lurra Tala Lamp 600 600 44818
66841 64963 product 0 79074 A 4 C 0 0 image001-residential-interior-lighting-on-hallway-Glass-Ball-Stem-Mount-Pendant-12in-Clear-Glass-705-Navy-6in-stem.jpg 12" Glass Ball Stem Mount, Clear Glass, 705-Navy, 6" Stem | Customer Submission 471 558 79074
25609 61937 product 0 37746 A 5 D 0 0 Downtown-Pendant-barn_red.jpg Downtown Minimalist Cord Hung Pendant, 400-Barn Red, CRZ-Red Chevron Cord | Nostalgic Edison-Style 1890 Era 40 Watt Light Bulb 600 600 37746
30460 64350 product 0 42692 A 5 D 0 0 downtown-stem-mount-pendant-teal.jpg Downtown Minimalist Stem Mount Pendant, 390-Teal, Edison-Style Victorian Bulb 1000 1000 42692
64053 64963 product 0 76286 A 5 C 0 0 light01-residential-interior-lighting-kitchen-Glass-Ball-Stem-Mount-Pendant-12in-Opaque-495-Sherbet-Orange-6in-stem.png Glass Ball Stem Mount, Opaque Glass, 495-Sherbet Orange 2800 3539 76286
30457 64350 product 0 42689 A 6 D 0 0 downtown-stem-mount-pendant-brass.jpg Downtown Minimalist Stem Mount Pendant, 997-Raw Brass, Edison-Style Victorian Bulb 1000 1000 42689
32583 61937 product 0 44816 A 6 D 0 0 Downtown-Pendant-jadite.jpg Downtown Minimalist Cord Pendant, 311-Jadite, CRZ-Red Chevron Cord | Nostalgic Edision 1890 Era 40w Bulb 600 600 44816
53620 64963 product 0 65853 A 6 C 0 0 commercial-restaurant-interior-wine-bar-glass-ball-stem-pendant-weathered-brass-clear.jpg Glass Ball Stem Mount Pendants, Clear Glass, 998-Natural Weathered Brass 1200 1600 65853
18821 61937 product 0 30500 A 7 D 0 0 Downtown-minimalist-cord-Pendant-light-brass.jpg Downtown Minimalist Cord Pendant, 997-Natural Raw Brass, CSBW-Black & White Cloth Cord | Nostalgic Edision 1890 Era 40w Bulb 600 600 30500
32602 64350 product 0 44835 A 7 D 0 0 Downtown-Minimalist-Stem-Mount-Pendant-Galvanized-Tala-Bulb-3W-2200k-Voronoi-II.jpg Downtown Minimalist Stem Mount Pendant, 975-Galvanized | Shown with Voronoi II Tala Lamp 475 475 44835
53621 64963 product 0 65854 A 7 C 0 0 glass-globe-pendant-opaque-orange-kitchen-island.jpg 12" Glass Ball Stem Mount Pendants, Opaque Glass, 420-Orange 1300 856 65854
18800 61937 product 0 30479 A 8 D 0 0 Downtown-Pendant-buttery-yellow.jpg Downtown Minimalist Cord Pendant, 500-Buttery Yellow, SWH-Standard White Cord | Nostalgic Edison 40 Watt G30 Light Bulb 600 600 30479
30462 64350 product 0 42694 A 8 D 0 0 downtown-stem-mount-pendant-teal_ag8k-2s.jpg Downtown Minimalist Stem Mount Pendant, 390-Teal, Edison-Style Victorian Bulb 1000 1000 42694
66688 64963 product 0 78921 A 8 C 0 0 Image__2_-residential-interior-lighting-on-kitchen-island-Glass-Ball-Stem-Mount-Pendant-12in-Opaque-Glass-100-Black-36in-Stem.jpeg 12" Glass Ball Stem Mount, Opaque Glass, 100-Black, 36" Stem | Customer Submission 2863 3063 78921
30464 64350 product 0 42696 A 9 D 0 0 downtown-stem-mount-pendant-black.jpg Downtown Minimalist Stem Mount Pendant, 100-Black, Edison-Style Victorian Bulb 1000 1000 42696
32584 61937 product 0 44817 A 9 D 0 0 Downtown-Minimalist-Cord-Hung-Pendant-Barn-Red-Black-Red-White-Chevron-Cord-Tala-Bulb-6W-2700k-Oval.jpg Downtown Minimalist Cord Pendant, 400-Barn Red, CRZ-Red Chevron Cord | Shown with Oval Tala Lamp 600 600 44817
66689 64963 product 0 78922 A 9 C 0 0 Image__1_-residential-interior-lighting-on-kitchen-island-Glass-Ball-Stem-Mount-Pendant-12in-Opaque-Glass-100-Black-36in-Stem.jpeg 12" Glass Ball Stem Mount, Opaque Glass, 100-Black, 36" Stem | Customer Submission 3332 2358 78922
30463 64350 product 0 42695 A 10 D 0 0 downtown-stem-mount-pendant-dlephite.jpg Downtown Minimalist Stem Mount Pendant, 715-Delphite PTMP, Edison-Style Victorian Bulb 1000 1000 42695
61415 61937 product 0 73648 A 10 C 0 0 Downtown_Minimalist_Cord_Pendants_-_Barn_Light_Electric_-_Commercial_Apartment_Building_Mailroom.png Downtown Minimalist Cord Pendant, 995-Raw Copper, CSBW-Black & White Cloth Cord (Also pictured: Barn Light Mini Eclipse Wall Sconce) | Photo Courtesy of CID Design Group, (@cid_designgroup), Alta Purl and Laura Sumrak (@laurasumrak) 1400 2100 73648
58562 61937 product 0 70795 A 11 C 0 0 Downtown_Minimalist_Cord_Pendant_Light_-_100_Black_Barn_Light_Electric_-_Modern_Restaurant_Bar_Lighting.jpg Downtown Minimalist Cord Pendant, 705-Navy, CSGW-Gold & White Cloth Cord, Ceiling Canopy in 705-Navy, Voronoi II LED Tala Lamp Bulbs (Also Pictured: Laramie LED Wall Sconces in 975-Galvanized) | Photo Courtesy of IQ Designs 1500 1001 70795
47962 61937 product 0 60195 A 12 C 0 0 downtown-minimalist-805-charcoal-granite-2.jpg Downtown Minimalist Cord Pendant, 805-Charcoal Granite, CSBW-Black & White Cloth Cord | Photo Courtesy of John Holschuh Photography and Chook Chicken 1500 2250 60195
47963 61937 product 0 60196 A 13 C 0 0 downtown-minimalist-charcoal-granite.jpg (3) Downtown Minimalist Cord Pendant, 805-Charcoal Granite, CSBW-Baclk & White Cloth Cord | Photo Courtesy of John Holschuh Photography and Chook Chicken 1500 2250 60196
58561 61937 product 0 70794 A 14 C 0 0 Downtown_Minimalist_Pendant_Light_-_Barn_Light_Electric_-_Restaurant_Bar_Lighting.jpg Downtown Minimalist Cord Pendant, 705-Navy, CSGW-Gold & White Cloth Cord, Ceiling Canopy in 705-Navy, Voronoi II LED Tala Lamp Bulbs | Photo Courtesy of IQ Designs 1500 1001 70794
32615 61937 product 0 44848 A 15 C 0 0 downtown-minimalist-cord-copper-veroni-II.jpg Downtown Minimalist Cord Pendant, 995-Natural Raw Copper, CSB-Black Cloth Cord | Shown with Voronoi II Tala Lamp 1000 1000 44848
19156 61937 product 0 30868 A 16 C 0 0 354B9044-3.jpg Downtown Minimalist Cord Pendant, 311-Jadite PTMP, CRZ-Red Chevron Cord | White G40 Light Bulb | Shown with Enamelware Bowls and Plates in 355-Jadite 600 497 30868
21902 61937 product 0 33788 A 17 C 0 0 cord-pendant-brass-socket.jpg Downtown Minimalist Pendant for creative kitchen island lighting 736 1104 33788
25608 61937 product 0 37745 A 18 C 0 0 Downtown-Pendant-bundle.jpg Downtown Minimalist Cord Pendant 600 600 37745
18803 61937 product 0 30482 A 19 C 0 0 downtown-pendant-mantel.jpg Downtown Minimalist Cord Pendant (from left) 715-Delphite, 420-Orange, 311-Jadite, 500-Buttery Yellow 450 600 30482
58549 61937 product 0 70782 A 20 C 0 0 Downtown_Minimalist_Cord_Hung_Pendant_-_Barn_Light_Electric_-_Modern_Restaurant_Lighting.png Downtown Minimalist Cord Pendant, 311-PTMP Jadite, CRZ-Red Chevron Cord | Photo Courtesy of Sarah Giel Interiors 1480 1004 70782
58563 61937 product 0 70796 A 21 C 0 0 Laramie_LED_Wall_Sconce_14in_975-Galvanized_1250lumen_4000K_Flat_Lens_Downtown_Minimalist_Pendant_705-Navy_CSGW3.jpg Downtown Minimalist Cord Pendant, 705-Navy, CSGW-Gold & White Cloth Cord, Ceiling Canopy in 705-Navy, Voronoi II LED Tala Lamp Bulbs (Also Pictured: Laramie LED Wall Sconces in 975-Galvanized) | Photo Courtesy of IQ Designs 1500 1001 70796
18822 61937 product 0 30501 A 22 C 0 0 downtown-pentant-collage.jpg Downtown Minimalist Cord Pendant, Black Cup, CSB-Black Chevron Cord | Nostalgic Edision 1890 Era 40w Bulb 600 600 30501
18802 61937 product 0 30481 A 23 C 0 0 downtown-pendant--kitchen.jpg Downtown Minimalist Cord Pendant (from left) 311-Jadite, 150-Black, 715-Delphite Blue 600 403 30481