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
  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 = ?
  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.url = 'new-yorker' AND t0.dtype IN ('BUSINESS') LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.description AS description_2,
  n0_.published AS published_3,
  n0_.url AS url_4,
  n0_.date_from AS date_from_5,
  n0_.date_till AS date_till_6,
  n0_.date_to_publish AS date_to_publish_7,
  n0_.dtype AS dtype_8,
  n0_.parent AS parent_9,
  n0_.image_id AS image_id_10,
  n0_.banner_id AS banner_id_11
FROM
  node n0_
  INNER JOIN node n1_ ON n0_.parent = n1_.id
  AND n1_.dtype IN (
    'DISCOUNT', 'BUSINESS', 'NEWS', 'PAGE'
  )
WHERE
  (
    n0_.parent = ?
    AND n0_.published = ?
    AND n0_.date_till > ?
  )
  AND n0_.dtype IN ('DISCOUNT')
ORDER BY
  n0_.date_from ASC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.published AS published_3, n0_.url AS url_4, n0_.date_from AS date_from_5, n0_.date_till AS date_till_6, n0_.date_to_publish AS date_to_publish_7, n0_.dtype AS dtype_8, n0_.parent AS parent_9, n0_.image_id AS image_id_10, n0_.banner_id AS banner_id_11 FROM node n0_ INNER JOIN node n1_ ON n0_.parent = n1_.id AND n1_.dtype IN ('DISCOUNT', 'BUSINESS', 'NEWS', 'PAGE') WHERE (n0_.parent = 104 AND n0_.published = 1 AND n0_.date_till > '2026-04-29 23:07:32') AND n0_.dtype IN ('DISCOUNT') ORDER BY n0_.date_from 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.floor = ?
  AND t0.published = ?
  AND t0.dtype IN ('BUSINESS')
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.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.floor = 1 AND t0.published = 1 AND t0.dtype IN ('BUSINESS') ORDER BY t0.title ASC;

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

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 = 8 ORDER BY c0_.name ASC;

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.file AS file_2,
  t0.alt AS alt_3
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.alt AS alt_3 FROM image t0 WHERE t0.id = 152;

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

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