Symfony Profiler

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

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 = 3038 ORDER BY t0.ordre ASC;

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

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 = 11 AND l0_.id IN (1098, 1097, 1096, 1095, 1094, 1093, 1092, 1091, 1090, 1089) ORDER BY p1_.enregistre_le DESC;

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 = ?

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 = 3038;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3
FROM
  artiste t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM artiste t0 WHERE t0.id = 143;

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

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 = 'du-raffinement-de-bill-evans-a-l-intensite-de-thelonious-monk-en-passant-par-les-grooves-de-kool-the-gang-et-l-energie-des-temptations-cette-selection-reunit-des-albums-incontournables-entre-elegance-chaleur-et-vibrations-authentiques' LIMIT 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 = ?

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 = 11;

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

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 = 11 ORDER BY p1_.enregistre_le DESC LIMIT 15;

SELECT
  COUNT(*)
FROM
  ligne_favori t0
WHERE
  t0.id_favori = ?

SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = 0;

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

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 = 'GLOBAL' LIMIT 1;

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

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;

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 = ?

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 = 0;

SELECT
  COUNT(*)
FROM
  ligne_panier t0
WHERE
  t0.id_panier = ?

SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = 0;

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 = ?

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 = 37;

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

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;

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 = ?

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 = 1118;

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

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;