https://www.ncmax.sk/presov/prevadzky

Query Metrics

193 Database Queries
9 Different statements
316.67 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • The association App\Entity\Business#movies is ordered by a foreign field 0 that is not a field on the target entity App\Entity\Movie.
  • The association App\Entity\Business#movies is ordered by a foreign field 1 that is not a field on the target entity App\Entity\Movie.
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.