Query Metrics
110
Database Queries
9
Different statements
137.33 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
42.23 ms (30.75%) |
36 |
SELECT t0.id AS id_1, t0.time_from AS time_from_2, t0.time_till AS time_till_3, t0.node_id AS node_id_4 FROM opening_hours t0 WHERE t0.node_id = ?
Parameters:
[
8
]
|
|
42.15 ms (30.69%) |
33 |
SELECT t0.id AS id_1, t0.file AS file_2, t0.alt AS alt_3 FROM image t0 WHERE t0.id = ?
Parameters:
[
132
]
|
|
42.07 ms (30.64%) |
35 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 INNER JOIN node_tag ON t0.id = node_tag.tag_id WHERE node_tag.node_id = ?
Parameters:
[
116
]
|
|
2.61 ms (1.90%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.published AS published_4, t0.url AS url_5, t0.parent AS parent_6, t0.image_id AS image_id_7, t0.banner_id AS banner_id_8, t0.dtype FROM node t0 WHERE t0.parent = ? AND t0.dtype IN ('PAGE') ORDER BY t0.title ASC
Parameters:
[
8
]
|
|
2.19 ms (1.59%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.center_id AS center_id_2 FROM category c0_ WHERE c0_.center_id = ? ORDER BY c0_.name ASC
Parameters:
[
8
]
|
|
1.83 ms (1.33%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.published AS published_4, t0.url AS url_5, t0.about AS about_6, t0.is_cinema AS is_cinema_7, t0.is_center AS is_center_8, t0.cinema_feed AS cinema_feed_9, t0.is_vacation_closed AS is_vacation_closed_10, t0.position AS position_11, t0.map AS map_12, t0.floor AS floor_13, t0.parent AS parent_14, t0.address_id AS address_id_15, t0.category_id AS category_id_16, t0.logo_id AS logo_id_17, t0.dtype FROM node t0 WHERE t0.url = ? AND t0.dtype IN ('BUSINESS') LIMIT 1
Parameters:
[
"skalica"
]
|
|
1.57 ms (1.14%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.facebook AS facebook_4, t0.instagram AS instagram_5, t0.address AS address_6, t0.city AS city_7, t0.zip AS zip_8, t0.website AS website_9 FROM contact t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
1.46 ms (1.07%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.published AS published_4, t0.url AS url_5, t0.about AS about_6, t0.is_cinema AS is_cinema_7, t0.is_center AS is_center_8, t0.cinema_feed AS cinema_feed_9, t0.is_vacation_closed AS is_vacation_closed_10, t0.position AS position_11, t0.map AS map_12, t0.floor AS floor_13, t0.parent AS parent_14, t0.address_id AS address_id_15, t0.category_id AS category_id_16, t0.logo_id AS logo_id_17, t0.dtype FROM node t0 WHERE t0.parent = ? AND t0.published = ? AND t0.dtype IN ('BUSINESS') ORDER BY t0.title ASC
Parameters:
[ 8 1 ] |
|
1.21 ms (0.88%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.published AS published_4, t0.url AS url_5, t0.about AS about_6, t0.is_cinema AS is_cinema_7, t0.is_center AS is_center_8, t0.cinema_feed AS cinema_feed_9, t0.is_vacation_closed AS is_vacation_closed_10, t0.position AS position_11, t0.map AS map_12, t0.floor AS floor_13, t0.parent AS parent_14, t0.address_id AS address_id_15, t0.category_id AS category_id_16, t0.logo_id AS logo_id_17, t0.dtype FROM node t0 WHERE t0.parent = ? AND t0.url IS NULL AND t0.dtype IN ('BUSINESS') LIMIT 1
Parameters:
[
8
]
|
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\Node | No errors. |
| App\Entity\Business |
|
| App\Entity\Contact | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\OpeningHours | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Movie | No errors. |
| App\Entity\Page | No errors. |