https://inserjeune.francophonie.org/fr/getPrefecturesByRegion?amp=&regionId%3D27=

Query Metrics

2 Database Queries
2 Different statements
1.49 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.91 ms
(61.24%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.id_region AS id_region_3 FROM prefecture t0 WHERE t0.id_region IS NULL
Parameters:
[]
0.58 ms
(38.76%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.post_code AS post_code_3, t0.is_capital AS is_capital_4, t0.is_prefecture_capital AS is_prefecture_capital_5, t0.id_region AS id_region_6, t0.prefecture_id AS prefecture_id_7 FROM city t0 WHERE t0.id_region IS NULL
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\Prefecture
  • The mappings App\Entity\Prefecture#region and App\Entity\Region#prefectures are inconsistent with each other.
App\Entity\Region
  • The association App\Entity\Region#currency refers to the inverse side field App\Entity\Currency#regions which does not exist.
  • The association App\Entity\Region#prefectures refers to the owning side field App\Entity\Prefecture#regions which does not exist.
App\Entity\City No errors.