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 = 'mogilev' AND t0.main_alias = '/mobile/api/v2/me-on-map/categories/5' 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/5' 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_.hide_work_examples AS hide_work_examples_32,
  c0_.is_bonus_code AS is_bonus_code_33,
  c0_.type AS type_34,
  c0_.city_id AS city_id_35,
  c0_.type_id AS type_id_36
FROM
  category c0_
WHERE
  (
    c0_.city_id = ?
    AND c0_.me_on_map_active = ?
    AND c0_.past = ?
    AND c0_.active = ?
  )
  AND c0_.type IN ('0')
ORDER BY
  c0_.me_on_map_position ASC,
  c0_.id ASC

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

SELECT c0_.name AS name_0, c0_.h1 AS h1_1, c0_.active AS active_2, c0_.sort_order AS sort_order_3, c0_.api_sort_order AS api_sort_order_4, c0_.map_pin_color AS map_pin_color_5, c0_.id AS id_6, c0_.type_id AS type_id_7, c0_.domain_object_id AS domain_object_id_8, c0_.past AS past_9, c0_.code AS code_10, c0_.top_count AS top_count_11, c0_.description AS description_12, c0_.mobile_api_hash AS mobile_api_hash_13, c0_.entity_count AS entity_count_14, c0_.last_modified AS last_modified_15, c0_.in_menu_bottom AS in_menu_bottom_16, c0_.hot_feed_name AS hot_feed_name_17, c0_.unpopular AS unpopular_18, c0_.featured_in_menu AS featured_in_menu_19, c0_.position AS position_20, c0_.telegram_bot_show AS telegram_bot_show_21, c0_.telegram_bot_name AS telegram_bot_name_22, c0_.telegram_bot_position AS telegram_bot_position_23, c0_.split_offers_with_same_categories AS split_offers_with_same_categories_24, c0_.utm_campaign AS utm_campaign_25, c0_.me_on_map_active AS me_on_map_active_26, c0_.me_on_map_position AS me_on_map_position_27, c0_.me_on_map_featured_active AS me_on_map_featured_active_28, c0_.me_on_map_featured_position AS me_on_map_featured_position_29, c0_.show_items_catalog AS show_items_catalog_30, c0_.active_in_best_offers_category AS active_in_best_offers_category_31, c0_.hide_work_examples AS hide_work_examples_32, c0_.is_bonus_code AS is_bonus_code_33, c0_.type AS type_34, c0_.city_id AS city_id_35, c0_.type_id AS type_id_36 FROM category c0_ WHERE (c0_.city_id = 5 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 = 10416)) 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.tags AS tags_10,
  t0.id AS id_11,
  t0.entity_id AS entity_id_12,
  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.tags AS tags_10, t0.id AS id_11, t0.entity_id AS entity_id_12, t0.type FROM media t0 WHERE t0.entity_id = 10416 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,
  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
  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
  t0.name AS name_1,
  t0.description AS description_2,
  t0.id AS id_3
FROM
  category_type t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.id AS id_3 FROM category_type t0 WHERE t0.id = 1;

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 = 10491)) 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
  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 = 10432)) 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 = 10432);

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 = 10429)) 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 = 10429);

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 = 10426)) 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 = 10426);

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 = 10497)) 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 = 10497);

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 = 10434)) 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 = 10434);

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 = 10494)) 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 = 10494);

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 = 10446)) 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 = 10446);

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 = 14063)) 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.tags AS tags_10,
  t0.id AS id_11,
  t0.entity_id AS entity_id_12,
  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.tags AS tags_10, t0.id AS id_11, t0.entity_id AS entity_id_12, t0.type FROM media t0 WHERE t0.entity_id = 14063 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,
  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 (14063)
  )
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 (14063)) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21;