Query Metrics
193
Database Queries
9
Different statements
316.67 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
119.85 ms (37.85%) |
69 |
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:
[
7
]
|
|
104.78 ms (33.09%) |
68 |
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:
[
278
]
|
|
78.69 ms (24.85%) |
50 |
SELECT t0.id AS id_1, t0.file AS file_2, t0.alt AS alt_3 FROM image t0 WHERE t0.id = ?
Parameters:
[
348
]
|
|
3.25 ms (1.03%) |
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:
[
"presov"
]
|
|
2.66 ms (0.84%) |
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:
[
7
]
|
|
2.26 ms (0.71%) |
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:
[ 7 1 ] |
|
1.98 ms (0.62%) |
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:
[
7
]
|
|
1.67 ms (0.53%) |
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:
[
7
]
|
|
1.54 ms (0.49%) |
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:
[
6
]
|
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. |