Query Metrics
29
Database Queries
10
Different statements
107.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
99.63 ms (92.56%) |
6 |
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, t0.product_id AS product_id_19, t0.parent_id AS parent_id_20 FROM page t0 WHERE t0.id = ?
Parameters:
[
15
]
|
|
2.03 ms (1.89%) |
7 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.tag AS tag_4, t0.url AS url_5, t0.white_rabbit AS white_rabbit_6, t0.cta_cover_file_name AS cta_cover_file_name_7, t0.cta_cover_mime_type AS cta_cover_mime_type_8, t0.cta_cover_path AS cta_cover_path_9, t0.cta_cover_size AS cta_cover_size_10, t0.cover_file_name AS cover_file_name_11, t0.cover_mime_type AS cover_mime_type_12, t0.cover_path AS cover_path_13, t0.cover_size AS cover_size_14, t0.document_file_name AS document_file_name_15, t0.document_mime_type AS document_mime_type_16, t0.document_path AS document_path_17, t0.document_size AS document_size_18, t0.slug AS slug_19 FROM call_to_action t0 WHERE t0.id = ?
Parameters:
[
17
]
|
|
1.60 ms (1.48%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"piscine-pubbliche"
]
|
|
1.32 ms (1.23%) |
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"
]
|
|
0.66 ms (0.61%) |
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.id = ?
Parameters:
[
2
]
|
|
0.64 ms (0.60%) |
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
]
|
|
0.55 ms (0.51%) |
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.49 ms (0.46%) |
1 |
SELECT t0.id AS id_1, t0.credits AS credits_2, t0.type AS type_3, t0.visible AS visible_4, t0.image_file_name AS image_file_name_5, t0.image_mime_type AS image_mime_type_6, t0.image_path AS image_path_7, t0.image_size AS image_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.product_id AS product_id_11 FROM realization t0 WHERE t0.product_id = ?
Parameters:
[
3
]
|
|
0.39 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.size AS size_3, t0.call_to_action_id AS call_to_action_id_4, t0.product_id AS product_id_5 FROM product_call_to_action t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
3
]
|
|
0.32 ms (0.30%) |
1 |
SELECT t0.id AS id_1, t0.custom AS custom_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.link AS link_6, t0.cover_file_name AS cover_file_name_7, t0.cover_mime_type AS cover_mime_type_8, t0.cover_path AS cover_path_9, t0.cover_size AS cover_size_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.product_id AS product_id_13, t0.page_id AS page_id_14 FROM section t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
Parameters:
[
3
]
|
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\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\Page\PageCallToAction | No errors. |
| App\Entity\Embeddable\File\DocumentFile | No errors. |
| App\Entity\CallToAction | No errors. |
| App\Entity\Component\ComponentCallToAction | No errors. |
| App\Entity\ComponentConfiguration\ComponentConfigurationCallToAction | No errors. |
| App\Entity\AboutConfiguration\AboutConfigurationCallToAction | No errors. |
| App\Entity\FooterEntry | No errors. |
| App\Entity\Component | No errors. |