SELECT 
  cscart_settings_sections.name, 
  cscart_settings_sections.section_id, 
  cscart_settings_sections.position, 
  cscart_settings_sections.type, 
  cscart_settings_sections.name as description, 
  CONCAT(
    'settings.manage?section_id=', cscart_settings_sections.name
  ) as href 
FROM 
  cscart_settings_sections 
WHERE 
  1 
  AND (
    FIND_IN_SET(
      'STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:ROOT', cscart_settings_sections.edition_type
    )
  ) 
ORDER BY 
  cscart_settings_sections.position

Query time 0.00081

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "180.65"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "164.00"
      },
      "table": {
        "table_name": "cscart_settings_sections",
        "access_type": "ALL",
        "rows_examined_per_scan": 164,
        "rows_produced_per_join": 164,
        "filtered": "100.00",
        "cost_info": {
          "read_cost": "0.25",
          "eval_cost": "16.40",
          "prefix_cost": "16.65",
          "data_read_per_join": "64K"
        },
        "used_columns": [
          "section_id",
          "edition_type",
          "name",
          "position",
          "type"
        ],
        "attached_condition": "((0 <> find_in_set('STOREFRONT',`dev2`.`cscart_settings_sections`.`edition_type`)) or (0 <> find_in_set('ROOT',`dev2`.`cscart_settings_sections`.`edition_type`)) or (0 <> find_in_set('MVE:STOREFRONT',`dev2`.`cscart_settings_sections`.`edition_type`)) or (0 <> find_in_set('MVE:ROOT',`dev2`.`cscart_settings_sections`.`edition_type`)))"
      }
    }
  }
}

Result

name section_id position type description href
Emails 1 0 CORE Emails settings.manage?section_id=Emails
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
Security 15 0 CORE Security settings.manage?section_id=Security
Vendors 16 0 CORE Vendors settings.manage?section_id=Vendors
hidpi 17 0 ADDON hidpi settings.manage?section_id=hidpi
general 18 0 TAB general settings.manage?section_id=general
tags 27 0 ADDON tags settings.manage?section_id=tags
general 28 0 TAB general settings.manage?section_id=general
rss_feed 29 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 30 0 TAB general settings.manage?section_id=general
newsletters 31 0 ADDON newsletters settings.manage?section_id=newsletters
general 32 0 TAB general settings.manage?section_id=general
attachments 38 0 ADDON attachments settings.manage?section_id=attachments
general 39 0 TAB general settings.manage?section_id=general
vendor_rating 40 0 ADDON vendor_rating settings.manage?section_id=vendor_rating
service 41 0 TAB service settings.manage?section_id=service
vendor_communication 42 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 43 0 TAB general settings.manage?section_id=general
geo_maps 45 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 46 0 TAB general settings.manage?section_id=general
vendor_data_premoderation 49 0 ADDON vendor_data_premoderation settings.manage?section_id=vendor_data_premoderation
vendors 50 0 TAB vendors settings.manage?section_id=vendors
vendor_plans 52 0 ADDON vendor_plans settings.manage?section_id=vendor_plans
general 53 0 TAB general settings.manage?section_id=general
yandex_delivery_v3 54 0 ADDON yandex_delivery_v3 settings.manage?section_id=yandex_delivery_v3
general 55 0 TAB general settings.manage?section_id=general
store_locator 58 0 ADDON store_locator settings.manage?section_id=store_locator
general 59 0 TAB general settings.manage?section_id=general
product_variations 60 0 ADDON product_variations settings.manage?section_id=product_variations
general 61 0 TAB general settings.manage?section_id=general
storefront_rest_api 62 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 63 0 TAB general settings.manage?section_id=general
recaptcha 64 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 65 0 TAB general settings.manage?section_id=general
bestsellers 69 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 70 0 TAB general settings.manage?section_id=general
seo 72 0 ADDON seo settings.manage?section_id=seo
general 73 0 TAB general settings.manage?section_id=general
facebook_pixel 78 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
general 79 0 TAB general settings.manage?section_id=general
call_requests 80 0 ADDON call_requests settings.manage?section_id=call_requests
general 81 0 TAB general settings.manage?section_id=general
access_restrictions 88 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 89 0 TAB general settings.manage?section_id=general
banners 90 0 ADDON banners settings.manage?section_id=banners
general 91 0 TAB general settings.manage?section_id=general
discussion 94 0 ADDON discussion settings.manage?section_id=discussion
products 95 0 TAB products settings.manage?section_id=products
product_reviews 101 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 102 0 TAB general settings.manage?section_id=general
image_zoom 103 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 104 0 TAB general settings.manage?section_id=general
google_sitemap 105 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 106 0 TAB general settings.manage?section_id=general
data_feeds 107 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 108 0 TAB general settings.manage?section_id=general
price_list 109 0 ADDON price_list settings.manage?section_id=price_list
general 110 0 TAB general settings.manage?section_id=general
rus_ruble 117 0 ADDON rus_ruble settings.manage?section_id=rus_ruble
settings 118 0 TAB settings settings.manage?section_id=settings
vendor_panel_configurator 121 0 ADDON vendor_panel_configurator settings.manage?section_id=vendor_panel_configurator
product_page_settings 122 0 TAB product_page_settings settings.manage?section_id=product_page_settings
vendor_privileges 124 0 ADDON vendor_privileges settings.manage?section_id=vendor_privileges
general 125 0 TAB general settings.manage?section_id=general
ab__addons_manager 128 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
settings 129 0 TAB settings settings.manage?section_id=settings
abt__unitheme2 130 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
settings 131 0 TAB settings settings.manage?section_id=settings
abt__unitheme2_mv 132 0 ADDON abt__unitheme2_mv settings.manage?section_id=abt__unitheme2_mv
settings 133 0 TAB settings settings.manage?section_id=settings
ab__category_banners 134 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
settings 135 0 TAB settings settings.manage?section_id=settings
ab__fast_navigation 140 0 ADDON ab__fast_navigation settings.manage?section_id=ab__fast_navigation
settings 141 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 142 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
settings 143 0 TAB settings settings.manage?section_id=settings
ab__scroll_to_top 144 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 145 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 146 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
settings 147 0 TAB settings settings.manage?section_id=settings
ab__landing_categories 148 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 149 0 TAB settings settings.manage?section_id=settings
ab__hide_product_description 150 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
settings 151 0 TAB settings settings.manage?section_id=settings
ab__deal_of_the_day 152 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 153 0 TAB settings settings.manage?section_id=settings
ab__stickers 154 0 ADDON ab__stickers settings.manage?section_id=ab__stickers
settings 155 0 TAB settings settings.manage?section_id=settings
ab__image_previewers 158 0 ADDON ab__image_previewers settings.manage?section_id=ab__image_previewers
settings 159 0 TAB settings settings.manage?section_id=settings
commerceml 162 0 ADDON commerceml settings.manage?section_id=commerceml
general 163 0 TAB general settings.manage?section_id=general
mobile_app 171 0 ADDON mobile_app settings.manage?section_id=mobile_app
service 172 0 TAB service settings.manage?section_id=service
pdf_documents 175 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 176 0 TAB general settings.manage?section_id=general
replain 177 0 ADDON replain settings.manage?section_id=replain
general 178 0 TAB general settings.manage?section_id=general
rus_exim_1c 179 0 ADDON rus_exim_1c settings.manage?section_id=rus_exim_1c
general 180 0 TAB general settings.manage?section_id=general
rus_online_cash_register 185 0 ADDON rus_online_cash_register settings.manage?section_id=rus_online_cash_register
general 186 0 TAB general settings.manage?section_id=general
searchanise 195 0 ADDON searchanise settings.manage?section_id=searchanise
configuration 196 0 SEPARATE_TAB configuration settings.manage?section_id=configuration
tilda_pages 201 0 ADDON tilda_pages settings.manage?section_id=tilda_pages
general 202 0 TAB general settings.manage?section_id=general
vendor_access 221 0 ADDON vendor_access settings.manage?section_id=vendor_access
section1 222 0 TAB section1 settings.manage?section_id=section1
optipic 227 0 ADDON optipic settings.manage?section_id=optipic
generic_settings 228 0 TAB generic_settings settings.manage?section_id=generic_settings
image_compress_squeezeimg 229 0 ADDON image_compress_squeezeimg settings.manage?section_id=image_compress_squeezeimg
general 230 0 TAB general settings.manage?section_id=general
rus_personal_data_processing 231 0 ADDON rus_personal_data_processing settings.manage?section_id=rus_personal_data_processing
general 232 0 TAB general settings.manage?section_id=general
finleo_services 255 0 ADDON finleo_services settings.manage?section_id=finleo_services
general 256 0 TAB general settings.manage?section_id=general
order_notif_online 257 0 ADDON order_notif_online settings.manage?section_id=order_notif_online
general 258 0 TAB general settings.manage?section_id=general
referral_program 261 0 ADDON referral_program settings.manage?section_id=referral_program
general 262 0 TAB general settings.manage?section_id=general
gr__seo_filters 263 0 ADDON gr__seo_filters settings.manage?section_id=gr__seo_filters
settings 264 0 TAB settings settings.manage?section_id=settings
reward_points 265 0 ADDON reward_points settings.manage?section_id=reward_points
general 266 0 TAB general settings.manage?section_id=general
ecl_seo_images 267 0 ADDON ecl_seo_images settings.manage?section_id=ecl_seo_images
section1 268 0 TAB section1 settings.manage?section_id=section1
finleo_crm 272 0 ADDON finleo_crm settings.manage?section_id=finleo_crm
general 273 0 TAB general settings.manage?section_id=general
telegram_bot 274 0 ADDON telegram_bot settings.manage?section_id=telegram_bot
general 275 0 TAB general settings.manage?section_id=general
General 2 10 CORE General settings.manage?section_id=General
promotions 33 10 TAB promotions settings.manage?section_id=promotions
vendor_to_customer 44 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
yandex 47 10 TAB yandex settings.manage?section_id=yandex
products 51 10 TAB products settings.manage?section_id=products
forbidden_countries 66 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
newest 71 10 TAB newest settings.manage?section_id=newest
categories 96 10 TAB categories settings.manage?section_id=categories
vendor_panel_style 123 10 TAB vendor_panel_style settings.manage?section_id=vendor_panel_style
text_stickers 156 10 TAB text_stickers settings.manage?section_id=text_stickers
import_restraction_features 181 10 TAB import_restraction_features settings.manage?section_id=import_restraction_features
atol 187 10 TAB atol settings.manage?section_id=atol
section2 223 10 TAB section2 settings.manage?section_id=section2
section2 269 10 TAB section2 settings.manage?section_id=section2
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
google 48 20 TAB google settings.manage?section_id=google
orders 97 20 TAB orders settings.manage?section_id=orders
vendors 157 20 TAB vendors settings.manage?section_id=vendors
prices 182 20 TAB prices settings.manage?section_id=prices
section3 224 20 TAB section3 settings.manage?section_id=section3
section3 270 20 TAB section3 settings.manage?section_id=section3
Company 5 30 CORE Company settings.manage?section_id=Company
pages 98 30 TAB pages settings.manage?section_id=pages
shipping_features 183 30 TAB shipping_features settings.manage?section_id=shipping_features
section4 271 30 TAB section4 settings.manage?section_id=section4
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
testimonials 99 40 TAB testimonials settings.manage?section_id=testimonials
true_orders 184 40 TAB true_orders settings.manage?section_id=true_orders
companies 100 50 TAB companies settings.manage?section_id=companies
Sitemap 8 80 CORE Sitemap settings.manage?section_id=Sitemap
Logging 12 100 CORE Logging settings.manage?section_id=Logging
Thumbnails 9 110 CORE Thumbnails settings.manage?section_id=Thumbnails
Reports 10 140 CORE Reports settings.manage?section_id=Reports