GET https://master.tajsoft.tj/api/message/check

Query Metrics

2 Database Queries
2 Different statements
4.04 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.54 ms
(62.85%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.gender AS gender_5, t0.img AS img_6, t0.phone_number AS phone_number_7, t0.balance AS balance_8, t0.work_experience AS work_experience_9, t0.self AS self_10, t0.role AS role_11, t0.token AS token_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.push_token AS push_token_15, t0.work_imgs AS work_imgs_16, t0.city_name AS city_name_17, t0.register_date AS register_date_18, t0.ban_text AS ban_text_19, t0.b AS b_20, t0.city_id AS city_id_21, t0.lang_id AS lang_id_22 FROM user t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "9d5024bc-26fb-4c05-81a2-4713e7cdb440"
]
1.50 ms
(37.15%)
1
SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_, chats c1_ WHERE ((c1_.from_user_id = ? OR c1_.to_user_id = ?)) AND m0_.chats_id = c1_.id AND m0_.sender_id <> ? AND m0_.is_ready = 0
Parameters:
[
  500
  500
  500
]

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#city refers to the inverse side field App\Entity\City#users which does not exist.
App\Entity\City
  • The mappings App\Entity\City#Users and App\Entity\User#city are inconsistent with each other.
  • The field App\Entity\City#cities is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\City#lang does not contain the required 'inversedBy="cities"' attribute.
App\Entity\Lang
  • The mappings App\Entity\Lang#fAQTranslates and App\Entity\FAQTranslate#lang are inconsistent with each other.
App\Entity\Category No errors.
App\Entity\Orders No errors.
App\Entity\Review
  • The association App\Entity\Review#performer refers to the inverse side field App\Entity\User#performers which does not exist.
App\Entity\Chats
  • The mappings App\Entity\Chats#to_user and App\Entity\User#chats are inconsistent with each other.
App\Entity\Message No errors.
App\Entity\Block
  • The mappings App\Entity\Block#to_user and App\Entity\User#blocks are inconsistent with each other.
App\Entity\Complate No errors.