Symfony Profiler

SELECT
  getcompteur(
    :p_type, :p_an, :p_mois, :p_entite,
    :p_taille, :four
  ) as compteur;

SELECT getcompteur(:p_type ,:p_an ,:p_mois ,:p_entite ,:p_taille, :four) as compteur; ;

INSERT INTO commande_client (
  code_commande, description_produit,
  date_publication, date_retrait,
  date_commande, date_modification,
  montant_commande, montant_reste_commande,
  etat_commande, type_commande, taux_echange,
  refboncommande, annule, code_genere,
  si_modification, si_retrait, si_credit,
  suivi_historique, utilisateur_id,
  anneecampagne_id, producteur_id,
  fournisseur_id, client_id, table_mange_id,
  surfaceannee_id, abonne_id, caisse_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO commande_client (code_commande, description_produit, date_publication, date_retrait, date_commande, date_modification, montant_commande, montant_reste_commande, etat_commande, type_commande, taux_echange, refboncommande, annule, code_genere, si_modification, si_retrait, si_credit, suivi_historique, utilisateur_id, anneecampagne_id, producteur_id, fournisseur_id, client_id, table_mange_id, surfaceannee_id, abonne_id, caisse_id) VALUES ('C000/NOV/2024', 'Evoluer C000/NOV/2024', '2024-11-15 19:18:40', NULL, '2024-11-15', '2024-11-15', NULL, 0, 1, 3, 0, 'C000/NOV/2024', 0, 'C000/NOV/2024', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 22, NULL);

SELECT
  t0.id AS id_1,
  t0.code_commande AS code_commande_2,
  t0.description_produit AS description_produit_3,
  t0.date_publication AS date_publication_4,
  t0.date_retrait AS date_retrait_5,
  t0.date_commande AS date_commande_6,
  t0.date_modification AS date_modification_7,
  t0.montant_commande AS montant_commande_8,
  t0.montant_reste_commande AS montant_reste_commande_9,
  t0.etat_commande AS etat_commande_10,
  t0.type_commande AS type_commande_11,
  t0.taux_echange AS taux_echange_12,
  t0.refboncommande AS refboncommande_13,
  t0.annule AS annule_14,
  t0.code_genere AS code_genere_15,
  t0.si_modification AS si_modification_16,
  t0.si_retrait AS si_retrait_17,
  t0.si_credit AS si_credit_18,
  t0.suivi_historique AS suivi_historique_19,
  t0.utilisateur_id AS utilisateur_id_20,
  t0.anneecampagne_id AS anneecampagne_id_21,
  t0.producteur_id AS producteur_id_22,
  t0.fournisseur_id AS fournisseur_id_23,
  t0.client_id AS client_id_24,
  t0.table_mange_id AS table_mange_id_25,
  t0.surfaceannee_id AS surfaceannee_id_26,
  t0.abonne_id AS abonne_id_27,
  t0.caisse_id AS caisse_id_28
FROM
  commande_client t0
WHERE
  t0.si_retrait = ?
  AND t0.abonne_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_commande AS code_commande_2, t0.description_produit AS description_produit_3, t0.date_publication AS date_publication_4, t0.date_retrait AS date_retrait_5, t0.date_commande AS date_commande_6, t0.date_modification AS date_modification_7, t0.montant_commande AS montant_commande_8, t0.montant_reste_commande AS montant_reste_commande_9, t0.etat_commande AS etat_commande_10, t0.type_commande AS type_commande_11, t0.taux_echange AS taux_echange_12, t0.refboncommande AS refboncommande_13, t0.annule AS annule_14, t0.code_genere AS code_genere_15, t0.si_modification AS si_modification_16, t0.si_retrait AS si_retrait_17, t0.si_credit AS si_credit_18, t0.suivi_historique AS suivi_historique_19, t0.utilisateur_id AS utilisateur_id_20, t0.anneecampagne_id AS anneecampagne_id_21, t0.producteur_id AS producteur_id_22, t0.fournisseur_id AS fournisseur_id_23, t0.client_id AS client_id_24, t0.table_mange_id AS table_mange_id_25, t0.surfaceannee_id AS surfaceannee_id_26, t0.abonne_id AS abonne_id_27, t0.caisse_id AS caisse_id_28 FROM commande_client t0 WHERE t0.si_retrait = 1 AND t0.abonne_id = 22 LIMIT 1;

SELECT
  DISTINCT (p0_.id) AS sclr_0,
  p0_.nom_produit AS nom_produit_1,
  p1_.info_prix AS info_prix_2,
  p2_.code_genere AS code_genere_3,
  p0_.montanthtAchat AS montanthtAchat_4,
  c3_.id AS id_5,
  p0_.code_genere AS code_genere_6,
  p0_.code_barre AS code_barre_7,
  c3_.type_categorie AS type_categorie_8,
  p0_.si_agricole AS si_agricole_9,
  p0_.si_agricole_parent AS si_agricole_parent_10,
  p0_.en_stock_produit AS en_stock_produit_11,
  p0_.si_semence AS si_semence_12,
  i4_.url_image AS url_image_13,
  d5_.libelle AS libelle_14
FROM
  produit p0_
  INNER JOIN categorieproduit c3_ ON p0_.categorie_id = c3_.id
  INNER JOIN abonne a6_ ON p0_.abonne_id = a6_.id
  INNER JOIN devise d5_ ON a6_.devise_id = d5_.id
  INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id
  INNER JOIN produit p2_ ON p0_.produit_id = p2_.id
  INNER JOIN image i4_ ON p0_.id = i4_.produit_id
WHERE
  1 = 1
  AND p1_.etat_prix = 1
  AND p0_.siEcommerce = 1
  AND a6_.id = ?

SELECT DISTINCT (p0_.id) AS sclr_0, p0_.nom_produit AS nom_produit_1, p1_.info_prix AS info_prix_2, p2_.code_genere AS code_genere_3, p0_.montanthtAchat AS montanthtAchat_4, c3_.id AS id_5, p0_.code_genere AS code_genere_6, p0_.code_barre AS code_barre_7, c3_.type_categorie AS type_categorie_8, p0_.si_agricole AS si_agricole_9, p0_.si_agricole_parent AS si_agricole_parent_10, p0_.en_stock_produit AS en_stock_produit_11, p0_.si_semence AS si_semence_12, i4_.url_image AS url_image_13, d5_.libelle AS libelle_14 FROM produit p0_ INNER JOIN categorieproduit c3_ ON p0_.categorie_id = c3_.id INNER JOIN abonne a6_ ON p0_.abonne_id = a6_.id INNER JOIN devise d5_ ON a6_.devise_id = d5_.id INNER JOIN prix_rigueur p1_ ON p0_.id = p1_.produit_id INNER JOIN produit p2_ ON p0_.produit_id = p2_.id INNER JOIN image i4_ ON p0_.id = i4_.produit_id WHERE 1 = 1 AND p1_.etat_prix = 1 AND p0_.siEcommerce = 1 AND a6_.id = 22;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_base_abonne AS code_base_abonne_3,
  t0.email_abonne AS email_abonne_4,
  t0.tel1_abonne AS tel1_abonne_5,
  t0.tel2_abonne AS tel2_abonne_6,
  t0.adresse_abonne AS adresse_abonne_7,
  t0.description_abonne AS description_abonne_8,
  t0.etat_abonne AS etat_abonne_9,
  t0.siExploitation AS siExploitation_10,
  t0.si_principale AS si_principale_11,
  t0.type_action_abonne AS type_action_abonne_12,
  t0.adresse_web AS adresse_web_13,
  t0.date_ajout_abonne AS date_ajout_abonne_14,
  t0.date_edit_abonne AS date_edit_abonne_15,
  t0.titre_image AS titre_image_16,
  t0.url_image AS url_image_17,
  t0.type_presentation AS type_presentation_18,
  t0.langue AS langue_19,
  t0.configuration AS configuration_20,
  t0.type_abonne_id AS type_abonne_id_21,
  t0.template_id AS template_id_22,
  t0.partenaire_id AS partenaire_id_23,
  t0.devise_id AS devise_id_24,
  t0.pays_id AS pays_id_25
FROM
  abonne t0
WHERE
  t0.adresse_web = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_base_abonne AS code_base_abonne_3, t0.email_abonne AS email_abonne_4, t0.tel1_abonne AS tel1_abonne_5, t0.tel2_abonne AS tel2_abonne_6, t0.adresse_abonne AS adresse_abonne_7, t0.description_abonne AS description_abonne_8, t0.etat_abonne AS etat_abonne_9, t0.siExploitation AS siExploitation_10, t0.si_principale AS si_principale_11, t0.type_action_abonne AS type_action_abonne_12, t0.adresse_web AS adresse_web_13, t0.date_ajout_abonne AS date_ajout_abonne_14, t0.date_edit_abonne AS date_edit_abonne_15, t0.titre_image AS titre_image_16, t0.url_image AS url_image_17, t0.type_presentation AS type_presentation_18, t0.langue AS langue_19, t0.configuration AS configuration_20, t0.type_abonne_id AS type_abonne_id_21, t0.template_id AS template_id_22, t0.partenaire_id AS partenaire_id_23, t0.devise_id AS devise_id_24, t0.pays_id AS pays_id_25 FROM abonne t0 WHERE t0.adresse_web = 'uropcm.coo.tg' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nom_produit AS nom_produit_1,
  0 AS sclr_2,
  p0_.montanthtAchat AS montanthtAchat_3,
  c1_.id AS id_4,
  p0_.code_genere AS code_genere_5,
  p0_.code_barre AS code_barre_6,
  c1_.type_categorie AS type_categorie_7,
  p0_.si_agricole AS si_agricole_8,
  p0_.si_agricole_parent AS si_agricole_parent_9,
  p0_.si_semence AS si_semence_10,
  i2_.url_image AS url_image_11
FROM
  produit p0_
  INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN abonne a3_ ON p0_.abonne_id = a3_.id
  INNER JOIN image i2_ ON p0_.id = i2_.produit_id
WHERE
  1 = 1
  AND p0_.si_agricole_parent = ?
  AND a3_.id = ?

SELECT p0_.id AS id_0, p0_.nom_produit AS nom_produit_1, 0 AS sclr_2, p0_.montanthtAchat AS montanthtAchat_3, c1_.id AS id_4, p0_.code_genere AS code_genere_5, p0_.code_barre AS code_barre_6, c1_.type_categorie AS type_categorie_7, p0_.si_agricole AS si_agricole_8, p0_.si_agricole_parent AS si_agricole_parent_9, p0_.si_semence AS si_semence_10, i2_.url_image AS url_image_11 FROM produit p0_ INNER JOIN categorieproduit c1_ ON p0_.categorie_id = c1_.id INNER JOIN abonne a3_ ON p0_.abonne_id = a3_.id INNER JOIN image i2_ ON p0_.id = i2_.produit_id WHERE 1 = 1 AND p0_.si_agricole_parent = 1 AND a3_.id = 22;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.code AS code_2,
  c0_.description AS description_3,
  c0_.etat AS etat_4,
  c0_.type_categorie AS type_categorie_5,
  c0_.si_affichage AS si_affichage_6,
  c0_.abonne_id AS abonne_id_7,
  c0_.categorieproduit_id AS categorieproduit_id_8,
  c0_.type_abonne_id AS type_abonne_id_9
FROM
  categorieproduit c0_
  INNER JOIN abonne a1_ ON c0_.abonne_id = a1_.id
WHERE
  (
    c0_.etat <> 2
    AND c0_.id = ?
  )
  OR a1_.id = ?

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.code AS code_2, c0_.description AS description_3, c0_.etat AS etat_4, c0_.type_categorie AS type_categorie_5, c0_.si_affichage AS si_affichage_6, c0_.abonne_id AS abonne_id_7, c0_.categorieproduit_id AS categorieproduit_id_8, c0_.type_abonne_id AS type_abonne_id_9 FROM categorieproduit c0_ INNER JOIN abonne a1_ ON c0_.abonne_id = a1_.id WHERE (c0_.etat <> 2 AND c0_.id = 1) OR a1_.id = 22;

"COMMIT"

"COMMIT";

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.datePublication AS datePublication_2,
  m0_.contenuMenu AS contenuMenu_3,
  m0_.type_menu AS type_menu_4,
  m0_.etat_menu AS etat_menu_5,
  m0_.classHtmlMenu AS classHtmlMenu_6,
  m0_.ordre AS ordre_7,
  m0_.abonne_id AS abonne_id_8,
  m0_.menu_id AS menu_id_9
FROM
  menu m0_
  INNER JOIN abonne a1_ ON m0_.abonne_id = a1_.id
WHERE
  m0_.etat_menu = 1
  AND a1_.id = 0
ORDER BY
  m0_.ordre ASC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.datePublication AS datePublication_2, m0_.contenuMenu AS contenuMenu_3, m0_.type_menu AS type_menu_4, m0_.etat_menu AS etat_menu_5, m0_.classHtmlMenu AS classHtmlMenu_6, m0_.ordre AS ordre_7, m0_.abonne_id AS abonne_id_8, m0_.menu_id AS menu_id_9 FROM menu m0_ INNER JOIN abonne a1_ ON m0_.abonne_id = a1_.id WHERE m0_.etat_menu = 1 AND a1_.id = 0 ORDER BY m0_.ordre ASC;

"START TRANSACTION"

"START TRANSACTION";