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 = 65836 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00052

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": "ref",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "ref": ["const", "const", "const"],
          "rows": 20,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A'",
          "attached_condition": "cscart_images_links.object_id <=> 65836 and cscart_images_links.object_type <=> 'product' and cscart_images_links.`type` <=> 'A'"
        }
      }
    },
    "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
73892 65836 product 0 86125 A 0 D 0 0 carver-sconce-16in-430-soft-clay-maple-wood.jpg 16" Carver LED Wooden Diffuser Light, 430-Soft Clay, Maple Wood Diffuser 1000 1000 86125
73887 65836 product 0 86120 A 1 D 0 0 carver-flush-mount-16in-300-dark-green-oak-wood_copy.jpg 16" Carver LED Wooden Diffuser Light, 300-Dark Green, Oak Wood Diffuser 1000 1000 86120
73896 65836 product 0 86129 A 2 D 0 0 carver-sconce-20in-200-white-walnut-wood.jpg 20" Carver LED Wooden Diffuser Light, 200-White, Walnut Wood Diffuser 1000 1000 86129
73888 65836 product 0 86121 A 3 D 0 0 carver-flush-mount-16in-996-weathered-copper-oak-wood_copy.jpg 16" Carver LED Wooden Diffuser Light, 996-Natural Weathered Copper, Oak Wood Diffuser 1000 1000 86121
73894 65836 product 0 86127 A 4 D 0 0 carver-sconce-16in-975-galvanized-oak-wood.jpg 16" Carver LED Wooden Diffuser Light, 975-Galvanized, Oak Wood Diffuser 1000 1000 86127
73886 65836 product 0 86119 A 5 D 0 0 carver-flush-mount-12in-630-beige-maple-wood_copy.jpg 12" Carver LED Wooden Diffuser Light, 630-Beige, Maple Wood Diffuser 1000 1000 86119
73889 65836 product 0 86122 A 6 D 0 0 carver-sconce-12in-100-black-walnut-wood.jpg 12" Carver LED Wooden Diffuser Light, 100-Black, Walnut Wood Diffuser 1000 1000 86122
73890 65836 product 0 86123 A 7 D 0 0 carver-sconce-12in-320-fern-green-ash-wood.jpg 12" Carver LED Wooden Diffuser Light, 320-Fern Green, Ash Wood Diffuser 1000 1000 86123
73895 65836 product 0 86128 A 8 D 0 0 carver-sconce-16in-999-oil-rubbed-copper-walnut-wood.jpg 16" Carver LED Wooden Diffuser Light, 999-Natural Oil-Rubbed Copper, Walnut Wood Diffuser 1000 1000 86128
73897 65836 product 0 86130 A 9 D 0 0 carver-sconce-20in-805-charcoal-granite-ash-wood.jpg 20" Carver LED Wooden Diffuser Light, 805-Charcoal Granite, Ash Wood Diffuser 1000 1000 86130
73891 65836 product 0 86124 A 10 D 0 0 carver-sconce-12in-607-taupe-oak-wood.jpg 12" Carver LED Wood Diffuser Light, 607-Taupe, Oak Wood Diffuser 1000 1000 86124
73893 65836 product 0 86126 A 11 D 0 0 carver-sconce-16in-605-textured-rust-walnut-wood.jpg 16" Carver LED Wooden Diffuser Light, 605-Textured Rust, Walnut Wood Diffuser 1000 1000 86126
73921 65836 product 0 86154 A 12 D 0 0 FSC-stustainable-hardwoods.jpg 960 960 86154
73900 65836 product 0 86133 A 13 C 0 0 1089897426-commerical-residential-living-room-lounge-carver-wall-sconce-20in-430-soft-clay-walnut-wood-sqaure.jpg 20" Carver LED Wooden Diffuser Light, 430-Soft Clay, Walnut Wood Diffuser 1000 1000 86133
73898 65836 product 0 86131 A 14 C 0 0 605695818-carver-sconce-20in-16in-12in-200-white-100-black-oak-wood-residential-interior-mudroom-entryway-square.jpg 12", 16" and 20" Carver LED Wooden Diffuser Light, 200-White and 100-Black, Oak Wood Diffusers 1000 1000 86131
73899 65836 product 0 86132 A 15 C 0 0 629541061-residential-interior-living-room-carver-sconce-20in-16in-12in-996-weathered-copper-oak-wood-square.jpg 12", 16" and 20" Carver LED Wooden Diffuser Light, 996-Natural Weathered Copper, Oak Wood Diffusers 1000 1000 86132
73901 65836 product 0 86134 A 16 C 0 0 H17rssr4-commercial-interior-restaurant-carver-wall-sconce-20in-12in-800-industrial-grey-maple-wood-square.jpg 12" and 20" Carver LED Wooden Diffuser Light, 800-Industrial Grey, Maple Wood Diffuser 1000 1000 86134
73923 65836 product 0 86156 A 16 D 0 0 4M5A1948-carver-sconce-16in-weathered-copper-ash-wood.jpg 16" Carver, 996-Natural Weathered Copper, Ash Wood Diffuser 1000 1000 86156
73924 65836 product 0 86157 A 16 D 0 0 Carver-sconce-16in-997-raw-brass-ash-wood-on.jpg 16" Carver, 997-Natural Raw Brass, Ash Wood Diffuser 1000 1000 86157
73925 65836 product 0 86158 A 16 D 0 0 Carver-cluster.jpg 1000 1000 86158