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, 62626, 62654, 62624) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00098

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": 28,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (62625,62626,62654,62624)"
        }
      }
    },
    "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
22462 62626 product 0 34360 A 0 D 0 0 outback-chain-12in-997-raw-brass-200-white-RIB-CSGW.jpg 12" Outback, 997-Natural Raw Brass, Guard in 200-White, RIB-Ribbed Glass, CSGW-Gold & White Cloth Cord, Mounting in 200-White 1000 1000 34360
22650 62654 product 0 34548 A 0 D 0 0 brisbane-chain-12in-490-magenta-100-black-CLR_7lu0-dk.jpg 12" Brisbane LED, 490-Magenta, Guard in 100-Black, CLR-Clear Glass, Mounting in 100-Black, CSBP-Black & Pink Cloth Cord 1000 1000 34548
22651 62654 product 0 34549 A 0 D 0 0 brisbane-chain-full-build-12in-307-emerald-green-CSGW-CLR.jpg 12" Brisbane LED, 307-Emerald Green, CLR-Clear Glass, CSGW-Gold & White Cloth Cord 1000 1000 34549
64119 62654 product 0 76352 A 0 D 0 0 brisbane-chain-12in-997-raw-brass-100-black-CLR-CSGW.jpg 12" Brisbane LED, 997-Natural Raw Brass, Guard in 100-Black, CLR-Clear Glass, Mounting in 100-Black, CSGW-Gold & White Cloth Cord 1000 1000 76352
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
66433 62654 product 0 78666 A 0 D 0 0 brisbane-chain-16in-200-white-rib-975-galvanized-CSW_figu-82.jpg 16" Brisbane LED, 200-White, RIB-Ribbed Glass, Mounting in 975-Galvanized, CSW-White Cloth Cord 1000 1000 78666
66434 62654 product 0 78667 A 0 D 0 0 brisbane-chain-14in-705-navy-CRD-CLR.jpg 14" Brisbane LED, 705-Navy, CLR-Clear Glass, CSR-Red Cloth Cord 1000 1000 78667
66435 62654 product 0 78668 A 0 D 0 0 brisbane-chain-16in-390-teal-975-galvanized-CSBG-CLR_qeb9-jn.jpg 16" Brisbane LED, 390-Teal, Guard in 975-Galvanized, CLR-Clear Glass, Mounting in 975-Galvanized, CSBG-Black & Gold Cloth Cord 1000 1000 78668
66436 62654 product 0 78669 A 0 D 0 0 brisbane-chain-14in-400-barn-red-CRZ-CLR.jpg 14" Brisbane LED, 400-Barn Red, CLR-Clear Glass, CRZ-Red Chevron Cord 1000 1000 78669
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
66808 62626 product 0 79041 A 1 D 0 0 outback-chain-Full-Build-20in-390-teal-200-white-RIB-CSBW.jpg 20" Outback, 390-Teal, Guard in 200-White, RIB-Ribbed Glass, CSBW-Black & White Cloth Cord 1000 1000 79041
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
66804 62626 product 0 79037 A 2 D 0 0 outback-chain-16in-400-barn-red-RIB-CRD.jpg 16" Outback, 400-Barn Red, RIB-Ribbed Glass, CSR-Red Cloth Cord 1000 1000 79037
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
66807 62626 product 0 79040 A 3 D 0 0 outback-chain-20in-307-emerald-green-FST-CSGW.jpg 20" Outback, 307-Emerald Green, FST-Frosted Glass, CSGW-Gold & White Cloth Cord 1000 1000 79040
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
66805 62626 product 0 79038 A 4 D 0 0 outback-chain-16in-705-navy-FST-CRZ.jpg 16" Outback, 705-Navy, FST-Frosted Glass, CRZ-Red Chevron Cord 1000 1000 79038
22463 62626 product 0 34361 A 5 D 0 0 outback-chain-14in-200-white-RIB-CSW.jpg 14" Outback, 200-White, RIB-Ribbed Glass, CSW-White Cloth Cord 1000 1000 34361
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
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
66806 62626 product 0 79039 A 6 D 0 0 outback-chain-18in-100-black-975-galvanized-RIB-CSB.jpg 18" Outback, 100-Black, Guard in 975-Galvanized, RIB-Ribbed Glass, CSB-Black Cloth Cord 1000 1000 79039