Register your account

You must register as a user in order to gain access to this site. Please enter your details below and submit your registration information.

Formkraft will review your application within one working day. Once access has been authorised, you will receive a verification email. Simply click on the link to verify your account.

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent8a9ea17583f4b540860318f8e0a5618c
  time1770543267
  countdown10
- EvCurrency(array)
  currencyId1
  currencyCodeGBP
  currencyData(array)
  id1
  nameGBP
  currency_prefix£
  currency_suffix(empty)
  thousand_separator,
  decimal_point_char.
  decimal_places2
  exchange_rate1.00
  exchange_rate_date(null)
  conversion_padding0.00
  free_delivery_threshold(null)
  is_active(true)
  is_default(true)
  sequence0
  created2016-06-07 15:17:56
  modified2016-06-07 15:17:56
- _SimpleCsrf(array)
  144fa79b6c2354a2078e654ba22cd332834dc1061770545667
====
Request
+
Request
Cake Params
- plugin(false)
- controllerev_core_users
- actionregister
- named(empty)
- pass(empty)
- _SimpleCsrf(array)
  token144fa79b6c2354a2078e654ba22cd332834dc106
Post data
No post data.
Query string
No querystring data.
Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  plugin(false)
  controllerev_core_users
  actionregister
- template/register
====

Sql Log

Sql Logs

default

Total Time: 78 ms
Total Queries: 67 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Company`.`inactive_logout_minutes` FROM `hive-beta`.`companies` AS `Company` WHERE `url_prefix` = 'demo' LIMIT 1	1	1	0
SELECT `SiteSetting`.`id`, `SiteSetting`.`name`, `SiteSetting`.`array_slug`, `SiteSetting`.`type`, `SiteSetting`.`options`, `SiteSetting`.`value`, `SiteSetting`.`sequence`, `SiteSetting`.`site_setting_category_id`, `SiteSetting`.`prevent_edit`, `SiteSetting`.`created`, `SiteSetting`.`modified`, `SiteSettingCategory`.`id`, `SiteSettingCategory`.`name`, `SiteSettingCategory`.`array_slug`, `SiteSettingCategory`.`sequence`, `SiteSettingCategory`.`prevent_edit`, `SiteSettingCategory`.`created`, `SiteSettingCategory`.`modified` FROM `hive-beta`.`ev_site_settings_site_settings` AS `SiteSetting` LEFT JOIN `hive-beta`.`ev_site_settings_site_setting_categories` AS `SiteSettingCategory` ON (`SiteSetting`.`site_setting_category_id` = `SiteSettingCategory`.`id`) WHERE 1 = 1 ORDER BY `SiteSetting`.`array_slug` ASC	22	22	1
SELECT `Currency`.`id`, `Currency`.`name` FROM `hive-beta`.`ev_currency_currencies` AS `Currency` WHERE `Currency`.`is_active` = '1' ORDER BY `Currency`.`name` ASC, `Currency`.`sequence` ASC	1	1	1
SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`currency_prefix`, `Currency`.`currency_suffix`, `Currency`.`thousand_separator`, `Currency`.`decimal_point_char`, `Currency`.`decimal_places`, `Currency`.`exchange_rate`, `Currency`.`exchange_rate_date`, `Currency`.`conversion_padding`, `Currency`.`free_delivery_threshold`, `Currency`.`is_active`, `Currency`.`is_default`, `Currency`.`sequence`, `Currency`.`created`, `Currency`.`modified` FROM `hive-beta`.`ev_currency_currencies` AS `Currency` WHERE `is_default` = '1' LIMIT 1	1	1	1
SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`currency_prefix`, `Currency`.`currency_suffix`, `Currency`.`thousand_separator`, `Currency`.`decimal_point_char`, `Currency`.`decimal_places`, `Currency`.`exchange_rate`, `Currency`.`exchange_rate_date`, `Currency`.`conversion_padding`, `Currency`.`free_delivery_threshold`, `Currency`.`is_active`, `Currency`.`is_default`, `Currency`.`sequence`, `Currency`.`created`, `Currency`.`modified` FROM `hive-beta`.`ev_currency_currencies` AS `Currency` WHERE `id` = 1 AND `is_active` = '1' LIMIT 1	1	1	0
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `hive-beta`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '6717d25657f915c8edf4f8b1372e2277' LIMIT 1	0	0	0
SELECT `Company`.`id`, `Company`.`name`, `Company`.`url_prefix`, `Company`.`hex_welcome_background`, `Company`.`hex_welcome_text`, `Company`.`hex_primary_background`, `Company`.`hex_primary_text`, `Company`.`hex_secondary_background`, `Company`.`hex_secondary_text`, `Company`.`hex_secondary_text2`, `Company`.`password_expiry_days`, `Company`.`inactive_logout_minutes`, `Company`.`whitelist_ips`, `Company`.`delivery_schedule`, `Company`.`contact_details`, `Company`.`allows_registration`, `Company`.`show_popular_products`, `Company`.`delivery_cost`, `Company`.`delivery_offer`, `Company`.`free_monthly_deliveries_per_branch`, `Company`.`free_delivery_fixed_amount`, `Company`.`minimum_spend`, `Company`.`budget_timeframe`, `Company`.`budget_start_date`, `Company`.`allows_hq_edit`, `Company`.`allows_area_manager_edit`, `Company`.`allows_area_manager_order_address_edit`, `Company`.`allows_area_manager_order_quantity_edit`, `Company`.`branch_registration_fields`, `Company`.`has_custom_briefing_form`, `Company`.`has_password_reveal`, `Company`.`has_mandatory_order_reference`, `Company`.`admin_contact_id`, `Company`.`branch_terminology_id`, `Company`.`created`, `Company`.`modified`, `Company`.`is_active`, `BranchTerminology`.`id`, `BranchTerminology`.`name`, `BranchTerminology`.`singular`, `BranchTerminology`.`plural`, `BranchTerminology`.`created`, `BranchTerminology`.`modified`, `BranchTerminology`.`is_active`, (CONCAT(`BranchTerminology`.`name`, ' (', `BranchTerminology`.`singular`, ' / ', `BranchTerminology`.`plural`, ')')) AS `BranchTerminology__long_name` FROM `hive-beta`.`companies` AS `Company` LEFT JOIN `hive-beta`.`branch_terminologies` AS `BranchTerminology` ON (`Company`.`branch_terminology_id` = `BranchTerminology`.`id`) WHERE `Company`.`url_prefix` = 'demo' AND `Company`.`is_active` = '1' AND ((`Company`.`whitelist_ips` IS NULL) OR (`Company`.`whitelist_ips` = '') OR (`Company`.`whitelist_ips` LIKE '%216.73.216.6%')) LIMIT 1	1	1	1
SELECT `LogoImage`.`id`, `LogoImage`.`model`, `LogoImage`.`model_id`, `LogoImage`.`filename`, `LogoImage`.`attachment_type`, `LogoImage`.`template_id`, `LogoImage`.`alt`, `LogoImage`.`caption`, `LogoImage`.`link_text`, `LogoImage`.`link_url`, `LogoImage`.`type`, `LogoImage`.`size`, `LogoImage`.`dir`, `LogoImage`.`sequence`, `LogoImage`.`is_active`, `LogoImage`.`created`, `LogoImage`.`modified`, (CONCAT("files/image/", dir, "/", filename)) AS `LogoImage__filepath` FROM `hive-beta`.`images` AS `LogoImage` WHERE `model` = 'Company' AND `attachment_type` = 'LogoImage' AND `LogoImage`.`model_id` = (2)	1	1	2	maybe slow
SELECT `UserManualDocument`.`id`, `UserManualDocument`.`uuid`, `UserManualDocument`.`model`, `UserManualDocument`.`model_id`, `UserManualDocument`.`filename`, `UserManualDocument`.`attachment_type`, `UserManualDocument`.`template_id`, `UserManualDocument`.`caption`, `UserManualDocument`.`type`, `UserManualDocument`.`ext`, `UserManualDocument`.`size`, `UserManualDocument`.`dir`, `UserManualDocument`.`sequence`, `UserManualDocument`.`is_active`, `UserManualDocument`.`created`, `UserManualDocument`.`modified`, (CONCAT("files/document/", dir, "/", filename)) AS `UserManualDocument__filepath`, (CONCAT("/files/document/", dir, "/", filename)) AS `UserManualDocument__url` FROM `hive-beta`.`documents` AS `UserManualDocument` WHERE `model` = 'Company' AND `attachment_type` = 'UserManualDocument' AND `UserManualDocument`.`model_id` = (2) ORDER BY `sequence` asc	1	1	1
SELECT `Company`.`branch_registration_fields` FROM `hive-beta`.`companies` AS `Company` WHERE `id` = 2 LIMIT 1	1	1	0
SELECT `Page`.`template_id` FROM `hive-beta`.`pages` AS `Page` WHERE `Page`.`id` = 7 LIMIT 1	1	1	0
SELECT `Page`.`id`, `Page`.`title`, `Page`.`internal_title`, `Page`.`body`, `Page`.`is_active`, `Page`.`is_protected`, `Page`.`template_id`, `Page`.`redirect_url`, `Page`.`created`, `Page`.`modified` FROM `hive-beta`.`pages` AS `Page` WHERE `Page`.`is_active` = '1' AND `Page`.`id` = 7 LIMIT 1	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`template_id`, `Image`.`alt`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", dir, "/", filename)) AS `Image__filepath` FROM `hive-beta`.`images` AS `Image` WHERE `model` = 'Page' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (7) ORDER BY `sequence` ASC	0	0	2	maybe slow
SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `hive-beta`.`meta_data` AS `MetaData` WHERE ((`MetaData`.`model` = 'Page') AND (`MetaData`.`model_id` = 7))	1	1	0
SELECT `FieldData`.`id`, `FieldData`.`field_id`, `FieldData`.`value`, `FieldData`.`model`, `FieldData`.`model_id`, `FieldData`.`created`, `FieldData`.`modified`, `Field`.`id`, `Field`.`name`, `Field`.`tab_name`, `Field`.`label`, `Field`.`type`, `Field`.`display_info`, `Field`.`options`, `Field`.`validation`, `Field`.`model`, `Field`.`model_id`, `Field`.`sequence`, `Field`.`is_active`, `Field`.`created`, `Field`.`modified` FROM `hive-beta`.`ev_custom_fields_field_data` AS `FieldData` LEFT JOIN `hive-beta`.`ev_custom_fields_fields` AS `Field` ON (`FieldData`.`field_id` = `Field`.`id`) WHERE `FieldData`.`model` = 'EvCore.Page' AND `FieldData`.`model_id` = (7) ORDER BY `Field`.`sequence` ASC	0	0	1	maybe slow
SELECT `Branch`.`id`, `Branch`.`name` FROM `hive-beta`.`branches` AS `Branch` WHERE `Branch`.`company_id` = 2 AND `Branch`.`is_active` = '1' ORDER BY `Branch`.`name` ASC	3	3	1	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`parent_id`, `CompaniesProductCategory`.`total_products`, `ProductCategory`.`slug` FROM `hive-beta`.`product_categories` AS `ProductCategory` INNER JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`slug` IS NOT NULL ORDER BY `ProductCategory`.`name` ASC	13	13	1	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`parent_id`, `CompaniesProductCategory`.`total_products`, `ProductCategory`.`slug` FROM `hive-beta`.`product_categories` AS `ProductCategory` INNER JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`slug` IS NOT NULL AND `ProductCategory`.`parent_id` IN (64, 21, 36, 80, 15, 45, 67, 4, 62, 1, 100, 13, 18) ORDER BY `ProductCategory`.`name` ASC	6	6	1	maybe slow
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 36 LIMIT 1	1	1	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 204 AND `ProductCategory`.`rght` >= 215 ORDER BY `ProductCategory`.`lft` asc	1	1	0
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 80 LIMIT 1	1	1	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 152 AND `ProductCategory`.`rght` >= 169 ORDER BY `ProductCategory`.`lft` asc	1	1	1
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 15 LIMIT 1	1	1	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 92 AND `ProductCategory`.`rght` >= 105 ORDER BY `ProductCategory`.`lft` asc	1	1	0
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 4 LIMIT 1	1	1	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 38 AND `ProductCategory`.`rght` >= 53 ORDER BY `ProductCategory`.`lft` asc	1	1	0
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 62 LIMIT 1	1	1	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 116 AND `ProductCategory`.`rght` >= 131 ORDER BY `ProductCategory`.`lft` asc	1	1	0
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 LIMIT 1	1	1	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 2 AND `ProductCategory`.`rght` >= 9 ORDER BY `ProductCategory`.`lft` asc	1	1	0
SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 18 LIMIT 1	1	1	0
SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 194 AND `ProductCategory`.`rght` >= 203 ORDER BY `ProductCategory`.`lft` asc	1	1	0
SELECT `ProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`parent_id` IS NULL GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	19	19	7	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 170 AND `ProductCategory`.`rght` < 171 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	0	0	1	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 78 AND `ProductCategory`.`rght` < 91 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	6	6	3	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 172 AND `ProductCategory`.`rght` < 191 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	9	9	4	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 204 AND `ProductCategory`.`rght` < 215 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	5	5	3	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 152 AND `ProductCategory`.`rght` < 169 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	8	8	3	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 92 AND `ProductCategory`.`rght` < 105 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	6	6	3	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 216 AND `ProductCategory`.`rght` < 223 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	3	3	2	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 10 AND `ProductCategory`.`rght` < 29 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	9	9	4	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 232 AND `ProductCategory`.`rght` < 241 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	4	4	2	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 30 AND `ProductCategory`.`rght` < 37 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	3	3	2	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 38 AND `ProductCategory`.`rght` < 53 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	7	7	3	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 116 AND `ProductCategory`.`rght` < 131 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	7	7	3	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 2 AND `ProductCategory`.`rght` < 9 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	3	3	2	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 54 AND `ProductCategory`.`rght` < 77 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	11	11	4	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 106 AND `ProductCategory`.`rght` < 107 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	0	0	1	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 132 AND `ProductCategory`.`rght` < 151 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	9	9	3	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 224 AND `ProductCategory`.`rght` < 231 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	3	3	2	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 108 AND `ProductCategory`.`rght` < 115 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	3	3	2	maybe slow
SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 2) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 194 AND `ProductCategory`.`rght` < 203 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC	4	4	3	maybe slow
SELECT `ProductBrand`.`id`, `ProductBrand`.`name`, `CompaniesProductBrand`.`total_products`, `ProductBrand`.`slug` FROM `hive-beta`.`product_brands` AS `ProductBrand` INNER JOIN `hive-beta`.`companies_product_brands` AS `CompaniesProductBrand` ON (`ProductBrand`.`id` = `CompaniesProductBrand`.`product_brand_id` AND `CompaniesProductBrand`.`company_id` = 2) WHERE `ProductBrand`.`is_active` = '1' AND `ProductBrand`.`slug` IS NOT NULL AND `ProductBrand`.`company_id` = 2 ORDER BY `ProductBrand`.`name` ASC	2	2	1	maybe slow
SELECT `CompaniesProductBrand`.`id`, `CompaniesProductBrand`.`company_id`, `CompaniesProductBrand`.`product_brand_id`, `CompaniesProductBrand`.`total_products`, `CompaniesProductBrand`.`created` FROM `hive-beta`.`companies_product_brands` AS `CompaniesProductBrand` WHERE `CompaniesProductBrand`.`product_brand_id` IN (1, 3)	10	10	0
SELECT `ProductRange`.`id`, `ProductRange`.`name`, `CompaniesProductRange`.`total_products`, `ProductRange`.`slug` FROM `hive-beta`.`product_ranges` AS `ProductRange` INNER JOIN `hive-beta`.`companies_product_ranges` AS `CompaniesProductRange` ON (`ProductRange`.`id` = `CompaniesProductRange`.`product_range_id` AND `CompaniesProductRange`.`company_id` = 2) WHERE `ProductRange`.`is_active` = '1' AND `ProductRange`.`slug` IS NOT NULL AND `ProductRange`.`company_id` = 2 ORDER BY `ProductRange`.`name` ASC	2	2	1	maybe slow
SELECT `CompaniesProductRange`.`id`, `CompaniesProductRange`.`company_id`, `CompaniesProductRange`.`product_range_id`, `CompaniesProductRange`.`total_products`, `CompaniesProductRange`.`created` FROM `hive-beta`.`companies_product_ranges` AS `CompaniesProductRange` WHERE `CompaniesProductRange`.`product_range_id` IN (1, 4)	18	18	0
SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '5a764645-dcf2-402a-acee-422005c56efc' AND `Basket`.`currency_id` = 1	1	1	0
BEGIN
SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '5a764645-dcf2-402a-acee-422005c56efc'	1	1	0
INSERT INTO `hive-beta`.`ev_basket_baskets` (`hash`, `currency_id`, `modified`, `created`) VALUES ('5a764645-dcf2-402a-acee-422005c56efc', 1, '2026-02-08 09:14:27', '2026-02-08 09:14:27')	1	1	0
COMMIT
SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '5a764645-dcf2-402a-acee-422005c56efc' AND `Basket`.`currency_id` = 1	1	1	2	maybe slow
SELECT `Basket`.`id`, `Basket`.`user_id`, `Basket`.`hash`, `Basket`.`currency_id`, `Basket`.`created`, `Basket`.`modified`, `Basket`.`last_activity` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '5a764645-dcf2-402a-acee-422005c56efc' AND `Basket`.`currency_id` = 1 LIMIT 1	1	1	1
SELECT `BasketItem`.`id`, `BasketItem`.`basket_id`, `BasketItem`.`name`, `BasketItem`.`model`, `BasketItem`.`model_id`, `BasketItem`.`artwork_type`, `BasketItem`.`company_artwork_id`, `BasketItem`.`company_artwork_caption`, `BasketItem`.`unit_price`, `BasketItem`.`unit_tax`, `BasketItem`.`tax_rate`, `BasketItem`.`quantity`, `BasketItem`.`row_total`, `BasketItem`.`created`, `BasketItem`.`modified` FROM `hive-beta`.`ev_basket_basket_items` AS `BasketItem` WHERE `BasketItem`.`basket_id` = (130410)	0	0	0
SELECT `BasketTotal`.`id`, `BasketTotal`.`basket_id`, `BasketTotal`.`name`, `BasketTotal`.`amount`, `BasketTotal`.`tax`, `BasketTotal`.`display_inc_tax`, `BasketTotal`.`display_ex_tax`, `BasketTotal`.`sequence`, `BasketTotal`.`is_grand_total`, `BasketTotal`.`display_only`, `BasketTotal`.`created`, `BasketTotal`.`modified` FROM `hive-beta`.`ev_basket_basket_totals` AS `BasketTotal` WHERE `BasketTotal`.`basket_id` = (130410) ORDER BY `BasketTotal`.`is_grand_total` ASC, `BasketTotal`.`sequence` ASC	0	0	0
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`level`, `Menu`.`name`, `Menu`.`system_name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`content_element`, `Menu`.`permission_level`, `Menu`.`requires_login`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified` FROM `hive-beta`.`ev_navigation_menus` AS `Menu` WHERE `Menu`.`id` = 8 ORDER BY `lft` ASC LIMIT 1	1	1	1
SELECT `Menu`.*, `Page`.`redirect_url` FROM `hive-beta`.`ev_navigation_menus` AS `Menu` LEFT JOIN `hive-beta`.`pages` AS `Page` ON (`Menu`.`model` = 'EvCorePage' AND `Page`.`id` = `Menu`.`model_id`) WHERE `Menu`.`lft` > 78 AND `Menu`.`rght` < 79 AND `Menu`.`is_active` = '1' ORDER BY `Menu`.`lft` ASC	0	0	0

1 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 9.23 MB

Message	Memory use
Component initialization	5.30 MB
Controller action start	5.61 MB
Controller render start	5.93 MB
View render complete	6.86 MB

Timers

Total Request Time: 772 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	126.14
Event: Controller.initialize	25.12
Event: Controller.startup	0.47
Controller action	21.70
Event: Controller.beforeRender	110.00
» Processing toolbar data	5.10
Rendering View	15.68
» Event: View.beforeRender	0.03
» Rendering APP/View/Plugin/EvCore/Users/register.ctp	6.19
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	8.98
» » Rendering APP/View/Elements/site_header.ctp	3.73
» » » Rendering APP/View/Elements/impersonate_banner.ctp	0.03
» » Rendering APP/View/Elements/site_footer.ctp	4.84
» » » Rendering APP/View/Elements/need-help-call-us.ctp	0.04
Event: View.afterLayout	0.00

====

Log
+
Logs
There were no log entries made this request
====
Variables
+
View Variables
- isRegistration(true)
- branches(array)
 1Demo Branch 1
 3Demo Branch 2
 43Demo Branch 3
- data(array)
 Page(array)
 id7
 titleRegister your account
 internal_title(null)
 bodyYou must register as a user in order to gain access to this site. Please enter your details below and submit your registration information. Formkraft will review your application within one working day. Once access has been authorised, you will receive a verification email. Simply click on the link to verify your account. 
 is_active(true)
 is_protected(false)
 template_id(null)
 redirect_url(null)
 created2016-04-22 16:30:56
 modified2016-09-30 14:56:59
 Image(empty)
 MetaData(array)
 id5
 modelPage
 model_id7
 title(empty)
 description(empty)
 keywords(null)
 created2016-04-22 16:30:56
 modified2016-09-30 14:56:59
- metaKeywordsYou must register as a user in order to gain access to this site. Please enter your details below and submit your registration information. Formkraft will review your application&nb...
- metaDescriptionYou must register as a user in order to gain access to this site. Please enter your details below and submit your registration information. Formkraft will review your application&nb...
- metaTitleRegister your account | Formkraft
- title_for_layoutRegister your account | Formkraft
- titleForLayoutRegister your account | Formkraft
- additionalBranchRegistrationFields(array)
 0(array)
 labelTest Field
 typetext
- currentCompany(array)
 Company(array)
 id2
 nameDemo
 url_prefixdemo
 hex_welcome_background#d3dff8
 hex_welcome_text#231f1f
 hex_primary_background#7f7f7f
 hex_primary_text#ffffff
 hex_secondary_background#dd4b85
 hex_secondary_text#3f3f3a
 hex_secondary_text2#ffffff
 password_expiry_days90
 inactive_logout_minutes20
 whitelist_ips(empty)
 delivery_scheduleThis is the help page text...
 contact_details(empty)
 allows_registrationbranch
 show_popular_products(false)
 delivery_cost15.000000
 delivery_offernone
 free_monthly_deliveries_per_branch(null)
 free_delivery_fixed_amount(null)
 minimum_spend50.000000
 budget_timeframequarterly
 budget_start_date01/10
 allows_hq_edit(true)
 allows_area_manager_edit(true)
 allows_area_manager_order_address_edit(true)
 allows_area_manager_order_quantity_edit(true)
 branch_registration_fields[{"label":"Test Field ","type":"text"}]
 has_custom_briefing_form(false)
 has_password_reveal(false)
 has_mandatory_order_reference(false)
 admin_contact_id9
 branch_terminology_id1
 created2017-01-17 12:29:17
 modified2025-05-07 15:15:14
 is_active(true)
 BranchTerminology(array)
 id1
 nameBranch
 singularbranch
 pluralbranches
 created2016-11-11 14:49:16
 modified2016-11-11 14:49:16
 is_active(true)
 long_nameBranch (branch / branches)
 LogoImage(array)
 0(array)
 id2803
 modelCompany
 model_id2
 filename1729260773_Test_Image_2.jfif
 attachment_typeLogoImage
 template_id(null)
 alt(null)
 caption(null)
 link_text(null)
 link_url(null)
 typeimage/jpeg
 size7860
 dir2803
 sequence0
 is_active(true)
 created2024-10-18 15:12:53
 modified2025-05-07 15:15:14
 filepathfiles/image/2803/1729260773_Test_Image_2.jfif
 UserManualDocument(array)
 0(array)
 id283
 uuida7de3ab6-f2ef-472d-aeae-c816c575c22c
 modelCompany
 model_id2
 filename1730117128_FormkraftHiveOnlineOrderingSystemUserManual.pptx
 attachment_typeUserManualDocument
 template_id(null)
 caption(empty)
 typeapplication/vnd.openxmlformats-officedocument.presentationml.presentation
 extpptx
 size41777
 dir283
 sequence0
 is_active(true)
 created2024-10-28 12:05:28
 modified2025-05-07 15:15:14
 filepathfiles/document/283/1730117128_FormkraftHiveOnlineOrderingSystemUserManual.pptx
 url/files/document/283/1730117128_FormkraftHiveOnlineOrderingSystemUserManual.pptx
 friendly_filenameFormkraftHiveOnlineOrderingSystemUserManual.pptx
- currency(array)
 id1
 nameGBP
 currency_prefix£
 currency_suffix(empty)
 thousand_separator,
 decimal_point_char.
 decimal_places2
 exchange_rate1.00
 exchange_rate_date(null)
 conversion_padding0.00
 free_delivery_threshold(null)
 is_active(true)
 is_default(true)
 sequence0
 created2016-06-07 15:17:56
 modified2016-06-07 15:17:56
- currencies(array)
 1GBP
- $request->data(empty)
- $this->validationErrors(array)
 Company(empty)
 User(empty)
 Branch(empty)
 CompanyArtwork(empty)
 Basket(empty)
 BasketItem(empty)
 BasketTotal(empty)
 Permission(empty)
 Aro(empty)
 Aco(empty)
 Session(empty)
 UserGroup(empty)
 SiteSetting(empty)
 SiteSettingCategory(empty)
 BasketData(empty)
 BasketItemData(empty)
 Currency(empty)
 Menu(empty)
 LogoImage(empty)
 UserManualDocument(empty)
 BranchTerminology(empty)
 Page(empty)
 Image(empty)
 MetaData(empty)
 FieldData(empty)
 Field(empty)
 ProductCategory(empty)
 CompaniesProductCategory(empty)
 ProductBrand(empty)
 Product(empty)
 Faq(empty)
 RelatedProduct(empty)
 ProductRange(empty)
 ProductIcon(empty)
 CompaniesProductBrand(empty)
 CompaniesProductRange(empty)
 ProductVariant(empty)
 GalleryImage(empty)
 ListingImage(empty)
 ParentProductCategory(empty)
 CompaniesProductData(empty)
 CustomImage(empty)
 Pricing(empty)
- Loaded Helpers(array)
 0Html
 1Form
 2Session
 3Flash
 4Number
 5InflectorExt
 6Img
 7Listing
 8Navigation
 9Route
 10CustomFields
 11Permissions
 12Page
 13Paginator
 14Text
 15Basket
 16OrderStatus
 17Company
 18Breadcrumb
 19SimpleGraph
 20DebugTimer
 21Toolbar
 22HtmlToolbar
====

Environment

App Constants

Constant	Value
CONFIG	'/var/www/hive-beta/releases/27/app/Config/'

CakePHP Constants

Constant	Value
APP	'/var/www/hive-beta/releases/27/app/'
APP_DIR	'app'
APPLIBS	'/var/www/hive-beta/releases/27/app/Lib/'
CACHE	'/var/www/hive-beta/releases/27/app/tmp/cache/'
CAKE	'/var/www/hive-beta/releases/27/Vendor/cakephp/cakephp/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/var/www/hive-beta/releases/27/Vendor/cakephp/cakephp/lib'
CORE_PATH	'/var/www/hive-beta/releases/27/Vendor/cakephp/cakephp/lib/'
CAKE_VERSION	'2.10.24'
CSS	'/var/www/hive-beta/releases/27/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'https://demo.beta.formkrafthive.co.uk'
IMAGES	'/var/www/hive-beta/releases/27/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/var/www/hive-beta/releases/27/app/webroot/js/'
JS_URL	'js/'
LOGS	'/var/www/hive-beta/releases/27/app/tmp/logs/'
ROOT	'/var/www/hive-beta/releases/27'
TESTS	'/var/www/hive-beta/releases/27/app/Test/'
TMP	'/var/www/hive-beta/releases/27/app/tmp/'
VENDORS	'/var/www/hive-beta/releases/27/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/var/www/hive-beta/releases/27/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'8.3.21'
User	'hive-beta'
Home	'/home/hive-beta'
Http Host	'demo.beta.formkrafthive.co.uk'
Http Accept Encoding	'gzip, br, zstd, deflate'
Http User Agent	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
Http Accept	'/'
Redirect Status	'200'
Server Name	'beta.formkrafthive.co.uk'
Server Port	'443'
Server Addr	'10.0.2.19'
Remote Port	'20595'
Remote Addr	'216.73.216.6'
Server Software	'nginx/1.27.5'
Gateway Interface	'CGI/1.1'
Https	'on'
Request Scheme	'https'
Server Protocol	'HTTP/1.1'
Document Uri	'/index.php'
Request Uri	'/register'
Script Name	'/index.php'
Content Length	''
Content Type	''
Request Method	'GET'
Query String	''
Mage Run Type	'store'
Path Translated	'/var/www/hive-beta/releases/27/app/webroot'
Path Info	''
Document Root	'/var/www/hive-beta/current/app/webroot'
Script Filename	'/var/www/hive-beta/releases/27/app/webroot/index.php'
Fcgi Role	'RESPONDER'
Php Self	'/index.php'
Request Time Float	(float) 1770542067.6772
Request Time	(int) 1770542067

====

Include
+
Included Files
Include Paths
- 1/usr/share/php
- 2-> /var/www/hive-beta/releases/27/Vendor/cakephp/cakephp/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/TreeBehavior.php
  2CORE/Model/Behavior/AclBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AclComponent.php
  1CORE/Controller/Component/Acl/DbAcl.php
  2CORE/Controller/Component/Acl/AclInterface.php
  3CORE/Controller/Component/AuthComponent.php
  4CORE/Controller/Component/SessionComponent.php
  5CORE/Controller/Component/FlashComponent.php
  6CORE/Controller/Component/PaginatorComponent.php
  7CORE/Controller/Component/CookieComponent.php
  8CORE/Controller/Component/Auth/FormAuthenticate.php
  9CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure(array)
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/Database/Mysql.php
  1CORE/Model/Datasource/DboSource.php
  2CORE/Model/Datasource/DataSource.php
  3CORE/Model/Datasource/CakeSession.php
  4CORE/Model/Datasource/Session/DatabaseSession.php
  5CORE/Model/Datasource/Session/CakeSessionHandlerInterface.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  4CORE/Model/Permission.php
  5CORE/Model/Aro.php
  6CORE/Model/AclNode.php
  7CORE/Model/Aco.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventManager.php
  6CORE/Event/CakeEventListener.php
  7CORE/Event/CakeEvent.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/CakeNumber.php
  4CORE/Utility/Debugger.php
  5CORE/Utility/CakeText.php
  6CORE/Utility/ClassRegistry.php
  7CORE/Utility/Folder.php
  8CORE/Utility/Security.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/AppBehavior.php
  Component(array)
  0APP/Controller/Component/AppComponent.php
  1APP/Controller/Component/EvCorePermissionsComponent.php
  2APP/Controller/Component/EvCoreUserManagerComponent.php
  3APP/Controller/Component/EvImpersonateImpersonateComponent.php
  4APP/Controller/Component/BranchManagerComponent.php
  5APP/Controller/Component/EvBasketBasketComponent.php
  6APP/Controller/Component/EvBasketBasketCookieComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/Plugin/ev_basket.php
  3APP/Config/Plugin/ev_checkout.php
  4APP/Config/Plugin/ev_core.php
  5APP/Config/events.php
  6APP/Config/routes.php
  7APP/Config/default_routes.php
  8APP/Config/database.php
  Controller(array)
  0APP/Controller/EvCoreUsersController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Company.php
  1APP/Model/AppModel.php
  2APP/Model/EvCoreUser.php
  3APP/Model/Branch.php
  4APP/Model/CompanyArtwork.php
  5APP/Model/EvBasketBasket.php
  6APP/Model/EvBasketBasketItem.php
  7APP/Model/EvCoreUserGroup.php
  8APP/Model/BranchTerminology.php
  9APP/Model/EvCorePage.php
  Other(array)
  0APP/webroot/index.php
  1APP/Lib/Event/EvBasketCheckForDeliveryListener.php
  2APP/Lib/Event/EvCheckoutOrderItemStatusChangedListener.php
  3APP/Lib/Event/EvCheckoutOrderSuccessListener.php
  4APP/Lib/Event/EvCheckoutOrderStatusListener.php
  5APP/Lib/Event/EmailTemplateListener.php
  6APP/Lib/Event/OrderListener.php
  7APP/Lib/Event/BranchListener.php
  8APP/Lib/Event/EvCoreUserListener.php
  9APP/Lib/Event/EvBasketCheckRemainingItemsListener.php
  10APP/tmp/intranet_routes.php
  11APP/Lib/EvCoreBasicPermissions.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  EvAddressBook(array)
  Config(array)
  0EvAddressBook/Config/bootstrap.php
  1EvAddressBook/Config/config.php
  2EvAddressBook/Config/routes.php
  EvBasket(array)
  Config(array)
  0EvBasket/Config/bootstrap.php
  1EvBasket/Config/config.php
  2EvBasket/Config/routes.php
  Plugin(array)
  0EvBasket/Lib/Event/EvBasketClearUserCookieListener.php
  Model(array)
  0EvBasket/Model/Basket.php
  1EvBasket/Model/EvBasketAppModel.php
  2EvBasket/Model/BasketItem.php
  3EvBasket/Model/BasketTotal.php
  4EvBasket/Model/BasketData.php
  5EvBasket/Model/BasketItemData.php
  Component(array)
  0EvBasket/Controller/Component/BasketComponent.php
  1EvBasket/Controller/Component/BasketCookieComponent.php
  EvBreadcrumb(array)
  Component(array)
  0EvBreadcrumb/Controller/Component/BreadcrumbComponent.php
  EvCheckout(array)
  Config(array)
  0EvCheckout/Config/bootstrap.php
  1EvCheckout/Config/config.php
  2EvCheckout/Config/events.php
  3EvCheckout/Config/routes.php
  Plugin(array)
  0EvCheckout/Lib/Event/EvCheckoutSendConfirmationEmailsListener.php
  1EvCheckout/Lib/Event/EvCheckoutLogoutGuestUserListener.php
  2EvCheckout/Lib/Event/AddSuccessfulOrderTemplate.php
  3EvCheckout/Lib/Event/OrderItemStatusChangedListener.php
  4EvCheckout/Lib/Event/OrderStatusChangedListener.php
  EvCore(array)
  Config(array)
  0EvCore/Config/bootstrap.php
  1EvCore/Config/config.php
  2EvCore/Config/events.php
  3EvCore/Config/routes.php
  Plugin(array)
  0EvCore/Lib/Event/EvUserEmailVerificationListener.php
  1EvCore/Lib/Event/EvUserUserRequiresActivationListener.php
  2EvCore/Lib/Event/CreatedActiveAdminUserListener.php
  3EvCore/Lib/EvClassRegistry.php
  4EvCore/Lib/Panel/TemplatePanel.php
  5EvCore/Lib/BasicPermissions.php
  Controller(array)
  0EvCore/Controller/UsersController.php
  1EvCore/Controller/EvCoreController.php
  Model(array)
  0EvCore/Model/EvCoreAppModel.php
  1EvCore/Model/User.php
  2EvCore/Model/UserGroup.php
  3EvCore/Model/Image.php
  4EvCore/Model/Attachment.php
  5EvCore/Model/Document.php
  6EvCore/Model/Page.php
  Component(array)
  0EvCore/Controller/Component/AuthExtComponent.php
  1EvCore/Controller/Component/PermissionsComponent.php
  2EvCore/Controller/Component/TidyComponent.php
  3EvCore/Controller/Component/MailQueueComponent.php
  4EvCore/Controller/Component/UserManagerComponent.php
  EvCountry(array)
  Config(array)
  0EvCountry/Config/bootstrap.php
  1EvCountry/Config/config.php
  EvCurrency(array)
  Config(array)
  0EvCurrency/Config/bootstrap.php
  1EvCurrency/Config/config.php
  Component(array)
  0EvCurrency/Controller/Component/CurrenciesComponent.php
  Model(array)
  0EvCurrency/Model/Currency.php
  1EvCurrency/Model/EvCurrencyAppModel.php
  EvCustomFields(array)
  Behavior(array)
  0EvCustomFields/Model/Behavior/CustomFieldsDataBehavior.php
  Model(array)
  0EvCustomFields/Model/FieldData.php
  1EvCustomFields/Model/EvCustomFieldsAppModel.php
  2EvCustomFields/Model/Field.php
  EvEmail(array)
  Config(array)
  0EvEmail/Config/bootstrap.php
  1EvEmail/Config/config.php
  EvForm(array)
  Component(array)
  0EvForm/Controller/Component/SimpleCsrfComponent.php
  EvImg(array)
  Config(array)
  0EvImg/Config/bootstrap.php
  1EvImg/Config/config.php
  EvImpersonate(array)
  Component(array)
  0EvImpersonate/Controller/Component/ImpersonateComponent.php
  EvInflector(array)
  Config(array)
  0EvInflector/Config/bootstrap.php
  1EvInflector/Config/config.php
  Plugin(array)
  0EvInflector/Lib/InflectorExt.php
  EvNavigation(array)
  Config(array)
  0EvNavigation/Config/bootstrap.php
  1EvNavigation/Config/config.php
  2EvNavigation/Config/events.php
  Plugin(array)
  0EvNavigation/Lib/Event/ClearMenuPermissionsCacheListener.php
  Model(array)
  0EvNavigation/Model/Menu.php
  1EvNavigation/Model/EvNavigationAppModel.php
  Behavior(array)
  0EvNavigation/Model/Behavior/NavigatableBehavior.php
  EvSiteSettings(array)
  Config(array)
  0EvSiteSettings/Config/routes.php
  Component(array)
  0EvSiteSettings/Controller/Component/SiteSettingsComponent.php
  Model(array)
  0EvSiteSettings/Model/SiteSetting.php
  1EvSiteSettings/Model/EvSiteSettingsAppModel.php
  2EvSiteSettings/Model/SiteSettingCategory.php
  EvTemplates(array)
  Component(array)
  0EvTemplates/Controller/Component/TplComponent.php
  Behavior(array)
  0EvTemplates/Model/Behavior/TemplateBehavior.php
  MetaData(array)
  Config(array)
  0MetaData/Config/bootstrap.php
  1MetaData/Config/config.php
  Component(array)
  0MetaData/Controller/Component/MetaComponent.php
  Plugin(array)
  0MetaData/Lib/MetaDataLib.php
  Behavior(array)
  0MetaData/Model/Behavior/MetaBehavior.php
  Model(array)
  0MetaData/Model/MetaData.php
  1MetaData/Model/MetaDataAppModel.php
  Routable(array)
  Config(array)
  0Routable/Config/routes.php
  Component(array)
  0Routable/Controller/Component/RoutableComponent.php
  Behavior(array)
  0Routable/Model/Behavior/RoutableBehavior.php
  Searchable(array)
  Config(array)
  0Searchable/Config/bootstrap.php
  1Searchable/Config/events.php
  2Searchable/Config/routes.php
  Plugin(array)
  0Searchable/Lib/Event/SearchableListenForToggleActiveListener.php
  Upload(array)
  Behavior(array)
  0Upload/Model/Behavior/UploadBehavior.php
====
Template
+
View Template
- View/var/www/hive-beta/releases/27/app/View/Plugin/EvCore/Users/register.ctp
- Layoutdefault
- ThemeSite
====

Register your account

New Branch Details

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 78 ms Total Queries: 67 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

View Template

Total Time: 78 ms
Total Queries: 67 queries