POST https://test-servicebox.bbox.hu/ajax/app/worksheets/get

Query Metrics

3 Database Queries
3 Different statements
1.65 ms Query time
0 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.02 ms
(62.00%)
1
SELECT DISTINCT count(w0_.id) AS sclr_0 FROM worksheet w0_ LEFT JOIN user u1_ ON w0_.user_id = u1_.id LEFT JOIN partner p2_ ON w0_.partner_id = p2_.id WHERE w0_.is_deleted = 0 AND (w0_.status <> 'draft' OR w0_.created_by_id = ?) AND w0_.is_deleted = 0
Parameters:
[
  4
]
0.40 ms
(24.06%)
1
SELECT DISTINCT w0_.id AS id_0, w0_.natura_api_status AS natura_api_status_1, w0_.natura_api_status_comment AS natura_api_status_comment_2, w0_.is_closing_email_opened AS is_closing_email_opened_3, w0_.is_closing_email_sent AS is_closing_email_sent_4, u1_.name AS name_5, p2_.name AS name_6, p2_.external_id AS external_id_7, w0_.created_at AS created_at_8, w0_.is_deleted AS is_deleted_9, w0_.type AS type_10, w0_.status AS status_11 FROM worksheet w0_ LEFT JOIN user u1_ ON w0_.user_id = u1_.id LEFT JOIN partner p2_ ON w0_.partner_id = p2_.id WHERE (w0_.status <> 'draft' OR w0_.created_by_id = ?) AND w0_.is_deleted = 0 ORDER BY w0_.id DESC LIMIT 50
Parameters:
[
  4
]
0.23 ms
(13.94%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.email AS email_4, t0.is_enabled AS is_enabled_5, t0.is_deleted AS is_deleted_6, t0.locale AS locale_7, t0.last_login AS last_login_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  4
]

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
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\WorksheetHistory No errors.
App\Entity\Vehicle No errors.
App\Entity\Worksheet No errors.
App\Entity\Partner No errors.