Products

Currently browsing category: Batons & Swords

1-9 of 9 products

Name	Quantity	Price	Unit price	Actions
9 Function Laser Sword	Box of 24	£44.40	£1.85	View
Cyber Baton	Box of 60	£117.00	£1.95	View
Dale Sword Fibre Optic Baton	Box of 144	£187.20	£1.30	View
Double Ended Sword	Box of 36	£115.20	£3.20	View
Galaxy Ball Laser Sword - Large	Box of 24	£48.00	£2.00	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
Motion Colour Changing Sword	Box of 48	£127.20	£2.65	View

History
Request History
4 previous requests available
Session
Session
- Config
  - userAgent0d335cdef5656d1bd1ddd24a426107e1
  - time1328567956
  - 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
  - category7
  - sortname
  - directionasc
- controllerproducts
- actionindex
- plugin(null)
- form(empty)
- url
  - urlproducts/index/page:1/category:7/sort:name/direction:asc
- paging
  - Product
    page1
    current9
    count9
    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:7/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	5
2	DESCRIBE `types`	6	6	4
3	DESCRIBE `categories`	4	4	4
4	DESCRIBE `categories_products`	2	2	4
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` = 7	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` = 7 ORDER BY `Product`.`name` asc LIMIT 20	9	9	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 (95, 96, 40, 97, 89, 99, 91, 98, 90)	15	15	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 (95, 96, 40, 97, 89, 99, 91, 98, 90) AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE 1 = 1	9	9	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.321445 (seconds)

Message	Time in seconds	Graph
Component initialization and startup	0.034980
Controller Action	0.022990
Render Controller Action	0.083180
Rendering View	0.082630
Rendering APP/views/products/index.ctp	0.062580
Rendering APP/views/layouts/default.ctp	0.019300
Rendering APP/views/elements/account.ctp	0.002230
Rendering APP/views/elements/search.ctp	0.004930
Rendering APP/views/elements/navigation.ctp	0.005730
Rendering APP/views/elements/basket.ctp	0.000940
Rendering APP/views/elements/bubbles.ctp	0.000710

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
    id95
    name9 Function Laser Sword
    quantity24
    casesize96
    packageBox
    price44.40
    unitprice1.85
    rrp4.00
    image9functionlasersword.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id95
    category_id7
    Type
    0
    id17
    product_id95
    codeNOVSWOR02
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 1
    Product
    id96
    nameCyber Baton
    quantity60
    casesize120
    packageBox
    price117.00
    unitprice1.95
    rrp4.00
    imagecyberbaton.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id96
    category_id7
    Type
    0
    id18
    product_id96
    codeNOVBAT08
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 2
    Product
    id40
    nameDale Sword Fibre Optic Baton
    quantity144
    casesize576
    packageBox
    price187.20
    unitprice1.30
    rrp3.00
    imagedaleswordfibreopticbaton.png
    created0000-00-00 00:00:00
    modified2009-04-23 16:36:11
    CategoriesProduct
    product_id40
    category_id7
    Type
    0
    id19
    product_id40
    codeNOVBAT05
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 3
    Product
    id97
    nameDouble Ended Sword
    quantity36
    casesize72
    packageBox
    price115.20
    unitprice3.20
    rrp6.00
    imagedoubleendedsword.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id97
    category_id7
    Type
    0
    id26
    product_id97
    codeNOVSWOR37
    descriptionBlue
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    1
    id25
    product_id97
    codeNOVSWOR34
    descriptionGreen
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    2
    id24
    product_id97
    codeNOVSWOR32
    descriptionDual - Blue/Red
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    3
    id23
    product_id97
    codeNOVSWOR31
    descriptionRed
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    4
    id22
    product_id97
    codeNOVSWOR26
    descriptionDual - Blue/Green
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 4
    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
    CategoriesProduct
    product_id89
    category_id7
    Type
    0
    id27
    product_id89
    codeNOVSWOR05
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 5
    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
    CategoriesProduct
    product_id99
    category_id7
    Type
    0
    id31
    product_id99
    codeNOVSWOR22
    descriptionRed
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    1
    id30
    product_id99
    codeNOVSWOR21
    descriptionBlue
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    2
    id29
    product_id99
    codeNOVSWOR20
    descriptionGreen
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 6
    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
    CategoriesProduct
    product_id91
    category_id7
    Type
    0
    id33
    product_id91
    codeNOVSWOR33
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 7
    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
    CategoriesProduct
    product_id98
    category_id7
    Type
    0
    id28
    product_id98
    codeNOVSWOR19
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
  - 8
    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
    CategoriesProduct
    product_id90
    category_id7
    Type
    0
    id32
    product_id90
    codeNOVSWOR30
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id7
    nameBatons & Swords
    created2009-04-23 09:54:34
    modified2009-04-23 15:26:54
- $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