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 = 558 
  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.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "93.60"
    },
    "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": 45,
            "rows_produced_per_join": 40,
            "filtered": "90.00",
            "index_condition": "(`webmarco`.`cscart_settings_objects`.`section_id` <=> 558)",
            "cost_info": {
              "read_cost": "36.00",
              "eval_cost": "8.10",
              "prefix_cost": "45.00",
              "data_read_per_join": "31K"
            },
            "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": 40,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "40.50",
              "eval_cost": "8.10",
              "prefix_cost": "93.60",
              "data_read_per_join": "971"
            },
            "used_columns": [
              "object_id",
              "company_id",
              "value",
              "storefront_id"
            ]
          }
        }
      ]
    }
  }
}

Result

object_id name section_id section_tab_id type position is_global description value
7682 licensekey 558 559 I 0 N licensekey
7687 cp_blog_power_color_scheme_settings 558 560 E 0 N cp_blog_power_color_scheme_settings color_scheme.tpl
7689 list_display_views 558 561 C 0 N list_display_views N
7697 post_display_views 558 562 C 0 N post_display_views N
7710 mail_lists 558 563 S 0 N mail_lists 0
7715 google_xml_notice 558 564 E 0 N google_xml_notice google_xml_notice.tpl
7724 generate_blog_category_meta 558 565 C 0 N generate_blog_category_meta N
7683 post_use_image 558 559 C 10 N post_use_image Y
7688 blog_colors 558 560 D 10 N blog_colors a:13:{s:12:"header_color";s:7:"#272727";s:10:"link_color";s:7:"#666666";s:12:"button_color";s:7:"#38761d";s:17:"button_text_color";s:7:"#ffffff";s:10:"date_color";s:7:"#38761d";s:15:"date_text_color";s:7:"#ffffff";s:20:"content_header_color";s:7:"#272727";s:18:"content_text_color";s:7:"#434343";s:18:"content_link_color";s:7:"#1c4587";s:19:"blocks_header_color";s:7:"#272727";s:17:"blocks_text_color";s:7:"#434343";s:17:"blocks_link_color";s:7:"#1c4587";s:19:"blocks_border_color";s:7:"#d9d9d9";}
7690 list_display_date 558 561 C 10 N list_display_date Y
7698 post_show_image 558 562 C 10 N post_show_image N
7725 generate_blog_article_meta 558 565 C 10 N generate_blog_article_meta N
7684 blog_date_format 558 559 S 20 N blog_date_format %b %e, %Y
7691 list_display_comments 558 561 C 20 N list_display_comments Y
7699 post_image_position 558 562 S 20 N post_image_position top
7711 marketing_info 558 563 O 20 N marketing_info
7717 include_posts 558 564 C 20 N include_posts Y
7726 add_to_sitemap 558 565 S 20 N add_to_sitemap none
7685 posts_per_page 558 559 I 30 N posts_per_page 12
7692 list_display_author 558 561 C 30 N list_display_author Y
7700 post_image_width 558 562 I 30 N post_image_width 300
7712 notices_list 558 563 S 30 N notices_list 0
7718 posts_change 558 564 S 30 N posts_change daily
7686 brand_feature_id 558 559 I 40 N brand_feature_id
7693 list_display_type 558 561 C 40 N list_display_type Y
7701 post_image_height 558 562 I 40 N post_image_height
7713 send_article_delay 558 563 I 40 N send_article_delay 12
7719 posts_priority 558 564 S 40 N posts_priority 0.5
7694 list_show_tags 558 561 C 50 N list_show_tags Y
7702 post_display_author 558 562 C 50 N post_display_author Y
7714 send_articles 558 563 I 50 N send_articles 1
7695 list_display_short_description 558 561 C 60 N list_display_short_description Y
7703 post_display_categories 558 562 C 60 N post_display_categories Y
7721 include_blog_categories 558 564 C 60 N include_blog_categories Y
7696 list_display_view_more 558 561 C 70 N list_display_view_more Y
7704 post_display_type 558 562 C 70 N post_display_type Y
7722 blog_categories_change 558 564 S 70 N blog_categories_change daily
7723 blog_categories_priority 558 564 S 80 N blog_categories_priority 0.5
7706 gallery_image_width 558 562 I 90 N gallery_image_width 895
7707 gallery_image_height 558 562 I 100 N gallery_image_height
7708 gallery_type 558 562 S 110 N gallery_type scroller
7709 gallery_columns 558 562 I 120 N gallery_columns 3