Notice (8): Undefined index: ImageGroupImage [APP/View/Themed/Terrace2019/Products/home.ctp, line 5]
Notice (8): Undefined index: ImageGroupImage [APP/View/Themed/Terrace2019/Products/home.ctp, line 7]
Warning (2): Invalid argument supplied for foreach() [APP/View/Themed/Terrace2019/Elements/Products/home_promos.ctp, line 7]
Winter Collection
SHIRTS
hats
polos
hoods
(default) 31 queries took 27 ms
#QueryEA#T
1SELECT `Colour`.`id`, `Colour`.`parent_id`, `Colour`.`lft`, `Colour`.`rght`, `Colour`.`name`, `Colour`.`description`, `Colour`.`swatch`, `Colour`.`code`, `Colour`.`deleted`, `Colour`.`created`, `Colour`.`modified` FROM `test_terrace`.`colours` AS `Colour` WHERE 1 = 1 ORDER BY `Colour`.`lft` ASC23231
2SELECT `Size`.`id`, `Size`.`size_group_id`, `Size`.`parent_id`, `Size`.`lft`, `Size`.`rght`, `Size`.`name`, `Size`.`description`, `Size`.`deleted`, `Size`.`created`, `Size`.`modified` FROM `test_terrace`.`sizes` AS `Size` WHERE 1 = 1 ORDER BY `Size`.`lft` ASC18181
3SELECT `TaxClass`.`id`, `TaxClass`.`name`, `TaxClass`.`created`, `TaxClass`.`modified` FROM `test_terrace`.`tax_classes` AS `TaxClass` WHERE 1 = 1330
4SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (1) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
5SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (2) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1110
6SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (3) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
7SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`friendly`, `Product`.`name`, `Product`.`purchase_price`, `Product`.`sale_price`, `Product`.`tax_class_id`, `Product`.`default_colour_id`, `Product`.`deleted`, `Product`.`hidden`, `Product`.`control_stock`, `Product`.`low_stock_threshold` FROM `test_terrace`.`products` AS `Product` WHERE `Product`.`parent_id` IS NULL AND `Product`.`hidden` = '0' AND `Product`.`deleted` = '0' AND `Product`.`is_stock_base` = '0' AND `Product`.`showcase` = '1' ORDER BY `Product`.`created` DESC551
8SELECT `ChildProduct`.`id`, `ChildProduct`.`parent_id`, `ChildProduct`.`colour_id`, `ChildProduct`.`size_id`, `ChildProduct`.`deleted` FROM `test_terrace`.`products` AS `ChildProduct` WHERE `ChildProduct`.`deleted` = '0' AND `ChildProduct`.`parent_id` IN (16533, 16212, 16185, 16111, 15064)86861
9SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`colour_id`, `ProductImage`.`image`, `ProductImage`.`full_image`, `ProductImage`.`alternate_text`, `ProductImage`.`title_text` FROM `test_terrace`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (16533, 16212, 16185, 16111, 15064) ORDER BY `ProductImage`.`id` ASC15151
10SELECT `Discount`.`id`, `Discount`.`description`, `Discount`.`is_percentage`, `Discount`.`value`, `Discount`.`start_date`, `Discount`.`end_date`, `Discount`.`revoked`, `Discount`.`created`, `Discount`.`modified`, `DiscountsProduct`.`discount_id`, `DiscountsProduct`.`product_id` FROM `test_terrace`.`discounts` AS `Discount` JOIN `test_terrace`.`discounts_products` AS `DiscountsProduct` ON (`DiscountsProduct`.`product_id` IN (16533, 16212, 16185, 16111, 15064) AND `DiscountsProduct`.`discount_id` = `Discount`.`id`) WHERE NOW() between `Discount`.`start_date` AND `Discount`.`end_date` AND `Discount`.`revoked` = '0'001
11SELECT `Colour`.`id`, `Colour`.`parent_id`, `Colour`.`lft`, `Colour`.`rght`, `Colour`.`name`, `Colour`.`description`, `Colour`.`swatch`, `Colour`.`code`, `Colour`.`deleted`, `Colour`.`created`, `Colour`.`modified` FROM `test_terrace`.`colours` AS `Colour` WHERE 1 = 1 ORDER BY `Colour`.`lft` ASC23231
12SELECT `Size`.`id`, `Size`.`size_group_id`, `Size`.`parent_id`, `Size`.`lft`, `Size`.`rght`, `Size`.`name`, `Size`.`description`, `Size`.`deleted`, `Size`.`created`, `Size`.`modified` FROM `test_terrace`.`sizes` AS `Size` WHERE 1 = 1 ORDER BY `Size`.`lft` ASC18181
13SELECT `TaxClass`.`id`, `TaxClass`.`name`, `TaxClass`.`created`, `TaxClass`.`modified` FROM `test_terrace`.`tax_classes` AS `TaxClass` WHERE 1 = 1330
14SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (1) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
15SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (2) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
16SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (3) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
17SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`friendly`, `Product`.`name`, `Product`.`purchase_price`, `Product`.`sale_price`, `Product`.`tax_class_id`, `Product`.`default_colour_id`, `Product`.`deleted`, `Product`.`hidden`, `Product`.`control_stock`, `Product`.`low_stock_threshold` FROM `test_terrace`.`products` AS `Product` WHERE `Product`.`parent_id` IS NULL AND `Product`.`hidden` = '0' AND `Product`.`deleted` = '0' AND `Product`.`is_stock_base` = '0' AND `Product`.`new_release` = '1' ORDER BY `Product`.`created` DESC001
18SELECT `Colour`.`id`, `Colour`.`parent_id`, `Colour`.`lft`, `Colour`.`rght`, `Colour`.`name`, `Colour`.`description`, `Colour`.`swatch`, `Colour`.`code`, `Colour`.`deleted`, `Colour`.`created`, `Colour`.`modified` FROM `test_terrace`.`colours` AS `Colour` WHERE 1 = 1 ORDER BY `Colour`.`lft` ASC23231
19SELECT `Size`.`id`, `Size`.`size_group_id`, `Size`.`parent_id`, `Size`.`lft`, `Size`.`rght`, `Size`.`name`, `Size`.`description`, `Size`.`deleted`, `Size`.`created`, `Size`.`modified` FROM `test_terrace`.`sizes` AS `Size` WHERE 1 = 1 ORDER BY `Size`.`lft` ASC18181
20SELECT `TaxClass`.`id`, `TaxClass`.`name`, `TaxClass`.`created`, `TaxClass`.`modified` FROM `test_terrace`.`tax_classes` AS `TaxClass` WHERE 1 = 1331
21SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (1) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
22SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (2) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1110
23SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (3) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
24SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`friendly`, `Product`.`name`, `Product`.`purchase_price`, `Product`.`sale_price`, `Product`.`tax_class_id`, `Product`.`default_colour_id`, `Product`.`deleted`, `Product`.`hidden`, `Product`.`control_stock`, `Product`.`low_stock_threshold` FROM `test_terrace`.`products` AS `Product` WHERE `Product`.`parent_id` IS NULL AND `Product`.`hidden` = '0' AND `Product`.`deleted` = '0' AND `Product`.`is_stock_base` = '0' AND `Product`.`classic` = '1' ORDER BY `Product`.`created` DESC001
25SELECT `ImageGroup`.`id`, `ImageGroup`.`image_group_image_constraint_id`, `ImageGroup`.`name`, `ImageGroup`.`can_add`, `ImageGroup`.`can_order`, `ImageGroup`.`can_delete`, `ImageGroup`.`created`, `ImageGroupImageConstraint`.`id`, `ImageGroupImageConstraint`.`format`, `ImageGroupImageConstraint`.`compression`, `ImageGroupImageConstraint`.`resolution`, `ImageGroupImageConstraint`.`height`, `ImageGroupImageConstraint`.`width`, `ImageGroupImageConstraint`.`created` FROM `test_terrace`.`image_groups` AS `ImageGroup` LEFT JOIN `test_terrace`.`image_group_image_constraints` AS `ImageGroupImageConstraint` ON (`ImageGroup`.`image_group_image_constraint_id` = `ImageGroupImageConstraint`.`id`) WHERE `ImageGroup`.`id` = 1 LIMIT 1111
26SELECT `ImageGroupImage`.`id`, `ImageGroupImage`.`image_group_id`, `ImageGroupImage`.`image_group_image_constraint_id`, `ImageGroupImage`.`order`, `ImageGroupImage`.`description`, `ImageGroupImage`.`image`, `ImageGroupImage`.`link`, `ImageGroupImage`.`created` FROM `test_terrace`.`image_group_images` AS `ImageGroupImage` WHERE `ImageGroupImage`.`image_group_id` = (1) ORDER BY `ImageGroupImage`.`order` ASC331
27SELECT `ImageGroup`.`id`, `ImageGroup`.`image_group_image_constraint_id`, `ImageGroup`.`name`, `ImageGroup`.`can_add`, `ImageGroup`.`can_order`, `ImageGroup`.`can_delete`, `ImageGroup`.`created`, `ImageGroupImageConstraint`.`id`, `ImageGroupImageConstraint`.`format`, `ImageGroupImageConstraint`.`compression`, `ImageGroupImageConstraint`.`resolution`, `ImageGroupImageConstraint`.`height`, `ImageGroupImageConstraint`.`width`, `ImageGroupImageConstraint`.`created` FROM `test_terrace`.`image_groups` AS `ImageGroup` LEFT JOIN `test_terrace`.`image_group_image_constraints` AS `ImageGroupImageConstraint` ON (`ImageGroup`.`image_group_image_constraint_id` = `ImageGroupImageConstraint`.`id`) WHERE `ImageGroup`.`id` = 2 LIMIT 1111
28SELECT `ImageGroupImage`.`id`, `ImageGroupImage`.`image_group_id`, `ImageGroupImage`.`image_group_image_constraint_id`, `ImageGroupImage`.`order`, `ImageGroupImage`.`description`, `ImageGroupImage`.`image`, `ImageGroupImage`.`link`, `ImageGroupImage`.`created` FROM `test_terrace`.`image_group_images` AS `ImageGroupImage` WHERE `ImageGroupImage`.`image_group_id` = (2) ORDER BY `ImageGroupImage`.`order` ASC551
29SELECT `ImageGroup`.`id`, `ImageGroup`.`image_group_image_constraint_id`, `ImageGroup`.`name`, `ImageGroup`.`can_add`, `ImageGroup`.`can_order`, `ImageGroup`.`can_delete`, `ImageGroup`.`created`, `ImageGroupImageConstraint`.`id`, `ImageGroupImageConstraint`.`format`, `ImageGroupImageConstraint`.`compression`, `ImageGroupImageConstraint`.`resolution`, `ImageGroupImageConstraint`.`height`, `ImageGroupImageConstraint`.`width`, `ImageGroupImageConstraint`.`created` FROM `test_terrace`.`image_groups` AS `ImageGroup` LEFT JOIN `test_terrace`.`image_group_image_constraints` AS `ImageGroupImageConstraint` ON (`ImageGroup`.`image_group_image_constraint_id` = `ImageGroupImageConstraint`.`id`) WHERE `ImageGroup`.`id` = 3 LIMIT 1001
30SELECT `ImageGroup`.`id`, `ImageGroup`.`image_group_image_constraint_id`, `ImageGroup`.`name`, `ImageGroup`.`can_add`, `ImageGroup`.`can_order`, `ImageGroup`.`can_delete`, `ImageGroup`.`created`, `ImageGroupImageConstraint`.`id`, `ImageGroupImageConstraint`.`format`, `ImageGroupImageConstraint`.`compression`, `ImageGroupImageConstraint`.`resolution`, `ImageGroupImageConstraint`.`height`, `ImageGroupImageConstraint`.`width`, `ImageGroupImageConstraint`.`created` FROM `test_terrace`.`image_groups` AS `ImageGroup` LEFT JOIN `test_terrace`.`image_group_image_constraints` AS `ImageGroupImageConstraint` ON (`ImageGroup`.`image_group_image_constraint_id` = `ImageGroupImageConstraint`.`id`) WHERE `ImageGroup`.`id` = 4 LIMIT 1001
31SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`friendly`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`name`, `Category`.`description`, `Category`.`image`, `Category`.`template`, `Category`.`hidden`, `Category`.`created`, `Category`.`modified` FROM `test_terrace`.`categories` AS `Category` WHERE `Category`.`parent_id` IS NULL AND `Category`.`hidden` = '0' ORDER BY `Category`.`lft` ASC661