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.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 = 'vi' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    31636, 31816, 49806, 41293, 31637, 31817, 
    18766, 18765, 3876, 48980, 48982, 48985, 
    48984, 48983, 43834, 43824, 43835, 
    43836, 43837, 43838, 2305, 27126, 22183, 
    22178, 22177, 22176, 22175, 22174, 
    35730, 35814, 35819, 35824, 35829, 
    35834, 35839, 35810, 35811, 35812, 
    35813, 18817, 18816, 18815, 18814, 
    18813, 18812, 3864, 35731, 35847, 35851, 
    35844, 35845, 35846, 3638, 49192, 49194, 
    49193, 464, 25550, 25551, 632, 24935, 
    24936, 24937, 47170, 47169, 47163, 
    1323, 23426, 23427, 23428, 23429, 40464, 
    47171, 47162
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00147

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
            "table": {
              "table_name": "cscart_images_links",
              "access_type": "ALL",
              "possible_keys": ["object_id"],
              "rows": 110,
              "filtered": 67.27272797,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (31636,31816,49806,41293,31637,31817,18766,18765,3876,48980,48982,48985,48984,48983,43834,43824,43835,43836,43837,43838,2305,27126,22183,22178,22177,22176,22175,22174,35730,35814,35819,35824,35829,35834,35839,35810,35811,35812,35813,18817,18816,18815,18814,18813,18812,3864,35731,35847,35851,35844,35845,35846,3638,49192,49194,49193,464,25550,25551,632,24935,24936,24937,47170,47169,47163,1323,23426,23427,23428,23429,40464,47171,47162)"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "cscart_images",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "4",
          "used_key_parts": ["image_id"],
          "ref": ["dev_db.cscart_images_links.detailed_id"],
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "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": ["dev_db.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 = 'vi' and trigcond(cscart_images.image_id is not null))"
        }
      }
    ]
  }
}