GET https://preprod.audioanalogdistribution.com/produit/Mat%C3%A9riel%20HiFi/marque/black-forest-audio

Query Metrics

22 Database Queries
17 Different statements
3.24 ms Query time
0 Invalid entities
45 Managed entities

Queries

Group similar statements

# Time Info
1 0.18 ms
SELECT t0.id AS id_1, t0.telephone_portable AS telephone_portable_2, t0.telephone_fixe AS telephone_fixe_3, t0.mail_contact AS mail_contact_4, t0.mail_newsletter AS mail_newsletter_5, t0.representant AS representant_6, t0.raison_social AS raison_social_7, t0.maintenance_mode AS maintenance_mode_8, t0.id_adresse AS id_adresse_9 FROM parametre_site t0 LIMIT 1
Parameters:
[]
2 0.10 ms
"START TRANSACTION"
Parameters:
[]
3 0.20 ms
INSERT INTO visiteur (ip, enregistre_le) VALUES (?, ?)
Parameters:
[
  "216.73.216.232"
  "2026-05-19 13:06:44"
]
4 0.32 ms
"COMMIT"
Parameters:
[]
5 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM marque t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "black-forest-audio"
]
6 0.12 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM marque t0 ORDER BY t0.nom ASC LIMIT 15
Parameters:
[]
7 0.09 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM type_materiel t0 ORDER BY t0.nom ASC LIMIT 15
Parameters:
[]
8 0.31 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM produit p0_ LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit WHERE p0_.categorie = ? AND p0_.id_marque = ?
Parameters:
[
  "Matériel HiFi"
  24
]
9 0.25 ms
SELECT DISTINCT p0_.id AS id_0, p0_.modifier_le AS modifier_le_1, p0_.nom AS nom_2 FROM produit p0_ LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit WHERE p0_.categorie = ? AND p0_.id_marque = ? ORDER BY p0_.modifier_le DESC, p0_.nom ASC LIMIT 12
Parameters:
[
  "Matériel HiFi"
  24
]
10 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.vat_rate AS vat_rate_3, t0.email AS email_4, t0.shipping_fee AS shipping_fee_5, t0.delivery_time AS delivery_time_6, t0.public_key AS public_key_7, t0.private_key AS private_key_8, t0.webhook_secret AS webhook_secret_9, t0.updated_at AS updated_at_10 FROM sale_setting t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "GLOBAL"
]
11 0.09 ms
SELECT t0.id AS id_1, t0.telephone_portable AS telephone_portable_2, t0.telephone_fixe AS telephone_fixe_3, t0.mail_contact AS mail_contact_4, t0.mail_newsletter AS mail_newsletter_5, t0.representant AS representant_6, t0.raison_social AS raison_social_7, t0.maintenance_mode AS maintenance_mode_8, t0.id_adresse AS id_adresse_9 FROM parametre_site t0 LIMIT 1
Parameters:
[]
12 0.18 ms
SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = ?
Parameters:
[
  0
]
13 0.09 ms
SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = ?
Parameters:
[
  0
]
14 0.09 ms
SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = ?
Parameters:
[
  0
]
15 0.07 ms
SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = ?
Parameters:
[
  0
]
16 0.14 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.code_iso2 AS code_iso2_2, p0_.code_iso3 AS code_iso3_3, p0_.slug AS slug_4 FROM pays p0_ LIMIT 10
Parameters:
[]
17 0.10 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.prix AS prix_3, t0.temps AS temps_4, t0.id_pays AS id_pays_5 FROM frais_livraison t0 WHERE t0.id_pays IS NULL LIMIT 1
Parameters:
[]
18 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.vat_rate AS vat_rate_3, t0.email AS email_4, t0.shipping_fee AS shipping_fee_5, t0.delivery_time AS delivery_time_6, t0.public_key AS public_key_7, t0.private_key AS private_key_8, t0.webhook_secret AS webhook_secret_9, t0.updated_at AS updated_at_10 FROM sale_setting t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "GLOBAL"
]
19 0.11 ms
SELECT t0.id AS id_1, t0.enregistre_le AS enregistre_le_2, t0.modifier_le AS modifier_le_3, t0.total_ht AS total_ht_4, t0.nombre_total AS nombre_total_5, t0.total_tva AS total_tva_6, t0.total_ttc AS total_ttc_7, t0.id_client AS id_client_8 FROM panier t0 WHERE t0.id = ?
Parameters:
[
  0
]
20 0.08 ms
SELECT t0.id AS id_1, t0.enregistre_le AS enregistre_le_2, t0.modifier_le AS modifier_le_3, t0.total_ht AS total_ht_4, t0.nombre_total AS nombre_total_5, t0.total_tva AS total_tva_6, t0.total_ttc AS total_ttc_7, t0.id_client AS id_client_8 FROM panier t0 WHERE t0.id = ?
Parameters:
[
  0
]
21 0.12 ms
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.societe AS societe_4, t0.libelle AS libelle_5, t0.complement AS complement_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.par_defaut AS par_defaut_9, t0.enregistre_le AS enregistre_le_10, t0.modifier_le AS modifier_le_11, t0.telephone_portable AS telephone_portable_12, t0.telephone_fixe AS telephone_fixe_13, t0.type AS type_14, t0.id_pays AS id_pays_15, t0.id_utilisateur AS id_utilisateur_16 FROM adresse t0 WHERE t0.id = ?
Parameters:
[
  1118
]
22 0.11 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_iso2 AS code_iso2_3, t0.code_iso3 AS code_iso3_4, t0.slug AS slug_5 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  37
]

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
App\Entity\Marque 15
App\Entity\TypeMateriel 15
App\Entity\Pays 11
App\Entity\ParametreSite 1
App\Entity\Adresse 1
App\Entity\Visiteur 1
App\Entity\SaleSetting 1

Entities Mapping