Query Metrics
8
Database Queries
8
Different statements
11.71 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.93 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.35 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.80 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.14 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.18 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.10 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.09 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.12 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:
[
"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\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. |