Created
July 28, 2022 03:14
-
-
Save scytacki/1fc60e781d9abd35a9517bb0f74d9e60 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- This is the log when I exported an activity with a single page and | |
| -- single open resp question | |
| app_1 | Started GET "/api/v1/activities/24/report_structure.json" for 172.22.0.4 at 2022-07-28 01:49:47 +0000 | |
| app_1 | Processing by Api::V1::LightweightActivitiesController#report_structure as JSON | |
| app_1 | Parameters: {"id"=>"24"} | |
| app_1 | session before:{"session_id"=>"26ee56a0ca00470ff11786176e766ab6", "warden.user.user.key"=>[[1], "$2a$10$u82W97eO7fS6esmPeMouAO"], "warden.user.user.session"=>{"last_request_at"=>2022-07-28 01:29:55 UTC}, "_csrf_token"=>"RJkLzKqiZrUbQkAPdsEDr32LdjeaqCmwOgFq+arVc4Q="} | |
| app_1 | * Accept-Language: en-US,en;q=0.9,es-419;q=0.8,es;q=0.7 | |
| app_1 | * Locale set to 'en' | |
| -- The initial load probably happens in the controller | |
| app_1 | LightweightActivity Load (0.5ms) SELECT `lightweight_activities`.* FROM `lightweight_activities` WHERE `lightweight_activities`.`id` = 24 LIMIT 1 | |
| -- From LightweightActivity#visible_pages_with_embeddables | |
| app_1 | InteractivePage Load (0.6ms) SELECT `interactive_pages`.* FROM `interactive_pages` WHERE `interactive_pages`.`lightweight_activity_id` = 24 AND `interactive_pages`.`is_hidden` = 0 ORDER BY position | |
| app_1 | Section Load (0.3ms) SELECT `sections`.* FROM `sections` WHERE `sections`.`interactive_page_id` IN (78) ORDER BY position ASC, position | |
| app_1 | PageItem Load (0.4ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` IN (91, 92) ORDER BY position ASC, position | |
| app_1 | Embeddable::Xhtml Load (0.3ms) SELECT `embeddable_xhtmls`.* FROM `embeddable_xhtmls` WHERE `embeddable_xhtmls`.`id` IN (39) | |
| app_1 | ManagedInteractive Load (0.5ms) SELECT `managed_interactives`.* FROM `managed_interactives` WHERE `managed_interactives`.`id` IN (31) | |
| app_1 | Embeddable::OpenResponse Load (0.4ms) SELECT `embeddable_open_responses`.* FROM `embeddable_open_responses` WHERE `embeddable_open_responses`.`id` IN (145) | |
| -- End of LightweightActivity#visible_pages_with_embeddables | |
| -- Page#reportable_items | |
| -- Page#visible_embeddables | |
| -- Page#section_visible_embeddables | |
| -- Page#section_embeddables | |
| -- 2 page_item.where queries, resulting in PageItems not from the original includes query | |
| app_1 | PageItem Load (0.6ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` = 92 AND `page_items`.`column` = 'secondary' ORDER BY position ASC, position | |
| app_1 | PageItem Load (0.6ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` = 92 AND `page_items`.`column` = 'primary' ORDER BY position ASC, position | |
| -- Page#section_embeddables : i.embeddable (I think) | |
| app_1 | ManagedInteractive Load (1.0ms) SELECT `managed_interactives`.* FROM `managed_interactives` WHERE `managed_interactives`.`id` = 31 LIMIT 1 | |
| app_1 | Embeddable::OpenResponse Load (0.8ms) SELECT `embeddable_open_responses`.* FROM `embeddable_open_responses` WHERE `embeddable_open_responses`.`id` = 145 LIMIT 1 | |
| -- Probably from ManagedInteractive#url | |
| app_1 | LibraryInteractive Load (0.5ms) SELECT `library_interactives`.* FROM `library_interactives` WHERE `library_interactives`.`id` = 1 LIMIT 1 | |
| -- Probably from | |
| -- BaseInteractive#report_service_hash | |
| -- Embeddable#index_in_activity | |
| app_1 | InteractivePage Load (1.2ms) SELECT `interactive_pages`.* FROM `interactive_pages` INNER JOIN `sections` ON `interactive_pages`.`id` = `sections`.`interactive_page_id` INNER JOIN `page_items` ON `sections`.`id` = `page_items`.`section_id` WHERE `page_items`.`embeddable_id` = 31 AND `page_items`.`embeddable_type` = 'ManagedInteractive' ORDER BY position ASC LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `lightweight_activities`.* FROM `lightweight_activities` WHERE `lightweight_activities`.`id` = 24 LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `interactive_pages`.* FROM `interactive_pages` WHERE `interactive_pages`.`lightweight_activity_id` = 24 AND `interactive_pages`.`is_hidden` = 0 ORDER BY position | |
| app_1 | CACHE (0.0ms) SELECT `sections`.* FROM `sections` WHERE `sections`.`interactive_page_id` IN (78) ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` IN (91, 92) ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `embeddable_xhtmls`.* FROM `embeddable_xhtmls` WHERE `embeddable_xhtmls`.`id` IN (39) | |
| app_1 | CACHE (0.0ms) SELECT `managed_interactives`.* FROM `managed_interactives` WHERE `managed_interactives`.`id` IN (31) | |
| app_1 | CACHE (0.0ms) SELECT `embeddable_open_responses`.* FROM `embeddable_open_responses` WHERE `embeddable_open_responses`.`id` IN (145) | |
| app_1 | CACHE (0.0ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` = 92 AND `page_items`.`column` = 'secondary' ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` = 92 AND `page_items`.`column` = 'primary' ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `managed_interactives`.* FROM `managed_interactives` WHERE `managed_interactives`.`id` = 31 LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `embeddable_open_responses`.* FROM `embeddable_open_responses` WHERE `embeddable_open_responses`.`id` = 145 LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `library_interactives`.* FROM `library_interactives` WHERE `library_interactives`.`id` = 1 LIMIT 1 | |
| -- Probably from | |
| -- OpenResponse#report_service_hash | |
| -- Embeddable#index_in_activity | |
| app_1 | InteractivePage Load (1.4ms) SELECT `interactive_pages`.* FROM `interactive_pages` INNER JOIN `sections` ON `interactive_pages`.`id` = `sections`.`interactive_page_id` INNER JOIN `page_items` ON `sections`.`id` = `page_items`.`section_id` WHERE `page_items`.`embeddable_id` = 145 AND `page_items`.`embeddable_type` = 'Embeddable::OpenResponse' ORDER BY position ASC LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `interactive_pages`.* FROM `interactive_pages` INNER JOIN `sections` ON `interactive_pages`.`id` = `sections`.`interactive_page_id` INNER JOIN `page_items` ON `sections`.`id` = `page_items`.`section_id` WHERE `page_items`.`embeddable_id` = 145 AND `page_items`.`embeddable_type` = 'Embeddable::OpenResponse' ORDER BY position ASC LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `lightweight_activities`.* FROM `lightweight_activities` WHERE `lightweight_activities`.`id` = 24 LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `interactive_pages`.* FROM `interactive_pages` INNER JOIN `sections` ON `interactive_pages`.`id` = `sections`.`interactive_page_id` INNER JOIN `page_items` ON `sections`.`id` = `page_items`.`section_id` WHERE `page_items`.`embeddable_id` = 145 AND `page_items`.`embeddable_type` = 'Embeddable::OpenResponse' ORDER BY position ASC LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `interactive_pages`.* FROM `interactive_pages` INNER JOIN `sections` ON `interactive_pages`.`id` = `sections`.`interactive_page_id` INNER JOIN `page_items` ON `sections`.`id` = `page_items`.`section_id` WHERE `page_items`.`embeddable_id` = 145 AND `page_items`.`embeddable_type` = 'Embeddable::OpenResponse' ORDER BY position ASC LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `lightweight_activities`.* FROM `lightweight_activities` WHERE `lightweight_activities`.`id` = 24 LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `interactive_pages`.* FROM `interactive_pages` WHERE `interactive_pages`.`lightweight_activity_id` = 24 AND `interactive_pages`.`is_hidden` = 0 ORDER BY position | |
| app_1 | CACHE (0.0ms) SELECT `sections`.* FROM `sections` WHERE `sections`.`interactive_page_id` IN (78) ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` IN (91, 92) ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `embeddable_xhtmls`.* FROM `embeddable_xhtmls` WHERE `embeddable_xhtmls`.`id` IN (39) | |
| app_1 | CACHE (0.0ms) SELECT `managed_interactives`.* FROM `managed_interactives` WHERE `managed_interactives`.`id` IN (31) | |
| app_1 | CACHE (0.0ms) SELECT `embeddable_open_responses`.* FROM `embeddable_open_responses` WHERE `embeddable_open_responses`.`id` IN (145) | |
| app_1 | CACHE (0.0ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` = 92 AND `page_items`.`column` = 'secondary' ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `page_items`.* FROM `page_items` WHERE `page_items`.`section_id` = 92 AND `page_items`.`column` = 'primary' ORDER BY position ASC, position | |
| app_1 | CACHE (0.0ms) SELECT `managed_interactives`.* FROM `managed_interactives` WHERE `managed_interactives`.`id` = 31 LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `embeddable_open_responses`.* FROM `embeddable_open_responses` WHERE `embeddable_open_responses`.`id` = 145 LIMIT 1 | |
| app_1 | CACHE (0.0ms) SELECT `library_interactives`.* FROM `library_interactives` WHERE `library_interactives`.`id` = 1 LIMIT 1 | |
| app_1 | session after:{"session_id"=>"26ee56a0ca00470ff11786176e766ab6", "warden.user.user.key"=>[[1], "$2a$10$u82W97eO7fS6esmPeMouAO"], "warden.user.user.session"=>{"last_request_at"=>2022-07-28 01:29:55 UTC}, "_csrf_token"=>"RJkLzKqiZrUbQkAPdsEDr32LdjeaqCmwOgFq+arVc4Q="} | |
| app_1 | Completed 200 OK in 895.1ms (Views: 0.3ms | ActiveRecord: 29.1ms) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment