SELECT 
  cscart_settings_objects.object_id as object_id, 
  name, 
  section_id, 
  section_tab_id, 
  type, 
  position, 
  is_global, 
  cscart_settings_objects.name as description, 
  (
    CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END
  ) AS value 
FROM 
  cscart_settings_objects 
  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id 
  AND storefront_values.storefront_id = 1 
  AND storefront_values.company_id = 0 
WHERE 
  1 
  AND section_id = 641 
  AND (
    FIND_IN_SET(
      'STOREFRONT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'ROOT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:STOREFRONT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:ROOT', cscart_settings_objects.edition_type
    )
  ) 
  AND cscart_settings_objects.type <> 'H' 
ORDER BY 
  cscart_settings_objects.position

Query time 0.00112

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "133.28"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_settings_objects",
            "access_type": "ref",
            "possible_keys": [
              "section_id"
            ],
            "key": "section_id",
            "used_key_parts": [
              "section_id"
            ],
            "key_length": "4",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 76,
            "rows_produced_per_join": 68,
            "filtered": "90.00",
            "index_condition": "(`webmarco`.`cscart_settings_objects`.`section_id` <=> 641)",
            "cost_info": {
              "read_cost": "36.00",
              "eval_cost": "13.68",
              "prefix_cost": "51.20",
              "data_read_per_join": "53K"
            },
            "used_columns": [
              "object_id",
              "edition_type",
              "name",
              "section_id",
              "section_tab_id",
              "type",
              "value",
              "position",
              "is_global"
            ],
            "attached_condition": "((find_in_set('STOREFRONT',`webmarco`.`cscart_settings_objects`.`edition_type`) or find_in_set('ROOT',`webmarco`.`cscart_settings_objects`.`edition_type`) or find_in_set('MVE:STOREFRONT',`webmarco`.`cscart_settings_objects`.`edition_type`) or find_in_set('MVE:ROOT',`webmarco`.`cscart_settings_objects`.`edition_type`)) and (`webmarco`.`cscart_settings_objects`.`type` <> 'H'))"
          }
        },
        {
          "table": {
            "table_name": "storefront_values",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "storefront_id",
              "company_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "company_id",
              "storefront_id"
            ],
            "key_length": "11",
            "ref": [
              "webmarco.cscart_settings_objects.object_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 68,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "68.40",
              "eval_cost": "13.68",
              "prefix_cost": "133.28",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "object_id",
              "company_id",
              "value",
              "storefront_id"
            ]
          }
        }
      ]
    }
  }
}

Result

object_id name section_id section_tab_id type position is_global description value
8202 search_by_phone_num 641 644 C 0 N search_by_phone_num Y
8205 search_categories 641 645 C 0 N search_categories N
8209 out_stock_end 641 646 C 0 N out_stock_end Y
8216 show_price 641 648 S 0 N show_price Y
8221 image_width 641 649 I 0 N image_width 75
8186 search_on_name 641 643 C 0 N search_on_name Y
8203 search_by_vat_num 641 644 C 10 N search_by_vat_num Y
8206 show_parent_category 641 645 C 10 N show_parent_category N
8210 increase_popularity 641 646 C 10 N increase_popularity Y
8214 search_storefront_categories 641 647 C 10 N search_storefront_categories N
8217 show_cart 641 648 S 10 N show_cart Y
8222 image_height 641 649 I 10 N image_height 75
8178 search_products 641 642 C 10 N search_products Y
8187 search_on_keywords 641 643 C 10 N search_on_keywords Y
8204 search_by_url 641 644 C 20 N search_by_url Y
8207 search_on_category_name 641 645 C 20 N search_on_category_name N
8211 sort_by 641 646 S 20 N sort_by cls_relevance_with_popularity
8215 allow_storefronts 641 647 N 20 N allow_storefronts N
8218 show_product_code 641 648 C 20 N show_product_code Y
8223 show_category_gradient 641 649 C 20 N show_category_gradient N
8179 search_brands 641 642 C 20 N search_brands Y
8188 search_on_metakeywords 641 643 C 20 N search_on_metakeywords N
8208 search_on_category_metakeywords 641 645 C 30 N search_on_category_metakeywords N
8212 sort_order 641 646 S 30 N sort_order desc
8219 show_wish 641 648 C 30 N show_wish Y
8224 color_type 641 649 S 30 N color_type M
8180 brands_feature_id 641 642 S 30 N brands_feature_id 1012
8189 search_on_metatitle 641 643 C 30 N search_on_metatitle N
8220 show_category 641 648 C 40 N show_category Y
8225 clr_category_e 641 649 I 40 N clr_category_e #DB4437
8181 search_vendors 641 642 C 40 N search_vendors Y
8190 search_on_metadesc 641 643 C 40 N search_on_metadesc N
8226 min_width 641 649 I 50 N min_width 400
8182 search_blog 641 642 C 50 N search_blog N
8191 search_on_pcode 641 643 C 50 N search_on_pcode Y
8192 search_on_description 641 643 C 60 N search_on_description N
8227 margin 641 649 I 60 N margin 48
8183 search_pages 641 642 C 60 N search_pages N
8193 search_on_short_description 641 643 C 70 N search_on_short_description Y
8228 border_radius 641 649 I 70 N border_radius 5
8194 search_on_product_id 641 643 C 80 N search_on_product_id Y
8229 clr_border 641 649 I 80 N clr_border #A5ACB2
8185 block_enter_press 641 642 C 80 N block_enter_press N
8195 search_on_features 641 643 C 90 N search_on_features N
8230 clr_top_bg 641 649 I 90 N clr_top_bg #FAFAFA
8196 search_by_features 641 643 M 100 N search_by_features
8231 clr_hover 641 649 I 100 N clr_hover #F3F3F3
8197 search_on_options 641 643 C 110 N search_on_options N
8232 clr_links 641 649 I 110 N clr_links #334553
8198 use_stop_words 641 643 C 120 N use_stop_words Y
8233 clr_links_hover 641 649 I 120 N clr_links_hover #678ca9
8199 limit 641 643 I 130 N limit 7
8200 characters_limit 641 643 I 140 N characters_limit 3
8235 btn_atc_radius 641 649 I 140 N btn_atc_radius 2
8201 autoredirect 641 643 C 150 N autoredirect N
8236 clr_btn_atc_border 641 649 I 150 N clr_btn_atc_border #36a0fb
8237 clr_btn_atc_border_hover 641 649 I 160 N clr_btn_atc_border_hover #a5acb2
8238 clr_btn_atc_text 641 649 I 170 N clr_btn_atc_text #fff
8239 clr_btn_atc_text_hover 641 649 I 180 N clr_btn_atc_text_hover #334553
8240 clr_btn_atc_bg 641 649 I 190 N clr_btn_atc_bg #36a0fb
8241 clr_btn_atc_bg_hover 641 649 I 200 N clr_btn_atc_bg_hover #fff
8243 clr_btn_atw_text 641 649 I 220 N clr_btn_atw_text #e31b23
8244 clr_btn_atw_text_hover 641 649 I 230 N clr_btn_atw_text_hover #98002e
8246 btn_radius 641 649 I 250 N btn_radius 2
8247 clr_btn_border 641 649 I 260 N clr_btn_border #a5acb2
8248 clr_btn_border_hover 641 649 I 270 N clr_btn_border_hover #a5acb2
8249 clr_btn_text 641 649 I 280 N clr_btn_text #fff
8250 clr_btn_text_hover 641 649 I 290 N clr_btn_text_hover #334553
8251 clr_btn_bg 641 649 I 300 N clr_btn_bg #a5acb2
8252 clr_btn_bg_hover 641 649 I 310 N clr_btn_bg_hover #fff