Query Metrics
13
Database Queries
6
Different statements
46.07 ms
Query time
26
Invalid entities
Queries
site connection
#▲ | Time | Info |
---|---|---|
1 | 14.18 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:
[ "baranovichi" "/skidki-i-rasprodazhi" 1 ] |
2 | 0.83 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:
[
"/skidki-i-rasprodazhi"
]
|
3 | 0.81 ms |
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[] |
4 | 6.99 ms |
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 ] |
5 | 5.70 ms |
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 2 ] |
6 | 10.27 ms |
select * from hot_feed where type = 1 order by created_on desc limit 20 offset 0
Parameters:
[] |
7 | 1.22 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.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 ] |
8 | 1.41 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.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:
[ 824 18077 ] |
9 | 0.96 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.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:
[ 329 18077 ] |
10 | 1.02 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.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:
[ 328 18077 ] |
11 | 1.00 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.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:
[ 823 18077 ] |
12 | 0.83 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.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:
[ 281578 18077 ] |
13 | 0.85 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.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:
[ 277869 18077 ] |
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 |
|
Slivki\Entity\Banner | No errors. |
Slivki\Entity\AbstractCategoryBase | No errors. |
Slivki\Entity\Category |
|
Slivki\Entity\ServerFeatureState | No errors. |
Slivki\Entity\Sale |
|
Slivki\Entity\MediaType | No errors. |
Slivki\Entity\MediaSize | No errors. |
Slivki\Entity\CityArea | No errors. |
Slivki\Entity\TopSale | No errors. |
Slivki\Entity\Mall | No errors. |
Slivki\Entity\BrandingBanner | No errors. |
Slivki\Entity\SearchBanner | 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\User |
|
Slivki\Entity\SaleVersion |
|
Slivki\Entity\AbstractShareClick |
|
Slivki\Entity\SaleShareClick |
|
Slivki\Entity\AbstractGeoLocationBase | No errors. |
Slivki\Entity\GeoLocation |
|
Slivki\Entity\Director |
|
admin entity manager
Class | Mapping errors |
---|---|
Slivki\Entity\Offer |
|
Slivki\Entity\EntityDescription | No errors. |
Slivki\Entity\AbstractShareClick |
|
Slivki\Entity\OfferShareClick |
|
Slivki\Entity\PhoneCoverClick | No errors. |
Slivki\Entity\ProductFastDelivery | No errors. |
Slivki\Entity\OfferDeliveryZone | No errors. |
Slivki\Entity\OfferFoodDeliveryZone | No errors. |
Slivki\Entity\AbstractCodePoolBase | No errors. |
Slivki\Entity\OfferCodePool | No errors. |
Slivki\Entity\AbstractOrderBase |
|
Slivki\Entity\OfferOrder |
|
Slivki\Entity\PhoneNumber | No errors. |
Slivki\Entity\GiftCertificate | No errors. |
Slivki\Entity\OfferExtension | No errors. |
Slivki\Entity\Media\AbstractMediaBase | No errors. |
Slivki\Entity\Media\OfferTeaserMedia |
|
Slivki\Entity\Media\OfferMobileTeaserMedia |
|
Slivki\Entity\Media\OfferAppTeaserMedia |
|
Slivki\Entity\Media\OfferTopBlockMedia |
|
Slivki\Entity\Media\OfferTopBlockMobileMedia |
|
Slivki\Entity\Media\OfferMailingTeaserMedia |
|
Slivki\Entity\OnlineOrderSettings | No errors. |
Slivki\Entity\Media\OnlineOrderPopupLogoMedia | No errors. |
Slivki\Entity\Media\GiftCertificatePdfBgMedia |
|
Slivki\Entity\Media\OfferMapLogoMedia | No errors. |
Slivki\Entity\Media\OfferDeliveryZoneMedia | No errors. |
Slivki\Entity\Media\OfferSupplierPhotoMedia |
|
Slivki\Entity\BankCurrency | No errors. |
Slivki\Entity\User |
|
Slivki\Entity\City | No errors. |
Slivki\Entity\AbstractCategoryBase | No errors. |
Slivki\Entity\Category |
|
Slivki\Entity\AbstractGeoLocationBase | No errors. |
Slivki\Entity\GeoLocation |
|
Slivki\Entity\Director |
|
Slivki\Entity\AntiTag | No errors. |
subscription entity manager
No loaded entities.