GET http://admin-symfony-review.kube-dev.ugol.click/work?page=1&sort%5Bname%5D=DESC

Query Metrics

23 Database Queries
4 Different statements
16.64 ms Query time
4 Invalid entities
50 Managed entities

Grouped Statements

Show all queries

Time Count Info
9.47 ms
(56.94%)
20
SELECT t0.price_id AS price_id_1, t0.created_at AS created_at_2, t0.deleted_at AS deleted_at_3, t0.key AS key_4, t0.price AS price_5, t0.current AS current_6, t0.work_id AS work_id_7 FROM work_prices t0 WHERE t0.work_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  7
]
5.84 ms
(35.08%)
1
SELECT DISTINCT w0_.work_id AS work_id_0, w0_.name AS name_1 FROM work_works w0_ WHERE (w0_.deleted_at IS NULL) ORDER BY w0_.name DESC LIMIT 20
Parameters:
[]
1.01 ms
(6.06%)
1
SELECT w0_.work_id AS work_id_0, w0_.created_at AS created_at_1, w0_.deleted_at AS deleted_at_2, w0_.key AS key_3, w0_.name AS name_4, w0_.type_id AS type_id_5, w0_.group_id AS group_id_6 FROM work_works w0_ WHERE (w0_.work_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (w0_.deleted_at IS NULL) ORDER BY w0_.name DESC
Parameters:
[
  7
  25
  3
  20
  5
  11
  15
  21
  18
  29
  30
  2
  10
  8
  26
  1
  27
  16
  14
  17
]
0.32 ms
(1.92%)
1
SELECT count(*) AS sclr_0 FROM work_works w0_ WHERE (w0_.deleted_at IS NULL)
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Work\Entity\Work 20
Work\Entity\Price 20
Work\Entity\Group 10

Entities Mapping

Class Mapping errors
Work\Entity\Work
  • The field Work\Entity\Work#prices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Work\Entity\Price#work does not contain the required 'inversedBy: "prices"' attribute.
Work\Entity\Type No errors.
Work\Entity\GroupTree No errors.
Work\Entity\Group
  • The field Work\Entity\Group#works is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Work\Entity\Work#group does not contain the required 'inversedBy: "works"' attribute.
Work\Entity\WorkMaterial
  • The field 'Work\Entity\WorkMaterial#count' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Work\Entity\Price
  • The field 'Work\Entity\Price#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.