Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username_user AS username_user_2,
  t0.nom_user AS nom_user_3,
  t0.prenoms_user AS prenoms_user_4,
  t0.email_user AS email_user_5,
  t0.tel1_user AS tel1_user_6,
  t0.tel2_user AS tel2_user_7,
  t0.bp AS bp_8,
  t0.adresse_user AS adresse_user_9,
  t0.etat_user AS etat_user_10,
  t0.attempt_user AS attempt_user_11,
  t0.password_user AS password_user_12,
  t0.c_password_user AS c_password_user_13,
  t0.salt_user AS salt_user_14,
  t0.etat_connecte AS etat_connecte_15,
  t0.adresse_ip_user AS adresse_ip_user_16,
  t0.sexe_user AS sexe_user_17,
  t0.date_ajout_user AS date_ajout_user_18,
  t0.date_edit_user AS date_edit_user_19,
  t0.loss_password_url_user AS loss_password_url_user_20,
  t0.date_loss_password_user AS date_loss_password_user_21,
  t0.date_naissance AS date_naissance_22,
  t0.date_synchronisation AS date_synchronisation_23,
  t0.type_prod_user AS type_prod_user_24,
  t0.si_chef AS si_chef_25,
  t0.code_genere AS code_genere_26,
  t0.site_web AS site_web_27,
  t0.cni AS cni_28,
  t0.cout AS cout_29,
  t0.commission AS commission_30,
  t0.type_utilisateur AS type_utilisateur_31,
  t0.roles AS roles_32,
  t0.profil_id AS profil_id_33,
  t0.ville_id AS ville_id_34,
  t0.entrepot_id AS entrepot_id_35,
  t0.caisse_id AS caisse_id_36,
  t0.abonne_id AS abonne_id_37
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.id = 23270;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.valeur AS valeur_3,
  t0.type_donnee AS type_donnee_4,
  t0.libelle AS libelle_5,
  t0.description AS description_6,
  t0.type_param AS type_param_7,
  t0.affiche AS affiche_8
FROM
  param t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.valeur AS valeur_3, t0.type_donnee AS type_donnee_4, t0.libelle AS libelle_5, t0.description AS description_6, t0.type_param AS type_param_7, t0.affiche AS affiche_8 FROM param t0 WHERE t0.nom = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_connexion AS date_connexion_2,
  t0.date_last_action AS date_last_action_3,
  t0.date_deconnexion AS date_deconnexion_4,
  t0.adresse_ip AS adresse_ip_5,
  t0.tab_id_actions AS tab_id_actions_6,
  t0.tab_date_actions AS tab_date_actions_7,
  t0.duree_connexion AS duree_connexion_8,
  t0.utilisateur_id AS utilisateur_id_9
FROM
  connexion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_connexion AS date_connexion_2, t0.date_last_action AS date_last_action_3, t0.date_deconnexion AS date_deconnexion_4, t0.adresse_ip AS adresse_ip_5, t0.tab_id_actions AS tab_id_actions_6, t0.tab_date_actions AS tab_date_actions_7, t0.duree_connexion AS duree_connexion_8, t0.utilisateur_id AS utilisateur_id_9 FROM connexion t0 WHERE t0.id = 7289;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.controleur_id AS controleur_id_4,
  t0.module_id AS module_id_5,
  t0.abonne_id AS abonne_id_6
FROM
  action t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.controleur_id AS controleur_id_4, t0.module_id AS module_id_5, t0.abonne_id AS abonne_id_6 FROM action t0 WHERE t0.nom = '' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.valeur AS valeur_3,
  t0.type_donnee AS type_donnee_4,
  t0.libelle AS libelle_5,
  t0.description AS description_6,
  t0.type_param AS type_param_7,
  t0.affiche AS affiche_8
FROM
  param t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.valeur AS valeur_3, t0.type_donnee AS type_donnee_4, t0.libelle AS libelle_5, t0.description AS description_6, t0.type_param AS type_param_7, t0.affiche AS affiche_8 FROM param t0 WHERE t0.nom = 1 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.code_produit AS code_produit_1,
  p0_.nom_produit AS nom_produit_2,
  p0_.description_produit AS description_produit_3,
  p0_.poids_produit AS poids_produit_4,
  p0_.frais_affecte_produit AS frais_affecte_produit_5,
  p0_.marge_salariale_produit AS marge_salariale_produit_6,
  p0_.siSysteme AS siSysteme_7,
  p0_.siMelange AS siMelange_8,
  p0_.seuil_produit AS seuil_produit_9,
  p0_.en_stock_produit AS en_stock_produit_10,
  p0_.fabricat_produit AS fabricat_produit_11,
  p0_.date_publication AS date_publication_12,
  p0_.date_commer AS date_commer_13,
  p0_.date_modification AS date_modification_14,
  p0_.id_auteur AS id_auteur_15,
  p0_.etat_produit AS etat_produit_16,
  p0_.quantite_detail AS quantite_detail_17,
  p0_.etat_libelle AS etat_libelle_18,
  p0_.siEcommerce AS siEcommerce_19,
  p0_.montanthtAchat AS montanthtAchat_20,
  p0_.montanthtvente AS montanthtvente_21,
  p0_.tauxTva AS tauxTva_22,
  p0_.couleur_produit AS couleur_produit_23,
  p0_.montantttcvente AS montantttcvente_24,
  p0_.autretaxe AS autretaxe_25,
  p0_.si_conditionnement AS si_conditionnement_26,
  p0_.si_transformation AS si_transformation_27,
  p0_.si_vendable AS si_vendable_28,
  p0_.si_semence AS si_semence_29,
  p0_.rendement AS rendement_30,
  p0_.si_accueil AS si_accueil_31,
  p0_.titre_image AS titre_image_32,
  p0_.code_genere AS code_genere_33,
  p0_.si_agricole AS si_agricole_34,
  p0_.si_agricole_parent AS si_agricole_parent_35,
  p0_.type_saison AS type_saison_36,
  p0_.si_heritage AS si_heritage_37,
  p0_.type_qualite AS type_qualite_38,
  p0_.si_affichage AS si_affichage_39,
  p0_.url_image AS url_image_40,
  p0_.action_comptable AS action_comptable_41,
  p0_.code_barre AS code_barre_42,
  p0_.melange_id AS melange_id_43,
  p0_.categorie_id AS categorie_id_44,
  p0_.produit_id AS produit_id_45,
  p0_.compte AS compte_46,
  p0_.produitsysteme_id AS produitsysteme_id_47,
  p0_.carateristiqueproduit_id AS carateristiqueproduit_id_48,
  p0_.unite_id AS unite_id_49,
  p0_.abonne_id AS abonne_id_50
FROM
  produit p0_
  INNER JOIN produit_abonne p1_ ON p0_.id = p1_.produit_id
  INNER JOIN abonne a2_ ON p1_.abonne_id = a2_.id
WHERE
  p0_.si_agricole = ?
  AND p0_.si_agricole_parent <> ?
  AND a2_.id = ?

SELECT p0_.id AS id_0, p0_.code_produit AS code_produit_1, p0_.nom_produit AS nom_produit_2, p0_.description_produit AS description_produit_3, p0_.poids_produit AS poids_produit_4, p0_.frais_affecte_produit AS frais_affecte_produit_5, p0_.marge_salariale_produit AS marge_salariale_produit_6, p0_.siSysteme AS siSysteme_7, p0_.siMelange AS siMelange_8, p0_.seuil_produit AS seuil_produit_9, p0_.en_stock_produit AS en_stock_produit_10, p0_.fabricat_produit AS fabricat_produit_11, p0_.date_publication AS date_publication_12, p0_.date_commer AS date_commer_13, p0_.date_modification AS date_modification_14, p0_.id_auteur AS id_auteur_15, p0_.etat_produit AS etat_produit_16, p0_.quantite_detail AS quantite_detail_17, p0_.etat_libelle AS etat_libelle_18, p0_.siEcommerce AS siEcommerce_19, p0_.montanthtAchat AS montanthtAchat_20, p0_.montanthtvente AS montanthtvente_21, p0_.tauxTva AS tauxTva_22, p0_.couleur_produit AS couleur_produit_23, p0_.montantttcvente AS montantttcvente_24, p0_.autretaxe AS autretaxe_25, p0_.si_conditionnement AS si_conditionnement_26, p0_.si_transformation AS si_transformation_27, p0_.si_vendable AS si_vendable_28, p0_.si_semence AS si_semence_29, p0_.rendement AS rendement_30, p0_.si_accueil AS si_accueil_31, p0_.titre_image AS titre_image_32, p0_.code_genere AS code_genere_33, p0_.si_agricole AS si_agricole_34, p0_.si_agricole_parent AS si_agricole_parent_35, p0_.type_saison AS type_saison_36, p0_.si_heritage AS si_heritage_37, p0_.type_qualite AS type_qualite_38, p0_.si_affichage AS si_affichage_39, p0_.url_image AS url_image_40, p0_.action_comptable AS action_comptable_41, p0_.code_barre AS code_barre_42, p0_.melange_id AS melange_id_43, p0_.categorie_id AS categorie_id_44, p0_.produit_id AS produit_id_45, p0_.compte AS compte_46, p0_.produitsysteme_id AS produitsysteme_id_47, p0_.carateristiqueproduit_id AS carateristiqueproduit_id_48, p0_.unite_id AS unite_id_49, p0_.abonne_id AS abonne_id_50 FROM produit p0_ INNER JOIN produit_abonne p1_ ON p0_.id = p1_.produit_id INNER JOIN abonne a2_ ON p1_.abonne_id = a2_.id WHERE p0_.si_agricole = 1 AND p0_.si_agricole_parent <> 1 AND a2_.id = 94;

SELECT
  DISTINCT(
    MONTH(c.date_commande)
  ) as mois
FROM
  commande c
  INNER JOIN lignecommande lc on lc.commande_id = c.id
  INNER JOIN produit_abonne pa on lc.produitabonne_id = pa.id
  INNER JOIN produit p on pa.produit_id = p.id
  INNER JOIN abonne a on pa.abonne_id = a.id
WHERE
  a.id = :abonneId
  AND YEAR(c.date_commande) = :annee
GROUP BY
  p.nom_produit,
  MONTH(c.date_commande)

SELECT DISTINCT( MONTH(c.date_commande)) as mois
            
                            FROM  commande c
                            INNER JOIN lignecommande lc on lc.commande_id = c.id
                            INNER JOIN produit_abonne pa on lc.produitabonne_id  = pa.id
                            INNER JOIN produit p on pa.produit_id = p.id
                            INNER JOIN abonne a on pa.abonne_id = a.id
                            
                            WHERE a.id =:abonneId AND YEAR(c.date_commande) =:annee 

                            GROUP BY p.nom_produit, MONTH(c.date_commande) ;

SELECT
  DISTINCT(
    MONTH(c.date_commande)
  ) as mois
FROM
  commande c
  INNER JOIN lignecommande lc on lc.commande_id = c.id
  INNER JOIN produit_abonne pa on lc.produitabonne_id = pa.id
  INNER JOIN produit p on pa.produit_id = p.id
  INNER JOIN abonne a on pa.abonne_id = a.id
WHERE
  a.id = :abonneId
  AND YEAR(c.date_commande) = :annee
GROUP BY
  p.nom_produit,
  MONTH(c.date_commande)

SELECT DISTINCT( MONTH(c.date_commande)) as mois
            
                            FROM  commande c
                            INNER JOIN lignecommande lc on lc.commande_id = c.id
                            INNER JOIN produit_abonne pa on lc.produitabonne_id  = pa.id
                            INNER JOIN produit p on pa.produit_id = p.id
                            INNER JOIN abonne a on pa.abonne_id = a.id
                            
                            WHERE a.id =:abonneId AND YEAR(c.date_commande) =:annee 

                            GROUP BY p.nom_produit, MONTH(c.date_commande) ;