Symfony Profiler

SELECT
  b0_.transaction_date AS transaction_date_0,
  b0_.amount_ht AS amount_ht_1,
  b0_.amount AS amount_2,
  b0_.amount_tva AS amount_tva_3
FROM
  bank_transaction b0_
  LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id
WHERE
  b0_.company_id = ?
  AND b0_.transaction_type = ?
  AND (
    c1_.label NOT LIKE ?
    OR c1_.label IS NULL
  )
  AND (
    c1_.out_of_kpi = 0
    OR c1_.id IS NULL
  )
  AND b0_.fiscal_period_id = ?

SELECT b0_.transaction_date AS transaction_date_0, b0_.amount_ht AS amount_ht_1, b0_.amount AS amount_2, b0_.amount_tva AS amount_tva_3 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = 1 AND b0_.transaction_type = 'DEBIT' AND (c1_.label NOT LIKE '%TVA%' OR c1_.label IS NULL) AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = 1;

SELECT
  c0_.label AS label_0,
  SUM(
    COALESCE(b1_.amount_ht, b1_.amount)
  ) AS sclr_1
FROM
  bank_transaction b1_
  LEFT JOIN classify c0_ ON b1_.classify_id = c0_.id
WHERE
  b1_.company_id = ?
  AND b1_.transaction_type = ?
  AND (
    c0_.out_of_kpi = 0
    OR c0_.id IS NULL
  )
  AND b1_.fiscal_period_id = ?
GROUP BY
  c0_.label

SELECT c0_.label AS label_0, SUM(COALESCE(b1_.amount_ht, b1_.amount)) AS sclr_1 FROM bank_transaction b1_ LEFT JOIN classify c0_ ON b1_.classify_id = c0_.id WHERE b1_.company_id = 1 AND b1_.transaction_type = 'DEBIT' AND (c0_.out_of_kpi = 0 OR c0_.id IS NULL) AND b1_.fiscal_period_id = 1 GROUP BY c0_.label;

SELECT
  b0_.transaction_date AS transaction_date_0,
  b0_.amount_ht AS amount_ht_1,
  b0_.amount AS amount_2
FROM
  bank_transaction b0_
  LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id
WHERE
  b0_.company_id = ?
  AND b0_.transaction_type = ?
  AND (
    (
      c1_.label NOT LIKE ?
      AND c1_.label NOT LIKE ?
      AND c1_.label NOT LIKE ?
    )
    OR c1_.label IS NULL
  )
  AND (
    c1_.out_of_kpi = 0
    OR c1_.id IS NULL
  )
  AND b0_.fiscal_period_id = ?

SELECT b0_.transaction_date AS transaction_date_0, b0_.amount_ht AS amount_ht_1, b0_.amount AS amount_2 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = 1 AND b0_.transaction_type = 'DEBIT' AND ((c1_.label NOT LIKE '%Fournisseur%' AND c1_.label NOT LIKE '%TVA%' AND c1_.label NOT LIKE '%Porteur%') OR c1_.label IS NULL) AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = 1;

SELECT
  SUM(
    COALESCE(b0_.amount_ht, b0_.amount)
  ) AS sclr_0
FROM
  bank_transaction b0_
  LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id
WHERE
  b0_.company_id = ?
  AND b0_.transaction_type = ?
  AND (
    c1_.out_of_kpi = 0
    OR c1_.id IS NULL
  )
  AND (
    (
      c1_.label NOT LIKE ?
      AND c1_.label NOT LIKE ?
      AND c1_.label NOT LIKE ?
    )
    OR c1_.label IS NULL
  )
  AND b0_.fiscal_period_id = ?

SELECT SUM(COALESCE(b0_.amount_ht, b0_.amount)) AS sclr_0 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = 1 AND b0_.transaction_type = 'DEBIT' AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND ((c1_.label NOT LIKE '%Fournisseur%' AND c1_.label NOT LIKE '%TVA%' AND c1_.label NOT LIKE '%Porteur%') OR c1_.label IS NULL) AND b0_.fiscal_period_id = 1;

SELECT
  SUM(b0_.amount_tva) AS sclr_0
FROM
  bank_transaction b0_
  LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id
WHERE
  b0_.company_id = ?
  AND b0_.transaction_type = ?
  AND (
    c1_.label NOT LIKE ?
    OR c1_.label IS NULL
  )
  AND (
    c1_.out_of_kpi = 0
    OR c1_.id IS NULL
  )
  AND b0_.fiscal_period_id = ?

SELECT SUM(b0_.amount_tva) AS sclr_0 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = 1 AND b0_.transaction_type = 'DEBIT' AND (c1_.label NOT LIKE '%Fournisseur%' OR c1_.label IS NULL) AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = 1;

SELECT
  b0_.transaction_date AS transaction_date_0,
  b0_.amount_ht AS amount_ht_1,
  b0_.amount AS amount_2,
  b0_.amount_tva AS amount_tva_3
FROM
  bank_transaction b0_
  LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id
WHERE
  b0_.company_id = ?
  AND b0_.transaction_type = ?
  AND (
    c1_.out_of_kpi = 0
    OR c1_.id IS NULL
  )
  AND b0_.fiscal_period_id = ?

SELECT b0_.transaction_date AS transaction_date_0, b0_.amount_ht AS amount_ht_1, b0_.amount AS amount_2, b0_.amount_tva AS amount_tva_3 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = 1 AND b0_.transaction_type = 'CREDIT' AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = 1;

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
  u0_.full_name AS full_name_0,
  SUM(c1_.total_excl_tax) AS sclr_1
FROM
  consultant_invoice c1_
  INNER JOIN activity_report a2_ ON c1_.activity_report_id = a2_.id
  INNER JOIN user u0_ ON a2_.consultant_id = u0_.id
WHERE
  c1_.company_id = ?
  AND c1_.created_at >= ?
  AND c1_.created_at <= ?
GROUP BY
  u0_.full_name

SELECT u0_.full_name AS full_name_0, SUM(c1_.total_excl_tax) AS sclr_1 FROM consultant_invoice c1_ INNER JOIN activity_report a2_ ON c1_.activity_report_id = a2_.id INNER JOIN user u0_ ON a2_.consultant_id = u0_.id WHERE c1_.company_id = 1 AND c1_.created_at >= '2025-10-01 00:00:00' AND c1_.created_at <= '2026-09-30 00:00:00' GROUP BY u0_.full_name;

SELECT
  c0_.name AS name_0,
  SUM(i1_.total_ht) AS sclr_1
FROM
  invoice i1_
  INNER JOIN customer c0_ ON i1_.customer_id = c0_.id
WHERE
  i1_.company_id = ?
  AND i1_.creation_date >= ?
  AND i1_.creation_date <= ?
GROUP BY
  c0_.name

SELECT c0_.name AS name_0, SUM(i1_.total_ht) AS sclr_1 FROM invoice i1_ INNER JOIN customer c0_ ON i1_.customer_id = c0_.id WHERE i1_.company_id = 1 AND i1_.creation_date >= '2025-10-01 00:00:00' AND i1_.creation_date <= '2026-09-30 00:00:00' GROUP BY c0_.name;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_start AS date_start_3,
  t0.date_end AS date_end_4,
  t0.is_closed AS is_closed_5,
  t0.company_id AS company_id_6
FROM
  fiscal_period t0
WHERE
  t0.company_id = ?
ORDER BY
  t0.date_start DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.is_closed AS is_closed_5, t0.company_id AS company_id_6 FROM fiscal_period t0 WHERE t0.company_id = 1 ORDER BY t0.date_start DESC;

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
  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.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.company_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.company_id = 1;

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.company_id = ?
  AND u0_.last_login_at >= ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.company_id = 1 AND u0_.last_login_at >= '2026-07-14 00:00:00';

SELECT
  SUM(b0_.amount_ht) AS sclr_0
FROM
  bank_transaction b0_
  INNER JOIN classify c1_ ON b0_.classify_id = c1_.id
WHERE
  b0_.company_id = ?
  AND b0_.transaction_type = ?
  AND c1_.label = ?
  AND c1_.out_of_kpi = 0
  AND b0_.fiscal_period_id = ?

SELECT SUM(b0_.amount_ht) AS sclr_0 FROM bank_transaction b0_ INNER JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = 1 AND b0_.transaction_type = 'DEBIT' AND c1_.label = 'TVA' AND c1_.out_of_kpi = 0 AND b0_.fiscal_period_id = 1;

SELECT
  i0_.creation_date AS creation_date_0,
  i0_.total_ht AS total_ht_1
FROM
  invoice i0_
WHERE
  i0_.company_id = ?
  AND i0_.creation_date >= ?
  AND i0_.creation_date <= ?

SELECT i0_.creation_date AS creation_date_0, i0_.total_ht AS total_ht_1 FROM invoice i0_ WHERE i0_.company_id = 1 AND i0_.creation_date >= '2025-10-01 00:00:00' AND i0_.creation_date <= '2026-09-30 00:00:00';

SELECT
  s0_.creation_date AS creation_date_0,
  s0_.total_ht AS total_ht_1
FROM
  supplier_invoice s0_
WHERE
  s0_.company_id = ?
  AND s0_.creation_date >= ?
  AND s0_.creation_date <= ?

SELECT s0_.creation_date AS creation_date_0, s0_.total_ht AS total_ht_1 FROM supplier_invoice s0_ WHERE s0_.company_id = 1 AND s0_.creation_date >= '2025-10-01 00:00:00' AND s0_.creation_date <= '2026-09-30 00:00:00';

SELECT
  c0_.created_at AS created_at_0,
  c0_.total_excl_tax AS total_excl_tax_1
FROM
  consultant_invoice c0_
WHERE
  c0_.company_id = ?
  AND c0_.created_at >= ?
  AND c0_.created_at <= ?

SELECT c0_.created_at AS created_at_0, c0_.total_excl_tax AS total_excl_tax_1 FROM consultant_invoice c0_ WHERE c0_.company_id = 1 AND c0_.created_at >= '2025-10-01 00:00:00' AND c0_.created_at <= '2026-09-30 00:00:00';

SELECT
  SUM(i0_.tva) AS sclr_0
FROM
  invoice i0_
WHERE
  i0_.company_id = ?
  AND i0_.creation_date >= ?
  AND i0_.creation_date <= ?

SELECT SUM(i0_.tva) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = 1 AND i0_.creation_date >= '2025-10-01 00:00:00' AND i0_.creation_date <= '2026-09-30 00:00:00';

SELECT
  a0_.id AS id_0,
  a0_.days AS days_1,
  a0_.date AS date_2,
  a0_.created_at AS created_at_3,
  a0_.pdf AS pdf_4,
  a0_.invoice_pdf AS invoice_pdf_5,
  a0_.holidays AS holidays_6,
  a0_.validated AS validated_7,
  a0_.invoiced AS invoiced_8,
  a0_.is_package AS is_package_9,
  a0_.company_id AS company_id_10,
  a0_.consultant_id AS consultant_id_11,
  a0_.purchase_order_id AS purchase_order_id_12
FROM
  activity_report a0_
WHERE
  a0_.company_id = ?
  AND a0_.date >= ?
  AND a0_.date <= ?

SELECT a0_.id AS id_0, a0_.days AS days_1, a0_.date AS date_2, a0_.created_at AS created_at_3, a0_.pdf AS pdf_4, a0_.invoice_pdf AS invoice_pdf_5, a0_.holidays AS holidays_6, a0_.validated AS validated_7, a0_.invoiced AS invoiced_8, a0_.is_package AS is_package_9, a0_.company_id AS company_id_10, a0_.consultant_id AS consultant_id_11, a0_.purchase_order_id AS purchase_order_id_12 FROM activity_report a0_ WHERE a0_.company_id = 1 AND a0_.date >= '2026-07-01 00:00:00' AND a0_.date <= '2026-07-31 00:00:00';

SELECT
  SUM(s0_.total_ht) AS sclr_0
FROM
  supplier_invoice s0_
WHERE
  s0_.company_id = ?
  AND s0_.creation_date >= ?
  AND s0_.creation_date <= ?

SELECT SUM(s0_.total_ht) AS sclr_0 FROM supplier_invoice s0_ WHERE s0_.company_id = 1 AND s0_.creation_date >= '2025-10-01 00:00:00' AND s0_.creation_date <= '2026-09-30 00:00:00';

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
  SUM(c0_.vat_amount) AS sclr_0
FROM
  consultant_invoice c0_
WHERE
  c0_.company_id = ?
  AND c0_.created_at >= ?
  AND c0_.created_at <= ?

SELECT SUM(c0_.vat_amount) AS sclr_0 FROM consultant_invoice c0_ WHERE c0_.company_id = 1 AND c0_.created_at >= '2025-10-01 00:00:00' AND c0_.created_at <= '2026-09-30 00:00:00';