Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.zipcode AS zipcode_2, 
  t0.city AS city_3, 
  t0.country AS country_4, 
  t0.region AS region_5, 
  t0.department AS department_6, 
  t0.parent_id AS parent_id_7, 
  t0.created AS created_8, 
  t0.updated AS updated_9, 
  t0.centers_title_seo AS centers_title_seo_10, 
  t0.professionals_title_seo AS professionals_title_seo_11, 
  t0.doctors_title_seo AS doctors_title_seo_12, 
  t0.suppliers_title_seo AS suppliers_title_seo_13, 
  t0.speechtherapists_title_seo AS speechtherapists_title_seo_14, 
  t0.networks_title_seo AS networks_title_seo_15, 
  t0.services_title_seo AS services_title_seo_16, 
  t0.special_schools_title_seo AS special_schools_title_seo_17, 
  t0.agencies_title_seo AS agencies_title_seo_18, 
  t0.training_centers_title_seo AS training_centers_title_seo_19, 
  t0.centers_description_seo AS centers_description_seo_20, 
  t0.professionals_description_seo AS professionals_description_seo_21, 
  t0.doctors_description_seo AS doctors_description_seo_22, 
  t0.suppliers_description_seo AS suppliers_description_seo_23, 
  t0.speechtherapists_description_seo AS speechtherapists_description_seo_24, 
  t0.networks_description_seo AS networks_description_seo_25, 
  t0.services_description_seo AS services_description_seo_26, 
  t0.special_schools_description_seo AS special_schools_description_seo_27, 
  t0.agencies_description_seo AS agencies_description_seo_28, 
  t0.training_centers_description_seo AS training_centers_description_seo_29, 
  t0.cities_id AS cities_id_30 
FROM 
  zipcode t0 
WHERE 
  t0.zipcode = ? 
  AND t0.city = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.city AS city_3, t0.country AS country_4, t0.region AS region_5, t0.department AS department_6, t0.parent_id AS parent_id_7, t0.created AS created_8, t0.updated AS updated_9, t0.centers_title_seo AS centers_title_seo_10, t0.professionals_title_seo AS professionals_title_seo_11, t0.doctors_title_seo AS doctors_title_seo_12, t0.suppliers_title_seo AS suppliers_title_seo_13, t0.speechtherapists_title_seo AS speechtherapists_title_seo_14, t0.networks_title_seo AS networks_title_seo_15, t0.services_title_seo AS services_title_seo_16, t0.special_schools_title_seo AS special_schools_title_seo_17, t0.agencies_title_seo AS agencies_title_seo_18, t0.training_centers_title_seo AS training_centers_title_seo_19, t0.centers_description_seo AS centers_description_seo_20, t0.professionals_description_seo AS professionals_description_seo_21, t0.doctors_description_seo AS doctors_description_seo_22, t0.suppliers_description_seo AS suppliers_description_seo_23, t0.speechtherapists_description_seo AS speechtherapists_description_seo_24, t0.networks_description_seo AS networks_description_seo_25, t0.services_description_seo AS services_description_seo_26, t0.special_schools_description_seo AS special_schools_description_seo_27, t0.agencies_description_seo AS agencies_description_seo_28, t0.training_centers_description_seo AS training_centers_description_seo_29, t0.cities_id AS cities_id_30 FROM zipcode t0 WHERE t0.zipcode = '24750' AND t0.city = 'CHAMPCEVINEL' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.zip_code AS zip_code_2, 
  t0.ville AS ville_3, 
  t0.region AS region_4, 
  t0.dept_txt AS dept_txt_5, 
  t0.dept_code AS dept_code_6, 
  t0.lat AS lat_7, 
  t0.lng AS lng_8 
FROM 
  cities t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.ville AS ville_3, t0.region AS region_4, t0.dept_txt AS dept_txt_5, t0.dept_code AS dept_code_6, t0.lat AS lat_7, t0.lng AS lng_8 FROM cities t0 WHERE t0.id = 33941;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 445 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(c0_.lat)
      ) * COS(
        RADIANS(c0_.lng) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(c0_.lat)
      )
    )
  ) AS sclr_0, 
  z1_.id AS id_1, 
  z1_.zipcode AS zipcode_2, 
  z1_.city AS city_3, 
  z1_.country AS country_4, 
  z1_.region AS region_5, 
  z1_.department AS department_6, 
  z1_.parent_id AS parent_id_7, 
  z1_.created AS created_8, 
  z1_.updated AS updated_9, 
  z1_.centers_title_seo AS centers_title_seo_10, 
  z1_.professionals_title_seo AS professionals_title_seo_11, 
  z1_.doctors_title_seo AS doctors_title_seo_12, 
  z1_.suppliers_title_seo AS suppliers_title_seo_13, 
  z1_.speechtherapists_title_seo AS speechtherapists_title_seo_14, 
  z1_.networks_title_seo AS networks_title_seo_15, 
  z1_.services_title_seo AS services_title_seo_16, 
  z1_.special_schools_title_seo AS special_schools_title_seo_17, 
  z1_.agencies_title_seo AS agencies_title_seo_18, 
  z1_.training_centers_title_seo AS training_centers_title_seo_19, 
  z1_.centers_description_seo AS centers_description_seo_20, 
  z1_.professionals_description_seo AS professionals_description_seo_21, 
  z1_.doctors_description_seo AS doctors_description_seo_22, 
  z1_.suppliers_description_seo AS suppliers_description_seo_23, 
  z1_.speechtherapists_description_seo AS speechtherapists_description_seo_24, 
  z1_.networks_description_seo AS networks_description_seo_25, 
  z1_.services_description_seo AS services_description_seo_26, 
  z1_.special_schools_description_seo AS special_schools_description_seo_27, 
  z1_.agencies_description_seo AS agencies_description_seo_28, 
  z1_.training_centers_description_seo AS training_centers_description_seo_29, 
  c0_.id AS id_30, 
  c0_.zip_code AS zip_code_31, 
  c0_.ville AS ville_32, 
  c0_.region AS region_33, 
  c0_.dept_txt AS dept_txt_34, 
  c0_.dept_code AS dept_code_35, 
  c0_.lat AS lat_36, 
  c0_.lng AS lng_37, 
  z1_.cities_id AS cities_id_38 
FROM 
  zipcode z1_ 
  LEFT JOIN cities c0_ ON z1_.cities_id = c0_.id 
WHERE 
  c0_.id = z1_.cities_id 
  AND c0_.id <> ? 
  AND (
    z1_.parent_id IS NULL 
    OR z1_.parent_id = ?
  ) 
GROUP BY 
  z1_.city 
HAVING 
  sclr_0 < 1000 
ORDER BY 
  sclr_0 ASC 
LIMIT 
  100

SELECT (6371 * ACOS(COS(RADIANS(45.2163)) * COS(RADIANS(c0_.lat)) * COS(RADIANS(c0_.lng) - RADIANS(0.728)) + SIN(RADIANS(45.2163)) * SIN(RADIANS(c0_.lat)))) AS sclr_0, z1_.id AS id_1, z1_.zipcode AS zipcode_2, z1_.city AS city_3, z1_.country AS country_4, z1_.region AS region_5, z1_.department AS department_6, z1_.parent_id AS parent_id_7, z1_.created AS created_8, z1_.updated AS updated_9, z1_.centers_title_seo AS centers_title_seo_10, z1_.professionals_title_seo AS professionals_title_seo_11, z1_.doctors_title_seo AS doctors_title_seo_12, z1_.suppliers_title_seo AS suppliers_title_seo_13, z1_.speechtherapists_title_seo AS speechtherapists_title_seo_14, z1_.networks_title_seo AS networks_title_seo_15, z1_.services_title_seo AS services_title_seo_16, z1_.special_schools_title_seo AS special_schools_title_seo_17, z1_.agencies_title_seo AS agencies_title_seo_18, z1_.training_centers_title_seo AS training_centers_title_seo_19, z1_.centers_description_seo AS centers_description_seo_20, z1_.professionals_description_seo AS professionals_description_seo_21, z1_.doctors_description_seo AS doctors_description_seo_22, z1_.suppliers_description_seo AS suppliers_description_seo_23, z1_.speechtherapists_description_seo AS speechtherapists_description_seo_24, z1_.networks_description_seo AS networks_description_seo_25, z1_.services_description_seo AS services_description_seo_26, z1_.special_schools_description_seo AS special_schools_description_seo_27, z1_.agencies_description_seo AS agencies_description_seo_28, z1_.training_centers_description_seo AS training_centers_description_seo_29, c0_.id AS id_30, c0_.zip_code AS zip_code_31, c0_.ville AS ville_32, c0_.region AS region_33, c0_.dept_txt AS dept_txt_34, c0_.dept_code AS dept_code_35, c0_.lat AS lat_36, c0_.lng AS lng_37, z1_.cities_id AS cities_id_38 FROM zipcode z1_ LEFT JOIN cities c0_ ON z1_.cities_id = c0_.id WHERE c0_.id = z1_.cities_id AND c0_.id <> 33941 AND (z1_.parent_id IS NULL OR z1_.parent_id = 0) GROUP BY z1_.city HAVING sclr_0 < 1000 ORDER BY sclr_0 ASC LIMIT 100;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 436 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 441 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 3837 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 2866 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 444 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 442 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 2869 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;

SELECT 
  h0_.id AS id_0, 
  h0_.corporate_name AS corporate_name_1, 
  h0_.corporate_name_2 AS corporate_name_2_2, 
  h0_.description AS description_3, 
  h0_.link AS link_4, 
  h0_.address AS address_5, 
  h0_.additional_address AS additional_address_6, 
  h0_.po_box AS po_box_7, 
  h0_.cedex AS cedex_8, 
  h0_.city_cedex AS city_cedex_9, 
  h0_.zip AS zip_10, 
  h0_.city AS city_11, 
  h0_.country AS country_12, 
  h0_.website AS website_13, 
  h0_.phone AS phone_14, 
  h0_.fax AS fax_15, 
  h0_.email AS email_16, 
  h0_.center_for_laryngectomy AS center_for_laryngectomy_17, 
  h0_.created AS created_18, 
  h0_.updated AS updated_19, 
  h0_.department AS department_20, 
  h0_.nouvelle_fiche AS nouvelle_fiche_21, 
  h0_.controle AS controle_22, 
  h0_.validate_with_modif AS validate_with_modif_23, 
  h0_.type_validate AS type_validate_24, 
  h0_.observation AS observation_25, 
  h0_.image AS image_26, 
  h0_.localisation_id AS localisation_id_27 
FROM 
  hospitals h0_ 
  LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) 
  INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) 
WHERE 
  z1_.id = ? 
GROUP BY 
  h0_.id 
ORDER BY 
  h0_.corporate_name ASC

SELECT h0_.id AS id_0, h0_.corporate_name AS corporate_name_1, h0_.corporate_name_2 AS corporate_name_2_2, h0_.description AS description_3, h0_.link AS link_4, h0_.address AS address_5, h0_.additional_address AS additional_address_6, h0_.po_box AS po_box_7, h0_.cedex AS cedex_8, h0_.city_cedex AS city_cedex_9, h0_.zip AS zip_10, h0_.city AS city_11, h0_.country AS country_12, h0_.website AS website_13, h0_.phone AS phone_14, h0_.fax AS fax_15, h0_.email AS email_16, h0_.center_for_laryngectomy AS center_for_laryngectomy_17, h0_.created AS created_18, h0_.updated AS updated_19, h0_.department AS department_20, h0_.nouvelle_fiche AS nouvelle_fiche_21, h0_.controle AS controle_22, h0_.validate_with_modif AS validate_with_modif_23, h0_.type_validate AS type_validate_24, h0_.observation AS observation_25, h0_.image AS image_26, h0_.localisation_id AS localisation_id_27 FROM hospitals h0_ LEFT JOIN zipcode z1_ ON (h0_.localisation_id = z1_.id) INNER JOIN services s2_ ON (s2_.hospital_id = h0_.id) WHERE z1_.id = 4048 GROUP BY h0_.id ORDER BY h0_.corporate_name ASC;