GET https://projects.cuetime.de/appointments/5/edit

Query Metrics

9 Database Queries
9 Different statements
1.95 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.95 ms
SELECT t0.id AS id_1, t0.occasion AS occasion_2, t0.date AS date_3, t0.start_time AS start_time_4, t0.end_time AS end_time_5, t0.is_confirmed AS is_confirmed_6, t0.setup_with_location AS setup_with_location_7, t0.teardown_with_location AS teardown_with_location_8, t0.setup_date AS setup_date_9, t0.setup_time AS setup_time_10, t0.teardown_date AS teardown_date_11, t0.teardown_time AS teardown_time_12, t0.attendees_count AS attendees_count_13, t0.attendees_age_from AS attendees_age_from_14, t0.attendees_age_to AS attendees_age_to_15, t0.attendees_notes AS attendees_notes_16, t0.music_pdf_path AS music_pdf_path_17, t0.dj_notes AS dj_notes_18, t0.price_dj_hour AS price_dj_hour_19, t0.price_dj_extention AS price_dj_extention_20, t0.price_tech AS price_tech_21, t0.price_approach AS price_approach_22, t0.deactivated AS deactivated_23, t0.customer_id AS customer_id_24, t0.location_id AS location_id_25 FROM appointments t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
2 0.22 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:
[]
3 0.16 ms
SELECT t0.id AS id_1, t0.prename AS prename_2, t0.lastname AS lastname_3, t0.street AS street_4, t0.housenr AS housenr_5, t0.postal AS postal_6, t0.city AS city_7, t0.email AS email_8, t0.phone AS phone_9, t0.require_cash AS require_cash_10, t0.require_prepaid AS require_prepaid_11, t0.payment_id AS payment_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  7
]
4 0.12 ms
SELECT t0.id AS id_1, t0.location_name AS location_name_2, t0.street AS street_3, t0.streetnr AS streetnr_4, t0.postal AS postal_5, t0.city AS city_6, t0.notes AS notes_7, t0.contact_id_id AS contact_id_id_8 FROM location t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.10 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.prename AS prename_4, t0.lastname AS lastname_5, t0.roles AS roles_6, t0.password AS password_7 FROM user t0 INNER JOIN appointments_user ON t0.id = appointments_user.user_id WHERE appointments_user.appointments_id = ?
Parameters:
[
  5
]
6 0.13 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:
[]
7 0.10 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:
[]
8 0.08 ms
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM payment p0_
Parameters:
[]
9 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\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\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\Order No errors.
App\Entity\Payment No errors.
App\Entity\Contacts No errors.
App\Entity\LocationImages No errors.