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 (63811, 63815, 63813, 63812, 63814) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00107

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 (63811,63815,63813,63812,63814)"
        }
      }
    },
    "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
27442 63812 product 0 39619 A 0 D 0 0 floor-lamp-sinclair-red-galvanized-black-white-cord.jpg Sinclair Floor Lamp, 400-Barn Red, Galvanized Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39619
27445 63814 product 0 39622 A 0 D 0 0 floor-lamp-circle-b-black-galvanized-white-cord.jpg Conoco Floor Lamp, 100-Black, Galvanized Stem, SWH-Standard White Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39622
27448 63811 product 0 39625 A 0 D 0 0 floor-lamp-fargo-white-galvanized-white-gold-cord.jpg Fargo Floor Lamp, 200-White, Galvanized Stem, CSGW-Gold & White Cloth Cord 600 600 39625
27451 63813 product 0 39628 A 0 D 0 0 floor-lamp-wesco-white-galvanized-white-gold-cord.jpg Gladstone Floor Lamp, 200-White, Galvanized Stem, CSGW-Gold & White Cloth Cord 600 600 39628
27454 63815 product 0 39631 A 0 D 0 0 floor-lamp-radial-wave-white-galvanized-white-cord.jpg Fluted Shade Floor Lamp, 200-White, Galvanized Stem, SWH-Standard White Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39631
27469 63814 product 0 39646 A 0 D 0 0 floor-lamp-circle-b-grey-brass-white-gold-cord.jpg Conoco Floor Lamp, 800-Industrial Grey, Brass Stem, CSGW-Gold & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39646
27470 63814 product 0 39647 A 0 D 0 0 floor-lamp-circle-b-magenta-brass-black-whtiecord.jpg Conoco Floor Lamp, 490-Magenta, Brass Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39647
27471 63814 product 0 39648 A 0 D 0 0 floor-lamp-circle-b-pink-galvanized-black-whitecord.jpg Conoco Floor Lamp, 480-Blush Pink, Galvanized Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39648
27472 63814 product 0 39649 A 0 D 0 0 floor-lamp-circle-b-teal-brass-black-white-cord.jpg Conoco Floor Lamp, 390-Teal, Brass Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39649
27473 63814 product 0 39650 A 0 D 0 0 floor-lamp-circle-b-yellow-galvanized-white-gold-cord.jpg Conoco Floor Lamp, 500-Buttery Yellow, Galvanized Stem, CSGW-Gold & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39650
27446 63814 product 0 39623 A 1 D 0 0 floor-lamp-circle-b-white-galvanized-white-gold-cord.jpg Conoco Floor Lamp, 200-White, Galvanized Stem, CSGW-Gold & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39623
27456 63812 product 0 39633 A 1 D 0 0 floor-lamp-sinclair-blue-galvanized-black-cord.jpg Sinclair Floor Lamp, 700-Royal Blue, Galvanized Stem, SBK-Standard Black Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39633
27477 63811 product 0 39654 A 1 D 0 0 floor-lamp-fargo-magenta-brass-black-white-cord.jpg Fargo Floor Lamp, 490-Magenta, Brass Stem, CSBW-Black & White Cloth Cord 600 600 39654
27480 63815 product 0 39657 A 1 D 0 0 floor-lamp-radial-wave-black-brass-white-gold-cord1466623563576ae64b52236.jpg Fluted Shade Floor Lamp, 100-Black, Brass Stem, CSGW-Gold & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39657
27488 63813 product 0 39665 A 1 C 0 0 getty-lamp-molly.jpg Gladstone Floor Lamp, 200-White, Brass Stem, CSGW-Gold & White Cloth Cord | Feat. Molly Braun 900 600 39665
27437 63814 product 0 39614 A 2 D 0 0 63814_63811_63522_lovell-task-lamp-black-white-cord-plug-switch-detail-web.jpg CSBW-Black & White Cloth Cord with Black Switch and Plug 600 600 39614
27459 63812 product 0 39636 A 2 D 0 0 floor-lamp-sinclair-magenta-brass-black-white-cord.jpg Sinclair Floor Lamp, 490-Magenta, Brass Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39636
27462 63813 product 0 39639 A 2 D 0 0 floor-lamp-wesco-red-glavanized-black-cord.jpg Gladstone Floor Lamp, 400-Barn Red, Galvanized Stem, SBK-Standard Black Cord 600 600 39639
27476 63811 product 0 39653 A 2 D 0 0 floor-lamp-fargo-grey-galvanized-white-gold-cord.jpg Fargo Floor Lamp, 800-Industrial Grey, Galvanized Stem, CSGW-Gold & White Cloth Cord 600 600 39653
27438 63814 product 0 39615 A 3 D 0 0 63814_63811_63522_lovell-white-cord-with-switch-web.jpg SWH-Standard White Cord with White Switch and Plug 600 600 39615
27457 63812 product 0 39634 A 3 D 0 0 floor-lamp-sinclair-grey-brass-white-gold-cord.jpg Sinclair Floor Lamp, 800-Industrial Grey, Brass Stem, CSGW-Gold & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39634
27465 63813 product 0 39642 A 3 D 0 0 floor-lamp-wesco-blush-pink-galvanized-white-cord.jpg Gladstone Floor Lamp, 480-Blush Pink, Galvanized Stem, SWH-Standard White Cord 600 600 39642
27468 63814 product 0 39645 A 3 D 0 0 floor-lamp-circle-b-blue-galvanized-black-cord.jpg Conoco Floor Lamp, 700-Royal Blue, Galvanized Stem, SBK-Standard Black Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39645
27474 63811 product 0 39651 A 3 D 0 0 floor-lamp-fargo-blue-galvanized-white-gold-cord.jpg Fargo Floor Lamp, 700-Royal Blue, Galvanized Stem, CSGW-Gold & White Cloth Cord 600 600 39651
27485 63815 product 0 39662 A 3 D 0 0 floor-lamp-radial-wave-teal-galvanized-black-cord.jpg Fluted Shade Floor Lamp, 390-Teal, Galvanized Stem, SBK-Standard Black Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39662
27461 63812 product 0 39638 A 4 D 0 0 floor-lamp-sinclair-teal-galvanized-white-cord.jpg Sinclair Floor Lamp, 390-Teal, Galvanized Stem, SWH-Standard White Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39638
27464 63813 product 0 39641 A 4 D 0 0 floor-lamp-wesco-gray-brass-black-cord.jpg Gladstone Floor Lamp, 800-Industrial Grey, Brass Stem, SBK-Standard Black Cord 600 600 39641
27478 63811 product 0 39655 A 4 D 0 0 floor-lamp-fargo-pink-galvanized-black-white-cord.jpg Fargo Floor Lamp, 480-Blush Pink, Galvanized Stem, CSBW-Black & White Cloth Cord 600 600 39655
27482 63815 product 0 39659 A 4 D 0 0 floor-lamp-radial-wave-blue-galvanized-white-cord.jpg Fluted Shade Floor Lamp, 700-Royal Blue, Galvanized Stem, SWH-Standard White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39659
27443 63812 product 0 39620 A 5 D 0 0 floor-lamp-sinclair-black-glavanized-white-cord.jpg Sinclair Floor Lamp, 100-Black, Galvanized Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39620
27479 63811 product 0 39656 A 5 D 0 0 floor-lamp-fargo-teal-brass-black-cord.jpg Fargo Floor Lamp, 390-Teal, Brass Stem, SBK-Standard Black Cord 600 600 39656
27486 63815 product 0 39663 A 5 D 0 0 floor-lamp-radial-wave-yellow-galvanized-black-white-cord.jpg Fluted Shade Floor Lamp, 500-Yellow, Galvanized Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39663
28572 63813 product 0 40771 A 5 C 0 0 354B1696.jpg Gladstone Floor Lamp, 100-Black, Brass Stem, CSBW-Black & White Cloth Cord 667 1000 40771
27460 63812 product 0 39637 A 6 D 0 0 floor-lamp-sinclair-pink-galvanized-black-white-cord.jpg Sinclair Floor Lamp, 480-Blush Pink, Galvanized Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39637
27467 63813 product 0 39644 A 6 D 0 0 floor-lamp-wesco-magenta-galvanized-black-white-cord.jpg Gladstone Floor Lamp, 490-Magenta, Galvanized Stem, CSBW-Black & White Cloth Cord 600 600 39644
27475 63811 product 0 39652 A 6 D 0 0 floor-lamp-fargo-yellow-galvanized-black-white-cord.jpg Fargo Floor Lamp, 500-Yellow, Galvanized Stem, CSBW-Black & White Cloth Cord 600 600 39652
27483 63815 product 0 39660 A 6 D 0 0 floor-lamp-radial-wave-magenta-galvanized-black-cord.jpg Fluted Shade Floor Lamp, 490-Magenta, Galvanized Stem, CSBW-Black & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39660
27449 63811 product 0 39626 A 7 D 0 0 floor-lamp-fargo-red-galvanized-black-cord.jpg Fargo Floor Lamp, 400-Barn Red, Galvanized Stem, SBK-Standard Black Cord 600 600 39626
27458 63812 product 0 39635 A 7 D 0 0 floor-lamp-sinclair-yellow-galvanized-white-gold-cord.jpg Sinclair Floor Lamp, 500-Buttery Yellow, Galvanized Stem, CSGW-Gold & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39635
27466 63813 product 0 39643 A 7 D 0 0 floor-lamp-wesco-blush-yellow-galvanized-white-cord.jpg Gladstone Floor Lamp, 500-Buttery Yellow, Galvanized Stem, SWH-Standard White Cord 600 600 39643
27481 63815 product 0 39658 A 7 D 0 0 floor-lamp-radial-wave-grey-brass-white-gold-cord.jpg Fluted Shade Floor Lamp, 800-Industrial Grey, Brass Stem, CSGW-Gold & White Cloth Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39658
27428 63811 product 0 39605 A 8 D 0 0 63811_63522_lovell-white-cord-with-switch-web.jpg SWH-Standard White Cord with White Switch and Plug 600 600 39605
27433 63812 product 0 39610 A 8 D 0 0 63812_63811_63522_lovell-task-lamp-black-white-cord-plug-switch-detail-web.jpg CSBW-Black & White Cloth Cord with Black Switch and Plug 600 600 39610
27452 63813 product 0 39629 A 8 D 0 0 floor-lamp-wesco-black-brass-black-white-cord.jpg Gladstone Floor Lamp, 100-Black, Brass Stem, CSBW-Black & White Cloth Cord 600 600 39629
27455 63815 product 0 39632 A 8 D 0 0 floor-lamp-radial-wave-red-galvanized-black-cord.jpg Fluted Shade Floor Lamp, 400-Barn Red, Galvanized Stem, SWH-Standard Black Cord, Nostalgic Edison 1890 Era 40W Bulb 600 600 39632
27434 63812 product 0 39611 A 9 D 0 0 63812_63811_63522_lovell-white-cord-with-switch-web.jpg SWH-Standard White Cord with White Switch and Plug 600 600 39611
27463 63813 product 0 39640 A 9 D 0 0 floor-lamp-wesco-blue-galvanized-white-cord.jpg Gladstone Floor Lamp, 700-Royal Blue, Galvanized Stem, SWH-Standard White Cord 600 600 39640
63368 63811 product 0 75601 A 9 C 0 0 image1-residential-interior-lighting-Fargo-Floor-Lamp-100-Black-975-Galvanized-Stem-CSB.jpeg Fargo Floor Lamp, 100-Black, 975-Galvanized Stem, CSB-Black Cotton Cord | Photo Courtesy of Homeowner 2253 3573 75601
64045 63812 product 0 76278 A 9 C 0 0 20220129_174250-residential-interior-lighting-reading-Sinclair-Floor-Lamp-106-Matte-Black-Stem-975-Galvanized-Black-Cloth-Cord.jpg Sinclair Floor Lamp, 106-Matte Black, 975-Galvanized, Black Cloth Cord | Photo Courtesy of Homeowner 1786 3367 76278
64046 63812 product 0 76279 A 9 C 0 0 20220129_174327-residential-interior-lighting-reading-Sinclair-Floor-Lamp-106-Matte-Black-Stem-975-Galvanized-Black-Cloth-Cord.jpg Sinclair Floor Lamp, 106-Matte Black, 975-Galvanized, Black Cloth Cord | Photo Courtesy of Homeowner 1800 4000 76279
64899 63812 product 0 77132 A 9 C 0 0 Image__2_-residential-interior-lighting-bedroom-Sinclair-Floor-Lamp-105-Textured-Black-Stem-997-Raw-Brass-SBK-Plug-Switch-100-Black.jpeg Sinclair Floor Lamp, 105-Textured Black Stem, 997-Raw Brass, SBK-Standard Black Cord, Plug Switch, 100-Black | Photo Courtesy of Homeowner 1500 2000 77132
64900 63812 product 0 77133 A 9 C 0 0 Image__1_-residential-interior-lighting-bedroom-Sinclair-Floor-Lamp-105-Textured-Black-Stem-997-Raw-Brass-SBK-Plug-Switch-100-Black.jpeg Sinclair Floor Lamp, 105-Textured Black Stem, 997-Raw Brass, SBK-Standard Black Cord, Plug Switch, 100-Black | Photo Courtesy of Homeowner 1383 1845 77133
64988 63811 product 0 77221 A 9 C 0 0 NathanTurner_0081-residential-interior-lighting-living-couch-Fargo-Floor-Lamp-300-Dark-Green-975-Galvanized.jpg Fargo Floor Lamp, 300-Dark Green, 975-Galvanized Stem | Photo Courtesy of Nathan Turner 1194 1756 77221
27435 63813 product 0 39612 A 10 D 0 0 63813_63812_63811_63522_lovell-task-lamp-black-white-cord-plug-switch-detail-web.jpg CSBW-Black & White Cloth Cord with Black Switch and Plug 600 600 39612
27436 63813 product 0 39613 A 11 D 0 0 63813_63812_63811_63522_lovell-white-cord-with-switch-web.jpg SWH-Standard White Cord with White Switch and Plug 600 600 39613
52019 63813 product 0 64252 A 11 C 0 0 floor_lamp_lighting-512x768.jpg Gladstone Floor Lamp, 100-Black, Brass Stem, CSBW-Black & White Cloth Cord 512 768 64252
52020 63813 product 0 64253 A 11 C 0 0 ce373266ac8dc4a4e3d724af0a9722c9.jpg Gladstone Floor Lamp, 200-White, Brass Stem, CSGW-Gold & White Cloth Cord | Feat. Molly Braun 564 846 64253
66854 63813 product 0 79087 A 11 C 0 0 residential-interior-furniture-Winston_Wall_Shelf-Golden-Pine-Matte-206-Matte-White-Gladstone-Floor-Lamp-206-Matte-White-975-Galvanized-Stem-Gold-White-Cloth-Cord-200-White-Plug-Switch.jpeg Gladstone Floor Lamp, 206-Matte White, 975-Galvanized Stem, Gold & White Cloth Cord, 200-White Plug Switch | Customer Submission 3394 2941 79087