Error 500 Internal Server Error

GET https://master.tajsoft.tj/api/dashboard/categories

Query Metrics

234 Database Queries
6 Different statements
218.30 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time Count Info
59.26 ms
(27.15%)
55
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 INNER JOIN user_category ON t0.id = user_category.user_id WHERE user_category.category_id = ?
Parameters:
[
  158
]
58.17 ms
(26.64%)
55
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.parent_id = ?
Parameters:
[
  6
]
47.27 ms
(21.65%)
57
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:
[
  158
  2
]
42.48 ms
(19.46%)
58
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.07 ms
(4.61%)
8
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:
[
  6
]
1.06 ms
(0.48%)
1
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.img AS img_2 FROM statistics s1_ INNER JOIN category c0_ ON s1_.category_id = c0_.id WHERE s1_.type = ? LIMIT 10
Parameters:
[
  1
]

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\Statistics No errors.
App\Entity\Category 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\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.
App\Entity\OrdersPerformers
  • The association App\Entity\OrdersPerformers#performers refers to the inverse side field App\Entity\User#ordersPerformers which does not exist.