| 1 | SELECT COUNT(*) AS `count` FROM `pay2playtest`.`reservations` AS `Reservation` WHERE `Reservation`.`id` = 215557 | | 1 | 1 | 0 |
| 2 | SELECT `Reservation`.`id`, `Reservation`.`name`, `Reservation`.`start_time`, `Reservation`.`finish_time`, `Reservation`.`start_date`, `Reservation`.`finish_date`, `Reservation`.`entry_cut_off`, `Reservation`.`description`, `Reservation`.`interval`, `Reservation`.`recurring_id`, `Reservation`.`type`, `Reservation`.`max_participants`, `Reservation`.`participant_count`, `Reservation`.`default_price`, `Reservation`.`sponsor_logo`, `Reservation`.`members_only`, `Reservation`.`txn_id`, `Reservation`.`created`, `Reservation`.`modified`, `Reservation`.`hold_doors`, `Reservation`.`venue_id` FROM `pay2playtest`.`reservations` AS `Reservation` WHERE `Reservation`.`id` = 215557 LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `Participant`.`id`, `Participant`.`email`, `Participant`.`mobile`, `Participant`.`notes`, `Participant`.`code`, `Participant`.`user_id`, `Participant`.`paid`, `Participant`.`paid_date`, `Participant`.`payment_id`, `Participant`.`created`, `Participant`.`modified`, `Participant`.`reservation_id`, `Participant`.`name`, `Participant`.`txn_id` FROM `pay2playtest`.`participants` AS `Participant` WHERE `Participant`.`reservation_id` = (215557) | | 0 | 0 | 49 |
| 4 | SELECT `Facility`.`id`, `Facility`.`name`, `Facility`.`description`, `Facility`.`slot_duration_mins`, `Facility`.`daily_start_time`, `Facility`.`daily_end_time`, `Facility`.`venue_id`, `Facility`.`default_price`, `Facility`.`sponsor_logo`, `Facility`.`facility_type_id`, `Facility`.`lights_pre_start_sec`, `Facility`.`lights_post_finish_sec`, `Facility`.`lights_darken`, `Facility`.`email`, `Facility`.`controller_ip`, `Facility`.`guest_start_time`, `Facility`.`guest_end_time`, `Facility`.`created`, `Facility`.`modified`, `Facility`.`hidden`, `facility_reservations`.`id`, `facility_reservations`.`reservation_id`, `facility_reservations`.`facility_id` FROM `pay2playtest`.`facilities` AS `Facility` JOIN `pay2playtest`.`facility_reservations` AS `facility_reservations` ON (`facility_reservations`.`reservation_id` = 215557 AND `facility_reservations`.`facility_id` = `Facility`.`id`) | | 4 | 4 | 0 |
| 5 | SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`address`, `Venue`.`phone`, `Venue`.`cost`, `Venue`.`google_map_link`, `Venue`.`terms`, `Venue`.`honesty_box`, `Venue`.`notes`, `Venue`.`booking_notes`, `Venue`.`image`, `Venue`.`allow_multi_slot_bookings`, `Venue`.`sport_id`, `Venue`.`region_id`, `Venue`.`type`, `Venue`.`clubscol`, `Venue`.`lock_identifier`, `Venue`.`lock_key`, `Venue`.`skip_booking_system`, `Venue`.`email`, `Venue`.`system_notification_email`, `Venue`.`logo`, `Venue`.`display_order`, `Venue`.`email_membership_reminders`, `Venue`.`accept_membership_payments`, `Venue`.`auto_renewal_reminder`, `Venue`.`uses_time_codes`, `Venue`.`booking_requires_confirmation`, `Venue`.`booking_window_days`, `Venue`.`min_bookable_slots`, `Venue`.`max_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cancellation_buffer`, `Venue`.`lock_offline_notification`, `Venue`.`opponent_price`, `Venue`.`terms_url`, `Venue`.`email_members_bookings`, `Venue`.`contact_tracing`, `Venue`.`last_updated`, `Venue`.`timezone`, `Venue`.`google_map_email_link`, `Venue`.`push_notification_type`, `Venue`.`ftp_user`, `Venue`.`ftp_password`, `Venue`.`ftp_address`, `Venue`.`helloclub_key`, `Venue`.`pxpay_user`, `Venue`.`pxpay_key`, `Venue`.`pxpay_email`, `Venue`.`pxpost_user`, `Venue`.`pxpost_pass`, `Venue`.`player_count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 72 | | 1 | 1 | 0 |
| 6 | SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`address`, `Venue`.`phone`, `Venue`.`cost`, `Venue`.`google_map_link`, `Venue`.`terms`, `Venue`.`honesty_box`, `Venue`.`notes`, `Venue`.`booking_notes`, `Venue`.`image`, `Venue`.`allow_multi_slot_bookings`, `Venue`.`sport_id`, `Venue`.`region_id`, `Venue`.`type`, `Venue`.`clubscol`, `Venue`.`lock_identifier`, `Venue`.`lock_key`, `Venue`.`skip_booking_system`, `Venue`.`email`, `Venue`.`system_notification_email`, `Venue`.`logo`, `Venue`.`display_order`, `Venue`.`email_membership_reminders`, `Venue`.`accept_membership_payments`, `Venue`.`auto_renewal_reminder`, `Venue`.`uses_time_codes`, `Venue`.`booking_requires_confirmation`, `Venue`.`booking_window_days`, `Venue`.`min_bookable_slots`, `Venue`.`max_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cancellation_buffer`, `Venue`.`lock_offline_notification`, `Venue`.`opponent_price`, `Venue`.`terms_url`, `Venue`.`email_members_bookings`, `Venue`.`contact_tracing`, `Venue`.`last_updated`, `Venue`.`timezone`, `Venue`.`google_map_email_link`, `Venue`.`push_notification_type`, `Venue`.`ftp_user`, `Venue`.`ftp_password`, `Venue`.`ftp_address`, `Venue`.`helloclub_key`, `Venue`.`pxpay_user`, `Venue`.`pxpay_key`, `Venue`.`pxpay_email`, `Venue`.`pxpost_user`, `Venue`.`pxpost_pass`, `Venue`.`player_count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 72 | | 1 | 1 | 0 |
| 7 | SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`address`, `Venue`.`phone`, `Venue`.`cost`, `Venue`.`google_map_link`, `Venue`.`terms`, `Venue`.`honesty_box`, `Venue`.`notes`, `Venue`.`booking_notes`, `Venue`.`image`, `Venue`.`allow_multi_slot_bookings`, `Venue`.`sport_id`, `Venue`.`region_id`, `Venue`.`type`, `Venue`.`clubscol`, `Venue`.`lock_identifier`, `Venue`.`lock_key`, `Venue`.`skip_booking_system`, `Venue`.`email`, `Venue`.`system_notification_email`, `Venue`.`logo`, `Venue`.`display_order`, `Venue`.`email_membership_reminders`, `Venue`.`accept_membership_payments`, `Venue`.`auto_renewal_reminder`, `Venue`.`uses_time_codes`, `Venue`.`booking_requires_confirmation`, `Venue`.`booking_window_days`, `Venue`.`min_bookable_slots`, `Venue`.`max_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cancellation_buffer`, `Venue`.`lock_offline_notification`, `Venue`.`opponent_price`, `Venue`.`terms_url`, `Venue`.`email_members_bookings`, `Venue`.`contact_tracing`, `Venue`.`last_updated`, `Venue`.`timezone`, `Venue`.`google_map_email_link`, `Venue`.`push_notification_type`, `Venue`.`ftp_user`, `Venue`.`ftp_password`, `Venue`.`ftp_address`, `Venue`.`helloclub_key`, `Venue`.`pxpay_user`, `Venue`.`pxpay_key`, `Venue`.`pxpay_email`, `Venue`.`pxpost_user`, `Venue`.`pxpost_pass`, `Venue`.`player_count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 72 | | 1 | 1 | 0 |
| 8 | SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`address`, `Venue`.`phone`, `Venue`.`cost`, `Venue`.`google_map_link`, `Venue`.`terms`, `Venue`.`honesty_box`, `Venue`.`notes`, `Venue`.`booking_notes`, `Venue`.`image`, `Venue`.`allow_multi_slot_bookings`, `Venue`.`sport_id`, `Venue`.`region_id`, `Venue`.`type`, `Venue`.`clubscol`, `Venue`.`lock_identifier`, `Venue`.`lock_key`, `Venue`.`skip_booking_system`, `Venue`.`email`, `Venue`.`system_notification_email`, `Venue`.`logo`, `Venue`.`display_order`, `Venue`.`email_membership_reminders`, `Venue`.`accept_membership_payments`, `Venue`.`auto_renewal_reminder`, `Venue`.`uses_time_codes`, `Venue`.`booking_requires_confirmation`, `Venue`.`booking_window_days`, `Venue`.`min_bookable_slots`, `Venue`.`max_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cancellation_buffer`, `Venue`.`lock_offline_notification`, `Venue`.`opponent_price`, `Venue`.`terms_url`, `Venue`.`email_members_bookings`, `Venue`.`contact_tracing`, `Venue`.`last_updated`, `Venue`.`timezone`, `Venue`.`google_map_email_link`, `Venue`.`push_notification_type`, `Venue`.`ftp_user`, `Venue`.`ftp_password`, `Venue`.`ftp_address`, `Venue`.`helloclub_key`, `Venue`.`pxpay_user`, `Venue`.`pxpay_key`, `Venue`.`pxpay_email`, `Venue`.`pxpost_user`, `Venue`.`pxpost_pass`, `Venue`.`player_count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 72 | | 1 | 1 | 0 |
