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 = '/station-rabochii-poselok/' 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_.timezone AS timezone_5,
  c0_.map_latitude AS map_latitude_6,
  c0_.map_longitude AS map_longitude_7
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_.timezone AS timezone_5, c0_.map_latitude AS map_latitude_6, c0_.map_longitude AS map_longitude_7 FROM cities c0_ WHERE c0_.uri_identity = 'moscow' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.uri_identity AS uri_identity_2,
  c0_.city_id AS city_id_3,
  c0_.county_id AS county_id_4,
  c0_.district_id AS district_id_5
FROM
  city_stations c0_
WHERE
  c0_.city_id = ?
  AND c0_.uri_identity = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.city_id AS city_id_3, c0_.county_id AS county_id_4, c0_.district_id AS district_id_5 FROM city_stations c0_ WHERE c0_.city_id = 1 AND c0_.uri_identity = 'rabochii-poselok' LIMIT 1;

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
  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_.is_approved AS is_approved_12,
  p1_.moderation_status AS moderation_status_13,
  p1_.created_at AS created_at_14,
  p1_.updated_at AS updated_at_15,
  p1_.inactivated_at AS inactivated_at_16,
  p1_.seo AS seo_17,
  p1_.delete_mode AS delete_mode_18,
  p1_.deleted_at AS deleted_at_19,
  p1_.person_gender AS person_gender_20,
  p1_.person_age AS person_age_21,
  p1_.person_height AS person_height_22,
  p1_.person_weight AS person_weight_23,
  p1_.person_breast_size AS person_breast_size_24,
  p1_.person_breast_type AS person_breast_type_25,
  p1_.person_cloth_size AS person_cloth_size_26,
  p1_.person_shoes_size AS person_shoes_size_27,
  p1_.person_body_type AS person_body_type_28,
  p1_.person_hair_color AS person_hair_color_29,
  p1_.person_private_haircut AS person_private_haircut_30,
  p1_.person_nationality AS person_nationality_31,
  p1_.person_has_tattoo AS person_has_tattoo_32,
  p1_.person_has_piercing AS person_has_piercing_33,
  p1_.messengers_telegram AS messengers_telegram_34,
  p1_.messengers_whatsapp AS messengers_whatsapp_35,
  p1_.messengers_telegram_username AS messengers_telegram_username_36,
  p1_.call_time_from AS call_time_from_37,
  p1_.call_time_to AS call_time_to_38,
  p1_.call_answering_to AS call_answering_to_39,
  p1_.client_min_age AS client_min_age_40,
  p1_.client_max_age AS client_max_age_41,
  p1_.apartments_one_hour_price AS apartments_one_hour_price_42,
  p1_.apartments_two_hours_price AS apartments_two_hours_price_43,
  p1_.apartments_night_price AS apartments_night_price_44,
  p1_.take_out_one_hour_price AS take_out_one_hour_price_45,
  p1_.take_out_two_hours_price AS take_out_two_hours_price_46,
  p1_.take_out_night_price AS take_out_night_price_47,
  p1_.take_out_locations AS take_out_locations_48,
  p1_.express_provided AS express_provided_49,
  p1_.express_price AS express_price_50,
  p1_.car_provided AS car_provided_51,
  p1_.map_latitude AS map_latitude_52,
  p1_.map_longitude AS map_longitude_53,
  p0_.city_id AS city_id_54,
  p0_.profile_id AS profile_id_55,
  p0_.placement_price_id AS placement_price_id_56,
  p1_.user_id AS user_id_57,
  p1_.city_id AS city_id_58,
  p1_.primary_station_id AS primary_station_id_59
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_.is_approved AS is_approved_12, p1_.moderation_status AS moderation_status_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.inactivated_at AS inactivated_at_16, p1_.seo AS seo_17, p1_.delete_mode AS delete_mode_18, p1_.deleted_at AS deleted_at_19, p1_.person_gender AS person_gender_20, p1_.person_age AS person_age_21, p1_.person_height AS person_height_22, p1_.person_weight AS person_weight_23, p1_.person_breast_size AS person_breast_size_24, p1_.person_breast_type AS person_breast_type_25, p1_.person_cloth_size AS person_cloth_size_26, p1_.person_shoes_size AS person_shoes_size_27, p1_.person_body_type AS person_body_type_28, p1_.person_hair_color AS person_hair_color_29, p1_.person_private_haircut AS person_private_haircut_30, p1_.person_nationality AS person_nationality_31, p1_.person_has_tattoo AS person_has_tattoo_32, p1_.person_has_piercing AS person_has_piercing_33, p1_.messengers_telegram AS messengers_telegram_34, p1_.messengers_whatsapp AS messengers_whatsapp_35, p1_.messengers_telegram_username AS messengers_telegram_username_36, p1_.call_time_from AS call_time_from_37, p1_.call_time_to AS call_time_to_38, p1_.call_answering_to AS call_answering_to_39, p1_.client_min_age AS client_min_age_40, p1_.client_max_age AS client_max_age_41, p1_.apartments_one_hour_price AS apartments_one_hour_price_42, p1_.apartments_two_hours_price AS apartments_two_hours_price_43, p1_.apartments_night_price AS apartments_night_price_44, p1_.take_out_one_hour_price AS take_out_one_hour_price_45, p1_.take_out_two_hours_price AS take_out_two_hours_price_46, p1_.take_out_night_price AS take_out_night_price_47, p1_.take_out_locations AS take_out_locations_48, p1_.express_provided AS express_provided_49, p1_.express_price AS express_price_50, p1_.car_provided AS car_provided_51, p1_.map_latitude AS map_latitude_52, p1_.map_longitude AS map_longitude_53, p0_.city_id AS city_id_54, p0_.profile_id AS profile_id_55, p0_.placement_price_id AS placement_price_id_56, p1_.user_id AS user_id_57, p1_.city_id AS city_id_58, p1_.primary_station_id AS primary_station_id_59 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-03-25 19:11:52' AND '2026-03-25 19:11:52' < 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_.is_approved AS is_approved_12,
  p1_.moderation_status AS moderation_status_13,
  p1_.created_at AS created_at_14,
  p1_.updated_at AS updated_at_15,
  p1_.inactivated_at AS inactivated_at_16,
  p1_.seo AS seo_17,
  p1_.delete_mode AS delete_mode_18,
  p1_.deleted_at AS deleted_at_19,
  p1_.person_gender AS person_gender_20,
  p1_.person_age AS person_age_21,
  p1_.person_height AS person_height_22,
  p1_.person_weight AS person_weight_23,
  p1_.person_breast_size AS person_breast_size_24,
  p1_.person_breast_type AS person_breast_type_25,
  p1_.person_cloth_size AS person_cloth_size_26,
  p1_.person_shoes_size AS person_shoes_size_27,
  p1_.person_body_type AS person_body_type_28,
  p1_.person_hair_color AS person_hair_color_29,
  p1_.person_private_haircut AS person_private_haircut_30,
  p1_.person_nationality AS person_nationality_31,
  p1_.person_has_tattoo AS person_has_tattoo_32,
  p1_.person_has_piercing AS person_has_piercing_33,
  p1_.messengers_telegram AS messengers_telegram_34,
  p1_.messengers_whatsapp AS messengers_whatsapp_35,
  p1_.messengers_telegram_username AS messengers_telegram_username_36,
  p1_.call_time_from AS call_time_from_37,
  p1_.call_time_to AS call_time_to_38,
  p1_.call_answering_to AS call_answering_to_39,
  p1_.client_min_age AS client_min_age_40,
  p1_.client_max_age AS client_max_age_41,
  p1_.apartments_one_hour_price AS apartments_one_hour_price_42,
  p1_.apartments_two_hours_price AS apartments_two_hours_price_43,
  p1_.apartments_night_price AS apartments_night_price_44,
  p1_.take_out_one_hour_price AS take_out_one_hour_price_45,
  p1_.take_out_two_hours_price AS take_out_two_hours_price_46,
  p1_.take_out_night_price AS take_out_night_price_47,
  p1_.take_out_locations AS take_out_locations_48,
  p1_.express_provided AS express_provided_49,
  p1_.express_price AS express_price_50,
  p1_.car_provided AS car_provided_51,
  p1_.map_latitude AS map_latitude_52,
  p1_.map_longitude AS map_longitude_53,
  p0_.city_id AS city_id_54,
  p0_.profile_id AS profile_id_55,
  p0_.placement_price_id AS placement_price_id_56,
  p1_.user_id AS user_id_57,
  p1_.city_id AS city_id_58,
  p1_.primary_station_id AS primary_station_id_59
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_.is_approved AS is_approved_12, p1_.moderation_status AS moderation_status_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.inactivated_at AS inactivated_at_16, p1_.seo AS seo_17, p1_.delete_mode AS delete_mode_18, p1_.deleted_at AS deleted_at_19, p1_.person_gender AS person_gender_20, p1_.person_age AS person_age_21, p1_.person_height AS person_height_22, p1_.person_weight AS person_weight_23, p1_.person_breast_size AS person_breast_size_24, p1_.person_breast_type AS person_breast_type_25, p1_.person_cloth_size AS person_cloth_size_26, p1_.person_shoes_size AS person_shoes_size_27, p1_.person_body_type AS person_body_type_28, p1_.person_hair_color AS person_hair_color_29, p1_.person_private_haircut AS person_private_haircut_30, p1_.person_nationality AS person_nationality_31, p1_.person_has_tattoo AS person_has_tattoo_32, p1_.person_has_piercing AS person_has_piercing_33, p1_.messengers_telegram AS messengers_telegram_34, p1_.messengers_whatsapp AS messengers_whatsapp_35, p1_.messengers_telegram_username AS messengers_telegram_username_36, p1_.call_time_from AS call_time_from_37, p1_.call_time_to AS call_time_to_38, p1_.call_answering_to AS call_answering_to_39, p1_.client_min_age AS client_min_age_40, p1_.client_max_age AS client_max_age_41, p1_.apartments_one_hour_price AS apartments_one_hour_price_42, p1_.apartments_two_hours_price AS apartments_two_hours_price_43, p1_.apartments_night_price AS apartments_night_price_44, p1_.take_out_one_hour_price AS take_out_one_hour_price_45, p1_.take_out_two_hours_price AS take_out_two_hours_price_46, p1_.take_out_night_price AS take_out_night_price_47, p1_.take_out_locations AS take_out_locations_48, p1_.express_provided AS express_provided_49, p1_.express_price AS express_price_50, p1_.car_provided AS car_provided_51, p1_.map_latitude AS map_latitude_52, p1_.map_longitude AS map_longitude_53, p0_.city_id AS city_id_54, p0_.profile_id AS profile_id_55, p0_.placement_price_id AS placement_price_id_56, p1_.user_id AS user_id_57, p1_.city_id AS city_id_58, p1_.primary_station_id AS primary_station_id_59 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-03-25 19:11:52' AND '2026-03-25 19:11:52' < p0_.expires_at) LIMIT 1;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND (
      p0_.city_id = ?
      AND (
        p0_.city_id = ?
        AND EXISTS (
          SELECT
            1
          FROM
            profile_stations p2_
          WHERE
            p2_.profile_id = p0_.id
            AND p2_.station_id IN (?)
        )
      )
    )
  )
  AND (p0_.deleted_at IS NULL)

SELECT COUNT(p0_.id) AS sclr_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND (p0_.city_id = 1 AND (p0_.city_id = 1 AND EXISTS (SELECT 1 FROM profile_stations p2_ WHERE p2_.profile_id = p0_.id AND p2_.station_id IN (269))))) AND (p0_.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
FROM
  city_districts t0
WHERE
  t0.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.id = 91;

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.district_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, t0.district_id AS district_id_6 FROM city_stations t0 WHERE t0.district_id = 91;

SELECT
  p0_.id AS id_0
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND (
      p0_.city_id = ?
      AND p0_.is_masseur = ?
      AND (
        p0_.city_id = ?
        AND EXISTS (
          SELECT
            1
          FROM
            profile_stations p2_
          WHERE
            p2_.profile_id = p0_.id
            AND p2_.station_id IN (?, ?, ?)
        )
      )
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  RAND() ASC
LIMIT
  72

SELECT p0_.id AS id_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND (p0_.city_id = 1 AND p0_.is_masseur = 0 AND (p0_.city_id = 1 AND EXISTS (SELECT 1 FROM profile_stations p2_ WHERE p2_.profile_id = p0_.id AND p2_.station_id IN (71, 88, 269))))) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 72;

SELECT
  p0_.id AS id_0
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.moderation_status IN (?, ?, ?)
    AND p0_.person_gender IN (?)
    AND (
      p0_.city_id = ?
      AND p0_.is_masseur = ?
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  RAND() ASC
LIMIT
  72

SELECT p0_.id AS id_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.moderation_status IN (0, 2, 1) AND p0_.person_gender IN (1) AND (p0_.city_id = 1 AND p0_.is_masseur = 0)) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 72;

SELECT
  p.*,
  JSON_UNQUOTE(
    JSON_EXTRACT(p.name, '$.ru')
  ) AS `name`,
  JSON_UNQUOTE(
    JSON_EXTRACT(p.description, '$.ru')
  ) AS `description`,
  (
    SELECT
      path
    FROM
      profile_media_files pmf_avatar
    WHERE
      p.id = pmf_avatar.profile_id
      AND pmf_avatar.type = 'avatar'
      AND pmf_avatar.is_main = 0
    LIMIT
      1
  ) AS `avatar_path`,
  (
    SELECT
      TYPE
    FROM
      profile_adboard_placements pap
    WHERE
      p.id = pap.profile_id
    LIMIT
      1
  ) AS `adboard_placement_type`,
  (
    SELECT
      position
    FROM
      profile_adboard_placements pap
    WHERE
      p.id = pap.profile_id
    LIMIT
      1
  ) AS `adboard_placement_position`,
  c.id AS `city_id`,
  JSON_UNQUOTE(
    JSON_EXTRACT(c.name, '$.ru')
  ) AS `city_name`,
  c.uri_identity AS `city_uri_identity`,
  c.country_code AS `city_country_code`,
  EXISTS(
    SELECT
      *
    FROM
      profile_top_placements ptp
    WHERE
      p.id = ptp.profile_id
      AND (
        NOW() BETWEEN ptp.placed_at
        AND ptp.expires_at
      )
  ) AS `has_top_placement`,
  EXISTS(
    SELECT
      *
    FROM
      placement_hidings ph
    WHERE
      p.id = ph.profile_id
      AND ph.entity_type = 'profile'
  ) AS `has_placement_hiding`,
  EXISTS(
    SELECT
      *
    FROM
      profile_comments pc
    WHERE
      p.id = pc.profile_id
      AND pc.deleted_at IS NULL
  ) AS `has_comments`,
  EXISTS(
    SELECT
      *
    FROM
      profile_media_files pmf_video
    WHERE
      p.id = pmf_video.profile_id
      AND pmf_video.type = 'video'
  ) AS `has_videos`,
  EXISTS(
    SELECT
      *
    FROM
      profile_media_files pmf_selfie
    WHERE
      p.id = pmf_selfie.profile_id
      AND pmf_selfie.type = 'selfie'
  ) AS `has_selfies`
FROM
  profiles `p`
  JOIN cities `c` ON c.id = p.city_id
WHERE
  p.id IN (
    14, 10, 19, 3, 21, 6, 4, 13, 9, 5, 18, 16,
    20, 7, 8, 2, 11, 17, 22, 1, 23, 15, 12
  )
ORDER BY
  FIELD(
    p.id, 14, 10, 19, 3, 21, 6, 4, 13, 9, 5, 18,
    16, 20, 7, 8, 2, 11, 17, 22, 1, 23, 15, 12
  )

SELECT 
                p.*, JSON_UNQUOTE(JSON_EXTRACT(p.name, '$.ru')) 
                    AS `name`, 
                JSON_UNQUOTE(JSON_EXTRACT(p.description, '$.ru')) 
                    AS `description`,
                (SELECT path FROM profile_media_files pmf_avatar WHERE p.id = pmf_avatar.profile_id AND pmf_avatar.type = 'avatar' AND pmf_avatar.is_main = 0 LIMIT 1) 
                    AS `avatar_path`,
                (SELECT TYPE FROM profile_adboard_placements pap WHERE p.id = pap.profile_id LIMIT 1) 
                    AS `adboard_placement_type`,
                (SELECT position FROM profile_adboard_placements pap WHERE p.id = pap.profile_id LIMIT 1) 
                    AS `adboard_placement_position`,
                c.id 
                    AS `city_id`, 
                JSON_UNQUOTE(JSON_EXTRACT(c.name, '$.ru')) 
                    AS `city_name`, 
                c.uri_identity 
                    AS `city_uri_identity`,
                c.country_code 
                    AS `city_country_code`,
                EXISTS(SELECT * FROM profile_top_placements ptp WHERE p.id = ptp.profile_id AND (NOW() BETWEEN ptp.placed_at AND ptp.expires_at))
                    AS `has_top_placement`,
                EXISTS(SELECT * FROM placement_hidings ph WHERE p.id = ph.profile_id AND ph.entity_type = 'profile') 
                    AS `has_placement_hiding`,
                EXISTS(SELECT * FROM profile_comments pc WHERE p.id = pc.profile_id AND pc.deleted_at IS NULL) 
                    AS `has_comments`,
                EXISTS(SELECT * FROM profile_media_files pmf_video WHERE p.id = pmf_video.profile_id AND pmf_video.type = 'video') 
                    AS `has_videos`,
                EXISTS(SELECT * FROM profile_media_files pmf_selfie WHERE p.id = pmf_selfie.profile_id AND pmf_selfie.type = 'selfie') 
                    AS `has_selfies`
            FROM profiles `p`
            JOIN cities `c` ON c.id = p.city_id 
            WHERE p.id IN (14,10,19,3,21,6,4,13,9,5,18,16,20,7,8,2,11,17,22,1,23,15,12)
            ORDER BY FIELD(p.id,14,10,19,3,21,6,4,13,9,5,18,16,20,7,8,2,11,17,22,1,23,15,12);

SELECT
  cs.id AS `id`,
  JSON_UNQUOTE(
    JSON_EXTRACT(cs.name, '$.ru')
  ) AS `name`,
  cs.uri_identity AS `uriIdentity`,
  ps.profile_id AS `profile_id`,
  csl.name AS `line_name`,
  csl.color AS `line_color`
FROM
  profile_stations ps
  JOIN city_stations cs ON ps.station_id = cs.id
  LEFT JOIN city_subway_station_lines cssl ON cssl.station_id = cs.id
  LEFT JOIN city_subway_lines csl ON csl.id = cssl.line_id
WHERE
  ps.profile_id IN (
    14, 10, 19, 3, 21, 6, 4, 13, 9, 5, 18, 16,
    20, 7, 8, 2, 11, 17, 22, 1, 23, 15, 12
  )

SELECT 
                    cs.id 
                        AS `id`,
                    JSON_UNQUOTE(JSON_EXTRACT(cs.name, '$.ru')) 
                        AS `name`, 
                    cs.uri_identity 
                        AS `uriIdentity`, 
                    ps.profile_id
                        AS `profile_id`,
                    csl.name
                        AS `line_name`,
                    csl.color
                        AS `line_color`
                FROM profile_stations ps
                JOIN city_stations cs ON ps.station_id = cs.id 
                LEFT JOIN city_subway_station_lines cssl ON cssl.station_id = cs.id
                LEFT JOIN city_subway_lines csl ON csl.id = cssl.line_id
                WHERE ps.profile_id IN (14,10,19,3,21,6,4,13,9,5,18,16,20,7,8,2,11,17,22,1,23,15,12);

SELECT
  s.id AS `id`,
  JSON_UNQUOTE(
    JSON_EXTRACT(s.name, '$.ru')
  ) AS `name`,
  s.group AS `group`,
  s.uri_identity AS `uriIdentity`,
  pps.profile_id AS `profile_id`,
  pps.service_condition AS `condition`,
  pps.extra_charge AS `extra_charge`,
  pps.comment AS `comment`
FROM
  profile_provided_services pps
  JOIN services s ON pps.service_id = s.id
WHERE
  pps.profile_id IN (
    14, 10, 19, 3, 21, 6, 4, 13, 9, 5, 18, 16,
    20, 7, 8, 2, 11, 17, 22, 1, 23, 15, 12
  )
ORDER BY
  s.group ASC,
  s.sort ASC,
  s.id ASC

SELECT 
                    s.id 
                        AS `id`,
                    JSON_UNQUOTE(JSON_EXTRACT(s.name, '$.ru')) 
                        AS `name`, 
                    s.group 
                        AS `group`, 
                    s.uri_identity 
                        AS `uriIdentity`,
                    pps.profile_id
                        AS `profile_id`,
                    pps.service_condition
                        AS `condition`,
                    pps.extra_charge
                        AS `extra_charge`,
                    pps.comment
                        AS `comment`
                FROM profile_provided_services pps
                JOIN services s ON pps.service_id = s.id 
                WHERE pps.profile_id IN (14,10,19,3,21,6,4,13,9,5,18,16,20,7,8,2,11,17,22,1,23,15,12)
                ORDER BY s.group ASC, s.sort ASC, s.id 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_.is_approved AS is_approved_12,
  p1_.moderation_status AS moderation_status_13,
  p1_.created_at AS created_at_14,
  p1_.updated_at AS updated_at_15,
  p1_.inactivated_at AS inactivated_at_16,
  p1_.seo AS seo_17,
  p1_.delete_mode AS delete_mode_18,
  p1_.deleted_at AS deleted_at_19,
  p1_.person_gender AS person_gender_20,
  p1_.person_age AS person_age_21,
  p1_.person_height AS person_height_22,
  p1_.person_weight AS person_weight_23,
  p1_.person_breast_size AS person_breast_size_24,
  p1_.person_breast_type AS person_breast_type_25,
  p1_.person_cloth_size AS person_cloth_size_26,
  p1_.person_shoes_size AS person_shoes_size_27,
  p1_.person_body_type AS person_body_type_28,
  p1_.person_hair_color AS person_hair_color_29,
  p1_.person_private_haircut AS person_private_haircut_30,
  p1_.person_nationality AS person_nationality_31,
  p1_.person_has_tattoo AS person_has_tattoo_32,
  p1_.person_has_piercing AS person_has_piercing_33,
  p1_.messengers_telegram AS messengers_telegram_34,
  p1_.messengers_whatsapp AS messengers_whatsapp_35,
  p1_.messengers_telegram_username AS messengers_telegram_username_36,
  p1_.call_time_from AS call_time_from_37,
  p1_.call_time_to AS call_time_to_38,
  p1_.call_answering_to AS call_answering_to_39,
  p1_.client_min_age AS client_min_age_40,
  p1_.client_max_age AS client_max_age_41,
  p1_.apartments_one_hour_price AS apartments_one_hour_price_42,
  p1_.apartments_two_hours_price AS apartments_two_hours_price_43,
  p1_.apartments_night_price AS apartments_night_price_44,
  p1_.take_out_one_hour_price AS take_out_one_hour_price_45,
  p1_.take_out_two_hours_price AS take_out_two_hours_price_46,
  p1_.take_out_night_price AS take_out_night_price_47,
  p1_.take_out_locations AS take_out_locations_48,
  p1_.express_provided AS express_provided_49,
  p1_.express_price AS express_price_50,
  p1_.car_provided AS car_provided_51,
  p1_.map_latitude AS map_latitude_52,
  p1_.map_longitude AS map_longitude_53,
  p0_.city_id AS city_id_54,
  p0_.profile_id AS profile_id_55,
  p0_.placement_price_id AS placement_price_id_56,
  p1_.user_id AS user_id_57,
  p1_.city_id AS city_id_58,
  p1_.primary_station_id AS primary_station_id_59
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_.is_approved AS is_approved_12, p1_.moderation_status AS moderation_status_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.inactivated_at AS inactivated_at_16, p1_.seo AS seo_17, p1_.delete_mode AS delete_mode_18, p1_.deleted_at AS deleted_at_19, p1_.person_gender AS person_gender_20, p1_.person_age AS person_age_21, p1_.person_height AS person_height_22, p1_.person_weight AS person_weight_23, p1_.person_breast_size AS person_breast_size_24, p1_.person_breast_type AS person_breast_type_25, p1_.person_cloth_size AS person_cloth_size_26, p1_.person_shoes_size AS person_shoes_size_27, p1_.person_body_type AS person_body_type_28, p1_.person_hair_color AS person_hair_color_29, p1_.person_private_haircut AS person_private_haircut_30, p1_.person_nationality AS person_nationality_31, p1_.person_has_tattoo AS person_has_tattoo_32, p1_.person_has_piercing AS person_has_piercing_33, p1_.messengers_telegram AS messengers_telegram_34, p1_.messengers_whatsapp AS messengers_whatsapp_35, p1_.messengers_telegram_username AS messengers_telegram_username_36, p1_.call_time_from AS call_time_from_37, p1_.call_time_to AS call_time_to_38, p1_.call_answering_to AS call_answering_to_39, p1_.client_min_age AS client_min_age_40, p1_.client_max_age AS client_max_age_41, p1_.apartments_one_hour_price AS apartments_one_hour_price_42, p1_.apartments_two_hours_price AS apartments_two_hours_price_43, p1_.apartments_night_price AS apartments_night_price_44, p1_.take_out_one_hour_price AS take_out_one_hour_price_45, p1_.take_out_two_hours_price AS take_out_two_hours_price_46, p1_.take_out_night_price AS take_out_night_price_47, p1_.take_out_locations AS take_out_locations_48, p1_.express_provided AS express_provided_49, p1_.express_price AS express_price_50, p1_.car_provided AS car_provided_51, p1_.map_latitude AS map_latitude_52, p1_.map_longitude AS map_longitude_53, p0_.city_id AS city_id_54, p0_.profile_id AS profile_id_55, p0_.placement_price_id AS placement_price_id_56, p1_.user_id AS user_id_57, p1_.city_id AS city_id_58, p1_.primary_station_id AS primary_station_id_59 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-03-25 19:11:52' AND '2026-03-25 19:11:52' < p0_.expires_at) LIMIT 1;