Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~

Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~
Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~ Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~ Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~ Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~ Shop4Ever Mama Bear Novelty Ceramic Coffee Mug Tea Cup Gift ~ Mother's Day ~ (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-04-17 06:57:12 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

This makes a great gift for a coffee loving mom. Includes 1 Best Mom Ever mug. The mug is printed with the design on each side of white ceramic mug and can hold 11 oz. of liquid.

Product Features

Exclusively from Shop4Ever official Shop4Ever brand. Sturdy and durable design. Printed in the United States. HIGH QUALITY ~ Easy grip handle. Ceramic style 11 oz. mugs. UNIQUE GIFT FOR MOM ~ This is a great gift any mom. Great for an anniversay, mother's day or any holiday. DISHWASHER & MICROWAVE SAFE ~ For your convenience our mugs are dishwasher safe for easy cleaning and microwave safe for convenience. CUSTOMER SATISFACTION GUARANTEED! ~ Your opinion matters to us! If you aren't happy then we aren't happy! We are always here to help!

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

Write a Review

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
2.9186310768127 281 0.2314 0


No Amazon API Requests Made.

Total time 2.9186310768127 seconds

Number Time From Start Name Description
1 0.20765805244446 Initialise Initialise FSB Function
2 0.21082401275635 App Controller Start Start of the App controller (called before the controller of every page)
3 0.22317600250244 Start of getCategoryListByGroup Function Before first category groups query
4 0.22431802749634 After initial query Before first category groups query
5 0.22431898117065 Get Category List for Group Before the call to getCategoryList function
6 0.22432208061218 Start of GetCategoryList function Start of the function
7 0.22432494163513 Before getting categories Query to get specific category list
8 0.22528910636902 After getting categories Query to get specific category list
9 0.22529006004333 Before getting category custom Before call to function getCategoryCustom
10 0.23933696746826 After getting category custom After call to function getCategoryCustom
11 0.23934006690979 Before getting category custom Before call to function getCategoryCustom
12 0.24258613586426 After getting category custom After call to function getCategoryCustom
13 0.24258899688721 Before getting category custom Before call to function getCategoryCustom
14 0.24537515640259 After getting category custom After call to function getCategoryCustom
15 0.24538016319275 Before getting category custom Before call to function getCategoryCustom
16 0.24749708175659 After getting category custom After call to function getCategoryCustom
17 0.24749994277954 Before getting category custom Before call to function getCategoryCustom
18 0.25016808509827 After getting category custom After call to function getCategoryCustom
19 0.25016903877258 Before getting category custom Before call to function getCategoryCustom
20 0.25253796577454 After getting category custom After call to function getCategoryCustom
21 0.25254201889038 Before getting category custom Before call to function getCategoryCustom
22 0.25490307807922 After getting category custom After call to function getCategoryCustom
23 0.25490593910217 Before getting category custom Before call to function getCategoryCustom
24 0.25793313980103 After getting category custom After call to function getCategoryCustom
25 0.25793504714966 Before getting category custom Before call to function getCategoryCustom
26 0.26004099845886 After getting category custom After call to function getCategoryCustom
27 0.26004314422607 End of GetCategoryList function End of the function
28 0.2600531578064 End of getCategoryListByGroup Function Before return()
29 0.35649013519287 App Controller End End of the App controller (called before the controller of every page)
30 0.35740995407104 Product Start Start of the product info controller
31 0.3584451675415 Cache file not found Starting get product details
32 0.38507413864136 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.79249405860901 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.79561305046082 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
35 1.1745719909668 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
36 1.175714969635 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
37 1.8372311592102 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
38 1.8380200862885 Related products Start getting related products if enabled
39 1.8380200862885 Related Products Start Before the related products are found
40 1.8380210399628 Related Products Keywords Before the related product keywords are found
41 1.8380260467529 Create Keyword List Function Start of function
42 1.838142156601 Create Keyword List Function After looping provided content - 33 keywords found
43 1.8388121128082 Create Keyword List Function After looping initial keyword list - 29 keywords remaining
44 1.8388230800629 Create Keyword List Function After reducing keyword list
45 1.8388900756836 Create Keyword List Function After selecting by scoring keywords
46 1.8388931751251 Create Keyword List Function After final loop of keywords
47 1.8388950824738 Related Products Keywords After the related product keywords are found
48 1.8508110046387 Related Products End After the related products are found
49 1.8612561225891 Product End End of the product info controller (Product Info)
50 1.8628730773926 App_after Controller Start Start of the App_after controller (called after the controller of every page)
51 1.8643281459808 Before Get Options Before the call to getOptions in the tpl class
52 1.888916015625 After Get Options After the call to getOptions in the tpl class
53 1.8890340328217 App_after Controller End End of the App_after controller (called after the controller of every page)
54 1.8890600204468 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
55 2.9070639610291 Product Info: After Smarty Fetch After the product.tpl template is fetched
56 2.9070701599121 Product Info: Before Template Display Before the template is displayed
57 2.9186110496521 Product Info: After Template Display After the template is displayed
58 2.9186170101166 Finalizing debug Before the debug is output to the page.
59 2.9186301231384 End of App This is the end of the app logging, final timestamp


Query Debug - 281 Database Queries. Total time 0.2314 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0011 0.0010628700256348
SELECT parameter, value FROM parameters
2 0.0015 0.0014538764953613
SELECT * FROM `bad_bots`
3 0.0003 0.00028300285339355
SET time_zone = 'Europe/London'
4 0.0014 0.0013759136199951
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0028 0.0027940273284912
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0003 0.00028705596923828
UPDATE autorun SET lastrun = '2020-08-06 10:07:50' WHERE id = '13'
7 0.0002 0.00021100044250488
SELECT * FROM version ORDER BY installed DESC LIMIT 1
8 0.0011 0.0010519027709961
SELECT id FROM pages WHERE pagename = 'shop4ever-mama-bear-novelty-ceramic-coffee-mug-tea-cup-gift-mothers' LIMIT 1
9 0.0014 0.0014429092407227
SELECT id FROM products WHERE pagename = 'shop4ever-mama-bear-novelty-ceramic-coffee-mug-tea-cup-gift-mothers' AND hidden = 0 LIMIT 1
10 0.0019 0.0018861293792725
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
11 0.0094 0.0094311237335205
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
12 0.0003 0.00033020973205566
SELECT * FROM pages WHERE pagename = 'shop4ever-mama-bear-novelty-ceramic-coffee-mug-tea-cup-gift-mothers'
13 0.0011 0.001129150390625
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0009 0.00093507766723633
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0045 0.0044689178466797
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.0018 0.0017509460449219
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.0008 0.00081920623779297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
18 0.0003 0.00029492378234863
SELECT id FROM categories WHERE parent_id = '26'
19 0.0023 0.0022709369659424
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.0011 0.0010859966278076
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.0019 0.00187087059021
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.0009 0.00094795227050781
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
23 0.0003 0.0003199577331543
SELECT * FROM categorygroups WHERE id = '1'
24 0.0009 0.00091695785522461
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.0003 0.00032496452331543
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
26 0.0003 0.00026512145996094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
27 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '27'
28 0.0006 0.00061583518981934
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.00020408630371094
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.00019407272338867
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
32 0.0002 0.00018882751464844
SELECT * FROM categorygroups WHERE id = '1'
33 0.0006 0.00056791305541992
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.00021815299987793
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.00019502639770508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
36 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '28'
37 0.0006 0.00063800811767578
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.00021696090698242
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.00022315979003906
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.00020694732666016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
41 0.0002 0.00019717216491699
SELECT * FROM categorygroups WHERE id = '1'
42 0.0003 0.00028681755065918
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.00022506713867188
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.00021696090698242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
45 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '29'
46 0.0003 0.00029802322387695
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.00019478797912598
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.00020909309387207
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.00019288063049316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
50 0.0002 0.00017499923706055
SELECT * FROM categorygroups WHERE id = '1'
51 0.0007 0.0006709098815918
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.00021100044250488
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.00019311904907227
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
54 0.0002 0.00017285346984863
SELECT id FROM categories WHERE parent_id = '30'
55 0.0006 0.00057315826416016
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.00020885467529297
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.0001978874206543
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
59 0.0002 0.00022006034851074
SELECT * FROM categorygroups WHERE id = '1'
60 0.0004 0.0004270076751709
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.00020503997802734
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.00018310546875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
63 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '31'
64 0.0004 0.00041580200195312
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.00018191337585449
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.00019383430480957
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.00020503997802734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
68 0.0002 0.00024819374084473
SELECT * FROM categorygroups WHERE id = '1'
69 0.0004 0.00044798851013184
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.000244140625
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.00017213821411133
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
72 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '32'
73 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 (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
74 0.0002 0.00023102760314941
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.00018596649169922
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.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
77 0.0002 0.00018501281738281
SELECT * FROM categorygroups WHERE id = '1'
78 0.0004 0.00038790702819824
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 33
79 0.0003 0.0003349781036377
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.00024700164794922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
81 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '33'
82 0.0006 0.00063490867614746
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.0003 0.00026702880859375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (33)
				  AND p.disabled = 0 
84 0.0003 0.00026798248291016
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
85 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
86 0.0003 0.0002748966217041
SELECT * FROM categorygroups WHERE id = '1'
87 0.0005 0.00046896934509277
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.00018405914306641
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.00016093254089355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
90 0.0002 0.00018620491027832
SELECT id FROM categories WHERE parent_id = '34'
91 0.0004 0.00036096572875977
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.00016999244689941
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.00018596649169922
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.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
95 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
96 0.0015 0.0014948844909668
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
97 0.0009 0.00089693069458008
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
98 0.0003 0.00027203559875488
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.00041699409484863
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
100 0.0005 0.0005030632019043
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
101 0.0892 0.089245080947876
SELECT * FROM ipgeocountries WHERE INET_ATON('3.80.160.29') >= INET_ATON(ip_start) AND INET_ATON('3.80.160.29') <= INET_ATON(ip_end)
102 0.0012 0.0012049674987793
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
103 0.0012 0.0011920928955078
SELECT * FROM countryredirects WHERE countrycode = 'US'
104 0.0002 0.0002131462097168
SELECT * FROM countryredirects WHERE id <> 1
105 0.0003 0.00031900405883789
SELECT * FROM products WHERE pagename = 'shop4ever-mama-bear-novelty-ceramic-coffee-mug-tea-cup-gift-mothers'
106 0.0003 0.00034308433532715
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1653
107 0.0002 0.00018501281738281
SELECT * FROM manufacturers WHERE id = '252'
108 0.0002 0.00018596649169922
SELECT category_id FROM products_categories WHERE product_id = '1653'
109 0.0002 0.00019407272338867
SELECT * FROM categories WHERE id = '30'
110 0.0006 0.00056290626525879
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
111 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
112 0.0002 0.00017905235290527
SELECT id FROM categories WHERE parent_id = '30'
113 0.0007 0.0007178783416748
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 
114 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
115 0.0002 0.00023007392883301
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
116 0.0002 0.00016880035400391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
117 0.0080 0.0080358982086182
SELECT * FROM productimages WHERE product_id = '1653' ORDER BY sortorder ASC
118 0.0003 0.0002899169921875
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1653' AND p.id = pi.product_id ORDER BY pi.sortorder
119 0.0009 0.00091290473937988
SELECT * FROM product_image_select WHERE product_id = '1653'
120 0.0007 0.00072979927062988
SELECT * FROM productcustomimages WHERE product_id = '1653'
121 0.0008 0.0007929801940918
SELECT * FROM productfeeds WHERE product_id = '1653' ORDER BY item_date DESC
122 0.0020 0.0019731521606445
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1653' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
123 0.0020 0.0019898414611816
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1653' AND t.hidden = 0 AND display_product = 1
124 0.0010 0.00098204612731934
SELECT * FROM productamazoncontent WHERE product_id = '1653'
125 0.0008 0.00077700614929199
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 = '1653'
                GROUP BY o.product_id
126 0.0012 0.001230001449585
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     = '1653'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0002 0.00022387504577637
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1653
128 0.0008 0.00078988075256348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1653' AND a.name = n.originalname
129 0.0003 0.0002601146697998
SELECT * FROM productoffers WHERE product_id = '1653' AND merchantid = 'A3P5ROKL5A1OLE'
130 0.0003 0.00027894973754883
SELECT * FROM productoffers
                WHERE product_id = '1653' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00025081634521484
SELECT * FROM productoffers
                WHERE product_id = 1653
                ORDER BY price ASC LIMIT 1
132 0.0002 0.00023794174194336
SELECT value FROM productattributes
                WHERE product_id = '1653'
                AND name = 'ListPriceAmount'
133 0.0003 0.00025081634521484
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 = '1653'
                GROUP BY o.product_id
134 0.0004 0.00038719177246094
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     = '1653'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 0.0002 0.00020599365234375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1653
136 0.0003 0.00025105476379395
SELECT value FROM productattributes WHERE product_id = '1653' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0002 0.0002439022064209
SELECT * FROM products WHERE parent_id = '1653'
138 0.0003 0.00029587745666504
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
139 0.0003 0.00029993057250977
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
140 0.0011 0.0010790824890137
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
141 0.0003 0.00030112266540527
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
142 0.0023 0.0023148059844971
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=Shop4Ever+Mama+Bear+Novelty+Ceramic+Coffee+Mug+Tea+Cup+Gift+%7E+Mother%27s+Day+%7E&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.4074330329895', '27f823d49171bc536cfa1914617604d8', 'https://store-uk.welovebears.club/shop4ever-mama-bear-novelty-ceramic-coffee-mug-tea-cup-gift-mothers'
143 0.0004 0.0003821849822998
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.0005 0.00051498413085938
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=Shop4Ever+Mama+Bear&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.37896609306335', '27f823d49171bc536cfa1914617604d8', 'https://store-uk.welovebears.club/shop4ever-mama-bear-novelty-ceramic-coffee-mug-tea-cup-gift-mothers'
145 0.0004 0.00044798851013184
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.0005 0.00049901008605957
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=Shop4Ever+Mama&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.66152191162109', '27f823d49171bc536cfa1914617604d8', 'https://store-uk.welovebears.club/shop4ever-mama-bear-novelty-ceramic-coffee-mug-tea-cup-gift-mothers'
147 0.0016 0.0016000270843506
SELECT *, MATCH (description, title) AGAINST ('shop4ever mama bear' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('shop4ever mama bear' IN BOOLEAN MODE) AND 1653 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
148 0.0003 0.00025510787963867
SELECT *, MATCH (description, title) AGAINST ('shop4ever mama bear' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('shop4ever mama bear' IN BOOLEAN MODE) AND 1653 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
149 0.0002 0.00022220611572266
SELECT *, MATCH (description, title) AGAINST ('shop4ever mama bear' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('shop4ever mama bear' IN BOOLEAN MODE) AND 1653 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
150 0.0015 0.0014729499816895
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
151 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '745'
152 0.0002 0.00023698806762695
SELECT * FROM productcustomimages WHERE product_id = '745'
153 0.0011 0.0010831356048584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
154 0.0003 0.00033807754516602
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
155 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00024294853210449
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0008 0.00081586837768555
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
158 0.0003 0.00029611587524414
SELECT * FROM product_image_select WHERE product_id = '751'
159 0.0002 0.00023102760314941
SELECT * FROM productcustomimages WHERE product_id = '751'
160 0.0009 0.00086283683776855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
161 0.0003 0.00026488304138184
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
162 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
165 0.0002 0.00018620491027832
SELECT * FROM product_image_select WHERE product_id = '739'
166 0.0002 0.00015997886657715
SELECT * FROM productcustomimages WHERE product_id = '739'
167 0.0009 0.00094103813171387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
168 0.0003 0.00034689903259277
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
169 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0002 0.00024008750915527
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0002 0.00017690658569336
SELECT id,asin FROM products WHERE parent_id = 1653
172 0.0011 0.0010650157928467
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1653' ORDER BY timestamp DESC
173 0.0002 0.00018906593322754
SELECT category_id FROM products_categories WHERE product_id = '1653'
174 0.0002 0.00022101402282715
SELECT * FROM categories WHERE id = '30'
175 0.0005 0.00050997734069824
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
176 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
177 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '30'
178 0.0005 0.00052404403686523
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 
179 0.0002 0.00022387504577637
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 
180 0.0002 0.00020885467529297
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
181 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
182 0.0006 0.00059890747070312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1653' AND a.name = n.originalname
183 0.0002 0.00021910667419434
SELECT * FROM productoffers WHERE product_id = '1653' AND merchantid = 'A3P5ROKL5A1OLE'
184 0.0002 0.0002281665802002
SELECT * FROM productoffers
                WHERE product_id = '1653' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = 1653
                ORDER BY price ASC LIMIT 1
186 0.0002 0.00023484230041504
SELECT value FROM productattributes
                WHERE product_id = '1653'
                AND name = 'ListPriceAmount'
187 0.0002 0.00023293495178223
SELECT * FROM products WHERE id = '1653'
188 0.0002 0.0002439022064209
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 = '1653'
                GROUP BY o.product_id
189 0.0002 0.00023818016052246
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     = '1653'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
190 0.0002 0.00020909309387207
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1653
191 0.0002 0.00023603439331055
SELECT value FROM productattributes WHERE product_id = '1653' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0005 0.00053286552429199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1653' AND a.name = n.originalname
193 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '1653' AND merchantid = 'A3P5ROKL5A1OLE'
194 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '1653' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00018310546875
SELECT * FROM productoffers
                WHERE product_id = 1653
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00021791458129883
SELECT value FROM productattributes
                WHERE product_id = '1653'
                AND name = 'ListPriceAmount'
197 0.0002 0.00018692016601562
SELECT category_id FROM products_categories WHERE product_id = '1653' AND prod_type = 'amz'
198 0.0002 0.00017881393432617
SELECT parent_id FROM categories WHERE id = '30'
199 0.0002 0.00018191337585449
SELECT * FROM categories WHERE id = '30'
200 0.0005 0.0004889965057373
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
201 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
202 0.0002 0.00019001960754395
SELECT id FROM categories WHERE parent_id = '30'
203 0.0005 0.0005340576171875
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 
204 0.0002 0.0001671314239502
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 
205 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 (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
206 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
207 0.0012 0.0011579990386963
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
208 0.0011 0.0011031627655029
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
209 0.0002 0.00024795532226562
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
210 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = 42
211 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = 55
212 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = 45
213 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = 51
214 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = 42
215 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = 37
216 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = 44
217 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = 53
218 0.0006 0.00057101249694824
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
219 0.0008 0.0007939338684082
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:1596708472;s:8:\"products\";a:6:{i:0;s:10:\"739|amazon\";i:1;s:10:\"740|amazon\";i:2;s:10:\"745|amazon\";i:3;s:10:\"751|amazon\";i:4;s:10:\"755|amazon\";i:5;s:10:\"769|amazon\";}}' WHERE id = '244'
220 0.0002 0.0002129077911377
SELECT * FROM products WHERE id = 739
221 0.0002 0.00020313262939453
SELECT * FROM products WHERE id = 740
222 0.0002 0.00020098686218262
SELECT * FROM products WHERE id = 745
223 0.0002 0.00022602081298828
SELECT * FROM products WHERE id = 751
224 0.0002 0.00019216537475586
SELECT * FROM products WHERE id = 755
225 0.0002 0.00020003318786621
SELECT * FROM products WHERE id = 769
226 0.0002 0.00019121170043945
SELECT * FROM products WHERE id = '739'
227 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
228 0.0002 0.00017404556274414
SELECT * FROM product_image_select WHERE product_id = '739'
229 0.0002 0.00015497207641602
SELECT * FROM productcustomimages WHERE product_id = '739'
230 0.0006 0.00056099891662598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
231 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
232 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0002 0.00022196769714355
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0003 0.00030684471130371
SELECT * FROM products WHERE id = '740'
235 0.0004 0.00038909912109375
SELECT * FROM productimages WHERE product_id = '740' ORDER BY sortorder ASC
236 0.0002 0.00017905235290527
SELECT * FROM product_image_select WHERE product_id = '740'
237 0.0002 0.00015997886657715
SELECT * FROM productcustomimages WHERE product_id = '740'
238 0.0009 0.00091719627380371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '740' AND a.name = n.originalname
239 0.0004 0.00038695335388184
SELECT * FROM productoffers WHERE product_id = '740' AND merchantid = 'A3P5ROKL5A1OLE'
240 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '740' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00022506713867188
SELECT value FROM productattributes WHERE product_id = '740' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0002 0.0001981258392334
SELECT * FROM products WHERE id = '745'
243 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
244 0.0002 0.00018095970153809
SELECT * FROM product_image_select WHERE product_id = '745'
245 0.0002 0.0001518726348877
SELECT * FROM productcustomimages WHERE product_id = '745'
246 0.0005 0.00051307678222656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
247 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
248 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0002 0.00021815299987793
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0002 0.00019502639770508
SELECT * FROM products WHERE id = '751'
251 0.0003 0.00029706954956055
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
252 0.0002 0.00018095970153809
SELECT * FROM product_image_select WHERE product_id = '751'
253 0.0002 0.0001518726348877
SELECT * FROM productcustomimages WHERE product_id = '751'
254 0.0003 0.00026917457580566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
255 0.0003 0.00026202201843262
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
256 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0002 0.00022411346435547
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0002 0.00019383430480957
SELECT * FROM products WHERE id = '755'
259 0.0005 0.00045084953308105
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
260 0.0002 0.00017094612121582
SELECT * FROM product_image_select WHERE product_id = '755'
261 0.0002 0.0001518726348877
SELECT * FROM productcustomimages WHERE product_id = '755'
262 0.0008 0.00083279609680176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
263 0.0003 0.00032687187194824
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
264 0.0002 0.00023388862609863
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0002 0.00023698806762695
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0002 0.00021982192993164
SELECT * FROM products WHERE id = '769'
267 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
268 0.0002 0.0001838207244873
SELECT * FROM product_image_select WHERE product_id = '769'
269 0.0002 0.00016307830810547
SELECT * FROM productcustomimages WHERE product_id = '769'
270 0.0004 0.00038504600524902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
271 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
272 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0002 0.00022292137145996
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0014 0.0013711452484131
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
275 0.0003 0.00030803680419922
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
276 0.0027 0.0027189254760742
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
277 0.0013 0.001284122467041
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
278 0.0003 0.00030899047851562
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
279 0.0004 0.00043582916259766
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
280 0.0003 0.00027298927307129
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
281 0.0003 0.00033807754516602
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'