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

Query Metrics

6 Database Queries
4 Different statements
2.06 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.41 ms
SELECT a0_.id AS id_0, a0_.occasion AS occasion_1, a0_.date AS date_2, a0_.start_time AS start_time_3, a0_.end_time AS end_time_4, a0_.is_confirmed AS is_confirmed_5, a0_.setup_with_location AS setup_with_location_6, a0_.teardown_with_location AS teardown_with_location_7, a0_.setup_date AS setup_date_8, a0_.setup_time AS setup_time_9, a0_.teardown_date AS teardown_date_10, a0_.teardown_time AS teardown_time_11, a0_.attendees_count AS attendees_count_12, a0_.attendees_age_from AS attendees_age_from_13, a0_.attendees_age_to AS attendees_age_to_14, a0_.attendees_notes AS attendees_notes_15, a0_.music_pdf_path AS music_pdf_path_16, a0_.dj_notes AS dj_notes_17, a0_.price_dj_hour AS price_dj_hour_18, a0_.price_dj_extention AS price_dj_extention_19, a0_.price_tech AS price_tech_20, a0_.price_approach AS price_approach_21, a0_.deactivated AS deactivated_22, a0_.customer_id AS customer_id_23, a0_.location_id AS location_id_24 FROM appointments a0_ WHERE a0_.deactivated = 0
Parameters:
[]
2 0.22 ms
SELECT a0_.id AS id_0, a0_.occasion AS occasion_1, a0_.date AS date_2, a0_.start_time AS start_time_3, a0_.end_time AS end_time_4, a0_.is_confirmed AS is_confirmed_5, a0_.setup_with_location AS setup_with_location_6, a0_.teardown_with_location AS teardown_with_location_7, a0_.setup_date AS setup_date_8, a0_.setup_time AS setup_time_9, a0_.teardown_date AS teardown_date_10, a0_.teardown_time AS teardown_time_11, a0_.attendees_count AS attendees_count_12, a0_.attendees_age_from AS attendees_age_from_13, a0_.attendees_age_to AS attendees_age_to_14, a0_.attendees_notes AS attendees_notes_15, a0_.music_pdf_path AS music_pdf_path_16, a0_.dj_notes AS dj_notes_17, a0_.price_dj_hour AS price_dj_hour_18, a0_.price_dj_extention AS price_dj_extention_19, a0_.price_tech AS price_tech_20, a0_.price_approach AS price_approach_21, a0_.deactivated AS deactivated_22, a0_.customer_id AS customer_id_23, a0_.location_id AS location_id_24 FROM appointments a0_ WHERE a0_.deactivated = 1
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:
[
  1
]
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:
[
  2
]
5 0.09 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
]
6 0.07 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
]

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.