Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.prix AS prix_1,
  d0_.credits AS credits_2,
  d0_.status AS status_3,
  d0_.creation_date AS creation_date_4,
  d0_.modified_date AS modified_date_5,
  d0_.client_statut AS client_statut_6,
  d0_.client_nom AS client_nom_7,
  d0_.client_email AS client_email_8,
  d0_.client_telephone AS client_telephone_9,
  d0_.bien_type AS bien_type_10,
  d0_.bien_localisation AS bien_localisation_11,
  d0_.bien_code_postal AS bien_code_postal_12,
  d0_.bien_ville AS bien_ville_13,
  d0_.bien_nombre_pieces AS bien_nombre_pieces_14,
  d0_.bien_surface AS bien_surface_15,
  d0_.bien_annee_construction AS bien_annee_construction_16,
  d0_.bien_copropriete AS bien_copropriete_17,
  d0_.bien_gaz AS bien_gaz_18,
  d0_.bien_electricite AS bien_electricite_19,
  d0_.bien_photo AS bien_photo_20,
  d0_.description_file AS description_file_21,
  d0_.expiration AS expiration_22,
  d0_.comment AS comment_23,
  d0_.prestation AS prestation_24,
  d0_.provenance AS provenance_25,
  d0_.similar AS similar_26,
  d0_.estimation AS estimation_27,
  c1_.id AS id_28,
  c1_.name AS name_29,
  c1_.description AS description_30,
  c1_.price AS price_31,
  c1_.credits AS credits_32,
  c1_.ordre AS ordre_33,
  c2_.id AS id_34,
  c2_.name AS name_35,
  c2_.description AS description_36,
  c2_.price AS price_37,
  c2_.credits AS credits_38,
  c2_.ordre AS ordre_39,
  d0_.categorie_id AS categorie_id_40,
  c1_.parent_id AS parent_id_41,
  c1_.group_id AS group_id_42,
  c1_.page_id AS page_id_43,
  c2_.parent_id AS parent_id_44,
  c2_.group_id AS group_id_45,
  c2_.page_id AS page_id_46
FROM
  Demande d0_
  INNER JOIN Categorie c1_ ON d0_.categorie_id = c1_.id
  INNER JOIN Categorie c2_ ON c1_.parent_id = c2_.id
WHERE
  d0_.status IN (?, ?)
  AND d0_.expiration > ?
ORDER BY
  d0_.creation_date DESC
LIMIT
  4

SELECT d0_.id AS id_0, d0_.prix AS prix_1, d0_.credits AS credits_2, d0_.status AS status_3, d0_.creation_date AS creation_date_4, d0_.modified_date AS modified_date_5, d0_.client_statut AS client_statut_6, d0_.client_nom AS client_nom_7, d0_.client_email AS client_email_8, d0_.client_telephone AS client_telephone_9, d0_.bien_type AS bien_type_10, d0_.bien_localisation AS bien_localisation_11, d0_.bien_code_postal AS bien_code_postal_12, d0_.bien_ville AS bien_ville_13, d0_.bien_nombre_pieces AS bien_nombre_pieces_14, d0_.bien_surface AS bien_surface_15, d0_.bien_annee_construction AS bien_annee_construction_16, d0_.bien_copropriete AS bien_copropriete_17, d0_.bien_gaz AS bien_gaz_18, d0_.bien_electricite AS bien_electricite_19, d0_.bien_photo AS bien_photo_20, d0_.description_file AS description_file_21, d0_.expiration AS expiration_22, d0_.comment AS comment_23, d0_.prestation AS prestation_24, d0_.provenance AS provenance_25, d0_.similar AS similar_26, d0_.estimation AS estimation_27, c1_.id AS id_28, c1_.name AS name_29, c1_.description AS description_30, c1_.price AS price_31, c1_.credits AS credits_32, c1_.ordre AS ordre_33, c2_.id AS id_34, c2_.name AS name_35, c2_.description AS description_36, c2_.price AS price_37, c2_.credits AS credits_38, c2_.ordre AS ordre_39, d0_.categorie_id AS categorie_id_40, c1_.parent_id AS parent_id_41, c1_.group_id AS group_id_42, c1_.page_id AS page_id_43, c2_.parent_id AS parent_id_44, c2_.group_id AS group_id_45, c2_.page_id AS page_id_46 FROM Demande d0_ INNER JOIN Categorie c1_ ON d0_.categorie_id = c1_.id INNER JOIN Categorie c2_ ON c1_.parent_id = c2_.id WHERE d0_.status IN (1, 2) AND d0_.expiration > '2026-02-01 16:26:13' ORDER BY d0_.creation_date DESC LIMIT 4;

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
  DISTINCT p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.register_date AS register_date_2,
  p0_.modified_date AS modified_date_3,
  p0_.credits AS credits_4,
  p0_.entreprise AS entreprise_5,
  p0_.siret AS siret_6,
  p0_.nom AS nom_7,
  p0_.adresse AS adresse_8,
  p0_.code_postal AS code_postal_9,
  p0_.ville AS ville_10,
  p0_.coordinates AS coordinates_11,
  p0_.telephone AS telephone_12,
  p0_.fax AS fax_13,
  p0_.website AS website_14,
  p0_.logo AS logo_15,
  p0_.user_id AS user_id_16
FROM
  Prestataire p0_
  INNER JOIN PrestataireDepartement p2_ ON p0_.id = p2_.prestataire_id
  INNER JOIN Departement d1_ ON d1_.id = p2_.departement_id
  INNER JOIN PrestataireCategorie p4_ ON p0_.id = p4_.prestataire_id
  INNER JOIN Categorie c3_ ON c3_.id = p4_.categorie_id
  AND (c3_.id = ?)
WHERE
  p0_.status = ?
  AND (
    p0_.code_postal LIKE ?
    OR d1_.code LIKE ?
  )

SELECT DISTINCT p0_.id AS id_0, p0_.status AS status_1, p0_.register_date AS register_date_2, p0_.modified_date AS modified_date_3, p0_.credits AS credits_4, p0_.entreprise AS entreprise_5, p0_.siret AS siret_6, p0_.nom AS nom_7, p0_.adresse AS adresse_8, p0_.code_postal AS code_postal_9, p0_.ville AS ville_10, p0_.coordinates AS coordinates_11, p0_.telephone AS telephone_12, p0_.fax AS fax_13, p0_.website AS website_14, p0_.logo AS logo_15, p0_.user_id AS user_id_16 FROM Prestataire p0_ INNER JOIN PrestataireDepartement p2_ ON p0_.id = p2_.prestataire_id INNER JOIN Departement d1_ ON d1_.id = p2_.departement_id INNER JOIN PrestataireCategorie p4_ ON p0_.id = p4_.prestataire_id INNER JOIN Categorie c3_ ON c3_.id = p4_.categorie_id AND (c3_.id = 72) WHERE p0_.status = 'valid' AND (p0_.code_postal LIKE '40%' OR d1_.code LIKE '40%');

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_
  INNER JOIN Url u1_ ON p0_.url_id = u1_.id
WHERE
  p0_.type = ?
  AND p0_.parent_id = ?
ORDER BY
  p0_.page_order ASC

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_ INNER JOIN Url u1_ ON p0_.url_id = u1_.id WHERE p0_.type = 'categorie' AND p0_.parent_id = 122 ORDER BY p0_.page_order 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
  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
  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
  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
  p0_.title AS title_0,
  d1_.code AS code_1,
  p2_.meta_value AS meta_value_2,
  d1_.name AS name_3,
  p0_.menu_label AS menu_label_4
FROM
  Departement d1_
  INNER JOIN PageMeta p3_ ON (
    p3_.meta_key = 'departement'
    AND p3_.meta_value = d1_.code
  )
  INNER JOIN Page p0_ ON p3_.page_id = p0_.id
  AND (p0_.type = ?)
  INNER JOIN PageMeta p2_ ON p0_.id = p2_.page_id
  AND (
    p2_.meta_key = 'cp'
    AND p2_.meta_value IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
ORDER BY
  p0_.title ASC

SELECT p0_.title AS title_0, d1_.code AS code_1, p2_.meta_value AS meta_value_2, d1_.name AS name_3, p0_.menu_label AS menu_label_4 FROM Departement d1_ INNER JOIN PageMeta p3_ ON (p3_.meta_key = 'departement' AND p3_.meta_value = d1_.code) INNER JOIN Page p0_ ON p3_.page_id = p0_.id AND (p0_.type = 'local') INNER JOIN PageMeta p2_ ON p0_.id = p2_.page_id AND (p2_.meta_key = 'cp' AND p2_.meta_value IN ('33000', '59000', '69000', '13000', '34000', '44000', '06000', '75000', '67000', '31000')) ORDER BY p0_.title ASC;

SELECT
  p0_.id AS id_0,
  c1_.id AS id_1,
  c1_.name AS name_2
FROM
  Prestataire p0_
  INNER JOIN PrestataireCategorie p3_ ON p0_.id = p3_.prestataire_id
  INNER JOIN Categorie c2_ ON c2_.id = p3_.categorie_id
  INNER JOIN Categorie c1_ ON c2_.group_id = c1_.id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
GROUP BY
  p0_.id,
  c1_.id
ORDER BY
  c1_.ordre ASC

SELECT p0_.id AS id_0, c1_.id AS id_1, c1_.name AS name_2 FROM Prestataire p0_ INNER JOIN PrestataireCategorie p3_ ON p0_.id = p3_.prestataire_id INNER JOIN Categorie c2_ ON c2_.id = p3_.categorie_id INNER JOIN Categorie c1_ ON c2_.group_id = c1_.id WHERE p0_.id IN (58, 60, 95, 97, 114, 211, 246, 248, 338, 388, 420, 478, 480, 490, 538, 585, 699) GROUP BY p0_.id, c1_.id ORDER BY c1_.ordre ASC;

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 = 'facebook_url' LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

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_
WHERE
  d0_.code = ?

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_ WHERE d0_.code = '40';

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
  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
FROM
  Region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM Region t0 WHERE t0.id = 10;