| 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
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;
|
| 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
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 3;
|