Symfony Profiler

SET
  @row_number = 0

SET @row_number = 0;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.fonction AS fonction_7,
  t0.tel AS tel_8,
  t0.mobile AS mobile_9,
  t0.fax AS fax_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.modules AS modules_13,
  t0.photo AS photo_14,
  t0.gender AS gender_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17,
  t0.upper_hierarchy_id AS upper_hierarchy_id_18,
  t0.entity_id AS entity_id_19,
  t0.entite_attache AS entite_attache_20
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.fonction AS fonction_7, t0.tel AS tel_8, t0.mobile AS mobile_9, t0.fax AS fax_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.modules AS modules_13, t0.photo AS photo_14, t0.gender AS gender_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.upper_hierarchy_id AS upper_hierarchy_id_18, t0.entity_id AS entity_id_19, t0.entite_attache AS entite_attache_20 FROM user t0 WHERE t0.id = 34;

SELECT
  t0.id AS id_1,
  t0.ref AS ref_2,
  t0.title AS title_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.type AS type_6,
  t0.description AS description_7,
  t0.finality AS finality_8,
  t0.is_outsourced AS is_outsourced_9,
  t0.external_company AS external_company_10,
  t0.contact_person AS contact_person_11,
  t0.pilote AS pilote_12,
  t0.created_by AS created_by_13,
  t0.updated_by AS updated_by_14,
  t0.comment_dashboard_id AS comment_dashboard_id_15
FROM
  processus t0
  INNER JOIN user_processus ON t0.id = user_processus.processus_id
WHERE
  user_processus.user_id = ?

SELECT t0.id AS id_1, t0.ref AS ref_2, t0.title AS title_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.type AS type_6, t0.description AS description_7, t0.finality AS finality_8, t0.is_outsourced AS is_outsourced_9, t0.external_company AS external_company_10, t0.contact_person AS contact_person_11, t0.pilote AS pilote_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.comment_dashboard_id AS comment_dashboard_id_15 FROM processus t0 INNER JOIN user_processus ON t0.id = user_processus.processus_id WHERE user_processus.user_id = 34;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.complements AS complements_4,
  t0.ville AS ville_5,
  t0.code_postal AS code_postal_6,
  t0.pays AS pays_7,
  t0.telephone AS telephone_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  company_entity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.complements AS complements_4, t0.ville AS ville_5, t0.code_postal AS code_postal_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM company_entity t0 WHERE t0.id = '16';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.created_by_id AS created_by_id_5,
  t0.updated_by_id AS updated_by_id_6,
  t0.job_id AS job_id_7,
  t8.id AS id_9,
  t8.title AS title_10,
  t8.created_at AS created_at_11,
  t8.updated_at AS updated_at_12,
  t8.created_by_id AS created_by_id_13,
  t8.updated_by_id AS updated_by_id_14,
  t8.processus_id AS processus_id_15
FROM
  mission t0
  INNER JOIN job t8 ON t0.job_id = t8.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6, t0.job_id AS job_id_7, t8.id AS id_9, t8.title AS title_10, t8.created_at AS created_at_11, t8.updated_at AS updated_at_12, t8.created_by_id AS created_by_id_13, t8.updated_by_id AS updated_by_id_14, t8.processus_id AS processus_id_15 FROM mission t0 INNER JOIN job t8 ON t0.job_id = t8.id WHERE t0.id = '19' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO task (
  title, created_at, updated_at, created_by,
  updated_by, mission_id, zone_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO task (title, created_at, updated_at, created_by, updated_by, mission_id, zone_id) VALUES (' Dépoussiérage des rails d’ascenseur (mode maintenance)', '2026-02-16 13:15:51', NULL, '34', NULL, 19, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO situation (
  title, created_at, updated_at, created_by,
  updated_by, task_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO situation (title, created_at, updated_at, created_by, updated_by, task_id) VALUES ('Risque de coincement ou d\'écrasement par mouvement imprévu de l\'ascenseur', '2026-02-16 13:15:51', NULL, '34', NULL, 98);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.commentaire AS commentaire_3,
  t0.consequence AS consequence_4
FROM
  risque t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.commentaire AS commentaire_3, t0.consequence AS consequence_4 FROM risque t0 WHERE t0.id = '34' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO situation_risque (
  commentaire, comment_cr, comment_rr,
  risque_id, frequence_id, gravite_id,
  situation_id, mop_id, mog_id, action_id,
  company_entity_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO situation_risque (commentaire, comment_cr, comment_rr, risque_id, frequence_id, gravite_id, situation_id, mop_id, mog_id, action_id, company_entity_id) VALUES (NULL, NULL, NULL, 34, NULL, NULL, 264, NULL, NULL, NULL, 16);

"COMMIT"

"COMMIT";