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 (63513, 64946, 64865, 64355) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00141

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": 55,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (63513,64946,64865,64355)"
        }
      }
    },
    "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
26495 63513 product 0 38662 A 0 D 0 0 downtown-wall-sconce-red-web2.jpg Downtown Minimalist Adjustable Sconce, 400-Barn Red, Nostalgic Edison-Style 1890 Era Victorian 40W Bulb 600 600 38662
30513 64355 product 0 42745 A 0 D 0 0 downtown-swing-arm-sconce-plug-in-14-galvanized-black-gold-chevron-cord.jpg Downtown Swing Arm Sconce, 975-Galvanized, G66 Arm, Nostalgic Edison Style 1890 Era Bulb, CSBG-Black & Gold Cloth Cord 1000 1000 42745
30514 64355 product 0 42746 A 0 D 0 0 downtown-swing-arm-sconce-plug-in-20-red-red-white-cord.jpg Downtown Swing Arm Sconce, 400-Barn Red, G68 Arm, Nostalgic Edison Style 1890 Era Bulb, CSRW-Red & White Cloth Cord 1000 1000 42746
30515 64355 product 0 42747 A 0 D 0 0 downtown-swing-arm-sconce-plug-in-14-delphite-gold-white-cord-angle.jpg Downtown Swing Arm Sconce, 311-Jadite PTMP, G66 Arm, Nostalgic Edison Style 1890 Era Bulb, CSGW-Gold & White Cloth Cord 1000 1000 42747
30516 64355 product 0 42748 A 0 D 0 0 downtown-swing-arm-sconce-plug-in-swivel-14-chartreuse-black-white-cord-angle.jpg Downtown Swing Arm Sconce, 380-Chartreuse, G67 Arm 1000 1000 42748
49001 64946 product 0 61234 A 0 D 0 0 0-Timber-Ore-Downtown-Minimalist-Swing-Arm-Sconce-Ash-Black-LED-ST19-Bulb.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, 100-Black, G69 Arm, Ash Wood, Shown with LED ST19 Bulb 1000 1000 61234
49005 64865 product 0 61238 A 0 D 0 0 Timber-Ore-Downtown-Minimalist-Wooden-Socket-Sconce-Ash-White-LED-T10-Edison-Bulb.jpg Downtown Minimalist Wooden Socket Sconce, 200-White, Ash Wood, Shown with LED T10 Bulb 600 600 61238
49006 64865 product 0 61239 A 0 D 0 0 Timber-Ore-Downtown-Minimalist-Wooden-Socket-Sconce-Maple-Teal-40W-1910-Era-Edison-Bulb.jpg Downtown Minimalist Wooden Socket Sconce, 390-Teal, Maple Wood, Shown with Edison 1910 Era Bulb 600 600 61239
49007 64865 product 0 61240 A 0 D 0 0 Timber-Ore-Downtown-Minimalist-Wooden-Socket-Sconce-Walnut-Black-LED-ST19-Edison-Bulb.jpg Downtown Minimalist Wooden Socket Sconce, 100-Black, Walnut Wood, Shown with LED ST19 Edison Bulb 600 600 61240
49008 64865 product 0 61241 A 0 D 0 0 Timber-Ore-Downtown-Minimalist-Wooden-Socket-Sconce-Ash-Blush-Pink-Totem-III-Edison-Bulb.jpg Downtown Minimalist Wooden Socket Sconce, 380-Blush Pink, Ash Wood, Shown with Totem III Edison Lamp 600 600 61241
55508 64865 product 0 67741 A 0 C 0 0 RR-Early_Avery_Rafterhouse_light_deetail_two-alt.jpg Downtown Minimalist Wooden Socket Sconce, 100-Black, Walnut Wood | Photo Courtesy of Early Avery - Rafterhouse and Roehner+Ryan 1500 2000 67741
55515 64865 product 0 67748 A 0 C 0 0 RR-Early_Avery_Rafterhouse_kitchen_one_zy9a-zk-alt.jpg Downtown Minimalist Wooden Socket Sconce, 100-Black, Walnut Wood (Shown with Timber & Ore Collection Conoco Draftsman Pendant) | Photo Courtesy of Early Avery - Rafterhouse and Roehner+Ryan 1500 1125 67748
55516 64865 product 0 67749 A 0 C 0 0 RR-Early_Avery_Rafterhouse_hall_bath-alt.jpg Downtown Minimalist Wooden Socket Sconce, 100-Black, Walnut Wood | Photo Courtesy of Early Avery - Rafterhouse and Roehner+Ryan 1500 2000 67749
57389 64355 product 0 69622 A 0 C 0 0 Downtown_Minimalist_Swing_Arm_Plug-In_Wall_Sconce_-_Barn_Light_Electric_-_Modern_Lighting.jpg Downtown Swing Arm Plug-In Wall Sconce, 570-Sunflower, G67 Arm, TBB-Brown & Beige Chevron Twist | Photo Courtesy of Brownstone Boys (@brownstoneboys) 2048 1366 69622
59049 64355 product 0 71282 A 0 C 0 0 Downtown_Minimalist_Swing_Arm_Plug_In_Wall_Sconce_-_Barn_Light_Electric_-_Bedroom_Lighting.JPG Downtown Swing Arm Plug-In Wall Sconce, 570-Sunflower, G67 Arm, TBB-Brown & Beige Chevron Twist | Photo Courtesy of Brownstone Boys (@brownstoneboys) 3712 5568 71282
59050 64355 product 0 71283 A 0 C 0 0 Downtown_Minimalist_Swing_Arm_Plug_In_Wall_Sconce_-_Barn_Light_Electric_-_Bedroom_Side_Table_Lighting.JPG Downtown Swing Arm Plug-In Wall Sconce, 570-Sunflower, G67 Arm, TBB-Brown & Beige Chevron Twist | Photo Courtesy of Brownstone Boys (@brownstoneboys) 5568 3712 71283
59051 64355 product 0 71284 A 0 C 0 0 Downtown_Minimalist_Swing_Arm_Wall_Sconce_-_Barn_Light_Electric_-_Wall_Sconce_Bedroom_Lighting.JPG Downtown Swing Arm Plug-In Wall Sconce, 570-Sunflower, G67 Arm, TBB-Brown & Beige Chevron Twist | Photo Courtesy of Brownstone Boys (@brownstoneboys) 3712 5568 71284
59052 64355 product 0 71285 A 0 C 0 0 Downtown_Minimalist_Swing_Arm_Wall_Sconce_Plug_In_-_Barn_Light_Electric_-_Bedroom_Side_Table_Lighting.JPG Downtown Swing Arm Plug-In Wall Sconce, 570-Sunflower, G67 Arm, TBB-Brown & Beige Chevron Twist | Photo Courtesy of Brownstone Boys (@brownstoneboys) 5568 3712 71285
66340 64865 product 0 78573 A 0 C 0 0 Photo_Sep_20,_5_45_17_PM-residential-interior-lighting-on-Downtown-Minimalist-Wooden-Socket-Wall-Sconce-Oak-106-Matte-Black-Porcelain-II-LED-Bulb.jpg Downtown Minimalist Wooden Socket Wall Sconce, Oak, 106-Matte Black, LED Bulb | Photo Courtesy of John Colaneri 3024 4032 78573
66341 64865 product 0 78574 A 0 C 0 0 Photo_Sep_03,_1_56_54_PM-residential-interior-lighting-on-bathroom-vanity-Downtown-Minimalist-Wooden-Socket-Wall-Sconce-Oak-106-Matte-Black-Porcelain-II-LED-Bulb.jpg Downtown Minimalist Wooden Socket Wall Sconce, Oak, 106-Matte Black, LED Bulb | Photo Courtesy of John Colaneri 3024 4032 78574
66342 64865 product 0 78575 A 0 C 0 0 Photo_Sep_03,_1_57_08_PM-residential-interior-lighting-on-bathroom-vanity-Downtown-Minimalist-Wooden-Socket-Wall-Sconce-Oak-106-Matte-Black-Porcelain-II-LED-Bulb.jpg Downtown Minimalist Wooden Socket Wall Sconce, Oak, 106-Matte Black, LED Bulb | Photo Courtesy of John Colaneri 3024 4032 78575
67102 64865 product 0 79335 A 0 C 0 0 image-residential-interior-lighting-bathroom-vanity-Downtown-Minimalist-Wooden-Socket-Wall-Sconce-Ash-Wood-106-Matte-Black.jpg Downtown Minimalist Wooden Socket Wall Sconce, Ash Wood, 106-Matte Black | Customer Submission 3004 3420 79335
26499 63513 product 0 38666 A 1 D 0 0 downtown-wall-sconce-teal-web2.jpg Downtown Minimalist Adjustable Sconce, 390-Teal, Nostalgic Edison-Style 1890 Era 40W Bulb 600 600 38666
49002 64946 product 0 61235 A 1 D 0 0 0-Timber-Ore-Downtown-Minimalist-Swing-Arm-Sconce-Ash-Galvanized-Totem-III-Tala-Bulb.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, 975-Galvanized, G66 Arm, Ash Wood, Shown with Totem III Tala Lamp 1000 1000 61235
30080 63513 product 0 42303 A 2 D 0 0 downtown-wall-sconce-brass-weathered-web2.jpg Downtown Minimalist Adjustable Sconce, 998-Natural Weathered Brass, Nostalgic Edison-Style 1890 Era 40W Bulb 600 600 42303
49003 64946 product 0 61236 A 2 D 0 0 0-Timber-Ore-Downtown-Minimalist-Swing-Arm-Sconce-Walnut-Emerald-Green-Noma-Tala-Bulb.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, 370-Emerald Green, G68 Arm, Walnut Wood, Shown with Noma Tala Lamp 1000 1000 61236
26590 63513 product 0 38759 A 3 D 0 0 downtown-wall-sconce-black-web-angled2.jpg Downtown Minimalist Adjustable Sconce, 100-Black, Nostalgic Edison-Style 1890 Era Bulb, Adjusted 600 600 38759
49004 64946 product 0 61237 A 3 D 0 0 0-Timber-Ore-Downtown-Minimalist-Swing-Arm-Sconce-Maple-Delphite-G40-Clear-Bulb.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, 715-Delphite Blue, G69 Arm, Maple Wood, Shown with G40 Clear Bulb 1000 1000 61237
26501 63513 product 0 38668 A 4 D 0 0 downtown-wall-sconce-delphite-web2.jpg Downtown Minimalist Adjustable Sconce, 715-Delphite, Nostalgic Edison-Style 1890 Era 40W Bulb 600 600 38668
55501 64946 product 0 67734 A 4 C 0 0 RR-Early_Avery_Rafterhouse_guest_bed_industrial_grey.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, 800-Industrial Grey, G67 Arm, Walnut Wood | Photo Courtesy of Early Avery - Rafterhouse and Roehner+Ryan 1500 1125 67734
26496 63513 product 0 38663 A 5 D 0 0 downtown-wall-sconce-galvanized-web2.jpg Downtown Minimalist Adjustable Sconce, 975-Galvanized, Nostalgic Edison-Style 1890 Era 40W Bulb 600 600 38663
68655 64946 product 0 80888 A 5 C 0 0 Downtown_Minimalist_Wooden_Socket_Adjustable_Swing_Arm_Sconce_-_Barn_Light_Electric_-_Bedroom_Lighting-gallery.jpeg Downtown Minimalist Wooden Socket Swing Arm, 800-Industrial Grey, G69 Arm, Maple Wood | Photo Courtesy of Customer 1500 1500 80888
26500 63513 product 0 38667 A 6 D 0 0 downtown-wall-sconce-jadite-web2.jpg Downtown Minimalist Adjustable Sconce, 311-Jadite, Nostalgic Edison-Style 1890 Era Victorian 40W Bulb 600 600 38667
59199 64946 product 0 71432 A 6 C 0 0 Downtown_Minimalist_Wooden_Socket_Swing_Arm_Sconce_-_Barn_Light_Electric_-_Modern_Restaurant_Lighting.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, 400-Barn Red, G67 Arm, Ash Wood | Photo Courtesy of Customer 1684 1738 71432
32482 63513 product 0 44715 A 7 C 0 0 downtown_minimalist_adjust_sconce_blk3.jpg Downtown Minimalist Adjustable Sconce, 100-Black | Photo courtesy of homeowner and Jonathan Garza Photography 2402 3600 44715
60082 64946 product 0 72315 A 7 C 0 0 Downtown_Minimalist_Wooden_Socket_Swing_Arm_Wall_Sconce_-_100-_Black_Barn_Light_Electric_-_Bathroom_Lighting.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, 300-Dark Green, G66 Arm, Maple Wood | Photo Courtesy of Kelley Ash and Hovel Design Studio 1500 2107 72315
32481 63513 product 0 44714 A 8 C 0 0 downtown_minimalist_adjust_sconce_100_blk.jpg (2) Downtown Minimalist Adjustable Sconces, 100-Black | Photo courtesy of homeowner and Jonathan Garza Photography 1500 1001 44714
65535 64946 product 0 77768 A 8 C 0 0 image3-residential-interior-lighting-kitchen-shelves-Downtown-Minimalist-Wooden-Socket-Swing-Arm-Wall-Sconce-Ash-300-Dark-Green-G66arm.jpeg Downtown Minimalist Wooden Socket Swing Arm Wall Sconce, Ash, 300-Dark Green, G66 Arm | Photo Courtesy of Homeowner 1512 2016 77768
51661 63513 product 0 63894 A 9 C 0 0 Downtown-Minimalist-Wall-Sconce-Black-Bathroom-Farmhouse.png Downtown Minimalist Adjustable Sconce, 105-Textured Black, Nostalgic Edison 1890 Era Bulb | Courtesy of Christina's Adventures 523 784 63894
65901 64946 product 0 78134 A 9 C 0 0 residential-interior-kitchen-sink-lighting-Downtown-Minimalist-Wooden-Socket-Swing-Arm-Sconce-Oak-307-Emerald-Green-G67arm.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, Oak, 307-Emerald Green, G67 Arm | Customer Submission 1500 2000 78134
60776 63513 product 0 73009 A 10 C 0 0 Downtown_Minimalist_Adjustable_Wall_Sconce_-_100-Black_Barn_Light_Electric_-_Modern_Wall_Sconce_Lighting4.jpg Downtown Minimalist Adjustable Sconce, 100-Black | Photo Courtesy of Designs North West 1500 1781 73009
66291 64946 product 0 78524 A 10 C 0 0 residential-interior-lighting-on-bar-Downtown-Minimalist-Wooden-Socket-Swing-Arm-Sconce-Oak-106-Matte-Black-Oblo-LED-Bulb-G67arm.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, Oak, 106-Matte Black, LED Bulb, G67 Arm | Photo Courtesy of John Colenari 1500 2000 78524
30277 63513 product 0 42500 A 11 C 0 0 bathroom_lighting_sconces-682x1024-512x768.jpg (2) Downtown Minimalist Adjustable Sconces, 105-Textured Black, Nostalgic Edison 1890 Era Bulbs | Courtesy of Christina's Adventures 512 768 42500
66292 64946 product 0 78525 A 11 C 0 0 residential-interior-lighting-on-Downtown-Minimalist-Wooden-Socket-Swing-Arm-Sconce-Oak-106-Matte-Black-Oblo-LED-Bulb-G67arm.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, Oak, 106-Matte Black, LED Bulb, G67 Arm | Photo Courtesy of John Colenari 1500 2000 78525
60773 63513 product 0 73006 A 12 C 0 0 Downtown_Minimalist_Adjustable_Wall_Sconce_-_100-Black_Barn_Light_Electric_-_Modern_Wall_Sconce_Lighting.jpg Downtown Minimalist Adjustable Sconce, 100-Black | Photo Courtesy of Designs North West 1500 2250 73006
66344 64946 product 0 78577 A 12 C 0 0 residential-interior-lighting-on-living-room-Downtown-Minimalist-Wooden-Socket-Swing-Arm-Sconce-Oak-106-Matte-Black-Oblo-LED-Bulb-G69arm.jpg Downtown Minimalist Wooden Socket Swing Arm Sconce, Oak, 106-Matte Black, LED Bulb, G69 Arm | Photo Courtesy of John Colaneri 1500 1662 78577
30276 63513 product 0 42499 A 13 C 0 0 wall_sconce_lighting-683x1024-512x768.jpg Downtown Minimalist Adjustable Sconce, 105-Textured Black, Nostalgic Edison 1890 Era Bulb | Courtesy of Christina's Adventures 512 768 42499
30081 63513 product 0 42304 A 14 C 0 0 brass_wall_sconce_light-512x768.jpg Downtown Minimalist Adjustable Sconce, 997-Raw Brass | Customer Submission 512 768 42304
33281 63513 product 0 45514 A 15 C 0 0 brass_wall_lights-512x768.jpg Downtown Minimalist Adjustable Sconce, 997-Raw Brass | Customer Submission 512 768 45514
51660 63513 product 0 63893 A 16 C 0 0 Downtown-Minimalist-Adjustable-Sconce-Black-6W-2200k-Elva-Tala-Bulb4.jpg Downtown Minimalist Adjustable Sconce, 100-Black | Shown with Elva Tala Bulb 1000 1000 63893
60774 63513 product 0 73007 A 17 C 0 0 Downtown_Minimalist_Adjustable_Wall_Sconce_-_Barn_Light_Electric_-_Modern_Wall_Sconce_Lighting2.jpg Downtown Minimalist Adjustable Sconce, 100-Black | Photo Courtesy of Designs North West 3280 3700 73007
60775 63513 product 0 73008 A 18 C 0 0 Downtown_Minimalist_Adjustable_Wall_Sconce_-_Barn_Light_Electric_-_Modern_Wall_Sconce_Lighting3.jpg Downtown Minimalist Adjustable Sconce, 100-Black | Photo Courtesy of Designs North West 3882 3656 73008
63842 63513 product 0 76075 A 19 D 0 0 residential-interior-lighting-hallway-stairway-Downtown-Minimalist-Adjustable-Wall-Sconce-975-Galvanized-Victorian-Edison-Bulbs.jpg Downtown Minimalist Adjustable Sconce, 975- Galvanized, Victorian Edison Bulbs | Photo Courtesy of Homeowner 1500 2105 76075
61172 63513 product 0 73405 A 20 C 0 0 Downtown_Minimalist_Adjustable_Wall_Sconce_615-ORB3.JPG Downtown Minimalist Adjustable Sconce, 615-Oil-Rubbed Bronze | Photo Courtesy of Weston & Co Home Decor 1200 1600 73405
61171 63513 product 0 73404 A 21 C 0 0 Downtown_Minimalist_Adjustable_Wall_Sconce_-_Black_Barn_Light_Electric_-_Kitchen_Lighting.jpg Downtown Minimalist Adjustable Sconce, 615-Oil-Rubbed Bronze | Photo Courtesy of Weston & Co Home Decor 1500 2000 73404