Query Metrics
5
Database Queries
5
Different statements
3.23 ms
Query time
0
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.36 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM article_category a1_, page p0_ INNER JOIN article_category a2_ ON p0_.category = a2_.id WHERE a2_.id = ? ORDER BY p0_.publication_date DESC LIMIT 5
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.51 ms |
SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page p1_, page_media p0_ WHERE p0_.page_id = ? AND p0_.is_enabled = true AND p0_.is_default = true LIMIT 1
Parameters:
[
9
]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.64 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = ? ORDER BY p0_.created_at DESC LIMIT 5
Parameters:
[
"article"
]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.45 ms |
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> ? ORDER BY a0_.label ASC
Parameters:
[
"autre"
]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.26 ms |
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = ? LIMIT 1
Parameters:
[
"autre"
]
|
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\Page\Page | 3 |
| App\Entity\Page\ArticleCategory | 2 |
| App\Entity\Page\Media | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Page\ArticleCategory | No errors. |
| App\Entity\Page\Page | No errors. |
| App\Entity\Page\Media | No errors. |