https://www.lida.test1.dev.slivki.by/delivery/reload/offer/168229/type/1

Query Metrics

105 Database Queries
13 Different statements
155.97 ms Query time
18 Invalid entities

Queries

Group similar statements

site connection

# Time Info
1 3.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.domain = ? AND t0.main_alias = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "www"
  "/delivery/reload/offer/168229/type/1"
  1
]
2 0.50 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:
[
  "/delivery/reload/offer/168229/type/1"
]
3 1.45 ms
SELECT f0_.entity_id AS entity_id_0, f0_.open AS open_1, f0_.recommended AS recommended_2, f0_.popular AS popular_3, f0_.speed AS speed_4, f0_.asc_price AS asc_price_5, f0_.desc_price AS desc_price_6, f0_.price_by_kg AS price_by_kg_7, f0_.popular_day AS popular_day_8, f0_.price_by_kg_desc AS price_by_kg_desc_9, f0_.id AS id_10 FROM food_filter_counter f0_ WHERE f0_.entity_id = ?
Parameters:
[
  168229
]
4 2.64 ms
SELECT o0_.created_on AS created_on_0, o0_.name AS name_1, o0_.short_description AS short_description_2, o0_.description AS description_3, o0_.price AS price_4, o0_.offer_price AS offer_price_5, o0_.code_price AS code_price_6, o0_.price_description AS price_description_7, o0_.code_prefix AS code_prefix_8, o0_.products_per_code AS products_per_code_9, o0_.dish_delivery_price AS dish_delivery_price_10, o0_.pickup_price AS pickup_price_11, o0_.price_delivery_type AS price_delivery_type_12, o0_.weight AS weight_13, o0_.components_count AS components_count_14, o0_.active AS active_15, o0_.hidden AS hidden_16, o0_.special123 AS special123_17, o0_.partner_image_url AS partner_image_url_18, o0_.additional_info AS additional_info_19, o0_.sauce_need AS sauce_need_20, o0_.modified_on AS modified_on_21, o0_.badge_label AS badge_label_22, o0_.badge_text_color AS badge_text_color_23, o0_.badge_bg_color AS badge_bg_color_24, o0_.is_delivery AS is_delivery_25, o0_.is_pickup AS is_pickup_26, o0_.position AS position_27, o0_.id AS id_28, o0_.price_by_time AS price_by_time_29, o0_.partner_item_id AS partner_item_id_30, o0_.partner_modifier_id AS partner_modifier_id_31, o0_.partner_modifier_group_id AS partner_modifier_group_id_32, o0_.type AS type_33, o0_.offer_id AS offer_id_34 FROM offer_extension o0_ WHERE (o0_.offer_id = ? AND o0_.active = ? AND o0_.is_delivery = ?) AND o0_.type IN ('0', '1')
Parameters:
[
  168229
  1
  1
]
5 72.03 ms
SELECT oe.id AS id, SUM(ood.items_count) AS cnt FROM offer_order_details ood INNER JOIN offer_order oo ON oo.id = ood.offer_order_id INNER JOIN offer_extension oe ON oe.id = ood.offer_extension_id WHERE (oo.status > :status) AND (oo.type = :type) AND (oo.offer_id = :offerId) AND (oo.created_on > :period) AND (oe.type = :extensionType) GROUP BY 1 ORDER BY 2 desc
Parameters:
[
  "status" => 0
  "type" => 4
  "offerId" => 168229
  "extensionType" => 0
  "period" => "2025-08-16 22:21:01"
]
6 1.64 ms
SELECT oe.id AS id, SUM(ood.items_count) AS cnt FROM offer_order_details ood INNER JOIN offer_order oo ON oo.id = ood.offer_order_id INNER JOIN offer_extension oe ON oe.id = ood.offer_extension_id WHERE (oo.status > :status) AND (oo.type = :type) AND (oo.offer_id = :offerId) AND (oo.created_on > :period) AND (oe.type = :extensionType) GROUP BY 1 ORDER BY 2 desc
Parameters:
[
  "status" => 0
  "type" => 4
  "offerId" => 168229
  "extensionType" => 0
  "period" => "2025-09-14 22:21:01"
]
7 2.39 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5484
]
8 3.83 ms
SELECT t0.title AS title_1, t0.me_on_map_name AS me_on_map_name_2, t0.explanation_text AS explanation_text_3, t0.price AS price_4, t0.old_price AS old_price_5, t0.regular_price AS regular_price_6, t0.offer_price AS offer_price_7, t0.discount AS discount_8, t0.active_since AS active_since_9, t0.active_till AS active_till_10, t0.code_active_till AS code_active_till_11, t0.active AS active_12, t0.hidden AS hidden_13, t0.free AS free_14, t0.without_codes AS without_codes_15, t0.online_order_allowed AS online_order_allowed_16, t0.buy_code_disable AS buy_code_disable_17, t0.mobile_app_online_order_allowed AS mobile_app_online_order_allowed_18, t0.online_order_allowed_removed_at AS online_order_allowed_removed_at_19, t0.show_price_in_conditions AS show_price_in_conditions_20, t0.show_alt_offers AS show_alt_offers_21, t0.show_currencies AS show_currencies_22, t0.additional_percents AS additional_percents_23, t0.address AS address_24, t0.caption_name AS caption_name_25, t0.caption_color AS caption_color_26, t0.regional_caption_name AS regional_caption_name_27, t0.regional_caption_color AS regional_caption_color_28, t0.search_position AS search_position_29, t0.active_search_position AS active_search_position_30, t0.hint AS hint_31, t0.bank_currency_id AS bank_currency_id_32, t0.active_currency_calculator AS active_currency_calculator_33, t0.last_modified AS last_modified_34, t0.teaser_logo_width AS teaser_logo_width_35, t0.teaser_logo_height AS teaser_logo_height_36, t0.lucene_reindex AS lucene_reindex_37, t0.code_cost AS code_cost_38, t0.code_cost_by_count AS code_cost_by_count_39, t0.default_category_id AS default_category_id_40, t0.company_name AS company_name_41, t0.renewed_on AS renewed_on_42, t0.hide_novelty_label AS hide_novelty_label_43, t0.hide_banners_in_comments AS hide_banners_in_comments_44, t0.sum_for_free_delivery AS sum_for_free_delivery_45, t0.delivery_price AS delivery_price_46, t0.created_on AS created_on_47, t0.allowed_buy_only_code AS allowed_buy_only_code_48, t0.buy_code_button_text AS buy_code_button_text_49, t0.buy_items_button_text AS buy_items_button_text_50, t0.purchase_koeff AS purchase_koeff_51, t0.telegram_bot_show AS telegram_bot_show_52, t0.telegram_bot_position AS telegram_bot_position_53, t0.version AS version_54, t0.hide_in_app AS hide_in_app_55, t0.brandbox_enabled AS brandbox_enabled_56, t0.hide_features AS hide_features_57, t0.discount_delivery_popup AS discount_delivery_popup_58, t0.discount_pickup_popup AS discount_pickup_popup_59, t0.delivery_time_teaser AS delivery_time_teaser_60, t0.external_offer_link AS external_offer_link_61, t0.is_show_external_offer_link AS is_show_external_offer_link_62, t0.is_included_in_beauty AS is_included_in_beauty_63, t0.qr_codes AS qr_codes_64, t0.recurrent_disabled AS recurrent_disabled_65, t0.available_on_food AS available_on_food_66, t0.online_auto_opened AS online_auto_opened_67, t0.foodcourt_logo_enabled AS foodcourt_logo_enabled_68, t0.rating AS rating_69, t0.foodcourt_info_teaser AS foodcourt_info_teaser_70, t0.foodcourt_info_color_teaser AS foodcourt_info_color_teaser_71, t0.online_order_gift_enabled AS online_order_gift_enabled_72, t0.buy_code_in_app_only AS buy_code_in_app_only_73, t0.show_products_in_offer_description AS show_products_in_offer_description_74, t0.check_address_in_offer_menu AS check_address_in_offer_menu_75, t0.show_map_icon_in_app AS show_map_icon_in_app_76, t0.viber AS viber_77, t0.telegram AS telegram_78, t0.partner_online_registration_link AS partner_online_registration_link_79, t0.partner_online_registration_allowed AS partner_online_registration_allowed_80, t0.allowed_payment_methods_for_certificate AS allowed_payment_methods_for_certificate_81, t0.messenger_callback AS messenger_callback_82, t0.allowed_online_order_types AS allowed_online_order_types_83, t0.title_font_color AS title_font_color_84, t0.separate_tab_for_certificates_in_app AS separate_tab_for_certificates_in_app_85, t0.map_price AS map_price_86, t0.map_rating AS map_rating_87, t0.yclient_app_key AS yclient_app_key_88, t0.yclient_company_id AS yclient_company_id_89, t0.fest_offer AS fest_offer_90, t0.review AS review_91, t0.on_review AS on_review_92, t0.id AS id_93, t0.bank_currency_id AS bank_currency_id_94, t0.manager_id AS manager_id_95, t0.creator_id AS creator_id_96, t0.default_city_id AS default_city_id_97 FROM offer t0 WHERE t0.id = ?
Parameters:
[
  168229
]
9 1.77 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.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:
[
  703900
]
10 0.82 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:
[
  703900
]
11 0.72 ms
SELECT p0_.product_id AS product_id_0, p0_.delivery_time AS delivery_time_1, p0_.active AS active_2, p0_.created_on AS created_on_3, p0_.last_modified AS last_modified_4, p0_.id AS id_5, p0_.offer_id AS offer_id_6 FROM product_fast_delivery p0_ WHERE p0_.active = ? AND p0_.offer_id = ?
Parameters:
[
  1
  168229
]
12 0.80 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5485
]
13 0.46 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.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:
[
  703902
]
14 0.44 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:
[
  703902
]
15 0.93 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5486
]
16 0.46 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.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:
[
  703903
]
17 0.41 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:
[
  703903
]
18 0.72 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5487
]
19 0.42 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.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:
[
  703904
]
20 0.41 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:
[
  703904
]
21 0.72 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5488
]
22 0.42 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.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:
[
  703905
]
23 0.31 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:
[
  703905
]
24 0.62 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5489
]
25 0.38 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.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:
[
  703906
]
26 0.33 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:
[
  703906
]
27 0.62 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5490
]
28 0.42 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.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:
[
  725942
]
29 0.42 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:
[
  725942
]
30 0.63 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5491
]
31 0.44 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.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:
[
  725944
]
32 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:
[
  725944
]
33 0.78 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5492
]
34 0.58 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.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:
[
  725965
]
35 0.43 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:
[
  725965
]
36 0.81 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5493
]
37 0.47 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.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:
[
  725946
]
38 0.49 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:
[
  725946
]
39 0.83 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5494
]
40 0.52 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.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:
[
  725947
]
41 0.40 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:
[
  725947
]
42 0.92 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5496
]
43 0.58 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.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:
[
  725949
]
44 0.49 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:
[
  725949
]
45 0.86 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5497
]
46 0.50 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.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:
[
  725950
]
47 0.46 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:
[
  725950
]
48 0.83 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5498
]
49 0.52 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.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:
[
  725951
]
50 0.48 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:
[
  725951
]
51 0.95 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5499
]
52 0.52 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.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:
[
  725952
]
53 0.47 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:
[
  725952
]
54 0.95 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5502
]
55 0.53 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.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:
[
  725954
]
56 0.44 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:
[
  725954
]
57 0.92 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5503
]
58 0.48 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.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:
[
  725955
]
59 0.40 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:
[
  725955
]
60 0.91 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5505
]
61 0.50 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.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:
[
  725957
]
62 0.43 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:
[
  725957
]
63 0.69 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5509
]
64 0.56 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.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:
[
  725961
]
65 0.43 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:
[
  725961
]
66 0.91 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5515
]
67 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.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:
[
  725959
]
68 0.45 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:
[
  725959
]
69 0.91 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5516
]
70 0.53 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.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:
[
  725960
]
71 0.54 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:
[
  725960
]
72 0.96 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5517
]
73 0.75 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.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:
[
  725962
]
74 0.68 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:
[
  725962
]
75 1.28 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5518
]
76 0.80 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.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:
[
  725963
]
77 0.66 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:
[
  725963
]
78 1.54 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  5519
]
79 0.51 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.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:
[
  725964
]
80 0.45 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:
[
  725964
]
81 0.78 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  12383
]
82 0.50 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.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:
[
  1253141
]
83 0.44 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:
[
  1253141
]
84 0.80 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  12384
]
85 0.56 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.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:
[
  1253142
]
86 0.60 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:
[
  1253142
]
87 1.08 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  24122
]
88 0.57 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.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:
[
  1206226
]
89 0.62 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:
[
  1206226
]
90 0.93 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  25770
]
91 0.55 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.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:
[
  1336193
]
92 0.47 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:
[
  1336193
]
93 0.87 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  27172
]
94 0.51 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.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:
[
  1384711
]
95 1.14 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:
[
  1384711
]
96 1.14 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  27173
]
97 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.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:
[
  1384712
]
98 0.49 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:
[
  1384712
]
99 1.14 ms
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type FROM category t0 INNER JOIN category2entity ON t0.id = category2entity.category_id WHERE category2entity.entity_id = ? AND t0.type IN ('6')
Parameters:
[
  27182
]
100 0.70 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.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:
[
  1385125
]
101 0.46 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:
[
  1385125
]
102 2.01 ms
SELECT oev.offer_extension_id, MAX(CASE WHEN oev.day_of_week = :currentDay AND oev.time_from <= :currentTime AND oev.time_to >= :currentTime THEN 1 ELSE 0 END) AS is_visible_now FROM offer_extension_visibility oev WHERE oev.offer_extension_id IN (:extensionIds) GROUP BY oev.offer_extension_id
Parameters:
[
  "extensionIds" => [
    5484
    5485
    5486
    5487
    5488
    5489
    5490
    5491
    5492
    5493
    5494
    5496
    5497
    5498
    5499
    5502
    5503
    5505
    5509
    5515
    5516
    5517
    5518
    5519
    12383
    12384
    24122
    25770
    27172
    27173
    27182
  ]
  "currentDay" => 1
  "currentTime" => "22:21:01"
]
103 1.20 ms
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:
[
  168229
  "ыавкдлуатувка"
]
104 0.50 ms
SELECT oev.offer_extension_id, MAX(CASE WHEN oev.day_of_week = :currentDay AND oev.time_from <= :currentTime AND oev.time_to >= :currentTime THEN 1 ELSE 0 END) AS is_visible_now FROM offer_extension_visibility oev WHERE oev.offer_extension_id IN (:extensionIds) GROUP BY oev.offer_extension_id
Parameters:
[
  "extensionIds" => [
    26979
  ]
  "currentDay" => 1
  "currentTime" => "22:21:01"
]

admin connection

# Time Info
1 3.64 ms
SELECT c2o.id as id, c2o.category_id as category_id, category.name as category_name, c2o.position as position FROM offer_extension_online_category_offer_relation c2o INNER JOIN category category ON c2o.category_id = category.id WHERE c2o.offer_id = :offerId ORDER BY c2o.position ASC, c2o.id ASC
Parameters:
[
  ":offerId" => 168229
]

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\FoodFilterCounter No errors.
Slivki\Entity\OfferExtension No errors.
Slivki\Entity\FoodOfferExtension No errors.
Slivki\Entity\FoodOfferOptionExtension 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\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\Media\CategoryMobileMenuIconMedia No errors.
Slivki\Entity\Media\CategoryAppIconMedia No errors.
Slivki\Entity\Media\CategoryMapPinIconMedia No errors.
Slivki\Entity\BankCurrency 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\EntityDescription No errors.
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\OfferShareClick
  • The association Slivki\Entity\OfferShareClick#user refers to the inverse side field Slivki\Entity\User#email which is not defined as association.
  • The association Slivki\Entity\OfferShareClick#user refers to the inverse side field Slivki\Entity\User#email which does not exist.
  • The association Slivki\Entity\OfferShareClick#offer refers to the inverse side field Slivki\Entity\Offer#title which is not defined as association.
  • The association Slivki\Entity\OfferShareClick#offer refers to the inverse side field Slivki\Entity\Offer#title which does not exist.
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
  • 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\PhoneNumber No errors.
Slivki\Entity\GiftCertificate 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\Media\OfferMobileTeaserMedia
  • The association Slivki\Entity\Media\OfferMobileTeaserMedia#offer refers to the inverse side field Slivki\Entity\Offer#mobileTeaserMedia which does not exist.
Slivki\Entity\Media\OfferAppTeaserMedia
  • The association Slivki\Entity\Media\OfferAppTeaserMedia#offer refers to the inverse side field Slivki\Entity\Offer#appTeaserMedia which does not exist.
Slivki\Entity\Media\OfferTopBlockMedia
  • The association Slivki\Entity\Media\OfferTopBlockMedia#offer refers to the inverse side field Slivki\Entity\Offer#topBlockMedia which does not exist.
Slivki\Entity\Media\OfferTopBlockMobileMedia
  • The association Slivki\Entity\Media\OfferTopBlockMobileMedia#offer refers to the inverse side field Slivki\Entity\Offer#topBlockMobileMedia which does not exist.
Slivki\Entity\Media\OfferMailingTeaserMedia
  • The association Slivki\Entity\Media\OfferMailingTeaserMedia#offer refers to the inverse side field Slivki\Entity\Offer#mailingTeaserMedia which does not exist.
Slivki\Entity\OnlineOrderSettings No errors.
Slivki\Entity\Media\OnlineOrderPopupLogoMedia No errors.
Slivki\Entity\Media\GiftCertificatePdfBgMedia
  • The association Slivki\Entity\Media\GiftCertificatePdfBgMedia#offer refers to the inverse side field Slivki\Entity\Offer#giftCertificatePdfBgMedia which does not exist.
Slivki\Entity\Media\OfferMapLogoMedia No errors.
Slivki\Entity\Media\OfferDeliveryZoneMedia No errors.
Slivki\Entity\Media\OfferSupplierPhotoMedia
  • The association Slivki\Entity\Media\OfferSupplierPhotoMedia#offer refers to the inverse side field Slivki\Entity\Offer#offerSupplierPhotoMedia which does not exist.
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\AbstractGeoLocationBase No errors.
Slivki\Entity\GeoLocation
  • The field Slivki\Entity\GeoLocation#offers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\Offer#geoLocations does not contain the required 'inversedBy="offers"' attribute.
  • The field Slivki\Entity\GeoLocation#giftCertificate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Slivki\Entity\GiftCertificate#geoLocations does not contain the required 'inversedBy="giftCertificate"' attribute.
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\AntiTag No errors.
Slivki\Entity\MediaSize 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.