Query Metrics
5
Database Queries
4
Different statements
12.26 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.15 ms |
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"
]
|
| 2 | 0.50 ms |
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.content"
]
|
| 3 | 0.26 ms |
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:
[] |
| 4 | 4.21 ms |
SELECT t0.id AS id_1, t0.background1 AS background1_2, t0.background2 AS background2_3 FROM bg_project t0
Parameters:
[] |
| 5 | 2.14 ms |
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
]
|
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. |
| App\Entity\Introduction | No errors. |
| App\Entity\Section | No errors. |
| App\Entity\Post |
|
| App\Entity\Like | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Commentary | No errors. |