No items available. |
No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Event`.`id`, `Event`.`active`, `Event`.`address`, `Event`.`address2`, `Event`.`age_restriction`, `Event`.`api_user_authentication_required`, `Event`.`archived_date`, `Event`.`attendee_limit`, `Event`.`charge_percentage_fee`, `Event`.`charge_tax`, `Event`.`charity_flat_fee`, `Event`.`charity_percent_fee`, `Event`.`city`, `Event`.`connected_stripe_account_id`, `Event`.`country`, `Event`.`created`, `Event`.`csv_offsets`, `Event`.`custom_id`, `Event`.`is_dateless`, `Event`.`end`, `Event`.`end_utc`, `Event`.`event_category_id`, `Event`.`event_instance_count`, `Event`.`featured`, `Event`.`file_count`, `Event`.`include_fees`, `Event`.`include_fees_api`, `Event`.`include_fees_pos`, `Event`.`invoice_code`, `Event`.`last_cached`, `Event`.`last_daily_order_report_generated`, `Event`.`latitude`, `Event`.`library_dir`, `Event`.`location`, `Event`.`longitude`, `Event`.`map_zoom`, `Event`.`mobile_per_ticket_fee`, `Event`.`name`, `Event`.`modified`, `Event`.`online_only`, `Event`.`organization_id`, `Event`.`activity_producer_id`, `Event`.`partner_id`, `Event`.`password_protected`, `Event`.`password_protected_limit`, `Event`.`password_protected_end`, `Event`.`password_protected_end_utc`, `Event`.`per_ticket_charge`, `Event`.`photo_count`, `Event`.`postal_code`, `Event`.`privacy_password`, `Event`.`privacy_type`, `Event`.`publish_datetime_utc`, `Event`.`refund_all_request`, `Event`.`region`, `Event`.`seating`, `Event`.`show_seats_by_default`, `Event`.`service_charge_percent`, `Event`.`service_charge_round_to`, `Event`.`seatsio_chart_key`, `Event`.`service_email`, `Event`.`service_fee_revenue_share_percent`, `Event`.`service_phone`, `Event`.`short_code`, `Event`.`show_end`, `Event`.`show_start`, `Event`.`slug`, `Event`.`sms_reminded`, `Event`.`sold_out`, `Event`.`sold_out_text`, `Event`.`start`, `Event`.`start_utc`, `Event`.`state`, `Event`.`status`, `Event`.`summary`, `Event`.`tax_rate`, `Event`.`tax_app`, `Event`.`tax_backend`, `Event`.`tax_online`, `Event`.`tax_service_fees`, `Event`.`layout_id`, `Event`.`theme_id`, `Event`.`tickets_active`, `Event`.`tickets_mail`, `Event`.`tickets_url`, `Event`.`transfer`, `Event`.`tickets_willcall`, `Event`.`tickets_display_type`, `Event`.`ticket_sponsor_list`, `Event`.`ticket_type_count`, `Event`.`ticket_types_description_display`, `Event`.`timezone`, `Event`.`user_id`, `Event`.`video_count`, `Event`.`website`, `Event`.`technical_email`, `Event`.`terms`, `Event`.`ticket_details`, `Event`.`ticket_disclaimer`, `Event`.`ticket_information`, `Event`.`event_topic_id`, `Event`.`event_type_id`, `Event`.`prevent_orphan_seats`, `Event`.`privacy`, `Event`.`charge_percentage_fee_onsite`, `Event`.`bundle_fees`, `Event`.`cancellation`, `Event`.`confirmation_details`, `Event`.`confirmation_details_popup`, `Event`.`confirmation_details_popup_enabled`, `Event`.`is_archived`, `Event`.`archive_failed`, `Event`.`ready_to_archive`, `Event`.`refund`, `Event`.`last_report_rerun`, `Event`.`reports_rerun_complete`, `Event`.`counts_update_complete`, `Event`.`csv_generation_complete`, `Event`.`date_last_scanned`, `Event`.`details`, `Event`.`email_text`, `Event`.`was_published`, `ConnectedStripeAccount`.`id`, `ConnectedStripeAccount`.`display_name`, `ConnectedStripeAccount`.`token_type`, `ConnectedStripeAccount`.`stripe_publishable_key`, `ConnectedStripeAccount`.`scope`, `ConnectedStripeAccount`.`livemode`, `ConnectedStripeAccount`.`stripe_user_id`, `ConnectedStripeAccount`.`refresh_token`, `ConnectedStripeAccount`.`access_token`, `ConnectedStripeAccount`.`created`, `ConnectedStripeAccount`.`modified`, `ConnectedStripeAccount`.`id_apple_pay_domain`, `Theme`.`id`, `Theme`.`name`, `Theme`.`description`, `Theme`.`slug`, `Theme`.`active`, `Theme`.`layout_id`, `Theme`.`user_id`, `Theme`.`default`, `Theme`.`use_custom_font`, `Theme`.`custom_font_id`, `Theme`.`created`, `Theme`.`modified`, `Layout`.`id`, `Layout`.`name`, `Layout`.`description`, `Layout`.`slug`, `Layout`.`theme`, `Layout`.`active`, `Layout`.`user_id`, `Layout`.`partner_id`, `Layout`.`list_order`, `Layout`.`allow_editable_fields`, `Layout`.`editable_fields`, `Layout`.`allow_image_upload`, `Layout`.`max_image_upload`, `Layout`.`image_upload_title`, `Layout`.`default`, `Layout`.`created`, `Layout`.`modified`, `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`events` AS `Event` LEFT JOIN `load-testing-202410`.`connected_stripe_accounts` AS `ConnectedStripeAccount` ON (`Event`.`connected_stripe_account_id` = `ConnectedStripeAccount`.`id`) LEFT JOIN `load-testing-202410`.`themes` AS `Theme` ON (`Event`.`theme_id` = `Theme`.`id`) LEFT JOIN `load-testing-202410`.`layouts` AS `Layout` ON (`Event`.`layout_id` = `Layout`.`id`) LEFT JOIN `load-testing-202410`.`photos` AS `Logo` ON (`Logo`.`foreign_key` = `Event`.`id` AND `Logo`.`model` = 'Event' AND `Logo`.`type` = 'logo') WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `EventSocialNetwork`.`id`, `EventSocialNetwork`.`event_id`, `EventSocialNetwork`.`social_network_id`, `EventSocialNetwork`.`url`, `EventSocialNetwork`.`created`, `EventSocialNetwork`.`modified` FROM `load-testing-202410`.`events_social_networks` AS `EventSocialNetwork` WHERE `EventSocialNetwork`.`url` != '' AND `EventSocialNetwork`.`event_id` = ('5f6a80fa-6048-447a-b379-14d40ad1e040') | 2 | 2 | 1 | maybe slow |
SELECT `SocialNetwork`.`id`, `SocialNetwork`.`name`, `SocialNetwork`.`url`, `SocialNetwork`.`slug`, `SocialNetwork`.`description`, `SocialNetwork`.`order`, `SocialNetwork`.`share_active`, `SocialNetwork`.`share_active_url`, `SocialNetwork`.`created`, `SocialNetwork`.`modified` FROM `load-testing-202410`.`social_networks` AS `SocialNetwork` WHERE `SocialNetwork`.`id` = '04CC5981-EA36-4252-8340-D8C391DB9E92' | 1 | 1 | 1 | |
SELECT `SocialNetwork`.`id`, `SocialNetwork`.`name`, `SocialNetwork`.`url`, `SocialNetwork`.`slug`, `SocialNetwork`.`description`, `SocialNetwork`.`order`, `SocialNetwork`.`share_active`, `SocialNetwork`.`share_active_url`, `SocialNetwork`.`created`, `SocialNetwork`.`modified` FROM `load-testing-202410`.`social_networks` AS `SocialNetwork` WHERE `SocialNetwork`.`id` = '5DE74EA4-3A1D-4FB2-A124-4E452C26DED0' | 1 | 1 | 1 | |
SELECT `Sponsor`.`id`, `Sponsor`.`active`, `Sponsor`.`digital_ad_sponsor`, `Sponsor`.`digital_ad_code`, `Sponsor`.`name`, `Sponsor`.`event_id`, `Sponsor`.`website`, `Sponsor`.`photo_count`, `Sponsor`.`video_count`, `Sponsor`.`file_count`, `Sponsor`.`sort`, `Sponsor`.`featured`, `Sponsor`.`on_countdown`, `Sponsor`.`on_event`, `Sponsor`.`on_bottom`, `Sponsor`.`on_mobile`, `Sponsor`.`on_ticket`, `Sponsor`.`on_ticket_page`, `Sponsor`.`on_receipt`, `Sponsor`.`created`, `Sponsor`.`modified` FROM `load-testing-202410`.`sponsors` AS `Sponsor` WHERE `Sponsor`.`event_id` = ('5f6a80fa-6048-447a-b379-14d40ad1e040') ORDER BY `Sponsor`.`sort` ASC | 3 | 3 | 26 | maybe slow |
SELECT `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`photos` AS `Logo` WHERE `Logo`.`foreign_key` = '5f6a870e-79b8-4777-b62a-56280ad1e040' AND `Logo`.`model` = 'Sponsor' AND `Logo`.`type` = 'logo' | 1 | 1 | 1 | |
SELECT `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`photos` AS `Logo` WHERE `Logo`.`foreign_key` = '5f6a88a1-a18c-4d95-914c-6c240ad1e040' AND `Logo`.`model` = 'Sponsor' AND `Logo`.`type` = 'logo' | 1 | 1 | 1 | |
SELECT `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`photos` AS `Logo` WHERE `Logo`.`foreign_key` = '5f6a88ad-73f0-466b-8bb4-6d190ad1e040' AND `Logo`.`model` = 'Sponsor' AND `Logo`.`type` = 'logo' | 1 | 1 | 1 | |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`foreign_key` = '5f6a870e-79b8-4777-b62a-56280ad1e040' AND `Photo`.`model` = 'Sponsor' AND `Photo`.`type` = 'mobile-banner' | 1 | 1 | 1 | |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`foreign_key` = '5f6a88a1-a18c-4d95-914c-6c240ad1e040' AND `Photo`.`model` = 'Sponsor' AND `Photo`.`type` = 'mobile-banner' | 0 | 0 | 1 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`foreign_key` = '5f6a88ad-73f0-466b-8bb4-6d190ad1e040' AND `Photo`.`model` = 'Sponsor' AND `Photo`.`type` = 'mobile-banner' | 0 | 0 | 1 | maybe slow |
SELECT `EventPassword`.`id`, `EventPassword`.`event_id`, `EventPassword`.`code`, `EventPassword`.`end`, `EventPassword`.`num_orders`, `EventPassword`.`num_orders_limit`, `EventPassword`.`start`, `EventPassword`.`is_active`, `EventPassword`.`type`, `EventPassword`.`created`, `EventPassword`.`modified` FROM `load-testing-202410`.`event_passwords` AS `EventPassword` WHERE `EventPassword`.`type` = 1 AND `EventPassword`.`event_id` = ('5f6a80fa-6048-447a-b379-14d40ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `Lang`.`id`, `Lang`.`name`, `Lang`.`locale_3`, `Lang`.`locale_2`, `EventsLang`.`id`, `EventsLang`.`event_id`, `EventsLang`.`lang_id` FROM `load-testing-202410`.`langs` AS `Lang` JOIN `load-testing-202410`.`events_langs` AS `EventsLang` ON (`EventsLang`.`event_id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `EventsLang`.`lang_id` = `Lang`.`id`) | 0 | 0 | 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 `foreign_key` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `model` = 'Event' ORDER BY `TicketType`.`sort` ASC | 8 | 8 | 1 | maybe slow |
SELECT `TicketTypePrice`.`id`, `TicketTypePrice`.`price_each`, `TicketTypePrice`.`price_each_all_in`, `TicketTypePrice`.`name`, `TicketTypePrice`.`total_available`, `TicketTypePrice`.`ticket_type_id`, `TicketTypePrice`.`description`, `TicketTypePrice`.`sort`, `TicketTypePrice`.`created`, `TicketTypePrice`.`modified`, `TicketTypePrice`.`quantity_min`, `TicketTypePrice`.`quantity_max` FROM `load-testing-202410`.`ticket_type_prices` AS `TicketTypePrice` WHERE `TicketTypePrice`.`ticket_type_id` IN ('5f6a820a-3f00-4aad-b604-1f080ad1e040', '5f6a813d-6910-44e1-bdf8-175c0ad1e040', '5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040', '5f6a95de-a82c-4c26-a38b-037d0ad1e040', '5f6a8349-24f0-499d-bf26-2fb60ad1e040', '5f6a8306-e920-4d92-adc5-294d0ad1e040', '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040', '5f6a8940-db50-4e6d-b0e1-71300ad1e040') ORDER BY `TicketTypePrice`.`sort` ASC | 11 | 11 | 1 | maybe slow |
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`.`ticket_type_id` IN ('5f6a820a-3f00-4aad-b604-1f080ad1e040', '5f6a813d-6910-44e1-bdf8-175c0ad1e040', '5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040', '5f6a95de-a82c-4c26-a38b-037d0ad1e040', '5f6a8349-24f0-499d-bf26-2fb60ad1e040', '5f6a8306-e920-4d92-adc5-294d0ad1e040', '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040', '5f6a8940-db50-4e6d-b0e1-71300ad1e040') | 15 | 15 | 1 | maybe slow |
SELECT `LinkedTicketType`.`id`, `LinkedTicketType`.`ticket_type_id`, `LinkedTicketType`.`master_ticket_type_id`, `LinkedTicketType`.`tickets_per_master` FROM `load-testing-202410`.`linked_ticket_types` AS `LinkedTicketType` WHERE `LinkedTicketType`.`ticket_type_id` IN ('5f6a820a-3f00-4aad-b604-1f080ad1e040', '5f6a813d-6910-44e1-bdf8-175c0ad1e040', '5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040', '5f6a95de-a82c-4c26-a38b-037d0ad1e040', '5f6a8349-24f0-499d-bf26-2fb60ad1e040', '5f6a8306-e920-4d92-adc5-294d0ad1e040', '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040', '5f6a8940-db50-4e6d-b0e1-71300ad1e040') | 4 | 4 | 12 | maybe slow |
SELECT `TicketTypesVoucherType`.`id`, `TicketTypesVoucherType`.`ticket_type_id`, `TicketTypesVoucherType`.`voucher_type_id`, `TicketTypesVoucherType`.`quantity` FROM `load-testing-202410`.`ticket_types_voucher_types` AS `TicketTypesVoucherType` WHERE `TicketTypesVoucherType`.`ticket_type_id` IN ('5f6a820a-3f00-4aad-b604-1f080ad1e040', '5f6a813d-6910-44e1-bdf8-175c0ad1e040', '5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040', '5f6a95de-a82c-4c26-a38b-037d0ad1e040', '5f6a8349-24f0-499d-bf26-2fb60ad1e040', '5f6a8306-e920-4d92-adc5-294d0ad1e040', '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040', '5f6a8940-db50-4e6d-b0e1-71300ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5f6a820a-3f00-4aad-b604-1f080ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 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 `event_id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `slug` = 'saturday-laughs' 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` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`activity_id` = ('5f6a8d9c-76f4-4d51-80d4-24650ad1e040') ORDER BY `ActivityInstance`.`start` ASC | 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` = ('5f6a8df2-7044-4c44-93ea-2b0d0ad1e040') | 3 | 3 | 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` = '5f6a8df2-7044-4c44-93ea-2b0d0ad1e040' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 2 | 2 | 1 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `model` = 'Activity' AND `foreign_key` = '5f6a8d9c-76f4-4d51-80d4-24650ad1e040' AND `type` = 'gallery' ORDER BY `sort` 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`, `Gratuity`.`id`, `Gratuity`.`active`, `Gratuity`.`allow_custom`, `Gratuity`.`allow_zero`, `Gratuity`.`created`, `Gratuity`.`event_id`, `Gratuity`.`modified`, `Gratuity`.`options`, `Gratuity`.`title`, `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`ticket_types` AS `TicketType` LEFT JOIN `load-testing-202410`.`gratuities` AS `Gratuity` ON (`TicketType`.`gratuity_id` = `Gratuity`.`id`) LEFT JOIN `load-testing-202410`.`photos` AS `Logo` ON (`Logo`.`foreign_key` = `TicketType`.`id` AND `Logo`.`model` = 'TicketType' AND `Logo`.`type` = 'logo') WHERE `TicketType`.`id` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TicketTypePrice`.`id`, `TicketTypePrice`.`price_each`, `TicketTypePrice`.`price_each_all_in`, `TicketTypePrice`.`name`, `TicketTypePrice`.`total_available`, `TicketTypePrice`.`ticket_type_id`, `TicketTypePrice`.`description`, `TicketTypePrice`.`sort`, `TicketTypePrice`.`created`, `TicketTypePrice`.`modified`, `TicketTypePrice`.`quantity_min`, `TicketTypePrice`.`quantity_max` FROM `load-testing-202410`.`ticket_type_prices` AS `TicketTypePrice` WHERE `TicketTypePrice`.`ticket_type_id` = ('5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040') ORDER BY `sort` ASC | 1 | 1 | 1 | |
SELECT `AccessCodeConnection`.`id`, `AccessCodeConnection`.`access_code_id`, `AccessCodeConnection`.`active`, `AccessCodeConnection`.`datetime_end`, `AccessCodeConnection`.`datetime_start`, `AccessCodeConnection`.`foreign_key`, `AccessCodeConnection`.`model`, `AccessCodeConnection`.`num_limit_orders`, `AccessCodeConnection`.`num_limit_tickets`, `AccessCodeConnection`.`use_date_restriction` FROM `load-testing-202410`.`access_code_connections` AS `AccessCodeConnection` WHERE `AccessCodeConnection`.`model` = 'TicketType' AND `AccessCodeConnection`.`foreign_key` = ('5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040') | 0 | 0 | 143 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`model` = 'TicketType' AND `Photo`.`foreign_key` = ('5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `LinkedTicketType`.`id`, `LinkedTicketType`.`ticket_type_id`, `LinkedTicketType`.`master_ticket_type_id`, `LinkedTicketType`.`tickets_per_master` FROM `load-testing-202410`.`linked_ticket_types` AS `LinkedTicketType` WHERE `LinkedTicketType`.`ticket_type_id` = ('5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040') | 4 | 4 | 9 | maybe slow |
SELECT `TicketTypesVoucherType`.`id`, `TicketTypesVoucherType`.`ticket_type_id`, `TicketTypesVoucherType`.`voucher_type_id`, `TicketTypesVoucherType`.`quantity` FROM `load-testing-202410`.`ticket_types_voucher_types` AS `TicketTypesVoucherType` WHERE `TicketTypesVoucherType`.`ticket_type_id` = ('5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `LinkedTicketType`.*, `masterticket`.`sort`, `masterticket`.`name` FROM `load-testing-202410`.`linked_ticket_types` AS `LinkedTicketType` INNER JOIN `load-testing-202410`.`ticket_types` AS `masterticket` ON (`masterticket`.`id` = `LinkedTicketType`.`master_ticket_type_id`) WHERE `ticket_type_id` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' ORDER BY `masterticket`.`sort` ASC | 4 | 4 | 9 | 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`, `Gratuity`.`id`, `Gratuity`.`active`, `Gratuity`.`allow_custom`, `Gratuity`.`allow_zero`, `Gratuity`.`created`, `Gratuity`.`event_id`, `Gratuity`.`modified`, `Gratuity`.`options`, `Gratuity`.`title`, `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`ticket_types` AS `TicketType` LEFT JOIN `load-testing-202410`.`gratuities` AS `Gratuity` ON (`TicketType`.`gratuity_id` = `Gratuity`.`id`) LEFT JOIN `load-testing-202410`.`photos` AS `Logo` ON (`Logo`.`foreign_key` = `TicketType`.`id` AND `Logo`.`model` = 'TicketType' AND `Logo`.`type` = 'logo') WHERE `TicketType`.`id` = '5f6a820a-3f00-4aad-b604-1f080ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TicketTypePrice`.`id`, `TicketTypePrice`.`price_each`, `TicketTypePrice`.`price_each_all_in`, `TicketTypePrice`.`name`, `TicketTypePrice`.`total_available`, `TicketTypePrice`.`ticket_type_id`, `TicketTypePrice`.`description`, `TicketTypePrice`.`sort`, `TicketTypePrice`.`created`, `TicketTypePrice`.`modified`, `TicketTypePrice`.`quantity_min`, `TicketTypePrice`.`quantity_max` FROM `load-testing-202410`.`ticket_type_prices` AS `TicketTypePrice` WHERE `TicketTypePrice`.`ticket_type_id` = ('5f6a820a-3f00-4aad-b604-1f080ad1e040') ORDER BY `sort` ASC | 1 | 1 | 0 | |
SELECT `AccessCodeConnection`.`id`, `AccessCodeConnection`.`access_code_id`, `AccessCodeConnection`.`active`, `AccessCodeConnection`.`datetime_end`, `AccessCodeConnection`.`datetime_start`, `AccessCodeConnection`.`foreign_key`, `AccessCodeConnection`.`model`, `AccessCodeConnection`.`num_limit_orders`, `AccessCodeConnection`.`num_limit_tickets`, `AccessCodeConnection`.`use_date_restriction` FROM `load-testing-202410`.`access_code_connections` AS `AccessCodeConnection` WHERE `AccessCodeConnection`.`model` = 'TicketType' AND `AccessCodeConnection`.`foreign_key` = ('5f6a820a-3f00-4aad-b604-1f080ad1e040') | 0 | 0 | 143 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`model` = 'TicketType' AND `Photo`.`foreign_key` = ('5f6a820a-3f00-4aad-b604-1f080ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `LinkedTicketType`.`id`, `LinkedTicketType`.`ticket_type_id`, `LinkedTicketType`.`master_ticket_type_id`, `LinkedTicketType`.`tickets_per_master` FROM `load-testing-202410`.`linked_ticket_types` AS `LinkedTicketType` WHERE `LinkedTicketType`.`ticket_type_id` = ('5f6a820a-3f00-4aad-b604-1f080ad1e040') | 0 | 0 | 9 | maybe slow |
SELECT `TicketTypesVoucherType`.`id`, `TicketTypesVoucherType`.`ticket_type_id`, `TicketTypesVoucherType`.`voucher_type_id`, `TicketTypesVoucherType`.`quantity` FROM `load-testing-202410`.`ticket_types_voucher_types` AS `TicketTypesVoucherType` WHERE `TicketTypesVoucherType`.`ticket_type_id` = ('5f6a820a-3f00-4aad-b604-1f080ad1e040') | 0 | 0 | 0 | |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5f6a820a-3f00-4aad-b604-1f080ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 | |
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`, `Gratuity`.`id`, `Gratuity`.`active`, `Gratuity`.`allow_custom`, `Gratuity`.`allow_zero`, `Gratuity`.`created`, `Gratuity`.`event_id`, `Gratuity`.`modified`, `Gratuity`.`options`, `Gratuity`.`title`, `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`ticket_types` AS `TicketType` LEFT JOIN `load-testing-202410`.`gratuities` AS `Gratuity` ON (`TicketType`.`gratuity_id` = `Gratuity`.`id`) LEFT JOIN `load-testing-202410`.`photos` AS `Logo` ON (`Logo`.`foreign_key` = `TicketType`.`id` AND `Logo`.`model` = 'TicketType' AND `Logo`.`type` = 'logo') WHERE `TicketType`.`id` = '5f6a813d-6910-44e1-bdf8-175c0ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TicketTypePrice`.`id`, `TicketTypePrice`.`price_each`, `TicketTypePrice`.`price_each_all_in`, `TicketTypePrice`.`name`, `TicketTypePrice`.`total_available`, `TicketTypePrice`.`ticket_type_id`, `TicketTypePrice`.`description`, `TicketTypePrice`.`sort`, `TicketTypePrice`.`created`, `TicketTypePrice`.`modified`, `TicketTypePrice`.`quantity_min`, `TicketTypePrice`.`quantity_max` FROM `load-testing-202410`.`ticket_type_prices` AS `TicketTypePrice` WHERE `TicketTypePrice`.`ticket_type_id` = ('5f6a813d-6910-44e1-bdf8-175c0ad1e040') ORDER BY `sort` ASC | 1 | 1 | 1 | |
SELECT `AccessCodeConnection`.`id`, `AccessCodeConnection`.`access_code_id`, `AccessCodeConnection`.`active`, `AccessCodeConnection`.`datetime_end`, `AccessCodeConnection`.`datetime_start`, `AccessCodeConnection`.`foreign_key`, `AccessCodeConnection`.`model`, `AccessCodeConnection`.`num_limit_orders`, `AccessCodeConnection`.`num_limit_tickets`, `AccessCodeConnection`.`use_date_restriction` FROM `load-testing-202410`.`access_code_connections` AS `AccessCodeConnection` WHERE `AccessCodeConnection`.`model` = 'TicketType' AND `AccessCodeConnection`.`foreign_key` = ('5f6a813d-6910-44e1-bdf8-175c0ad1e040') | 0 | 0 | 143 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`model` = 'TicketType' AND `Photo`.`foreign_key` = ('5f6a813d-6910-44e1-bdf8-175c0ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `LinkedTicketType`.`id`, `LinkedTicketType`.`ticket_type_id`, `LinkedTicketType`.`master_ticket_type_id`, `LinkedTicketType`.`tickets_per_master` FROM `load-testing-202410`.`linked_ticket_types` AS `LinkedTicketType` WHERE `LinkedTicketType`.`ticket_type_id` = ('5f6a813d-6910-44e1-bdf8-175c0ad1e040') | 0 | 0 | 9 | maybe slow |
SELECT `TicketTypesVoucherType`.`id`, `TicketTypesVoucherType`.`ticket_type_id`, `TicketTypesVoucherType`.`voucher_type_id`, `TicketTypesVoucherType`.`quantity` FROM `load-testing-202410`.`ticket_types_voucher_types` AS `TicketTypesVoucherType` WHERE `TicketTypesVoucherType`.`ticket_type_id` = ('5f6a813d-6910-44e1-bdf8-175c0ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5f6a813d-6910-44e1-bdf8-175c0ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 | |
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`, `Gratuity`.`id`, `Gratuity`.`active`, `Gratuity`.`allow_custom`, `Gratuity`.`allow_zero`, `Gratuity`.`created`, `Gratuity`.`event_id`, `Gratuity`.`modified`, `Gratuity`.`options`, `Gratuity`.`title`, `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`ticket_types` AS `TicketType` LEFT JOIN `load-testing-202410`.`gratuities` AS `Gratuity` ON (`TicketType`.`gratuity_id` = `Gratuity`.`id`) LEFT JOIN `load-testing-202410`.`photos` AS `Logo` ON (`Logo`.`foreign_key` = `TicketType`.`id` AND `Logo`.`model` = 'TicketType' AND `Logo`.`type` = 'logo') WHERE `TicketType`.`id` = '5f6a8349-24f0-499d-bf26-2fb60ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TicketTypePrice`.`id`, `TicketTypePrice`.`price_each`, `TicketTypePrice`.`price_each_all_in`, `TicketTypePrice`.`name`, `TicketTypePrice`.`total_available`, `TicketTypePrice`.`ticket_type_id`, `TicketTypePrice`.`description`, `TicketTypePrice`.`sort`, `TicketTypePrice`.`created`, `TicketTypePrice`.`modified`, `TicketTypePrice`.`quantity_min`, `TicketTypePrice`.`quantity_max` FROM `load-testing-202410`.`ticket_type_prices` AS `TicketTypePrice` WHERE `TicketTypePrice`.`ticket_type_id` = ('5f6a8349-24f0-499d-bf26-2fb60ad1e040') ORDER BY `sort` ASC | 1 | 1 | 1 | |
SELECT `AccessCodeConnection`.`id`, `AccessCodeConnection`.`access_code_id`, `AccessCodeConnection`.`active`, `AccessCodeConnection`.`datetime_end`, `AccessCodeConnection`.`datetime_start`, `AccessCodeConnection`.`foreign_key`, `AccessCodeConnection`.`model`, `AccessCodeConnection`.`num_limit_orders`, `AccessCodeConnection`.`num_limit_tickets`, `AccessCodeConnection`.`use_date_restriction` FROM `load-testing-202410`.`access_code_connections` AS `AccessCodeConnection` WHERE `AccessCodeConnection`.`model` = 'TicketType' AND `AccessCodeConnection`.`foreign_key` = ('5f6a8349-24f0-499d-bf26-2fb60ad1e040') | 0 | 0 | 143 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`model` = 'TicketType' AND `Photo`.`foreign_key` = ('5f6a8349-24f0-499d-bf26-2fb60ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `LinkedTicketType`.`id`, `LinkedTicketType`.`ticket_type_id`, `LinkedTicketType`.`master_ticket_type_id`, `LinkedTicketType`.`tickets_per_master` FROM `load-testing-202410`.`linked_ticket_types` AS `LinkedTicketType` WHERE `LinkedTicketType`.`ticket_type_id` = ('5f6a8349-24f0-499d-bf26-2fb60ad1e040') | 0 | 0 | 9 | maybe slow |
SELECT `TicketTypesVoucherType`.`id`, `TicketTypesVoucherType`.`ticket_type_id`, `TicketTypesVoucherType`.`voucher_type_id`, `TicketTypesVoucherType`.`quantity` FROM `load-testing-202410`.`ticket_types_voucher_types` AS `TicketTypesVoucherType` WHERE `TicketTypesVoucherType`.`ticket_type_id` = ('5f6a8349-24f0-499d-bf26-2fb60ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5f6a8349-24f0-499d-bf26-2fb60ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 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`, `Gratuity`.`id`, `Gratuity`.`active`, `Gratuity`.`allow_custom`, `Gratuity`.`allow_zero`, `Gratuity`.`created`, `Gratuity`.`event_id`, `Gratuity`.`modified`, `Gratuity`.`options`, `Gratuity`.`title`, `Logo`.`id`, `Logo`.`location`, `Logo`.`url`, `Logo`.`path`, `Logo`.`filename`, `Logo`.`original_filename`, `Logo`.`filesize`, `Logo`.`height`, `Logo`.`mime_type`, `Logo`.`width`, `Logo`.`type`, `Logo`.`foreign_key`, `Logo`.`model`, `Logo`.`caption`, `Logo`.`sort`, `Logo`.`modified`, `Logo`.`created` FROM `load-testing-202410`.`ticket_types` AS `TicketType` LEFT JOIN `load-testing-202410`.`gratuities` AS `Gratuity` ON (`TicketType`.`gratuity_id` = `Gratuity`.`id`) LEFT JOIN `load-testing-202410`.`photos` AS `Logo` ON (`Logo`.`foreign_key` = `TicketType`.`id` AND `Logo`.`model` = 'TicketType' AND `Logo`.`type` = 'logo') WHERE `TicketType`.`id` = '5f6a8306-e920-4d92-adc5-294d0ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TicketTypePrice`.`id`, `TicketTypePrice`.`price_each`, `TicketTypePrice`.`price_each_all_in`, `TicketTypePrice`.`name`, `TicketTypePrice`.`total_available`, `TicketTypePrice`.`ticket_type_id`, `TicketTypePrice`.`description`, `TicketTypePrice`.`sort`, `TicketTypePrice`.`created`, `TicketTypePrice`.`modified`, `TicketTypePrice`.`quantity_min`, `TicketTypePrice`.`quantity_max` FROM `load-testing-202410`.`ticket_type_prices` AS `TicketTypePrice` WHERE `TicketTypePrice`.`ticket_type_id` = ('5f6a8306-e920-4d92-adc5-294d0ad1e040') ORDER BY `sort` ASC | 1 | 1 | 1 | |
SELECT `AccessCodeConnection`.`id`, `AccessCodeConnection`.`access_code_id`, `AccessCodeConnection`.`active`, `AccessCodeConnection`.`datetime_end`, `AccessCodeConnection`.`datetime_start`, `AccessCodeConnection`.`foreign_key`, `AccessCodeConnection`.`model`, `AccessCodeConnection`.`num_limit_orders`, `AccessCodeConnection`.`num_limit_tickets`, `AccessCodeConnection`.`use_date_restriction` FROM `load-testing-202410`.`access_code_connections` AS `AccessCodeConnection` WHERE `AccessCodeConnection`.`model` = 'TicketType' AND `AccessCodeConnection`.`foreign_key` = ('5f6a8306-e920-4d92-adc5-294d0ad1e040') | 0 | 0 | 143 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `Photo`.`model` = 'TicketType' AND `Photo`.`foreign_key` = ('5f6a8306-e920-4d92-adc5-294d0ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `LinkedTicketType`.`id`, `LinkedTicketType`.`ticket_type_id`, `LinkedTicketType`.`master_ticket_type_id`, `LinkedTicketType`.`tickets_per_master` FROM `load-testing-202410`.`linked_ticket_types` AS `LinkedTicketType` WHERE `LinkedTicketType`.`ticket_type_id` = ('5f6a8306-e920-4d92-adc5-294d0ad1e040') | 0 | 0 | 9 | maybe slow |
SELECT `TicketTypesVoucherType`.`id`, `TicketTypesVoucherType`.`ticket_type_id`, `TicketTypesVoucherType`.`voucher_type_id`, `TicketTypesVoucherType`.`quantity` FROM `load-testing-202410`.`ticket_types_voucher_types` AS `TicketTypesVoucherType` WHERE `TicketTypesVoucherType`.`ticket_type_id` = ('5f6a8306-e920-4d92-adc5-294d0ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5f6a8306-e920-4d92-adc5-294d0ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a820a-3f00-4aad-b604-1f080ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a813d-6910-44e1-bdf8-175c0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a95de-a82c-4c26-a38b-037d0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a8349-24f0-499d-bf26-2fb60ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a8306-e920-4d92-adc5-294d0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a8940-db50-4e6d-b0e1-71300ad1e040' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a8940-db50-4e6d-b0e1-71300ad1e040' AND `Ticket`.`ticket_type_price_id` = '5f6a8940-f234-405d-a4cd-71300ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a8940-db50-4e6d-b0e1-71300ad1e040' AND `Ticket`.`ticket_type_price_id` = '5f6a8940-a96c-4990-951d-71300ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a8940-db50-4e6d-b0e1-71300ad1e040' AND `Ticket`.`ticket_type_price_id` = '5f6a8940-3d04-4be1-a3c1-71300ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f6a8940-db50-4e6d-b0e1-71300ad1e040' AND `Ticket`.`ticket_type_price_id` = '5f6a8940-36d0-4e30-9250-71300ad1e040' | 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` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' 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` = ('5f6a8bfa-b91c-4b4a-a244-144e0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' | 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` = '5f6a8b5c-6040-44c0-bc65-7cd60ad1e040' | 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` = '5f57c3cf-03cc-4165-b2cf-0b450ad1e040' | 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` = ('5f6a8bfa-b91c-4b4a-a244-144e0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' | 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` = '5f6a8b5c-6040-44c0-bc65-7cd60ad1e040' | 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` = '5f57c3cf-03cc-4165-b2cf-0b450ad1e040' | 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` = ('5f6a8bfa-b91c-4b4a-a244-144e0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' | 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` = '5f6a8b5c-6040-44c0-bc65-7cd60ad1e040' | 1 | 1 | 0 | |
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` = '5f57c3cf-03cc-4165-b2cf-0b450ad1e040' | 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` = ('5f6a8bfa-b91c-4b4a-a244-144e0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 0 | |
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` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' | 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` = '5f6a8b5c-6040-44c0-bc65-7cd60ad1e040' | 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` = '5f57c3cf-03cc-4165-b2cf-0b450ad1e040' | 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` = ('5f6a8bfa-b91c-4b4a-a244-144e0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 0 | |
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` = '5f6a813d-6910-44e1-bdf8-175c0ad1e040' | 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` = '5f6a820a-3f00-4aad-b604-1f080ad1e040' | 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` = '5f6a8306-e920-4d92-adc5-294d0ad1e040' | 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` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' 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` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 3 | 3 | 8 | 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` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' 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` = ('5f6a80fd-6ee8-47d7-9c85-14d40ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 1 | 1 | 0 | |
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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a80fd-6ee8-47d7-9c85-14d40ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 0 | |
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` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 1 | 1 | 0 | |
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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a80fd-6ee8-47d7-9c85-14d40ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 1 | 1 | 0 | |
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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a80fd-6ee8-47d7-9c85-14d40ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a80fd-6ee8-47d7-9c85-14d40ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040' | 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` = '5f6a8306-e920-4d92-adc5-294d0ad1e040' | 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` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' | 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` = '5f6a95de-a82c-4c26-a38b-037d0ad1e040' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' 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` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' GROUP BY `ActivityInstancesTicket`.`ticket_type_id` | 3 | 3 | 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` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' 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` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' 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` = ('5f6a8d60-db74-44c6-88d6-23cc0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 1 | 1 | 0 | |
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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a8d60-db74-44c6-88d6-23cc0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 0 | |
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` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 1 | 1 | 0 | |
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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a8d60-db74-44c6-88d6-23cc0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 0 | |
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` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 1 | 1 | 0 | |
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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a8d60-db74-44c6-88d6-23cc0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 0 | |
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` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' | 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` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' | 1 | 1 | 0 | |
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` = '5f6a4297-8dcc-4096-ae05-26b20ad1e040' | 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` = ('5f6a8d60-db74-44c6-88d6-23cc0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 4 | 4 | 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` = '5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040' | 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` = '5f6a8306-e920-4d92-adc5-294d0ad1e040' | 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` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' | 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` = '5f6a95de-a82c-4c26-a38b-037d0ad1e040' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' 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` = '5f6a8df2-7044-4c44-93ea-2b0d0ad1e040' 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` = ('5f6a8df2-7044-4c44-93ea-2b0d0ad1e040') 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` = '5f6a8df2-7044-4c44-93ea-2b0d0ad1e040' | 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` = '5f6a8d9c-76f4-4d51-80d4-24650ad1e040' | 1 | 1 | 0 | |
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` = '5f57c3cf-03cc-4165-b2cf-0b450ad1e040' | 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` = ('5f6a8df2-7044-4c44-93ea-2b0d0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 3 | 3 | 0 | |
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` = '5f6a8df2-7044-4c44-93ea-2b0d0ad1e040' | 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` = '5f6a8d9c-76f4-4d51-80d4-24650ad1e040' | 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` = '5f57c3cf-03cc-4165-b2cf-0b450ad1e040' | 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` = ('5f6a8df2-7044-4c44-93ea-2b0d0ad1e040') ORDER BY `ActivityInstanceTicketType`.`ticket_type_id` ASC | 3 | 3 | 0 | |
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` = '5f6a8df2-7044-4c44-93ea-2b0d0ad1e040' | 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` = '5f6a8d9c-76f4-4d51-80d4-24650ad1e040' | 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` = '5f57c3cf-03cc-4165-b2cf-0b450ad1e040' | 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` = ('5f6a8df2-7044-4c44-93ea-2b0d0ad1e040') 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` = '5f6a8306-e920-4d92-adc5-294d0ad1e040' | 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` = '5f6a8349-24f0-499d-bf26-2fb60ad1e040' | 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` = '5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040' | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`event_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`id` = '5f6a8df2-7044-4c44-93ea-2b0d0ad1e040' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5f6a8bfa-b91c-4b4a-a244-144e0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5f6a80fd-6ee8-47d7-9c85-14d40ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5f6a8d60-db74-44c6-88d6-23cc0ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`activity_instances_tickets` AS `ActivityInstancesTicket` WHERE `ActivityInstancesTicket`.`activity_instance_id` = '5f6a8df2-7044-4c44-93ea-2b0d0ad1e040' | 1 | 1 | 1 | |
SELECT `EventOrderField`.*, `OrderField`.* FROM `load-testing-202410`.`order_fields` AS `OrderField` left JOIN `load-testing-202410`.`event_order_fields` AS `EventOrderField` ON (`OrderField`.`id` = `EventOrderField`.`order_field_id` AND `EventOrderField`.`event_id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `EventOrderField`.`type` = 'front') WHERE 1 = 1 ORDER BY `OrderField`.`sort` ASC | 24 | 24 | 20 | maybe slow |
69 duplicate queries run.
Peak Memory Use 27.68 MB
Message | Memory use |
---|---|
Component initialization | 1.41 MB |
Controller action start | 2.35 MB |
Controller render start | 6.71 MB |
View render complete | 7.44 MB |
Total Request Time: 1634 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 100.20 | |
Event: Controller.initialize | 20.48 | |
Event: Controller.startup | 2.05 | |
Controller action | 1172.76 | |
Event: Controller.beforeRender | 77.70 | |
» Processing toolbar data | 77.54 | |
Rendering View | 17.06 | |
» Event: View.beforeRender | 0.03 | |
» Rendering | 0.66 | |
» Rendering #2 | 0.18 | |
» Rendering #3 | 2.67 | |
» Rendering #4 | 4.26 | |
» Rendering #5 | 5.00 | |
» Rendering #6 | 1.88 | |
» Rendering #7 | 1.90 | |
» Rendering #8 | 1.86 | |
» Rendering #9 | 1.83 | |
» Rendering #10 | 1.92 | |
» Rendering #11 | 1.09 | |
» Rendering #12 | 0.30 | |
» Rendering #13 | 0.38 | |
» Rendering #14 | 0.44 | |
» Rendering #15 | 0.26 | |
» Rendering #16 | 0.16 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering #17 | 1.00 | |
» Rendering #18 | 0.98 | |
» Rendering #19 | 0.48 | |
» Rendering #20 | 0.40 | |
» Rendering #21 | 0.45 | |
» Rendering #22 | 0.37 | |
» Rendering #23 | 0.23 | |
» Rendering #24 | 0.21 | |
» Rendering #25 | 0.25 | |
» Rendering #26 | 0.31 | |
» Rendering #27 | 0.79 | |
» Rendering #28 | 1.80 | |
» Rendering #29 | 1.21 | |
Event: View.afterLayout | 0.00 |
Type | Keyname | Took (ms) |
---|---|---|
read | debug_kit_eng | 0.86 |
read | cake_eng | 0.7 |
read | method_cache (missed) | 0.81 |
read | default_eng | 1.13 |
8 00 | 3.5 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | default_load-testing-202410_list | 0.84 |
read | default_load-testing-202410_events (missed) | 0.7 |
write | default_load-testing-202410_events | 0.6 |
read | default_load-testing-202410_events | 0.63 |
write | default_load-testing-202410_events | 1.21 |
read | default_load-testing-202410_connected_stripe_accounts (missed) | 0.73 |
write | default_load-testing-202410_connected_stripe_accounts | 0.79 |
read | default_load-testing-202410_connected_stripe_accounts | 0.64 |
write | default_load-testing-202410_connected_stripe_accounts | 0.69 |
read | default_load-testing-202410_themes (missed) | 0.6 |
write | default_load-testing-202410_themes | 0.55 |
read | default_load-testing-202410_themes | 0.55 |
write | default_load-testing-202410_themes | 0.69 |
read | default_load-testing-202410_layouts (missed) | 0.55 |
write | default_load-testing-202410_layouts | 0.57 |
read | default_load-testing-202410_layouts | 0.61 |
write | default_load-testing-202410_layouts | 0.8 |
read | default_load-testing-202410_photos (missed) | 0.57 |
write | default_load-testing-202410_photos | 0.52 |
read | default_load-testing-202410_photos | 0.56 |
write | default_load-testing-202410_photos | 0.65 |
read | default_load-testing-202410_custom_fonts (missed) | 0.62 |
write | default_load-testing-202410_custom_fonts | 0.55 |
read | default_load-testing-202410_custom_fonts | 0.54 |
write | default_load-testing-202410_custom_fonts | 0.55 |
read | default_load-testing-202410_events_social_networks (missed) | 0.52 |
write | default_load-testing-202410_events_social_networks | 0.49 |
read | default_load-testing-202410_events_social_networks | 0.52 |
write | default_load-testing-202410_events_social_networks | 0.61 |
read | default_load-testing-202410_social_networks (missed) | 0.55 |
write | default_load-testing-202410_social_networks | 0.49 |
read | default_load-testing-202410_social_networks | 0.55 |
write | default_load-testing-202410_social_networks | 0.59 |
read | default_load-testing-202410_sponsors (missed) | 0.58 |
write | default_load-testing-202410_sponsors | 0.52 |
read | default_load-testing-202410_sponsors | 0.7 |
write | default_load-testing-202410_sponsors | 0.67 |
read | default_load-testing-202410_event_passwords (missed) | 0.73 |
write | default_load-testing-202410_event_passwords | 0.62 |
read | default_load-testing-202410_event_passwords | 0.67 |
write | default_load-testing-202410_event_passwords | 0.72 |
read | default_load-testing-202410_events_langs (missed) | 0.62 |
write | default_load-testing-202410_events_langs | 0.63 |
read | default_load-testing-202410_events_langs | 0.61 |
write | default_load-testing-202410_events_langs | 0.6 |
read | default_load-testing-202410_langs (missed) | 0.66 |
write | default_load-testing-202410_langs | 0.64 |
read | default_load-testing-202410_langs | 0.63 |
write | default_load-testing-202410_langs | 0.63 |
read | default_load-testing-202410_ticket_types (missed) | 0.71 |
write | default_load-testing-202410_ticket_types | 0.79 |
read | default_load-testing-202410_ticket_types | 0.68 |
write | default_load-testing-202410_ticket_types | 1.01 |
read | default_load-testing-202410_ticket_type_prices (missed) | 0.72 |
write | default_load-testing-202410_ticket_type_prices | 0.58 |
read | default_load-testing-202410_ticket_type_prices | 0.63 |
write | default_load-testing-202410_ticket_type_prices | 0.75 |
read | default_load-testing-202410_activity_instances_ticket_types (missed) | 0.71 |
write | default_load-testing-202410_activity_instances_ticket_types | 0.6 |
read | default_load-testing-202410_activity_instances_ticket_types | 0.58 |
write | default_load-testing-202410_activity_instances_ticket_types | 0.71 |
read | default_load-testing-202410_linked_ticket_types (missed) | 0.6 |
write | default_load-testing-202410_linked_ticket_types | 0.62 |
read | default_load-testing-202410_linked_ticket_types | 0.62 |
write | default_load-testing-202410_linked_ticket_types | 0.66 |
read | default_load-testing-202410_ticket_types_voucher_types (missed) | 0.7 |
write | default_load-testing-202410_ticket_types_voucher_types | 0.55 |
read | default_load-testing-202410_ticket_types_voucher_types | 0.51 |
write | default_load-testing-202410_ticket_types_voucher_types | 0.55 |
read | default_load-testing-202410_activities (missed) | 0.61 |
write | default_load-testing-202410_activities | 0.56 |
read | default_load-testing-202410_activities | 0.6 |
write | default_load-testing-202410_activities | 0.87 |
read | default_load-testing-202410_activity_instances (missed) | 0.73 |
write | default_load-testing-202410_activity_instances | 0.65 |
read | default_load-testing-202410_activity_instances | 0.61 |
write | default_load-testing-202410_activity_instances | 0.76 |
read | default_load-testing-202410_activity_instances_tickets (missed) | 0.63 |
write | default_load-testing-202410_activity_instances_tickets | 0.6 |
read | default_load-testing-202410_activity_instances_tickets | 0.61 |
write | default_load-testing-202410_activity_instances_tickets | 0.68 |
read | default_load-testing-202410_gratuities (missed) | 0.6 |
write | default_load-testing-202410_gratuities | 0.69 |
read | default_load-testing-202410_gratuities | 0.57 |
write | default_load-testing-202410_gratuities | 0.72 |
read | default_load-testing-202410_access_code_connections (missed) | 0.59 |
write | default_load-testing-202410_access_code_connections | 0.69 |
read | default_load-testing-202410_access_code_connections | 0.65 |
write | default_load-testing-202410_access_code_connections | 0.8 |
read | default_load-testing-202410_tickets | 1.14 |
read | default_load-testing-202410_venues (missed) | 0.89 |
write | default_load-testing-202410_venues | 0.6 |
read | default_load-testing-202410_venues | 0.68 |
write | default_load-testing-202410_venues | 0.82 |
96 920 | 61.49 ms |
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | activity_by_slug_saturday-laughs_eventid_5f6a80fa-6048-447a-b379-14d40ad1e040 (missed) | 0.61 |
write | activity_by_slug_saturday-laughs_eventid_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.86 |
remember | activity_by_slug_saturday-laughs_eventid_5f6a80fa-6048-447a-b379-14d40ad1e040 | 13.76 |
read | activity_instances_by_activity_5f6a8d9c-76f4-4d51-80d4-24650ad1e040 | 0.86 |
read | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040 (missed) | 0.67 |
write | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040 | 1.28 |
remember | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040 | 25.9 |
read | activity_instances_by_activity_5f6a8b5c-6040-44c0-bc65-7cd60ad1e040 | 0.91 |
read | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040 (missed) | 0.66 |
write | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040 | 1.3 |
remember | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040 | 19.07 |
read | activity_instances_by_activity_5f6a80fb-0180-4c1d-aa53-14d40ad1e040 | 0.89 |
read | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040 (missed) | 0.57 |
write | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040 | 1.52 |
remember | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040 | 18.29 |
read | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040 (missed) | 0.56 |
write | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040 | 1.61 |
remember | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040 | 15.97 |
16 1010 | 105.29 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | activity_5f6a8d9c-76f4-4d51-80d4-24650ad1e040_all_registration_counts (missed) | 0.65 |
write | activity_5f6a8d9c-76f4-4d51-80d4-24650ad1e040_all_registration_counts | 0.58 |
remember | activity_5f6a8d9c-76f4-4d51-80d4-24650ad1e040_all_registration_counts | 6.86 |
read | activity_5f6a8b5c-6040-44c0-bc65-7cd60ad1e040_all_registration_counts (missed) | 0.72 |
write | activity_5f6a8b5c-6040-44c0-bc65-7cd60ad1e040_all_registration_counts | 0.73 |
remember | activity_5f6a8b5c-6040-44c0-bc65-7cd60ad1e040_all_registration_counts | 10.43 |
read | activity_5f6a80fb-0180-4c1d-aa53-14d40ad1e040_all_registration_counts (missed) | 0.57 |
write | activity_5f6a80fb-0180-4c1d-aa53-14d40ad1e040_all_registration_counts | 0.66 |
remember | activity_5f6a80fb-0180-4c1d-aa53-14d40ad1e040_all_registration_counts | 3.61 |
read | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040_registration_count (missed) | 0.6 |
write | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040_registration_count | 0.59 |
remember | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040_registration_count | 1.64 |
read | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040_registration_count (missed) | 0.6 |
write | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040_registration_count | 0.63 |
remember | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040_registration_count | 1.56 |
read | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040_registration_count (missed) | 0.73 |
write | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040_registration_count | 0.63 |
remember | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040_registration_count | 1.49 |
read | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040_registration_count (missed) | 0.76 |
write | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040_registration_count | 0.62 |
remember | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040_registration_count | 1.49 |
14 1414 | 36.15 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_settings_5f6a80fa-6048-447a-b379-14d40ad1e040 | 2.83 |
read | linked_ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 (missed) | 0.75 |
write | linked_ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 | 0.92 |
remember | linked_ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 | 10.84 |
read | event_attendee_limit_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.63 |
read | event_settings_5f6a80fa-6048-447a-b379-14d40ad1e040 | 2.99 |
8 22 | 18.96 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_organization_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.6 |
read | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040 (missed) | 0.55 |
write | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040 | 1.07 |
remember | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040 | 160.6 |
read | event_is_archived_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.67 |
read | venue_5f6a4297-8dcc-4096-ae05-26b20ad1e040 | 0.55 |
read | event_organization_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.6 |
10 22 | 164.64 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 (missed) | 0.7 |
write | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 | 1.11 |
remember | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 | 169.88 |
2 22 | 171.69 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_id_by_slug_timpanogos-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 | 0.73 |
read | event_setting_tickets_merch_product_name_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.51 |
read | event_custom_css_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.46 |
read | event_id_by_slug_timpanogos-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 | 0.63 |
read | get_organization_607e521e-b4c0-4f0f-befc-3b940a0000ba | 3.27 |
read | photos_event_masthead_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.69 |
12 00 | 6.29 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | custom_style_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.56 |
read | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040 (missed) | 0.54 |
write | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040 | 1.04 |
remember | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040 | 160.18 |
4 22 | 162.32 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | partner_settings_52e7320e-ed7c-4b47-a42c-57214834d839 | 3.16 |
read | venue_5f57c3cf-03cc-4165-b2cf-0b450ad1e040 | 0.65 |
read | venue_5f57c3cf-03cc-4165-b2cf-0b450ad1e040 | 0.7 |
6 00 | 4.51 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_setting_tickets_product_name_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.62 |
read | photos_activity_gallery_5f6a8d9c-76f4-4d51-80d4-24650ad1e040 (missed) | 0.64 |
write | photos_activity_gallery_5f6a8d9c-76f4-4d51-80d4-24650ad1e040 | 0.66 |
remember | photos_activity_gallery_5f6a8d9c-76f4-4d51-80d4-24650ad1e040 | 2.03 |
read | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040 (missed) | 0.6 |
write | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040 | 0.85 |
remember | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040 | 159.89 |
6 44 | 165.29 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_master_5f6a80fa-6048-447a-b379-14d40ad1e040_activity_timpanogos-event (missed) | 0.69 |
write | event_master_5f6a80fa-6048-447a-b379-14d40ad1e040_activity_timpanogos-event | 1.57 |
read | photos_event_ticket-masthead_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.77 |
4 20 | 3.03 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_partner_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.61 |
read | event_partner_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.85 |
4 00 | 1.46 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | partner_by_server_load_testing_rs_ticketsauce_com_null_null | 1.28 |
read | event_ticket_types_5f6a80fa-6048-447a-b379-14d40ad1e040 (missed) | 0.66 |
write | event_ticket_types_5f6a80fa-6048-447a-b379-14d40ad1e040 | 1.61 |
remember | event_ticket_types_5f6a80fa-6048-447a-b379-14d40ad1e040 | 43.47 |
read | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040 (missed) | 0.71 |
write | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040 | 1.06 |
remember | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040 | 159.86 |
read | event_order_fields_front_5f6a80fa-6048-447a-b379-14d40ad1e040 (missed) | 0.58 |
write | event_order_fields_front_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.9 |
remember | event_order_fields_front_5f6a80fa-6048-447a-b379-14d40ad1e040 | 22.95 |
8 66 | 233.08 ms |
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | toolbar_cache | 24.19 |
2 00 | 24.19 ms |
No cache activities
No cache activities
No cache activities
No cache activities
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_5f6a80fa-6048-447a-b379-14d40ad1e040_ticket_count | 0.64 |
read | event_5f6a80fa-6048-447a-b379-14d40ad1e040_ticket_count | 0.71 |
4 00 | 1.35 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040_count (missed) | 0.75 |
write | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040_count | 0.62 |
remember | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040_count | 3.09 |
read | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040_count (missed) | 0.77 |
write | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040_count | 0.59 |
remember | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040_count | 1.54 |
read | ticket_type_5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040_count (missed) | 0.55 |
write | ticket_type_5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040_count | 0.68 |
remember | ticket_type_5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040_count | 1.6 |
read | ticket_type_5f6a95de-a82c-4c26-a38b-037d0ad1e040_count (missed) | 0.58 |
write | ticket_type_5f6a95de-a82c-4c26-a38b-037d0ad1e040_count | 0.74 |
remember | ticket_type_5f6a95de-a82c-4c26-a38b-037d0ad1e040_count | 1.64 |
read | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040_count (missed) | 0.67 |
write | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040_count | 0.66 |
remember | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040_count | 1.52 |
read | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040_count (missed) | 0.61 |
write | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040_count | 0.68 |
remember | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040_count | 1.46 |
read | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040_count (missed) | 0.61 |
write | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040_count | 0.57 |
remember | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040_count | 1.36 |
read | ticket_type_5f6a8940-db50-4e6d-b0e1-71300ad1e040_count (missed) | 0.68 |
write | ticket_type_5f6a8940-db50-4e6d-b0e1-71300ad1e040_count | 0.63 |
remember | ticket_type_5f6a8940-db50-4e6d-b0e1-71300ad1e040_count | 1.27 |
read | ticket_type_price_5f6a8940-f234-405d-a4cd-71300ad1e040_count (missed) | 0.84 |
write | ticket_type_price_5f6a8940-f234-405d-a4cd-71300ad1e040_count | 0.72 |
remember | ticket_type_price_5f6a8940-f234-405d-a4cd-71300ad1e040_count | 1.56 |
read | ticket_type_price_5f6a8940-a96c-4990-951d-71300ad1e040_count (missed) | 0.64 |
write | ticket_type_price_5f6a8940-a96c-4990-951d-71300ad1e040_count | 0.58 |
remember | ticket_type_price_5f6a8940-a96c-4990-951d-71300ad1e040_count | 1.32 |
read | ticket_type_price_5f6a8940-3d04-4be1-a3c1-71300ad1e040_count (missed) | 0.58 |
write | ticket_type_price_5f6a8940-3d04-4be1-a3c1-71300ad1e040_count | 0.61 |
remember | ticket_type_price_5f6a8940-3d04-4be1-a3c1-71300ad1e040_count | 1.55 |
read | ticket_type_price_5f6a8940-36d0-4e30-9250-71300ad1e040_count (missed) | 0.6 |
write | ticket_type_price_5f6a8940-36d0-4e30-9250-71300ad1e040_count | 0.58 |
remember | ticket_type_price_5f6a8940-36d0-4e30-9250-71300ad1e040_count | 1.55 |
24 2424 | 35 ms |
No cache activities