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

Query time 0.00021

JSON explain

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

Result

name company_id value
ab__seo_filters_limit 0 5
active_elements_background 0 #f3f3f3
active_elements_color 0 #3c78d8
anti_csrf 0 Y
autoredirect 0 Y
base_text_color 0 #2a2c47
block_enter_press 0 Y
border_radius 0 15
brands_feature_id 0 2
brands_limit 0 1
cats_limit 0 5
cats_sort_by 0 category
characters_limit 0 3
clear_turbo_cache_when 0 on_create_product
clsm_motivation_text_en 0 array()["bentley used parts","bentley gt headlight","ferrari steering wheel"]
clsm_motivation_text_ko 0 array()["벤틀리GT 헤드라이트","BMW 부품","제네시스부품"]
clsm_redirect_category 0 Y
clsm_show_parent_level 0 2
clsm_status 0 1
clss_admin_status 0 1
clss_status 0 1
color_type 0 A
custom_result_ids 0
desktop_max_width 0 700
group_by_root_cats 0 Y
history_limit 0 5
hooks_before_response 0 array()[""]
hooks_get_brands 0 array()[""]
hooks_get_categories 0 array()[""]
hooks_get_categories_fields_condition 0 array()[""]
hooks_get_conditions 0 array()[""]
hooks_get_fields 0 array()[""]
hooks_get_joins 0 array()[""]
hooks_get_pages 0 array()[""]
hooks_get_pages_fields_condition 0 array()[""]
hooks_get_products 0 array()[""]
hooks_get_product_phrase_condition 0 array()[""]
hooks_get_speedup_product_data 0 array()[""]
hooks_get_vendors 0 array()[""]
ignore_lang_code 0 N
increase_popularity 0 Y
link_color 0 #3a4b65
need_redis_auth 0 N
out_stock_end 0 Y
pb_ignore_lang_code 0 N
pb_limit 0 5
products_per_page 0 5
redis_port 0 6379
redis_server 0 localhost
replace_with_break 0 , . : / - \ " ' “ ”
search_blog 0 Y
search_brands 0 Y
search_by_features 0 array()["","2","3","4","28"]
search_categories 0 Y
search_categories_on_ab__seo_filters 0 Y
search_categories_on_ab__seo_filters_ignore_placeholder 0 Y
search_delay 0 500
search_on_category_metakeywords 0 N
search_on_category_name 0 Y
search_on_description 0 N
search_on_features 0 Y
search_on_keywords 0 Y
search_on_metadesc 0 N
search_on_metakeywords 0 N
search_on_metatitle 0 N
search_on_name 0 Y
search_on_options 0 N
search_on_pcode 0 Y
search_on_product_id 0 N
search_on_short_description 0 N
search_on_tags 0 Y
search_pages 0 Y
search_products 0 Y
search_variation 0 Y
search_vendors 0 Y
show_cart 0 Y
show_category 0 Y
show_category_gradient 0 Y
show_compare 0 N
show_parent_category 0 Y
show_price 0 Y
show_product_code 0 Y
show_quick_view 0 N
show_user_history 0 Y
show_wish 0 Y
skip_chars 0 . , - ; : ' / "
sort_by 0 cls_rel_pop|asc
speedup_cluster_size 0 2
speedup_cron_key 0 HEL765FW
speedup_exclude_import 0 Y
speedup_level 0 light
suggest_corrections 0 Y
suggest_products_categories 0 Y
syn_partial_match 0 1
theme 0 csc_live_search/themes/modern.less
turbo_cache_ttl 0 720
use_synonyms 0 1
use_turbo_cache 0 1
vendors_limit 0 3
vendor_history_access 0 C