Query Metrics
13
Database Queries
11
Different statements
26.48 ms
Query time
2
Invalid entities
562
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.33 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[] |
2 | 0.73 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[] |
3 | 2.11 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deletedAt AS deletedAt_4, t0.status AS status_5, t0.membership_number AS membership_number_6, t0.email AS email_7, t0.password AS password_8, t0.stripe_customer_id AS stripe_customer_id_9, t0.stripe_payment_method_id AS stripe_payment_method_id_10, t0.stripe_addons AS stripe_addons_11, t0.ignore_payments AS ignore_payments_12, t0.full_name AS full_name_13, t0.membership_type_id AS membership_type_id_14 FROM member t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
2461
]
|
4 | 2.51 ms |
SELECT t0.id AS id_1, t0.mdauto AS mdauto_2, t0.mdsauto AS mdsauto_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.address1 AS address1_6, t0.address2 AS address2_7, t0.address3 AS address3_8, t0.address4 AS address4_9, t0.postcode AS postcode_10, t0.country AS country_11, t0.mdtel AS mdtel_12, t0.private AS private_13, t0.directory AS directory_14, t0.clinical AS clinical_15, t0.counselling AS counselling_16, t0.educational AS educational_17, t0.work AS work_18, t0.overview AS overview_19, t0.bio AS bio_20, t0.map AS map_21, t0.google_map_img AS google_map_img_22, t0.img AS img_23, t0.mdemail AS mdemail_24, t0.mdwww AS mdwww_25, t0.fax AS fax_26, t0.login AS login_27, t0.passwd AS passwd_28, t0.open_mon AS open_mon_29, t0.open_tue AS open_tue_30, t0.open_wed AS open_wed_31, t0.open_thu AS open_thu_32, t0.open_fri AS open_fri_33, t0.open_sat AS open_sat_34, t0.open_sun AS open_sun_35, t0.close_mon AS close_mon_36, t0.close_tue AS close_tue_37, t0.close_wed AS close_wed_38, t0.close_thu AS close_thu_39, t0.close_fri AS close_fri_40, t0.close_sat AS close_sat_41, t0.close_sun AS close_sun_42, t0.logo AS logo_43, t0.subdomain AS subdomain_44, t0.qualifications AS qualifications_45, t0.interests AS interests_46, t0.memberships AS memberships_47, t0.salutation AS salutation_48, t0.fee AS fee_49, t0.wheelchair AS wheelchair_50, t0.fee_negotiable AS fee_negotiable_51, t0.fee_donation AS fee_donation_52, t0.fee_free AS fee_free_53, t0.whom_one AS whom_one_54, t0.whom_families AS whom_families_55, t0.whom_groups AS whom_groups_56, t0.whom_children AS whom_children_57, t0.whom_teenagers AS whom_teenagers_58, t0.whom_adults AS whom_adults_59, t0.for_whom AS for_whom_60, t0.inactive AS inactive_61, t0.keywords AS keywords_62, t0.old_location_id AS old_location_id_63, t0.online_register AS online_register_64, t0.lapsed AS lapsed_65, t0.login_token AS login_token_66, t0.sign_language AS sign_language_67, t0.hse_frontline AS hse_frontline_68, t0.pa_website_list AS pa_website_list_69, t0.additional_training AS additional_training_70, t0.custom_lang AS custom_lang_71, t0.deletedAt AS deletedAt_72, t0.member_id AS member_id_73, t0.location_id AS location_id_74 FROM therapist t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
"3121"
]
|
5 | 0.70 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[] |
6 | 2.05 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC
Parameters:
[
1
]
|
7 | 0.99 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = ? AND t0.type_key = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.field2 DESC
Parameters:
[ 1 "events" ] |
8 | 7.39 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.`lead` AS lead_4, t0.content AS content_5, t0.right_column AS right_column_6, t0.gallery_content AS gallery_content_7, t0.type_key AS type_key_8, t0.visible AS visible_9, t0.priority_news AS priority_news_10, t0.full_width AS full_width_11, t0.hide_right_column AS hide_right_column_12, t0.hide_submenu AS hide_submenu_13, t0.show_subpage_panels AS show_subpage_panels_14, t0.show_subpage_links AS show_subpage_links_15, t0.show_subpage_news AS show_subpage_news_16, t0.use_parent_header AS use_parent_header_17, t0.list_order AS list_order_18, t0.seo_title AS seo_title_19, t0.custom_tabs AS custom_tabs_20, t0.seo_keywords AS seo_keywords_21, t0.seo_description AS seo_description_22, t0.seo_url AS seo_url_23, t0.parent_id AS parent_id_24, t0.image_name AS image_name_25, t0.image_alt AS image_alt_26, t0.image2_name AS image2_name_27, t0.image2_alt AS image2_alt_28, t0.image3_name AS image3_name_29, t0.image3_alt AS image3_alt_30, t0.heading AS heading_31, t0.external_link AS external_link_32, t0.page_date AS page_date_33, t0.parent_id AS parent_id_34 FROM page t0 WHERE t0.visible = ? ORDER BY t0.list_order ASC
Parameters:
[
1
]
|
9 | 2.09 ms |
SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.name AS name_2, p0_.`lead` AS lead_3, p0_.content AS content_4, p0_.right_column AS right_column_5, p0_.gallery_content AS gallery_content_6, p0_.type_key AS type_key_7, p0_.visible AS visible_8, p0_.priority_news AS priority_news_9, p0_.full_width AS full_width_10, p0_.hide_right_column AS hide_right_column_11, p0_.hide_submenu AS hide_submenu_12, p0_.show_subpage_panels AS show_subpage_panels_13, p0_.show_subpage_links AS show_subpage_links_14, p0_.show_subpage_news AS show_subpage_news_15, p0_.use_parent_header AS use_parent_header_16, p0_.list_order AS list_order_17, p0_.seo_title AS seo_title_18, p0_.custom_tabs AS custom_tabs_19, p0_.seo_keywords AS seo_keywords_20, p0_.seo_description AS seo_description_21, p0_.seo_url AS seo_url_22, p0_.parent_id AS parent_id_23, p0_.image_name AS image_name_24, p0_.image_alt AS image_alt_25, p0_.image2_name AS image2_name_26, p0_.image2_alt AS image2_alt_27, p0_.image3_name AS image3_name_28, p0_.image3_alt AS image3_alt_29, p0_.heading AS heading_30, p0_.external_link AS external_link_31, p0_.page_date AS page_date_32, p0_.parent_id AS parent_id_33 FROM page p0_ WHERE p0_.type_key = ? AND p0_.visible = ? AND p0_.page_date <= ? ORDER BY p0_.priority_news DESC, p0_.page_date DESC, p0_.id ASC
Parameters:
[ "news" 1 "2025-08-13 15:46:13" ] |
10 | 1.96 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_whom_relation ON t0.id = therapist_whom_relation.whom_id WHERE therapist_whom_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
3121
]
|
11 | 1.64 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_categories_relation ON t0.id = therapist_categories_relation.category_id WHERE therapist_categories_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
3121
]
|
12 | 1.52 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_approaches_relation ON t0.id = therapist_approaches_relation.approach_id WHERE therapist_approaches_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
3121
]
|
13 | 1.45 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_languages_relation ON t0.id = therapist_languages_relation.language_id WHERE therapist_languages_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
3121
]
|
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\Dictionary | 303 |
App\Entity\Page | 178 |
App\Entity\Setting | 78 |
App\Entity\Member | 2 |
App\Entity\Therapist | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\MemberBase | No errors. |
App\Entity\Member | No errors. |
App\Entity\Dictionary | No errors. |
App\Entity\Setting | No errors. |
App\Entity\MemberApplicationBase | No errors. |
App\Entity\MemberApplication |
|
App\Entity\MemberDocument | No errors. |
App\Entity\MemberLog | No errors. |
App\Entity\Therapist |
|
App\Entity\MemberCpdLog | No errors. |
App\Entity\Page | No errors. |