https://314-cherry-pick-20261029-1.review.mechanic.works/moskva/test-anketa-moskva-200/

Query Metrics

22 Database Queries
22 Different statements
30.70 ms Query time
18 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼ Count Info
10.12 ms
(32.98%)
1
SELECT COUNT(DISTINCT p.id)
FROM profiles p
INNER JOIN profile_adboard_placements pap ON pap.profile_id = p.id
LEFT JOIN `user` u ON u.id = p.user_id
WHERE p.city_id = ?
AND p.deleted_at IS NULL
AND p.is_masseur = 0
AND p.saloon_id IS NULL
AND p.person_gender = ?
AND p.moderation_status IN (?, ?, ?)
AND p.user_id IS NOT NULL
AND (
    SELECT COUNT(owner_profiles.id)
    FROM profiles owner_profiles
    WHERE owner_profiles.user_id = p.user_id
    AND owner_profiles.deleted_at IS NULL
) <= ?
Parameters:
[
  1
  1
  0
  2
  1
  5
]
3.34 ms
(10.89%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('adm_apr_ph')
Parameters:
[
  200
]
2.58 ms
(8.42%)
1
SELECT t0.id AS id_1, t0.service_condition AS service_condition_2, t0.extra_charge AS extra_charge_3, t0.comment AS comment_4, t0.profile_id AS profile_id_5, t0.service_id AS service_id_6 FROM profile_provided_services t0 WHERE t0.profile_id = ?
Parameters:
[
  200
]
2.28 ms
(7.44%)
1
SELECT t0.id AS id_1, t0.is_dummy AS is_dummy_2, t0.uri_identity AS uri_identity_3, t0.name AS name_4, t0.description AS description_5, t0.client_types AS client_types_6, t0.phone_number AS phone_number_7, t0.is_masseur AS is_masseur_8, t0.extra_charge AS extra_charge_9, t0.prepayment AS prepayment_10, t0.prepayment_amount AS prepayment_amount_11, t0.prepayment_comment AS prepayment_comment_12, t0.is_approved AS is_approved_13, t0.moderation_status AS moderation_status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.inactivated_at AS inactivated_at_17, t0.seo AS seo_18, t0.delete_mode AS delete_mode_19, t0.deleted_at AS deleted_at_20, t0.person_gender AS person_gender_21, t0.person_age AS person_age_22, t0.person_height AS person_height_23, t0.person_weight AS person_weight_24, t0.person_breast_size AS person_breast_size_25, t0.person_breast_type AS person_breast_type_26, t0.person_cloth_size AS person_cloth_size_27, t0.person_shoes_size AS person_shoes_size_28, t0.person_body_type AS person_body_type_29, t0.person_hair_color AS person_hair_color_30, t0.person_private_haircut AS person_private_haircut_31, t0.person_nationality AS person_nationality_32, t0.person_appearance AS person_appearance_33, t0.person_has_tattoo AS person_has_tattoo_34, t0.person_has_piercing AS person_has_piercing_35, t0.messengers_telegram AS messengers_telegram_36, t0.messengers_whatsapp AS messengers_whatsapp_37, t0.messengers_telegram_username AS messengers_telegram_username_38, t0.call_time_from AS call_time_from_39, t0.call_time_to AS call_time_to_40, t0.call_answering_to AS call_answering_to_41, t0.client_min_age AS client_min_age_42, t0.client_max_age AS client_max_age_43, t0.apartments_one_hour_price AS apartments_one_hour_price_44, t0.apartments_two_hours_price AS apartments_two_hours_price_45, t0.apartments_night_price AS apartments_night_price_46, t0.take_out_one_hour_price AS take_out_one_hour_price_47, t0.take_out_two_hours_price AS take_out_two_hours_price_48, t0.take_out_night_price AS take_out_night_price_49, t0.take_out_locations AS take_out_locations_50, t0.express_provided AS express_provided_51, t0.express_price AS express_price_52, t0.car_provided AS car_provided_53, t0.map_latitude AS map_latitude_54, t0.map_longitude AS map_longitude_55, t0.user_id AS user_id_56, t57.type AS type_58, t57.position_group AS position_group_59, t57.position AS position_60, t57.placed_at AS placed_at_61, t57.placed_until AS placed_until_62, t57.plan_managed AS plan_managed_63, t57.profile_id AS profile_id_64, t57.placement_price_id AS placement_price_id_65, t0.city_id AS city_id_66, t0.primary_station_id AS primary_station_id_67, t0.saloon_id AS saloon_id_68 FROM profiles t0 LEFT JOIN profile_adboard_placements t57 ON t57.profile_id = t0.id WHERE t0.uri_identity = ? AND t0.city_id = ? LIMIT 1
Parameters:
[
  "test-anketa-moskva-200"
  1
]
1.56 ms
(5.10%)
1
SELECT t0.id AS id_1, t0.placed_at AS placed_at_2, t0.placed_until AS placed_until_3, t0.profile_id AS profile_id_4, t0.entity_type FROM placement_hidings t0 WHERE t0.profile_id = ? AND t0.entity_type IN ('profile')
Parameters:
[
  200
]
1.34 ms
(4.37%)
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
Parameters:
[
  1
]
1.23 ms
(4.02%)
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
Parameters:
[]
1.21 ms
(3.93%)
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 INNER JOIN profile_stations ON t0.id = profile_stations.station_id WHERE profile_stations.profile_id = ?
Parameters:
[
  200
]
1.03 ms
(3.36%)
1
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE p0_.city_id = ? AND p0_.deleted_at IS NULL AND p0_.person_gender = ? AND p0_.moderation_status IN (?, ?, ?) AND p0_.id = ? AND p0_.is_masseur = 0 AND p0_.saloon_id IS NULL AND ((p0_.user_id IS NOT NULL AND (SELECT COUNT(p2_.id) AS sclr_1 FROM profiles p2_ WHERE p2_.user_id = p0_.user_id AND p2_.deleted_at IS NULL) <= ?) OR (p0_.is_approved = 1 AND ((p0_.apartments_one_hour_price BETWEEN ? AND ?) OR (p0_.take_out_one_hour_price BETWEEN ? AND ?))))
Parameters:
[
  1
  1
  0
  2
  1
  200
  5
  6000
  12000
  6000
  12000
]
0.61 ms
(2.00%)
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 (?, ?, ?) GROUP BY p0_.city_id
Parameters:
[
  1
  0
  2
  1
]
0.60 ms
(1.96%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('photo', 'video', 'selfie', 'avatar', 'adm_apr_ph')
Parameters:
[
  200
]
0.56 ms
(1.83%)
1
SELECT t0.id AS id_1, t0.placed_at AS placed_at_2, t0.expires_at AS expires_at_3, t0.city_id AS city_id_4, t0.profile_id AS profile_id_5, t0.placement_price_id AS placement_price_id_6 FROM profile_top_placements t0 WHERE t0.profile_id = ?
Parameters:
[
  200
]
0.55 ms
(1.79%)
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, CASE WHEN s0_.`group` = 1 THEN 10 WHEN s0_.`group` = 2 THEN 20 WHEN s0_.`group` = 8 THEN 30 WHEN s0_.`group` = 3 THEN 40 WHEN s0_.`group` = 4 THEN 50 WHEN s0_.`group` = 5 THEN 60 WHEN s0_.`group` = 6 THEN 70 WHEN s0_.`group` = 9 THEN 80 WHEN s0_.`group` = 7 THEN 90 ELSE 100 END AS sclr_5 FROM services s0_ ORDER BY sclr_5 ASC, s0_.sort ASC, s0_.id ASC
Parameters:
[]
0.54 ms
(1.77%)
1
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 (EXISTS (SELECT 1 FROM profile_stations p2_ WHERE p2_.profile_id = p0_.id AND p2_.station_id IN (?)) AND NOT (p0_.id IN (?))) LIMIT 6
Parameters:
[
  0
  2
  1
  false
  200
]
0.50 ms
(1.64%)
1
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_.city_id = ? AND NOT (p0_.id IN (?))) LIMIT 6
Parameters:
[
  0
  2
  1
  1
  200
]
0.47 ms
(1.52%)
1
SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.mark AS mark_5, t0.parent_id AS parent_id_6, t0.profile_id AS profile_id_7, t0.user_id AS user_id_8, t0.ip_address_id AS ip_address_id_9, t0.account_type FROM profile_comments t0 WHERE t0.profile_id = ? AND t0.account_type IN ('customer') AND ((t0.deleted_at IS NULL))
Parameters:
[
  200
]
0.41 ms
(1.34%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('video')
Parameters:
[
  200
]
0.40 ms
(1.31%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('selfie')
Parameters:
[
  200
]
0.38 ms
(1.22%)
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_.region AS region_7, c0_.map_latitude AS map_latitude_8, c0_.map_longitude AS map_longitude_9 FROM cities c0_ WHERE c0_.uri_identity = ? LIMIT 1
Parameters:
[
  "moskva"
]
0.33 ms
(1.07%)
1
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.region AS region_8, t0.map_latitude AS map_latitude_9, t0.map_longitude AS map_longitude_10 FROM cities t0
Parameters:
[]
0.33 ms
(1.06%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = ? AND t0.type IN ('avatar')
Parameters:
[
  200
]
0.30 ms
(0.98%)
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_.last_modified AS last_modified_8, p0_.city_id AS city_id_9 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1
Parameters:
[
  "/moskva/test-anketa-moskva-200/"
]

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 No errors.
App\Entity\Profile\PersonParameters No errors.
App\Entity\Messengers No errors.
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\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\Profile\Profile
  • 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\SEO\PageMetadata No errors.
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\User No errors.
App\Entity\Account\Advertiser No errors.
App\Entity\Sales\PlacementHiding No errors.
App\Entity\Sales\Profile\PlacementHiding No errors.
App\Entity\Profile\Photo No errors.
App\Entity\Profile\AdminApprovalPhoto No errors.
App\Entity\Profile\Avatar No errors.
App\Entity\Saloon\WorkingHours No errors.
App\Entity\Saloon\Saloon
  • The field 'App\Entity\Saloon\Saloon#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\Saloon\Saloon#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\Saloon\Saloon#placementHiding is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sales\Saloon\PlacementHiding#saloon does not contain the required 'inversedBy="placementHiding"' attribute.
  • The field App\Entity\Saloon\Saloon#providedServices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Saloon\SaloonService#saloon does not contain the required 'inversedBy="providedServices"' attribute.
  • The field App\Entity\Saloon\Saloon#thumbnail is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Saloon\Thumbnail#saloon does not contain the required 'inversedBy="thumbnail"' attribute.
  • The field App\Entity\Saloon\Saloon#photos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Saloon\Photo#saloon does not contain the required 'inversedBy="photos"' attribute.
  • The field App\Entity\Saloon\Saloon#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Saloon\Video#saloon does not contain the required 'inversedBy="videos"' attribute.
App\Entity\Sales\Profile\TopPlacement No errors.
App\Entity\Profile\ProfileService No errors.
App\Entity\Profile\ProfileProvidedInventoryItem No errors.
App\Entity\Profile\Selfie No errors.
App\Entity\Profile\Video No errors.
App\Entity\Profile\FileProcessingTask No errors.
App\Entity\Profile\Confirmation\ConfirmationRequest
  • The mappings App\Entity\Profile\Confirmation\ConfirmationRequest#videos and App\Entity\Profile\Confirmation\Video#confirmationRequest are inconsistent with each other.
App\Entity\Profile\Confirmation\ModerationRequest
  • The mappings App\Entity\Profile\Confirmation\ModerationRequest#videos and App\Entity\Profile\Confirmation\Video#confirmationRequest are inconsistent with each other.
App\Entity\Profile\Comment\Comment No errors.
App\Entity\Profile\Comment\CommentByCustomer
  • The field App\Entity\Profile\Comment\CommentByCustomer#comments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\Comment\Comment#parent does not contain the required 'inversedBy="comments"' attribute.
App\Entity\Profile\ProfileName No errors.
App\Entity\Sales\PaidPlacementsOrder No errors.
App\Entity\Service No errors.
App\Entity\System\IpAddress
  • The mappings App\Entity\System\IpAddress#dailyCommentBans and App\Entity\System\IpAddressDailyCommentBan#ipAddress are inconsistent with each other.
  • The mappings App\Entity\System\IpAddress#permanentCommentBans and App\Entity\System\IpAddressPermanentCommentBan#ipAddress are inconsistent with each other.
App\Entity\Location\Subway\Line No errors.
App\Entity\Account\Avatar No errors.
App\Entity\Sales\AccountEnrollment
  • The field 'App\Entity\Sales\AccountEnrollment#paidAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Sales\AccountEnrollment#enrolledAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Sales\AccountCharge
  • The field 'App\Entity\Sales\AccountCharge#chargedAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Sales\AccountTransaction
  • The field 'App\Entity\Sales\AccountTransaction#amount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\OfferBarHidden No errors.
App\Entity\Account\PhoneReviewAdded
  • The association App\Entity\Account\PhoneReviewAdded#user refers to the inverse side field App\Entity\User#phoneReviewsAdded which does not exist.
App\Entity\Sales\Saloon\AdBoardPlacement No errors.
App\Entity\Sales\Saloon\PlacementHiding No errors.
App\Entity\Saloon\SaloonService No errors.
App\Entity\Saloon\MediaFile No errors.
App\Entity\Saloon\Thumbnail No errors.
App\Entity\Saloon\Photo No errors.
App\Entity\Saloon\Video No errors.
App\Entity\Saloon\Comment\Comment No errors.
App\Entity\Saloon\Comment\CommentByCustomer
  • The field App\Entity\Saloon\Comment\CommentByCustomer#comments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Saloon\Comment\Comment#parent does not contain the required 'inversedBy="comments"' attribute.
App\Entity\Profile\ProfileInventoryItem No errors.
App\Entity\Profile\Confirmation\MediaFile No errors.
App\Entity\Profile\Confirmation\Photo No errors.
App\Entity\Profile\Confirmation\Video No errors.
App\Entity\System\IpAddressCommentBan
  • The association App\Entity\System\IpAddressCommentBan#ipAddress refers to the inverse side field App\Entity\System\IpAddress#commentBans which does not exist.
App\Entity\System\IpAddressDailyCommentBan
  • The association App\Entity\System\IpAddressDailyCommentBan#ipAddress refers to the inverse side field App\Entity\System\IpAddress#commentBans which does not exist.
App\Entity\System\IpAddressPermanentCommentBan
  • The association App\Entity\System\IpAddressPermanentCommentBan#ipAddress refers to the inverse side field App\Entity\System\IpAddress#commentBans which does not exist.
BigIdea\IdentityBundle\Entity\TeamMate No errors.
App\Entity\Sales\PaymentProduct
  • The field 'App\Entity\Sales\PaymentProduct#paymentAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Sales\AccountRefund
  • The field 'App\Entity\Sales\AccountRefund#refundedAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.

multi_website entity manager

No loaded entities.