Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.parent_id AS sclr_1,
  c0_.name AS name_2
FROM
  Categorie c0_
ORDER BY
  c0_.parent_id ASC,
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.parent_id AS sclr_1, c0_.name AS name_2 FROM Categorie c0_ ORDER BY c0_.parent_id ASC, c0_.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;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'exacompabdd'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.creation_date AS creation_date_2,
  p0_.modified_date AS modified_date_3,
  p0_.title AS title_4,
  p0_.menu_label AS menu_label_5,
  p0_.page_title AS page_title_6,
  p0_.page_description AS page_description_7,
  p0_.bandeau_text_1 AS bandeau_text_1_8,
  p0_.bandeau_text_2 AS bandeau_text_2_9,
  p0_.bandeau_text_3 AS bandeau_text_3_10,
  p0_.content AS content_11,
  p0_.page_order AS page_order_12,
  p0_.robots AS robots_13,
  u1_.id AS id_14,
  u1_.url AS url_15,
  p0_.parent_id AS parent_id_16,
  p0_.url_id AS url_id_17,
  u1_.redirect_on AS redirect_on_18
FROM
  Page p0_
  LEFT JOIN Url u1_ ON p0_.url_id = u1_.id
WHERE
  p0_.type = ?

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.creation_date AS creation_date_2, p0_.modified_date AS modified_date_3, p0_.title AS title_4, p0_.menu_label AS menu_label_5, p0_.page_title AS page_title_6, p0_.page_description AS page_description_7, p0_.bandeau_text_1 AS bandeau_text_1_8, p0_.bandeau_text_2 AS bandeau_text_2_9, p0_.bandeau_text_3 AS bandeau_text_3_10, p0_.content AS content_11, p0_.page_order AS page_order_12, p0_.robots AS robots_13, u1_.id AS id_14, u1_.url AS url_15, p0_.parent_id AS parent_id_16, p0_.url_id AS url_id_17, u1_.redirect_on AS redirect_on_18 FROM Page p0_ LEFT JOIN Url u1_ ON p0_.url_id = u1_.id WHERE p0_.type = 'aide';

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 = 'header_incentive' 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
  u0_.url AS url_0
FROM
  Page p1_
  LEFT JOIN Url u0_ ON p1_.url_id = u0_.id
WHERE
  p1_.type = ?
LIMIT
  1

SELECT u0_.url AS url_0 FROM Page p1_ LEFT JOIN Url u0_ ON p1_.url_id = u0_.id WHERE p1_.type = 'links' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.creation_date AS creation_date_3,
  t0.modified_date AS modified_date_4,
  t0.title AS title_5,
  t0.menu_label AS menu_label_6,
  t0.page_title AS page_title_7,
  t0.page_description AS page_description_8,
  t0.bandeau_text_1 AS bandeau_text_1_9,
  t0.bandeau_text_2 AS bandeau_text_2_10,
  t0.bandeau_text_3 AS bandeau_text_3_11,
  t0.content AS content_12,
  t0.page_order AS page_order_13,
  t0.robots AS robots_14,
  t0.parent_id AS parent_id_15,
  t0.url_id AS url_id_16
FROM
  Page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.creation_date AS creation_date_3, t0.modified_date AS modified_date_4, t0.title AS title_5, t0.menu_label AS menu_label_6, t0.page_title AS page_title_7, t0.page_description AS page_description_8, t0.bandeau_text_1 AS bandeau_text_1_9, t0.bandeau_text_2 AS bandeau_text_2_10, t0.bandeau_text_3 AS bandeau_text_3_11, t0.content AS content_12, t0.page_order AS page_order_13, t0.robots AS robots_14, t0.parent_id AS parent_id_15, t0.url_id AS url_id_16 FROM Page t0 WHERE t0.id = 205;

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;