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(
      'VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:ROOT', cscart_settings_sections.edition_type
    )
  ) 
ORDER BY 
  cscart_settings_sections.position

Query time 0.00064

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "211.91"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "174.00"
      },
      "table": {
        "table_name": "cscart_settings_sections",
        "access_type": "ALL",
        "rows_examined_per_scan": 174,
        "rows_produced_per_join": 174,
        "filtered": "100.00",
        "cost_info": {
          "read_cost": "3.11",
          "eval_cost": "34.80",
          "prefix_cost": "37.91",
          "data_read_per_join": "67K"
        },
        "used_columns": [
          "section_id",
          "edition_type",
          "name",
          "position",
          "type"
        ],
        "attached_condition": "(find_in_set('STOREFRONT',`eshopuga_upgr_4122`.`cscart_settings_sections`.`edition_type`) or find_in_set('VENDOR',`eshopuga_upgr_4122`.`cscart_settings_sections`.`edition_type`) or find_in_set('ROOT',`eshopuga_upgr_4122`.`cscart_settings_sections`.`edition_type`) or find_in_set('ULT:STOREFRONT',`eshopuga_upgr_4122`.`cscart_settings_sections`.`edition_type`) or find_in_set('ULT:VENDOR',`eshopuga_upgr_4122`.`cscart_settings_sections`.`edition_type`) or find_in_set('ULT:ROOT',`eshopuga_upgr_4122`.`cscart_settings_sections`.`edition_type`))"
      }
    }
  }
}

Result

name section_id position type description href
Emails 1 0 CORE Emails settings.manage?section_id=Emails
Company 5 0 CORE Company settings.manage?section_id=Company
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
Stores 17 0 CORE Stores settings.manage?section_id=Stores
access_restrictions 18 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 19 0 TAB general settings.manage?section_id=general
banners 20 0 ADDON banners settings.manage?section_id=banners
general 21 0 TAB general settings.manage?section_id=general
barcode 22 0 ADDON barcode settings.manage?section_id=barcode
general 23 0 TAB general settings.manage?section_id=general
call_requests 24 0 ADDON call_requests settings.manage?section_id=call_requests
general 25 0 TAB general settings.manage?section_id=general
catalog_mode 26 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 27 0 TAB general settings.manage?section_id=general
data_feeds 28 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 29 0 TAB general settings.manage?section_id=general
discussion 30 0 ADDON discussion settings.manage?section_id=discussion
products 31 0 TAB products settings.manage?section_id=products
email_marketing 38 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 39 0 TAB general settings.manage?section_id=general
gift_certificates 42 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 43 0 TAB general settings.manage?section_id=general
google_analytics 44 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 45 0 TAB general settings.manage?section_id=general
google_sitemap 46 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 47 0 TAB general settings.manage?section_id=general
hybrid_auth 48 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 49 0 TAB general settings.manage?section_id=general
image_zoom 210 0 ADDON image_zoom settings.manage?section_id=image_zoom
janrain 52 0 ADDON janrain settings.manage?section_id=janrain
general 53 0 TAB general settings.manage?section_id=general
newsletters 54 0 ADDON newsletters settings.manage?section_id=newsletters
general 55 0 TAB general settings.manage?section_id=general
paypal 56 0 ADDON paypal settings.manage?section_id=paypal
general 57 0 TAB general settings.manage?section_id=general
polls 58 0 ADDON polls settings.manage?section_id=polls
general 59 0 TAB general settings.manage?section_id=general
price_list 60 0 ADDON price_list settings.manage?section_id=price_list
general 61 0 TAB general settings.manage?section_id=general
reward_points 62 0 ADDON reward_points settings.manage?section_id=reward_points
general 63 0 TAB general settings.manage?section_id=general
rma 64 0 ADDON rma settings.manage?section_id=rma
general 65 0 TAB general settings.manage?section_id=general
rss_feed 66 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 67 0 TAB general settings.manage?section_id=general
seo 68 0 ADDON seo settings.manage?section_id=seo
general 69 0 TAB general settings.manage?section_id=general
social_buttons 70 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 71 0 TAB twitter settings.manage?section_id=twitter
store_locator 75 0 ADDON store_locator settings.manage?section_id=store_locator
general 193 0 TAB general settings.manage?section_id=general
tags 77 0 ADDON tags settings.manage?section_id=tags
general 78 0 TAB general settings.manage?section_id=general
service 128 0 TAB service settings.manage?section_id=service
watermarks 84 0 ADDON watermarks settings.manage?section_id=watermarks
general 85 0 TAB general settings.manage?section_id=general
image_gallery 167 0 ADDON image_gallery settings.manage?section_id=image_gallery
cp_floating_menu 98 0 ADDON cp_floating_menu settings.manage?section_id=cp_floating_menu
general 99 0 TAB general settings.manage?section_id=general
fliping_product_icons 180 0 ADDON fliping_product_icons settings.manage?section_id=fliping_product_icons
graceful_slider 120 0 ADDON graceful_slider settings.manage?section_id=graceful_slider
cp_power_popup 174 0 ADDON cp_power_popup settings.manage?section_id=cp_power_popup
graceful_notification 106 0 ADDON graceful_notification settings.manage?section_id=graceful_notification
general 107 0 TAB general settings.manage?section_id=general
cp_power_reviews 108 0 ADDON cp_power_reviews settings.manage?section_id=cp_power_reviews
general 109 0 TAB general settings.manage?section_id=general
cp_animated_blocks 178 0 ADDON cp_animated_blocks settings.manage?section_id=cp_animated_blocks
general 121 0 TAB general settings.manage?section_id=general
twigmo 127 0 ADDON twigmo settings.manage?section_id=twigmo
product_packages 172 0 ADDON product_packages settings.manage?section_id=product_packages
orders_feedback 176 0 ADDON orders_feedback settings.manage?section_id=orders_feedback
bestsellers 141 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 142 0 TAB general settings.manage?section_id=general
newest 143 0 TAB newest settings.manage?section_id=newest
geo_maps 192 0 ADDON geo_maps settings.manage?section_id=geo_maps
cp_power_statistics 184 0 ADDON cp_power_statistics settings.manage?section_id=cp_power_statistics
cp_equal_height_product_blocks 152 0 ADDON cp_equal_height_product_blocks settings.manage?section_id=cp_equal_height_product_blocks
general 153 0 TAB general settings.manage?section_id=general
google_recaptcha 156 0 ADDON google_recaptcha settings.manage?section_id=google_recaptcha
general 157 0 TAB general settings.manage?section_id=general
mobile 158 0 ADDON mobile settings.manage?section_id=mobile
general 159 0 TAB general settings.manage?section_id=general
cp_rename_images 160 0 ADDON cp_rename_images settings.manage?section_id=cp_rename_images
general 161 0 TAB general settings.manage?section_id=general
recaptcha 163 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 164 0 TAB general settings.manage?section_id=general
cp_graceful_theme 165 0 ADDON cp_graceful_theme settings.manage?section_id=cp_graceful_theme
general 166 0 TAB general settings.manage?section_id=general
general 168 0 TAB general settings.manage?section_id=general
image_gallery 169 0 TAB image_gallery settings.manage?section_id=image_gallery
cp_live_search 202 0 ADDON cp_live_search settings.manage?section_id=cp_live_search
general 173 0 TAB general settings.manage?section_id=general
general 175 0 TAB general settings.manage?section_id=general
general 177 0 TAB general settings.manage?section_id=general
general 179 0 TAB general settings.manage?section_id=general
general 181 0 TAB general settings.manage?section_id=general
powerfull_owl 182 0 ADDON powerfull_owl settings.manage?section_id=powerfull_owl
general 183 0 TAB general settings.manage?section_id=general
general 185 0 TAB general settings.manage?section_id=general
storefront_rest_api 186 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
hidpi 189 0 ADDON hidpi settings.manage?section_id=hidpi
general 190 0 TAB general settings.manage?section_id=general
general 191 0 TAB general settings.manage?section_id=general
step_by_step_checkout 196 0 ADDON step_by_step_checkout settings.manage?section_id=step_by_step_checkout
general 197 0 TAB general settings.manage?section_id=general
attachments 198 0 ADDON attachments settings.manage?section_id=attachments
general 199 0 TAB general settings.manage?section_id=general
cp_addons_manager 200 0 ADDON cp_addons_manager settings.manage?section_id=cp_addons_manager
general 201 0 TAB general settings.manage?section_id=general
general 203 0 TAB general settings.manage?section_id=general
general 211 0 TAB general settings.manage?section_id=general
ab__addons_manager 212 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
settings 213 0 TAB settings settings.manage?section_id=settings
ab__category_banners 216 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
settings 217 0 TAB settings settings.manage?section_id=settings
abt__unitheme2 218 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
settings 219 0 TAB settings settings.manage?section_id=settings
ab__scroll_to_top 220 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 221 0 TAB settings settings.manage?section_id=settings
ab__fast_navigation 222 0 ADDON ab__fast_navigation settings.manage?section_id=ab__fast_navigation
settings 223 0 TAB settings settings.manage?section_id=settings
ab__landing_categories 224 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 225 0 TAB settings settings.manage?section_id=settings
ab__motivation_block 226 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
settings 227 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 230 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
settings 231 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 232 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
settings 233 0 TAB settings settings.manage?section_id=settings
ab__hide_product_description 234 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
settings 235 0 TAB settings settings.manage?section_id=settings
ab__deal_of_the_day 236 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 237 0 TAB settings settings.manage?section_id=settings
ab__stickers 238 0 ADDON ab__stickers settings.manage?section_id=ab__stickers
settings 239 0 TAB settings settings.manage?section_id=settings
gdpr 241 0 ADDON gdpr settings.manage?section_id=gdpr
general 242 0 TAB general settings.manage?section_id=general
General 2 10 CORE General settings.manage?section_id=General
categories 32 10 TAB categories settings.manage?section_id=categories
promotions 144 10 TAB promotions settings.manage?section_id=promotions
mailchimp 40 10 TAB mailchimp settings.manage?section_id=mailchimp
facebook 72 10 TAB facebook settings.manage?section_id=facebook
storefront 129 10 TAB storefront settings.manage?section_id=storefront
general 187 10 TAB general settings.manage?section_id=general
forbidden_countries 188 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
yandex 194 10 TAB yandex settings.manage?section_id=yandex
search_options 204 10 TAB search_options settings.manage?section_id=search_options
appearance 228 10 TAB appearance settings.manage?section_id=appearance
text_stickers 240 10 TAB text_stickers settings.manage?section_id=text_stickers
gdpr 243 10 TAB gdpr settings.manage?section_id=gdpr
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
orders 33 20 TAB orders settings.manage?section_id=orders
madmimi 41 20 TAB madmimi settings.manage?section_id=madmimi
vkontakte 73 20 TAB vkontakte settings.manage?section_id=vkontakte
admin_app 130 20 TAB admin_app settings.manage?section_id=admin_app
google 195 20 TAB google settings.manage?section_id=google
display_options 205 20 TAB display_options settings.manage?section_id=display_options
admin_panel 229 20 TAB admin_panel settings.manage?section_id=admin_panel
twg_push 131 30 TAB twg_push settings.manage?section_id=twg_push
search_motivation 206 30 TAB search_motivation settings.manage?section_id=search_motivation
yandex 162 35 TAB yandex settings.manage?section_id=yandex
Checkout 147 40 CORE Checkout settings.manage?section_id=Checkout
gift_registry 35 40 TAB gift_registry settings.manage?section_id=gift_registry
addon 132 40 TAB addon settings.manage?section_id=addon
pinterest 146 40 TAB pinterest settings.manage?section_id=pinterest
search_acceleration 207 40 TAB search_acceleration settings.manage?section_id=search_acceleration
pages 36 50 TAB pages settings.manage?section_id=pages
testimonials 37 60 TAB testimonials settings.manage?section_id=testimonials
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