Symfony Profiler

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
WHERE
  t0.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 WHERE t0.id = 1;

select
  get_visit_count(1, 0, 30)

select get_visit_count(1, 0, 30);

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 = '/delivery/select/168501' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

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
  coalesce(
    max(city_id),
    1
  )
from
  category
  inner join category2entity on category.id = category2entity.category_id
where
  category2entity.entity_id = 168501

select coalesce(max(city_id), 1) from category inner join category2entity on category.id = category2entity.category_id where category2entity.entity_id = 168501;

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-01 05:11:35' AND b0_.active_till > '2025-04-30 05:11:35' AND b0_.test = 0 AND b0_.active = 1 ORDER BY b0_.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 = 6000;

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.tags AS tags_10,
  t0.id AS id_11,
  t0.entity_id AS entity_id_12,
  t0.type
FROM
  media t0
WHERE
  t0.id = ?
  AND t0.type IN ('23')

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.tags AS tags_10, t0.id AS id_11, t0.entity_id AS entity_id_12, t0.type FROM media t0 WHERE t0.id = 944544 AND t0.type IN ('23');

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;

SELECT
  p0_.last_modified AS last_modified_0,
  p0_.entity_id AS entity_id_1,
  p0_.purchase_count AS purchase_count_2,
  p0_.purchase_count_recent AS purchase_count_recent_3,
  p0_.purchase_count_last_month AS purchase_count_last_month_4,
  p0_.purchase_count_last_day AS purchase_count_last_day_5,
  p0_.purchase_count_last_month_with_correction AS purchase_count_last_month_with_correction_6,
  p0_.purchase_count_last_week_with_correction AS purchase_count_last_week_with_correction_7,
  p0_.purchase_count_last_day_with_correction AS purchase_count_last_day_with_correction_8,
  p0_.purchase_count_with_correction AS purchase_count_with_correction_9,
  p0_.id AS id_10
FROM
  purchase_count p0_
WHERE
  p0_.entity_id = ?

SELECT p0_.last_modified AS last_modified_0, p0_.entity_id AS entity_id_1, p0_.purchase_count AS purchase_count_2, p0_.purchase_count_recent AS purchase_count_recent_3, p0_.purchase_count_last_month AS purchase_count_last_month_4, p0_.purchase_count_last_day AS purchase_count_last_day_5, p0_.purchase_count_last_month_with_correction AS purchase_count_last_month_with_correction_6, p0_.purchase_count_last_week_with_correction AS purchase_count_last_week_with_correction_7, p0_.purchase_count_last_day_with_correction AS purchase_count_last_day_with_correction_8, p0_.purchase_count_with_correction AS purchase_count_with_correction_9, p0_.id AS id_10 FROM purchase_count p0_ WHERE p0_.entity_id = 168501;

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

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.resource_url = ?
  AND t0.entity_id = ?
  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.resource_url = 'Slivki:Default:details' AND t0.entity_id = 168501 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 = '/delivery/select/168501' ORDER BY t0.id DESC;

SELECT
  t0.media_id AS media_id_1,
  t0.width AS width_2,
  t0.height AS height_3,
  t0.id AS id_4,
  t0.media_id AS media_id_5
FROM
  media_size t0
WHERE
  t0.media_id = ?

SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = 944544;

SELECT
  f0_.entity_id AS entity_id_0,
  f0_.open AS open_1,
  f0_.recommended AS recommended_2,
  f0_.popular AS popular_3,
  f0_.speed AS speed_4,
  f0_.asc_price AS asc_price_5,
  f0_.desc_price AS desc_price_6,
  f0_.price_by_kg AS price_by_kg_7,
  f0_.popular_day AS popular_day_8,
  f0_.price_by_kg_desc AS price_by_kg_desc_9,
  f0_.id AS id_10
FROM
  food_filter_counter f0_
WHERE
  f0_.entity_id = ?

SELECT f0_.entity_id AS entity_id_0, f0_.open AS open_1, f0_.recommended AS recommended_2, f0_.popular AS popular_3, f0_.speed AS speed_4, f0_.asc_price AS asc_price_5, f0_.desc_price AS desc_price_6, f0_.price_by_kg AS price_by_kg_7, f0_.popular_day AS popular_day_8, f0_.price_by_kg_desc AS price_by_kg_desc_9, f0_.id AS id_10 FROM food_filter_counter f0_ WHERE f0_.entity_id = 168501;

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.resource_url = ?
  AND t0.entity_id IS NULL
  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.resource_url = 'Slivki:Default:category' AND t0.entity_id IS NULL AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  count(*)
FROM
  product_fast_delivery pfd
WHERE
  (pfd.active = :active)
  AND (pfd.offer_id = :offerId)

SELECT count(*) FROM product_fast_delivery pfd WHERE (pfd.active = 1) AND (pfd.offer_id = 168501);

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