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

25 Day(s) 7 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

5 Day(s) 3 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

15 Day(s) 19 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.89725518226624 291 0.3123 0


No Amazon API Requests Made.

Total time 0.89725518226624 seconds

Number Time From Start Name Description
1 0.16527104377747 Initialise Initialise FSB Function
2 0.16748213768005 App Controller Start Start of the App controller (called before the controller of every page)
3 0.18312621116638 Start of getCategoryListByGroup Function Before first category groups query
4 0.1843090057373 After initial query Before first category groups query
5 0.18431115150452 Get Category List for Group Before the call to getCategoryList function
6 0.18431401252747 Start of GetCategoryList function Start of the function
7 0.18431711196899 Before getting categories Query to get specific category list
8 0.18546319007874 After getting categories Query to get specific category list
9 0.18546414375305 Before getting category custom Before call to function getCategoryCustom
10 0.19547414779663 After getting category custom After call to function getCategoryCustom
11 0.19547700881958 Before getting category custom Before call to function getCategoryCustom
12 0.19880604743958 After getting category custom After call to function getCategoryCustom
13 0.1988091468811 Before getting category custom Before call to function getCategoryCustom
14 0.20206308364868 After getting category custom After call to function getCategoryCustom
15 0.20206499099731 Before getting category custom Before call to function getCategoryCustom
16 0.20453500747681 After getting category custom After call to function getCategoryCustom
17 0.20453715324402 Before getting category custom Before call to function getCategoryCustom
18 0.20758318901062 After getting category custom After call to function getCategoryCustom
19 0.20758700370789 Before getting category custom Before call to function getCategoryCustom
20 0.21124720573425 After getting category custom After call to function getCategoryCustom
21 0.21125102043152 Before getting category custom Before call to function getCategoryCustom
22 0.21421003341675 After getting category custom After call to function getCategoryCustom
23 0.21421217918396 Before getting category custom Before call to function getCategoryCustom
24 0.21650409698486 After getting category custom After call to function getCategoryCustom
25 0.2165060043335 Before getting category custom Before call to function getCategoryCustom
26 0.21984100341797 After getting category custom After call to function getCategoryCustom
27 0.21984505653381 End of GetCategoryList function End of the function
28 0.21985721588135 End of getCategoryListByGroup Function Before return()
29 0.31628513336182 App Controller End End of the App controller (called before the controller of every page)
30 0.316819190979 Product Start Start of the product info controller
31 0.31780600547791 Cache file not found Starting get product details
32 0.33762311935425 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.73450207710266 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.73766303062439 Related products Start getting related products if enabled
35 0.73766613006592 Related Products Start Before the related products are found
36 0.73766708374023 Related Products Keywords Before the related product keywords are found
37 0.73767518997192 Create Keyword List Function Start of function
38 0.73791313171387 Create Keyword List Function After looping provided content - 24 keywords found
39 0.74076414108276 Create Keyword List Function After looping initial keyword list - 23 keywords remaining
40 0.74078416824341 Create Keyword List Function After reducing keyword list
41 0.74113321304321 Create Keyword List Function After selecting by scoring keywords
42 0.74114012718201 Create Keyword List Function After final loop of keywords
43 0.74115300178528 Related Products Keywords After the related product keywords are found
44 0.83008313179016 Related Products End After the related products are found
45 0.8453471660614 Product End End of the product info controller (Product Info)
46 0.84731698036194 App_after Controller Start Start of the App_after controller (called after the controller of every page)
47 0.84912300109863 Before Get Options Before the call to getOptions in the tpl class
48 0.87892699241638 After Get Options After the call to getOptions in the tpl class
49 0.87908720970154 App_after Controller End End of the App_after controller (called after the controller of every page)
50 0.87913203239441 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
51 0.88732099533081 Product Info: After Smarty Fetch After the product.tpl template is fetched
52 0.88732504844666 Product Info: Before Template Display Before the template is displayed
53 0.89723801612854 Product Info: After Template Display After the template is displayed
54 0.8972430229187 Finalizing debug Before the debug is output to the page.
55 0.89725399017334 End of App This is the end of the app logging, final timestamp


Query Debug - 291 Database Queries. Total time 0.3123 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.00090885162353516
SELECT parameter, value FROM parameters
2 0.0057 0.0057060718536377
SELECT * FROM `bad_bots`
3 0.0003 0.00032687187194824
SET time_zone = 'Europe/London'
4 0.0022 0.0022079944610596
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0010981559753418
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0003 0.00027298927307129
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0007 0.0006718635559082
SELECT id FROM pages WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta' LIMIT 1
8 0.0009 0.00086283683776855
SELECT id FROM products WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta' AND hidden = 0 LIMIT 1
9 0.0012 0.001154899597168
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
10 0.0130 0.012978076934814
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
11 0.0003 0.00027894973754883
SELECT * FROM pages WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta'
12 0.0012 0.001166820526123
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0011 0.0010931491851807
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0025 0.0024569034576416
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
15 0.0011 0.0010628700256348
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
16 0.0012 0.00124192237854
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
17 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '26'
18 0.0015 0.0015208721160889
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 
19 0.0011 0.0011358261108398
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 
20 0.0010 0.0010190010070801
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
21 0.0009 0.00094199180603027
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
22 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
23 0.0007 0.0007178783416748
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
24 0.0003 0.00027894973754883
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
25 0.0002 0.00022602081298828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0002 0.00023889541625977
SELECT id FROM categories WHERE parent_id = '27'
27 0.0008 0.00080418586730957
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 
28 0.0003 0.00025582313537598
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 
29 0.0002 0.00024700164794922
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
30 0.0002 0.00023698806762695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0002 0.00023579597473145
SELECT * FROM categorygroups WHERE id = '1'
32 0.0007 0.00074100494384766
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
33 0.0003 0.00027084350585938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
34 0.0002 0.00023102760314941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '28'
36 0.0007 0.00073790550231934
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 
37 0.0002 0.00023198127746582
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 
38 0.0003 0.00027203559875488
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
39 0.0002 0.00023484230041504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0002 0.00023603439331055
SELECT * FROM categorygroups WHERE id = '1'
41 0.0004 0.00036287307739258
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
42 0.0003 0.00027179718017578
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
43 0.0002 0.00022602081298828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '29'
45 0.0004 0.00038719177246094
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 
46 0.0002 0.00023913383483887
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 
47 0.0003 0.00026178359985352
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
48 0.0002 0.0001988410949707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0002 0.00024700164794922
SELECT * FROM categorygroups WHERE id = '1'
50 0.0007 0.00072908401489258
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
51 0.0003 0.0002739429473877
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
52 0.0002 0.00024700164794922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0002 0.00022387504577637
SELECT id FROM categories WHERE parent_id = '30'
54 0.0006 0.00055193901062012
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 
55 0.0002 0.00018906593322754
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 
56 0.0002 0.0002129077911377
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
57 0.0002 0.00024795532226562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0003 0.0002589225769043
SELECT * FROM categorygroups WHERE id = '1'
59 0.0007 0.00066399574279785
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
60 0.0003 0.00032901763916016
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
61 0.0003 0.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0003 0.00029897689819336
SELECT id FROM categories WHERE parent_id = '31'
63 0.0007 0.00072479248046875
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 
64 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 (31)
				  AND p.disabled = 0 
65 0.0003 0.00033807754516602
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
66 0.0003 0.0002748966217041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0003 0.00029182434082031
SELECT * FROM categorygroups WHERE id = '1'
68 0.0007 0.00070309638977051
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
69 0.0004 0.0003819465637207
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 32
70 0.0003 0.00027608871459961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
71 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '32'
72 0.0005 0.00045204162597656
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 
73 0.0002 0.00020408630371094
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 
74 0.0002 0.0002129077911377
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
75 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
76 0.0002 0.00019502639770508
SELECT * FROM categorygroups WHERE id = '1'
77 0.0004 0.00037693977355957
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
78 0.0002 0.00020813941955566
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 33
79 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
80 0.0002 0.00019383430480957
SELECT id FROM categories WHERE parent_id = '33'
81 0.0004 0.00040507316589355
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 
82 0.0002 0.00020217895507812
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 
83 0.0002 0.0002140998840332
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
84 0.0002 0.0002140998840332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
85 0.0002 0.00020098686218262
SELECT * FROM categorygroups WHERE id = '1'
86 0.0004 0.0003819465637207
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
87 0.0003 0.00031900405883789
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 34
88 0.0003 0.0002739429473877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
89 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '34'
90 0.0007 0.00069594383239746
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 
91 0.0003 0.00030303001403809
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 
92 0.0004 0.00036191940307617
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
93 0.0003 0.0002748966217041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
94 0.0003 0.00029802322387695
SELECT * FROM categorygroups WHERE id = '1'
95 0.0020 0.0020320415496826
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
96 0.0016 0.0015640258789062
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
97 0.0008 0.00076508522033691
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
98 0.0017 0.0016558170318604
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
99 0.0008 0.00080609321594238
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
100 0.0845 0.08446192741394
SELECT * FROM ipgeocountries WHERE INET_ATON('3.80.160.29') >= INET_ATON(ip_start) AND INET_ATON('3.80.160.29') <= INET_ATON(ip_end)
101 0.0014 0.001446008682251
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
102 0.0012 0.0011899471282959
SELECT * FROM countryredirects WHERE countrycode = 'US'
103 0.0003 0.00027704238891602
SELECT * FROM countryredirects WHERE id <> 1
104 0.0003 0.00034189224243164
SELECT * FROM products WHERE pagename = 'brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta'
105 0.0003 0.00030803680419922
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1667
106 0.0002 0.000244140625
SELECT * FROM manufacturers WHERE id = '257'
107 0.0002 0.00022196769714355
SELECT category_id FROM products_categories WHERE product_id = '1667'
108 0.0003 0.00032591819763184
SELECT * FROM categories WHERE id = '32'
109 0.0005 0.00045013427734375
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
110 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
111 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '32'
112 0.0004 0.00042986869812012
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 
113 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 (32)
				  AND p.disabled = 0 
114 0.0002 0.00021100044250488
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
115 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
116 0.0011 0.0011081695556641
SELECT * FROM productimages WHERE product_id = '1667' ORDER BY sortorder ASC
117 0.0003 0.00026893615722656
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
118 0.0010 0.0010371208190918
SELECT * FROM product_image_select WHERE product_id = '1667'
119 0.0010 0.0010099411010742
SELECT * FROM productcustomimages WHERE product_id = '1667'
120 0.0006 0.00059795379638672
SELECT * FROM productfeeds WHERE product_id = '1667' ORDER BY item_date DESC
121 0.0023 0.0022900104522705
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
122 0.0011 0.0011191368103027
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
123 0.0011 0.0011100769042969
SELECT * FROM productamazoncontent WHERE product_id = '1667'
124 0.0013 0.0013301372528076
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
125 0.0025 0.0025451183319092
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
126 0.0002 0.00023508071899414
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
127 0.0005 0.00053000450134277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
128 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A3P5ROKL5A1OLE'
129 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '1667' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = 1667
                ORDER BY price ASC LIMIT 1
131 0.0002 0.0002288818359375
SELECT value FROM productattributes
                WHERE product_id = '1667'
                AND name = 'ListPriceAmount'
132 0.0002 0.00022101402282715
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
133 0.0003 0.00025320053100586
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
134 0.0002 0.00022006034851074
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
135 0.0003 0.00025486946105957
SELECT value FROM productattributes WHERE product_id = '1667' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0002 0.00020194053649902
SELECT * FROM products WHERE parent_id = '1667'
137 0.0003 0.00030803680419922
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
138 0.0003 0.00026798248291016
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.0004 0.00043392181396484
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
140 0.0003 0.00028586387634277
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
141 0.0004 0.00044894218444824
SELECT id FROM ebay_products WHERE itemid = '152644825676' 
142 0.0003 0.00025200843811035
SELECT id FROM ebay_products WHERE itemid = '372687953200' 
143 0.0002 0.00020384788513184
SELECT id FROM ebay_products WHERE itemid = '363027902821' 
144 0.0009 0.00088405609130859
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.39689183235168', 'b23912457c351b80179051acfe22b593', 'https://store-uk.welovebears.club/brown-sugar-bear-original-brown-sugar-saver-and-softener-terracotta/'
145 0.0017 0.0017189979553223
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
146 0.0004 0.00036382675170898
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
147 0.0003 0.00034499168395996
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
148 0.0009 0.00094723701477051
SELECT * FROM productimages WHERE product_id = '1237' ORDER BY sortorder ASC
149 0.0003 0.00034904479980469
SELECT * FROM product_image_select WHERE product_id = '1237'
150 0.0002 0.00024104118347168
SELECT * FROM productcustomimages WHERE product_id = '1237'
151 0.0036 0.0036089420318604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname
152 0.0003 0.00032186508178711
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A3P5ROKL5A1OLE'
153 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = '1237' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0005 0.00054216384887695
SELECT value FROM productattributes WHERE product_id = '1237' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0040 0.0039918422698975
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
156 0.0004 0.00044488906860352
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
157 0.0003 0.00034999847412109
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
158 0.0040 0.0040061473846436
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
159 0.0005 0.00045919418334961
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
160 0.0003 0.00025200843811035
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
161 0.0004 0.00038599967956543
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
162 0.0011 0.0011260509490967
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()
163 0.0003 0.00028610229492188
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()
164 0.0004 0.00041389465332031
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()
165 0.0004 0.00044107437133789
SELECT * FROM productimages WHERE product_id = '741' ORDER BY sortorder ASC
166 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '741'
167 0.0002 0.00018882751464844
SELECT * FROM productcustomimages WHERE product_id = '741'
168 0.0005 0.00053620338439941
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '741' AND a.name = n.originalname
169 0.0002 0.00022792816162109
SELECT * FROM productoffers WHERE product_id = '741' AND merchantid = 'A3P5ROKL5A1OLE'
170 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '741' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = 741
                ORDER BY price ASC LIMIT 1
172 0.0002 0.00021004676818848
SELECT value FROM productattributes
                WHERE product_id = '741'
                AND name = 'ListPriceAmount'
173 0.0002 0.00023007392883301
SELECT value FROM productattributes WHERE product_id = '741' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0005 0.00047397613525391
SELECT * FROM productimages WHERE product_id = '1665' ORDER BY sortorder ASC
175 0.0003 0.00032496452331543
SELECT * FROM product_image_select WHERE product_id = '1665'
176 0.0003 0.00029611587524414
SELECT * FROM productcustomimages WHERE product_id = '1665'
177 0.0014 0.0014331340789795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1665' AND a.name = n.originalname
178 0.0003 0.0003349781036377
SELECT * FROM productoffers WHERE product_id = '1665' AND merchantid = 'A3P5ROKL5A1OLE'
179 0.0612 0.061187982559204
SELECT * FROM productoffers
                WHERE product_id = '1665' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00039315223693848
SELECT value FROM productattributes WHERE product_id = '1665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0003 0.0003199577331543
SELECT id,asin FROM products WHERE parent_id = 1667
182 0.0013 0.0012729167938232
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1667' ORDER BY timestamp DESC
183 0.0003 0.00034809112548828
SELECT category_id FROM products_categories WHERE product_id = '1667'
184 0.0004 0.00036215782165527
SELECT * FROM categories WHERE id = '32'
185 0.0005 0.00046110153198242
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
186 0.0002 0.00024604797363281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
187 0.0003 0.00032186508178711
SELECT id FROM categories WHERE parent_id = '32'
188 0.0007 0.00067400932312012
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 
189 0.0003 0.00029492378234863
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 
190 0.0003 0.00030612945556641
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
191 0.0002 0.00024509429931641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
192 0.0012 0.0012409687042236
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
193 0.0003 0.00033187866210938
SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A3P5ROKL5A1OLE'
194 0.0003 0.00033092498779297
SELECT * FROM productoffers
                WHERE product_id = '1667' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = 1667
                ORDER BY price ASC LIMIT 1
196 0.0003 0.00034093856811523
SELECT value FROM productattributes
                WHERE product_id = '1667'
                AND name = 'ListPriceAmount'
197 0.0004 0.00035619735717773
SELECT * FROM products WHERE id = '1667'
198 0.0004 0.0003809928894043
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
199 0.0004 0.0003819465637207
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
200 0.0003 0.0003209114074707
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
201 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '1667' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0009 0.00091195106506348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
203 0.0003 0.00029301643371582
SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A3P5ROKL5A1OLE'
204 0.0003 0.0003049373626709
SELECT * FROM productoffers
                WHERE product_id = '1667' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0003 0.00028705596923828
SELECT * FROM productoffers
                WHERE product_id = 1667
                ORDER BY price ASC LIMIT 1
206 0.0003 0.00029897689819336
SELECT value FROM productattributes
                WHERE product_id = '1667'
                AND name = 'ListPriceAmount'
207 0.0003 0.00027298927307129
SELECT category_id FROM products_categories WHERE product_id = '1667' AND prod_type = 'amz'
208 0.0003 0.00026702880859375
SELECT parent_id FROM categories WHERE id = '32'
209 0.0003 0.00028705596923828
SELECT * FROM categories WHERE id = '32'
210 0.0006 0.00059008598327637
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
211 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
212 0.0002 0.00024008750915527
SELECT id FROM categories WHERE parent_id = '32'
213 0.0006 0.00064206123352051
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 
214 0.0003 0.00025606155395508
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 
215 0.0003 0.00026798248291016
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
216 0.0002 0.00019288063049316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
217 0.0014 0.0014231204986572
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
218 0.0014 0.0013730525970459
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
219 0.0003 0.00027894973754883
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
220 0.0003 0.00025010108947754
SELECT * FROM pages WHERE id = 42
221 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = 55
222 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = 45
223 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = 51
224 0.0002 0.00022387504577637
SELECT * FROM pages WHERE id = 42
225 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = 37
226 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = 44
227 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = 53
228 0.0008 0.00075888633728027
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
229 0.0003 0.00027704238891602
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:1596706842;s:8:\"products\";a:6:{i:0;s:10:\"739|amazon\";i:1;s:10:\"740|amazon\";i:2;s:10:\"745|amazon\";i:3;s:10:\"751|amazon\";i:4;s:10:\"755|amazon\";i:5;s:10:\"769|amazon\";}}' WHERE id = '244'
230 0.0003 0.00026082992553711
SELECT * FROM products WHERE id = 739
231 0.0003 0.00025606155395508
SELECT * FROM products WHERE id = 740
232 0.0002 0.00023794174194336
SELECT * FROM products WHERE id = 745
233 0.0003 0.00025200843811035
SELECT * FROM products WHERE id = 751
234 0.0003 0.00027084350585938
SELECT * FROM products WHERE id = 755
235 0.0003 0.00025677680969238
SELECT * FROM products WHERE id = 769
236 0.0003 0.00025200843811035
SELECT * FROM products WHERE id = '739'
237 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
238 0.0003 0.00025105476379395
SELECT * FROM product_image_select WHERE product_id = '739'
239 0.0002 0.00022292137145996
SELECT * FROM productcustomimages WHERE product_id = '739'
240 0.0009 0.00091695785522461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
241 0.0003 0.0002899169921875
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
242 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0003 0.00034308433532715
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0003 0.00032901763916016
SELECT * FROM products WHERE id = '740'
245 0.0003 0.00034618377685547
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
246 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '740'
247 0.0002 0.00024509429931641
SELECT * FROM productcustomimages WHERE product_id = '740'
248 0.0006 0.00063514709472656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
249 0.0003 0.00029802322387695
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'A3P5ROKL5A1OLE'
250 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0003 0.00034594535827637
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = '745'
253 0.0003 0.00034093856811523
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
254 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '745'
255 0.0002 0.00021600723266602
SELECT * FROM productcustomimages WHERE product_id = '745'
256 0.0008 0.00084018707275391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
257 0.0003 0.00029206275939941
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
258 0.0003 0.00030112266540527
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
259 0.0004 0.00035214424133301
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0003 0.00031399726867676
SELECT * FROM products WHERE id = '751'
261 0.0004 0.00037884712219238
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
262 0.0003 0.00025510787963867
SELECT * FROM product_image_select WHERE product_id = '751'
263 0.0002 0.00024008750915527
SELECT * FROM productcustomimages WHERE product_id = '751'
264 0.0004 0.0004429817199707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
265 0.0003 0.00028300285339355
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
266 0.0003 0.00027990341186523
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0003 0.00032997131347656
SELECT * FROM products WHERE id = '755'
269 0.0003 0.00029706954956055
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
270 0.0003 0.00027608871459961
SELECT * FROM product_image_select WHERE product_id = '755'
271 0.0002 0.00023484230041504
SELECT * FROM productcustomimages WHERE product_id = '755'
272 0.0010 0.00098204612731934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
273 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
274 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0003 0.00034403800964355
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276 0.0003 0.00028514862060547
SELECT * FROM products WHERE id = '769'
277 0.0003 0.00030112266540527
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
278 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '769'
279 0.0002 0.00023388862609863
SELECT * FROM productcustomimages WHERE product_id = '769'
280 0.0007 0.00069499015808105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
281 0.0003 0.00031614303588867
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
282 0.0003 0.00026988983154297
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0003 0.00032782554626465
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284 0.0016 0.0015959739685059
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
285 0.0005 0.0004880428314209
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
286 0.0020 0.0020458698272705
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
287 0.0011 0.0011379718780518
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
288 0.0005 0.00048303604125977
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
289 0.0009 0.00088787078857422
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
290 0.0007 0.00069284439086914
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
291 0.0008 0.00077295303344727
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'