GET https://orientejeunes-metfp.mg/carto/ATSINANANA

Query Metrics

1 Database Queries
1 Different statements
8.23 ms Query time
3 Invalid entities

Queries

Group similar statements

# 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
  • The field App\Entity\Region#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#region does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Region#user is many-to-one, then the inversed side App\Entity\User#region has to be one-to-many.
App\Entity\Commune
  • The association App\Entity\Commune#district refers to the inverse side field App\Entity\District#communes which does not exist.
App\Entity\User
  • The field App\Entity\User#loginHistories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LoginHistory#user does not contain the required 'inversedBy="loginHistories"' attribute.
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.