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

Query time 0.00166

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.053575273,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_addons.priority",
            "table": {
              "table_name": "cscart_addons",
              "access_type": "ALL",
              "loops": 1,
              "rows": 53,
              "cost": 0.0194938,
              "filtered": 100
            }
          }
        }
      }
    ]
  }
}

Result

addon priority status unmanaged
upsell 1 A 1
hidpi 1 A 0
pwa 50 A 0
onboarding_guide 100 A 1
paypal_checkout 100 A 0
social_buttons 100 A 0
help_center 100 A 0
tags 200 A 0
rss_feed 490 A 0
newsletters 500 A 0
email_marketing 500 D 0
attachments 600 A 0
customers_also_bought 900 A 0
geo_maps 1000 A 0
vendor_communication 1000 A 0
advanced_import 1000 A 0
gift_certificates 1100 A 0
store_locator 1200 A 0
product_variations 1500 A 0
recaptcha 1500 A 0
storefront_rest_api 1500 A 1
product_bundles 1520 A 0
rma 1600 D 0
blog 1700 A 0
bestsellers 1700 A 0
seo 1800 A 0
reward_points 1900 A 0
google_analytics 2000 D 0
facebook_pixel 2000 D 0
call_requests 2300 A 0
form_builder 2400 A 0
barcode 2500 A 0
polls 2600 D 0
access_restrictions 2700 D 0
banners 2800 A 0
discussion 3000 A 0
watermarks 3000 D 0
product_reviews 3001 A 0
wishlist 3100 A 0
google_sitemap 3500 A 0
image_zoom 3500 A 0
required_products 3900 A 0
data_feeds 4000 A 0
price_list 4100 A 0
catalog_mode 4200 D 0
janrain 4200 D 0
hybrid_auth 4200 A 0
zapier 4320 A 0
price_per_unit 4330 A 0
gdpr 9999 A 0
shopify_import 4328362 A 0
my_changes 4294967294 D 0
tech_support_chat 4294967294 A 1