SELECT 
  * 
FROM 
  cscart_abt__ut2_settings 
WHERE 
  lang_code = 'en'

Query time 0.00281

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "24.60"
    },
    "table": {
      "table_name": "cscart_abt__ut2_settings",
      "access_type": "ALL",
      "rows_examined_per_scan": 118,
      "rows_produced_per_join": 11,
      "filtered": "10.00",
      "cost_info": {
        "read_cost": "22.24",
        "eval_cost": "2.36",
        "prefix_cost": "24.60",
        "data_read_per_join": "7K"
      },
      "used_columns": [
        "section",
        "name",
        "company_id",
        "lang_code",
        "value"
      ],
      "attached_condition": "(`webmarco`.`cscart_abt__ut2_settings`.`lang_code` = 'en')"
    }
  }
}

Result

section name company_id lang_code value
addons wishlist_products.item_quantity 0 en a:1:{s:7:"desktop";s:1:"4";}
category description_position 0 en s:6:"bottom";
category show_subcategories 0 en s:1:"Y";
features description_position 0 en s:6:"bottom";
general blog_page_id 0 en s:0:"";
general brand_feature_id 0 en s:2:"18";
general enable_fixed_header_panel 0 en s:1:"Y";
general lazy_load 0 en s:1:"Y";
general menu_min_height 0 en s:3:"476";
load_more before_end 0 en s:3:"300";
load_more blog 0 en s:1:"Y";
load_more mode 0 en s:15:"on_button_click";
load_more product_list 0 en s:1:"Y";
products addon_buy_together.view 0 en s:19:"as_block_above_tabs";
products addon_required_products.item_quantity 0 en a:1:{s:7:"desktop";s:1:"4";}
products addon_required_products.list_type 0 en a:1:{s:7:"desktop";s:9:"grid_list";}
products addon_social_buttons.view 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
products custom_block_id 0 en s:0:"";
products vendor.show_ask_question_link 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
products vendor.show_logo 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
products vendor.show_name_as_link 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
products vendor.show_phone 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
products vendor.truncate_short_description 0 en a:3:{s:7:"desktop";s:1:"0";s:6:"tablet";s:1:"0";s:6:"mobile";s:1:"0";}
products view.brand_link_behavior 0 en s:23:"to_category_with_filter";
products view.show_brand_logo 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"N";}
products view.show_features 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
products view.show_qty 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
products view.show_short_description 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
products view.show_sku 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
products view.show_sticky_add_to_cart 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list decolorate_out_of_stock_products 0 en s:1:"N";
product_list limit_product_variations 0 en s:2:"10";
product_list max_features 0 en a:3:{s:7:"desktop";s:1:"5";s:6:"tablet";s:1:"5";s:6:"mobile";s:1:"5";}
product_list price_display_format 0 en s:3:"row";
product_list products_multicolumns.grid_item_bottom_content 0 en a:1:{s:7:"desktop";s:4:"none";}
product_list products_multicolumns.grid_item_height 0 en a:3:{s:7:"desktop";s:0:"";s:6:"tablet";s:0:"";s:6:"mobile";s:0:"";}
product_list products_multicolumns.show_brand_logo 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list products_multicolumns.show_buttons 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list products_multicolumns.show_buttons_on_hover 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list products_multicolumns.show_qty 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list products_multicolumns.show_sku 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list products_multicolumns.show_you_save 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list products_without_options.grid_item_bottom_content 0 en a:3:{s:7:"desktop";s:23:"features_and_variations";s:6:"tablet";s:4:"none";s:6:"mobile";s:4:"none";}
product_list products_without_options.show_amount 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list products_without_options.show_brand_logo 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list products_without_options.show_options 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list products_without_options.show_qty 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list products_without_options.show_sku 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list short_list.show_button 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list short_list.show_button_compare 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list short_list.show_button_quick_view 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list short_list.show_button_wishlist 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list short_list.show_qty 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list short_list.show_sku 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"N";}
product_list show_fixed_filters_button 0 en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"Y";}
product_list show_gallery 0 en s:1:"N";
product_list show_rating 0 en s:1:"N";
vendor show_ask_question_link 0 en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
vendor truncate_short_description 0 en a:3:{s:7:"desktop";s:3:"180";s:6:"tablet";s:3:"180";s:6:"mobile";s:3:"180";}