Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 2 | 2 | 1 | maybe slow |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-66a8-4ea9-90f4-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 1 | 1 | 1 | |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-4290-4950-be6a-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-4290-4950-be6a-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' | 1 | 1 | 0 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-4290-4950-be6a-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-4290-4950-be6a-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-4290-4950-be6a-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-4290-4950-be6a-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-4290-4950-be6a-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734027-41ec-433a-948d-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734027-cdcc-4ed2-a956-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734147-ef60-4864-9be0-247e0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a7346eb-fe08-42dc-86f7-31d60ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734711-2080-4590-bb56-30310ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734716-4554-4058-9986-31710ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-fd68-4f44-abe3-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-fd68-4f44-abe3-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-fd68-4f44-abe3-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-fd68-4f44-abe3-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 0 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-fd68-4f44-abe3-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-fd68-4f44-abe3-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-a760-4d6a-84ac-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aed-a480-4dc2-b2cf-7e8e0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-fd68-4f44-abe3-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734027-41ec-433a-948d-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734027-cdcc-4ed2-a956-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734147-ef60-4864-9be0-247e0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a7346eb-fe08-42dc-86f7-31d60ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734711-2080-4590-bb56-30310ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734716-4554-4058-9986-31710ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734026-c5a0-4543-b876-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734026-c5a0-4543-b876-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734026-c5a0-4543-b876-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-07fc-451c-9c6e-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99b0a-ffa8-4979-8aa1-7e8c0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734026-c5a0-4543-b876-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a73476a-9358-465c-b67d-31db0ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734026-c5a0-4543-b876-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-c5a0-4543-b876-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-6bf0-41d0-9837-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-28f8-4e87-9f22-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734026-6bf0-41d0-9837-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734026-6bf0-41d0-9837-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734026-6bf0-41d0-9837-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-07fc-451c-9c6e-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99b0a-ffa8-4979-8aa1-7e8c0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734026-6bf0-41d0-9837-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a7347a5-f654-44b6-be74-33670ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734026-6bf0-41d0-9837-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734026-28f8-4e87-9f22-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734026-28f8-4e87-9f22-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734026-28f8-4e87-9f22-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734026-07fc-451c-9c6e-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99b0a-ffa8-4979-8aa1-7e8c0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734026-28f8-4e87-9f22-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a7347c2-a53c-4ffc-a0ac-33580ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734026-28f8-4e87-9f22-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734027-75f8-4c40-ae02-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-75f8-4c40-ae02-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-75f8-4c40-ae02-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734027-a154-47da-9a7b-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aca-11a8-4f63-bbf7-7d890ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-75f8-4c40-ae02-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a7347f3-dacc-45fa-8857-337d0ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-75f8-4c40-ae02-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aca-11a8-4f63-bbf7-7d890ad0a778' AND `Venue`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-75f8-4c40-ae02-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-2544-40db-a6de-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734027-2544-40db-a6de-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-2544-40db-a6de-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-2544-40db-a6de-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734027-a154-47da-9a7b-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aca-11a8-4f63-bbf7-7d890ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-2544-40db-a6de-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734840-6818-45b9-9368-34b40ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-2544-40db-a6de-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734027-c948-4276-b9e4-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-c948-4276-b9e4-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-c948-4276-b9e4-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734027-d08c-4003-bb7c-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99b37-f250-43e5-a44e-7fda0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-c948-4276-b9e4-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734867-bc14-4808-ad4c-34a10ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-c948-4276-b9e4-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99b37-f250-43e5-a44e-7fda0ad0a778' AND `Venue`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-c948-4276-b9e4-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-b800-4d17-9863-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734027-b800-4d17-9863-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-b800-4d17-9863-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-b800-4d17-9863-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734027-d08c-4003-bb7c-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99b37-f250-43e5-a44e-7fda0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-b800-4d17-9863-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a7348a1-7bd4-42ef-87d2-340d0ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-b800-4d17-9863-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5a734027-5e8c-4d28-978f-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-5e8c-4d28-978f-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-5e8c-4d28-978f-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5a734027-459c-4870-ae5e-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99e34-f61c-4283-b447-07ee0ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5a734027-5e8c-4d28-978f-21ba0ab0c97d') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a73924a-c954-41c5-91ae-604f0ab0c97d' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5a734027-5e8c-4d28-978f-21ba0ab0c97d' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99e34-f61c-4283-b447-07ee0ad0a778' AND `Venue`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-5e8c-4d28-978f-21ba0ab0c97d' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 0 | 0 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id`, `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type`, `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` LEFT JOIN `load-testing-202410`.`activities` AS `Activity` ON (`ActivityInstance`.`activity_id` = `Activity`.`id`) LEFT JOIN `load-testing-202410`.`venues` AS `Venue` ON (`ActivityInstance`.`venue_id` = `Venue`.`id`) WHERE `ActivityInstance`.`id` = '5e6129aa-e778-44a4-ab88-33750ad1e040' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5e6129aa-e778-44a4-ab88-33750ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 3 | 3 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5e6129aa-e778-44a4-ab88-33750ad1e040' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5e6127a8-cbe0-481f-9288-2c850ad1e040' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aab-176c-40c5-b069-7d470ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5e6129aa-e778-44a4-ab88-33750ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 3 | 3 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5e6129aa-e778-44a4-ab88-33750ad1e040' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5e6127a8-cbe0-481f-9288-2c850ad1e040' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aab-176c-40c5-b069-7d470ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5e6129aa-e778-44a4-ab88-33750ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 3 | 3 | 1 | maybe slow |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5e6129aa-e778-44a4-ab88-33750ad1e040' | 1 | 1 | 1 | |
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `Activity`.`id` = '5e6127a8-cbe0-481f-9288-2c850ad1e040' | 1 | 1 | 1 | |
SELECT `Venue`.`id`, `Venue`.`name`, `Venue`.`description`, `Venue`.`address`, `Venue`.`address2`, `Venue`.`city`, `Venue`.`state`, `Venue`.`postal_code`, `Venue`.`country`, `Venue`.`longitude`, `Venue`.`latitude`, `Venue`.`map_zoom`, `Venue`.`capacity`, `Venue`.`partner_id`, `Venue`.`organization_id`, `Venue`.`user_id`, `Venue`.`website`, `Venue`.`facebook`, `Venue`.`twitter`, `Venue`.`status`, `Venue`.`created`, `Venue`.`modified` FROM `load-testing-202410`.`venues` AS `Venue` WHERE `Venue`.`id` = '57c99aab-176c-40c5-b069-7d470ad0a778' | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`activity_instance_id` = ('5e6129aa-e778-44a4-ab88-33750ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 3 | 3 | 1 | maybe slow |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734027-cdcc-4ed2-a956-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a734147-ef60-4864-9be0-247e0ab0c97d' | 1 | 1 | 1 | |
SELECT `TicketType`.`id`, `TicketType`.`foreign_key`, `TicketType`.`model`, `TicketType`.`gratuity_id`, `TicketType`.`custom_id`, `TicketType`.`name`, `TicketType`.`api_user_authentication_required`, `TicketType`.`description`, `TicketType`.`ticket_type_group_id`, `TicketType`.`activity_instance_to_display_id`, `TicketType`.`pdf_display_ticket_type_description`, `TicketType`.`pdf_display_event_ticket_details`, `TicketType`.`pdf_display_event_ticket_disclaimer`, `TicketType`.`use_dates`, `TicketType`.`use_dates_not_available`, `TicketType`.`use_start`, `TicketType`.`use_end`, `TicketType`.`use_access_code_NIU`, `TicketType`.`access_code_NIU`, `TicketType`.`start`, `TicketType`.`start_utc`, `TicketType`.`end`, `TicketType`.`end_utc`, `TicketType`.`description_display`, `TicketType`.`ticket_type_price_count`, `TicketType`.`total_available`, `TicketType`.`quantity_min`, `TicketType`.`quantity_max`, `TicketType`.`sort`, `TicketType`.`seating_category_key`, `TicketType`.`tickets_per`, `TicketType`.`activity_quantity_registrations`, `TicketType`.`max_activities`, `TicketType`.`include_photo`, `TicketType`.`photo_min`, `TicketType`.`photo_max`, `TicketType`.`created`, `TicketType`.`modified`, `TicketType`.`auto_activity_instance_registration`, `TicketType`.`is_linked`, `TicketType`.`use_custom_service_charge`, `TicketType`.`service_charge_percent`, `TicketType`.`service_charge_percent_mobile`, `TicketType`.`service_charge_flat`, `TicketType`.`service_charge_flat_mobile`, `TicketType`.`ticketless`, `TicketType`.`hide`, `TicketType`.`partner_order_push_incl`, `TicketType`.`product_type`, `TicketType`.`registration_instructions`, `TicketType`.`use_quantity`, `TicketType`.`use_quantity_not_available`, `TicketType`.`by_qty_ticket_type`, `TicketType`.`int_id_prefix`, `TicketType`.`has_popup`, `TicketType`.`popup`, `TicketType`.`is_swappable`, `TicketType`.`swappable_timed`, `TicketType`.`swappable_start`, `TicketType`.`swappable_end`, `TicketType`.`confirmation_text`, `TicketType`.`count_confirmed`, `TicketType`.`ticket_visibility`, `TicketType`.`has_access_code_connection`, `TicketType`.`sales_availability`, `TicketType`.`message_inactive`, `TicketType`.`message_before`, `TicketType`.`message_after`, `TicketType`.`message_soldout`, `TicketType`.`mobile_graphic_click_through_url`, `TicketType`.`show_before_sale`, `TicketType`.`show_after_sale`, `TicketType`.`show_remaining`, `TicketType`.`show_remaining_threshold`, `TicketType`.`show_by` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5e61276c-cd30-4e4f-9cd8-2be10ad1e040' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5e6129aa-e778-44a4-ab88-33750ad1e040' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a734026-c0c8-4651-b7c5-21ba0ab0c97d' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(`ActivityInstancesTicket`.`id`) AS reserved, `ActivityInstancesTicket`.`ticket_type_id` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5e6129aa-e778-44a4-ab88-33750ad1e040' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-4404-426d-a4f0-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-49b8-40c6-8091-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5ccb09b4-ff78-47c1-80de-1f5f0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-f3e0-4dc3-8bc0-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5ccb0a00-8bd8-4ced-bd89-1fa10ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '6528104c-0b48-4285-a9ab-6d560ad1e030' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-3b90-437f-9e27-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5ccb0a15-c3e0-426d-8a2c-1ff80ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-d7dc-4c15-91d3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5ccb0a51-bc28-4b67-ba0a-1ff80ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-5a3c-4e28-8c5f-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5ccb0a6e-cb18-4a12-87af-203d0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-8e84-4221-ab71-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-66a8-4ea9-90f4-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-4290-4950-be6a-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-fd68-4f44-abe3-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-c5a0-4543-b876-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-6bf0-41d0-9837-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734026-28f8-4e87-9f22-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-75f8-4c40-ae02-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-2544-40db-a6de-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-c948-4276-b9e4-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-b800-4d17-9863-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5a734027-5e8c-4d28-978f-21ba0ab0c97d' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5e6129aa-e778-44a4-ab88-33750ad1e040' | 1 | 1 | 1 | |
88 duplicate queries run.