SELECT 
  addon, 
  priority, 
  status, 
  unmanaged 
FROM 
  cscart_addons 
WHERE 
  1 
ORDER BY 
  priority

Query time 0.00067

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_addons.priority",
        "table": {
          "table_name": "cscart_addons",
          "access_type": "ALL",
          "rows": 81,
          "filtered": 100
        }
      }
    }
  }
}

Result

addon priority status unmanaged
hidpi 1 D 0
stripe 100 A 0
paypal_checkout 100 A 0
social_buttons 100 A 0
paypal 100 D 0
help_center 100 A 0
tags 200 A 0
debug_mailer 300 A 0
rss_feed 490 A 0
newsletters 500 A 0
email_marketing 500 D 0
attachments 600 A 0
vendor_rating 900 A 0
customers_also_bought 900 A 0
vendor_terms 1000 D 0
mve_plus 1000 A 1
geo_maps 1000 D 0
advanced_import 1000 A 0
vendor_plans 1000 A 0
gift_certificates 1100 D 0
store_locator 1200 D 0
product_variations 1500 D 0
recaptcha 1500 A 0
storefront_rest_api 1500 A 1
product_bundles 1520 D 0
rma 1600 D 0
bestsellers 1700 A 0
blog 1700 A 0
seo 1800 A 0
reward_points 1900 D 0
vendor_data_premoderation 1900 A 0
vendor_categories_fee 2000 A 0
google_analytics 2000 D 0
facebook_pixel 2000 D 0
call_requests 2300 D 0
form_builder 2400 D 0
barcode 2500 D 0
polls 2600 D 0
access_restrictions 2700 D 0
banners 2800 A 0
eitems_banners 2800 A 0
ecl_full_ckeditor 2900 A 0
watermarks 3000 D 0
discussion 3000 A 0
product_reviews 3001 A 0
wishlist 3100 D 0
image_zoom 3500 A 0
google_sitemap 3500 A 0
required_products 3900 D 0
data_feeds 4000 A 0
price_list 4100 A 0
hybrid_auth 4200 D 0
janrain 4200 D 0
graphql_api 4200 A 1
catalog_mode 4200 D 0
zapier 4320 A 0
eitems_services 9000 A 0
eitems_acc 9000 A 0
eitems_category_filters 9000 A 0
eitems_gold 9000 A 0
eitems_currency 9000 A 0
eitems_validation 9000 A 0
gdpr 9999 A 0
vendor_panel_configurator 10000 D 0
eitems_vendor_data_premoderation 100500 A 0
eitems_featuresstyles 100500 A 0
eitems_privat 100500 A 0
eitems_office 100500 A 0
eitems_wallet 100500 A 0
eitems_chat 100500 A 0
eitems_orders 100500 A 0
btkeeper 100500 D 0
eitems_design 100500 A 0
eitems_faq 100500 A 0
bt_keeper 100500 D 0
eitems_admin 100500 A 0
eitems_service_types 100500 A 0
shopify_import 4328362 D 0
vendor_privileges 4294967294 D 0
tech_support_chat 4294967294 A 1
my_changes 4294967294 D 0