CUSTOM LISÄVARUSTEET

Autotalo Savusalo
CUSTOM LISÄVARUSTEET

CUSTOM LISÄVARUSTEET

HIGHWAY HAWK JALKATAPPI PARI TECH GLIDE E.

Tuotekoodi : 561-73-496 | Varastotilanne:

60.00 € 48.39 € alv. 0% €

HIGHWAY HAWK JALKATAPPIEN JATKOT MATKUSTAJALLE E.

Tuotekoodi : 561-732-0500 | Varastotilanne:

60.00 € 48.39 € alv. 0% €

ALUTUPET H-D SPORTSTER

Tuotekoodi : MAP-HDM1031G8/1 | Varastotilanne:

60.00 € 48.39 € alv. 0% €

HIGHWAY LEPUUTUSTAPIT PRT-011 KULMIKAS

Tuotekoodi : PRT-011 | Varastotilanne:

36.00 € 29.03 € alv. 0% €

FOOTREST CUSTOM

Tuotekoodi : PRT-012 | Varastotilanne:

44.00 € 35.48 € alv. 0% €

HIGHWAY HAWK HANDGRIPS COMFORT 25MM E.

Tuotekoodi : 561-45-0112 | Varastotilanne:

39.62 € 31.95 € alv. 0% €

History
+ –

Request History

No previous requests logged.

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

Cake Params
- controllerclient
- actionindex
- named(empty)
- pass
  057
- plugin(null)
- form(empty)
- url
  urlclient/index/57/
- paging
  Product
  page1
  current6
  count6
  prevPage(false)
  nextPage(false)
  pageCount1
  defaults
  limit20
  step1
  conditions
  Product.id
  04527
  14892
  24896
  34895
  44971
  54994
  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
  04527
  14892
  24896
  34895
  44971
  54994
  Product.active1
  not
  and
  Product.price0
  Product.price_custom0
  Product.price_discount0
  not
  Product.group_product1
  contain
  0AttachmentGroup.Attachment
$_GET
- urlclient/index/57/
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	7
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	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_aros_acos`	7	7	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_products`	39	39	22	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	7	maybe slow
SHOW FULL COLUMNS FROM `automatik_packages`	6	6	6
SHOW FULL COLUMNS FROM `automatik_packages_products`	5	5	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_categories`	20	20	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_videos`	5	5	12	maybe slow
SHOW FULL COLUMNS FROM `automatik_subcategories`	7	7	9	maybe slow
SHOW FULL COLUMNS FROM `automatik_products_categories`	7	7	13	maybe slow
SHOW FULL COLUMNS FROM `automatik_attachments`	12	12	8	maybe slow
SHOW FULL COLUMNS FROM `automatik_settings`	8	8	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_specials`	4	4	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_orders`	28	28	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_order_items`	16	16	7	maybe slow
SHOW FULL COLUMNS FROM `automatik_users`	27	27	8	maybe slow
SHOW FULL COLUMNS FROM `automatik_groups`	5	5	5
SHOW FULL COLUMNS FROM `automatik_delivery_methods`	14	14	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_offers`	38	38	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_offer_items`	15	15	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_cart_progress`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `automatik_products_products`	5	5	6	maybe slow
SHOW FULL COLUMNS FROM `automatik_event_log`	7	7	10	maybe slow
SHOW FULL COLUMNS FROM `automatik_bookmarks`	7	7	7
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	3	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`.`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` = 57 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` = 57	0	0	1	maybe slow
SELECT `Video`.`id`, `Video`.`name`, `Video`.`ident`, `Video`.`product_id`, `Video`.`category_id` FROM `automatik_videos` AS `Video` WHERE `Video`.`category_id` = (57)	0	0	1	maybe slow
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` = '57' 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` = 57 ORDER BY `Package`.`category_id` ASC, `Package`.`index` ASC	0	0	7	maybe slow
SELECT `Category`.`lft`, `Category`.`rght` FROM `automatik_categories` AS `Category` WHERE `Category`.`id` = 57 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` <= 17 AND `Category`.`rght` >= 18 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`, `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` = 57 AND `Category`.`active` = '1'	0	0	1	maybe slow
SELECT `Category`.`lft`, `Category`.`rght` FROM `automatik_categories` AS `Category` WHERE `Category`.`id` = 57 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` <= 17 AND `Category`.`rght` >= 18 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` = 57 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` = 57 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` = 57 AND `subcategory_id` IS NULL	6	6	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 (4527, 4892, 4896, 4895, 4971, 4994) 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	1
SHOW FULL COLUMNS FROM `automatik_suppliers`	4	4	7	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 (4527, 4892, 4896, 4895, 4971, 4994) 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	6	6	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` = 4895	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` = (7)	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` = 4896	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` = (8)	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` = 4994	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` = (9)	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` = 4527	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` = (23)	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` = 4892	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` = (24)	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` = 4971	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` = (25)	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` = '121' 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` = '121' 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` = '278' 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` = '271' 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` = '271' 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` = '121' LIMIT 1	0	0	1	maybe slow
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 (4527, 4892, 4896, 4895, 4971, 4994)	0	0	1	maybe slow
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	1

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	12	maybe slow
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	6	maybe slow
SHOW FULL COLUMNS FROM `cms_content_props`	9	9	7	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	1	maybe slow

Query Explain:

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

====

Timer

+ –

Memory

Peak Memory Use 11.98 MB

Message	Memory use
Component intitailization	8.36 MB
Controller action start	8.75 MB
Controller render start	9.14 MB
View render complete	11.39 MB

Timers

Total Request Time: 1383 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	449.83
Component initialization and startup	68.55
Controller action	95.39
Render Controller Action	572.21
» Rendering View	567.91
» » Rendering APP/views/themed/default/client/index.ctp	538.61
» » » Rendering APP/views/themed/default/elements/index_productlist.ctp	484.02
» » » » Rendering APP/views/themed/default/elements/all_paginator_end.ctp	0.31
» » Rendering APP/views/themed/default/layouts/client.ctp	28.48
» » » Rendering APP/views/themed/default/elements/all_cart.ctp	0.46

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- title_for_layoutCUSTOM LISÄVARUSTEET
- products
  0
  Product
  id4895
  nameHIGHWAY HAWK JALKATAPPI PARI TECH GLIDE E.
  desc
  number561-73-496
  price75.21
  discount_code84,68
  name_custom
  number_long
  desc_imported
  supplier_number121
  tax24.00
  active1
  stock1
  groupE.20.210
  price_discount0.00
  created2012-09-19 04:00:52
  updated2020-05-27 02:15:58
  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_custom60.00
  delivery_time
  delivery_time_nostock
  delivery_time_eng
  delivery_time_nostock_eng
  delivery_time_swe
  delivery_time_nostock_swe
  AttachmentGroup
  id7
  name(null)
  desc(null)
  date_added(null)
  product_id4895
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id5
  name561-73-496.jpg
  version(null)
  desc(null)
  filename561-73-496.jpg
  mime_typeimage/jpeg
  file_size84.9873046875
  subdirdocuments/509ce4e3698ef/
  attachment_group_id7
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  1
  Product
  id4896
  nameHIGHWAY HAWK JALKATAPPIEN JATKOT MATKUSTAJALLE E.
  desc
  number561-732-0500
  price80.24
  discount_code84,68
  name_custom
  number_long
  desc_imported
  supplier_number121
  tax24.00
  active1
  stock1
  groupE.20.210
  price_discount0.00
  created2012-09-19 04:00:52
  updated2020-05-27 02:15:58
  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_custom60.00
  delivery_time
  delivery_time_nostock
  delivery_time_eng
  delivery_time_nostock_eng
  delivery_time_swe
  delivery_time_nostock_swe
  AttachmentGroup
  id8
  name(null)
  desc(null)
  date_added(null)
  product_id4896
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id6
  name561-732-0500.jpg
  version(null)
  desc(null)
  filename561-732-0500.jpg
  mime_typeimage/jpeg
  file_size94.9140625
  subdirdocuments/509cec2ae1ec7/
  attachment_group_id8
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  2
  Product
  id4994
  nameALUTUPET H-D SPORTSTER
  desc
  numberMAP-HDM1031G8/1
  price74.60
  discount_code
  name_custom
  number_long
  desc_imported
  supplier_number278
  tax24.00
  active1
  stock1
  group
  price_discount0.00
  created2012-10-04 04:01:05
  updated2020-05-27 02:16:47
  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_custom60.00
  delivery_time
  delivery_time_nostock
  delivery_time_eng
  delivery_time_nostock_eng
  delivery_time_swe
  delivery_time_nostock_swe
  AttachmentGroup
  id9
  name(null)
  desc(null)
  date_added(null)
  product_id4994
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id7
  nameMAP-HDM1031G8-1.jpg
  version(null)
  desc(null)
  filenameMAP-HDM1031G8-1.jpg
  mime_typeimage/jpeg
  file_size99.373046875
  subdirdocuments/509cec74ecff8/
  attachment_group_id9
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  3
  Product
  id4527
  nameFOOTREST HIGHWAY
  desc
  numberPRT-011
  price36.00
  discount_codeDICE4000
  name_customHIGHWAY LEPUUTUSTAPIT PRT-011 KULMIKAS
  number_long
  desc_imported
  supplier_number271
  tax24.00
  active1
  stock1
  group27016
  price_discount0.00
  created2012-04-13 04:01:06
  updated2020-05-27 02:16:54
  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
  id23
  name(null)
  desc(null)
  date_added(null)
  product_id4527
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id22
  name21112012(002).jpg
  version(null)
  desc(null)
  filename21112012002.jpg
  mime_typeimage/pjpeg
  file_size82.119140625
  subdirdocuments/50acea43d47b4/
  attachment_group_id23
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  4
  Product
  id4892
  nameFOOTREST CUSTOM
  desc
  numberPRT-012
  price44.00
  discount_codeDICE4000
  name_custom
  number_long
  desc_imported
  supplier_number271
  tax24.00
  active1
  stock0
  group27016
  price_discount0.00
  created2012-09-18 04:00:59
  updated2020-05-27 02:16:54
  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
  id24
  name(null)
  desc(null)
  date_added(null)
  product_id4892
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id23
  name21112012(001).jpg
  version(null)
  desc(null)
  filename21112012001.jpg
  mime_typeimage/pjpeg
  file_size92.2373046875
  subdirdocuments/50acea5b5590c/
  attachment_group_id24
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
  5
  Product
  id4971
  nameHIGHWAY HAWK HANDGRIPS COMFORT 25MM E.
  desc
  number561-45-0112
  price39.62
  discount_code44,35
  name_custom
  number_long
  desc_imported
  supplier_number121
  tax24.00
  active1
  stock1
  groupE.20.210
  price_discount0.00
  created2012-09-28 04:00:27
  updated2020-05-27 02:15:58
  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
  id25
  name(null)
  desc(null)
  date_added(null)
  product_id4971
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(null)
  Attachment
  0
  id24
  name21112012.jpg
  version(null)
  desc(null)
  filename21112012.jpg
  mime_typeimage/pjpeg
  file_size92.8837890625
  subdirdocuments/50acea79a4932/
  attachment_group_id25
  created0000-00-00 00:00:00
  product_image1
  admin_only0
  Supplier(false)
- children(empty)
- showthese
  057
  149
  250
  351
  454
  553
  655
  756
  958
  1059
  1160
  1261
  1362
  1463
- current57
- firstcategory57
- category_nameCUSTOM LISÄVARUSTEET
- breadcrumbs
  0
  nameCUSTOM LISÄVARUSTEET
  id57
- packages(empty)
- specials(empty)
- category
  Category
  id57
  nameCUSTOM LISÄVARUSTEET
  desc
  image(null)
  tree0
  active1
  parent_id(null)
  lft17
  rght18
  futur_group(null)
  name_eng
  name_swe
  desc_eng
  desc_swe
  pagetitle
  pagetitle_swe
  pagetitle_eng
  seo_url(null)
  discount(null)
  group(null)
  AttachmentGroup
  id(null)
  name(null)
  desc(null)
  date_added(null)
  product_id(null)
  category_id(null)
  package_id(null)
  subcategory_id(null)
  supplier_id(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
====

Autotalo Savusalo

Ostoskori