https://www.dima.dev.slivki.by/landing

Query Metrics

12 Database Queries
8 Different statements
16.65 ms Query time
4 Invalid entities

Queries

Group similar statements

site connection

# Time Info
1 3.24 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"
  "/landing"
  1
]
2 0.45 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:
[
  "/landing"
]
3 0.69 ms
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[]
4 0.90 ms
SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.category_id AS category_id_3 FROM popular_category t0 ORDER BY t0.sort_order ASC LIMIT 3
Parameters:
[]
5 1.52 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.type_id AS type_id_8, t0.domain_object_id AS domain_object_id_9, t0.past AS past_10, t0.code AS code_11, t0.top_count AS top_count_12, t0.description AS description_13, t0.mobile_api_hash AS mobile_api_hash_14, t0.entity_count AS entity_count_15, t0.last_modified AS last_modified_16, t0.in_menu_bottom AS in_menu_bottom_17, t0.hot_feed_name AS hot_feed_name_18, t0.unpopular AS unpopular_19, t0.featured_in_menu AS featured_in_menu_20, t0.position AS position_21, t0.telegram_bot_show AS telegram_bot_show_22, t0.telegram_bot_name AS telegram_bot_name_23, t0.telegram_bot_position AS telegram_bot_position_24, t0.split_offers_with_same_categories AS split_offers_with_same_categories_25, t0.utm_campaign AS utm_campaign_26, t0.me_on_map_active AS me_on_map_active_27, t0.me_on_map_position AS me_on_map_position_28, t0.me_on_map_featured_active AS me_on_map_featured_active_29, t0.me_on_map_featured_position AS me_on_map_featured_position_30, t0.show_items_catalog AS show_items_catalog_31, t0.active_in_best_offers_category AS active_in_best_offers_category_32, t0.hide_work_examples AS hide_work_examples_33, t0.is_bonus_code AS is_bonus_code_34, t0.city_id AS city_id_35, t0.type_id AS type_id_36, t0.type FROM category t0 WHERE t0.id = ? AND t0.type IN ('0')
Parameters:
[
  3894
]
6 1.25 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:
[
  3894
  18235
]
7 1.35 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type, t0.type_id AS type_id_9, t0.domain_object_id AS domain_object_id_10, t0.past AS past_11, t0.code AS code_12, t0.top_count AS top_count_13, t0.description AS description_14, t0.mobile_api_hash AS mobile_api_hash_15, t0.entity_count AS entity_count_16, t0.last_modified AS last_modified_17, t0.in_menu_bottom AS in_menu_bottom_18, t0.hot_feed_name AS hot_feed_name_19, t0.unpopular AS unpopular_20, t0.featured_in_menu AS featured_in_menu_21, t0.position AS position_22, t0.telegram_bot_show AS telegram_bot_show_23, t0.telegram_bot_name AS telegram_bot_name_24, t0.telegram_bot_position AS telegram_bot_position_25, t0.split_offers_with_same_categories AS split_offers_with_same_categories_26, t0.utm_campaign AS utm_campaign_27, t0.me_on_map_active AS me_on_map_active_28, t0.me_on_map_position AS me_on_map_position_29, t0.me_on_map_featured_active AS me_on_map_featured_active_30, t0.me_on_map_featured_position AS me_on_map_featured_position_31, t0.show_items_catalog AS show_items_catalog_32, t0.active_in_best_offers_category AS active_in_best_offers_category_33, t0.hide_work_examples AS hide_work_examples_34, t0.is_bonus_code AS is_bonus_code_35, t0.type_id AS type_id_36 FROM category t0 INNER JOIN category_child_relation ON t0.id = category_child_relation.parent_id WHERE category_child_relation.child_id = ? AND t0.type IN ('0', '1', '3', '4', '5', '6')
Parameters:
[
  3894
]
8 0.78 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.type_id AS type_id_8, t0.domain_object_id AS domain_object_id_9, t0.past AS past_10, t0.code AS code_11, t0.top_count AS top_count_12, t0.description AS description_13, t0.mobile_api_hash AS mobile_api_hash_14, t0.entity_count AS entity_count_15, t0.last_modified AS last_modified_16, t0.in_menu_bottom AS in_menu_bottom_17, t0.hot_feed_name AS hot_feed_name_18, t0.unpopular AS unpopular_19, t0.featured_in_menu AS featured_in_menu_20, t0.position AS position_21, t0.telegram_bot_show AS telegram_bot_show_22, t0.telegram_bot_name AS telegram_bot_name_23, t0.telegram_bot_position AS telegram_bot_position_24, t0.split_offers_with_same_categories AS split_offers_with_same_categories_25, t0.utm_campaign AS utm_campaign_26, t0.me_on_map_active AS me_on_map_active_27, t0.me_on_map_position AS me_on_map_position_28, t0.me_on_map_featured_active AS me_on_map_featured_active_29, t0.me_on_map_featured_position AS me_on_map_featured_position_30, t0.show_items_catalog AS show_items_catalog_31, t0.active_in_best_offers_category AS active_in_best_offers_category_32, t0.hide_work_examples AS hide_work_examples_33, t0.is_bonus_code AS is_bonus_code_34, t0.city_id AS city_id_35, t0.type_id AS type_id_36, t0.type FROM category t0 WHERE t0.id = ? AND t0.type IN ('0')
Parameters:
[
  476
]
9 0.59 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:
[
  476
  18235
]
10 0.63 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.type_id AS type_id_8, t0.domain_object_id AS domain_object_id_9, t0.past AS past_10, t0.code AS code_11, t0.top_count AS top_count_12, t0.description AS description_13, t0.mobile_api_hash AS mobile_api_hash_14, t0.entity_count AS entity_count_15, t0.last_modified AS last_modified_16, t0.in_menu_bottom AS in_menu_bottom_17, t0.hot_feed_name AS hot_feed_name_18, t0.unpopular AS unpopular_19, t0.featured_in_menu AS featured_in_menu_20, t0.position AS position_21, t0.telegram_bot_show AS telegram_bot_show_22, t0.telegram_bot_name AS telegram_bot_name_23, t0.telegram_bot_position AS telegram_bot_position_24, t0.split_offers_with_same_categories AS split_offers_with_same_categories_25, t0.utm_campaign AS utm_campaign_26, t0.me_on_map_active AS me_on_map_active_27, t0.me_on_map_position AS me_on_map_position_28, t0.me_on_map_featured_active AS me_on_map_featured_active_29, t0.me_on_map_featured_position AS me_on_map_featured_position_30, t0.show_items_catalog AS show_items_catalog_31, t0.active_in_best_offers_category AS active_in_best_offers_category_32, t0.hide_work_examples AS hide_work_examples_33, t0.is_bonus_code AS is_bonus_code_34, t0.city_id AS city_id_35, t0.type_id AS type_id_36, t0.type FROM category t0 WHERE t0.id = ? AND t0.type IN ('0')
Parameters:
[
  212
]
11 0.46 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:
[
  212
  18235
]
12 4.79 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.type FROM banner t0 WHERE t0.active = ? AND t0.type IN ('9') ORDER BY t0.position ASC
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\ServerFeatureState 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\PopularCategory No errors.
Slivki\Entity\Media\AbstractMediaBase No errors.
Slivki\Entity\Media No errors.
Slivki\Entity\CategoryType No errors.
Slivki\Entity\Media\CategoryMobileMenuIconMedia No errors.
Slivki\Entity\Media\CategoryAppIconMedia No errors.
Slivki\Entity\Media\CategoryMapPinIconMedia No errors.
Slivki\Entity\Banner\AbstractBannerBase No errors.
Slivki\Entity\Banner No errors.
Slivki\Entity\BrandingBanner 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\MediaType No errors.
Slivki\Entity\ProductCategory No errors.
Slivki\Entity\OfferExtensionCategory No errors.
Slivki\Entity\GiftCertificateCategory No errors.
Slivki\Entity\GiftCertificateGiftCategory No errors.
Slivki\Entity\OfferExtensionOnlineCategory No errors.
Slivki\Entity\MediaSize No errors.
Slivki\Entity\Banner\MobileLandingBanner 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\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.

admin entity manager

No loaded entities.

subscription entity manager

No loaded entities.