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 (64867, 61072, 64981, 64944) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00096

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": 48,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64867,61072,64981,64944)"
        }
      }
    },
    "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
49013 64867 product 0 61246 A 0 D 0 0 Timber-Ore-Marathon-Wooden-Shade-Ash-Delphite-Putty-Twist-Cord.jpg 14" Shade in 765-Porcelain Delphite Blue, Ash Wood, TPT-Putty Twist Cord 1000 1000 61246
49272 64944 product 0 61505 A 0 D 0 0 Timber-Ore-Conoco-Draftsman-Pendant-Ash-Barn-Red-Black-Twist-Cord-Edison-Style-1890-Era-40-Watt-Bulb.jpg 12" Shade in 400-Barn Red, Ash Wood, TBK-Black Twist Cord, Canopy in 400-Barn Red (Shown with Edison 1890 Era Bulb) 1000 1000 61505
50194 64981 product 0 62427 A 0 D 0 0 marathon-cord-LED-12in-400-red-CRD.jpg 12" Marathon LED, 400-Barn Red, CSR-Red Cloth Cord 1000 1000 62427
64051 61072 product 0 76284 A 0 D 0 0 marathon-soho-cord-full-build-12in-975-galvanized-400-barn-red-CRZ.jpg 12" Marathon SoHo, 975-Galvanized, Shade Top in 400-Barn Red, CRZ-Red Chevron Cord 1000 1000 76284
14190 61072 product 0 24985 A 1 D 0 0 marathon-soho-cord-12in-300-dark-green-975-galvanized-CSB.jpg 12" Marathon SoHo, 300-Dark Green, Shade Top in 975-Galvanized, CSB-Black Cloth Cord 1000 1000 24985
49019 64944 product 0 61252 A 1 D 0 0 Timber-Ore-Conoco-Draftsman-Pendant-Maple-Delphite-LED-T14-120-Lumen-Bulb.jpg 10" Shade in 765-Porcelain Delphite, Maple Wood, SWH-Standard White Cord (Shown with LED T14 120 Lumen Bulb) 1000 1000 61252
49270 64867 product 0 61503 A 1 D 0 0 Timber-Ore-Marathon-Wooden-Shade-Walnut-Jadite-Black-White-Twist-Cord-Walnut-Canopy.jpg 14" Shade in 355-Porcelain Jadite, Walnut Wood, TBW-Black & White Twist Cord, Walnut Canopy Cover 1000 1000 61503
64028 64981 product 0 76261 A 1 D 0 0 marathon-cord-LED-16in-997-raw-brass-100-black-CSBG.jpg 12" Marathon LED, 997-Natural Raw Brass, CSBG-Black & Gold Cloth Cord, Canopy in 100-Black 1000 1000 76261
14189 61072 product 0 24984 A 2 D 0 0 marathon-soho-cord-12in-100-black-490-magenta-CSBP.jpg 12" Marathon SoHo, 490-Magenta, Shade Top in 100-Black, CSBP-Black & Pink Cloth Cord 1000 1000 24984
49015 64867 product 0 61248 A 2 D 0 0 Timber-Ore-Marathon-Wooden-Shade-Walnut-Galvanized-White-Cord.jpg 12" Shade in 975-Galvanized, Walnut Wood, SWH-Standard White Cord 1000 1000 61248
50911 64944 product 0 63144 A 2 D 0 0 Timber-Ore-Conoco-Draftsman-Pendant-Ash-Brass-Edison-30Watt-Hairpin-Bulb.jpg 12" Shade in 997-Natural Raw Brass, Ash Wood, CSGW-Gold & White Cloth Cord (Shown with Totem III Tala Lamp) 1000 1000 63144
64025 64981 product 0 76258 A 2 D 0 0 marathon-cord-LED-16in-100-black-CSBG-WC-975-galvanized.jpg 16" Marathon LED, 100-Black, Wire Cage, 975-Galvanized, CSBG-Black & Gold Cloth Cord 1000 1000 76258
49014 64867 product 0 61247 A 3 D 0 0 Timber-Ore-Marathon-Wooden-Shade-Ash-Oil-Rubbed-Bronze-Standard-Black-Cord-Edison-Style-1910-Bulb.jpg 16" Shade in 615-Oil-Rubbed Bronze, Ash Wood, SBK-Standard Black Cord, Shown with Edison 1910 Era Bulb 1000 1000 61247
49271 64944 product 0 61504 A 3 D 0 0 Timber-Ore-Conoco-Draftsman-Pendant-Walnut-Magenta-Black-Pink-Cloth-Cord-LED-T14-120-Lumen-Bulb.jpg 12" Shade in 490-Magenta, Walnut Wood, CSBP-Black & Pink Cloth Cord, Walnut Canopy Cover (Shown with LED T14 120 Lumen Bulb) 1000 1000 61504
50195 64981 product 0 62428 A 3 D 0 0 marathon-cord-LED-14in-250-white-CSW.jpg 14" Marathon LED, 250-Porcelain White, CSW-White Cloth Cord 1000 1000 62428
64047 61072 product 0 76280 A 3 D 0 0 marathon-soho-cord-12in-400-barn-red-CRD.jpg 12" Marathon SoHo, 400-Barn Red, CSR-Red Cloth Cord 1000 1000 76280
49016 64867 product 0 61249 A 4 D 0 0 Timber-Ore-Marathon-Wooden-Shade-Walnut-Jadite-Black-White-Twist-Cord.jpg 14" Shade in 355-Porcelain Jadite, Walnut Wood, TBW-Black & White Twist Cord 1000 1000 61249
49020 64944 product 0 61253 A 4 D 0 0 Timber-Ore-Conoco-Draftsman-Pendant-Walnut-Barn-Red-Brown-Twist-Cord-Edison-Style-1890-Era-40-Watt-Bulb.jpg 12" Shade in 400-Barn Red, Walnut Wood, TBR-Brown Twist Cord (Shown with Edison 1890 Era Bulb) 1000 1000 61253
64026 64981 product 0 76259 A 4 D 0 0 marathon-cord-LED-16in-300-dark--green-CSGW.jpg 16" Marathon LED, 300-Dark Green, CSGW-Gold & White Cloth Cord 1000 1000 76259
64050 61072 product 0 76283 A 4 D 0 0 marathon-soho-cord-full-build-12in-307-emerald-green-CSB.jpg 12" Marathon SoHo, 307-Emerald Green, CSB-Black Cloth Cord 1000 1000 76283
49269 64867 product 0 61502 A 5 D 0 0 Timber-Ore-Marathon-Wooden-Shade-Ash-Galvanized-White-Cloth-Cord-Galvanized-Canopy.jpg 12" Shade in 975-Galvanized, Ash Wood, SWH-Standard White Cord, Canopy in 975-Galvanized 1000 1000 61502
59003 64944 product 0 71236 A 5 C 0 0 Conoco_Draftsman_Wooden_Top_Pendant_Light_-_Barn_Light_Electric_-_Farmhouse_Kitchen_Sink_Light.jpg 10” Shade in 400-Barn Red, Walnut Wood, CSBG-Black & Gold Cloth Cord | Photo Courtesy of Lisa Davenport of LDD Interiors 1024 1365 71236
64027 64981 product 0 76260 A 5 D 0 0 marathon-cord-LED-16in-975-galvanized-CMG.jpg 16" Marathon LED, 975-Galvanized, CMG-Grey Cloth Cord 1000 1000 76260
64049 61072 product 0 76282 A 5 D 0 0 marathon-soho-cord-14in-715-delphite-CMG.jpg 14" Marathon SoHo, 715-Delphite, CMG-Grey Cloth Cord 1000 1000 76282
50196 64981 product 0 62429 A 6 D 0 0 marathon-cord-LED-14in-500-buttery-yellow-CSBG.jpg 14" Marathon LED, 500-Buttery Yellow, CSBG-Black & Gold Cloth Cord 1000 1000 62429
59004 64944 product 0 71237 A 6 C 0 0 Conoco_Draftsman_Wooden_Top_Pendant_-_Barn_Light_Electric_-_Kitchen_Lighting.jpg 10” Shade in 400-Barn Red, Walnut Wood, CSBG-Black & Gold Cloth Cord | Photo Courtesy of Lisa Davenport of LDD Interiors 1024 1365 71237
61491 64867 product 0 73724 A 6 C 0 0 Marathon_Wooden_Top_Pendant_Light_-_Barn_Light_Electric_-_Island_Lighting_.jpg 16” Shade in 850-Graphite, Walnut Wood, CMG-Grey Cloth Cord | Photo Courtesy of Homeowner 1500 2000 73724
64052 61072 product 0 76285 A 6 D 0 0 marathon-soho-cord-full-build-500-buttery-yellow-100-black-CSBG.jpg 14" Marathon SoHo, 500-Buttery Yellow, CSBG-Black & Gold Cloth Cord, Ceiling Canopy in 100-Black 1000 1000 76285
49334 64944 product 0 61567 A 7 C 0 0 timber-ore-conoco-cord-pendant-residential-kitchen.jpg 12" Shade in 400-Barn Red, Ash Wood, SBK-Standard Black Cord 1500 2250 61567
61490 64867 product 0 73723 A 7 C 0 0 Marathon_Wooden_Top_Pendant_Light_-_Barn_Light_Electric_-_Wooden_Lighting-2.jpg 16” Shade in 850-Graphite, Walnut Wood, CMG-Grey Cloth Cord | Photo Courtesy of Homeowner 1500 1958 73723
64048 61072 product 0 76281 A 7 D 0 0 marathon-soho-cord-14in-200-white-CSW.jpg 14" Marathon SoHo, 200-White, CSW-White Cloth Cord 1000 1000 76281
55434 64944 product 0 67667 A 8 C 0 0 RR-Early_Avery_Rafterhouse_kitchen_2.jpg (2) 12" Shade in 100-Black, Ash Wood, CSB-Black Cloth Cord | Photo Courtesy of Early Avery - Rafterhouse and Roehner+Ryan 1500 2000 67667
61489 64867 product 0 73722 A 8 C 0 0 Marathon_Wooden_Top_Pendant_Light_-_Barn_Light_Electric_-_Kitchen_Lighting-3.jpg 16” Shade in 850-Graphite, Walnut Wood, CMG-Grey Cloth Cord | Photo Courtesy of Homeowner 1500 1125 73722
69122 61072 product 0 81355 A 8 C 0 0 3-435-residential-interior-lighting-livinig-Penelope-SoHo-Pendant-14in-390-Teal-975-Galvanized-Heavy-Duty-Canopy.jpg 14" Marathon SoHo Pendant, 390-Teal, Mounting in 975-Galvanized, Heavy Duty Stem Mount Canopy | Photo Courtesy of Vertical Point Media 6000 4000 81355
46473 61072 product 0 58706 A 9 C 0 0 industrial_pendants-768x602.jpg 14" Marathon Soho Pendant, 490-Magenta, SWH-Standard White Cord | Photos Courtesy of Homeowner 768 602 58706
49335 64867 product 0 61568 A 9 C 0 0 timber-ore-marathon-textured-black-oak-cord-commercial-restaurant-1.jpg 14" Shade in 105-Textured Black, Oak Wood, SBK-Standard Black Cord 1500 2000 61568
55435 64944 product 0 67668 A 9 C 0 0 RR-Early_Avery_Rafterhouse_light_detail.jpg (2) 12" Shade in 100-Black, Ash Wood, CSB-Black Cloth Cord | Photo Courtesy of Early Avery - Rafterhouse and Roehner+Ryan 1500 1125 67668
46472 61072 product 0 58705 A 10 C 0 0 industrial_pendant_lighting-768x576.jpg 14" Marathon Soho Pendant, 490-Magenta, SWH-Standard White Cord | Photos Courtesy of Homeowner 768 576 58705
55433 64944 product 0 67666 A 10 C 0 0 RR-Early_Avery_Rafterhouse_kitchen_1.jpg (2) 12" Shade in 100-Black, Ash Wood, CSB-Black Cloth Cord | Photo Courtesy of Early Avery - Rafterhouse and Roehner+Ryan 1500 1125 67666
63150 64867 product 0 75383 A 10 C 0 0 Marathon_Wooden_Top_Pendant_Light_-_Ocala_Airport_-_Barn_Light_Electric.jpg 14" Shade in 100-Black, Walnut Wood, SBK-Standard Black Cord | Photo Courtesy of Western Florida Lighting Orlando and MLM-Martin Architects 1500 676 75383
44351 61072 product 0 56584 A 11 C 0 0 marathon-soho-pendant-lavender.jpg 14" Marathon Soho Pendant, 790-Lavender, CRZ-Red Chevron Cord 1500 2249 56584
49339 64867 product 0 61572 A 11 C 0 0 i-timber-ore-wilcox-uplight-marathon-cord-pendant-green-white-residential-kitchen_iha6-wp-.jpg 14" Shade in 200-White, Oak Wood, SWH-Standard White Cord (Shown with Wilcox Uplight Wooden Top Pendant) 1500 1185 61572
65337 64867 product 0 77570 A 11 C 0 0 Kitchen_5_Residential-Interior-Lighting-island-Marathon-Wooden-Top-Pendant-14in-Ash-Wood-705-Navy-Grey-cloth-Ash-Canopy.jpg 14" Shade in 705-Navy, Ash Wood, Grey Cloth Cord, Ash Canopy | Photo Courtesy of Homeowner 3024 4032 77570
65338 64867 product 0 77571 A 11 C 0 0 Kitchen_6_Residential-Interior-Lighting-island-Marathon-Wooden-Top-Pendant-12in-Ash-Wood-705-Navy-Grey-cloth-Ash-Canopy.jpg 14" Shade in 705-Navy, Ash Wood, Grey Cloth Cord, Ash Canopy | Photo Courtesy of Homeowner 2845 3793 77571
65339 64867 product 0 77572 A 11 C 0 0 Kitchen_2_Residential-Interior-Lighting-island-Marathon-Wooden-Top-Pendant-14in-Ash-Wood-705-Navy-Grey-cloth-Ash-Canopy.jpg 14" Shade in 705-Navy, Ash Wood, Grey Cloth Cord, Ash Canopy | Photo Courtesy of Homeowner 4032 3024 77572
66326 64867 product 0 78559 A 11 C 0 0 Barnlights-residential-interior-lighting-kitchen-dining-Marathon-Wooden-Top-Pendant-12in-100-Black-Ash-SBK-Loma-Pendant-20in-200-White-940-Painted-Aged-Copper-SWH.JPG 12" Marathon Wooden Top Pendant, 100-Black, Ash, Standard Black Cord | Customer Submission 4032 3024 78559
44350 61072 product 0 56583 A 12 C 0 0 marathon-soho-pendant-sherbet-orange.jpg 14" Marathon Soho Pendant, 495-Sherbert Orange, CSBW-Black & White Cloth Cord 1500 2250 56583
14281 61072 product 0 25076 A 13 C 0 0 houston_street_soho_green_cord.jpg 14" Marathon Soho Pendant, 300-Dark Green 600 616 25076