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 (64854, 64853, 65590) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00097

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": 58,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64854,64853,65590)"
        }
      }
    },
    "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
42114 64853 product 0 54347 A 0 D 0 0 lovell-table-lamp-600-bronze.jpg Lovell Task Lamp, 600-Bronze, Stem in 997-Natural Raw Brass, SBK-Standard Black Cord, Black Plug & Switch 600 602 54347
64869 65590 product 0 77102 A 0 D 0 0 LOVELL-hardwire-307-emerald_il0r-w7_3hqn-yx.jpg Lovell Wall Sconce, 307-Emerald Green, Black Arm, SBK-Standard Black Cord 1000 1000 77102
64871 65590 product 0 77104 A 0 D 0 0 LOVELL-hardwire-400-barn-red.jpg Lovell Wall Sconce, 400-Barn Red, Black Arm, SBK-Standard Black Cord 1000 1000 77104
64872 65590 product 0 77105 A 0 D 0 0 LOVELL-hardwire-975-galvanized-weathered-brass-arm-CSBB_2jip-6t_ii1h-wc_vciw-mu.jpg Lovell Wall Sconce, 975-Galvanized, Weathered Brass Arm, CSBB-Black & Brown Cloth Cord 1000 1000 77105
64874 65590 product 0 77107 A 0 D 0 0 LOVELL-hardwire-100-black_kom4-n0.jpg Lovell Wall Sconce, 100-Black, Black Arm, SBK-Standard Black Cord 1000 1000 77107
64875 65590 product 0 77108 A 0 D 0 0 LOVELL-hardwire-997-raw-brass.jpg Lovell Wall Sconce, 997-Natural Raw Brass, Raw Brass Arm, CSGW-Gold & White Cloth Cord 1000 1000 77108
42113 64853 product 0 54346 A 1 D 0 0 lovell-table-lamp-490-magenta142548278654f7242283e2d.jpg Lovell Task Lamp, 490-Magenta, Stem in 975-Galvanized, CSBW-Black & White Cloth Cord, Black Plug & Switch 600 600 54346
42154 64854 product 0 54387 A 1 D 0 0 lovell-copper-wall-sconce-weathered-web.jpg Lovell Plug-In Sconce, 996-Natural Weathered Copper, CSGW-Gold & White Cloth Cord 600 600 54387
42092 64853 product 0 54325 A 2 C 0 0 lovell-task-lamp-400-barn-red-brass-detail-web.jpg Lovell Task Lamp (Close Up), 455-Porcelain Cherry Red, Stem in 997-Natural Raw Brass, CSRW-Red & White Cloth Cord 600 600 54325
42155 64854 product 0 54388 A 2 D 0 0 lovell-plug-in-wall-sconce-750-cobalt-blue-web-fix1396544587533d944b7d526.jpg Lovell Plug-In Sconce, 710-Cobalt Blue, Galvanized Arm, SWH-Standard White Cord 600 600 54388
42094 64853 product 0 54327 A 3 D 0 0 lovell-task-lamp-250-white-brass-on-web.jpg Lovell Task Lamp (Lit up), 250-Porcelain White, Stem in 997-Natural Raw Brass, CSBW-Black & White Cloth Cord, Black Plug & Switch 600 600 54327
42145 64854 product 0 54378 A 3 D 0 0 Lovell-plug-in-wall-sconce-355-jadite-web.jpg Lovell Plug-In Wall Sconce, 311-Jadite, Galvanized Arm, CSRW-Red & White Cloth Cord 600 600 54378
42110 64853 product 0 54343 A 4 D 0 0 lovell-copper-desk-lamp-weathered-web.jpg Lovell Task Lamp, 996-Natural Weathered Copper, Stem in 100-Black, CSGW-Gold & White Cloth Cord, Black Plug & Switch 600 600 54343
42146 64854 product 0 54379 A 4 D 0 0 lovell-plug-in-wall-sconce-550-yellow.jpg Lovell Plug-In Wall Scone, 570-Sunflower, Raw Brass Arm, SBK-Standard Black Cord 600 600 54379
42095 64853 product 0 54328 A 5 D 0 0 lovell-task-lamp-350-green.jpg Lovell Task Lamp, 350-Porcelain Vintage Green, Stem in 975-Galvanized, SBK-Standard Black Cord, Black Plug & Switch 600 600 54328
42153 64854 product 0 54386 A 5 D 0 0 lovell-copper-wall-sconce-raw-web.jpg Lovell Plug-In Sconce, 995-Natural Raw Copper, Black Arm, CSBG-Black & Gold Cloth Cord 600 600 54386
64870 65590 product 0 77103 A 5 D 0 0 LOVELL-hardwire-250-white.jpg Lovell Wall Sconce, 200-White, Galvanized Arm, SWH-Standard White Cord 1000 1000 77103
42096 64853 product 0 54329 A 6 D 0 0 lovell-task-lamp-550-yellow.jpg Lovell Task Lamp, 550-Porcelain Yellow, Stem in 975-Galvanized, SBK-Standard Black Cord, Black Plug & Switch 600 600 54329
42147 64854 product 0 54380 A 6 D 0 0 lovell-plug-in-wall-sconce-770-delphite-blue-web.jpg Lovell Plug-In Wall Sconce, 715-Delphite Blue, Galvanized Arm, CSBW-Black & White Cloth Cord 600 600 54380
64873 65590 product 0 77106 A 6 D 0 0 LOVELL-hardwire-500-buttery-yellow.jpg Lovell Wall Sconce, 500-Buttery Yellow, Galvanized Arm, SWH-Standard White Cord 1000 1000 77106
65409 65590 product 0 77642 A 6 C 0 0 lovell-hardwire-sconce-997-natural-raw-brass-csgw.jpg Lovell Wall Sconce, 997-Natural Raw Brass, Raw Brass Arm, CSGW-Gold & White Cloth Cord 1500 2250 77642
65410 65590 product 0 77643 A 6 C 0 0 lovell-hardwire-sconce-997-natural-raw-brass-csgw-alt.jpg Lovell Wall Sconce, 997-Natural Raw Brass, Raw Brass Arm, CSGW-Gold & White Cloth Cord 1500 1000 77643
42097 64853 product 0 54330 A 7 C 0 0 lovell-task-lamp-red-insetting.jpg Lovell Task Lamp, 455-Porcelain Cherry Red, Stem in 997-Raw Brass, CSRW-Red & White Cloth Cord 600 900 54330
42160 64854 product 0 54393 A 7 D 0 0 lovell-sconce-480-blush-pink.jpg Lovell Plug-In Wall Sconce, 480-Blush Pink, Galvanized Arm, SWH-Standard White Cord 649 654 54393
42098 64853 product 0 54331 A 8 C 0 0 lovell-task-lamp-white-insetting.jpg Lovell Task Lamp (Lit up), 250-Porcelain White, Stem in 997-Raw Brass, CSBW-Black & White Cloth Cord 900 600 54331
42152 64854 product 0 54385 A 8 D 0 0 lovell-copper-wall-sconce-oil-rubbed-web.jpg Lovell Plug-In Wall Sconce, 999-Natural Oil-Rubbed Copper, Black Arm, SBK-Standard Black Cord 600 600 54385
42099 64853 product 0 54332 A 9 D 0 0 lovell-task-lamp-355-jadite-web.jpg Lovell Task Lamp, 355-Porcelain Jadite, Stem in 975-Galvanized, CSRW-Red & White Cloth Cord, Black Plug & Switch 600 600 54332
42156 64854 product 0 54389 A 9 D 0 0 lovell-sconce-100-black.jpg Lovell Plug-In Wall Sconce, 100-Black, Galvanized Arm, SBK-Standard Black Cord 649 654 54389
42100 64853 product 0 54333 A 10 D 0 0 lovell-task-lamp-150-black-web.jpg Lovell Task Lamp, 150-Porcelain Black, Stem in 997-Raw Brass, SBK-Standard Black Cord, Black Plug & Switch 600 600 54333
42157 64854 product 0 54390 A 10 D 0 0 lovell-sconce-307-emerald-green.jpg Lovell Plug-In Wall Sconce, 307-Emerald Green, Galvanized Arm, SBK-Standard Black Cord 600 605 54390
42102 64853 product 0 54335 A 11 C 0 0 lovell-task-lamp-vintag-green.jpg Lovell Task Lamp, 350-Porcelain Vintage Green, Stem in 975-Galvanized, SBK-Standard Black Cord 853 1280 54335
42158 64854 product 0 54391 A 11 D 0 0 lovell-sconce-390-teal.jpg Lovell Plug-In Wall Sconce, 390-Teal, Raw Brass Arm, SBK-Standard Black Cord 600 574 54391
42109 64853 product 0 54342 A 12 D 0 0 lovell-copper-desk-lamp-raw-web.jpg Lovell Task Lamp, 995-Natural Raw Copper, Stem in 975-Galvanized, CSBG-Black & Gold Cloth Cord, Black Plug & Switch 600 600 54342
42159 64854 product 0 54392 A 12 D 0 0 lovell-sconce-420-orange.jpg Lovell Plug-In Wall Sconce, 420-Orange, Galvanized Arm, SBK-Standard Black Cord 649 654 54392
42103 64853 product 0 54336 A 13 D 0 0 lovell-task-lamp-400-barn-red-web.jpg Lovell Task Lamp, 455-Porcelain Cherry Red, Stem in 997-Natural Raw Brass, CSRW-Red & White Cloth Cord, Black Plug & Switch 600 600 54336
42162 64854 product 0 54395 A 13 D 0 0 lovell-sconce-weathered-brass-galvanized-1.jpg Lovell Plug-In Wall Sconce, 998-Natural Weathered Brass, Galvanized Arm, SBK-Standard Black Cord 600 605 54395
42105 64853 product 0 54338 A 14 C 0 0 Copper_Lovell_Task_Lamp_copy.jpg Lovell Task Lamp, 995-Natural Raw Copper, Stem in 975-Galvanized, CSBW-Black & White Cloth Cord, Black Plug & Switch | Photo Courtesy of Homeowner 720 829 54338
42161 64854 product 0 54394 A 14 D 0 0 lovell-sconce-705-navy.jpg Lovell Plug-In Wall Sconce, 705-Navy, Raw Brass Arm, SBK-Standard Black Cord 600 574 54394
42107 64853 product 0 54340 A 15 C 0 0 JOLIET-sfgirl-final-6900-1-512x768.jpg Lovell Task Lamp (Lit up), 250-Porcelain White, Stem in 997-Natural Raw Brass, CSBW-Black & White Cloth Cord, Black Plug & Switch 512 768 54340
42144 64854 product 0 54377 A 15 C 0 0 lovell-plug-in-wall-sconce-250-white-in-setting-web.jpg Lovell Plug-In Wall Sconce, 200-White, Raw Brass Arm, CSRW-Red & White Cloth Cord 600 600 54377
42108 64853 product 0 54341 A 16 D 0 0 lovell-copper-desk-lamp-oil-rubbed-web.jpg Lovell Task Lamp, 999-Natural Oil-Rubbed Bronze, Stem in 100-Black, SBK-Standard Black Cord, Black Plug & Switch 600 600 54341
42148 64854 product 0 54381 A 16 C 0 0 wall_lights_porcelain_wall_sconces.jpg Lovell Plug-In Wall Sconce, 200-White, Raw Brass Arm, CSRW-Red & White Cloth Cord | Photo Courtesy of Pencil Shavings Studio 635 953 54381
42106 64853 product 0 54339 A 17 C 0 0 copper-lovell-table-lamp.jpg Lovell Task Lamp, 997-Natural Raw Brass, Stem in Raw Brass, SBK-Standard Black Cord, Black Plug & Switch 600 600 54339
50027 64854 product 0 62260 A 17 C 0 0 Lovell_Plug-In_Wall_Sconces_White_Weathered_Brass_arm_Black-and-White_cloth_cord.jpg Lovell Plug-In Wall Sconce, 200-White, Weathered Brass Arm, CSBW-Black and White Cloth Cord | Photo Courtesy of Little Adi+Co 2048 1536 62260
42111 64853 product 0 54344 A 18 D 0 0 lovell-table-lamp-100-black.jpg Lovell Task Lamp, 100-Black, Stem in 997-Natural Raw Brass, SBK-Standard Black Cord, Black Plug & Switch 600 602 54344
42149 64854 product 0 54382 A 18 C 0 0 Lovell_Plug-In_Wall_Sconces_White_Weathered_Brass_arm_Black-White_cloth_cord3.jpg Lovell Plug-In Wall Sconce, 200-White, Weathered Brass Arm, CSBW-Black and White Cloth Cord | Photo Courtesy of Little Adi+Co 1500 1000 54382
54132 64853 product 0 66365 A 19 C 0 0 1503-lovell-table-lamp-weathered-brass.jpg Lovell Task Lamp, 998-Natural Weathered Brass, Stem in Raw Brass, SBK-Standard Black Cord, Plug Black & Switch 5550 3700 66365
61352 64854 product 0 73585 A 19 C 0 0 Lovell_Plug_In_Wall_Sconce_-_Barn_Light_Electric_-_Task_Lighting.png Lovell Plug-In Wall Sconce, 420-Orange, 975-Galvanized Arm, SBK-Standard Cord | Photo Courtesy of Dane Street Studio 549 589 73585
42117 64853 product 0 54350 A 20 D 0 0 lovell-table-lamp-balck-and-white-cord-teal.jpg Lovell Task Lamp, 390-Teal, Stem in 997-Natural Raw Brass, CSBW-Black & White Cloth Cord, Black Plug & Switch 600 600 54350
42151 64854 product 0 54384 A 20 C 0 0 lovell_plugin_wall_sconce_white_brassarm_blue_white_cloth_cord4.jpg (2) Lovell Plug-In Wall Sconces, 200-White, Raw Brass Arm, CSUW-Blue and White Cloth Cord | Photo Courtesy of Rental Home Owner, www.5wharflane.com 768 1024 54384
42112 64853 product 0 54345 A 21 D 0 0 lovell-table-lamp-300-dark-green.jpg Lovell Task Lamp, 300-Dark Green, Stem in 975-Galvanized, CSBW-Black & White Cloth Cord, Black Plug & Switch 600 600 54345
51651 64854 product 0 63884 A 21 C 0 0 lovell_plugin_wall_sconce_white_brass_arm_blue_white_cloth_cord.jpg Lovell Plug-In Wall Sconces, 200-White, Raw Brass Arm, CSUW-Blue and White Cloth Cord | Photo Courtesy of Rental Home Owner, www.5wharflane.com 1500 2000 63884
42115 64853 product 0 54348 A 22 D 0 0 lovell-table-lamp-balck-and-white-cord-blush-pink.jpg Lovell Task Lamp, 480-Blush Pink, Stem in 997-Natural Raw Brass, CSBW-Black & White Cloth Cord, Black Plug & Switch 600 600 54348
64491 64854 product 0 76724 A 22 C 0 0 residential-interior-lighting-kid-bedroom-bunk-bed-Lovell-Plug-In-Wall-Sconce-206-Matte-White-Arm-975-Galvanized-SWH-Plug-Switch-206-Matte-White.jpg Lovell Plug-In Wall Sconce, 206-Matte White, 975-Galvanized Arm, SWH-Plug In Switch | Photo Courtesy of Homeowner 1500 2000 76724
42118 64853 product 0 54351 A 23 C 0 0 weathered-copper-lovell-table-lamp.jpg Lovell Task Lamp, 998-Natural Weathered Brass, Stem in Raw Brass, SBK-Standard Black Cord, Plug Black & Switch 600 600 54351
42116 64853 product 0 54349 A 24 D 0 0 lovell-table-lamp-balck-and-white-cord-navy.jpg Lovell Task Lamp, 705-Navy, Stem in 997-Natural Raw Brass, CSBW-Black & White Cloth Cord, Black Plug & Switch 600 600 54349
51664 64853 product 0 63897 A 25 C 0 0 _simplygrove.jpg Lovell Task Lamp, 250-Porcelain White, Stem in 997-Raw Brass, CSBW-Black & White Cloth Cord, Black Plug & Switch | Photo Courtesy of Kristen Grove 640 640 63897
58996 64853 product 0 71229 A 25 C 0 0 Lovell_Task_Lamp_-_Barn_Light_Electric_-_Bedroom_Lighting.jpg Lovell Task Lamp, 350-Vintage Green, Stem in 997-Raw Brass | Photo Courtesy of Raili Clasen 3795 3795 71229