Query Metrics

60 Database Queries
19 Different statements
9.43 ms Query time
0 Invalid entities
89 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.43 ms
(25.80%)
13
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fichier AS fichier_3, t0.extention AS extention_4, t0.ordre AS ordre_5, t0.taille AS taille_6, t0.modifier_le AS modifier_le_7, t0.id_produit AS id_produit_8 FROM photo_produit t0 WHERE t0.id_produit = ? ORDER BY t0.ordre ASC
Parameters:
[
  414
]
1.30 ms
(13.77%)
13
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  158
]
1.27 ms
(13.46%)
1
SELECT l0_.id AS id_0, l0_.envoyer AS envoyer_1, l0_.ordre AS ordre_2, p1_.id AS id_3, p1_.nom AS nom_4, p1_.information_complementaire AS information_complementaire_5, p1_.description AS description_6, p1_.prix_vente AS prix_vente_7, p1_.delai_livraison AS delai_livraison_8, p1_.musicien_orchestre AS musicien_orchestre_9, p1_.son_music AS son_music_10, p1_.grammage_music AS grammage_music_11, p1_.rpm_music AS rpm_music_12, p1_.lps_music AS lps_music_13, p1_.set_box_music AS set_box_music_14, p1_.limited_edition AS limited_edition_15, p1_.pre_commande AS pre_commande_16, p1_.selection_aad AS selection_aad_17, p1_.extrait_youtube AS extrait_youtube_18, p1_.reference_produit AS reference_produit_19, p1_.titre_morceau AS titre_morceau_20, p1_.produit_teste_par AS produit_teste_par_21, p1_.adresse_internet_test AS adresse_internet_test_22, p1_.poids AS poids_23, p1_.unite AS unite_24, p1_.caracteristique AS caracteristique_25, p1_.enregistre_le AS enregistre_le_26, p1_.modifier_le AS modifier_le_27, p1_.categorie AS categorie_28, p1_.disponible AS disponible_29, p1_.terminer AS terminer_30, p1_.info_master_tape AS info_master_tape_31, p1_.slug AS slug_32, l0_.id_newsletter AS id_newsletter_33, l0_.id_produit AS id_produit_34, p1_.id_artiste AS id_artiste_35, p1_.id_label AS id_label_36, p1_.id_style AS id_style_37, p1_.id_type_master_tape AS id_type_master_tape_38, p1_.id_marque AS id_marque_39, p1_.id_type_materiel AS id_type_materiel_40, p1_.id_type_accessoire AS id_type_accessoire_41 FROM ligne_newsletter l0_ INNER JOIN produit p1_ ON l0_.id_produit = p1_.id WHERE l0_.id_newsletter = ? AND l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p1_.enregistre_le DESC
Parameters:
[
  5
  912
  911
  910
  909
  908
  907
  906
  905
  904
  903
  902
  901
  900
]
1.19 ms
(12.63%)
13
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.poids AS poids_4, t0.unite AS unite_5, t0.id_produit AS id_produit_6, t0.id_attribute AS id_attribute_7 FROM option_prix t0 WHERE t0.id_produit = ?
Parameters:
[
  414
]
0.37 ms
(3.93%)
1
SELECT count(DISTINCT l0_.id) AS sclr_0 FROM ligne_newsletter l0_ INNER JOIN produit p1_ ON l0_.id_produit = p1_.id WHERE l0_.id_newsletter = ?
Parameters:
[
  5
]
0.33 ms
(3.49%)
1
"COMMIT"
Parameters:
[]
0.32 ms
(3.36%)
2
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:
[]
0.29 ms
(3.07%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.enregistre_le AS enregistre_le_3, t0.modifier_le AS modifier_le_4, t0.envoyer AS envoyer_5, t0.statut AS statut_6, t0.slug AS slug_7, t0.description AS description_8 FROM newsletter t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "nos-disques-vinyles-classic-records-sont-des-editions-desormais-introuvables-souvent-tirees-en-quantites-ultra-limitees-et-pour-certains-pressees-en-clarity-vinyl-quiex-sv-p-ii-un-son-d-une-purete-exceptionnelle-pour-audiophiles-exigeants"
]
0.29 ms
(3.03%)
1
SELECT DISTINCT l0_.id AS id_0, p1_.enregistre_le AS enregistre_le_1 FROM ligne_newsletter l0_ INNER JOIN produit p1_ ON l0_.id_produit = p1_.id WHERE l0_.id_newsletter = ? ORDER BY p1_.enregistre_le DESC LIMIT 15 OFFSET 15
Parameters:
[
  5
]
0.26 ms
(2.71%)
2
SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = ?
Parameters:
[
  0
]
0.24 ms
(2.49%)
2
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"
]
0.23 ms
(2.42%)
1
INSERT INTO visiteur (ip, enregistre_le) VALUES (?, ?)
Parameters:
[
  "216.73.216.232"
  "2026-05-19 14:05:28"
]
0.19 ms
(2.01%)
2
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
]
0.18 ms
(1.88%)
2
SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = ?
Parameters:
[
  0
]
0.14 ms
(1.52%)
1
"START TRANSACTION"
Parameters:
[]
0.12 ms
(1.22%)
1
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:
[]
0.11 ms
(1.19%)
1
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
]
0.10 ms
(1.05%)
1
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
]
0.09 ms
(0.97%)
1
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:
[]

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\PhotoProduit 28
App\Entity\LigneNewsletter 13
App\Entity\Produit 13
App\Entity\Artiste 13
App\Entity\Pays 11
App\Entity\Style 5
App\Entity\ParametreSite 1
App\Entity\Adresse 1
App\Entity\Visiteur 1
App\Entity\Newsletter 1
App\Entity\Label 1
App\Entity\SaleSetting 1