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 (
    18807, 18806, 18805, 18804, 3866, 18803, 
    18802, 18801, 18800, 3867, 18799, 18798, 
    18797, 18796, 3868, 18795, 18794, 18793, 
    18792, 18791, 18790, 18789, 18788, 
    3869, 18811, 18810, 18809, 18808, 3865, 
    18787, 18786, 18785, 18784, 3870, 18777, 
    18776, 18775, 18774, 18773, 3872, 18783, 
    18782, 18781, 18780, 18779, 18778, 
    3871, 18766, 18765, 3876, 35730, 35814, 
    35819, 35824, 35829, 35834, 35839, 
    35810, 35811, 35812, 35813, 18817, 
    18816, 18815, 18814, 18813, 18812, 
    3864, 35731, 35847, 35851, 35844, 35845, 
    35846, 18772, 18771, 3873, 47984, 47989, 
    47994, 47999, 48004, 47927, 47982, 
    47983, 47985, 18770, 18769, 3874, 18768, 
    18767, 3875, 18761, 3880, 18764, 3877, 
    18762, 3879, 35729, 35792, 35798, 35804, 
    35787, 35788, 35789, 35790, 35791, 
    18760, 18759, 3881, 18758, 3882, 35732, 
    35859, 35864, 35869, 35874, 35860, 
    35861, 35862, 35863
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00929

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": 96.80000305,
              "attached_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (18807,18806,18805,18804,3866,18803,18802,18801,18800,3867,18799,18798,18797,18796,3868,18795,18794,18793,18792,18791,18790,18789,18788,3869,18811,18810,18809,18808,3865,18787,18786,18785,18784,3870,18777,18776,18775,18774,18773,3872,18783,18782,18781,18780,18779,18778,3871,18766,18765,3876,35730,35814,35819,35824,35829,35834,35839,35810,35811,35812,35813,18817,18816,18815,18814,18813,18812,3864,35731,35847,35851,35844,35845,35846,18772,18771,3873,47984,47989,47994,47999,48004,47927,47982,47983,47985,18770,18769,3874,18768,18767,3875,18761,3880,18764,3877,18762,3879,35729,35792,35798,35804,35787,35788,35789,35790,35791,18760,18759,3881,18758,3882,35732,35859,35864,35869,35874,35860,35861,35862,35863)"
            }
          }
        }
      },
      {
        "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))"
        }
      }
    ]
  }
}