log-of-report-structure-export.sql

-- 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)