Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.register_date AS register_date_3,
  t0.modified_date AS modified_date_4,
  t0.credits AS credits_5,
  t0.entreprise AS entreprise_6,
  t0.siret AS siret_7,
  t0.nom AS nom_8,
  t0.adresse AS adresse_9,
  t0.code_postal AS code_postal_10,
  t0.ville AS ville_11,
  t0.coordinates AS coordinates_12,
  t0.telephone AS telephone_13,
  t0.fax AS fax_14,
  t0.website AS website_15,
  t0.logo AS logo_16,
  t0.user_id AS user_id_17
FROM
  Prestataire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.register_date AS register_date_3, t0.modified_date AS modified_date_4, t0.credits AS credits_5, t0.entreprise AS entreprise_6, t0.siret AS siret_7, t0.nom AS nom_8, t0.adresse AS adresse_9, t0.code_postal AS code_postal_10, t0.ville AS ville_11, t0.coordinates AS coordinates_12, t0.telephone AS telephone_13, t0.fax AS fax_14, t0.website AS website_15, t0.logo AS logo_16, t0.user_id AS user_id_17 FROM Prestataire t0 WHERE t0.id = 530;

SELECT
  c0_.name AS name_0,
  c1_.id AS id_1,
  c1_.name AS name_2
FROM
  Prestataire p2_
  INNER JOIN PrestataireCategorie p3_ ON p2_.id = p3_.prestataire_id
  INNER JOIN Categorie c1_ ON c1_.id = p3_.categorie_id
  INNER JOIN Categorie c0_ ON c1_.group_id = c0_.id
WHERE
  p2_.id = ?
ORDER BY
  c0_.ordre ASC,
  c1_.ordre ASC

SELECT c0_.name AS name_0, c1_.id AS id_1, c1_.name AS name_2 FROM Prestataire p2_ INNER JOIN PrestataireCategorie p3_ ON p2_.id = p3_.prestataire_id INNER JOIN Categorie c1_ ON c1_.id = p3_.categorie_id INNER JOIN Categorie c0_ ON c1_.group_id = c0_.id WHERE p2_.id = 530 ORDER BY c0_.ordre ASC, c1_.ordre ASC;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  Prestataire p0_
WHERE
  p0_.status = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = 'valid';

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  Prestataire p0_
WHERE
  p0_.status = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = 'valid';

SELECT
  p0_.id AS id_0,
  p0_.parent_id AS sclr_1,
  p0_.menu_label AS menu_label_2,
  c1_.description AS description_3,
  u2_.url AS url_4,
  c1_.id AS id_5
FROM
  Page p0_
  INNER JOIN Url u2_ ON p0_.url_id = u2_.id
  LEFT JOIN Categorie c1_ ON (c1_.page_id = p0_.id)
WHERE
  p0_.type = ?
ORDER BY
  p0_.parent_id ASC,
  p0_.page_order ASC

SELECT p0_.id AS id_0, p0_.parent_id AS sclr_1, p0_.menu_label AS menu_label_2, c1_.description AS description_3, u2_.url AS url_4, c1_.id AS id_5 FROM Page p0_ INNER JOIN Url u2_ ON p0_.url_id = u2_.id LEFT JOIN Categorie c1_ ON (c1_.page_id = p0_.id) WHERE p0_.type = 'categorie' ORDER BY p0_.parent_id ASC, p0_.page_order ASC;