Products

Currently browsing category: Torches & Wands

1-10 of 10 products

Name	Quantity	Price	Unit price	Actions
Galaxy Ball Torch - Large	Box of 24	£38.40	£1.60	View
Double Galaxy Ball Baton	Box of 24	£47.76	£1.99	View
Chrome Space Baton	Box of 25	£61.25	£2.45	View
Heart Tunnel Light Torch	Box of 36	£45.00	£1.25	View
Butterfly Wand	Box of 36	£81.00	£2.25	View
Flashing Star Wand	Box of 48	£81.60	£1.70	View
Fluffy Wand	Box of 48	£67.20	£1.40	View
Galaxy Ball Fibre-Optic Torch	Box of 48	£67.20	£1.40	View
Galaxy Ball Torch - Mini	Box of 50	£62.50	£1.25	View
Butterfly Fibre Optic Torch	Box of 96	£120.00	£1.25	View

History
Request History
4 previous requests available
Session
Session
- Config
  - userAgent0d335cdef5656d1bd1ddd24a426107e1
  - time1328568522
  - 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
  - category5
  - sortquantity
  - directionasc
- controllerproducts
- actionindex
- plugin(null)
- form(empty)
- url
  - urlproducts/index/page:1/category:5/sort:quantity/direction:asc
- paging
  - Product
    page1
    current10
    count10
    prevPage(false)
    nextPage(false)
    pageCount1
    defaults
    limit20
    step1
    order
    Product.nameASC
    conditions(empty)
    options
    page1
    limit20
    order
    Product.quantityasc
    conditions(empty)
$_GET
- urlproducts/index/page:1/category:5/sort:quantity/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	4
2	DESCRIBE `types`	6	6	4
3	DESCRIBE `categories`	4	4	4
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` = 5	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` = 5 ORDER BY `Product`.`quantity` asc LIMIT 20	10	10	0
7	SELECT `Type`.`id`, `Type`.`product_id`, `Type`.`code`, `Type`.`description`, `Type`.`created`, `Type`.`modified` FROM `types` AS `Type` WHERE `Type`.`product_id` IN (77, 73, 72, 37, 38, 34, 76, 94, 78, 70)	10	10	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 (77, 73, 72, 37, 38, 34, 76, 94, 78, 70) AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE 1 = 1	10	10	0

Warning No slow queries!, or your database does not support EXPLAIN

Timer

Memory

Current Memory Use 10.80 MB

Peak Memory Use 10.88 MB

Timers

Total Request Time: 1.374122 (seconds)

Message	Time in seconds	Graph
Component initialization and startup	0.023740
Controller Action	0.018920
Render Controller Action	0.083460
Rendering View	0.083140
Rendering APP/views/products/index.ctp	0.064230
Rendering APP/views/layouts/default.ctp	0.018440
Rendering APP/views/elements/account.ctp	0.002090
Rendering APP/views/elements/search.ctp	0.004650
Rendering APP/views/elements/navigation.ctp	0.005430
Rendering APP/views/elements/basket.ctp	0.001050
Rendering APP/views/elements/bubbles.ctp	0.000720

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
    id77
    nameGalaxy Ball Torch - Large
    quantity24
    casesize96
    packageBox
    price38.40
    unitprice1.60
    rrp4.00
    imagegalaxyballtorch-large.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id77
    category_id5
    Type
    0
    id12
    product_id77
    codeNOVTOR22
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 1
    Product
    id73
    nameDouble Galaxy Ball Baton
    quantity24
    casesize96
    packageBox
    price47.76
    unitprice1.99
    rrp4.00
    imagedoublegalaxyballbaton.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id73
    category_id5
    Type
    0
    id7
    product_id73
    codeNOVBAT01
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 2
    Product
    id72
    nameChrome Space Baton
    quantity25
    casesize50
    packageBox
    price61.25
    unitprice2.45
    rrp6.00
    imagechromespacebaton.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id72
    category_id5
    Type
    0
    id6
    product_id72
    codeNOVBAT09
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 3
    Product
    id37
    nameHeart Tunnel Light Torch
    quantity36
    casesize144
    packageBox
    price45.00
    unitprice1.25
    rrp3.00
    imagehearttunnellighttorch.png
    created0000-00-00 00:00:00
    modified2009-04-23 16:33:26
    CategoriesProduct
    product_id37
    category_id5
    Type
    0
    id14
    product_id37
    codeNOVTOR23
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 4
    Product
    id38
    nameButterfly Wand
    quantity36
    casesize72
    packageBox
    price81.00
    unitprice2.25
    rrp5.00
    imagebutterflywand.png
    created0000-00-00 00:00:00
    modified2009-04-23 16:33:52
    CategoriesProduct
    product_id38
    category_id5
    Type
    0
    id2
    product_id38
    codeNOVTOR13
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 5
    Product
    id34
    nameFlashing Star Wand
    quantity48
    casesize96
    packageBox
    price81.60
    unitprice1.70
    rrp4.00
    imageflashingstarwand.png
    created0000-00-00 00:00:00
    modified2009-04-23 16:30:43
    CategoriesProduct
    product_id34
    category_id5
    Type
    0
    id9
    product_id34
    codeNOVSTAR00
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 6
    Product
    id76
    nameFluffy Wand
    quantity48
    casesize192
    packageBox
    price67.20
    unitprice1.40
    rrp3.00
    imagefluffywand.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id76
    category_id5
    Type
    0
    id10
    product_id76
    codeNOVTOR04
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 7
    Product
    id94
    nameGalaxy Ball Fibre-Optic Torch
    quantity48
    casesize144
    packageBox
    price67.20
    unitprice1.40
    rrp3.00
    imagegalaxyballfibreoptictorch.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id94
    category_id5
    Type
    0
    id11
    product_id94
    codeNOVTOR43
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 8
    Product
    id78
    nameGalaxy Ball Torch - Mini
    quantity50
    casesize100
    packageBox
    price62.50
    unitprice1.25
    rrp3.00
    imagegalaxyballtorch-mini.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id78
    category_id5
    Type
    0
    id13
    product_id78
    codeNOVTOR21
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25:34
  - 9
    Product
    id70
    nameButterfly Fibre Optic Torch
    quantity96
    casesize192
    packageBox
    price120.00
    unitprice1.25
    rrp3.00
    imagebutterflyfibreoptictorch.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id70
    category_id5
    Type
    0
    id3
    product_id70
    codeNOVTOR26
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id5
    nameTorches & Wands
    created2009-04-23 09:54:01
    modified2009-04-23 15:25: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