Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nick_name AS nick_name_3,
  t0.notes AS notes_4,
  t0.country_code AS country_code_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.confirmation_code AS confirmation_code_8,
  t0.smsc_code AS smsc_code_9,
  t0.enabled AS enabled_10,
  t0.trusted AS trusted_11,
  t0.credits AS credits_12,
  t0.currency_code AS currency_code_13,
  t0.full_registered AS full_registered_14,
  t0.post_registration_step AS post_registration_step_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.balance_low_notified_at AS balance_low_notified_at_18,
  t0.ban AS ban_19,
  t0.city_id AS city_id_20,
  t22.id AS id_21,
  t22.path AS path_23,
  t22.user_id AS user_id_24,
  t25.account_id AS account_id_26,
  t0.type
FROM
  user t0
  LEFT JOIN user_media_files t22 ON t22.user_id = t0.id
  LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN ('advertiser', 'customer')

SELECT t0.id AS id_1, t0.email AS email_2, t0.nick_name AS nick_name_3, t0.notes AS notes_4, t0.country_code AS country_code_5, t0.roles AS roles_6, t0.password AS password_7, t0.confirmation_code AS confirmation_code_8, t0.smsc_code AS smsc_code_9, t0.enabled AS enabled_10, t0.trusted AS trusted_11, t0.credits AS credits_12, t0.currency_code AS currency_code_13, t0.full_registered AS full_registered_14, t0.post_registration_step AS post_registration_step_15, t0.created AS created_16, t0.updated AS updated_17, t0.balance_low_notified_at AS balance_low_notified_at_18, t0.ban AS ban_19, t0.city_id AS city_id_20, t22.id AS id_21, t22.path AS path_23, t22.user_id AS user_id_24, t25.account_id AS account_id_26, t0.type FROM user t0 LEFT JOIN user_media_files t22 ON t22.user_id = t0.id LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id WHERE t0.id = 1 AND t0.type IN ('advertiser', 'customer');

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 = '/account/girls/add' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.`group` AS group_2,
  t0.name AS name_3,
  t0.uri_identity AS uri_identity_4,
  t0.sort AS sort_5
FROM
  services t0

SELECT t0.id AS id_1, t0.`group` AS group_2, t0.name AS name_3, t0.uri_identity AS uri_identity_4, t0.sort AS sort_5 FROM services 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.timezone AS timezone_6,
  t0.map_latitude AS map_latitude_7,
  t0.map_longitude AS map_longitude_8
FROM
  cities t0
WHERE
  t0.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.timezone AS timezone_6, t0.map_latitude AS map_latitude_7, t0.map_longitude AS map_longitude_8 FROM cities t0 WHERE t0.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
  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_.country_code = ?

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_.country_code = 'RU';

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_
ORDER BY
  JSON_UNQUOTE(
    JSON_EXTRACT(c0_.name, ?)
  ) ASC

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_ ORDER BY JSON_UNQUOTE(JSON_EXTRACT(c0_.name, '$.ru')) ASC;

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
  p.id,
  p.is_approved,
  psp.price_amount
FROM
  profiles `p`
  JOIN profile_adboard_placements pap ON pap.profile_id = p.id
  AND pap.placement_price_id IS NOT NULL
  JOIN paid_service_prices psp ON pap.placement_price_id = psp.id
WHERE
  p.user_id = 1

SELECT 
                p.id, p.is_approved, psp.price_amount
            FROM profiles `p`
            JOIN profile_adboard_placements pap ON pap.profile_id = p.id AND pap.placement_price_id IS NOT NULL
            JOIN paid_service_prices psp ON pap.placement_price_id = psp.id
            WHERE p.user_id = 1
        ;

SELECT
  p0_.id AS id_0,
  p0_.price_amount AS price_amount_1,
  p0_.currency AS currency_2,
  p0_.duration AS duration_3,
  p0_.enabled AS enabled_4,
  p0_.placement_type AS placement_type_5,
  p0_.city_id AS city_id_6
FROM
  paid_service_prices p0_
WHERE
  (
    p0_.enabled = 1
    AND p0_.placement_type IN (?)
    AND p0_.currency = ?
  )
  AND p0_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
LIMIT
  1

SELECT p0_.id AS id_0, p0_.price_amount AS price_amount_1, p0_.currency AS currency_2, p0_.duration AS duration_3, p0_.enabled AS enabled_4, p0_.placement_type AS placement_type_5, p0_.city_id AS city_id_6 FROM paid_service_prices p0_ WHERE (p0_.enabled = 1 AND p0_.placement_type IN ('placement_hiding') AND p0_.currency = 'RUB') AND p0_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') LIMIT 1;

SELECT
  p.id,
  p.is_approved
FROM
  profiles `p`
  JOIN placement_hidings ph ON ph.profile_id = p.id
WHERE
  p.user_id = 1

SELECT 
                p.id, p.is_approved
            FROM profiles `p`
            JOIN placement_hidings ph ON ph.profile_id = p.id
            WHERE p.user_id = 1
        ;

SELECT
  s0_.id AS id_0,
  s0_.uri_identity AS uri_identity_1,
  s0_.name AS name_2,
  s0_.description AS description_3,
  s0_.client_types AS client_types_4,
  s0_.phone_number AS phone_number_5,
  s0_.prices AS prices_6,
  s0_.extra_charge AS extra_charge_7,
  s0_.districts AS districts_8,
  s0_.address AS address_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.inactivated_at AS inactivated_at_12,
  s0_.email AS email_13,
  s0_.seo AS seo_14,
  s0_.delete_mode AS delete_mode_15,
  s0_.deleted_at AS deleted_at_16,
  s0_.messengers_telegram AS messengers_telegram_17,
  s0_.messengers_whatsapp AS messengers_whatsapp_18,
  s0_.messengers_telegram_username AS messengers_telegram_username_19,
  s0_.call_time_from AS call_time_from_20,
  s0_.call_time_to AS call_time_to_21,
  s0_.call_answering_to AS call_answering_to_22,
  s0_.working_hours_since AS working_hours_since_23,
  s0_.working_hours_till AS working_hours_till_24,
  s0_.apartments_one_hour_price AS apartments_one_hour_price_25,
  s0_.apartments_two_hours_price AS apartments_two_hours_price_26,
  s0_.apartments_night_price AS apartments_night_price_27,
  s0_.take_out_one_hour_price AS take_out_one_hour_price_28,
  s0_.take_out_two_hours_price AS take_out_two_hours_price_29,
  s0_.take_out_night_price AS take_out_night_price_30,
  s0_.take_out_locations AS take_out_locations_31,
  s0_.express_provided AS express_provided_32,
  s0_.express_price AS express_price_33,
  s0_.map_latitude AS map_latitude_34,
  s0_.map_longitude AS map_longitude_35,
  s0_.user_id AS user_id_36,
  s0_.city_id AS city_id_37,
  s0_.primary_station_id AS primary_station_id_38
FROM
  saloons s0_
  LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id
  LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id
  AND p2_.entity_type IN ('saloon')
WHERE
  (
    (
      s1_.saloon_id IS NOT NULL
      OR p2_.id IS NOT NULL
    )
    AND s0_.user_id = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.uri_identity AS uri_identity_1, s0_.name AS name_2, s0_.description AS description_3, s0_.client_types AS client_types_4, s0_.phone_number AS phone_number_5, s0_.prices AS prices_6, s0_.extra_charge AS extra_charge_7, s0_.districts AS districts_8, s0_.address AS address_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.inactivated_at AS inactivated_at_12, s0_.email AS email_13, s0_.seo AS seo_14, s0_.delete_mode AS delete_mode_15, s0_.deleted_at AS deleted_at_16, s0_.messengers_telegram AS messengers_telegram_17, s0_.messengers_whatsapp AS messengers_whatsapp_18, s0_.messengers_telegram_username AS messengers_telegram_username_19, s0_.call_time_from AS call_time_from_20, s0_.call_time_to AS call_time_to_21, s0_.call_answering_to AS call_answering_to_22, s0_.working_hours_since AS working_hours_since_23, s0_.working_hours_till AS working_hours_till_24, s0_.apartments_one_hour_price AS apartments_one_hour_price_25, s0_.apartments_two_hours_price AS apartments_two_hours_price_26, s0_.apartments_night_price AS apartments_night_price_27, s0_.take_out_one_hour_price AS take_out_one_hour_price_28, s0_.take_out_two_hours_price AS take_out_two_hours_price_29, s0_.take_out_night_price AS take_out_night_price_30, s0_.take_out_locations AS take_out_locations_31, s0_.express_provided AS express_provided_32, s0_.express_price AS express_price_33, s0_.map_latitude AS map_latitude_34, s0_.map_longitude AS map_longitude_35, s0_.user_id AS user_id_36, s0_.city_id AS city_id_37, s0_.primary_station_id AS primary_station_id_38 FROM saloons s0_ LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id AND p2_.entity_type IN ('saloon') WHERE ((s1_.saloon_id IS NOT NULL OR p2_.id IS NOT NULL) AND s0_.user_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.value AS value_3
FROM
  system_variables t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM system_variables t0 WHERE t0.name = 'offer_bar_string' 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_.user_id = ?
    AND p0_.moderation_status 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_.user_id = 1 AND p0_.moderation_status IN (0, 2, 1)) AND (p0_.deleted_at IS NULL);

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  profiles p0_
WHERE
  (
    p0_.user_id = ?
    AND p0_.deleted_at IS NULL
  )
  AND (p0_.deleted_at IS NULL)

SELECT COUNT(p0_.id) AS sclr_0 FROM profiles p0_ WHERE (p0_.user_id = 1 AND p0_.deleted_at IS NULL) AND (p0_.deleted_at IS NULL);

SELECT
  COUNT(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')
WHERE
  (
    s0_.user_id = ?
    AND p1_.id IS NULL
  )
  AND (s0_.deleted_at IS NULL)

SELECT COUNT(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') WHERE (s0_.user_id = 1 AND p1_.id IS NULL) AND (s0_.deleted_at IS NULL);

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  saloons s0_
WHERE
  (s0_.user_id = ?)
  AND (s0_.deleted_at IS NULL)

SELECT COUNT(s0_.id) AS sclr_0 FROM saloons s0_ WHERE (s0_.user_id = 1) AND (s0_.deleted_at IS NULL);

SELECT
  COUNT(*)
FROM
  support_messages t0
WHERE
  t0.user_id = ?
  AND t0.wrote_by_user = ?
  AND t0.is_read = ?

SELECT COUNT(*) FROM support_messages t0 WHERE t0.user_id = 1 AND t0.wrote_by_user = 0 AND t0.is_read = 0;

SELECT
  COUNT(pc.id)
FROM
  profile_comments `pc`
  JOIN profiles p ON p.id = pc.profile_id
  LEFT JOIN profile_comments pc2 ON pc2.parent_id = pc.id
  AND pc2.account_type = 'advertiser'
WHERE
  pc.deleted_at IS NULL
  AND pc.parent_id IS NULL
  AND pc.account_type = 'customer'
  AND (
    pc2.id IS NULL
    OR pc2.deleted_at IS NOT NULL
  )
  AND p.user_id = 1
  AND p.deleted_at IS NULL

SELECT COUNT(pc.id)
            FROM profile_comments `pc`
            JOIN profiles p ON p.id = pc.profile_id
            LEFT JOIN profile_comments pc2 ON pc2.parent_id = pc.id AND pc2.account_type = 'advertiser'
            WHERE pc.deleted_at IS NULL AND pc.parent_id IS NULL AND pc.account_type = 'customer'
                AND (pc2.id IS NULL OR pc2.deleted_at IS NOT NULL)
                AND p.user_id = 1 AND p.deleted_at IS NULL
        ;

SELECT
  COUNT(sc.id)
FROM
  saloon_comments `sc`
  JOIN saloons s ON s.id = sc.saloon_id
  LEFT JOIN saloon_comments sc2 ON sc2.parent_id = sc.id
  AND sc2.account_type = 'advertiser'
WHERE
  sc.deleted_at IS NULL
  AND sc.parent_id IS NULL
  AND sc.account_type = 'customer'
  AND (
    sc2.id IS NULL
    OR sc2.deleted_at IS NOT NULL
  )
  AND s.user_id = 1
  AND s.deleted_at IS NULL

SELECT COUNT(sc.id)
            FROM saloon_comments `sc`
            JOIN saloons s ON s.id = sc.saloon_id
            LEFT JOIN saloon_comments sc2 ON sc2.parent_id = sc.id AND sc2.account_type = 'advertiser'
            WHERE sc.deleted_at IS NULL AND sc.parent_id IS NULL AND sc.account_type = 'customer'
                AND (sc2.id IS NULL OR sc2.deleted_at IS NOT NULL)
                AND s.user_id = 1 AND s.deleted_at IS NULL
        ;

SELECT
  COUNT(*)
FROM
  support_messages t0
WHERE
  t0.user_id = ?
  AND t0.wrote_by_user = ?
  AND t0.is_read = ?

SELECT COUNT(*) FROM support_messages t0 WHERE t0.user_id = 1 AND t0.wrote_by_user = 0 AND t0.is_read = 0;

SELECT
  p.id,
  p.is_approved,
  psp.price_amount
FROM
  profiles `p`
  JOIN profile_adboard_placements pap ON pap.profile_id = p.id
  AND pap.placement_price_id IS NOT NULL
  JOIN paid_service_prices psp ON pap.placement_price_id = psp.id
WHERE
  p.user_id = 1

SELECT 
                p.id, p.is_approved, psp.price_amount
            FROM profiles `p`
            JOIN profile_adboard_placements pap ON pap.profile_id = p.id AND pap.placement_price_id IS NOT NULL
            JOIN paid_service_prices psp ON pap.placement_price_id = psp.id
            WHERE p.user_id = 1
        ;

SELECT
  p0_.id AS id_0,
  p0_.price_amount AS price_amount_1,
  p0_.currency AS currency_2,
  p0_.duration AS duration_3,
  p0_.enabled AS enabled_4,
  p0_.placement_type AS placement_type_5,
  p0_.city_id AS city_id_6
FROM
  paid_service_prices p0_
WHERE
  (
    p0_.enabled = 1
    AND p0_.placement_type IN (?)
    AND p0_.currency = ?
  )
  AND p0_.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )
LIMIT
  1

SELECT p0_.id AS id_0, p0_.price_amount AS price_amount_1, p0_.currency AS currency_2, p0_.duration AS duration_3, p0_.enabled AS enabled_4, p0_.placement_type AS placement_type_5, p0_.city_id AS city_id_6 FROM paid_service_prices p0_ WHERE (p0_.enabled = 1 AND p0_.placement_type IN ('placement_hiding') AND p0_.currency = 'RUB') AND p0_.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding') LIMIT 1;

SELECT
  p.id,
  p.is_approved
FROM
  profiles `p`
  JOIN placement_hidings ph ON ph.profile_id = p.id
WHERE
  p.user_id = 1

SELECT 
                p.id, p.is_approved
            FROM profiles `p`
            JOIN placement_hidings ph ON ph.profile_id = p.id
            WHERE p.user_id = 1
        ;

SELECT
  s0_.id AS id_0,
  s0_.uri_identity AS uri_identity_1,
  s0_.name AS name_2,
  s0_.description AS description_3,
  s0_.client_types AS client_types_4,
  s0_.phone_number AS phone_number_5,
  s0_.prices AS prices_6,
  s0_.extra_charge AS extra_charge_7,
  s0_.districts AS districts_8,
  s0_.address AS address_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.inactivated_at AS inactivated_at_12,
  s0_.email AS email_13,
  s0_.seo AS seo_14,
  s0_.delete_mode AS delete_mode_15,
  s0_.deleted_at AS deleted_at_16,
  s0_.messengers_telegram AS messengers_telegram_17,
  s0_.messengers_whatsapp AS messengers_whatsapp_18,
  s0_.messengers_telegram_username AS messengers_telegram_username_19,
  s0_.call_time_from AS call_time_from_20,
  s0_.call_time_to AS call_time_to_21,
  s0_.call_answering_to AS call_answering_to_22,
  s0_.working_hours_since AS working_hours_since_23,
  s0_.working_hours_till AS working_hours_till_24,
  s0_.apartments_one_hour_price AS apartments_one_hour_price_25,
  s0_.apartments_two_hours_price AS apartments_two_hours_price_26,
  s0_.apartments_night_price AS apartments_night_price_27,
  s0_.take_out_one_hour_price AS take_out_one_hour_price_28,
  s0_.take_out_two_hours_price AS take_out_two_hours_price_29,
  s0_.take_out_night_price AS take_out_night_price_30,
  s0_.take_out_locations AS take_out_locations_31,
  s0_.express_provided AS express_provided_32,
  s0_.express_price AS express_price_33,
  s0_.map_latitude AS map_latitude_34,
  s0_.map_longitude AS map_longitude_35,
  s0_.user_id AS user_id_36,
  s0_.city_id AS city_id_37,
  s0_.primary_station_id AS primary_station_id_38
FROM
  saloons s0_
  LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id
  LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id
  AND p2_.entity_type IN ('saloon')
WHERE
  (
    (
      s1_.saloon_id IS NOT NULL
      OR p2_.id IS NOT NULL
    )
    AND s0_.user_id = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.uri_identity AS uri_identity_1, s0_.name AS name_2, s0_.description AS description_3, s0_.client_types AS client_types_4, s0_.phone_number AS phone_number_5, s0_.prices AS prices_6, s0_.extra_charge AS extra_charge_7, s0_.districts AS districts_8, s0_.address AS address_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.inactivated_at AS inactivated_at_12, s0_.email AS email_13, s0_.seo AS seo_14, s0_.delete_mode AS delete_mode_15, s0_.deleted_at AS deleted_at_16, s0_.messengers_telegram AS messengers_telegram_17, s0_.messengers_whatsapp AS messengers_whatsapp_18, s0_.messengers_telegram_username AS messengers_telegram_username_19, s0_.call_time_from AS call_time_from_20, s0_.call_time_to AS call_time_to_21, s0_.call_answering_to AS call_answering_to_22, s0_.working_hours_since AS working_hours_since_23, s0_.working_hours_till AS working_hours_till_24, s0_.apartments_one_hour_price AS apartments_one_hour_price_25, s0_.apartments_two_hours_price AS apartments_two_hours_price_26, s0_.apartments_night_price AS apartments_night_price_27, s0_.take_out_one_hour_price AS take_out_one_hour_price_28, s0_.take_out_two_hours_price AS take_out_two_hours_price_29, s0_.take_out_night_price AS take_out_night_price_30, s0_.take_out_locations AS take_out_locations_31, s0_.express_provided AS express_provided_32, s0_.express_price AS express_price_33, s0_.map_latitude AS map_latitude_34, s0_.map_longitude AS map_longitude_35, s0_.user_id AS user_id_36, s0_.city_id AS city_id_37, s0_.primary_station_id AS primary_station_id_38 FROM saloons s0_ LEFT JOIN saloon_adboard_placements s1_ ON s0_.id = s1_.saloon_id LEFT JOIN placement_hidings p2_ ON s0_.id = p2_.saloon_id AND p2_.entity_type IN ('saloon') WHERE ((s1_.saloon_id IS NOT NULL OR p2_.id IS NOT NULL) AND s0_.user_id = 1) AND (s0_.deleted_at IS NULL);

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.timezone AS timezone_6,
  t0.map_latitude AS map_latitude_7,
  t0.map_longitude AS map_longitude_8
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.timezone AS timezone_6, t0.map_latitude AS map_latitude_7, t0.map_longitude AS map_longitude_8 FROM cities t0;