GET https://master.tajsoft.tj/api/review/get/306?page=1

Query Metrics

5 Database Queries
4 Different statements
5.84 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 2.22 ms
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.id = ?
Parameters:
[
  306
]
2 1.62 ms
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.performer_id = ?
Parameters:
[
  306
]
3 0.90 ms
SELECT DISTINCT r0_.id AS id_0, r0_.created_at AS created_at_1 FROM review r0_ WHERE r0_.performer_id = ? ORDER BY r0_.created_at DESC LIMIT 10
Parameters:
[
  306
]
4 0.50 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.grade AS grade_2, r0_.descr AS descr_3, r0_.user_id AS user_id_4, r0_.performer_id AS performer_id_5, r0_.orders_id AS orders_id_6 FROM review r0_ WHERE r0_.performer_id = ? AND r0_.id IN (?) ORDER BY r0_.created_at DESC
Parameters:
[
  306
  92
]
5 0.59 ms
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.id = ?
Parameters:
[
  316
]

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.