Query Metrics
2
Database Queries
2
Different statements
1.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.96 ms (55.79%) |
1 |
SELECT q0_.id AS id_0, q0_.code AS code_1, q0_.libelle AS libelle_2, q0_.actif AS actif_3, q0_.sous_prefecture_id AS sous_prefecture_id_4 FROM quartier q0_ INNER JOIN sous_prefecture s1_ ON (s1_.id = q0_.sous_prefecture_id) WHERE q0_.sous_prefecture_id = ? AND q0_.actif = 1
Parameters:
[
"918"
]
|
|
0.76 ms (44.21%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.date_naissance AS date_naissance_4, t0.lieu_naissance AS lieu_naissance_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.account_must_be_verified_before AS account_must_be_verified_before_8, t0.registration_token AS registration_token_9, t0.is_verified AS is_verified_10, t0.account_verified_at AS account_verified_at_11, t0.forgot_password_token AS forgot_password_token_12, t0.forgot_password_token_requested_at AS forgot_password_token_requested_at_13, t0.forgot_password_token_must_be_verified_before AS forgot_password_token_must_be_verified_before_14, t0.forgot_password_token_verified_at AS forgot_password_token_verified_at_15, t0.password AS password_16, t0.nom AS nom_17, t0.prenom AS prenom_18, t0.numero_piece_identite AS numero_piece_identite_19, t0.ville AS ville_20, t0.last_login AS last_login_21, t0.last_logout AS last_logout_22, t0.is_first_login AS is_first_login_23, t0.username AS username_24, t0.signature_file_name AS signature_file_name_25, t0.code_pin AS code_pin_26, t0.signataire_id AS signataire_id_27, t0.appelant_id AS appelant_id_28, t0.kyc_piece1 AS kyc_piece1_29, t0.kyc_piece2 AS kyc_piece2_30, t0.kyc_photo AS kyc_photo_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.civilite_id AS civilite_id_34, t0.piece_itendite_id AS piece_itendite_id_35, t0.pays_id AS pays_id_36, t0.service_id AS service_id_37, t0.role_id AS role_id_38, t0.banque_id AS banque_id_39 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
200
]
|
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\Utilisateur | No errors. |
| App\Entity\Civilite | No errors. |
| App\Entity\PieceIdentite | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Services | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Banque | No errors. |
| App\Entity\Statut | No errors. |
| App\Entity\DossierDemande | No errors. |
| App\Entity\Paiement | No errors. |
| App\Entity\Quittance | No errors. |
| App\Entity\UserGroupe | No errors. |
| App\Entity\HistoriqueLettre | No errors. |
| App\Entity\ServiceJuridique | No errors. |
| App\Entity\DemandeModification | No errors. |
| App\Entity\JournalisationSaisi | No errors. |
| App\Entity\Radiation | No errors. |
| App\Entity\DocumentCollected | No errors. |
| App\Entity\CompteEntreprise | No errors. |
| App\Entity\ModificationRCCM | No errors. |
| App\Entity\Quartier | No errors. |
| App\Entity\SousPrefecture | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\StatutGerantAssocie | No errors. |
| App\Entity\Gerant | No errors. |