Help Request
Please use the form below to submit a help request to Formkraft. If your need is urgent, please call our Operations team on 0114 275 4646.
For non urgent enquiries, you can email us at sales@formkraft.co.uk.
- History
- Session+
Session
- Config(array)
- userAgent8a9ea17583f4b540860318f8e0a5618c
- time1765343293
- 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)
- e81715a5a196cc9efa4fa67896216f19cfbf4a601765346293
==== - Config(array)
- Request+
Request
Cake Params
- plugin(false)
- controllerhelp_requests
- actionindex
- named(empty)
- pass(empty)
- _SimpleCsrf(array)
- tokene81715a5a196cc9efa4fa67896216f19cfbf4a60
Post data
No post data.
Query string
No querystring data.
Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
- plugin(false)
- controllerhelp_requests
- actionindex
- template/need-help
==== - Sql Log+
Sql Logs
default
Total Time: 76 ms
Total Queries: 68 queriesQuery Affected Num. rows Took (ms) Actions SELECT `Company`.`inactive_logout_minutes` FROM `hive-beta`.`companies` AS `Company` WHERE `url_prefix` = 'acme' 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 0 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` = 'b365b29a1a645d6e860fa27955a09dd9' 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` = 'acme' AND `Company`.`is_active` = '1' AND ((`Company`.`whitelist_ips` IS NULL) OR (`Company`.`whitelist_ips` = '') OR (`Company`.`whitelist_ips` LIKE '%216.73.216.166%')) 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` = (7) 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` = (7) ORDER BY `sequence` asc 1 1 1 SELECT `Page`.`template_id` FROM `hive-beta`.`pages` AS `Page` WHERE `Page`.`id` = 8 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` = 8 LIMIT 1 1 1 0 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` = (8) ORDER BY `sequence` ASC 0 0 1 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` = 8)) 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` = (8) ORDER BY `Field`.`sequence` ASC 0 0 1 maybe slow SELECT `Branch`.`id`, `Branch`.`name` FROM `hive-beta`.`branches` AS `Branch` WHERE `Branch`.`is_active` = '1' AND `Branch`.`company_id` = 7 ORDER BY `Branch`.`name` ASC 1 1 1 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` = 7) WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`slug` IS NOT NULL ORDER BY `ProductCategory`.`name` ASC 23 23 1 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` = 7) WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`slug` IS NOT NULL AND `ProductCategory`.`parent_id` IN (64, 21, 68, 83, 36, 15, 38, 22, 14, 2, 67, 3, 4, 65, 62, 1, 12, 5, 26, 10, 16, 13, 18) ORDER BY `ProductCategory`.`name` ASC 14 14 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 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` = 2 LIMIT 1 1 1 1 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` <= 10 AND `ProductCategory`.`rght` >= 29 ORDER BY `ProductCategory`.`lft` asc 1 1 0 SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 3 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` <= 30 AND `ProductCategory`.`rght` >= 37 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` = 5 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` <= 54 AND `ProductCategory`.`rght` >= 77 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` = 7) 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 6 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` = 7) 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` = 7) 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` = 7) 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` = 7) 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` = 7) 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` = 7) 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` = 7) 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` = 7) 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 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` = 7) 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 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` = 7) 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` = 7) 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` = 7) 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` = 7) 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 3 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` = 7) 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` = 7) 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` = 7) 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` = 7) 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 3 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` = 7) 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` = 7) 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 2 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` = 7) WHERE `ProductBrand`.`is_active` = '1' AND `ProductBrand`.`slug` IS NOT NULL AND `ProductBrand`.`company_id` = 7 ORDER BY `ProductBrand`.`name` ASC 0 0 1 maybe slow 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` = 7) WHERE `ProductRange`.`is_active` = '1' AND `ProductRange`.`slug` IS NOT NULL AND `ProductRange`.`company_id` = 7 ORDER BY `ProductRange`.`name` ASC 0 0 1 maybe slow SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = 'b985ae37-641b-4075-ba66-138e2a6b5821' AND `Basket`.`currency_id` = 1 1 1 1 BEGIN SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = 'b985ae37-641b-4075-ba66-138e2a6b5821' 1 1 0 INSERT INTO `hive-beta`.`ev_basket_baskets` (`hash`, `currency_id`, `modified`, `created`) VALUES ('b985ae37-641b-4075-ba66-138e2a6b5821', 1, '2025-12-10 04:58:13', '2025-12-10 04:58:13') 1 1 0 COMMIT SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = 'b985ae37-641b-4075-ba66-138e2a6b5821' 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` = 'b985ae37-641b-4075-ba66-138e2a6b5821' 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` = (114346) 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` = (114346) 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 0 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:
==== - Timer+
Memory
Peak Memory Use 8.48 MB
Message Memory use Component initialization 5.29 MB Controller action start 5.60 MB Controller render start 5.98 MB View render complete 6.76 MB Timers
Total Request Time: 792 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 134.09 Event: Controller.initialize 25.78 Event: Controller.startup 0.49 Controller action 22.38 Event: Controller.beforeRender 114.21 » Processing toolbar data 4.43 Rendering View 14.59 » Event: View.beforeRender 0.03 » Rendering APP/View/HelpRequests/index.ctp 4.73 » » Rendering APP/View/Elements/need-help-call-us.ctp 0.11 » Event: View.afterRender 0.02 » Event: View.beforeLayout 0.02 » Rendering APP/View/Layouts/default.ctp 9.32 » » Rendering APP/View/Elements/site_header.ctp 4.08 » » » Rendering APP/View/Elements/impersonate_banner.ctp 0.03 » » » Rendering APP/View/Elements/need-help-call-us.ctp #2 0.03 » » Rendering APP/View/Elements/site_footer.ctp 4.79 » » » Rendering APP/View/Elements/need-help-call-us.ctp #3 0.03 Event: View.afterLayout 0.00 ==== - Log
- Variables+
View Variables
- branches(array)
- 107Sheffield Acme
- metaKeywordsPlease use the form below to submit a help request to Formkraft. If your need is urgent, please call our Operations team on 0114 275 4646.For non urgent enquiries, you can email us at sales@fo...
- metaDescriptionPlease use the form below to submit a help request to Formkraft. If your need is urgent, please call our Operations team on 0114 275 4646.For non urgent enquiries, you can email us at sales@fo...
- metaTitleHelp Request | Formkraft
- title_for_layoutHelp Request | Formkraft
- titleForLayoutHelp Request | Formkraft
- data(array)
- Page(array)
- id8
- titleHelp Request
- internal_title(null)
- body<p>Please use the form below to submit a help request to Formkraft. If your need is urgent, please call our Operations team on 0114 275 4646.<br /><br />For non urgent enquiries, you can email us at sales@formkraft.co.uk.</p>
- is_active(true)
- is_protected(false)
- template_id(null)
- redirect_url(null)
- created2016-05-16 15:55:38
- modified2017-07-20 16:44:28
- Image(empty)
- MetaData(array)
- id6
- modelPage
- model_id8
- title(empty)
- description(empty)
- keywords(null)
- created2016-05-16 15:55:38
- modified2017-07-20 16:44:28
- Page(array)
- currentCompany(array)
- Company(array)
- id7
- nameAcme Ltd
- url_prefixacme
- hex_welcome_background#fffce6
- hex_welcome_text#000000
- hex_primary_background#a600ff
- hex_primary_text#000000
- hex_secondary_background#464749
- hex_secondary_text#a600ff
- hex_secondary_text2#ffffff
- password_expiry_days90
- inactive_logout_minutes10
- whitelist_ips(empty)
- delivery_schedule(empty)
- contact_details(empty)
- allows_registration(empty)
- show_popular_products(false)
- delivery_cost8.000000
- delivery_offerfixed_amount
- free_monthly_deliveries_per_branch(null)
- free_delivery_fixed_amount250.000000
- minimum_spend0.000000
- budget_timeframemonthly
- budget_start_date01
- allows_hq_edit(false)
- allows_area_manager_edit(false)
- allows_area_manager_order_address_edit(false)
- allows_area_manager_order_quantity_edit(false)
- branch_registration_fields(null)
- has_custom_briefing_form(false)
- has_password_reveal(false)
- has_mandatory_order_reference(false)
- admin_contact_id9
- branch_terminology_id1
- created2017-02-20 15:42:55
- modified2024-05-24 11:20:07
- 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)
- id2795
- modelCompany
- model_id7
- filename1714563079_giraffe1.jpg
- attachment_typeLogoImage
- template_id(null)
- alt(empty)
- caption(null)
- link_text(null)
- link_url(null)
- typeimage/jpeg
- size43217
- dir2795
- sequence0
- is_active(true)
- created2024-05-01 12:31:19
- modified2024-05-24 11:20:07
- filepathfiles/image/2795/1714563079_giraffe1.jpg
- 0(array)
- UserManualDocument(array)
- 0(array)
- id276
- uuid47f6cbe9-1820-4893-b2d1-ab40e5981ac3
- modelCompany
- model_id7
- filename1714563057_giraffe1.jpg
- attachment_typeUserManualDocument
- template_id(null)
- caption(empty)
- typeimage/jpeg
- extjpg
- size43217
- dir276
- sequence0
- is_active(true)
- created2024-05-01 12:30:57
- modified2024-05-24 11:20:07
- filepathfiles/document/276/1714563057_giraffe1.jpg
- url/files/document/276/1714563057_giraffe1.jpg
- friendly_filenamegiraffe1.jpg
- 0(array)
- Company(array)
- 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)
- HelpRequest(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
==== - branches(array)
- 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://acme.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 'acme.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 '32927' Remote Addr '216.73.216.166' 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 '/need-help' 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) 1765342693.5641 Request Time (int) 1765342693 ==== - 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
- Behavior(array)
- app(array)
- Behavior(array)
- 0APP/Model/Behavior/AppBehavior.php
- Component(array)
- 0APP/Controller/Component/AppComponent.php
- 1APP/Controller/Component/EvCorePermissionsComponent.php
- 2APP/Controller/Component/EvBasketBasketComponent.php
- 3APP/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/HelpRequestsController.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
- 10APP/Model/HelpRequest.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
- Behavior(array)
- 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
- Component(array)
- EvAddressBook(array)
- Config(array)
- 0EvAddressBook/Config/bootstrap.php
- 1EvAddressBook/Config/config.php
- 2EvAddressBook/Config/routes.php
- Config(array)
- 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
- Config(array)
- EvBreadcrumb(array)
- Component(array)
- 0EvBreadcrumb/Controller/Component/BreadcrumbComponent.php
- Component(array)
- 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
- Config(array)
- 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/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
- Config(array)
- EvCountry(array)
- Config(array)
- 0EvCountry/Config/bootstrap.php
- 1EvCountry/Config/config.php
- Config(array)
- 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
- Config(array)
- EvCustomFields(array)
- Behavior(array)
- 0EvCustomFields/Model/Behavior/CustomFieldsDataBehavior.php
- Model(array)
- 0EvCustomFields/Model/FieldData.php
- 1EvCustomFields/Model/EvCustomFieldsAppModel.php
- 2EvCustomFields/Model/Field.php
- Behavior(array)
- EvEmail(array)
- Config(array)
- 0EvEmail/Config/bootstrap.php
- 1EvEmail/Config/config.php
- Config(array)
- EvForm(array)
- Component(array)
- 0EvForm/Controller/Component/SimpleCsrfComponent.php
- Component(array)
- EvImg(array)
- Config(array)
- 0EvImg/Config/bootstrap.php
- 1EvImg/Config/config.php
- Config(array)
- EvInflector(array)
- Config(array)
- 0EvInflector/Config/bootstrap.php
- 1EvInflector/Config/config.php
- Plugin(array)
- 0EvInflector/Lib/InflectorExt.php
- Config(array)
- 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
- Config(array)
- 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
- Config(array)
- EvTemplates(array)
- Component(array)
- 0EvTemplates/Controller/Component/TplComponent.php
- Behavior(array)
- 0EvTemplates/Model/Behavior/TemplateBehavior.php
- Component(array)
- 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
- Config(array)
- Routable(array)
- Config(array)
- 0Routable/Config/routes.php
- Component(array)
- 0Routable/Controller/Component/RoutableComponent.php
- Behavior(array)
- 0Routable/Model/Behavior/RoutableBehavior.php
- Config(array)
- Searchable(array)
- Config(array)
- 0Searchable/Config/bootstrap.php
- 1Searchable/Config/events.php
- 2Searchable/Config/routes.php
- Plugin(array)
- 0Searchable/Lib/Event/SearchableListenForToggleActiveListener.php
- Config(array)
- Upload(array)
- Behavior(array)
- 0Upload/Model/Behavior/UploadBehavior.php
- Behavior(array)
- DebugKit(array)
==== - Template+
View Template
- View/var/www/hive-beta/releases/27/app/View/HelpRequests/index.ctp
- Layoutdefault
- ThemeSite
====