https://www.test.dev.slivki.by/mobile/api/v2/user/codes/1

Query Metrics

3 Database Queries
3 Different statements
5.10 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

site connection

Time Count Info
2.08 ms
(40.83%)
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_.batch_codes_count AS batch_codes_count_24, c0_.money_balance AS money_balance_25, c0_.id AS id_26, c0_.city_id AS city_id_27 FROM customer c0_ INNER JOIN mobile_user_token m1_ ON (c0_.id = m1_.user_id) WHERE m1_.token = ?
Parameters:
[
  ""
]
1.83 ms
(35.89%)
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:
[
  "/mobile/api/v2/user/codes/1"
]
1.19 ms
(23.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.domain = ? AND t0.main_alias = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "www"
  "/mobile/api/v2/user/codes/1"
  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\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\MobileUserToken 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.

admin entity manager

No loaded entities.

subscription entity manager

No loaded entities.