Query Metrics
41
Database Queries
11
Different statements
111.77 ms
Query time
0
Invalid entities
59
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 13.43 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 1.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.attendee_filter AS attendee_filter_4, t0.customer_exclusion AS customer_exclusion_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.customer_id AS customer_id_8, t9.id AS id_10, t9.title AS title_11, t9.slug AS slug_12, t9.header_text AS header_text_13, t9.footer_text AS footer_text_14, t9.email_subject AS email_subject_15, t9.email_body AS email_body_16, t9.is_active AS is_active_17, t9.created_at AS created_at_18, t9.updated_at AS updated_at_19, t9.project_id AS project_id_20 FROM project t0 LEFT JOIN survey t9 ON t9.project_id = t0.id WHERE t0.id = ?
Parameters:
[
"1023"
]
|
| 3 | 1.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM customer t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 4 | 2.53 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "to_mailout" ] |
| 5 | 6.14 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "mailout" ] |
| 6 | 2.88 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "confirmed" ] |
| 7 | 4.34 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "attended" ] |
| 8 | 1.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.exclusion AS exclusion_3, t0.customer_id AS customer_id_4 FROM topic t0 INNER JOIN topic_project ON t0.id = topic_project.topic_id WHERE topic_project.project_id = ?
Parameters:
[
1023
]
|
| 9 | 2.50 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "to_mailout" ] |
| 10 | 3.17 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "mailout" ] |
| 11 | 2.07 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "survey_completed" ] |
| 12 | 0.93 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "excluded" ] |
| 13 | 0.74 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "confirmed" ] |
| 14 | 0.59 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "cancelled" ] |
| 15 | 0.46 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "not_attended" ] |
| 16 | 0.45 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "attended" ] |
| 17 | 0.63 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3, t0.position AS position_4, t0.required AS required_5, t0.match_pattern AS match_pattern_6, t0.match_type AS match_type_7, t0.has_other AS has_other_8, t0.other_match_type AS other_match_type_9, t0.survey_id AS survey_id_10 FROM survey_question t0 WHERE t0.survey_id = ? ORDER BY t0.position ASC
Parameters:
[
7
]
|
| 18 | 1.30 ms |
SELECT t0.id AS id_1, t0.is_match AS is_match_2, t0.completed_at AS completed_at_3, t0.created_at AS created_at_4, t0.survey_id AS survey_id_5, t0.attendee_id AS attendee_id_6 FROM survey_response t0 WHERE t0.survey_id = ?
Parameters:
[
7
]
|
| 19 | 1.72 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "to_mailout" ] |
| 20 | 5.77 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "survey_completed" ] |
| 21 | 4.53 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "mailout" ] |
| 22 | 2.90 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "confirmed" ] |
| 23 | 1.10 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "attended" ] |
| 24 | 3.24 ms |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1023 "not_attended" ] |
| 25 | 1.72 ms |
SELECT a0_.id AS id_0, a0_.status AS status_1, a0_.mailout_at AS mailout_at_2, a0_.confirmed_at AS confirmed_at_3, a0_.cancelled_at AS cancelled_at_4, a1_.id AS id_5, a1_.firstname AS firstname_6, a1_.lastname AS lastname_7, a1_.dob AS dob_8, a1_.balcony AS balcony_9, a1_.zip AS zip_10, a1_.city AS city_11, a1_.phone_mobile AS phone_mobile_12, a1_.phone_landline AS phone_landline_13, a1_.email AS email_14, a1_.english AS english_15, a1_.profession AS profession_16, a1_.garden AS garden_17, a1_.illness AS illness_18, a1_.visual_aid AS visual_aid_19, a1_.hearing_aid AS hearing_aid_20, a1_.smoking AS smoking_21, a1_.rolling_tobacco AS rolling_tobacco_22, a1_.darning_tobacco AS darning_tobacco_23, a1_.tablet AS tablet_24, a1_.hobbies AS hobbies_25, a1_.special_remarks AS special_remarks_26, a1_.internal_comment AS internal_comment_27, a1_.age AS age_28, a1_.bank_other AS bank_other_29, a1_.smartphone_other_brand AS smartphone_other_brand_30, a1_.smartphone_other_model AS smartphone_other_model_31, a1_.coffee_machines_other AS coffee_machines_other_32, a1_.kitchen_appliances_big_other AS kitchen_appliances_big_other_33, a1_.kitchen_appliances_small_other AS kitchen_appliances_small_other_34, a1_.pets_other AS pets_other_35, a1_.blocked AS blocked_36, a1_.form_submitted_at AS form_submitted_at_37, a1_.created_at AS created_at_38, a1_.updated_at AS updated_at_39, a1_.answer_id AS answer_id_40, a1_.token AS token_41, a1_.approved AS approved_42, a1_.email_confirmation_sent_at AS email_confirmation_sent_at_43, a1_.email_confirmed_at AS email_confirmed_at_44, a0_.project_id AS project_id_45, a0_.attendee_id AS attendee_id_46, a0_.invitation_group_id AS invitation_group_id_47, a1_.family_status_id AS family_status_id_48, a1_.degree_id AS degree_id_49, a1_.state_id AS state_id_50, a1_.income_id AS income_id_51, a1_.living_situation_id AS living_situation_id_52, a1_.gender_id AS gender_id_53, a1_.sector_id AS sector_id_54, a1_.info_id AS info_id_55, a1_.cigarettes_id AS cigarettes_id_56, a1_.cigarettes_second_id AS cigarettes_second_id_57, a1_.e_cigarettes_id AS e_cigarettes_id_58, a1_.smartphone_id AS smartphone_id_59 FROM attendance a0_ LEFT JOIN attendee a1_ ON a0_.attendee_id = a1_.id WHERE a0_.project_id = ? ORDER BY a0_.id DESC
Parameters:
[
1023
]
|
| 26 | 1.13 ms |
SELECT t0.id AS id_1, t0.original_filename AS original_filename_2, t0.storage_path AS storage_path_3, t0.mime_type AS mime_type_4, t0.document_type AS document_type_5, t0.uploaded_at AS uploaded_at_6, t0.project_id AS project_id_7 FROM project_document t0 WHERE t0.project_id = ? ORDER BY t0.uploaded_at DESC
Parameters:
[
1023
]
|
| 27 | 1.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.start_time AS start_time_4, t0.end_time AS end_time_5, t0.zoom_link AS zoom_link_6, t0.capacity AS capacity_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.project_id AS project_id_10 FROM invitation_group t0 WHERE t0.project_id = ? ORDER BY t0.date ASC, t0.start_time ASC
Parameters:
[
1023
]
|
| 28 | 3.84 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
15
]
|
| 29 | 1.25 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
16
]
|
| 30 | 3.15 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
17
]
|
| 31 | 5.06 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
18
]
|
| 32 | 13.08 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
19
]
|
| 33 | 4.10 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
20
]
|
| 34 | 1.63 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
21
]
|
| 35 | 0.94 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
22
]
|
| 36 | 0.99 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
23
]
|
| 37 | 2.60 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
24
]
|
| 38 | 1.42 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
25
]
|
| 39 | 1.11 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
26
]
|
| 40 | 1.24 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
27
]
|
| 41 | 1.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mailout_at AS mailout_at_3, t0.confirmed_at AS confirmed_at_4, t0.cancelled_at AS cancelled_at_5, t0.project_id AS project_id_6, t0.attendee_id AS attendee_id_7, t0.invitation_group_id AS invitation_group_id_8 FROM attendance t0 WHERE t0.invitation_group_id = ?
Parameters:
[
28
]
|
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\Set\Set | 15 |
| App\Entity\InvitationGroup | 14 |
| App\Entity\SurveyQuestion | 12 |
| App\Entity\Attendee | 5 |
| App\Entity\Attendance | 5 |
| App\Entity\SurveyResponse | 3 |
| App\Entity\User | 1 |
| App\Entity\Project | 1 |
| App\Entity\Customer | 1 |
| App\Entity\Survey | 1 |
| App\Entity\ProjectDocument | 1 |