Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.uri AS uri_1,
  p0_.top_html AS top_html_2,
  p0_.bottom_html AS bottom_html_3,
  p0_.meta_title AS meta_title_4,
  p0_.meta_description AS meta_description_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.page_heading AS page_heading_7,
  p0_.city_id AS city_id_8
FROM
  page_seo_texts p0_
WHERE
  p0_.uri = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = '/moskva/salons/' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.uri_identity AS uri_identity_2,
  c0_.country_code AS country_code_3,
  c0_.city_group AS city_group_4,
  c0_.city_price_category AS city_price_category_5,
  c0_.timezone AS timezone_6,
  c0_.map_latitude AS map_latitude_7,
  c0_.map_longitude AS map_longitude_8
FROM
  cities c0_
WHERE
  c0_.uri_identity = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.country_code AS country_code_3, c0_.city_group AS city_group_4, c0_.city_price_category AS city_price_category_5, c0_.timezone AS timezone_6, c0_.map_latitude AS map_latitude_7, c0_.map_longitude AS map_longitude_8 FROM cities c0_ WHERE c0_.uri_identity = 'moskva' LIMIT 1;

SELECT
  DISTINCT s0_.id AS id_0,
  (
    CASE WHEN (s1_.position_group IS NOT NULL) THEN s1_.position_group ELSE 0 END
  ) AS sclr_1,
  (
    CASE WHEN (s1_.position IS NOT NULL) THEN s1_.position ELSE 0 END
  ) AS sclr_2,
  s0_.inactivated_at AS inactivated_at_3,
  (
    CASE WHEN (s0_.user_id IS NOT NULL) THEN 1 ELSE 0 END
  ) AS sclr_4,
  s0_.id AS id_5
FROM
  saloons s0_
  LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id
  AND p2_.entity_type IN ('saloon')
  LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id
  INNER JOIN cities c3_ ON s0_.city_id = c3_.id
  LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id
  LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id
  LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id
  AND s6_.type IN ('thumbnail')
  LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id
WHERE
  (
    p2_.id IS NULL
    AND s0_.city_id = ?
  )
  AND (s0_.deleted_at IS NULL)
ORDER BY
  sclr_1 DESC,
  sclr_2 ASC,
  s0_.inactivated_at DESC,
  sclr_4 DESC,
  s0_.id DESC
LIMIT
  36

SELECT DISTINCT s0_.id AS id_0, (CASE WHEN (s1_.position_group IS NOT NULL) THEN s1_.position_group ELSE 0 END) AS sclr_1, (CASE WHEN (s1_.position IS NOT NULL) THEN s1_.position ELSE 0 END) AS sclr_2, s0_.inactivated_at AS inactivated_at_3, (CASE WHEN (s0_.user_id IS NOT NULL) THEN 1 ELSE 0 END) AS sclr_4, s0_.id AS id_5 FROM saloons s0_ LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id AND p2_.entity_type IN ('saloon') LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id INNER JOIN cities c3_ ON s0_.city_id = c3_.id LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id AND s6_.type IN ('thumbnail') LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id WHERE (p2_.id IS NULL AND s0_.city_id = 1) AND (s0_.deleted_at IS NULL) ORDER BY sclr_1 DESC, sclr_2 ASC, s0_.inactivated_at DESC, sclr_4 DESC, s0_.id DESC LIMIT 36;

SELECT
  (
    CASE WHEN (s0_.position_group IS NOT NULL) THEN s0_.position_group ELSE 0 END
  ) AS sclr_0,
  (
    CASE WHEN (s0_.position IS NOT NULL) THEN s0_.position ELSE 0 END
  ) AS sclr_1,
  (
    CASE WHEN (s1_.user_id IS NOT NULL) THEN 1 ELSE 0 END
  ) AS sclr_2,
  s1_.id AS id_3,
  s1_.uri_identity AS uri_identity_4,
  s1_.name AS name_5,
  s1_.description AS description_6,
  s1_.client_types AS client_types_7,
  s1_.phone_number AS phone_number_8,
  s1_.prices AS prices_9,
  s1_.extra_charge AS extra_charge_10,
  s1_.districts AS districts_11,
  s1_.address AS address_12,
  s1_.created_at AS created_at_13,
  s1_.updated_at AS updated_at_14,
  s1_.inactivated_at AS inactivated_at_15,
  s1_.email AS email_16,
  s1_.seo AS seo_17,
  s1_.delete_mode AS delete_mode_18,
  s1_.deleted_at AS deleted_at_19,
  s1_.messengers_telegram AS messengers_telegram_20,
  s1_.messengers_whatsapp AS messengers_whatsapp_21,
  s1_.messengers_max AS messengers_max_22,
  s1_.messengers_telegram_username AS messengers_telegram_username_23,
  s1_.messengers_max_url AS messengers_max_url_24,
  s1_.call_time_from AS call_time_from_25,
  s1_.call_time_to AS call_time_to_26,
  s1_.call_answering_to AS call_answering_to_27,
  s1_.working_hours_since AS working_hours_since_28,
  s1_.working_hours_till AS working_hours_till_29,
  s1_.apartments_one_hour_price AS apartments_one_hour_price_30,
  s1_.apartments_two_hours_price AS apartments_two_hours_price_31,
  s1_.apartments_night_price AS apartments_night_price_32,
  s1_.take_out_one_hour_price AS take_out_one_hour_price_33,
  s1_.take_out_two_hours_price AS take_out_two_hours_price_34,
  s1_.take_out_night_price AS take_out_night_price_35,
  s1_.take_out_locations AS take_out_locations_36,
  s1_.express_provided AS express_provided_37,
  s1_.express_price AS express_price_38,
  s1_.map_latitude AS map_latitude_39,
  s1_.map_longitude AS map_longitude_40,
  p2_.id AS id_41,
  p2_.placed_at AS placed_at_42,
  p2_.placed_until AS placed_until_43,
  s0_.type AS type_44,
  s0_.position_group AS position_group_45,
  s0_.position AS position_46,
  s0_.placed_at AS placed_at_47,
  s0_.placed_until AS placed_until_48,
  c3_.id AS id_49,
  c3_.name AS name_50,
  c3_.uri_identity AS uri_identity_51,
  c3_.country_code AS country_code_52,
  c3_.city_group AS city_group_53,
  c3_.city_price_category AS city_price_category_54,
  c3_.timezone AS timezone_55,
  c3_.map_latitude AS map_latitude_56,
  c3_.map_longitude AS map_longitude_57,
  c4_.id AS id_58,
  c4_.name AS name_59,
  c4_.uri_identity AS uri_identity_60,
  s5_.id AS id_61,
  s5_.path AS path_62,
  s5_.preview_path AS preview_path_63,
  s6_.type AS type_64,
  s6_.position_group AS position_group_65,
  s6_.position AS position_66,
  s6_.placed_at AS placed_at_67,
  s6_.placed_until AS placed_until_68,
  s1_.user_id AS user_id_69,
  s1_.city_id AS city_id_70,
  s1_.primary_station_id AS primary_station_id_71,
  p2_.entity_type AS entity_type_72,
  p2_.saloon_id AS saloon_id_73,
  s0_.saloon_id AS saloon_id_74,
  s0_.placement_price_id AS placement_price_id_75,
  c4_.city_id AS city_id_76,
  c4_.county_id AS county_id_77,
  c4_.district_id AS district_id_78,
  s5_.type AS type_79,
  s5_.saloon_id AS saloon_id_80,
  s6_.saloon_id AS saloon_id_81,
  s6_.placement_price_id AS placement_price_id_82
FROM
  saloons s1_
  LEFT JOIN placement_hidings p2_ ON s1_.id = p2_.saloon_id
  AND p2_.entity_type IN ('saloon')
  LEFT JOIN saloon_adboard_placements s0_ ON s1_.id = s0_.saloon_id
  INNER JOIN cities c3_ ON s1_.city_id = c3_.id
  LEFT JOIN saloon_stations s7_ ON s1_.id = s7_.saloon_id
  LEFT JOIN city_stations c4_ ON c4_.id = s7_.station_id
  LEFT JOIN saloon_media_files s5_ ON s1_.id = s5_.saloon_id
  AND s5_.type IN ('thumbnail')
  LEFT JOIN saloon_adboard_placements s6_ ON s1_.id = s6_.saloon_id
WHERE
  (
    p2_.id IS NULL
    AND s1_.city_id = ?
    AND s1_.id IN (?)
  )
  AND (s1_.deleted_at IS NULL)
ORDER BY
  sclr_0 DESC,
  sclr_1 ASC,
  s1_.inactivated_at DESC,
  sclr_2 DESC,
  s1_.id DESC

SELECT (CASE WHEN (s0_.position_group IS NOT NULL) THEN s0_.position_group ELSE 0 END) AS sclr_0, (CASE WHEN (s0_.position IS NOT NULL) THEN s0_.position ELSE 0 END) AS sclr_1, (CASE WHEN (s1_.user_id IS NOT NULL) THEN 1 ELSE 0 END) AS sclr_2, s1_.id AS id_3, s1_.uri_identity AS uri_identity_4, s1_.name AS name_5, s1_.description AS description_6, s1_.client_types AS client_types_7, s1_.phone_number AS phone_number_8, s1_.prices AS prices_9, s1_.extra_charge AS extra_charge_10, s1_.districts AS districts_11, s1_.address AS address_12, s1_.created_at AS created_at_13, s1_.updated_at AS updated_at_14, s1_.inactivated_at AS inactivated_at_15, s1_.email AS email_16, s1_.seo AS seo_17, s1_.delete_mode AS delete_mode_18, s1_.deleted_at AS deleted_at_19, s1_.messengers_telegram AS messengers_telegram_20, s1_.messengers_whatsapp AS messengers_whatsapp_21, s1_.messengers_max AS messengers_max_22, s1_.messengers_telegram_username AS messengers_telegram_username_23, s1_.messengers_max_url AS messengers_max_url_24, s1_.call_time_from AS call_time_from_25, s1_.call_time_to AS call_time_to_26, s1_.call_answering_to AS call_answering_to_27, s1_.working_hours_since AS working_hours_since_28, s1_.working_hours_till AS working_hours_till_29, s1_.apartments_one_hour_price AS apartments_one_hour_price_30, s1_.apartments_two_hours_price AS apartments_two_hours_price_31, s1_.apartments_night_price AS apartments_night_price_32, s1_.take_out_one_hour_price AS take_out_one_hour_price_33, s1_.take_out_two_hours_price AS take_out_two_hours_price_34, s1_.take_out_night_price AS take_out_night_price_35, s1_.take_out_locations AS take_out_locations_36, s1_.express_provided AS express_provided_37, s1_.express_price AS express_price_38, s1_.map_latitude AS map_latitude_39, s1_.map_longitude AS map_longitude_40, p2_.id AS id_41, p2_.placed_at AS placed_at_42, p2_.placed_until AS placed_until_43, s0_.type AS type_44, s0_.position_group AS position_group_45, s0_.position AS position_46, s0_.placed_at AS placed_at_47, s0_.placed_until AS placed_until_48, c3_.id AS id_49, c3_.name AS name_50, c3_.uri_identity AS uri_identity_51, c3_.country_code AS country_code_52, c3_.city_group AS city_group_53, c3_.city_price_category AS city_price_category_54, c3_.timezone AS timezone_55, c3_.map_latitude AS map_latitude_56, c3_.map_longitude AS map_longitude_57, c4_.id AS id_58, c4_.name AS name_59, c4_.uri_identity AS uri_identity_60, s5_.id AS id_61, s5_.path AS path_62, s5_.preview_path AS preview_path_63, s6_.type AS type_64, s6_.position_group AS position_group_65, s6_.position AS position_66, s6_.placed_at AS placed_at_67, s6_.placed_until AS placed_until_68, s1_.user_id AS user_id_69, s1_.city_id AS city_id_70, s1_.primary_station_id AS primary_station_id_71, p2_.entity_type AS entity_type_72, p2_.saloon_id AS saloon_id_73, s0_.saloon_id AS saloon_id_74, s0_.placement_price_id AS placement_price_id_75, c4_.city_id AS city_id_76, c4_.county_id AS county_id_77, c4_.district_id AS district_id_78, s5_.type AS type_79, s5_.saloon_id AS saloon_id_80, s6_.saloon_id AS saloon_id_81, s6_.placement_price_id AS placement_price_id_82 FROM saloons s1_ LEFT JOIN placement_hidings p2_ ON s1_.id = p2_.saloon_id AND p2_.entity_type IN ('saloon') LEFT JOIN saloon_adboard_placements s0_ ON s1_.id = s0_.saloon_id INNER JOIN cities c3_ ON s1_.city_id = c3_.id LEFT JOIN saloon_stations s7_ ON s1_.id = s7_.saloon_id LEFT JOIN city_stations c4_ ON c4_.id = s7_.station_id LEFT JOIN saloon_media_files s5_ ON s1_.id = s5_.saloon_id AND s5_.type IN ('thumbnail') LEFT JOIN saloon_adboard_placements s6_ ON s1_.id = s6_.saloon_id WHERE (p2_.id IS NULL AND s1_.city_id = 1 AND s1_.id IN (1)) AND (s1_.deleted_at IS NULL) ORDER BY sclr_0 DESC, sclr_1 ASC, s1_.inactivated_at DESC, sclr_2 DESC, s1_.id DESC;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  saloons s0_
  LEFT JOIN placement_hidings p1_ ON s0_.id = p1_.saloon_id
  AND p1_.entity_type IN ('saloon')
  LEFT JOIN saloon_adboard_placements s2_ ON s0_.id = s2_.saloon_id
  INNER JOIN cities c3_ ON s0_.city_id = c3_.id
  LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id
  LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id
  LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id
  AND s6_.type IN ('thumbnail')
  LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id
WHERE
  (
    p1_.id IS NULL
    AND s0_.city_id = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM saloons s0_ LEFT JOIN placement_hidings p1_ ON s0_.id = p1_.saloon_id AND p1_.entity_type IN ('saloon') LEFT JOIN saloon_adboard_placements s2_ ON s0_.id = s2_.saloon_id INNER JOIN cities c3_ ON s0_.city_id = c3_.id LEFT JOIN saloon_stations s5_ ON s0_.id = s5_.saloon_id LEFT JOIN city_stations c4_ ON c4_.id = s5_.station_id LEFT JOIN saloon_media_files s6_ ON s0_.id = s6_.saloon_id AND s6_.type IN ('thumbnail') LEFT JOIN saloon_adboard_placements s7_ ON s0_.id = s7_.saloon_id WHERE (p1_.id IS NULL AND s0_.city_id = 1) AND (s0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.city_id AS city_id_4,
  t0.county_id AS county_id_5,
  t0.district_id AS district_id_6
FROM
  city_stations t0
WHERE
  t0.city_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5, t0.district_id AS district_id_6 FROM city_stations t0 WHERE t0.city_id = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.city_id AS city_id_4,
  t0.county_id AS county_id_5
FROM
  city_districts t0
WHERE
  t0.city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5 FROM city_districts t0 WHERE t0.city_id = 1;

SELECT
  s0_.id AS id_0,
  s0_.`group` AS group_1,
  s0_.name AS name_2,
  s0_.uri_identity AS uri_identity_3,
  s0_.sort AS sort_4
FROM
  services s0_
ORDER BY
  s0_.`group` ASC,
  s0_.sort ASC,
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.`group` AS group_1, s0_.name AS name_2, s0_.uri_identity AS uri_identity_3, s0_.sort AS sort_4 FROM services s0_ ORDER BY s0_.`group` ASC, s0_.sort ASC, s0_.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.placed_at AS placed_at_1,
  p0_.expires_at AS expires_at_2,
  p1_.id AS id_3,
  p1_.is_dummy AS is_dummy_4,
  p1_.uri_identity AS uri_identity_5,
  p1_.name AS name_6,
  p1_.description AS description_7,
  p1_.client_types AS client_types_8,
  p1_.phone_number AS phone_number_9,
  p1_.is_masseur AS is_masseur_10,
  p1_.extra_charge AS extra_charge_11,
  p1_.prepayment AS prepayment_12,
  p1_.prepayment_amount AS prepayment_amount_13,
  p1_.prepayment_comment AS prepayment_comment_14,
  p1_.is_approved AS is_approved_15,
  p1_.moderation_status AS moderation_status_16,
  p1_.created_at AS created_at_17,
  p1_.updated_at AS updated_at_18,
  p1_.inactivated_at AS inactivated_at_19,
  p1_.seo AS seo_20,
  p1_.delete_mode AS delete_mode_21,
  p1_.deleted_at AS deleted_at_22,
  p1_.person_gender AS person_gender_23,
  p1_.person_age AS person_age_24,
  p1_.person_height AS person_height_25,
  p1_.person_weight AS person_weight_26,
  p1_.person_breast_size AS person_breast_size_27,
  p1_.person_breast_type AS person_breast_type_28,
  p1_.person_cloth_size AS person_cloth_size_29,
  p1_.person_shoes_size AS person_shoes_size_30,
  p1_.person_body_type AS person_body_type_31,
  p1_.person_hair_color AS person_hair_color_32,
  p1_.person_private_haircut AS person_private_haircut_33,
  p1_.person_nationality AS person_nationality_34,
  p1_.person_has_tattoo AS person_has_tattoo_35,
  p1_.person_has_piercing AS person_has_piercing_36,
  p1_.messengers_telegram AS messengers_telegram_37,
  p1_.messengers_whatsapp AS messengers_whatsapp_38,
  p1_.messengers_max AS messengers_max_39,
  p1_.messengers_telegram_username AS messengers_telegram_username_40,
  p1_.messengers_max_url AS messengers_max_url_41,
  p1_.call_time_from AS call_time_from_42,
  p1_.call_time_to AS call_time_to_43,
  p1_.call_answering_to AS call_answering_to_44,
  p1_.client_min_age AS client_min_age_45,
  p1_.client_max_age AS client_max_age_46,
  p1_.apartments_one_hour_price AS apartments_one_hour_price_47,
  p1_.apartments_two_hours_price AS apartments_two_hours_price_48,
  p1_.apartments_night_price AS apartments_night_price_49,
  p1_.take_out_one_hour_price AS take_out_one_hour_price_50,
  p1_.take_out_two_hours_price AS take_out_two_hours_price_51,
  p1_.take_out_night_price AS take_out_night_price_52,
  p1_.take_out_locations AS take_out_locations_53,
  p1_.express_provided AS express_provided_54,
  p1_.express_price AS express_price_55,
  p1_.car_provided AS car_provided_56,
  p1_.map_latitude AS map_latitude_57,
  p1_.map_longitude AS map_longitude_58,
  p0_.city_id AS city_id_59,
  p0_.profile_id AS profile_id_60,
  p0_.placement_price_id AS placement_price_id_61,
  p1_.user_id AS user_id_62,
  p1_.city_id AS city_id_63,
  p1_.primary_station_id AS primary_station_id_64,
  p1_.saloon_id AS saloon_id_65
FROM
  profile_top_placements p0_
  INNER JOIN profiles p1_ ON p0_.profile_id = p1_.id
  AND (p1_.deleted_at IS NULL)
WHERE
  p1_.city_id = ?
  AND (
    p0_.placed_at <= ?
    AND ? < p0_.expires_at
  )
LIMIT
  1

SELECT p0_.id AS id_0, p0_.placed_at AS placed_at_1, p0_.expires_at AS expires_at_2, p1_.id AS id_3, p1_.is_dummy AS is_dummy_4, p1_.uri_identity AS uri_identity_5, p1_.name AS name_6, p1_.description AS description_7, p1_.client_types AS client_types_8, p1_.phone_number AS phone_number_9, p1_.is_masseur AS is_masseur_10, p1_.extra_charge AS extra_charge_11, p1_.prepayment AS prepayment_12, p1_.prepayment_amount AS prepayment_amount_13, p1_.prepayment_comment AS prepayment_comment_14, p1_.is_approved AS is_approved_15, p1_.moderation_status AS moderation_status_16, p1_.created_at AS created_at_17, p1_.updated_at AS updated_at_18, p1_.inactivated_at AS inactivated_at_19, p1_.seo AS seo_20, p1_.delete_mode AS delete_mode_21, p1_.deleted_at AS deleted_at_22, p1_.person_gender AS person_gender_23, p1_.person_age AS person_age_24, p1_.person_height AS person_height_25, p1_.person_weight AS person_weight_26, p1_.person_breast_size AS person_breast_size_27, p1_.person_breast_type AS person_breast_type_28, p1_.person_cloth_size AS person_cloth_size_29, p1_.person_shoes_size AS person_shoes_size_30, p1_.person_body_type AS person_body_type_31, p1_.person_hair_color AS person_hair_color_32, p1_.person_private_haircut AS person_private_haircut_33, p1_.person_nationality AS person_nationality_34, p1_.person_has_tattoo AS person_has_tattoo_35, p1_.person_has_piercing AS person_has_piercing_36, p1_.messengers_telegram AS messengers_telegram_37, p1_.messengers_whatsapp AS messengers_whatsapp_38, p1_.messengers_max AS messengers_max_39, p1_.messengers_telegram_username AS messengers_telegram_username_40, p1_.messengers_max_url AS messengers_max_url_41, p1_.call_time_from AS call_time_from_42, p1_.call_time_to AS call_time_to_43, p1_.call_answering_to AS call_answering_to_44, p1_.client_min_age AS client_min_age_45, p1_.client_max_age AS client_max_age_46, p1_.apartments_one_hour_price AS apartments_one_hour_price_47, p1_.apartments_two_hours_price AS apartments_two_hours_price_48, p1_.apartments_night_price AS apartments_night_price_49, p1_.take_out_one_hour_price AS take_out_one_hour_price_50, p1_.take_out_two_hours_price AS take_out_two_hours_price_51, p1_.take_out_night_price AS take_out_night_price_52, p1_.take_out_locations AS take_out_locations_53, p1_.express_provided AS express_provided_54, p1_.express_price AS express_price_55, p1_.car_provided AS car_provided_56, p1_.map_latitude AS map_latitude_57, p1_.map_longitude AS map_longitude_58, p0_.city_id AS city_id_59, p0_.profile_id AS profile_id_60, p0_.placement_price_id AS placement_price_id_61, p1_.user_id AS user_id_62, p1_.city_id AS city_id_63, p1_.primary_station_id AS primary_station_id_64, p1_.saloon_id AS saloon_id_65 FROM profile_top_placements p0_ INNER JOIN profiles p1_ ON p0_.profile_id = p1_.id AND (p1_.deleted_at IS NULL) WHERE p1_.city_id = 1 AND (p0_.placed_at <= '2026-08-24 14:28:20' AND '2026-08-24 14:28:20' < p0_.expires_at) LIMIT 1;

SELECT
  sp.id
FROM
  sidebar_placements sp
  JOIN `paid_service_prices` pp ON pp.id = sp.placement_price_id
  LEFT JOIN `profiles` p ON p.id = sp.profile_id
WHERE
  sp.type = 100
  AND pp.city_id = 1
  AND sp.id NOT IN (0)
  AND sp.placed_at <= NOW()
  AND NOW() <= sp.placed_until
  AND (
    p.id IS NULL
    OR p.person_gender IN (1, 2, 3)
  )
  AND sp.entity_type = "saloon"
ORDER BY
  sp.is_new DESC,
  sp.shows ASC,
  sp.placed_at DESC
LIMIT
  4

SELECT sp.id 
            FROM sidebar_placements sp
            JOIN `paid_service_prices` pp ON pp.id = sp.placement_price_id
            LEFT JOIN `profiles` p ON p.id = sp.profile_id
            WHERE
                sp.type = 100
                AND pp.city_id = 1
                AND sp.id NOT IN (0)
                AND sp.placed_at <= NOW() AND NOW() <= sp.placed_until
                AND (
                    p.id IS NULL OR p.person_gender IN (1,2,3)
                )
                
                
                AND sp.entity_type = "saloon"
            ORDER BY sp.is_new DESC, sp.shows ASC, sp.placed_at DESC
            LIMIT 4
            ;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.city_id AS city_id_4
FROM
  city_counties t0
WHERE
  t0.city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4 FROM city_counties t0 WHERE t0.city_id = 1;

SELECT
  p0_.city_id AS sclr_0,
  COUNT(p0_.id) AS sclr_1
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.person_gender IN (?)
    AND p0_.moderation_status IN (?, ?, ?)
  )
  AND (p0_.deleted_at IS NULL)
GROUP BY
  p0_.city_id

SELECT p0_.city_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.person_gender IN (1) AND p0_.moderation_status IN (0, 2, 1)) AND (p0_.deleted_at IS NULL) GROUP BY p0_.city_id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.country_code AS country_code_4,
  t0.city_group AS city_group_5,
  t0.city_price_category AS city_price_category_6,
  t0.timezone AS timezone_7,
  t0.map_latitude AS map_latitude_8,
  t0.map_longitude AS map_longitude_9
FROM
  cities t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.country_code AS country_code_4, t0.city_group AS city_group_5, t0.city_price_category AS city_price_category_6, t0.timezone AS timezone_7, t0.map_latitude AS map_latitude_8, t0.map_longitude AS map_longitude_9 FROM cities t0;