SELECT 
  * 
FROM 
  cscart_abt__ut2_settings 
WHERE 
  lang_code = 'en' 
  AND storefront_id = 1

Query time 0.00185

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "27.40"
    },
    "table": {
      "table_name": "cscart_abt__ut2_settings",
      "access_type": "ALL",
      "rows_examined_per_scan": 264,
      "rows_produced_per_join": 2,
      "filtered": "1.00",
      "cost_info": {
        "read_cost": "27.14",
        "eval_cost": "0.26",
        "prefix_cost": "27.40",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "section",
        "name",
        "lang_code",
        "value",
        "storefront_id"
      ],
      "attached_condition": "((`s2cart`.`cscart_abt__ut2_settings`.`storefront_id` = 1) and (`s2cart`.`cscart_abt__ut2_settings`.`lang_code` = 'en'))"
    }
  }
}

Result

section name lang_code value storefront_id
addons ab__intelligent_accessories.display_block en a:3:{s:7:"desktop";s:11:"do_not_show";s:6:"tablet";s:11:"do_not_show";s:6:"mobile";s:11:"do_not_show";} 1
addons ab__intelligent_accessories.enable_quick_view en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
addons ab__intelligent_accessories.hide_add_to_cart_button en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
addons ab__intelligent_accessories.item_quantity en s:1:"5"; 1
addons ab__intelligent_accessories.not_scroll_automatically en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"N";} 1
addons ab__intelligent_accessories.outside_navigation en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
addons ab__intelligent_accessories.pause_delay en s:1:"6"; 1
addons ab__intelligent_accessories.scroll_per_page en s:1:"N"; 1
addons ab__intelligent_accessories.show_price en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
addons ab__intelligent_accessories.speed en s:3:"400"; 1
addons ab__intelligent_accessories.thumbnail_width en a:3:{s:7:"desktop";s:3:"170";s:6:"tablet";s:3:"150";s:6:"mobile";s:3:"150";} 1
addons wishlist_products.item_quantity en a:1:{s:7:"desktop";s:1:"4";} 1
category description_position en s:3:"top"; 1
category show_subcategories en s:1:"Y"; 1
features description_position en s:6:"bottom"; 1
general blog_page_id en s:0:""; 1
general brand_feature_id en s:2:"18"; 1
general enable_fixed_header_panel en s:1:"Y"; 1
general lazy_load en s:1:"Y"; 1
load_more before_end en s:3:"300"; 1
load_more blog en s:1:"Y"; 1
load_more mode en a:3:{s:7:"desktop";s:15:"on_button_click";s:6:"tablet";s:15:"on_button_click";s:6:"mobile";s:15:"on_button_click";} 1
load_more product_list en s:1:"Y"; 1
products addon_buy_together.view en s:19:"as_block_above_tabs"; 1
products addon_required_products.item_quantity en a:1:{s:7:"desktop";s:1:"4";} 1
products addon_required_products.list_type en a:1:{s:7:"desktop";s:9:"grid_list";} 1
products addon_social_buttons.view en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
products custom_block_id en s:0:""; 1
products vendor.show_ask_question_link en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
products vendor.show_logo en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
products vendor.show_name_as_link en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
products vendor.show_phone en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
products vendor.truncate_short_description en a:3:{s:7:"desktop";s:2:"90";s:6:"tablet";s:2:"90";s:6:"mobile";s:2:"90";} 1
products view.show_brand_logo en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"N";} 1
products view.show_features en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
products view.show_qty en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
products view.show_short_description en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
products view.show_sku en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
products view.show_sticky_add_to_cart en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"Y";} 1
product_list decolorate_out_of_stock_products en s:1:"N"; 1
product_list limit_product_variations en s:2:"10"; 1
product_list max_features en a:3:{s:7:"desktop";s:1:"5";s:6:"tablet";s:1:"5";s:6:"mobile";s:1:"5";} 1
product_list products_multicolumns.grid_item_bottom_content en a:1:{s:7:"desktop";s:8:"features";} 1
product_list products_multicolumns.grid_item_height en a:3:{s:7:"desktop";s:0:"";s:6:"tablet";s:0:"";s:6:"mobile";s:0:"";} 1
product_list products_multicolumns.show_brand_logo en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
product_list products_multicolumns.show_buttons en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
product_list products_multicolumns.show_buttons_on_hover en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
product_list products_multicolumns.show_qty en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
product_list products_multicolumns.show_sku en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
product_list products_multicolumns.show_you_save en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";} 1
product_list products_without_options.show_amount en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list products_without_options.show_brand_logo en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list products_without_options.show_features en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list products_without_options.show_options en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list products_without_options.show_qty en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list products_without_options.show_sku en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list short_list.show_button en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list short_list.show_button_compare en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"Y";} 1
product_list short_list.show_button_quick_view en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"N";} 1
product_list short_list.show_button_wishlist en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list short_list.show_qty en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
product_list short_list.show_sku en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"N";} 1
product_list show_fixed_filters_button en a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"Y";} 1
product_list show_gallery en s:1:"N"; 1
vendor show_ask_question_link en a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";} 1
vendor truncate_short_description en a:3:{s:7:"desktop";s:3:"180";s:6:"tablet";s:3:"180";s:6:"mobile";s:3:"180";} 1