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.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 = 'ro' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    1660621, 1663150, 1664049, 1658333, 
    1658334, 1664157, 1658506, 1657840, 
    1657777, 1658557, 1661197, 1662527, 
    1658427, 1658811, 1658265, 1663182, 
    1658593, 1660401, 1658270, 1663613, 
    1659564, 1658864, 1657833, 1662451, 
    1661407, 1659246, 1663612, 2099795, 
    1660547, 1660154, 1659920, 1659832, 
    1658398, 1658504, 1661697, 1661022
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.01274

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "191.71"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "36.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_images_links",
            "access_type": "range",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type",
              "type"
            ],
            "key_length": "81",
            "rows_examined_per_scan": 36,
            "rows_produced_per_join": 36,
            "filtered": "100.00",
            "index_condition": "((`maniamall_cscart`.`cscart_images_links`.`object_type` = 'product') and (`maniamall_cscart`.`cscart_images_links`.`type` = 'M') and (`maniamall_cscart`.`cscart_images_links`.`object_id` in (1660621,1663150,1664049,1658333,1658334,1664157,1658506,1657840,1657777,1658557,1661197,1662527,1658427,1658811,1658265,1663182,1658593,1660401,1658270,1663613,1659564,1658864,1657833,1662451,1661407,1659246,1663612,2099795,1660547,1660154,1659920,1659832,1658398,1658504,1661697,1661022)))",
            "cost_info": {
              "read_cost": "73.21",
              "eval_cost": "3.60",
              "prefix_cost": "76.81",
              "data_read_per_join": "3K"
            },
            "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": "3",
            "ref": [
              "maniamall_cscart.cscart_images_links.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 36,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "35.93",
              "eval_cost": "3.60",
              "prefix_cost": "116.34",
              "data_read_per_join": "27K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_images), (`maniamall_cscart`.`cscart_images_links`.`image_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
          }
        },
        {
          "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": [
              "maniamall_cscart.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 36,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "35.77",
              "eval_cost": "3.60",
              "prefix_cost": "155.71",
              "data_read_per_join": "21K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`maniamall_cscart`.`cscart_common_descriptions`.`object_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_path alt image_x image_y images_image_id
3642880 1657777 product 0 3643133 M 0
3642942 1657833 product 0 3643195 M 0
3642949 1657840 product 0 3643202 M 0
3643505 1658265 product 0 3643758 M 0
3643510 1658270 product 0 3643763 M 0
3643578 1658333 product 0 3643831 M 0
3643579 1658334 product 0 3643832 M 0
3643644 1658398 product 0 3643897 M 0
3643677 1658427 product 0 3643930 M 0
3643758 1658504 product 0 3644011 M 0
3643760 1658506 product 0 3644013 M 0
3643811 1658557 product 0 3644064 M 0
3643851 1658593 product 0 3644104 M 0
3644080 1658811 product 0 3644333 M 0
3644136 1658864 product 0 3644389 M 0
3644537 1659246 product 0 3644790 M 0
3644869 1659564 product 0 3645122 M 0
3645142 1659832 product 0 3645395 M 0
3645231 1659920 product 0 3645484 M 0
3645476 1660154 product 0 3645729 M 0
3645727 1660401 product 0 3645980 M 0
3645873 1660547 product 0 3646126 M 0
3645947 1660621 product 0 3646200 M 0
3646365 1661022 product 0 3646618 M 0
3646541 1661197 product 0 3646794 M 0
3646754 1661407 product 0 3647007 M 0
3647044 1661697 product 0 3647297 M 0
3647793 1662451 product 0 3648046 M 0
3647869 1662527 product 0 3648122 M 0
3648492 1663150 product 0 3648745 M 0
3648524 1663182 product 0 3648777 M 0
3648954 1663612 product 0 3649207 M 0
3648955 1663613 product 0 3649208 M 0
3649399 1664049 product 0 3649652 M 0
3649507 1664157 product 0 3649760 M 0
5161675 2099795 product 0 5161928 M 0