Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name_categorie AS name_categorie_1,
  c0_.couverture AS couverture_2,
  c0_.img_produit AS img_produit_3,
  c0_.priorite AS priorite_4,
  c0_.description AS description_5
FROM
  categorie c0_
ORDER BY
  c0_.priorite ASC
LIMIT
  6

SELECT c0_.id AS id_0, c0_.name_categorie AS name_categorie_1, c0_.couverture AS couverture_2, c0_.img_produit AS img_produit_3, c0_.priorite AS priorite_4, c0_.description AS description_5 FROM categorie c0_ ORDER BY c0_.priorite ASC LIMIT 6;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.name_categorie AS name_categorie_1,
          c0_.couverture AS couverture_2,
          c0_.img_produit AS img_produit_3,
          c0_.priorite AS priorite_4,
          c0_.description AS description_5
        FROM
          categorie c0_
        ORDER BY
          c0_.priorite ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name_categorie AS name_categorie_1, c0_.couverture AS couverture_2, c0_.img_produit AS img_produit_3, c0_.priorite AS priorite_4, c0_.description AS description_5 FROM categorie c0_ ORDER BY c0_.priorite ASC) dctrn_result) dctrn_table;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.designation AS designation_2,
  p0_.statut AS statut_3,
  p0_.statut_comptable AS statut_comptable_4,
  p0_.code_barre AS code_barre_5,
  p0_.nbre_piece AS nbre_piece_6,
  p0_.nbre_paquet AS nbre_paquet_7,
  p0_.tva AS tva_8,
  p0_.seuil_alerte AS seuil_alerte_9,
  p1_.prix_vente AS prix_vente_10,
  p1_.type_produit AS type_produit_11,
  p1_.nbre_vente AS nbre_vente_12,
  a2_.type_aliment AS type_aliment_13,
  a2_.description AS description_14,
  a2_.unite AS unite_15,
  p0_.type AS type_16,
  p0_.categorie_id AS categorie_id_17,
  p1_.epaisseur_id AS epaisseur_id_18,
  p1_.dimension_id AS dimension_id_19,
  p1_.origine_id AS origine_id_20,
  p1_.type_id AS type_id_21
FROM
  products p0_
  LEFT JOIN product_vente p1_ ON p0_.id = p1_.id
  LEFT JOIN alimentation_animal_ferme a2_ ON p0_.id = a2_.id
LIMIT
  25

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.statut AS statut_3, p0_.statut_comptable AS statut_comptable_4, p0_.code_barre AS code_barre_5, p0_.nbre_piece AS nbre_piece_6, p0_.nbre_paquet AS nbre_paquet_7, p0_.tva AS tva_8, p0_.seuil_alerte AS seuil_alerte_9, p1_.prix_vente AS prix_vente_10, p1_.type_produit AS type_produit_11, p1_.nbre_vente AS nbre_vente_12, a2_.type_aliment AS type_aliment_13, a2_.description AS description_14, a2_.unite AS unite_15, p0_.type AS type_16, p0_.categorie_id AS categorie_id_17, p1_.epaisseur_id AS epaisseur_id_18, p1_.dimension_id AS dimension_id_19, p1_.origine_id AS origine_id_20, p1_.type_id AS type_id_21 FROM products p0_ LEFT JOIN product_vente p1_ ON p0_.id = p1_.id LEFT JOIN alimentation_animal_ferme a2_ ON p0_.id = a2_.id LIMIT 25;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.reference AS reference_1,
          p0_.designation AS designation_2,
          p0_.statut AS statut_3,
          p0_.statut_comptable AS statut_comptable_4,
          p0_.code_barre AS code_barre_5,
          p0_.nbre_piece AS nbre_piece_6,
          p0_.nbre_paquet AS nbre_paquet_7,
          p0_.tva AS tva_8,
          p0_.seuil_alerte AS seuil_alerte_9,
          p1_.prix_vente AS prix_vente_10,
          p1_.type_produit AS type_produit_11,
          p1_.nbre_vente AS nbre_vente_12,
          a2_.type_aliment AS type_aliment_13,
          a2_.description AS description_14,
          a2_.unite AS unite_15,
          p0_.type AS type_16
        FROM
          products p0_
          LEFT JOIN product_vente p1_ ON p0_.id = p1_.id
          LEFT JOIN alimentation_animal_ferme a2_ ON p0_.id = a2_.id
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.statut AS statut_3, p0_.statut_comptable AS statut_comptable_4, p0_.code_barre AS code_barre_5, p0_.nbre_piece AS nbre_piece_6, p0_.nbre_paquet AS nbre_paquet_7, p0_.tva AS tva_8, p0_.seuil_alerte AS seuil_alerte_9, p1_.prix_vente AS prix_vente_10, p1_.type_produit AS type_produit_11, p1_.nbre_vente AS nbre_vente_12, a2_.type_aliment AS type_aliment_13, a2_.description AS description_14, a2_.unite AS unite_15, p0_.type AS type_16 FROM products p0_ LEFT JOIN product_vente p1_ ON p0_.id = p1_.id LEFT JOIN alimentation_animal_ferme a2_ ON p0_.id = a2_.id) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.nom_entreprise AS nom_entreprise_2,
  t0.identifiant AS identifiant_3,
  t0.numero_agrement AS numero_agrement_4,
  t0.adresse AS adresse_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.pays AS pays_3,
  t0.region AS region_4,
  t0.ville AS ville_5,
  t0.telephone AS telephone_6,
  t0.email AS email_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.initial AS initial_10,
  t0.type_commerce AS type_commerce_11,
  t0.lieu AS lieu_12,
  t0.entreprise_id AS entreprise_id_13,
  t0.gestionnaire_id AS gestionnaire_id_14,
  t0.ferme_id AS ferme_id_15
FROM
  lieux_ventes t0

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.pays AS pays_3, t0.region AS region_4, t0.ville AS ville_5, t0.telephone AS telephone_6, t0.email AS email_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.initial AS initial_10, t0.type_commerce AS type_commerce_11, t0.lieu AS lieu_12, t0.entreprise_id AS entreprise_id_13, t0.gestionnaire_id AS gestionnaire_id_14, t0.ferme_id AS ferme_id_15 FROM lieux_ventes t0;

SELECT
  t0.id AS id_1,
  t0.numero_licence AS numero_licence_2,
  t0.date_debut AS date_debut_3,
  t0.datefin AS datefin_4,
  t0.statut AS statut_5,
  t0.statut_site_web AS statut_site_web_6,
  t0.tarif AS tarif_7,
  t0.type_licence AS type_licence_8,
  t0.lien_paiement AS lien_paiement_9,
  t0.entreprise_id AS entreprise_id_10
FROM
  licence t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_licence AS numero_licence_2, t0.date_debut AS date_debut_3, t0.datefin AS datefin_4, t0.statut AS statut_5, t0.statut_site_web AS statut_site_web_6, t0.tarif AS tarif_7, t0.type_licence AS type_licence_8, t0.lien_paiement AS lien_paiement_9, t0.entreprise_id AS entreprise_id_10 FROM licence t0 WHERE t0.id = 1;