Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.siret AS siret_7, t0.tva AS tva_8, t0.price_precision AS price_precision_9, t0.company_id AS company_id_10, t0.currency_id AS currency_id_11 FROM customer t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.siret AS siret_7,
  t0.tva AS tva_8,
  t0.price_precision AS price_precision_9,
  t0.company_id AS company_id_10,
  t0.currency_id AS currency_id_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.siret AS siret_7, t0.tva AS tva_8, t0.price_precision AS price_precision_9, t0.company_id AS company_id_10, t0.currency_id AS currency_id_11 FROM customer t0 WHERE t0.id = 1;

SELECT DISTINCT i0_.id AS id_0, i0_.creation_date AS creation_date_1 FROM invoice i0_ WHERE i0_.company_id = ? ORDER BY i0_.creation_date DESC LIMIT 20

[
  1
]

SELECT
  DISTINCT i0_.id AS id_0,
  i0_.creation_date AS creation_date_1
FROM
  invoice i0_
WHERE
  i0_.company_id = ?
ORDER BY
  i0_.creation_date DESC
LIMIT
  20

SELECT DISTINCT i0_.id AS id_0, i0_.creation_date AS creation_date_1 FROM invoice i0_ WHERE i0_.company_id = 1 ORDER BY i0_.creation_date DESC LIMIT 20;

SELECT SUM(i0_.total_ht) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?

[
  1
]

SELECT
  SUM(i0_.total_ht) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.company_id = ?

SELECT SUM(i0_.total_ht) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = 1;

SELECT i0_.id AS id_0, i0_.code AS code_1, i0_.paid AS paid_2, i0_.creation_date AS creation_date_3, i0_.due_date AS due_date_4, i0_.total_ht AS total_ht_5, i0_.mail_sent AS mail_sent_6, i0_.total_ttc AS total_ttc_7, i0_.tva AS tva_8, i0_.relance AS relance_9, i0_.timbre AS timbre_10, i0_.status AS status_11, i0_.company_id AS company_id_12, i0_.customer_id AS customer_id_13 FROM invoice i0_ WHERE i0_.company_id = ? AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.creation_date DESC

[
  1
  161
  124
  102
  103
  101
  100
  99
  98
  95
  96
  97
  92
  93
  94
  90
  91
]

SELECT
  i0_.id AS id_0,
  i0_.code AS code_1,
  i0_.paid AS paid_2,
  i0_.creation_date AS creation_date_3,
  i0_.due_date AS due_date_4,
  i0_.total_ht AS total_ht_5,
  i0_.mail_sent AS mail_sent_6,
  i0_.total_ttc AS total_ttc_7,
  i0_.tva AS tva_8,
  i0_.relance AS relance_9,
  i0_.timbre AS timbre_10,
  i0_.status AS status_11,
  i0_.company_id AS company_id_12,
  i0_.customer_id AS customer_id_13
FROM
  invoice i0_
WHERE
  i0_.company_id = ?
  AND i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  i0_.creation_date DESC

SELECT i0_.id AS id_0, i0_.code AS code_1, i0_.paid AS paid_2, i0_.creation_date AS creation_date_3, i0_.due_date AS due_date_4, i0_.total_ht AS total_ht_5, i0_.mail_sent AS mail_sent_6, i0_.total_ttc AS total_ttc_7, i0_.tva AS tva_8, i0_.relance AS relance_9, i0_.timbre AS timbre_10, i0_.status AS status_11, i0_.company_id AS company_id_12, i0_.customer_id AS customer_id_13 FROM invoice i0_ WHERE i0_.company_id = 1 AND i0_.id IN (161, 124, 102, 103, 101, 100, 99, 98, 95, 96, 97, 92, 93, 94, 90, 91) ORDER BY i0_.creation_date DESC;

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4 FROM currency t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.symbol AS symbol_4
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4 FROM currency t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.bio AS bio_7, t0.website AS website_8, t0.twitter_handle AS twitter_handle_9, t0.is_verified AS is_verified_10, t0.enabled AS enabled_11, t0.last_login_at AS last_login_at_12, t0.avatar AS avatar_13, t0.company_id AS company_id_14 FROM user t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.bio AS bio_7,
  t0.website AS website_8,
  t0.twitter_handle AS twitter_handle_9,
  t0.is_verified AS is_verified_10,
  t0.enabled AS enabled_11,
  t0.last_login_at AS last_login_at_12,
  t0.avatar AS avatar_13,
  t0.company_id AS company_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.bio AS bio_7, t0.website AS website_8, t0.twitter_handle AS twitter_handle_9, t0.is_verified AS is_verified_10, t0.enabled AS enabled_11, t0.last_login_at AS last_login_at_12, t0.avatar AS avatar_13, t0.company_id AS company_id_14 FROM user t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.company_id AS company_id_4 FROM user_group t0 INNER JOIN user_user_group ON t0.id = user_user_group.user_group_id WHERE user_user_group.user_id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.roles AS roles_3,
  t0.company_id AS company_id_4
FROM
  user_group t0
  INNER JOIN user_user_group ON t0.id = user_user_group.user_group_id
WHERE
  user_user_group.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.company_id AS company_id_4 FROM user_group t0 INNER JOIN user_user_group ON t0.id = user_user_group.user_group_id WHERE user_user_group.user_id = 2;

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.logo AS logo_4, t0.address AS address_5, t0.capital AS capital_6, t0.website AS website_7, t0.email AS email_8, t0.phone AS phone_9, t0.siret AS siret_10, t0.tva AS tva_11, t0.rcs AS rcs_12, t0.price_precision AS price_precision_13, t0.loi_pdf AS loi_pdf_14, t0.footer_pdf AS footer_pdf_15, t0.favicon AS favicon_16, t0.smtp_host AS smtp_host_17, t0.smtp_port AS smtp_port_18, t0.smtp_user AS smtp_user_19, t0.smtp_password AS smtp_password_20, t0.smtp_sender_email AS smtp_sender_email_21, t0.smtp_sender_name AS smtp_sender_name_22, t0.smtp_encryption AS smtp_encryption_23, t0.country_code AS country_code_24, t0.invoice_start_number AS invoice_start_number_25, t0.cra_email_template AS cra_email_template_26, t0.email_header AS email_header_27, t0.email_footer AS email_footer_28, t0.legal_form_id AS legal_form_id_29, t0.currency_id AS currency_id_30, t0.cachet AS cachet_31 FROM company t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.logo AS logo_4,
  t0.address AS address_5,
  t0.capital AS capital_6,
  t0.website AS website_7,
  t0.email AS email_8,
  t0.phone AS phone_9,
  t0.siret AS siret_10,
  t0.tva AS tva_11,
  t0.rcs AS rcs_12,
  t0.price_precision AS price_precision_13,
  t0.loi_pdf AS loi_pdf_14,
  t0.footer_pdf AS footer_pdf_15,
  t0.favicon AS favicon_16,
  t0.smtp_host AS smtp_host_17,
  t0.smtp_port AS smtp_port_18,
  t0.smtp_user AS smtp_user_19,
  t0.smtp_password AS smtp_password_20,
  t0.smtp_sender_email AS smtp_sender_email_21,
  t0.smtp_sender_name AS smtp_sender_name_22,
  t0.smtp_encryption AS smtp_encryption_23,
  t0.country_code AS country_code_24,
  t0.invoice_start_number AS invoice_start_number_25,
  t0.cra_email_template AS cra_email_template_26,
  t0.email_header AS email_header_27,
  t0.email_footer AS email_footer_28,
  t0.legal_form_id AS legal_form_id_29,
  t0.currency_id AS currency_id_30,
  t0.cachet AS cachet_31
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.logo AS logo_4, t0.address AS address_5, t0.capital AS capital_6, t0.website AS website_7, t0.email AS email_8, t0.phone AS phone_9, t0.siret AS siret_10, t0.tva AS tva_11, t0.rcs AS rcs_12, t0.price_precision AS price_precision_13, t0.loi_pdf AS loi_pdf_14, t0.footer_pdf AS footer_pdf_15, t0.favicon AS favicon_16, t0.smtp_host AS smtp_host_17, t0.smtp_port AS smtp_port_18, t0.smtp_user AS smtp_user_19, t0.smtp_password AS smtp_password_20, t0.smtp_sender_email AS smtp_sender_email_21, t0.smtp_sender_name AS smtp_sender_name_22, t0.smtp_encryption AS smtp_encryption_23, t0.country_code AS country_code_24, t0.invoice_start_number AS invoice_start_number_25, t0.cra_email_template AS cra_email_template_26, t0.email_header AS email_header_27, t0.email_footer AS email_footer_28, t0.legal_form_id AS legal_form_id_29, t0.currency_id AS currency_id_30, t0.cachet AS cachet_31 FROM company t0 WHERE t0.id = 1;

SELECT SUM(i0_.total_ttc) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?

[
  1
]

SELECT
  SUM(i0_.total_ttc) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.company_id = ?

SELECT SUM(i0_.total_ttc) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = 1;

SELECT SUM(i0_.tva) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?

[
  1
]

SELECT
  SUM(i0_.tva) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.company_id = ?

SELECT SUM(i0_.tva) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = 1;

SELECT SUM(i0_.timbre) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?

[
  1
]

SELECT
  SUM(i0_.timbre) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.company_id = ?

SELECT SUM(i0_.timbre) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = 1;

SELECT count(*) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?

[
  1
]

SELECT
  count(*) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.company_id = ?

SELECT count(*) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = 1;