GET https://orientejeunes-metfp.mg/cio/VAKINANKARATRA

Query Metrics

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

Queries

Group similar statements

# 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
  • 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\Filiere No errors.
App\Entity\Diplome No errors.
App\Entity\TypeFormation No errors.