Products

Products

Currently browsing category: Toys

1-2 of 2 products

Image	Name	Quantity	Price	Unit price	Actions
	Flashing Maracas	Box of 72	£50.40	£0.70	View
	LED Balloon Light	Box of 20	£14.80	£0.74	View

History
Request History
4 previous requests available
Session
Session
- Config
  - userAgent0d335cdef5656d1bd1ddd24a426107e1
  - time1337573103
  - 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
  - category4
  - sortimage
  - directionasc
- controllerproducts
- actionindex
- plugin(null)
- form(empty)
- url
  - urlproducts/index/page:1/category:4/sort:image/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.imageasc
    conditions(empty)
$_GET
- urlproducts/index/page:1/category:4/sort:image/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	3
2	DESCRIBE `types`		6	6	3
3	DESCRIBE `categories`		4	4	3
4	DESCRIBE `categories_products`		2	2	2
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` = 4		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` = 4 ORDER BY `Product`.`image` asc LIMIT 20		2	2	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 (110, 108)		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 (110, 108) AND `CategoriesProduct`.`category_id` = `Category`.`id`) WHERE 1 = 1		2	2	0

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

Memory

Current Memory Use 10.75 MB

Peak Memory Use 10.83 MB

Timers

Total Request Time: 1.264134 (seconds)

Message	Time in seconds	Graph
Component initialization and startup	0.021330
Controller Action	0.015160
Render Controller Action	0.095670
Rendering View	0.095190
Rendering APP/views/products/index.ctp	0.073970
Rendering APP/views/layouts/default.ctp	0.020690
Rendering APP/views/elements/account.ctp	0.001860
Rendering APP/views/elements/search.ctp	0.005570
Rendering APP/views/elements/navigation.ctp	0.006360
Rendering APP/views/elements/basket.ctp	0.001040
Rendering APP/views/elements/bubbles.ctp	0.000790

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
    id110
    nameFlashing Maracas
    quantity72
    casesize144
    packageBox
    price50.40
    unitprice0.70
    rrp1.50
    imageflashingmaracas.png
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    CategoriesProduct
    product_id110
    category_id4
    Type
    0
    id55
    product_id110
    codeNOVSASA
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id4
    nameToys
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
  - 1
    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
    CategoriesProduct
    product_id108
    category_id4
    Type
    0
    id53
    product_id108
    codeNOVBALLOON01
    description
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
    Category
    0
    id4
    nameToys
    created0000-00-00 00:00:00
    modified0000-00-00 00:00:00
- $this->data(null)
- $this->validationErrors(empty)