Query Metrics
19
Database Queries
8
Different statements
45.79 ms
Query time
0
Invalid entities
65
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
29.18 ms (63.74%) |
12 |
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:
[
45
]
|
|
3.70 ms (8.07%) |
1 |
SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.type AS type_2, s0_.position AS position_3, s0_.required AS required_4, s0_.match_pattern AS match_pattern_5, s0_.match_type AS match_type_6, s0_.has_other AS has_other_7, s0_.other_match_type AS other_match_type_8, s0_.survey_id AS survey_id_9 FROM survey_question s0_ WHERE s0_.survey_id = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.position ASC
Parameters:
[ 7 45 47 49 50 51 53 54 55 57 59 62 64 ] |
|
2.70 ms (5.89%) |
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.survey_id = ? ORDER BY t0.position ASC
Parameters:
[
7
]
|
|
2.51 ms (5.49%) |
1 |
SELECT DISTINCT s0_.id AS id_0, s0_.position AS position_1 FROM survey_question s0_ WHERE s0_.survey_id = ? ORDER BY s0_.position ASC LIMIT 20
Parameters:
[
7
]
|
|
2.24 ms (4.88%) |
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
]
|
|
1.95 ms (4.27%) |
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.85 ms (4.05%) |
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
]
|
|
1.66 ms (3.62%) |
1 |
SELECT count(s0_.id) AS sclr_0 FROM survey_question s0_ WHERE s0_.survey_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 | 49 |
| App\Entity\SurveyQuestion | 12 |
| App\Entity\User | 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. |