Query Metrics

52 Database Queries
19 Different statements
9.91 ms Query time
0 Invalid entities
89 Managed entities

Queries

Group similar statements

# Time Info
1 0.14 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.12 ms
"START TRANSACTION"
Parameters:
[]
3 0.20 ms
INSERT INTO visiteur (ip, enregistre_le) VALUES (?, ?)
Parameters:
[
  "216.73.216.232"
  "2026-05-19 13:04:50"
]
4 0.38 ms
"COMMIT"
Parameters:
[]
5 0.30 ms
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:
[
  "sur-audio-analogue-distribution-parcourez-une-selection-de-disques-recemment-arrives-et-d-editions-rares-pressees-avec-soin-le-son-analogique-sublime-pour-les-puristes-sans-compromis-pour-tous"
]
6 0.46 ms
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:
[
  7
]
7 0.27 ms
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
Parameters:
[
  7
]
8 1.38 ms
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:
[
  7
  1007
  1006
  1005
  1004
  1003
  1002
  1001
  1000
  999
  998
  997
]
9 0.13 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"
]
10 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:
[]
11 0.17 ms
SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = ?
Parameters:
[
  0
]
12 0.12 ms
SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = ?
Parameters:
[
  0
]
13 0.10 ms
SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = ?
Parameters:
[
  0
]
14 0.08 ms
SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = ?
Parameters:
[
  0
]
15 0.12 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:
[]
16 0.09 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:
[]
17 0.11 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"
]
18 0.10 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
]
19 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
]
20 0.39 ms
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:
[
  2962
]
21 0.17 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  1311
]
22 0.21 ms
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:
[
  2962
]
23 0.21 ms
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:
[
  2961
]
24 0.17 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  1310
]
25 0.21 ms
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:
[
  2961
]
26 0.21 ms
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:
[
  2960
]
27 0.18 ms
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:
[
  2960
]
28 0.19 ms
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:
[
  2959
]
29 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  1309
]
30 0.09 ms
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:
[
  2959
]
31 0.19 ms
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:
[
  2958
]
32 0.10 ms
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:
[
  2958
]
33 0.19 ms
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:
[
  2934
]
34 0.16 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  652
]
35 0.20 ms
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:
[
  2934
]
36 0.20 ms
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:
[
  2931
]
37 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  302
]
38 0.21 ms
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:
[
  2931
]
39 0.19 ms
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:
[
  2927
]
40 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  1295
]
41 0.10 ms
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:
[
  2927
]
42 0.18 ms
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:
[
  2926
]
43 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  101
]
44 0.18 ms
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:
[
  2926
]
45 0.18 ms
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:
[
  2902
]
46 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  245
]
47 0.10 ms
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:
[
  2902
]
48 0.18 ms
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:
[
  838
]
49 0.10 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  318
]
50 0.21 ms
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:
[
  838
]
51 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
]
52 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\PhotoProduit 34
App\Entity\LigneNewsletter 11
App\Entity\Produit 11
App\Entity\Pays 11
App\Entity\Artiste 9
App\Entity\Label 4
App\Entity\Style 4
App\Entity\ParametreSite 1
App\Entity\Adresse 1
App\Entity\Visiteur 1
App\Entity\Newsletter 1
App\Entity\SaleSetting 1