GET https://master.tajsoft.tj/api/performer/get/task/?category_id=7&limit=10&page=1

Query Metrics

26 Database Queries
7 Different statements
13.10 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 1.88 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 1.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.lang_id AS lang_id_6 FROM city t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 1.75 ms
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.descr AS descr_2, o0_.img AS img_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.price AS price_6, o0_.is_contract AS is_contract_7, o0_.type AS type_8, o0_.created_add AS created_add_9, o0_.status AS status_10, o0_.is_deleted AS is_deleted_11, o0_.category_id AS category_id_12, o0_.user_id AS user_id_13, o0_.master_id AS master_id_14 FROM orders o0_ WHERE o0_.category_id = ? ORDER BY o0_.type DESC
Parameters:
[
  7
]
4 1.10 ms
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM orders o0_ WHERE o0_.category_id = ?
Parameters:
[
  7
]
5 0.43 ms
SELECT DISTINCT o0_.id AS id_0, o0_.type AS type_1 FROM orders o0_ WHERE o0_.category_id = ? ORDER BY o0_.type DESC LIMIT 10
Parameters:
[
  7
]
6 0.91 ms
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.descr AS descr_2, o0_.img AS img_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.price AS price_6, o0_.is_contract AS is_contract_7, o0_.type AS type_8, o0_.created_add AS created_add_9, o0_.status AS status_10, o0_.is_deleted AS is_deleted_11, o0_.category_id AS category_id_12, o0_.user_id AS user_id_13, o0_.master_id AS master_id_14 FROM orders o0_ WHERE o0_.category_id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.type DESC
Parameters:
[
  7
  47
  49
  55
  56
  59
  60
  61
  62
  73
  84
]
7 0.47 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"
]
8 0.99 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:
[
  7
  2
]
9 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"
]
10 0.62 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:
[
  7
  2
]
11 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"
]
12 0.31 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:
[
  7
  2
]
13 0.18 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"
]
14 0.25 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:
[
  7
  2
]
15 0.17 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"
]
16 0.23 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:
[
  7
  2
]
17 0.15 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"
]
18 0.24 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:
[
  7
  2
]
19 0.16 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.22 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:
[
  7
  2
]
21 0.14 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"
]
22 0.25 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:
[
  7
  2
]
23 0.19 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"
]
24 0.25 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:
[
  7
  2
]
25 0.17 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"
]
26 0.26 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:
[
  7
  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\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\Orders No errors.
App\Entity\Category 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\Review
  • The association App\Entity\Review#performer refers to the inverse side field App\Entity\User#performers which does not exist.