Symfony Profiler

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.domain = ?
  AND t0.main_alias = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/mobile/api/v2/me-on-map/categories/1' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.main_alias = ?
ORDER BY
  t0.id DESC

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = '/mobile/api/v2/me-on-map/categories/1' ORDER BY t0.id DESC;

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_.type AS type_32,
  c0_.city_id AS city_id_33,
  c0_.type_id AS type_id_34
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_.type AS type_32, c0_.city_id AS city_id_33, c0_.type_id AS type_id_34 FROM category c0_ WHERE (c0_.city_id = 1 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
  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_.type AS type_32,
  c0_.city_id AS city_id_33,
  c0_.type_id AS type_id_34
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_.type AS type_32, c0_.city_id AS city_id_33, c0_.type_id AS type_id_34 FROM category c0_ WHERE (c0_.city_id = 1 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
  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
  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 = 9 AND t0.type IN ('18') ORDER BY t0.id DESC;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 (14480));

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

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

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

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 (473));

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

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

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