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

Query time 0.00115

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_settings_sections.position",
        "table": {
          "table_name": "cscart_settings_sections",
          "access_type": "ALL",
          "rows": 173,
          "filtered": 100,
          "attached_condition": "find_in_set('ROOT',cscart_settings_sections.edition_type) or find_in_set('VENDOR',cscart_settings_sections.edition_type) or find_in_set('ULT:ROOT',cscart_settings_sections.edition_type) or find_in_set('ULT:VENDOR',cscart_settings_sections.edition_type)"
        }
      }
    }
  }
}

Result

name section_id position type description href
general 97 0 TAB general settings.manage?section_id=general
settings 167 0 TAB settings settings.manage?section_id=settings
settings 169 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 168 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
ab__multiple_cat_descriptions 166 0 ADDON ab__multiple_cat_descriptions settings.manage?section_id=ab__multiple_cat_descriptions
image_gallery 143 0 ADDON image_gallery settings.manage?section_id=image_gallery
general 144 0 TAB general settings.manage?section_id=general
image_gallery 147 0 TAB image_gallery settings.manage?section_id=image_gallery
cp_seo_templates 148 0 ADDON cp_seo_templates settings.manage?section_id=cp_seo_templates
general 149 0 TAB general settings.manage?section_id=general
cp_tag_ext 150 0 ADDON cp_tag_ext settings.manage?section_id=cp_tag_ext
general 151 0 TAB general settings.manage?section_id=general
cp_auto_image_title 153 0 ADDON cp_auto_image_title settings.manage?section_id=cp_auto_image_title
general 154 0 TAB general settings.manage?section_id=general
cp_entity 155 0 ADDON cp_entity settings.manage?section_id=cp_entity
general 156 0 TAB general settings.manage?section_id=general
ab__deal_of_the_day 164 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 165 0 TAB settings settings.manage?section_id=settings
rus_ruble 98 0 ADDON rus_ruble settings.manage?section_id=rus_ruble
settings 99 0 TAB settings settings.manage?section_id=settings
rus_russianpost 100 0 ADDON rus_russianpost settings.manage?section_id=rus_russianpost
general 101 0 TAB general settings.manage?section_id=general
rus_personal_data_processing 103 0 ADDON rus_personal_data_processing settings.manage?section_id=rus_personal_data_processing
general 104 0 TAB general settings.manage?section_id=general
yandex_delivery 105 0 ADDON yandex_delivery settings.manage?section_id=yandex_delivery
general 106 0 TAB general settings.manage?section_id=general
ab__addons_manager 207 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
cp_power_blog 115 0 ADDON cp_power_blog settings.manage?section_id=cp_power_blog
general 116 0 TAB general settings.manage?section_id=general
blog 117 0 TAB blog settings.manage?section_id=blog
abt__youpitheme 162 0 ADDON abt__youpitheme settings.manage?section_id=abt__youpitheme
general 125 0 TAB general settings.manage?section_id=general
sd_affiliate 124 0 ADDON sd_affiliate settings.manage?section_id=sd_affiliate
rus_online_cash_register 157 0 ADDON rus_online_cash_register settings.manage?section_id=rus_online_cash_register
general 158 0 TAB general settings.manage?section_id=general
rus_yandex_metrika 160 0 ADDON rus_yandex_metrika settings.manage?section_id=rus_yandex_metrika
gdpr 192 0 ADDON gdpr settings.manage?section_id=gdpr
general 189 0 TAB general settings.manage?section_id=general
general 191 0 TAB general settings.manage?section_id=general
general 193 0 TAB general settings.manage?section_id=general
vendor_communication 195 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 196 0 TAB general settings.manage?section_id=general
redesk_connection 197 0 ADDON redesk_connection settings.manage?section_id=redesk_connection
general 198 0 TAB general settings.manage?section_id=general
general 202 0 TAB general settings.manage?section_id=general
sofit 201 0 ADDON sofit settings.manage?section_id=sofit
cp_video_gallery 203 0 ADDON cp_video_gallery settings.manage?section_id=cp_video_gallery
general 204 0 TAB general settings.manage?section_id=general
settings 208 0 TAB settings settings.manage?section_id=settings
ab__motivation_block 209 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
settings 210 0 TAB settings settings.manage?section_id=settings
general 214 0 TAB general settings.manage?section_id=general
general 188 0 TAB general settings.manage?section_id=general
general 161 0 TAB general settings.manage?section_id=general
settings 163 0 TAB settings settings.manage?section_id=settings
ab__scroll_to_top 170 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 171 0 TAB settings settings.manage?section_id=settings
ab__landing_categories 172 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 173 0 TAB settings settings.manage?section_id=settings
default_secondary_currency 174 0 ADDON default_secondary_currency settings.manage?section_id=default_secondary_currency
section 175 0 TAB section settings.manage?section_id=section
geo_maps 183 0 ADDON geo_maps settings.manage?section_id=geo_maps
hidpi 176 0 ADDON hidpi settings.manage?section_id=hidpi
general 177 0 TAB general settings.manage?section_id=general
step_by_step_checkout 190 0 ADDON step_by_step_checkout settings.manage?section_id=step_by_step_checkout
product_variations 181 0 ADDON product_variations settings.manage?section_id=product_variations
general 184 0 TAB general settings.manage?section_id=general
ecl_google_tag_manager 187 0 ADDON ecl_google_tag_manager settings.manage?section_id=ecl_google_tag_manager
replain 213 0 ADDON replain settings.manage?section_id=replain
paypal 26 0 ADDON paypal settings.manage?section_id=paypal
gift_certificates 39 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 40 0 TAB general settings.manage?section_id=general
store_locator 41 0 ADDON store_locator settings.manage?section_id=store_locator
general 182 0 TAB general settings.manage?section_id=general
storefront_rest_api 43 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 44 0 TAB general settings.manage?section_id=general
recaptcha 45 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 46 0 TAB general settings.manage?section_id=general
rma 48 0 ADDON rma settings.manage?section_id=rma
general 49 0 TAB general settings.manage?section_id=general
bestsellers 50 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 51 0 TAB general settings.manage?section_id=general
seo 53 0 ADDON seo settings.manage?section_id=seo
general 54 0 TAB general settings.manage?section_id=general
reward_points 55 0 ADDON reward_points settings.manage?section_id=reward_points
general 37 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
general 33 0 TAB general settings.manage?section_id=general
email_marketing 32 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 31 0 TAB general settings.manage?section_id=general
rss_feed 30 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 29 0 TAB general settings.manage?section_id=general
tags 28 0 ADDON tags settings.manage?section_id=tags
general 27 0 TAB general settings.manage?section_id=general
twitter 19 0 TAB twitter settings.manage?section_id=twitter
newsletters 36 0 ADDON newsletters settings.manage?section_id=newsletters
social_buttons 18 0 ADDON social_buttons settings.manage?section_id=social_buttons
Stores 17 0 CORE Stores settings.manage?section_id=Stores
Security 15 0 CORE Security settings.manage?section_id=Security
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
Company 5 0 CORE Company settings.manage?section_id=Company
general 56 0 TAB general settings.manage?section_id=general
rus_pickup 57 0 ADDON rus_pickup settings.manage?section_id=rus_pickup
general 58 0 TAB general settings.manage?section_id=general
general 76 0 TAB general settings.manage?section_id=general
discussion 77 0 ADDON discussion settings.manage?section_id=discussion
products 78 0 TAB products settings.manage?section_id=products
image_zoom 84 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 85 0 TAB general settings.manage?section_id=general
google_sitemap 86 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 87 0 TAB general settings.manage?section_id=general
data_feeds 88 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 89 0 TAB general settings.manage?section_id=general
price_list 90 0 ADDON price_list settings.manage?section_id=price_list
general 91 0 TAB general settings.manage?section_id=general
hybrid_auth 92 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 93 0 TAB general settings.manage?section_id=general
janrain 94 0 ADDON janrain settings.manage?section_id=janrain
general 95 0 TAB general settings.manage?section_id=general
watermarks 75 0 ADDON watermarks settings.manage?section_id=watermarks
general 74 0 TAB general settings.manage?section_id=general
google_analytics 59 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 60 0 TAB general settings.manage?section_id=general
call_requests 61 0 ADDON call_requests settings.manage?section_id=call_requests
general 62 0 TAB general settings.manage?section_id=general
maps_provider 63 0 ADDON maps_provider settings.manage?section_id=maps_provider
general 64 0 TAB general settings.manage?section_id=general
yandex_search 65 0 ADDON yandex_search settings.manage?section_id=yandex_search
general 66 0 TAB general settings.manage?section_id=general
barcode 67 0 ADDON barcode settings.manage?section_id=barcode
general 68 0 TAB general settings.manage?section_id=general
banners 73 0 ADDON banners settings.manage?section_id=banners
general 72 0 TAB general settings.manage?section_id=general
access_restrictions 71 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 70 0 TAB general settings.manage?section_id=general
polls 69 0 ADDON polls settings.manage?section_id=polls
catalog_mode 96 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
gdpr 194 10 TAB gdpr settings.manage?section_id=gdpr
visual_options 205 10 TAB visual_options settings.manage?section_id=visual_options
galleries_page_settings 145 10 TAB galleries_page_settings settings.manage?section_id=galleries_page_settings
appearance 211 10 TAB appearance settings.manage?section_id=appearance
yandex 185 10 TAB yandex settings.manage?section_id=yandex
size 102 10 TAB size settings.manage?section_id=size
text_banner 126 10 TAB text_banner settings.manage?section_id=text_banner
tags_sitemap_settings 152 10 TAB tags_sitemap_settings settings.manage?section_id=tags_sitemap_settings
newest 52 10 TAB newest settings.manage?section_id=newest
atol 159 10 TAB atol settings.manage?section_id=atol
categories 79 10 TAB categories settings.manage?section_id=categories
forbidden_countries 47 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
promotions 38 10 TAB promotions settings.manage?section_id=promotions
General 2 10 CORE General settings.manage?section_id=General
mailchimp 34 10 TAB mailchimp settings.manage?section_id=mailchimp
facebook 20 10 TAB facebook settings.manage?section_id=facebook
admin_panel 212 20 TAB admin_panel settings.manage?section_id=admin_panel
google 186 20 TAB google settings.manage?section_id=google
comments_and_review 206 20 TAB comments_and_review settings.manage?section_id=comments_and_review
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
vkontakte 21 20 TAB vkontakte settings.manage?section_id=vkontakte
madmimi 35 20 TAB madmimi settings.manage?section_id=madmimi
discount_coupons 127 20 TAB discount_coupons settings.manage?section_id=discount_coupons
gallery_sitemap_settings 146 20 TAB gallery_sitemap_settings settings.manage?section_id=gallery_sitemap_settings
orders 80 20 TAB orders settings.manage?section_id=orders
gift_registry 81 30 TAB gift_registry settings.manage?section_id=gift_registry
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
pages 82 40 TAB pages settings.manage?section_id=pages
yandex 23 40 TAB yandex settings.manage?section_id=yandex
testimonials 83 50 TAB testimonials settings.manage?section_id=testimonials
pinterest 24 50 TAB pinterest settings.manage?section_id=pinterest
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