Query Metrics
11
Database Queries
9
Different statements
41.28 ms
Query time
0
Invalid entities
29
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
12.21 ms (29.59%) |
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:
[ 41 "2025-12-06" ] |
|
11.50 ms (27.85%) |
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:
[ 41 "2025-12-06 04:11:09" ] |
|
10.86 ms (26.31%) |
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:
[
41
]
|
|
2.51 ms (6.09%) |
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:
[
41
]
|
|
1.31 ms (3.18%) |
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:
[ "veerschepoort" "false" ] |
|
1.10 ms (2.65%) |
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:
[
41
]
|
|
0.73 ms (1.76%) |
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:
[
41
]
|
|
0.59 ms (1.44%) |
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:
[
41
]
|
|
0.47 ms (1.13%) |
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:
[
41
]
|
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 | 3 |
| App\Entity\Pharmacy | 1 |
| App\Entity\TeamProfile | 1 |
| App\Entity\User | 1 |
confidential entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Embeddable\Address | No errors. |
| App\Entity\Embeddable\EmergencyDetails | No errors. |
| App\Entity\Pharmacy | No errors. |
| App\Entity\CoverImage | No errors. |
| App\Entity\TeamProfile | No errors. |
| App\Entity\PharmacyService | No errors. |
| App\Entity\BusinessDay | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Announcement | No errors. |
| App\Entity\IntakeForm | No errors. |
| App\Entity\IntakeFormPatient | No errors. |
| App\Entity\NewsItem | No errors. |
| App\Entity\PatientMedicine | No errors. |
| App\Entity\Submission | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Confidential\Confidential | No errors. |
| App\Entity\Confidential\Medicine | No errors. |
| App\Entity\Confidential\Patient | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| Gedmo\Translator\Entity\Translation | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
confidential entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Confidential\Confidential | No errors. |
| App\Entity\Confidential\Medicine | No errors. |
| App\Entity\Confidential\Patient | No errors. |