Symfony Profiler

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 = 'heusdenhout' 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 = 8;

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

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 = 8 AND b0_.date IS NULL;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.image_size AS image_size_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.pharmacy_id AS pharmacy_id_6
FROM
  cover_image t0
WHERE
  t0.pharmacy_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.image_size AS image_size_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.pharmacy_id AS pharmacy_id_6 FROM cover_image t0 WHERE t0.pharmacy_id = 8;

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 = 8 AND (b0_.date IS NULL OR b0_.date >= '2025-12-06');

SELECT
  t0.id AS id_1,
  t0.name_prefix AS name_prefix_2,
  t0.first_name AS first_name_3,
  t0.surname_prefix AS surname_prefix_4,
  t0.surname AS surname_5,
  t0.function AS function_6,
  t0.big_nr AS big_nr_7,
  t0.email AS email_8,
  t0.avatar_url AS avatar_url_9,
  t0.member_of_id AS member_of_id_10
FROM
  team_profile t0
WHERE
  t0.member_of_id = ?

SELECT t0.id AS id_1, t0.name_prefix AS name_prefix_2, t0.first_name AS first_name_3, t0.surname_prefix AS surname_prefix_4, t0.surname AS surname_5, t0.function AS function_6, t0.big_nr AS big_nr_7, t0.email AS email_8, t0.avatar_url AS avatar_url_9, t0.member_of_id AS member_of_id_10 FROM team_profile t0 WHERE t0.member_of_id = 8;

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 = 8 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 = 8;

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 = 8 AND (b0_.date IS NULL OR b0_.date >= '2025-12-06');

SELECT
  t0_.id AS id_0,
  t0_.name_prefix AS name_prefix_1,
  t0_.first_name AS first_name_2,
  t0_.surname_prefix AS surname_prefix_3,
  t0_.surname AS surname_4,
  t0_.function AS function_5,
  t0_.big_nr AS big_nr_6,
  t0_.email AS email_7,
  t0_.avatar_url AS avatar_url_8,
  t0_.member_of_id AS member_of_id_9
FROM
  team_profile t0_
WHERE
  t0_.member_of_id = ?
  AND t0_.avatar_url IS NOT NULL
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.name_prefix AS name_prefix_1, t0_.first_name AS first_name_2, t0_.surname_prefix AS surname_prefix_3, t0_.surname AS surname_4, t0_.function AS function_5, t0_.big_nr AS big_nr_6, t0_.email AS email_7, t0_.avatar_url AS avatar_url_8, t0_.member_of_id AS member_of_id_9 FROM team_profile t0_ WHERE t0_.member_of_id = 8 AND t0_.avatar_url IS NOT NULL ORDER BY t0_.id ASC;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.intro_content AS intro_content_2,
  n0_.full_content AS full_content_3,
  n0_.slug AS slug_4,
  n0_.image_url AS image_url_5,
  n0_.publish_up AS publish_up_6,
  n0_.publish_down AS publish_down_7,
  n0_.status AS status_8,
  n0_.created_at AS created_at_9,
  n0_.updated_at AS updated_at_10,
  n0_.author_id AS author_id_11,
  n0_.pharmacy_id AS pharmacy_id_12
FROM
  news_item n0_
WHERE
  (
    n0_.pharmacy_id = ?
    OR n0_.pharmacy_id IS NULL
  )
  AND n0_.status = 1
  AND n0_.publish_up <= ?
ORDER BY
  n0_.publish_up DESC
LIMIT
  4

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.intro_content AS intro_content_2, n0_.full_content AS full_content_3, n0_.slug AS slug_4, n0_.image_url AS image_url_5, n0_.publish_up AS publish_up_6, n0_.publish_down AS publish_down_7, n0_.status AS status_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.author_id AS author_id_11, n0_.pharmacy_id AS pharmacy_id_12 FROM news_item n0_ WHERE (n0_.pharmacy_id = 8 OR n0_.pharmacy_id IS NULL) AND n0_.status = 1 AND n0_.publish_up <= '2025-12-06 04:10:30' ORDER BY n0_.publish_up DESC LIMIT 4;