Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
Brown Sugar Bear Original Brown Sugar Saver and Softener, Terracotta
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Brown Sugar Bear Original Brown Sugar Saver and Softener, Terracotta

Brown Sugar Bear Original Brown Sugar Saver and Softener, Terracotta
Brown Sugar Bear Original Brown Sugar Saver and Softener, Terracotta Brown Sugar Bear Original Brown Sugar Saver and Softener, Terracotta (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-08-04 02:14:00 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.co.uk/ at the time of purchase will apply to the purchase of this product.

There are no customer reviews yet. Be the first to Write a Review!

Write a Review

The Best Products on eBay

Buy it Now

New

22 Day(s) 3 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

19 Day(s) 11 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

1 Day(s) 23 h(s)
Worldwide

N/A

No Returns

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.67490482330322 293 0.2123 0


No Amazon API Requests Made.

Total time 0.67490482330322 seconds

Number Time From Start Name Description
1 0.082183837890625 Initialise Initialise FSB Function
2 0.083844900131226 App Controller Start Start of the App controller (called before the controller of every page)
3 0.093147993087769 Start of getCategoryListByGroup Function Before first category groups query
4 0.094461917877197 After initial query Before first category groups query
5 0.09446382522583 Get Category List for Group Before the call to getCategoryList function
6 0.094467878341675 Start of GetCategoryList function Start of the function
7 0.09447193145752 Before getting categories Query to get specific category list
8 0.095860004425049 After getting categories Query to get specific category list
9 0.095861911773682 Before getting category custom Before call to function getCategoryCustom
10 0.10353088378906 After getting category custom After call to function getCategoryCustom
11 0.10353398323059 Before getting category custom Before call to function getCategoryCustom
12 0.1069438457489 After getting category custom After call to function getCategoryCustom
13 0.10694789886475 Before getting category custom Before call to function getCategoryCustom
14 0.11048889160156 After getting category custom After call to function getCategoryCustom
15 0.11049294471741 Before getting category custom Before call to function getCategoryCustom
16 0.11305093765259 After getting category custom After call to function getCategoryCustom
17 0.11305403709412 Before getting category custom Before call to function getCategoryCustom
18 0.11563181877136 After getting category custom After call to function getCategoryCustom
19 0.11563396453857 Before getting category custom Before call to function getCategoryCustom
20 0.11815094947815 After getting category custom After call to function getCategoryCustom
21 0.11815404891968 Before getting category custom Before call to function getCategoryCustom
22 0.12080097198486 After getting category custom After call to function getCategoryCustom
23 0.12080383300781 Before getting category custom Before call to function getCategoryCustom
24 0.12376999855042 After getting category custom After call to function getCategoryCustom
25 0.12377190589905 Before getting category custom Before call to function getCategoryCustom
26 0.12686395645142 After getting category custom After call to function getCategoryCustom
27 0.12686681747437 End of GetCategoryList function End of the function
28 0.12687683105469 End of getCategoryListByGroup Function Before return()
29 0.22674798965454 App Controller End End of the App controller (called before the controller of every page)
30 0.22728085517883 Product Start Start of the product info controller
31 0.22814583778381 Cache file not found Starting get product details
32 0.2393970489502 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.5991039276123 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.60113286972046 Related products Start getting related products if enabled
35 0.60113382339478 Related Products Start Before the related products are found
36 0.60113501548767 Related Products Keywords Before the related product keywords are found
37 0.60113883018494 Create Keyword List Function Start of function
38 0.60125994682312 Create Keyword List Function After looping provided content - 24 keywords found
39 0.60181403160095 Create Keyword List Function After looping initial keyword list - 23 keywords remaining
40 0.60182285308838 Create Keyword List Function After reducing keyword list
41 0.601881980896 Create Keyword List Function After selecting by scoring keywords
42 0.60188388824463 Create Keyword List Function After final loop of keywords
43 0.60188484191895 Related Products Keywords After the related product keywords are found
44 0.62126684188843 Related Products End After the related products are found
45 0.63505887985229 Product End End of the product info controller (Product Info)
46 0.63641881942749 App_after Controller Start Start of the App_after controller (called after the controller of every page)
47 0.63750004768372 Before Get Options Before the call to getOptions in the tpl class
48 0.66050481796265 After Get Options After the call to getOptions in the tpl class
49 0.66061997413635 App_after Controller End End of the App_after controller (called after the controller of every page)
50 0.66064596176147 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
51 0.66639804840088 Product Info: After Smarty Fetch After the product.tpl template is fetched
52 0.66640090942383 Product Info: Before Template Display Before the template is displayed
53 0.67488884925842 Product Info: After Template Display After the template is displayed
54 0.67489385604858 Finalizing debug Before the debug is output to the page.
55 0.67490482330322 End of App This is the end of the app logging, final timestamp


Query Debug - 293 Database Queries. Total time 0.2123 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00046896934509277
SELECT parameter, value FROM parameters
2 0.0011 0.0010719299316406
SELECT * FROM `bad_bots`
3 0.0003 0.00025796890258789
SET time_zone = 'Europe/London'
4 0.0009 0.00092911720275879
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00090193748474121
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0003 0.00029993057250977
UPDATE autorun SET lastrun = '2020-08-09 13:37:10' WHERE id = '15'
7 0.0002 0.00024700164794922
SELECT * FROM version ORDER BY installed DESC LIMIT 1
8 0.0005 0.00052881240844727
SELECT id FROM pages WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta' LIMIT 1
9 0.0004 0.00044107437133789
SELECT id FROM products WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta' AND hidden = 0 LIMIT 1
10 0.0008 0.00084710121154785
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
11 0.0075 0.0075469017028809
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
12 0.0002 0.00022196769714355
SELECT * FROM pages WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta'
13 0.0013 0.0012979507446289
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0013 0.0013411045074463
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0020 0.0019981861114502
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
16 0.0006 0.00063705444335938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
17 0.0005 0.00049710273742676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
18 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '26'
19 0.0019 0.0019450187683105
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0006 0.00059294700622559
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
21 0.0006 0.00063204765319824
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
22 0.0006 0.00064802169799805
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
23 0.0003 0.00027179718017578
SELECT * FROM categorygroups WHERE id = '1'
24 0.0006 0.00058817863464355
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
25 0.0002 0.00022101402282715
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
26 0.0003 0.00026679039001465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
27 0.0003 0.0002739429473877
SELECT id FROM categories WHERE parent_id = '27'
28 0.0009 0.00094079971313477
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
29 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
30 0.0003 0.00030279159545898
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
31 0.0002 0.00023818016052246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
32 0.0002 0.00024008750915527
SELECT * FROM categorygroups WHERE id = '1'
33 0.0008 0.00080394744873047
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
34 0.0002 0.0002281665802002
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
35 0.0002 0.00024700164794922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
36 0.0003 0.00033307075500488
SELECT id FROM categories WHERE parent_id = '28'
37 0.0008 0.00077986717224121
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0003 0.00026512145996094
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
39 0.0003 0.00028204917907715
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
40 0.0002 0.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
41 0.0002 0.00023889541625977
SELECT * FROM categorygroups WHERE id = '1'
42 0.0004 0.00035381317138672
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
43 0.0003 0.00026416778564453
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
44 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
45 0.0002 0.00023889541625977
SELECT id FROM categories WHERE parent_id = '29'
46 0.0004 0.00037288665771484
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
47 0.0004 0.00038504600524902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
48 0.0002 0.00020599365234375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
49 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
50 0.0002 0.00018501281738281
SELECT * FROM categorygroups WHERE id = '1'
51 0.0005 0.00053811073303223
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00022006034851074
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
53 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
54 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '30'
55 0.0006 0.00055909156799316
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
56 0.0002 0.00019717216491699
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
57 0.0002 0.00020313262939453
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
58 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
59 0.0002 0.00020790100097656
SELECT * FROM categorygroups WHERE id = '1'
60 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
61 0.0002 0.00023984909057617
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
62 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
63 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '31'
64 0.0004 0.00043702125549316
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
65 0.0003 0.00025010108947754
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
66 0.0002 0.0002281665802002
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
67 0.0002 0.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
68 0.0002 0.00020790100097656
SELECT * FROM categorygroups WHERE id = '1'
69 0.0004 0.00043106079101562
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
70 0.0003 0.0002741813659668
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 32
71 0.0002 0.00023317337036133
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
72 0.0002 0.00023412704467773
SELECT id FROM categories WHERE parent_id = '32'
73 0.0005 0.00045990943908691
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
74 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
75 0.0003 0.00026106834411621
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
76 0.0002 0.00020194053649902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
77 0.0002 0.00020909309387207
SELECT * FROM categorygroups WHERE id = '1'
78 0.0006 0.00057005882263184
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 33
79 0.0003 0.00029587745666504
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 33
80 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
81 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '33'
82 0.0005 0.00053000450134277
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00021100044250488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
84 0.0003 0.00027680397033691
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
85 0.0003 0.00026082992553711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
86 0.0003 0.00026607513427734
SELECT * FROM categorygroups WHERE id = '1'
87 0.0005 0.00047993659973145
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
88 0.0002 0.00023317337036133
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 34
89 0.0003 0.00032210350036621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
90 0.0003 0.00027680397033691
SELECT id FROM categories WHERE parent_id = '34'
91 0.0005 0.00052499771118164
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
92 0.0003 0.00031495094299316
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (34)
				  AND p.disabled = 0 
93 0.0003 0.00031495094299316
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (34)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
94 0.0003 0.00025486946105957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
95 0.0003 0.00025105476379395
SELECT * FROM categorygroups WHERE id = '1'
96 0.0011 0.0011270046234131
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
97 0.0009 0.00090384483337402
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
98 0.0004 0.00042819976806641
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
99 0.0007 0.00072693824768066
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
100 0.0005 0.00054788589477539
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
101 0.0928 0.092800140380859
SELECT * FROM ipgeocountries WHERE INET_ATON('35.172.233.2') >= INET_ATON(ip_start) AND INET_ATON('35.172.233.2') <= INET_ATON(ip_end)
102 0.0009 0.0009009838104248
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
103 0.0004 0.00037813186645508
SELECT * FROM countryredirects WHERE countrycode = 'US'
104 0.0002 0.00019693374633789
SELECT * FROM countryredirects WHERE id <> 1
105 0.0003 0.00027990341186523
SELECT * FROM products WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta'
106 0.0003 0.00026202201843262
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1667
107 0.0002 0.00021505355834961
SELECT * FROM manufacturers WHERE id = '257'
108 0.0002 0.00020885467529297
SELECT category_id FROM products_categories WHERE product_id = '1667'
109 0.0002 0.00020885467529297
SELECT * FROM categories WHERE id = '32'
110 0.0004 0.00039505958557129
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
111 0.0002 0.00019192695617676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
112 0.0002 0.00019288063049316
SELECT id FROM categories WHERE parent_id = '32'
113 0.0004 0.00040316581726074
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
114 0.0002 0.00017380714416504
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
115 0.0002 0.00021195411682129
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
116 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
117 0.0006 0.0005500316619873
SELECT * FROM productimages WHERE product_id = '1667' ORDER BY sortorder ASC
118 0.0003 0.00025200843811035
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1667' AND p.id = pi.product_id ORDER BY pi.sortorder
119 0.0004 0.00036120414733887
SELECT * FROM product_image_select WHERE product_id = '1667'
120 0.0003 0.00033092498779297
SELECT * FROM productcustomimages WHERE product_id = '1667'
121 0.0004 0.00035595893859863
SELECT * FROM productfeeds WHERE product_id = '1667' ORDER BY item_date DESC
122 0.0006 0.00059795379638672
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
123 0.0006 0.00056695938110352
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1667' AND t.hidden = 0 AND display_product = 1
124 0.0004 0.00037288665771484
SELECT * FROM productamazoncontent WHERE product_id = '1667'
125 0.0005 0.00045490264892578
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1667'
                GROUP BY o.product_id
126 0.0005 0.00053691864013672
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1667'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0002 0.00024008750915527
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1667
128 0.0005 0.0005190372467041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
129 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A3P5ROKL5A1OLE'
130 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '1667' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = 1667
                ORDER BY price ASC LIMIT 1
132 0.0002 0.00022411346435547
SELECT value FROM productattributes
                WHERE product_id = '1667'
                AND name = 'ListPriceAmount'
133 0.0002 0.00021004676818848
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1667'
                GROUP BY o.product_id
134 0.0002 0.00022482872009277
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1667'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 0.0002 0.00023388862609863
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1667
136 0.0003 0.00026297569274902
SELECT value FROM productattributes WHERE product_id = '1667' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0002 0.00023388862609863
SELECT * FROM products WHERE parent_id = '1667'
138 0.0003 0.00032305717468262
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
139 0.0003 0.00026106834411621
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
140 0.0004 0.00042080879211426
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
141 0.0003 0.00027108192443848
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
142 0.0002 0.00018501281738281
SELECT id FROM ebay_products WHERE itemid = '152644825676' 
143 0.0002 0.00019598007202148
SELECT id FROM ebay_products WHERE itemid = '224097804283' 
144 0.0002 0.00018906593322754
SELECT id FROM ebay_products WHERE itemid = '372687953200' 
145 0.0009 0.00091004371643066
INSERT INTO externalrequestlog (`type`, `wherefrom`, `url`, `parameters`, `successful`, `timetaken`, `appinstance`, `apprequesturi`) SELECT 'ebay', 'function searchProducts()', 'https://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsAdvanced&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-GB&SECURITY-APPNAME=CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=Brown+Sugar+Bear+Original+Brown+Sugar+Saver+and+Softener%2C+Terracotta&paginationInput.pageNumber=1&paginationInput.entriesPerPage=10&itemFilter(0).name=HideDuplicateItems&itemFilter(0).value=true&affiliate.trackingId=5338348474&affiliate.networkId=9', 'a:10:{s:9:\"ebayappid\";s:40:\"CareyBai-FreshLab-PRD-8c8e89b76-cd0afb12\";s:9:\"authtoken\";s:872:\"AgAAAA**AQAAAA**aAAAAA**nHudXg**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wJloekCJmCpwSdj6x9nY+seQ**vzUGAA**AAMAAA**0PcLL5IjXlYT4KWKSP6TQmbS1jHqlPkPchO3UmdfnXAnitHzji9pyoChVgnUmNrM6cTGqAIcJoboQONk44n/aqA4+MJT6ODp++3Nl7zFLIbn+RcglkVr4HF8aFEEVNILdX3erQzQIHSDmODv+QL1TpjPA7Csr13Tpin5QkS9bSNdmAV7rzZ6bR9ECHEYSSISh3XYw1ee0MzO0gx7yQ/w1vXwvi2OtBjuDDIZI71cBlReIsYC42CZgbLabTytchW7EVbdY/fsH2hrNI41ewUgntdf4dsPZ/wkfUBNx4alBE3jwzdbH0guT+B5EuUKblmxNvCZc/2Gzj7lX+79M9A8nRBXZJ5RARjabquo2jBCqAYzT/YGZWMMPWC7Y1C4Nd7lWEL36ii6fmC4z3qvrxar0ztEuMvbm4zRJpP+XmMhxjJ65q1fzcK8gHiSR5sp3C7S9cDN5xW+a6psHAf306B9WSvDk1k6JSwQDmG2DbZuEQmZqXQrjG1dLxB9IPKrN7Zg12DTwKoTU7+y4ITRzh6xJDz9DV9dA4imi9EnswineabPdD8/cReOZuNwp5zY6sl4HoAtttnqBH4M3xpj20prLHwyDv6pmWg0GtXedfLnISXCuVzODdKDGfl4W/GL8cy1UqXAwinzI9y0hlNhgeWB///rRY8OVk2huaGVRvdrf+2dhrZczeKT4fQ4E1qcaFeVWGwhUI6LLdEM8pVds6xUpRt2/z+HyLSHcVCrgCbrWphvWbpBQZweoWVtTBs3Tib5\";s:13:\"ebaynetworkid\";s:1:\"9\";s:14:\"ebaytrackingid\";s:10:\"5338348474\";s:19:\"googlerecaptchatype\";s:1:\"0\";s:15:\"googlesecretkey\";s:40:\"6LeE2Y8UAAAAAFJdEBXWuCq7RGueqpK1wBa3dZjT\";s:13:\"googlesitekey\";s:40:\"6LeE2Y8UAAAAAAy6cXScXGvVSQgPK-E5iV0dbTAk\";s:12:\"ebayglobalid\";s:7:\"EBAY-GB\";s:10:\"ebaysiteid\";s:1:\"3\";s:8:\"currency\";s:3:\"GBP\";}', '1', '0.3597149848938', '2c45c057b4be8dabe92ef77bd563cf19', 'https://store-uk.welovebears.club/brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta'
146 0.0016 0.0016160011291504
SELECT *, MATCH (description, title) AGAINST ('brown sugar' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('brown sugar' IN BOOLEAN MODE) AND 1667 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
147 0.0003 0.00031208992004395
SELECT *, MATCH (description, title) AGAINST ('brown sugar' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('brown sugar' IN BOOLEAN MODE) AND 1667 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
148 0.0002 0.00023794174194336
SELECT *, MATCH (description, title) AGAINST ('brown sugar' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('brown sugar' IN BOOLEAN MODE) AND 1667 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
149 0.0003 0.00034594535827637
SELECT * FROM productimages WHERE product_id = '1237' ORDER BY sortorder ASC
150 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '1237'
151 0.0002 0.0001990795135498
SELECT * FROM productcustomimages WHERE product_id = '1237'
152 0.0008 0.00080513954162598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname
153 0.0002 0.00024604797363281
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A3P5ROKL5A1OLE'
154 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '1237' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0003 0.00030612945556641
SELECT value FROM productattributes WHERE product_id = '1237' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0014 0.0014200210571289
SELECT *, MATCH (description, title) AGAINST ('saver and softener' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('saver and softener' IN BOOLEAN MODE) AND 1667 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
157 0.0004 0.00037002563476562
SELECT *, MATCH (description, title) AGAINST ('saver and softener' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('saver and softener' IN BOOLEAN MODE) AND 1667 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
158 0.0004 0.00035691261291504
SELECT *, MATCH (description, title) AGAINST ('saver and softener' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('saver and softener' IN BOOLEAN MODE) AND 1667 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
159 0.0041 0.004082202911377
SELECT *, MATCH (description, title) AGAINST ('softener terracotta' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('softener terracotta' IN BOOLEAN MODE) AND 1667 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
160 0.0005 0.00045299530029297
SELECT *, MATCH (description, title) AGAINST ('softener terracotta' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('softener terracotta' IN BOOLEAN MODE) AND 1667 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
161 0.0003 0.00028109550476074
SELECT *, MATCH (description, title) AGAINST ('softener terracotta' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('softener terracotta' IN BOOLEAN MODE) AND 1667 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
162 0.0004 0.00041985511779785
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1667') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
163 0.0011 0.0011131763458252
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '32' AND pc.prod_type = 'amz'  AND p.id <> '1667' ORDER BY RAND()
164 0.0003 0.00028896331787109
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '32' AND pc.prod_type = 'ebay' AND p.id <> '1667' ORDER BY RAND()
165 0.0002 0.00023293495178223
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '32' AND pc.prod_type = 'custom' AND p.id <> '1667' ORDER BY RAND()
166 0.0003 0.00025796890258789
SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC
167 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '1669'
168 0.0002 0.00021696090698242
SELECT * FROM productcustomimages WHERE product_id = '1669'
169 0.0006 0.00063586235046387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
170 0.0003 0.00025820732116699
SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A3P5ROKL5A1OLE'
171 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00025701522827148
SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'
174 0.0003 0.00025105476379395
SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '1664' ORDER BY sortorder ASC
176 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '1664'
177 0.0002 0.0001828670501709
SELECT * FROM productcustomimages WHERE product_id = '1664'
178 0.0008 0.00076889991760254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1664' AND a.name = n.originalname
179 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '1664' AND merchantid = 'A3P5ROKL5A1OLE'
180 0.0002 0.00023317337036133
SELECT * FROM productoffers
                WHERE product_id = '1664' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = 1664
                ORDER BY price ASC LIMIT 1
182 0.0002 0.00024080276489258
SELECT value FROM productattributes
                WHERE product_id = '1664'
                AND name = 'ListPriceAmount'
183 0.0002 0.000244140625
SELECT id,asin FROM products WHERE parent_id = 1667
184 0.0007 0.00072503089904785
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1667' ORDER BY timestamp DESC
185 0.0002 0.00022196769714355
SELECT category_id FROM products_categories WHERE product_id = '1667'
186 0.0002 0.00022196769714355
SELECT * FROM categories WHERE id = '32'
187 0.0004 0.00040602684020996
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
188 0.0002 0.00022387504577637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
189 0.0003 0.00026321411132812
SELECT id FROM categories WHERE parent_id = '32'
190 0.0004 0.00040793418884277
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
191 0.0002 0.00021696090698242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
192 0.0003 0.00025796890258789
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
193 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
194 0.0005 0.00053191184997559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
195 0.0002 0.00022792816162109
SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A3P5ROKL5A1OLE'
196 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '1667' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0002 0.00020480155944824
SELECT * FROM productoffers
                WHERE product_id = 1667
                ORDER BY price ASC LIMIT 1
198 0.0004 0.0003819465637207
SELECT value FROM productattributes
                WHERE product_id = '1667'
                AND name = 'ListPriceAmount'
199 0.0005 0.0004570484161377
SELECT * FROM products WHERE id = '1667'
200 0.0004 0.00037097930908203
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1667'
                GROUP BY o.product_id
201 0.0004 0.0003821849822998
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1667'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
202 0.0003 0.00030994415283203
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1667
203 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '1667' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0017 0.0017070770263672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
205 0.0004 0.00036883354187012
SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A3P5ROKL5A1OLE'
206 0.0003 0.00034093856811523
SELECT * FROM productoffers
                WHERE product_id = '1667' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = 1667
                ORDER BY price ASC LIMIT 1
208 0.0004 0.00038480758666992
SELECT value FROM productattributes
                WHERE product_id = '1667'
                AND name = 'ListPriceAmount'
209 0.0003 0.00029087066650391
SELECT category_id FROM products_categories WHERE product_id = '1667' AND prod_type = 'amz'
210 0.0003 0.00027203559875488
SELECT parent_id FROM categories WHERE id = '32'
211 0.0003 0.0003211498260498
SELECT * FROM categories WHERE id = '32'
212 0.0007 0.0007011890411377
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
213 0.0002 0.00021195411682129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
214 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '32'
215 0.0004 0.00043916702270508
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
216 0.0002 0.00023412704467773
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
217 0.0002 0.00022578239440918
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
218 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
219 0.0008 0.0007939338684082
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
220 0.0007 0.00073099136352539
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
221 0.0002 0.00023293495178223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
222 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = 42
223 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = 55
224 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = 45
225 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = 51
226 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = 42
227 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = 37
228 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = 44
229 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = 53
230 0.0007 0.00072789192199707
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
231 0.0003 0.00025701522827148
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:0:\"\";s:8:\"maxprice\";s:0:\"\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:3:\"all\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1596980230;s:8:\"products\";a:6:{i:0;s:10:\"739|amazon\";i:1;s:10:\"745|amazon\";i:2;s:10:\"751|amazon\";i:3;s:10:\"755|amazon\";i:4;s:10:\"769|amazon\";i:5;s:11:\"1229|amazon\";}}' WHERE id = '244'
232 0.0002 0.0002281665802002
SELECT * FROM products WHERE id = 739
233 0.0002 0.00022006034851074
SELECT * FROM products WHERE id = 745
234 0.0002 0.00021886825561523
SELECT * FROM products WHERE id = 751
235 0.0002 0.00023889541625977
SELECT * FROM products WHERE id = 755
236 0.0002 0.00024199485778809
SELECT * FROM products WHERE id = 769
237 0.0002 0.00024008750915527
SELECT * FROM products WHERE id = 1229
238 0.0002 0.00024104118347168
SELECT * FROM products WHERE id = '739'
239 0.0002 0.00024700164794922
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
240 0.0002 0.00019717216491699
SELECT * FROM product_image_select WHERE product_id = '739'
241 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '739'
242 0.0006 0.00058794021606445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
243 0.0002 0.00021505355834961
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
244 0.0002 0.00024914741516113
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0002 0.00022387504577637
SELECT * FROM products WHERE id = '745'
247 0.0004 0.00036787986755371
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
248 0.0002 0.00019693374633789
SELECT * FROM product_image_select WHERE product_id = '745'
249 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '745'
250 0.0005 0.00050997734069824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
251 0.0002 0.00021100044250488
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
252 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0002 0.00024986267089844
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0002 0.00024604797363281
SELECT * FROM products WHERE id = '751'
255 0.0003 0.00031208992004395
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
256 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '751'
257 0.0002 0.00020217895507812
SELECT * FROM productcustomimages WHERE product_id = '751'
258 0.0003 0.00031518936157227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
259 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
260 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0002 0.00022292137145996
SELECT * FROM products WHERE id = '755'
263 0.0002 0.00024509429931641
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
264 0.0002 0.00019598007202148
SELECT * FROM product_image_select WHERE product_id = '755'
265 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '755'
266 0.0006 0.00060415267944336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
267 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
268 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0003 0.00030684471130371
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0002 0.00022315979003906
SELECT * FROM products WHERE id = '769'
271 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
272 0.0002 0.00019693374633789
SELECT * FROM product_image_select WHERE product_id = '769'
273 0.0002 0.00018095970153809
SELECT * FROM productcustomimages WHERE product_id = '769'
274 0.0005 0.0005190372467041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
275 0.0002 0.0002129077911377
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
276 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
277 0.0003 0.00026798248291016
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0002 0.00024819374084473
SELECT * FROM products WHERE id = '1229'
279 0.0003 0.0003349781036377
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
280 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '1229'
281 0.0002 0.00017690658569336
SELECT * FROM productcustomimages WHERE product_id = '1229'
282 0.0006 0.00055098533630371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
283 0.0002 0.00023317337036133
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
284 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0009 0.00091290473937988
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
287 0.0004 0.00035595893859863
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
288 0.0013 0.0012638568878174
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
289 0.0008 0.00078797340393066
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
290 0.0003 0.00031208992004395
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
291 0.0005 0.00048112869262695
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
292 0.0003 0.00032687187194824
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
293 0.0003 0.00034308433532715
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'