Query Metrics
16
Database Queries
7
Different statements
9.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.25 ms (24.33%) |
6 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = ? ORDER BY t0.sorting ASC
Parameters:
[
"row_1"
]
|
|
1.91 ms (20.62%) |
1 |
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.featured AS featured_3, t0.date AS date_4, t0.title AS title_5, t0.content AS content_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.cover_file_name AS cover_file_name_9, t0.cover_mime_type AS cover_mime_type_10, t0.cover_path AS cover_path_11, t0.cover_size AS cover_size_12, t0.document_file_name AS document_file_name_13, t0.document_mime_type AS document_mime_type_14, t0.document_path AS document_path_15, t0.document_size AS document_size_16, t0.slug AS slug_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"igienizzazione-della-piscina-con-raggi-uv"
]
|
|
1.72 ms (18.57%) |
3 |
SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.visible = 1 AND a0_.id <> ? ORDER BY a0_.date DESC LIMIT 3
Parameters:
[
146
]
|
|
1.16 ms (12.51%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.introduction AS introduction_4, t0.visible AS visible_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.background_file_name AS background_file_name_12, t0.background_mime_type AS background_mime_type_13, t0.background_path AS background_path_14, t0.background_size AS background_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM component t0 WHERE t0.visible = ?
Parameters:
[
1
]
|
|
1.03 ms (11.19%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.visible AS visible_4, t0.introduction AS introduction_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.menu_cover_file_name AS menu_cover_file_name_12, t0.menu_cover_mime_type AS menu_cover_mime_type_13, t0.menu_cover_path AS menu_cover_path_14, t0.menu_cover_size AS menu_cover_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM product t0 WHERE t0.visible = ?
Parameters:
[
1
]
|
|
0.65 ms (7.05%) |
1 |
SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.id <> ? ORDER BY a0_.date DESC LIMIT 4
Parameters:
[
146
]
|
|
0.53 ms (5.74%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.cover_file_name AS cover_file_name_3, t0.cover_mime_type AS cover_mime_type_4, t0.cover_path AS cover_path_5, t0.cover_size AS cover_size_6, t0.slug AS slug_7 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
Parameters:
[
146
]
|
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\Embeddable\File\CoverFile | No errors. |
| App\Entity\Embeddable\File\DocumentFile | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\FooterEntry | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Embeddable\File\RealizationImageFile | No errors. |
| App\Entity\Product\Realization | No errors. |
| App\Entity\Product\ProductCallToAction | No errors. |
| App\Entity\Product\Section | No errors. |
| App\Entity\Component | No errors. |
| App\Entity\Component\ComponentCallToAction | No errors. |