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 (62625, 62624, 62623, 62657) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00077

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": 34,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (62625,62624,62623,62657)"
        }
      }
    },
    "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
22433 62624 product 0 34331 A 0 D 0 0 Wallaby-chain-12in-700-royal-blue-CLR-CSUW-alt.jpg 12" Wallaby, 700-Royal Blue, CLR-Clear Glass, CSUW-Blue & White Cloth Cord 1000 1000 34331
22593 62657 product 0 34491 A 0 D 0 0 outback-chain-12in-997-raw-brass-200-white-RIB-CSGW_i4u1-ap.jpg 12" Outback LED, 997-Natural Raw Brass, Guard in 200-White, RIB-Ribbed Glass, CSGW-Gold & White Cloth Cord, Mounting in 200-White 1000 1000 34491
66186 62624 product 0 78419 A 0 D 0 0 Wallaby-chain-14in-400-Barn-Red-RIB-CRZ-alt.jpg 14" Wallaby, 400-Barn Red, RIB-Ribbed Glass, CRZ-Red Chevron Cord 1000 1000 78419
66187 62624 product 0 78420 A 0 D 0 0 Wallaby-chain-14in-715-delphite-705-navy-CMG-CLR-alt.jpg 14" Wallaby, 715-Delphite, Guard in 705-Navy, CLR-Clear Glass, CMG-Grey Cloth Cord, Mounting in 705-Navy 1000 1000 78420
66188 62624 product 0 78421 A 0 D 0 0 Wallaby-Chain-16in-311-jadite-RIB-CSW-alt.jpg 16" Wallaby, 311-Jadite, RIB-Ribbed Glass, CSW-White Cloth Cord 1000 1000 78421
66191 62624 product 0 78424 A 0 D 0 0 Wallaby-Chain-full-build-16in-995-copper-100-black-CLR-CSBB-alt.jpg 16" Wallaby, 995-Natural Raw Copper, Guard in 100-Black, CLR-Clear Glass, CSBB-Black & Brown Cloth Cord, Mounting in 100-Black 1000 1000 78424
66192 62624 product 0 78425 A 0 D 0 0 Wallaby-Chain-16in-997-raw-brass-200-white-CSGW-alt.jpg 16" Wallaby, 997-Natural Raw Brass, Guard in 200-White, CSGW-Gold & White Cloth Cord, Mounting in 200-White 1000 1000 78425
66311 62625 product 0 78544 A 0 D 0 0 sydney-chain-14in-997-raw-brass-200-white-RIB-CSGW.jpg 14" Sydney, 997-Natural Raw Brass, Guard in 200-White, RIB-Ribbed Glass, CSGW-Gold & White Cloth Cord, Mounting in 200-White 1000 1000 78544
66429 62623 product 0 78662 A 0 D 0 0 brisbane-chain-16in-100-black-200-white-rib-CSBW.jpg 16" Brisbane, 100-Black, Guard in 200-White, RIB-Ribbed Glass, Mounting in 200-White, CSBW-Black & White Cloth Cord 1000 1000 78662
22594 62657 product 0 34492 A 1 D 0 0 outback-chain-Full-Build-20in-390-teal-200-white-RIB-CSBW.jpg 20" Outback LED, 390-Teal, Guard in 200-White, RIB-Ribbed Glass, CSBW-Black & White Cloth Cord 1000 1000 34492
66315 62625 product 0 78548 A 1 D 0 0 sydney-full-build-chain-18in-400-barn-red-CLR-CSB-FULL-BUILD.jpg 18" Sydney, 400-Barn Red, CLR-Clear Glass, CSB-Black Cloth Cord 1000 1000 78548
66432 62623 product 0 78665 A 1 D 0 0 brisbane-chain-full-build-12in-307-emerald-green-CSGW-CLR.jpg 12" Brisbane, 307-Emerald Green, CLR-Clear Glass, CSGW-Gold & White Cloth Cord 1000 1000 78665
22652 62623 product 0 34550 A 2 D 0 0 brisbane-chain-12in-997-raw-brass-100-black-CLR-CSGW.jpg 12" Brisbane, 997-Natural Raw Brass, Guard in 100-Black, CLR-Clear Glass, Mounting in 100-Black, CSGW-Gold & White Cloth Cord 1000 1000 34550
66313 62625 product 0 78546 A 2 D 0 0 sydney-chain-16in-200-white-975-galvanized-CSW-FST.jpg 16" Sydney, 200-White, Guard in 975-Galvanized, FST-Frosted Glass, CSW-White Cloth Cord, Mounting in 975-Galvanized 1000 1000 78546
66809 62657 product 0 79042 A 2 D 0 0 outback-chain-16in-400-barn-red-RIB-CRD_8jub-qr.jpg 16" Outback LED, 400-Barn Red, RIB-Ribbed Glass, CSR-Red Cloth Cord 1000 1000 79042
22592 62657 product 0 34490 A 3 D 0 0 outback-chain-12in-975-galvanized-700-royal-FST-CSUW_s7be-ak.jpg 12" Outback LED, 975-Galvanized, Guard in 700-Royal Blue, FST-Frosted Glass, CSUW-Blue & White Cloth Cord 1000 1000 34490
22657 62625 product 0 34555 A 3 D 0 0 sydney-chain-14in-790-lavender-390-teal-CLR-CMG.jpg 14" Sydney, 790-Lavender, Guard in 390-Teal, CLR-Clear Glass, CMG-Grey Cloth Cord, Mounting in 390-Teal 1000 1000 34555
66430 62623 product 0 78663 A 3 D 0 0 brisbane-chain-16in-200-white-rib-975-galvanized-CSW.jpg 16" Brisbane, 200-White, RIB-Ribbed Glass, Mounting in 975-Galvanized, CSW-White Cloth Cord 1000 1000 78663
22656 62625 product 0 34554 A 4 D 0 0 sydney-chain-12in-300-dark-green-CSBB-RIB.jpg 12" Sydney, 300-Dark Green, RIB-Ribbed Glass, CSBB-Black & Brown Cloth Cord 1000 1000 34554
29479 62623 product 0 41699 A 4 D 0 0 brisbane-chain-14in-705-navy-CRD-CLR.jpg 14" Brisbane, 705-Navy, CLR-Clear Glass, CSR-Red Cloth Cord 1000 1000 41699
66810 62657 product 0 79043 A 4 D 0 0 outback-chain-20in-307-emerald-green-FST-CSGW_ql6e-gy.jpg 20" Outback LED, 307-Emerald Green, FST-Frosted Glass, CSGW-Gold & White Cloth Cord 1000 1000 79043
66314 62625 product 0 78547 A 5 D 0 0 sydney-chain-18in-715-delphite-200-white-RIB-CSBW.jpg 18" Sydney, 715-Delphite, Guard in 200-White, RIB-Ribbed Glass, CSBW-Black & White Cloth Cord 1000 1000 78547
66431 62623 product 0 78664 A 5 D 0 0 brisbane-chain-16in-390-teal-975-galvanized-CSBG-CLR.jpg 16" Brisbane, 390-Teal, Guard in 975-Galvanized, CLR-Clear Glass, Mounting in 975-Galvanized, CSBG-Black & Gold Cloth Cord 1000 1000 78664
66812 62657 product 0 79045 A 5 D 0 0 outback-chain-14in-200-white-RIB-CSW.jpg 14" Outback LED, 200-White, RIB-Ribbed Glass, CSW-White Cloth Cord 1000 1000 79045
22653 62623 product 0 34551 A 6 D 0 0 brisbane-chain-14in-400-barn-red-CRZ-CLR.jpg 14" Brisbane, 400-Barn Red, CLR-Clear Glass, CRZ-Red Chevron Cord 1000 1000 34551
66312 62625 product 0 78545 A 6 D 0 0 sydney-chain-16in-100-black-CSB-CLR.jpg 16" Sydney, 100-Black, CLR-Clear Glass, CSB-Black Cloth Cord 1000 1000 78545
66438 62625 product 0 78671 A 6 C 0 0 IMG-0732-residential-interior-lighting-bedroom-bunkbed-Sydney-Chain-Hung-Pendant-18in-400-Barn-Red-SBK-Clear-Glass.jpg 18" Sydney, 400-Barn Red, Standard Black Cord, Clear Glass | Customer Submission 4032 3024 78671
66811 62657 product 0 79044 A 6 D 0 0 outback-chain-16in-705-navy-FST-CRZ_bb8k-c1.jpg 16" Outback LED, 705-Navy, FST-Frosted Glass, CRZ-Red Chevron Cord 1000 1000 79044
68220 62657 product 0 80453 A 6 C 0 0 IMG_3309-commercial-interior-lighting-on-kitchen-Outback-LED-Chain-Hung-14in-700-Royal-Blue-CSB-Black-Cloth-Chain-Guard-975-Galvanized-Clear-Glass.jpg 14" Outback LED Chain Hung, 700-Royal Blue, Cotton Black Cord & Chain, Guard, 975-Galvanized, Clear Glass | Photo Courtesy of Linda Ashley Interiors 2939 3919 80453
58266 62623 product 0 70499 A 7 C 0 0 Brisbane_Chain_Hung_Pendant_-_200_White_Barn_Light_Electric_-_Exterior_Porch_Dining_Lighting.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 993 70499
58267 62623 product 0 70500 A 8 C 0 0 Brisbane_Chain_Hung_Pendants_-_200_White_Barn_Light_Electric_-_Modern_Porch_Lighting_Decor.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 1000 70500
58268 62623 product 0 70501 A 9 C 0 0 Brisbane_Chain_Hung_Pendant_Lights_-_200_White_Barn_Light_Electric_-_Modern_Lighting_Decor.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 2250 70501
58269 62623 product 0 70502 A 10 C 0 0 Brisbane_Chain_Hung_Pendant_Lights_-_200_White_Barn_Light_Electric_-_Modern_Exterior_Lighting.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 983 70502
62173 62623 product 0 74406 A 11 C 0 0 Brisbane_Chain_Hung_Pendant_16in_600_Bronze_SBK_ClearGlass.jpg 16" Brisbane, 600-Bronze, CLR-Clear Glass, SBK-Standard Black Cord 1500 1125 74406