https://baranovichi.test.dev.slivki.by/skidki-i-rasprodazhi?utm_source=main_menu

Query Metrics

13 Database Queries
6 Different statements
46.07 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

site connection

Time Count Info
14.18 ms
(30.79%)
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:
[
  "baranovichi"
  "/skidki-i-rasprodazhi"
  1
]
12.70 ms
(27.56%)
2
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.position_row AS position_row_16, t0.position_column AS position_column_17, t0.utm_campaign AS utm_campaign_18, t0.type FROM banner t0 WHERE t0.type_id = ? AND t0.active = ? AND t0.position_row = ? AND t0.type IN ('0') LIMIT 1
Parameters:
[
  2
  1
  1
]
10.27 ms
(22.28%)
1
select * from hot_feed where type = 1  order by created_on desc limit 20 offset 0
Parameters:
[]
7.28 ms
(15.80%)
7
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.id AS id_10, t0.type_id AS type_id_11, t0.entity_id AS entity_id_12, t0.type_id AS type_id_13, 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:
[
  511
  18077
]
0.83 ms
(1.81%)
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:
[
  "/skidki-i-rasprodazhi"
]
0.81 ms
(1.76%)
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\Media\AbstractMediaBase No errors.
Slivki\Entity\Media 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\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\MediaSize No errors.

admin entity manager

Class Mapping 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.

subscription entity manager

No loaded entities.