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 = '/skidki-i-rasprodazhi' 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 = '/skidki-i-rasprodazhi' ORDER BY t0.id DESC;

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
  t0.type_id AS type_id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.file_path AS file_path_4,
  t0.active AS active_5,
  t0.file_path_mobile AS file_path_mobile_6,
  t0.substitute_path AS substitute_path_7,
  t0.javascript AS javascript_8,
  t0.json AS json_9,
  t0.code AS code_10,
  t0.code_file_path AS code_file_path_11,
  t0.position AS position_12,
  t0.pixel_code AS pixel_code_13,
  t0.pixel_code_mobile AS pixel_code_mobile_14,
  t0.id AS id_15,
  t0.position_row AS position_row_16,
  t0.position_column AS position_column_17,
  t0.utm_campaign AS utm_campaign_18,
  t0.type
FROM
  banner t0
WHERE
  t0.type_id = ?
  AND t0.active = ?
  AND t0.position_row = ?
  AND t0.type IN ('0')
LIMIT
  1

SELECT t0.type_id AS type_id_1, t0.title AS title_2, t0.url AS url_3, t0.file_path AS file_path_4, t0.active AS active_5, t0.file_path_mobile AS file_path_mobile_6, t0.substitute_path AS substitute_path_7, t0.javascript AS javascript_8, t0.json AS json_9, t0.code AS code_10, t0.code_file_path AS code_file_path_11, t0.position AS position_12, t0.pixel_code AS pixel_code_13, t0.pixel_code_mobile AS pixel_code_mobile_14, t0.id AS id_15, t0.position_row AS position_row_16, t0.position_column AS position_column_17, t0.utm_campaign AS utm_campaign_18, t0.type FROM banner t0 WHERE t0.type_id = 2 AND t0.active = 1 AND t0.position_row = 1 AND t0.type IN ('0') LIMIT 1;

SELECT
  t0.type_id AS type_id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.file_path AS file_path_4,
  t0.active AS active_5,
  t0.file_path_mobile AS file_path_mobile_6,
  t0.substitute_path AS substitute_path_7,
  t0.javascript AS javascript_8,
  t0.json AS json_9,
  t0.code AS code_10,
  t0.code_file_path AS code_file_path_11,
  t0.position AS position_12,
  t0.pixel_code AS pixel_code_13,
  t0.pixel_code_mobile AS pixel_code_mobile_14,
  t0.id AS id_15,
  t0.position_row AS position_row_16,
  t0.position_column AS position_column_17,
  t0.utm_campaign AS utm_campaign_18,
  t0.type
FROM
  banner t0
WHERE
  t0.type_id = ?
  AND t0.active = ?
  AND t0.position_row = ?
  AND t0.type IN ('0')
LIMIT
  1

SELECT t0.type_id AS type_id_1, t0.title AS title_2, t0.url AS url_3, t0.file_path AS file_path_4, t0.active AS active_5, t0.file_path_mobile AS file_path_mobile_6, t0.substitute_path AS substitute_path_7, t0.javascript AS javascript_8, t0.json AS json_9, t0.code AS code_10, t0.code_file_path AS code_file_path_11, t0.position AS position_12, t0.pixel_code AS pixel_code_13, t0.pixel_code_mobile AS pixel_code_mobile_14, t0.id AS id_15, t0.position_row AS position_row_16, t0.position_column AS position_column_17, t0.utm_campaign AS utm_campaign_18, t0.type FROM banner t0 WHERE t0.type_id = 2 AND t0.active = 1 AND t0.position_row = 2 AND t0.type IN ('0') LIMIT 1;

select
  *
from
  hot_feed
where
  type = 1
order by
  created_on desc
limit
  20 offset 0

select * from hot_feed where type = 1  order by created_on desc limit 20 offset 0;

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.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 824 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order 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.tags AS tags_10,
  t0.id AS id_11,
  t0.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 1820 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order 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.tags AS tags_10,
  t0.id AS id_11,
  t0.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 282598 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order 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.tags AS tags_10,
  t0.id AS id_11,
  t0.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 284939 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order 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.tags AS tags_10,
  t0.id AS id_11,
  t0.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 293871 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order 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.tags AS tags_10,
  t0.id AS id_11,
  t0.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 280657 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

SELECT
  t0.created_on AS created_on_1,
  t0.title AS title_2,
  t0.alternative_title AS alternative_title_3,
  t0.body AS body_4,
  t0.active AS active_5,
  t0.sort_order AS sort_order_6,
  t0.since AS since_7,
  t0.till AS till_8,
  t0.top_position AS top_position_9,
  t0.last_modified AS last_modified_10,
  t0.teaser_title AS teaser_title_11,
  t0.flier_title AS flier_title_12,
  t0.flier_text AS flier_text_13,
  t0.gallery_url AS gallery_url_14,
  t0.caption_name AS caption_name_15,
  t0.caption_color AS caption_color_16,
  t0.video_guide_youtube_id AS video_guide_youtube_id_17,
  t0.address AS address_18,
  t0.video_duration_seconds AS video_duration_seconds_19,
  t0.renewed_on AS renewed_on_20,
  t0.offer_link_url AS offer_link_url_21,
  t0.offer_link_name AS offer_link_name_22,
  t0.show_map AS show_map_23,
  t0.supercheck_shop_id AS supercheck_shop_id_24,
  t0.gszurl AS gszurl_25,
  t0.lucene_reindex AS lucene_reindex_26,
  t0.show_on_main_page AS show_on_main_page_27,
  t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28,
  t0.default_category_id AS default_category_id_29,
  t0.alternative_url AS alternative_url_30,
  t0.review AS review_31,
  t0.on_review AS on_review_32,
  t0.id AS id_33,
  t0.creator_id AS creator_id_34
FROM
  sale t0
WHERE
  t0.id = ?

SELECT t0.created_on AS created_on_1, t0.title AS title_2, t0.alternative_title AS alternative_title_3, t0.body AS body_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.since AS since_7, t0.till AS till_8, t0.top_position AS top_position_9, t0.last_modified AS last_modified_10, t0.teaser_title AS teaser_title_11, t0.flier_title AS flier_title_12, t0.flier_text AS flier_text_13, t0.gallery_url AS gallery_url_14, t0.caption_name AS caption_name_15, t0.caption_color AS caption_color_16, t0.video_guide_youtube_id AS video_guide_youtube_id_17, t0.address AS address_18, t0.video_duration_seconds AS video_duration_seconds_19, t0.renewed_on AS renewed_on_20, t0.offer_link_url AS offer_link_url_21, t0.offer_link_name AS offer_link_name_22, t0.show_map AS show_map_23, t0.supercheck_shop_id AS supercheck_shop_id_24, t0.gszurl AS gszurl_25, t0.lucene_reindex AS lucene_reindex_26, t0.show_on_main_page AS show_on_main_page_27, t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28, t0.default_category_id AS default_category_id_29, t0.alternative_url AS alternative_url_30, t0.review AS review_31, t0.on_review AS on_review_32, t0.id AS id_33, t0.creator_id AS creator_id_34 FROM sale t0 WHERE t0.id = 2031;

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.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 276650 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order 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.tags AS tags_10,
  t0.id AS id_11,
  t0.type_id AS type_id_12,
  t0.entity_id AS entity_id_13,
  t0.type_id AS type_id_14,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type_id = ?
  AND t0.type IN ('0')
ORDER BY
  t0.sort_order 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.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = 475 AND t0.type_id = 18077 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;

SELECT
  NEXTVAL('visit_id_seq')

SELECT NEXTVAL('visit_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO visit (
  created_on, entity_id, entity_type_id,
  ip_address, device_type, referrer,
  id, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO visit (created_on, entity_id, entity_type_id, ip_address, device_type, referrer, id, user_id) VALUES ('2025-10-14 07:30:49', 0, 7, '216.73.216.55', 0, '', 841409093, NULL);

"COMMIT"

"COMMIT";

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-10-14 07:30:49' AND b0_.active_till > '2025-10-13 07:30:49' 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 = 808;

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

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

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

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

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

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