| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `BootstrapInstance`.`id`, `BootstrapInstance`.`name`, `BootstrapInstance`.`slug` FROM `realtycap_rog`.`prototype_instances` AS `BootstrapInstance` WHERE 1 = 1 | 5 | 5 | 1 | maybe slow |
| SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `realtycap_rog`.`pages` AS `Page` WHERE `controller` = 'pages' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `realtycap_rog`.`permissions` AS `Permission` WHERE `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC | 101 | 101 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| INSERT INTO `realtycap_rog`.`activities` (`ip`, `url`, `user_id`, `posted_vars`, `deal_id`, `modified`, `created`) VALUES ('216.73.216.46', '/style-guide', 1, '{\"data\":[],\"query\":[],\"params\":{\"params\":{\"plugin\":\"pages\",\"controller\":\"pages\",\"action\":\"view\",\"named\":[],\"pass\":[],\"path\":\"style-guide\"},\"data\":[],\"query\":[],\"url\":\"style-guide\",\"base\":\"\",\"webroot\":\"\/\",\"here\":\"\/style-guide\"}}', NULL, '2026-03-08 03:53:16', '2026-03-08 03:53:16') | 1 | 1 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `realtycap_rog`.`pages` AS `Page` WHERE `Page`.`plugin` = '' AND `Page`.`controller` = '' AND `Page`.`published` = '1' AND `Page`.`path` = 'style-guide' AND `Page`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, `Image`.`user_id`, `Image`.`deal_id`, `Image`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `realtycap_rog`.`attachments` AS `Image` WHERE `Image`.`model` = 'Page' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (11) | 0 | 0 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `realtycap_rog`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11) | 0 | 0 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `realtycap_rog`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11) | 4 | 4 | 1 | maybe slow |
| SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `realtycap_rog`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`id` FROM `realtycap_rog`.`pages` AS `Page` WHERE `Page`.`id` = 11 AND `Page`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `realtycap_rog`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11) | 0 | 0 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `realtycap_rog`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11) | 4 | 4 | 0 | |
| SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `realtycap_rog`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Page`.`id`, `Page`.`published` FROM `realtycap_rog`.`pages` AS `Page` WHERE `Page`.`plugin` = '' AND `Page`.`lft` <= 7 AND `Page`.`rght` >= 8 AND `Page`.`deleted` = '0' ORDER BY `Page`.`lft` asc | 1 | 1 | 1 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `realtycap_rog`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (11) | 0 | 0 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `realtycap_rog`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (11) | 4 | 4 | 0 | |
| SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `realtycap_rog`.`permissions` AS `Permission` WHERE `plugin` = 'pages' AND `controller` = 'pages' AND `action` = 'non-admin' AND `resource_id` = '11' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `realtycap_rog`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC | 4 | 4 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-03-08 03:53:16" | 0 | 0 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date`, `Group`.`admin_access` FROM `realtycap_rog`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
