GET https://reservation.complexehotelierlabonte.com/

Query Metrics

10 Database Queries
6 Different statements
3.89 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.29 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.titre AS titre_3, t0.btn AS btn_4, t0.lien AS lien_5 FROM slider t0
Parameters:
[]
2 0.53 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.reference_manuel = ? LIMIT 1
Parameters:
[
  "S0000011"
]
3 0.22 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.reference_manuel = ? LIMIT 1
Parameters:
[
  "S00000001"
]
4 0.27 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.reference_manuel = ? LIMIT 1
Parameters:
[
  "S0000002"
]
5 0.14 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.reference_manuel = ? LIMIT 1
Parameters:
[
  "S0000004"
]
6 0.14 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.reference_manuel = ? LIMIT 1
Parameters:
[
  "S0000008"
]
7 0.14 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.image AS image_4, t0.featured AS featured_5, t0.image_service AS image_service_6, t0.slug AS slug_7, t0.reference_systeme AS reference_systeme_8, t0.reference_manuel AS reference_manuel_9, t0.cree_le AS cree_le_10, t0.modifie_le AS modifie_le_11 FROM services t0 WHERE t0.featured = ?
Parameters:
[
  1
]
8 0.58 ms
SELECT p0_.id AS id_0, p0_.prix AS prix_1, p0_.stock AS stock_2, p0_.qte_vendu AS qte_vendu_3, p0_.qte_approvisionne AS qte_approvisionne_4, p0_.qte_retourne AS qte_retourne_5, p0_.nb_reportion AS nb_reportion_6, p0_.stock_en_portion AS stock_en_portion_7, p0_.reference_systeme AS reference_systeme_8, p0_.reference_manuel AS reference_manuel_9, p0_.cree_le AS cree_le_10, p0_.modifie_le AS modifie_le_11, p0_.service_id AS service_id_12, p0_.produit_id AS produit_id_13 FROM prix_aapplique p0_ INNER JOIN produit p1_ ON p0_.produit_id = p1_.id INNER JOIN famille f2_ ON p1_.famille_id = f2_.id INNER JOIN services s3_ ON p0_.service_id = s3_.id WHERE s3_.reference_manuel = ? LIMIT 5
Parameters:
[
  "S0000011"
]
9 0.31 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.slogan AS slogan_3, t0.description AS description_4, t0.photo AS photo_5, t0.video AS video_6 FROM presentation t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.28 ms
SELECT t0.id AS id_1, t0.icone AS icone_2, t0.titre AS titre_3, t0.description AS description_4, t0.is_active AS is_active_5 FROM facilities t0 WHERE t0.is_active = ?
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.