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.00047

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_settings_sections ALL 148 Using where; Using filesort

Result

name section_id position type description href
polls 75 0 ADDON polls settings.manage?section_id=polls
price_list 97 0 ADDON price_list settings.manage?section_id=price_list
general 98 0 TAB general settings.manage?section_id=general
janrain 99 0 ADDON janrain settings.manage?section_id=janrain
general 100 0 TAB general settings.manage?section_id=general
catalog_mode 101 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 102 0 TAB general settings.manage?section_id=general
hybrid_auth 103 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 104 0 TAB general settings.manage?section_id=general
zapier 105 0 ADDON zapier settings.manage?section_id=zapier
general 106 0 TAB general settings.manage?section_id=general
gdpr 107 0 ADDON gdpr settings.manage?section_id=gdpr
general 108 0 TAB general settings.manage?section_id=general
general 456 0 TAB general settings.manage?section_id=general
pinta_google_tag_manager 455 0 ADDON pinta_google_tag_manager settings.manage?section_id=pinta_google_tag_manager
general 577 0 TAB general settings.manage?section_id=general
general 96 0 TAB general settings.manage?section_id=general
data_feeds 95 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 76 0 TAB general settings.manage?section_id=general
access_restrictions 77 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 78 0 TAB general settings.manage?section_id=general
banners 79 0 ADDON banners settings.manage?section_id=banners
general 80 0 TAB general settings.manage?section_id=general
watermarks 81 0 ADDON watermarks settings.manage?section_id=watermarks
general 82 0 TAB general settings.manage?section_id=general
products 473 0 TAB products settings.manage?section_id=products
discussion 472 0 ADDON discussion settings.manage?section_id=discussion
product_reviews 89 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 90 0 TAB general settings.manage?section_id=general
google_sitemap 91 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 92 0 TAB general settings.manage?section_id=general
image_zoom 93 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 94 0 TAB general settings.manage?section_id=general
pinta_openai 576 0 ADDON pinta_openai settings.manage?section_id=pinta_openai
general 563 0 TAB general settings.manage?section_id=general
general 436 0 TAB general settings.manage?section_id=general
totalshipping 478 0 ADDON totalshipping settings.manage?section_id=totalshipping
seometatags 391 0 ADDON seometatags settings.manage?section_id=seometatags
optipic 323 0 ADDON optipic settings.manage?section_id=optipic
generic_settings 324 0 TAB generic_settings settings.manage?section_id=generic_settings
image_compress_pro 568 0 ADDON image_compress_pro settings.manage?section_id=image_compress_pro
general 569 0 TAB general settings.manage?section_id=general
pw_google_two_auth 469 0 ADDON pw_google_two_auth settings.manage?section_id=pw_google_two_auth
pinta_nova_poshta 514 0 ADDON pinta_nova_poshta settings.manage?section_id=pinta_nova_poshta
google_merchant_api 441 0 ADDON google_merchant_api settings.manage?section_id=google_merchant_api
ecl_google_tag_manager 415 0 ADDON ecl_google_tag_manager settings.manage?section_id=ecl_google_tag_manager
general 416 0 TAB general settings.manage?section_id=general
general1 442 0 TAB general1 settings.manage?section_id=general1
general 567 0 TAB general settings.manage?section_id=general
image_compress_resmush 516 0 ADDON image_compress_resmush settings.manage?section_id=image_compress_resmush
general 515 0 TAB general settings.manage?section_id=general
general 479 0 TAB general settings.manage?section_id=general
general 392 0 TAB general settings.manage?section_id=general
module_admin 566 0 ADDON module_admin settings.manage?section_id=module_admin
PintaAMP 530 0 ADDON PintaAMP settings.manage?section_id=PintaAMP
PintaAMP_general 531 0 TAB PintaAMP_general settings.manage?section_id=PintaAMP_general
general 394 0 TAB general settings.manage?section_id=general
pinta_google_feed 393 0 ADDON pinta_google_feed settings.manage?section_id=pinta_google_feed
pinta_social_login 562 0 ADDON pinta_social_login settings.manage?section_id=pinta_social_login
general 537 0 TAB general settings.manage?section_id=general
pinta_redirect_manager 536 0 ADDON pinta_redirect_manager settings.manage?section_id=pinta_redirect_manager
Preloader 526 0 ADDON Preloader settings.manage?section_id=Preloader
pinta_preloader 247 0 ADDON pinta_preloader settings.manage?section_id=pinta_preloader
general 248 0 TAB general settings.manage?section_id=general
general 527 0 TAB general settings.manage?section_id=general
mb_messenger_buttons 435 0 ADDON mb_messenger_buttons settings.manage?section_id=mb_messenger_buttons
general 270 0 TAB general settings.manage?section_id=general
pinta_product_label 269 0 ADDON pinta_product_label settings.manage?section_id=pinta_product_label
general 517 0 TAB general settings.manage?section_id=general
general 74 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
newsletters 36 0 ADDON newsletters settings.manage?section_id=newsletters
general 37 0 TAB general settings.manage?section_id=general
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
attachments 39 0 ADDON attachments settings.manage?section_id=attachments
general 40 0 TAB general settings.manage?section_id=general
vendor_communication 41 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
geo_maps 43 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 44 0 TAB general settings.manage?section_id=general
email_marketing 32 0 ADDON email_marketing settings.manage?section_id=email_marketing
gift_certificates 47 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
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
Company 5 0 CORE Company settings.manage?section_id=Company
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
hidpi 18 0 ADDON hidpi settings.manage?section_id=hidpi
general 19 0 TAB general settings.manage?section_id=general
paypal 20 0 ADDON paypal settings.manage?section_id=paypal
general 21 0 TAB general settings.manage?section_id=general
social_buttons 22 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 23 0 TAB twitter settings.manage?section_id=twitter
tags 28 0 ADDON tags settings.manage?section_id=tags
general 48 0 TAB general settings.manage?section_id=general
store_locator 49 0 ADDON store_locator settings.manage?section_id=store_locator
general 50 0 TAB general settings.manage?section_id=general
barcode 73 0 ADDON barcode settings.manage?section_id=barcode
general 59 0 TAB general settings.manage?section_id=general
general 66 0 TAB general settings.manage?section_id=general
general 72 0 TAB general settings.manage?section_id=general
bestsellers 60 0 ADDON bestsellers settings.manage?section_id=bestsellers
rma 58 0 ADDON rma settings.manage?section_id=rma
general 61 0 TAB general settings.manage?section_id=general
seo 63 0 ADDON seo settings.manage?section_id=seo
general 64 0 TAB general settings.manage?section_id=general
google_analytics 67 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 57 0 TAB general settings.manage?section_id=general
recaptcha 51 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 52 0 TAB general settings.manage?section_id=general
call_requests 71 0 ADDON call_requests settings.manage?section_id=call_requests
reward_points 65 0 ADDON reward_points settings.manage?section_id=reward_points
general 70 0 TAB general settings.manage?section_id=general
facebook_pixel 69 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
product_variations 54 0 ADDON product_variations settings.manage?section_id=product_variations
general 68 0 TAB general settings.manage?section_id=general
general 55 0 TAB general settings.manage?section_id=general
product_bundles 56 0 ADDON product_bundles settings.manage?section_id=product_bundles
facebook 24 10 TAB facebook settings.manage?section_id=facebook
General 2 10 CORE General settings.manage?section_id=General
categories 474 10 TAB categories settings.manage?section_id=categories
newest 62 10 TAB newest settings.manage?section_id=newest
yandex 45 10 TAB yandex settings.manage?section_id=yandex
forbidden_countries 53 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
promotions 38 10 TAB promotions settings.manage?section_id=promotions
mailchimp 34 10 TAB mailchimp settings.manage?section_id=mailchimp
gdpr 109 10 TAB gdpr settings.manage?section_id=gdpr
PintaAMP_googl_add 532 10 TAB PintaAMP_googl_add settings.manage?section_id=PintaAMP_googl_add
vendor_to_customer 42 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
orders 475 20 TAB orders settings.manage?section_id=orders
PintaAMP_icon 533 20 TAB PintaAMP_icon settings.manage?section_id=PintaAMP_icon
madmimi 35 20 TAB madmimi settings.manage?section_id=madmimi
vkontakte 25 20 TAB vkontakte settings.manage?section_id=vkontakte
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
google 46 20 TAB google settings.manage?section_id=google
PintaAMP_banner 534 30 TAB PintaAMP_banner settings.manage?section_id=PintaAMP_banner
pages 476 30 TAB pages settings.manage?section_id=pages
yandex 26 30 TAB yandex settings.manage?section_id=yandex
testimonials 477 40 TAB testimonials settings.manage?section_id=testimonials
PintaAMP_theme_settings 535 40 TAB PintaAMP_theme_settings settings.manage?section_id=PintaAMP_theme_settings
pinterest 27 40 TAB pinterest settings.manage?section_id=pinterest
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
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