SELECT 
  category_id 
FROM 
  cscart_categories 
WHERE 
  status IN (0, 0) 
  AND (
    0 
    OR category_id = 1186 
    OR id_path = 1186 
    OR id_path LIKE '1186/%' 
    OR id_path LIKE '%/1186' 
    OR id_path LIKE '%/1186/%' 
    OR category_id = 2438 
    OR id_path = 2438 
    OR id_path LIKE '2438/%' 
    OR id_path LIKE '%/2438' 
    OR id_path LIKE '%/2438/%' 
    OR category_id = 2453 
    OR id_path = 2453 
    OR id_path LIKE '2453/%' 
    OR id_path LIKE '%/2453' 
    OR id_path LIKE '%/2453/%' 
    OR category_id = 2463 
    OR id_path = 2463 
    OR id_path LIKE '2463/%' 
    OR id_path LIKE '%/2463' 
    OR id_path LIKE '%/2463/%' 
    OR category_id = 2494 
    OR id_path = 2494 
    OR id_path LIKE '2494/%' 
    OR id_path LIKE '%/2494' 
    OR id_path LIKE '%/2494/%' 
    OR category_id = 2676 
    OR id_path = 2676 
    OR id_path LIKE '2676/%' 
    OR id_path LIKE '%/2676' 
    OR id_path LIKE '%/2676/%'
  )

Query time 0.01261

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "157.71"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY",
        "id_path",
        "p_category_id"
      ],
      "rows_examined_per_scan": 1513,
      "rows_produced_per_join": 283,
      "filtered": "18.73",
      "cost_info": {
        "read_cost": "129.37",
        "eval_cost": "28.34",
        "prefix_cost": "157.71",
        "data_read_per_join": "792K"
      },
      "used_columns": [
        "category_id",
        "id_path",
        "status"
      ],
      "attached_condition": "((`cscart_db`.`cscart_categories`.`status` in (0,0)) and ((`cscart_db`.`cscart_categories`.`category_id` = 1186) or (`cscart_db`.`cscart_categories`.`id_path` = 1186) or (`cscart_db`.`cscart_categories`.`id_path` like '1186/%') or (`cscart_db`.`cscart_categories`.`id_path` like '%/1186') or (`cscart_db`.`cscart_categories`.`id_path` like '%/1186/%') or (`cscart_db`.`cscart_categories`.`category_id` = 2438) or (`cscart_db`.`cscart_categories`.`id_path` = 2438) or (`cscart_db`.`cscart_categories`.`id_path` like '2438/%') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2438') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2438/%') or (`cscart_db`.`cscart_categories`.`category_id` = 2453) or (`cscart_db`.`cscart_categories`.`id_path` = 2453) or (`cscart_db`.`cscart_categories`.`id_path` like '2453/%') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2453') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2453/%') or (`cscart_db`.`cscart_categories`.`category_id` = 2463) or (`cscart_db`.`cscart_categories`.`id_path` = 2463) or (`cscart_db`.`cscart_categories`.`id_path` like '2463/%') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2463') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2463/%') or (`cscart_db`.`cscart_categories`.`category_id` = 2494) or (`cscart_db`.`cscart_categories`.`id_path` = 2494) or (`cscart_db`.`cscart_categories`.`id_path` like '2494/%') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2494') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2494/%') or (`cscart_db`.`cscart_categories`.`category_id` = 2676) or (`cscart_db`.`cscart_categories`.`id_path` = 2676) or (`cscart_db`.`cscart_categories`.`id_path` like '2676/%') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2676') or (`cscart_db`.`cscart_categories`.`id_path` like '%/2676/%')))"
    }
  }
}