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

Grouped Statements

Show all queries

Time Count Info
4.01 ms
(30.63%)
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"
]
3.62 ms
(27.64%)
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:
[
  7
  2
]
1.75 ms
(13.38%)
1
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
]
1.28 ms
(9.75%)
1
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
]
1.10 ms
(8.37%)
1
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM orders o0_ WHERE o0_.category_id = ?
Parameters:
[
  7
]
0.91 ms
(6.92%)
1
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
]
0.43 ms
(3.31%)
1
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
]

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.