GET https://projects.cuetime.de/appointments/new

Query Metrics

5 Database Queries
5 Different statements
2.13 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.49 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.prename AS prename_3, u0_.lastname AS lastname_4, u0_.roles AS roles_5, u0_.password AS password_6 FROM user u0_
Parameters:
[]
2 0.23 ms
SELECT c0_.id AS id_0, c0_.prename AS prename_1, c0_.lastname AS lastname_2, c0_.street AS street_3, c0_.housenr AS housenr_4, c0_.postal AS postal_5, c0_.city AS city_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.require_cash AS require_cash_9, c0_.require_prepaid AS require_prepaid_10, c0_.payment_id AS payment_id_11 FROM customer c0_
Parameters:
[]
3 0.18 ms
SELECT l0_.id AS id_0, l0_.location_name AS location_name_1, l0_.street AS street_2, l0_.streetnr AS streetnr_3, l0_.postal AS postal_4, l0_.city AS city_5, l0_.notes AS notes_6, l0_.contact_id_id AS contact_id_id_7 FROM location l0_
Parameters:
[]
4 0.13 ms
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM payment p0_
Parameters:
[]
5 0.10 ms
SELECT c0_.id AS id_0, c0_.prename AS prename_1, c0_.lastname AS lastname_2, c0_.email AS email_3, c0_.phone AS phone_4 FROM contacts c0_
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.

Entities Mapping

Class Mapping errors
App\Entity\Customer
  • The association App\Entity\Customer#appointments refers to the owning side field App\Entity\Appointments#customer_id which does not exist.
App\Entity\Location
  • The association App\Entity\Location#appointments refers to the owning side field App\Entity\Appointments#location_id which does not exist.
App\Entity\User No errors.
App\Entity\Appointments
  • The mappings App\Entity\Appointments#customer and App\Entity\Customer#appointments are inconsistent with each other.
  • The mappings App\Entity\Appointments#location and App\Entity\Location#appointments are inconsistent with each other.
App\Entity\Payment No errors.
App\Entity\Contacts No errors.
App\Entity\Order No errors.
App\Entity\LocationImages No errors.