https://389-feat-main-city-routing.review.mechanic.works/wordpress/

Query Metrics

3 Database Queries
3 Different statements
3.83 ms Query time
13 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 1.20 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:
[
  "/wordpress/"
]
2 0.66 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 1.96 ms
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.is_approved AS is_approved_10, t0.moderation_status AS moderation_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.inactivated_at AS inactivated_at_14, t0.seo AS seo_15, t0.deleted_at AS deleted_at_16, t0.person_gender AS person_gender_17, t0.person_age AS person_age_18, t0.person_height AS person_height_19, t0.person_weight AS person_weight_20, t0.person_breast_size AS person_breast_size_21, t0.person_breast_type AS person_breast_type_22, t0.person_cloth_size AS person_cloth_size_23, t0.person_shoes_size AS person_shoes_size_24, t0.person_body_type AS person_body_type_25, t0.person_hair_color AS person_hair_color_26, t0.person_private_haircut AS person_private_haircut_27, t0.person_nationality AS person_nationality_28, t0.person_has_tattoo AS person_has_tattoo_29, t0.person_has_piercing AS person_has_piercing_30, t0.messengers_telegram AS messengers_telegram_31, t0.messengers_whatsapp AS messengers_whatsapp_32, t0.call_time_from AS call_time_from_33, t0.call_time_to AS call_time_to_34, t0.call_answering_to AS call_answering_to_35, t0.client_min_age AS client_min_age_36, t0.client_max_age AS client_max_age_37, t0.apartments_one_hour_price AS apartments_one_hour_price_38, t0.apartments_two_hours_price AS apartments_two_hours_price_39, t0.apartments_night_price AS apartments_night_price_40, t0.take_out_one_hour_price AS take_out_one_hour_price_41, t0.take_out_two_hours_price AS take_out_two_hours_price_42, t0.take_out_night_price AS take_out_night_price_43, t0.take_out_locations AS take_out_locations_44, t0.express_provided AS express_provided_45, t0.express_price AS express_price_46, t0.car_provided AS car_provided_47, t0.map_latitude AS map_latitude_48, t0.map_longitude AS map_longitude_49, t0.user_id AS user_id_50, t51.type AS type_52, t51.position_group AS position_group_53, t51.position AS position_54, t51.placed_at AS placed_at_55, t51.placed_until AS placed_until_56, t51.profile_id AS profile_id_57, t51.placement_price_id AS placement_price_id_58, t0.city_id AS city_id_59 FROM profiles t0 LEFT JOIN profile_adboard_placements t51 ON t51.profile_id = t0.id WHERE t0.uri_identity = ? AND t0.city_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "wordpress"
  1
]

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\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\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\Sales\PaidPlacementsOrder No errors.
App\Entity\Location\Subway\Line No errors.
App\Entity\Sales\Profile\TopPlacement No errors.
App\Entity\Profile\ProfileService No errors.
App\Entity\Profile\Selfie No errors.
App\Entity\Profile\Video No errors.
App\Entity\Profile\FileProcessingTask No errors.
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\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\Saloon\WorkingHours No errors.
App\Entity\Saloon\Saloon
  • The field 'App\Entity\Saloon\Saloon#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\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\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.

multi_website entity manager

No loaded entities.