Symfony Profiler

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 44
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 44 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 50
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 50 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 107
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 107 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 33
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 33 and now() between active_since and active_till;

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 = ?

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 = 706;

SELECT
  DISTINCT category.id,
  category.name
FROM
  category
  INNER JOIN category2entity category2entity ON category.id = category2entity.category_id
  INNER JOIN offer offer ON offer.id = category2entity.entity_id
  INNER JOIN offer_extension offer_extension ON offer.id = offer_extension.offer_id
  INNER JOIN geo_location_relation geo_location_relation ON geo_location_relation.entity_id = offer.id
  INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id
WHERE
  (
    category.active = :categoryActive
  )
  AND (category.past = :categoryPast)
  AND (
    category.domain_object_id = :domainObjectId
  )
  AND (category.type = :categoryType)
  AND (
    category.type_id IN (1, 2)
  )
  AND (
    category.id IN (
      SELECT
        category_child_relation.child_id
      FROM
        category_child_relation
      WHERE
        category_child_relation.parent_id = :parentCategoryId
    )
  )
  AND (
    now() between offer.active_since
    and offer.active_till
  )
  AND (offer.active = :offerActive)
  AND (offer.hidden = :offerHidden)
  AND (
    (offer_extension.active IS NULL)
    OR (
      offer_extension.active = :offerExtensionActive
    )
  )
  AND (
    offer_extension.type = :tireExtensionType
  )
  AND (geo_location.schedule IS NOT NULL)

SELECT DISTINCT category.id, category.name FROM category INNER JOIN category2entity category2entity ON category.id = category2entity.category_id INNER JOIN offer offer ON offer.id = category2entity.entity_id INNER JOIN offer_extension offer_extension ON offer.id = offer_extension.offer_id INNER JOIN geo_location_relation geo_location_relation ON geo_location_relation.entity_id = offer.id INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id WHERE (category.active = 1) AND (category.past = 0) AND (category.domain_object_id = 1) AND (category.type = 0) AND (category.type_id IN (1, 2)) AND (category.id IN (SELECT category_child_relation.child_id FROM category_child_relation WHERE category_child_relation.parent_id  = 6243)) AND (now() between offer.active_since and offer.active_till) AND (offer.active = 1) AND (offer.hidden = 0) AND ((offer_extension.active IS NULL) OR (offer_extension.active = 1)) AND (offer_extension.type = 3) AND (geo_location.schedule IS NOT NULL);

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 19
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 19 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 22
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 22 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 67
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 67 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 111
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 111 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 66
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 66 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 68
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 68 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 47
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 47 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 48
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 48 and now() between active_since and active_till;

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

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 = 'www' AND t0.main_alias = '/populyarnye-aktsii/obuchenie' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 95
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 95 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 115
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 115 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 46
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 46 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 84
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 84 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 24
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 24 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 40
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 40 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 26
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 26 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 131
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 131 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 121
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 121 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 25
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 25 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 35
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 35 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 93
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 93 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 53
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 53 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 141
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 141 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 51
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 51 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 101
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 101 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 114
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 114 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 113
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 113 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 52
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 52 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 18
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 18 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 29
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 29 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 57
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 57 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 9
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 9 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 69
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 69 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 31
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 31 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 13
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 13 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 109
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 109 and now() between active_since and active_till;

select
  count(distinct offer.id)
from
  offer
  inner join category2entity on offer.id = category2entity.entity_id
  inner join category on category2entity.category_id = category.id
where
  offer.active
  and category.city_id = 42
  and now() between active_since
  and active_till

select count(distinct offer.id) from offer inner join category2entity on offer.id = category2entity.entity_id
          inner join category on category2entity.category_id = category.id 
          where offer.active and category.city_id = 42 and now() between active_since and active_till;

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

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 < '2025-05-01 05:13:57' AND b0_.active_till > '2025-04-30 05:13:57' AND b0_.test = 0 AND b0_.active = 1 ORDER BY b0_.id DESC;