Symfony Profiler

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 = 10416)) AND (active = 'true') AND (hidden = 'false') AND (now() between active_since and active_till);

SELECT
  ccr.end_of_block
FROM
  category_child_relation ccr
WHERE
  (parent_id = :parentId)
  AND (child_id = :childId)

SELECT ccr.end_of_block FROM category_child_relation ccr WHERE (parent_id = 10416) AND (child_id = 10491);

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,
  t0.type_id AS type_id_9,
  t0.domain_object_id AS domain_object_id_10,
  t0.past AS past_11,
  t0.code AS code_12,
  t0.top_count AS top_count_13,
  t0.description AS description_14,
  t0.mobile_api_hash AS mobile_api_hash_15,
  t0.entity_count AS entity_count_16,
  t0.last_modified AS last_modified_17,
  t0.in_menu_bottom AS in_menu_bottom_18,
  t0.hot_feed_name AS hot_feed_name_19,
  t0.unpopular AS unpopular_20,
  t0.featured_in_menu AS featured_in_menu_21,
  t0.position AS position_22,
  t0.telegram_bot_show AS telegram_bot_show_23,
  t0.telegram_bot_name AS telegram_bot_name_24,
  t0.telegram_bot_position AS telegram_bot_position_25,
  t0.split_offers_with_same_categories AS split_offers_with_same_categories_26,
  t0.utm_campaign AS utm_campaign_27,
  t0.me_on_map_active AS me_on_map_active_28,
  t0.me_on_map_position AS me_on_map_position_29,
  t0.me_on_map_featured_active AS me_on_map_featured_active_30,
  t0.me_on_map_featured_position AS me_on_map_featured_position_31,
  t0.show_items_catalog AS show_items_catalog_32,
  t0.active_in_best_offers_category AS active_in_best_offers_category_33,
  t0.hide_work_examples AS hide_work_examples_34,
  t0.is_bonus_code AS is_bonus_code_35,
  t0.type_id AS type_id_36
FROM
  category t0
  INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id
WHERE
  category_child_relation.parent_id = ?
  AND t0.type IN ('0', '1', '3', '4', '5', '6')
ORDER BY
  t0.sort_order ASC

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, t0.type_id AS type_id_9, t0.domain_object_id AS domain_object_id_10, t0.past AS past_11, t0.code AS code_12, t0.top_count AS top_count_13, t0.description AS description_14, t0.mobile_api_hash AS mobile_api_hash_15, t0.entity_count AS entity_count_16, t0.last_modified AS last_modified_17, t0.in_menu_bottom AS in_menu_bottom_18, t0.hot_feed_name AS hot_feed_name_19, t0.unpopular AS unpopular_20, t0.featured_in_menu AS featured_in_menu_21, t0.position AS position_22, t0.telegram_bot_show AS telegram_bot_show_23, t0.telegram_bot_name AS telegram_bot_name_24, t0.telegram_bot_position AS telegram_bot_position_25, t0.split_offers_with_same_categories AS split_offers_with_same_categories_26, t0.utm_campaign AS utm_campaign_27, t0.me_on_map_active AS me_on_map_active_28, t0.me_on_map_position AS me_on_map_position_29, t0.me_on_map_featured_active AS me_on_map_featured_active_30, t0.me_on_map_featured_position AS me_on_map_featured_position_31, t0.show_items_catalog AS show_items_catalog_32, t0.active_in_best_offers_category AS active_in_best_offers_category_33, t0.hide_work_examples AS hide_work_examples_34, t0.is_bonus_code AS is_bonus_code_35, t0.type_id AS type_id_36 FROM category t0 INNER JOIN category_child_relation ON t0.id = category_child_relation.child_id WHERE category_child_relation.parent_id = 10416 AND t0.type IN ('0', '1', '3', '4', '5', '6') ORDER BY t0.sort_order 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,
  offer.viber as viber,
  offer.telegram as telegram,
  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 (8057)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19,
  20,
  21

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, offer.viber as viber, offer.telegram as telegram, 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 (8057)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;

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,
  offer.viber as viber,
  offer.telegram as telegram,
  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 (10416)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19,
  20,
  21

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, offer.viber as viber, offer.telegram as telegram, 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 (10416)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;

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,
  offer.viber as viber,
  offer.telegram as telegram,
  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 (8082)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19,
  20,
  21

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, offer.viber as viber, offer.telegram as telegram, 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 (8082)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;

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,
  offer.viber as viber,
  offer.telegram as telegram,
  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 (7900)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19,
  20,
  21

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, offer.viber as viber, offer.telegram as telegram, 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 (7900)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;

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,
  offer.viber as viber,
  offer.telegram as telegram,
  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 (7977)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19,
  20,
  21

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, offer.viber as viber, offer.telegram as telegram, 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 (7977)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;

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,
  offer.viber as viber,
  offer.telegram as telegram,
  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 (7814)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19,
  20,
  21

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, offer.viber as viber, offer.telegram as telegram, 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 (7814)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;

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,
  offer.viber as viber,
  offer.telegram as telegram,
  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 (8052)
  )
GROUP BY
  1,
  2,
  3,
  4,
  5,
  6,
  7,
  8,
  9,
  10,
  11,
  12,
  13,
  14,
  15,
  16,
  17,
  18,
  19,
  20,
  21

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, offer.viber as viber, offer.telegram as telegram, 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 (8052)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;