Query Metrics
14
Database Queries
14
Different statements
25.29 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.88 ms (27.21%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.phone AS phone_16, t0.vacation_days AS vacation_days_17 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3
]
|
|
4.36 ms (17.23%) |
1 |
SELECT sum(t0_.worked_minutes) AS sclr_0 FROM task t0_ WHERE t0_.project_id = ?
Parameters:
[
46
]
|
|
2.48 ms (9.79%) |
1 |
SELECT sum(t0_.worked_minutes) AS sclr_0 FROM task_log t0_ WHERE t0_.task_id = ?
Parameters:
[
5091
]
|
|
2.46 ms (9.71%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
2.29 ms (9.05%) |
1 |
UPDATE project SET worked_hours = ?, hourly_rate = ?, updated_at = ? WHERE id = ?
Parameters:
[ 30257 16.0 "2026-08-27 08:22:23" 46 ] |
|
1.98 ms (7.83%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM task_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
1.94 ms (7.66%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.95 ms (3.74%) |
1 |
SELECT t0.id AS id_1, t0.due_date AS due_date_2, t0.worked_minutes AS worked_minutes_3, t0.description AS description_4, t0.task_id AS task_id_5, t0.user_id AS user_id_6 FROM task_log t0 WHERE t0.id = ?
Parameters:
[
7446
]
|
|
0.40 ms (1.60%) |
1 |
UPDATE task_log SET due_date = ?, worked_minutes = ? WHERE id = ?
Parameters:
[ "2026-08-26 00:00:00" 49 7446 ] |
|
0.37 ms (1.45%) |
1 |
SELECT t0.name AS name_1, t0.technical_description AS technical_description_2, t0.scheduled_hours AS scheduled_hours_3, t0.priotity AS priotity_4, t0.schedule_date AS schedule_date_5, t0.offer_value AS offer_value_6, t0.billable_value AS billable_value_7, t0.worked_minutes AS worked_minutes_8, t0.not_used AS not_used_9, t0.not_used_minutes AS not_used_minutes_10, t0.finished_date AS finished_date_11, t0.order_task AS order_task_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.task_owner_id AS task_owner_id_16, t0.assigned_user_id AS assigned_user_id_17, t0.task_status_id AS task_status_id_18, t0.project_id AS project_id_19, t0.currency_id AS currency_id_20, t0.task_type_id AS task_type_id_21, t0.offer_body_id AS offer_body_id_22, t0.tranche_id AS tranche_id_23, t0.not_used_parent_id AS not_used_parent_id_24 FROM task t0 WHERE t0.id = ?
Parameters:
[
5091
]
|
|
0.34 ms (1.33%) |
1 |
SELECT t0.name AS name_1, t0.price AS price_2, t0.scheduled_hours AS scheduled_hours_3, t0.worked_hours AS worked_hours_4, t0.url AS url_5, t0.end_date AS end_date_6, t0.description AS description_7, t0.security_data AS security_data_8, t0.deadline AS deadline_9, t0.hourly_rate AS hourly_rate_10, t0.contact_person_name AS contact_person_name_11, t0.contact_person_email AS contact_person_email_12, t0.contact_person_phone AS contact_person_phone_13, t0.id AS id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.company_id AS company_id_17, t0.project_type_id AS project_type_id_18, t0.status_id AS status_id_19, t0.currency_id AS currency_id_20, t0.project_manager_id AS project_manager_id_21 FROM project t0 WHERE t0.id = ?
Parameters:
[
46
]
|
|
0.31 ms (1.24%) |
1 |
SELECT t0.id AS id_1, t0.due_date AS due_date_2, t0.worked_minutes AS worked_minutes_3, t0.description AS description_4, t0.task_id AS task_id_5, t0.user_id AS user_id_6 FROM task_log t0 WHERE t0.task_id = ?
Parameters:
[
5091
]
|
|
0.30 ms (1.19%) |
1 |
UPDATE task SET worked_minutes = ?, updated_at = ? WHERE id = ?
Parameters:
[ 126 "2026-08-27 08:22:23" 5091 ] |
|
0.25 ms (0.97%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM task_status t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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 |
|---|---|
| Sonata\UserBundle\Entity\BaseUser | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Base\AbstractEntity | No errors. |
| App\Entity\Base\AbstractTimestampableEntity | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\TaskLog | No errors. |
| App\Entity\CashOut | No errors. |
| App\Entity\AnualLeave | No errors. |
| App\Entity\TaskStatus | No errors. |
| App\Entity\Project |
|
| App\Entity\Currency | No errors. |
| App\Entity\TaskType | No errors. |
| App\Entity\OfferBody | No errors. |
| App\Entity\Tranche | No errors. |
| App\Entity\Contract |
|
| App\Entity\Unit | No errors. |
| App\Entity\ProjectType |
|
| App\Entity\Company |
|
| App\Entity\ContractStatus | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\County | No errors. |
| App\Entity\City | No errors. |
| App\Entity\CompanyType | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\OfferStatus | No errors. |
| App\Entity\ProjectStatus | No errors. |
| App\Entity\CashIn | No errors. |