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

Query time 0.00152

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.95"
    },
    "table": {
      "table_name": "ushop_csc_live_search",
      "access_type": "ALL",
      "rows_examined_per_scan": 87,
      "rows_produced_per_join": 8,
      "filtered": "10.00",
      "cost_info": {
        "read_cost": "8.08",
        "eval_cost": "0.87",
        "prefix_cost": "8.95",
        "data_read_per_join": "6K"
      },
      "used_columns": [
        "name",
        "company_id",
        "value"
      ],
      "attached_condition": "(`marketplace`.`ushop_csc_live_search`.`company_id` = 0)"
    }
  }
}

Result

name company_id value
active_elements_background 0 #eaeaed
active_elements_color 0 #3483fa
anti_csrf 0 Y
autoredirect 0 N
base_text_color 0 #333333
block_enter_press 0 N
border_radius 0 5
brands_feature_id 0 array()[""]
brands_limit 0 5
cats_limit 0 5
cats_sort_by 0 category
characters_limit 0 1
clear_turbo_cache_when 0 on_create_product
clsm_redirect_category 0 N
color_type 0 E
current_page_redirect 0 N
custom_result_ids 0
desktop_max_width 0 700
group_by_root_cats 0 N
history_limit 0 6
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 #3483fa
min_chars_limit 0
need_redis_auth 0 N
out_stock_end 0 Y
pb_ignore_lang_code 0 N
pb_limit 0 5
products_per_page 0 10
redis_port 0 6379
redis_server 0 127.0.0.1
replace_with_break 0 , . : / - \ " ' “ ”
search_blog 0 N
search_brands 0 Y
search_categories 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 N
search_on_keywords 0 N
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 N
search_pages 0 N
search_products 0 Y
search_variation 0 N
search_vendors 0 Y
show_cart 0 Y
show_category 0 Y
show_category_gradient 0 N
show_clear_btn 0 N
show_compare 0 Y
show_parent_category 0 N
show_price 0 Y
show_product_code 0 Y
show_quick_view 0 Y
show_user_history 0 Y
show_wish 0 Y
sort_by 0 cls_rel_pop|asc
suggest_corrections 0 Y
suggest_products_categories 0 Y
theme 0 csc_live_search/themes/modern.less
turbo_cache_ttl 0 48
use_turbo_cache 0 1
vendors_limit 0 3
vendor_history_access 0 D
vendor_history_product 0 N