Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.67 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
1.93 ms (52.69%)	2	SELECT t0.id AS id_1, t0.name AS name_2, t0.prefixed AS prefixed_3, t0.subdomain AS subdomain_4, t0.external_url AS external_url_5, t0.online AS online_6, t0.intro_text AS intro_text_7, t0.meta_description AS meta_description_8, t0.cover_image_url AS cover_image_url_9, t0.email AS email_10, t0.assistent_email AS assistent_email_11, t0.safe_email AS safe_email_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.pharmapartners_ref AS pharmapartners_ref_15, t0.hroffice_company_name AS hroffice_company_name_16, t0.zgz_url AS zgz_url_17, t0.zorgkaart_code AS zorgkaart_code_18, t0.address_street AS address_street_19, t0.address_building_nr AS address_building_nr_20, t0.address_addon AS address_addon_21, t0.address_postalcode AS address_postalcode_22, t0.address_city AS address_city_23, t0.address_province AS address_province_24, t0.address_country AS address_country_25, t0.address_latitude AS address_latitude_26, t0.address_longitude AS address_longitude_27, t0.emergency_details_name AS emergency_details_name_28, t0.emergency_details_description AS emergency_details_description_29, t0.emergency_details_phone AS emergency_details_phone_30, t0.emergency_details_email AS emergency_details_email_31, t0.emergency_details_address_street AS emergency_details_address_street_32, t0.emergency_details_address_building_nr AS emergency_details_address_building_nr_33, t0.emergency_details_address_addon AS emergency_details_address_addon_34, t0.emergency_details_address_postalcode AS emergency_details_address_postalcode_35, t0.emergency_details_address_city AS emergency_details_address_city_36, t0.emergency_details_address_province AS emergency_details_address_province_37, t0.emergency_details_address_country AS emergency_details_address_country_38, t0.emergency_details_address_latitude AS emergency_details_address_latitude_39, t0.emergency_details_address_longitude AS emergency_details_address_longitude_40, t0.emergency_details_backup_name AS emergency_details_backup_name_41, t0.emergency_details_backup_description AS emergency_details_backup_description_42, t0.emergency_details_backup_phone AS emergency_details_backup_phone_43, t0.emergency_details_backup_email AS emergency_details_backup_email_44, t0.emergency_details_backup_address_street AS emergency_details_backup_address_street_45, t0.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_46, t0.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_47, t0.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_48, t0.emergency_details_backup_address_city AS emergency_details_backup_address_city_49, t0.emergency_details_backup_address_province AS emergency_details_backup_address_province_50, t0.emergency_details_backup_address_country AS emergency_details_backup_address_country_51, t0.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_52, t0.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_53 FROM pharmacy t0 WHERE t0.subdomain = ? AND t0.online = ? LIMIT 1 Parameters: [`"medsen" "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 = 'medsen' AND t0.online = 'false' LIMIT 1;
1.73 ms (47.31%)	1	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.prefixed AS prefixed_2, p0_.subdomain AS subdomain_3, p0_.external_url AS external_url_4, p0_.online AS online_5, p0_.intro_text AS intro_text_6, p0_.meta_description AS meta_description_7, p0_.cover_image_url AS cover_image_url_8, p0_.email AS email_9, p0_.assistent_email AS assistent_email_10, p0_.safe_email AS safe_email_11, p0_.phone AS phone_12, p0_.fax AS fax_13, p0_.pharmapartners_ref AS pharmapartners_ref_14, p0_.hroffice_company_name AS hroffice_company_name_15, p0_.zgz_url AS zgz_url_16, p0_.zorgkaart_code AS zorgkaart_code_17, p0_.address_street AS address_street_18, p0_.address_building_nr AS address_building_nr_19, p0_.address_addon AS address_addon_20, p0_.address_postalcode AS address_postalcode_21, p0_.address_city AS address_city_22, p0_.address_province AS address_province_23, p0_.address_country AS address_country_24, p0_.address_latitude AS address_latitude_25, p0_.address_longitude AS address_longitude_26, p0_.emergency_details_name AS emergency_details_name_27, p0_.emergency_details_description AS emergency_details_description_28, p0_.emergency_details_phone AS emergency_details_phone_29, p0_.emergency_details_email AS emergency_details_email_30, p0_.emergency_details_address_street AS emergency_details_address_street_31, p0_.emergency_details_address_building_nr AS emergency_details_address_building_nr_32, p0_.emergency_details_address_addon AS emergency_details_address_addon_33, p0_.emergency_details_address_postalcode AS emergency_details_address_postalcode_34, p0_.emergency_details_address_city AS emergency_details_address_city_35, p0_.emergency_details_address_province AS emergency_details_address_province_36, p0_.emergency_details_address_country AS emergency_details_address_country_37, p0_.emergency_details_address_latitude AS emergency_details_address_latitude_38, p0_.emergency_details_address_longitude AS emergency_details_address_longitude_39, p0_.emergency_details_backup_name AS emergency_details_backup_name_40, p0_.emergency_details_backup_description AS emergency_details_backup_description_41, p0_.emergency_details_backup_phone AS emergency_details_backup_phone_42, p0_.emergency_details_backup_email AS emergency_details_backup_email_43, p0_.emergency_details_backup_address_street AS emergency_details_backup_address_street_44, p0_.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_45, p0_.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_46, p0_.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_47, p0_.emergency_details_backup_address_city AS emergency_details_backup_address_city_48, p0_.emergency_details_backup_address_province AS emergency_details_backup_address_province_49, p0_.emergency_details_backup_address_country AS emergency_details_backup_address_country_50, p0_.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_51, p0_.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_52 FROM pharmacy p0_ LEFT JOIN service_point s2_ ON p0_.id = s2_.service_point_id LEFT JOIN pharmacy p1_ ON p1_.id = s2_.parent_pharmacy_id WHERE p0_.online <> 0 AND (p1_.online <> 0 OR p1_.id IS NULL) ORDER BY p0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.prefixed AS prefixed_2, p0_.subdomain AS subdomain_3, p0_.external_url AS external_url_4, p0_.online AS online_5, p0_.intro_text AS intro_text_6, p0_.meta_description AS meta_description_7, p0_.cover_image_url AS cover_image_url_8, p0_.email AS email_9, p0_.assistent_email AS assistent_email_10, p0_.safe_email AS safe_email_11, p0_.phone AS phone_12, p0_.fax AS fax_13, p0_.pharmapartners_ref AS pharmapartners_ref_14, p0_.hroffice_company_name AS hroffice_company_name_15, p0_.zgz_url AS zgz_url_16, p0_.zorgkaart_code AS zorgkaart_code_17, p0_.address_street AS address_street_18, p0_.address_building_nr AS address_building_nr_19, p0_.address_addon AS address_addon_20, p0_.address_postalcode AS address_postalcode_21, p0_.address_city AS address_city_22, p0_.address_province AS address_province_23, p0_.address_country AS address_country_24, p0_.address_latitude AS address_latitude_25, p0_.address_longitude AS address_longitude_26, p0_.emergency_details_name AS emergency_details_name_27, p0_.emergency_details_description AS emergency_details_description_28, p0_.emergency_details_phone AS emergency_details_phone_29, p0_.emergency_details_email AS emergency_details_email_30, p0_.emergency_details_address_street AS emergency_details_address_street_31, p0_.emergency_details_address_building_nr AS emergency_details_address_building_nr_32, p0_.emergency_details_address_addon AS emergency_details_address_addon_33, p0_.emergency_details_address_postalcode AS emergency_details_address_postalcode_34, p0_.emergency_details_address_city AS emergency_details_address_city_35, p0_.emergency_details_address_province AS emergency_details_address_province_36, p0_.emergency_details_address_country AS emergency_details_address_country_37, p0_.emergency_details_address_latitude AS emergency_details_address_latitude_38, p0_.emergency_details_address_longitude AS emergency_details_address_longitude_39, p0_.emergency_details_backup_name AS emergency_details_backup_name_40, p0_.emergency_details_backup_description AS emergency_details_backup_description_41, p0_.emergency_details_backup_phone AS emergency_details_backup_phone_42, p0_.emergency_details_backup_email AS emergency_details_backup_email_43, p0_.emergency_details_backup_address_street AS emergency_details_backup_address_street_44, p0_.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_45, p0_.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_46, p0_.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_47, p0_.emergency_details_backup_address_city AS emergency_details_backup_address_city_48, p0_.emergency_details_backup_address_province AS emergency_details_backup_address_province_49, p0_.emergency_details_backup_address_country AS emergency_details_backup_address_country_50, p0_.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_51, p0_.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_52 FROM pharmacy p0_ LEFT JOIN service_point s2_ ON p0_.id = s2_.service_point_id LEFT JOIN pharmacy p1_ ON p1_.id = s2_.parent_pharmacy_id WHERE p0_.online <> 0 AND ( p1_.online <> 0 OR p1_.id IS NULL ) ORDER BY p0_.name ASC SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.prefixed AS prefixed_2, p0_.subdomain AS subdomain_3, p0_.external_url AS external_url_4, p0_.online AS online_5, p0_.intro_text AS intro_text_6, p0_.meta_description AS meta_description_7, p0_.cover_image_url AS cover_image_url_8, p0_.email AS email_9, p0_.assistent_email AS assistent_email_10, p0_.safe_email AS safe_email_11, p0_.phone AS phone_12, p0_.fax AS fax_13, p0_.pharmapartners_ref AS pharmapartners_ref_14, p0_.hroffice_company_name AS hroffice_company_name_15, p0_.zgz_url AS zgz_url_16, p0_.zorgkaart_code AS zorgkaart_code_17, p0_.address_street AS address_street_18, p0_.address_building_nr AS address_building_nr_19, p0_.address_addon AS address_addon_20, p0_.address_postalcode AS address_postalcode_21, p0_.address_city AS address_city_22, p0_.address_province AS address_province_23, p0_.address_country AS address_country_24, p0_.address_latitude AS address_latitude_25, p0_.address_longitude AS address_longitude_26, p0_.emergency_details_name AS emergency_details_name_27, p0_.emergency_details_description AS emergency_details_description_28, p0_.emergency_details_phone AS emergency_details_phone_29, p0_.emergency_details_email AS emergency_details_email_30, p0_.emergency_details_address_street AS emergency_details_address_street_31, p0_.emergency_details_address_building_nr AS emergency_details_address_building_nr_32, p0_.emergency_details_address_addon AS emergency_details_address_addon_33, p0_.emergency_details_address_postalcode AS emergency_details_address_postalcode_34, p0_.emergency_details_address_city AS emergency_details_address_city_35, p0_.emergency_details_address_province AS emergency_details_address_province_36, p0_.emergency_details_address_country AS emergency_details_address_country_37, p0_.emergency_details_address_latitude AS emergency_details_address_latitude_38, p0_.emergency_details_address_longitude AS emergency_details_address_longitude_39, p0_.emergency_details_backup_name AS emergency_details_backup_name_40, p0_.emergency_details_backup_description AS emergency_details_backup_description_41, p0_.emergency_details_backup_phone AS emergency_details_backup_phone_42, p0_.emergency_details_backup_email AS emergency_details_backup_email_43, p0_.emergency_details_backup_address_street AS emergency_details_backup_address_street_44, p0_.emergency_details_backup_address_building_nr AS emergency_details_backup_address_building_nr_45, p0_.emergency_details_backup_address_addon AS emergency_details_backup_address_addon_46, p0_.emergency_details_backup_address_postalcode AS emergency_details_backup_address_postalcode_47, p0_.emergency_details_backup_address_city AS emergency_details_backup_address_city_48, p0_.emergency_details_backup_address_province AS emergency_details_backup_address_province_49, p0_.emergency_details_backup_address_country AS emergency_details_backup_address_country_50, p0_.emergency_details_backup_address_latitude AS emergency_details_backup_address_latitude_51, p0_.emergency_details_backup_address_longitude AS emergency_details_backup_address_longitude_52 FROM pharmacy p0_ LEFT JOIN service_point s2_ ON p0_.id = s2_.service_point_id LEFT JOIN pharmacy p1_ ON p1_.id = s2_.parent_pharmacy_id WHERE p0_.online <> 0 AND (p1_.online <> 0 OR p1_.id IS NULL) ORDER BY p0_.name ASC;

Time▼

Count

Info

1.93 ms
(52.69%)

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:

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

1.73 ms
(47.31%)

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

Parameters:

[]

View formatted query View runnable query Explain query

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

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

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\Pharmacy	26

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\Service	No errors.
App\Entity\Announcement	No errors.
App\Entity\BusinessDay	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

Grouped Statements

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