Query Metrics
5
Database Queries
5
Different statements
3.79 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.17 ms (30.92%) |
1 |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.libelle AS libelle_2, p0_.isactif AS isactif_3, p0_.nationalite AS nationalite_4, p0_.code_iso3 AS code_iso3_5 FROM pays p0_ WHERE p0_.isactif = 1 ORDER BY p0_.libelle ASC
Parameters:
[] |
0.75 ms (19.79%) |
1 |
SELECT t0.id AS id_1, t0.ocr_enabled AS ocr_enabled_2, t0.face_validation_enabled AS face_validation_enabled_3, t0.ocr_url AS ocr_url_4, t0.face_validation_url AS face_validation_url_5, t0.face_validation_json_label AS face_validation_json_label_6, t0.face_result_numeric AS face_result_numeric_7, t0.numeric_face_result_threshold AS numeric_face_result_threshold_8, t0.web_cam_enabled AS web_cam_enabled_9, t0.restriction_type_piece_enabled AS restriction_type_piece_enabled_10, t0.token AS token_11 FROM parametrage_kyc t0 LIMIT 1
Parameters:
[] |
0.68 ms (17.90%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.isactif AS isactif_5 FROM role t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"ROLE_PROMOTEUR"
]
|
0.62 ms (16.42%) |
1 |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.libelle AS libelle_2, c0_.isactif AS isactif_3 FROM civilite c0_
Parameters:
[] |
0.57 ms (14.97%) |
1 |
SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.code AS code_2 FROM piece_identite p0_
Parameters:
[] |
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\Role | No errors. |
App\Entity\Utilisateur | No errors. |
App\Entity\Civilite | No errors. |
App\Entity\PieceIdentite | No errors. |
App\Entity\Pays | No errors. |
App\Entity\ParametrageKyc | No errors. |
App\Entity\Gerant | No errors. |
App\Entity\StatutGerantAssocie | No errors. |
App\Entity\Statut | No errors. |
App\Entity\Region | No errors. |
App\Entity\DossierDemande | No errors. |
App\Entity\Aguipe | No errors. |
App\Entity\PersonneEngageur | No errors. |