Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT Value FROM `System` WHERE `Key` = ?

[
  "WebsiteDefaultCountry"
]

SELECT
  Value
FROM
  `System`
WHERE
  `Key` = ?

SELECT Value FROM `System` WHERE `Key` = 'WebsiteDefaultCountry';

SELECT currencyCode as CurrencyCode FROM Country c WHERE countryCode = ?

[
  "NA"
]

SELECT
  currencyCode as CurrencyCode
FROM
  Country c
WHERE
  countryCode = ?

SELECT currencyCode as CurrencyCode FROM Country c WHERE countryCode = 'NA';

SELECT currencySign as CurrencySign FROM Country c WHERE countryCode = ?

[
  "NA"
]

SELECT
  currencySign as CurrencySign
FROM
  Country c
WHERE
  countryCode = ?

SELECT currencySign as CurrencySign FROM Country c WHERE countryCode = 'NA';

SELECT CountryCode FROM Pricing p WHERE CountryCode = ?

[
  "NA"
]

SELECT
  CountryCode
FROM
  Pricing p
WHERE
  CountryCode = ?

SELECT CountryCode FROM Pricing p WHERE CountryCode = 'NA';

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 = ?

[
  "NA"
]

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 = ?

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 = 'NA';

SELECT * FROM Package WHERE ID = ?

[
  1
]

SELECT
  *
FROM
  Package
WHERE
  ID = ?

SELECT * FROM Package WHERE ID = 1;

SELECT * FROM Package WHERE ID = ?

[
  2
]

SELECT
  *
FROM
  Package
WHERE
  ID = ?

SELECT * FROM Package WHERE ID = 2;

SELECT * FROM Package WHERE ID = ?

[
  3
]

SELECT
  *
FROM
  Package
WHERE
  ID = ?

SELECT * FROM Package WHERE ID = 3;

SELECT * FROM Package WHERE ID = ?

[
  100
]

SELECT
  *
FROM
  Package
WHERE
  ID = ?

SELECT * FROM Package WHERE ID = 100;

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

[
  "Y"
]

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

SELECT c.CountryCode, countryName as CountryName FROM Pricing p INNER JOIN Country c ON p.CountryCode = c.countryCode WHERE Active = 'Y' GROUP BY CountryCode, CountryName ORDER BY CountryName ASC;