https://soligorsk.test.dev.slivki.by/main_hot_feed/20/20/1/false/27

Query Metrics

24 Database Queries
6 Different statements
23.28 ms Query time
6 Invalid entities

Queries

Group similar statements

site connection

# Time Info
1 2.01 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:
[
  "soligorsk"
  "/main_hot_feed/20/20/1/false/27"
  1
]
2 1.20 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:
[
  "/main_hot_feed/20/20/1/false/27"
]
3 4.12 ms
select * from hot_feed where type = 1  and city_id = 27 order by created_on desc limit 20 offset 20
Parameters:
[]
4 1.26 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  285589
  1
]
5 0.71 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.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.id = ? AND t0.type IN ('10')
Parameters:
[
  720538
]
6 0.74 ms
SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = ?
Parameters:
[
  720538
]
7 0.89 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  290575
  1
]
8 0.87 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  288577
  1
]
9 0.64 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.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.id = ? AND t0.type IN ('10')
Parameters:
[
  775875
]
10 0.57 ms
SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = ?
Parameters:
[
  775875
]
11 0.74 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  288574
  1
]
12 0.97 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  288596
  1
]
13 0.85 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  288594
  1
]
14 0.60 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.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.id = ? AND t0.type IN ('10')
Parameters:
[
  776007
]
15 0.57 ms
SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = ?
Parameters:
[
  776007
]
16 0.79 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  279174
  1
]
17 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.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.id = ? AND t0.type IN ('10')
Parameters:
[
  611301
]
18 0.52 ms
SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = ?
Parameters:
[
  611301
]
19 0.81 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  279172
  1
]
20 0.69 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.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.id = ? AND t0.type IN ('10')
Parameters:
[
  614215
]
21 0.55 ms
SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = ?
Parameters:
[
  614215
]
22 1.37 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.resource_url = ? AND t0.entity_id = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "Slivki:Default:details"
  143139
  1
]
23 0.62 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.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.id = ? AND t0.type IN ('10')
Parameters:
[
  1377792
]
24 0.61 ms
SELECT t0.media_id AS media_id_1, t0.width AS width_2, t0.height AS height_3, t0.id AS id_4, t0.media_id AS media_id_5 FROM media_size t0 WHERE t0.media_id = ?
Parameters:
[
  1377792
]

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\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\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\ServerFeatureState No errors.
Slivki\Entity\Media\OfferTeaserMedia
  • The association Slivki\Entity\Media\OfferTeaserMedia#offer refers to the inverse side field Slivki\Entity\Offer#teaserMedia which does not exist.
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\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.