Query Metrics
5
Database Queries
5
Different statements
7.33 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.58 ms (76.06%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.58 ms (7.89%) |
1 |
SELECT j0_.id AS id_0, j0_.kind AS kind_1, j0_.completed_at_timestamp AS completed_at_timestamp_2, j0_.estimated_timescale_in_minutes AS estimated_timescale_in_minutes_3, j0_.specification AS specification_4, j0_.reviewed_at_timestamp AS reviewed_at_timestamp_5, j0_.stock_status AS stock_status_6, j0_.created_at_timestamp AS created_at_timestamp_7, j0_.updated_at_timestamp AS updated_at_timestamp_8, j0_.status AS status_9, j0_.booked_at_timestamp AS booked_at_timestamp_10, j0_.metadata AS metadata_11, j0_.arrival_timestamp AS arrival_timestamp_12, j0_.leaving_timestamp AS leaving_timestamp_13, j0_.display_id AS display_id_14, j0_.project_id AS project_id_15, j0_.reviewed_by_user_id AS reviewed_by_user_id_16, j0_.trainer_user_id AS trainer_user_id_17, j0_.quote_product_id AS quote_product_id_18, j0_.assigned_items_id AS assigned_items_id_19, j0_.created_by_user_id AS created_by_user_id_20, j0_.last_updated_by_user_id AS last_updated_by_user_id_21, j0_.assigned_user_id AS assigned_user_id_22 FROM job j0_ WHERE j0_.trainer_user_id = ? AND j0_.booked_at_timestamp IS NOT NULL ORDER BY j0_.booked_at_timestamp ASC
Parameters:
[
16
]
|
|
0.53 ms (7.17%) |
1 |
UPDATE user SET last_activity_timestamp = ? WHERE id = ?
Parameters:
[ 1781693197 16 ] |
|
0.47 ms (6.48%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
16
]
|
|
0.18 ms (2.40%) |
1 |
"START TRANSACTION"
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 |
|---|---|
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Job | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\QuoteProduct | No errors. |
| App\Entity\Stock\AssignedItems | No errors. |