GET https://insurancebuffalo.net/pricing

Query Metrics

10 Database Queries
7 Different statements
8.50 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.35 ms
(27.67%)
4
SELECT * FROM Package WHERE ID = ?
Parameters:
[
  1
]
1.88 ms
(22.08%)
1
SELECT Value FROM `System` WHERE `Key` = ?
Parameters:
[
  "WebsiteDefaultCountry"
]
1.10 ms
(12.91%)
1
SELECT currencyCode as CurrencyCode FROM Country c WHERE countryCode = ?
Parameters:
[
  "NA"
]
0.94 ms
(11.02%)
1
SELECT c.CountryCode, countryName as CountryName FROM Pricing p INNER JOIN Country c ON p.CountryCode = c.countryCode WHERE Active = ? GROUP BY CountryCode, CountryName ORDER BY CountryName ASC
Parameters:
[
  "Y"
]
0.86 ms
(10.13%)
1
SELECT CountryCode FROM Pricing p WHERE CountryCode = ?
Parameters:
[
  "NA"
]
0.73 ms
(8.62%)
1
SELECT p.*, c.currencySign as CurrencySign, c.currencyCode as CurrencyCode FROM Pricing p INNER JOIN Country c ON p.CountryCode = c.countryCode WHERE p.CountryCode = ?
Parameters:
[
  "NA"
]
0.64 ms
(7.57%)
1
SELECT currencySign as CurrencySign FROM Country c WHERE countryCode = ?
Parameters:
[
  "NA"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.