| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`name`, `PrototypeCategory`.`rank`, `PrototypeCategory`.`created`, `PrototypeCategory`.`modified`, `PrototypeCategory`.`slug`, `PrototypeCategory`.`prototype_instance_id`, `PrototypeCategory`.`parent_id`, `PrototypeCategory`.`lft`, `PrototypeCategory`.`rght`, `PrototypeCategory`.`deleted`, `PrototypeCategory`.`deleted_date`, `PrototypeCategory`.`head_title`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` 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`.`slug` = 'todo-and-todovalues' AND `PrototypeCategory`.`deleted` = '0' AND `PublishingInformation`.`published` = '1' AND ((`PublishingInformation`.`start` <= '2026-05-24 03:53:21') OR (`PublishingInformation`.`start` IS NULL)) AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2026-05-24 03:53:21')) ORDER BY `PrototypeCategory`.`rank` ASC LIMIT 1 | 1 | 1 | 1 | |
| 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` = 'PrototypeCategory' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (7) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, `Document`.`user_id`, `Document`.`deal_id`, `Document`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `realtycap_rog`.`attachments` AS `Document` WHERE `Document`.`model` = 'PrototypeCategory' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (7) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`name`, `PrototypeCategory`.`rank`, `PrototypeCategory`.`created`, `PrototypeCategory`.`modified`, `PrototypeCategory`.`slug`, `PrototypeCategory`.`prototype_instance_id`, `PrototypeCategory`.`parent_id`, `PrototypeCategory`.`lft`, `PrototypeCategory`.`rght`, `PrototypeCategory`.`deleted`, `PrototypeCategory`.`deleted_date`, `PrototypeCategory`.`head_title` FROM `realtycap_rog`.`prototype_categories` AS `PrototypeCategory` WHERE `PrototypeCategory`.`parent_id` = (7) | 0 | 0 | 0 | |
| SELECT `CategoryBannerImage`.`id`, `CategoryBannerImage`.`model`, `CategoryBannerImage`.`foreign_key`, `CategoryBannerImage`.`dirname`, `CategoryBannerImage`.`basename`, `CategoryBannerImage`.`checksum`, `CategoryBannerImage`.`alternative`, `CategoryBannerImage`.`group`, `CategoryBannerImage`.`created`, `CategoryBannerImage`.`modified`, `CategoryBannerImage`.`rank`, `CategoryBannerImage`.`deleted`, `CategoryBannerImage`.`deleted_date`, `CategoryBannerImage`.`user_id`, `CategoryBannerImage`.`deal_id`, `CategoryBannerImage`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `CategoryBannerImage__path` FROM `realtycap_rog`.`attachments` AS `CategoryBannerImage` WHERE `CategoryBannerImage`.`model` = 'PrototypeCategory' AND `CategoryBannerImage`.`group` = 'Category Banner Image' AND `CategoryBannerImage`.`foreign_key` = (7) | 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` = 'PrototypeCategory' AND `CustomFieldValue`.`foreign_key` = (7) | 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` = 'PrototypeCategory' AND `MetaValue`.`foreign_key` = (7) | 4 | 4 | 0 | |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `realtycap_rog`.`prototype_items` AS `PrototypeItem` INNER JOIN `realtycap_rog`.`prototype_categories_prototype_items` AS `PrototypeCategory` ON (`PrototypeCategory`.`prototype_item_id` = `PrototypeItem`.`id` AND `PrototypeCategory`.`prototype_category_id` = '7') LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`prototype_instance_id` = 4 AND `PublishingInformation`.`published` = '1' AND ((`PublishingInformation`.`start` <= '2026-05-24 03:53:21') OR (`PublishingInformation`.`start` IS NULL)) AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2026-05-24 03:53:21')) AND `PrototypeItem`.`deleted` = '0' ORDER BY `PrototypeItem`.`name` ASC, `PrototypeItem`.`rank` ASC LIMIT 1000 | 5 | 5 | 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` = 'PrototypeItem' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` IN (38, 39, 44, 40, 42) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Document`.`id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`dirname`, `Document`.`basename`, `Document`.`checksum`, `Document`.`alternative`, `Document`.`group`, `Document`.`created`, `Document`.`modified`, `Document`.`rank`, `Document`.`deleted`, `Document`.`deleted_date`, `Document`.`user_id`, `Document`.`deal_id`, `Document`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `realtycap_rog`.`attachments` AS `Document` WHERE `Document`.`model` = 'PrototypeItem' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` IN (38, 39, 44, 40, 42) ORDER BY `Document`.`rank` ASC | 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` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` IN (38, 39, 44, 40, 42) | 25 | 25 | 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` = 'PrototypeItem' AND `MetaValue`.`foreign_key` IN (38, 39, 44, 40, 42) | 20 | 20 | 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`.`id` = 438 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (438) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 439 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (439) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 440 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (440) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 441 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (441) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 442 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (442) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 443 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (443) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 444 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (444) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 445 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (445) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 446 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (446) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 447 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (447) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 468 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (468) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 469 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (469) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 470 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (470) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 471 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (471) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 472 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (472) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 448 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (448) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 449 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (449) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 450 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (450) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 451 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (451) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 452 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (452) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 458 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (458) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 459 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (459) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 460 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (460) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 461 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (461) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 462 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (462) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC LIMIT 1 | 1 | 1 | 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 `controller` = 'prototype_categories' AND `action` = 'view' AND `Page`.`deleted` = '0' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`model` = 'PrototypeInstance' AND `CustomField`.`group` = 'PrototypeCategory' AND ((`CustomField`.`foreign_key` = 4) OR (`CustomField`.`foreign_key` = 0)) ORDER BY `CustomField`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`parent_id`, `PrototypeCategory`.`lft`, `PrototypeCategory`.`rght`, `PrototypeCategory`.`prototype_instance_id` 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`.`id` = 7 AND `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`rank` ASC 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` = 'PrototypeCategory' AND `CustomFieldValue`.`foreign_key` = (7) | 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` = 'PrototypeCategory' AND `MetaValue`.`foreign_key` = (7) | 4 | 4 | 0 | |
| SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`name` 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`.`lft` <= 7 AND `PrototypeCategory`.`rght` >= 8 AND `PrototypeCategory`.`prototype_instance_id` = 4 AND `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`lft` asc, `PrototypeCategory`.`rank` ASC | 2 | 2 | 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` = 'PrototypeCategory' AND `CustomFieldValue`.`foreign_key` IN (5, 7) | 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` = 'PrototypeCategory' AND `MetaValue`.`foreign_key` IN (5, 7) | 8 | 8 | 0 | |
| SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`name`, `PrototypeCategory`.`rank`, `PrototypeCategory`.`created`, `PrototypeCategory`.`modified`, `PrototypeCategory`.`slug`, `PrototypeCategory`.`prototype_instance_id`, `PrototypeCategory`.`parent_id`, `PrototypeCategory`.`lft`, `PrototypeCategory`.`rght`, `PrototypeCategory`.`deleted`, `PrototypeCategory`.`deleted_date`, `PrototypeCategory`.`head_title`, `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_categories` AS `PrototypeCategory` LEFT JOIN `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeCategory`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeCategory`.`id` AND `PublishingInformation`.`model` = 'PrototypeCategory') WHERE `PrototypeCategory`.`id` = 7 AND `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`rank` ASC 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` = 'PrototypeCategory' AND `CustomFieldValue`.`foreign_key` = (7) | 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` = 'PrototypeCategory' AND `MetaValue`.`foreign_key` = (7) | 4 | 4 | 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 `controller` = 'prototype_categories' AND `action` = 'view' AND `Page`.`deleted` = '0' 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-05-24 03:53:21" | 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 `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `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_items` AS `PrototypeItem` LEFT JOIN `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeItem`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`id` = 38 AND `PrototypeItem`.`deleted` = '0' ORDER BY `PrototypeItem`.`rank` ASC 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` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` = (38) | 5 | 5 | 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` = 'PrototypeItem' AND `MetaValue`.`foreign_key` = (38) | 4 | 4 | 1 | maybe slow |
| 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`.`id` = 438 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (438) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 439 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (439) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 440 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (440) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 441 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (441) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 442 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (442) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `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_items` AS `PrototypeItem` LEFT JOIN `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeItem`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`id` = 39 AND `PrototypeItem`.`deleted` = '0' ORDER BY `PrototypeItem`.`rank` ASC 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` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` = (39) | 5 | 5 | 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` = 'PrototypeItem' AND `MetaValue`.`foreign_key` = (39) | 4 | 4 | 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`.`id` = 443 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (443) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 444 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (444) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 445 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (445) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 446 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (446) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 447 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (447) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `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_items` AS `PrototypeItem` LEFT JOIN `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeItem`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`id` = 44 AND `PrototypeItem`.`deleted` = '0' ORDER BY `PrototypeItem`.`rank` ASC 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` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` = (44) | 5 | 5 | 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` = 'PrototypeItem' AND `MetaValue`.`foreign_key` = (44) | 4 | 4 | 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`.`id` = 468 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (468) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 469 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (469) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 470 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (470) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 471 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (471) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 472 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (472) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `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_items` AS `PrototypeItem` LEFT JOIN `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeItem`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`id` = 40 AND `PrototypeItem`.`deleted` = '0' ORDER BY `PrototypeItem`.`rank` ASC 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` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` = (40) | 5 | 5 | 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` = 'PrototypeItem' AND `MetaValue`.`foreign_key` = (40) | 4 | 4 | 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`.`id` = 448 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (448) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 449 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (449) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 450 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (450) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 451 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (451) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 452 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (452) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PrototypeItem`.`id`, `PrototypeItem`.`name`, `PrototypeItem`.`rank`, `PrototypeItem`.`created`, `PrototypeItem`.`modified`, `PrototypeItem`.`slug`, `PrototypeItem`.`prototype_instance_id`, `PrototypeItem`.`featured`, `PrototypeItem`.`deleted`, `PrototypeItem`.`deleted_date`, `PrototypeItem`.`head_title`, `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_items` AS `PrototypeItem` LEFT JOIN `realtycap_rog`.`prototype_instances` AS `PrototypeInstance` ON (`PrototypeItem`.`prototype_instance_id` = `PrototypeInstance`.`id`) LEFT JOIN `realtycap_rog`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeItem`.`id` AND `PublishingInformation`.`model` = 'PrototypeItem') WHERE `PrototypeItem`.`id` = 42 AND `PrototypeItem`.`deleted` = '0' ORDER BY `PrototypeItem`.`rank` ASC 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` = 'PrototypeItem' AND `CustomFieldValue`.`foreign_key` = (42) | 5 | 5 | 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` = 'PrototypeItem' AND `MetaValue`.`foreign_key` = (42) | 4 | 4 | 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`.`id` = 458 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (458) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 6 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 459 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (459) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 7 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 460 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (460) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 8 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 461 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (461) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 9 ORDER BY `CustomField`.`rank` ASC 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`.`id` = 462 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`foreign_key`, `Attachment`.`dirname`, `Attachment`.`basename`, `Attachment`.`checksum`, `Attachment`.`alternative`, `Attachment`.`group`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`rank`, `Attachment`.`deleted`, `Attachment`.`deleted_date`, `Attachment`.`user_id`, `Attachment`.`deal_id`, `Attachment`.`user_name`, (CONCAT_WS("/", dirname, basename)) AS `Attachment__path` FROM `realtycap_rog`.`attachments` AS `Attachment` WHERE `Attachment`.`model` = 'CustomFieldValue' AND `Attachment`.`foreign_key` = (462) | 0 | 0 | 0 | |
| SELECT `CustomField`.`id`, `CustomField`.`name`, `CustomField`.`default`, `CustomField`.`type`, `CustomField`.`required`, `CustomField`.`validate`, `CustomField`.`label`, `CustomField`.`validate_message`, `CustomField`.`rank`, `CustomField`.`options`, `CustomField`.`foreign_key`, `CustomField`.`model`, `CustomField`.`display_label`, `CustomField`.`group`, `CustomField`.`placeholder`, `CustomField`.`description` FROM `realtycap_rog`.`custom_fields` AS `CustomField` WHERE `CustomField`.`id` = 10 ORDER BY `CustomField`.`rank` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `LoginToken`.`id` FROM `realtycap_rog`.`login_tokens` AS `LoginToken` WHERE expires < "2026-05-24 03:53:21" | 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-05-24 03:53:21" | 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-05-24 03:53:21" | 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-05-24 03:53:21" | 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 | |