Query Metrics

11 Database Queries
6 Different statements
2.81 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.20 ms
(42.63%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.note AS note_4, t0.created AS created_5, t0.phone AS phone_6, t0.email AS email_7 FROM customers t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.55 ms
(19.64%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.display_name AS display_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.modified AS modified_7, t0.worker_id AS worker_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.38 ms
(13.45%)
1
SELECT t0.id AS id_1, t0.payed AS payed_2, t0.created AS created_3, t0.payed_hour_price AS payed_hour_price_4, t0.hours AS hours_5, t0.day AS day_6, t0.note AS note_7, t0.other_price AS other_price_8, t0.validated_date AS validated_date_9, t0.is_validated AS is_validated_10, t0.worker_id AS worker_id_11, t0.project_id AS project_id_12, t0.project_product_id AS project_product_id_13, t0.validated_id AS validated_id_14 FROM work_hours t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[]
0.29 ms
(10.43%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.deadline AS deadline_2, p0_.closed AS closed_3, p0_.created AS created_4, p0_.description AS description_5, p0_.price_netto AS price_netto_6, p0_.is_closed AS is_closed_7, p0_.customer_id AS customer_id_8 FROM projects p0_ INNER JOIN projects_workers p2_ ON p0_.id = p2_.projects_id INNER JOIN workers w1_ ON w1_.id = p2_.workers_id WHERE w1_.id = ? AND (p0_.is_closed IS NULL OR p0_.is_closed = 0)
Parameters:
[
  14
]
0.25 ms
(8.76%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.full_name AS full_name_3, t0.price_hour AS price_hour_4, t0.price_month AS price_month_5, t0.created AS created_6, t0.active AS active_7, t0.contribution AS contribution_8, t9.id AS id_10, t9.username AS username_11, t9.display_name AS display_name_12, t9.email AS email_13, t9.roles AS roles_14, t9.password AS password_15, t9.modified AS modified_16, t9.worker_id AS worker_id_17 FROM workers t0 LEFT JOIN user t9 ON t9.worker_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  14
]
0.14 ms
(5.09%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.note AS note_2, p0_.est_hour AS est_hour_3, p0_.net_price AS net_price_4, p0_.created AS created_5, p0_.qty AS qty_6, p0_.qty_finish AS qty_finish_7, p0_.closed AS closed_8, p0_.is_closed AS is_closed_9, p0_.project_id AS project_id_10 FROM project_products p0_ INNER JOIN projects p1_ ON p0_.project_id = p1_.id INNER JOIN projects_workers p3_ ON p1_.id = p3_.projects_id INNER JOIN workers w2_ ON w2_.id = p3_.workers_id WHERE w2_.id = ? AND (p0_.is_closed IS NULL OR p0_.is_closed = 0)
Parameters:
[
  14
]

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\User No errors.
App\Entity\Workers No errors.
App\Entity\Attachment No errors.
App\Entity\WorkHours No errors.
App\Entity\Projects No errors.
App\Entity\ProjectProducts No errors.
App\Entity\Customers No errors.
App\Entity\Photo No errors.
App\Entity\Material No errors.
App\Entity\Contracts No errors.