GET https://complexehotelierlabonte.com/

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.95 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.33 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.16 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.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:
[
  "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.16 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.15 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.48 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.23 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.21 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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
App\Entity\Slider No errors.
App\Entity\Services No errors.
App\Entity\PrixAApplique No errors.
App\Entity\Produit No errors.
App\Entity\Famille No errors.
App\Entity\Presentation No errors.
App\Entity\Facilities No errors.