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 (
    45242, 45521, 45522, 45523, 45524, 45525, 
    33700, 33770, 44878, 45056, 45057, 
    45058, 45059, 45060, 45061, 45062, 
    45063, 45064, 45031, 45032, 44874, 
    40652, 40656, 40655, 40654, 40653, 
    40651, 40650, 40536, 36659, 36660, 
    44877, 45044, 45045, 45046, 45047, 
    45048, 45049, 45050, 45051, 45052, 
    45053, 45054, 45055, 45011, 45010, 
    45009, 44873, 44880, 45074, 45075, 
    44879, 45065, 45066, 45067, 45068, 
    45069, 45070, 45071, 45072, 45073, 
    45033, 44875, 45034, 45501, 45499, 
    45497, 44876, 45036, 45035, 45037, 
    45038, 45039, 45040, 45041, 45042, 
    45043, 36519, 36652, 33466, 33562, 
    33563, 33564, 33565, 47651, 47680, 
    47681, 47682, 47683, 47684
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00786

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": 81.8181839,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (45242,45521,45522,45523,45524,45525,33700,33770,44878,45056,45057,45058,45059,45060,45061,45062,45063,45064,45031,45032,44874,40652,40656,40655,40654,40653,40651,40650,40536,36659,36660,44877,45044,45045,45046,45047,45048,45049,45050,45051,45052,45053,45054,45055,45011,45010,45009,44873,44880,45074,45075,44879,45065,45066,45067,45068,45069,45070,45071,45072,45073,45033,44875,45034,45501,45499,45497,44876,45036,45035,45037,45038,45039,45040,45041,45042,45043,36519,36652,33466,33562,33563,33564,33565,47651,47680,47681,47682,47683,47684)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}