Query Metrics

3 Database Queries
3 Different statements
8.87 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.66 ms
(86.45%)
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.83 ms
(9.40%)
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.37 ms
(4.15%)
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
  • The mappings App\Entity\CheckQr#personcivil and App\Entity\PersonCivil#checkQr are inconsistent with each other.
App\Entity\Person
  • The association App\Entity\Person#bioAuthHistories refers to the owning side field App\Entity\BioAuthHistory#person which does not exist.
  • The association App\Entity\Person#personAuthHistories refers to the owning side field App\Entity\PersonAuthHistory#person which does not exist.
  • The mappings App\Entity\Person#identifications and App\Entity\Identification#toBeIdentified are inconsistent with each other.
App\Entity\Transaction No errors.
App\Entity\PersonAuthHistory
  • The association App\Entity\PersonAuthHistory#device refers to the inverse side field App\Entity\Device#personAuthHistory which does not exist.
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
  • The association App\Entity\PersonAppAvatar#identificationAvatar refers to the owning side field App\Entity\PersonAppIdentity#avatar which does not exist.
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
  • The mappings App\Entity\Device#personAuthHistories and App\Entity\PersonAuthHistory#device are inconsistent with each other.