Products

Currently browsing category: Headwear

1-7 of 7 products

Name	Quantity	Price	Unit price	Actions
Fibre Optic Hair Clip	Box of 12	£11.88	£0.99	View
Flashing Chrome Bunny Ears	Box of 48	£76.80	£1.60	View
Flashing Devil Horns	Box of 12	£21.00	£1.75	View
Fluffy Devil Horn	Box of 36	£64.80	£1.80	View
Butterfly Boppers	Box of 12	£21.60	£1.80	View
Mohawk Headboppers	Box of 48	£108.00	£2.25	View
Flashing Dreadlocks	Box of 30	£74.70	£2.49	View

History
Request History
4 previous requests available
Session
Session
- Config
  - userAgent0d335cdef5656d1bd1ddd24a426107e1
  - time1328568683
  - 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
  - category3
  - sortunitprice
  - directionasc
- controllerproducts
- actionindex
- plugin(null)
- form(empty)
- url
  - urlproducts/index/page:1/category:3/sort:unitprice/direction:asc
- paging
  - Product
    page1
    current7
    count7
    prevPage(false)
    nextPage(false)
    pageCount1
    defaults
    limit20
    step1
    order
    Product.nameASC
    conditions(empty)
    options
    page1
    limit20
    order
    Product.unitpriceasc
    conditions(empty)
$_GET
- urlproducts/index/page:1/category:3/sort:unitprice/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 Log

Sql Logs

default

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `products`	11	11	5
2	DESCRIBE `types`	6	6	6
3	DESCRIBE `categories`	4	4	3
4	DESCRIBE `categories_products`	2	2	6
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` = 3	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` = 3 ORDER BY `Product`.`unitprice` asc LIMIT 20	7	7	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 (107, 104, 80, 106, 102, 105, 81)	11	11	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 (107, 104, 80, 106, 102, 105, 81) AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE 1 = 1	7	7	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` = 3 ORDER BY `Product`.`unitprice` asc LIMIT 20

Timer

Memory

Current Memory Use 10.80 MB

Peak Memory Use 10.88 MB

Timers

Total Request Time: 1.316335 (seconds)

Message	Time in seconds	Graph
Component initialization and startup	0.026800
Controller Action	0.028260
Render Controller Action	0.075820
Rendering View	0.075380
Rendering APP/views/products/index.ctp	0.056900
Rendering APP/views/layouts/default.ctp	0.017900
Rendering APP/views/elements/account.ctp	0.002040
Rendering APP/views/elements/search.ctp	0.004370
Rendering APP/views/elements/navigation.ctp	0.005150
Rendering APP/views/elements/basket.ctp	0.001010
Rendering APP/views/elements/bubbles.ctp	0.000690

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
    id107
    nameFibre Optic Hair Clip
    quantity12
    casesize500
    packageBox
    price11.88
    unitprice0.99
    rrp2.50
    imagefibreoptichairclip.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id107
    category_id3
    Type
    0
    id49
    product_id107
    codeALTHAIRCR
    descriptionRed
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    1
    id48
    product_id107
    codeALTHAIRCG
    descriptionGreen
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    2
    id47
    product_id107
    codeALTHAIRCB
    descriptionBlue
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id3
    nameHeadwear
    created2009-04-23 09:53:32
    modified2009-04-23 15:23:34
  - 1
    Product
    id104
    nameFlashing Chrome Bunny Ears
    quantity48
    casesize96
    packageBox
    price76.80
    unitprice1.60
    rrp4.00
    imageflashingchromebunnyears.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id104
    category_id3
    Type
    0
    id40
    product_id104
    codeNOVHEAD06
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id3
    nameHeadwear
    created2009-04-23 09:53:32
    modified2009-04-23 15:23:34
  - 2
    Product
    id80
    nameFlashing Devil Horns
    quantity12
    casesize144
    packageBox
    price21.00
    unitprice1.75
    rrp4.00
    imageflashingdevilhorns.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id80
    category_id3
    Type
    0
    id42
    product_id80
    codeNOVHEAD11
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id3
    nameHeadwear
    created2009-04-23 09:53:32
    modified2009-04-23 15:23:34
  - 3
    Product
    id106
    nameFluffy Devil Horn
    quantity36
    casesize144
    packageBox
    price64.80
    unitprice1.80
    rrp4.00
    imagefluffydevilhorn.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id106
    category_id3
    Type
    0
    id46
    product_id106
    codeNOVHEAD17
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id3
    nameHeadwear
    created2009-04-23 09:53:32
    modified2009-04-23 15:23:34
  - 4
    Product
    id102
    nameButterfly Boppers
    quantity12
    casesize144
    packageBox
    price21.60
    unitprice1.80
    rrp4.00
    imagebutterflyboppers.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id102
    category_id3
    Type
    0
    id38
    product_id102
    codeNOVHEAD05
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id3
    nameHeadwear
    created2009-04-23 09:53:32
    modified2009-04-23 15:23:34
  - 5
    Product
    id105
    nameMohawk Headboppers
    quantity48
    casesize144
    packageBox
    price108.00
    unitprice2.25
    rrp5.00
    imagemohawkheadboppers.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id105
    category_id3
    Type
    0
    id41
    product_id105
    codeNOVHEAD16
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id3
    nameHeadwear
    created2009-04-23 09:53:32
    modified2009-04-23 15:23:34
  - 6
    Product
    id81
    nameFlashing Dreadlocks
    quantity30
    casesize60
    packageBox
    price74.70
    unitprice2.49
    rrp6.00
    imageflashingdreadlocks.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id81
    category_id3
    Type
    0
    id45
    product_id81
    codeNOVHEAD12
    descriptionMulticoloured
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    1
    id44
    product_id81
    codeNOVHEAD10
    descriptionBlue
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    2
    id43
    product_id81
    codeNOVHEAD07
    descriptionPink
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id3
    nameHeadwear
    created2009-04-23 09:53:32
    modified2009-04-23 15:23:34
- $this->data(null)
- $this->validationErrors(empty)

Products

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Memory

Timers

Logs

error.log

debug.log

View Variables