Query Metrics
7
Database Queries
6
Different statements
24.92 ms
Query time
3
Invalid entities
Queries
site connection
#▲ | Time | Info |
---|---|---|
1 | 2.88 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:
[ "www" "/virtual-wallet-pay" 1 ] |
2 | 0.43 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.main_alias = ? ORDER BY t0.id DESC
Parameters:
[
"/virtual-wallet-pay"
]
|
3 | 1.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-04-30 13:49:05" "2025-04-29 13:49:05" 0 1 ] |
4 | 16.64 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:
[
706
]
|
5 | 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 branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = ?
Parameters:
[
584
]
|
6 | 0.72 ms |
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[] |
7 | 1.22 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
]
|
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\Banner\AbstractBannerBase | No errors. |
Slivki\Entity\Banner\AbstractMobileAppBanner |
|
Slivki\Entity\Banner | No errors. |
Slivki\Entity\ServerFeatureState | No errors. |
Slivki\Entity\BrandingBanner | No errors. |
Slivki\Entity\AbstractCategoryBase | No errors. |
Slivki\Entity\Category |
|
Slivki\Entity\CityArea | No errors. |
Slivki\Entity\TopSale | No errors. |
Slivki\Entity\Mall | No errors. |
Slivki\Entity\Offer |
|
Slivki\Entity\NoticePopup | No errors. |
admin entity manager
No loaded entities.
subscription entity manager
No loaded entities.