https://www.vlad.dev.slivki.by/otzyvy/stroyka

Query Metrics

33 Database Queries
12 Different statements
84.36 ms Query time
9 Invalid entities

Queries

Group similar statements

site connection

# Time Info
1 3.77 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"
  "/otzyvy/stroyka"
  1
]
2 5.19 ms
SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.id AS id_20, c1_.comment_id AS comment_id_21, c1_.user_id AS user_id_22, c1_.vote AS vote_23, c1_.id AS id_24, m2_.name AS name_25, m2_.path AS path_26, m2_.description AS description_27, m2_.width AS width_28, m2_.height AS height_29, m2_.size AS size_30, m2_.sort_order AS sort_order_31, m2_.checked AS checked_32, m2_.youtube AS youtube_33, m2_.id AS id_34, c3_.external_id AS external_id_35, c3_.created_on AS created_on_36, c3_.city_id AS city_id_37, c3_.email AS email_38, c3_.password AS password_39, c3_.accept_newsletter AS accept_newsletter_40, c3_.transition_id AS transition_id_41, c3_.first_name AS first_name_42, c3_.last_name AS last_name_43, c3_.phone AS phone_44, c3_.status AS status_45, c3_.balance AS balance_46, c3_.registered_from_utm_source AS registered_from_utm_source_47, c3_.token AS token_48, c3_.totally_unsubscribed AS totally_unsubscribed_49, c3_.seen_microphone_tooltip AS seen_microphone_tooltip_50, c3_.not_show_rate_popup_till AS not_show_rate_popup_till_51, c3_.geo_location_accepted AS geo_location_accepted_52, c3_.geo_location AS geo_location_53, c3_.telegram_id AS telegram_id_54, c3_.site_id AS site_id_55, c3_.manager_name AS manager_name_56, c3_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_57, c3_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_58, c3_.batch_codes_count AS batch_codes_count_59, c3_.money_balance AS money_balance_60, c3_.id AS id_61, c0_.parent_id AS parent_id_62, c0_.user_id AS user_id_63, c0_.operator_id AS operator_id_64, c1_.comment_id AS comment_id_65, m2_.type AS type_66, m2_.entity_id AS entity_id_67, c3_.city_id AS city_id_68 FROM comment c0_ LEFT JOIN comment_like c1_ ON c0_.id = c1_.comment_id LEFT JOIN media m2_ ON c0_.id = m2_.entity_id AND m2_.type IN ('18079') INNER JOIN customer c3_ ON c0_.user_id = c3_.id WHERE c0_.entity_id IN (?) AND c0_.type_id = ? AND c0_.hidden <> true AND c0_.id < ? AND c0_.confirmed_phone = true ORDER BY c0_.created_on DESC, m2_.sort_order ASC LIMIT 10
Parameters:
[
  [
    299352
    299352
    299352
  ]
  1
  2147483647
]
3 26.26 ms
select count(*) from comment
            inner join customer on customer.id = comment.user_id
            where entity_id in (select entity_id from category2entity 
              where category_id = 2178) and type_id = 1 
              and (hidden is null or not hidden) and (deleted is null or not deleted) and confirmed_phone
Parameters:
[]
4 1.41 ms
SELECT b0_.banner_id AS banner_id_0, b0_.title AS title_1, b0_.url AS url_2, b0_.right_side_url AS right_side_url_3, b0_.active_since AS active_since_4, b0_.active_till AS active_till_5, b0_.active AS active_6, b0_.test AS test_7, b0_.for_categories AS for_categories_8, b0_.pass_through AS pass_through_9, b0_.small_image AS small_image_10, b0_.middle_image AS middle_image_11, b0_.big_image AS big_image_12, b0_.mobile_image AS mobile_image_13, b0_.mobile_banner AS mobile_banner_14, b0_.mobile_divider AS mobile_divider_15, b0_.id AS id_16 FROM branding_banner b0_ WHERE b0_.active_since < ? AND b0_.active_till > ? AND b0_.test = ? AND b0_.active = ? ORDER BY b0_.id DESC
Parameters:
[
  "2025-06-16 08:21:10"
  "2025-06-15 08:21:10"
  0
  1
]
5 13.70 ms
SELECT t0.name AS name_1, t0.domain AS domain_2, t0.name_genitive AS name_genitive_3, t0.name_locative AS name_locative_4, t0.active AS active_5, t0.position AS position_6, t0.google_analytics AS google_analytics_7, ST_AsEWKT(t0.point::geometry) AS point_8, t0.id AS id_9, t0.parent_id AS parent_id_10 FROM city t0 INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = ?
Parameters:
[
  706
]
6 1.16 ms
SELECT t0.name AS name_1, t0.domain AS domain_2, t0.name_genitive AS name_genitive_3, t0.name_locative AS name_locative_4, t0.active AS active_5, t0.position AS position_6, t0.google_analytics AS google_analytics_7, ST_AsEWKT(t0.point::geometry) AS point_8, t0.id AS id_9, t0.parent_id AS parent_id_10 FROM city t0 INNER JOIN branding_banner_city ON t0.id = branding_banner_city.city_id WHERE branding_banner_city.banner_id = ?
Parameters:
[
  584
]
7 0.78 ms
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[]
8 0.86 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:commentsByCategory"
  3052
  1
]
9 19.31 ms
SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.id AS id_20, m1_.name AS name_21, m1_.path AS path_22, m1_.description AS description_23, m1_.width AS width_24, m1_.height AS height_25, m1_.size AS size_26, m1_.sort_order AS sort_order_27, m1_.checked AS checked_28, m1_.youtube AS youtube_29, m1_.id AS id_30, c0_.parent_id AS parent_id_31, c0_.user_id AS user_id_32, c0_.operator_id AS operator_id_33, m1_.type AS type_34, m1_.entity_id AS entity_id_35 FROM comment c0_ INNER JOIN offer o2_ ON (o2_.id = c0_.entity_id) INNER JOIN category2entity c4_ ON o2_.id = c4_.entity_id INNER JOIN category c3_ ON c3_.id = c4_.category_id AND c3_.type IN ('0') INNER JOIN media m1_ ON c0_.id = m1_.entity_id AND m1_.type IN ('18079') WHERE c0_.type_id = ? AND c0_.hidden = false AND c0_.confirmed_phone = true AND (c0_.deleted = false OR c0_.deleted IS NULL) AND o2_.active = true AND c3_.id = ? ORDER BY c0_.id DESC, m1_.sort_order ASC LIMIT 10
Parameters:
[
  1
  2178
]
10 0.88 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:
[
  1146485
]
11 1.01 ms
SELECT t0.external_id AS external_id_1, t0.created_on AS created_on_2, t0.city_id AS city_id_3, t0.email AS email_4, t0.password AS password_5, t0.accept_newsletter AS accept_newsletter_6, t0.transition_id AS transition_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.status AS status_11, t0.balance AS balance_12, t0.registered_from_utm_source AS registered_from_utm_source_13, t0.token AS token_14, t0.totally_unsubscribed AS totally_unsubscribed_15, t0.seen_microphone_tooltip AS seen_microphone_tooltip_16, t0.not_show_rate_popup_till AS not_show_rate_popup_till_17, t0.geo_location_accepted AS geo_location_accepted_18, t0.geo_location AS geo_location_19, t0.telegram_id AS telegram_id_20, t0.site_id AS site_id_21, t0.manager_name AS manager_name_22, t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23, t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24, t0.batch_codes_count AS batch_codes_count_25, t0.money_balance AS money_balance_26, t0.id AS id_27, t28.created_on AS created_on_29, t28.email AS email_30, t28.status AS status_31, t28.id AS id_32, t28.referral_id AS referral_id_33, t28.user_balance_activity_id AS user_balance_activity_id_34, t28.referer_id AS referer_id_35, t0.city_id AS city_id_36 FROM customer t0 LEFT JOIN referral t28 ON t28.referral_id = t0.id WHERE t0.id = ?
Parameters:
[
  1323750
]
12 0.49 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.entity_id = ? AND t0.type IN ('18083')
Parameters:
[
  1323750
]
13 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:
[
  1146486
]
14 0.30 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:
[
  1146487
]
15 0.34 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:
[
  1083989
]
16 0.72 ms
SELECT t0.external_id AS external_id_1, t0.created_on AS created_on_2, t0.city_id AS city_id_3, t0.email AS email_4, t0.password AS password_5, t0.accept_newsletter AS accept_newsletter_6, t0.transition_id AS transition_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.status AS status_11, t0.balance AS balance_12, t0.registered_from_utm_source AS registered_from_utm_source_13, t0.token AS token_14, t0.totally_unsubscribed AS totally_unsubscribed_15, t0.seen_microphone_tooltip AS seen_microphone_tooltip_16, t0.not_show_rate_popup_till AS not_show_rate_popup_till_17, t0.geo_location_accepted AS geo_location_accepted_18, t0.geo_location AS geo_location_19, t0.telegram_id AS telegram_id_20, t0.site_id AS site_id_21, t0.manager_name AS manager_name_22, t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23, t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24, t0.batch_codes_count AS batch_codes_count_25, t0.money_balance AS money_balance_26, t0.id AS id_27, t28.created_on AS created_on_29, t28.email AS email_30, t28.status AS status_31, t28.id AS id_32, t28.referral_id AS referral_id_33, t28.user_balance_activity_id AS user_balance_activity_id_34, t28.referer_id AS referer_id_35, t0.city_id AS city_id_36 FROM customer t0 LEFT JOIN referral t28 ON t28.referral_id = t0.id WHERE t0.id = ?
Parameters:
[
  2506411
]
17 0.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.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.entity_id = ? AND t0.type IN ('18083')
Parameters:
[
  2506411
]
18 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:
[
  1083990
]
19 0.30 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:
[
  1083991
]
20 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:
[
  1077507
]
21 0.68 ms
SELECT t0.external_id AS external_id_1, t0.created_on AS created_on_2, t0.city_id AS city_id_3, t0.email AS email_4, t0.password AS password_5, t0.accept_newsletter AS accept_newsletter_6, t0.transition_id AS transition_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.status AS status_11, t0.balance AS balance_12, t0.registered_from_utm_source AS registered_from_utm_source_13, t0.token AS token_14, t0.totally_unsubscribed AS totally_unsubscribed_15, t0.seen_microphone_tooltip AS seen_microphone_tooltip_16, t0.not_show_rate_popup_till AS not_show_rate_popup_till_17, t0.geo_location_accepted AS geo_location_accepted_18, t0.geo_location AS geo_location_19, t0.telegram_id AS telegram_id_20, t0.site_id AS site_id_21, t0.manager_name AS manager_name_22, t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23, t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24, t0.batch_codes_count AS batch_codes_count_25, t0.money_balance AS money_balance_26, t0.id AS id_27, t28.created_on AS created_on_29, t28.email AS email_30, t28.status AS status_31, t28.id AS id_32, t28.referral_id AS referral_id_33, t28.user_balance_activity_id AS user_balance_activity_id_34, t28.referer_id AS referer_id_35, t0.city_id AS city_id_36 FROM customer t0 LEFT JOIN referral t28 ON t28.referral_id = t0.id WHERE t0.id = ?
Parameters:
[
  2501904
]
22 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.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.entity_id = ? AND t0.type IN ('18083')
Parameters:
[
  2501904
]
23 0.38 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:
[
  909856
]
24 0.63 ms
SELECT t0.external_id AS external_id_1, t0.created_on AS created_on_2, t0.city_id AS city_id_3, t0.email AS email_4, t0.password AS password_5, t0.accept_newsletter AS accept_newsletter_6, t0.transition_id AS transition_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.status AS status_11, t0.balance AS balance_12, t0.registered_from_utm_source AS registered_from_utm_source_13, t0.token AS token_14, t0.totally_unsubscribed AS totally_unsubscribed_15, t0.seen_microphone_tooltip AS seen_microphone_tooltip_16, t0.not_show_rate_popup_till AS not_show_rate_popup_till_17, t0.geo_location_accepted AS geo_location_accepted_18, t0.geo_location AS geo_location_19, t0.telegram_id AS telegram_id_20, t0.site_id AS site_id_21, t0.manager_name AS manager_name_22, t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23, t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24, t0.batch_codes_count AS batch_codes_count_25, t0.money_balance AS money_balance_26, t0.id AS id_27, t28.created_on AS created_on_29, t28.email AS email_30, t28.status AS status_31, t28.id AS id_32, t28.referral_id AS referral_id_33, t28.user_balance_activity_id AS user_balance_activity_id_34, t28.referer_id AS referer_id_35, t0.city_id AS city_id_36 FROM customer t0 LEFT JOIN referral t28 ON t28.referral_id = t0.id WHERE t0.id = ?
Parameters:
[
  549056
]
25 0.39 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.entity_id = ? AND t0.type IN ('18083')
Parameters:
[
  549056
]
26 0.38 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:
[
  254320
]
27 0.35 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:
[
  741612
]
28 0.71 ms
SELECT t0.external_id AS external_id_1, t0.created_on AS created_on_2, t0.city_id AS city_id_3, t0.email AS email_4, t0.password AS password_5, t0.accept_newsletter AS accept_newsletter_6, t0.transition_id AS transition_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.status AS status_11, t0.balance AS balance_12, t0.registered_from_utm_source AS registered_from_utm_source_13, t0.token AS token_14, t0.totally_unsubscribed AS totally_unsubscribed_15, t0.seen_microphone_tooltip AS seen_microphone_tooltip_16, t0.not_show_rate_popup_till AS not_show_rate_popup_till_17, t0.geo_location_accepted AS geo_location_accepted_18, t0.geo_location AS geo_location_19, t0.telegram_id AS telegram_id_20, t0.site_id AS site_id_21, t0.manager_name AS manager_name_22, t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23, t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24, t0.batch_codes_count AS batch_codes_count_25, t0.money_balance AS money_balance_26, t0.id AS id_27, t28.created_on AS created_on_29, t28.email AS email_30, t28.status AS status_31, t28.id AS id_32, t28.referral_id AS referral_id_33, t28.user_balance_activity_id AS user_balance_activity_id_34, t28.referer_id AS referer_id_35, t0.city_id AS city_id_36 FROM customer t0 LEFT JOIN referral t28 ON t28.referral_id = t0.id WHERE t0.id = ?
Parameters:
[
  1940439
]
29 0.37 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.entity_id = ? AND t0.type IN ('18083')
Parameters:
[
  1940439
]
30 0.34 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:
[
  714085
]
31 0.61 ms
SELECT t0.external_id AS external_id_1, t0.created_on AS created_on_2, t0.city_id AS city_id_3, t0.email AS email_4, t0.password AS password_5, t0.accept_newsletter AS accept_newsletter_6, t0.transition_id AS transition_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.status AS status_11, t0.balance AS balance_12, t0.registered_from_utm_source AS registered_from_utm_source_13, t0.token AS token_14, t0.totally_unsubscribed AS totally_unsubscribed_15, t0.seen_microphone_tooltip AS seen_microphone_tooltip_16, t0.not_show_rate_popup_till AS not_show_rate_popup_till_17, t0.geo_location_accepted AS geo_location_accepted_18, t0.geo_location AS geo_location_19, t0.telegram_id AS telegram_id_20, t0.site_id AS site_id_21, t0.manager_name AS manager_name_22, t0.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_23, t0.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_24, t0.batch_codes_count AS batch_codes_count_25, t0.money_balance AS money_balance_26, t0.id AS id_27, t28.created_on AS created_on_29, t28.email AS email_30, t28.status AS status_31, t28.id AS id_32, t28.referral_id AS referral_id_33, t28.user_balance_activity_id AS user_balance_activity_id_34, t28.referer_id AS referer_id_35, t0.city_id AS city_id_36 FROM customer t0 LEFT JOIN referral t28 ON t28.referral_id = t0.id WHERE t0.id = ?
Parameters:
[
  1262008
]
32 0.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.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.entity_id = ? AND t0.type IN ('18083')
Parameters:
[
  1262008
]
33 0.77 ms
SELECT n0_.active AS active_0, n0_.test AS test_1, n0_.type AS type_2, n0_.cookie_name AS cookie_name_3, n0_.active_till AS active_till_4, n0_.start_after AS start_after_5, n0_.picture_text AS picture_text_6, n0_.picture_text_bg_color AS picture_text_bg_color_7, n0_.left_text AS left_text_8, n0_.right_text AS right_text_9, n0_.mobile_text AS mobile_text_10, n0_.right_bg_color AS right_bg_color_11, n0_.button_text AS button_text_12, n0_.button_link AS button_link_13, n0_.button_bg_color AS button_bg_color_14, n0_.button_text_color AS button_text_color_15, n0_.dark_close_btn AS dark_close_btn_16, n0_.active_from AS active_from_17, n0_.id AS id_18 FROM notice_popup n0_ WHERE n0_.active = true AND n0_.type = ? AND CURRENT_TIMESTAMP BETWEEN n0_.active_from AND n0_.active_till
Parameters:
[
  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\Comment 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\CommentLike No errors.
Slivki\Entity\Media\AbstractMediaBase No errors.
Slivki\Entity\Media\CommentMedia 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\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\BrandingBanner No errors.
Slivki\Entity\CityArea No errors.
Slivki\Entity\TopSale No errors.
Slivki\Entity\Mall 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\MediaSize No errors.
Slivki\Entity\Referral No errors.
Slivki\Entity\UserBalanceActivity No errors.
Slivki\Entity\SocialAccount 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\OfferOrderDetails No errors.
Slivki\Entity\UserPhone No errors.
Slivki\Entity\UserActivity No errors.
Slivki\Entity\Visit No errors.
Slivki\Entity\UserProperty No errors.
Slivki\Entity\FavouriteCategory No errors.
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\Media\ProfileImageMedia No errors.
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\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\SaleProductBasket No errors.
Slivki\Entity\AuthToken No errors.
Slivki\Entity\UserAddress No errors.
Slivki\Entity\SubscriptionPlanUserRelation No errors.
Slivki\Entity\UserGroup No errors.
Slivki\Entity\MailingCampaignType No errors.
Slivki\Entity\CreditCard No errors.
Slivki\Entity\NoticePopup No errors.

admin entity manager

No loaded entities.

subscription entity manager

No loaded entities.