Symfony Profiler

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.domain = ?
  AND t0.main_alias = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/online-zapis/278695' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.main_alias = ?
ORDER BY
  t0.id DESC

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = '/online-zapis/278695' ORDER BY t0.id DESC;

SELECT
  d0_.domain_object_id AS domain_object_id_0,
  d0_.name AS name_1,
  d0_.email AS email_2,
  d0_.legal_email AS legal_email_3,
  d0_.legal_entity AS legal_entity_4,
  d0_.tax_id AS tax_id_5,
  d0_.receive_letters AS receive_letters_6,
  d0_.transition_id AS transition_id_7,
  d0_.teaser_logo_width AS teaser_logo_width_8,
  d0_.teaser_logo_height AS teaser_logo_height_9,
  d0_.status AS status_10,
  d0_.punished AS punished_11,
  d0_.last_code_number AS last_code_number_12,
  d0_.about AS about_13,
  d0_.created_on AS created_on_14,
  d0_.modified_on AS modified_on_15,
  d0_.extra_emails AS extra_emails_16,
  d0_.phone_number AS phone_number_17,
  d0_.site AS site_18,
  d0_.legal_address AS legal_address_19,
  d0_.account_number AS account_number_20,
  d0_.tax_registration_date AS tax_registration_date_21,
  d0_.trade_registration_date AS trade_registration_date_22,
  d0_.registration_authority AS registration_authority_23,
  d0_.working_hours AS working_hours_24,
  d0_.footer_info AS footer_info_25,
  d0_.company_link AS company_link_26,
  d0_.id AS id_27,
  d0_.page_offer_id AS page_offer_id_28,
  d0_.manager_id AS manager_id_29
FROM
  director d0_
WHERE
  d0_.id = ?

SELECT d0_.domain_object_id AS domain_object_id_0, d0_.name AS name_1, d0_.email AS email_2, d0_.legal_email AS legal_email_3, d0_.legal_entity AS legal_entity_4, d0_.tax_id AS tax_id_5, d0_.receive_letters AS receive_letters_6, d0_.transition_id AS transition_id_7, d0_.teaser_logo_width AS teaser_logo_width_8, d0_.teaser_logo_height AS teaser_logo_height_9, d0_.status AS status_10, d0_.punished AS punished_11, d0_.last_code_number AS last_code_number_12, d0_.about AS about_13, d0_.created_on AS created_on_14, d0_.modified_on AS modified_on_15, d0_.extra_emails AS extra_emails_16, d0_.phone_number AS phone_number_17, d0_.site AS site_18, d0_.legal_address AS legal_address_19, d0_.account_number AS account_number_20, d0_.tax_registration_date AS tax_registration_date_21, d0_.trade_registration_date AS trade_registration_date_22, d0_.registration_authority AS registration_authority_23, d0_.working_hours AS working_hours_24, d0_.footer_info AS footer_info_25, d0_.company_link AS company_link_26, d0_.id AS id_27, d0_.page_offer_id AS page_offer_id_28, d0_.manager_id AS manager_id_29 FROM director d0_ WHERE d0_.id = 3641;

SELECT
  o0_.created_on AS created_on_0,
  o0_.name AS name_1,
  o0_.short_description AS short_description_2,
  o0_.description AS description_3,
  o0_.price AS price_4,
  o0_.offer_price AS offer_price_5,
  o0_.code_price AS code_price_6,
  o0_.price_description AS price_description_7,
  o0_.code_prefix AS code_prefix_8,
  o0_.products_per_code AS products_per_code_9,
  o0_.dish_delivery_price AS dish_delivery_price_10,
  o0_.pickup_price AS pickup_price_11,
  o0_.price_delivery_type AS price_delivery_type_12,
  o0_.weight AS weight_13,
  o0_.components_count AS components_count_14,
  o0_.active AS active_15,
  o0_.hidden AS hidden_16,
  o0_.special123 AS special123_17,
  o0_.partner_image_url AS partner_image_url_18,
  o0_.additional_info AS additional_info_19,
  o0_.sauce_need AS sauce_need_20,
  o0_.modified_on AS modified_on_21,
  o0_.is_delivery AS is_delivery_22,
  o0_.is_pickup AS is_pickup_23,
  o0_.position AS position_24,
  o0_.id AS id_25,
  o0_.parameter_int_0 AS parameter_int_0_26,
  o0_.parameter_int_1 AS parameter_int_1_27,
  o0_.type AS type_28,
  o0_.offer_id AS offer_id_29
FROM
  offer_extension o0_
WHERE
  (
    o0_.offer_id = ?
    AND (
      o0_.active = ?
      OR o0_.active IS NULL
    )
  )
  AND o0_.type IN ('3')
ORDER BY
  o0_.position ASC

SELECT o0_.created_on AS created_on_0, o0_.name AS name_1, o0_.short_description AS short_description_2, o0_.description AS description_3, o0_.price AS price_4, o0_.offer_price AS offer_price_5, o0_.code_price AS code_price_6, o0_.price_description AS price_description_7, o0_.code_prefix AS code_prefix_8, o0_.products_per_code AS products_per_code_9, o0_.dish_delivery_price AS dish_delivery_price_10, o0_.pickup_price AS pickup_price_11, o0_.price_delivery_type AS price_delivery_type_12, o0_.weight AS weight_13, o0_.components_count AS components_count_14, o0_.active AS active_15, o0_.hidden AS hidden_16, o0_.special123 AS special123_17, o0_.partner_image_url AS partner_image_url_18, o0_.additional_info AS additional_info_19, o0_.sauce_need AS sauce_need_20, o0_.modified_on AS modified_on_21, o0_.is_delivery AS is_delivery_22, o0_.is_pickup AS is_pickup_23, o0_.position AS position_24, o0_.id AS id_25, o0_.parameter_int_0 AS parameter_int_0_26, o0_.parameter_int_1 AS parameter_int_1_27, o0_.type AS type_28, o0_.offer_id AS offer_id_29 FROM offer_extension o0_ WHERE (o0_.offer_id = 278695 AND (o0_.active = 1 OR o0_.active IS NULL)) AND o0_.type IN ('3') ORDER BY o0_.position ASC;

SELECT
  t0.name AS name_1,
  t0.path AS path_2,
  t0.description AS description_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.sort_order AS sort_order_7,
  t0.checked AS checked_8,
  t0.youtube AS youtube_9,
  t0.id AS id_10,
  t0.entity_id AS entity_id_11,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type IN ('7')

SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.entity_id = 15320 AND t0.type IN ('7');

SELECT
  s0_.created_on AS created_on_0,
  s0_.entity_id AS entity_id_1,
  s0_.active AS active_2,
  s0_.resource_url AS resource_url_3,
  s0_.main_alias AS main_alias_4,
  s0_.title AS title_5,
  s0_.meta_title AS meta_title_6,
  s0_.meta_description AS meta_description_7,
  s0_.page_description AS page_description_8,
  s0_.meta_keywords AS meta_keywords_9,
  s0_.domain AS domain_10,
  s0_.id AS id_11
FROM
  seo s0_
WHERE
  s0_.resource_url = ?
  AND s0_.entity_id = ?
  AND s0_.active = ?
ORDER BY
  s0_.id DESC
LIMIT
  1

SELECT s0_.created_on AS created_on_0, s0_.entity_id AS entity_id_1, s0_.active AS active_2, s0_.resource_url AS resource_url_3, s0_.main_alias AS main_alias_4, s0_.title AS title_5, s0_.meta_title AS meta_title_6, s0_.meta_description AS meta_description_7, s0_.page_description AS page_description_8, s0_.meta_keywords AS meta_keywords_9, s0_.domain AS domain_10, s0_.id AS id_11 FROM seo s0_ WHERE s0_.resource_url = 'Slivki:Default:details' AND s0_.entity_id = 278695 AND s0_.active = 1 ORDER BY s0_.id DESC LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.path AS path_2,
  t0.description AS description_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.sort_order AS sort_order_7,
  t0.checked AS checked_8,
  t0.youtube AS youtube_9,
  t0.id AS id_10,
  t0.entity_id AS entity_id_11,
  t0.type
FROM
  media t0
WHERE
  t0.id = ?
  AND t0.type IN ('19')

SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.id = 699732 AND t0.type IN ('19');

SELECT
  t0.last_modified AS last_modified_1,
  t0.created_on AS created_on_2,
  t0.content AS content_3,
  t0.active AS active_4,
  t0.name AS name_5,
  t0.type AS type_6,
  t0.id AS id_7,
  t0.director_id AS director_id_8
FROM
  info_page t0
WHERE
  t0.director_id = ?

SELECT t0.last_modified AS last_modified_1, t0.created_on AS created_on_2, t0.content AS content_3, t0.active AS active_4, t0.name AS name_5, t0.type AS type_6, t0.id AS id_7, t0.director_id AS director_id_8 FROM info_page t0 WHERE t0.director_id = 3641;

SELECT
  coalesce(
    avg(comment.rating),
    0
  )
FROM
  comment
WHERE
  (comment.entity_id = :entityId)
  AND (comment.type_id = :type)
  AND (
    comment.confirmed_phone = :confirmedPhone
  )
  AND (comment.hidden = :hidden)
  AND (comment.rating > :rating)
  AND (comment.created_on > :dateFrom)

SELECT coalesce(avg(comment.rating), 0) FROM comment WHERE (comment.entity_id = 278695) AND (comment.type_id = 1) AND (comment.confirmed_phone = 1) AND (comment.hidden = 0) AND (comment.rating > 0) AND (comment.created_on > '2025-02-01 05:01:18');

SELECT
  b0_.banner_id AS banner_id_0,
  b0_.title AS title_1,
  b0_.url AS url_2,
  b0_.right_side_url AS right_side_url_3,
  b0_.active_since AS active_since_4,
  b0_.active_till AS active_till_5,
  b0_.active AS active_6,
  b0_.test AS test_7,
  b0_.for_categories AS for_categories_8,
  b0_.pass_through AS pass_through_9,
  b0_.small_image AS small_image_10,
  b0_.middle_image AS middle_image_11,
  b0_.big_image AS big_image_12,
  b0_.mobile_image AS mobile_image_13,
  b0_.mobile_banner AS mobile_banner_14,
  b0_.mobile_divider AS mobile_divider_15,
  b0_.id AS id_16
FROM
  branding_banner b0_
WHERE
  b0_.active_since < ?
  AND b0_.active_till > ?
  AND b0_.test = ?
  AND b0_.active = ?
ORDER BY
  b0_.id DESC

SELECT b0_.banner_id AS banner_id_0, b0_.title AS title_1, b0_.url AS url_2, b0_.right_side_url AS right_side_url_3, b0_.active_since AS active_since_4, b0_.active_till AS active_till_5, b0_.active AS active_6, b0_.test AS test_7, b0_.for_categories AS for_categories_8, b0_.pass_through AS pass_through_9, b0_.small_image AS small_image_10, b0_.middle_image AS middle_image_11, b0_.big_image AS big_image_12, b0_.mobile_image AS mobile_image_13, b0_.mobile_banner AS mobile_banner_14, b0_.mobile_divider AS mobile_divider_15, b0_.id AS id_16 FROM branding_banner b0_ WHERE b0_.active_since < '2025-05-02 05:01:18' AND b0_.active_till > '2025-05-01 05:01:18' AND b0_.test = 0 AND b0_.active = 1 ORDER BY b0_.id DESC;

SELECT
  t0.name AS name_1,
  t0.domain AS domain_2,
  t0.name_genitive AS name_genitive_3,
  t0.name_locative AS name_locative_4,
  t0.active AS active_5,
  t0.position AS position_6,
  t0.google_analytics AS google_analytics_7,
  ST_AsEWKT(t0.point : :geometry) AS point_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10
FROM
  city t0
  INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id
WHERE
  branding_banner_city.banner_id = ?

SELECT t0.name AS name_1, t0.domain AS domain_2, t0.name_genitive AS name_genitive_3, t0.name_locative AS name_locative_4, t0.active AS active_5, t0.position AS position_6, t0.google_analytics AS google_analytics_7, ST_AsEWKT(t0.point::geometry) AS point_8, t0.id AS id_9, t0.parent_id AS parent_id_10 FROM city t0 INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = 728;

SELECT
  t0.name AS name_1,
  t0.domain AS domain_2,
  t0.name_genitive AS name_genitive_3,
  t0.name_locative AS name_locative_4,
  t0.active AS active_5,
  t0.position AS position_6,
  t0.google_analytics AS google_analytics_7,
  ST_AsEWKT(t0.point : :geometry) AS point_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10
FROM
  city t0
  INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id
WHERE
  branding_banner_city.banner_id = ?

SELECT t0.name AS name_1, t0.domain AS domain_2, t0.name_genitive AS name_genitive_3, t0.name_locative AS name_locative_4, t0.active AS active_5, t0.position AS position_6, t0.google_analytics AS google_analytics_7, ST_AsEWKT(t0.point::geometry) AS point_8, t0.id AS id_9, t0.parent_id AS parent_id_10 FROM city t0 INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = 706;

SELECT
  t0.name AS name_1,
  t0.domain AS domain_2,
  t0.name_genitive AS name_genitive_3,
  t0.name_locative AS name_locative_4,
  t0.active AS active_5,
  t0.position AS position_6,
  t0.google_analytics AS google_analytics_7,
  ST_AsEWKT(t0.point : :geometry) AS point_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10
FROM
  city t0
  INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id
WHERE
  branding_banner_city.banner_id = ?

SELECT t0.name AS name_1, t0.domain AS domain_2, t0.name_genitive AS name_genitive_3, t0.name_locative AS name_locative_4, t0.active AS active_5, t0.position AS position_6, t0.google_analytics AS google_analytics_7, ST_AsEWKT(t0.point::geometry) AS point_8, t0.id AS id_9, t0.parent_id AS parent_id_10 FROM city t0 INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = 682;

SELECT
  t0.name AS name_1,
  t0.domain AS domain_2,
  t0.name_genitive AS name_genitive_3,
  t0.name_locative AS name_locative_4,
  t0.active AS active_5,
  t0.position AS position_6,
  t0.google_analytics AS google_analytics_7,
  ST_AsEWKT(t0.point : :geometry) AS point_8,
  t0.id AS id_9,
  t0.parent_id AS parent_id_10
FROM
  city t0
  INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id
WHERE
  branding_banner_city.banner_id = ?

SELECT t0.name AS name_1, t0.domain AS domain_2, t0.name_genitive AS name_genitive_3, t0.name_locative AS name_locative_4, t0.active AS active_5, t0.position AS position_6, t0.google_analytics AS google_analytics_7, ST_AsEWKT(t0.point::geometry) AS point_8, t0.id AS id_9, t0.parent_id AS parent_id_10 FROM city t0 INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = 584;

SELECT
  s0_.eligibility_rule AS eligibility_rule_0,
  s0_.id AS id_1
FROM
  server_feature_state s0_

SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_;

SELECT
  n0_.active AS active_0,
  n0_.test AS test_1,
  n0_.type AS type_2,
  n0_.cookie_name AS cookie_name_3,
  n0_.active_till AS active_till_4,
  n0_.start_after AS start_after_5,
  n0_.picture_text AS picture_text_6,
  n0_.picture_text_bg_color AS picture_text_bg_color_7,
  n0_.left_text AS left_text_8,
  n0_.right_text AS right_text_9,
  n0_.mobile_text AS mobile_text_10,
  n0_.right_bg_color AS right_bg_color_11,
  n0_.button_text AS button_text_12,
  n0_.button_link AS button_link_13,
  n0_.button_bg_color AS button_bg_color_14,
  n0_.button_text_color AS button_text_color_15,
  n0_.dark_close_btn AS dark_close_btn_16,
  n0_.active_from AS active_from_17,
  n0_.id AS id_18
FROM
  notice_popup n0_
WHERE
  n0_.active = true
  AND n0_.type = ?
  AND CURRENT_TIMESTAMP BETWEEN n0_.active_from
  AND n0_.active_till

SELECT n0_.active AS active_0, n0_.test AS test_1, n0_.type AS type_2, n0_.cookie_name AS cookie_name_3, n0_.active_till AS active_till_4, n0_.start_after AS start_after_5, n0_.picture_text AS picture_text_6, n0_.picture_text_bg_color AS picture_text_bg_color_7, n0_.left_text AS left_text_8, n0_.right_text AS right_text_9, n0_.mobile_text AS mobile_text_10, n0_.right_bg_color AS right_bg_color_11, n0_.button_text AS button_text_12, n0_.button_link AS button_link_13, n0_.button_bg_color AS button_bg_color_14, n0_.button_text_color AS button_text_color_15, n0_.dark_close_btn AS dark_close_btn_16, n0_.active_from AS active_from_17, n0_.id AS id_18 FROM notice_popup n0_ WHERE n0_.active = true AND n0_.type = 1 AND CURRENT_TIMESTAMP BETWEEN n0_.active_from AND n0_.active_till;