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 = 92 
  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.00040

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

Result

object_id name section_id section_tab_id type position is_global description value
5894 product_posts_per_page 92 93 I 0 N product_posts_per_page 10
5899 category_posts_per_page 92 94 I 0 N category_posts_per_page 10
5903 order_posts_per_page 92 95 I 0 N order_posts_per_page 10
5905 page_posts_per_page 92 96 I 0 N page_posts_per_page 10
5909 home_page_posts_per_page 92 97 I 0 N home_page_posts_per_page 10
5913 company_discussion_type 92 98 S 0 N company_discussion_type D
5895 product_post_approval 92 93 S 10 N product_post_approval any
5900 category_post_approval 92 94 S 10 N category_post_approval any
5904 order_initiate 92 95 C 10 N order_initiate Y
5906 page_post_approval 92 96 S 10 N page_post_approval disabled
5910 home_page_post_approval 92 97 S 10 N home_page_post_approval any
5914 company_only_buyers 92 98 C 10 N company_only_buyers Y
5896 product_post_ip_check 92 93 C 20 N product_post_ip_check N
5901 category_post_ip_check 92 94 C 20 N category_post_ip_check N
5907 page_post_ip_check 92 96 C 20 N page_post_ip_check N
5911 home_page_post_ip_check 92 97 C 20 N home_page_post_ip_check Y
5915 company_posts_per_page 92 98 I 20 N company_posts_per_page 10
5897 product_discussion_type 92 93 S 30 N product_discussion_type D
5902 category_discussion_type 92 94 S 30 N category_discussion_type D
5908 page_discussion_type 92 96 S 30 N page_discussion_type D
5912 home_page_testimonials 92 97 S 30 N home_page_testimonials B
5916 company_post_approval 92 98 S 30 N company_post_approval any
5917 company_post_ip_check 92 98 C 40 N company_post_ip_check N
5898 product_review_after_purchase 92 93 C 50 N product_review_after_purchase N