CakePHP Shopping Cart






(default) 2 queries took 6 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 (8, 2, 5, 1, 14, 15, 9, 11, 20, 7, 16, 4, 18, 13, 6, 3, 12, 19)18185