| 1 |
0.98 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 = ?
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 = '4';
|
| 3 |
0.15 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.11 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.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 = ?
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 = 4;
|
| 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_
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_;
|