SELECT 
  category_id 
FROM 
  cscart_categories 
WHERE 
  id_path LIKE '290/3168/%'

Query time 0.00571

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "7.36"
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "range",
      "possible_keys": [
        "id_path"
      ],
      "key": "id_path",
      "used_key_parts": [
        "id_path"
      ],
      "key_length": "767",
      "rows_examined_per_scan": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "4.16",
        "eval_cost": "3.20",
        "prefix_cost": "7.36",
        "data_read_per_join": "83K"
      },
      "used_columns": [
        "category_id",
        "id_path"
      ],
      "attached_condition": "(`maniamall_cscart`.`cscart_categories`.`id_path` like '290/3168/%')"
    }
  }
}

Result

category_id
3169
23494
23495
23496
23506
23507
23510
23524
23525
23733
23738
23768
23769
23776
23777
23785
23792
3170
3215
3220
3321
7897
7898
7908
8085
8086
8087
8092
8134
8709
9721
9728