Symfony Profiler

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 = 'local_index';

SELECT
  p0_.title AS title_0,
  d1_.code AS code_1,
  p2_.meta_value AS meta_value_2,
  d1_.name AS name_3,
  COALESCE(r3_.name, d1_.name) AS sclr_4,
  d1_.slug AS slug_5
FROM
  Departement d1_
  LEFT JOIN PageMeta p4_ ON (
    p4_.meta_key = 'departement'
    AND p4_.meta_value = d1_.code
  )
  LEFT JOIN Page p0_ ON p4_.page_id = p0_.id
  AND (p0_.type = ?)
  LEFT JOIN PageMeta p2_ ON p0_.id = p2_.page_id
  AND (p2_.meta_key = 'cp')
  LEFT JOIN Region r3_ ON d1_.region_id = r3_.id
ORDER BY
  sclr_4 ASC,
  code_1 ASC,
  title_0 ASC

SELECT p0_.title AS title_0, d1_.code AS code_1, p2_.meta_value AS meta_value_2, d1_.name AS name_3, COALESCE(r3_.name, d1_.name) AS sclr_4, d1_.slug AS slug_5 FROM Departement d1_ LEFT JOIN PageMeta p4_ ON (p4_.meta_key = 'departement' AND p4_.meta_value = d1_.code) LEFT JOIN Page p0_ ON p4_.page_id = p0_.id AND (p0_.type = 'local') LEFT JOIN PageMeta p2_ ON p0_.id = p2_.page_id AND (p2_.meta_key = 'cp') LEFT JOIN Region r3_ ON d1_.region_id = r3_.id ORDER BY sclr_4 ASC, code_1 ASC, title_0 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 '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 '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 '15%' OR d1_.code LIKE '15%');

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

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

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

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

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

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

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

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

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 ?
  )