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

Bear Paws Meat Shredder Claws

Bear Paws Meat Shredder Claws
Bear Paws Meat Shredder Claws Bear Paws Meat Shredder Claws Bear Paws Meat Shredder Claws Bear Paws Meat Shredder Claws Bear Paws Meat Shredder Claws (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-08-03 22:39:58 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 Paws Meat Shredder Claws

Product Features

TIME SAVER - Bear Paws are the answer to perfectly shredded meat without the mess and headache of knives and forks. Easily grasp and shred pork, chicken, beef, and more with the ultra-sharp "claws." MELTPROOF and DISHWASHER SAFE - Made of BPA-free nylon, FDA-approved, and heat-resistant up to 475 degrees. Never worry about your shredding tools melting near the grill or in the dishwasher. EASY & FUN TO USE - Lift , handle, shred, pull, and carve to your heart's content. Our unique design gives you a perfect handhold for safely managing the super-sharp shredding blades. BBQ PRO FAVORITE - Featured on BBQ Pitmasters, Guy Fieri's Diners, Drive-Ins, and Dives, and America's Test Kitchen. Bear Paws have been named "Best BBQ Tool" by the National BBQ Association. THE ORIGINAL BEAR PAWS - The favorite BBQ accessory for years, Bear Paws are 100% made in the USA. Nobody beats us for quality and strength. We know Bear Paws will make your BBQs 100% more epic.

Product Tags

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

24 Day(s) 0 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

24 Day(s) 5 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

2 Day(s) 18 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

2 Day(s) 4 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

12 Day(s) 19 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

13 Day(s) 6 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

29 Day(s) 19 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

29 Day(s) 5 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

16 Day(s) 16 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

29 Day(s) 10 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.96169209480286 306 0.1351 0


No Amazon API Requests Made.

Total time 0.96169209480286 seconds

Number Time From Start Name Description
1 0.15673589706421 Initialise Initialise FSB Function
2 0.15764689445496 App Controller Start Start of the App controller (called before the controller of every page)
3 0.16531109809875 Start of getCategoryListByGroup Function Before first category groups query
4 0.16548705101013 After initial query Before first category groups query
5 0.16548705101013 Get Category List for Group Before the call to getCategoryList function
6 0.16548895835876 Start of GetCategoryList function Start of the function
7 0.16549110412598 Before getting categories Query to get specific category list
8 0.165766954422 After getting categories Query to get specific category list
9 0.165766954422 Before getting category custom Before call to function getCategoryCustom
10 0.16989803314209 After getting category custom After call to function getCategoryCustom
11 0.16989994049072 Before getting category custom Before call to function getCategoryCustom
12 0.17211508750916 After getting category custom After call to function getCategoryCustom
13 0.17211604118347 Before getting category custom Before call to function getCategoryCustom
14 0.17437410354614 After getting category custom After call to function getCategoryCustom
15 0.17437505722046 Before getting category custom Before call to function getCategoryCustom
16 0.17614603042603 After getting category custom After call to function getCategoryCustom
17 0.17614698410034 Before getting category custom Before call to function getCategoryCustom
18 0.17837405204773 After getting category custom After call to function getCategoryCustom
19 0.17837500572205 Before getting category custom Before call to function getCategoryCustom
20 0.18031311035156 After getting category custom After call to function getCategoryCustom
21 0.18031406402588 Before getting category custom Before call to function getCategoryCustom
22 0.18227291107178 After getting category custom After call to function getCategoryCustom
23 0.18227410316467 Before getting category custom Before call to function getCategoryCustom
24 0.1842200756073 After getting category custom After call to function getCategoryCustom
25 0.18422102928162 Before getting category custom Before call to function getCategoryCustom
26 0.18613004684448 After getting category custom After call to function getCategoryCustom
27 0.1861310005188 End of GetCategoryList function End of the function
28 0.18613409996033 End of getCategoryListByGroup Function Before return()
29 0.23400211334229 App Controller End End of the App controller (called before the controller of every page)
30 0.23449301719666 Product Start Start of the product info controller
31 0.23542594909668 Cache file not found Starting get product details
32 0.24919700622559 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.74085807800293 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.74432110786438 Related products Start getting related products if enabled
35 0.7443220615387 Related Products Start Before the related products are found
36 0.7443220615387 Related Products Keywords Before the related product keywords are found
37 0.74432706832886 Create Keyword List Function Start of function
38 0.74442291259766 Create Keyword List Function After looping provided content - 12 keywords found
39 0.74473595619202 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
40 0.74474596977234 Create Keyword List Function After reducing keyword list
41 0.74476003646851 Create Keyword List Function After selecting by scoring keywords
42 0.74476289749146 Create Keyword List Function After final loop of keywords
43 0.74476408958435 Related Products Keywords After the related product keywords are found
44 0.75815510749817 Related Products End After the related products are found
45 0.7675518989563 Product End End of the product info controller (Product Info)
46 0.76822996139526 App_after Controller Start Start of the App_after controller (called after the controller of every page)
47 0.76876306533813 Before Get Options Before the call to getOptions in the tpl class
48 0.78883290290833 After Get Options After the call to getOptions in the tpl class
49 0.78893899917603 App_after Controller End End of the App_after controller (called after the controller of every page)
50 0.78895998001099 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
51 0.86795091629028 Product Info: After Smarty Fetch After the product.tpl template is fetched
52 0.86795592308044 Product Info: Before Template Display Before the template is displayed
53 0.96167588233948 Product Info: After Template Display After the template is displayed
54 0.96168208122253 Finalizing debug Before the debug is output to the page.
55 0.96169090270996 End of App This is the end of the app logging, final timestamp


Query Debug - 306 Database Queries. Total time 0.1351 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00051689147949219
SELECT parameter, value FROM parameters
2 0.0003 0.00027203559875488
SELECT * FROM `bad_bots`
3 0.0002 0.00020980834960938
SET time_zone = 'Europe/London'
4 0.0002 0.00024008750915527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0004 0.00037503242492676
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0002 0.00023698806762695
UPDATE autorun SET lastrun = '2020-08-13 14:51:57' WHERE id = '13'
7 0.0002 0.00020503997802734
SELECT * FROM version ORDER BY installed DESC LIMIT 1
8 0.0002 0.00019979476928711
SELECT id FROM pages WHERE pagename = 'bear-paws-meat-shredder-claws' LIMIT 1
9 0.0002 0.00023102760314941
SELECT id FROM products WHERE pagename = 'bear-paws-meat-shredder-claws' AND hidden = 0 LIMIT 1
10 0.0005 0.00050210952758789
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
11 0.0064 0.0064079761505127
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
12 0.0002 0.00021505355834961
SELECT * FROM pages WHERE pagename = 'bear-paws-meat-shredder-claws'
13 0.0002 0.00016903877258301
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0003 0.00025796890258789
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0014 0.0013899803161621
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
16 0.0002 0.00023603439331055
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
17 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
18 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '26'
19 0.0014 0.0013601779937744
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
21 0.0002 0.00019311904907227
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
22 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
23 0.0002 0.0001678466796875
SELECT * FROM categorygroups WHERE id = '1'
24 0.0005 0.00046420097351074
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
25 0.0002 0.00020790100097656
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
26 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
27 0.0002 0.0001680850982666
SELECT id FROM categories WHERE parent_id = '27'
28 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
29 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
30 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
31 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
32 0.0002 0.00016617774963379
SELECT * FROM categorygroups WHERE id = '1'
33 0.0005 0.00049710273742676
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
34 0.0002 0.00018095970153809
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
35 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
36 0.0002 0.0001671314239502
SELECT id FROM categories WHERE parent_id = '28'
37 0.0005 0.0005488395690918
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
39 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
40 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
41 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
42 0.0003 0.00026106834411621
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
43 0.0002 0.00018095970153809
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
44 0.0002 0.00015878677368164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
45 0.0002 0.0001680850982666
SELECT id FROM categories WHERE parent_id = '29'
46 0.0002 0.00024890899658203
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
47 0.0002 0.0001838207244873
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
48 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
49 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
50 0.0002 0.00017404556274414
SELECT * FROM categorygroups WHERE id = '1'
51 0.0005 0.00049805641174316
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00017905235290527
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
53 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
54 0.0002 0.00016498565673828
SELECT id FROM categories WHERE parent_id = '30'
55 0.0005 0.00052285194396973
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
56 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
57 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
58 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
59 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
60 0.0004 0.00038003921508789
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
61 0.0002 0.00018095970153809
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
62 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
63 0.0002 0.00016617774963379
SELECT id FROM categories WHERE parent_id = '31'
64 0.0003 0.00034904479980469
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
65 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
66 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
67 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
68 0.0002 0.00016307830810547
SELECT * FROM categorygroups WHERE id = '1'
69 0.0003 0.00034809112548828
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
70 0.0002 0.00018000602722168
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 32
71 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
72 0.0002 0.0001671314239502
SELECT id FROM categories WHERE parent_id = '32'
73 0.0004 0.00037884712219238
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
74 0.0002 0.00017309188842773
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
75 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
76 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
77 0.0002 0.00016379356384277
SELECT * FROM categorygroups WHERE id = '1'
78 0.0004 0.00036883354187012
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 33
79 0.0002 0.00018000602722168
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 33
80 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
81 0.0002 0.00016403198242188
SELECT id FROM categories WHERE parent_id = '33'
82 0.0003 0.00034093856811523
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
84 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
85 0.0002 0.00015878677368164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
86 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
87 0.0003 0.00033998489379883
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
88 0.0002 0.00018000602722168
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 34
89 0.0002 0.00015521049499512
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
90 0.0002 0.00016498565673828
SELECT id FROM categories WHERE parent_id = '34'
91 0.0003 0.0003359317779541
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
92 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (34)
				  AND p.disabled = 0 
93 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (34)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
94 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
95 0.0002 0.00018310546875
SELECT * FROM categorygroups WHERE id = '1'
96 0.0002 0.00021886825561523
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
97 0.0002 0.00024199485778809
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
98 0.0003 0.00025701522827148
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
99 0.0004 0.00041007995605469
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
100 0.0003 0.00033116340637207
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
101 0.0446 0.044625997543335
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)
102 0.0004 0.00041794776916504
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
103 0.0003 0.00031900405883789
SELECT * FROM countryredirects WHERE countrycode = 'US'
104 0.0002 0.00024795532226562
SELECT * FROM countryredirects WHERE id <> 1
105 0.0003 0.00033807754516602
SELECT * FROM products WHERE pagename = 'bear-paws-meat-shredder-claws'
106 0.0003 0.00029301643371582
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1691
107 0.0002 0.00022602081298828
SELECT * FROM manufacturers WHERE id = '274'
108 0.0002 0.00023794174194336
SELECT category_id FROM products_categories WHERE product_id = '1691'
109 0.0002 0.00024104118347168
SELECT * FROM categories WHERE id = '34'
110 0.0004 0.00044608116149902
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
111 0.0002 0.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
112 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '34'
113 0.0004 0.00037813186645508
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 
114 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 (34)
				  AND p.disabled = 0 
115 0.0002 0.00019311904907227
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
116 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
117 0.0002 0.00024890899658203
SELECT * FROM productimages WHERE product_id = '1691' ORDER BY sortorder ASC
118 0.0002 0.00023293495178223
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1691' AND p.id = pi.product_id ORDER BY pi.sortorder
119 0.0002 0.00018811225891113
SELECT * FROM product_image_select WHERE product_id = '1691'
120 0.0002 0.00016498565673828
SELECT * FROM productcustomimages WHERE product_id = '1691'
121 0.0007 0.00072407722473145
SELECT * FROM productfeeds WHERE product_id = '1691' ORDER BY item_date DESC
122 0.0003 0.00026607513427734
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1691' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
123 0.0013 0.0012669563293457
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1691' AND t.hidden = 0 AND display_product = 1
124 0.0002 0.00019001960754395
SELECT * FROM tags WHERE id = '1'
125 0.0007 0.00065302848815918
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
126 0.0007 0.0006709098815918
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
127 0.0007 0.00065016746520996
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
128 0.0004 0.00038599967956543
SELECT * FROM productimages WHERE product_id = '1696' ORDER BY sortorder ASC
129 0.0002 0.00020313262939453
SELECT * FROM productamazoncontent WHERE product_id = '1691'
130 0.0002 0.00023102760314941
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 = '1691'
                GROUP BY o.product_id
131 0.0002 0.00023007392883301
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     = '1691'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
132 0.0002 0.00022697448730469
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1691
133 0.0008 0.00080680847167969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1691' AND a.name = n.originalname
134 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '1691' AND merchantid = 'A3P5ROKL5A1OLE'
135 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '1691' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0002 0.00018692016601562
SELECT * FROM productoffers
                WHERE product_id = 1691
                ORDER BY price ASC LIMIT 1
137 0.0002 0.00020694732666016
SELECT value FROM productattributes
                WHERE product_id = '1691'
                AND name = 'ListPriceAmount'
138 0.0003 0.00025177001953125
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 = '1691'
                GROUP BY o.product_id
139 0.0002 0.00022006034851074
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     = '1691'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
140 0.0002 0.00019383430480957
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1691
141 0.0002 0.00023508071899414
SELECT value FROM productattributes WHERE product_id = '1691' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0003 0.00025391578674316
SELECT * FROM products WHERE parent_id = '1691'
143 0.0003 0.00025606155395508
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
144 0.0002 0.00023794174194336
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.0007 0.00072193145751953
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
146 0.0002 0.0002439022064209
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
147 0.0003 0.00032997131347656
SELECT id FROM ebay_products WHERE itemid = '303644407375' 
148 0.0002 0.00024104118347168
SELECT id FROM ebay_products WHERE itemid = '112433667063' 
149 0.0002 0.00022387504577637
SELECT id FROM ebay_products WHERE itemid = '293650242815' 
150 0.0002 0.00024199485778809
SELECT id FROM ebay_products WHERE itemid = '293649571537' 
151 0.0003 0.00025200843811035
SELECT id FROM ebay_products WHERE itemid = '233323093610' 
152 0.0002 0.00017786026000977
SELECT id FROM ebay_products WHERE itemid = '174364819643' 
153 0.0002 0.00017404556274414
SELECT id FROM ebay_products WHERE itemid = '164334097403' 
154 0.0002 0.00017189979553223
SELECT id FROM ebay_products WHERE itemid = '174345971291' 
155 0.0002 0.00018501281738281
SELECT id FROM ebay_products WHERE itemid = '324245132329' 
156 0.0002 0.00017905235290527
SELECT id FROM ebay_products WHERE itemid = '173687215223' 
157 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=Bear+Paws+Meat+Shredder+Claws&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.49166989326477', 'a39211e56e6c1b510d6d97abe8eea664', 'https://store-uk.welovebears.club/bear-paws-meat-shredder-claws'
158 0.0015 0.0015039443969727
SELECT *, MATCH (description, title) AGAINST ('meat shredder claws' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('meat shredder claws' IN BOOLEAN MODE) AND 1691 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
159 0.0002 0.00024008750915527
SELECT *, MATCH (description, title) AGAINST ('meat shredder claws' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('meat shredder claws' IN BOOLEAN MODE) AND 1691 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
160 0.0002 0.00021982192993164
SELECT *, MATCH (description, title) AGAINST ('meat shredder claws' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('meat shredder claws' IN BOOLEAN MODE) AND 1691 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
161 0.0004 0.00037097930908203
SELECT * FROM productimages WHERE product_id = '1696' ORDER BY sortorder ASC
162 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '1696'
163 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '1696'
164 0.0006 0.00062894821166992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1696' AND a.name = n.originalname
165 0.0002 0.00022101402282715
SELECT * FROM productoffers WHERE product_id = '1696' AND merchantid = 'A3P5ROKL5A1OLE'
166 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '1696' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00025391578674316
SELECT value FROM productattributes WHERE product_id = '1696' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0003 0.00027680397033691
SELECT * FROM productimages WHERE product_id = '1695' ORDER BY sortorder ASC
169 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '1695'
170 0.0002 0.00017499923706055
SELECT * FROM productcustomimages WHERE product_id = '1695'
171 0.0008 0.00076818466186523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1695' AND a.name = n.originalname
172 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '1695' AND merchantid = 'A3P5ROKL5A1OLE'
173 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = '1695' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '1695' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175 0.0006 0.00062108039855957
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1691') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
176 0.0011 0.0011119842529297
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '34' AND pc.prod_type = 'amz'  AND p.id <> '1691' ORDER BY RAND()
177 0.0002 0.00024008750915527
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '34' AND pc.prod_type = 'ebay' AND p.id <> '1691' ORDER BY RAND()
178 0.0002 0.00023198127746582
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '34' AND pc.prod_type = 'custom' AND p.id <> '1691' ORDER BY RAND()
179 0.0002 0.00024509429931641
SELECT * FROM productimages WHERE product_id = '1690' ORDER BY sortorder ASC
180 0.0002 0.00023412704467773
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1690' AND p.id = pi.product_id ORDER BY pi.sortorder
181 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '1690'
182 0.0002 0.00018787384033203
SELECT * FROM productcustomimages WHERE product_id = '1690'
183 0.0002 0.00023794174194336
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 = '1690'
                GROUP BY o.product_id
184 0.0002 0.00023913383483887
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     = '1690'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
185 0.0002 0.0002140998840332
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1690
186 0.0006 0.00058698654174805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1690' AND a.name = n.originalname
187 0.0002 0.00020885467529297
SELECT * FROM productoffers WHERE product_id = '1690' AND merchantid = 'A3P5ROKL5A1OLE'
188 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '1690' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = 1690
                ORDER BY price ASC LIMIT 1
190 0.0002 0.00022387504577637
SELECT value FROM productattributes
                WHERE product_id = '1690'
                AND name = 'ListPriceAmount'
191 0.0002 0.00023317337036133
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 = '1690'
                GROUP BY o.product_id
192 0.0002 0.00024008750915527
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     = '1690'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
193 0.0002 0.00022292137145996
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1690
194 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '1690' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0002 0.00021910667419434
SELECT * FROM products WHERE parent_id = '1690'
196 0.0002 0.00019097328186035
SELECT id,asin FROM products WHERE parent_id = 1691
197 0.0002 0.00021910667419434
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1691' ORDER BY timestamp DESC
198 0.0002 0.00019288063049316
SELECT category_id FROM products_categories WHERE product_id = '1691'
199 0.0002 0.00020098686218262
SELECT * FROM categories WHERE id = '34'
200 0.0004 0.00036907196044922
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
201 0.0002 0.00019288063049316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
202 0.0002 0.00018811225891113
SELECT id FROM categories WHERE parent_id = '34'
203 0.0004 0.0003809928894043
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 
204 0.0002 0.00019407272338867
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 
205 0.0002 0.00023412704467773
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
206 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
207 0.0006 0.00062012672424316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1691' AND a.name = n.originalname
208 0.0002 0.0002129077911377
SELECT * FROM productoffers WHERE product_id = '1691' AND merchantid = 'A3P5ROKL5A1OLE'
209 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '1691' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = 1691
                ORDER BY price ASC LIMIT 1
211 0.0002 0.00022196769714355
SELECT value FROM productattributes
                WHERE product_id = '1691'
                AND name = 'ListPriceAmount'
212 0.0002 0.00022792816162109
SELECT * FROM products WHERE id = '1691'
213 0.0002 0.00023078918457031
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 = '1691'
                GROUP BY o.product_id
214 0.0003 0.00026202201843262
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     = '1691'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
215 0.0002 0.00020503997802734
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1691
216 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '1691' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0006 0.00059199333190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1691' AND a.name = n.originalname
218 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '1691' AND merchantid = 'A3P5ROKL5A1OLE'
219 0.0002 0.00023484230041504
SELECT * FROM productoffers
                WHERE product_id = '1691' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = 1691
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00021505355834961
SELECT value FROM productattributes
                WHERE product_id = '1691'
                AND name = 'ListPriceAmount'
222 0.0002 0.00019288063049316
SELECT category_id FROM products_categories WHERE product_id = '1691' AND prod_type = 'amz'
223 0.0002 0.00018000602722168
SELECT parent_id FROM categories WHERE id = '34'
224 0.0003 0.00030398368835449
SELECT * FROM categories WHERE id = '34'
225 0.0004 0.00035214424133301
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
226 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
227 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '34'
228 0.0004 0.00036883354187012
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 
229 0.0002 0.00018787384033203
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 
230 0.0002 0.00019502639770508
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
231 0.0002 0.00018787384033203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
232 0.0002 0.00021982192993164
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
233 0.0002 0.00021886825561523
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
234 0.0002 0.00022602081298828
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
235 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = 42
236 0.0002 0.00019478797912598
SELECT * FROM pages WHERE id = 55
237 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = 45
238 0.0003 0.00025510787963867
SELECT * FROM pages WHERE id = 51
239 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = 42
240 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = 37
241 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = 44
242 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = 53
243 0.0006 0.00060296058654785
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
244 0.0002 0.00023412704467773
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:1597330318;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'
245 0.0002 0.00024580955505371
SELECT * FROM products WHERE id = 739
246 0.0002 0.0002138614654541
SELECT * FROM products WHERE id = 745
247 0.0002 0.0002129077911377
SELECT * FROM products WHERE id = 751
248 0.0002 0.00020980834960938
SELECT * FROM products WHERE id = 755
249 0.0002 0.00023794174194336
SELECT * FROM products WHERE id = 769
250 0.0002 0.00021100044250488
SELECT * FROM products WHERE id = 1229
251 0.0002 0.00021195411682129
SELECT * FROM products WHERE id = '739'
252 0.0002 0.00022006034851074
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
253 0.0002 0.00019979476928711
SELECT * FROM product_image_select WHERE product_id = '739'
254 0.0002 0.00017285346984863
SELECT * FROM productcustomimages WHERE product_id = '739'
255 0.0005 0.00053501129150391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
256 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
257 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0003 0.0002589225769043
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0002 0.00024008750915527
SELECT * FROM products WHERE id = '745'
260 0.0003 0.0003049373626709
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
261 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '745'
262 0.0002 0.00017189979553223
SELECT * FROM productcustomimages WHERE product_id = '745'
263 0.0005 0.00048494338989258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
264 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
265 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0002 0.00024008750915527
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0002 0.00024008750915527
SELECT * FROM products WHERE id = '751'
268 0.0003 0.00031304359436035
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
269 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '751'
270 0.0002 0.00020790100097656
SELECT * FROM productcustomimages WHERE product_id = '751'
271 0.0003 0.00030899047851562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
272 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
273 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0003 0.00025486946105957
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0002 0.00021696090698242
SELECT * FROM products WHERE id = '755'
276 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
277 0.0002 0.00019001960754395
SELECT * FROM product_image_select WHERE product_id = '755'
278 0.0002 0.00017189979553223
SELECT * FROM productcustomimages WHERE product_id = '755'
279 0.0006 0.00060582160949707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
280 0.0002 0.00021505355834961
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
281 0.0002 0.00024890899658203
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0002 0.00024986267089844
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283 0.0002 0.00021600723266602
SELECT * FROM products WHERE id = '769'
284 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
285 0.0002 0.00019693374633789
SELECT * FROM product_image_select WHERE product_id = '769'
286 0.0002 0.00017213821411133
SELECT * FROM productcustomimages WHERE product_id = '769'
287 0.0004 0.00040793418884277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
288 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
289 0.0002 0.0002448558807373
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0003 0.00026297569274902
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0002 0.00024104118347168
SELECT * FROM products WHERE id = '1229'
292 0.0003 0.00034594535827637
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
293 0.0002 0.00019216537475586
SELECT * FROM product_image_select WHERE product_id = '1229'
294 0.0002 0.00018596649169922
SELECT * FROM productcustomimages WHERE product_id = '1229'
295 0.0006 0.00055599212646484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
296 0.0002 0.00021791458129883
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
297 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0002 0.00024509429931641
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0004 0.00036501884460449
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
300 0.0003 0.00032305717468262
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
301 0.0007 0.00069499015808105
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
302 0.0003 0.00030016899108887
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
303 0.0003 0.00028800964355469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
304 0.0006 0.0005650520324707
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
305 0.0003 0.00030303001403809
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
306 0.0004 0.00041389465332031
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'