https://rusticavoyages.com/detailcircuit/7

Query Metrics

13 Database Queries
7 Different statements
6.56 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.36 ms
SELECT t0.id AS id_1, t0.dated AS dated_2, t0.datef AS datef_3, t0.libelle AS libelle_4, t0.type AS type_5, t0.dcr AS dcr_6, t0.ville AS ville_7, t0.nbre_etoiles AS nbre_etoiles_8, t0.prix AS prix_9, t0.prixavance AS prixavance_10, t0.marge AS marge_11, t0.apartir AS apartir_12, t0.etat AS etat_13, t0.pindex AS pindex_14, t0.nbrejour AS nbrejour_15, t0.description AS description_16, t0.ageminenf AS ageminenf_17, t0.ageminbb AS ageminbb_18, t0.agemaxenf AS agemaxenf_19, t0.agemaxbb AS agemaxbb_20, t0.maps AS maps_21, t0.serviceinclus AS serviceinclus_22, t0.servicenoninclus AS servicenoninclus_23 FROM circuit t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
2 0.49 ms
SELECT c0_.id AS id_0, c0_.dated AS dated_1, c0_.datef AS datef_2, c0_.libelle AS libelle_3, c0_.type AS type_4, c0_.dcr AS dcr_5, c0_.ville AS ville_6, c0_.nbre_etoiles AS nbre_etoiles_7, c0_.prix AS prix_8, c0_.prixavance AS prixavance_9, c0_.marge AS marge_10, c0_.apartir AS apartir_11, c0_.etat AS etat_12, c0_.pindex AS pindex_13, c0_.nbrejour AS nbrejour_14, c0_.description AS description_15, c0_.ageminenf AS ageminenf_16, c0_.ageminbb AS ageminbb_17, c0_.agemaxenf AS agemaxenf_18, c0_.agemaxbb AS agemaxbb_19, c0_.maps AS maps_20, c0_.serviceinclus AS serviceinclus_21, c0_.servicenoninclus AS servicenoninclus_22 FROM circuit c0_ WHERE c0_.etat = 1
Parameters:
[]
3 0.62 ms
SELECT t0.id AS id_1, t0.pricebb AS pricebb_2, t0.dated AS dated_3, t0.datef AS datef_4, t0.enf252 AS enf252_5, t0.enf6112 AS enf6112_6, t0.enf25 AS enf25_7, t0.enf611 AS enf611_8, t0.demande252 AS demande252_9, t0.demande6112 AS demande6112_10, t0.demande611 AS demande611_11, t0.demande25 AS demande25_12, t0.demandebb AS demandebb_13, t0.pack AS pack_14, t0.circuit_id AS circuit_id_15 FROM circuitprice t0 WHERE t0.circuit_id = ?
Parameters:
[
  7
]
4 0.57 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.circuitroom_id AS circuitroom_id_4, t0.circuitprice_id AS circuitprice_id_5 FROM circuitpriceroom t0 WHERE t0.circuitprice_id = ?
Parameters:
[
  5
]
5 0.51 ms
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.circuit_id AS circuit_id_3, t0.chambre_id AS chambre_id_4 FROM circuitroom t0 WHERE t0.id = ?
Parameters:
[
  37
]
6 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3, t0.capacity AS capacity_4 FROM chambre t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.33 ms
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.circuit_id AS circuit_id_3, t0.chambre_id AS chambre_id_4 FROM circuitroom t0 WHERE t0.id = ?
Parameters:
[
  38
]
8 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3, t0.capacity AS capacity_4 FROM chambre t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.32 ms
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.circuit_id AS circuit_id_3, t0.chambre_id AS chambre_id_4 FROM circuitroom t0 WHERE t0.id = ?
Parameters:
[
  39
]
10 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3, t0.capacity AS capacity_4 FROM chambre t0 WHERE t0.id = ?
Parameters:
[
  3
]
11 0.35 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.circuitroom_id AS circuitroom_id_4, t0.circuitprice_id AS circuitprice_id_5 FROM circuitpriceroom t0 WHERE t0.circuitprice_id = ?
Parameters:
[
  7
]
12 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.circuits_id AS circuits_id_3 FROM imagescircuits t0 WHERE t0.circuits_id = ?
Parameters:
[
  7
]
13 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.circuits_id AS circuits_id_3 FROM imagescircuits t0 WHERE t0.circuits_id = ?
Parameters:
[
  12
]

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\Circuit No errors.
App\Entity\Imagescircuits No errors.
App\Entity\DateSuppCircuit No errors.
App\Entity\Coordonnescircuit No errors.
App\Entity\Reservationcircuit No errors.
App\Entity\Circuitprice No errors.
App\Entity\Circuitpriceroom No errors.
App\Entity\Circuitroom
  • The association App\Entity\Circuitroom#circuit refers to the inverse side field App\Entity\Circuit#circuitrooms which does not exist.
  • The association App\Entity\Circuitroom#chambre refers to the inverse side field App\Entity\Chambre#circuitrooms which does not exist.
App\Entity\Chambre
  • The association App\Entity\Chambre#hotels refers to the owning side field App\Entity\Hotel#hotelroom which does not exist.
App\Entity\Hotel
  • The mappings App\Entity\Hotel#ville and App\Entity\Villes#hotels are inconsistent with each other.