Symfony Profiler

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

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 = 'skalica' AND t0.dtype IN ('BUSINESS') LIMIT 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

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 = 8 AND t0.dtype IN ('PAGE') ORDER BY t0.title ASC;

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

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 = 8 AND m0_.preview_date >= '2024-08-12 00:00:00' AND m0_.preview_date < '2024-08-12 23:00:00' ORDER BY m0_.preview_date ASC, m0_.name ASC;

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

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 = 8 AND t0.is_cinema = 1 AND t0.dtype IN ('BUSINESS') LIMIT 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 = ?

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 = 8;

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 = ?

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 = 7;

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 = ?

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 = 12;