Query Metrics
6
Database Queries
5
Different statements
10.55 ms
Query time
5
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.96 ms |
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
Parameters:
[
"de5557b8-bd65-4b63-89d6-5c516be359fc"
]
|
| 2 | 2.92 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.notification_message AS notification_message_2, p0_.notification_title AS notification_title_3, p0_.process AS process_4, p0_.score AS score_5, p0_.date_sign AS date_sign_6, p0_.date_created AS date_created_7, p0_.file AS file_8, p0_.verification_status AS verification_status_9, p0_.finger_json AS finger_json_10, p0_.status AS status_11, p0_.application_id AS application_id_12, p0_.user_reference_id AS user_reference_id_13, p0_.device_id AS device_id_14, p0_.check_qr_id AS check_qr_id_15 FROM person_bio_verification p0_ INNER JOIN check_qr c1_ ON p0_.check_qr_id = c1_.id WHERE c1_.numero = ?
Parameters:
[
"4467-5661-8371"
]
|
| 3 | 0.37 ms |
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.id = ?
Parameters:
[
6098
]
|
| 4 | 0.52 ms |
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.id = ?
Parameters:
[
3633
]
|
| 5 | 0.79 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.civility AS civility_4, t0.date_of_birth AS date_of_birth_5, t0.place_of_birth AS place_of_birth_6, t0.email AS email_7, t0.phone AS phone_8, t0.type_of_identification_document AS type_of_identification_document_9, t0.identification_document_number AS identification_document_number_10, t0.date_of_issue AS date_of_issue_11, t0.date_of_expiration_issue AS date_of_expiration_issue_12, t0.date_of_prorogation AS date_of_prorogation_13, t0.date_of_expiration_prorogation AS date_of_expiration_prorogation_14, t0.picture_front_of_identification_document AS picture_front_of_identification_document_15, t0.picture_back_of_identification_document AS picture_back_of_identification_document_16, t0.picture_of_localisation AS picture_of_localisation_17, t0.firebase_token AS firebase_token_18, t0.firebase_plateform AS firebase_plateform_19, t0.enrolment_id AS enrolment_id_20, t0.enrolment_uid AS enrolment_uid_21, t0.enrolment_source AS enrolment_source_22, t0.date_created AS date_created_23, t0.signature AS signature_24, t0.office_stamp AS office_stamp_25, t0.nominative_stamp AS nominative_stamp_26, t0.office_stamp_and_signature AS office_stamp_and_signature_27, t0.nominative_stamp_and_signature AS nominative_stamp_and_signature_28, t0.initials AS initials_29, t0.adresse AS adresse_30, t0.status AS status_31, t0.nationality AS nationality_32, t0.check_qr_id AS check_qr_id_33, t0.person_id AS person_id_34 FROM person_civil t0 WHERE t0.check_qr_id = ?
Parameters:
[
3633
]
|
| 6 | 4.98 ms |
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 = ?
Parameters:
[
3633
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\PersonBioVerification | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\CheckQr |
|
| App\Entity\ApplicationRequirement | No errors. |
| App\Entity\ApplicationSubscription | No errors. |
| App\Entity\BioAuth | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\Fichier | No errors. |
| App\Entity\PersonAppIdentity | No errors. |
| App\Entity\Device |
|
| App\Entity\Person |
|
| App\Entity\Transaction | No errors. |
| App\Entity\PersonAuthHistory |
|
| App\Entity\Identification | No errors. |
| App\Entity\Appointment | No errors. |
| App\Entity\PersonBiometrics | No errors. |
| App\Entity\PersonCivil | No errors. |
| App\Entity\BioAuthHistory | No errors. |
| App\Entity\PersonAppAvatar |
|
| App\Entity\PersonMeeting | No errors. |
| App\Entity\PersonMeetingMember | No errors. |
| App\Entity\Cryptographe | No errors. |
| App\Entity\PersonSignature | No errors. |
| App\Entity\PersonMeetingReportComment | No errors. |
| App\Entity\PersonMeetingReport | No errors. |