Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

13.75 ms Query time

0 Invalid entities

18 Managed entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	12.03 ms	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: [`"woltermann" "false"`] View formatted query View runnable query Explain query 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 = 'woltermann' AND t0.online = 'false' LIMIT 1;
2	0.93 ms	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: [`10`] View formatted query View runnable query Explain query 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 = 10;
3	0.79 ms	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: [`10`] View formatted query View runnable query Explain query 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 = 10 AND b0_.date IS NULL;

#▲

Time

Info

12.03 ms

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:

[
  "woltermann"
  "false"
]

View formatted query View runnable query Explain query

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 = 'woltermann' AND t0.online = 'false' LIMIT 1;

0.93 ms

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:

[
  10
]

View formatted query View runnable query Explain query

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

0.79 ms

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:

[
  10
]

View formatted query View runnable query Explain query

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

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	17
App\Entity\Pharmacy	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.

Symfony Profiler

GET https://medsen.vwebdev.nl/_fragment?_path=_format%3Dhtml%26_locale%3Dnl%26_controller%3DApp%255CController%255CMenuController%253A%253AmobileMenu

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

confidential entity manager

Entities Mapping

default entity manager

confidential entity manager