Query Metrics

11 Database Queries
9 Different statements
10.79 ms Query time
0 Invalid entities
28 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
2.57 ms
(23.78%)
3
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 >= ?)
Parameters:
[
  2
  "2025-12-06"
]
1.58 ms
(14.69%)
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
Parameters:
[
  "bierhaalder"
  "false"
]
1.15 ms
(10.68%)
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 = ?
Parameters:
[
  2
]
1.13 ms
(10.48%)
1
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
Parameters:
[
  2
  "2025-12-06 04:11:04"
]
1.04 ms
(9.67%)
1
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
Parameters:
[
  2
]
0.96 ms
(8.91%)
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.service_point_id WHERE service_point.parent_pharmacy_id = ?
Parameters:
[
  2
]
0.84 ms
(7.77%)
1
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 = ?
Parameters:
[
  2
]
0.81 ms
(7.51%)
1
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
Parameters:
[
  2
]
0.70 ms
(6.52%)
1
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 = ?
Parameters:
[
  2
]

Database Connections

Name Service
default doctrine.dbal.default_connection
confidential doctrine.dbal.confidential_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
confidential doctrine.orm.confidential_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\BusinessDay 19
App\Entity\NewsItem 4
App\Entity\CoverImage 2
App\Entity\Pharmacy 1
App\Entity\TeamProfile 1
App\Entity\User 1

confidential entity manager

Class Amount of managed objects