Query Metrics
15
Database Queries
7
Different statements
11.28 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.55 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:
[
"12"
]
|
2 | 0.94 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 | 1.16 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:
[
12
]
|
4 | 1.15 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:
[
8
]
|
5 | 1.05 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:
[
43
]
|
6 | 0.72 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.49 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:
[
44
]
|
8 | 0.42 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.42 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:
[
45
]
|
10 | 0.43 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.54 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:
[
9
]
|
12 | 0.48 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:
[
10
]
|
13 | 0.47 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:
[
11
]
|
14 | 1.04 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
]
|
15 | 0.42 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
]
|
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 |
|
App\Entity\Chambre |
|
App\Entity\Hotel |
|