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

Grouped Statements

Show all queries

Time Count Info
4.82 ms
(18.50%)
10
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
]
3.99 ms
(15.33%)
10
SELECT COUNT(*) FROM orders_performers t0 WHERE t0.performers_id = ? AND t0.status = ?
Parameters:
[
  393
  3
]
3.93 ms
(15.09%)
10
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
]
3.62 ms
(13.87%)
10
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
]
3.53 ms
(13.53%)
11
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"
]
1.97 ms
(7.58%)
1
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
]
1.43 ms
(5.48%)
1
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
]
1.22 ms
(4.69%)
1
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
]
0.89 ms
(3.40%)
1
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
]
0.66 ms
(2.53%)
1
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
]

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.