Öljynsuodattimet

History
+ –

Request History

No previous requests logged.

====
Session
+ –
Session
- Config
  userAgent4c61a1676a4699d5d4943274ece9dc6b
  time1724491609
  timeout10
  languagefin
====
Request
+ –
Request

Cake Params
- controllerclient
- actionindex
- named(empty)
- pass
  049
- plugin(null)
- form(empty)
- url
  urlclient/index/49/
- paging
  Product
  page1
  current12
  count12
  prevPage(false)
  nextPage(false)
  pageCount1
  defaults
  limit20
  step1
  conditions
  Product.id
  0882
  1883
  2739
  3862
  4588
  5271
  6268
  7890
  8923
  9857
  10884
  11887
  Product.active1
  not
  and
  Product.price0
  Product.price_custom0
  Product.price_discount0
  not
  Product.group_product1
  contain
  0AttachmentGroup.Attachment
  options
  page1
  limit20
  conditions
  Product.id
  0882
  1883
  2739
  3862
  4588
  5271
  6268
  7890
  8923
  9857
  10884
  11887
  Product.active1
  not
  and
  Product.price0
  Product.price_custom0
  Product.price_discount0
  not
  Product.group_product1
  contain
  0AttachmentGroup.Attachment
$_GET
- urlclient/index/49/
Cookie
- 7f3e30ceeba4c761f9f1330cf4e3243clangfin
Current Route
- keys
  0controller
  1action
- options(empty)
- defaults
  plugin(null)
  actionindex
- template/:controller/:action/*
- _greedy(true)
- _compiledRoute#^/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Log

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `automatik_aros`	7	7	2	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
SHOW FULL COLUMNS FROM `automatik_acos`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_aros_acos`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_products`	39	39	2	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
SHOW FULL COLUMNS FROM `automatik_attachment_groups`	9	9	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_packages`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `automatik_packages_products`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `automatik_categories`	20	20	2	maybe slow
SHOW FULL COLUMNS FROM `automatik_videos`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_subcategories`	7	7	2	maybe slow
SHOW FULL COLUMNS FROM `automatik_products_categories`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_attachments`	12	12	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_settings`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_specials`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_orders`	28	28	1
SHOW FULL COLUMNS FROM `automatik_order_items`	16	16	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_users`	27	27	1
SHOW FULL COLUMNS FROM `automatik_groups`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_delivery_methods`	14	14	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_offers`	38	38	1
SHOW FULL COLUMNS FROM `automatik_offer_items`	15	15	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_cart_progress`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_products_products`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_event_log`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `automatik_bookmarks`	7	7	1	maybe slow
SELECT `Settings`.`id`, `Settings`.`parameter`, `Settings`.`value`, `Settings`.`description`, `Settings`.`inputtype`, `Settings`.`group`, `Settings`.`superadmin`, `Settings`.`install` FROM `automatik_settings` AS `Settings` WHERE 1 = 1	57	57	1
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE `Category`.`tree` = '0' ORDER BY `Category`.`lft` asc	15	15	1	maybe slow
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE `Category`.`active` = ('1') AND `Category`.`parent_id` IS NULL ORDER BY `Category`.`lft` ASC	14	14	1	maybe slow
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_categories` AS `Category` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`category_id` = `Category`.`id`) WHERE `Category`.`id` = 49 LIMIT 1	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`category_id` = 49	1	1	1
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE `Category`.`id` = 49	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (22)	1	1	1
SELECT `Video`.`id`, `Video`.`name`, `Video`.`ident`, `Video`.`product_id`, `Video`.`category_id` FROM `automatik_videos` AS `Video` WHERE `Video`.`category_id` = (49)	0	0	0
SELECT `Special`.`id`, `Special`.`product_id`, `Special`.`category_id`, `Special`.`special_index`, `Product`.`id`, `Product`.`name`, `Product`.`desc`, `Product`.`number`, `Product`.`price`, `Product`.`discount_code`, `Product`.`name_custom`, `Product`.`number_long`, `Product`.`desc_imported`, `Product`.`supplier_number`, `Product`.`tax`, `Product`.`active`, `Product`.`stock`, `Product`.`group`, `Product`.`price_discount`, `Product`.`created`, `Product`.`updated`, `Product`.`weight`, `Product`.`name_custom_eng`, `Product`.`name_custom_swe`, `Product`.`desc_eng`, `Product`.`desc_swe`, `Product`.`show_price`, `Product`.`seo_product_title`, `Product`.`seo_product_link`, `Product`.`seo_product_meta_desc`, `Product`.`seo_product_meta_keywords`, `Product`.`name_custom_short`, `Product`.`name_custom_short_eng`, `Product`.`name_custom_short_swe`, `Product`.`image_text`, `Product`.`group_product`, `Product`.`price_custom`, `Product`.`delivery_time`, `Product`.`delivery_time_nostock`, `Product`.`delivery_time_eng`, `Product`.`delivery_time_nostock_eng`, `Product`.`delivery_time_swe`, `Product`.`delivery_time_nostock_swe` FROM `automatik_specials` AS `Special` LEFT JOIN `automatik_products` AS `Product` ON (`Special`.`product_id` = `Product`.`id`) WHERE `Special`.`category_id` = '49' AND NOT (`Special`.`special_index` IS NULL) ORDER BY `Special`.`category_id` ASC, `Special`.`special_index` ASC	0	0	1	maybe slow
SELECT `Package`.`id`, `Package`.`name`, `Package`.`desc`, `Package`.`index`, `Package`.`category_id`, `Package`.`slug`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_packages` AS `Package` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`package_id` = `Package`.`id`) WHERE `Package`.`category_id` = 49 ORDER BY `Package`.`category_id` ASC, `Package`.`index` ASC	0	0	1	maybe slow
SELECT `Category`.`lft`, `Category`.`rght` FROM `automatik_categories` AS `Category` WHERE `Category`.`id` = 49 LIMIT 1	1	1	1
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 1 AND `Category`.`rght` >= 2 ORDER BY `Category`.`lft` asc	1	1	6	maybe slow
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_categories` AS `Category` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`category_id` = `Category`.`id`) WHERE `Category`.`parent_id` = 49 AND `Category`.`active` = '1'	0	0	1	maybe slow
SELECT `Category`.`lft`, `Category`.`rght` FROM `automatik_categories` AS `Category` WHERE `Category`.`id` = 49 LIMIT 1	1	1	1
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 1 AND `Category`.`rght` >= 2 ORDER BY `Category`.`lft` asc	1	1	1
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 49 ORDER BY `Category`.`lft` asc	0	0	1	maybe slow
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 49 ORDER BY `Category`.`lft` asc	0	0	1	maybe slow
SELECT `Category`.`id`, `Category`.`name`, `Category`.`desc`, `Category`.`image`, `Category`.`tree`, `Category`.`active`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`futur_group`, `Category`.`name_eng`, `Category`.`name_swe`, `Category`.`desc_eng`, `Category`.`desc_swe`, `Category`.`pagetitle`, `Category`.`pagetitle_swe`, `Category`.`pagetitle_eng`, `Category`.`seo_url`, `Category`.`discount`, `Category`.`group` FROM `automatik_categories` AS `Category` WHERE `Category`.`active` = ('1') AND `Category`.`parent_id` IS NULL ORDER BY `Category`.`lft` ASC	14	14	1	maybe slow
SELECT `ProductsCategory`.`id`, `ProductsCategory`.`product_id`, `ProductsCategory`.`category_id`, `ProductsCategory`.`subcategory_id`, `ProductsCategory`.`desc`, `ProductsCategory`.`created`, `ProductsCategory`.`imported` FROM `automatik_products_categories` AS `ProductsCategory` WHERE `category_id` = 49 AND `subcategory_id` IS NULL	12	12	1	maybe slow
SELECT COUNT(*) AS `count` FROM `automatik_products` AS `Product` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`product_id` = `Product`.`id`) WHERE `Product`.`id` IN (882, 883, 739, 862, 588, 271, 268, 890, 923, 857, 884, 887) AND `Product`.`active` = 1 AND NOT (((`Product`.`price` = 0) AND (`Product`.`price_custom` = 0) AND (`Product`.`price_discount` = 0) AND (NOT (`Product`.`group_product` = 1))))	1	1	2	maybe slow
SHOW FULL COLUMNS FROM `automatik_suppliers`	4	4	2	maybe slow
SELECT `Product`.`id`, `Product`.`name`, `Product`.`desc`, `Product`.`number`, `Product`.`price`, `Product`.`discount_code`, `Product`.`name_custom`, `Product`.`number_long`, `Product`.`desc_imported`, `Product`.`supplier_number`, `Product`.`tax`, `Product`.`active`, `Product`.`stock`, `Product`.`group`, `Product`.`price_discount`, `Product`.`created`, `Product`.`updated`, `Product`.`weight`, `Product`.`name_custom_eng`, `Product`.`name_custom_swe`, `Product`.`desc_eng`, `Product`.`desc_swe`, `Product`.`show_price`, `Product`.`seo_product_title`, `Product`.`seo_product_link`, `Product`.`seo_product_meta_desc`, `Product`.`seo_product_meta_keywords`, `Product`.`name_custom_short`, `Product`.`name_custom_short_eng`, `Product`.`name_custom_short_swe`, `Product`.`image_text`, `Product`.`group_product`, `Product`.`price_custom`, `Product`.`delivery_time`, `Product`.`delivery_time_nostock`, `Product`.`delivery_time_eng`, `Product`.`delivery_time_nostock_eng`, `Product`.`delivery_time_swe`, `Product`.`delivery_time_nostock_swe`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_products` AS `Product` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`product_id` = `Product`.`id`) WHERE `Product`.`id` IN (882, 883, 739, 862, 588, 271, 268, 890, 923, 857, 884, 887) AND `Product`.`active` = 1 AND NOT (((`Product`.`price` = 0) AND (`Product`.`price_custom` = 0) AND (`Product`.`price_discount` = 0) AND (NOT (`Product`.`group_product` = 1)))) LIMIT 20	12	12	2	maybe slow
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 268	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (4)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 271	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (10)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 588	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (11)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 739	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (12)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 857	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (13)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 862	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (14)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 882	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (15)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 883	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (16)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 884	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (17)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 887	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (18)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 890	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (19)	1	1	1
SELECT `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_attachment_groups` AS `AttachmentGroup` WHERE `AttachmentGroup`.`product_id` = 923	1	1	1
SELECT `Attachment`.`id`, `Attachment`.`name`, `Attachment`.`version`, `Attachment`.`desc`, `Attachment`.`filename`, `Attachment`.`mime_type`, `Attachment`.`file_size`, `Attachment`.`subdir`, `Attachment`.`attachment_group_id`, `Attachment`.`created`, `Attachment`.`product_image`, `Attachment`.`admin_only` FROM `automatik_attachments` AS `Attachment` WHERE `Attachment`.`attachment_group_id` = (20)	1	1	1
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	1	maybe slow
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `Supplier`.`id`, `Supplier`.`name`, `Supplier`.`link`, `Supplier`.`number`, `AttachmentGroup`.`id`, `AttachmentGroup`.`name`, `AttachmentGroup`.`desc`, `AttachmentGroup`.`date_added`, `AttachmentGroup`.`product_id`, `AttachmentGroup`.`category_id`, `AttachmentGroup`.`package_id`, `AttachmentGroup`.`subcategory_id`, `AttachmentGroup`.`supplier_id` FROM `automatik_suppliers` AS `Supplier` LEFT JOIN `automatik_attachment_groups` AS `AttachmentGroup` ON (`AttachmentGroup`.`supplier_id` = `Supplier`.`id`) WHERE `Supplier`.`number` = '222' LIMIT 1	0	0	0
SELECT `ProductsProduct`.`id`, `ProductsProduct`.`product_id`, `ProductsProduct`.`linked_product_id`, `ProductsProduct`.`mode`, `ProductsProduct`.`created` FROM `automatik_products_products` AS `ProductsProduct` WHERE `ProductsProduct`.`mode` = 3 AND `ProductsProduct`.`product_id` IN (882, 883, 739, 862, 588, 271, 268, 890, 923, 857, 884, 887)	0	0	0
SELECT `Setting`.`id`, `Setting`.`parameter`, `Setting`.`value`, `Setting`.`description`, `Setting`.`inputtype`, `Setting`.`group`, `Setting`.`superadmin`, `Setting`.`install` FROM `automatik_settings` AS `Setting` WHERE `Setting`.`parameter` = 'cms_root' LIMIT 1	1	1	1
SELECT `Setting`.`id`, `Setting`.`parameter`, `Setting`.`value`, `Setting`.`description`, `Setting`.`inputtype`, `Setting`.`group`, `Setting`.`superadmin`, `Setting`.`install` FROM `automatik_settings` AS `Setting` WHERE `Setting`.`parameter` = 'cms_pretty_urls' LIMIT 1	1	1	0

Query Explain:

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

cmsms

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `cms_content`	28	28	1
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
SHOW FULL COLUMNS FROM `cms_htmlblobs`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `cms_content_props`	9	9	1	maybe slow
SELECT `CmsContent`.`content_id`, `CmsContent`.`content_alias`, `CmsContent`.`menu_text`, `CmsContent`.`item_order`, `CmsContent`.`type` FROM `cms_content` AS `CmsContent` WHERE `parent_id` = 1 AND `show_in_menu` = 1 AND `active` = 1 ORDER BY `item_order` ASC	0	0	0

Query Explain:

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

====

Timer

+ –

Memory

Peak Memory Use 12.32 MB

Message	Memory use
Component intitailization	8.36 MB
Controller action start	8.75 MB
Controller render start	9.27 MB
View render complete	11.53 MB

Timers

Total Request Time: 1054 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	147.44
Component initialization and startup	20.80
Controller action	90.02
Render Controller Action	652.76
» Rendering View	651.37
» » Rendering APP/views/themed/default/client/index.ctp	638.18
» » » Rendering APP/views/themed/default/elements/index_productlist.ctp	615.92
» » » » Rendering APP/views/themed/default/elements/all_paginator_end.ctp	0.36
» » Rendering APP/views/themed/default/layouts/client.ctp	12.79
» » » Rendering APP/views/themed/default/elements/all_cart.ctp	0.32

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- title_for_layoutÖljynsuodattimet
- products
  0
  Product
  id268
  nameELEMENT, OIL CLEANER
  desc
  number1J7134411000
  price10.90
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock0
  group
  price_discount0.00
  created2011-03-25 14:01:26
  updated2018-12-11 02:15:08
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short
  name_custom_short_eng
  name_custom_short_swe
  image_text
  group_product0
  price_custom0.00
  delivery_time
  delivery_time_nostock
  delivery_time_eng
  delivery_time_nostock_eng
  delivery_time_swe
  delivery_time_nostock_swe
  AttachmentGroup
  id4
  name(null)
  desc(null)
  date_added(null)
  product_id268
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id8
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace64e2ef08/
  attachment_group_id4
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  1
  Product
  id271
  nameELEMENT, OIL CLEANER
  desc
  number1L9134411100
  price10.90
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock4
  group
  price_discount0.00
  created2011-03-25 14:01:26
  updated2018-12-11 02:15:09
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id10
  name(null)
  desc(null)
  date_added(null)
  product_id271
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id9
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace667beefa/
  attachment_group_id10
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  2
  Product
  id588
  nameELEMENT, OIL CLEANER
  desc
  number36Y134410000
  price10.90
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock-1
  group
  price_discount0.00
  created2011-03-25 14:01:27
  updated2018-12-11 02:15:21
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id11
  name(null)
  desc(null)
  date_added(null)
  product_id588
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id10
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace682500fb/
  attachment_group_id11
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  3
  Product
  id739
  nameELEMENT ASSY, OIL CLEANER
  desc
  number4X7134409000
  price10.90
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock5
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:26
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id12
  name(null)
  desc(null)
  date_added(null)
  product_id739
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id11
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace72d981b9/
  attachment_group_id12
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  4
  Product
  id857
  nameELEMENT ASSY, OIL CLEANER
  desc
  number5D3134400000
  price17.00
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock0
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:31
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id13
  name(null)
  desc(null)
  date_added(null)
  product_id857
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id12
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace7426c29c/
  attachment_group_id13
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  5
  Product
  id862
  nameELEMENT ASSY, OIL CLEANER
  desc
  number5DM134400000
  price16.30
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock9
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:31
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id14
  name(null)
  desc(null)
  date_added(null)
  product_id862
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id13
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace77d2d874/
  attachment_group_id14
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  6
  Product
  id882
  nameELEMENT ASSY, OIL CLEANER
  desc
  number5GH134400000
  price13.89
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock0
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:32
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id15
  name(null)
  desc(null)
  date_added(null)
  product_id882
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id14
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace792de249/
  attachment_group_id15
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  7
  Product
  id883
  nameELEMENT ASSY, OIL CLEANER
  desc
  number5GH134402000
  price14.67
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock0
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:32
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id16
  name(null)
  desc(null)
  date_added(null)
  product_id883
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id15
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace7e079bbf/
  attachment_group_id16
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  8
  Product
  id884
  nameOIL CLEANER ASSY
  desc
  number5H0134400900
  price10.90
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock2
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:32
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id17
  name(null)
  desc(null)
  date_added(null)
  product_id884
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id16
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace7fb19dde/
  attachment_group_id17
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  9
  Product
  id887
  nameELEMENT ASSY, OIL CLEANER
  desc
  number5JW134400000
  price17.57
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock1
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:32
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id18
  name(null)
  desc(null)
  date_added(null)
  product_id887
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id17
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace81c8c2c9/
  attachment_group_id18
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  10
  Product
  id890
  nameELEMENT ASSY, OIL CLEANER
  desc
  number5JX134400000
  price10.90
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock4
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:32
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id19
  name(null)
  desc(null)
  date_added(null)
  product_id890
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id18
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace83671de0/
  attachment_group_id19
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  11
  Product
  id923
  nameELEMENT ASSY, OIL CLEANER
  desc
  number5YPE34400000
  price10.90
  discount_code40
  name_custom
  number_long
  desc_imported
  supplier_number222
  tax24.00
  active1
  stock10
  group
  price_discount0.00
  created2011-03-25 14:01:28
  updated2018-12-11 02:15:33
  weight0
  name_custom_eng
  name_custom_swe
  desc_eng
  desc_swe
  show_price1
  seo_product_title(null)
  seo_product_link(null)
  seo_product_meta_desc(null)
  seo_product_meta_keywords(null)
  name_custom_short(null)
  name_custom_short_eng(null)
  name_custom_short_swe(null)
  image_text(null)
  group_product0
  price_custom0.00
  delivery_time(null)
  delivery_time_nostock(null)
  delivery_time_eng(null)
  delivery_time_nostock_eng(null)
  delivery_time_swe(null)
  delivery_time_nostock_swe(null)
  AttachmentGroup
  id20
  name(null)
  desc(null)
  date_added(null)
  product_id923
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id19
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace84a8f23b/
  attachment_group_id20
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
- children(empty)
- showthese
  049
  250
  351
  454
  553
  655
  756
  857
  958
  1059
  1160
  1261
  1362
  1463
- current49
- firstcategory49
- category_nameÖljynsuodattimet
- breadcrumbs
  0
  nameÖljynsuodattimet
  id49
- packages(empty)
- specials(empty)
- category
  Category
  id49
  nameÖljynsuodattimet
  desc
  image(null)
  tree0
  active1
  parent_id(null)
  lft1
  rght2
  futur_group
  name_eng
  name_swe
  desc_eng
  desc_swe
  pagetitle
  pagetitle_swe
  pagetitle_eng
  seo_url(null)
  discount(null)
  group(null)
  AttachmentGroup
  id22
  name(null)
  desc(null)
  date_added(null)
  product_id(null)
  category_id49
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Package(empty)
  Product(empty)
  Category
  id49
  nameÖljynsuodattimet
  desc
  image(null)
  tree0
  active1
  parent_id(null)
  lft1
  rght2
  futur_group
  name_eng
  name_swe
  desc_eng
  desc_swe
  pagetitle
  pagetitle_swe
  pagetitle_eng
  seo_url(null)
  discount(null)
  group(null)
  Subcategory(empty)
  Attachment
  0
  id21
  nameLJYNSUODATIN.jpg
  version(null)
  desc(null)
  filenameLJYNSUODATIN.jpg
  mime_typeimage/pjpeg
  file_size73.7666015625
  subdirdocuments/50ace8884ea95/
  attachment_group_id22
  created0000-00-00 00:00:00
  product_image(null)
  admin_only(null)
  Video(empty)
- categories
  49Öljynsuodattimet
  50Kypärät
  51Ajopuvut
  52_Miehille
  54Ajovarusteet muut
  53Mönkijän lisävarusteet
  55MP ja Mopon renkaat
  56MOPON LISÄVARUSTEET
  57CUSTOM LISÄVARUSTEET
  58AKUT JA AKKULATURIT
  59ATV JA KELKAN VARAOSAT
  60MOOTTORIPYÖRÄN VARAOSAT
  61MOPON VARAOSAT
  62ILMANSUODATTIMET
  63GENERAATTORIT JA LUMILINGOT
- langfin
- is_logged_in(false)
- showlog0
- is_company(false)
- is_admin(false)
- is_superadmin(false)
- delivery_allow_bill0
- allows(empty)
- settings
  system_emailvaraosat@autotalosavusalo.fi
  mail_server_loginapikey
  mail_server_urlsmtp.sendgrid.net
  mail_server_port587
  mail_server_passwordSG.ozINA7G-RmOmfsPOVARnCQ.5PM8IuPYdO_VeKOAdQAY6OCGrOiEc4-R3Unu-7moqQo
  session_timeout
  mail_signup0
  mail_checkout_order1
  merchant_id13802
  merchant_keyVa5CBZviWdheS3HYNF7nXz6mE9GRxr
  ecommerce_nameAutotalo Savusalo
  image_root/srv/autotalosavusalo.fi/public/kuva-data/
  image_root_httphttps://www.autotalosavusalo.fi/kuva-data/
  futur_use_stock1
  futur_use_price1
  futur_url
  futur_port13000
  csv_location/srv/autotalosavusalo.fi/csv/products.csv
  cms_pretty_urls0
  cms_roothttps://www.autotalosavusalo.fi/
  clicky_site_id
  clicky_site_key
  clicky_use_tracking0
  memo
  cm_api_key
  cm_client_id
  track_added_customers0
  allow_purchase_loggedout1
  allow_purchase_loggedin1
  merchant_test_mode1
  offer_default_text<p>Omistusoikeus tavaraan siirtyy myyjältä ostajalle, kun kauppahinta on kokonaisuudessaan maksettu.</p>
  order_default_text
  cm_use_lists1
  image_extensionjpg
  image_use_supplier1
  image_name_fieldnumber
  offer_request_default_text
  email_ordervaraosat@autotalosavusalo.fi
  email_offervaraosat@autotalosavusalo.fi
  email_customersvaraosat@autotalosavusalo.fi
  mail_checkout_offer0
  use_futur1
  language_finnish1
  language_english1
  language_swedish1
  seo_urls0
  imports_today06.12.2011/1
  use_filter_price0
  use_filter_category0
  client_themedefault
  test_emailinfo@trimedia.fi
  use_custom_product_price1
  allow_offer_unknown0
  allow_offer_admin0
  delivery_allow_bill_loggedout1
  delivery_allow_bill_loggedin1
  allow_offer_customer0
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0jqueryEngine
  1js
  2paginator
  3simpleGraph
  4htmlToolbar
  5toolbar
  6image
  7time
  8productblock
  9mime2icon
  10ajax
  11cms
  12cache
  13html
  14form
  15seolink
  16tree
  17session
  18number
  19javascript
====

Ostoskori

Öljynsuodattimet

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

cmsms

Query Explain:

Memory

Timers

Logs

View Variables