SELECT 
  * 
FROM 
  cscart_csc_full_page_cache 
WHERE 
  1 
  AND cscart_csc_full_page_cache.company_id = 0

Query time 0.00015

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_csc_full_page_cache",
      "access_type": "ALL",
      "rows": 1,
      "filtered": 100,
      "attached_condition": "cscart_csc_full_page_cache.company_id = 0"
    }
  }
}

Result

name company_id value
cache_lifetime 0 720
cache_of_applied_promotion 0 Y
cache_of_usergroup 0 N
clear_vendor_store_on_post 0 Y
compress_cache 0 Y
controllers 0 array()["","products","categories","pages","index","_no_page","product_features","tags","companies"]
cron_key 0 JD630DS
disable_for_auth 0 Y
disable_if_cart 0 Y
disable_if_compare 0 Y
disable_if_wishlist 0 Y
location_dependency 0 Y
minify_html 0 Y
minify_js 0 Y
mobile_devices 0 Y
need_redis_auth 0 N
no_cache_filters 0 Y
no_generate_from_auth 0 Y
rebuild_categories_cache 0 Y
rebuild_create_product_cache 0 Y
rebuild_pages_cache 0 Y
rebuild_product_cache 0 Y
redis_login 0
redis_pass 0
redis_port 0 6379
redis_server 0 localhost
skip_ajax 0 Y
skip_import_process 0 Y
storage_type 0 R