https://munka.gortech.hu/admin?crudAction=actionBatch&crudControllerFqcn=App%5CController%5CAdmin%5CWorkersCrudController&entityId=2&menuIndex=12&referrer=https%3A%2F%2Fmunka.gortech.hu%2Fadmin%3FcrudAction%3Dindex%26crudControllerFqcn%3DApp%255CController%255CAdmin%255CWorkersCrudController%26menuIndex%3D12%26signature%3DsxtT_f_OjD7zNJglvcKiYnFt5Rqo5iT1_2n353U3ARs%26submenuIndex%3D-1&signature=VQ5V9EgETZNS53voL7teoS6dbJmHGlSg58d_lmm35aI&submenuIndex=-1 Return to referer URL

Query Metrics

100 Database Queries
10 Different statements
76.24 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
52.18 ms
(68.44%)
23
"COMMIT"
Parameters:
[]
7.20 ms
(9.44%)
1
SELECT w0_.id AS id_0, w0_.payed AS payed_1, w0_.created AS created_2, w0_.payed_hour_price AS payed_hour_price_3, w0_.hours AS hours_4, w0_.day AS day_5, w0_.note AS note_6, w0_.other_price AS other_price_7, w0_.validated_date AS validated_date_8, w0_.is_validated AS is_validated_9, w0_.worker_id AS worker_id_10, w0_.project_id AS project_id_11, w0_.project_product_id AS project_product_id_12, w0_.validated_id AS validated_id_13 FROM work_hours w0_ WHERE w0_.worker_id = ? AND w0_.payed IS NULL
Parameters:
[
  "2"
]
6.90 ms
(9.04%)
23
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 = ? LIMIT 1
Parameters:
[
  "7232"
]
5.62 ms
(7.37%)
23
UPDATE work_hours SET payed = ?, payed_hour_price = ? WHERE id = ?
Parameters:
[
  "2026-09-01"
  3000
  7232
]
2.71 ms
(3.55%)
23
"START TRANSACTION"
Parameters:
[]
0.63 ms
(0.82%)
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:
[
  4
]
0.33 ms
(0.43%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.deadline AS deadline_3, t0.closed AS closed_4, t0.created AS created_5, t0.description AS description_6, t0.price_netto AS price_netto_7, t0.is_closed AS is_closed_8, t0.customer_id AS customer_id_9 FROM projects t0 WHERE t0.id = ?
Parameters:
[
  120
]
0.28 ms
(0.36%)
2
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:
[
  107
]
0.22 ms
(0.29%)
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 = ?
Parameters:
[
  2
]
0.19 ms
(0.25%)
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:
[
  "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\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.