https://rusticavoyages.com/sous_croisiere/details/61

Query Metrics

26 Database Queries
12 Different statements
18.17 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.88 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:
[
  "61"
]
2 0.96 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:
[
  61
]
3 0.89 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:
[
  898
]
4 0.95 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:
[
  1338
]
5 0.73 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:
[
  1339
]
7 0.44 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.40 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:
[
  1340
]
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.43 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:
[
  1341
]
11 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:
[
  4
]
12 0.48 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:
[
  899
]
13 0.57 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:
[
  900
]
14 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:
[
  901
]
15 0.86 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:
[
  61
]
16 0.95 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:
[
  24
]
17 1.32 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:
[
  61
]
18 0.82 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
]
19 0.46 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
]
20 0.53 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
]
21 0.57 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:
[
  61
]
22 0.59 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:
[
  1338
]
23 0.69 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:
[
  1339
]
24 0.58 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:
[
  1340
]
25 0.50 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:
[
  1341
]
26 0.90 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:
[
  24
]

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
  • The association App\Entity\Souscroisiere#navire refers to the inverse side field App\Entity\Navire#souscroisieres which does not exist.
  • The association App\Entity\Souscroisiere#avantages refers to the inverse side field App\Entity\Avantage#souscroisieres which does not exist.
App\Entity\Croisiere No errors.
App\Entity\Navire
  • The mappings App\Entity\Navire#souscroisiere and App\Entity\Souscroisiere#navire are inconsistent with each other.
App\Entity\Souscroisiereprice No errors.
App\Entity\Souscroisiereroom No errors.
App\Entity\Imagessouscroisiere No errors.
App\Entity\Avantage
  • The field App\Entity\Avantage#souscroisiere is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Souscroisiere#avantages does not contain the required 'mappedBy="souscroisiere"' attribute.
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.