Symfony Profiler

• Request / Response
• Performance
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Emails
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.totp_secret AS totp_secret_5, t0.nonce AS nonce_6, t0.timestamp AS timestamp_7 FROM `user` t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.totp_secret AS totp_secret_5,
  t0.nonce AS nonce_6,
  t0.timestamp AS timestamp_7
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.totp_secret AS totp_secret_5, t0.nonce AS nonce_6, t0.timestamp AS timestamp_7 FROM `user` t0 WHERE t0.id = 1;

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.dateout IS NULL

[]

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  articles a0_
  LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id
WHERE
  a0_.returned IS NULL
  AND a0_.dateout IS NULL

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.dateout IS NULL;

SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.dateout IS NULL ORDER BY a0_.name DESC LIMIT 20

[]

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.name AS name_1
FROM
  articles a0_
  LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id
WHERE
  a0_.returned IS NULL
  AND a0_.dateout IS NULL
ORDER BY
  a0_.name DESC
LIMIT
  20

SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.dateout IS NULL ORDER BY a0_.name DESC LIMIT 20;

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.rate AS rate_3, a0_.datein AS datein_4, a0_.priceexpected AS priceexpected_5, a0_.offline AS offline_6, a0_.online AS online_7, a0_.section AS section_8, a0_.invoice AS invoice_9, a0_.receipt_sent AS receipt_sent_10, a0_.dateout AS dateout_11, a0_.pricerealized AS pricerealized_12, a0_.returned AS returned_13, a0_.supplier_id AS supplier_id_14, a0_.bon_id AS bon_id_15 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.dateout IS NULL AND a0_.id IN (?, ?, ?, ?, ?) ORDER BY a0_.name DESC

[
  2
  3
  1
  5
  4
]

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.rate AS rate_3,
  a0_.datein AS datein_4,
  a0_.priceexpected AS priceexpected_5,
  a0_.offline AS offline_6,
  a0_.online AS online_7,
  a0_.section AS section_8,
  a0_.invoice AS invoice_9,
  a0_.receipt_sent AS receipt_sent_10,
  a0_.dateout AS dateout_11,
  a0_.pricerealized AS pricerealized_12,
  a0_.returned AS returned_13,
  a0_.supplier_id AS supplier_id_14,
  a0_.bon_id AS bon_id_15
FROM
  articles a0_
  LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id
WHERE
  a0_.returned IS NULL
  AND a0_.dateout IS NULL
  AND a0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  a0_.name DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.rate AS rate_3, a0_.datein AS datein_4, a0_.priceexpected AS priceexpected_5, a0_.offline AS offline_6, a0_.online AS online_7, a0_.section AS section_8, a0_.invoice AS invoice_9, a0_.receipt_sent AS receipt_sent_10, a0_.dateout AS dateout_11, a0_.pricerealized AS pricerealized_12, a0_.returned AS returned_13, a0_.supplier_id AS supplier_id_14, a0_.bon_id AS bon_id_15 FROM articles a0_ LEFT JOIN suppliers s1_ ON a0_.supplier_id = s1_.id WHERE a0_.returned IS NULL AND a0_.dateout IS NULL AND a0_.id IN (2, 3, 1, 5, 4) ORDER BY a0_.name DESC;

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.amountnet AS amountnet_2,
  t0.billsid_id AS billsid_id_3,
  t0.articleid_id AS articleid_id_4
FROM
  billpositions t0
WHERE
  t0.articleid_id = ?

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = 2;

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.amountnet AS amountnet_2,
  t0.billsid_id AS billsid_id_3,
  t0.articleid_id AS articleid_id_4
FROM
  billpositions t0
WHERE
  t0.articleid_id = ?

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = 3;

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.amountnet AS amountnet_2,
  t0.billsid_id AS billsid_id_3,
  t0.articleid_id AS articleid_id_4
FROM
  billpositions t0
WHERE
  t0.articleid_id = ?

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = 1;

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.amountnet AS amountnet_2,
  t0.billsid_id AS billsid_id_3,
  t0.articleid_id AS articleid_id_4
FROM
  billpositions t0
WHERE
  t0.articleid_id = ?

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = 5;

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.amountnet AS amountnet_2,
  t0.billsid_id AS billsid_id_3,
  t0.articleid_id AS articleid_id_4
FROM
  billpositions t0
WHERE
  t0.articleid_id = ?

SELECT t0.id AS id_1, t0.amountnet AS amountnet_2, t0.billsid_id AS billsid_id_3, t0.articleid_id AS articleid_id_4 FROM billpositions t0 WHERE t0.articleid_id = 4;

SELECT t0.id AS id_1, t0.prename AS prename_2, t0.name AS name_3, t0.street AS street_4, t0.country AS country_5, t0.zip AS zip_6, t0.city AS city_7, t0.email AS email_8, t0.rate AS rate_9, t0.iban AS iban_10 FROM suppliers t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.prename AS prename_2,
  t0.name AS name_3,
  t0.street AS street_4,
  t0.country AS country_5,
  t0.zip AS zip_6,
  t0.city AS city_7,
  t0.email AS email_8,
  t0.rate AS rate_9,
  t0.iban AS iban_10
FROM
  suppliers t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.prename AS prename_2, t0.name AS name_3, t0.street AS street_4, t0.country AS country_5, t0.zip AS zip_6, t0.city AS city_7, t0.email AS email_8, t0.rate AS rate_9, t0.iban AS iban_10 FROM suppliers t0 WHERE t0.id = 1;