Query Metrics

20 Database Queries
15 Different statements
3.08 ms Query time
0 Invalid entities
47 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.49 ms
(15.95%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.information_complementaire AS information_complementaire_3, t0.description AS description_4, t0.prix_vente AS prix_vente_5, t0.delai_livraison AS delai_livraison_6, t0.musicien_orchestre AS musicien_orchestre_7, t0.son_music AS son_music_8, t0.grammage_music AS grammage_music_9, t0.rpm_music AS rpm_music_10, t0.lps_music AS lps_music_11, t0.set_box_music AS set_box_music_12, t0.limited_edition AS limited_edition_13, t0.pre_commande AS pre_commande_14, t0.selection_aad AS selection_aad_15, t0.extrait_youtube AS extrait_youtube_16, t0.reference_produit AS reference_produit_17, t0.titre_morceau AS titre_morceau_18, t0.produit_teste_par AS produit_teste_par_19, t0.adresse_internet_test AS adresse_internet_test_20, t0.poids AS poids_21, t0.unite AS unite_22, t0.caracteristique AS caracteristique_23, t0.enregistre_le AS enregistre_le_24, t0.modifier_le AS modifier_le_25, t0.categorie AS categorie_26, t0.disponible AS disponible_27, t0.terminer AS terminer_28, t0.info_master_tape AS info_master_tape_29, t0.slug AS slug_30, t0.id_artiste AS id_artiste_31, t0.id_label AS id_label_32, t0.id_style AS id_style_33, t0.id_type_master_tape AS id_type_master_tape_34, t0.id_marque AS id_marque_35, t0.id_type_materiel AS id_type_materiel_36, t0.id_type_accessoire AS id_type_accessoire_37 FROM produit t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "vinyles-birdy-numbered-limited-edition-half-speed-remastered-real-world-records-5095-456"
]
0.38 ms
(12.25%)
1
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:
[
  1567
]
0.34 ms
(11.12%)
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.27 ms
(8.91%)
2
SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = ?
Parameters:
[
  0
]
0.23 ms
(7.39%)
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.22 ms
(7.24%)
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.21 ms
(6.90%)
2
SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = ?
Parameters:
[
  0
]
0.15 ms
(4.77%)
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.14 ms
(4.61%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.nom ASC LIMIT 30
Parameters:
[]
0.12 ms
(4.02%)
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:
[]
0.12 ms
(3.79%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = ?
Parameters:
[
  41
]
0.11 ms
(3.70%)
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
(3.30%)
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.10 ms
(3.22%)
1
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:
[
  1567
]
0.09 ms
(2.85%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM label t0 WHERE t0.id = ?
Parameters:
[
  94
]

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\Style 29
App\Entity\Pays 11
App\Entity\ParametreSite 1
App\Entity\Adresse 1
App\Entity\Produit 1
App\Entity\Artiste 1
App\Entity\Label 1
App\Entity\SaleSetting 1
App\Entity\PhotoProduit 1