Symfony Profiler

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,
  p1_.meta_value AS meta_value_1,
  p2_.meta_value AS meta_value_2,
  p0_.modified_date AS modified_date_3
FROM
  Page p0_
  INNER JOIN PageMeta p1_ ON p0_.id = p1_.page_id
  AND (p1_.meta_key = 'departement')
  INNER JOIN PageMeta p2_ ON p0_.id = p2_.page_id
  AND (p2_.meta_key = 'cp')
WHERE
  p0_.type = ?
ORDER BY
  title_0 ASC

SELECT p0_.title AS title_0, p1_.meta_value AS meta_value_1, p2_.meta_value AS meta_value_2, p0_.modified_date AS modified_date_3 FROM Page p0_ INNER JOIN PageMeta p1_ ON p0_.id = p1_.page_id AND (p1_.meta_key = 'departement') INNER JOIN PageMeta p2_ ON p0_.id = p2_.page_id AND (p2_.meta_key = 'cp') WHERE p0_.type = 'local' ORDER BY title_0 ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.region_id AS region_id_5
FROM
  Departement t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.slug AS slug_4, t0.region_id AS region_id_5 FROM Departement t0 ORDER BY t0.name ASC;

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 '01%' OR d1_.code LIKE '01%');

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 '02%' OR d1_.code LIKE '02%');

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 '03%' OR d1_.code LIKE '03%');

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 '04%' OR d1_.code LIKE '04%');

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 '06%' OR d1_.code LIKE '06%');

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 '07%' OR d1_.code LIKE '07%');

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 '08%' OR d1_.code LIKE '08%');

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 '09%' OR d1_.code LIKE '09%');

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 '10%' OR d1_.code LIKE '10%');

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 '11%' OR d1_.code LIKE '11%');

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 '12%' OR d1_.code LIKE '12%');

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 '67%' OR d1_.code LIKE '67%');

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 '13%' OR d1_.code LIKE '13%');