Symfony Profiler

SELECT
  DISTINCT ON (geo_location.id) geo_location.id as geo_location_id,
  offer.id as offer_id,
  offer.without_codes,
  offer.show_map_icon_in_app,
  geo_location.latitude,
  geo_location.longitude,
  geo_location.city,
  geo_location.street,
  geo_location.house,
  default_category.id as category_id,
  default_category.map_pin_color,
  default_category.city_id as city_id,
  media.id as icon_media_id,
  logo_media.id as offer_logo_media_id,
  offer.map_price,
  offer.map_rating,
  director.name as director_name,
  offer.rating,
  purchase_count.purchase_count_last_month_with_correction as month_sale_count,
  json_agg(category2entity.category_id) as offer_categories
FROM
  geo_location_relation
  INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id
  INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id
  INNER JOIN category default_category ON offer.default_category_id = default_category.id
  LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id
  LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id)
  AND (
    logo_media.type = :mapLogoMediaType
  )
  LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id
  LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id
  LEFT JOIN media media ON (
    default_category.id = media.entity_id
  )
  AND (media.type = :mapIconMediaType)
  LEFT JOIN category category ON category.id = category2entity.category_id
  LEFT JOIN director director ON offer2director.director_id = director.id
WHERE
  (
    geo_location.active = :geoLocationActive
  )
  AND (offer.active = :offerActive)
  AND (offer.hidden = :offerHidden)
  AND (
    now() between offer.active_since
    and offer.active_till
  )
  AND (
    category2entity.category_id IN (11583)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19

SELECT DISTINCT ON (geo_location.id) geo_location.id as geo_location_id, offer.id as offer_id, offer.without_codes, offer.show_map_icon_in_app, geo_location.latitude, geo_location.longitude, geo_location.city, geo_location.street, geo_location.house, default_category.id as category_id, default_category.map_pin_color, default_category.city_id as city_id, media.id as icon_media_id, logo_media.id as offer_logo_media_id, offer.map_price, offer.map_rating, director.name as director_name, offer.rating, purchase_count.purchase_count_last_month_with_correction as month_sale_count, json_agg(category2entity.category_id) as offer_categories FROM geo_location_relation INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id INNER JOIN category default_category ON offer.default_category_id = default_category.id LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id) AND (logo_media.type = 24) LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id LEFT JOIN media media ON (default_category.id = media.entity_id) AND (media.type = 18266) LEFT JOIN category category ON category.id = category2entity.category_id LEFT JOIN director director ON offer2director.director_id = director.id WHERE (geo_location.active = 1) AND (offer.active = 1) AND (offer.hidden = 0) AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (11583)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19;

SELECT
  c0_.name AS name_0,
  c0_.h1 AS h1_1,
  c0_.active AS active_2,
  c0_.sort_order AS sort_order_3,
  c0_.api_sort_order AS api_sort_order_4,
  c0_.map_pin_color AS map_pin_color_5,
  c0_.id AS id_6,
  c0_.type_id AS type_id_7,
  c0_.domain_object_id AS domain_object_id_8,
  c0_.past AS past_9,
  c0_.code AS code_10,
  c0_.top_count AS top_count_11,
  c0_.description AS description_12,
  c0_.mobile_api_hash AS mobile_api_hash_13,
  c0_.entity_count AS entity_count_14,
  c0_.last_modified AS last_modified_15,
  c0_.in_menu_bottom AS in_menu_bottom_16,
  c0_.hot_feed_name AS hot_feed_name_17,
  c0_.unpopular AS unpopular_18,
  c0_.featured_in_menu AS featured_in_menu_19,
  c0_.position AS position_20,
  c0_.telegram_bot_show AS telegram_bot_show_21,
  c0_.telegram_bot_name AS telegram_bot_name_22,
  c0_.telegram_bot_position AS telegram_bot_position_23,
  c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24,
  c0_.utm_campaign AS utm_campaign_25,
  c0_.me_on_map_active AS me_on_map_active_26,
  c0_.me_on_map_position AS me_on_map_position_27,
  c0_.me_on_map_featured_active AS me_on_map_featured_active_28,
  c0_.me_on_map_featured_position AS me_on_map_featured_position_29,
  c0_.show_items_catalog AS show_items_catalog_30,
  c0_.active_in_best_offers_category AS active_in_best_offers_category_31,
  c0_.hide_work_examples AS hide_work_examples_32,
  c0_.type AS type_33,
  c0_.city_id AS city_id_34,
  c0_.type_id AS type_id_35
FROM
  category c0_
WHERE
  (
    c0_.city_id = ?
    AND c0_.me_on_map_featured_active = ?
    AND c0_.past = ?
    AND c0_.active = ?
  )
  AND c0_.type IN ('0')
ORDER BY
  c0_.me_on_map_featured_position ASC,
  c0_.id ASC

SELECT c0_.name AS name_0, c0_.h1 AS h1_1, c0_.active AS active_2, c0_.sort_order AS sort_order_3, c0_.api_sort_order AS api_sort_order_4, c0_.map_pin_color AS map_pin_color_5, c0_.id AS id_6, c0_.type_id AS type_id_7, c0_.domain_object_id AS domain_object_id_8, c0_.past AS past_9, c0_.code AS code_10, c0_.top_count AS top_count_11, c0_.description AS description_12, c0_.mobile_api_hash AS mobile_api_hash_13, c0_.entity_count AS entity_count_14, c0_.last_modified AS last_modified_15, c0_.in_menu_bottom AS in_menu_bottom_16, c0_.hot_feed_name AS hot_feed_name_17, c0_.unpopular AS unpopular_18, c0_.featured_in_menu AS featured_in_menu_19, c0_.position AS position_20, c0_.telegram_bot_show AS telegram_bot_show_21, c0_.telegram_bot_name AS telegram_bot_name_22, c0_.telegram_bot_position AS telegram_bot_position_23, c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24, c0_.utm_campaign AS utm_campaign_25, c0_.me_on_map_active AS me_on_map_active_26, c0_.me_on_map_position AS me_on_map_position_27, c0_.me_on_map_featured_active AS me_on_map_featured_active_28, c0_.me_on_map_featured_position AS me_on_map_featured_position_29, c0_.show_items_catalog AS show_items_catalog_30, c0_.active_in_best_offers_category AS active_in_best_offers_category_31, c0_.hide_work_examples AS hide_work_examples_32, c0_.type AS type_33, c0_.city_id AS city_id_34, c0_.type_id AS type_id_35 FROM category c0_ WHERE (c0_.city_id = 113 AND c0_.me_on_map_featured_active = 1 AND c0_.past = 0 AND c0_.active = 1) AND c0_.type IN ('0') ORDER BY c0_.me_on_map_featured_position ASC, c0_.id ASC;

SELECT
  c0_.name AS name_0,
  c0_.h1 AS h1_1,
  c0_.active AS active_2,
  c0_.sort_order AS sort_order_3,
  c0_.api_sort_order AS api_sort_order_4,
  c0_.map_pin_color AS map_pin_color_5,
  c0_.id AS id_6,
  c0_.type_id AS type_id_7,
  c0_.domain_object_id AS domain_object_id_8,
  c0_.past AS past_9,
  c0_.code AS code_10,
  c0_.top_count AS top_count_11,
  c0_.description AS description_12,
  c0_.mobile_api_hash AS mobile_api_hash_13,
  c0_.entity_count AS entity_count_14,
  c0_.last_modified AS last_modified_15,
  c0_.in_menu_bottom AS in_menu_bottom_16,
  c0_.hot_feed_name AS hot_feed_name_17,
  c0_.unpopular AS unpopular_18,
  c0_.featured_in_menu AS featured_in_menu_19,
  c0_.position AS position_20,
  c0_.telegram_bot_show AS telegram_bot_show_21,
  c0_.telegram_bot_name AS telegram_bot_name_22,
  c0_.telegram_bot_position AS telegram_bot_position_23,
  c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24,
  c0_.utm_campaign AS utm_campaign_25,
  c0_.me_on_map_active AS me_on_map_active_26,
  c0_.me_on_map_position AS me_on_map_position_27,
  c0_.me_on_map_featured_active AS me_on_map_featured_active_28,
  c0_.me_on_map_featured_position AS me_on_map_featured_position_29,
  c0_.show_items_catalog AS show_items_catalog_30,
  c0_.active_in_best_offers_category AS active_in_best_offers_category_31,
  c0_.hide_work_examples AS hide_work_examples_32,
  c0_.type AS type_33,
  c0_.city_id AS city_id_34,
  c0_.type_id AS type_id_35
FROM
  category c0_
WHERE
  (
    c0_.city_id = ?
    AND c0_.me_on_map_active = ?
    AND c0_.past = ?
    AND c0_.active = ?
  )
  AND c0_.type IN ('0')
ORDER BY
  c0_.me_on_map_position ASC,
  c0_.id ASC

SELECT c0_.name AS name_0, c0_.h1 AS h1_1, c0_.active AS active_2, c0_.sort_order AS sort_order_3, c0_.api_sort_order AS api_sort_order_4, c0_.map_pin_color AS map_pin_color_5, c0_.id AS id_6, c0_.type_id AS type_id_7, c0_.domain_object_id AS domain_object_id_8, c0_.past AS past_9, c0_.code AS code_10, c0_.top_count AS top_count_11, c0_.description AS description_12, c0_.mobile_api_hash AS mobile_api_hash_13, c0_.entity_count AS entity_count_14, c0_.last_modified AS last_modified_15, c0_.in_menu_bottom AS in_menu_bottom_16, c0_.hot_feed_name AS hot_feed_name_17, c0_.unpopular AS unpopular_18, c0_.featured_in_menu AS featured_in_menu_19, c0_.position AS position_20, c0_.telegram_bot_show AS telegram_bot_show_21, c0_.telegram_bot_name AS telegram_bot_name_22, c0_.telegram_bot_position AS telegram_bot_position_23, c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24, c0_.utm_campaign AS utm_campaign_25, c0_.me_on_map_active AS me_on_map_active_26, c0_.me_on_map_position AS me_on_map_position_27, c0_.me_on_map_featured_active AS me_on_map_featured_active_28, c0_.me_on_map_featured_position AS me_on_map_featured_position_29, c0_.show_items_catalog AS show_items_catalog_30, c0_.active_in_best_offers_category AS active_in_best_offers_category_31, c0_.hide_work_examples AS hide_work_examples_32, c0_.type AS type_33, c0_.city_id AS city_id_34, c0_.type_id AS type_id_35 FROM category c0_ WHERE (c0_.city_id = 113 AND c0_.me_on_map_active = 1 AND c0_.past = 0 AND c0_.active = 1) AND c0_.type IN ('0') ORDER BY c0_.me_on_map_position ASC, c0_.id ASC;

SELECT
  DISTINCT ON (geo_location.id) geo_location.id as geo_location_id,
  offer.id as offer_id,
  offer.without_codes,
  offer.show_map_icon_in_app,
  geo_location.latitude,
  geo_location.longitude,
  geo_location.city,
  geo_location.street,
  geo_location.house,
  default_category.id as category_id,
  default_category.map_pin_color,
  default_category.city_id as city_id,
  media.id as icon_media_id,
  logo_media.id as offer_logo_media_id,
  offer.map_price,
  offer.map_rating,
  director.name as director_name,
  offer.rating,
  purchase_count.purchase_count_last_month_with_correction as month_sale_count,
  json_agg(category2entity.category_id) as offer_categories
FROM
  geo_location_relation
  INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id
  INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id
  INNER JOIN category default_category ON offer.default_category_id = default_category.id
  LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id
  LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id)
  AND (
    logo_media.type = :mapLogoMediaType
  )
  LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id
  LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id
  LEFT JOIN media media ON (
    default_category.id = media.entity_id
  )
  AND (media.type = :mapIconMediaType)
  LEFT JOIN category category ON category.id = category2entity.category_id
  LEFT JOIN director director ON offer2director.director_id = director.id
WHERE
  (
    geo_location.active = :geoLocationActive
  )
  AND (offer.active = :offerActive)
  AND (offer.hidden = :offerHidden)
  AND (
    now() between offer.active_since
    and offer.active_till
  )
  AND (
    category2entity.category_id IN (14890)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19

SELECT DISTINCT ON (geo_location.id) geo_location.id as geo_location_id, offer.id as offer_id, offer.without_codes, offer.show_map_icon_in_app, geo_location.latitude, geo_location.longitude, geo_location.city, geo_location.street, geo_location.house, default_category.id as category_id, default_category.map_pin_color, default_category.city_id as city_id, media.id as icon_media_id, logo_media.id as offer_logo_media_id, offer.map_price, offer.map_rating, director.name as director_name, offer.rating, purchase_count.purchase_count_last_month_with_correction as month_sale_count, json_agg(category2entity.category_id) as offer_categories FROM geo_location_relation INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id INNER JOIN category default_category ON offer.default_category_id = default_category.id LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id) AND (logo_media.type = 24) LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id LEFT JOIN media media ON (default_category.id = media.entity_id) AND (media.type = 18266) LEFT JOIN category category ON category.id = category2entity.category_id LEFT JOIN director director ON offer2director.director_id = director.id WHERE (geo_location.active = 1) AND (offer.active = 1) AND (offer.hidden = 0) AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (14890)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19;

SELECT
  DISTINCT ON (geo_location.id) geo_location.id as geo_location_id,
  offer.id as offer_id,
  offer.without_codes,
  offer.show_map_icon_in_app,
  geo_location.latitude,
  geo_location.longitude,
  geo_location.city,
  geo_location.street,
  geo_location.house,
  default_category.id as category_id,
  default_category.map_pin_color,
  default_category.city_id as city_id,
  media.id as icon_media_id,
  logo_media.id as offer_logo_media_id,
  offer.map_price,
  offer.map_rating,
  director.name as director_name,
  offer.rating,
  purchase_count.purchase_count_last_month_with_correction as month_sale_count,
  json_agg(category2entity.category_id) as offer_categories
FROM
  geo_location_relation
  INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id
  INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id
  INNER JOIN category default_category ON offer.default_category_id = default_category.id
  LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id
  LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id)
  AND (
    logo_media.type = :mapLogoMediaType
  )
  LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id
  LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id
  LEFT JOIN media media ON (
    default_category.id = media.entity_id
  )
  AND (media.type = :mapIconMediaType)
  LEFT JOIN category category ON category.id = category2entity.category_id
  LEFT JOIN director director ON offer2director.director_id = director.id
WHERE
  (
    geo_location.active = :geoLocationActive
  )
  AND (offer.active = :offerActive)
  AND (offer.hidden = :offerHidden)
  AND (
    now() between offer.active_since
    and offer.active_till
  )
  AND (
    category2entity.category_id IN (16450)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19

SELECT DISTINCT ON (geo_location.id) geo_location.id as geo_location_id, offer.id as offer_id, offer.without_codes, offer.show_map_icon_in_app, geo_location.latitude, geo_location.longitude, geo_location.city, geo_location.street, geo_location.house, default_category.id as category_id, default_category.map_pin_color, default_category.city_id as city_id, media.id as icon_media_id, logo_media.id as offer_logo_media_id, offer.map_price, offer.map_rating, director.name as director_name, offer.rating, purchase_count.purchase_count_last_month_with_correction as month_sale_count, json_agg(category2entity.category_id) as offer_categories FROM geo_location_relation INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id INNER JOIN category default_category ON offer.default_category_id = default_category.id LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id) AND (logo_media.type = 24) LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id LEFT JOIN media media ON (default_category.id = media.entity_id) AND (media.type = 18266) LEFT JOIN category category ON category.id = category2entity.category_id LEFT JOIN director director ON offer2director.director_id = director.id WHERE (geo_location.active = 1) AND (offer.active = 1) AND (offer.hidden = 0) AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (16450)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19;

SELECT
  DISTINCT ON (geo_location.id) geo_location.id as geo_location_id,
  offer.id as offer_id,
  offer.without_codes,
  offer.show_map_icon_in_app,
  geo_location.latitude,
  geo_location.longitude,
  geo_location.city,
  geo_location.street,
  geo_location.house,
  default_category.id as category_id,
  default_category.map_pin_color,
  default_category.city_id as city_id,
  media.id as icon_media_id,
  logo_media.id as offer_logo_media_id,
  offer.map_price,
  offer.map_rating,
  director.name as director_name,
  offer.rating,
  purchase_count.purchase_count_last_month_with_correction as month_sale_count,
  json_agg(category2entity.category_id) as offer_categories
FROM
  geo_location_relation
  INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id
  INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id
  INNER JOIN category default_category ON offer.default_category_id = default_category.id
  LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id
  LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id)
  AND (
    logo_media.type = :mapLogoMediaType
  )
  LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id
  LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id
  LEFT JOIN media media ON (
    default_category.id = media.entity_id
  )
  AND (media.type = :mapIconMediaType)
  LEFT JOIN category category ON category.id = category2entity.category_id
  LEFT JOIN director director ON offer2director.director_id = director.id
WHERE
  (
    geo_location.active = :geoLocationActive
  )
  AND (offer.active = :offerActive)
  AND (offer.hidden = :offerHidden)
  AND (
    now() between offer.active_since
    and offer.active_till
  )
  AND (
    category2entity.category_id IN (11650)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19

SELECT DISTINCT ON (geo_location.id) geo_location.id as geo_location_id, offer.id as offer_id, offer.without_codes, offer.show_map_icon_in_app, geo_location.latitude, geo_location.longitude, geo_location.city, geo_location.street, geo_location.house, default_category.id as category_id, default_category.map_pin_color, default_category.city_id as city_id, media.id as icon_media_id, logo_media.id as offer_logo_media_id, offer.map_price, offer.map_rating, director.name as director_name, offer.rating, purchase_count.purchase_count_last_month_with_correction as month_sale_count, json_agg(category2entity.category_id) as offer_categories FROM geo_location_relation INNER JOIN offer offer ON geo_location_relation.entity_id = offer.id INNER JOIN geo_location geo_location ON geo_location_relation.location_id = geo_location.id INNER JOIN category default_category ON offer.default_category_id = default_category.id LEFT JOIN category2entity category2entity ON offer.id = category2entity.entity_id LEFT JOIN media logo_media ON (offer.id = logo_media.entity_id) AND (logo_media.type = 24) LEFT JOIN purchase_count purchase_count ON offer.id = purchase_count.entity_id LEFT JOIN offer2director offer2director ON offer.id = offer2director.offer_id LEFT JOIN media media ON (default_category.id = media.entity_id) AND (media.type = 18266) LEFT JOIN category category ON category.id = category2entity.category_id LEFT JOIN director director ON offer2director.director_id = director.id WHERE (geo_location.active = 1) AND (offer.active = 1) AND (offer.hidden = 0) AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (11650)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19;

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 ('18')
ORDER BY
  t0.id DESC

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 = 11650 AND t0.type IN ('18') ORDER BY t0.id DESC;

SELECT
  count(*)
FROM
  offer
WHERE
  (
    id IN (
      SELECT
        entity_id
      FROM
        category2entity
      WHERE
        category_id = :categoryId
    )
  )
  AND (active = :active)
  AND (hidden = :hidden)
  AND (
    now() between active_since
    and active_till
  )

SELECT count(*) FROM offer WHERE (id IN (SELECT entity_id FROM category2entity WHERE category_id = 11650)) AND (active = 'true') AND (hidden = 'false') AND (now() between active_since and active_till);

SELECT
  c0_.name AS name_0,
  c0_.h1 AS h1_1,
  c0_.active AS active_2,
  c0_.sort_order AS sort_order_3,
  c0_.api_sort_order AS api_sort_order_4,
  c0_.map_pin_color AS map_pin_color_5,
  c0_.id AS id_6,
  c0_.type_id AS type_id_7,
  c0_.domain_object_id AS domain_object_id_8,
  c0_.past AS past_9,
  c0_.code AS code_10,
  c0_.top_count AS top_count_11,
  c0_.description AS description_12,
  c0_.mobile_api_hash AS mobile_api_hash_13,
  c0_.entity_count AS entity_count_14,
  c0_.last_modified AS last_modified_15,
  c0_.in_menu_bottom AS in_menu_bottom_16,
  c0_.hot_feed_name AS hot_feed_name_17,
  c0_.unpopular AS unpopular_18,
  c0_.featured_in_menu AS featured_in_menu_19,
  c0_.position AS position_20,
  c0_.telegram_bot_show AS telegram_bot_show_21,
  c0_.telegram_bot_name AS telegram_bot_name_22,
  c0_.telegram_bot_position AS telegram_bot_position_23,
  c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24,
  c0_.utm_campaign AS utm_campaign_25,
  c0_.me_on_map_active AS me_on_map_active_26,
  c0_.me_on_map_position AS me_on_map_position_27,
  c0_.me_on_map_featured_active AS me_on_map_featured_active_28,
  c0_.me_on_map_featured_position AS me_on_map_featured_position_29,
  c0_.show_items_catalog AS show_items_catalog_30,
  c0_.active_in_best_offers_category AS active_in_best_offers_category_31,
  c0_.hide_work_examples AS hide_work_examples_32,
  c0_.type AS type_33,
  c0_.city_id AS city_id_34,
  c0_.type_id AS type_id_35
FROM
  category c0_
WHERE
  (c0_.id = ?)
  AND c0_.type IN ('0')

SELECT c0_.name AS name_0, c0_.h1 AS h1_1, c0_.active AS active_2, c0_.sort_order AS sort_order_3, c0_.api_sort_order AS api_sort_order_4, c0_.map_pin_color AS map_pin_color_5, c0_.id AS id_6, c0_.type_id AS type_id_7, c0_.domain_object_id AS domain_object_id_8, c0_.past AS past_9, c0_.code AS code_10, c0_.top_count AS top_count_11, c0_.description AS description_12, c0_.mobile_api_hash AS mobile_api_hash_13, c0_.entity_count AS entity_count_14, c0_.last_modified AS last_modified_15, c0_.in_menu_bottom AS in_menu_bottom_16, c0_.hot_feed_name AS hot_feed_name_17, c0_.unpopular AS unpopular_18, c0_.featured_in_menu AS featured_in_menu_19, c0_.position AS position_20, c0_.telegram_bot_show AS telegram_bot_show_21, c0_.telegram_bot_name AS telegram_bot_name_22, c0_.telegram_bot_position AS telegram_bot_position_23, c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24, c0_.utm_campaign AS utm_campaign_25, c0_.me_on_map_active AS me_on_map_active_26, c0_.me_on_map_position AS me_on_map_position_27, c0_.me_on_map_featured_active AS me_on_map_featured_active_28, c0_.me_on_map_featured_position AS me_on_map_featured_position_29, c0_.show_items_catalog AS show_items_catalog_30, c0_.active_in_best_offers_category AS active_in_best_offers_category_31, c0_.hide_work_examples AS hide_work_examples_32, c0_.type AS type_33, c0_.city_id AS city_id_34, c0_.type_id AS type_id_35 FROM category c0_ WHERE (c0_.id = 11650) AND c0_.type IN ('0');

SELECT
  m0_.entity_id AS entity_id_0,
  m0_.type AS type_1,
  m0_.position AS position_2,
  m0_.font_color AS font_color_3,
  m0_.alias AS alias_4,
  m0_.novetly AS novetly_5,
  m0_.menu_id AS menu_id_6,
  m0_.mobile_only AS mobile_only_7,
  m0_.city_id AS city_id_8,
  m0_.fixed_position AS fixed_position_9,
  m0_.fixed_app_position AS fixed_app_position_10,
  m0_.id AS id_11
FROM
  main_menu m0_
  INNER JOIN category c1_ ON (
    c1_.id = m0_.entity_id
    AND m0_.type IN (?)
    AND c1_.active = ?
  )
  AND c1_.type IN ('0')
WHERE
  m0_.city_id = ?
ORDER BY
  m0_.position ASC

SELECT m0_.entity_id AS entity_id_0, m0_.type AS type_1, m0_.position AS position_2, m0_.font_color AS font_color_3, m0_.alias AS alias_4, m0_.novetly AS novetly_5, m0_.menu_id AS menu_id_6, m0_.mobile_only AS mobile_only_7, m0_.city_id AS city_id_8, m0_.fixed_position AS fixed_position_9, m0_.fixed_app_position AS fixed_app_position_10, m0_.id AS id_11 FROM main_menu m0_ INNER JOIN category c1_ ON (c1_.id = m0_.entity_id AND m0_.type IN (1) AND c1_.active = 1) AND c1_.type IN ('0') WHERE m0_.city_id = 113 ORDER BY m0_.position ASC;

SELECT
  ommopp.id,
  ommopp.position,
  ommopp.offer_id,
  o.title,
  o.me_on_map_name
FROM
  on_me_map_offer_position_paid ommopp
  INNER JOIN offer o ON ommopp.offer_id = o.id
WHERE
  ommopp.city_id = :cityId
ORDER BY
  ommopp.position ASC

SELECT ommopp.id, ommopp.position, ommopp.offer_id, o.title, o.me_on_map_name FROM on_me_map_offer_position_paid ommopp INNER JOIN offer o ON ommopp.offer_id = o.id WHERE ommopp.city_id = 113 ORDER BY ommopp.position ASC;

SELECT
  c0_.name AS name_0,
  c0_.h1 AS h1_1,
  c0_.active AS active_2,
  c0_.sort_order AS sort_order_3,
  c0_.api_sort_order AS api_sort_order_4,
  c0_.map_pin_color AS map_pin_color_5,
  c0_.id AS id_6,
  c0_.type_id AS type_id_7,
  c0_.domain_object_id AS domain_object_id_8,
  c0_.past AS past_9,
  c0_.code AS code_10,
  c0_.top_count AS top_count_11,
  c0_.description AS description_12,
  c0_.mobile_api_hash AS mobile_api_hash_13,
  c0_.entity_count AS entity_count_14,
  c0_.last_modified AS last_modified_15,
  c0_.in_menu_bottom AS in_menu_bottom_16,
  c0_.hot_feed_name AS hot_feed_name_17,
  c0_.unpopular AS unpopular_18,
  c0_.featured_in_menu AS featured_in_menu_19,
  c0_.position AS position_20,
  c0_.telegram_bot_show AS telegram_bot_show_21,
  c0_.telegram_bot_name AS telegram_bot_name_22,
  c0_.telegram_bot_position AS telegram_bot_position_23,
  c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24,
  c0_.utm_campaign AS utm_campaign_25,
  c0_.me_on_map_active AS me_on_map_active_26,
  c0_.me_on_map_position AS me_on_map_position_27,
  c0_.me_on_map_featured_active AS me_on_map_featured_active_28,
  c0_.me_on_map_featured_position AS me_on_map_featured_position_29,
  c0_.show_items_catalog AS show_items_catalog_30,
  c0_.active_in_best_offers_category AS active_in_best_offers_category_31,
  c0_.hide_work_examples AS hide_work_examples_32,
  c0_.type AS type_33,
  c0_.city_id AS city_id_34,
  c0_.type_id AS type_id_35
FROM
  category c0_
WHERE
  (
    c0_.id IN (?)
  )
  AND c0_.type IN ('0')

SELECT c0_.name AS name_0, c0_.h1 AS h1_1, c0_.active AS active_2, c0_.sort_order AS sort_order_3, c0_.api_sort_order AS api_sort_order_4, c0_.map_pin_color AS map_pin_color_5, c0_.id AS id_6, c0_.type_id AS type_id_7, c0_.domain_object_id AS domain_object_id_8, c0_.past AS past_9, c0_.code AS code_10, c0_.top_count AS top_count_11, c0_.description AS description_12, c0_.mobile_api_hash AS mobile_api_hash_13, c0_.entity_count AS entity_count_14, c0_.last_modified AS last_modified_15, c0_.in_menu_bottom AS in_menu_bottom_16, c0_.hot_feed_name AS hot_feed_name_17, c0_.unpopular AS unpopular_18, c0_.featured_in_menu AS featured_in_menu_19, c0_.position AS position_20, c0_.telegram_bot_show AS telegram_bot_show_21, c0_.telegram_bot_name AS telegram_bot_name_22, c0_.telegram_bot_position AS telegram_bot_position_23, c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24, c0_.utm_campaign AS utm_campaign_25, c0_.me_on_map_active AS me_on_map_active_26, c0_.me_on_map_position AS me_on_map_position_27, c0_.me_on_map_featured_active AS me_on_map_featured_active_28, c0_.me_on_map_featured_position AS me_on_map_featured_position_29, c0_.show_items_catalog AS show_items_catalog_30, c0_.active_in_best_offers_category AS active_in_best_offers_category_31, c0_.hide_work_examples AS hide_work_examples_32, c0_.type AS type_33, c0_.city_id AS city_id_34, c0_.type_id AS type_id_35 FROM category c0_ WHERE (c0_.id IN (NULL)) AND c0_.type IN ('0');