Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.numero AS numero_3,
  t0.chemin AS chemin_4,
  t0.date_created AS date_created_5
FROM
  check_qr t0
WHERE
  t0.numero = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.numero AS numero_3, t0.chemin AS chemin_4, t0.date_created AS date_created_5 FROM check_qr t0 WHERE t0.numero = '7739-6879-7658' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.first_name AS first_name_1,
  p0_.last_name AS last_name_2,
  p0_.civility AS civility_3,
  p0_.date_of_birth AS date_of_birth_4,
  p0_.place_of_birth AS place_of_birth_5,
  p0_.email AS email_6,
  p0_.phone AS phone_7,
  p0_.type_of_identification_document AS type_of_identification_document_8,
  p0_.identification_document_number AS identification_document_number_9,
  p0_.date_of_issue AS date_of_issue_10,
  p0_.date_of_expiration_issue AS date_of_expiration_issue_11,
  p0_.date_of_prorogation AS date_of_prorogation_12,
  p0_.date_of_expiration_prorogation AS date_of_expiration_prorogation_13,
  p0_.picture_front_of_identification_document AS picture_front_of_identification_document_14,
  p0_.picture_back_of_identification_document AS picture_back_of_identification_document_15,
  p0_.picture_of_localisation AS picture_of_localisation_16,
  p0_.firebase_token AS firebase_token_17,
  p0_.firebase_plateform AS firebase_plateform_18,
  p0_.enrolment_id AS enrolment_id_19,
  p0_.enrolment_uid AS enrolment_uid_20,
  p0_.enrolment_source AS enrolment_source_21,
  p0_.date_created AS date_created_22,
  p0_.signature AS signature_23,
  p0_.office_stamp AS office_stamp_24,
  p0_.nominative_stamp AS nominative_stamp_25,
  p0_.office_stamp_and_signature AS office_stamp_and_signature_26,
  p0_.nominative_stamp_and_signature AS nominative_stamp_and_signature_27,
  p0_.initials AS initials_28,
  p0_.adresse AS adresse_29,
  p0_.status AS status_30,
  p0_.nationality AS nationality_31,
  p0_.check_qr_id AS check_qr_id_32,
  p0_.person_id AS person_id_33
FROM
  person_civil p0_
  INNER JOIN check_qr c1_ ON p0_.check_qr_id = c1_.id
WHERE
  c1_.numero = ?

SELECT p0_.id AS id_0, p0_.first_name AS first_name_1, p0_.last_name AS last_name_2, p0_.civility AS civility_3, p0_.date_of_birth AS date_of_birth_4, p0_.place_of_birth AS place_of_birth_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.type_of_identification_document AS type_of_identification_document_8, p0_.identification_document_number AS identification_document_number_9, p0_.date_of_issue AS date_of_issue_10, p0_.date_of_expiration_issue AS date_of_expiration_issue_11, p0_.date_of_prorogation AS date_of_prorogation_12, p0_.date_of_expiration_prorogation AS date_of_expiration_prorogation_13, p0_.picture_front_of_identification_document AS picture_front_of_identification_document_14, p0_.picture_back_of_identification_document AS picture_back_of_identification_document_15, p0_.picture_of_localisation AS picture_of_localisation_16, p0_.firebase_token AS firebase_token_17, p0_.firebase_plateform AS firebase_plateform_18, p0_.enrolment_id AS enrolment_id_19, p0_.enrolment_uid AS enrolment_uid_20, p0_.enrolment_source AS enrolment_source_21, p0_.date_created AS date_created_22, p0_.signature AS signature_23, p0_.office_stamp AS office_stamp_24, p0_.nominative_stamp AS nominative_stamp_25, p0_.office_stamp_and_signature AS office_stamp_and_signature_26, p0_.nominative_stamp_and_signature AS nominative_stamp_and_signature_27, p0_.initials AS initials_28, p0_.adresse AS adresse_29, p0_.status AS status_30, p0_.nationality AS nationality_31, p0_.check_qr_id AS check_qr_id_32, p0_.person_id AS person_id_33 FROM person_civil p0_ INNER JOIN check_qr c1_ ON p0_.check_qr_id = c1_.id WHERE c1_.numero = '7739-6879-7658';

SELECT
  t0.id AS id_1,
  t0.fp1 AS fp1_2,
  t0.fp2 AS fp2_3,
  t0.fp3 AS fp3_4,
  t0.fp4 AS fp4_5,
  t0.fp5 AS fp5_6,
  t0.fp6 AS fp6_7,
  t0.fp7 AS fp7_8,
  t0.fp8 AS fp8_9,
  t0.fp9 AS fp9_10,
  t0.fp10 AS fp10_11,
  t0.face AS face_12,
  t0.fire_base_token AS fire_base_token_13,
  t0.date_created AS date_created_14,
  t0.status AS status_15,
  t0.is_doublon AS is_doublon_16,
  t0.is_enrolled AS is_enrolled_17,
  t0.finger_json AS finger_json_18,
  t0.abis_finger_json AS abis_finger_json_19,
  t0.abis_template_json AS abis_template_json_20,
  t0.abis_identification_json AS abis_identification_json_21,
  t0.abis_encounter_id AS abis_encounter_id_22,
  t0.check_qr_id AS check_qr_id_23,
  t0.device_id AS device_id_24,
  t0.person_id AS person_id_25,
  t0.cryptographe_id AS cryptographe_id_26
FROM
  person_biometrics t0
WHERE
  t0.check_qr_id = ?

SELECT t0.id AS id_1, t0.fp1 AS fp1_2, t0.fp2 AS fp2_3, t0.fp3 AS fp3_4, t0.fp4 AS fp4_5, t0.fp5 AS fp5_6, t0.fp6 AS fp6_7, t0.fp7 AS fp7_8, t0.fp8 AS fp8_9, t0.fp9 AS fp9_10, t0.fp10 AS fp10_11, t0.face AS face_12, t0.fire_base_token AS fire_base_token_13, t0.date_created AS date_created_14, t0.status AS status_15, t0.is_doublon AS is_doublon_16, t0.is_enrolled AS is_enrolled_17, t0.finger_json AS finger_json_18, t0.abis_finger_json AS abis_finger_json_19, t0.abis_template_json AS abis_template_json_20, t0.abis_identification_json AS abis_identification_json_21, t0.abis_encounter_id AS abis_encounter_id_22, t0.check_qr_id AS check_qr_id_23, t0.device_id AS device_id_24, t0.person_id AS person_id_25, t0.cryptographe_id AS cryptographe_id_26 FROM person_biometrics t0 WHERE t0.check_qr_id = 3642;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cryptographe (
  first_name, ACTION, demog, last_name,
  civility, date_of_birth, place_of_birth,
  email, phone, titre_diplome, specialisation,
  etablissement, annee, numero_reference,
  nationality, pays_residence, ville_residence,
  date_created, firebase_token, firebase_plateform,
  STATUS, signature, crypto_uuid, crypto_base64,
  check_qr_id, user_reference_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO cryptographe (first_name, ACTION, demog, last_name, civility, date_of_birth, place_of_birth, email, phone, titre_diplome, specialisation, etablissement, annee, numero_reference, nationality, pays_residence, ville_residence, date_created, firebase_token, firebase_plateform, STATUS, signature, crypto_uuid, crypto_base64, check_qr_id, user_reference_id) VALUES (NULL, 'CRYPTOID', 'sdsdsd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-27 15:56:13', NULL, 'MOBILE', 1, NULL, NULL, NULL, 3642, 3642);

"COMMIT"

"COMMIT";