Symfony Profiler

"COMMIT"

"COMMIT";

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.id = ?

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

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.rdv1 AS rdv1_6,
  t0.rdv2 AS rdv2_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.zipcode AS zipcode_10,
  t0.mprcategory AS mprcategory_11,
  t0.property_type AS property_type_12,
  t0.isolation AS isolation_13,
  t0.heating AS heating_14,
  t0.pv AS pv_15,
  t0.vmc AS vmc_16,
  t0.address_lat AS address_lat_17,
  t0.address_lng AS address_lng_18,
  t0.audit_invoice_sent AS audit_invoice_sent_19,
  t0.audit_paid AS audit_paid_20,
  t0.granting_invoice_sent AS granting_invoice_sent_21,
  t0.granting_invoice_paid AS granting_invoice_paid_22,
  t0.has_account_anah AS has_account_anah_23,
  t0.has_signed_contract_mar AS has_signed_contract_mar_24,
  t0.has_signed_contract_cq AS has_signed_contract_cq_25,
  t0.file_number AS file_number_26,
  t0.mprpassword AS mprpassword_27,
  t0.vt_done AS vt_done_28,
  t0.status_rank AS status_rank_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.deleted_at AS deleted_at_32,
  t0.status_id AS status_id_33,
  t0.company_auditor_extern_id AS company_auditor_extern_id_34,
  t0.company_auditor_intern_id AS company_auditor_intern_id_35,
  t0.company_installer_admin_id AS company_installer_admin_id_36,
  t0.company_installer_collab_id AS company_installer_collab_id_37,
  t0.company_mar_id AS company_mar_id_38,
  t0.created_by_id AS created_by_id_39,
  t0.updated_by_id AS updated_by_id_40
FROM
  `customer` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.rdv1 AS rdv1_6, t0.rdv2 AS rdv2_7, t0.address AS address_8, t0.city AS city_9, t0.zipcode AS zipcode_10, t0.mprcategory AS mprcategory_11, t0.property_type AS property_type_12, t0.isolation AS isolation_13, t0.heating AS heating_14, t0.pv AS pv_15, t0.vmc AS vmc_16, t0.address_lat AS address_lat_17, t0.address_lng AS address_lng_18, t0.audit_invoice_sent AS audit_invoice_sent_19, t0.audit_paid AS audit_paid_20, t0.granting_invoice_sent AS granting_invoice_sent_21, t0.granting_invoice_paid AS granting_invoice_paid_22, t0.has_account_anah AS has_account_anah_23, t0.has_signed_contract_mar AS has_signed_contract_mar_24, t0.has_signed_contract_cq AS has_signed_contract_cq_25, t0.file_number AS file_number_26, t0.mprpassword AS mprpassword_27, t0.vt_done AS vt_done_28, t0.status_rank AS status_rank_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.deleted_at AS deleted_at_32, t0.status_id AS status_id_33, t0.company_auditor_extern_id AS company_auditor_extern_id_34, t0.company_auditor_intern_id AS company_auditor_intern_id_35, t0.company_installer_admin_id AS company_installer_admin_id_36, t0.company_installer_collab_id AS company_installer_collab_id_37, t0.company_mar_id AS company_mar_id_38, t0.created_by_id AS created_by_id_39, t0.updated_by_id AS updated_by_id_40 FROM `customer` t0 WHERE t0.id = '532';

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 = 'benoit.rousselle@ctbg.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.deleted AS deleted_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.customer_id AS customer_id_8,
  t0.user_id AS user_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  `customer_file` t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.customer_id AS customer_id_8, t0.user_id AS user_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM `customer_file` t0 WHERE t0.customer_id = 532;

INSERT INTO `customer_history` (
  status_rank, created_at, updated_at,
  deleted_at, user_id, customer_id,
  status_id, created_by_id, updated_by_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO `customer_history` (status_rank, created_at, updated_at, deleted_at, user_id, customer_id, status_id, created_by_id, updated_by_id) VALUES ('RANK21', '2026-08-31 14:49:24', '2026-08-31 14:49:24', NULL, 28, 532, 21, NULL, NULL);

SELECT
  t0.id AS id_1,
  t0.step AS step_2,
  t0.status AS status_3,
  t0.signature_id AS signature_id_4,
  t0.customer_signer_id AS customer_signer_id_5,
  t0.mar_signer_id AS mar_signer_id_6,
  t0.document_step1_doc1_id AS document_step1_doc1_id_7,
  t0.document_step2_doc1_id AS document_step2_doc1_id_8,
  t0.document_step2_doc2_id AS document_step2_doc2_id_9,
  t0.document_step2_doc3_id AS document_step2_doc3_id_10,
  t0.document_step2_doc4_id AS document_step2_doc4_id_11,
  t0.document_step3_doc1_id AS document_step3_doc1_id_12,
  t0.document_step3_doc2_id AS document_step3_doc2_id_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.customer_id AS customer_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.updated_by_id AS updated_by_id_19
FROM
  `yousign` t0
WHERE
  t0.customer_id = ?
  AND t0.step = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.step AS step_2, t0.status AS status_3, t0.signature_id AS signature_id_4, t0.customer_signer_id AS customer_signer_id_5, t0.mar_signer_id AS mar_signer_id_6, t0.document_step1_doc1_id AS document_step1_doc1_id_7, t0.document_step2_doc1_id AS document_step2_doc1_id_8, t0.document_step2_doc2_id AS document_step2_doc2_id_9, t0.document_step2_doc3_id AS document_step2_doc3_id_10, t0.document_step2_doc4_id AS document_step2_doc4_id_11, t0.document_step3_doc1_id AS document_step3_doc1_id_12, t0.document_step3_doc2_id AS document_step3_doc2_id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.customer_id AS customer_id_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19 FROM `yousign` t0 WHERE t0.customer_id = 532 AND t0.step = 'step1' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color_selected AS color_selected_3,
  t0.background_color_selected AS background_color_selected_4,
  t0.color_unselected AS color_unselected_5,
  t0.background_color_unselected AS background_color_unselected_6,
  t0.is_allowed_installer AS is_allowed_installer_7,
  t0.is_allowed_auditor AS is_allowed_auditor_8,
  t0.status_rank AS status_rank_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.status_category_id AS status_category_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15
FROM
  status t0
WHERE
  t0.status_rank = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.color_selected AS color_selected_3, t0.background_color_selected AS background_color_selected_4, t0.color_unselected AS color_unselected_5, t0.background_color_unselected AS background_color_unselected_6, t0.is_allowed_installer AS is_allowed_installer_7, t0.is_allowed_auditor AS is_allowed_auditor_8, t0.status_rank AS status_rank_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.status_category_id AS status_category_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15 FROM status t0 WHERE t0.status_rank = 'RANK21' LIMIT 1;

UPDATE
  `customer`
SET
  status_rank = ?,
  updated_at = ?,
  status_id = ?
WHERE
  id = ?

UPDATE `customer` SET status_rank = 'RANK21', updated_at = '2026-08-31 14:49:24', status_id = 21 WHERE id = 532;

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 = 21;

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
  t0.id AS id_1,
  t0.status_rank AS status_rank_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.user_id AS user_id_6,
  t0.customer_id AS customer_id_7,
  t0.status_id AS status_id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  `customer_history` t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.status_rank AS status_rank_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.user_id AS user_id_6, t0.customer_id AS customer_id_7, t0.status_id AS status_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM `customer_history` t0 WHERE t0.customer_id = 532;

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.user_id AS user_id_6,
  t0.customer_id AS customer_id_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  `customer_comment` t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.user_id AS user_id_6, t0.customer_id AS customer_id_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM `customer_comment` t0 WHERE t0.customer_id = 532;