Shop

Products

SugaronlineGold Monthly Membership (Pay Monthly)

Price from $180.00

A membership package for the serious sugar professional.


More Details Add to cart Buy now

SugaronlineGold Annual Membership

Price from $1,980.00

A membership package for the serious sugar professional.
Buy 12 months for price of 11


More Details Add to cart Buy now

(default) 56 queries took 144 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `shop_categories`12124
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';114
3SHOW FULL COLUMNS FROM `shop_access_levels`554
4SHOW FULL COLUMNS FROM `website_access_levels`334
5SHOW FULL COLUMNS FROM `website_contents`35355
6SHOW FULL COLUMNS FROM `website_content_types`664
7SHOW FULL COLUMNS FROM `website_top_categories`10104
8SHOW FULL COLUMNS FROM `website_top_category_types`224
9SHOW FULL COLUMNS FROM `website_categories`334
10SHOW FULL COLUMNS FROM `website_categories_website_contents`224
11SHOW FULL COLUMNS FROM `website_categories_website_top_categories`226
12SHOW FULL COLUMNS FROM `countries`17174
13SHOW FULL COLUMNS FROM `people`94946
14SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
15SHOW FULL COLUMNS FROM `user_types`11114
16SHOW FULL COLUMNS FROM `person_shop_products`883
17SHOW FULL COLUMNS FROM `shop_orders`23235
18SHOW FULL COLUMNS FROM `payment_methods`223
19SHOW FULL COLUMNS FROM `shop_order_statuses`224
20SHOW FULL COLUMNS FROM `discounts`664
21SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';113
22SHOW FULL COLUMNS FROM `logins`443
23SHOW FULL COLUMNS FROM `interests`335
24SHOW FULL COLUMNS FROM `interest_groups`225
25SHOW FULL COLUMNS FROM `interests_people`334
26SHOW FULL COLUMNS FROM `people_shop_categories`225
27SHOW FULL COLUMNS FROM `shop_ordered_products`773
28SHOW FULL COLUMNS FROM `shop_products`27275
29SHOW FULL COLUMNS FROM `shop_pricing_units`333
30SHOW FULL COLUMNS FROM `shop_access_levels_shop_products`333
31SHOW FULL COLUMNS FROM `shop_addon_products`226
32SHOW FULL COLUMNS FROM `shop_sub_products`445
33SHOW FULL COLUMNS FROM `your_menu_items`553
34SHOW FULL COLUMNS FROM `configuration`553
35SELECT `Country`.`id`, `Country`.`name`, `Country`.`iso_code`, `Country`.`gmt_offset`, `Country`.`int_dial_code`, `Country`.`is_domicile_country`, `Country`.`is_origin_country`, `Country`.`is_destination_country`, `Country`.`is_trading_country`, `Country`.`name_fr`, `Country`.`name_es`, `Country`.`name_pt`, `Country`.`name_de`, `Country`.`name_cn`, `Country`.`name_th`, `Country`.`name_ru`, `Country`.`tax_rate` FROM `countries` AS `Country` WHERE `Country`.`id` = 270 LIMIT 1110
36SELECT `ShopAccessLevel`.`id`, `ShopAccessLevel`.`name`, `ShopAccessLevel`.`description`, `ShopAccessLevel`.`price`, `ShopAccessLevel`.`visible` FROM `shop_access_levels` AS `ShopAccessLevel` WHERE `ShopAccessLevel`.`id` = 1 LIMIT 1110
37SELECT `WebsiteAccessLevel`.`id`, `WebsiteAccessLevel`.`name`, `WebsiteAccessLevel`.`shop_access_level_id` FROM `website_access_levels` AS `WebsiteAccessLevel` WHERE `WebsiteAccessLevel`.`id` = 1 LIMIT 1110
38SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`input_type`, `Configuration`.`cronjob` FROM `configuration` AS `Configuration` WHERE 1 = 1 16160
39SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`in_footer` = 1 AND `WebsiteContent`.`visible` = 1 440
40SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`subscription_type` = 1 AND `WebsiteContent`.`visible` = 1 ORDER BY IF(name = 'Compare Levels', 1, 0) ASC, id ASC 440
41SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`information` = 1 AND `WebsiteContent`.`visible` = 1 440
42SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`service` = 1 AND `WebsiteContent`.`visible` = 1 330
43SHOW FULL COLUMNS FROM `settlement_prices`32324
44SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '5' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
45SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '11' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
46SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '16' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
47SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '5' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
48SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '11' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
49SHOW FULL COLUMNS FROM `prices`24244
50SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'W-ICL' ORDER BY `Price`.`id` ASC LIMIT 20880
51SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'SB' ORDER BY `Price`.`id` ASC LIMIT 2012120
52SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'SFQ' ORDER BY `Price`.`id` ASC LIMIT 2011110
53SELECT `ShopCategory`.`id`, `ShopCategory`.`name`, `ShopCategory`.`description`, `ShopCategory`.`allow_multiple_items_in_basket`, `ShopCategory`.`visible`, `ShopCategory`.`parent_id`, `ShopCategory`.`available_as_email_alert`, `ShopCategory`.`full_months_only`, `ShopCategory`.`shop_access_level_id`, `ShopCategory`.`image_file`, `ShopCategory`.`lft`, `ShopCategory`.`rght` FROM `shop_categories` AS `ShopCategory` WHERE `ShopCategory`.`id` = 444 LIMIT 1110
54SELECT `ChildShopCategory`.`id`, `ChildShopCategory`.`name`, `ChildShopCategory`.`description`, `ChildShopCategory`.`allow_multiple_items_in_basket`, `ChildShopCategory`.`visible`, `ChildShopCategory`.`parent_id`, `ChildShopCategory`.`available_as_email_alert`, `ChildShopCategory`.`full_months_only`, `ChildShopCategory`.`shop_access_level_id`, `ChildShopCategory`.`image_file`, `ChildShopCategory`.`lft`, `ChildShopCategory`.`rght` FROM `shop_categories` AS `ChildShopCategory` WHERE `ChildShopCategory`.`parent_id` = (444) ORDER BY `ChildShopCategory`.`name` ASC 000
55SELECT `ShopProduct`.`id`, `ShopProduct`.`name`, `ShopProduct`.`featured`, `ShopProduct`.`feature_date`, `ShopProduct`.`feature_text`, `ShopProduct`.`image_filename`, `ShopProduct`.`short_description`, `ShopProduct`.`full_description`, `ShopProduct`.`tax_payable`, `ShopProduct`.`small_image_url`, `ShopProduct`.`big_image_url`, `ShopProduct`.`file_url`, `ShopProduct`.`active`, `ShopProduct`.`shop_category_id`, `ShopProduct`.`new_shop_access_level_id`, `ShopProduct`.`can_buy_separately`, `ShopProduct`.`default_quantity`, `ShopProduct`.`minimum_quantity`, `ShopProduct`.`can_change_quantity`, `ShopProduct`.`shop_pricing_unit_id`, `ShopProduct`.`can_pay_by_instalments`, `ShopProduct`.`sample_file_url`, `ShopProduct`.`available_as_email_alert`, `ShopProduct`.`created`, `ShopProduct`.`deleted`, `ShopProduct`.`quantity_must_not_exceed_subscription_length`, `ShopProduct`.`subscription` FROM `shop_products` AS `ShopProduct` WHERE ((`ShopProduct`.`can_buy_separately` = 1) AND (`ShopProduct`.`active` = 1) AND (`ShopProduct`.`deleted` = 0)) AND `ShopProduct`.`shop_category_id` = (444) ORDER BY `ShopProduct`.`created` DESC 220
56SELECT `ShopAccessLevel`.`id`, `ShopAccessLevel`.`name`, `ShopAccessLevel`.`description`, `ShopAccessLevel`.`price`, `ShopAccessLevel`.`visible`, `ShopAccessLevelsShopProduct`.`shop_product_id`, `ShopAccessLevelsShopProduct`.`shop_access_level_id`, `ShopAccessLevelsShopProduct`.`price` FROM `shop_access_levels` AS `ShopAccessLevel` JOIN `shop_access_levels_shop_products` AS `ShopAccessLevelsShopProduct` ON (`ShopAccessLevelsShopProduct`.`shop_product_id` IN (42297, 42295) AND `ShopAccessLevelsShopProduct`.`shop_access_level_id` = `ShopAccessLevel`.`id`) ORDER BY `ShopAccessLevelsShopProduct`.`price` ASC 10100