Query Metrics
258
Database Queries
11
Different statements
251.21 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
183.76 ms (73.15%) |
122 |
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:
[
2258
]
|
14.53 ms (5.78%) |
32 |
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:
[
66
]
|
13.78 ms (5.49%) |
32 |
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:
[
66
]
|
13.41 ms (5.34%) |
32 |
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:
[
66
]
|
13.21 ms (5.26%) |
32 |
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:
[
66
]
|
6.98 ms (2.78%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.duree AS duree_2, s0_.destination AS destination_3, s0_.itineraire AS itineraire_4, s0_.etat AS etat_5, s0_.croisiere_id AS croisiere_id_6, s0_.navire_id AS navire_id_7 FROM souscroisiere s0_ INNER JOIN navire n1_ ON s0_.navire_id = n1_.id INNER JOIN croisiere c2_ ON s0_.croisiere_id = c2_.id LEFT JOIN souscroisiereprice s3_ ON s0_.id = s3_.souscroisiere_id WHERE s0_.croisiere_id = ?
Parameters:
[
4
]
|
1.67 ms (0.67%) |
1 |
SELECT s0_.dated AS dated_0 FROM souscroisiereprice s0_ INNER JOIN souscroisiere s1_ ON s0_.souscroisiere_id = s1_.id WHERE s1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.dated ASC
Parameters:
[ 66 77 8 67 71 75 88 17 70 72 74 23 68 73 81 92 13 14 79 84 93 10 30 56 59 82 83 89 94 41 69 15 91 99 26 86 20 12 48 76 44 24 29 80 50 43 49 60 95 35 45 78 85 87 90 ] |
1.31 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM croisiere t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
1.28 ms (0.51%) |
3 |
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
]
|
0.96 ms (0.38%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.longdesc AS longdesc_3, t0.technique AS technique_4 FROM navire t0
Parameters:
[] |
0.32 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM croisiere t0
Parameters:
[] |
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\Croisiere | No errors. |
App\Entity\Imagescroisiere | No errors. |
App\Entity\Souscroisiere |
|
App\Entity\Navire |
|
App\Entity\Pont | No errors. |
App\Entity\Imagesnavire | No errors. |
App\Entity\Souscroisiereprice | No errors. |
App\Entity\Souscroisiereroom | No errors. |
App\Entity\Imagessouscroisiere | No errors. |
App\Entity\Avantage |
|
App\Entity\Imagesavantage | No errors. |
App\Entity\Souscroisierepriceroom | No errors. |
App\Entity\Cabine | No errors. |