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 = 19 
  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.00034

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE storefront_values system PRIMARY,storefront_id,company_id 0 const row not found
1 SIMPLE cscart_settings_objects ref section_id section_id 4 const 28 Using where; Using filesort

Result

object_id name section_id section_tab_id type position is_global description value
5680 twitter_enable 19 20 C 0 N twitter_enable Y
5685 facebook_enable 19 21 C 0 N facebook_enable Y
5697 vkontakte_enable 19 22 C 0 N vkontakte_enable
5704 yandex_enable 19 23 C 0 N yandex_enable Y
5707 pinterest_enable 19 24 C 0 N pinterest_enable Y
5681 twitter_via 19 20 I 10 N twitter_via
5686 facebook_app_id 19 21 I 10 N facebook_app_id
5698 vkontakte_appid 19 22 I 10 N vkontakte_appid
5705 yandex_share_code 19 23 T 10 N yandex_share_code <div class="ya-share2" data-services="collections,vkontakte,facebook,twitter,odnoklassniki,moimir"></div>
5708 pinterest_size 19 24 S 10 N pinterest_size 20
5682 twitter_size 19 20 S 20 N twitter_size medium
5687 facebook_href 19 21 I 20 N facebook_href
5699 vkontakte_button_style 19 22 S 20 N vkontakte_button_style mini
5706 yandex_display_on 19 23 N 20 N yandex_display_on products,pages
5709 pinterest_shape 19 24 S 20 N pinterest_shape rect
5683 twitter_display_count 19 20 S 30 N twitter_display_count horizontal
5688 facebook_send 19 21 C 30 N facebook_send Y
5700 vkontakte_height 19 22 I 30 N vkontakte_height 22
5710 pinterest_display_on 19 24 N 30 N pinterest_display_on #M#products=Y
5684 twitter_display_on 19 20 N 40 N twitter_display_on #M#products=Y
5689 facebook_width 19 21 I 40 N facebook_width 450
5701 vkontakte_width 19 22 I 40 N vkontakte_width 350
5690 facebook_layout 19 21 S 50 N facebook_layout button_count
5702 vkontakte_buttons_name 19 22 S 50 N vkontakte_buttons_name like
5691 facebook_show_faces 19 21 C 60 N facebook_show_faces N
5703 vkontakte_display_on 19 22 N 60 N vkontakte_display_on
5692 facebook_action 19 21 S 70 N facebook_action like
5693 facebook_lang 19 21 S 80 N facebook_lang en_US
5694 facebook_action_font 19 21 S 90 N facebook_action_font arial
5695 facebook_colorscheme 19 21 S 100 N facebook_colorscheme light
5696 facebook_display_on 19 21 N 110 N facebook_display_on #M#products=Y