https://313-release-profile-prepayment.review.mechanic.works/moscow/station-vyhino/

Query Metrics

19 Database Queries
16 Different statements
16.76 ms Query time
5 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 0.77 ms
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
Parameters:
[
  "/moscow/station-vyhino/"
]
2 0.56 ms
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
Parameters:
[
  "moscow"
]
3 0.64 ms
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
Parameters:
[
  1
  "vyhino"
]
4 1.33 ms
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
Parameters:
[
  1
]
5 0.89 ms
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_telegram_username AS messengers_telegram_username_39, p1_.call_time_from AS call_time_from_40, p1_.call_time_to AS call_time_to_41, p1_.call_answering_to AS call_answering_to_42, p1_.client_min_age AS client_min_age_43, p1_.client_max_age AS client_max_age_44, p1_.apartments_one_hour_price AS apartments_one_hour_price_45, p1_.apartments_two_hours_price AS apartments_two_hours_price_46, p1_.apartments_night_price AS apartments_night_price_47, p1_.take_out_one_hour_price AS take_out_one_hour_price_48, p1_.take_out_two_hours_price AS take_out_two_hours_price_49, p1_.take_out_night_price AS take_out_night_price_50, p1_.take_out_locations AS take_out_locations_51, p1_.express_provided AS express_provided_52, p1_.express_price AS express_price_53, p1_.car_provided AS car_provided_54, p1_.map_latitude AS map_latitude_55, p1_.map_longitude AS map_longitude_56, p0_.city_id AS city_id_57, p0_.profile_id AS profile_id_58, p0_.placement_price_id AS placement_price_id_59, p1_.user_id AS user_id_60, p1_.city_id AS city_id_61, p1_.primary_station_id AS primary_station_id_62 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
Parameters:
[
  1
  "2026-04-13 13:05:18"
  "2026-04-13 13:05:18"
]
6 1.35 ms
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_telegram_username AS messengers_telegram_username_39, p1_.call_time_from AS call_time_from_40, p1_.call_time_to AS call_time_to_41, p1_.call_answering_to AS call_answering_to_42, p1_.client_min_age AS client_min_age_43, p1_.client_max_age AS client_max_age_44, p1_.apartments_one_hour_price AS apartments_one_hour_price_45, p1_.apartments_two_hours_price AS apartments_two_hours_price_46, p1_.apartments_night_price AS apartments_night_price_47, p1_.take_out_one_hour_price AS take_out_one_hour_price_48, p1_.take_out_two_hours_price AS take_out_two_hours_price_49, p1_.take_out_night_price AS take_out_night_price_50, p1_.take_out_locations AS take_out_locations_51, p1_.express_provided AS express_provided_52, p1_.express_price AS express_price_53, p1_.car_provided AS car_provided_54, p1_.map_latitude AS map_latitude_55, p1_.map_longitude AS map_longitude_56, p0_.city_id AS city_id_57, p0_.profile_id AS profile_id_58, p0_.placement_price_id AS placement_price_id_59, p1_.user_id AS user_id_60, p1_.city_id AS city_id_61, p1_.primary_station_id AS primary_station_id_62 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
Parameters:
[
  1
  "2026-04-13 13:05:18"
  "2026-04-13 13:05:18"
]
7 0.95 ms
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)
Parameters:
[
  0
  2
  1
  1
  1
  1
  40
]
8 0.73 ms
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 = ?
Parameters:
[
  44
]
9 0.58 ms
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 = ?
Parameters:
[
  44
]
10 1.00 ms
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 1
Parameters:
[
  0
  2
  1
  1
  1
  0
  1
  40
  48
  61
  75
  202
  209
]
11 0.84 ms
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 1
Parameters:
[
  0
  2
  1
  1
  1
  0
]
12 0.78 ms
SELECT p0_.id AS id_0 FROM profiles p0_ LEFT JOIN cities c1_ ON p0_.city_id = c1_.id INNER JOIN profile_adboard_placements p2_ ON p0_.id = p2_.profile_id WHERE (c1_.country_code = ? AND p0_.moderation_status IN (?, ?, ?) AND p0_.person_gender IN (?) AND p0_.is_masseur = ?) AND (p0_.deleted_at IS NULL) ORDER BY RAND() ASC LIMIT 1
Parameters:
[
  "RU"
  0
  2
  1
  1
  0
]
13 0.93 ms
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 = ?
Parameters:
[
  1
]
14 0.62 ms
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
Parameters:
[]
15 0.84 ms
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_telegram_username AS messengers_telegram_username_39, p1_.call_time_from AS call_time_from_40, p1_.call_time_to AS call_time_to_41, p1_.call_answering_to AS call_answering_to_42, p1_.client_min_age AS client_min_age_43, p1_.client_max_age AS client_max_age_44, p1_.apartments_one_hour_price AS apartments_one_hour_price_45, p1_.apartments_two_hours_price AS apartments_two_hours_price_46, p1_.apartments_night_price AS apartments_night_price_47, p1_.take_out_one_hour_price AS take_out_one_hour_price_48, p1_.take_out_two_hours_price AS take_out_two_hours_price_49, p1_.take_out_night_price AS take_out_night_price_50, p1_.take_out_locations AS take_out_locations_51, p1_.express_provided AS express_provided_52, p1_.express_price AS express_price_53, p1_.car_provided AS car_provided_54, p1_.map_latitude AS map_latitude_55, p1_.map_longitude AS map_longitude_56, p0_.city_id AS city_id_57, p0_.profile_id AS profile_id_58, p0_.placement_price_id AS placement_price_id_59, p1_.user_id AS user_id_60, p1_.city_id AS city_id_61, p1_.primary_station_id AS primary_station_id_62 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
Parameters:
[
  1
  "2026-04-13 13:05:18"
  "2026-04-13 13:05:18"
]
16 0.85 ms
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
Parameters:
[
  1
  0
  2
  1
]
17 0.89 ms
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
Parameters:
[]
18 1.11 ms
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
Parameters:
[]
19 1.11 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
multi_website doctrine.dbal.multi_website_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
multi_website doctrine.orm.multi_website_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Sales\Profile\AdBoardPlacement No errors.
App\Entity\Sales\PaidPlacementPrice
  • The field 'App\Entity\Sales\PaidPlacementPrice#priceAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\SEO\PageMetadata No errors.
App\Entity\Location\MapCoordinate
  • The field 'App\Entity\Location\MapCoordinate#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Location\MapCoordinate#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Location\City
  • The field 'App\Entity\Location\City#mapCoordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Location\City#mapCoordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Location\County No errors.
App\Entity\Location\District No errors.
App\Entity\Location\Station No errors.
App\Entity\Location\Subway\Line No errors.
App\Entity\Sales\PaidPlacementsOrder No errors.
App\Entity\Sales\Profile\TopPlacement No errors.
App\Entity\Profile\PersonParameters No errors.
App\Entity\Messengers
  • The field 'App\Entity\Messengers#whatsApp' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\PhoneCallRestrictions No errors.
App\Entity\Profile\ClientRestrictions No errors.
App\Entity\ApartmentsPricing No errors.
App\Entity\TakeOutPricing No errors.
App\Entity\ExpressPricing No errors.
App\Entity\Profile\CarPricing No errors.
App\Entity\Profile\Profile
  • The field 'App\Entity\Profile\Profile#messengers.whatsApp' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Profile\Profile#mapCoordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Profile\Profile#mapCoordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\Profile\Profile#placementHiding is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sales\Profile\PlacementHiding#profile does not contain the required 'inversedBy="placementHiding"' attribute.
  • The field App\Entity\Profile\Profile#providedServices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\ProfileService#profile does not contain the required 'inversedBy="providedServices"' attribute.
  • The mappings App\Entity\Profile\Profile#selfies and App\Entity\Profile\Selfie#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#videos and App\Entity\Profile\Video#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#adminApprovalPhoto and App\Entity\Profile\AdminApprovalPhoto#profile are inconsistent with each other.
  • The mappings App\Entity\Profile\Profile#avatar and App\Entity\Profile\Avatar#profile are inconsistent with each other.
App\Entity\User No errors.
App\Entity\Account\Advertiser No errors.
App\Entity\Service No errors.

multi_website entity manager

No loaded entities.