1
0.87 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . nom AS nom_5 , t0 . prenom AS prenom_6 , t0 . telephone AS telephone_7 , t0 . numero_inspecteur AS numero_inspecteur_8 , t0 . created_at AS created_at_9 , t0 . is_verified AS is_verified_10 , t0 . domaine_id AS domaine_id_11 , t0 . chef_service_id AS chef_service_id_12 , t0 . directeur_technique_id AS directeur_technique_id_13 , t0 . organisme_id AS organisme_id_14 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 . nom AS nom_5 , t0 . prenom AS prenom_6 , t0 . telephone AS telephone_7 , t0 . numero_inspecteur AS numero_inspecteur_8 , t0 . created_at AS created_at_9 , t0 . is_verified AS is_verified_10 , t0 . domaine_id AS domaine_id_11 , t0 . chef_service_id AS chef_service_id_12 , t0 . directeur_technique_id AS directeur_technique_id_13 , t0 . organisme_id AS organisme_id_14 FROM user t0 WHERE t0 . id = 65 ;
Copy
2
2.37 ms
SELECT t0 . id AS id_1 , t0 . decision_initiale AS decision_initiale_2 , t0 . date_decision_initiale AS date_decision_initiale_3 , t0 . decision_finale AS decision_finale_4 , t0 . date_decision_finale AS date_decision_finale_5 , t0 . commentaire_initial AS commentaire_initial_6 , t0 . commentaire_final AS commentaire_final_7 , t0 . date_soumission AS date_soumission_8 , t0 . statut AS statut_9 , t0 . created_at AS created_at_10 , t0 . constatation_id AS constatation_id_11 FROM plan_action t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . decision_initiale AS decision_initiale_2 , t0 . date_decision_initiale AS date_decision_initiale_3 , t0 . decision_finale AS decision_finale_4 , t0 . date_decision_finale AS date_decision_finale_5 , t0 . commentaire_initial AS commentaire_initial_6 , t0 . commentaire_final AS commentaire_final_7 , t0 . date_soumission AS date_soumission_8 , t0 . statut AS statut_9 , t0 . created_at AS created_at_10 , t0 . constatation_id AS constatation_id_11 FROM plan_action t0 WHERE t0 . id = '37' ;
Copy
3
3.81 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
4
0.46 ms
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"1- Actualiser le comité PPA par une nouvelle décision "
"2025-05-05 "
"2025-05-16 "
"Directeur des Opérations et de l'eXpérience Passagers "
""
null
null
"en_cours "
37
]
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES ('1- Actualiser le comité PPA par une nouvelle décision ' , '2025-05-05' , '2025-05-16' , 'Directeur des Opérations et de l\'eXpérience Passagers' , '' , NULL , NULL , 'en_cours' , 37 );
Copy
5
29.61 ms
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"2- Installer le comité PPA "
"2025-05-30 "
"2025-05-30 "
"Directeur des Opérations et de l'eXpérience Passagers "
""
null
null
"en_cours "
37
]
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES ('2- Installer le comité PPA' , '2025-05-30' , '2025-05-30' , 'Directeur des Opérations et de l\'eXpérience Passagers' , '' , NULL , NULL , 'en_cours' , 37 );
Copy
6
0.35 ms
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"3- Former les membres du comité PPA "
"2025-06-16 "
"2025-06-27 "
"Directeur des Opérations et de l'eXpérience Passagers "
""
null
null
"en_cours "
37
]
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES ('3- Former les membres du comité PPA' , '2025-06-16' , '2025-06-27' , 'Directeur des Opérations et de l\'eXpérience Passagers' , '' , NULL , NULL , 'en_cours' , 37 );
Copy
7
0.24 ms
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"4- Faire l’évaluation du risque faunique année par année de 2021 à 2024 "
"2025-07-07 "
"2025-07-18 "
"Directeur des Opérations et de l'eXpérience Passagers "
""
null
null
"en_cours "
37
]
INSERT INTO action_correctrice (libelle , date_debut , date_fin , responsable , observation , decision_anac , commentaire_anac , statut , plan_action_id ) VALUES ('4- Faire l’évaluation du risque faunique année par année de 2021 à 2024 ' , '2025-07-07' , '2025-07-18' , 'Directeur des Opérations et de l\'eXpérience Passagers' , '' , NULL , NULL , 'en_cours' , 37 );
Copy
8
11.12 ms
"COMMIT"
9
0.49 ms
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . intitule AS intitule_3 , t0 . regle AS regle_4 , t0 . preuve AS preuve_5 , t0 . daterevise AS daterevise_6 , t0 . date AS date_7 , t0 . remarque AS remarque_8 , t0 . niveau_id AS niveau_id_9 , t0 . statut_id AS statut_id_10 , t0 . acte_id AS acte_id_11 , t0 . risque_id AS risque_id_12 , t0 . type_constatation_id AS type_constatation_id_13 FROM constatation t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . numero AS numero_2 , t0 . intitule AS intitule_3 , t0 . regle AS regle_4 , t0 . preuve AS preuve_5 , t0 . daterevise AS daterevise_6 , t0 . date AS date_7 , t0 . remarque AS remarque_8 , t0 . niveau_id AS niveau_id_9 , t0 . statut_id AS statut_id_10 , t0 . acte_id AS acte_id_11 , t0 . risque_id AS risque_id_12 , t0 . type_constatation_id AS type_constatation_id_13 FROM constatation t0 WHERE t0 . id = 77 ;
Copy
10
0.48 ms
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . datedebut AS datedebut_3 , t0 . datefin AS datefin_4 , t0 . audite AS audite_5 , t0 . items AS items_6 , t0 . nbre AS nbre_7 , t0 . inspecteur_secondaire AS inspecteur_secondaire_8 , t0 . created_at AS created_at_9 , t0 . preuve AS preuve_10 , t0 . titre AS titre_11 , t0 . organisme_id AS organisme_id_12 , t0 . inspecteur_id AS inspecteur_id_13 , t0 . domaine_id AS domaine_id_14 , t0 . nature_id AS nature_id_15 FROM acte t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . datedebut AS datedebut_3 , t0 . datefin AS datefin_4 , t0 . audite AS audite_5 , t0 . items AS items_6 , t0 . nbre AS nbre_7 , t0 . inspecteur_secondaire AS inspecteur_secondaire_8 , t0 . created_at AS created_at_9 , t0 . preuve AS preuve_10 , t0 . titre AS titre_11 , t0 . organisme_id AS organisme_id_12 , t0 . inspecteur_id AS inspecteur_id_13 , t0 . domaine_id AS domaine_id_14 , t0 . nature_id AS nature_id_15 FROM acte t0 WHERE t0 . id = 62 ;
Copy
11
2.37 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . nom AS nom_5 , t0 . prenom AS prenom_6 , t0 . telephone AS telephone_7 , t0 . numero_inspecteur AS numero_inspecteur_8 , t0 . created_at AS created_at_9 , t0 . is_verified AS is_verified_10 , t0 . domaine_id AS domaine_id_11 , t0 . chef_service_id AS chef_service_id_12 , t0 . directeur_technique_id AS directeur_technique_id_13 , t0 . organisme_id AS organisme_id_14 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 . nom AS nom_5 , t0 . prenom AS prenom_6 , t0 . telephone AS telephone_7 , t0 . numero_inspecteur AS numero_inspecteur_8 , t0 . created_at AS created_at_9 , t0 . is_verified AS is_verified_10 , t0 . domaine_id AS domaine_id_11 , t0 . chef_service_id AS chef_service_id_12 , t0 . directeur_technique_id AS directeur_technique_id_13 , t0 . organisme_id AS organisme_id_14 FROM user t0 WHERE t0 . id = 15 ;
Copy