Query Metrics
1
Database Queries
1
Different statements
8.23 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 8.23 ms |
SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.adresse AS adresse_2, e0_.latitude AS latitude_3, e0_.longitude AS longitude_4, e0_.contact AS contact_5, e0_.ao AS ao_6, e0_.chef AS chef_7, e0_.description AS description_8, e0_.photos AS photos_9, e0_.type AS type_10, e0_.whatsapp AS whatsapp_11, e0_.facebook AS facebook_12, f1_.id AS id_13, f1_.code AS code_14, f1_.name AS name_15, f1_.slug AS slug_16, t2_.id AS id_17, t2_.abr AS abr_18, t2_.type AS type_19, s3_.id AS id_20, s3_.code AS code_21, s3_.name AS name_22, s3_.slug AS slug_23, m4_.id AS id_24, m4_.code AS code_25, m4_.slug AS slug_26, m4_.name AS name_27, m4_.coderiasec AS coderiasec_28, m4_.sigle AS sigle_29, m4_.fichier AS fichier_30, m4_.updated_at AS updated_at_31, d5_.id AS id_32, d5_.code AS code_33, d5_.slug AS slug_34, d5_.name AS name_35, r6_.id AS id_36, r6_.code AS code_37, r6_.slug AS slug_38, r6_.name AS name_39, e0_.district_id AS district_id_40, e0_.commune_id AS commune_id_41, f1_.sector_id AS sector_id_42, m4_.filiere_id AS filiere_id_43, d5_.region_id AS region_id_44, r6_.user_id AS user_id_45 FROM etablissements e0_ INNER JOIN etablissements_filiere e7_ ON e0_.id = e7_.etablissements_id INNER JOIN filiere f1_ ON f1_.id = e7_.filiere_id INNER JOIN etablissements_type_formation e8_ ON e0_.id = e8_.etablissements_id INNER JOIN type_formation t2_ ON t2_.id = e8_.type_formation_id INNER JOIN sector s3_ ON f1_.sector_id = s3_.id INNER JOIN metier m4_ ON f1_.id = m4_.filiere_id INNER JOIN district d5_ ON e0_.district_id = d5_.id AND (e0_.district_id = d5_.id) INNER JOIN region r6_ ON d5_.region_id = r6_.id AND (d5_.region_id = r6_.id) WHERE r6_.name = ?
Parameters:
[
"ATSINANANA"
]
|
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\Etablissements | No errors. |
| App\Entity\Filiere | No errors. |
| App\Entity\TypeFormation | No errors. |
| App\Entity\Sector | No errors. |
| App\Entity\Metier | No errors. |
| App\Entity\District | No errors. |
| App\Entity\Region |
|
| App\Entity\Commune |
|
| App\Entity\User |
|
| App\Entity\Cio | No errors. |
| App\Entity\Diplome | No errors. |
| App\Entity\ProgrammeFormation | No errors. |
| App\Entity\Referentiels | No errors. |
| App\Entity\FicheMetier | No errors. |
| App\Entity\Competence | No errors. |