https://www.t.dev.slivki.by/atest

Query Metrics

6 Database Queries
6 Different statements
8.20 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

site connection

Time Count Info
2.81 ms
(34.24%)
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"
  "/atest"
  1
]
2.19 ms
(26.76%)
1
SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.dob AS dob_24, c0_.batch_codes_count AS batch_codes_count_25, c0_.virtual_wallet_amount AS virtual_wallet_amount_26, c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27, c0_.money_balance AS money_balance_28, c0_.id AS id_29, c0_.city_id AS city_id_30 FROM customer c0_ WHERE c0_.id = ?
Parameters:
[
  535179
]
1.32 ms
(16.07%)
1
SELECT t0.name AS name_1, t0.description AS description_2, t0.transition_id AS transition_id_3, t0.hidden AS hidden_4, t0.id AS id_5 FROM user_group t0 INNER JOIN user2group ON t0.id = user2group.group_id WHERE user2group.user_id = ?
Parameters:
[
  535179
]
0.73 ms
(8.91%)
1
SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.dob AS dob_24, c0_.batch_codes_count AS batch_codes_count_25, c0_.virtual_wallet_amount AS virtual_wallet_amount_26, c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27, c0_.money_balance AS money_balance_28, c0_.id AS id_29, c0_.city_id AS city_id_30 FROM customer c0_ WHERE c0_.token = ?
Parameters:
[
  "5351795e997e952d0622.51592337"
]
0.72 ms
(8.74%)
1
SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = ?
Parameters:
[
  535179
]
0.43 ms
(5.29%)
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:
[
  "/atest"
]

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\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\Referral No errors.
Slivki\Entity\UserBalanceActivity 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\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\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\ProfileImageMedia 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\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\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\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\ServerFeatureState No errors.

admin entity manager

No loaded entities.

subscription entity manager

No loaded entities.