https://www.rusticavoyages.com/details/4

Query Metrics

258 Database Queries
11 Different statements
251.21 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

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
  • 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\Navire
  • The mappings App\Entity\Navire#souscroisiere and App\Entity\Souscroisiere#navire are inconsistent with each other.
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
  • 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\Imagesavantage No errors.
App\Entity\Souscroisierepriceroom No errors.
App\Entity\Cabine No errors.