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 (
    66077, 66079, 66082, 66084, 66369, 66371, 
    66386, 66681, 66682, 66683, 66685, 
    66687, 66692, 66694, 66695, 67273, 
    68901, 68904, 68906, 68978, 68979, 
    68980, 68981, 68982
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00184

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "572.01"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "201.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": 201,
            "rows_produced_per_join": 201,
            "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 (66077,66079,66082,66084,66369,66371,66386,66681,66682,66683,66685,66687,66692,66694,66695,67273,68901,68904,68906,68978,68979,68980,68981,68982)))",
            "cost_info": {
              "read_cost": "125.02",
              "eval_cost": "20.10",
              "prefix_cost": "145.12",
              "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": 201,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "101.82",
              "eval_cost": "20.10",
              "prefix_cost": "267.04",
              "data_read_per_join": "153K"
            },
            "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": 201,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "83.88",
              "eval_cost": "20.10",
              "prefix_cost": "371.01",
              "data_read_per_join": "119K"
            },
            "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 181268 66077 product 182614 A 1
0 181290 66079 product 182636 A 1
0 181323 66082 product 182669 A 1
0 181345 66084 product 182691 A 1
0 181775 66369 product 183121 A 1
0 181783 66371 product 183129 A 1
0 181882 66386 product 183228 A 1
0 183549 66681 product 184895 A 1
0 183559 66682 product 184905 A 1
0 183569 66683 product 184915 A 1
0 183589 66685 product 184935 A 1
0 183609 66687 product 184955 A 1
0 183659 66692 product 185005 A 1
0 183681 66694 product 185027 A 1
0 183692 66695 product 185038 A 1
0 187973 67273 product 189311 A 1
0 203764 68979 product 205048 A 1
0 204049 68978 product 205333 A 1
0 181269 66077 product 182615 A 2
0 181291 66079 product 182637 A 2
0 181324 66082 product 182670 A 2
0 181346 66084 product 182692 A 2
0 181776 66369 product 183122 A 2
0 181784 66371 product 183130 A 2
0 181883 66386 product 183229 A 2
0 183550 66681 product 184896 A 2
0 183565 66682 product 184911 A 2
0 183570 66683 product 184916 A 2
0 183590 66685 product 184936 A 2
0 183610 66687 product 184956 A 2
0 183660 66692 product 185006 A 2
0 183682 66694 product 185028 A 2
0 183693 66695 product 185039 A 2
0 187974 67273 product 189312 A 2
0 204091 68978 product 205375 A 2
0 204095 68979 product 205379 A 2
0 181270 66077 product 182616 A 3
0 181292 66079 product 182638 A 3
0 181325 66082 product 182671 A 3
0 181347 66084 product 182693 A 3
0 181777 66369 product 183123 A 3
0 181785 66371 product 183131 A 3
0 181884 66386 product 183230 A 3
0 183551 66681 product 184897 A 3
0 183560 66682 product 184906 A 3
0 183571 66683 product 184917 A 3
0 183591 66685 product 184937 A 3
0 183611 66687 product 184957 A 3
0 183661 66692 product 185007 A 3
0 183683 66694 product 185029 A 3
0 183694 66695 product 185040 A 3
0 187975 67273 product 189313 A 3
0 204092 68978 product 205376 A 3
0 204096 68979 product 205380 A 3
0 181271 66077 product 182617 A 4
0 181293 66079 product 182639 A 4
0 181326 66082 product 182672 A 4
0 181348 66084 product 182694 A 4
0 181786 66371 product 183132 A 4
0 181885 66386 product 183231 A 4
0 183552 66681 product 184898 A 4
0 183566 66682 product 184912 A 4
0 183572 66683 product 184918 A 4
0 183592 66685 product 184938 A 4
0 183612 66687 product 184958 A 4
0 183662 66692 product 185008 A 4
0 183684 66694 product 185030 A 4
0 183695 66695 product 185041 A 4
0 187976 67273 product 189314 A 4
0 204052 68978 product 205336 A 4
0 204097 68979 product 205381 A 4
0 181272 66077 product 182618 A 5
0 181294 66079 product 182640 A 5
0 181327 66082 product 182673 A 5
0 181349 66084 product 182695 A 5
0 181787 66371 product 183133 A 5
0 181886 66386 product 183232 A 5
0 183553 66681 product 184899 A 5
0 183561 66682 product 184907 A 5
0 183573 66683 product 184919 A 5
0 183593 66685 product 184939 A 5
0 183613 66687 product 184959 A 5
0 183663 66692 product 185009 A 5
0 183685 66694 product 185031 A 5
0 183696 66695 product 185042 A 5
0 204053 68978 product 205337 A 5
0 204098 68979 product 205382 A 5
0 181273 66077 product 182619 A 6
0 181295 66079 product 182641 A 6
0 181328 66082 product 182674 A 6
0 181350 66084 product 182696 A 6
0 181788 66371 product 183134 A 6
0 181887 66386 product 183233 A 6
0 183554 66681 product 184900 A 6
0 183564 66682 product 184910 A 6
0 183574 66683 product 184920 A 6
0 183594 66685 product 184940 A 6
0 183614 66687 product 184960 A 6
0 183664 66692 product 185010 A 6
0 183686 66694 product 185032 A 6
0 183697 66695 product 185043 A 6
0 204093 68978 product 205377 A 6
0 204099 68979 product 205383 A 6
0 181274 66077 product 182620 A 7
0 181296 66079 product 182642 A 7
0 181329 66082 product 182675 A 7
0 181351 66084 product 182697 A 7
0 181789 66371 product 183135 A 7
0 183555 66681 product 184901 A 7
0 183563 66682 product 184909 A 7
0 183575 66683 product 184921 A 7
0 183595 66685 product 184941 A 7
0 183615 66687 product 184961 A 7
0 183665 66692 product 185011 A 7
0 183687 66694 product 185033 A 7
0 183698 66695 product 185044 A 7
0 204094 68978 product 205378 A 7
0 204100 68979 product 205384 A 7
0 181275 66077 product 182621 A 8
0 181297 66079 product 182643 A 8
0 181330 66082 product 182676 A 8
0 181352 66084 product 182698 A 8
0 181790 66371 product 183136 A 8
0 183556 66681 product 184902 A 8
0 183562 66682 product 184908 A 8
0 183576 66683 product 184922 A 8
0 183596 66685 product 184942 A 8
0 183616 66687 product 184962 A 8
0 183666 66692 product 185012 A 8
0 183688 66694 product 185034 A 8
0 183699 66695 product 185045 A 8
0 181276 66077 product 182622 A 9
0 181298 66079 product 182644 A 9
0 181331 66082 product 182677 A 9
0 181353 66084 product 182699 A 9
0 183558 66681 product 184904 A 9
0 183568 66682 product 184914 A 9
0 183578 66683 product 184924 A 9
0 183598 66685 product 184944 A 9
0 183618 66687 product 184964 A 9
0 183668 66692 product 185014 A 9
0 183690 66694 product 185036 A 9
0 183701 66695 product 185047 A 9
0 181277 66077 product 182623 A 10
0 181299 66079 product 182645 A 10
0 181332 66082 product 182678 A 10
0 181354 66084 product 182700 A 10
0 183669 66692 product 185015 A 10
0 183691 66694 product 185037 A 10
0 183702 66695 product 185048 A 10
0 200750 68901 product 202034 A 10
0 200782 68904 product 202066 A 10
0 200804 68906 product 202088 A 10
0 203771 68980 product 205055 A 10
0 203778 68981 product 205062 A 10
0 204063 68982 product 205347 A 10
0 200751 68901 product 202035 A 20
0 200783 68904 product 202067 A 20
0 200805 68906 product 202089 A 20
0 203772 68980 product 205056 A 20
0 203779 68981 product 205063 A 20
0 204064 68982 product 205348 A 20
0 200752 68901 product 202036 A 30
0 200784 68904 product 202068 A 30
0 200806 68906 product 202090 A 30
0 203773 68980 product 205057 A 30
0 203780 68981 product 205064 A 30
0 204065 68982 product 205349 A 30
0 200753 68901 product 202037 A 40
0 200785 68904 product 202069 A 40
0 200807 68906 product 202091 A 40
0 203774 68980 product 205058 A 40
0 203781 68981 product 205065 A 40
0 204066 68982 product 205350 A 40
0 200754 68901 product 202038 A 50
0 200786 68904 product 202070 A 50
0 200808 68906 product 202092 A 50
0 203775 68980 product 205059 A 50
0 203782 68981 product 205066 A 50
0 204067 68982 product 205351 A 50
0 200755 68901 product 202039 A 60
0 200787 68904 product 202071 A 60
0 200809 68906 product 202093 A 60
0 203776 68980 product 205060 A 60
0 203783 68981 product 205067 A 60
0 204068 68982 product 205352 A 60
0 200756 68901 product 202040 A 70
0 200788 68904 product 202072 A 70
0 200810 68906 product 202094 A 70
0 203777 68980 product 205061 A 70
0 203784 68981 product 205068 A 70
0 204069 68982 product 205353 A 70
0 200757 68901 product 202041 A 80
0 200789 68904 product 202073 A 80
0 200811 68906 product 202095 A 80
0 200758 68901 product 202042 A 90
0 200790 68904 product 202074 A 90
0 200812 68906 product 202096 A 90
0 200759 68901 product 202043 A 100
0 200791 68904 product 202075 A 100
0 200813 68906 product 202097 A 100