Query Metrics
1
Database Queries
1
Different statements
2.51 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.51 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.prenom AS prenom_2, c0_.contact AS contact_3, c0_.role AS role_4, c0_.email AS email_5, e1_.id AS id_6, e1_.nom AS nom_7, e1_.adresse AS adresse_8, e1_.latitude AS latitude_9, e1_.longitude AS longitude_10, e1_.contact AS contact_11, e1_.ao AS ao_12, e1_.chef AS chef_13, e1_.description AS description_14, e1_.photos AS photos_15, e1_.type AS type_16, e1_.whatsapp AS whatsapp_17, e1_.facebook AS facebook_18, d2_.id AS id_19, d2_.code AS code_20, d2_.slug AS slug_21, d2_.name AS name_22, r3_.id AS id_23, r3_.code AS code_24, r3_.slug AS slug_25, r3_.name AS name_26, c0_.etablissement_id_id AS etablissement_id_id_27, e1_.district_id AS district_id_28, e1_.commune_id AS commune_id_29, d2_.region_id AS region_id_30, r3_.user_id AS user_id_31 FROM cio c0_ INNER JOIN etablissements e1_ ON c0_.etablissement_id_id = e1_.id INNER JOIN district d2_ ON e1_.district_id = d2_.id AND (e1_.district_id = d2_.id) INNER JOIN region r3_ ON d2_.region_id = r3_.id AND (d2_.region_id = r3_.id) WHERE r3_.name = ?
Parameters:
[
"VAKINANKARATRA"
]
|
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\Cio | No errors. |
| App\Entity\Etablissements | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Region |
|
| App\Entity\Commune |
|
| App\Entity\User |
|
| App\Entity\Filiere | No errors. |
| App\Entity\Diplome | No errors. |
| App\Entity\TypeFormation | No errors. |