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 (
    65891, 65892, 65893, 65894, 65903, 65904, 
    65905, 65906, 65907, 65908, 65994, 
    65996, 65998, 65999, 66000, 66002, 
    66057, 66058, 68990, 68991, 68992, 
    68993, 68994, 68995
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00158

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "710.95"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "199.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": 199,
            "rows_produced_per_join": 199,
            "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 (65891,65892,65893,65894,65903,65904,65905,65906,65907,65908,65994,65996,65998,65999,66000,66002,66057,66058,68990,68991,68992,68993,68994,68995)))",
            "cost_info": {
              "read_cost": "160.99",
              "eval_cost": "19.90",
              "prefix_cost": "180.89",
              "data_read_per_join": "18K"
            },
            "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": 199,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "155.03",
              "eval_cost": "19.90",
              "prefix_cost": "355.82",
              "data_read_per_join": "152K"
            },
            "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": 199,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "136.24",
              "eval_cost": "19.90",
              "prefix_cost": "511.95",
              "data_read_per_join": "118K"
            },
            "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 179365 65994 product 180711 A 1
0 179383 65996 product 180729 A 1
0 179402 65998 product 180748 A 1
0 179412 65999 product 180758 A 1
0 179422 66000 product 180768 A 1
0 179442 66002 product 180788 A 1
0 179564 65891 product 180910 A 1
0 179573 65892 product 180919 A 1
0 179582 65893 product 180928 A 1
0 179591 65894 product 180937 A 1
0 179672 65903 product 181018 A 1
0 179681 65904 product 181027 A 1
0 179690 65905 product 181036 A 1
0 179699 65906 product 181045 A 1
0 179708 65907 product 181054 A 1
0 179717 65908 product 181063 A 1
0 180929 66057 product 182275 A 1
0 180938 66058 product 182284 A 1
0 202132 68990 product 203416 A 1
0 202148 68992 product 203432 A 1
0 202156 68993 product 203440 A 1
0 202164 68994 product 203448 A 1
0 202172 68995 product 203456 A 1
0 204155 68991 product 205439 A 1
0 179366 65994 product 180712 A 2
0 179384 65996 product 180730 A 2
0 179403 65998 product 180749 A 2
0 179413 65999 product 180759 A 2
0 179423 66000 product 180769 A 2
0 179443 66002 product 180789 A 2
0 179565 65891 product 180911 A 2
0 179574 65892 product 180920 A 2
0 179583 65893 product 180929 A 2
0 179592 65894 product 180938 A 2
0 179673 65903 product 181019 A 2
0 179682 65904 product 181028 A 2
0 179691 65905 product 181037 A 2
0 179700 65906 product 181046 A 2
0 179709 65907 product 181055 A 2
0 179718 65908 product 181064 A 2
0 180930 66057 product 182276 A 2
0 180939 66058 product 182285 A 2
0 204154 68990 product 205438 A 2
0 204163 68992 product 205447 A 2
0 204177 68993 product 205461 A 2
0 204184 68991 product 205468 A 2
0 204199 68994 product 205483 A 2
0 204206 68995 product 205490 A 2
0 179367 65994 product 180713 A 3
0 179385 65996 product 180731 A 3
0 179404 65998 product 180750 A 3
0 179414 65999 product 180760 A 3
0 179424 66000 product 180770 A 3
0 179444 66002 product 180790 A 3
0 179566 65891 product 180912 A 3
0 179575 65892 product 180921 A 3
0 179584 65893 product 180930 A 3
0 179593 65894 product 180939 A 3
0 179674 65903 product 181020 A 3
0 179683 65904 product 181029 A 3
0 179692 65905 product 181038 A 3
0 179701 65906 product 181047 A 3
0 179710 65907 product 181056 A 3
0 179719 65908 product 181065 A 3
0 180931 66057 product 182277 A 3
0 180940 66058 product 182286 A 3
0 204164 68992 product 205448 A 3
0 204170 68990 product 205454 A 3
0 204178 68993 product 205462 A 3
0 204185 68991 product 205469 A 3
0 204200 68994 product 205484 A 3
0 204207 68995 product 205491 A 3
0 179368 65994 product 180714 A 4
0 179386 65996 product 180732 A 4
0 179405 65998 product 180751 A 4
0 179415 65999 product 180761 A 4
0 179425 66000 product 180771 A 4
0 179445 66002 product 180791 A 4
0 179567 65891 product 180913 A 4
0 179576 65892 product 180922 A 4
0 179585 65893 product 180931 A 4
0 179594 65894 product 180940 A 4
0 179675 65903 product 181021 A 4
0 179684 65904 product 181030 A 4
0 179693 65905 product 181039 A 4
0 179702 65906 product 181048 A 4
0 179711 65907 product 181057 A 4
0 179720 65908 product 181066 A 4
0 180932 66057 product 182278 A 4
0 180941 66058 product 182287 A 4
0 204165 68992 product 205449 A 4
0 204171 68990 product 205455 A 4
0 204179 68993 product 205463 A 4
0 204186 68991 product 205470 A 4
0 204201 68994 product 205485 A 4
0 204208 68995 product 205492 A 4
0 179369 65994 product 180715 A 5
0 179387 65996 product 180733 A 5
0 179406 65998 product 180752 A 5
0 179416 65999 product 180762 A 5
0 179426 66000 product 180772 A 5
0 179446 66002 product 180792 A 5
0 179568 65891 product 180914 A 5
0 179577 65892 product 180923 A 5
0 179586 65893 product 180932 A 5
0 179595 65894 product 180941 A 5
0 179676 65903 product 181022 A 5
0 179685 65904 product 181031 A 5
0 179694 65905 product 181040 A 5
0 179703 65906 product 181049 A 5
0 179712 65907 product 181058 A 5
0 179721 65908 product 181067 A 5
0 180933 66057 product 182279 A 5
0 180942 66058 product 182288 A 5
0 204166 68992 product 205450 A 5
0 204172 68990 product 205456 A 5
0 204180 68993 product 205464 A 5
0 204187 68991 product 205471 A 5
0 204202 68994 product 205486 A 5
0 204209 68995 product 205493 A 5
0 179370 65994 product 180716 A 6
0 179388 65996 product 180734 A 6
0 179407 65998 product 180753 A 6
0 179417 65999 product 180763 A 6
0 179427 66000 product 180773 A 6
0 179447 66002 product 180793 A 6
0 179569 65891 product 180915 A 6
0 179578 65892 product 180924 A 6
0 179587 65893 product 180933 A 6
0 179596 65894 product 180942 A 6
0 179677 65903 product 181023 A 6
0 179686 65904 product 181032 A 6
0 179695 65905 product 181041 A 6
0 179704 65906 product 181050 A 6
0 179713 65907 product 181059 A 6
0 179722 65908 product 181068 A 6
0 180934 66057 product 182280 A 6
0 180943 66058 product 182289 A 6
0 204167 68992 product 205451 A 6
0 204173 68990 product 205457 A 6
0 204181 68993 product 205465 A 6
0 204188 68991 product 205472 A 6
0 204203 68994 product 205487 A 6
0 204210 68995 product 205494 A 6
0 179371 65994 product 180717 A 7
0 179389 65996 product 180735 A 7
0 179408 65998 product 180754 A 7
0 179418 65999 product 180764 A 7
0 179428 66000 product 180774 A 7
0 179448 66002 product 180794 A 7
0 179570 65891 product 180916 A 7
0 179579 65892 product 180925 A 7
0 179588 65893 product 180934 A 7
0 179597 65894 product 180943 A 7
0 179678 65903 product 181024 A 7
0 179687 65904 product 181033 A 7
0 179696 65905 product 181042 A 7
0 179705 65906 product 181051 A 7
0 179714 65907 product 181060 A 7
0 179723 65908 product 181069 A 7
0 180935 66057 product 182281 A 7
0 180944 66058 product 182290 A 7
0 204168 68992 product 205452 A 7
0 204174 68990 product 205458 A 7
0 204182 68993 product 205466 A 7
0 204189 68991 product 205473 A 7
0 204204 68994 product 205488 A 7
0 204211 68995 product 205495 A 7
0 179372 65994 product 180718 A 8
0 179390 65996 product 180736 A 8
0 179409 65998 product 180755 A 8
0 179419 65999 product 180765 A 8
0 179429 66000 product 180775 A 8
0 179449 66002 product 180795 A 8
0 179571 65891 product 180917 A 8
0 179580 65892 product 180926 A 8
0 179589 65893 product 180935 A 8
0 179598 65894 product 180944 A 8
0 179679 65903 product 181025 A 8
0 179688 65904 product 181034 A 8
0 179697 65905 product 181043 A 8
0 179706 65906 product 181052 A 8
0 179715 65907 product 181061 A 8
0 179724 65908 product 181070 A 8
0 180936 66057 product 182282 A 8
0 180945 66058 product 182291 A 8
0 204169 68992 product 205453 A 8
0 204175 68990 product 205459 A 8
0 204183 68993 product 205467 A 8
0 204190 68991 product 205474 A 8
0 204205 68994 product 205489 A 8
0 204212 68995 product 205496 A 8
0 179410 65998 product 180756 A 9
0 179420 65999 product 180766 A 9
0 179430 66000 product 180776 A 9
0 179450 66002 product 180796 A 9
0 180946 66058 product 182292 A 9
0 204176 68990 product 205460 A 9
0 180947 66058 product 182293 A 10