Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

38 Database Queries

18 Different statements

83.46 ms Query time

10 Invalid entities

Queries

Group similar statements

site connection


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 = ? AND t0.main_alias = ? ORDER BY t0.id DESC LIMIT 1
SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.voice_path AS voice_path_20, c0_.phone AS phone_21, c0_.transcription AS transcription_22, c0_.id AS id_23, c0_.parent_id AS parent_id_24, c0_.user_id AS user_id_25, c0_.operator_id AS operator_id_26 FROM comment c0_ INNER JOIN offer o1_ ON (o1_.id = c0_.entity_id) WHERE c0_.hidden = ? AND c0_.confirmed_phone = ? AND o1_.default_city_id <> ? ORDER BY c0_.created_on DESC LIMIT 3
SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = ? ORDER BY t0.sort_order ASC LIMIT 3
SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = ? ORDER BY t0.sort_order ASC LIMIT 3
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.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.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.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.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.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 NEXTVAL('visit_id_seq')
"START TRANSACTION"
INSERT INTO visit (created_on, entity_id, entity_type_id, ip_address, device_type, referrer, id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
select * from hot_feed where type = 1  and city_id = 89 order by created_on desc limit 20 offset 0
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 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 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 = ?
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.category_id AS category_id_16, t0.pass_through AS pass_through_17, t0.type FROM banner t0 WHERE t0.active = ? AND t0.type IN ('7') ORDER BY t0.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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ?
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

#▲	Time	Info
1	3.31 ms	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 Parameters: [`"mozyr" "/" 1`] View formatted query View runnable query Explain query 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 = 'mozyr' AND t0.main_alias = '/' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;
2	0.62 ms	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 = ? ORDER BY t0.id DESC LIMIT 1 Parameters: [`"mozyr" "/mozyr"`] View formatted query View runnable query Explain query 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 = ? 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 = 'mozyr' AND t0.main_alias = '/mozyr' ORDER BY t0.id DESC LIMIT 1;
3	4.80 ms	SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.voice_path AS voice_path_20, c0_.phone AS phone_21, c0_.transcription AS transcription_22, c0_.id AS id_23, c0_.parent_id AS parent_id_24, c0_.user_id AS user_id_25, c0_.operator_id AS operator_id_26 FROM comment c0_ INNER JOIN offer o1_ ON (o1_.id = c0_.entity_id) WHERE c0_.hidden = ? AND c0_.confirmed_phone = ? AND o1_.default_city_id <> ? ORDER BY c0_.created_on DESC LIMIT 3 Parameters: [`0 1 184`] View formatted query View runnable query Explain query SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.voice_path AS voice_path_20, c0_.phone AS phone_21, c0_.transcription AS transcription_22, c0_.id AS id_23, c0_.parent_id AS parent_id_24, c0_.user_id AS user_id_25, c0_.operator_id AS operator_id_26 FROM comment c0_ INNER JOIN offer o1_ ON (o1_.id = c0_.entity_id) WHERE c0_.hidden = ? AND c0_.confirmed_phone = ? AND o1_.default_city_id <> ? ORDER BY c0_.created_on DESC LIMIT 3 SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.voice_path AS voice_path_20, c0_.phone AS phone_21, c0_.transcription AS transcription_22, c0_.id AS id_23, c0_.parent_id AS parent_id_24, c0_.user_id AS user_id_25, c0_.operator_id AS operator_id_26 FROM comment c0_ INNER JOIN offer o1_ ON (o1_.id = c0_.entity_id) WHERE c0_.hidden = 0 AND c0_.confirmed_phone = 1 AND o1_.default_city_id <> 184 ORDER BY c0_.created_on DESC LIMIT 3;
4	1.43 ms	SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = ? ORDER BY t0.sort_order ASC LIMIT 3 Parameters: [`89`] View formatted query View runnable query Explain query SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = ? ORDER BY t0.sort_order ASC LIMIT 3 SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = 89 ORDER BY t0.sort_order ASC LIMIT 3;
5	0.42 ms	SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = ? ORDER BY t0.sort_order ASC LIMIT 3 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = ? ORDER BY t0.sort_order ASC LIMIT 3 SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.sale_id AS sale_id_3, t0.city_id AS city_id_4 FROM top_sale t0 WHERE t0.city_id = 1 ORDER BY t0.sort_order ASC LIMIT 3;
6	2.44 ms	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 = ? Parameters: [`286299`] View formatted query View runnable query Explain query 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 = 286299;
7	2.09 ms	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 Parameters: [`286299 18228`] View formatted query View runnable query Explain query 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 = 286299 AND t0.type_id = 18228 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;
8	1.41 ms	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 = ? Parameters: [`1356`] View formatted query View runnable query Explain query 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 = 1356;
9	0.85 ms	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 Parameters: [`1356 18228`] View formatted query View runnable query Explain query 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 = 1356 AND t0.type_id = 18228 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;
10	0.71 ms	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 = ? Parameters: [`286334`] View formatted query View runnable query Explain query 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 = 286334;
11	0.80 ms	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 Parameters: [`286334 18228`] View formatted query View runnable query Explain query 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 = 286334 AND t0.type_id = 18228 AND t0.type IN ('0') ORDER BY t0.sort_order ASC;
12	0.61 ms	SELECT NEXTVAL('visit_id_seq') Parameters: [] View formatted query View runnable query Explain query SELECT NEXTVAL('visit_id_seq') SELECT NEXTVAL('visit_id_seq');
13	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
14	1.50 ms	INSERT INTO visit (created_on, entity_id, entity_type_id, ip_address, device_type, referrer, id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-11-03 17:17:40" 2 => 0 3 => 0 4 => "124.243.181.22" 5 => 0 6 => "https://mozyr.test1.dev.slivki.by/" 7 => 845814306 8 => null`] View formatted query View runnable query Explain query 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-11-03 17:17:40', 0, 0, '124.243.181.22', 0, 'https://mozyr.test1.dev.slivki.by/', 845814306, NULL);
15	0.97 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	1.12 ms	select * from hot_feed where type = 1 and city_id = 89 order by created_on desc limit 20 offset 0 Parameters: [] View formatted query View runnable query Explain query select * from hot_feed where type = 1 and city_id = 89 order by created_on desc limit 20 offset 0 select * from hot_feed where type = 1 and city_id = 89 order by created_on desc limit 20 offset 0;
17	1.15 ms	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 Parameters: [`"Slivki:Default:index" 89 1`] View formatted query View runnable query Explain query 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:index' AND t0.entity_id = 89 AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;
18	2.79 ms	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 Parameters: [`"2025-11-03 17:17:40" "2025-11-02 17:17:40" 0 1`] View formatted query View runnable query Explain query 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-11-03 17:17:40' AND b0_.active_till > '2025-11-02 17:17:40' AND b0_.test = 0 AND b0_.active = 1 ORDER BY b0_.id DESC;
19	22.20 ms	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 = ? Parameters: [`736`] View formatted query View runnable query Explain query 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 = 736;
20	2.04 ms	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 = ? Parameters: [`272`] View formatted query View runnable query Explain query 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 = 272;
21	9.73 ms	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.category_id AS category_id_16, t0.pass_through AS pass_through_17, t0.type FROM banner t0 WHERE t0.active = ? AND t0.type IN ('7') ORDER BY t0.id DESC Parameters: [`1`] View formatted query View runnable query Explain query 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.category_id AS category_id_16, t0.pass_through AS pass_through_17, t0.type FROM banner t0 WHERE t0.active = ? AND t0.type IN ('7') ORDER BY t0.id DESC 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.category_id AS category_id_16, t0.pass_through AS pass_through_17, t0.type FROM banner t0 WHERE t0.active = 1 AND t0.type IN ('7') ORDER BY t0.id DESC;
22	3.27 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`15430`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 15430;
23	2.07 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`15387`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 15387;
24	1.16 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`15319`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 15319;
25	1.17 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`14939`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 14939;
26	1.33 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`14121`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 14121;
27	1.24 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`13498`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 13498;
28	1.09 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`13454`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 13454;
29	1.07 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`12986`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 12986;
30	1.05 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`12892`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 12892;
31	1.07 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`12524`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 12524;
32	1.30 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`12322`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 12322;
33	1.22 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`11044`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 11044;
34	1.14 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`10883`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 10883;
35	1.13 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`10093`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 10093;
36	1.11 ms	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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = ? Parameters: [`5746`] View formatted query View runnable query Explain query 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 banner_city ON t0.id = banner_city.city_id WHERE 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 banner_city ON t0.id = banner_city.city_id WHERE banner_city.banner_id = 5746;
37	0.76 ms	SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_ Parameters: [] View formatted query View runnable query Explain query 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_;
38	1.07 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;

admin connection

No database queries were performed.

subscription connection

No database queries were performed.

default connection

No database queries were performed.

Database Connections

Name	Service
site	doctrine.dbal.site_connection
admin	doctrine.dbal.admin_connection
subscription	doctrine.dbal.subscription_connection
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
admin	doctrine.orm.admin_entity_manager
subscription	doctrine.orm.subscription_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
Slivki\Entity\City	No errors.
Slivki\Entity\PartnerMailingCampaignAction	No errors.
Slivki\Entity\Seo	No errors.
Slivki\Entity\Media\AbstractMediaBase	No errors.
Slivki\Entity\Media	No errors.
Slivki\Entity\Media\CommentMedia	No errors.
Slivki\Entity\Media\ProfileImageMedia	No errors.
Slivki\Entity\Banner\AbstractBannerBase	No errors.
Slivki\Entity\Banner\AbstractMobileAppBanner	Entity class 'Slivki\Entity\Banner\AbstractMobileAppBanner' is part of inheritance hierarchy, but is not mapped in the root entity 'Slivki\Entity\Banner\AbstractBannerBase' discriminator map. All subclasses must be listed in the discriminator map.
Slivki\Entity\Banner	No errors.
Slivki\Entity\AbstractCategoryBase	No errors.
Slivki\Entity\Category	The field Slivki\Entity\Category#brandingBanners is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\BrandingBanner#categories does not contain the required 'inversedBy="brandingBanners"' attribute.
Slivki\Entity\ServerFeatureState	No errors.
Slivki\Entity\Comment	No errors.
Slivki\Entity\MainMenu	No errors.
Slivki\Entity\Offer	The mappings Slivki\Entity\Offer#shareClick and Slivki\Entity\OfferShareClick#offer are inconsistent with each other. The association Slivki\Entity\Offer#phoneCoverClick refers to the owning side field Slivki\Entity\PhoneCoverClick#offer which does not exist. The mappings Slivki\Entity\Offer#teaserMedias and Slivki\Entity\Media\OfferTeaserMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#mobileTeaserMedias and Slivki\Entity\Media\OfferMobileTeaserMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#appTeaserMedias and Slivki\Entity\Media\OfferAppTeaserMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#topBlockMedias and Slivki\Entity\Media\OfferTopBlockMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#topBlockMobileMedias and Slivki\Entity\Media\OfferTopBlockMobileMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#mailingTeaserMedias and Slivki\Entity\Media\OfferMailingTeaserMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#giftCertificatePdfBgMedias and Slivki\Entity\Media\GiftCertificatePdfBgMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#supplierPhotoMedias and Slivki\Entity\Media\OfferSupplierPhotoMedia#offer are inconsistent with each other. The mappings Slivki\Entity\Offer#creator and Slivki\Entity\User#createdOffers are inconsistent with each other.
Slivki\Entity\User	The association Slivki\Entity\User#offerOrderDetails refers to the owning side field Slivki\Entity\OfferOrderDetails#user which does not exist. The association Slivki\Entity\User#createdOffers refers to the owning side field Slivki\Entity\Offer#user which does not exist. The association Slivki\Entity\User#createdSales refers to the owning side field Slivki\Entity\Sale#user which does not exist. The mappings Slivki\Entity\User#shareClick and Slivki\Entity\AbstractShareClick#user are inconsistent with each other. The association Slivki\Entity\User#shareClick is ordered by a foreign field sortOrder that is not a field on the target entity Slivki\Entity\AbstractShareClick.
Slivki\Entity\CommentLike	No errors.
Slivki\Entity\Sale	The mappings Slivki\Entity\Sale#creator and Slivki\Entity\User#createdSales are inconsistent with each other. If association Slivki\Entity\Sale#creator is one-to-one, then the inversed side Slivki\Entity\User#createdSales has to be one-to-one as well. The mappings Slivki\Entity\Sale#shareClick and Slivki\Entity\SaleShareClick#sale are inconsistent with each other. The field Slivki\Entity\Sale#offerCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\Category#sales does not contain the required 'inversedBy="offerCategories"' attribute.
Slivki\Entity\TopSale	No errors.
Slivki\Entity\SaleVersion	The field Slivki\Entity\SaleVersion#descriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\SaleDescription#saleVersion does not contain the required 'inversedBy="descriptions"' attribute. The field Slivki\Entity\SaleVersion#loadMoreBtnDescriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\SaleLoadMoreBtnDescription#saleVersion does not contain the required 'inversedBy="loadMoreBtnDescriptions"' attribute.
Slivki\Entity\AbstractShareClick	The association Slivki\Entity\AbstractShareClick#user refers to the inverse side field Slivki\Entity\User#email which is not defined as association. The association Slivki\Entity\AbstractShareClick#user refers to the inverse side field Slivki\Entity\User#email which does not exist.
Slivki\Entity\SaleShareClick	The association Slivki\Entity\SaleShareClick#user refers to the inverse side field Slivki\Entity\User#email which is not defined as association. The association Slivki\Entity\SaleShareClick#user refers to the inverse side field Slivki\Entity\User#email which does not exist. The association Slivki\Entity\SaleShareClick#sale refers to the inverse side field Slivki\Entity\Sale#title which is not defined as association. The association Slivki\Entity\SaleShareClick#sale refers to the inverse side field Slivki\Entity\Sale#title which does not exist.
Slivki\Entity\AbstractGeoLocationBase	No errors.
Slivki\Entity\GeoLocation	The field Slivki\Entity\GeoLocation#offers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\Offer#geoLocations does not contain the required 'inversedBy="offers"' attribute. The field Slivki\Entity\GeoLocation#giftCertificate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\GiftCertificate#geoLocations does not contain the required 'inversedBy="giftCertificate"' attribute.
Slivki\Entity\Director	The field Slivki\Entity\Director#infoPages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\InfoPage#director does not contain the required 'inversedBy="infoPages"' attribute.
Slivki\Entity\MediaType	No errors.
Slivki\Entity\MediaSize	No errors.
Slivki\Entity\Visit	No errors.
Slivki\Entity\BrandingBanner	No errors.
Slivki\Entity\CityArea	No errors.
Slivki\Entity\Mall	No errors.
Slivki\Entity\Banner\HeaderBanner	No errors.
Slivki\Entity\NoticePopup	No errors.

admin entity manager

No loaded entities.

subscription entity manager

No loaded entities.

Symfony Profiler

https://mozyr.test1.dev.slivki.by/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

site connection

admin connection

subscription connection

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

admin entity manager

subscription entity manager