| 1 | SELECT `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` ASC | | 23 | 23 | 1 |
| 2 | SELECT `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` ASC | | 18 | 18 | 1 |
| 3 | SELECT `TaxClass`.`id`, `TaxClass`.`name`, `TaxClass`.`created`, `TaxClass`.`modified` FROM `test_terrace`.`tax_classes` AS `TaxClass` WHERE 1 = 1 | | 3 | 3 | 0 |
| 4 | SELECT `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 1 | | 1 | 1 | 1 |
| 5 | SELECT `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 1 | | 1 | 1 | 1 |
| 6 | SELECT `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 1 | | 1 | 1 | 0 |
| 7 | SELECT `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`, `Product`.`description` 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`.`friendly` = 'Terraces-Heritage-Check-Cargo-Shorts-Navy' | | 1 | 1 | 1 |
| 8 | SELECT `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` = (15717) | | 6 | 6 | 1 |
| 9 | SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15718 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 1 |
| 10 | SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15719 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 1 |
| 11 | SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15720 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 1 |
| 12 | SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15721 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 0 |
| 13 | SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15722 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 0 |
| 14 | SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15723 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 1 |
| 15 | SELECT `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` = (15717) ORDER BY `ProductImage`.`id` ASC | | 6 | 6 | 1 |
| 16 | SELECT `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` = 15717 AND `DiscountsProduct`.`discount_id` = `Discount`.`id`) WHERE NOW() between `Discount`.`start_date` AND `Discount`.`end_date` AND `Discount`.`revoked` = '0' | | 0 | 0 | 1 |
| 17 | SELECT `SizeGroup`.`id`, `SizeGroup`.`name`, `SizeGroup`.`description`, `SizeGroup`.`created`, `SizeGroup`.`modified` FROM `test_terrace`.`size_groups` AS `SizeGroup` WHERE `SizeGroup`.`id` = 2 LIMIT 1 | | 1 | 1 | 1 |
| 18 | SELECT `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 `Size`.`size_group_id` = (2) ORDER BY `Size`.`lft` ASC | | 8 | 8 | 1 |
| 19 | SELECT `ProductsProduct`.`to_product_id` FROM `test_terrace`.`products_products` AS `ProductsProduct` WHERE `ProductsProduct`.`product_id` = 15717 | | 4 | 4 | 1 |
| 20 | SELECT `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` ASC | | 23 | 23 | 1 |
| 21 | SELECT `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` ASC | | 18 | 18 | 1 |
| 22 | SELECT `TaxClass`.`id`, `TaxClass`.`name`, `TaxClass`.`created`, `TaxClass`.`modified` FROM `test_terrace`.`tax_classes` AS `TaxClass` WHERE 1 = 1 | | 3 | 3 | 0 |
| 23 | SELECT `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 1 | | 1 | 1 | 1 |
| 24 | SELECT `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 1 | | 1 | 1 | 1 |
| 25 | SELECT `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 1 | | 1 | 1 | 1 |
| 26 | SELECT `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`.`id` IN (15344, 15708, 15733, 15740) | | 4 | 4 | 1 |
| 27 | SELECT `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 (15344, 15708, 15733, 15740) | | 22 | 22 | 1 |
| 28 | SELECT `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 (15344, 15708, 15733, 15740) ORDER BY `ProductImage`.`id` ASC | | 17 | 17 | 1 |
| 29 | SELECT `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 (15344, 15708, 15733, 15740) AND `DiscountsProduct`.`discount_id` = `Discount`.`id`) WHERE NOW() between `Discount`.`start_date` AND `Discount`.`end_date` AND `Discount`.`revoked` = '0' | | 0 | 0 | 1 |
| 30 | SELECT `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` ASC | | 6 | 6 | 1 |
