Query Metrics
33
Database Queries
12
Different statements
17.53 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.80 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.duree AS duree_3, t0.destination AS destination_4, t0.itineraire AS itineraire_5, t0.etat AS etat_6, t0.croisiere_id AS croisiere_id_7, t0.navire_id AS navire_id_8 FROM souscroisiere t0 WHERE t0.id = ?
Parameters:
[
"51"
]
|
2 | 0.98 ms |
SELECT t0.id AS id_1, t0.dated AS dated_2, t0.datef AS datef_3, t0.pack AS pack_4, t0.souscroisiere_id AS souscroisiere_id_5 FROM souscroisiereprice t0 WHERE t0.souscroisiere_id = ?
Parameters:
[
51
]
|
3 | 0.71 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
895
]
|
4 | 0.79 ms |
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.souscroisiere_id AS souscroisiere_id_5, t0.chambre_id AS chambre_id_6 FROM souscroisiereroom t0 WHERE t0.id = ?
Parameters:
[
2223
]
|
5 | 0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM cabine t0 WHERE t0.id = ?
Parameters:
[
1
]
|
6 | 0.42 ms |
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.souscroisiere_id AS souscroisiere_id_5, t0.chambre_id AS chambre_id_6 FROM souscroisiereroom t0 WHERE t0.id = ?
Parameters:
[
2224
]
|
7 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM cabine t0 WHERE t0.id = ?
Parameters:
[
2
]
|
8 | 0.37 ms |
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.souscroisiere_id AS souscroisiere_id_5, t0.chambre_id AS chambre_id_6 FROM souscroisiereroom t0 WHERE t0.id = ?
Parameters:
[
2225
]
|
9 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM cabine t0 WHERE t0.id = ?
Parameters:
[
3
]
|
10 | 0.35 ms |
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.souscroisiere_id AS souscroisiere_id_5, t0.chambre_id AS chambre_id_6 FROM souscroisiereroom t0 WHERE t0.id = ?
Parameters:
[
2226
]
|
11 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM cabine t0 WHERE t0.id = ?
Parameters:
[
4
]
|
12 | 0.49 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
896
]
|
13 | 0.41 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1000
]
|
14 | 0.39 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1001
]
|
15 | 0.40 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1002
]
|
16 | 0.45 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1021
]
|
17 | 0.40 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1022
]
|
18 | 0.42 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1023
]
|
19 | 0.39 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1024
]
|
20 | 0.46 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1025
]
|
21 | 0.39 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereprice_id = ?
Parameters:
[
1026
]
|
22 | 0.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.souscroisieres_id AS souscroisieres_id_3 FROM imagessouscroisiere t0 WHERE t0.souscroisieres_id = ?
Parameters:
[
51
]
|
23 | 0.51 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.longdesc AS longdesc_3, t0.technique AS technique_4 FROM navire t0 WHERE t0.id = ?
Parameters:
[
3
]
|
24 | 0.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.etat AS etat_4 FROM avantage t0 INNER JOIN souscroisiere_avantage ON t0.id = souscroisiere_avantage.avantage_id WHERE souscroisiere_avantage.souscroisiere_id = ?
Parameters:
[
51
]
|
25 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.avantages_id AS avantages_id_3 FROM imagesavantage t0 WHERE t0.avantages_id = ?
Parameters:
[
5
]
|
26 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.avantages_id AS avantages_id_3 FROM imagesavantage t0 WHERE t0.avantages_id = ?
Parameters:
[
6
]
|
27 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.avantages_id AS avantages_id_3 FROM imagesavantage t0 WHERE t0.avantages_id = ?
Parameters:
[
7
]
|
28 | 0.37 ms |
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.souscroisiere_id AS souscroisiere_id_5, t0.chambre_id AS chambre_id_6 FROM souscroisiereroom t0 WHERE t0.souscroisiere_id = ?
Parameters:
[
51
]
|
29 | 0.46 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereroom_id = ?
Parameters:
[
2223
]
|
30 | 0.52 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereroom_id = ?
Parameters:
[
2224
]
|
31 | 0.46 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereroom_id = ?
Parameters:
[
2225
]
|
32 | 0.38 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.souscroisiereroom_id AS souscroisiereroom_id_4, t0.souscroisiereprice_id AS souscroisiereprice_id_5 FROM souscroisierepriceroom t0 WHERE t0.souscroisiereroom_id = ?
Parameters:
[
2226
]
|
33 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.navire_id AS navire_id_3 FROM imagesnavire t0 WHERE t0.navire_id = ?
Parameters:
[
3
]
|
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\Souscroisiere |
|
App\Entity\Croisiere | No errors. |
App\Entity\Navire |
|
App\Entity\Souscroisiereprice | No errors. |
App\Entity\Souscroisiereroom | No errors. |
App\Entity\Imagessouscroisiere | No errors. |
App\Entity\Avantage |
|
App\Entity\Souscroisierepriceroom | No errors. |
App\Entity\Cabine | No errors. |
App\Entity\Pont | No errors. |
App\Entity\Imagesnavire | No errors. |
App\Entity\Imagesavantage | No errors. |