GET https://preprod.theoriginals-bourges.fr/hotel/the-originals-city

Query Metrics

12 Database Queries
8 Different statements
13.66 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.43 ms
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.home_image AS home_image_3, t0.name AS name_4, t0.description AS description_5, t0.home_image_alt AS home_image_alt_6, t0.color AS color_7, t0.service_first_line AS service_first_line_8, t0.service_second_line AS service_second_line_9, t0.service_third_line AS service_third_line_10, t0.service_fourth_line AS service_fourth_line_11, t0.slug AS slug_12, t0.background_image AS background_image_13, t0.plaquette AS plaquette_14, t0.seminaire_background_image AS seminaire_background_image_15, t0.seminaire_text AS seminaire_text_16, t0.seminaire_plaquette AS seminaire_plaquette_17, t0.logo_dedicated_page AS logo_dedicated_page_18, t0.logo_dedicated_page_alt AS logo_dedicated_page_alt_19, t0.mail AS mail_20, t0.tel AS tel_21, t0.fifth_service AS fifth_service_22, t0.seo_title AS seo_title_23, t0.seo_description AS seo_description_24, t0.adresse AS adresse_25, t0.ville AS ville_26, t0.code_postal AS code_postal_27, t0.link AS link_28, t0.etoiles AS etoiles_29 FROM hotel t0
Parameters:
[]
2 0.80 ms
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.home_image AS home_image_3, t0.name AS name_4, t0.description AS description_5, t0.home_image_alt AS home_image_alt_6, t0.color AS color_7, t0.service_first_line AS service_first_line_8, t0.service_second_line AS service_second_line_9, t0.service_third_line AS service_third_line_10, t0.service_fourth_line AS service_fourth_line_11, t0.slug AS slug_12, t0.background_image AS background_image_13, t0.plaquette AS plaquette_14, t0.seminaire_background_image AS seminaire_background_image_15, t0.seminaire_text AS seminaire_text_16, t0.seminaire_plaquette AS seminaire_plaquette_17, t0.logo_dedicated_page AS logo_dedicated_page_18, t0.logo_dedicated_page_alt AS logo_dedicated_page_alt_19, t0.mail AS mail_20, t0.tel AS tel_21, t0.fifth_service AS fifth_service_22, t0.seo_title AS seo_title_23, t0.seo_description AS seo_description_24, t0.adresse AS adresse_25, t0.ville AS ville_26, t0.code_postal AS code_postal_27, t0.link AS link_28, t0.etoiles AS etoiles_29 FROM hotel t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "the-originals-city"
]
3 1.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.have_shower AS have_shower_4, t0.have_tv AS have_tv_5, t0.have_air_dryer AS have_air_dryer_6, t0.url AS url_7, t0.price AS price_8, t0.personne AS personne_9, t0.surface AS surface_10, t0.lit AS lit_11, t0.hotel_id AS hotel_id_12 FROM chambre t0 WHERE t0.hotel_id = ?
Parameters:
[
  1
]
4 1.53 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3 FROM chambre_image t0 INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id WHERE chambre_image_chambre.chambre_id = ?
Parameters:
[
  1
]
5 0.62 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3 FROM chambre_image t0 INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id WHERE chambre_image_chambre.chambre_id = ?
Parameters:
[
  8
]
6 0.49 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3 FROM chambre_image t0 INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id WHERE chambre_image_chambre.chambre_id = ?
Parameters:
[
  9
]
7 0.57 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3 FROM chambre_image t0 INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id WHERE chambre_image_chambre.chambre_id = ?
Parameters:
[
  10
]
8 0.53 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3 FROM chambre_image t0 INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id WHERE chambre_image_chambre.chambre_id = ?
Parameters:
[
  11
]
9 1.59 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.image_alt AS image_alt_4, t0.text AS text_5, t0.name AS name_6 FROM service_equipement t0 INNER JOIN service_equipement_hotel ON t0.id = service_equipement_hotel.service_equipement_id WHERE service_equipement_hotel.hotel_id = ?
Parameters:
[
  1
]
10 1.40 ms
SELECT t0.id AS id_1, t0.svg AS svg_2, t0.title AS title_3, t0.text AS text_4 FROM service_picto t0 INNER JOIN service_picto_hotel ON t0.id = service_picto_hotel.service_picto_id WHERE service_picto_hotel.hotel_id = ?
Parameters:
[
  1
]
11 1.46 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_alt AS image_alt_3 FROM offre_seminaire t0 INNER JOIN offre_seminaire_hotel ON t0.id = offre_seminaire_hotel.offre_seminaire_id WHERE offre_seminaire_hotel.hotel_id = ?
Parameters:
[
  1
]
12 0.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.commentaire AS commentaire_3, t0.provenance AS provenance_4, t0.hotel_id AS hotel_id_5 FROM avis t0 WHERE t0.hotel_id = ?
Parameters:
[
  1
]

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\Hotel No errors.
App\Entity\Service No errors.
App\Entity\Chambre No errors.
App\Entity\ServiceEquipement No errors.
App\Entity\ServicePicto No errors.
App\Entity\OffreSeminaire No errors.
App\Entity\Avis No errors.
App\Entity\ServiceLine No errors.
App\Entity\ChambreImage No errors.