Query Metrics
5
Database Queries
5
Different statements
17.68 ms
Query time
0
Invalid entities
8
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.03 ms (45.43%) |
1 |
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
]
|
|
5.15 ms (29.10%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.position AS position_3, t0.dimension AS dimension_4, t0.match_type AS match_type_5, t0.question_id AS question_id_6 FROM survey_question_option t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
47
]
|
|
1.84 ms (10.41%) |
1 |
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
]
|
|
1.55 ms (8.78%) |
1 |
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.id = ?
Parameters:
[
"47"
]
|
|
1.11 ms (6.28%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.header_text AS header_text_4, t0.footer_text AS footer_text_5, t0.email_subject AS email_subject_6, t0.email_body AS email_body_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.project_id AS project_id_11 FROM survey t0 WHERE t0.id = ?
Parameters:
[
7
]
|
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\SurveyQuestionOption | 3 |
| App\Entity\User | 1 |
| App\Entity\SurveyQuestion | 1 |
| App\Entity\Survey | 1 |
| App\Entity\Project | 1 |
| App\Entity\Customer | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\SurveyQuestion | No errors. |
| App\Entity\Survey | No errors. |
| App\Entity\SurveyQuestionOption | No errors. |
| App\Entity\SurveyQuestionMatrixMatch | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\SurveyResponse | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Attendance | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\Topic | No errors. |
| App\Entity\InvitationGroup | No errors. |
| App\Entity\ProjectDocument | No errors. |