Query Metrics
14
Database Queries
6
Different statements
101.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
56.04 ms (55.48%) |
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
]
|
|
25.29 ms (25.04%) |
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"
]
|
|
16.32 ms (16.15%) |
1 |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.type AS type_2, r0_.phone AS phone_3, r0_.email AS email_4, r0_.website AS website_5, ST_AsText(r0_.address_coordinates) AS address_coordinates_6, r0_.address_name AS address_name_7, r0_.address_city AS address_city_8, r0_.address_zip_code AS address_zip_code_9, r0_.address_province AS address_province_10, r0_.address_region AS address_region_11, r0_.address_address AS address_address_12, r0_.icon_id AS icon_id_13 FROM reseller r0_ WHERE r0_.type = ? OR r0_.type = ?
Parameters:
[ "official_partner" "e_partner" ] |
|
1.78 ms (1.76%) |
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.90 ms (0.89%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.page AS page_4 FROM page_introduction t0 WHERE t0.page = ? LIMIT 1
Parameters:
[
"reseller"
]
|
|
0.68 ms (0.67%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_file_name AS icon_file_name_3, t0.icon_mime_type AS icon_mime_type_4, t0.icon_path AS icon_path_5, t0.icon_size AS icon_size_6 FROM reseller_icon t0 WHERE t0.id = ?
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\Embeddable\AddressWithCoordinates | No errors. |
| App\Entity\Reseller | No errors. |
| App\Entity\Embeddable\File\CoverFile | No errors. |
| App\Entity\Reseller\Icon | No errors. |
| App\Entity\PageIntroduction | 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. |