Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.date_created AS date_created_4,
  t0.application_pass AS application_pass_5,
  t0.http_link AS http_link_6,
  t0.logo AS logo_7,
  t0.api_link AS api_link_8,
  t0.api_back_link AS api_back_link_9,
  t0.max_cash_out AS max_cash_out_10,
  t0.cash_out_cumul AS cash_out_cumul_11,
  t0.is_validated AS is_validated_12,
  t0.status AS status_13,
  t0.validation_delay AS validation_delay_14,
  t0.session_delay AS session_delay_15,
  t0.is_monday_block AS is_monday_block_16,
  t0.is_tuesday_block AS is_tuesday_block_17,
  t0.is_wednesday_block AS is_wednesday_block_18,
  t0.is_thursday_block AS is_thursday_block_19,
  t0.is_friday_block AS is_friday_block_20,
  t0.is_saturday_block AS is_saturday_block_21,
  t0.is_sunday_block AS is_sunday_block_22,
  t0.monday_start AS monday_start_23,
  t0.monday_end AS monday_end_24,
  t0.tuesday_start AS tuesday_start_25,
  t0.tuesday_end AS tuesday_end_26,
  t0.wednesday_start AS wednesday_start_27,
  t0.wednesday_end AS wednesday_end_28,
  t0.thursday_start AS thursday_start_29,
  t0.thursday_end AS thursday_end_30,
  t0.friday_start AS friday_start_31,
  t0.friday_end AS friday_end_32,
  t0.saturday_start AS saturday_start_33,
  t0.saturday_end AS saturday_end_34,
  t0.sunday_start AS sunday_start_35,
  t0.sunday_end AS sunday_end_36,
  t0.application_holder_ido_id AS application_holder_ido_id_37,
  t0.check_qr_id AS check_qr_id_38
FROM
  application t0
WHERE
  t0.application_pass = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.date_created AS date_created_4, t0.application_pass AS application_pass_5, t0.http_link AS http_link_6, t0.logo AS logo_7, t0.api_link AS api_link_8, t0.api_back_link AS api_back_link_9, t0.max_cash_out AS max_cash_out_10, t0.cash_out_cumul AS cash_out_cumul_11, t0.is_validated AS is_validated_12, t0.status AS status_13, t0.validation_delay AS validation_delay_14, t0.session_delay AS session_delay_15, t0.is_monday_block AS is_monday_block_16, t0.is_tuesday_block AS is_tuesday_block_17, t0.is_wednesday_block AS is_wednesday_block_18, t0.is_thursday_block AS is_thursday_block_19, t0.is_friday_block AS is_friday_block_20, t0.is_saturday_block AS is_saturday_block_21, t0.is_sunday_block AS is_sunday_block_22, t0.monday_start AS monday_start_23, t0.monday_end AS monday_end_24, t0.tuesday_start AS tuesday_start_25, t0.tuesday_end AS tuesday_end_26, t0.wednesday_start AS wednesday_start_27, t0.wednesday_end AS wednesday_end_28, t0.thursday_start AS thursday_start_29, t0.thursday_end AS thursday_end_30, t0.friday_start AS friday_start_31, t0.friday_end AS friday_end_32, t0.saturday_start AS saturday_start_33, t0.saturday_end AS saturday_end_34, t0.sunday_start AS sunday_start_35, t0.sunday_end AS sunday_end_36, t0.application_holder_ido_id AS application_holder_ido_id_37, t0.check_qr_id AS check_qr_id_38 FROM application t0 WHERE t0.application_pass = 'de5557b8-bd65-4b63-89d6-5c516be359fc' 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 = '8718-4287-5294';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO check_qr (
  libelle, numero, chemin, date_created
)
VALUES
  (?, ?, ?, ?)

INSERT INTO check_qr (libelle, numero, chemin, date_created) VALUES ('KVLAcI463PsXRKGgFcYvPdC1lA==', '1478-7271-2955', NULL, '2026-06-12 11:41:58');

INSERT INTO person_bio_verification (
  title, notification_message, notification_title,
  PROCESS, score, date_sign, date_created,
  FILE, verification_status, finger_json,
  STATUS, application_id, user_reference_id,
  device_id, check_qr_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO person_bio_verification (title, notification_message, notification_title, PROCESS, score, date_sign, date_created, FILE, verification_status, finger_json, STATUS, application_id, user_reference_id, device_id, check_qr_id) VALUES ('Signature document', 'Signature document : verify code', 'Signature document', 'Signature document', NULL, NULL, '2026-06-12 11:41:58', NULL, '[]', '[]', 0, 3, 3633, NULL, 6123);

"COMMIT"

"COMMIT";