GET https://www.it-schlamassel.ch/

Query Metrics

4 Database Queries
2 Different statements
1.14 ms Query time
1 Invalid entities
5 Managed entities

Queries

Group similar statements

# 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
  • The field App\Entity\Ticket#comments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TicketComment#ticket does not contain the required 'inversedBy: "comments"' attribute.
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.