GET https://staging.nfz-v2.vps.opatrunek.eu/api/v1/messages

Query Metrics

2 Database Queries
2 Different statements
0.84 ms Query time
4 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.52 ms
(62.28%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.login AS login_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.roles AS roles_6, t0.password AS password_7, t0.invitation_token AS invitation_token_8, t0.restore_password_token AS restore_password_token_9, t0.invited_at AS invited_at_10, t0.pharmacy_id AS pharmacy_id_11, t12.id AS id_13, t12.name AS name_14, t12.mail AS mail_15, t12.phone AS phone_16, t12.address AS address_17, t12.joining_date AS joining_date_18, t12.status AS status_19, t12.owner_id AS owner_id_20, t21.id AS id_22, t21.created_at AS created_at_23, t21.last_updated_at AS last_updated_at_24, t21.user_id AS user_id_25, t26.id AS id_27, t26.code AS code_28, t26.name AS name_29, t26.type AS type_30, t26.settings AS settings_31, t26.user_id AS user_id_32 FROM `user` t0 LEFT JOIN organization t12 ON t12.owner_id = t0.id LEFT JOIN `conversations` t21 ON t21.user_id = t0.id LEFT JOIN `integration` t26 ON t26.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
0.32 ms
(37.72%)
1
SELECT m0_.id AS id_0, m0_.message AS message_1, m0_.is_administrator_message AS is_administrator_message_2, m0_.read_at AS read_at_3, m0_.created_at AS created_at_4 FROM `messages` m0_ ORDER BY m0_.id DESC LIMIT 10
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\User\Entity\User 1

Entities Mapping

Class Mapping errors
App\User\Entity\User
  • The field App\User\Entity\User#ownedOrganization is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Organization\Entity\Organization#owner does not contain the required 'inversedBy: "ownedOrganization"' attribute.
App\Pharmacy\Entity\Pharmacy
  • The field 'App\Pharmacy\Entity\Pharmacy#buyLimit' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Pharmacy\Entity\Pharmacy#remainingBuyLimit' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The association App\Pharmacy\Entity\Pharmacy#integrations refers to the owning side field App\Integration\Entity\Integration#pharmacy which does not exist.
App\Organization\Entity\Organization No errors.
App\Messaging\Entity\Conversation
  • The field App\Messaging\Entity\Conversation#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Messaging\Entity\Message#conversation does not contain the required 'inversedBy: "messages"' attribute.
App\Integration\Entity\Integration No errors.
App\Order\Entity\Order
  • The field 'App\Order\Entity\Order#totalPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Order\Entity\Order#totalRefundedPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Order\Entity\Order#marginTotal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Order\Entity\Order#shippingPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Messaging\Entity\Message No errors.