Symfony Profiler

SELECT
  t0.id AS id_7,
  t0.email AS email_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.firstname AS firstname_11,
  t0.lastname AS lastname_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.dtype
FROM
  `user` t0
  LEFT JOIN `user_admin` t1 ON t0.id = t1.id
  LEFT JOIN `user_installer_admin` t2 ON t0.id = t2.id
  LEFT JOIN `user_mar` t3 ON t0.id = t3.id
  LEFT JOIN `user_auditor_extern` t4 ON t0.id = t4.id
  LEFT JOIN `user_auditor_intern` t5 ON t0.id = t5.id
  LEFT JOIN `user_installer_collab` t6 ON t0.id = t6.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_7, t0.email AS email_8, t0.roles AS roles_9, t0.password AS password_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.dtype FROM `user` t0 LEFT JOIN `user_admin` t1 ON t0.id = t1.id LEFT JOIN `user_installer_admin` t2 ON t0.id = t2.id LEFT JOIN `user_mar` t3 ON t0.id = t3.id LEFT JOIN `user_auditor_extern` t4 ON t0.id = t4.id LEFT JOIN `user_auditor_intern` t5 ON t0.id = t5.id LEFT JOIN `user_installer_collab` t6 ON t0.id = t6.id WHERE t0.email = 'contact@innovoa.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.company_installer_admin_id AS company_installer_admin_id_5,
  t0.user_installer_admin_id AS user_installer_admin_id_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  company_installer_admin_user t0
WHERE
  t0.user_installer_admin_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.company_installer_admin_id AS company_installer_admin_id_5, t0.user_installer_admin_id AS user_installer_admin_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM company_installer_admin_user t0 WHERE t0.user_installer_admin_id = 48;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_installer_admin` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_installer_admin` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 44;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_installer_collab` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_installer_collab` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 0;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_auditor_intern` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_auditor_intern` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 0;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_auditor_extern` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_auditor_extern` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 0;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_mar` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_mar` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 0;

SELECT
  c0_.id AS id_0,
  c0_.firstname AS firstname_1,
  c0_.lastname AS lastname_2,
  c0_.email AS email_3,
  c0_.phone AS phone_4,
  c0_.rdv1 AS rdv1_5,
  c0_.rdv2 AS rdv2_6,
  c0_.address AS address_7,
  c0_.city AS city_8,
  c0_.zipcode AS zipcode_9,
  c0_.mprcategory AS mprcategory_10,
  c0_.property_type AS property_type_11,
  c0_.isolation AS isolation_12,
  c0_.heating AS heating_13,
  c0_.pv AS pv_14,
  c0_.vmc AS vmc_15,
  c0_.address_lat AS address_lat_16,
  c0_.address_lng AS address_lng_17,
  c0_.audit_invoice_sent AS audit_invoice_sent_18,
  c0_.audit_paid AS audit_paid_19,
  c0_.granting_invoice_sent AS granting_invoice_sent_20,
  c0_.granting_invoice_paid AS granting_invoice_paid_21,
  c0_.has_account_anah AS has_account_anah_22,
  c0_.has_signed_contract_mar AS has_signed_contract_mar_23,
  c0_.has_signed_contract_cq AS has_signed_contract_cq_24,
  c0_.file_number AS file_number_25,
  c0_.mprpassword AS mprpassword_26,
  c0_.vt_done AS vt_done_27,
  c0_.status_rank AS status_rank_28,
  c0_.created_at AS created_at_29,
  c0_.updated_at AS updated_at_30,
  c0_.deleted_at AS deleted_at_31,
  c0_.status_id AS status_id_32,
  c0_.company_auditor_extern_id AS company_auditor_extern_id_33,
  c0_.company_auditor_intern_id AS company_auditor_intern_id_34,
  c0_.company_installer_admin_id AS company_installer_admin_id_35,
  c0_.company_installer_collab_id AS company_installer_collab_id_36,
  c0_.company_mar_id AS company_mar_id_37,
  c0_.created_by_id AS created_by_id_38,
  c0_.updated_by_id AS updated_by_id_39
FROM
  `customer` c0_
WHERE
  c0_.status_rank IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND (
    c0_.updated_at BETWEEN ?
    AND ?
  )
  AND c0_.company_installer_admin_id IN (?)
ORDER BY
  c0_.updated_at DESC
LIMIT
  100

SELECT c0_.id AS id_0, c0_.firstname AS firstname_1, c0_.lastname AS lastname_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.rdv1 AS rdv1_5, c0_.rdv2 AS rdv2_6, c0_.address AS address_7, c0_.city AS city_8, c0_.zipcode AS zipcode_9, c0_.mprcategory AS mprcategory_10, c0_.property_type AS property_type_11, c0_.isolation AS isolation_12, c0_.heating AS heating_13, c0_.pv AS pv_14, c0_.vmc AS vmc_15, c0_.address_lat AS address_lat_16, c0_.address_lng AS address_lng_17, c0_.audit_invoice_sent AS audit_invoice_sent_18, c0_.audit_paid AS audit_paid_19, c0_.granting_invoice_sent AS granting_invoice_sent_20, c0_.granting_invoice_paid AS granting_invoice_paid_21, c0_.has_account_anah AS has_account_anah_22, c0_.has_signed_contract_mar AS has_signed_contract_mar_23, c0_.has_signed_contract_cq AS has_signed_contract_cq_24, c0_.file_number AS file_number_25, c0_.mprpassword AS mprpassword_26, c0_.vt_done AS vt_done_27, c0_.status_rank AS status_rank_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.deleted_at AS deleted_at_31, c0_.status_id AS status_id_32, c0_.company_auditor_extern_id AS company_auditor_extern_id_33, c0_.company_auditor_intern_id AS company_auditor_intern_id_34, c0_.company_installer_admin_id AS company_installer_admin_id_35, c0_.company_installer_collab_id AS company_installer_collab_id_36, c0_.company_mar_id AS company_mar_id_37, c0_.created_by_id AS created_by_id_38, c0_.updated_by_id AS updated_by_id_39 FROM `customer` c0_ WHERE c0_.status_rank IN ('RANK1', 'RANK2', 'RANK3', 'RANK4', 'RANK5', 'RANK6', 'RANK7', 'RANK8', 'RANK9', 'RANK10', 'RANK11', 'RANK12', 'RANK13', 'RANK14', 'RANK15', 'RANK16', 'RANK17', 'RANK18', 'RANK19', 'RANK20', 'RANK21', 'RANK22', 'RANK23', 'RANK24', 'RANK25', 'RANK26', 'RANK27', 'RANK28', 'RANK29', 'RANK30', 'RANK31', 'RANK32', 'RANK33') AND (c0_.updated_at BETWEEN '2023-05-03 00:00:00' AND '2026-05-04 00:00:00') AND c0_.company_installer_admin_id IN (44) ORDER BY c0_.updated_at DESC LIMIT 100;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.firstname AS firstname_1,
          c0_.lastname AS lastname_2,
          c0_.email AS email_3,
          c0_.phone AS phone_4,
          c0_.rdv1 AS rdv1_5,
          c0_.rdv2 AS rdv2_6,
          c0_.address AS address_7,
          c0_.city AS city_8,
          c0_.zipcode AS zipcode_9,
          c0_.mprcategory AS mprcategory_10,
          c0_.property_type AS property_type_11,
          c0_.isolation AS isolation_12,
          c0_.heating AS heating_13,
          c0_.pv AS pv_14,
          c0_.vmc AS vmc_15,
          c0_.address_lat AS address_lat_16,
          c0_.address_lng AS address_lng_17,
          c0_.audit_invoice_sent AS audit_invoice_sent_18,
          c0_.audit_paid AS audit_paid_19,
          c0_.granting_invoice_sent AS granting_invoice_sent_20,
          c0_.granting_invoice_paid AS granting_invoice_paid_21,
          c0_.has_account_anah AS has_account_anah_22,
          c0_.has_signed_contract_mar AS has_signed_contract_mar_23,
          c0_.has_signed_contract_cq AS has_signed_contract_cq_24,
          c0_.file_number AS file_number_25,
          c0_.mprpassword AS mprpassword_26,
          c0_.vt_done AS vt_done_27,
          c0_.status_rank AS status_rank_28,
          c0_.created_at AS created_at_29,
          c0_.updated_at AS updated_at_30,
          c0_.deleted_at AS deleted_at_31
        FROM
          `customer` c0_
        WHERE
          c0_.status_rank IN (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
            ?, ?
          )
          AND (
            c0_.updated_at BETWEEN ?
            AND ?
          )
          AND c0_.company_installer_admin_id IN (?)
        ORDER BY
          c0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.firstname AS firstname_1, c0_.lastname AS lastname_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.rdv1 AS rdv1_5, c0_.rdv2 AS rdv2_6, c0_.address AS address_7, c0_.city AS city_8, c0_.zipcode AS zipcode_9, c0_.mprcategory AS mprcategory_10, c0_.property_type AS property_type_11, c0_.isolation AS isolation_12, c0_.heating AS heating_13, c0_.pv AS pv_14, c0_.vmc AS vmc_15, c0_.address_lat AS address_lat_16, c0_.address_lng AS address_lng_17, c0_.audit_invoice_sent AS audit_invoice_sent_18, c0_.audit_paid AS audit_paid_19, c0_.granting_invoice_sent AS granting_invoice_sent_20, c0_.granting_invoice_paid AS granting_invoice_paid_21, c0_.has_account_anah AS has_account_anah_22, c0_.has_signed_contract_mar AS has_signed_contract_mar_23, c0_.has_signed_contract_cq AS has_signed_contract_cq_24, c0_.file_number AS file_number_25, c0_.mprpassword AS mprpassword_26, c0_.vt_done AS vt_done_27, c0_.status_rank AS status_rank_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.deleted_at AS deleted_at_31 FROM `customer` c0_ WHERE c0_.status_rank IN ('RANK1', 'RANK2', 'RANK3', 'RANK4', 'RANK5', 'RANK6', 'RANK7', 'RANK8', 'RANK9', 'RANK10', 'RANK11', 'RANK12', 'RANK13', 'RANK14', 'RANK15', 'RANK16', 'RANK17', 'RANK18', 'RANK19', 'RANK20', 'RANK21', 'RANK22', 'RANK23', 'RANK24', 'RANK25', 'RANK26', 'RANK27', 'RANK28', 'RANK29', 'RANK30', 'RANK31', 'RANK32', 'RANK33') AND (c0_.updated_at BETWEEN '2023-05-03 00:00:00' AND '2026-05-04 00:00:00') AND c0_.company_installer_admin_id IN (44) ORDER BY c0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_mar` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_mar` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 8;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_mar` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_mar` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 10;

SELECT
  t1.id AS id_2,
  t1.name AS name_3,
  t1.role AS role_4,
  t1.is_active AS is_active_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.deleted_at AS deleted_at_8,
  t1.created_by_id AS created_by_id_9,
  t1.updated_by_id AS updated_by_id_10,
  t1.dtype
FROM
  `company_mar` t0
  INNER JOIN `company` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.name AS name_3, t1.role AS role_4, t1.is_active AS is_active_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.deleted_at AS deleted_at_8, t1.created_by_id AS created_by_id_9, t1.updated_by_id AS updated_by_id_10, t1.dtype FROM `company_mar` t0 INNER JOIN `company` t1 ON t0.id = t1.id WHERE t1.id = 14;