Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.designation AS designation_3,
  t0.logo AS logo_4,
  t0.numeroordre AS numeroordre_5,
  t0.nif AS nif_6,
  t0.stat AS stat_7,
  t0.is_valid AS is_valid_8,
  t0.logitude AS logitude_9,
  t0.latitude AS latitude_10,
  t0.adresse AS adresse_11,
  t0.photocouverture AS photocouverture_12,
  t0.pagename AS pagename_13,
  t0.is_commande_special AS is_commande_special_14,
  t0.is_valide_automatique AS is_valide_automatique_15,
  t0.pourcentage_commande_special AS pourcentage_commande_special_16,
  t0.rcs AS rcs_17,
  t0.mail_responsable AS mail_responsable_18,
  t0.real_designation AS real_designation_19,
  t0.is_show_price AS is_show_price_20,
  t0.is_active_reservation AS is_active_reservation_21,
  t0.is24_and7 AS is24_and7_22,
  t0.quartier_id AS quartier_id_23
FROM
  ictus_pharmacie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.designation AS designation_3, t0.logo AS logo_4, t0.numeroordre AS numeroordre_5, t0.nif AS nif_6, t0.stat AS stat_7, t0.is_valid AS is_valid_8, t0.logitude AS logitude_9, t0.latitude AS latitude_10, t0.adresse AS adresse_11, t0.photocouverture AS photocouverture_12, t0.pagename AS pagename_13, t0.is_commande_special AS is_commande_special_14, t0.is_valide_automatique AS is_valide_automatique_15, t0.pourcentage_commande_special AS pourcentage_commande_special_16, t0.rcs AS rcs_17, t0.mail_responsable AS mail_responsable_18, t0.real_designation AS real_designation_19, t0.is_show_price AS is_show_price_20, t0.is_active_reservation AS is_active_reservation_21, t0.is24_and7 AS is24_and7_22, t0.quartier_id AS quartier_id_23 FROM ictus_pharmacie t0 WHERE t0.id = '31';

SELECT
  s0_.id AS id_0,
  s0_.nomproduit AS nomproduit_1,
  s0_.is_ordonnance AS is_ordonnance_2,
  s0_.is_disponible AS is_disponible_3,
  s0_.prixunitforme AS prixunitforme_4,
  i1_.designation AS designation_5,
  p2_.id AS id_6,
  (
    SELECT
      MIN(p3_.lien) AS sclr_8
    FROM
      photo p3_
    WHERE
      p3_.produit_id = s0_.produit_id
  ) AS sclr_7
FROM
  stockpharmacie s0_
  LEFT JOIN ictus_forme i1_ ON s0_.ictusforme_id = i1_.id
  INNER JOIN product p2_ ON s0_.produit_id = p2_.id
WHERE
  s0_.ictuspharmacie_id = ?
  AND (s0_.id IS NOT NULL)
ORDER BY
  s0_.nomproduit ASC
LIMIT
  10

SELECT s0_.id AS id_0, s0_.nomproduit AS nomproduit_1, s0_.is_ordonnance AS is_ordonnance_2, s0_.is_disponible AS is_disponible_3, s0_.prixunitforme AS prixunitforme_4, i1_.designation AS designation_5, p2_.id AS id_6, (SELECT MIN(p3_.lien) AS sclr_8 FROM photo p3_ WHERE p3_.produit_id = s0_.produit_id) AS sclr_7 FROM stockpharmacie s0_ LEFT JOIN ictus_forme i1_ ON s0_.ictusforme_id = i1_.id INNER JOIN product p2_ ON s0_.produit_id = p2_.id WHERE s0_.ictuspharmacie_id = 31 AND (s0_.id IS NOT NULL) ORDER BY s0_.nomproduit ASC LIMIT 10;