Squash
Tennis
Petanque
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT COUNT(*) AS `count` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 7 | 1 | 1 | 1 | |
| 2 | SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`skip_booking_system`, `Venue`.`max_bookable_slots`, `Venue`.`min_bookable_slots`, `Venue`.`refresh_bookable_slots`, `Venue`.`cost`, `Venue`.`type`, `Venue`.`contact_tracing`, `Venue`.`timezone` FROM `pay2playtest`.`venues` AS `Venue` WHERE `Venue`.`id` = 7 LIMIT 1 | 1 | 1 | 0 | |
| 3 | SELECT `Facility`.`id`, `Facility`.`name`, `Facility`.`slot_duration_mins`, `Facility`.`daily_start_time`, `Facility`.`daily_end_time`, `Facility`.`venue_id`, `Facility`.`facility_type_id` FROM `pay2playtest`.`facilities` AS `Facility` WHERE `hidden` = 0 AND `Facility`.`venue_id` = (7) | 17 | 17 | 8 | |
| 4 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 1 | 1 | 1 | 0 | |
| 5 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 1 | 1 | 1 | 0 | |
| 6 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 1 | 1 | 1 | 0 | |
| 7 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 8 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 9 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 10 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 11 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 12 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 13 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 14 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 15 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 16 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 2 | 1 | 1 | 0 | |
| 17 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 12 | 1 | 1 | 0 | |
| 18 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 12 | 1 | 1 | 0 | |
| 19 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 12 | 1 | 1 | 0 | |
| 20 | SELECT `FacilityType`.`id`, `FacilityType`.`name`, `FacilityType`.`created`, `FacilityType`.`modified` FROM `pay2playtest`.`facility_types` AS `FacilityType` WHERE `FacilityType`.`id` = 12 | 1 | 1 | 0 | |
| 21 | 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`, `Sport`.`id`, `Sport`.`name`, `Region`.`id`, `Region`.`name` FROM `pay2playtest`.`venues` AS `Venue` LEFT JOIN `pay2playtest`.`sports` AS `Sport` ON (`Venue`.`sport_id` = `Sport`.`id`) LEFT JOIN `pay2playtest`.`regions` AS `Region` ON (`Venue`.`region_id` = `Region`.`id`) WHERE `Venue`.`id` = 7 LIMIT 1 | 1 | 1 | 1 | |
| 22 | SELECT `Membership`.`id`, `Membership`.`valid_till`, `Membership`.`suspended`, `Membership`.`club_admin`, `Membership`.`reservation_admin`, `Membership`.`user_id`, `Membership`.`venue_id`, `Membership`.`security_code`, `Membership`.`membership_number`, `Membership`.`multi_select`, `Membership`.`membership_category_id`, `Membership`.`parent_id`, `Membership`.`student_id`, `Membership`.`card_number`, `Membership`.`accepted_terms`, `Membership`.`accepted_terms_timestamp`, `Membership`.`created`, `Membership`.`modified`, `Membership`.`renewal_approval_date`, `Membership`.`notes` FROM `pay2playtest`.`memberships` AS `Membership` WHERE `Membership`.`venue_id` = (7) | 506 | 506 | 6 | |
| 23 | 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` FROM `pay2playtest`.`facilities` AS `Facility` WHERE `Facility`.`venue_id` = (7) | 17 | 17 | 2 | |
| 24 | SELECT `Event`.`id`, `Event`.`name`, `Event`.`start_time`, `Event`.`finish_time`, `Event`.`start_date`, `Event`.`finish_date`, `Event`.`entry_cut_off`, `Event`.`description`, `Event`.`interval`, `Event`.`recurring_id`, `Event`.`type`, `Event`.`max_participants`, `Event`.`participant_count`, `Event`.`default_price`, `Event`.`sponsor_logo`, `Event`.`members_only`, `Event`.`txn_id`, `Event`.`created`, `Event`.`modified`, `Event`.`hold_doors`, `Event`.`venue_id` FROM `pay2playtest`.`reservations` AS `Event` WHERE `Event`.`venue_id` = (7) | 1263 | 1263 | 110 | |
| 25 | SELECT `Voucher`.`id`, `Voucher`.`venue_id`, `Voucher`.`discount`, `Voucher`.`amount`, `Voucher`.`expires`, `Voucher`.`max_use`, `Voucher`.`use_count`, `Voucher`.`created`, `Voucher`.`modified`, `Voucher`.`name`, `Voucher`.`code` FROM `pay2playtest`.`vouchers` AS `Voucher` WHERE `Voucher`.`venue_id` = (7) | 15 | 15 | 8 | |
| 26 | SELECT `MembershipCategory`.`id`, `MembershipCategory`.`venue_id`, `MembershipCategory`.`name`, `MembershipCategory`.`renewal_period_months`, `MembershipCategory`.`advanced_warning_days`, `MembershipCategory`.`cost`, `MembershipCategory`.`group_type`, `MembershipCategory`.`created`, `MembershipCategory`.`modified`, `MembershipCategory`.`recurring_billing`, `MembershipCategory`.`hide_from_public`, `MembershipCategory`.`casual_membership`, `MembershipCategory`.`renewal_requires_confirmation` FROM `pay2playtest`.`membership_categories` AS `MembershipCategory` WHERE `MembershipCategory`.`venue_id` = (7) | 18 | 18 | 1 | |
| 27 | SELECT `TimeCode`.`id`, `TimeCode`.`venue_id`, `TimeCode`.`date_to`, `TimeCode`.`time_to`, `TimeCode`.`code`, `TimeCode`.`created`, `TimeCode`.`modified` FROM `pay2playtest`.`time_codes` AS `TimeCode` WHERE `TimeCode`.`date_to` >= CURDATE() AND `TimeCode`.`venue_id` = (7) ORDER BY `TimeCode`.`date_to` ASC | 0 | 0 | 0 | |
| 28 | SELECT `Door`.`id`, `Door`.`venue_id`, `Door`.`name`, `Door`.`identifier`, `Door`.`last_contact`, `Door`.`created`, `Door`.`software_version`, `Door`.`ip`, `Door`.`door_key`, `Door`.`controller_id`, `Door`.`controller_door_id` FROM `pay2playtest`.`doors` AS `Door` WHERE `Door`.`venue_id` = (7) | 2 | 2 | 0 | |
| 29 | SELECT `Tag`.`id`, `Tag`.`venue_id`, `Tag`.`name`, `Tag`.`created` FROM `pay2playtest`.`tags` AS `Tag` WHERE `Tag`.`venue_id` = (7) | 12 | 12 | 1 | |
| 30 | SELECT `EmailTemplate`.`id`, `EmailTemplate`.`name`, `EmailTemplate`.`content`, `EmailTemplate`.`venue_id`, `EmailTemplate`.`created`, `EmailTemplate`.`modified` FROM `pay2playtest`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`venue_id` = (7) | 6 | 6 | 3 |