Query Metrics
13
Database Queries
7
Different statements
9.75 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.61 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.etat AS etat_2 FROM banniere b0_ WHERE b0_.etat = 1
Parameters:
[] |
2 | 1.47 ms |
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.dcr AS dcr_2, s0_.etat AS etat_3, s0_.titre AS titre_4, s0_.dureesej AS dureesej_5, s0_.prix AS prix_6, s0_.pindex AS pindex_7, s0_.villed AS villed_8, s0_.voyagecart AS voyagecart_9, s0_.villea AS villea_10, s0_.hotel AS hotel_11, s0_.nbreetoile AS nbreetoile_12, s0_.nbreplaces AS nbreplaces_13, s0_.description AS description_14, s0_.prixavance AS prixavance_15, s0_.ageminenf AS ageminenf_16, s0_.agemaxenf AS agemaxenf_17, s0_.ageminbb AS ageminbb_18, s0_.agemaxbb AS agemaxbb_19, s0_.marge AS marge_20, s0_.maps AS maps_21, s0_.dated AS dated_22, s0_.datef AS datef_23, s0_.serviceinclus AS serviceinclus_24, s0_.servicenoninclus AS servicenoninclus_25, s0_.latest AS latest_26, s0_.themes_id AS themes_id_27, s0_.arrangement_id AS arrangement_id_28 FROM sejour s0_ WHERE s0_.etat = 1 AND s0_.latest = 1
Parameters:
[] |
3 | 0.95 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:
[] |
4 | 0.87 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.etat AS etat_2 FROM croisiere c0_ WHERE c0_.etat = 1
Parameters:
[] |
5 | 1.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.bannieres_id AS bannieres_id_3 FROM imagesbannieres t0 WHERE t0.bannieres_id = ?
Parameters:
[
23
]
|
6 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.bannieres_id AS bannieres_id_3 FROM imagesbannieres t0 WHERE t0.bannieres_id = ?
Parameters:
[
24
]
|
7 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.bannieres_id AS bannieres_id_3 FROM imagesbannieres t0 WHERE t0.bannieres_id = ?
Parameters:
[
25
]
|
8 | 0.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.croisieres_id AS croisieres_id_3 FROM imagescroisiere t0 WHERE t0.croisieres_id = ?
Parameters:
[
1
]
|
9 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.croisieres_id AS croisieres_id_3 FROM imagescroisiere t0 WHERE t0.croisieres_id = ?
Parameters:
[
2
]
|
10 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.croisieres_id AS croisieres_id_3 FROM imagescroisiere t0 WHERE t0.croisieres_id = ?
Parameters:
[
4
]
|
11 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sejours_id AS sejours_id_3 FROM image_sejours t0 WHERE t0.sejours_id = ?
Parameters:
[
101
]
|
12 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sejours_id AS sejours_id_3 FROM image_sejours t0 WHERE t0.sejours_id = ?
Parameters:
[
111
]
|
13 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sejours_id AS sejours_id_3 FROM image_sejours t0 WHERE t0.sejours_id = ?
Parameters:
[
113
]
|
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\Banniere | No errors. |
App\Entity\Imagesbannieres | No errors. |
App\Entity\Sejour | No errors. |
App\Entity\Themes |
|
App\Entity\Arrangements |
|
App\Entity\ImageSejours | No errors. |
App\Entity\DateSuppSejours | No errors. |
App\Entity\Sejourprice | No errors. |
App\Entity\Sejourroom |
|
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\Croisiere | No errors. |
App\Entity\Imagescroisiere | No errors. |
App\Entity\Souscroisiere |
|