https://www.t.dev.slivki.by/skidki-i-rasprodazhi/vakansii-ekonomist-stroytrest35

Query Metrics

3 Database Queries
3 Different statements
5.48 ms Query time
14 Invalid entities

Queries

Group similar statements

site connection

# Time Info
1 3.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.domain = ? AND t0.main_alias = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "www"
  "/skidki-i-rasprodazhi/vakansii-ekonomist-stroytrest35"
  1
]
2 0.57 ms
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[]
3 1.49 ms
SELECT t0.created_on AS created_on_1, t0.title AS title_2, t0.alternative_title AS alternative_title_3, t0.body AS body_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.since AS since_7, t0.till AS till_8, t0.top_position AS top_position_9, t0.last_modified AS last_modified_10, t0.teaser_title AS teaser_title_11, t0.flier_title AS flier_title_12, t0.flier_text AS flier_text_13, t0.gallery_url AS gallery_url_14, t0.caption_name AS caption_name_15, t0.caption_color AS caption_color_16, t0.video_guide_youtube_id AS video_guide_youtube_id_17, t0.address AS address_18, t0.video_duration_seconds AS video_duration_seconds_19, t0.renewed_on AS renewed_on_20, t0.offer_link_url AS offer_link_url_21, t0.offer_link_name AS offer_link_name_22, t0.show_map AS show_map_23, t0.supercheck_shop_id AS supercheck_shop_id_24, t0.gszurl AS gszurl_25, t0.lucene_reindex AS lucene_reindex_26, t0.show_on_main_page AS show_on_main_page_27, t0.show_on_main_page_on_mobile_device AS show_on_main_page_on_mobile_device_28, t0.default_category_id AS default_category_id_29, t0.alternative_url AS alternative_url_30, t0.review AS review_31, t0.on_review AS on_review_32, t0.id AS id_33, t0.creator_id AS creator_id_34 FROM sale t0 WHERE t0.id = ?
Parameters:
[
  291201
]

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
  • 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\User
  • The association Slivki\Entity\User#offerOrderDetails refers to the owning side field Slivki\Entity\OfferOrderDetails#user which does not exist.
  • The association Slivki\Entity\User#createdOffers refers to the owning side field Slivki\Entity\Offer#user which does not exist.
  • The association Slivki\Entity\User#createdSales refers to the owning side field Slivki\Entity\Sale#user which does not exist.
  • The mappings Slivki\Entity\User#shareClick and Slivki\Entity\AbstractShareClick#user are inconsistent with each other.
  • The association Slivki\Entity\User#shareClick is ordered by a foreign field sortOrder that is not a field on the target entity Slivki\Entity\AbstractShareClick.
Slivki\Entity\SaleVersion
  • The field Slivki\Entity\SaleVersion#descriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\SaleDescription#saleVersion does not contain the required 'inversedBy="descriptions"' attribute.
  • The field Slivki\Entity\SaleVersion#loadMoreBtnDescriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\SaleLoadMoreBtnDescription#saleVersion does not contain the required 'inversedBy="loadMoreBtnDescriptions"' attribute.
Slivki\Entity\AbstractShareClick
  • The association Slivki\Entity\AbstractShareClick#user refers to the inverse side field Slivki\Entity\User#email which is not defined as association.
  • The association Slivki\Entity\AbstractShareClick#user refers to the inverse side field Slivki\Entity\User#email which does not exist.
Slivki\Entity\SaleShareClick
  • The association Slivki\Entity\SaleShareClick#user refers to the inverse side field Slivki\Entity\User#email which is not defined as association.
  • The association Slivki\Entity\SaleShareClick#user refers to the inverse side field Slivki\Entity\User#email which does not exist.
  • The association Slivki\Entity\SaleShareClick#sale refers to the inverse side field Slivki\Entity\Sale#title which is not defined as association.
  • The association Slivki\Entity\SaleShareClick#sale refers to the inverse side field Slivki\Entity\Sale#title which does not exist.
Slivki\Entity\AbstractGeoLocationBase No errors.
Slivki\Entity\GeoLocation
  • The field Slivki\Entity\GeoLocation#offers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\Offer#geoLocations does not contain the required 'inversedBy="offers"' attribute.
  • The field Slivki\Entity\GeoLocation#giftCertificate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\GiftCertificate#geoLocations does not contain the required 'inversedBy="giftCertificate"' attribute.
Slivki\Entity\Director
  • The field Slivki\Entity\Director#infoPages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\InfoPage#director does not contain the required 'inversedBy="infoPages"' attribute.
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\CityArea No errors.
Slivki\Entity\TopSale No errors.
Slivki\Entity\Mall No errors.
Slivki\Entity\BrandingBanner No errors.
Slivki\Entity\Media\CategoryMobileMenuIconMedia No errors.
Slivki\Entity\Media\CategoryAppIconMedia No errors.
Slivki\Entity\Media\CategoryMapPinIconMedia No errors.
Slivki\Entity\CategoryType No errors.
Slivki\Entity\Referral No errors.
Slivki\Entity\SocialAccount No errors.
Slivki\Entity\AbstractOrderBase
  • The field Slivki\Entity\AbstractOrderBase#offerCodes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\OfferCode#offerOrder does not contain the required 'inversedBy="offerCodes"' attribute.
Slivki\Entity\OfferOrder
  • The field Slivki\Entity\OfferOrder#offerCodes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\OfferCode#offerOrder does not contain the required 'inversedBy="offerCodes"' attribute.
Slivki\Entity\OfferOrderDetails No errors.
Slivki\Entity\UserPhone No errors.
Slivki\Entity\Comment No errors.
Slivki\Entity\UserBalanceActivity No errors.
Slivki\Entity\UserActivity No errors.
Slivki\Entity\Visit No errors.
Slivki\Entity\UserProperty No 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.
Slivki\Entity\FavouriteCategory No errors.
Slivki\Entity\Media\ProfileImageMedia No errors.
Slivki\Entity\SaleProductBasket No errors.
Slivki\Entity\AuthToken No errors.
Slivki\Entity\UserAddress No errors.
Slivki\Entity\SubscriptionPlanUserRelation No errors.
Slivki\Entity\UserGroup No errors.
Slivki\Entity\MailingCampaignType No errors.
Slivki\Entity\CreditCard No errors.
Slivki\Entity\EntityDescription No errors.
Slivki\Entity\SaleFancyDescription No errors.
Slivki\Entity\SaleProduct
  • The association Slivki\Entity\SaleProduct#product refers to the inverse side field Slivki\Entity\Product#saleProduct which does not exist.
Slivki\Entity\SaleDescription No errors.
Slivki\Entity\SaleLoadMoreBtnDescription No errors.
Slivki\Entity\PhoneNumber No errors.
Slivki\Entity\Partner\AdditionalDiscount No errors.
Slivki\Entity\GiftCertificate No errors.
Slivki\Entity\BeautyMaster
  • The field Slivki\Entity\BeautyMaster#workExamples is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\WorkExample#beautyMaster does not contain the required 'inversedBy="workExamples"' attribute.
Slivki\Entity\InfoPage No errors.
Slivki\Entity\Media\DirectorMapLogo No errors.
Slivki\Entity\Media\DirectorOnlinePaymentLogoMedia No errors.
Slivki\Entity\MediaSize No errors.
Slivki\Entity\MediaType No errors.
Slivki\Entity\SearchBanner No errors.

admin entity manager

No loaded entities.

subscription entity manager

No loaded entities.