GET http://www.maison.duhavre.fr/parcours

Query Metrics

6 Database Queries
5 Different statements
28.65 ms Query time
3 Invalid entities
1832 Managed entities

Queries

Group similar statements

# Time Info
1 18.32 ms
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.titre AS titre_4, t0.description AS description_5 FROM poi t0
Parameters:
[]
2 2.56 ms
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.nom AS nom_4, t0.numero AS numero_5, t0.info1 AS info1_6, t0.info2 AS info2_7, t0.info3 AS info3_8, t0.description AS description_9, t0.slug AS slug_10, t0.type_etape AS type_etape_11 FROM etape t0
Parameters:
[]
3 2.41 ms
SELECT t0.id AS id_1, t0.sens AS sens_2, t0.titre AS titre_3, t0.km AS km_4, t0.denivele_monte AS denivele_monte_5, t0.denivele_descente AS denivele_descente_6, t0.difficulte AS difficulte_7, t0.numero AS numero_8, t0.slug AS slug_9, t0.etape_depart_id AS etape_depart_id_10, t0.etape_arrivee_id AS etape_arrivee_id_11 FROM troncon t0 WHERE t0.sens = ? ORDER BY t0.numero ASC
Parameters:
[
  1
]
4 2.22 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.ville AS ville_4, c0_.code_postal AS code_postal_5, c0_.pays AS pays_6, c0_.adresse_ligne1 AS adresse_ligne1_7, c0_.adresse_ligne2 AS adresse_ligne2_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.slug AS slug_11, c0_.est_valide AS est_valide_12, c0_.proprietaire_id AS proprietaire_id_13, c0_.type_commerce_id AS type_commerce_id_14, c0_.ttroncon_id AS ttroncon_id_15, c0_.etape_id AS etape_id_16 FROM commerce c0_ WHERE c0_.latitude IS NOT NULL AND c0_.longitude IS NOT NULL
Parameters:
[]
5 1.67 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_commerce t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 1.48 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_commerce t0 WHERE t0.id = ?
Parameters:
[
  10
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Poi 1807
App\Entity\Etape 10
App\Entity\Troncon 9
App\Entity\Commerce 3
App\Entity\TypeCommerce 2
App\Entity\Utilisateur 1

Entities Mapping

Class Mapping errors
App\Entity\Poi No errors.
App\Entity\ImagePoi No errors.
App\Entity\Etape No errors.
App\Entity\Commerce
  • The association App\Entity\Commerce#typeCommerce refers to the inverse side field App\Entity\TypeCommerce#Commerces which does not exist.
App\Entity\Troncon No errors.
App\Entity\Utilisateur No errors.
App\Entity\TypeCommerce
  • The mappings App\Entity\TypeCommerce#commerces and App\Entity\Commerce#typeCommerce are inconsistent with each other.
App\Entity\CommerceCard
  • The mappings App\Entity\CommerceCard#images and App\Entity\CommerceImageCard#card are inconsistent with each other.