Query Metrics

19 Database Queries
8 Different statements
45.79 ms Query time
0 Invalid entities
65 Managed entities

Grouped Statements

Show all queries

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