Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.prefixed AS prefixed_2,
  p0_.subdomain AS subdomain_3,
  p0_.external_url AS external_url_4,
  p0_.online AS online_5,
  p0_.intro_text AS intro_text_6,
  p0_.meta_description AS meta_description_7,
  p0_.cover_image_url AS cover_image_url_8,
  p0_.email AS email_9,
  p0_.assistent_email AS assistent_email_10,
  p0_.safe_email AS safe_email_11,
  p0_.phone AS phone_12,
  p0_.fax AS fax_13,
  p0_.pharmapartners_ref AS pharmapartners_ref_14,
  p0_.hroffice_company_name AS hroffice_company_name_15,
  p0_.zgz_url AS zgz_url_16,
  p0_.zorgkaart_code AS zorgkaart_code_17,
  p0_.address_street AS address_street_18,
  p0_.address_building_nr AS address_building_nr_19,
  p0_.address_addon AS address_addon_20,
  p0_.address_postalcode AS address_postalcode_21,
  p0_.address_city AS address_city_22,
  p0_.address_province AS address_province_23,
  p0_.address_country AS address_country_24,
  p0_.address_latitude AS address_latitude_25,
  p0_.address_longitude AS address_longitude_26,
  p0_.emergency_details_name AS emergency_details_name_27,
  p0_.emergency_details_description AS emergency_details_description_28,
  p0_.emergency_details_phone AS emergency_details_phone_29,
  p0_.emergency_details_email AS emergency_details_email_30,
  p0_.emergency_details_address_street AS emergency_details_address_street_31,
  p0_.emergency_details_address_building_nr AS emergency_details_address_building_nr_32,
  p0_.emergency_details_address_addon AS emergency_details_address_addon_33,
  p0_.emergency_details_address_postalcode AS emergency_details_address_postalcode_34,
  p0_.emergency_details_address_city AS emergency_details_address_city_35,
  p0_.emergency_details_address_province AS emergency_details_address_province_36,
  p0_.emergency_details_address_country AS emergency_details_address_country_37,
  p0_.emergency_details_address_latitude AS emergency_details_address_latitude_38,
  p0_.emergency_details_address_longitude AS emergency_details_address_longitude_39,
  p0_.emergency_details_backup_name AS emergency_details_backup_name_40,
  p0_.emergency_details_backup_description AS emergency_details_backup_description_41,
  p0_.emergency_details_backup_phone AS emergency_details_backup_phone_42,
  p0_.emergency_details_backup_email AS emergency_details_backup_email_43,
  p0_.emergency_details_backup_address_street AS emergency_details_backup_address_street_44,
  p0_.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_45,
  p0_.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_46,
  p0_.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_47,
  p0_.emergency_details_backup_address_city AS emergency_details_backup_address_city_48,
  p0_.emergency_details_backup_address_province AS emergency_details_backup_address_province_49,
  p0_.emergency_details_backup_address_country AS emergency_details_backup_address_country_50,
  p0_.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_51,
  p0_.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_52
FROM
  pharmacy p0_
  LEFT JOIN service_point s2_ ON p0_.id = s2_.service_point_id
  LEFT JOIN pharmacy p1_ ON p1_.id = s2_.parent_pharmacy_id
WHERE
  p0_.online <> 0
  AND (
    p1_.online <> 0
    OR p1_.id IS NULL
  )
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.prefixed AS prefixed_2, p0_.subdomain AS subdomain_3, p0_.external_url AS external_url_4, p0_.online AS online_5, p0_.intro_text AS intro_text_6, p0_.meta_description AS meta_description_7, p0_.cover_image_url AS cover_image_url_8, p0_.email AS email_9, p0_.assistent_email AS assistent_email_10, p0_.safe_email AS safe_email_11, p0_.phone AS phone_12, p0_.fax AS fax_13, p0_.pharmapartners_ref AS pharmapartners_ref_14, p0_.hroffice_company_name AS hroffice_company_name_15, p0_.zgz_url AS zgz_url_16, p0_.zorgkaart_code AS zorgkaart_code_17, p0_.address_street AS address_street_18, p0_.address_building_nr AS address_building_nr_19, p0_.address_addon AS address_addon_20, p0_.address_postalcode AS address_postalcode_21, p0_.address_city AS address_city_22, p0_.address_province AS address_province_23, p0_.address_country AS address_country_24, p0_.address_latitude AS address_latitude_25, p0_.address_longitude AS address_longitude_26, p0_.emergency_details_name AS emergency_details_name_27, p0_.emergency_details_description AS emergency_details_description_28, p0_.emergency_details_phone AS emergency_details_phone_29, p0_.emergency_details_email AS emergency_details_email_30, p0_.emergency_details_address_street AS emergency_details_address_street_31, p0_.emergency_details_address_building_nr AS emergency_details_address_building_nr_32, p0_.emergency_details_address_addon AS emergency_details_address_addon_33, p0_.emergency_details_address_postalcode AS emergency_details_address_postalcode_34, p0_.emergency_details_address_city AS emergency_details_address_city_35, p0_.emergency_details_address_province AS emergency_details_address_province_36, p0_.emergency_details_address_country AS emergency_details_address_country_37, p0_.emergency_details_address_latitude AS emergency_details_address_latitude_38, p0_.emergency_details_address_longitude AS emergency_details_address_longitude_39, p0_.emergency_details_backup_name AS emergency_details_backup_name_40, p0_.emergency_details_backup_description AS emergency_details_backup_description_41, p0_.emergency_details_backup_phone AS emergency_details_backup_phone_42, p0_.emergency_details_backup_email AS emergency_details_backup_email_43, p0_.emergency_details_backup_address_street AS emergency_details_backup_address_street_44, p0_.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_45, p0_.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_46, p0_.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_47, p0_.emergency_details_backup_address_city AS emergency_details_backup_address_city_48, p0_.emergency_details_backup_address_province AS emergency_details_backup_address_province_49, p0_.emergency_details_backup_address_country AS emergency_details_backup_address_country_50, p0_.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_51, p0_.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_52 FROM pharmacy p0_ LEFT JOIN service_point s2_ ON p0_.id = s2_.service_point_id LEFT JOIN pharmacy p1_ ON p1_.id = s2_.parent_pharmacy_id WHERE p0_.online <> 0 AND (p1_.online <> 0 OR p1_.id IS NULL) ORDER BY p0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.prefixed AS prefixed_3,
  t0.subdomain AS subdomain_4,
  t0.external_url AS external_url_5,
  t0.online AS online_6,
  t0.intro_text AS intro_text_7,
  t0.meta_description AS meta_description_8,
  t0.cover_image_url AS cover_image_url_9,
  t0.email AS email_10,
  t0.assistent_email AS assistent_email_11,
  t0.safe_email AS safe_email_12,
  t0.phone AS phone_13,
  t0.fax AS fax_14,
  t0.pharmapartners_ref AS pharmapartners_ref_15,
  t0.hroffice_company_name AS hroffice_company_name_16,
  t0.zgz_url AS zgz_url_17,
  t0.zorgkaart_code AS zorgkaart_code_18,
  t0.address_street AS address_street_19,
  t0.address_building_nr AS address_building_nr_20,
  t0.address_addon AS address_addon_21,
  t0.address_postalcode AS address_postalcode_22,
  t0.address_city AS address_city_23,
  t0.address_province AS address_province_24,
  t0.address_country AS address_country_25,
  t0.address_latitude AS address_latitude_26,
  t0.address_longitude AS address_longitude_27,
  t0.emergency_details_name AS emergency_details_name_28,
  t0.emergency_details_description AS emergency_details_description_29,
  t0.emergency_details_phone AS emergency_details_phone_30,
  t0.emergency_details_email AS emergency_details_email_31,
  t0.emergency_details_address_street AS emergency_details_address_street_32,
  t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33,
  t0.emergency_details_address_addon AS emergency_details_address_addon_34,
  t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35,
  t0.emergency_details_address_city AS emergency_details_address_city_36,
  t0.emergency_details_address_province AS emergency_details_address_province_37,
  t0.emergency_details_address_country AS emergency_details_address_country_38,
  t0.emergency_details_address_latitude AS emergency_details_address_latitude_39,
  t0.emergency_details_address_longitude AS emergency_details_address_longitude_40,
  t0.emergency_details_backup_name AS emergency_details_backup_name_41,
  t0.emergency_details_backup_description AS emergency_details_backup_description_42,
  t0.emergency_details_backup_phone AS emergency_details_backup_phone_43,
  t0.emergency_details_backup_email AS emergency_details_backup_email_44,
  t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45,
  t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46,
  t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47,
  t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48,
  t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49,
  t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50,
  t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51,
  t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52,
  t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53
FROM
  pharmacy t0
WHERE
  t0.subdomain = ?
  AND t0.online = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.prefixed AS prefixed_3, t0.subdomain AS subdomain_4, t0.external_url AS external_url_5, t0.online AS online_6, t0.intro_text AS intro_text_7, t0.meta_description AS meta_description_8, t0.cover_image_url AS cover_image_url_9, t0.email AS email_10, t0.assistent_email AS assistent_email_11, t0.safe_email AS safe_email_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.pharmapartners_ref AS pharmapartners_ref_15, t0.hroffice_company_name AS hroffice_company_name_16, t0.zgz_url AS zgz_url_17, t0.zorgkaart_code AS zorgkaart_code_18, t0.address_street AS address_street_19, t0.address_building_nr AS address_building_nr_20, t0.address_addon AS address_addon_21, t0.address_postalcode AS address_postalcode_22, t0.address_city AS address_city_23, t0.address_province AS address_province_24, t0.address_country AS address_country_25, t0.address_latitude AS address_latitude_26, t0.address_longitude AS address_longitude_27, t0.emergency_details_name AS emergency_details_name_28, t0.emergency_details_description AS emergency_details_description_29, t0.emergency_details_phone AS emergency_details_phone_30, t0.emergency_details_email AS emergency_details_email_31, t0.emergency_details_address_street AS emergency_details_address_street_32, t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33, t0.emergency_details_address_addon AS emergency_details_address_addon_34, t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35, t0.emergency_details_address_city AS emergency_details_address_city_36, t0.emergency_details_address_province AS emergency_details_address_province_37, t0.emergency_details_address_country AS emergency_details_address_country_38, t0.emergency_details_address_latitude AS emergency_details_address_latitude_39, t0.emergency_details_address_longitude AS emergency_details_address_longitude_40, t0.emergency_details_backup_name AS emergency_details_backup_name_41, t0.emergency_details_backup_description AS emergency_details_backup_description_42, t0.emergency_details_backup_phone AS emergency_details_backup_phone_43, t0.emergency_details_backup_email AS emergency_details_backup_email_44, t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45, t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46, t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47, t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48, t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49, t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50, t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51, t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52, t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53 FROM pharmacy t0 WHERE t0.subdomain = 'medsen' AND t0.online = 'false' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.prefixed AS prefixed_3,
  t0.subdomain AS subdomain_4,
  t0.external_url AS external_url_5,
  t0.online AS online_6,
  t0.intro_text AS intro_text_7,
  t0.meta_description AS meta_description_8,
  t0.cover_image_url AS cover_image_url_9,
  t0.email AS email_10,
  t0.assistent_email AS assistent_email_11,
  t0.safe_email AS safe_email_12,
  t0.phone AS phone_13,
  t0.fax AS fax_14,
  t0.pharmapartners_ref AS pharmapartners_ref_15,
  t0.hroffice_company_name AS hroffice_company_name_16,
  t0.zgz_url AS zgz_url_17,
  t0.zorgkaart_code AS zorgkaart_code_18,
  t0.address_street AS address_street_19,
  t0.address_building_nr AS address_building_nr_20,
  t0.address_addon AS address_addon_21,
  t0.address_postalcode AS address_postalcode_22,
  t0.address_city AS address_city_23,
  t0.address_province AS address_province_24,
  t0.address_country AS address_country_25,
  t0.address_latitude AS address_latitude_26,
  t0.address_longitude AS address_longitude_27,
  t0.emergency_details_name AS emergency_details_name_28,
  t0.emergency_details_description AS emergency_details_description_29,
  t0.emergency_details_phone AS emergency_details_phone_30,
  t0.emergency_details_email AS emergency_details_email_31,
  t0.emergency_details_address_street AS emergency_details_address_street_32,
  t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33,
  t0.emergency_details_address_addon AS emergency_details_address_addon_34,
  t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35,
  t0.emergency_details_address_city AS emergency_details_address_city_36,
  t0.emergency_details_address_province AS emergency_details_address_province_37,
  t0.emergency_details_address_country AS emergency_details_address_country_38,
  t0.emergency_details_address_latitude AS emergency_details_address_latitude_39,
  t0.emergency_details_address_longitude AS emergency_details_address_longitude_40,
  t0.emergency_details_backup_name AS emergency_details_backup_name_41,
  t0.emergency_details_backup_description AS emergency_details_backup_description_42,
  t0.emergency_details_backup_phone AS emergency_details_backup_phone_43,
  t0.emergency_details_backup_email AS emergency_details_backup_email_44,
  t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45,
  t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46,
  t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47,
  t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48,
  t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49,
  t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50,
  t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51,
  t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52,
  t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53
FROM
  pharmacy t0
WHERE
  t0.subdomain = ?
  AND t0.online = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.prefixed AS prefixed_3, t0.subdomain AS subdomain_4, t0.external_url AS external_url_5, t0.online AS online_6, t0.intro_text AS intro_text_7, t0.meta_description AS meta_description_8, t0.cover_image_url AS cover_image_url_9, t0.email AS email_10, t0.assistent_email AS assistent_email_11, t0.safe_email AS safe_email_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.pharmapartners_ref AS pharmapartners_ref_15, t0.hroffice_company_name AS hroffice_company_name_16, t0.zgz_url AS zgz_url_17, t0.zorgkaart_code AS zorgkaart_code_18, t0.address_street AS address_street_19, t0.address_building_nr AS address_building_nr_20, t0.address_addon AS address_addon_21, t0.address_postalcode AS address_postalcode_22, t0.address_city AS address_city_23, t0.address_province AS address_province_24, t0.address_country AS address_country_25, t0.address_latitude AS address_latitude_26, t0.address_longitude AS address_longitude_27, t0.emergency_details_name AS emergency_details_name_28, t0.emergency_details_description AS emergency_details_description_29, t0.emergency_details_phone AS emergency_details_phone_30, t0.emergency_details_email AS emergency_details_email_31, t0.emergency_details_address_street AS emergency_details_address_street_32, t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33, t0.emergency_details_address_addon AS emergency_details_address_addon_34, t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35, t0.emergency_details_address_city AS emergency_details_address_city_36, t0.emergency_details_address_province AS emergency_details_address_province_37, t0.emergency_details_address_country AS emergency_details_address_country_38, t0.emergency_details_address_latitude AS emergency_details_address_latitude_39, t0.emergency_details_address_longitude AS emergency_details_address_longitude_40, t0.emergency_details_backup_name AS emergency_details_backup_name_41, t0.emergency_details_backup_description AS emergency_details_backup_description_42, t0.emergency_details_backup_phone AS emergency_details_backup_phone_43, t0.emergency_details_backup_email AS emergency_details_backup_email_44, t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45, t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46, t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47, t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48, t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49, t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50, t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51, t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52, t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53 FROM pharmacy t0 WHERE t0.subdomain = 'medsen' AND t0.online = 'false' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.prefixed AS prefixed_3,
  t0.subdomain AS subdomain_4,
  t0.external_url AS external_url_5,
  t0.online AS online_6,
  t0.intro_text AS intro_text_7,
  t0.meta_description AS meta_description_8,
  t0.cover_image_url AS cover_image_url_9,
  t0.email AS email_10,
  t0.assistent_email AS assistent_email_11,
  t0.safe_email AS safe_email_12,
  t0.phone AS phone_13,
  t0.fax AS fax_14,
  t0.pharmapartners_ref AS pharmapartners_ref_15,
  t0.hroffice_company_name AS hroffice_company_name_16,
  t0.zgz_url AS zgz_url_17,
  t0.zorgkaart_code AS zorgkaart_code_18,
  t0.address_street AS address_street_19,
  t0.address_building_nr AS address_building_nr_20,
  t0.address_addon AS address_addon_21,
  t0.address_postalcode AS address_postalcode_22,
  t0.address_city AS address_city_23,
  t0.address_province AS address_province_24,
  t0.address_country AS address_country_25,
  t0.address_latitude AS address_latitude_26,
  t0.address_longitude AS address_longitude_27,
  t0.emergency_details_name AS emergency_details_name_28,
  t0.emergency_details_description AS emergency_details_description_29,
  t0.emergency_details_phone AS emergency_details_phone_30,
  t0.emergency_details_email AS emergency_details_email_31,
  t0.emergency_details_address_street AS emergency_details_address_street_32,
  t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33,
  t0.emergency_details_address_addon AS emergency_details_address_addon_34,
  t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35,
  t0.emergency_details_address_city AS emergency_details_address_city_36,
  t0.emergency_details_address_province AS emergency_details_address_province_37,
  t0.emergency_details_address_country AS emergency_details_address_country_38,
  t0.emergency_details_address_latitude AS emergency_details_address_latitude_39,
  t0.emergency_details_address_longitude AS emergency_details_address_longitude_40,
  t0.emergency_details_backup_name AS emergency_details_backup_name_41,
  t0.emergency_details_backup_description AS emergency_details_backup_description_42,
  t0.emergency_details_backup_phone AS emergency_details_backup_phone_43,
  t0.emergency_details_backup_email AS emergency_details_backup_email_44,
  t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45,
  t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46,
  t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47,
  t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48,
  t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49,
  t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50,
  t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51,
  t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52,
  t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53
FROM
  pharmacy t0
  INNER JOIN service_point ON t0.id = service_point.parent_pharmacy_id
WHERE
  service_point.service_point_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.prefixed AS prefixed_3, t0.subdomain AS subdomain_4, t0.external_url AS external_url_5, t0.online AS online_6, t0.intro_text AS intro_text_7, t0.meta_description AS meta_description_8, t0.cover_image_url AS cover_image_url_9, t0.email AS email_10, t0.assistent_email AS assistent_email_11, t0.safe_email AS safe_email_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.pharmapartners_ref AS pharmapartners_ref_15, t0.hroffice_company_name AS hroffice_company_name_16, t0.zgz_url AS zgz_url_17, t0.zorgkaart_code AS zorgkaart_code_18, t0.address_street AS address_street_19, t0.address_building_nr AS address_building_nr_20, t0.address_addon AS address_addon_21, t0.address_postalcode AS address_postalcode_22, t0.address_city AS address_city_23, t0.address_province AS address_province_24, t0.address_country AS address_country_25, t0.address_latitude AS address_latitude_26, t0.address_longitude AS address_longitude_27, t0.emergency_details_name AS emergency_details_name_28, t0.emergency_details_description AS emergency_details_description_29, t0.emergency_details_phone AS emergency_details_phone_30, t0.emergency_details_email AS emergency_details_email_31, t0.emergency_details_address_street AS emergency_details_address_street_32, t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33, t0.emergency_details_address_addon AS emergency_details_address_addon_34, t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35, t0.emergency_details_address_city AS emergency_details_address_city_36, t0.emergency_details_address_province AS emergency_details_address_province_37, t0.emergency_details_address_country AS emergency_details_address_country_38, t0.emergency_details_address_latitude AS emergency_details_address_latitude_39, t0.emergency_details_address_longitude AS emergency_details_address_longitude_40, t0.emergency_details_backup_name AS emergency_details_backup_name_41, t0.emergency_details_backup_description AS emergency_details_backup_description_42, t0.emergency_details_backup_phone AS emergency_details_backup_phone_43, t0.emergency_details_backup_email AS emergency_details_backup_email_44, t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45, t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46, t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47, t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48, t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49, t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50, t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51, t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52, t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53 FROM pharmacy t0 INNER JOIN service_point ON t0.id = service_point.parent_pharmacy_id WHERE service_point.service_point_id = 2;

SELECT
  b0_.id AS id_0,
  b0_.label AS label_1,
  b0_.opening_time AS opening_time_2,
  b0_.closing_time AS closing_time_3,
  b0_.closed AS closed_4,
  b0_.breaks AS breaks_5,
  b0_.day AS day_6,
  b0_.date AS date_7,
  b0_.holiday AS holiday_8,
  b0_.override_closed_default AS override_closed_default_9,
  b0_.pharmacy_id AS pharmacy_id_10
FROM
  business_day b0_
WHERE
  b0_.pharmacy_id = ?
  AND (
    b0_.date IS NULL
    OR b0_.date >= ?
  )

SELECT b0_.id AS id_0, b0_.label AS label_1, b0_.opening_time AS opening_time_2, b0_.closing_time AS closing_time_3, b0_.closed AS closed_4, b0_.breaks AS breaks_5, b0_.day AS day_6, b0_.date AS date_7, b0_.holiday AS holiday_8, b0_.override_closed_default AS override_closed_default_9, b0_.pharmacy_id AS pharmacy_id_10 FROM business_day b0_ WHERE b0_.pharmacy_id = 2 AND (b0_.date IS NULL OR b0_.date >= '2025-12-06');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.prefixed AS prefixed_3,
  t0.subdomain AS subdomain_4,
  t0.external_url AS external_url_5,
  t0.online AS online_6,
  t0.intro_text AS intro_text_7,
  t0.meta_description AS meta_description_8,
  t0.cover_image_url AS cover_image_url_9,
  t0.email AS email_10,
  t0.assistent_email AS assistent_email_11,
  t0.safe_email AS safe_email_12,
  t0.phone AS phone_13,
  t0.fax AS fax_14,
  t0.pharmapartners_ref AS pharmapartners_ref_15,
  t0.hroffice_company_name AS hroffice_company_name_16,
  t0.zgz_url AS zgz_url_17,
  t0.zorgkaart_code AS zorgkaart_code_18,
  t0.address_street AS address_street_19,
  t0.address_building_nr AS address_building_nr_20,
  t0.address_addon AS address_addon_21,
  t0.address_postalcode AS address_postalcode_22,
  t0.address_city AS address_city_23,
  t0.address_province AS address_province_24,
  t0.address_country AS address_country_25,
  t0.address_latitude AS address_latitude_26,
  t0.address_longitude AS address_longitude_27,
  t0.emergency_details_name AS emergency_details_name_28,
  t0.emergency_details_description AS emergency_details_description_29,
  t0.emergency_details_phone AS emergency_details_phone_30,
  t0.emergency_details_email AS emergency_details_email_31,
  t0.emergency_details_address_street AS emergency_details_address_street_32,
  t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33,
  t0.emergency_details_address_addon AS emergency_details_address_addon_34,
  t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35,
  t0.emergency_details_address_city AS emergency_details_address_city_36,
  t0.emergency_details_address_province AS emergency_details_address_province_37,
  t0.emergency_details_address_country AS emergency_details_address_country_38,
  t0.emergency_details_address_latitude AS emergency_details_address_latitude_39,
  t0.emergency_details_address_longitude AS emergency_details_address_longitude_40,
  t0.emergency_details_backup_name AS emergency_details_backup_name_41,
  t0.emergency_details_backup_description AS emergency_details_backup_description_42,
  t0.emergency_details_backup_phone AS emergency_details_backup_phone_43,
  t0.emergency_details_backup_email AS emergency_details_backup_email_44,
  t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45,
  t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46,
  t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47,
  t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48,
  t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49,
  t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50,
  t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51,
  t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52,
  t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53
FROM
  pharmacy t0
  INNER JOIN service_point ON t0.id = service_point.service_point_id
WHERE
  service_point.parent_pharmacy_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.prefixed AS prefixed_3, t0.subdomain AS subdomain_4, t0.external_url AS external_url_5, t0.online AS online_6, t0.intro_text AS intro_text_7, t0.meta_description AS meta_description_8, t0.cover_image_url AS cover_image_url_9, t0.email AS email_10, t0.assistent_email AS assistent_email_11, t0.safe_email AS safe_email_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.pharmapartners_ref AS pharmapartners_ref_15, t0.hroffice_company_name AS hroffice_company_name_16, t0.zgz_url AS zgz_url_17, t0.zorgkaart_code AS zorgkaart_code_18, t0.address_street AS address_street_19, t0.address_building_nr AS address_building_nr_20, t0.address_addon AS address_addon_21, t0.address_postalcode AS address_postalcode_22, t0.address_city AS address_city_23, t0.address_province AS address_province_24, t0.address_country AS address_country_25, t0.address_latitude AS address_latitude_26, t0.address_longitude AS address_longitude_27, t0.emergency_details_name AS emergency_details_name_28, t0.emergency_details_description AS emergency_details_description_29, t0.emergency_details_phone AS emergency_details_phone_30, t0.emergency_details_email AS emergency_details_email_31, t0.emergency_details_address_street AS emergency_details_address_street_32, t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33, t0.emergency_details_address_addon AS emergency_details_address_addon_34, t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35, t0.emergency_details_address_city AS emergency_details_address_city_36, t0.emergency_details_address_province AS emergency_details_address_province_37, t0.emergency_details_address_country AS emergency_details_address_country_38, t0.emergency_details_address_latitude AS emergency_details_address_latitude_39, t0.emergency_details_address_longitude AS emergency_details_address_longitude_40, t0.emergency_details_backup_name AS emergency_details_backup_name_41, t0.emergency_details_backup_description AS emergency_details_backup_description_42, t0.emergency_details_backup_phone AS emergency_details_backup_phone_43, t0.emergency_details_backup_email AS emergency_details_backup_email_44, t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45, t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46, t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47, t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48, t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49, t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50, t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51, t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52, t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53 FROM pharmacy t0 INNER JOIN service_point ON t0.id = service_point.service_point_id WHERE service_point.parent_pharmacy_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.prefixed AS prefixed_3,
  t0.subdomain AS subdomain_4,
  t0.external_url AS external_url_5,
  t0.online AS online_6,
  t0.intro_text AS intro_text_7,
  t0.meta_description AS meta_description_8,
  t0.cover_image_url AS cover_image_url_9,
  t0.email AS email_10,
  t0.assistent_email AS assistent_email_11,
  t0.safe_email AS safe_email_12,
  t0.phone AS phone_13,
  t0.fax AS fax_14,
  t0.pharmapartners_ref AS pharmapartners_ref_15,
  t0.hroffice_company_name AS hroffice_company_name_16,
  t0.zgz_url AS zgz_url_17,
  t0.zorgkaart_code AS zorgkaart_code_18,
  t0.address_street AS address_street_19,
  t0.address_building_nr AS address_building_nr_20,
  t0.address_addon AS address_addon_21,
  t0.address_postalcode AS address_postalcode_22,
  t0.address_city AS address_city_23,
  t0.address_province AS address_province_24,
  t0.address_country AS address_country_25,
  t0.address_latitude AS address_latitude_26,
  t0.address_longitude AS address_longitude_27,
  t0.emergency_details_name AS emergency_details_name_28,
  t0.emergency_details_description AS emergency_details_description_29,
  t0.emergency_details_phone AS emergency_details_phone_30,
  t0.emergency_details_email AS emergency_details_email_31,
  t0.emergency_details_address_street AS emergency_details_address_street_32,
  t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33,
  t0.emergency_details_address_addon AS emergency_details_address_addon_34,
  t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35,
  t0.emergency_details_address_city AS emergency_details_address_city_36,
  t0.emergency_details_address_province AS emergency_details_address_province_37,
  t0.emergency_details_address_country AS emergency_details_address_country_38,
  t0.emergency_details_address_latitude AS emergency_details_address_latitude_39,
  t0.emergency_details_address_longitude AS emergency_details_address_longitude_40,
  t0.emergency_details_backup_name AS emergency_details_backup_name_41,
  t0.emergency_details_backup_description AS emergency_details_backup_description_42,
  t0.emergency_details_backup_phone AS emergency_details_backup_phone_43,
  t0.emergency_details_backup_email AS emergency_details_backup_email_44,
  t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45,
  t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46,
  t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47,
  t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48,
  t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49,
  t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50,
  t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51,
  t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52,
  t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53
FROM
  pharmacy t0
  INNER JOIN service_point ON t0.id = service_point.parent_pharmacy_id
WHERE
  service_point.service_point_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.prefixed AS prefixed_3, t0.subdomain AS subdomain_4, t0.external_url AS external_url_5, t0.online AS online_6, t0.intro_text AS intro_text_7, t0.meta_description AS meta_description_8, t0.cover_image_url AS cover_image_url_9, t0.email AS email_10, t0.assistent_email AS assistent_email_11, t0.safe_email AS safe_email_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.pharmapartners_ref AS pharmapartners_ref_15, t0.hroffice_company_name AS hroffice_company_name_16, t0.zgz_url AS zgz_url_17, t0.zorgkaart_code AS zorgkaart_code_18, t0.address_street AS address_street_19, t0.address_building_nr AS address_building_nr_20, t0.address_addon AS address_addon_21, t0.address_postalcode AS address_postalcode_22, t0.address_city AS address_city_23, t0.address_province AS address_province_24, t0.address_country AS address_country_25, t0.address_latitude AS address_latitude_26, t0.address_longitude AS address_longitude_27, t0.emergency_details_name AS emergency_details_name_28, t0.emergency_details_description AS emergency_details_description_29, t0.emergency_details_phone AS emergency_details_phone_30, t0.emergency_details_email AS emergency_details_email_31, t0.emergency_details_address_street AS emergency_details_address_street_32, t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33, t0.emergency_details_address_addon AS emergency_details_address_addon_34, t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35, t0.emergency_details_address_city AS emergency_details_address_city_36, t0.emergency_details_address_province AS emergency_details_address_province_37, t0.emergency_details_address_country AS emergency_details_address_country_38, t0.emergency_details_address_latitude AS emergency_details_address_latitude_39, t0.emergency_details_address_longitude AS emergency_details_address_longitude_40, t0.emergency_details_backup_name AS emergency_details_backup_name_41, t0.emergency_details_backup_description AS emergency_details_backup_description_42, t0.emergency_details_backup_phone AS emergency_details_backup_phone_43, t0.emergency_details_backup_email AS emergency_details_backup_email_44, t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45, t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46, t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47, t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48, t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49, t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50, t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51, t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52, t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53 FROM pharmacy t0 INNER JOIN service_point ON t0.id = service_point.parent_pharmacy_id WHERE service_point.service_point_id = 6;

SELECT
  b0_.id AS id_0,
  b0_.label AS label_1,
  b0_.opening_time AS opening_time_2,
  b0_.closing_time AS closing_time_3,
  b0_.closed AS closed_4,
  b0_.breaks AS breaks_5,
  b0_.day AS day_6,
  b0_.date AS date_7,
  b0_.holiday AS holiday_8,
  b0_.override_closed_default AS override_closed_default_9,
  b0_.pharmacy_id AS pharmacy_id_10
FROM
  business_day b0_
WHERE
  b0_.pharmacy_id = ?
  AND (
    b0_.date IS NULL
    OR b0_.date >= ?
  )

SELECT b0_.id AS id_0, b0_.label AS label_1, b0_.opening_time AS opening_time_2, b0_.closing_time AS closing_time_3, b0_.closed AS closed_4, b0_.breaks AS breaks_5, b0_.day AS day_6, b0_.date AS date_7, b0_.holiday AS holiday_8, b0_.override_closed_default AS override_closed_default_9, b0_.pharmacy_id AS pharmacy_id_10 FROM business_day b0_ WHERE b0_.pharmacy_id = 6 AND (b0_.date IS NULL OR b0_.date >= '2025-12-06');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.prefixed AS prefixed_3,
  t0.subdomain AS subdomain_4,
  t0.external_url AS external_url_5,
  t0.online AS online_6,
  t0.intro_text AS intro_text_7,
  t0.meta_description AS meta_description_8,
  t0.cover_image_url AS cover_image_url_9,
  t0.email AS email_10,
  t0.assistent_email AS assistent_email_11,
  t0.safe_email AS safe_email_12,
  t0.phone AS phone_13,
  t0.fax AS fax_14,
  t0.pharmapartners_ref AS pharmapartners_ref_15,
  t0.hroffice_company_name AS hroffice_company_name_16,
  t0.zgz_url AS zgz_url_17,
  t0.zorgkaart_code AS zorgkaart_code_18,
  t0.address_street AS address_street_19,
  t0.address_building_nr AS address_building_nr_20,
  t0.address_addon AS address_addon_21,
  t0.address_postalcode AS address_postalcode_22,
  t0.address_city AS address_city_23,
  t0.address_province AS address_province_24,
  t0.address_country AS address_country_25,
  t0.address_latitude AS address_latitude_26,
  t0.address_longitude AS address_longitude_27,
  t0.emergency_details_name AS emergency_details_name_28,
  t0.emergency_details_description AS emergency_details_description_29,
  t0.emergency_details_phone AS emergency_details_phone_30,
  t0.emergency_details_email AS emergency_details_email_31,
  t0.emergency_details_address_street AS emergency_details_address_street_32,
  t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33,
  t0.emergency_details_address_addon AS emergency_details_address_addon_34,
  t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35,
  t0.emergency_details_address_city AS emergency_details_address_city_36,
  t0.emergency_details_address_province AS emergency_details_address_province_37,
  t0.emergency_details_address_country AS emergency_details_address_country_38,
  t0.emergency_details_address_latitude AS emergency_details_address_latitude_39,
  t0.emergency_details_address_longitude AS emergency_details_address_longitude_40,
  t0.emergency_details_backup_name AS emergency_details_backup_name_41,
  t0.emergency_details_backup_description AS emergency_details_backup_description_42,
  t0.emergency_details_backup_phone AS emergency_details_backup_phone_43,
  t0.emergency_details_backup_email AS emergency_details_backup_email_44,
  t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45,
  t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46,
  t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47,
  t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48,
  t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49,
  t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50,
  t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51,
  t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52,
  t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53
FROM
  pharmacy t0
  INNER JOIN service_point ON t0.id = service_point.service_point_id
WHERE
  service_point.parent_pharmacy_id = ?