No items available. |
No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Activity`.`id`, `Activity`.`created`, `Activity`.`details`, `Activity`.`event_id`, `Activity`.`has_gate`, `Activity`.`is_livestream`, `Activity`.`use_livestream_dac_time_restriction`, `Activity`.`livestream_dac_access_before`, `Activity`.`livestream_dac_access_after`, `Activity`.`livestream_embed_code`, `Activity`.`entry_requirement`, `Activity`.`ticket_type_restrictions`, `Activity`.`modified`, `Activity`.`name`, `Activity`.`activity_producer_id`, `Activity`.`search_tags`, `Activity`.`sort`, `Activity`.`summary`, `Activity`.`activity_event_url`, `Activity`.`visible`, `Activity`.`tags`, `Activity`.`minutes`, `Activity`.`display_page`, `Activity`.`slug`, `Activity`.`featured_photo_id`, `Activity`.`legacy_update`, `Activity`.`ticket_description`, `Activity`.`cutoff_time`, `Activity`.`cutoff_text`, `Activity`.`date_selection_type` FROM `load-testing-202410`.`activities` AS `Activity` WHERE `event_id` = '5f6a80fa-6048-447a-b379-14d40ad1e040' AND `slug` = 'scary-stories' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ActivityInstance`.`id`, `ActivityInstance`.`event_id`, `ActivityInstance`.`default`, `ActivityInstance`.`capacity`, `ActivityInstance`.`activity_id`, `ActivityInstance`.`venue_id`, `ActivityInstance`.`status`, `ActivityInstance`.`start`, `ActivityInstance`.`end`, `ActivityInstance`.`start_utc`, `ActivityInstance`.`end_utc`, `ActivityInstance`.`access_after_initial_hours`, `ActivityInstance`.`access_after_purchase_hours`, `ActivityInstance`.`activity_instance_event_url`, `ActivityInstance`.`created`, `ActivityInstance`.`modified`, `ActivityInstance`.`alternate_instance_id` FROM `load-testing-202410`.`activity_instances` AS `ActivityInstance` WHERE `ActivityInstance`.`activity_id` = ('5f6a80fb-0180-4c1d-aa53-14d40ad1e040') ORDER BY `ActivityInstance`.`start` ASC | 2 | 2 | 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`.`activity_instance_id` IN ('5f6a80fd-6ee8-47d7-9c85-14d40ad1e040', '5f6a8d60-db74-44c6-88d6-23cc0ad1e040') | 8 | 8 | 1 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`location`, `Photo`.`url`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`original_filename`, `Photo`.`filesize`, `Photo`.`height`, `Photo`.`mime_type`, `Photo`.`width`, `Photo`.`type`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`caption`, `Photo`.`sort`, `Photo`.`modified`, `Photo`.`created` FROM `load-testing-202410`.`photos` AS `Photo` WHERE `model` = 'Activity' AND `foreign_key` = '5f6a80fb-0180-4c1d-aa53-14d40ad1e040' AND `type` = 'gallery' ORDER BY `sort` ASC | 1 | 1 | 1 |
Peak Memory Use 22.72 MB
Message | Memory use |
---|---|
Component initialization | 1.43 MB |
Controller action start | 2.37 MB |
Controller render start | 5.70 MB |
View render complete | 6.53 MB |
Total Request Time: 387 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 111.32 | |
Event: Controller.initialize | 22.12 | |
Event: Controller.startup | 2.04 | |
Controller action | 86.08 | |
Event: Controller.beforeRender | 67.70 | |
» Processing toolbar data | 67.53 | |
Rendering View | 17.40 | |
» Event: View.beforeRender | 0.03 | |
» Rendering | 0.60 | |
» Rendering #2 | 0.17 | |
» Rendering #3 | 2.58 | |
» Rendering #4 | 5.06 | |
» Rendering #5 | 5.81 | |
» Rendering #6 | 1.87 | |
» Rendering #7 | 1.84 | |
» Rendering #8 | 1.83 | |
» Rendering #9 | 1.82 | |
» Rendering #10 | 1.85 | |
» Rendering #11 | 1.07 | |
» Rendering #12 | 0.32 | |
» Rendering #13 | 0.36 | |
» Rendering #14 | 0.38 | |
» Rendering #15 | 0.25 | |
» Rendering #16 | 0.14 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering #17 | 1.01 | |
» Rendering #18 | 0.99 | |
» Rendering #19 | 0.48 | |
» Rendering #20 | 0.33 | |
» Rendering #21 | 0.42 | |
» Rendering #22 | 0.38 | |
» Rendering #23 | 0.23 | |
» Rendering #24 | 0.22 | |
» Rendering #25 | 0.25 | |
» Rendering #26 | 0.25 | |
» Rendering #27 | 0.73 | |
» Rendering #28 | 1.72 | |
» Rendering #29 | 1.14 | |
Event: View.afterLayout | 0.00 |
Type | Keyname | Took (ms) |
---|---|---|
read | debug_kit_eng | 0.99 |
read | cake_eng | 0.81 |
read | method_cache | 2.15 |
read | default_eng | 1.06 |
8 00 | 5.01 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | default_load-testing-202410_list | 0.96 |
read | default_load-testing-202410_activities (missed) | 0.74 |
write | default_load-testing-202410_activities | 0.66 |
read | default_load-testing-202410_activities | 0.66 |
write | default_load-testing-202410_activities | 0.91 |
read | default_load-testing-202410_activity_instances (missed) | 0.7 |
write | default_load-testing-202410_activity_instances | 0.59 |
read | default_load-testing-202410_activity_instances | 0.62 |
write | default_load-testing-202410_activity_instances | 0.88 |
read | default_load-testing-202410_activity_instances_ticket_types (missed) | 0.65 |
write | default_load-testing-202410_activity_instances_ticket_types | 0.59 |
read | default_load-testing-202410_activity_instances_ticket_types | 0.6 |
write | default_load-testing-202410_activity_instances_ticket_types | 0.72 |
read | default_load-testing-202410_photos (missed) | 0.67 |
write | default_load-testing-202410_photos | 0.58 |
read | default_load-testing-202410_photos | 0.56 |
write | default_load-testing-202410_photos | 0.76 |
18 160 | 11.85 ms |
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | activity_by_slug_scary-stories_eventid_5f6a80fa-6048-447a-b379-14d40ad1e040 (missed) | 0.8 |
write | activity_by_slug_scary-stories_eventid_5f6a80fa-6048-447a-b379-14d40ad1e040 | 1.21 |
remember | activity_by_slug_scary-stories_eventid_5f6a80fa-6048-447a-b379-14d40ad1e040 | 22.15 |
read | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040 | 1.29 |
read | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040 | 1.03 |
read | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040 | 1.09 |
read | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040 | 0.97 |
10 22 | 28.54 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | activity_5f6a80fb-0180-4c1d-aa53-14d40ad1e040_all_registration_counts | 0.82 |
read | activity_5f6a8b5c-6040-44c0-bc65-7cd60ad1e040_all_registration_counts | 0.71 |
read | activity_5f6a8d9c-76f4-4d51-80d4-24650ad1e040_all_registration_counts | 0.72 |
read | activity_instance_5f6a8bfa-b91c-4b4a-a244-144e0ad1e040_registration_count | 0.83 |
read | activity_instance_5f6a80fd-6ee8-47d7-9c85-14d40ad1e040_registration_count | 0.61 |
read | activity_instance_5f6a8d60-db74-44c6-88d6-23cc0ad1e040_registration_count | 0.61 |
read | activity_instance_5f6a8df2-7044-4c44-93ea-2b0d0ad1e040_registration_count | 0.67 |
14 00 | 4.97 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_settings_5f6a80fa-6048-447a-b379-14d40ad1e040 | 3.15 |
read | photos_activity_gallery_5f6a80fb-0180-4c1d-aa53-14d40ad1e040 (missed) | 0.66 |
write | photos_activity_gallery_5f6a80fb-0180-4c1d-aa53-14d40ad1e040 | 0.69 |
remember | photos_activity_gallery_5f6a80fb-0180-4c1d-aa53-14d40ad1e040 | 5.96 |
read | linked_ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 | 0.71 |
read | event_attendee_limit_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.59 |
read | event_settings_5f6a80fa-6048-447a-b379-14d40ad1e040 | 3.03 |
10 22 | 14.79 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_organization_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.77 |
read | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040 | 0.76 |
read | event_is_archived_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.58 |
read | venue_5f6a4297-8dcc-4096-ae05-26b20ad1e040 | 0.77 |
read | venue_5f6a4297-8dcc-4096-ae05-26b20ad1e040 | 0.61 |
read | event_organization_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.62 |
12 00 | 4.11 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040 | 0.94 |
2 00 | 0.94 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_id_by_slug_timpanogos-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 | 0.74 |
read | event_setting_tickets_merch_product_name_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.7 |
read | event_custom_css_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.75 |
read | event_id_by_slug_timpanogos-event_partner_52e7320e-ed7c-4b47-a42c-57214834d839 | 0.82 |
read | get_organization_607e521e-b4c0-4f0f-befc-3b940a0000ba | 3.83 |
read | photos_event_masthead_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.73 |
12 00 | 7.57 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | custom_style_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.85 |
read | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040 | 0.84 |
4 00 | 1.69 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | partner_settings_52e7320e-ed7c-4b47-a42c-57214834d839 | 3.37 |
read | venue_5f57c3cf-03cc-4165-b2cf-0b450ad1e040 | 0.71 |
4 00 | 4.08 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_setting_tickets_product_name_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.7 |
read | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040 | 0.89 |
4 00 | 1.59 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_master_5f6a80fa-6048-447a-b379-14d40ad1e040_activity_timpanogos-event | 1.09 |
read | photos_event_ticket-masthead_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.6 |
4 00 | 1.69 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_partner_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.73 |
read | event_partner_id_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.69 |
4 00 | 1.42 ms |
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | partner_by_server_load_testing_rs_ticketsauce_com_null_null | 1.4 |
read | event_ticket_types_5f6a80fa-6048-447a-b379-14d40ad1e040 | 1.29 |
read | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040 | 0.68 |
read | event_order_fields_front_5f6a80fa-6048-447a-b379-14d40ad1e040 | 0.95 |
8 00 | 4.32 ms |
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | toolbar_cache | 24.42 |
2 00 | 24.42 ms |
No cache activities
No cache activities
No cache activities
No cache activities
No cache activities
No cache activities
Type | Keyname | Took (ms) |
---|---|---|
read | event_5f6a80fa-6048-447a-b379-14d40ad1e040_ticket_count | 0.54 |
read | event_5f6a80fa-6048-447a-b379-14d40ad1e040_ticket_count | 0.55 |
4 00 | 1.09 ms |
Type | Keyname | Took (ms) |
---|---|---|
read | ticket_type_5f6a820a-3f00-4aad-b604-1f080ad1e040_count | 0.6 |
read | ticket_type_5f6a813d-6910-44e1-bdf8-175c0ad1e040_count | 0.72 |
read | ticket_type_5f6a82a9-d1c4-4cc5-bc6b-25f60ad1e040_count | 0.69 |
read | ticket_type_5f6a95de-a82c-4c26-a38b-037d0ad1e040_count | 0.64 |
read | ticket_type_5f6a8349-24f0-499d-bf26-2fb60ad1e040_count | 0.66 |
read | ticket_type_5f6a8306-e920-4d92-adc5-294d0ad1e040_count | 0.67 |
read | ticket_type_5f6a83f3-f7ac-4bc3-bf19-368a0ad1e040_count | 0.7 |
read | ticket_type_5f6a8940-db50-4e6d-b0e1-71300ad1e040_count | 0.64 |
read | ticket_type_price_5f6a8940-f234-405d-a4cd-71300ad1e040_count | 0.63 |
read | ticket_type_price_5f6a8940-a96c-4990-951d-71300ad1e040_count | 0.6 |
read | ticket_type_price_5f6a8940-3d04-4be1-a3c1-71300ad1e040_count | 0.77 |
read | ticket_type_price_5f6a8940-36d0-4e30-9250-71300ad1e040_count | 0.69 |
24 00 | 8.01 ms |
No cache activities