Query Metrics
28
Database Queries
19
Different statements
26.91 ms
Query time
4
Invalid entities
288
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.23 ms (15.73%) |
3 |
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ?) AND (d0_.deletedAt IS NULL) ORDER BY d0_.name ASC
Parameters:
[
"therapist_category"
]
|
|
3.20 ms (11.89%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"iacpclrwww"
]
|
|
2.64 ms (9.79%) |
1 |
SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "iacpclrwww" "iacpclrwww" "doctrine_migration_versions" ] |
|
2.50 ms (9.28%) |
6 |
SELECT DATABASE()
Parameters:
[] |
|
2.21 ms (8.21%) |
2 |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[] |
|
1.81 ms (6.71%) |
1 |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'iacpclrwww' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "iacpclrwww" "doctrine_migration_versions" ] |
|
1.32 ms (4.90%) |
1 |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "iacpclrwww" "doctrine_migration_versions" ] |
|
1.19 ms (4.42%) |
1 |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "iacpclrwww" "doctrine_migration_versions" ] |
|
0.99 ms (3.66%) |
1 |
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ?) AND (d0_.deletedAt IS NULL) ORDER BY d0_.list_order ASC
Parameters:
[
"therapist_whom"
]
|
|
0.98 ms (3.63%) |
1 |
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:
[
8206
]
|
|
0.95 ms (3.55%) |
1 |
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.image_name AS image_name_73, t0.updated_at AS updated_at_74, t0.member_id AS member_id_75, t0.location_id AS location_id_76 FROM therapist t0 WHERE t0.member_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
3764
]
|
|
0.82 ms (3.06%) |
1 |
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deletedAt IS NULL) ORDER BY d0_.name ASC
Parameters:
[ "therapist_category" "288" "256" "257" "258" "259" "281" "260" "283" "262" "263" "275" "264" "276" "266" "267" "268" "272" "273" "286" "278" ] |
|
0.74 ms (2.76%) |
1 |
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.ta_content AS ta_content_14, t0.ta_entries_to_include_in_log AS ta_entries_to_include_in_log_15, t0.ta_last_fetch_date AS ta_last_fetch_date_16, t0.member_page_hero_image_name AS member_page_hero_image_name_17, t0.member_page_services AS member_page_services_18, t0.member_page_service_description AS member_page_service_description_19, t0.member_page_email AS member_page_email_20, t0.member_page_phone AS member_page_phone_21, t0.member_page_about AS member_page_about_22, t0.member_page_hero_line1 AS member_page_hero_line1_23, t0.member_page_hero_line2 AS member_page_hero_line2_24, t0.member_page_hero_line3 AS member_page_hero_line3_25, t0.member_page_about_image_name AS member_page_about_image_name_26, t0.member_page_for_whom_title AS member_page_for_whom_title_27, t0.member_page_for_whom_text AS member_page_for_whom_text_28, t0.member_page_section_services_title AS member_page_section_services_title_29, t0.member_page_section_about_title AS member_page_section_about_title_30, t0.member_page_address AS member_page_address_31, t0.member_page_social_facebook AS member_page_social_facebook_32, t0.member_page_social_twitter AS member_page_social_twitter_33, t0.member_page_social_linkedin AS member_page_social_linkedin_34, t0.member_page_social_instagram AS member_page_social_instagram_35, t0.member_page_www AS member_page_www_36, t0.membership_type_id AS membership_type_id_37 FROM member t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
3764
]
|
|
0.69 ms (2.58%) |
1 |
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:
[
8206
]
|
|
0.63 ms (2.36%) |
1 |
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:
[
8206
]
|
|
0.54 ms (1.99%) |
1 |
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:
[
8206
]
|
|
0.51 ms (1.90%) |
1 |
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deletedAt IS NULL) ORDER BY d0_.name ASC
Parameters:
[ "therapist_approach" "174" "157" "176" "159" "160" "161" "153" "195" "163" "167" "172" "182" ] |
|
0.50 ms (1.86%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
|
0.46 ms (1.72%) |
1 |
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deletedAt IS NULL) ORDER BY d0_.list_order ASC
Parameters:
[ "therapist_whom" "353" "356" "368" "358" "354" "364" "618" "365" ] |
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 | 173 |
| App\Entity\Setting | 113 |
| App\Entity\Member | 1 |
| 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\MembershipForm |
|
| App\Entity\EventRegistration | No errors. |
| App\Entity\ResetPasswordRequest | No errors. |
| App\Entity\User | No errors. |
| App\Entity\MemberForm |
|
| App\Entity\Page | No errors. |
| App\Entity\Log | No errors. |
| App\Entity\EmailForm | No errors. |
| App\Entity\Event | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |