https://rusticavoyages.com/detailsejour/114

Query Metrics

11 Database Queries
7 Different statements
8.15 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 1.67 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.dcr AS dcr_3, t0.etat AS etat_4, t0.titre AS titre_5, t0.dureesej AS dureesej_6, t0.prix AS prix_7, t0.pindex AS pindex_8, t0.villed AS villed_9, t0.voyagecart AS voyagecart_10, t0.villea AS villea_11, t0.hotel AS hotel_12, t0.nbreetoile AS nbreetoile_13, t0.nbreplaces AS nbreplaces_14, t0.description AS description_15, t0.prixavance AS prixavance_16, t0.ageminenf AS ageminenf_17, t0.agemaxenf AS agemaxenf_18, t0.ageminbb AS ageminbb_19, t0.agemaxbb AS agemaxbb_20, t0.marge AS marge_21, t0.maps AS maps_22, t0.dated AS dated_23, t0.datef AS datef_24, t0.serviceinclus AS serviceinclus_25, t0.servicenoninclus AS servicenoninclus_26, t0.latest AS latest_27, t0.themes_id AS themes_id_28, t0.arrangement_id AS arrangement_id_29 FROM sejour t0 WHERE t0.id = ?
Parameters:
[
  "114"
]
2 0.98 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
Parameters:
[]
3 0.85 ms
SELECT t0.id AS id_1, t0.pricebb AS pricebb_2, t0.dated AS dated_3, t0.datef AS datef_4, t0.dcr AS dcr_5, t0.dmj AS dmj_6, t0.enf252 AS enf252_7, t0.enf6112 AS enf6112_8, t0.enf25 AS enf25_9, t0.enf611 AS enf611_10, t0.demande252 AS demande252_11, t0.demande6112 AS demande6112_12, t0.demande611 AS demande611_13, t0.demande25 AS demande25_14, t0.demandebb AS demandebb_15, t0.pack AS pack_16, t0.sejour_id AS sejour_id_17 FROM sejourprice t0 WHERE t0.sejour_id = ?
Parameters:
[
  114
]
4 0.65 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.etat AS etat_3, t0.sejourroom_id AS sejourroom_id_4, t0.sejourprice_id AS sejourprice_id_5 FROM sejourpriceroom t0 WHERE t0.sejourprice_id = ?
Parameters:
[
  76
]
5 0.64 ms
SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.bebe AS bebe_5, t0.personne AS personne_6, t0.sejour_id AS sejour_id_7, t0.chambre_id AS chambre_id_8 FROM sejourroom t0 WHERE t0.id = ?
Parameters:
[
  316
]
6 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3, t0.capacity AS capacity_4 FROM chambre t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.57 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:
[
  114
]
8 0.65 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
]
9 0.56 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
]
10 0.50 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
]
11 0.50 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:
[
  115
]

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\Sejour No errors.
App\Entity\Themes
  • The association App\Entity\Themes#hotels refers to the owning side field App\Entity\Hotel#hotelthemes which does not exist.
App\Entity\Arrangements
  • The association App\Entity\Arrangements#pricearrangements refers to the owning side field App\Entity\Pricearrangement#arrangement which does not exist.
App\Entity\ImageSejours No errors.
App\Entity\DateSuppSejours No errors.
App\Entity\Sejourprice No errors.
App\Entity\Sejourroom
  • The association App\Entity\Sejourroom#chambre refers to the inverse side field App\Entity\Chambre#sejourrooms which does not exist.
App\Entity\Sejourpriceroom No errors.
App\Entity\Chambre
  • The association App\Entity\Chambre#hotels refers to the owning side field App\Entity\Hotel#hotelroom which does not exist.
App\Entity\Hotel
  • The mappings App\Entity\Hotel#ville and App\Entity\Villes#hotels are inconsistent with each other.