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

Query time 0.00095

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "121.20"
    },
    "table": {
      "table_name": "cscart_abt__ut2_settings",
      "access_type": "ALL",
      "rows_examined_per_scan": 576,
      "rows_produced_per_join": 5,
      "filtered": "1.00",
      "cost_info": {
        "read_cost": "120.05",
        "eval_cost": "1.15",
        "prefix_cost": "121.20",
        "data_read_per_join": "3K"
      },
      "used_columns": [
        "section",
        "name",
        "storefront_id",
        "lang_code",
        "value"
      ],
      "attached_condition": "((`eshopuga_upgr_4122`.`cscart_abt__ut2_settings`.`storefront_id` = 1) and (`eshopuga_upgr_4122`.`cscart_abt__ut2_settings`.`lang_code` = 'no'))"
    }
  }
}

Result

section name storefront_id lang_code value
addons call_requests.item_button 1 no s:1:"N";
addons discussion.highlight_administrator 1 no s:1:"N";
addons discussion.verified_buyer 1 no s:1:"Y";
addons wishlist_products.item_quantity 1 no a:1:{s:7:"desktop";s:1:"5";}
category description_position 1 no s:6:"bottom";
category show_subcategories 1 no s:1:"Y";
category use_swipe_to_close_filters 1 no a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
features description_position 1 no s:6:"bottom";
general blog_page_id 1 no s:0:"";
general brand_feature_id 1 no s:2:"18";
general check_clone_theme 1 no s:1:"Y";
general enable_fixed_header_panel 1 no s:1:"Y";
general lazy_load 1 no s:1:"Y";
general price_format 1 no s:7:"default";
general push_history_on_popups 1 no a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"Y";}
load_more before_end 1 no s:3:"300";
load_more blog 1 no s:1:"Y";
load_more mode 1 no s:15:"on_button_click";
load_more product_list 1 no s:1:"Y";
products addon_buy_together.view 1 no s:19:"as_block_above_tabs";
products addon_required_products.item_quantity 1 no a:1:{s:7:"desktop";s:1:"5";}
products addon_required_products.list_type 1 no a:1:{s:7:"desktop";s:9:"grid_list";}
products addon_social_buttons.view 1 no a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
products custom_block_id 1 no s:0:"";
products view.brand_link_behavior 1 no s:23:"to_category_with_filter";
products view.show_brand_logo 1 no a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"N";}
products view.show_features 1 no a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
products view.show_qty 1 no 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 1 no a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
products view.show_sku 1 no 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 1 no a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list decolorate_out_of_stock_products 1 no s:1:"N";
product_list default_products_view 1 no a:3:{s:7:"desktop";s:21:"products_multicolumns";s:6:"tablet";s:21:"products_multicolumns";s:6:"mobile";s:21:"products_multicolumns";}
product_list max_features 1 no 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 1 no s:3:"col";
product_list products_multicolumns.grid_item_bottom_content 1 no a:1:{s:7:"desktop";s:23:"features_and_variations";}
product_list products_multicolumns.grid_item_height 1 no a:3:{s:7:"desktop";s:0:"";s:6:"tablet";s:0:"";s:6:"mobile";s:0:"";}
product_list products_multicolumns.image_height 1 no a:3:{s:7:"desktop";s:3:"270";s:6:"tablet";s:3:"200";s:6:"mobile";s:3:"140";}
product_list products_multicolumns.image_width 1 no a:3:{s:7:"desktop";s:3:"270";s:6:"tablet";s:3:"200";s:6:"mobile";s:3:"140";}
product_list products_multicolumns.show_amount 1 no 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_brand_logo 1 no 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 1 no a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list products_multicolumns.show_buttons_on_hover 1 no a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"N";}
product_list products_multicolumns.show_qty 1 no 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 1 no 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 1 no 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 1 no 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 1 no 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 1 no 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 1 no 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 1 no 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 1 no a:3:{s:7:"desktop";s:1:"Y";s:6:"tablet";s:1:"Y";s:6:"mobile";s:1:"Y";}
product_list product_variations.display_as_links 1 no s:1:"Y";
product_list product_variations.limit 1 no s:2:"10";
product_list short_list.show_amount 1 no 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 1 no 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 1 no 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 1 no 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 1 no 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 1 no 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 1 no 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 1 no a:3:{s:7:"desktop";s:1:"N";s:6:"tablet";s:1:"N";s:6:"mobile";s:1:"Y";}
product_list show_gallery 1 no s:1:"N";
product_list show_rating 1 no s:1:"Y";