SELECT 
  * 
FROM 
  ushop_hybrid_auth_providers 
WHERE 
  1 
  AND status = 'A' 
ORDER BY 
  position

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "ushop_hybrid_auth_providers",
          "access_type": "system",
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

provider_id name company_id provider position app_id app_secret_key app_public_key app_params status
1 UShop MarketPlace 0 google 0 1077122503334-b2cuo0nmk2jhpbotnm0nncufs2jvtbp7.apps.googleusercontent.com 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 A