https://coasttocorner.com/chater/vendor/6/37

Query Metrics

4 Database Queries
3 Different statements
1.49 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.35 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.roles AS roles_7, t0.password AS password_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.image_profil_fb AS image_profil_fb_11, t0.users_loyalty AS users_loyalty_12, t0.user_mangopay_id_natural AS user_mangopay_id_natural_13, t0.phone AS phone_14, t0.customer_stripe_id AS customer_stripe_id_15, t0.user_account_id AS user_account_id_16, t0.accountform_id AS accountform_id_17, t0.image_profil_id AS image_profil_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.39 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.roles AS roles_7, t0.password AS password_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.image_profil_fb AS image_profil_fb_11, t0.users_loyalty AS users_loyalty_12, t0.user_mangopay_id_natural AS user_mangopay_id_natural_13, t0.phone AS phone_14, t0.customer_stripe_id AS customer_stripe_id_15, t0.user_account_id AS user_account_id_16, t0.accountform_id AS accountform_id_17, t0.image_profil_id AS image_profil_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
3 0.43 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.content AS content_3, t0.last_message_id AS last_message_id_4, t0.is_read AS is_read_5, t0.vendor_id AS vendor_id_6, t0.visitor_id AS visitor_id_7, t0.message_owner_id AS message_owner_id_8, t0.message_receiver_id AS message_receiver_id_9, t0.offers_id AS offers_id_10 FROM message t0 WHERE t0.vendor_id = ? AND t0.visitor_id = ?
Parameters:
[
  4
  6
]
4 0.31 ms
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM image_profil t0 WHERE t0.id = ?
Parameters:
[
  3
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#orders refers to the owning side field App\Entity\Orders#User which does not exist.
App\Entity\UserAccount No errors.
App\Entity\AccountForm
  • The mappings App\Entity\AccountForm#customLoyalty and App\Entity\CustomersLoyalty#accountForm are inconsistent with each other.
  • The mappings App\Entity\AccountForm#orders and App\Entity\Orders#accountForm are inconsistent with each other.
App\Entity\ImageProfil No errors.
App\Entity\Reviews No errors.
App\Entity\Message No errors.
App\Entity\Orders
  • The association App\Entity\Orders#accountForm refers to the inverse side field App\Entity\AccountForm#Orders which does not exist.
  • The mappings App\Entity\Orders#user and App\Entity\User#orders are inconsistent with each other.
App\Entity\Offers No errors.