Query Metrics
65
Database Queries
5
Different statements
35.40 ms
Query time
2
Invalid entities
Grouped Statements
site connection
Time▼ | Count | Info |
---|---|---|
15.58 ms (44.00%) |
21 |
SELECT t0.created_on AS created_on_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.price AS price_5, t0.offer_price AS offer_price_6, t0.code_price AS code_price_7, t0.price_description AS price_description_8, t0.code_prefix AS code_prefix_9, t0.products_per_code AS products_per_code_10, t0.dish_delivery_price AS dish_delivery_price_11, t0.pickup_price AS pickup_price_12, t0.price_delivery_type AS price_delivery_type_13, t0.weight AS weight_14, t0.components_count AS components_count_15, t0.active AS active_16, t0.hidden AS hidden_17, t0.special123 AS special123_18, t0.partner_image_url AS partner_image_url_19, t0.additional_info AS additional_info_20, t0.sauce_need AS sauce_need_21, t0.modified_on AS modified_on_22, t0.badge_label AS badge_label_23, t0.badge_text_color AS badge_text_color_24, t0.badge_bg_color AS badge_bg_color_25, t0.is_delivery AS is_delivery_26, t0.is_pickup AS is_pickup_27, t0.position AS position_28, t0.id AS id_29, t0.price_by_time AS price_by_time_30, t0.partner_item_id AS partner_item_id_31, t0.partner_modifier_id AS partner_modifier_id_32, t0.partner_modifier_group_id AS partner_modifier_group_id_33, t0.offer_id AS offer_id_34, t0.type FROM offer_extension t0 WHERE t0.offer_id = ? AND t0.partner_item_id = ? AND t0.type IN ('1') LIMIT 1
Parameters:
[ 282278 "102" ] |
8.71 ms (24.60%) |
21 |
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.tags AS tags_10, t0.id AS id_11, t0.entity_id AS entity_id_12, t0.type FROM media t0 WHERE t0.id = ? AND t0.type IN ('7')
Parameters:
[
686578
]
|
7.46 ms (21.06%) |
21 |
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:
[
686578
]
|
3.23 ms (9.13%) |
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" "/delivery/online-order/offer/282278/dish-options" 1 ] |
0.43 ms (1.21%) |
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:
[
"/delivery/online-order/offer/282278/dish-options"
]
|
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\OfferExtension | No errors. |
Slivki\Entity\FoodOfferExtension | No errors. |
Slivki\Entity\FoodOfferOptionExtension | No errors. |
Slivki\Entity\Offer |
|
Slivki\Entity\OfferExtensionVariant | No errors. |
Slivki\Entity\OfferExtension\OfferExtensionVisibility | No errors. |
Slivki\Entity\Media\OfferExtensionMedia | No errors. |
Slivki\Entity\AbstractCategoryBase | No errors. |
Slivki\Entity\OfferExtensionCategory | No errors. |
Slivki\Entity\OfferExtensionOnlineCategory | No errors. |
Slivki\Entity\MediaSize | No errors. |
Slivki\Entity\Banner\AbstractBannerBase | No errors. |
Slivki\Entity\Banner\AbstractMobileAppBanner |
|
Slivki\Entity\Banner | No errors. |
Slivki\Entity\ServerFeatureState | No errors. |
admin entity manager
No loaded entities.
subscription entity manager
No loaded entities.