Query Metrics
11
Database Queries
5
Different statements
359.71 ms
Query time
0
Invalid entities
129
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.34 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 2 | 0.75 ms |
SELECT count(DISTINCT f0_.id) AS sclr_0 FROM factual_comment f0_ LEFT JOIN factual_comment_item f1_ ON f0_.id = f1_.comment_id AND (f1_.deleted_at IS NULL) WHERE (f0_.status >= ?) AND (f0_.deleted_at IS NULL)
Parameters:
[
10
]
|
| 3 | 0.71 ms |
SELECT DISTINCT f0_.id AS id_0, f0_.basic_form AS basic_form_1 FROM factual_comment f0_ LEFT JOIN factual_comment_item f1_ ON f0_.id = f1_.comment_id AND (f1_.deleted_at IS NULL) WHERE (f0_.status >= ?) AND (f0_.deleted_at IS NULL) ORDER BY f0_.basic_form ASC LIMIT 50
Parameters:
[
10
]
|
| 4 | 0.56 ms |
SELECT f0_.id AS id_0, f0_.reference_id AS reference_id_1, f0_.basic_form AS basic_form_2, f0_.status AS status_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.deleted_at AS deleted_at_6, f1_.id AS id_7, f1_.content AS content_8, f1_.factual_comment_number AS factual_comment_number_9, f1_.created_at AS created_at_10, f1_.updated_at AS updated_at_11, f1_.deleted_at AS deleted_at_12, f0_.created_by_id AS created_by_id_13, f1_.comment_id AS comment_id_14 FROM factual_comment f0_ LEFT JOIN factual_comment_item f1_ ON f0_.id = f1_.comment_id AND (f1_.deleted_at IS NULL) WHERE (f0_.status >= ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (f0_.deleted_at IS NULL) ORDER BY f0_.basic_form ASC
Parameters:
[ 10 143 48 53 130 29 51 120 129 176 75 168 203 205 16 106 151 234 256 35 23 43 46 84 193 66 156 101 155 179 72 85 222 235 201 96 173 64 131 249 187 88 180 80 49 56 38 202 174 145 141 ] |
| 5 | 177.33 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.path AS path_2, s0_.content AS content_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.e_tag AS e_tag_6 FROM sermon s0_ WHERE s0_.content LIKE ?
Parameters:
[
"%FJCNJUAF%"
]
|
| 6 | 178.52 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.path AS path_2, s0_.content AS content_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.e_tag AS e_tag_6 FROM sermon s0_ WHERE s0_.content LIKE ?
Parameters:
[
"%FKJMJMNN%"
]
|
| 7 | 0.40 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 8 | 0.24 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 9 | 0.30 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 10 | 0.19 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 11 | 0.38 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
11
]
|
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\FactualComment | 50 |
| App\Entity\FactualCommentItem | 50 |
| App\Entity\Sermon | 23 |
| App\Entity\User | 6 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\LanguageComment | No errors. |
| App\Entity\BiblicalReference | No errors. |
| App\Entity\Quote | No errors. |
| App\Entity\ContextComment | No errors. |
| App\Entity\FactualComment | No errors. |
| App\Entity\FactualCommentItem | No errors. |
| App\Entity\Sermon | No errors. |