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, 
  IF(
    cscart_settings_vendor_values.value IS NULL, 
    cscart_settings_objects.value, 
    cscart_settings_vendor_values.value
  ) as value 
FROM 
  cscart_settings_objects 
  LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id 
  AND company_id = 1 
WHERE 
  1 
  AND section_id = '317' 
  AND (
    FIND_IN_SET(
      'ROOT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:ROOT', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'VENDOR', cscart_settings_objects.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', cscart_settings_objects.edition_type
    )
  ) 
  AND cscart_settings_objects.type <> 'H' 
ORDER BY 
  cscart_settings_objects.position

Query time 0.00097

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_settings_objects ref section_id section_id 2 const 45 Using where; Using filesort
1 SIMPLE cscart_settings_vendor_values eq_ref PRIMARY PRIMARY 7 mahm3t_cs443.cscart_settings_objects.object_id,const 1

Result

object_id name section_id section_tab_id type position is_global description value
6086 twitter_enable 317 318 C 10 N twitter_enable Y
6092 facebook_enable 317 319 C 10 N facebook_enable Y
6105 vkontakte_enable 317 320 C 10 N vkontakte_enable N
6113 gplus_enable 317 321 C 10 N gplus_enable N
6123 pinterest_enable 317 322 C 10 N pinterest_enable N
6129 email_enable 317 323 C 10 N email_enable Y
6300 yandex_enable 317 432 C 10 N yandex_enable N
6087 twitter_via 317 318 I 20 N twitter_via
6093 facebook_app_id 317 319 I 20 N facebook_app_id 1075645842469427
6106 vkontakte_appid 317 320 I 20 N vkontakte_appid
6114 gplus_href 317 321 I 20 N gplus_href
6124 pinterest_size 317 322 S 20 N pinterest_size 20
6130 email_display_on 317 323 N 20 N email_display_on #M#products=Y&pages=Y
6301 yandex_share_code 317 432 T 20 N yandex_share_code <script type="text/javascript" src="//yandex.st/share/share.js" charset="utf-8"></script><div class="yashare-auto-init" data-yashareL10n="ru" data-yashareQuickServices="vkontakte,facebook,twitter,odnoklassniki,moimir" data-yashareTheme="counter"></div>
6088 twitter_size 317 318 S 30 N twitter_size medium
6094 facebook_href 317 319 I 30 N facebook_href
6107 vkontakte_button_style 317 320 S 30 N vkontakte_button_style mini
6115 gplus_size 317 321 S 30 N gplus_size standard
6125 pinterest_shape 317 322 S 30 N pinterest_shape rect
6302 yandex_display_on 317 432 N 30 N yandex_display_on products,pages
6089 twitter_display_count 317 318 S 40 N twitter_display_count horizontal
6095 facebook_send 317 319 C 40 N facebook_send Y
6108 vkontakte_height 317 320 I 40 N vkontakte_height 22
6116 gplus_annotation 317 321 S 40 N gplus_annotation bubble
6126 pinterest_color 317 322 S 40 N pinterest_color gray
6090 twitter_display_on 317 318 N 50 N twitter_display_on #M#products=Y&pages=Y
6096 facebook_width 317 319 I 50 N facebook_width 450
6109 vkontakte_width 317 320 I 50 N vkontakte_width 350
6117 gplus_width 317 321 I 50 N gplus_width
6127 pinterest_display_on 317 322 N 50 N pinterest_display_on #M#products=Y&pages=Y
6097 facebook_layout 317 319 S 60 N facebook_layout button_count
6110 vkontakte_buttons_name 317 320 S 60 N vkontakte_buttons_name like
6118 gplus_align 317 321 S 60 N gplus_align left
6098 facebook_show_faces 317 319 C 70 N facebook_show_faces N
6111 vkontakte_display_on 317 320 N 70 N vkontakte_display_on N
6119 gplus_expandto 317 321 S 70 N gplus_expandto top
6099 facebook_action 317 319 S 80 N facebook_action like
6120 gplus_recommendations 317 321 S 80 N gplus_recommendations yes
6100 facebook_lang 317 319 S 90 N facebook_lang de_DE
6121 gplus_display_on 317 321 N 90 N gplus_display_on #M#products=Y&pages=Y
6101 facebook_action_font 317 319 S 100 N facebook_action_font arial
6102 facebook_colorscheme 317 319 S 110 N facebook_colorscheme light
6103 facebook_display_on 317 319 N 120 N facebook_display_on #M#products=Y&pages=Y