https://313-f-29314-show-more-duplicate.review.mechanic.works/remind/

Query Metrics

3 Database Queries
3 Different statements
6.52 ms Query time
4 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 0.86 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:
[
  "/remind/"
]
2 5.18 ms
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.email IS NULL AND t0.type IN ('advertiser', 'customer') LIMIT 1
Parameters:
[]
3 0.48 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"
]

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\Sales\PaidPlacementsOrder No errors.
App\Entity\User No errors.
App\Entity\Account\Avatar No errors.
App\Entity\OfferBarHidden No errors.
App\Entity\Account\Advertiser No errors.
App\Entity\Account\Customer
  • The field App\Entity\Account\Customer#commentBan is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Account\CommentBan#user does not contain the required 'inversedBy="commentBan"' attribute.
  • The field App\Entity\Account\Customer#profilePreference is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Account\CustomerProfilePreference#user does not contain the required 'inversedBy="profilePreference"' attribute.
  • The field App\Entity\Account\Customer#preferredProfilesData is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Account\CustomerPreferredProfilesData#user does not contain the required 'inversedBy="preferredProfilesData"' attribute.
  • The field App\Entity\Account\Customer#profileComments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Profile\Comment\CommentByCustomer#user does not contain the required 'inversedBy="profileComments"' attribute.
  • The field App\Entity\Account\Customer#saloonComments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Saloon\Comment\CommentByCustomer#user does not contain the required 'inversedBy="saloonComments"' attribute.
App\Entity\Location\County No errors.
App\Entity\Location\District No errors.
App\Entity\Location\Station No errors.

multi_website entity manager

No loaded entities.