Query Metrics
36
Database Queries
8
Different statements
21.35 ms
Query time
3
Invalid entities
519
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.37 ms (34.53%) |
27 |
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:
[
80
]
|
|
5.46 ms (25.57%) |
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_.booked_at_timestamp IS NOT NULL AND j0_.booked_at_timestamp >= ? AND j0_.booked_at_timestamp < ? AND j0_.assigned_user_id IS NULL ORDER BY j0_.booked_at_timestamp ASC
Parameters:
[ 1762992000 1763078400 ] |
|
4.51 ms (21.12%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.48 ms (6.95%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.start_date_timestamp AS start_date_timestamp_3, t0.end_date_timestamp AS end_date_timestamp_4, t0.description AS description_5, t0.address_lines AS address_lines_6, t0.address_town AS address_town_7, t0.address_postcode AS address_postcode_8, t0.address_county AS address_county_9, t0.address_country AS address_country_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.created_at_timestamp AS created_at_timestamp_13, t0.updated_at_timestamp AS updated_at_timestamp_14, t0.assigned_user_id AS assigned_user_id_15, t0.created_by_user_id AS created_by_user_id_16, t0.last_updated_by_user_id AS last_updated_by_user_id_17 FROM misc_calendar_event t0
Parameters:
[] |
|
1.00 ms (4.68%) |
2 |
SELECT t0.id AS id_1, t0.requirements AS requirements_2, t0.source AS source_3, t0.stairlift_condition AS stairlift_condition_4, t0.staircase AS staircase_5, t0.external_id AS external_id_6, t0.external_distribution_id AS external_distribution_id_7, t0.lead_type AS lead_type_8, t0.extended_warranty AS extended_warranty_9, t0.status AS status_10, t0.created_at_timestamp AS created_at_timestamp_11, t0.updated_at_timestamp AS updated_at_timestamp_12, t0.metadata AS metadata_13, t0.customer_id AS customer_id_14, t0.brand_id AS brand_id_15, t0.api_user_id AS api_user_id_16, t0.assigned_user_id AS assigned_user_id_17 FROM project t0 WHERE t0.id = ?
Parameters:
[
18439
]
|
|
0.85 ms (3.98%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.additional_name AS additional_name_3, t0.stripe_id AS stripe_id_4, t0.address_lines AS address_lines_5, t0.address_town AS address_town_6, t0.address_postcode AS address_postcode_7, t0.address_county AS address_county_8, t0.address_country AS address_country_9, t0.created_at_timestamp AS created_at_timestamp_10, t0.updated_at_timestamp AS updated_at_timestamp_11, t0.contact_number AS contact_number_12, t0.e164_contact_number AS e164_contact_number_13, t0.email_address AS email_address_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.display_id AS display_id_17, t0.created_by_user_id AS created_by_user_id_18, t0.last_updated_by_user_id AS last_updated_by_user_id_19, t0.xero_guid_id AS xero_guid_id_20 FROM customer t0 WHERE t0.id = ?
Parameters:
[
18406
]
|
|
0.50 ms (2.35%) |
1 |
UPDATE user SET last_activity_timestamp = ? WHERE id = ?
Parameters:
[ 1782292458 80 ] |
|
0.17 ms (0.82%) |
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\MiscCalendarEvent | 479 |
| App\Entity\User | 30 |
| App\Entity\Job | 2 |
| App\Entity\Project | 2 |
| App\Entity\Stock\AssignedItems | 2 |
| App\Entity\Customer | 2 |
| App\Entity\ApiUser | 2 |
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. |
| App\Entity\Stock\PickOrder | No errors. |
| App\Entity\Stock\ReturnRequest | No errors. |
| App\Entity\Stock\CourierReceipt | No errors. |
| App\Entity\Customer |
|
| App\Entity\Brand | No errors. |
| App\Entity\ApiUser | No errors. |
| App\Entity\ProjectNote | No errors. |
| App\Entity\Quote |
|
| App\Entity\PurchaseOrder | No errors. |
| App\Entity\ProjectFile | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Xero\XeroGuid | No errors. |
| App\Entity\PhoneCall | No errors. |
| App\Entity\Warranty | No errors. |
| App\Entity\Stock\Item | No errors. |
| App\Entity\Complaint | No errors. |
| App\Entity\MiscCalendarEvent |
|