SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_id AS images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.image_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 (
    7985, 7986, 8040, 9545, 13134, 13136, 
    13146, 15999, 16000, 16001, 19743, 
    19745, 19746, 19747, 19749, 19750, 
    19751, 19752, 19753, 19754, 29970, 
    29971, 64687, 69464
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00157

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "646.90"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "158.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_images_links",
            "access_type": "range",
            "possible_keys": [
              "object_id",
              "idx_object_type_type_position"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type",
              "type"
            ],
            "key_length": "81",
            "rows_examined_per_scan": 158,
            "rows_produced_per_join": 158,
            "filtered": "100.00",
            "index_condition": "((`cscart_db`.`cscart_images_links`.`object_type` = 'product') and (`cscart_db`.`cscart_images_links`.`type` = 'A') and (`cscart_db`.`cscart_images_links`.`object_id` in (7985,7986,8040,9545,13134,13136,13146,15999,16000,16001,19743,19745,19746,19747,19749,19750,19751,19752,19753,19754,29970,29971,64687,69464)))",
            "cost_info": {
              "read_cost": "172.07",
              "eval_cost": "15.80",
              "prefix_cost": "187.87",
              "data_read_per_join": "14K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "cscart_db.cscart_images_links.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 158,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "139.38",
              "eval_cost": "15.80",
              "prefix_cost": "343.06",
              "data_read_per_join": "120K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "107",
            "ref": [
              "cscart_db.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 158,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "130.05",
              "eval_cost": "15.80",
              "prefix_cost": "488.90",
              "data_read_per_join": "93K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`cscart_db`.`cscart_common_descriptions`.`object_id` = `cscart_db`.`cscart_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res pair_id object_id object_type detailed_id type position alt images_image_id
0 20722 7985 product 22074 A 1
0 20725 7986 product 22077 A 1
0 46667 13134 product 48019 A 1
0 46681 13136 product 48033 A 1
0 46779 13146 product 48131 A 1
0 58581 15999 product 59933 A 1
0 58589 16000 product 59941 A 1
0 58597 16001 product 59949 A 1
0 76464 19743 product 77816 A 1
0 76480 19745 product 77832 A 1
0 76489 19746 product 77841 A 1
0 76490 19747 product 77842 A 1
0 76512 19749 product 77864 A 1
0 76520 19750 product 77872 A 1
0 76528 19751 product 77880 A 1
0 76536 19752 product 77888 A 1
0 76544 19753 product 77896 A 1
0 76552 19754 product 77904 A 1
0 114216 29970 product 115568 A 1
0 114224 29971 product 115576 A 1
0 20723 7985 product 22075 A 2
0 20726 7986 product 22078 A 2
0 46668 13134 product 48020 A 2
0 46682 13136 product 48034 A 2
0 58582 15999 product 59934 A 2
0 58590 16000 product 59942 A 2
0 58598 16001 product 59950 A 2
0 64803 9545 product 66155 A 2
0 76465 19743 product 77817 A 2
0 76481 19745 product 77833 A 2
0 76491 19746 product 77843 A 2
0 76492 19747 product 77844 A 2
0 76513 19749 product 77865 A 2
0 76521 19750 product 77873 A 2
0 76529 19751 product 77881 A 2
0 76537 19752 product 77889 A 2
0 76545 19753 product 77897 A 2
0 76553 19754 product 77905 A 2
0 114217 29970 product 115569 A 2
0 114225 29971 product 115577 A 2
0 21017 8040 product 22369 A 3
0 46669 13134 product 48021 A 3
0 46683 13136 product 48035 A 3
0 58583 15999 product 59935 A 3
0 58591 16000 product 59943 A 3
0 58599 16001 product 59951 A 3
0 64804 9545 product 66156 A 3
0 76466 19743 product 77818 A 3
0 76482 19745 product 77834 A 3
0 76493 19746 product 77845 A 3
0 76494 19747 product 77846 A 3
0 76514 19749 product 77866 A 3
0 76522 19750 product 77874 A 3
0 76530 19751 product 77882 A 3
0 76538 19752 product 77890 A 3
0 76546 19753 product 77898 A 3
0 76554 19754 product 77906 A 3
0 114218 29970 product 115570 A 3
0 114226 29971 product 115578 A 3
0 21018 8040 product 22370 A 4
0 46670 13134 product 48022 A 4
0 46684 13136 product 48036 A 4
0 58584 15999 product 59936 A 4
0 58592 16000 product 59944 A 4
0 58600 16001 product 59952 A 4
0 64805 9545 product 66157 A 4
0 76467 19743 product 77819 A 4
0 76483 19745 product 77835 A 4
0 76495 19746 product 77847 A 4
0 76496 19747 product 77848 A 4
0 76515 19749 product 77867 A 4
0 76523 19750 product 77875 A 4
0 76531 19751 product 77883 A 4
0 76539 19752 product 77891 A 4
0 76547 19753 product 77899 A 4
0 76555 19754 product 77907 A 4
0 114219 29970 product 115571 A 4
0 114227 29971 product 115579 A 4
0 21019 8040 product 22371 A 5
0 46671 13134 product 48023 A 5
0 46685 13136 product 48037 A 5
0 58585 15999 product 59937 A 5
0 58593 16000 product 59945 A 5
0 58601 16001 product 59953 A 5
0 64806 9545 product 66158 A 5
0 76468 19743 product 77820 A 5
0 76484 19745 product 77836 A 5
0 76497 19746 product 77849 A 5
0 76498 19747 product 77850 A 5
0 76516 19749 product 77868 A 5
0 76524 19750 product 77876 A 5
0 76532 19751 product 77884 A 5
0 76540 19752 product 77892 A 5
0 76548 19753 product 77900 A 5
0 76556 19754 product 77908 A 5
0 114220 29970 product 115572 A 5
0 114228 29971 product 115580 A 5
0 21020 8040 product 22372 A 6
0 46672 13134 product 48024 A 6
0 46686 13136 product 48038 A 6
0 58586 15999 product 59938 A 6
0 58594 16000 product 59946 A 6
0 58602 16001 product 59954 A 6
0 64807 9545 product 66159 A 6
0 76469 19743 product 77821 A 6
0 76485 19745 product 77837 A 6
0 76499 19746 product 77851 A 6
0 76500 19747 product 77852 A 6
0 76517 19749 product 77869 A 6
0 76525 19750 product 77877 A 6
0 76533 19751 product 77885 A 6
0 76541 19752 product 77893 A 6
0 76549 19753 product 77901 A 6
0 76557 19754 product 77909 A 6
0 114221 29970 product 115573 A 6
0 114229 29971 product 115581 A 6
0 21021 8040 product 22373 A 7
0 58587 15999 product 59939 A 7
0 58595 16000 product 59947 A 7
0 58603 16001 product 59955 A 7
0 64808 9545 product 66160 A 7
0 76470 19743 product 77822 A 7
0 76486 19745 product 77838 A 7
0 76501 19746 product 77853 A 7
0 76502 19747 product 77854 A 7
0 76518 19749 product 77870 A 7
0 76526 19750 product 77878 A 7
0 76534 19751 product 77886 A 7
0 76542 19752 product 77894 A 7
0 76550 19753 product 77902 A 7
0 76558 19754 product 77910 A 7
0 114222 29970 product 115574 A 7
0 114230 29971 product 115582 A 7
0 21022 8040 product 22374 A 8
0 64809 9545 product 66161 A 8
0 21023 8040 product 22375 A 9
0 64810 9545 product 66162 A 9
0 21024 8040 product 22376 A 10
0 65212 9545 product 66564 A 10
0 207856 69464 product 209131 A 10
0 65213 9545 product 66565 A 11
0 65214 9545 product 66566 A 12
0 65215 9545 product 66567 A 13
0 65216 9545 product 66568 A 14
0 207857 69464 product 209132 A 20
0 207858 69464 product 209133 A 30
0 207859 69464 product 209134 A 40
0 207860 69464 product 209135 A 50
0 207861 69464 product 209136 A 60
0 207862 69464 product 209137 A 70
0 207863 69464 product 209138 A 80
0 207864 69464 product 209139 A 90
0 207865 69464 product 209140 A 100
0 207866 69464 product 209141 A 110
0 207867 69464 product 209142 A 120
0 207868 69464 product 209143 A 130
0 207869 69464 product 209144 A 140