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 (63810, 64349, 64352, 63467) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00131

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": 44,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (63810,64349,64352,63467)"
        }
      }
    },
    "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
26273 63467 product 0 38436 A 0 D 0 0 Downtown-3-Light-Chandelier-Black-Victorian-Style-Edison-Bulb.jpg Downtown Minimalist 3-Light Chandelier, 100-Black, 12" Stem, 25W Victorian Style Edison Bulbs 1000 1000 38436
27411 63810 product 0 39588 A 0 D 0 0 Parson-5-Arm-Barn-Red-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 400-Barn Red, Nostalgic Edison 1890 Era Bulbs 1000 1000 39588
27413 63810 product 0 39590 A 0 D 0 0 Parson-5-Arm-Delphite-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 715-Delphite Blue PTMP, Nostalgic Edison 1890 Era Bulbs 1000 1000 39590
27414 63810 product 0 39591 A 0 D 0 0 Parson-5-Arm-Magenta-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 490-Magenta, Nostalgic Edison 1890 Era Bulbs 1000 1000 39591
30074 63810 product 0 42297 A 0 D 0 0 Parson-5-Arm-Brass-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 997-Natural Raw Brass, Nostalgic Edison 1890 Era Bulbs 1000 1000 42297
30154 63810 product 0 42377 A 0 D 0 0 Parson-5-Arm-Black-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 100-Black, Nostalgic Edison 1890 Era Bulbs 1000 1000 42377
30445 64352 product 0 42677 A 0 D 0 0 bubble-stem-mount-pendant-clear-mint.jpg Bubble Stem Mount Pendant, 370-Mint, Clear Globe 1000 1000 42677
30451 64349 product 0 42683 A 0 D 0 0 downtown-5-light-chandelier-mint.jpg Downtown Minimalist 5-Light Chandelier, 370-Mint, Edison-Style Victorian Bulbs 1000 1000 42683
30449 64352 product 0 42681 A 1 D 0 0 bubble-stem-mount-pendant-clear-galvanized.jpg Bubble Stem Mount Pendant, 975-Galvanized, Clear Globe 1000 1000 42681
67661 63467 product 0 79894 A 1 C 0 0 image4-residential-interior-lighting-Downtown-Minimalist-3-Light-Chandelier-975-Galvanized-12in-Stem.jpeg Downtown Minimalist 3-Light Chandelier, 975-Galvanized, 12" Stem | Customer Submission 3004 3246 79894
71039 64349 product 0 83272 A 1 D 0 0 downtown-5-light-chandelier-galvanized.jpg Downtown Minimalist 5-Light Chandelier, 975-Galvanized, Edison-Style Victorian Bulbs 1000 1000 83272
30078 63467 product 0 42301 A 2 C 0 0 The_Downtown_Minimalist_3-Light_Chandelier.jpg Downtown Minimalist 3-Light Chandelier, 997-Natural Raw Brass | Photo Courtesy of Homeowner 683 1024 42301
30446 64352 product 0 42678 A 2 D 0 0 bubble-stem-mount-pendant-opaque-sunflower.jpg Bubble Stem Mount Pendant, 570-Sunflower, White Globe 1000 1000 42678
30452 64349 product 0 42684 A 2 D 0 0 downtown-5-light-chandelier-blush-pink.jpg Downtown Minimalist 5-Light Chandelier, 480-Blush Pink, Edison-Style Victorian Bulbs 1000 1000 42684
30075 63467 product 0 42298 A 3 D 0 0 Downtown-3-Light-Chandelier-Galvanized-1890-Era-Edison-Bulb.jpg Downtown Minimalist 3-Light Chandelier, 975-Galvanized, 12" Stem, 40W 1890 Era Edison Bulbs 1000 1000 42298
30447 64352 product 0 42679 A 3 D 0 0 bubble-stem-mount-pendant-opaque-royal-blue.jpg Bubble Stem Mount, 700-Royal Blue, White Globe 1000 1000 42679
30453 64349 product 0 42685 A 3 D 0 0 downtown-5-light-chandelier-black.jpg Downtown Minimalist 5-Light Chandelier, 100-Black, Edison-Style Victorian Bulbs 1000 1000 42685
30448 64352 product 0 42680 A 4 D 0 0 bubble-stem-mount-pendant-clear-black.jpg Bubble Stem Mount Pendant, 100-Black, Clear Globe 1000 1000 42680
30454 64349 product 0 42686 A 4 D 0 0 downtown-5-light-chandelier-delphite.jpg Downtown Minimalist 5-Light Chandelier, 715-Delphite PTMP, Edison-Style Victorian Bulbs 1000 1000 42686
62897 63467 product 0 75130 A 4 C 0 0 image2-residential-interior-mudroom-hallway-lighting-downtown-minimalist-3-light-chandelier-495-sherbet-orange-24in-stem-Porcelain-II-LED-Tala-Lamp.jpeg Downtown Minimalist 3-Light Chandelier, 495-Sherbet Orange, 24" Stem, Porcelain II LED Tala Lamp | Photo Courtesy of Homeowner 1500 1943 75130
26279 63467 product 0 38442 A 5 D 0 0 Downtown-3-Light-Chandelier-Dark-Green-Victorian-Style-Edison-Bulb.jpg Downtown Minimalist 3-Light Chandelier, 300-Dark Green, 12" Stem, 25W Victorian Style Edison Bulbs 1000 1000 38442
65417 64352 product 0 77650 A 5 C 0 0 DSCF3075-commercial-interior-shop-ice-cream-parlour-bubble-stem-pendant-opaque-glass-370-mint-on.jpg Bubble Stem Mount Pendant Light, Opaque Glass, 370-Mint | Photography Courtesy of Haley Hill Photography 3980 5970 77650
26280 63467 product 0 38443 A 6 D 0 0 Downtown-3-Light-Chandelier-Navy-Victorian-Style-Edison-Bulb.jpg Downtown Minimalist 3-Light Chandelier, 705-Navy, 12" Stem, 25W Victorian Style Edison Bulbs 1000 1000 38443
30455 64349 product 0 42687 A 6 D 0 0 downtown-5-light-chandelier-white.jpg Downtown Minimalist 5-Light Chandelier, 200-White, Edison-Style Victorian Bulbs 1000 1000 42687
65418 64352 product 0 77651 A 6 C 0 0 IMG_3715-commercial-interior-shop-ice-cream-parlour-bubble-stem-pendant-opaque-glass-370-mint-on.jpg Bubble Stem Mount Pendant Light, Opaque Glass, 370-Mint | Photography Courtesy of Haley Hill Photography 6232 4155 77651
58531 64349 product 0 70764 A 7 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Modern_Interior_Lighting-alt.jpg Downtown Minimalist 5-Light Chandelier, 400-Barn Red, 12” Stem | Photo Courtesy of Tosnflies Photography 1500 2248 70764
58995 63467 product 0 71228 A 7 C 0 0 Downtown_Minimalist_3-Light_Chandelier_-_Barn_Light_Electric_-_Bedroom_Lighting.JPG Downtown Minimalist 3-Light Chandelier, 997-Natural Raw Brass | Photo Courtesy of Homeowner 2367 2367 71228
60920 64352 product 0 73153 A 7 C 0 0 Forme-Jan-20-JonAdrian-39-office-headquarters-front-desk-bubble-stem-pendant-clear-glass-on-100-black-web.jpg Bubble Stem Mount Pendant, 100-Black, CLR-Clear Glass | Photo Courtesy of Forme Interior Design Inc. and Jon Adrian Photography 1500 1000 73153
31855 63467 product 0 44088 A 8 C 0 0 Downtown_Minimalist_3-Light_Chandelier_Raw_Brass.jpg Downtown Minimalist 3-Light Chandelier, 997-Natural Raw Brass, 40W 1890 Era Edison Bulbs 3500 2334 44088
45308 64349 product 0 57541 A 8 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Modern_Dining_Room_Chandelier_Lighting-alt.jpg Downtown Minimalist 5-Light Chandelier, 200-White, Totem III LED Tala Lamps 1500 2157 57541
56919 64352 product 0 69152 A 8 C 0 0 Bubble_Stem_Mount_Pendant_Light_-_Mint_Barn_Light_Electric_-_Hotel_Lobby_Lighting.jpg Bubble Stem Mount Pendant, 370-Mint, WHT-White Glass, 12in Stem (Also Pictured: Downtown Minimalist 5-Light Chandelier in Watermelon) | Photo Courtesy of Beachside Hotel & Suites 1500 1000 69152
35128 63467 product 0 47361 A 9 C 0 0 american_made_chandelier_lighting__1_.jpg Downtown Minimalist 3-Light Chandelier, 997-Natural Raw Brass | Photo Courtesy of Homeowner 1148 1722 47361
56920 64352 product 0 69153 A 9 C 0 0 Bubble_Stem_Mount_Pendant_Light_-_Mint_Barn_Light_Electric_-_Hotel_Lighting.jpg Bubble Stem Mount Pendant, 370-Mint, WHT-White Glass, 12in Stem (Also Pictured: Downtown Minimalist 5-Light Chandelier in Watermelon) | Photo Courtesy of Beachside Hotel & Suites 1500 1095 69153
30077 63467 product 0 42300 A 10 C 0 0 brass_chandelier-512x768.jpg Downtown Minimalist 3-Light Chandelier, 998-Natural Weathered Brass | Photo Courtesy of Homeowner 512 768 42300
56918 64352 product 0 69151 A 10 C 0 0 Bubble_Stem_Mount_Pendant_Light_-_Mint_-_Opaque_Glass_Hotel_Lobby_Modern_Lighting_-_Barn_Light_Electric.jpg Bubble Stem Mount Pendant, 370-Mint, WHT-White Glass, 12in Stem (Also Pictured: Downtown Minimalist 5-Light Chandelier in Watermelon) | Photo Courtesy of Beachside Hotel & Suites 1500 889 69151
61212 64349 product 0 73445 A 10 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Dining_Room_Chandelier-alt.jpg Downtown Minimalist 5-Light Chandelier, 105-Textured Black, 36in Stem, 1910 Era 40W Edison Bulbs | Photo Courtesy of Stephanie Peyton (@springofmint) 1500 2000 73445
61214 64349 product 0 73447 A 11 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Farmhouse_Lighting-alt.jpg Downtown Minimalist 5-Light Chandelier, 105-Textured Black, 36in Stem, 1910 Era 40W Edison Bulbs | Photo Courtesy of Stephanie Peyton (@springofmint) 1500 2000 73447
56988 64349 product 0 69221 A 13 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Watermelon_Barn_Light_Electric_-_Interior_Commercial_Lighting.jpg Downtown Minimalist 5-Light Chandelier, 470-Watermelon (Also featured: Bubble Stem Mount Pendant Lights in Mint) | Photo Courtesy of Beachside Hotel & Suites and Baker Barrios Architects 1500 889 69221
61215 64349 product 0 73448 A 14 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Farmhouse_Chandelier-alt.jpg Downtown Minimalist 5-Light Chandelier, 105-Textured Black, 36in Stem, 1910 Era 40W Edison Bulbs | Photo Courtesy of Stephanie Peyton (@springofmint) 1500 2000 73448
56986 64349 product 0 69219 A 15 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Watermelon_Barn_Light_Electric_-_Commercial_Hotel_Lighting.jpg Downtown Minimalist 5-Light Chandelier, 470-Watermelon (Also featured: Bubble Stem Mount Pendant Lights in Mint) | Photo Courtesy of Beachside Hotel & Suites and Baker Barrios Architects 1500 1095 69219
56987 64349 product 0 69220 A 16 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Commercial_Interior_Hotel_Lighting.jpg Downtown Minimalist 5-Light Chandelier, 470-Watermelon (Also featured: Bubble Stem Mount Pendant Lights in Mint) | Photo Courtesy of Beachside Hotel & Suites and Baker Barrios Architects 6552 4367 69220
61213 64349 product 0 73446 A 17 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_100_Black_Barn_Light_Electric_-_Dining_Room_Light.jpg Downtown Minimalist 5-Light Chandelier, 105-Textured Black, 36in Stem, 1910 Era 40W Edison Bulbs | Photo Courtesy of Stephanie Peyton (@springofmint) 1500 2000 73446
32099 64349 product 0 44332 A 18 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Modern_Black_Minimalist_Bedroom_Lighting_.jpg Downtown Minimalist Chandelier, 100-Black 1000 700 44332
45309 64349 product 0 57542 A 19 C 0 0 Downtown_Minimalist_5-Light_Chandelier_-_Barn_Light_Electric_-_Blush_Pink_Minimalist_Chandelier_Dining_Room_Lighting-alt.pg.jpg Downtown Minimalist 5-Light Chandelier, 480-Blush Pink, Globe LED Tala Lamps 1500 2148 57542