Query Metrics
4
Database Queries
2
Different statements
1.14 ms
Query time
1
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.45 ms |
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.priority AS priority_4, t0_.created_at AS created_at_5, t0_.closed_at AS closed_at_6, t0_.due_at AS due_at_7, t0_.assigned_to_id AS assigned_to_id_8, t0_.created_by_id AS created_by_id_9, t0_.assigned_by_id AS assigned_by_id_10, t0_.closed_by_id AS closed_by_id_11, t0_.due_by_id AS due_by_id_12 FROM ticket t0_ WHERE LOWER(t0_.status) IN (?, ?) ORDER BY t0_.created_at DESC, t0_.id DESC LIMIT 10
Parameters:
[ "open" "in_progress" ] |
| 2 | 0.32 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.payable_until AS payable_until_3, t0.label AS label_4, t0.discount AS discount_5, t0.vat AS vat_6, t0.amount AS amount_7, t0.invoice_number AS invoice_number_8, t0.billing_name AS billing_name_9, t0.billing_street AS billing_street_10, t0.billing_postal_code AS billing_postal_code_11, t0.billing_city AS billing_city_12, t0.billing_country AS billing_country_13, t0.generated_at AS generated_at_14, t0.pdf_path AS pdf_path_15, t0.ticket_id AS ticket_id_16 FROM invoice t0 WHERE t0.ticket_id = ?
Parameters:
[
13
]
|
| 3 | 0.23 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.payable_until AS payable_until_3, t0.label AS label_4, t0.discount AS discount_5, t0.vat AS vat_6, t0.amount AS amount_7, t0.invoice_number AS invoice_number_8, t0.billing_name AS billing_name_9, t0.billing_street AS billing_street_10, t0.billing_postal_code AS billing_postal_code_11, t0.billing_city AS billing_city_12, t0.billing_country AS billing_country_13, t0.generated_at AS generated_at_14, t0.pdf_path AS pdf_path_15, t0.ticket_id AS ticket_id_16 FROM invoice t0 WHERE t0.ticket_id = ?
Parameters:
[
12
]
|
| 4 | 0.14 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.payable_until AS payable_until_3, t0.label AS label_4, t0.discount AS discount_5, t0.vat AS vat_6, t0.amount AS amount_7, t0.invoice_number AS invoice_number_8, t0.billing_name AS billing_name_9, t0.billing_street AS billing_street_10, t0.billing_postal_code AS billing_postal_code_11, t0.billing_city AS billing_city_12, t0.billing_country AS billing_country_13, t0.generated_at AS generated_at_14, t0.pdf_path AS pdf_path_15, t0.ticket_id AS ticket_id_16 FROM invoice t0 WHERE t0.ticket_id = ?
Parameters:
[
10
]
|
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\Ticket | 3 |
| App\Entity\User | 1 |
| App\Entity\Person | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Ticket |
|
| App\Entity\User | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\TicketComment | No errors. |
| App\Entity\Attachment | No errors. |
| App\Entity\Invoice | No errors. |