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 = 134 
  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.00115

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 13 Using where; Using filesort

Result

object_id name section_id section_tab_id type position is_global description value
6016 enable_clear_logs 134 135 C 0 N enable_clear_logs Y
6023 enable_dropbox_backup 134 136 C 0 N enable_dropbox_backup N
6026 notice 134 137 O 0 N notice
6017 enable_clear_tpl_cache 134 135 C 10 N enable_clear_tpl_cache Y
6024 access_token 134 136 I 10 N access_token
6027 send_backup_email 134 137 C 10 N send_backup_email N
6018 enable_clear_thumbnails 134 135 C 20 N enable_clear_thumbnails N
6025 upload_backup_of 134 136 N 20 N upload_backup_of
6028 backup_email 134 137 I 20 N backup_email
6019 enable_clear_cache 134 135 C 30 N enable_clear_cache Y
6029 cron_key 134 137 I 30 N cron_key Cron_key
6020 enable_optimize_db 134 135 C 40 N enable_optimize_db Y
6021 enable_backup_for 134 135 N 50 N enable_backup_for
6022 enable_clear_old_backup 134 135 C 60 N enable_clear_old_backup N