| 1 | SELECT COUNT(*) AS `count` FROM `jesses_cake`.`products` AS `Product` WHERE `Product`.`id` = 497 | | 1 | 1 | 2 |
| 2 | SELECT `Product`.`id`, `Product`.`subcategory_id`, `Product`.`name`, `Product`.`slug`, `Product`.`sku`, `Product`.`description`, `Product`.`ingredients`, `Product`.`price`, `Product`.`quantity`, `Product`.`weight`, `Product`.`sale`, `Product`.`new`, `Product`.`special`, `Product`.`last_chance`, `Product`.`swatch`, `Product`.`discontinued`, `Product`.`out_of_stock`, `Product`.`active`, `Product`.`created`, `Product`.`modified`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`product_id`, `Subcategory`.`name`, `Subcategory`.`slug`, `Subcategory`.`active`, `Subcategory`.`created`, `Subcategory`.`modified`, `DefaultPhoto`.`id`, `DefaultPhoto`.`product_id`, `DefaultPhoto`.`src`, `DefaultPhoto`.`default`, `DefaultPhoto`.`created`, `DefaultPhoto`.`modified` 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`.`id` = 497 AND `Product`.`active` = '1' LIMIT 1 | | 1 | 1 | 1 |
| 3 | SELECT `Category`.`name` FROM `jesses_cake`.`categories` AS `Category` WHERE `Category`.`id` = 6 | | 1 | 1 | 1 |
| 4 | SELECT `ProductPhoto`.`id`, `ProductPhoto`.`product_id`, `ProductPhoto`.`src`, `ProductPhoto`.`default`, `ProductPhoto`.`created`, `ProductPhoto`.`modified` FROM `jesses_cake`.`product_photos` AS `ProductPhoto` WHERE `default` = 0 AND `ProductPhoto`.`product_id` = (497) | | 1 | 1 | 1 |
| 5 | SELECT `RelatedProduct`.`id`, `RelatedProduct`.`name`, `RelatedProduct`.`price`, `RelatedProduct`.`sale`, `RelatedProduct`.`slug`, `RelatedProduct`.`subcategory_id`, `ProductsProduct`.`id`, `ProductsProduct`.`product_id`, `ProductsProduct`.`related_id` FROM `jesses_cake`.`products` AS `RelatedProduct` JOIN `jesses_cake`.`products_products` AS `ProductsProduct` ON (`ProductsProduct`.`product_id` = 497 AND `ProductsProduct`.`related_id` = `RelatedProduct`.`id`) | | 0 | 0 | 1 |
| 6 | SELECT `Product`.`id`, `Product`.`name`, `Product`.`slug`, `Product`.`swatch` FROM `jesses_cake`.`products` AS `Product` WHERE `subcategory_id` = 59 AND `active` = '1' | | 3 | 3 | 1 |
| 7 | SELECT `Subcategory`.`name`, `Subcategory`.`slug`, `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`.`id` != 59 AND `Subcategory`.`category_id` = 6 AND `Subcategory`.`active` = '1' AND `DefaultProduct`.`special` = '0' AND `DefaultProduct`.`last_chance` = '0' AND `DefaultProduct`.`active` = '1' | | 6 | 6 | 1 |
| 8 | SELECT `Product`.`quantity` FROM `jesses_cake`.`products` AS `Product` WHERE `Product`.`id` = 497 LIMIT 1 | | 1 | 1 | 1 |
| 9 | SELECT `Category`.`id`, `Category`.`name` FROM `jesses_cake`.`categories` AS `Category` WHERE `active` = '1' ORDER BY `id` ASC | | 6 | 6 | 1 |
| 10 | SELECT `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) | | 4 | 4 | 1 |
| 11 | SELECT `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) | | 57 | 57 | 2 |
| 12 | SELECT `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` ASC | | 31 | 31 | 2 |
