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 | 1 |
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` = 'Squire-Pollock-Pocket-T-shirt-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` = (14553) | | 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` = 14554 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` = 14555 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` = 14556 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` = 14557 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 1 |
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` = 14558 AND `CurrentStock`.`current` = '1' | | 1 | 1 | 1 |
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` = 14559 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` = (14553) ORDER BY `ProductImage`.`id` ASC | | 4 | 4 | 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` = 14553 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` = 1 LIMIT 1 | | 1 | 1 | 2 |
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` = (1) ORDER BY `Size`.`lft` ASC | | 9 | 9 | 1 |
19 | SELECT `ProductsProduct`.`to_product_id` FROM `test_terrace`.`products_products` AS `ProductsProduct` WHERE `ProductsProduct`.`product_id` = 14553 | | 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 | 1 |
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 (13926, 14546, 14560, 14581) | | 2 | 2 | 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 (14546, 14560) | | 12 | 12 | 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 (14546, 14560) ORDER BY `ProductImage`.`id` ASC | | 8 | 8 | 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 (14546, 14560) 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 |