Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
Concord bear patch towel Parent
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Concord bear patch towel Parent

Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-08-04 01:43:25 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.

Manufacturer Description

Bear Dish towel parent

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 with tags

15 Day(s) 8 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

15 Day(s) 8 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

15 Day(s) 8 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

7 Day(s) 5 h(s)
Worldwide

N/A

No Returns

Buy it Now

New with tags

15 Day(s) 8 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
1.1876330375671 304 0.1813 0


No Amazon API Requests Made.

Total time 1.1876330375671 seconds

Number Time From Start Name Description
1 0.13251686096191 Initialise Initialise FSB Function
2 0.13519191741943 App Controller Start Start of the App controller (called before the controller of every page)
3 0.14885687828064 Start of getCategoryListByGroup Function Before first category groups query
4 0.14979791641235 After initial query Before first category groups query
5 0.14980006217957 Get Category List for Group Before the call to getCategoryList function
6 0.14980506896973 Start of GetCategoryList function Start of the function
7 0.14981007575989 Before getting categories Query to get specific category list
8 0.15044498443604 After getting categories Query to get specific category list
9 0.15044593811035 Before getting category custom Before call to function getCategoryCustom
10 0.15701484680176 After getting category custom After call to function getCategoryCustom
11 0.15702104568481 Before getting category custom Before call to function getCategoryCustom
12 0.15997791290283 After getting category custom After call to function getCategoryCustom
13 0.15998291969299 Before getting category custom Before call to function getCategoryCustom
14 0.16319489479065 After getting category custom After call to function getCategoryCustom
15 0.16319799423218 Before getting category custom Before call to function getCategoryCustom
16 0.16567206382751 After getting category custom After call to function getCategoryCustom
17 0.16567707061768 Before getting category custom Before call to function getCategoryCustom
18 0.16935396194458 After getting category custom After call to function getCategoryCustom
19 0.16935586929321 Before getting category custom Before call to function getCategoryCustom
20 0.17170095443726 After getting category custom After call to function getCategoryCustom
21 0.1717050075531 Before getting category custom Before call to function getCategoryCustom
22 0.17417001724243 After getting category custom After call to function getCategoryCustom
23 0.17417287826538 Before getting category custom Before call to function getCategoryCustom
24 0.17895603179932 After getting category custom After call to function getCategoryCustom
25 0.17895889282227 Before getting category custom Before call to function getCategoryCustom
26 0.18170094490051 After getting category custom After call to function getCategoryCustom
27 0.18170404434204 End of GetCategoryList function End of the function
28 0.18171691894531 End of getCategoryListByGroup Function Before return()
29 0.24252891540527 App Controller End End of the App controller (called before the controller of every page)
30 0.24303197860718 Product Start Start of the product info controller
31 0.24388194084167 Cache file not found Starting get product details
32 0.26666808128357 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.69095587730408 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.69312286376953 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
35 1.1202108860016 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
36 1.1222369670868 Related products Start getting related products if enabled
37 1.1222388744354 Related Products Start Before the related products are found
38 1.1222400665283 Related Products Keywords Before the related product keywords are found
39 1.1222479343414 Create Keyword List Function Start of function
40 1.1224310398102 Create Keyword List Function After looping provided content - 12 keywords found
41 1.122750043869 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
42 1.1227600574493 Create Keyword List Function After reducing keyword list
43 1.1227769851685 Create Keyword List Function After selecting by scoring keywords
44 1.1227810382843 Create Keyword List Function After final loop of keywords
45 1.1227819919586 Related Products Keywords After the related product keywords are found
46 1.1380188465118 Related Products End After the related products are found
47 1.148777961731 Product End End of the product info controller (Product Info)
48 1.1499838829041 App_after Controller Start Start of the App_after controller (called after the controller of every page)
49 1.1507248878479 Before Get Options Before the call to getOptions in the tpl class
50 1.1725208759308 After Get Options After the call to getOptions in the tpl class
51 1.1726388931274 App_after Controller End End of the App_after controller (called after the controller of every page)
52 1.1726679801941 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
53 1.1791269779205 Product Info: After Smarty Fetch After the product.tpl template is fetched
54 1.1791310310364 Product Info: Before Template Display Before the template is displayed
55 1.1876180171967 Product Info: After Template Display After the template is displayed
56 1.1876230239868 Finalizing debug Before the debug is output to the page.
57 1.1876318454742 End of App This is the end of the app logging, final timestamp


Query Debug - 304 Database Queries. Total time 0.1813 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00039315223693848
SELECT parameter, value FROM parameters
2 0.0013 0.0012979507446289
SELECT * FROM `bad_bots`
3 0.0003 0.00026202201843262
SET time_zone = 'Europe/London'
4 0.0013 0.0012738704681396
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0013 0.0013010501861572
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0004 0.00041890144348145
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0008 0.00080299377441406
SELECT id FROM pages WHERE pagename = 'concord-bear-patch-towel-parent' LIMIT 1
8 0.0007 0.00073623657226562
SELECT id FROM products WHERE pagename = 'concord-bear-patch-towel-parent' AND hidden = 0 LIMIT 1
9 0.0017 0.0016858577728271
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
10 0.0100 0.010031938552856
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
11 0.0004 0.00037789344787598
SELECT * FROM pages WHERE pagename = 'concord-bear-patch-towel-parent'
12 0.0009 0.00092291831970215
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0006 0.00057601928710938
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0016 0.0016438961029053
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.0008 0.000823974609375
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.0004 0.00037312507629395
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.0017 0.001680850982666
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.0007 0.00067591667175293
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.0004 0.00040102005004883
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.0004 0.00036215782165527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
22 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
23 0.0005 0.00053596496582031
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.00028491020202637
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.00017809867858887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '27'
27 0.0006 0.00058698654174805
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.00027990341186523
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.0003 0.0002899169921875
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.00024604797363281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0002 0.00023889541625977
SELECT * FROM categorygroups WHERE id = '1'
32 0.0007 0.0006721019744873
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.0002 0.00022292137145996
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.0003 0.00025081634521484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '28'
36 0.0007 0.00073003768920898
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.0003 0.00026893615722656
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.0002 0.00024199485778809
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.00024986267089844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0003 0.00025486946105957
SELECT * FROM categorygroups WHERE id = '1'
41 0.0004 0.0003960132598877
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.00034594535827637
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.0003 0.0002589225769043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '29'
45 0.0003 0.00034403800964355
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.00021004676818848
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.0002 0.00020098686218262
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0002 0.00020194053649902
SELECT * FROM categorygroups WHERE id = '1'
50 0.0013 0.0013020038604736
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.0004 0.00036811828613281
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.00018405914306641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '30'
54 0.0006 0.00059103965759277
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.00019478797912598
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.0003 0.00025510787963867
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.00021505355834961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0002 0.00022506713867188
SELECT * FROM categorygroups WHERE id = '1'
59 0.0004 0.00037407875061035
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.0002 0.00021696090698242
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.0002 0.00018095970153809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0002 0.00018191337585449
SELECT id FROM categories WHERE parent_id = '31'
63 0.0004 0.00043010711669922
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.0002 0.00022101402282715
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.0002 0.00023603439331055
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.0002 0.00019478797912598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0002 0.00019097328186035
SELECT * FROM categorygroups WHERE id = '1'
68 0.0004 0.00040411949157715
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.0002 0.00021505355834961
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.0002 0.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
71 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '32'
72 0.0004 0.00041913986206055
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.00021886825561523
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.00021505355834961
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.0003 0.00026583671569824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
76 0.0002 0.00022101402282715
SELECT * FROM categorygroups WHERE id = '1'
77 0.0004 0.00040698051452637
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.0003 0.0002601146697998
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.0003 0.00029802322387695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
80 0.0012 0.0011970996856689
SELECT id FROM categories WHERE parent_id = '33'
81 0.0007 0.00065493583679199
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.0003 0.00031709671020508
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.0009 0.00093221664428711
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.0003 0.00029802322387695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
85 0.0003 0.00026798248291016
SELECT * FROM categorygroups WHERE id = '1'
86 0.0006 0.00055694580078125
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.00032901763916016
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.00029993057250977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
89 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '34'
90 0.0004 0.00040388107299805
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.0002 0.00022315979003906
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.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 (34)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
93 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
94 0.0002 0.00019192695617676
SELECT * FROM categorygroups WHERE id = '1'
95 0.0008 0.00084304809570312
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
96 0.0005 0.00045108795166016
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
97 0.0003 0.00029802322387695
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.0005 0.00045084953308105
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
99 0.0004 0.00036811828613281
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
100 0.0549 0.054900169372559
SELECT * FROM ipgeocountries WHERE INET_ATON('18.207.108.191') >= INET_ATON(ip_start) AND INET_ATON('18.207.108.191') <= INET_ATON(ip_end)
101 0.0009 0.00086498260498047
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
102 0.0006 0.00063514709472656
SELECT * FROM countryredirects WHERE countrycode = 'US'
103 0.0002 0.00018811225891113
SELECT * FROM countryredirects WHERE id <> 1
104 0.0003 0.00026798248291016
SELECT * FROM products WHERE pagename = 'concord-bear-patch-towel-parent'
105 0.0003 0.00026512145996094
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1672
106 0.0002 0.00024104118347168
SELECT * FROM manufacturers WHERE id = '172'
107 0.0003 0.00028419494628906
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '172'
108 0.0006 0.00064396858215332
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '172' LIMIT 1
109 0.0005 0.00046491622924805
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '172' ORDER BY RAND() LIMIT 1
110 0.0003 0.00027203559875488
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
111 0.0002 0.00024008750915527
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '172'
112 0.0003 0.00025701522827148
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '172'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
113 0.0002 0.00017786026000977
SELECT * FROM manufacturerimages WHERE manufacturer_id = '172'
114 0.0002 0.00020599365234375
SELECT category_id FROM products_categories WHERE product_id = '1672'
115 0.0002 0.00020408630371094
SELECT * FROM categories WHERE id = '32'
116 0.0004 0.00038504600524902
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
117 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
118 0.0002 0.00024509429931641
SELECT id FROM categories WHERE parent_id = '32'
119 0.0004 0.00039196014404297
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 
120 0.0002 0.00019502639770508
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 
121 0.0002 0.00020217895507812
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
122 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
123 0.0010 0.0010170936584473
SELECT * FROM productimages WHERE product_id = '1672' ORDER BY sortorder ASC
124 0.0003 0.00032901763916016
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1672' AND p.id = pi.product_id ORDER BY pi.sortorder
125 0.0008 0.0007941722869873
SELECT * FROM product_image_select WHERE product_id = '1672'
126 0.0004 0.0003960132598877
SELECT * FROM productcustomimages WHERE product_id = '1672'
127 0.0006 0.00057506561279297
SELECT * FROM productfeeds WHERE product_id = '1672' ORDER BY item_date DESC
128 0.0007 0.00067019462585449
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1672' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
129 0.0026 0.0025699138641357
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1672' AND t.hidden = 0 AND display_product = 1
130 0.0011 0.0011429786682129
SELECT * FROM productamazoncontent WHERE product_id = '1672'
131 0.0009 0.00085616111755371
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 = '1672'
                GROUP BY o.product_id
132 0.0009 0.00093197822570801
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     = '1672'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
133 0.0004 0.0003509521484375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1672
134 0.0016 0.0015888214111328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1672' AND a.name = n.originalname
135 0.0003 0.00029611587524414
SELECT * FROM productoffers WHERE product_id = '1672' AND merchantid = 'A3P5ROKL5A1OLE'
136 0.0003 0.00031781196594238
SELECT * FROM productoffers
                WHERE product_id = '1672' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0003 0.00031113624572754
SELECT * FROM productoffers
                WHERE product_id = 1672
                ORDER BY price ASC LIMIT 1
138 0.0003 0.00030398368835449
SELECT value FROM productattributes
                WHERE product_id = '1672'
                AND name = 'ListPriceAmount'
139 0.0004 0.0003509521484375
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 = '1672'
                GROUP BY o.product_id
140 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     = '1672'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
141 0.0003 0.00033092498779297
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1672
142 0.0005 0.000518798828125
SELECT value FROM productattributes WHERE product_id = '1672' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0004 0.00040912628173828
SELECT * FROM products WHERE parent_id = '1672'
144 0.0006 0.00055694580078125
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
145 0.0005 0.00053000450134277
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
146 0.0011 0.0010731220245361
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
147 0.0005 0.00049614906311035
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
148 0.0010 0.00099611282348633
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=Concord+bear+patch+towel+Parent&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\";}', '', '0.42430520057678', 'd69b95d2e96eb246716f1a91fa9b8003', 'https://store-uk.welovebears.club/concord-bear-patch-towel-parent/'
149 0.0006 0.00055980682373047
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
150 0.0004 0.00038790702819824
SELECT id FROM ebay_products WHERE itemid = '274380503745' 
151 0.0002 0.00020194053649902
SELECT id FROM ebay_products WHERE itemid = '274380503708' 
152 0.0002 0.00019502639770508
SELECT id FROM ebay_products WHERE itemid = '274380500834' 
153 0.0002 0.00019598007202148
SELECT id FROM ebay_products WHERE itemid = '283821863163' 
154 0.0002 0.0001981258392334
SELECT id FROM ebay_products WHERE itemid = '274380500788' 
155 0.0003 0.00028896331787109
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=Concord+bear+patch&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.42709898948669', 'd69b95d2e96eb246716f1a91fa9b8003', 'https://store-uk.welovebears.club/concord-bear-patch-towel-parent/'
156 0.0015 0.0014870166778564
SELECT *, MATCH (description, title) AGAINST ('patch towel parent' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('patch towel parent' IN BOOLEAN MODE) AND 1672 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
157 0.0003 0.00026702880859375
SELECT *, MATCH (description, title) AGAINST ('patch towel parent' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('patch towel parent' IN BOOLEAN MODE) AND 1672 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
158 0.0003 0.0002601146697998
SELECT *, MATCH (description, title) AGAINST ('patch towel parent' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('patch towel parent' IN BOOLEAN MODE) AND 1672 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
159 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
160 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '745'
161 0.0002 0.00019621849060059
SELECT * FROM productcustomimages WHERE product_id = '745'
162 0.0006 0.00056099891662598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
163 0.0002 0.00023484230041504
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
164 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0003 0.00027084350585938
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0015 0.0015039443969727
SELECT *, MATCH (description, title) AGAINST ('concord bear patch' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('concord bear patch' IN BOOLEAN MODE) AND 1672 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
167 0.0003 0.00026893615722656
SELECT *, MATCH (description, title) AGAINST ('concord bear patch' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('concord bear patch' IN BOOLEAN MODE) AND 1672 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
168 0.0003 0.00025200843811035
SELECT *, MATCH (description, title) AGAINST ('concord bear patch' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('concord bear patch' IN BOOLEAN MODE) AND 1672 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
169 0.0002 0.00024008750915527
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
170 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '739'
171 0.0002 0.00019693374633789
SELECT * FROM productcustomimages WHERE product_id = '739'
172 0.0006 0.00058293342590332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
173 0.0002 0.00023293495178223
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
174 0.0002 0.00024509429931641
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0003 0.00027894973754883
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
177 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '745'
178 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '745'
179 0.0005 0.00052595138549805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
180 0.0002 0.00023484230041504
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
181 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00026297569274902
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0004 0.00038409233093262
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1672') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
184 0.0011 0.0011458396911621
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 <> '1672' ORDER BY RAND()
185 0.0003 0.00025701522827148
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 <> '1672' ORDER BY RAND()
186 0.0002 0.00024199485778809
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 <> '1672' ORDER BY RAND()
187 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '1685' ORDER BY sortorder ASC
188 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '1685'
189 0.0002 0.00019383430480957
SELECT * FROM productcustomimages WHERE product_id = '1685'
190 0.0008 0.00082993507385254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1685' AND a.name = n.originalname
191 0.0002 0.00023388862609863
SELECT * FROM productoffers WHERE product_id = '1685' AND merchantid = 'A3P5ROKL5A1OLE'
192 0.0003 0.00025415420532227
SELECT * FROM productoffers
                WHERE product_id = '1685' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0003 0.00028705596923828
SELECT value FROM productattributes WHERE product_id = '1685' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194 0.0002 0.00021195411682129
SELECT id,asin FROM products WHERE parent_id = 1672
195 0.0007 0.00074601173400879
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1672' ORDER BY timestamp DESC
196 0.0002 0.00021100044250488
SELECT category_id FROM products_categories WHERE product_id = '1672'
197 0.0002 0.00021815299987793
SELECT * FROM categories WHERE id = '32'
198 0.0004 0.00043296813964844
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
199 0.0002 0.00020194053649902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
200 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '32'
201 0.0004 0.00043797492980957
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 
202 0.0002 0.00020980834960938
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 
203 0.0002 0.00022196769714355
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
204 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
205 0.0007 0.00071096420288086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1672' AND a.name = n.originalname
206 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '1672' AND merchantid = 'A3P5ROKL5A1OLE'
207 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '1672' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = 1672
                ORDER BY price ASC LIMIT 1
209 0.0002 0.00024199485778809
SELECT value FROM productattributes
                WHERE product_id = '1672'
                AND name = 'ListPriceAmount'
210 0.0002 0.00024104118347168
SELECT * FROM products WHERE id = '1672'
211 0.0003 0.00025510787963867
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 = '1672'
                GROUP BY o.product_id
212 0.0003 0.0002589225769043
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     = '1672'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
213 0.0002 0.00022983551025391
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1672
214 0.0003 0.0002739429473877
SELECT value FROM productattributes WHERE product_id = '1672' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0007 0.00072193145751953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1672' AND a.name = n.originalname
216 0.0002 0.00022387504577637
SELECT * FROM productoffers WHERE product_id = '1672' AND merchantid = 'A3P5ROKL5A1OLE'
217 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '1672' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = 1672
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00024318695068359
SELECT value FROM productattributes
                WHERE product_id = '1672'
                AND name = 'ListPriceAmount'
220 0.0002 0.00021696090698242
SELECT category_id FROM products_categories WHERE product_id = '1672' AND prod_type = 'amz'
221 0.0002 0.00020384788513184
SELECT parent_id FROM categories WHERE id = '32'
222 0.0002 0.00021910667419434
SELECT * FROM categories WHERE id = '32'
223 0.0004 0.00040411949157715
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
224 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
225 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '32'
226 0.0004 0.00042009353637695
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 
227 0.0002 0.00020909309387207
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 
228 0.0002 0.00024509429931641
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
229 0.0002 0.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
230 0.0007 0.00073409080505371
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
231 0.0004 0.0004119873046875
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
232 0.0002 0.00022196769714355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
233 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = 42
234 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = 55
235 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = 45
236 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = 51
237 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = 42
238 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = 37
239 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = 44
240 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = 53
241 0.0008 0.00083708763122559
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
242 0.0003 0.00027203559875488
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:1597329812;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'
243 0.0003 0.0002589225769043
SELECT * FROM products WHERE id = 739
244 0.0002 0.00023603439331055
SELECT * FROM products WHERE id = 745
245 0.0002 0.00024604797363281
SELECT * FROM products WHERE id = 751
246 0.0002 0.00024890899658203
SELECT * FROM products WHERE id = 755
247 0.0002 0.00022196769714355
SELECT * FROM products WHERE id = 769
248 0.0002 0.00022006034851074
SELECT * FROM products WHERE id = 1229
249 0.0002 0.00023412704467773
SELECT * FROM products WHERE id = '739'
250 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
251 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '739'
252 0.0002 0.00017905235290527
SELECT * FROM productcustomimages WHERE product_id = '739'
253 0.0006 0.00056004524230957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
254 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
255 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0002 0.00018787384033203
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257 0.0002 0.00023508071899414
SELECT * FROM products WHERE id = '745'
258 0.0003 0.00026583671569824
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
259 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '745'
260 0.0002 0.00018095970153809
SELECT * FROM productcustomimages WHERE product_id = '745'
261 0.0005 0.00050592422485352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
262 0.0002 0.0002140998840332
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
263 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
264 0.0003 0.00026082992553711
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0002 0.00022411346435547
SELECT * FROM products WHERE id = '751'
266 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
267 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '751'
268 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '751'
269 0.0003 0.00032901763916016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
270 0.0002 0.0002129077911377
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
271 0.0002 0.00023317337036133
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0003 0.00025510787963867
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0002 0.00022292137145996
SELECT * FROM products WHERE id = '755'
274 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
275 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '755'
276 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '755'
277 0.0006 0.00057816505432129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
278 0.0002 0.00022387504577637
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
279 0.0002 0.00017404556274414
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0003 0.00026297569274902
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281 0.0002 0.0002291202545166
SELECT * FROM products WHERE id = '769'
282 0.0002 0.00023317337036133
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
283 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '769'
284 0.0002 0.00018882751464844
SELECT * FROM productcustomimages WHERE product_id = '769'
285 0.0004 0.00043201446533203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
286 0.0002 0.00023388862609863
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
287 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0002 0.00024580955505371
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289 0.0002 0.00022506713867188
SELECT * FROM products WHERE id = '1229'
290 0.0004 0.00039005279541016
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
291 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '1229'
292 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '1229'
293 0.0006 0.0005500316619873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
294 0.0002 0.00021505355834961
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
295 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297 0.0009 0.00089597702026367
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
298 0.0004 0.00035786628723145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
299 0.0010 0.00096917152404785
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
300 0.0006 0.00060796737670898
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
301 0.0003 0.00030112266540527
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
302 0.0003 0.0003199577331543
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
303 0.0003 0.00027799606323242
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
304 0.0003 0.00031304359436035
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'