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

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,
  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
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 (8)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (8));

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,
  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
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 (9)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (9));

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,
  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
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 (7)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (7));

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,
  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
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 (18)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (18));

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,
  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
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 (12)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (12));

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,
  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
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 (10)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (10));

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,
  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
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 (11)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (11));

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,
  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
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 (160)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (160));

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,
  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
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 (23)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (23));

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,
  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
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 (474)
  )

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, 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 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 = 'true') AND (offer.active = 'true') AND (offer.hidden = 'false') AND (now() between offer.active_since and offer.active_till) AND (category2entity.category_id IN (474));