Query Metrics
6
Database Queries
6
Different statements
2.95 ms
Query time
2
Invalid entities
2297
Managed entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.email AS email_4, t0.email_title AS email_title_5, t0.email_title_sick_leave AS email_title_sick_leave_6, t0.logo_url AS logo_url_7, t0.faq_url AS faq_url_8, t0.contact_url AS contact_url_9, t0.rule_url AS rule_url_10, t0.privacy_policy_url AS privacy_policy_url_11, t0.sms_sender AS sms_sender_12, t0.sms_content AS sms_content_13, t0.url AS url_14, t0.has_refund AS has_refund_15, t0.slug AS slug_16, t0.iframe_head_text AS iframe_head_text_17, t0.iframe_top_text AS iframe_top_text_18, t0.hash AS hash_19, t0.virtual_ AS virtual__20, t0.redirect AS redirect_21, t0.default_api_state AS default_api_state_22, t0.show_top_bar AS show_top_bar_23, t0.top_bar_message AS top_bar_message_24, t0.top_bar_bg_color AS top_bar_bg_color_25, t0.top_bar_text_color AS top_bar_text_color_26, t0.api AS api_27, t0.logo_id AS logo_id_28 FROM site t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
||||||||||||||||||||||||||||
2 | 0.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.external_id AS external_id_8, t0.seo_json AS seo_json_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sources AS sources_12, t0.active AS active_13, t0.publish_at AS publish_at_14, t0.deleted_at AS deleted_at_15, t0.thumbnail_id AS thumbnail_id_16, t0.user_id AS user_id_17 FROM blog_post t0 WHERE t0.active = ? ORDER BY t0.publish_at DESC LIMIT 4
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
3 | 0.23 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.cta_text AS cta_text_4, t0.link AS link_5, t0.position AS position_6, t0.image_id AS image_id_7 FROM box t0 ORDER BY t0.position ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
4 | 0.22 ms |
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.type AS type_6, t0.gender_requirements AS gender_requirements_7, t0.max_age AS max_age_8, t0.comparison AS comparison_9, t0.short_description AS short_description_10, t0.alt_name AS alt_name_11, t0.image_id AS image_id_12 FROM package t0 WHERE t0.status = ?
Parameters:
[
"ACTIVE"
]
|
||||||||||||||||||||||||||||
5 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.total_price AS total_price_4, t0.position AS position_5, t0.image_id AS image_id_6 FROM lab_examination_group t0
Parameters:
[]
|
||||||||||||||||||||||||||||
6 | 0.63 ms |
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.lab_external_id AS lab_external_id_3, t0.external_url AS external_url_4, t0.google_url AS google_url_5, t0.name AS name_6, t0.type AS type_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.phone1 AS phone1_10, t0.phone2 AS phone2_11, t0.email1 AS email1_12, t0.email2 AS email2_13, t0.description AS description_14, t0.description_working_hours AS description_working_hours_15, t0.description_location AS description_location_16, t0.at_id AS at_id_17, t0.nfz_phone1 AS nfz_phone1_18, t0.nfz_phone2 AS nfz_phone2_19, t0.ks_id AS ks_id_20, t0.working_day_notes AS working_day_notes_21, t0.saturday_notes AS saturday_notes_22, t0.sunday_notes AS sunday_notes_23, t0.working_day_material_collection_until AS working_day_material_collection_until_24, t0.saturday_material_collection_until AS saturday_material_collection_until_25, t0.sunday_material_collection_until AS sunday_material_collection_until_26, t0.open24_hours AS open24_hours_27, t0.open24_hours_restrictions AS open24_hours_restrictions_28, t0.poz AS poz_29, t0.active AS active_30, t0.description_working_hours_short AS description_working_hours_short_31, t0.postal_code AS postal_code_32, t0.city AS city_33, t0.street AS street_34, t0.building_number AS building_number_35, t0.local_number AS local_number_36, t0.voivodeship AS voivodeship_37, t0.commune AS commune_38, t0.district AS district_39, t0.country AS country_40, t0.census_tract AS census_tract_41, t0.logo_id AS logo_id_42, t0.photo_id AS photo_id_43, t0.photo2_id AS photo2_id_44 FROM institution t0
Parameters:
[]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Institution | 2202 |
App\Entity\File | 51 |
App\Entity\Package | 30 |
App\Entity\LabExaminationGroup | 7 |
App\Entity\BlogPost | 4 |
App\Entity\User | 2 |
App\Entity\Site | 1 |