Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Event`.`id` FROM `load-testing-202410`.`events` AS `Event` WHERE `slug` = 'ts-concert-classic' AND `partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `EventSettingKey`.`id`, `EventSettingKey`.`active`, `EventSettingKey`.`created`, `EventSettingKey`.`default_value`, `EventSettingKey`.`description`, `EventSettingKey`.`key`, `EventSettingKey`.`max_length`, `EventSettingKey`.`max_number`, `EventSettingKey`.`min_length`, `EventSettingKey`.`min_number`, `EventSettingKey`.`modified`, `EventSettingKey`.`name`, `EventSettingKey`.`options`, `EventSettingKey`.`partner_only`, `EventSettingKey`.`type`, `EventSettingKey`.`setting_key_id` FROM `load-testing-202410`.`event_setting_keys` AS `EventSettingKey` WHERE `key` = 'Tickets.merch_product_name' LIMIT 1 | 1 | 1 | 1 | |
SELECT `EventSetting`.`id`, `EventSetting`.`event_id`, `EventSetting`.`event_setting_key_id`, `EventSetting`.`value`, `EventSetting`.`created`, `EventSetting`.`modified` FROM `load-testing-202410`.`event_settings` AS `EventSetting` WHERE `event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `EventSetting`.`event_setting_key_id` = ('8ec7d096-3d4f-407d-9815-df44685ec508') | 1 | 1 | 1 | |
SELECT `CustomStyle`.`id`, `CustomStyle`.`event_id`, `CustomStyle`.`layout_id`, `CustomStyle`.`layout_slug`, `CustomStyle`.`custom_css_options`, `CustomStyle`.`page_bg`, `CustomStyle`.`page_bg_gradient`, `CustomStyle`.`page_bg_modern`, `CustomStyle`.`page_header`, `CustomStyle`.`page_header_opacity`, `CustomStyle`.`page_header_text`, `CustomStyle`.`title_text`, `CustomStyle`.`title_date`, `CustomStyle`.`title_location`, `CustomStyle`.`button_bg`, `CustomStyle`.`button_text`, `CustomStyle`.`button_border`, `CustomStyle`.`button_bg_gradient`, `CustomStyle`.`purchase_main`, `CustomStyle`.`purchase_alt`, `CustomStyle`.`header_bg`, `CustomStyle`.`header_border`, `CustomStyle`.`header_text`, `CustomStyle`.`header_bg_gradient`, `CustomStyle`.`content_bg`, `CustomStyle`.`content_text`, `CustomStyle`.`content_links`, `CustomStyle`.`content_bg_gradient`, `CustomStyle`.`masthead_text`, `CustomStyle`.`modified`, `CustomStyle`.`created`, `CustomStyle`.`tmp_cloudinary_converted` FROM `load-testing-202410`.`custom_styles` AS `CustomStyle` WHERE `event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' LIMIT 1 | 1 | 1 | 1 | |
SELECT `StaticAsset`.`id`, `StaticAsset`.`foreign_key`, `StaticAsset`.`model`, `StaticAsset`.`file_type`, `StaticAsset`.`url`, `StaticAsset`.`created`, `StaticAsset`.`modified` FROM `load-testing-202410`.`static_assets` AS `StaticAsset` WHERE `foreign_key` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `model` = 'Event' AND `file_type` = 'css' LIMIT 1 | 0 | 0 | 1 | maybe slow |
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`, `Masthead`.`id`, `Masthead`.`location`, `Masthead`.`url`, `Masthead`.`path`, `Masthead`.`filename`, `Masthead`.`original_filename`, `Masthead`.`filesize`, `Masthead`.`height`, `Masthead`.`mime_type`, `Masthead`.`width`, `Masthead`.`type`, `Masthead`.`foreign_key`, `Masthead`.`model`, `Masthead`.`caption`, `Masthead`.`sort`, `Masthead`.`modified`, `Masthead`.`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') LEFT JOIN `load-testing-202410`.`photos` AS `Masthead` ON (`Masthead`.`foreign_key` = `Event`.`id` AND `Masthead`.`model` = 'Event' AND `Masthead`.`type` = 'masthead') WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Event`.`status` = 0 ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 2 | 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`.`model` = 'Event' AND `TicketType`.`foreign_key` = ('5a283381-53cc-42fa-b12c-19320ab0c9ad') ORDER BY `product_type` DESC, `sort` ASC | 12 | 12 | 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 ('5a283381-e498-4eb8-8fd0-19320ab0c9ad', '5a283381-c7a8-44b5-add4-19320ab0c9ad', '5a283381-c090-4fbc-8e99-19320ab0c9ad', '5a283381-742c-4c79-9098-19320ab0c9ad', '5a283381-88f8-4f8a-b3f3-19320ab0c9ad', '5a283381-8004-4d63-a205-19320ab0c9ad', '5f62417c-22c8-4c4d-b5e9-11990ad1e040', '5bd39483-5bd8-4a66-8632-416f0ab0c9ad', '647a59d8-43b8-4c48-9c85-5b5d0ad120a1', '66429396-bcf8-4f21-80fc-6f690ad1e02c', '665f8074-a284-4622-951a-2e9c0ad1e02c', '5ed5343c-13c4-4268-a489-1f010ad1e040') ORDER BY `sort` ASC | 16 | 16 | 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 ('5a283381-e498-4eb8-8fd0-19320ab0c9ad', '5a283381-c7a8-44b5-add4-19320ab0c9ad', '5a283381-c090-4fbc-8e99-19320ab0c9ad', '5a283381-742c-4c79-9098-19320ab0c9ad', '5a283381-88f8-4f8a-b3f3-19320ab0c9ad', '5a283381-8004-4d63-a205-19320ab0c9ad', '5f62417c-22c8-4c4d-b5e9-11990ad1e040', '5bd39483-5bd8-4a66-8632-416f0ab0c9ad', '647a59d8-43b8-4c48-9c85-5b5d0ad120a1', '66429396-bcf8-4f21-80fc-6f690ad1e02c', '665f8074-a284-4622-951a-2e9c0ad1e02c', '5ed5343c-13c4-4268-a489-1f010ad1e040') | 0 | 0 | 1 | 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 ('5a283381-e498-4eb8-8fd0-19320ab0c9ad', '5a283381-c7a8-44b5-add4-19320ab0c9ad', '5a283381-c090-4fbc-8e99-19320ab0c9ad', '5a283381-742c-4c79-9098-19320ab0c9ad', '5a283381-88f8-4f8a-b3f3-19320ab0c9ad', '5a283381-8004-4d63-a205-19320ab0c9ad', '5f62417c-22c8-4c4d-b5e9-11990ad1e040', '5bd39483-5bd8-4a66-8632-416f0ab0c9ad', '647a59d8-43b8-4c48-9c85-5b5d0ad120a1', '66429396-bcf8-4f21-80fc-6f690ad1e02c', '665f8074-a284-4622-951a-2e9c0ad1e02c', '5ed5343c-13c4-4268-a489-1f010ad1e040') | 0 | 0 | 1 | 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` = ('5a283381-53cc-42fa-b12c-19320ab0c9ad') | 3 | 3 | 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` = '99A42C06-2B79-45D1-90E4-7B799051A5E' | 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` = '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` = ('5a283381-53cc-42fa-b12c-19320ab0c9ad') ORDER BY `Sponsor`.`sort` ASC | 1 | 1 | 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` = '5aba8c67-ed78-43e9-bff7-3ab10ab0c9ad' 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` = '5aba8c67-ed78-43e9-bff7-3ab10ab0c9ad' AND `Photo`.`model` = 'Sponsor' AND `Photo`.`type` = 'mobile-banner' | 0 | 0 | 1 | maybe slow |
SELECT `VoucherType`.`id`, `VoucherType`.`description`, `VoucherType`.`event_id`, `VoucherType`.`id_ebms`, `VoucherType`.`range_end`, `VoucherType`.`range_start`, `VoucherType`.`active`, `VoucherType`.`terms_conditions`, `VoucherType`.`title`, `VoucherType`.`valid_string`, `VoucherType`.`created`, `VoucherType`.`modified` FROM `load-testing-202410`.`voucher_types` AS `VoucherType` WHERE `VoucherType`.`event_id` = ('5a283381-53cc-42fa-b12c-19320ab0c9ad') | 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` = ('5a283381-53cc-42fa-b12c-19320ab0c9ad') | 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` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `EventsLang`.`lang_id` = `Lang`.`id`) | 0 | 0 | 1 | maybe slow |
SELECT `AccessCode`.`id`, `AccessCode`.`active`, `AccessCode`.`code`, `AccessCode`.`end`, `AccessCode`.`created`, `AccessCode`.`event_id`, `AccessCode`.`id_batch`, `AccessCode`.`ignore_connections`, `AccessCode`.`is_date_restricted`, `AccessCode`.`modified`, `AccessCode`.`usage`, `AccessCode`.`usage_limit` FROM `load-testing-202410`.`access_codes` AS `AccessCode` WHERE `event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' | 0 | 0 | 36 | maybe slow |
SELECT `Event`.`partner_id` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`organization_id` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `EventSettingKey`.*, `Setting`.`value`, `EventSettingKey`.`id` FROM `load-testing-202410`.`event_setting_keys` AS `EventSettingKey` LEFT JOIN `load-testing-202410`.`settings` AS `Setting` ON (`Setting`.`setting_key_id` = `EventSettingKey`.`setting_key_id` AND `Setting`.`foreign_key` IN ('52e7320e-ed7c-4b47-a42c-57214834d839', '607e521e-b4c0-4f0f-befc-3b940a0000ba')) WHERE `EventSettingKey`.`active` = '1' | 201 | 201 | 10 | |
SELECT `EventSetting`.`id`, `EventSetting`.`event_id`, `EventSetting`.`event_setting_key_id`, `EventSetting`.`value`, `EventSetting`.`created`, `EventSetting`.`modified` FROM `load-testing-202410`.`event_settings` AS `EventSetting` WHERE `event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `EventSetting`.`event_setting_key_id` IN ('f4d10a30-d1bf-4dc4-ba6e-73d2537a3cc5', 'ad7dd78e-c698-4b24-9a97-8909d278a0a8', '10c6bc5d-fe6b-4f3b-b44d-8ab7dbee529f', 'dec660b1-6c1a-4926-aff3-a9bbc0bce833', '31cdf0d4-618b-4ce3-ae4d-f098c09b8729', 'C9D6C7B0-2943-4C7F-8985-0BC216AA0792', 'd2341589-edab-4c60-b0ed-a3fccf549127', 'e3712c4e-46e4-47a0-aa54-33dbcd3e1bcc', 'CC8249F5-DF5E-49A6-B0C2-FA90CA10DE2E', 'eada837b-9067-4892-9bb3-fa7ad3e0b1ab', 'd5f86f97-a85b-4699-8f33-68e6d941a9cd', 'd26cb727-6f5c-45cf-a945-be466fb1f467', '040902af-e031-4b6a-8bc6-6f1a31fb5391', '2dd82c20-5ca0-4dfb-88c9-efc761e657e5', '156233e3-25c8-4c8e-8aac-1c3c3b7506fa', '8ad50d13-4f96-4d93-a882-91e0710590ba', 'C88D04D5-18D2-4ABB-A38D-EAF11F68DF30', '0016db09-9beb-4f22-9b4a-a429bfe5b6f4', '003db2ce-0a61-4c8b-8c89-ac7efab648ed', '005bbdde-7dfc-4422-8ebc-4b6d92f97772', '00a9f7e2-f9ba-43f9-98b8-dd810248396f', '07e9d2a9-7a77-4420-8637-21c58df04278', '08e2d3f4-2dc8-4bc9-8d4b-54baaa81fc2f', '09bcee2a-5a0a-4306-9ec3-8f9d6a239995', '09de97d6-3837-44f7-8516-28c5dea62b2a', '0ac5b2b8-7b58-46ca-89e3-41d71029439b', '0b9aa2c3-e1e5-4a9d-a742-437864550ac6', '0BC959DE-943A-49A4-AE6F-A2AA45A98BDB', '0c555fb0-e335-4241-b449-44d7723e7123', '0e504ebf-4298-4f18-ea88-0cb6fcfe22c9', '12d5c5bc-a05f-4ae6-afca-b4bbd5868327', '136ca962-4bfb-47a3-f033-3bb5b7f66863', '1394ef99-d8ba-4124-bac0-f6e8abcf70de', '149181fb-60ed-4839-9849-512590bb0121', '14d59e12-d1a0-48ec-aa21-5b6b2332cc38', '153e4ec3-f57b-48af-b550-2aa388f8e8ec', '192206cb-4d5a-4957-b271-5e82e6765739', '19fb37cd-524a-4a34-82ec-96a1b14b3c91', '1b38dfb6-308d-4944-9571-9578390a1853', '1c811547-3bca-4fb0-ad16-b9f530620f37', '1dd43a51-dff9-4d2a-e483-5ecb54110991', '1e4fe225-540f-441e-8aa8-9ab42f43d05a', '1f16034c-4636-413b-8df8-592a4afd4fd6', '1f1642fc-9deb-49d2-85ee-a350953fe01f', '2097897f-8225-46c0-8d2c-baba03ff2a7c', '20bfdec9-82f5-4a9f-9052-1272e2671dc5', '21da256b-c1ab-434e-8a1e-11570f1e9269', '22d23042-021a-470e-843c-68d511c2afab', '23864706-7c67-4412-cfdf-1fbd8b7e5173', '24B64378-B2B5-42A3-B1C3-5CE5759E8F57', '286a5818-adf8-4881-a527-0726f96c3353', '29a644ce-d781-4a84-b2bb-8bd69b2f8c64', '2a7d7d80-5cd0-48ac-b912-5eaa71a0e910', '2b75a8d2-6d95-4498-dde6-fed42878eabe', '2d33397b-5d7d-42da-95d5-a8c5e162c468', '306b71f5-e2fd-40bd-bcc9-816634c86529', '317a8363-d6f9-4a3f-af95-eed4a33c66a4', '3520bbe1-814e-43d4-96b8-f05dcae766a2', '3549d63b-94e0-4e6d-a362-2e3727060d3e', '35cb82f7-6cd3-4d23-999f-f4911917ca43', '35D8EE34-84FC-43B5-B515-50260D6BF24B', '3643bc3d-8c21-4e05-cfc5-356e1d305734', '368e7f9c-1c73-46dc-cf0e-646013ac3974', '3a3eae06-687b-4ea4-b99a-0f61d2c30c3b', '3a4fdbf8-5ac5-48b6-9bd9-48b8ec251175', '3c719a75-a590-4e77-9717-23287917f1cc', '3d5beb30-a07f-4e89-dc62-90c0a758caf6', '3ddbfef9-3894-4fa6-a3a2-a240390e4d21', '3E7CF49D-9F1C-454C-9191-474BFB7C24E3', '3fe215f2-6eda-4944-8fee-83aa4cf8526d', '40696363-e245-4a79-e827-f7164a4a855e', '40ea16f2-0ac0-441a-bae5-585a344569ae', '4244aea1-ebe5-48ad-931a-e75c70be6c7c', '45bad433-7fd0-4e95-a5c2-b44c9d2bd5d1', '48169947-7214-471a-82a5-487863ac6e7f', '49396a38-96a6-48ad-e0dc-e557861a524b', '4C90CB39-AC11-494C-B51B-237096AA74C2', '4cb124e7-b64c-48a4-b0e0-9d188e003584', '4e2bef25-4b56-4290-ad37-0b5bc4825743', '4e442a17-d557-4e5b-8f3f-78ff3245f8a5', '4e5d8ad0-2028-4e71-e6fe-72b83aabd45e', '4f66c2bb-c3bc-4f7e-8f69-be89b3549d1d', '529210f0-d0bd-4054-b0ad-d0584cdba061', '53c37247-df5f-4111-97aa-a8f827043a29', '593b3a3f-1243-4d5b-bef6-31cc776ee92a', '5ba62ab9-5aca-41e0-a766-5fba9cd1ba86', '5ba6df65-e694-4c09-bf75-02f0b03f0efa', '5d99787e-05dc-42e0-aa53-adbce715bf0e', '5f7ba5f9-b82a-468e-b60d-caad9daa2e23', '5fa1ae04-741c-44ca-8293-98140815c0b7', '613eb886-6e26-426d-ac85-a939987b6af8', '656F1D80-C0AE-49D0-88DA-5BC2F6BCD057', '67c0a36b-52ab-491a-97bb-f24ceb17c670', '6898a2b6-62b7-428d-8b70-5370ee5d28dc', '6b42d197-1c75-4a27-d109-28e8b3b83e24', '6edb39ef-7433-4295-9416-37a8414f108b', '6f9b57ed-0d0a-4920-ace6-2295eb31bac7', '706c447a-fb78-4a62-9de0-aba65422f3ed', '7137cc11-faac-48b3-e4b9-3e55790c422c', '71c2b172-c709-4006-af1d-781a58814b31', '73c38086-36f2-483e-9127-2a1ab1dfc5ca', '758fe331-4b1c-44e7-b0de-1ce31f96be38', '76601ba6-2bc2-408e-a8e8-8ee0f8bb3436', '76a4bbb9-16f6-406c-980c-d7033333166d', '77b571a5-d9f7-4b14-cbcd-004b2a815080', '77d34355-d631-491e-bfae-6a231b7cacac', '7a288782-b1d4-4ff2-af8a-05041b23503b', '7e4189a8-e643-4286-9220-65e1dc49e3d5', '80b1df13-de0a-4583-ec5e-1499c7ad43ce', '844BE464-13E7-471F-B917-E2F8B15F99EF', '86c22b53-6ee7-45c0-9dcb-3b432613ffcc', '87cedb57-162c-436c-8ea2-149ea8ff5c64', '883730f9-6649-43a5-97b1-c2f118bad2bc', '88dc50c0-c3fc-476f-bcc3-37ae22a70863', '8abf5a2a-ce89-4eb9-b401-a6bcd186008f', '8b0a0e00-a4d7-49ae-8a99-445ca60e1338', '8d2d3b7e-1136-433d-edfd-4eceff78d7ad', '8ec7d096-3d4f-407d-9815-df44685ec508', '8fb20499-1490-4c30-8c36-4045f1b233e9', '9010f853-c217-472f-b82b-d67ba3b95b32', '903D0FF3-624C-4282-ABC7-5F750729D35D', '909c44a4-d40f-4f46-925b-4dccbfb5d719', '91ec0ea1-54d3-4ca1-956f-b2a5aa5f5549', '929e816b-e897-497d-8de1-2b02800050d3', '9751d2b6-fecc-4c8d-f168-d6449bf045eb', '9792fe39-0c27-4ce8-aa57-99455b6897c8', '98d067e6-f329-4e93-b196-bdddcd03cf53', '9be8dd38-f54b-4730-898c-a40daf9245b2', '9c9ba77c-92d0-410c-8506-981cff85a4db', '9da93173-c056-4f6c-843c-7e4ae4057ae1', '9DFD2A93-23DE-4B2D-A0D5-99D2C3170C2D', '9ec8c17b-5d56-467d-93d8-091a7c74a208', 'a018f581-4490-43a4-e677-fcd28d6be075', 'a111c05e-f22b-438f-8a44-a37cbb47ef77', 'a11e2396-f244-41ed-d8a4-168615d5902b', 'A2081AD3-1E86-4210-9FBB-341814D1C72B', 'a2ada0e6-ed02-4952-94b5-564c2e6ca0ca', 'a2fcbfbb-236c-4cfc-f505-b40c2ccd11a8', 'a566cb4e-5fb8-11ed-9b6a-0242ac120002', 'a755850c-bb0f-4085-8ba2-dfb4b852176d', 'a7759143-59dc-48d5-b9d6-90c607b299b1', 'a9229785-080f-49c7-9036-e6b0ffcbfe5f', 'aa8a6291-c828-470c-912f-8cd059ec81ab', 'ab0de414-d29d-4f81-8d17-c9aaa17d65b9', 'ac3bbfe8-14ef-440f-ff89-42bc309d1432', 'ae3b1a78-de75-49d7-b573-4191271fb213', 'B028C554-CDCC-4F7D-84DB-730D710BF9DD', 'b06b4f52-3368-469b-8675-dcb013374454', 'B0CE54CA-9E93-4F64-AA6F-75415F1CD132', 'b120cd78-6a79-4e51-885d-ccc323e16cba', 'b367d0db-780f-49c9-e42e-2ec68a4826e6', 'b4a2cacd-0dcb-4921-ae05-3d3f5b98f398', 'b6342604-0014-4064-9056-01c92ca75891', 'bbed0244-0bc7-406f-af5c-fb82b0f21fac', 'bc68ee05-86ed-4399-978a-573e5fc9f467', 'bf01c990-aee7-4715-ab7a-a4d5d20b6be5', 'C0C565FB-294A-4626-AF10-0C9A5563A973', 'c1eeae65-477c-4e2e-aa57-65768db2c861', 'c2bca760-603d-463d-9ecf-9ff303fbd368', 'c502a1d0-32d4-4939-93ee-0cfa86e2e269', 'C53B86BB-2D4A-41F1-BFB4-1EB1EB304FBF', 'c53d0ba0-7a63-4a24-90f8-c569be4f3cc4', 'c651f558-08ed-48df-8d66-5d0e7132464f', 'C7327672-B4FD-483B-A901-EA4DFB8D05EE', 'c9bc8509-f11e-4304-a356-43e917e5cade', 'ca366cff-0ce8-424f-b796-72654c3af37b', 'ccb79f51-f2de-4edd-a9c4-eacf35bc365f', 'cd859360-3f53-11ed-b878-0242ac120002', 'cf899c67-31ac-4341-a901-51d588331cca', 'd26aac1b-c283-4c06-c18b-de50cd03bccf', 'd33543da-9fea-4ef3-8e9e-177e31b7c10c', 'd45f8763-8bab-4b7d-8be8-abc4a3919897', 'D6FD1DC6-9BC6-42E7-BB9D-DA23B877E9E4', 'd76c110b-8f74-482f-8615-3970025ef94a', 'd8b2ea57-51f9-43fd-bef9-a11c4dc515aa', 'dab9a5d2-391f-4869-b08a-7f2a4fda879a', 'daf92624-217f-45e1-8765-4729c8276097', 'dbff275d-ffd2-4f8e-a08a-c731d47867de', 'dcf1bec5-b319-4829-a0c9-54fa7610d8de', 'dd0a5749-8822-44cd-a5f4-6a3aee1e7e45', 'de23449c-4751-4a2c-ed36-69c76488895c', 'dfd8432c-d4ef-471e-8405-9a3f0b198ee6', 'e0eb73df-d8a1-4e05-a91a-1b8e98ce0e01', 'e1eed2fc-69b0-4a4b-b944-f2cf7293f9a7', 'E4B3B60A-6216-4F97-8062-8291D70AB1C3', 'e5d6de32-e1c7-4cb8-8721-a3e9772fd97c', 'e67e3f77-2fbd-4949-a94d-0dc6a996e417', 'e6f31a0a-c779-43fa-b69d-190c1d21b357', 'e76953f9-a8df-4cbe-9e3e-aadb64b943d0', 'e8253e57-ad51-43db-80ec-2fea1a866f8c', 'EB1CDED9-5CB6-4F08-84CF-07F99FB2317A', 'f2757fbf-5033-4faf-aa06-31b215966a7b', 'f41898cb-8d88-44f9-8586-23a1e7c17cfb', 'f4b491e8-8a33-4559-b6e2-c595b8547045', 'f72964c5-a4f0-48d2-9570-4730ebac2045', 'f779b20f-e1e1-453c-b40e-667d065ac3e1', 'f83d5924-32a9-431a-f6f4-ce7bd98ee42a', 'f8849eba-1de5-4d5f-bd9a-8cebed588d18', 'F8BD683C-B0FC-441E-81DA-1BEF59BFE2E1', 'fd1105e1-76f8-4ac9-917d-8c235c3aeecc', 'ffc2be96-f3ca-4bce-87c3-97e6e8dd1f3f') | 159 | 159 | 3 | |
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` = 'Event' AND `foreign_key` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `type` = 'gallery' ORDER BY `sort` ASC | 3 | 3 | 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` = 'Event' AND `foreign_key` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `type` = 'secondary' ORDER BY `sort` ASC | 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 `model` = 'Event' AND `foreign_key` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `type` = 'masthead' ORDER BY `sort` ASC | 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 `model` = 'Event' AND `foreign_key` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `type` = 'ticket-masthead' ORDER BY `sort` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Video`.`id`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`type`, `Video`.`id_player`, `Video`.`id_video`, `Video`.`watch_url`, `Video`.`thumbnail_url`, `Video`.`foreign_key`, `Video`.`model`, `Video`.`modified`, `Video`.`created` FROM `load-testing-202410`.`videos` AS `Video` WHERE `model` = 'Event' AND `foreign_key` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT `Event`.`is_archived` FROM `load-testing-202410`.`events` AS `Event` WHERE `id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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`.`orders` AS `Order` WHERE `Order`.`event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Order`.`status` IN (1, 2) | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TicketTypeGroup`.* FROM `load-testing-202410`.`ticket_type_groups` AS `TicketTypeGroup` INNER JOIN `load-testing-202410`.`events_ticket_type_groups` AS `EventsTicketTypeGroup` ON (((`TicketTypeGroup`.`partner_id` IS NULL) OR (`TicketTypeGroup`.`partner_id` = '')) AND `TicketTypeGroup`.`id` = `EventsTicketTypeGroup`.`ticket_type_group_id` AND `EventsTicketTypeGroup`.`event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad') WHERE 1 = 1 ORDER BY `TicketTypeGroup`.`sort` ASC | 1 | 1 | 1 | |
SELECT `TicketTypeGroup`.`partner_id` FROM `load-testing-202410`.`ticket_type_groups` AS `TicketTypeGroup` WHERE `TicketTypeGroup`.`id` = '642f0f75-9570-4d58-9795-03b40ad1e02c' ORDER BY `TicketTypeGroup`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Partner`.`timezone` FROM `load-testing-202410`.`partners` AS `Partner` WHERE `Partner`.`id` = '' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Event`.`start`, `Event`.`end`, `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` LEFT JOIN `load-testing-202410`.`ticket_types` AS `TicketType` ON (`Ticket`.`ticket_type_id` = `TicketType`.`id`) WHERE `Ticket`.`event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Ticket`.`status` = 1 AND `Ticket`.`product_type` = 'ticket' AND `TicketType`.`ticketless` = '0' | 1 | 1 | 2 | maybe slow |
SELECT `Event`.`attendee_limit` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `WaitListSetting`.`id`, `WaitListSetting`.`attendance_limit_on`, `WaitListSetting`.`created`, `WaitListSetting`.`email_text`, `WaitListSetting`.`hrs_to_accept`, `WaitListSetting`.`event_id`, `WaitListSetting`.`modified`, `WaitListSetting`.`pre_text` FROM `load-testing-202410`.`wait_list_settings` AS `WaitListSetting` WHERE `event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Questionnaire`.`id`, `Questionnaire`.`name`, `Questionnaire`.`event_id`, `Questionnaire`.`sort`, `Questionnaire`.`pub_type`, `Questionnaire`.`active`, `Questionnaire`.`create_order_include`, `Questionnaire`.`create_order_required_enforced`, `Questionnaire`.`complimentary_include`, `Questionnaire`.`complimentary_required_enforced`, `Questionnaire`.`created`, `Questionnaire`.`modified` FROM `load-testing-202410`.`questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Questionnaire`.`pub_type` = 1 ORDER BY `Questionnaire`.`sort` ASC | 1 | 1 | 1 | |
SELECT `Question`.`id`, `Question`.`questionnaire_id`, `Question`.`question_option_id`, `Question`.`sort`, `Question`.`question_text`, `Question`.`response_type`, `Question`.`required`, `Question`.`ticket_type_id`, `Question`.`active`, `Question`.`attendee_name`, `Question`.`attendee_email`, `Question`.`has_follow`, `Question`.`created`, `Question`.`modified` FROM `load-testing-202410`.`questions` AS `Question` WHERE `Question`.`questionnaire_id` = ('5aba8dbc-0484-4fcb-9a28-3df90ab0c9ad') ORDER BY `Question`.`sort` ASC, `Question`.`created` ASC | 2 | 2 | 1 | maybe slow |
SELECT `QuestionOption`.`id`, `QuestionOption`.`question_id`, `QuestionOption`.`response_number`, `QuestionOption`.`response_text`, `QuestionOption`.`max_quantity`, `QuestionOption`.`sel_quantity`, `QuestionOption`.`created`, `QuestionOption`.`modified` FROM `load-testing-202410`.`question_options` AS `QuestionOption` WHERE `QuestionOption`.`question_id` IN ('5aba8dbc-72a4-4598-9735-3df90ab0c9ad', '5aba8dbc-c52c-435d-b598-3df90ab0c9ad') ORDER BY `QuestionOption`.`response_number` ASC | 4 | 4 | 1 | maybe slow |
SELECT `FollowUpQuestion`.`id`, `FollowUpQuestion`.`questionnaire_id`, `FollowUpQuestion`.`question_option_id`, `FollowUpQuestion`.`sort`, `FollowUpQuestion`.`question_text`, `FollowUpQuestion`.`response_type`, `FollowUpQuestion`.`required`, `FollowUpQuestion`.`ticket_type_id`, `FollowUpQuestion`.`active`, `FollowUpQuestion`.`attendee_name`, `FollowUpQuestion`.`attendee_email`, `FollowUpQuestion`.`has_follow`, `FollowUpQuestion`.`created`, `FollowUpQuestion`.`modified` FROM `load-testing-202410`.`questions` AS `FollowUpQuestion` WHERE `FollowUpQuestion`.`question_option_id` IN ('5aba8dbc-7660-4983-b8a0-3df90ab0c9ad', '5aba8dbc-ec10-4daf-b0c0-3df90ab0c9ad', '5aba8dbc-6ba8-492f-9c35-3df90ab0c9ad', '5aba8dbc-e8e8-4c8d-9853-3df90ab0c9ad') ORDER BY `FollowUpQuestion`.`sort` ASC | 1 | 1 | 1 | |
SELECT `QuestionOption`.`id`, `QuestionOption`.`question_id`, `QuestionOption`.`response_number`, `QuestionOption`.`response_text`, `QuestionOption`.`max_quantity`, `QuestionOption`.`sel_quantity`, `QuestionOption`.`created`, `QuestionOption`.`modified` FROM `load-testing-202410`.`question_options` AS `QuestionOption` WHERE `QuestionOption`.`question_id` = ('5aba8dbc-c910-445b-ab39-3df90ab0c9ad') ORDER BY `QuestionOption`.`response_number` ASC | 0 | 0 | 1 | maybe slow |
SELECT `QuestionsTicketType`.`id`, `QuestionsTicketType`.`question_id`, `QuestionsTicketType`.`ticket_type_id` FROM `load-testing-202410`.`questions_ticket_types` AS `QuestionsTicketType` WHERE `QuestionsTicketType`.`question_id` IN ('5aba8dbc-72a4-4598-9735-3df90ab0c9ad', '5aba8dbc-c52c-435d-b598-3df90ab0c9ad') | 0 | 0 | 8 | maybe slow |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`question_responses` AS `QuestionResponse` WHERE `QuestionResponse`.`question_option_id` = '5aba8dbc-7660-4983-b8a0-3df90ab0c9ad' | 1 | 1 | 1404 | maybe slow |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`question_responses` AS `QuestionResponse` WHERE `QuestionResponse`.`question_option_id` = '5aba8dbc-ec10-4daf-b0c0-3df90ab0c9ad' | 1 | 1 | 1394 | maybe slow |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`question_responses` AS `QuestionResponse` WHERE `QuestionResponse`.`question_option_id` = '5aba8dbc-6ba8-492f-9c35-3df90ab0c9ad' | 1 | 1 | 1399 | maybe slow |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`question_responses` AS `QuestionResponse` WHERE `QuestionResponse`.`question_option_id` = '5aba8dbc-e8e8-4c8d-9853-3df90ab0c9ad' | 1 | 1 | 1400 | maybe slow |
SELECT `Questionnaire`.`id`, `Questionnaire`.`name`, `Questionnaire`.`event_id`, `Questionnaire`.`sort`, `Questionnaire`.`pub_type`, `Questionnaire`.`active`, `Questionnaire`.`create_order_include`, `Questionnaire`.`create_order_required_enforced`, `Questionnaire`.`complimentary_include`, `Questionnaire`.`complimentary_required_enforced`, `Questionnaire`.`created`, `Questionnaire`.`modified` FROM `load-testing-202410`.`questionnaires` AS `Questionnaire` WHERE `Questionnaire`.`event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Questionnaire`.`pub_type` = 2 ORDER BY `Questionnaire`.`sort` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Charity`.*, `CharityEvent`.* FROM `load-testing-202410`.`charities` AS `Charity` inner JOIN `load-testing-202410`.`charities_events` AS `CharityEvent` ON (`Charity`.`id` = `CharityEvent`.`charity_id` AND `CharityEvent`.`event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad') WHERE `CharityEvent`.`event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `CharityEvent`.`active` = '1' AND `Charity`.`active` = '1' AND `Charity`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' | 0 | 0 | 3 | 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` FROM `load-testing-202410`.`ticket_types` AS `TicketType` LEFT JOIN `load-testing-202410`.`gratuities` AS `Gratuity` ON (`TicketType`.`gratuity_id` = `Gratuity`.`id`) WHERE `TicketType`.`foreign_key` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `TicketType`.`model` = 'Event' ORDER BY `TicketType`.`product_type` DESC, `TicketType`.`sort` ASC | 12 | 12 | 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 ('5a283381-e498-4eb8-8fd0-19320ab0c9ad', '5a283381-c7a8-44b5-add4-19320ab0c9ad', '5a283381-c090-4fbc-8e99-19320ab0c9ad', '5a283381-742c-4c79-9098-19320ab0c9ad', '5a283381-88f8-4f8a-b3f3-19320ab0c9ad', '5a283381-8004-4d63-a205-19320ab0c9ad', '5f62417c-22c8-4c4d-b5e9-11990ad1e040', '5bd39483-5bd8-4a66-8632-416f0ab0c9ad', '647a59d8-43b8-4c48-9c85-5b5d0ad120a1', '66429396-bcf8-4f21-80fc-6f690ad1e02c', '665f8074-a284-4622-951a-2e9c0ad1e02c', '5ed5343c-13c4-4268-a489-1f010ad1e040') ORDER BY `TicketTypePrice`.`sort` ASC | 16 | 16 | 1 | maybe slow |
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` IN ('5a283381-e498-4eb8-8fd0-19320ab0c9ad', '5a283381-c7a8-44b5-add4-19320ab0c9ad', '5a283381-c090-4fbc-8e99-19320ab0c9ad', '5a283381-742c-4c79-9098-19320ab0c9ad', '5a283381-88f8-4f8a-b3f3-19320ab0c9ad', '5a283381-8004-4d63-a205-19320ab0c9ad', '5f62417c-22c8-4c4d-b5e9-11990ad1e040', '5bd39483-5bd8-4a66-8632-416f0ab0c9ad', '647a59d8-43b8-4c48-9c85-5b5d0ad120a1', '66429396-bcf8-4f21-80fc-6f690ad1e02c', '665f8074-a284-4622-951a-2e9c0ad1e02c', '5ed5343c-13c4-4268-a489-1f010ad1e040') | 0 | 0 | 178 | 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 ('5a283381-e498-4eb8-8fd0-19320ab0c9ad', '5a283381-c7a8-44b5-add4-19320ab0c9ad', '5a283381-c090-4fbc-8e99-19320ab0c9ad', '5a283381-742c-4c79-9098-19320ab0c9ad', '5a283381-88f8-4f8a-b3f3-19320ab0c9ad', '5a283381-8004-4d63-a205-19320ab0c9ad', '5f62417c-22c8-4c4d-b5e9-11990ad1e040', '5bd39483-5bd8-4a66-8632-416f0ab0c9ad', '647a59d8-43b8-4c48-9c85-5b5d0ad120a1', '66429396-bcf8-4f21-80fc-6f690ad1e02c', '665f8074-a284-4622-951a-2e9c0ad1e02c', '5ed5343c-13c4-4268-a489-1f010ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a283381-e498-4eb8-8fd0-19320ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5a283381-e498-4eb8-8fd0-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5a283381-e498-4eb8-8fd0-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-e498-4eb8-8fd0-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5a283381-c7a8-44b5-add4-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5a283381-c7a8-44b5-add4-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-c7a8-44b5-add4-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-c7a8-44b5-add4-19320ab0c9ad' AND `Ticket`.`ticket_type_price_id` = '5a283381-6194-44f5-890f-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-c7a8-44b5-add4-19320ab0c9ad' AND `Ticket`.`ticket_type_price_id` = '620fd4d8-31e4-4cb9-8eee-2c420ad1e024' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5a283381-c090-4fbc-8e99-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5a283381-c090-4fbc-8e99-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-c090-4fbc-8e99-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5a283381-742c-4c79-9098-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5a283381-742c-4c79-9098-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-742c-4c79-9098-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5a283381-88f8-4f8a-b3f3-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5a283381-88f8-4f8a-b3f3-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-88f8-4f8a-b3f3-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5a283381-8004-4d63-a205-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5a283381-8004-4d63-a205-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5a283381-8004-4d63-a205-19320ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5f62417c-22c8-4c4d-b5e9-11990ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5f62417c-22c8-4c4d-b5e9-11990ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5f62417c-22c8-4c4d-b5e9-11990ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5bd39483-5bd8-4a66-8632-416f0ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5bd39483-5bd8-4a66-8632-416f0ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5bd39483-5bd8-4a66-8632-416f0ab0c9ad' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '647a59d8-43b8-4c48-9c85-5b5d0ad120a1' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '647a59d8-43b8-4c48-9c85-5b5d0ad120a1' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '647a59d8-43b8-4c48-9c85-5b5d0ad120a1' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '66429396-bcf8-4f21-80fc-6f690ad1e02c' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '66429396-bcf8-4f21-80fc-6f690ad1e02c' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '66429396-bcf8-4f21-80fc-6f690ad1e02c' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '665f8074-a284-4622-951a-2e9c0ad1e02c' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '665f8074-a284-4622-951a-2e9c0ad1e02c' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '665f8074-a284-4622-951a-2e9c0ad1e02c' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` = '' AND `Ticket`.`price` = 0 AND `Ticket`.`ticket_type_id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`promo_code` != '' AND `Ticket`.`ticket_type_id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' AND `Ticket`.`ticket_type_price_id` = '5ed5343d-2f98-425a-a52e-1f010ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' AND `Ticket`.`ticket_type_price_id` = '5ed5343d-80ec-461a-ba79-1f010ad1e040' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' AND `Ticket`.`ticket_type_price_id` = '5ed5343d-c5f8-4c35-a89a-1f010ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' AND `Ticket`.`ticket_type_price_id` = '5ed5343d-b72c-4e8f-8318-1f010ad1e040' | 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` = '5a283381-e498-4eb8-8fd0-19320ab0c9ad' 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` = ('5a283381-e498-4eb8-8fd0-19320ab0c9ad') 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` = ('5a283381-e498-4eb8-8fd0-19320ab0c9ad') | 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` = ('5a283381-e498-4eb8-8fd0-19320ab0c9ad') | 1 | 1 | 1 | |
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` = ('5a283381-e498-4eb8-8fd0-19320ab0c9ad') | 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` = ('5a283381-e498-4eb8-8fd0-19320ab0c9ad') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a283381-e498-4eb8-8fd0-19320ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '5a283381-c7a8-44b5-add4-19320ab0c9ad' 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` = ('5a283381-c7a8-44b5-add4-19320ab0c9ad') ORDER BY `sort` ASC | 2 | 2 | 1 | maybe slow |
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` = ('5a283381-c7a8-44b5-add4-19320ab0c9ad') | 0 | 0 | 152 | 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` = ('5a283381-c7a8-44b5-add4-19320ab0c9ad') | 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` = ('5a283381-c7a8-44b5-add4-19320ab0c9ad') | 0 | 0 | 11 | 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` = ('5a283381-c7a8-44b5-add4-19320ab0c9ad') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a283381-c7a8-44b5-add4-19320ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '5a283381-c090-4fbc-8e99-19320ab0c9ad' 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` = ('5a283381-c090-4fbc-8e99-19320ab0c9ad') 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` = ('5a283381-c090-4fbc-8e99-19320ab0c9ad') | 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` = ('5a283381-c090-4fbc-8e99-19320ab0c9ad') | 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` = ('5a283381-c090-4fbc-8e99-19320ab0c9ad') | 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` = ('5a283381-c090-4fbc-8e99-19320ab0c9ad') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a283381-c090-4fbc-8e99-19320ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '5a283381-742c-4c79-9098-19320ab0c9ad' 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` = ('5a283381-742c-4c79-9098-19320ab0c9ad') 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` = ('5a283381-742c-4c79-9098-19320ab0c9ad') | 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` = ('5a283381-742c-4c79-9098-19320ab0c9ad') | 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` = ('5a283381-742c-4c79-9098-19320ab0c9ad') | 0 | 0 | 10 | 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` = ('5a283381-742c-4c79-9098-19320ab0c9ad') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a283381-742c-4c79-9098-19320ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '5a283381-88f8-4f8a-b3f3-19320ab0c9ad' 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` = ('5a283381-88f8-4f8a-b3f3-19320ab0c9ad') 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` = ('5a283381-88f8-4f8a-b3f3-19320ab0c9ad') | 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` = ('5a283381-88f8-4f8a-b3f3-19320ab0c9ad') | 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` = ('5a283381-88f8-4f8a-b3f3-19320ab0c9ad') | 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` = ('5a283381-88f8-4f8a-b3f3-19320ab0c9ad') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a283381-88f8-4f8a-b3f3-19320ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '5a283381-8004-4d63-a205-19320ab0c9ad' 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` = ('5a283381-8004-4d63-a205-19320ab0c9ad') 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` = ('5a283381-8004-4d63-a205-19320ab0c9ad') | 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` = ('5a283381-8004-4d63-a205-19320ab0c9ad') | 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` = ('5a283381-8004-4d63-a205-19320ab0c9ad') | 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` = ('5a283381-8004-4d63-a205-19320ab0c9ad') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5a283381-8004-4d63-a205-19320ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '5f62417c-22c8-4c4d-b5e9-11990ad1e040' 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` = ('5f62417c-22c8-4c4d-b5e9-11990ad1e040') 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` = ('5f62417c-22c8-4c4d-b5e9-11990ad1e040') | 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` = ('5f62417c-22c8-4c4d-b5e9-11990ad1e040') | 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` = ('5f62417c-22c8-4c4d-b5e9-11990ad1e040') | 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` = ('5f62417c-22c8-4c4d-b5e9-11990ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5f62417c-22c8-4c4d-b5e9-11990ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '5bd39483-5bd8-4a66-8632-416f0ab0c9ad' 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` = ('5bd39483-5bd8-4a66-8632-416f0ab0c9ad') 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` = ('5bd39483-5bd8-4a66-8632-416f0ab0c9ad') | 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` = ('5bd39483-5bd8-4a66-8632-416f0ab0c9ad') | 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` = ('5bd39483-5bd8-4a66-8632-416f0ab0c9ad') | 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` = ('5bd39483-5bd8-4a66-8632-416f0ab0c9ad') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5bd39483-5bd8-4a66-8632-416f0ab0c9ad' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '647a59d8-43b8-4c48-9c85-5b5d0ad120a1' 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` = ('647a59d8-43b8-4c48-9c85-5b5d0ad120a1') 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` = ('647a59d8-43b8-4c48-9c85-5b5d0ad120a1') | 0 | 0 | 148 | 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` = ('647a59d8-43b8-4c48-9c85-5b5d0ad120a1') | 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` = ('647a59d8-43b8-4c48-9c85-5b5d0ad120a1') | 0 | 0 | 10 | 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` = ('647a59d8-43b8-4c48-9c85-5b5d0ad120a1') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '647a59d8-43b8-4c48-9c85-5b5d0ad120a1' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '66429396-bcf8-4f21-80fc-6f690ad1e02c' 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` = ('66429396-bcf8-4f21-80fc-6f690ad1e02c') 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` = ('66429396-bcf8-4f21-80fc-6f690ad1e02c') | 0 | 0 | 147 | 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` = ('66429396-bcf8-4f21-80fc-6f690ad1e02c') | 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` = ('66429396-bcf8-4f21-80fc-6f690ad1e02c') | 0 | 0 | 11 | 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` = ('66429396-bcf8-4f21-80fc-6f690ad1e02c') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '66429396-bcf8-4f21-80fc-6f690ad1e02c' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '665f8074-a284-4622-951a-2e9c0ad1e02c' 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` = ('665f8074-a284-4622-951a-2e9c0ad1e02c') 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` = ('665f8074-a284-4622-951a-2e9c0ad1e02c') | 0 | 0 | 149 | 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` = ('665f8074-a284-4622-951a-2e9c0ad1e02c') | 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` = ('665f8074-a284-4622-951a-2e9c0ad1e02c') | 1 | 1 | 10 | 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` = ('665f8074-a284-4622-951a-2e9c0ad1e02c') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '665f8074-a284-4622-951a-2e9c0ad1e02c' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' 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` = '665f8074-a284-4622-951a-2e9c0ad1e02c' ORDER BY `masterticket`.`sort` ASC | 1 | 1 | 10 | 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` = '5ed5343c-13c4-4268-a489-1f010ad1e040' 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` = ('5ed5343c-13c4-4268-a489-1f010ad1e040') ORDER BY `sort` ASC | 4 | 4 | 1 | maybe slow |
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` = ('5ed5343c-13c4-4268-a489-1f010ad1e040') | 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` = ('5ed5343c-13c4-4268-a489-1f010ad1e040') | 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` = ('5ed5343c-13c4-4268-a489-1f010ad1e040') | 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` = ('5ed5343c-13c4-4268-a489-1f010ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5ed5343c-13c4-4268-a489-1f010ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 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` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `EventOrderField`.`type` = 'front') WHERE 1 = 1 ORDER BY `OrderField`.`sort` ASC | 24 | 24 | 3 | maybe slow |
SELECT `PromoCode`.`id`, `PromoCode`.`code`, `PromoCode`.`active`, `PromoCode`.`event_id`, `PromoCode`.`use_dates`, `PromoCode`.`start`, `PromoCode`.`start_utc`, `PromoCode`.`end`, `PromoCode`.`end_utc`, `PromoCode`.`ticket_type_id_niu`, `PromoCode`.`total_available`, `PromoCode`.`minimum`, `PromoCode`.`tickets_per`, `PromoCode`.`all_ticket_type`, `PromoCode`.`discount_type`, `PromoCode`.`type`, `PromoCode`.`usage_type`, `PromoCode`.`discount`, `PromoCode`.`batch_id`, `PromoCode`.`created`, `PromoCode`.`modified` FROM `load-testing-202410`.`promo_codes` AS `PromoCode` WHERE `event_id` = '5a283381-53cc-42fa-b12c-19320ab0c9ad' AND `active` = 1 LIMIT 1 | 0 | 0 | 1 | maybe slow |
15 duplicate queries run.