Query Metrics
3
Database Queries
3
Different statements
7.23 ms
Query time
5
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.96 ms (82.54%) |
1 |
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
]
|
|
0.87 ms (12.11%) |
1 |
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.email = ? LIMIT 1
Parameters:
[
"anziapetra@gmail.com"
]
|
|
0.39 ms (5.35%) |
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.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\PersonCivil | No errors. |
| App\Entity\CheckQr |
|
| 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\PersonAppIdentity | No errors. |
| App\Entity\BioAuth | 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\Application | No errors. |
| App\Entity\PersonSignature | No errors. |
| App\Entity\PersonBioVerification | No errors. |
| App\Entity\PersonMeetingReportComment | No errors. |
| App\Entity\PersonMeetingReport | No errors. |
| App\Entity\Device |
|