Query Metrics
26
Database Queries
11
Different statements
50.30 ms
Query time
3
Invalid entities
Grouped Statements
site connection
Time▼ | Count | Info |
---|---|---|
23.12 ms (45.96%) |
1 |
SELECT c0_.name AS name_0, c0_.domain AS domain_1, c0_.name_genitive AS name_genitive_2, c0_.name_locative AS name_locative_3, c0_.active AS active_4, c0_.position AS position_5, c0_.google_analytics AS google_analytics_6, ST_AsEWKT(c0_.point::geometry) AS point_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9 FROM city c0_ WHERE c0_.active = ? AND c0_.domain = ? LIMIT 1
Parameters:
[ 1 "glubokoe" ] |
12.14 ms (24.14%) |
13 |
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:
[
13164
]
|
3.20 ms (6.35%) |
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.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
]
|
3.09 ms (6.15%) |
3 |
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:
[
728
]
|
2.56 ms (5.09%) |
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 = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "glubokoe" "/auth" 1 ] |
1.72 ms (3.42%) |
2 |
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" 57 1 ] |
1.15 ms (2.29%) |
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
Parameters:
[ "2025-05-20 16:28:36" "2025-05-19 16:28:36" 0 1 ] |
1.15 ms (2.28%) |
1 |
SELECT t0.code_cost AS code_cost_1, t0.regions_code_cost AS regions_code_cost_2, t0.rate_home_phone_text AS rate_home_phone_text_3, t0.rate_mobile_phone_text AS rate_mobile_phone_text_4, t0.default_balance_replenishment AS default_balance_replenishment_5, t0.default_balance_replenishment_call AS default_balance_replenishment_call_6, t0.monthly_code_count AS monthly_code_count_7, t0.monthly_bonus AS monthly_bonus_8, t0.registration_bonus AS registration_bonus_9, t0.replenishment_bonus AS replenishment_bonus_10, t0.replenishment_bonus1 AS replenishment_bonus1_11, t0.replenishment_bonus2 AS replenishment_bonus2_12, t0.avatar_bonus AS avatar_bonus_13, t0.comment_bonus AS comment_bonus_14, t0.comment_bought_bonus AS comment_bought_bonus_15, t0.comment_photo_bonus AS comment_photo_bonus_16, t0.main_page_promo_text AS main_page_promo_text_17, t0.cash_back_bonus AS cash_back_bonus_18, t0.referral_bonus AS referral_bonus_19, t0.mediakit_manager AS mediakit_manager_20, t0.mediakit_phone AS mediakit_phone_21, t0.mob_app_login_bonus AS mob_app_login_bonus_22, t0.subscription_first_payment AS subscription_first_payment_23, t0.subscription_price AS subscription_price_24, t0.mobile_application_version AS mobile_application_version_25, t0.mobile_application_lock_version AS mobile_application_lock_version_26, t0.promised_payment_limit AS promised_payment_limit_27, t0.subscription_code_active_period_in_days AS subscription_code_active_period_in_days_28, t0.replenishment_bonus3 AS replenishment_bonus3_29, t0.replenishment_bonus4 AS replenishment_bonus4_30, t0.id AS id_31 FROM site_settings t0
Parameters:
[] |
0.97 ms (1.92%) |
1 |
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
]
|
0.68 ms (1.35%) |
1 |
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[] |
0.52 ms (1.04%) |
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
Parameters:
[
"/auth"
]
|
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\AbstractCategoryBase | No errors. |
Slivki\Entity\CityArea | No errors. |
Slivki\Entity\TopSale | No errors. |
Slivki\Entity\Mall | No errors. |
Slivki\Entity\Banner\AbstractBannerBase | No errors. |
Slivki\Entity\BrandingBanner | No errors. |
Slivki\Entity\Seo | No errors. |
Slivki\Entity\Media\AbstractMediaBase | No errors. |
Slivki\Entity\Media | No errors. |
Slivki\Entity\Banner\AbstractMobileAppBanner |
|
Slivki\Entity\Banner | No errors. |
Slivki\Entity\ServerFeatureState | No errors. |
Slivki\Entity\Category |
|
Slivki\Entity\SiteSettings | No errors. |
Slivki\Entity\Banner\HeaderBanner | No errors. |
Slivki\Entity\Offer |
|
Slivki\Entity\InfoPage | No errors. |
Slivki\Entity\NoticePopup | No errors. |
admin entity manager
No loaded entities.
subscription entity manager
No loaded entities.