Symfony Profiler

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  Demande d0_
WHERE
  d0_.status IN (?, ?)
  AND d0_.expiration > ?

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM Demande d0_ WHERE d0_.status IN (1, 2) AND d0_.expiration > '2026-02-01 14:44:23';

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.creation_date AS creation_date_1
FROM
  Demande d0_
WHERE
  d0_.status IN (?, ?)
  AND d0_.expiration > ?
ORDER BY
  d0_.creation_date DESC
LIMIT
  72

SELECT DISTINCT d0_.id AS id_0, d0_.creation_date AS creation_date_1 FROM Demande d0_ WHERE d0_.status IN (1, 2) AND d0_.expiration > '2026-02-01 14:44:23' ORDER BY d0_.creation_date DESC LIMIT 72;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.price AS price_3,
  c0_.credits AS credits_4,
  c0_.ordre AS ordre_5,
  c0_.parent_id AS parent_id_6,
  c0_.group_id AS group_id_7,
  c0_.page_id AS page_id_8
FROM
  Categorie c0_
  LEFT JOIN Categorie c1_ ON c0_.group_id = c1_.id
WHERE
  c0_.parent_id IS NOT NULL
ORDER BY
  c1_.ordre ASC,
  c0_.ordre ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.price AS price_3, c0_.credits AS credits_4, c0_.ordre AS ordre_5, c0_.parent_id AS parent_id_6, c0_.group_id AS group_id_7, c0_.page_id AS page_id_8 FROM Categorie c0_ LEFT JOIN Categorie c1_ ON c0_.group_id = c1_.id WHERE c0_.parent_id IS NOT NULL ORDER BY c1_.ordre ASC, c0_.ordre ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.credits AS credits_5,
  t0.ordre AS ordre_6,
  t0.parent_id AS parent_id_7,
  t0.group_id AS group_id_8,
  t0.page_id AS page_id_9
FROM
  Categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.credits AS credits_5, t0.ordre AS ordre_6, t0.parent_id AS parent_id_7, t0.group_id AS group_id_8, t0.page_id AS page_id_9 FROM Categorie t0 WHERE t0.id = 72;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.credits AS credits_5,
  t0.ordre AS ordre_6,
  t0.parent_id AS parent_id_7,
  t0.group_id AS group_id_8,
  t0.page_id AS page_id_9
FROM
  Categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.credits AS credits_5, t0.ordre AS ordre_6, t0.parent_id AS parent_id_7, t0.group_id AS group_id_8, t0.page_id AS page_id_9 FROM Categorie t0 WHERE t0.id = 73;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.credits AS credits_5,
  t0.ordre AS ordre_6,
  t0.parent_id AS parent_id_7,
  t0.group_id AS group_id_8,
  t0.page_id AS page_id_9
FROM
  Categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.credits AS credits_5, t0.ordre AS ordre_6, t0.parent_id AS parent_id_7, t0.group_id AS group_id_8, t0.page_id AS page_id_9 FROM Categorie t0 WHERE t0.id = 74;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.credits AS credits_5,
  t0.ordre AS ordre_6,
  t0.parent_id AS parent_id_7,
  t0.group_id AS group_id_8,
  t0.page_id AS page_id_9
FROM
  Categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.credits AS credits_5, t0.ordre AS ordre_6, t0.parent_id AS parent_id_7, t0.group_id AS group_id_8, t0.page_id AS page_id_9 FROM Categorie t0 WHERE t0.id = 75;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.credits AS credits_5,
  t0.ordre AS ordre_6,
  t0.parent_id AS parent_id_7,
  t0.group_id AS group_id_8,
  t0.page_id AS page_id_9
FROM
  Categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.credits AS credits_5, t0.ordre AS ordre_6, t0.parent_id AS parent_id_7, t0.group_id AS group_id_8, t0.page_id AS page_id_9 FROM Categorie t0 WHERE t0.id = 76;

SELECT
  d0_.id AS id_0,
  d0_.code AS code_1,
  d0_.name AS name_2,
  d0_.slug AS slug_3,
  d0_.region_id AS region_id_4
FROM
  Departement d0_

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.region_id AS region_id_4 FROM Departement d0_;

SELECT
  t0.id AS id_1,
  t0.option_key AS option_key_2,
  t0.option_value AS option_value_3
FROM
  `Option` t0
WHERE
  t0.option_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.option_key AS option_key_2, t0.option_value AS option_value_3 FROM `Option` t0 WHERE t0.option_key = 'default_page_suffix' LIMIT 1;

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;