Products

21-40 of 41 products

Name	Quantity	Price	Unit price	Actions
Flashing Star Wand	Box of 48	£81.60	£1.70	View
Fluffy Devil Horn	Box of 36	£64.80	£1.80	View
Fluffy Wand	Box of 48	£67.20	£1.40	View
Fundraiser - Festival Pack	Multibox of 1	£175.00	£175.00	View
Fundraiser - Glow Pack	Multibox of 1	£120.00	£120.00	View
Galaxy Ball Fibre-Optic Torch	Box of 48	£67.20	£1.40	View
Galaxy Ball Laser Sword - Large	Box of 24	£48.00	£2.00	View
Galaxy Ball Torch - Large	Box of 24	£38.40	£1.60	View
Galaxy Ball Torch - Mini	Box of 50	£62.50	£1.25	View
Glow Glasses	Box of 40	£26.00	£0.65	View
Heart Tunnel Light Torch	Box of 36	£45.00	£1.25	View
Laser Rings	Box of 4	£1.80	£0.45	View
Laser Space Sword	Box of 36	£90.00	£2.50	View
Laser Space Sword - Multi	Box of 48	£88.00	£1.85	View
Laser Sword - Multi Colour	Box of 24	£44.40	£1.85	View
LED Balloon Light	Box of 20	£14.80	£0.74	View
Metallic LED Flashing Gloves	Box of 25	£68.75	£2.75	View
Mohawk Headboppers	Box of 48	£108.00	£2.25	View
Motion Colour Changing Sword	Box of 48	£127.20	£2.65	View
Neon Face & Body Paint	Box of 12	£21.48	£1.79	View

<< previous 1 | 2 | 3 next >>

History
Request History
4 previous requests available
Session
Session
- Config
  - userAgent0d335cdef5656d1bd1ddd24a426107e1
  - time1337573507
  - 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
  - page2
  - sortname
  - directionasc
- controllerproducts
- actionindex
- plugin(null)
- form(empty)
- url
  - urlproducts/index/page:2/sort:name/direction:asc
- paging
  - Product
    page2
    current20
    count41
    prevPage(true)
    nextPage(true)
    pageCount3
    defaults
    limit20
    step1
    order
    Product.nameASC
    conditions(empty)
    options
    page2
    limit20
    order
    Product.nameasc
    conditions(empty)
$_GET
- urlproducts/index/page: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 Log

Sql Logs

default

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `products`	11	11	4
2	DESCRIBE `types`	6	6	3
3	DESCRIBE `categories`	4	4	10
4	DESCRIBE `categories_products`	2	2	15
5	SELECT COUNT(*) AS `count` FROM `products` AS `Product` WHERE 1 = 1	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` FROM `products` AS `Product` WHERE 1 = 1 ORDER BY `Product`.`name` asc LIMIT 20, 20	20	20	1

toggle (1) query explains for default

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra	query
1	SIMPLE	Product	ALL					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` FROM `products` AS `Product` WHERE 1 = 1 ORDER BY `Product`.`name` asc LIMIT 20, 20

Timer

Memory

Current Memory Use 10.78 MB

Peak Memory Use 10.86 MB

Timers

Total Request Time: 0.976534 (seconds)

Message	Time in seconds	Graph
Component initialization and startup	0.012350
Controller Action	0.009020
Render Controller Action	0.185900
Rendering View	0.185580
Rendering APP/views/products/index.ctp	0.173290
Rendering APP/views/layouts/default.ctp	0.011880
Rendering APP/views/elements/account.ctp	0.001180
Rendering APP/views/elements/search.ctp	0.002860
Rendering APP/views/elements/navigation.ctp	0.003530
Rendering APP/views/elements/basket.ctp	0.000670
Rendering APP/views/elements/bubbles.ctp	0.000500

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
    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
  - 1
    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
  - 2
    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
  - 3
    Product
    id92
    nameFundraiser - Festival Pack
    quantity1
    casesize1
    packageMultibox
    price175.00
    unitprice175.00
    rrp396.00
    imagefundraiserfestivalpack.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 4
    Product
    id68
    nameFundraiser - Glow Pack
    quantity1
    casesize1
    packageMultibox
    price120.00
    unitprice120.00
    rrp470.00
    imagefundraiserglowpack.png
    created2009-07-16 12:38:38
    modified2009-07-16 12:38:38
  - 5
    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
  - 6
    Product
    id89
    nameGalaxy Ball Laser Sword - Large
    quantity24
    casesize48
    packageBox
    price48.00
    unitprice2.00
    rrp5.00
    imagegalaxyballlasersword-large.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 7
    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
  - 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
  - 9
    Product
    id115
    nameGlow Glasses
    quantity40
    casesize400
    packageBox
    price26.00
    unitprice0.65
    rrp1.50
    imageglowglasses.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 10
    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
  - 11
    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
  - 12
    Product
    id99
    nameLaser Space Sword
    quantity36
    casesize72
    packageBox
    price90.00
    unitprice2.50
    rrp5.00
    imagelaserspacesword.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 13
    Product
    id91
    nameLaser Space Sword - Multi
    quantity48
    casesize96
    packageBox
    price88.00
    unitprice1.85
    rrp4.00
    imagelaserspacesword-multi.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 14
    Product
    id98
    nameLaser Sword - Multi Colour
    quantity24
    casesize96
    packageBox
    price44.40
    unitprice1.85
    rrp4.00
    imagelasersword.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 15
    Product
    id108
    nameLED Balloon Light
    quantity20
    casesize100
    packageBox
    price14.80
    unitprice0.74
    rrp1.50
    imageledballoonlight.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 16
    Product
    id111
    nameMetallic LED Flashing Gloves
    quantity25
    casesize100
    packageBox
    price68.75
    unitprice2.75
    rrp5.00
    imagemetallicledflashinggloves.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 17
    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
  - 18
    Product
    id90
    nameMotion Colour Changing Sword
    quantity48
    casesize96
    packageBox
    price127.20
    unitprice2.65
    rrp5.00
    imagemotioncolourchangingsword.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 19
    Product
    id112
    nameNeon Face & Body Paint
    quantity12
    casesize48
    packageBox
    price21.48
    unitprice1.79
    rrp3.00
    imageneonfaceandbodypaint.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
- $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