Query Metrics
7
Database Queries
6
Different statements
47.12 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
35.45 ms (75.24%) |
1 |
SELECT m0_.id AS id_0, m0_.cinema_id AS cinema_id_1, m0_.name AS name_2, m0_.preview_date AS preview_date_3, m0_.price AS price_4, m0_.length AS length_5, m0_.room AS room_6, m0_.type AS type_7, m0_.program_id AS program_id_8, m0_.node_id AS node_id_9 FROM movie m0_ WHERE m0_.node_id = ? AND m0_.preview_date >= ? AND m0_.preview_date < ? ORDER BY m0_.preview_date ASC, m0_.name ASC
Parameters:
[ 7 "2025-08-23 00:00:00" "2025-08-23 23:00:00" ] |
|
3.41 ms (7.25%) |
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.71 ms (5.74%) |
2 |
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
]
|
|
2.31 ms (4.91%) |
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"
]
|
|
1.66 ms (3.53%) |
1 |
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
]
|
|
1.57 ms (3.34%) |
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.is_cinema = ? AND t0.dtype IN ('BUSINESS') LIMIT 1
Parameters:
[ 7 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\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. |