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 (
    35813, 35818, 35823, 35828, 35833, 35838, 
    35843, 35829, 35830, 35831, 35832, 
    35729, 35792, 35798, 35804, 35805, 
    35806, 35807, 35808, 35809, 31971, 
    31966, 31986, 31976, 31981, 31967, 
    31968, 31969, 31970, 35732, 35859, 
    35864, 35869, 35874, 35860, 35861, 
    35862, 35863, 18244, 4465, 18334, 18333, 
    18332, 4362, 33606, 33622, 33625, 33628, 
    33631, 33626, 33627, 16776, 16775, 
    16774, 16773, 5478, 18337, 18336, 18335, 
    4361, 16772, 16771, 16770, 16769, 16768, 
    5479, 18320, 4366, 18338, 4360, 16757, 
    16756, 16755, 16754, 5485, 18344, 18343, 
    18342, 4358, 18245, 4464, 18243, 4466, 
    18341, 18340, 18339, 4359, 16767, 16766, 
    16765, 16764, 16763, 5481, 18347, 18346, 
    18345, 4357
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00245

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": 77.59999847,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (35813,35818,35823,35828,35833,35838,35843,35829,35830,35831,35832,35729,35792,35798,35804,35805,35806,35807,35808,35809,31971,31966,31986,31976,31981,31967,31968,31969,31970,35732,35859,35864,35869,35874,35860,35861,35862,35863,18244,4465,18334,18333,18332,4362,33606,33622,33625,33628,33631,33626,33627,16776,16775,16774,16773,5478,18337,18336,18335,4361,16772,16771,16770,16769,16768,5479,18320,4366,18338,4360,16757,16756,16755,16754,5485,18344,18343,18342,4358,18245,4464,18243,4466,18341,18340,18339,4359,16767,16766,16765,16764,16763,5481,18347,18346,18345,4357)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}