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

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

Result

name section_id position type description href
general 83 0 TAB general settings.manage?section_id=general
data_feeds 103 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 104 0 TAB general settings.manage?section_id=general
price_list 105 0 ADDON price_list settings.manage?section_id=price_list
general 106 0 TAB general settings.manage?section_id=general
hybrid_auth 107 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 108 0 TAB general settings.manage?section_id=general
janrain 109 0 ADDON janrain settings.manage?section_id=janrain
general 110 0 TAB general settings.manage?section_id=general
catalog_mode 111 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 112 0 TAB general settings.manage?section_id=general
vendor_panel_configurator 113 0 ADDON vendor_panel_configurator settings.manage?section_id=vendor_panel_configurator
product_page_settings 114 0 TAB product_page_settings settings.manage?section_id=product_page_settings
general 102 0 TAB general settings.manage?section_id=general
image_zoom 101 0 ADDON image_zoom settings.manage?section_id=image_zoom
access_restrictions 84 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 85 0 TAB general settings.manage?section_id=general
banners 86 0 ADDON banners settings.manage?section_id=banners
general 87 0 TAB general settings.manage?section_id=general
watermarks 88 0 ADDON watermarks settings.manage?section_id=watermarks
general 89 0 TAB general settings.manage?section_id=general
product_reviews 90 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 91 0 TAB general settings.manage?section_id=general
discussion 92 0 ADDON discussion settings.manage?section_id=discussion
products 93 0 TAB products settings.manage?section_id=products
google_sitemap 99 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 100 0 TAB general settings.manage?section_id=general
vendor_debt_payout 116 0 ADDON vendor_debt_payout settings.manage?section_id=vendor_debt_payout
general 117 0 TAB general settings.manage?section_id=general
vendor_privileges 118 0 ADDON vendor_privileges settings.manage?section_id=vendor_privileges
general_settings 135 0 TAB general_settings settings.manage?section_id=general_settings
wk_category_manage 138 0 ADDON wk_category_manage settings.manage?section_id=wk_category_manage
general 139 0 TAB general settings.manage?section_id=general
wk_whatsapp_order_notification 145 0 ADDON wk_whatsapp_order_notification settings.manage?section_id=wk_whatsapp_order_notification
general 144 0 TAB general settings.manage?section_id=general
wk_open_ai_suggestions 143 0 ADDON wk_open_ai_suggestions settings.manage?section_id=wk_open_ai_suggestions
api_credentials 146 0 TAB api_credentials settings.manage?section_id=api_credentials
wk_google_language_convertor 148 0 ADDON wk_google_language_convertor settings.manage?section_id=wk_google_language_convertor
general 149 0 TAB general settings.manage?section_id=general
cp_power_seo_filter 152 0 ADDON cp_power_seo_filter settings.manage?section_id=cp_power_seo_filter
general 153 0 TAB general settings.manage?section_id=general
wk_elastic_search 158 0 ADDON wk_elastic_search settings.manage?section_id=wk_elastic_search
wk_backup_management 134 0 ADDON wk_backup_management settings.manage?section_id=wk_backup_management
wk_general 132 0 TAB wk_general settings.manage?section_id=wk_general
general 119 0 TAB general settings.manage?section_id=general
wk_saas 120 0 ADDON wk_saas settings.manage?section_id=wk_saas
general 121 0 TAB general settings.manage?section_id=general
wk_iyzico_marketplace 123 0 ADDON wk_iyzico_marketplace settings.manage?section_id=wk_iyzico_marketplace
general 124 0 TAB general settings.manage?section_id=general
sd_xml_import 125 0 ADDON sd_xml_import settings.manage?section_id=sd_xml_import
sd_import_xml 126 0 TAB sd_import_xml settings.manage?section_id=sd_import_xml
accordian 127 0 ADDON accordian settings.manage?section_id=accordian
general 128 0 TAB general settings.manage?section_id=general
wk_advanced_currency_exchange 129 0 ADDON wk_advanced_currency_exchange settings.manage?section_id=wk_advanced_currency_exchange
general 130 0 TAB general settings.manage?section_id=general
wk_chatbot 131 0 ADDON wk_chatbot settings.manage?section_id=wk_chatbot
wk_general 159 0 TAB wk_general settings.manage?section_id=wk_general
polls 82 0 ADDON polls settings.manage?section_id=polls
Emails 1 0 CORE Emails settings.manage?section_id=Emails
newsletters 31 0 ADDON newsletters settings.manage?section_id=newsletters
general 32 0 TAB general settings.manage?section_id=general
email_marketing 34 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 35 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
geo_maps 42 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 43 0 TAB general settings.manage?section_id=general
vendor_communication 46 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 47 0 TAB general settings.manage?section_id=general
general 30 0 TAB general settings.manage?section_id=general
rss_feed 29 0 ADDON rss_feed settings.manage?section_id=rss_feed
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
social_buttons 19 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 20 0 TAB twitter settings.manage?section_id=twitter
paypal 25 0 ADDON paypal settings.manage?section_id=paypal
general 26 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
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
seo 70 0 ADDON seo settings.manage?section_id=seo
general 71 0 TAB general settings.manage?section_id=general
reward_points 72 0 ADDON reward_points settings.manage?section_id=reward_points
general 73 0 TAB general settings.manage?section_id=general
facebook_pixel 74 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
general 75 0 TAB general settings.manage?section_id=general
google_analytics 76 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 77 0 TAB general settings.manage?section_id=general
call_requests 78 0 ADDON call_requests settings.manage?section_id=call_requests
general 79 0 TAB general settings.manage?section_id=general
general 81 0 TAB general settings.manage?section_id=general
barcode 80 0 ADDON barcode settings.manage?section_id=barcode
general 68 0 TAB general settings.manage?section_id=general
bestsellers 67 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 66 0 TAB general settings.manage?section_id=general
general 53 0 TAB general settings.manage?section_id=general
gift_certificates 54 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 55 0 TAB general settings.manage?section_id=general
store_locator 56 0 ADDON store_locator settings.manage?section_id=store_locator
general 57 0 TAB general settings.manage?section_id=general
storefront_rest_api 58 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
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
recaptcha 62 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 63 0 TAB general settings.manage?section_id=general
rma 65 0 ADDON rma settings.manage?section_id=rma
email_template 122 10 TAB email_template settings.manage?section_id=email_template
wk_theme_settings 133 10 TAB wk_theme_settings settings.manage?section_id=wk_theme_settings
dropbox_settings 136 10 TAB dropbox_settings settings.manage?section_id=dropbox_settings
whatsapp_template 147 10 TAB whatsapp_template settings.manage?section_id=whatsapp_template
seo_templates 154 10 TAB seo_templates settings.manage?section_id=seo_templates
wk_search_setting 160 10 TAB wk_search_setting settings.manage?section_id=wk_search_setting
vendor_panel_style 115 10 TAB vendor_panel_style settings.manage?section_id=vendor_panel_style
categories 94 10 TAB categories settings.manage?section_id=categories
newest 69 10 TAB newest settings.manage?section_id=newest
promotions 33 10 TAB promotions settings.manage?section_id=promotions
General 2 10 CORE General settings.manage?section_id=General
facebook 21 10 TAB facebook settings.manage?section_id=facebook
mailchimp 36 10 TAB mailchimp settings.manage?section_id=mailchimp
yandex 44 10 TAB yandex settings.manage?section_id=yandex
vendor_to_customer 48 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
products 51 10 TAB products settings.manage?section_id=products
forbidden_countries 64 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
indexation 155 20 TAB indexation settings.manage?section_id=indexation
cron_settings 137 20 TAB cron_settings settings.manage?section_id=cron_settings
orders 95 20 TAB orders settings.manage?section_id=orders
madmimi 37 20 TAB madmimi settings.manage?section_id=madmimi
vkontakte 22 20 TAB vkontakte settings.manage?section_id=vkontakte
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
google 45 20 TAB google settings.manage?section_id=google
images_map 156 30 TAB images_map settings.manage?section_id=images_map
pages 96 30 TAB pages settings.manage?section_id=pages
Company 5 30 CORE Company settings.manage?section_id=Company
yandex 23 30 TAB yandex settings.manage?section_id=yandex
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
shared_buttons 157 40 TAB shared_buttons settings.manage?section_id=shared_buttons
testimonials 97 40 TAB testimonials settings.manage?section_id=testimonials
pinterest 24 40 TAB pinterest settings.manage?section_id=pinterest
companies 98 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