GET https://reservation.complexehotelierlabonte.com/hebergement/TA00000003

Query Metrics

12 Database Queries
4 Different statements
2.45 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.47 ms
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1, f0_.numero_s AS numero_s_2, f0_.description AS description_3, f0_.supprimer AS supprimer_4, f0_.urlimage AS urlimage_5, f0_.slug AS slug_6, f0_.reference_systeme AS reference_systeme_7, f0_.reference_manuel AS reference_manuel_8, f0_.cree_le AS cree_le_9, f0_.modifie_le AS modifie_le_10 FROM famille f0_ WHERE f0_.slug = ? OR f0_.reference_manuel = ?
Parameters:
[
  "TA00000003"
  "TA00000003"
]
2 0.23 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.libelle = ? LIMIT 1
Parameters:
[
  "HEBERGEMENT"
]
3 0.54 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, s1_.id AS id_12, s1_.libelle AS libelle_13, s1_.description AS description_14, s1_.image AS image_15, s1_.featured AS featured_16, s1_.image_service AS image_service_17, s1_.slug AS slug_18, s1_.reference_systeme AS reference_systeme_19, s1_.reference_manuel AS reference_manuel_20, s1_.cree_le AS cree_le_21, s1_.modifie_le AS modifie_le_22, p2_.id AS id_23, p2_.libelle AS libelle_24, p2_.prix_ht AS prix_ht_25, p2_.prix_achat AS prix_achat_26, p2_.description AS description_27, p2_.code_barre AS code_barre_28, p2_.code_barre_fournisseur AS code_barre_fournisseur_29, p2_.stock_actuel AS stock_actuel_30, p2_.qte_reapprovissement AS qte_reapprovissement_31, p2_.qte_mini AS qte_mini_32, p2_.qte_vente AS qte_vente_33, p2_.qte_rebus AS qte_rebus_34, p2_.prix_revient AS prix_revient_35, p2_.est_matiere_premiere AS est_matiere_premiere_36, p2_.est_stockable AS est_stockable_37, p2_.est_disponible AS est_disponible_38, p2_.unite AS unite_39, p2_.unite_detail AS unite_detail_40, p2_.nbre_unite AS nbre_unite_41, p2_.stock_alerte AS stock_alerte_42, p2_.reference_systeme AS reference_systeme_43, p2_.reference_manuel AS reference_manuel_44, p2_.cree_le AS cree_le_45, p2_.modifie_le AS modifie_le_46, f3_.id AS id_47, f3_.libelle AS libelle_48, f3_.numero_s AS numero_s_49, f3_.description AS description_50, f3_.supprimer AS supprimer_51, f3_.urlimage AS urlimage_52, f3_.slug AS slug_53, f3_.reference_systeme AS reference_systeme_54, f3_.reference_manuel AS reference_manuel_55, f3_.cree_le AS cree_le_56, f3_.modifie_le AS modifie_le_57, p0_.service_id AS service_id_58, p0_.produit_id AS produit_id_59, p2_.famille_id AS famille_id_60 FROM prix_aapplique p0_ INNER JOIN services s1_ ON p0_.service_id = s1_.id INNER JOIN produit p2_ ON p0_.produit_id = p2_.id INNER JOIN famille f3_ ON p2_.famille_id = f3_.id WHERE p0_.service_id = ?
Parameters:
[
  b"\x01—»è¿6|u¬6Ú¸ãàŽv"
]
4 0.18 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01ù╗■,My&Ø\x1A\x18 dfv"
]
5 0.14 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01ù§rl¼v'░ë¤y,ÔØw"
]
6 0.12 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01˜\x1DÓ_lvw¥¹wÇ?Øûç"
]
7 0.12 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01ÿhË╔\x0Fy>ÅôâZ:y┬█"
]
8 0.12 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01ÿhı¸E}Ü┤\x7F\r¥ÅåùÒ"
]
9 0.13 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"""
    \x01ÿhÎ└fsËì░\n
    Í»i■\x0E
    """
]
10 0.14 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01˜tÍõÇ\x7FÒŽ\x14ýÃ#ý§á"
]
11 0.13 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01˜~£&Zrg¦.\x04’\†r{"
]
12 0.12 ms
SELECT t0.id AS id_1, t0.qte_en_stock AS qte_en_stock_2, t0.auteur_modif AS auteur_modif_3, t0.date_modif AS date_modif_4, t0.produit_id AS produit_id_5 FROM stock t0 WHERE t0.produit_id = ?
Parameters:
[
  b"\x01˜~£ðâzâ²›gd*- \x00"
]

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.