CakePHP Shopping Cart




THIS IS A DEMO CAKEPHP SHOPPING CART !
(default) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`brand_id`, `Product`.`name`, `Product`.`slug`, `Product`.`description`, `Product`.`image`, `Product`.`price`, `Product`.`weight`, `Product`.`tags`, `Product`.`views`, `Product`.`active`, `Product`.`created`, `Product`.`modified`, `Brand`.`id`, `Brand`.`name`, `Brand`.`slug`, `Brand`.`active`, `Brand`.`created`, `Brand`.`modified` FROM `shop`.`products` AS `Product` LEFT JOIN `shop`.`brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE `Product`.`active` = 1 AND `Brand`.`active` = 1 ORDER BY `Product`.`views` ASC LIMIT 2018181
2UPDATE `shop`.`products` AS `Product` SET `Product`.`views` = Product.views + 1 WHERE `Product`.`id` IN (20, 11, 9, 2, 15, 1, 14, 8, 18, 4, 5, 7, 16, 13, 6, 3, 12, 19)18181