Query Metrics
5
Database Queries
4
Different statements
12.26 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.65 ms (46.06%) |
2 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.icon AS icon_2, p0_.content AS content_3, p0_.media AS media_4, p0_.available AS available_5, p0_.user_id AS user_id_6 FROM project p0_ INNER JOIN translation t1_ ON p0_.id = t1_.project_id WHERE t1_.keyword = ?
Parameters:
[
"project.title"
]
|
|
4.21 ms (34.38%) |
1 |
SELECT t0.id AS id_1, t0.background1 AS background1_2, t0.background2 AS background2_3 FROM bg_project t0
Parameters:
[] |
|
2.14 ms (17.47%) |
1 |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.logo AS logo_2, l0_.available AS available_3 FROM logo l0_ WHERE l0_.available = ?
Parameters:
[
1
]
|
|
0.26 ms (2.08%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.icon AS icon_2, p0_.content AS content_3, p0_.media AS media_4, p0_.available AS available_5, p0_.user_id AS user_id_6 FROM project p0_ WHERE p0_.available = 1
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Project | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\User |
|
| App\Entity\BgProject | No errors. |
| App\Entity\Logo | No errors. |