Error 500 Internal Server Error

GET https://master.tajsoft.tj/api/master/get/3

Query Metrics

56 Database Queries
10 Different statements
26.06 ms Query time
8 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
2 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  3
]
3 1.97 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.birthday AS birthday_3, u0_.gender AS gender_4, u0_.img AS img_5, u0_.phone_number AS phone_number_6, u0_.balance AS balance_7, u0_.work_experience AS work_experience_8, u0_.self AS self_9, u0_.role AS role_10, u0_.token AS token_11, u0_.latitude AS latitude_12, u0_.longitude AS longitude_13, u0_.push_token AS push_token_14, u0_.work_imgs AS work_imgs_15, u0_.city_name AS city_name_16, u0_.register_date AS register_date_17, u0_.ban_text AS ban_text_18, u0_.b AS b_19, u0_.city_id AS city_id_20, u0_.lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = ? AND u0_.role = ?
Parameters:
[
  3
  2
]
4 1.22 ms
SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = ? AND u0_.role = ?
Parameters:
[
  3
  2
]
5 0.66 ms
SELECT DISTINCT u0_.id AS id_0 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = ? AND u0_.role = ? LIMIT 10
Parameters:
[
  3
  2
]
6 1.43 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.surname AS surname_2, u0_.birthday AS birthday_3, u0_.gender AS gender_4, u0_.img AS img_5, u0_.phone_number AS phone_number_6, u0_.balance AS balance_7, u0_.work_experience AS work_experience_8, u0_.self AS self_9, u0_.role AS role_10, u0_.token AS token_11, u0_.latitude AS latitude_12, u0_.longitude AS longitude_13, u0_.push_token AS push_token_14, u0_.work_imgs AS work_imgs_15, u0_.city_name AS city_name_16, u0_.register_date AS register_date_17, u0_.ban_text AS ban_text_18, u0_.b AS b_19, u0_.city_id AS city_id_20, u0_.lang_id AS lang_id_21 FROM user u0_ INNER JOIN user_category u2_ ON u0_.id = u2_.user_id INNER JOIN category c1_ ON c1_.id = u2_.category_id WHERE c1_.id = ? AND u0_.role = ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  3
  2
  393
  422
  448
  450
  455
  456
  457
  458
  459
  460
]
7 0.81 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  393
]
8 0.87 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  393
  3
]
9 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
10 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  393
]
11 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
12 0.37 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  422
]
13 0.31 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  422
  3
]
14 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
15 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  422
]
16 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
17 0.30 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  448
]
18 0.30 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  448
  3
]
19 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
20 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  448
]
21 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
22 0.30 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  450
]
23 0.31 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  450
  3
]
24 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
25 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  450
]
26 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
27 0.28 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  455
]
28 0.85 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  455
  3
]
29 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
30 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  455
]
31 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
32 0.31 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  456
]
33 0.27 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  456
  3
]
34 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
35 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  456
]
36 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
37 0.32 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  457
]
38 0.26 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  457
  3
]
39 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
40 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  457
]
41 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
42 0.30 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  458
]
43 0.26 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  458
  3
]
44 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
45 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  458
]
46 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
47 0.34 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  459
]
48 0.25 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  459
  3
]
49 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
50 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  459
]
51 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]
52 0.28 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.grade AS grade_3, t0.descr AS descr_4, t0.user_id AS user_id_5, t0.performer_id AS performer_id_6, t0.orders_id AS orders_id_7 FROM review t0 WHERE t0.performer_id = ?
Parameters:
[
  460
]
53 0.31 ms
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  460
  3
]
54 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3 FROM lang t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ru"
]
55 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.parent_id AS parent_id_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN user_category ON t0.id = user_category.category_id WHERE user_category.user_id = ?
Parameters:
[
  460
]
56 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3, t0.lang_id AS lang_id_4 FROM category_translate t0 WHERE t0.category_id = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  3
  2
]

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\Lang
  • The mappings App\Entity\Lang#fAQTranslates and App\Entity\FAQTranslate#lang are inconsistent with each other.
App\Entity\CategoryTranslate No 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\NotificationTranslate No errors.
App\Entity\FAQ No errors.
App\Entity\AboutUs No errors.
App\Entity\FAQTranslate No errors.
App\Entity\AboutUsTranslate No errors.
App\Entity\Category No errors.
App\Entity\Statistics No errors.
App\Entity\Orders No errors.
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\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.
App\Entity\OrdersPerformers
  • The association App\Entity\OrdersPerformers#performers refers to the inverse side field App\Entity\User#ordersPerformers which does not exist.
App\Entity\Notifications
  • The association App\Entity\Notifications#user refers to the inverse side field App\Entity\User#notifications which does not exist.
  • The mappings App\Entity\Notifications#translations and App\Entity\NotificationTranslate#notification are inconsistent with each other.