Symfony Profiler

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_.selection_aad = 1
ORDER BY
  p0_.modifier_le DESC,
  p0_.nom ASC
LIMIT
  12
OFFSET
  24

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 = 'Vinyles' AND p0_.selection_aad = 1 ORDER BY p0_.modifier_le DESC, p0_.nom ASC LIMIT 12 OFFSET 24;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.information_complementaire AS information_complementaire_2,
  p0_.description AS description_3,
  p0_.prix_vente AS prix_vente_4,
  p0_.delai_livraison AS delai_livraison_5,
  p0_.musicien_orchestre AS musicien_orchestre_6,
  p0_.son_music AS son_music_7,
  p0_.grammage_music AS grammage_music_8,
  p0_.rpm_music AS rpm_music_9,
  p0_.lps_music AS lps_music_10,
  p0_.set_box_music AS set_box_music_11,
  p0_.limited_edition AS limited_edition_12,
  p0_.pre_commande AS pre_commande_13,
  p0_.selection_aad AS selection_aad_14,
  p0_.extrait_youtube AS extrait_youtube_15,
  p0_.reference_produit AS reference_produit_16,
  p0_.titre_morceau AS titre_morceau_17,
  p0_.produit_teste_par AS produit_teste_par_18,
  p0_.adresse_internet_test AS adresse_internet_test_19,
  p0_.poids AS poids_20,
  p0_.unite AS unite_21,
  p0_.caracteristique AS caracteristique_22,
  p0_.enregistre_le AS enregistre_le_23,
  p0_.modifier_le AS modifier_le_24,
  p0_.categorie AS categorie_25,
  p0_.disponible AS disponible_26,
  p0_.terminer AS terminer_27,
  p0_.info_master_tape AS info_master_tape_28,
  p0_.slug AS slug_29,
  p1_.id AS id_30,
  p1_.nom AS nom_31,
  p1_.fichier AS fichier_32,
  p1_.extention AS extention_33,
  p1_.ordre AS ordre_34,
  p1_.taille AS taille_35,
  p1_.modifier_le AS modifier_le_36,
  p0_.id_artiste AS id_artiste_37,
  p0_.id_label AS id_label_38,
  p0_.id_style AS id_style_39,
  p0_.id_type_master_tape AS id_type_master_tape_40,
  p0_.id_marque AS id_marque_41,
  p0_.id_type_materiel AS id_type_materiel_42,
  p0_.id_type_accessoire AS id_type_accessoire_43,
  p1_.id_produit AS id_produit_44
FROM
  produit p0_
  LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit
WHERE
  p0_.categorie = ?
  AND p0_.selection_aad = 1
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.modifier_le DESC,
  p0_.nom ASC,
  p1_.ordre ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.information_complementaire AS information_complementaire_2, p0_.description AS description_3, p0_.prix_vente AS prix_vente_4, p0_.delai_livraison AS delai_livraison_5, p0_.musicien_orchestre AS musicien_orchestre_6, p0_.son_music AS son_music_7, p0_.grammage_music AS grammage_music_8, p0_.rpm_music AS rpm_music_9, p0_.lps_music AS lps_music_10, p0_.set_box_music AS set_box_music_11, p0_.limited_edition AS limited_edition_12, p0_.pre_commande AS pre_commande_13, p0_.selection_aad AS selection_aad_14, p0_.extrait_youtube AS extrait_youtube_15, p0_.reference_produit AS reference_produit_16, p0_.titre_morceau AS titre_morceau_17, p0_.produit_teste_par AS produit_teste_par_18, p0_.adresse_internet_test AS adresse_internet_test_19, p0_.poids AS poids_20, p0_.unite AS unite_21, p0_.caracteristique AS caracteristique_22, p0_.enregistre_le AS enregistre_le_23, p0_.modifier_le AS modifier_le_24, p0_.categorie AS categorie_25, p0_.disponible AS disponible_26, p0_.terminer AS terminer_27, p0_.info_master_tape AS info_master_tape_28, p0_.slug AS slug_29, p1_.id AS id_30, p1_.nom AS nom_31, p1_.fichier AS fichier_32, p1_.extention AS extention_33, p1_.ordre AS ordre_34, p1_.taille AS taille_35, p1_.modifier_le AS modifier_le_36, p0_.id_artiste AS id_artiste_37, p0_.id_label AS id_label_38, p0_.id_style AS id_style_39, p0_.id_type_master_tape AS id_type_master_tape_40, p0_.id_marque AS id_marque_41, p0_.id_type_materiel AS id_type_materiel_42, p0_.id_type_accessoire AS id_type_accessoire_43, p1_.id_produit AS id_produit_44 FROM produit p0_ LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit WHERE p0_.categorie = 'Vinyles' AND p0_.selection_aad = 1 AND p0_.id IN (2621, 2522, 2637, 2596, 2642, 2653, 2592, 2590, 2940, 2184, 2537, 2553) ORDER BY p0_.modifier_le DESC, p0_.nom ASC, p1_.ordre ASC;

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

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

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
  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
  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_.selection_aad = 1

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 = 'Vinyles' AND p0_.selection_aad = 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

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;

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.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
  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;