Contact Us
Kevin Sing
DFH Real Estate Ltd.
3914 Shelbourne Street
Victoria, BC V8P 4J1
Email: ksing@kevinsing.com
Toll-Free: 1-800-668-2272
Phone: 250-477-7291
Fax: 250-477-3161
Kevin Sing
DFH Real Estate Ltd.
3914 Shelbourne Street
Victoria, BC V8P 4J1
Email: ksing@kevinsing.com
Toll-Free: 1-800-668-2272
Phone: 250-477-7291
Fax: 250-477-3161
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `BootstrapInstance`.`id`, `BootstrapInstance`.`name`, `BootstrapInstance`.`slug` FROM `kevinsingdb`.`prototype_instances` AS `BootstrapInstance` WHERE 1 = 1 | 0 | 0 | 0 | |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`slug` FROM `kevinsingdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0' | 0 | 0 | 0 | |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`slug` FROM `kevinsingdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`allow_instance_view` = '1' AND `PrototypeInstance`.`deleted` = '0' | 0 | 0 | 1 | maybe slow |
| SELECT `PrototypeCategory`.`id`, `PrototypeCategory`.`slug` FROM `kevinsingdb`.`prototype_categories` AS `PrototypeCategory` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeCategory`.`id` AND `PublishingInformation`.`model` = 'PrototypeCategory') WHERE `PrototypeCategory`.`deleted` = '0' ORDER BY `PrototypeCategory`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Permission`.`id`, `Permission`.`plugin`, `Permission`.`controller`, `Permission`.`action`, `Permission`.`resource_id`, `Permission`.`description`, `Permission`.`created`, `Permission`.`modified`, `Permission`.`deleted`, `Permission`.`deleted_date`, (CONCAT_WS(':', NULLIF(`Permission`.`plugin`, ''), NULLIF(`Permission`.`controller`, ''), NULLIF(`Permission`.`action`, ''), NULLIF(`Permission`.`resource_id`, ''))) AS `Permission__name` FROM `kevinsingdb`.`permissions` AS `Permission` WHERE `Permission`.`deleted` = '0' ORDER BY `Permission`.`plugin` ASC, `Permission`.`controller` ASC, `Permission`.`action` ASC, `Permission`.`resource_id` ASC | 74 | 74 | 2 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `kevinsingdb`.`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 `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`login_redirect`, `Group`.`rank`, `Group`.`deleted`, `Group`.`deleted_date` FROM `kevinsingdb`.`groups` AS `Group` WHERE `Group`.`name` = 'Unregistered' AND `Group`.`deleted` = '0' ORDER BY `Group`.`rank` ASC, `Group`.`id` ASC, `Group`.`rank` ASC LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Page`.`id`, `Page`.`created`, `Page`.`modified`, `Page`.`internal_name`, `Page`.`title`, `Page`.`page_heading`, `Page`.`content`, `Page`.`slug`, `Page`.`path`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`layout`, `Page`.`plugin`, `Page`.`controller`, `Page`.`action`, `Page`.`extra`, `Page`.`protected`, `Page`.`exclude_sitemap`, `Page`.`deleted`, `Page`.`deleted_date`, `Page`.`password`, `Page`.`published`, `Page`.`extra_header_code`, `Page`.`extra_footer_code`, `Page`.`override_title_format`, `Page`.`super_admin`, (CONCAT_WS('/', NULLIF(`Page`.`plugin`, ''), NULLIF(`Page`.`controller`, ''), NULLIF(`Page`.`action`, ''), NULLIF(`Page`.`extra`, ''))) AS `Page__action_map` FROM `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`plugin` = '' AND `Page`.`controller` = '' AND `Page`.`published` = '1' AND `Page`.`path` = 'contact-us' AND `Page`.`deleted` = '0' 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`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Page' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (2) | 0 | 0 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2) | 0 | 0 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2) | 4 | 4 | 0 | |
| SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`id` FROM `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`id` = 2 AND `Page`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2) | 0 | 0 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2) | 4 | 4 | 0 | |
| SELECT `Page`.`id`, `Page`.`published` FROM `kevinsingdb`.`pages` AS `Page` WHERE `Page`.`plugin` = '' AND `Page`.`lft` <= 28 AND `Page`.`rght` >= 31 AND `Page`.`deleted` = '0' ORDER BY `Page`.`lft` asc | 1 | 1 | 0 | |
| SELECT `CustomFieldValue`.`id`, `CustomFieldValue`.`foreign_key`, `CustomFieldValue`.`model`, `CustomFieldValue`.`custom_field_id`, `CustomFieldValue`.`key`, `CustomFieldValue`.`val`, `CustomFieldValue`.`type` FROM `kevinsingdb`.`custom_field_values` AS `CustomFieldValue` WHERE `CustomFieldValue`.`model` = 'Page' AND `CustomFieldValue`.`foreign_key` = (2) | 0 | 0 | 0 | |
| SELECT `MetaValue`.`id`, `MetaValue`.`created`, `MetaValue`.`modified`, `MetaValue`.`model`, `MetaValue`.`foreign_key`, `MetaValue`.`meta_key_id`, `MetaValue`.`val` FROM `kevinsingdb`.`meta_values` AS `MetaValue` WHERE `MetaValue`.`model` = 'Page' AND `MetaValue`.`foreign_key` = (2) | 4 | 4 | 0 | |
| SELECT `MetaKey`.`id`, `MetaKey`.`name`, `MetaKey`.`default`, `MetaKey`.`allow_default` FROM `kevinsingdb`.`meta_keys` AS `MetaKey` WHERE 1 = 1 ORDER BY `MetaKey`.`rank` ASC | 5 | 5 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `AttachmentVersion`.`id`, `AttachmentVersion`.`created`, `AttachmentVersion`.`modified`, `AttachmentVersion`.`model`, `AttachmentVersion`.`foreign_key`, `AttachmentVersion`.`group`, `AttachmentVersion`.`name`, `AttachmentVersion`.`type`, `AttachmentVersion`.`convert`, `AttachmentVersion`.`width`, `AttachmentVersion`.`height`, `AttachmentVersion`.`deleted`, `AttachmentVersion`.`deleted_date` FROM `kevinsingdb`.`attachment_versions` AS `AttachmentVersion` WHERE `AttachmentVersion`.`deleted` = '0' | 16 | 16 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`name` FROM `kevinsingdb`.`galleries` AS `Gallery` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `Gallery`.`id` AND `PublishingInformation`.`model` = 'Gallery') WHERE `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:14:11' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:14:11')) AND `Gallery`.`deleted` = '0' ORDER BY `PublishingInformation`.`start` DESC | 0 | 0 | 1 | maybe slow |
| SELECT `PrototypeInstance`.`id`, `PrototypeInstance`.`name`, `PrototypeInstance`.`description`, `PrototypeInstance`.`slug`, `PrototypeInstance`.`created`, `PrototypeInstance`.`modified`, `PrototypeInstance`.`use_categories`, `PrototypeInstance`.`public`, `PrototypeInstance`.`footer_text`, `PrototypeInstance`.`layout`, `PrototypeInstance`.`item_order`, `PrototypeInstance`.`allow_instance_view`, `PrototypeInstance`.`allow_category_views`, `PrototypeInstance`.`allow_item_views`, `PrototypeInstance`.`item_image_type`, `PrototypeInstance`.`item_document_type`, `PrototypeInstance`.`category_image_type`, `PrototypeInstance`.`category_document_type`, `PrototypeInstance`.`item_summary_pagination`, `PrototypeInstance`.`item_summary_pagination_limit`, `PrototypeInstance`.`use_featured_items`, `PrototypeInstance`.`all_items_featured`, `PrototypeInstance`.`number_of_featured_items`, `PrototypeInstance`.`autoload_featured_items_in_layouts`, `PrototypeInstance`.`deleted`, `PrototypeInstance`.`deleted_date`, `PrototypeInstance`.`name_field_label`, `PrototypeInstance`.`head_title`, `PrototypeInstance`.`category_changefreq`, `PrototypeInstance`.`item_changefreq`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`prototype_instances` AS `PrototypeInstance` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `PrototypeInstance`.`id` AND `PublishingInformation`.`model` = 'PrototypeInstance') WHERE `PrototypeInstance`.`deleted` = '0' | 0 | 0 | 1 | maybe slow |
| SELECT `EmailForm`.`id`, `EmailForm`.`name`, `EmailForm`.`created`, `EmailForm`.`modified`, `EmailForm`.`recipient`, `EmailForm`.`subject_template`, `EmailForm`.`content_template`, `EmailForm`.`auto_response_enabled`, `EmailForm`.`auto_response_subject_template`, `EmailForm`.`auto_response_content_template`, `EmailForm`.`attach_file`, `EmailForm`.`math_captcha`, `EmailForm`.`success_text`, `EmailForm`.`success_title`, `EmailForm`.`submit_button_text`, `EmailForm`.`cc`, `EmailForm`.`bcc`, `EmailForm`.`super_admin`, `EmailForm`.`deleted`, `EmailForm`.`deleted_date`, `EmailForm`.`submit_button_onclick`, `EmailForm`.`redirect_page_id`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`email_forms` AS `EmailForm` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `EmailForm`.`id` AND `PublishingInformation`.`model` = 'EmailForm') WHERE `EmailForm`.`id` = 1 AND `PublishingInformation`.`published` = '1' AND `PublishingInformation`.`start` <= '2017-09-24 03:14:11' AND ((`PublishingInformation`.`end` IS NULL) OR (`PublishingInformation`.`end` > '2017-09-24 03:14:11')) AND `EmailForm`.`deleted` = '0' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `EmailFormGroup`.`id`, `EmailFormGroup`.`name`, `EmailFormGroup`.`email_form_id`, `EmailFormGroup`.`rank` FROM `kevinsingdb`.`email_form_groups` AS `EmailFormGroup` WHERE `EmailFormGroup`.`email_form_id` = (1) ORDER BY `EmailFormGroup`.`rank` ASC | 1 | 1 | 12 | maybe slow |
| SELECT `EmailFormField`.`id`, `EmailFormField`.`name`, `EmailFormField`.`default`, `EmailFormField`.`type`, `EmailFormField`.`required`, `EmailFormField`.`validate`, `EmailFormField`.`label`, `EmailFormField`.`validate_message`, `EmailFormField`.`rank`, `EmailFormField`.`options`, `EmailFormField`.`foreign_key`, `EmailFormField`.`model`, `EmailFormField`.`display_label`, `EmailFormField`.`group`, `EmailFormField`.`placeholder`, `EmailFormField`.`description` FROM `kevinsingdb`.`custom_fields` AS `EmailFormField` WHERE `EmailFormField`.`model` = 'EmailFormGroup' AND `EmailFormField`.`foreign_key` = (1) ORDER BY `EmailFormField`.`rank` ASC, `EmailFormField`.`id` ASC | 3 | 3 | 8 | maybe slow |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Bing.verification_code' 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`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (20) ORDER BY `Image`.`rank` ASC, `Image`.`id` ASC | 0 | 0 | 1 | maybe slow |
| 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`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (20) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.Google.analytics_code' 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`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (19) 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`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (19) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`dirname`, `Image`.`basename`, `Image`.`checksum`, `Image`.`alternative`, `Image`.`group`, `Image`.`created`, `Image`.`modified`, `Image`.`rank`, `Image`.`deleted`, `Image`.`deleted_date`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (1) 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`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 8 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 16 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 9 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 10 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 13 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 12 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 11 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 15 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 14 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 5 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 6 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 17 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 18 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 19 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`publishing_information` AS `PublishingInformation` WHERE `model` = 'NavigationMenuItem' AND `foreign_key` = 7 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`id` = 7 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `NavigationMenuItem`.`id`, `NavigationMenuItem`.`created`, `NavigationMenuItem`.`modified`, `NavigationMenuItem`.`name`, `NavigationMenuItem`.`parent_id`, `NavigationMenuItem`.`lft`, `NavigationMenuItem`.`rght`, `NavigationMenuItem`.`navigation_menu_id`, `NavigationMenuItem`.`url`, `NavigationMenuItem`.`target_page`, `NavigationMenuItem`.`rank`, `NavigationMenuItem`.`foreign_model`, `NavigationMenuItem`.`foreign_key`, `NavigationMenuItem`.`new_window`, `NavigationMenuItem`.`foreign_plugin`, `NavigationMenuItem`.`deleted`, `NavigationMenuItem`.`deleted_date`, `PublishingInformation`.`id`, `PublishingInformation`.`created`, `PublishingInformation`.`modified`, `PublishingInformation`.`model`, `PublishingInformation`.`foreign_key`, `PublishingInformation`.`start`, `PublishingInformation`.`end`, `PublishingInformation`.`published` FROM `kevinsingdb`.`navigation_menu_items` AS `NavigationMenuItem` LEFT JOIN `kevinsingdb`.`publishing_information` AS `PublishingInformation` ON (`PublishingInformation`.`foreign_key` = `NavigationMenuItem`.`id` AND `PublishingInformation`.`model` = 'NavigationMenuItem') WHERE `NavigationMenuItem`.`parent_id` = 7 AND `NavigationMenuItem`.`deleted` = '0' ORDER BY `NavigationMenuItem`.`lft` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`key`, `Setting`.`value`, `Setting`.`title`, `Setting`.`description`, `Setting`.`type`, `Setting`.`editable`, `Setting`.`super_admin`, `Setting`.`options`, `Setting`.`method`, `Setting`.`display`, (REPLACE(CONCAT(UPPER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1), 1, 1)), LOWER(SUBSTRING(SUBSTRING_INDEX(`Setting`.`key`, '.', -1) FROM 2))), '_', ' ')) AS `Setting__tinyMceOption` FROM `kevinsingdb`.`settings` AS `Setting` WHERE `Setting`.`key` = 'Site.name' 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`, (CONCAT_WS("/", dirname, basename)) AS `Image__path` FROM `kevinsingdb`.`attachments` AS `Image` WHERE `Image`.`model` = 'Setting' AND `Image`.`group` = 'Image' AND `Image`.`foreign_key` = (1) 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`, (CONCAT_WS("/", dirname, basename)) AS `Document__path` FROM `kevinsingdb`.`attachments` AS `Document` WHERE `Document`.`model` = 'Setting' AND `Document`.`group` = 'Document' AND `Document`.`foreign_key` = (1) ORDER BY `Document`.`rank` ASC | 0 | 0 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CmsPlugin`.`id`, `CmsPlugin`.`created`, `CmsPlugin`.`modified`, `CmsPlugin`.`name`, `CmsPlugin`.`alias`, `CmsPlugin`.`slug`, `CmsPlugin`.`description`, `CmsPlugin`.`active`, `CmsPlugin`.`layout`, `CmsPlugin`.`theme`, `CmsPlugin`.`internal`, `CmsPlugin`.`schema_version`, `CmsPlugin`.`core` FROM `kevinsingdb`.`installed_plugins` AS `CmsPlugin` WHERE `name` = 'Responsive' LIMIT 1 | 1 | 1 | 0 |
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `BootstrapVrebInstance`.`id`, `BootstrapVrebInstance`.`name`, `BootstrapVrebInstance`.`slug` FROM `vrebradarhilldb`.`prototype_instances` AS `BootstrapVrebInstance` WHERE `id` IN (1, 2) | 2 | 2 | 0 |
Peak Memory Use 34.89 MB
| Message | Memory use |
|---|---|
| Component initialization | 12.72 MB |
| Controller action start | 14.84 MB |
| Controller render start | 18.90 MB |
| View render complete | 27.09 MB |
Total Request Time: 950 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 178.82 | |
| Component initialization and startup | 24.24 | |
| Controller action | 149.13 | |
| Render Controller Action | 407.57 | |
| » Rendering View | 406.10 | |
| » » Rendering CORE/working/lib/Cms/Plugin/Pages/View/Pages/view.ctp | 146.41 | |
| » » » Rendering CORE/working/lib/Cms/Plugin/EmailForms/View/Elements/email_form.ctp | 27.09 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/required.ctp | 0.57 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/required.ctp #2 | 0.46 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/required.ctp #3 | 0.31 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/required.ctp #4 | 0.31 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/required.ctp #5 | 0.31 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/required.ctp #6 | 0.30 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/required.ctp #7 | 0.30 | |
| » » Rendering APP/View/Layouts/default.ctp | 178.09 | |
| » » » Rendering APP/View/Elements/layout/header.ctp | 167.35 | |
| » » » » Rendering CORE/working/lib/Cms/Plugin/VrebListings/View/Elements/header_scripts.ctp | 0.61 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/clear_float.ctp | 1.20 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/clear_float.ctp #2 | 1.24 | |
| » » » Rendering APP/View/Elements/layout/footer.ctp | 6.26 | |
| » » » » Rendering CORE/working/lib/Cms/View/Elements/clear_float.ctp #3 | 1.23 |
| Time | Message |
|---|---|
| 2017-09-24 03:14:11 | Array ( [successful_login] => false ) |
| 2017-09-24 03:14:11 | Array ( [successful_login] => false ) |