Symfony Profiler

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 ?
  )
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 ('RANK26') AND (c0_.updated_at BETWEEN '2023-08-31 00:00:00' AND '2026-09-01 00:00:00') ORDER BY c0_.updated_at DESC LIMIT 100;

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 = 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
  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 ?
          )
        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 ('RANK26') AND (c0_.updated_at BETWEEN '2023-08-31 00:00:00' AND '2026-09-01 00:00:00') ORDER BY c0_.updated_at DESC) dctrn_result) dctrn_table;

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 = 'simon@renofy.fr' LIMIT 1;

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_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;