Shop

Products

SugaronlineSilver Annual Membership

Price from $660.00

News, quotes, reports and more.
Buy annual membership and receive 12 months for the price of 11.


More Details Add to cart Buy now

SugaronlineSilver Monthly Membership (Pay Monthly)

Price from $60.00

News, Delayed Quotes, Reports and more (3 month minimum period)


More Details Add to cart Buy now

(default) 56 queries took 139 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`663
7SHOW FULL COLUMNS FROM `website_top_categories`10103
8SHOW FULL COLUMNS FROM `website_top_category_types`223
9SHOW FULL COLUMNS FROM `website_categories`334
10SHOW FULL COLUMNS FROM `website_categories_website_contents`223
11SHOW FULL COLUMNS FROM `website_categories_website_top_categories`225
12SHOW FULL COLUMNS FROM `countries`17173
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`884
17SHOW FULL COLUMNS FROM `shop_orders`23234
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`444
23SHOW FULL COLUMNS FROM `interests`334
24SHOW FULL COLUMNS FROM `interest_groups`225
25SHOW FULL COLUMNS FROM `interests_people`335
26SHOW FULL COLUMNS FROM `people_shop_categories`225
27SHOW FULL COLUMNS FROM `shop_ordered_products`773
28SHOW FULL COLUMNS FROM `shop_products`27274
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`225
32SHOW FULL COLUMNS FROM `shop_sub_products`446
33SHOW FULL COLUMNS FROM `your_menu_items`553
34SHOW FULL COLUMNS FROM `configuration`554
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` = 443 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` = (443) 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` = (443) 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 (42306, 42305) AND `ShopAccessLevelsShopProduct`.`shop_access_level_id` = `ShopAccessLevel`.`id`) ORDER BY `ShopAccessLevelsShopProduct`.`price` ASC 10100