Symfony Profiler

Query Metrics

3 Database Queries

1 Different statements

3.62 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
3.62 ms (100.00%)	3	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: [`"www" "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 = 'www' AND t0.online = 'false' LIMIT 1;

Time▼

Count

Info

3.62 ms
(100.00%)

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:

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

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

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://www.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