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 (
    48839, 48840, 35730, 35814, 35819, 35824, 
    35829, 35834, 35839, 35810, 35811, 
    35812, 35813, 35731, 35847, 35851, 
    35844, 35845, 35846, 35729, 35792, 
    35798, 35804, 35787, 35788, 35789, 
    35790, 35791, 16819, 16818, 5455, 31972, 
    31967, 31872, 31977, 31982, 31986, 
    31987, 31988, 31989, 35732, 35859, 
    35864, 35869, 35874, 35860, 35861, 
    35862, 35863, 15700, 15699, 15698, 
    15697, 15696, 15695, 15694, 5958, 16781, 
    16780, 16779, 16778, 16777, 5476, 189, 
    26409, 26410, 26411, 26412, 26413, 
    18244, 4465, 18334, 18333, 18332, 4362, 
    33606, 33622, 33625, 33628, 33631, 
    33620, 33621, 15693, 15692, 15691, 
    15690, 15689, 15688, 15687, 15686, 
    15685, 5959
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00622

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": 125,
              "filtered": 73.59999847,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (48839,48840,35730,35814,35819,35824,35829,35834,35839,35810,35811,35812,35813,35731,35847,35851,35844,35845,35846,35729,35792,35798,35804,35787,35788,35789,35790,35791,16819,16818,5455,31972,31967,31872,31977,31982,31986,31987,31988,31989,35732,35859,35864,35869,35874,35860,35861,35862,35863,15700,15699,15698,15697,15696,15695,15694,5958,16781,16780,16779,16778,16777,5476,189,26409,26410,26411,26412,26413,18244,4465,18334,18333,18332,4362,33606,33622,33625,33628,33631,33620,33621,15693,15692,15691,15690,15689,15688,15687,15686,15685,5959)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}