https://kursetest.essener-sport-betriebsgesellschaft.de/place/4/?q=place%2F4

Query Metrics

8 Database Queries
8 Different statements
11.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.21 ms
UPDATE orders SET o_xml_export = 0 WHERE o_xml_file = '' AND o_xml_export = 1 AND o_xml_storno_file = '' AND o_payment = 2 AND o_price_netto != 0
Parameters:
[]
2 5.06 ms
UPDATE orders SET o_xml_storno_export = 0 WHERE o_xml_storno_file = '' AND o_xml_storno_export = 1  AND o_price_netto != 0 AND o_xml_file = '' AND o_payment = 2
Parameters:
[]
3 0.74 ms
SELECT t0.id AS id_1, t0.ctt_from AS ctt_from_2, t0.ctt_to AS ctt_to_3, t0.ctt_cid AS ctt_cid_4, t0.ctt_note AS ctt_note_5, t0.ctt_day AS ctt_day_6, t0.ctt_active AS ctt_active_7, t0.ctt_room AS ctt_room_8, t0.ctt_offline_customer AS ctt_offline_customer_9, t0.ctt_maxoffline AS ctt_maxoffline_10, t0.ctt_online AS ctt_online_11, t0.ctt_maxonline AS ctt_maxonline_12, t0.ctt_number AS ctt_number_13 FROM course_times t0 WHERE t0.ctt_active = ?
Parameters:
[
  1
]
4 0.18 ms
SELECT t0.id AS id_1, t0.ca_uid AS ca_uid_2, t0.ca_cid AS ca_cid_3, t0.ca_tid AS ca_tid_4, t0.ca_amount AS ca_amount_5, t0.ca_now AS ca_now_6, t0.ca_session AS ca_session_7 FROM cart t0
Parameters:
[]
5 0.17 ms
SELECT t0.id AS id_1, t0.c_name AS c_name_2, t0.c_maxcustomer AS c_maxcustomer_3, t0.c_duration AS c_duration_4, t0.c_break_before AS c_break_before_5, t0.c_break_after AS c_break_after_6, t0.c_start AS c_start_7, t0.c_end AS c_end_8, t0.c_price AS c_price_9, t0.c_tax AS c_tax_10, t0.c_description AS c_description_11, t0.c_category AS c_category_12, t0.c_place AS c_place_13, t0.c_active_untill AS c_active_untill_14, t0.c_active AS c_active_15, t0.c_active_from AS c_active_from_16, t0.c_monday AS c_monday_17, t0.c_tuesday AS c_tuesday_18, t0.c_wednesday AS c_wednesday_19, t0.c_thursday AS c_thursday_20, t0.c_friday AS c_friday_21, t0.c_saturday AS c_saturday_22, t0.c_sunday AS c_sunday_23, t0.c_appointment_series AS c_appointment_series_24, t0.c_appointment_series_days AS c_appointment_series_days_25, t0.c_costplace AS c_costplace_26, t0.c_number AS c_number_27, t0.c_leader AS c_leader_28, t0.c_room AS c_room_29, t0.c_sb_number AS c_sb_number_30, t0.c_admin_fee AS c_admin_fee_31, t0.c_discount AS c_discount_32, t0.c_sibling_discount AS c_sibling_discount_33, t0.c_visible_from AS c_visible_from_34, t0.c_offline_customer AS c_offline_customer_35, t0.c_period AS c_period_36, t0.c_studio_discount AS c_studio_discount_37, t0.c_visible AS c_visible_38, t0.c_yoga AS c_yoga_39 FROM course t0 WHERE t0.c_active = ?
Parameters:
[
  1
]
6 0.08 ms
SELECT t0.id AS id_1, t0.cc_name AS cc_name_2, t0.cc_created AS cc_created_3, t0.cc_maxamount AS cc_maxamount_4 FROM course_categories t0
Parameters:
[]
7 0.10 ms
SELECT t0.id AS id_1, t0.cai_catid AS cai_catid_2, t0.cai_path AS cai_path_3 FROM category_images t0
Parameters:
[]
8 0.22 ms
SELECT t0.id AS id_1, t0.cc_catid AS cc_catid_2, t0.cc_cpid AS cc_cpid_3, t0.cc_active AS cc_active_4 FROM category_costplace t0 WHERE t0.cc_cpid = ?
Parameters:
[
  "4"
]

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\CourseTimes No errors.
App\Entity\Cart No errors.
App\Entity\Course No errors.
App\Entity\CourseCategories No errors.
App\Entity\CategoryImages No errors.
App\Entity\CategoryCostplace No errors.