- RealtyCAP - APP -

Skip to main content

RealtyCap

{"session":"

Session<\/h2>\n
Config<\/strong>
userAgent<\/strong><\/li>
time<\/strong>1769068581<\/li>
countdown<\/strong>10<\/li><\/ul><\/li>
Users<\/strong>
User<\/strong>(empty)<\/li><\/ul><\/li><\/ul>","request":"
Request<\/h2>\n\n
Cake Params<\/h4>\n
plugin<\/strong>pages<\/li>
controller<\/strong>pages<\/li>
action<\/strong>view<\/li>
named<\/strong>(empty)<\/li>
pass<\/strong>(empty)<\/li>
path<\/strong><\/li>
isAjax<\/strong>(false)<\/li><\/ul>\n
Post data<\/h4>\n
No post data.<\/p>\n
Query string<\/h4>\n
No querystring data.<\/p>\n
Cookie<\/h4>\n\t
0<\/strong>(empty)<\/li><\/ul>\n
Current Route<\/h4>\n
keys<\/strong>(empty)<\/li>
options<\/strong>(empty)<\/li>
defaults<\/strong>
plugin<\/strong>pages<\/li>
controller<\/strong>pages<\/li>
action<\/strong>view<\/li>
path<\/strong><\/li><\/ul><\/li>
template<\/strong>\/<\/li><\/ul>","sql_log":"
Sql Logs<\/h2>\n\t\t
\n\t\t
default<\/h4>\n\t\t
Total Time: 4 ms
Total Queries: 59 queries<\/h5>
Query<\/th> Affected<\/th> Num. rows<\/th> Took (ms)<\/th> Actions<\/th><\/tr>
SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `realtycap_rog`.`installed_plugins` AS `CmsPlugin` WHERE `active` = '1'<\/td> 32<\/td> 32<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Setting`.`key`, `Setting`.`value` FROM `realtycap_rog`.`settings` AS `Setting` WHERE 1 = 1<\/td> 57<\/td> 57<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `BootstrapInstance`.`id`, `BootstrapInstance`.`name`, `BootstrapInstance`.`slug` FROM `realtycap_rog`.`prototype_instances` AS `BootstrapInstance` WHERE 1 = 1<\/td> 5<\/td> 5<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`slug` FROM `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0'<\/td> 3<\/td> 3<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeInstance' AND `CustomFieldValue`.`foreign_key` IN (2, 3, 4) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` IN (2, 3, 4) <\/td> 12<\/td> 12<\/td> 1<\/td> maybe slow<\/span>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '3' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '4' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`slug` FROM `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`allow_instance_view` = '1' AND `PublishingInformation`.`published` = '1' AND ((`PublishingInformation`.`start` <= '2026-01-21 21:56:21') OR (`PublishingInformation`.`start` IS NULL)) AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2026-01-21 21:56:21')) AND `PrototypeInstance`.`deleted` = '0'<\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeInstance' AND `CustomFieldValue`.`foreign_key` IN (2, 3, 4) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` IN (2, 3, 4) <\/td> 12<\/td> 12<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '3' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '4' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`slug` FROM `realtycap_rog`.`prototype_categories` AS `PrototypeCategory` LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeCategory`.`id` AND `PublishingInformation`.`model` = 'PrototypeCategory') WHERE `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`rank` ASC<\/td> 9<\/td> 9<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeCategory' AND `CustomFieldValue`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeCategory' AND `MetaValue`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) <\/td> 16<\/td> 16<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 101<\/td> 101<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
INSERT INTO `realtycap_rog`.`activities` (`ip`, `url`, `user_id`, `posted_vars`, `deal_id`, `modified`, `created`) VALUES ('154.28.229.42', '\/', 1, '{\\"data\\":[],\\"query\\":[],\\"params\\":{\\"params\\":{\\"plugin\\":\\"pages\\",\\"controller\\":\\"pages\\",\\"action\\":\\"view\\",\\"named\\":[],\\"pass\\":[],\\"path\\":\\"\\"},\\"data\\":[],\\"query\\":[],\\"url\\":false,\\"base\\":\\"\\",\\"webroot\\":\\"\\\\\/\\",\\"here\\":\\"\\\\\/\\"}}', NULL, '2026-01-21 21:56:21', '2026-01-21 21:56:21')<\/td> 1<\/td> 1<\/td> 1<\/td> <\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = '' AND `Page`.`deleted` = '0' LIMIT 1<\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = (1) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = (1) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = (1) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`id` FROM `realtycap_rog`.`pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`deleted` = '0' LIMIT 1<\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = (1) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = (1) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Page`.`id`, `Page`.`published` FROM `realtycap_rog`.`pages` AS `Page` WHERE `Page`.`plugin` = '' AND `Page`.`lft` <= 1 AND `Page`.`rght` >= 2 AND `Page`.`deleted` = '0' ORDER BY `Page`.`lft` asc<\/td> 1<\/td> 1<\/td> 1<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = (1) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = (1) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = '1' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 4<\/td> 4<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`use_page_banner_images`, `PrototypeInstance`.`fallback_to_instance_banner_image`, `PrototypeInstance`.`use_page_banner_image_categories`, `PrototypeInstance`.`use_page_banner_image_items`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0'<\/td> 3<\/td> 3<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeInstance' AND `CustomFieldValue`.`foreign_key` IN (2, 3, 4) <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'PrototypeInstance' AND `MetaValue`.`foreign_key` IN (2, 3, 4) <\/td> 12<\/td> 12<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '2' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '3' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 'prototype' AND `controller` = 'prototype_instances' AND `action` = 'non-admin' AND `resource_id` = '4' AND `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC LIMIT 1<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-01-21 21:56:21"<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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<\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr><\/table>\t\t
Query Explain:<\/h4>\n\t\t
\n\t\t\t <\/a>\n\t\t\t
Click an \"Explain\" link above, to see the query explanation.<\/p>\n\t\t<\/div>\n\t<\/div>\n\t\n