Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.sales_condition_text AS sales_condition_text_2,
  t0.clientstring AS clientstring_3,
  t0.tax AS tax_4,
  t0.street AS street_5,
  t0.housenumber AS housenumber_6,
  t0.postcode AS postcode_7,
  t0.municipality AS municipality_8,
  t0.process_state AS process_state_9,
  t0.total_amount AS total_amount_10,
  t0.total_tax_amount AS total_tax_amount_11,
  t0.total_with_tax_amount AS total_with_tax_amount_12,
  t0.invoice_date AS invoice_date_13,
  t0.due_date AS due_date_14,
  t0.invoice_number AS invoice_number_15,
  t0.about AS about_16,
  t0.note AS note_17,
  t0.ubl_mail_to_accountant_needed AS ubl_mail_to_accountant_needed_18,
  t0.contract_number AS contract_number_19,
  t0.attachment_number AS attachment_number_20,
  t0.marginowner AS marginowner_21,
  t0.secondarymarginowner AS secondarymarginowner_22,
  t0.unit_price AS unit_price_23,
  t0.intake_rate AS intake_rate_24,
  t0.working_days_per_week AS working_days_per_week_25,
  t0.external_reference AS external_reference_26,
  t0.external_update_needed AS external_update_needed_27,
  t0.external_info_needed AS external_info_needed_28,
  t0.send_peppol_needed AS send_peppol_needed_29,
  t0.peppol_status AS peppol_status_30,
  t0.peppol_description AS peppol_description_31,
  t0.peppol_latest_update AS peppol_latest_update_32,
  t0.structured_message_for_bank_transfer AS structured_message_for_bank_transfer_33,
  t0.state AS state_34,
  t0.created AS created_35,
  t0.updated AS updated_36,
  t0.organization_id AS organization_id_37,
  t0.client_id AS client_id_38,
  t0.sales_condition_id AS sales_condition_id_39,
  t0.language_id AS language_id_40,
  t0.currency_id AS currency_id_41,
  t0.pdf_id AS pdf_id_42,
  t0.ubl_id AS ubl_id_43,
  t0.contract_id AS contract_id_44,
  t0.accounttransaction_id AS accounttransaction_id_45,
  t0.profit_calculation_method_id AS profit_calculation_method_id_46,
  t0.created_by AS created_by_47,
  t0.updated_by AS updated_by_48
FROM
  invoice t0
WHERE
  t0.accounttransaction_id = ?

SELECT t0.id AS id_1, t0.sales_condition_text AS sales_condition_text_2, t0.clientstring AS clientstring_3, t0.tax AS tax_4, t0.street AS street_5, t0.housenumber AS housenumber_6, t0.postcode AS postcode_7, t0.municipality AS municipality_8, t0.process_state AS process_state_9, t0.total_amount AS total_amount_10, t0.total_tax_amount AS total_tax_amount_11, t0.total_with_tax_amount AS total_with_tax_amount_12, t0.invoice_date AS invoice_date_13, t0.due_date AS due_date_14, t0.invoice_number AS invoice_number_15, t0.about AS about_16, t0.note AS note_17, t0.ubl_mail_to_accountant_needed AS ubl_mail_to_accountant_needed_18, t0.contract_number AS contract_number_19, t0.attachment_number AS attachment_number_20, t0.marginowner AS marginowner_21, t0.secondarymarginowner AS secondarymarginowner_22, t0.unit_price AS unit_price_23, t0.intake_rate AS intake_rate_24, t0.working_days_per_week AS working_days_per_week_25, t0.external_reference AS external_reference_26, t0.external_update_needed AS external_update_needed_27, t0.external_info_needed AS external_info_needed_28, t0.send_peppol_needed AS send_peppol_needed_29, t0.peppol_status AS peppol_status_30, t0.peppol_description AS peppol_description_31, t0.peppol_latest_update AS peppol_latest_update_32, t0.structured_message_for_bank_transfer AS structured_message_for_bank_transfer_33, t0.state AS state_34, t0.created AS created_35, t0.updated AS updated_36, t0.organization_id AS organization_id_37, t0.client_id AS client_id_38, t0.sales_condition_id AS sales_condition_id_39, t0.language_id AS language_id_40, t0.currency_id AS currency_id_41, t0.pdf_id AS pdf_id_42, t0.ubl_id AS ubl_id_43, t0.contract_id AS contract_id_44, t0.accounttransaction_id AS accounttransaction_id_45, t0.profit_calculation_method_id AS profit_calculation_method_id_46, t0.created_by AS created_by_47, t0.updated_by AS updated_by_48 FROM invoice t0 WHERE t0.accounttransaction_id = 323;

SELECT
  t0.id AS id_1,
  t0.sales_condition_text AS sales_condition_text_2,
  t0.clientstring AS clientstring_3,
  t0.tax AS tax_4,
  t0.street AS street_5,
  t0.housenumber AS housenumber_6,
  t0.postcode AS postcode_7,
  t0.municipality AS municipality_8,
  t0.process_state AS process_state_9,
  t0.total_amount AS total_amount_10,
  t0.total_tax_amount AS total_tax_amount_11,
  t0.total_with_tax_amount AS total_with_tax_amount_12,
  t0.credit_note_date AS credit_note_date_13,
  t0.credit_note_number AS credit_note_number_14,
  t0.about AS about_15,
  t0.note AS note_16,
  t0.ubl_mail_to_accountant_needed AS ubl_mail_to_accountant_needed_17,
  t0.contract_number AS contract_number_18,
  t0.attachment_number AS attachment_number_19,
  t0.marginowner AS marginowner_20,
  t0.secondarymarginowner AS secondarymarginowner_21,
  t0.state AS state_22,
  t0.created AS created_23,
  t0.updated AS updated_24,
  t0.organization_id AS organization_id_25,
  t0.client_id AS client_id_26,
  t0.invoice_id AS invoice_id_27,
  t0.sales_condition_id AS sales_condition_id_28,
  t0.language_id AS language_id_29,
  t0.currency_id AS currency_id_30,
  t0.pdf_id AS pdf_id_31,
  t0.ubl_id AS ubl_id_32,
  t0.contract_id AS contract_id_33,
  t0.accounttransaction_id AS accounttransaction_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  credit_note t0
WHERE
  t0.invoice_id = ?

SELECT t0.id AS id_1, t0.sales_condition_text AS sales_condition_text_2, t0.clientstring AS clientstring_3, t0.tax AS tax_4, t0.street AS street_5, t0.housenumber AS housenumber_6, t0.postcode AS postcode_7, t0.municipality AS municipality_8, t0.process_state AS process_state_9, t0.total_amount AS total_amount_10, t0.total_tax_amount AS total_tax_amount_11, t0.total_with_tax_amount AS total_with_tax_amount_12, t0.credit_note_date AS credit_note_date_13, t0.credit_note_number AS credit_note_number_14, t0.about AS about_15, t0.note AS note_16, t0.ubl_mail_to_accountant_needed AS ubl_mail_to_accountant_needed_17, t0.contract_number AS contract_number_18, t0.attachment_number AS attachment_number_19, t0.marginowner AS marginowner_20, t0.secondarymarginowner AS secondarymarginowner_21, t0.state AS state_22, t0.created AS created_23, t0.updated AS updated_24, t0.organization_id AS organization_id_25, t0.client_id AS client_id_26, t0.invoice_id AS invoice_id_27, t0.sales_condition_id AS sales_condition_id_28, t0.language_id AS language_id_29, t0.currency_id AS currency_id_30, t0.pdf_id AS pdf_id_31, t0.ubl_id AS ubl_id_32, t0.contract_id AS contract_id_33, t0.accounttransaction_id AS accounttransaction_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM credit_note t0 WHERE t0.invoice_id = 2;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  employee e0_
WHERE
  (e0_.state = 0)
  AND (e0_.available_on < ?)

SELECT COUNT(e0_.id) AS sclr_0 FROM employee e0_ WHERE (e0_.state = 0) AND (e0_.available_on < '2026-09-22');

SELECT
  t0.id AS id_1,
  t0.transaction_date AS transaction_date_2,
  t0.valuta_date AS valuta_date_3,
  t0.amount AS amount_4,
  t0.client_name AS client_name_5,
  t0.client_iban AS client_iban_6,
  t0.client_bic AS client_bic_7,
  t0.message AS message_8,
  t0.structured_message AS structured_message_9,
  t0.description AS description_10,
  t0.accept_unmatched_amount AS accept_unmatched_amount_11,
  t0.state AS state_12,
  t0.created AS created_13,
  t0.updated AS updated_14,
  t0.account_id AS account_id_15,
  t0.client_id AS client_id_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18
FROM
  account_transaction t0
WHERE
  t0.state = ?
  AND t0.account_id = ?

SELECT t0.id AS id_1, t0.transaction_date AS transaction_date_2, t0.valuta_date AS valuta_date_3, t0.amount AS amount_4, t0.client_name AS client_name_5, t0.client_iban AS client_iban_6, t0.client_bic AS client_bic_7, t0.message AS message_8, t0.structured_message AS structured_message_9, t0.description AS description_10, t0.accept_unmatched_amount AS accept_unmatched_amount_11, t0.state AS state_12, t0.created AS created_13, t0.updated AS updated_14, t0.account_id AS account_id_15, t0.client_id AS client_id_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM account_transaction t0 WHERE t0.state = 0 AND t0.account_id = 1;

SELECT
  a0_.id AS id_0,
  a0_.transaction_date AS transaction_date_1,
  a0_.valuta_date AS valuta_date_2,
  a0_.amount AS amount_3,
  a0_.client_name AS client_name_4,
  a0_.client_iban AS client_iban_5,
  a0_.client_bic AS client_bic_6,
  a0_.message AS message_7,
  a0_.structured_message AS structured_message_8,
  a0_.description AS description_9,
  a0_.accept_unmatched_amount AS accept_unmatched_amount_10,
  a0_.state AS state_11,
  a0_.created AS created_12,
  a0_.updated AS updated_13,
  a0_.account_id AS account_id_14,
  a0_.client_id AS client_id_15,
  a0_.created_by AS created_by_16,
  a0_.updated_by AS updated_by_17
FROM
  account_transaction a0_
WHERE
  (
    (a0_.state = 0)
    AND (a0_.account_id = ?)
  )
ORDER BY
  a0_.transaction_date DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.transaction_date AS transaction_date_1, a0_.valuta_date AS valuta_date_2, a0_.amount AS amount_3, a0_.client_name AS client_name_4, a0_.client_iban AS client_iban_5, a0_.client_bic AS client_bic_6, a0_.message AS message_7, a0_.structured_message AS structured_message_8, a0_.description AS description_9, a0_.accept_unmatched_amount AS accept_unmatched_amount_10, a0_.state AS state_11, a0_.created AS created_12, a0_.updated AS updated_13, a0_.account_id AS account_id_14, a0_.client_id AS client_id_15, a0_.created_by AS created_by_16, a0_.updated_by AS updated_by_17 FROM account_transaction a0_ WHERE ((a0_.state = 0) AND (a0_.account_id = 1)) ORDER BY a0_.transaction_date DESC LIMIT 1;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  employee e0_
WHERE
  (e0_.state = 0)

SELECT COUNT(e0_.id) AS sclr_0 FROM employee e0_ WHERE (e0_.state = 0);

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  employee e0_
WHERE
  (e0_.state = 0)
  AND e0_.start_date <= ?
  AND (
    e0_.end_date >= ?
    OR e0_.end_date IS NULL
  )

SELECT COUNT(e0_.id) AS sclr_0 FROM employee e0_ WHERE (e0_.state = 0) AND e0_.start_date <= '2026-09-21' AND (e0_.end_date >= '2026-09-21' OR e0_.end_date IS NULL);

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  employee e0_
WHERE
  (e0_.state = 0)
  AND (e0_.available_on < ?)
  AND e0_.hot_profile = 1

SELECT COUNT(e0_.id) AS sclr_0 FROM employee e0_ WHERE (e0_.state = 0) AND (e0_.available_on < '2026-09-22') AND e0_.hot_profile = 1;

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  invoice i0_
WHERE
  (i0_.state = 0)
  AND (i0_.process_state = ?)

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ WHERE (i0_.state = 0) AND (i0_.process_state = 0);

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  employee e0_
WHERE
  (e0_.state = 0)
  AND e0_.hot_profile = 1

SELECT COUNT(e0_.id) AS sclr_0 FROM employee e0_ WHERE (e0_.state = 0) AND e0_.hot_profile = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.list1 AS list1_3,
  t0.list2 AS list2_4,
  t0.list3 AS list3_5,
  t0.boolean1 AS boolean1_6,
  t0.boolean2 AS boolean2_7,
  t0.boolean3 AS boolean3_8,
  t0.integer1 AS integer1_9,
  t0.integer2 AS integer2_10,
  t0.integer3 AS integer3_11,
  t0.float1 AS float1_12,
  t0.float2 AS float2_13,
  t0.float3 AS float3_14,
  t0.string1 AS string1_15,
  t0.string2 AS string2_16,
  t0.string3 AS string3_17,
  t0.state AS state_18,
  t0.created AS created_19,
  t0.updated AS updated_20,
  t0.type_id AS type_id_21,
  t0.list1_list_id AS list1_list_id_22,
  t0.list2_list_id AS list2_list_id_23,
  t0.list3_list_id AS list3_list_id_24,
  t0.created_by AS created_by_25,
  t0.updated_by AS updated_by_26
FROM
  widget t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.list1 AS list1_3, t0.list2 AS list2_4, t0.list3 AS list3_5, t0.boolean1 AS boolean1_6, t0.boolean2 AS boolean2_7, t0.boolean3 AS boolean3_8, t0.integer1 AS integer1_9, t0.integer2 AS integer2_10, t0.integer3 AS integer3_11, t0.float1 AS float1_12, t0.float2 AS float2_13, t0.float3 AS float3_14, t0.string1 AS string1_15, t0.string2 AS string2_16, t0.string3 AS string3_17, t0.state AS state_18, t0.created AS created_19, t0.updated AS updated_20, t0.type_id AS type_id_21, t0.list1_list_id AS list1_list_id_22, t0.list2_list_id AS list2_list_id_23, t0.list3_list_id AS list3_list_id_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM widget t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.boolean1 AS boolean1_3,
  t0.boolean2 AS boolean2_4,
  t0.boolean3 AS boolean3_5,
  t0.integer1 AS integer1_6,
  t0.integer2 AS integer2_7,
  t0.integer3 AS integer3_8,
  t0.float1 AS float1_9,
  t0.float2 AS float2_10,
  t0.float3 AS float3_11,
  t0.string1 AS string1_12,
  t0.string2 AS string2_13,
  t0.string3 AS string3_14,
  t0.state AS state_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.pagerowcolumn_id AS pagerowcolumn_id_18,
  t0.widget_id AS widget_id_19,
  t0.list1_id AS list1_id_20,
  t0.list2_id AS list2_id_21,
  t0.list3_id AS list3_id_22,
  t0.created_by AS created_by_23,
  t0.updated_by AS updated_by_24
FROM
  page_row_column_widget t0
WHERE
  t0.pagerowcolumn_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.boolean1 AS boolean1_3, t0.boolean2 AS boolean2_4, t0.boolean3 AS boolean3_5, t0.integer1 AS integer1_6, t0.integer2 AS integer2_7, t0.integer3 AS integer3_8, t0.float1 AS float1_9, t0.float2 AS float2_10, t0.float3 AS float3_11, t0.string1 AS string1_12, t0.string2 AS string2_13, t0.string3 AS string3_14, t0.state AS state_15, t0.created AS created_16, t0.updated AS updated_17, t0.pagerowcolumn_id AS pagerowcolumn_id_18, t0.widget_id AS widget_id_19, t0.list1_id AS list1_id_20, t0.list2_id AS list2_id_21, t0.list3_id AS list3_id_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24 FROM page_row_column_widget t0 WHERE t0.pagerowcolumn_id = 3;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  account_transaction a0_
WHERE
  (
    (a0_.state = 0)
    AND (a0_.account_id = ?)
  )
  AND a0_.transaction_date >= ?

SELECT COUNT(a0_.id) AS sclr_0 FROM account_transaction a0_ WHERE ((a0_.state = 0) AND (a0_.account_id = 1)) AND a0_.transaction_date >= '2026-09-14';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.class AS class_4,
  t0.state AS state_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.screenconfigurationpage_id AS screenconfigurationpage_id_8,
  t0.pagerowcolumn_id AS pagerowcolumn_id_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11
FROM
  page_row t0
WHERE
  t0.pagerowcolumn_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.class AS class_4, t0.state AS state_5, t0.created AS created_6, t0.updated AS updated_7, t0.screenconfigurationpage_id AS screenconfigurationpage_id_8, t0.pagerowcolumn_id AS pagerowcolumn_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM page_row t0 WHERE t0.pagerowcolumn_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.boolean1 AS boolean1_3,
  t0.boolean2 AS boolean2_4,
  t0.integer1 AS integer1_5,
  t0.integer2 AS integer2_6,
  t0.float1 AS float1_7,
  t0.float2 AS float2_8,
  t0.string1 AS string1_9,
  t0.string2 AS string2_10,
  t0.text1 AS text1_11,
  t0.text2 AS text2_12,
  t0.state AS state_13,
  t0.created AS created_14,
  t0.updated AS updated_15,
  t0.list1_id AS list1_id_16,
  t0.list2_id AS list2_id_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19,
  t0.organization_id AS organization_id_20,
  t0.configurablelist_id AS configurablelist_id_21
FROM
  list_item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.boolean1 AS boolean1_3, t0.boolean2 AS boolean2_4, t0.integer1 AS integer1_5, t0.integer2 AS integer2_6, t0.float1 AS float1_7, t0.float2 AS float2_8, t0.string1 AS string1_9, t0.string2 AS string2_10, t0.text1 AS text1_11, t0.text2 AS text2_12, t0.state AS state_13, t0.created AS created_14, t0.updated AS updated_15, t0.list1_id AS list1_id_16, t0.list2_id AS list2_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.organization_id AS organization_id_20, t0.configurablelist_id AS configurablelist_id_21 FROM list_item t0 WHERE t0.id = 4;

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  invoice i0_
  LEFT JOIN client c1_ ON i0_.client_id = c1_.id
WHERE
  (
    (i0_.state = 0)
    AND (c1_.contact_by_email = 1)
  )
  AND i0_.process_state = 0

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ LEFT JOIN client c1_ ON i0_.client_id = c1_.id WHERE ((i0_.state = 0) AND (c1_.contact_by_email = 1)) AND i0_.process_state = 0;

SELECT
  u0_.first_name AS first_name_0,
  u0_.id AS id_1,
  COUNT(p1_.id) AS sclr_2
FROM
  proposal p1_
  INNER JOIN user u0_ ON p1_.owner_id = u0_.id
WHERE
  (p1_.state = 0)
  AND p1_.open = ?
  AND p1_.state = 0
GROUP BY
  u0_.id,
  u0_.uuid,
  u0_.email,
  u0_.first_name,
  u0_.last_name,
  u0_.phone,
  u0_.type,
  u0_.last_login,
  u0_.failed_login_attempts,
  u0_.enabled,
  u0_.locked,
  u0_.roles,
  u0_.password,
  u0_.state,
  u0_.created,
  u0_.updated,
  u0_.picture_id,
  u0_.userfunction_id,
  u0_.timezone_id,
  u0_.locale_id,
  u0_.employee_id,
  u0_.organization_id,
  u0_.created_by,
  u0_.updated_by

SELECT u0_.first_name AS first_name_0, u0_.id AS id_1, COUNT(p1_.id) AS sclr_2 FROM proposal p1_ INNER JOIN user u0_ ON p1_.owner_id = u0_.id WHERE (p1_.state = 0) AND p1_.open = 1 AND p1_.state = 0 GROUP BY u0_.id, u0_.uuid, u0_.email, u0_.first_name, u0_.last_name, u0_.phone, u0_.type, u0_.last_login, u0_.failed_login_attempts, u0_.enabled, u0_.locked, u0_.roles, u0_.password, u0_.state, u0_.created, u0_.updated, u0_.picture_id, u0_.userfunction_id, u0_.timezone_id, u0_.locale_id, u0_.employee_id, u0_.organization_id, u0_.created_by, u0_.updated_by;

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  invoice i0_
WHERE
  (i0_.state = 0)
  AND (i0_.invoice_date >= ?)
  AND (i0_.invoice_date <= ?)

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ WHERE (i0_.state = 0) AND (i0_.invoice_date >= '2026-08-01') AND (i0_.invoice_date <= '2026-08-31');

SELECT
  u0_.first_name AS first_name_0,
  u0_.id AS id_1,
  COUNT(l1_.id) AS sclr_2
FROM
  lead l1_
  INNER JOIN user u0_ ON l1_.owner_id = u0_.id
WHERE
  (l1_.state = 0)
  AND l1_.open = ?
  AND l1_.state = 0
GROUP BY
  u0_.id,
  u0_.uuid,
  u0_.email,
  u0_.first_name,
  u0_.last_name,
  u0_.phone,
  u0_.type,
  u0_.last_login,
  u0_.failed_login_attempts,
  u0_.enabled,
  u0_.locked,
  u0_.roles,
  u0_.password,
  u0_.state,
  u0_.created,
  u0_.updated,
  u0_.picture_id,
  u0_.userfunction_id,
  u0_.timezone_id,
  u0_.locale_id,
  u0_.employee_id,
  u0_.organization_id,
  u0_.created_by,
  u0_.updated_by

SELECT u0_.first_name AS first_name_0, u0_.id AS id_1, COUNT(l1_.id) AS sclr_2 FROM lead l1_ INNER JOIN user u0_ ON l1_.owner_id = u0_.id WHERE (l1_.state = 0) AND l1_.open = 1 AND l1_.state = 0 GROUP BY u0_.id, u0_.uuid, u0_.email, u0_.first_name, u0_.last_name, u0_.phone, u0_.type, u0_.last_login, u0_.failed_login_attempts, u0_.enabled, u0_.locked, u0_.roles, u0_.password, u0_.state, u0_.created, u0_.updated, u0_.picture_id, u0_.userfunction_id, u0_.timezone_id, u0_.locale_id, u0_.employee_id, u0_.organization_id, u0_.created_by, u0_.updated_by;

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  invoice i0_
WHERE
  (i0_.state = 0)
  AND (
    (
      (i0_.due_date IS NOT NULL)
      AND (i0_.due_date < ?)
    )
    AND i0_.process_state <> 2
  )

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ WHERE (i0_.state = 0) AND (((i0_.due_date IS NOT NULL) AND (i0_.due_date < '2026-09-21 20:34:19')) AND i0_.process_state <> 2);

SELECT
  t0.id AS id_1,
  t0.entity AS entity_2,
  t0.action AS action_3,
  t0.path AS path_4,
  t0.logging AS logging_5,
  t0.found_during_last_run AS found_during_last_run_6,
  t0.execution_action AS execution_action_7,
  t0.state AS state_8,
  t0.created AS created_9,
  t0.updated AS updated_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12
FROM
  security_action t0
WHERE
  t0.entity = ?
  AND t0.action = ?
  AND t0.state = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.path AS path_4, t0.logging AS logging_5, t0.found_during_last_run AS found_during_last_run_6, t0.execution_action AS execution_action_7, t0.state AS state_8, t0.created AS created_9, t0.updated AS updated_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM security_action t0 WHERE t0.entity = 'User' AND t0.action = 'home' AND t0.state = 0 LIMIT 1;

SELECT
  u0_.first_name AS first_name_0,
  u0_.id AS id_1,
  COUNT(p1_.id) AS sclr_2
FROM
  proposal p1_
  INNER JOIN user u0_ ON p1_.owner_id = u0_.id
WHERE
  (p1_.state = 0)
  AND (
    p1_.open = ?
    AND p1_.interview = ?
  )
  AND p1_.state = 0
GROUP BY
  u0_.id,
  u0_.uuid,
  u0_.email,
  u0_.first_name,
  u0_.last_name,
  u0_.phone,
  u0_.type,
  u0_.last_login,
  u0_.failed_login_attempts,
  u0_.enabled,
  u0_.locked,
  u0_.roles,
  u0_.password,
  u0_.state,
  u0_.created,
  u0_.updated,
  u0_.picture_id,
  u0_.userfunction_id,
  u0_.timezone_id,
  u0_.locale_id,
  u0_.employee_id,
  u0_.organization_id,
  u0_.created_by,
  u0_.updated_by

SELECT u0_.first_name AS first_name_0, u0_.id AS id_1, COUNT(p1_.id) AS sclr_2 FROM proposal p1_ INNER JOIN user u0_ ON p1_.owner_id = u0_.id WHERE (p1_.state = 0) AND (p1_.open = 1 AND p1_.interview = 1) AND p1_.state = 0 GROUP BY u0_.id, u0_.uuid, u0_.email, u0_.first_name, u0_.last_name, u0_.phone, u0_.type, u0_.last_login, u0_.failed_login_attempts, u0_.enabled, u0_.locked, u0_.roles, u0_.password, u0_.state, u0_.created, u0_.updated, u0_.picture_id, u0_.userfunction_id, u0_.timezone_id, u0_.locale_id, u0_.employee_id, u0_.organization_id, u0_.created_by, u0_.updated_by;

SELECT
  u0_.first_name AS first_name_0,
  u0_.id AS id_1,
  COUNT(c1_.id) AS sclr_2
FROM
  contract c1_
  INNER JOIN user u0_ ON c1_.owner_id = u0_.id
WHERE
  (c1_.state = 0)
  AND (
    (
      (c1_.end_date >= ?)
      OR (c1_.end_date IS NULL)
    )
    AND (c1_.start_date <= ?)
  )
  AND c1_.state = 0
GROUP BY
  u0_.id,
  u0_.uuid,
  u0_.email,
  u0_.first_name,
  u0_.last_name,
  u0_.phone,
  u0_.type,
  u0_.last_login,
  u0_.failed_login_attempts,
  u0_.enabled,
  u0_.locked,
  u0_.roles,
  u0_.password,
  u0_.state,
  u0_.created,
  u0_.updated,
  u0_.picture_id,
  u0_.userfunction_id,
  u0_.timezone_id,
  u0_.locale_id,
  u0_.employee_id,
  u0_.organization_id,
  u0_.created_by,
  u0_.updated_by

SELECT u0_.first_name AS first_name_0, u0_.id AS id_1, COUNT(c1_.id) AS sclr_2 FROM contract c1_ INNER JOIN user u0_ ON c1_.owner_id = u0_.id WHERE (c1_.state = 0) AND (((c1_.end_date >= '2026-09-01') OR (c1_.end_date IS NULL)) AND (c1_.start_date <= '2026-09-30')) AND c1_.state = 0 GROUP BY u0_.id, u0_.uuid, u0_.email, u0_.first_name, u0_.last_name, u0_.phone, u0_.type, u0_.last_login, u0_.failed_login_attempts, u0_.enabled, u0_.locked, u0_.roles, u0_.password, u0_.state, u0_.created, u0_.updated, u0_.picture_id, u0_.userfunction_id, u0_.timezone_id, u0_.locale_id, u0_.employee_id, u0_.organization_id, u0_.created_by, u0_.updated_by;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  contract c0_
WHERE
  (c0_.state = 0)
  AND (
    (c0_.end_date >= ?)
    OR (c0_.end_date IS NULL)
  )
  AND (c0_.start_date <= ?)

SELECT COUNT(c0_.id) AS sclr_0 FROM contract c0_ WHERE (c0_.state = 0) AND ((c0_.end_date >= '2026-08-01') OR (c0_.end_date IS NULL)) AND (c0_.start_date <= '2026-08-31');