No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Event`.`id` FROM `load-testing-202410`.`events` AS `Event` WHERE `slug` = 'zapier-test-event' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `EventSetting`.`event_setting_key_id` = ('8ec7d096-3d4f-407d-9815-df44685ec508') | 0 | 0 | 1 | maybe slow |
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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' LIMIT 1 | 1 | 1 | 1 | |
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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = ('5fce74e4-85d0-4213-8ac5-0b850ad1e040') ORDER BY `product_type` DESC, `sort` ASC | 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') ORDER BY `sort` ASC | 1 | 1 | 1 | |
SELECT `ActivityInstanceTicketType`.`id`, `ActivityInstanceTicketType`.`activity_instance_id`, `ActivityInstanceTicketType`.`auto_register`, `ActivityInstanceTicketType`.`max_allowed`, `ActivityInstanceTicketType`.`selective_register`, `ActivityInstanceTicketType`.`ticket_type_id`, `ActivityInstanceTicketType`.`post_purchase_register` FROM `load-testing-202410`.`activity_instances_ticket_types` AS `ActivityInstanceTicketType` WHERE `ActivityInstanceTicketType`.`ticket_type_id` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 0 | 0 | 0 | |
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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 0 | 0 | 0 | |
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` = ('5fce74e4-85d0-4213-8ac5-0b850ad1e040') | 0 | 0 | 0 | |
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` = ('5fce74e4-85d0-4213-8ac5-0b850ad1e040') ORDER BY `Sponsor`.`sort` ASC | 0 | 0 | 26 | 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` = ('5fce74e4-85d0-4213-8ac5-0b850ad1e040') | 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` = ('5fce74e4-85d0-4213-8ac5-0b850ad1e040') | 0 | 0 | 0 | |
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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' | 0 | 0 | 37 | maybe slow |
SELECT `Event`.`partner_id` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`organization_id` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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') | 96 | 96 | 2 | |
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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `type` = 'gallery' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' | 0 | 0 | 1 | maybe slow |
SELECT `Event`.`is_archived` FROM `load-testing-202410`.`events` AS `Event` WHERE `id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `Order`.`status` IN (1, 2) | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040') WHERE 1 = 1 ORDER BY `TicketTypeGroup`.`sort` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Event`.`start`, `Event`.`end`, `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 1 | |
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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `Ticket`.`status` = 1 AND `Ticket`.`product_type` = 'ticket' AND `TicketType`.`ticketless` = '0' | 1 | 1 | 1 | |
SELECT `Event`.`attendee_limit` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = ('611411e5-77cc-435e-9d9a-68c90ad1e040') ORDER BY `Question`.`sort` ASC, `Question`.`created` 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` = ('611411e5-a460-4636-bf04-68c90ad1e040') ORDER BY `QuestionOption`.`response_number` ASC | 3 | 3 | 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 ('611411e5-3d50-4b66-a249-68c90ad1e040', '611411e5-0218-46f2-813e-68c90ad1e040', '611411e5-a994-4b42-82ad-68c90ad1e040') ORDER BY `FollowUpQuestion`.`sort` 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` = ('611411e5-a460-4636-bf04-68c90ad1e040') | 0 | 0 | 8 | maybe slow |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`question_responses` AS `QuestionResponse` WHERE `QuestionResponse`.`question_option_id` = '611411e5-3d50-4b66-a249-68c90ad1e040' | 1 | 1 | 1412 | maybe slow |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`question_responses` AS `QuestionResponse` WHERE `QuestionResponse`.`question_option_id` = '611411e5-0218-46f2-813e-68c90ad1e040' | 1 | 1 | 1415 | maybe slow |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`question_responses` AS `QuestionResponse` WHERE `QuestionResponse`.`question_option_id` = '611411e5-a994-4b42-82ad-68c90ad1e040' | 1 | 1 | 1419 | 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `Questionnaire`.`pub_type` = 2 ORDER BY `Questionnaire`.`sort` ASC | 2 | 2 | 1 | maybe slow |
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` IN ('611411f4-1f54-49e5-b16e-70770ad1e040', '6114198c-ed0c-475e-935c-42690ad1e040') 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 ('611411f4-7d20-41b5-b718-70770ad1e040', '6114198c-3494-4626-8861-42690ad1e040') 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 ('611411f4-7d20-41b5-b718-70770ad1e040', '6114198c-3494-4626-8861-42690ad1e040') | 0 | 0 | 9 | 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040') WHERE `CharityEvent`.`event_id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `CharityEvent`.`active` = '1' AND `Charity`.`active` = '1' AND `Charity`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' | 1 | 1 | 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `TicketType`.`model` = 'Event' ORDER BY `TicketType`.`product_type` DESC, `TicketType`.`sort` ASC | 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') ORDER BY `TicketTypePrice`.`sort` ASC | 1 | 1 | 0 | |
SELECT `AccessCodeConnection`.`id`, `AccessCodeConnection`.`access_code_id`, `AccessCodeConnection`.`active`, `AccessCodeConnection`.`datetime_end`, `AccessCodeConnection`.`datetime_start`, `AccessCodeConnection`.`foreign_key`, `AccessCodeConnection`.`model`, `AccessCodeConnection`.`num_limit_orders`, `AccessCodeConnection`.`num_limit_tickets`, `AccessCodeConnection`.`use_date_restriction` FROM `load-testing-202410`.`access_code_connections` AS `AccessCodeConnection` WHERE `AccessCodeConnection`.`model` = 'TicketType' AND `AccessCodeConnection`.`foreign_key` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 0 | 0 | 143 | 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 0 | 0 | 1 | maybe slow |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5fce74f6-8d20-49e8-b6a5-7f770ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74f6-8d20-49e8-b6a5-7f770ad1e040' | 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` = '5fce74f6-8d20-49e8-b6a5-7f770ad1e040' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `load-testing-202410`.`tickets` AS `Ticket` WHERE `Ticket`.`status` = 1 AND `Ticket`.`ticket_type_id` = '5fce74f6-8d20-49e8-b6a5-7f770ad1e040' | 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` = '5fce74f6-8d20-49e8-b6a5-7f770ad1e040' 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 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` = ('5fce74f6-8d20-49e8-b6a5-7f770ad1e040') | 0 | 0 | 0 | |
SELECT `TicketType`.`foreign_key` FROM `load-testing-202410`.`ticket_types` AS `TicketType` WHERE `TicketType`.`id` = '5fce74f6-8d20-49e8-b6a5-7f770ad1e040' ORDER BY `TicketType`.`sort` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 | |
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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' 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` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `active` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `PromoCode`.`event_id` FROM `load-testing-202410`.`promo_codes` AS `PromoCode` WHERE `PromoCode`.`id` = '61141a63-73b8-4731-bfb4-49a10ad1e040' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`timezone` FROM `load-testing-202410`.`events` AS `Event` WHERE `Event`.`id` = '5fce74e4-85d0-4213-8ac5-0b850ad1e040' AND `Event`.`partner_id` = '52e7320e-ed7c-4b47-a42c-57214834d839' ORDER BY `start_utc` DESC LIMIT 1 | 1 | 1 | 0 |
8 duplicate queries run.
Peak Memory Use 27.09 MB
Message | Memory use |
---|---|
Component initialization | 1.41 MB |
Controller action start | 2.74 MB |
Controller render start | 7.95 MB |
View render complete | 8.95 MB |
Total Request Time: 5282 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 91.34 | |
Event: Controller.initialize | 43.91 | |
Event: Controller.startup | 1.61 | |
Controller action | 4918.66 | |
Event: Controller.beforeRender | 64.10 | |
» Processing toolbar data | 63.95 | |
Rendering View | 33.09 | |
» Event: View.beforeRender | 0.03 | |
» Rendering | 0.21 | |
» Rendering #2 | 0.50 | |
» Rendering #3 | 0.59 | |
» Rendering #4 | 0.21 | |
» Rendering #5 | 1.87 | |
» Rendering #6 | 3.04 | |
» Rendering #7 | 6.51 | |
» Rendering #8 | 10.47 | |
» Rendering #9 | 5.66 | |
» Rendering #10 | 4.77 | |
» Rendering #11 | 0.46 | |
» Rendering #12 | 0.50 | |
» Rendering #13 | 0.52 | |
» Rendering #14 | 0.79 | |
» Rendering #15 | 0.22 | |
» Rendering #16 | 0.44 | |
» Rendering #17 | 0.91 | |
» Rendering #18 | 0.84 | |
» Rendering #19 | 0.16 | |
» Rendering #20 | 0.17 | |
» Rendering #21 | 0.17 | |
» Rendering #22 | 0.16 | |
» Rendering #23 | 0.16 | |
» Rendering #24 | 0.21 | |
» Rendering #25 | 0.15 | |
» Rendering #26 | 0.12 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering #27 | 1.01 | |
» Rendering #28 | 1.21 | |
» Rendering #29 | 0.96 | |
» Rendering #30 | 0.69 | |
» Rendering #31 | 0.76 | |
» Rendering #32 | 0.70 | |
» Rendering #33 | 0.41 | |
» Rendering #34 | 0.43 | |
» Rendering #35 | 0.29 | |
» Rendering #36 | 0.46 | |
» Rendering #37 | 0.45 | |
» Rendering #38 | 0.98 | |
» Rendering #39 | 1.37 | |
» Rendering #40 | 2.66 | |
» Rendering #41 | 2.03 | |
» Rendering #42 | 0.40 | |
Event: View.afterLayout | 0.00 |
Type | Keyname | Took (ms) |
---|---|---|
read | debug_kit_eng | 0.64 |
read | method_cache | 1.24 |
read | cake_eng | 0.6 |
read | default_eng | 1.02 |
8 00 | 3.5 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | default_load-testing-202410_list | 0.71 |
read | default_load-testing-202410_events (missed) | 0.56 |
write | default_load-testing-202410_events | 0.58 |
read | default_load-testing-202410_events | 0.6 |
write | default_load-testing-202410_events | 1.15 |
read | default_load-testing-202410_event_setting_keys (missed) | 0.57 |
write | default_load-testing-202410_event_setting_keys | 0.65 |
read | default_load-testing-202410_event_setting_keys | 0.58 |
write | default_load-testing-202410_event_setting_keys | 0.76 |
read | default_load-testing-202410_event_settings (missed) | 0.54 |
write | default_load-testing-202410_event_settings | 0.57 |
read | default_load-testing-202410_event_settings | 0.64 |
write | default_load-testing-202410_event_settings | 0.64 |
read | default_load-testing-202410_custom_styles (missed) | 0.58 |
write | default_load-testing-202410_custom_styles | 0.51 |
read | default_load-testing-202410_custom_styles | 0.64 |
write | default_load-testing-202410_custom_styles | 0.77 |
read | default_load-testing-202410_connected_stripe_accounts (missed) | 0.57 |
write | default_load-testing-202410_connected_stripe_accounts | 0.55 |
read | default_load-testing-202410_connected_stripe_accounts | 0.55 |
write | default_load-testing-202410_connected_stripe_accounts | 0.61 |
read | default_load-testing-202410_themes (missed) | 0.51 |
write | default_load-testing-202410_themes | 0.51 |
read | default_load-testing-202410_themes | 0.51 |
write | default_load-testing-202410_themes | 0.54 |
read | default_load-testing-202410_layouts (missed) | 0.49 |
write | default_load-testing-202410_layouts | 0.48 |
read | default_load-testing-202410_layouts | 0.49 |
write | default_load-testing-202410_layouts | 0.63 |
read | default_load-testing-202410_photos (missed) | 0.51 |
write | default_load-testing-202410_photos | 0.49 |
read | default_load-testing-202410_photos | 0.52 |
write | default_load-testing-202410_photos | 0.63 |
read | default_load-testing-202410_custom_fonts (missed) | 0.66 |
write | default_load-testing-202410_custom_fonts | 0.53 |
read | default_load-testing-202410_custom_fonts | 0.61 |
write | default_load-testing-202410_custom_fonts | 0.59 |
read | default_load-testing-202410_ticket_types (missed) | 0.57 |
write | default_load-testing-202410_ticket_types | 0.59 |
read | default_load-testing-202410_ticket_types | 0.61 |
write | default_load-testing-202410_ticket_types | 0.97 |
read | default_load-testing-202410_gratuities (missed) | 0.58 |
write | default_load-testing-202410_gratuities | 0.65 |
read | default_load-testing-202410_gratuities | 0.63 |
write | default_load-testing-202410_gratuities | 0.67 |
read | default_load-testing-202410_ticket_type_prices (missed) | 0.58 |
write | default_load-testing-202410_ticket_type_prices | 0.61 |
read | default_load-testing-202410_ticket_type_prices | 0.59 |
write | default_load-testing-202410_ticket_type_prices | 0.68 |
read | default_load-testing-202410_activity_instances_ticket_types (missed) | 0.64 |
write | default_load-testing-202410_activity_instances_ticket_types | 0.61 |
read | default_load-testing-202410_activity_instances_ticket_types | 0.58 |
write | default_load-testing-202410_activity_instances_ticket_types | 0.65 |
read | default_load-testing-202410_ticket_types_voucher_types (missed) | 0.69 |
write | default_load-testing-202410_ticket_types_voucher_types | 0.59 |
read | default_load-testing-202410_ticket_types_voucher_types | 0.62 |
write | default_load-testing-202410_ticket_types_voucher_types | 0.59 |
read | default_load-testing-202410_events_social_networks (missed) | 0.52 |
write | default_load-testing-202410_events_social_networks | 0.56 |
read | default_load-testing-202410_events_social_networks | 0.6 |
write | default_load-testing-202410_events_social_networks | 0.63 |
read | default_load-testing-202410_sponsors (missed) | 0.66 |
write | default_load-testing-202410_sponsors | 0.56 |
read | default_load-testing-202410_sponsors | 0.61 |
write | default_load-testing-202410_sponsors | 0.92 |
read | default_load-testing-202410_voucher_types (missed) | 0.77 |
write | default_load-testing-202410_voucher_types | 0.58 |
read | default_load-testing-202410_voucher_types | 0.59 |
write | default_load-testing-202410_voucher_types | 0.75 |
read | default_load-testing-202410_event_passwords (missed) | 0.52 |
write | default_load-testing-202410_event_passwords | 0.55 |
read | default_load-testing-202410_event_passwords | 0.59 |
write | default_load-testing-202410_event_passwords | 0.63 |
read | default_load-testing-202410_events_langs (missed) | 0.61 |
write | default_load-testing-202410_events_langs | 1.43 |
read | default_load-testing-202410_events_langs | 0.58 |
write | default_load-testing-202410_events_langs | 0.6 |
read | default_load-testing-202410_langs (missed) | 0.61 |
write | default_load-testing-202410_langs | 0.55 |
read | default_load-testing-202410_langs | 0.56 |
write | default_load-testing-202410_langs | 0.62 |
read | default_load-testing-202410_access_codes (missed) | 0.54 |
write | default_load-testing-202410_access_codes | 0.54 |
read | default_load-testing-202410_access_codes | 0.62 |
write | default_load-testing-202410_access_codes | 0.72 |
read | default_load-testing-202410_access_code_connections (missed) | 0.76 |
write | default_load-testing-202410_access_code_connections | 0.57 |
read | default_load-testing-202410_access_code_connections | 0.62 |
write | default_load-testing-202410_access_code_connections | 0.78 |
read | default_load-testing-202410_videos (missed) | 0.56 |
write | default_load-testing-202410_videos | 0.49 |
read | default_load-testing-202410_videos | 0.57 |
write | default_load-testing-202410_videos | 0.67 |
read | default_load-testing-202410_orders (missed) | 0.59 |
write | default_load-testing-202410_orders | 0.57 |
read | default_load-testing-202410_orders | 0.61 |
write | default_load-testing-202410_orders | 1.35 |
read | default_load-testing-202410_tickets (missed) | 0.55 |
write | default_load-testing-202410_tickets | 0.52 |
read | default_load-testing-202410_tickets | 0.57 |
write | default_load-testing-202410_tickets | 1.11 |
read | default_load-testing-202410_wait_list_settings (missed) | 0.6 |
write | default_load-testing-202410_wait_list_settings | 0.54 |
read | default_load-testing-202410_wait_list_settings | 0.54 |
write | default_load-testing-202410_wait_list_settings | 0.68 |
read | default_load-testing-202410_questionnaires (missed) | 0.58 |
write | default_load-testing-202410_questionnaires | 0.6 |
read | default_load-testing-202410_questionnaires | 0.62 |
write | default_load-testing-202410_questionnaires | 0.7 |
read | default_load-testing-202410_questions (missed) | 0.55 |
write | default_load-testing-202410_questions | 0.58 |
read | default_load-testing-202410_questions | 0.59 |
write | default_load-testing-202410_questions | 0.67 |
read | default_load-testing-202410_question_options (missed) | 0.9 |
write | default_load-testing-202410_question_options | 0.58 |
read | default_load-testing-202410_question_options | 0.62 |
write | default_load-testing-202410_question_options | 0.68 |
read | default_load-testing-202410_questions_ticket_types (missed) | 0.55 |
write | default_load-testing-202410_questions_ticket_types | 0.55 |
read | default_load-testing-202410_questions_ticket_types | 0.52 |
write | default_load-testing-202410_questions_ticket_types | 0.5 |
read | default_load-testing-202410_question_responses (missed) | 0.63 |
write | default_load-testing-202410_question_responses | 0.57 |
read | default_load-testing-202410_question_responses | 0.59 |
write | default_load-testing-202410_question_responses | 0.72 |
read | default_load-testing-202410_charities (missed) | 1.01 |
write | default_load-testing-202410_charities | 0.82 |
read | default_load-testing-202410_charities | 0.62 |
write | default_load-testing-202410_charities | 0.65 |
read | default_load-testing-202410_charities_events (missed) | 0.54 |
write | default_load-testing-202410_charities_events | 0.71 |
read | default_load-testing-202410_charities_events | 0.6 |
write | default_load-testing-202410_charities_events | 0.77 |
read | default_load-testing-202410_linked_ticket_types (missed) | 0.64 |
write | default_load-testing-202410_linked_ticket_types | 0.62 |
read | default_load-testing-202410_linked_ticket_types | 0.54 |
write | default_load-testing-202410_linked_ticket_types | 0.55 |
read | default_load-testing-202410_promo_codes (missed) | 0.55 |
write | default_load-testing-202410_promo_codes | 0.57 |
read | default_load-testing-202410_promo_codes | 0.54 |
write | default_load-testing-202410_promo_codes | 0.64 |
142 1400 | 88.67 ms |
No cache activities
No cache activities
No cache activities
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_videos_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.63 |
write | event_videos_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.64 |
remember | event_videos_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 5.2 |
read | event_videos_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.63 |
4 22 | 7.1 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_is_archived_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.69 |
write | event_is_archived_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.73 |
remember | event_is_archived_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.7 |
read | event_is_archived_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.62 |
read | event_is_archived_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.7 |
6 22 | 4.44 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | custom_style_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.59 |
write | custom_style_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.59 |
remember | custom_style_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 6.41 |
read | event_master_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.5 |
write | event_master_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.22 |
read | event_organization_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.64 |
write | event_organization_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.63 |
remember | event_organization_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.5 |
read | event_timezone_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.8 |
write | event_timezone_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.68 |
remember | event_timezone_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.77 |
read | event_organization_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.66 |
read | event_start_and_end_w_timezone_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.63 |
write | event_start_and_end_w_timezone_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.62 |
remember | event_start_and_end_w_timezone_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.78 |
read | event_master_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.02 |
read | event_organization_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.7 |
read | event_timezone_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.68 |
read | order_questionnaires_event_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.65 |
write | order_questionnaires_event_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.9 |
remember | order_questionnaires_event_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 28.39 |
read | partner_gift_cards_52e7320e-ed7c-4b47-a42c-57214834d839 | 0.7 |
read | event_organization_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.78 |
read | event_organization_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.5 |
26 1210 | 53.34 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_id_by_slug_zapier-test-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 (missed) | 0.56 |
write | event_id_by_slug_zapier-test-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 | 0.6 |
remember | event_id_by_slug_zapier-test-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 | 10.23 |
read | event_id_by_slug_zapier-test-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 | 0.63 |
read | photos_event_secondary_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.61 |
write | photos_event_secondary_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.69 |
remember | photos_event_secondary_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.53 |
read | get_organization_607e521e-b4c0-4f0f-befc-3b940a0000ba | 4.09 |
read | photos_event_secondary_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.58 |
read | get_organization_607e521e-b4c0-4f0f-befc-3b940a0000ba | 2.82 |
read | question_option_611411e5-a994-4b42-82ad-68c90ad1e040_count (missed) | 0.61 |
write | question_option_611411e5-a994-4b42-82ad-68c90ad1e040_count | 0.74 |
remember | question_option_611411e5-a994-4b42-82ad-68c90ad1e040_count | 1419.9 |
14 66 | 1443.59 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | organization_settings_607e521e-b4c0-4f0f-befc-3b940a0000ba | 1.43 |
read | organization_settings_607e521e-b4c0-4f0f-befc-3b940a0000ba | 1.29 |
read | event_ticket_type_groups_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.63 |
write | event_ticket_type_groups_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.62 |
remember | event_ticket_type_groups_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 2.15 |
read | wait_list_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.69 |
write | wait_list_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.64 |
remember | wait_list_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 4.89 |
read | event_charities_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.97 |
write | event_charities_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.62 |
remember | event_charities_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 12.29 |
read | event_ticket_types_data_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.54 |
write | event_ticket_types_data_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1 |
remember | event_ticket_types_data_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 149.61 |
12 88 | 177.37 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | partner_settings_52e7320e-ed7c-4b47-a42c-57214834d839 | 2.44 |
read | event_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.65 |
write | event_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 8.76 |
remember | event_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 24.86 |
read | photos_event_masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.63 |
write | photos_event_masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.57 |
remember | photos_event_masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.39 |
read | partner_settings_52e7320e-ed7c-4b47-a42c-57214834d839 | 3.02 |
read | event_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 2.17 |
read | photos_event_masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.6 |
read | question_option_611411e5-0218-46f2-813e-68c90ad1e040_count (missed) | 0.7 |
write | question_option_611411e5-0218-46f2-813e-68c90ad1e040_count | 0.76 |
remember | question_option_611411e5-0218-46f2-813e-68c90ad1e040_count | 1416.17 |
read | attendee_questionnaires_event_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.58 |
write | attendee_questionnaires_event_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.82 |
remember | attendee_questionnaires_event_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 12.93 |
read | event_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 2.26 |
read | event_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 2.12 |
read | event_settings_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.9 |
22 88 | 1483.33 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_partner_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.67 |
write | event_partner_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.61 |
remember | event_partner_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.42 |
read | photos_event_gallery_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.6 |
write | photos_event_gallery_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.55 |
remember | photos_event_gallery_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.84 |
read | event_partner_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.73 |
read | event_partner_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.58 |
read | photos_event_gallery_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.66 |
read | question_option_611411e5-3d50-4b66-a249-68c90ad1e040_count (missed) | 0.55 |
write | question_option_611411e5-3d50-4b66-a249-68c90ad1e040_count | 0.82 |
remember | question_option_611411e5-3d50-4b66-a249-68c90ad1e040_count | 1417.77 |
read | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040 (missed) | 0.76 |
write | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040 | 0.86 |
remember | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040 | 163.53 |
read | has_active_promo_codes_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.52 |
write | has_active_promo_codes_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.53 |
remember | has_active_promo_codes_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 5.9 |
read | event_partner_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.54 |
read | event_partner_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.53 |
20 1010 | 1599.97 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_setting_tickets_merch_product_name_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.63 |
write | event_setting_tickets_merch_product_name_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.64 |
remember | event_setting_Tickets_merch_product_name_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 11.13 |
read | partner_ticket_type_groups_52e7320e-ed7c-4b47-a42c-57214834d839 | 1.17 |
read | event_attendee_limit_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.64 |
write | event_attendee_limit_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.6 |
remember | event_attendee_limit_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.58 |
read | event_order_fields_front_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.65 |
write | event_order_fields_front_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.85 |
remember | event_order_fields_front_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 4.79 |
8 66 | 22.68 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_setting_tickets_product_name_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.66 |
read | get_access_codes_by_event_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040_all (missed) | 0.67 |
write | get_access_codes_by_event_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040_all | 0.68 |
remember | get_access_codes_by_event_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040_all | 45.77 |
read | get_access_codes_by_event_id_5fce74e4-85d0-4213-8ac5-0b850ad1e040_all | 0.69 |
6 22 | 48.47 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | partner_by_server_load_testing_rs_ticketsauce_com_null_null | 1.02 |
read | photos_event_ticket-masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 (missed) | 0.57 |
write | photos_event_ticket-masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.56 |
remember | photos_event_ticket-masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 1.54 |
read | photos_event_ticket-masthead_5fce74e4-85d0-4213-8ac5-0b850ad1e040 | 0.66 |
6 22 | 4.35 ms |
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | toolbar_cache | 18.17 |
2 00 | 18.17 ms |
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_order_count (missed) | 0.6 |
write | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_order_count | 0.7 |
remember | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_order_count | 8.98 |
read | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_order_count | 0.59 |
4 22 | 10.87 ms |
No cache activities
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_ticket_count (missed) | 0.63 |
write | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_ticket_count | 0.71 |
remember | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_ticket_count | 8.29 |
read | event_5fce74e4-85d0-4213-8ac5-0b850ad1e040_ticket_count | 0.7 |
4 22 | 10.33 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_comped_count (missed) | 0.65 |
write | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_comped_count | 0.7 |
remember | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_comped_count | 1.95 |
read | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_promo_count (missed) | 0.64 |
write | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_promo_count | 0.61 |
remember | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_promo_count | 1.87 |
read | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_count (missed) | 0.61 |
write | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_count | 0.61 |
remember | ticket_type_5fce74f6-8d20-49e8-b6a5-7f770ad1e040_count | 1.63 |
6 66 | 9.27 ms |
No cache activities