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

Cave Tools Meat Shredders Parent

Cave Tools Meat Shredders Parent
Cave Tools Meat Shredders Parent Cave Tools Meat Shredders Parent Cave Tools Meat Shredders Parent Cave Tools Meat Shredders Parent Cave Tools Meat Shredders Parent (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-04-18 04:50:05 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

The Hottest New Kitchen Tools No Family Should Be Without

SHREDDING - HANDLING - CARVING


5 Giant Reasons Why Cave Tools Has the Best Pulled Pork Shredder Claws on the Market:

1. Lightning Fast Meat Shredding - After you shred an entire chunk of pork in 3 minutes you'll never go back to 2 forks and bruised fingers again

2. Comfortable Handles are Perfect For Picking Up Large Hot Food in the Kitchen - No more dropping the Turkey on the floor because you tried to pick it up with a couple of oven mitts

3. Safe & Easy Carving - Using a fork just doesn't cut it and it's outright dangerous

4. Incredibly Strong Heat Resistance - You'll never have to worry about the tips melting or bending like on other low quality claws

5. No Job Is Too Big For Cave Tools - Whether you're a competition bbq pit master or just shredding up some pork for the family, We Have You Covered


OUR UNBEATABLE LIFETIME GUARANTEE

If at any point in the life of your meat claws, if you feel like you received less value than what you paid for it, we will give you a full refund for your money. Even if you use your pulled pork shredder claws for an entire year, if you want your money back, we will give you a full refund for your meat shredder claws.

That's how confident we feel that we have the best meat claws on the market


THE GRILL MASTER'S ESSENTIAL BARBECUE RECIPE BOOK

Download instructions included with purchase. Complete with 25 Professional BBQ Recipes, Step by Step instructions, Tutorial Videos, and access to over 135 Cooking Videos


WHO IS CAVE TOOLS

Cave Tools has been featured on: The "Q" Review, BBQ Central Radio Station, Outdoor Cooking Channel, FOX, NBC, ABC

We Are Committed To Superior Strength, Design & Durability so You Can Buy Today With Confidence

Product Features

HIGH QUALITY PULLED PORK SHREDDER CLAWS dominate chicken, beef, brisket, turkey, poultry, hams, roasts and anything from your slow cooker, grill or smoker in record time MEAT HANDLER FORKS NEVER LOSE GRIP - bear paw shaped so you can pick up and carry hot foods in the kitchen without dropping them or burning your hands USE TO SAFELY CARVE LARGE FOODS - Heat resistant BPA Free pulled pork shredder claws never slip COMES WITH 25 PROFESSIONAL RECIPES - step by step instructions and detailed tutorial videos are great for the family LIFETIME SATISFACTION GUARANTEE - If at any point you are unhappy with your pulled pork shredder claws you can return it for a full money back refund. We Take Customer Service That Seriously

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 other (see details)

14 Day(s) 9 h(s)
Worldwide

N/A

No Returns

Buy it Now

Used

26 Day(s) 23 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

7 Day(s) 2 h(s)
Worldwide

N/A

No Returns

Buy it Now

1 Day(s) 8 h(s)
Worldwide

N/A

No Returns

Buy it Now

Used

9 Day(s) 5 h(s)
Worldwide

N/A

No Returns

Buy it Now

18 Day(s) 9 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

7 Day(s) 0 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

20 Day(s) 19 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

5 Day(s) 17 h(s)
Worldwide

N/A

No Returns

Buy it Now

New

12 Day(s) 20 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.1716630458832 301 0.1844 0


No Amazon API Requests Made.

Total time 1.1716630458832 seconds

Number Time From Start Name Description
1 0.18743896484375 Initialise Initialise FSB Function
2 0.19134593009949 App Controller Start Start of the App controller (called before the controller of every page)
3 0.20645403862 Start of getCategoryListByGroup Function Before first category groups query
4 0.20719695091248 After initial query Before first category groups query
5 0.20719814300537 Get Category List for Group Before the call to getCategoryList function
6 0.207200050354 Start of GetCategoryList function Start of the function
7 0.20720314979553 Before getting categories Query to get specific category list
8 0.20776510238647 After getting categories Query to get specific category list
9 0.20776605606079 Before getting category custom Before call to function getCategoryCustom
10 0.21430802345276 After getting category custom After call to function getCategoryCustom
11 0.21431112289429 Before getting category custom Before call to function getCategoryCustom
12 0.21837496757507 After getting category custom After call to function getCategoryCustom
13 0.21838092803955 Before getting category custom Before call to function getCategoryCustom
14 0.22205209732056 After getting category custom After call to function getCategoryCustom
15 0.2220561504364 Before getting category custom Before call to function getCategoryCustom
16 0.22427105903625 After getting category custom After call to function getCategoryCustom
17 0.22427296638489 Before getting category custom Before call to function getCategoryCustom
18 0.22684907913208 After getting category custom After call to function getCategoryCustom
19 0.22685194015503 Before getting category custom Before call to function getCategoryCustom
20 0.22903299331665 After getting category custom After call to function getCategoryCustom
21 0.22903513908386 Before getting category custom Before call to function getCategoryCustom
22 0.23109102249146 After getting category custom After call to function getCategoryCustom
23 0.23109292984009 Before getting category custom Before call to function getCategoryCustom
24 0.233078956604 After getting category custom After call to function getCategoryCustom
25 0.2330801486969 Before getting category custom Before call to function getCategoryCustom
26 0.23521113395691 After getting category custom After call to function getCategoryCustom
27 0.23521304130554 End of GetCategoryList function End of the function
28 0.23521995544434 End of getCategoryListByGroup Function Before return()
29 0.29428505897522 App Controller End End of the App controller (called before the controller of every page)
30 0.29502201080322 Product Start Start of the product info controller
31 0.29599404335022 Cache file not found Starting get product details
32 0.31111407279968 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.69591593742371 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.69764304161072 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
35 1.0796401500702 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
36 1.0832901000977 Related products Start getting related products if enabled
37 1.0832920074463 Related Products Start Before the related products are found
38 1.0832941532135 Related Products Keywords Before the related product keywords are found
39 1.0833020210266 Create Keyword List Function Start of function
40 1.083505153656 Create Keyword List Function After looping provided content - 12 keywords found
41 1.0838310718536 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
42 1.083841085434 Create Keyword List Function After reducing keyword list
43 1.0838611125946 Create Keyword List Function After selecting by scoring keywords
44 1.0838649272919 Create Keyword List Function After final loop of keywords
45 1.0838661193848 Related Products Keywords After the related product keywords are found
46 1.0962190628052 Related Products End After the related products are found
47 1.1063930988312 Product End End of the product info controller (Product Info)
48 1.1075439453125 App_after Controller Start Start of the App_after controller (called after the controller of every page)
49 1.1082739830017 Before Get Options Before the call to getOptions in the tpl class
50 1.1440620422363 After Get Options After the call to getOptions in the tpl class
51 1.1441791057587 App_after Controller End End of the App_after controller (called after the controller of every page)
52 1.1442041397095 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
53 1.1535069942474 Product Info: After Smarty Fetch After the product.tpl template is fetched
54 1.1535141468048 Product Info: Before Template Display Before the template is displayed
55 1.1716370582581 Product Info: After Template Display After the template is displayed
56 1.1716470718384 Finalizing debug Before the debug is output to the page.
57 1.1716620922089 End of App This is the end of the app logging, final timestamp


Query Debug - 301 Database Queries. Total time 0.1844 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00037217140197754
SELECT parameter, value FROM parameters
2 0.0010 0.0010330677032471
SELECT * FROM `bad_bots`
3 0.0003 0.00026297569274902
SET time_zone = 'Europe/London'
4 0.0008 0.00077581405639648
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.0010218620300293
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0002 0.0002439022064209
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0005 0.00054001808166504
SELECT id FROM pages WHERE pagename = 'cave-tools-meat-shredders-parent' LIMIT 1
8 0.0027 0.0026969909667969
SELECT id FROM products WHERE pagename = 'cave-tools-meat-shredders-parent' AND hidden = 0 LIMIT 1
9 0.0011 0.0011191368103027
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
10 0.0128 0.012841939926147
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
11 0.0002 0.00024199485778809
SELECT * FROM pages WHERE pagename = 'cave-tools-meat-shredders-parent'
12 0.0007 0.0007319450378418
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0005 0.00049710273742676
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0020 0.001953125
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.0006 0.00060486793518066
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.00035595893859863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
17 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '26'
18 0.0015 0.0014510154724121
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.00074505805969238
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.0005 0.00045084953308105
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.0003 0.00025582313537598
SELECT * FROM categorygroups WHERE id = '1'
23 0.0008 0.00079703330993652
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.0005 0.00050592422485352
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.0003 0.00033807754516602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0003 0.00027894973754883
SELECT id FROM categories WHERE parent_id = '27'
27 0.0009 0.00091981887817383
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.00026202201843262
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.00028014183044434
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.0003 0.0002589225769043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0003 0.00027298927307129
SELECT * FROM categorygroups WHERE id = '1'
32 0.0009 0.00093698501586914
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.0005 0.0005340576171875
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
34 0.0002 0.00018787384033203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0002 0.00019097328186035
SELECT id FROM categories WHERE parent_id = '28'
36 0.0007 0.00069880485534668
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
37 0.0002 0.00024819374084473
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
38 0.0003 0.00026297569274902
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.00021910667419434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0002 0.00024509429931641
SELECT * FROM categorygroups WHERE id = '1'
41 0.0004 0.00036311149597168
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.00030016899108887
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
43 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '29'
45 0.0003 0.00029182434082031
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.00021100044250488
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.0001978874206543
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0002 0.00017905235290527
SELECT * FROM categorygroups WHERE id = '1'
50 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 = 30
51 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 = 30
52 0.0002 0.00018882751464844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0002 0.00018191337585449
SELECT id FROM categories WHERE parent_id = '30'
54 0.0005 0.00054311752319336
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.00020599365234375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
56 0.0002 0.00020098686218262
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.00020503997802734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0002 0.00017499923706055
SELECT * FROM categorygroups WHERE id = '1'
59 0.0004 0.00035595893859863
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.00018787384033203
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.00021910667419434
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '31'
63 0.0003 0.00033402442932129
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.00020599365234375
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.00021791458129883
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.00022101402282715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0002 0.00017690658569336
SELECT * FROM categorygroups WHERE id = '1'
68 0.0004 0.00037908554077148
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.0001 0.00012898445129395
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.0001680850982666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
71 0.0002 0.00017189979553223
SELECT id FROM categories WHERE parent_id = '32'
72 0.0004 0.00037693977355957
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.00017404556274414
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.00021719932556152
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
75 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
76 0.0002 0.00019502639770508
SELECT * FROM categorygroups WHERE id = '1'
77 0.0004 0.00036096572875977
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 33
78 0.0002 0.00019288063049316
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 33
79 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
80 0.0002 0.00017213821411133
SELECT id FROM categories WHERE parent_id = '33'
81 0.0004 0.00035691261291504
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
82 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
83 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
84 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
85 0.0002 0.00016880035400391
SELECT * FROM categorygroups WHERE id = '1'
86 0.0003 0.00033903121948242
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.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 = 34
88 0.0002 0.00020003318786621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
89 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '34'
90 0.0004 0.00038290023803711
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.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 
92 0.0002 0.00018501281738281
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.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
94 0.0002 0.0001680850982666
SELECT * FROM categorygroups WHERE id = '1'
95 0.0008 0.00077700614929199
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
96 0.0004 0.00044512748718262
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
97 0.0003 0.00027704238891602
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.0004 0.00043892860412598
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
99 0.0004 0.00038385391235352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
100 0.0543 0.054306030273438
SELECT * FROM ipgeocountries WHERE INET_ATON('35.172.233.2') >= INET_ATON(ip_start) AND INET_ATON('35.172.233.2') <= INET_ATON(ip_end)
101 0.0008 0.00084805488586426
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
102 0.0004 0.00040388107299805
SELECT * FROM countryredirects WHERE countrycode = 'US'
103 0.0003 0.00029706954956055
SELECT * FROM countryredirects WHERE id <> 1
104 0.0003 0.00034117698669434
SELECT * FROM products WHERE pagename = 'cave-tools-meat-shredders-parent'
105 0.0003 0.00026798248291016
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1708
106 0.0002 0.00021195411682129
SELECT * FROM manufacturers WHERE id = '195'
107 0.0002 0.00023913383483887
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '195'
108 0.0004 0.00040316581726074
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '195' LIMIT 1
109 0.0002 0.00023508071899414
SELECT pagename, id FROM products p WHERE manufacturer_id = '195' ORDER BY RAND() LIMIT 1
110 0.0004 0.00041007995605469
SELECT * FROM productimages WHERE product_id = '1708' ORDER BY sortorder ASC
111 0.0002 0.00023794174194336
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '195'
112 0.0002 0.00023007392883301
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '195'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
113 0.0002 0.00017404556274414
SELECT * FROM manufacturerimages WHERE manufacturer_id = '195'
114 0.0002 0.00019097328186035
SELECT category_id FROM products_categories WHERE product_id = '1708'
115 0.0002 0.00022315979003906
SELECT * FROM categories WHERE id = '34'
116 0.0004 0.00037479400634766
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
117 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
118 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '34'
119 0.0004 0.00040411949157715
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 
120 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 
121 0.0002 0.00021982192993164
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
122 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
123 0.0003 0.00028491020202637
SELECT * FROM productimages WHERE product_id = '1708' ORDER BY sortorder ASC
124 0.0003 0.00025582313537598
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1708' AND p.id = pi.product_id ORDER BY pi.sortorder
125 0.0006 0.00057601928710938
SELECT * FROM product_image_select WHERE product_id = '1708'
126 0.0004 0.00038409233093262
SELECT * FROM productcustomimages WHERE product_id = '1708'
127 0.0003 0.0003349781036377
SELECT * FROM productfeeds WHERE product_id = '1708' ORDER BY item_date DESC
128 0.0006 0.00063586235046387
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1708' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
129 0.0007 0.00065803527832031
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1708' AND t.hidden = 0 AND display_product = 1
130 0.0004 0.00041294097900391
SELECT * FROM productamazoncontent WHERE product_id = '1708'
131 0.0005 0.00046205520629883
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 = '1708'
                GROUP BY o.product_id
132 0.0006 0.00058913230895996
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     = '1708'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
133 0.0002 0.00021600723266602
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1708
134 0.0007 0.0006861686706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1708' AND a.name = n.originalname
135 0.0002 0.00023198127746582
SELECT * FROM productoffers WHERE product_id = '1708' AND merchantid = 'A3P5ROKL5A1OLE'
136 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = '1708' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = 1708
                ORDER BY price ASC LIMIT 1
138 0.0003 0.00032591819763184
SELECT value FROM productattributes
                WHERE product_id = '1708'
                AND name = 'ListPriceAmount'
139 0.0003 0.00032591819763184
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 = '1708'
                GROUP BY o.product_id
140 0.0003 0.00031208992004395
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     = '1708'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
141 0.0003 0.0002748966217041
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1708
142 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '1708' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0003 0.00030803680419922
SELECT * FROM products WHERE parent_id = '1708'
144 0.0004 0.00040507316589355
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.0004 0.0003659725189209
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.0008 0.00078797340393066
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
147 0.0004 0.00040483474731445
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.00097012519836426
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=Cave+Tools+Meat+Shredders+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.38481378555298', 'c7ec0294437f060d18b984b156b78c46', 'https://store-uk.welovebears.club/cave-tools-meat-shredders-parent'
149 0.0003 0.00032901763916016
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.0003 0.00025391578674316
SELECT id FROM ebay_products WHERE itemid = '223871075191' 
151 0.0002 0.00022602081298828
SELECT id FROM ebay_products WHERE itemid = '224106604173' 
152 0.0002 0.00019598007202148
SELECT id FROM ebay_products WHERE itemid = '192219392052' 
153 0.0002 0.00019121170043945
SELECT id FROM ebay_products WHERE itemid = '262757296409' 
154 0.0002 0.00019598007202148
SELECT id FROM ebay_products WHERE itemid = '352489968890' 
155 0.0002 0.00022697448730469
SELECT id FROM ebay_products WHERE itemid = '124025190442' 
156 0.0002 0.00017786026000977
SELECT id FROM ebay_products WHERE itemid = '273705253644' 
157 0.0002 0.00017380714416504
SELECT id FROM ebay_products WHERE itemid = '174300386267' 
158 0.0002 0.0001838207244873
SELECT id FROM ebay_products WHERE itemid = '183536847714' 
159 0.0003 0.00025701522827148
SELECT id FROM ebay_products WHERE itemid = '114270394617' 
160 0.0003 0.00027012825012207
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=Cave+Tools+Meat&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.38200712203979', 'c7ec0294437f060d18b984b156b78c46', 'https://store-uk.welovebears.club/cave-tools-meat-shredders-parent'
161 0.0018 0.0018401145935059
SELECT *, MATCH (description, title) AGAINST ('meat shredders parent' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('meat shredders parent' IN BOOLEAN MODE) AND 1708 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
162 0.0003 0.00030398368835449
SELECT *, MATCH (description, title) AGAINST ('meat shredders parent' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('meat shredders parent' IN BOOLEAN MODE) AND 1708 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
163 0.0003 0.00026416778564453
SELECT *, MATCH (description, title) AGAINST ('meat shredders parent' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('meat shredders parent' IN BOOLEAN MODE) AND 1708 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
164 0.0004 0.0004270076751709
SELECT * FROM productimages WHERE product_id = '1696' ORDER BY sortorder ASC
165 0.0002 0.00024795532226562
SELECT * FROM product_image_select WHERE product_id = '1696'
166 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '1696'
167 0.0007 0.00072789192199707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1696' AND a.name = n.originalname
168 0.0002 0.00024104118347168
SELECT * FROM productoffers WHERE product_id = '1696' AND merchantid = 'A3P5ROKL5A1OLE'
169 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '1696' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0003 0.00027894973754883
SELECT value FROM productattributes WHERE product_id = '1696' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0003 0.00028705596923828
SELECT * FROM productimages WHERE product_id = '1695' ORDER BY sortorder ASC
172 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '1695'
173 0.0003 0.00028085708618164
SELECT * FROM productcustomimages WHERE product_id = '1695'
174 0.0008 0.00079798698425293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1695' AND a.name = n.originalname
175 0.0002 0.0002281665802002
SELECT * FROM productoffers WHERE product_id = '1695' AND merchantid = 'A3P5ROKL5A1OLE'
176 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '1695' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0003 0.00031900405883789
SELECT value FROM productattributes WHERE product_id = '1695' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0004 0.00043010711669922
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1708') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
179 0.0011 0.0011389255523682
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 <> '1708' ORDER BY RAND()
180 0.0002 0.0002439022064209
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 <> '1708' ORDER BY RAND()
181 0.0002 0.00022602081298828
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 <> '1708' ORDER BY RAND()
182 0.0003 0.00030112266540527
SELECT * FROM productimages WHERE product_id = '1688' ORDER BY sortorder ASC
183 0.0002 0.00018811225891113
SELECT * FROM product_image_select WHERE product_id = '1688'
184 0.0002 0.00016307830810547
SELECT * FROM productcustomimages WHERE product_id = '1688'
185 0.0006 0.00056099891662598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1688' AND a.name = n.originalname
186 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '1688' AND merchantid = 'A3P5ROKL5A1OLE'
187 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '1688' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = 1688
                ORDER BY price ASC LIMIT 1
189 0.0002 0.00024294853210449
SELECT value FROM productattributes
                WHERE product_id = '1688'
                AND name = 'ListPriceAmount'
190 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '1688' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0002 0.00018191337585449
SELECT id,asin FROM products WHERE parent_id = 1708
192 0.0007 0.00070810317993164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1708' ORDER BY timestamp DESC
193 0.0002 0.00022387504577637
SELECT category_id FROM products_categories WHERE product_id = '1708'
194 0.0002 0.00020909309387207
SELECT * FROM categories WHERE id = '34'
195 0.0004 0.00040006637573242
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
196 0.0002 0.00015020370483398
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
197 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '34'
198 0.0004 0.00044798851013184
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 
199 0.0002 0.00022602081298828
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 
200 0.0002 0.00015997886657715
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
201 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
202 0.0007 0.00068306922912598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1708' AND a.name = n.originalname
203 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '1708' AND merchantid = 'A3P5ROKL5A1OLE'
204 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '1708' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = 1708
                ORDER BY price ASC LIMIT 1
206 0.0002 0.00021600723266602
SELECT value FROM productattributes
                WHERE product_id = '1708'
                AND name = 'ListPriceAmount'
207 0.0002 0.00021600723266602
SELECT * FROM products WHERE id = '1708'
208 0.0002 0.00022602081298828
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 = '1708'
                GROUP BY o.product_id
209 0.0003 0.00026488304138184
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     = '1708'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
210 0.0002 0.00023388862609863
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1708
211 0.0003 0.00027799606323242
SELECT value FROM productattributes WHERE product_id = '1708' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0008 0.00075316429138184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1708' AND a.name = n.originalname
213 0.0002 0.00024795532226562
SELECT * FROM productoffers WHERE product_id = '1708' AND merchantid = 'A3P5ROKL5A1OLE'
214 0.0002 0.00024104118347168
SELECT * FROM productoffers
                WHERE product_id = '1708' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = 1708
                ORDER BY price ASC LIMIT 1
216 0.0002 0.00024509429931641
SELECT value FROM productattributes
                WHERE product_id = '1708'
                AND name = 'ListPriceAmount'
217 0.0002 0.00021791458129883
SELECT category_id FROM products_categories WHERE product_id = '1708' AND prod_type = 'amz'
218 0.0001 0.00014710426330566
SELECT parent_id FROM categories WHERE id = '34'
219 0.0002 0.00023317337036133
SELECT * FROM categories WHERE id = '34'
220 0.0004 0.00040197372436523
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
221 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
222 0.0001 0.00012683868408203
SELECT id FROM categories WHERE parent_id = '34'
223 0.0004 0.00040102005004883
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 
224 0.0002 0.00021505355834961
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 
225 0.0002 0.00020194053649902
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
226 0.0002 0.00018119812011719
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
227 0.0007 0.00068902969360352
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
228 0.0004 0.0003969669342041
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
229 0.0002 0.00023317337036133
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
230 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = 42
231 0.0002 0.000244140625
SELECT * FROM pages WHERE id = 55
232 0.0003 0.00026106834411621
SELECT * FROM pages WHERE id = 45
233 0.0002 0.0002439022064209
SELECT * FROM pages WHERE id = 51
234 0.0002 0.00024986267089844
SELECT * FROM pages WHERE id = 42
235 0.0003 0.00029683113098145
SELECT * FROM pages WHERE id = 37
236 0.0003 0.00026082992553711
SELECT * FROM pages WHERE id = 44
237 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = 53
238 0.0011 0.0011169910430908
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
239 0.0003 0.00032305717468262
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:1596982124;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'
240 0.0003 0.00031685829162598
SELECT * FROM products WHERE id = 739
241 0.0003 0.00027608871459961
SELECT * FROM products WHERE id = 745
242 0.0004 0.00039291381835938
SELECT * FROM products WHERE id = 751
243 0.0003 0.00026488304138184
SELECT * FROM products WHERE id = 755
244 0.0003 0.00026392936706543
SELECT * FROM products WHERE id = 769
245 0.0003 0.00031113624572754
SELECT * FROM products WHERE id = 1229
246 0.0003 0.0003058910369873
SELECT * FROM products WHERE id = '739'
247 0.0003 0.00028014183044434
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
248 0.0003 0.00026798248291016
SELECT * FROM product_image_select WHERE product_id = '739'
249 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '739'
250 0.0009 0.00093317031860352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
251 0.0003 0.00029802322387695
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
252 0.0003 0.00028610229492188
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0003 0.00031208992004395
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0003 0.0003058910369873
SELECT * FROM products WHERE id = '745'
255 0.0004 0.00035595893859863
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
256 0.0002 0.00024700164794922
SELECT * FROM product_image_select WHERE product_id = '745'
257 0.0002 0.00021100044250488
SELECT * FROM productcustomimages WHERE product_id = '745'
258 0.0006 0.00057387351989746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
259 0.0003 0.00026202201843262
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
260 0.0003 0.00026178359985352
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0002 0.00023794174194336
SELECT * FROM products WHERE id = '751'
263 0.0003 0.00031805038452148
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
264 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '751'
265 0.0002 0.00023317337036133
SELECT * FROM productcustomimages WHERE product_id = '751'
266 0.0004 0.00036978721618652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
267 0.0002 0.00020480155944824
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
268 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0003 0.0002751350402832
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0002 0.00024104118347168
SELECT * FROM products WHERE id = '755'
271 0.0005 0.00046205520629883
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
272 0.0003 0.00025105476379395
SELECT * FROM product_image_select WHERE product_id = '755'
273 0.0002 0.0001828670501709
SELECT * FROM productcustomimages WHERE product_id = '755'
274 0.0012 0.0012028217315674
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
275 0.0003 0.00033092498779297
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
276 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
277 0.0004 0.00035500526428223
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0004 0.00036406517028809
SELECT * FROM products WHERE id = '769'
279 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
280 0.0003 0.0002899169921875
SELECT * FROM product_image_select WHERE product_id = '769'
281 0.0003 0.00026106834411621
SELECT * FROM productcustomimages WHERE product_id = '769'
282 0.0010 0.00095319747924805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
283 0.0053 0.0053250789642334
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
284 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0006 0.00057101249694824
SELECT * FROM products WHERE id = '1229'
287 0.0005 0.00049090385437012
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
288 0.0003 0.00034403800964355
SELECT * FROM product_image_select WHERE product_id = '1229'
289 0.0003 0.0002892017364502
SELECT * FROM productcustomimages WHERE product_id = '1229'
290 0.0013 0.0013179779052734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
291 0.0004 0.00036811828613281
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
292 0.0004 0.00039815902709961
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0016 0.0016260147094727
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
295 0.0004 0.00038409233093262
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
296 0.0013 0.001255989074707
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
297 0.0009 0.00086498260498047
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
298 0.0003 0.00033211708068848
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
299 0.0011 0.0011019706726074
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
300 0.0009 0.00092911720275879
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
301 0.0007 0.00073695182800293
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'