Products

Products

Currently browsing category: Jewellery

1-2 of 2 products

Image	Name	Quantity	Price	Unit price	Actions
	Laser Rings	Box of 4	£1.80	£0.45	View
	Starfish Jelly Pendant	Box of 24	£15.60	£0.65	View

History
Request History
4 previous requests available
Session
Session
- Config
  - userAgent0d335cdef5656d1bd1ddd24a426107e1
  - time1328567816
  - timeout10
- Message
  - auth
    messageYou are not authorized to access that location.
    layoutdefault
    params(empty)
- Auth
  - redirect/order_contents/view
Request
Request

Cake Params
- pass(empty)
- named
  - page1
  - category2
  - sortname
  - directionasc
- controllerproducts
- actionindex
- plugin(null)
- form(empty)
- url
  - urlproducts/index/page:1/category:2/sort:name/direction:asc
- paging
  - Product
    page1
    current2
    count2
    prevPage(false)
    nextPage(false)
    pageCount1
    defaults
    limit20
    step1
    order
    Product.nameASC
    conditions(empty)
    options
    page1
    limit20
    order
    Product.nameasc
    conditions(empty)
$_GET
- urlproducts/index/page:1/category:2/sort:name/direction:asc
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- 0/:controller/:action/*
- 1#^(?:/([^\/]+))?(?:/([^\/]+))?(?:/(.*))?[\/]*$#
- 2
  - 0controller
  - 1action
- 3
  - plugin(null)
  - controller(null)
  - actionindex
- 4(empty)

Sql Logs

default

Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `products`		11	11	5
2	DESCRIBE `types`		6	6	4
3	DESCRIBE `categories`		4	4	3
4	DESCRIBE `categories_products`		2	2	3
5	SELECT COUNT(*) AS `count` FROM `products` AS `Product` LEFT JOIN `categories_products` AS `CategoriesProduct` ON (`Product`.`id` = `CategoriesProduct`.`product_id`) WHERE `CategoriesProduct`.`category_id` = 2		1	1	0
6	SELECT `Product`.`id`, `Product`.`name`, `Product`.`quantity`, `Product`.`casesize`, `Product`.`package`, `Product`.`price`, `Product`.`unitprice`, `Product`.`rrp`, `Product`.`image`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `products` AS `Product` LEFT JOIN `categories_products` AS `CategoriesProduct` ON (`Product`.`id` = `CategoriesProduct`.`product_id`) WHERE `CategoriesProduct`.`category_id` = 2 ORDER BY `Product`.`name` asc LIMIT 20		2	2	1
7	SELECT `Type`.`id`, `Type`.`product_id`, `Type`.`code`, `Type`.`description`, `Type`.`created`, `Type`.`modified` FROM `types` AS `Type` WHERE `Type`.`product_id` IN (113, 114)		2	2	0
8	SELECT `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories` AS `Category` JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` IN (113, 114) AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE 1 = 1		2	2	0

toggle (1) query explains for default

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra	query
1	SIMPLE	Product	ALL	PRIMARY				41	Using filesort	SELECT `Product`.`id`, `Product`.`name`, `Product`.`quantity`, `Product`.`casesize`, `Product`.`package`, `Product`.`price`, `Product`.`unitprice`, `Product`.`rrp`, `Product`.`image`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `products` AS `Product` LEFT JOIN `categories_products` AS `CategoriesProduct` ON (`Product`.`id` = `CategoriesProduct`.`product_id`) WHERE `CategoriesProduct`.`category_id` = 2 ORDER BY `Product`.`name` asc LIMIT 20

Memory

Current Memory Use 10.76 MB

Peak Memory Use 10.84 MB

Timers

Total Request Time: 1.054242 (seconds)

Message	Time in seconds	Graph
Component initialization and startup	0.026570
Controller Action	0.024500
Render Controller Action	0.060490
Rendering View	0.059890
Rendering APP/views/products/index.ctp	0.041550
Rendering APP/views/layouts/default.ctp	0.017690
Rendering APP/views/elements/account.ctp	0.002250
Rendering APP/views/elements/search.ctp	0.004800
Rendering APP/views/elements/navigation.ctp	0.003860
Rendering APP/views/elements/basket.ctp	0.001010
Rendering APP/views/elements/bubbles.ctp	0.000920

Log

Logs

error.log

There were no log entries made this request

debug.log

There were no log entries made this request
Variables
View Variables
- products
  - 0
    Product
    id113
    nameLaser Rings
    quantity4
    casesize500
    packageBox
    price1.80
    unitprice0.45
    rrp1.00
    imagelaserrings.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id113
    category_id2
    Type
    0
    id61
    product_id113
    codeALTRINGLIGHTS
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id2
    nameJewellery
    created2009-04-23 09:53:20
    modified2009-04-23 15:23:11
  - 1
    Product
    id114
    nameStarfish Jelly Pendant
    quantity24
    casesize576
    packageBox
    price15.60
    unitprice0.65
    rrp2.00
    imagestarfishjellypendant.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id114
    category_id2
    Type
    0
    id62
    product_id114
    codeNOVPEN03
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id2
    nameJewellery
    created2009-04-23 09:53:20
    modified2009-04-23 15:23:11
- $this->data(null)
- $this->validationErrors(empty)