GET https://iacp.cloud/therapists/modal?t=3121

Query Metrics

13 Database Queries
11 Different statements
26.48 ms Query time
2 Invalid entities
562 Managed entities

Queries

Group similar statements

# 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
  • The field 'App\Entity\MemberApplication#confirmInformation' has the property type 'bool' that differs from the metadata field type 'string' returned by the 'text' DBAL type.
  • The field 'App\Entity\MemberApplication#confirmTerms' has the property type 'bool' that differs from the metadata field type 'string' returned by the 'text' DBAL type.
App\Entity\MemberDocument No errors.
App\Entity\MemberLog No errors.
App\Entity\Therapist
  • The field 'App\Entity\Therapist#sign_language' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\MemberCpdLog No errors.
App\Entity\Page No errors.