Query Metrics
39
Database Queries
9
Different statements
61.22 ms
Query time
5
Invalid entities
Grouped Statements
site connection
Time▼ | Count | Info |
---|---|---|
18.90 ms (30.87%) |
26 |
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:
[ 1679 18077 ] |
15.87 ms (25.92%) |
2 |
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
]
|
11.29 ms (18.45%) |
1 |
select DISTINCT sale_product.id from sale_product inner join sale_version on sale_product.sale_version_id = sale_version.id inner join category2entity on sale_version.sale_id = category2entity.entity_id inner join sale on category2entity.entity_id = sale.id inner join media on media.entity_id = sale_product.id where category2entity.category_id = 55 and sale.active and media.type = 1 and now() between sale_version.since and sale_version.till order by 1;
Parameters:
[] |
6.30 ms (10.28%) |
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:
[ "www" "/listovki" 1 ] |
3.72 ms (6.07%) |
5 |
SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = ?
Parameters:
[
180679
]
|
1.46 ms (2.39%) |
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:
[
"/listovki"
]
|
1.46 ms (2.38%) |
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-01 05:16:15" "2025-04-30 05:16:15" 0 1 ] |
1.18 ms (1.93%) |
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
]
|
1.05 ms (1.71%) |
1 |
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[] |
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\AbstractCategoryBase | No errors. |
Slivki\Entity\Category |
|
Slivki\Entity\ServerFeatureState | No errors. |
Slivki\Entity\SaleProduct |
|
Slivki\Entity\Sale |
|
Slivki\Entity\Media\AbstractMediaBase | No errors. |
Slivki\Entity\Media | No errors. |
Slivki\Entity\MediaType | No errors. |
Slivki\Entity\MediaSize | No errors. |
Slivki\Entity\Banner\AbstractBannerBase | No errors. |
Slivki\Entity\Banner\AbstractMobileAppBanner |
|
Slivki\Entity\Banner | No errors. |
Slivki\Entity\Visit | No errors. |
Slivki\Entity\MainMenu | No errors. |
Slivki\Entity\BrandingBanner | No errors. |
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.