Whats New

View All Eyes Lips Nails Face JulieG
(default) 7 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id`, `Category`.`name` FROM `jesses_cake`.`categories` AS `Category` WHERE 1 = 1661
2SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`price`, `Product`.`sale`, `Subcategory`.`name`, `Subcategory`.`slug`, `DefaultPhoto`.`src` FROM `jesses_cake`.`products` AS `Product` LEFT JOIN `jesses_cake`.`subcategories` AS `Subcategory` ON (`Product`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `jesses_cake`.`product_photos` AS `DefaultPhoto` ON (`DefaultPhoto`.`product_id` = `Product`.`id` AND `DefaultPhoto`.`default` = '1') WHERE `Product`.`active` = '1' AND `Product`.`new` = '1' ORDER BY `Subcategory`.`category_id` ASC, `Product`.`subcategory_id` ASC, `Product`.`name` ASC LIMIT 2012122
3SELECT COUNT(*) AS `count` FROM `jesses_cake`.`products` AS `Product` LEFT JOIN `jesses_cake`.`subcategories` AS `Subcategory` ON (`Product`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `jesses_cake`.`product_photos` AS `DefaultPhoto` ON (`DefaultPhoto`.`product_id` = `Product`.`id` AND `DefaultPhoto`.`default` = '1') WHERE `Product`.`active` = '1' AND `Product`.`new` = '1'112
4SELECT `Category`.`id`, `Category`.`name` FROM `jesses_cake`.`categories` AS `Category` WHERE `active` = '1' ORDER BY `id` ASC661
5SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`type_id`, `Page`.`title`, `Page`.`slug`, `Page`.`body`, `Page`.`img`, `Page`.`url_1`, `Page`.`video`, `Page`.`active`, `Page`.`created`, `Page`.`modified` FROM `jesses_cake`.`pages` AS `Page` WHERE `Page`.`category_id` IN (1, 2, 3, 4, 5, 6) 441
6SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`product_id`, `Subcategory`.`name`, `Subcategory`.`slug`, `Subcategory`.`active`, `Subcategory`.`created`, `Subcategory`.`modified` FROM `jesses_cake`.`subcategories` AS `Subcategory` WHERE `Subcategory`.`category_id` IN (1, 2, 3, 4, 5, 6) 57572
7SELECT `Subcategory`.`category_id`, `Subcategory`.`name`, `Subcategory`.`slug`, `DefaultProduct`.`id`, `DefaultProduct`.`slug`, `DefaultProduct`.`active`, `Subcategory`.`id` FROM `jesses_cake`.`subcategories` AS `Subcategory` LEFT JOIN `jesses_cake`.`categories` AS `Category` ON (`Subcategory`.`category_id` = `Category`.`id`) LEFT JOIN `jesses_cake`.`products` AS `DefaultProduct` ON (`Subcategory`.`product_id` = `DefaultProduct`.`id`) WHERE `Subcategory`.`category_id` IN (1, 2, 3, 4, 5, 6) AND `Subcategory`.`active` = '1' AND `DefaultProduct`.`special` = '0' AND `DefaultProduct`.`last_chance` = '0' AND `DefaultProduct`.`active` = '1' ORDER BY `Subcategory`.`name` ASC32322