Query Metrics
133
Database Queries
7
Different statements
473.10 ms
Query time
0
Invalid entities
34
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
417.03 ms (88.15%) |
100 |
SELECT COUNT(a0_.id) AS sclr_0 FROM attendance a0_ WHERE a0_.project_id = ? AND a0_.status = ?
Parameters:
[ 1018 "to_mailout" ] |
|
22.71 ms (4.80%) |
20 |
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.project_id = ?
Parameters:
[
1018
]
|
|
22.62 ms (4.78%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM customer t0 WHERE t0.id = ?
Parameters:
[
18
]
|
|
4.83 ms (1.02%) |
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
]
|
|
2.27 ms (0.48%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM project p0_
Parameters:
[] |
|
2.04 ms (0.43%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date AS date_2, p0_.attendee_filter AS attendee_filter_3, p0_.customer_exclusion AS customer_exclusion_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.customer_id AS customer_id_7 FROM project p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC, p0_.id DESC
Parameters:
[ 1018 1017 1016 1015 1014 1013 1012 1011 1010 1009 1008 1007 1006 1005 1004 1003 1002 1001 1000 999 ] |
|
1.60 ms (0.34%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.id AS id_2 FROM project p0_ ORDER BY p0_.created_at DESC, p0_.id DESC LIMIT 20
Parameters:
[] |
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\Project | 20 |
| App\Entity\Customer | 9 |
| App\Entity\Survey | 4 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Attendance | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\Topic | No errors. |
| App\Entity\Survey | No errors. |
| App\Entity\SurveyQuestion | No errors. |
| App\Entity\SurveyResponse | No errors. |
| App\Entity\InvitationGroup | No errors. |
| App\Entity\ProjectDocument | No errors. |