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

Response
200 OK
IP
216.73.216.113
Profiled on
Token
9452ba

Query Metrics

3 Database Queries
2 Different statements
8.41 ms Query time
0 Invalid entities
26 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
5.79 ms
(68.83%) 		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
2.62 ms
(31.17%) 		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

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.

confidential entity manager

No loaded entities.