Query Metrics
13
Database Queries
6
Different statements
8.48 ms
Query time
0
Invalid entities
18
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.91 ms (34.33%) |
4 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.project_id AS project_id_5 FROM project_screenshot t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
20
]
|
|
2.02 ms (23.85%) |
4 |
SELECT t0.id AS id_1, t0.title_cat AS title_cat_2, t0.picture AS picture_3 FROM project_cat t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
1.06 ms (12.55%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url AS url_4, t0.repository_url AS repository_url_5, t0.image AS image_6, t0.body AS body_7, t0.published AS published_8, t0.stopped AS stopped_9, t0.licence AS licence_10, t0.licence_body AS licence_body_11, t0.projectcat_id AS projectcat_id_12 FROM project t0 WHERE t0.stopped = ? ORDER BY t0.id DESC LIMIT 4
Parameters:
[
0
]
|
|
0.98 ms (11.61%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.80 ms (9.47%) |
1 |
SELECT g0_.id AS id_0, g0_.github_id AS github_id_1, g0_.name AS name_2, g0_.full_name AS full_name_3, g0_.description AS description_4, g0_.html_url AS html_url_5, g0_.language AS language_6, g0_.stargazers_count AS stargazers_count_7, g0_.forks_count AS forks_count_8, g0_.pushed_at AS pushed_at_9, g0_.archived AS archived_10, g0_.fork AS fork_11, g0_.private AS private_12, g0_.position AS position_13, g0_.synced_at AS synced_at_14 FROM github_repository g0_ WHERE g0_.private = ? ORDER BY g0_.position ASC, g0_.pushed_at DESC, g0_.id ASC LIMIT 3
Parameters:
[
0
]
|
|
0.69 ms (8.19%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.body AS body_4, t0.publish AS publish_5, t0.createdAt AS createdAt_6, t0.category_id AS category_id_7 FROM blog_post t0 WHERE t0.publish = ? ORDER BY t0.id DESC LIMIT 3
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Project | 4 |
| App\Entity\ProjectCat | 4 |
| App\Entity\BlogPost | 3 |
| App\Entity\GitHubRepository | 3 |
| App\Entity\Category | 2 |
| App\Entity\ProjectScreenshot | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Project | No errors. |
| App\Entity\ProjectCat | No errors. |
| App\Entity\ProjectScreenshot | No errors. |
| App\Entity\BlogPost | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\GitHubRepository | No errors. |