GET http://www.iacp.cloud/therapists

Response
200 OK
IP
216.73.216.234
Profiled on
Token
cb4354

Query Metrics

12 Database Queries
7 Different statements
55.12 ms Query time
0 Invalid entities
7158 Managed entities

Queries

Group similar statements

#▲ Time Info
1 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: 
[]
View formatted query    View runnable query    Explain query
2 0.43 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: 
[]
View formatted query    View runnable query    Explain query
3 0.83 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.list_order ASC
Parameters: 
[
  1
  "therapist_location"
]
View formatted query    View runnable query    Explain query
4 0.98 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.list_order ASC
Parameters: 
[
  1
  "therapist_category"
]
View formatted query    View runnable query    Explain query
5 0.88 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.list_order ASC
Parameters: 
[
  1
  "therapist_whom"
]
View formatted query    View runnable query    Explain query
6 1.15 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.list_order ASC
Parameters: 
[
  1
  "therapist_approach"
]
View formatted query    View runnable query    Explain query
7 42.31 ms 
SELECT t0_.id AS id_0, t0_.mdauto AS mdauto_1, t0_.mdsauto AS mdsauto_2, t0_.firstname AS firstname_3, t0_.lastname AS lastname_4, t0_.address1 AS address1_5, t0_.address2 AS address2_6, t0_.address3 AS address3_7, t0_.address4 AS address4_8, t0_.postcode AS postcode_9, t0_.country AS country_10, t0_.mdtel AS mdtel_11, t0_.private AS private_12, t0_.directory AS directory_13, t0_.clinical AS clinical_14, t0_.counselling AS counselling_15, t0_.educational AS educational_16, t0_.work AS work_17, t0_.overview AS overview_18, t0_.bio AS bio_19, t0_.map AS map_20, t0_.google_map_img AS google_map_img_21, t0_.img AS img_22, t0_.mdemail AS mdemail_23, t0_.mdwww AS mdwww_24, t0_.fax AS fax_25, t0_.login AS login_26, t0_.passwd AS passwd_27, t0_.open_mon AS open_mon_28, t0_.open_tue AS open_tue_29, t0_.open_wed AS open_wed_30, t0_.open_thu AS open_thu_31, t0_.open_fri AS open_fri_32, t0_.open_sat AS open_sat_33, t0_.open_sun AS open_sun_34, t0_.close_mon AS close_mon_35, t0_.close_tue AS close_tue_36, t0_.close_wed AS close_wed_37, t0_.close_thu AS close_thu_38, t0_.close_fri AS close_fri_39, t0_.close_sat AS close_sat_40, t0_.close_sun AS close_sun_41, t0_.logo AS logo_42, t0_.subdomain AS subdomain_43, t0_.qualifications AS qualifications_44, t0_.interests AS interests_45, t0_.memberships AS memberships_46, t0_.salutation AS salutation_47, t0_.fee AS fee_48, t0_.wheelchair AS wheelchair_49, t0_.fee_negotiable AS fee_negotiable_50, t0_.fee_donation AS fee_donation_51, t0_.fee_free AS fee_free_52, t0_.whom_one AS whom_one_53, t0_.whom_families AS whom_families_54, t0_.whom_groups AS whom_groups_55, t0_.whom_children AS whom_children_56, t0_.whom_teenagers AS whom_teenagers_57, t0_.whom_adults AS whom_adults_58, t0_.for_whom AS for_whom_59, t0_.inactive AS inactive_60, t0_.keywords AS keywords_61, t0_.old_location_id AS old_location_id_62, t0_.online_register AS online_register_63, t0_.lapsed AS lapsed_64, t0_.login_token AS login_token_65, t0_.sign_language AS sign_language_66, t0_.hse_frontline AS hse_frontline_67, t0_.pa_website_list AS pa_website_list_68, t0_.additional_training AS additional_training_69, t0_.custom_lang AS custom_lang_70, t0_.deletedAt AS deletedAt_71, t0_.member_id AS member_id_72, t0_.location_id AS location_id_73 FROM therapist t0_ WHERE (t0_.online_register = ? AND t0_.lapsed = ?) AND (t0_.deletedAt IS NULL)
Parameters: 
[
  1
  0
]
View formatted query    View runnable query    Explain query
8 0.63 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: 
[]
View formatted query    View runnable query    Explain query
9 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.deletedAt IS NULL)) ORDER BY t0.list_order ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
10 0.85 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"
]
View formatted query    View runnable query    Explain query
11 3.99 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
]
View formatted query    View runnable query    Explain query
12 1.35 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-07-25 14:58:45"
]
View formatted query    View runnable query    Explain query

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\Therapist 3314
App\Entity\Member 3286
App\Entity\Dictionary 303
App\Entity\Page 177
App\Entity\Setting 78

Entities Mapping

Class Mapping errors
App\Entity\Dictionary No errors.
App\Entity\Setting No errors.
App\Entity\Therapist No errors.
App\Entity\MemberBase No errors.
App\Entity\Member No errors.
App\Entity\Page No errors.