Notice: Undefined index: ebay_keyword in /home/fsi65be/public_html/storeukwelovebearsclub56958/controllers/product.php on line 145
ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys
Have you seen our United States website? Visit We Love Bears (USA) today! We also have websites for: X

ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys

ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys
ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys ZaH 300ml 3D Animal Cup Morning Mug Coffee Teacup Cute Birthday Christmas Gift for Men Women Girls Boys (click images to enlarge)
Click Button for Price
Not Available Discontinued
Product prices and availability are accurate as of 2020-04-17 18:57:11 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

ZaH 3D animal mug! Cute animal in your mug, when you drink you will see the animal. You will have good start everyday when you see your animal every morning. It will give you happiness everyday. Hurry to get one!!!

Product Features

Made of ceramics, durable and heat-resistance 100% brand new and high quality Size: 4.6"*3.4"*2.6" (116mm*87mm*65mm); Volume: 230ml; Weight: 10oz (280g) Cute 3D mini animal in the cup, it will bring the happiness everyday Perfect gift for your childern, your family, your friends; Suitable for daily use, restaurant and party

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.0099620819092 316 0.2543 0


No Amazon API Requests Made.

Total time 2.0099620819092 seconds

Number Time From Start Name Description
1 0.1881160736084 Initialise Initialise FSB Function
2 0.19001007080078 App Controller Start Start of the App controller (called before the controller of every page)
3 0.1987030506134 Start of getCategoryListByGroup Function Before first category groups query
4 0.19937896728516 After initial query Before first category groups query
5 0.19937896728516 Get Category List for Group Before the call to getCategoryList function
6 0.19938206672668 Start of GetCategoryList function Start of the function
7 0.19938397407532 Before getting categories Query to get specific category list
8 0.2001039981842 After getting categories Query to get specific category list
9 0.20010495185852 Before getting category custom Before call to function getCategoryCustom
10 0.20669412612915 After getting category custom After call to function getCategoryCustom
11 0.20669794082642 Before getting category custom Before call to function getCategoryCustom
12 0.20910906791687 After getting category custom After call to function getCategoryCustom
13 0.20911192893982 Before getting category custom Before call to function getCategoryCustom
14 0.21166205406189 After getting category custom After call to function getCategoryCustom
15 0.21166396141052 Before getting category custom Before call to function getCategoryCustom
16 0.21371412277222 After getting category custom After call to function getCategoryCustom
17 0.21371603012085 Before getting category custom Before call to function getCategoryCustom
18 0.23237800598145 After getting category custom After call to function getCategoryCustom
19 0.23238205909729 Before getting category custom Before call to function getCategoryCustom
20 0.24038195610046 After getting category custom After call to function getCategoryCustom
21 0.24038505554199 Before getting category custom Before call to function getCategoryCustom
22 0.24292206764221 After getting category custom After call to function getCategoryCustom
23 0.24292492866516 Before getting category custom Before call to function getCategoryCustom
24 0.24536800384521 After getting category custom After call to function getCategoryCustom
25 0.24536991119385 Before getting category custom Before call to function getCategoryCustom
26 0.24763607978821 After getting category custom After call to function getCategoryCustom
27 0.24763894081116 End of GetCategoryList function End of the function
28 0.24764609336853 End of getCategoryListByGroup Function Before return()
29 0.3187141418457 App Controller End End of the App controller (called before the controller of every page)
30 0.3194739818573 Product Start Start of the product info controller
31 0.32149195671082 Cache file not found Starting get product details
32 0.34437608718872 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
33 0.84935712814331 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
34 0.85103106498718 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
35 1.268975019455 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
36 1.2934470176697 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
37 1.7441000938416 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
38 1.7451910972595 Related products Start getting related products if enabled
39 1.7451930046082 Related Products Start Before the related products are found
40 1.7451939582825 Related Products Keywords Before the related product keywords are found
41 1.7452039718628 Create Keyword List Function Start of function
42 1.7454290390015 Create Keyword List Function After looping provided content - 51 keywords found
43 1.7487819194794 Create Keyword List Function After looping initial keyword list - 45 keywords remaining
44 1.7488050460815 Create Keyword List Function After reducing keyword list
45 1.7495110034943 Create Keyword List Function After selecting by scoring keywords
46 1.7495200634003 Create Keyword List Function After final loop of keywords
47 1.7495250701904 Related Products Keywords After the related product keywords are found
48 1.7672910690308 Related Products End After the related products are found
49 1.7992689609528 Product End End of the product info controller (Product Info)
50 1.8009750843048 App_after Controller Start Start of the App_after controller (called after the controller of every page)
51 1.8025660514832 Before Get Options Before the call to getOptions in the tpl class
52 1.8275361061096 After Get Options After the call to getOptions in the tpl class
53 1.8276760578156 App_after Controller End End of the App_after controller (called after the controller of every page)
54 1.8277070522308 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
55 1.9355759620667 Product Info: After Smarty Fetch After the product.tpl template is fetched
56 1.9355809688568 Product Info: Before Template Display Before the template is displayed
57 2.0099449157715 Product Info: After Template Display After the template is displayed
58 2.0099511146545 Finalizing debug Before the debug is output to the page.
59 2.0099620819092 End of App This is the end of the app logging, final timestamp


Query Debug - 316 Database Queries. Total time 0.2543 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00037002563476562
SELECT parameter, value FROM parameters
2 0.0011 0.0010888576507568
SELECT * FROM `bad_bots`
3 0.0003 0.0003209114074707
SET time_zone = 'Europe/London'
4 0.0008 0.00080108642578125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00083494186401367
SELECT * FROM autorun ORDER BY lastrun ASC
6 0.0003 0.00027203559875488
UPDATE autorun SET lastrun = '2020-08-09 13:41:16' WHERE id = '16'
7 0.0002 0.00022196769714355
SELECT * FROM version ORDER BY installed DESC LIMIT 1
8 0.0008 0.00077104568481445
SELECT id FROM pages WHERE pagename = 'zah-300ml-3d-animal-cup-morning-mug-coffee-teacup-cute-birthday' LIMIT 1
9 0.0005 0.00050592422485352
SELECT id FROM products WHERE pagename = 'zah-300ml-3d-animal-cup-morning-mug-coffee-teacup-cute-birthday' AND hidden = 0 LIMIT 1
10 0.0008 0.00075101852416992
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
11 0.0069 0.0069169998168945
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'en'
12 0.0003 0.00025796890258789
SELECT * FROM pages WHERE pagename = 'zah-300ml-3d-animal-cup-morning-mug-coffee-teacup-cute-birthday'
13 0.0007 0.00066590309143066
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0007 0.00069689750671387
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
15 0.0020 0.0019819736480713
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.0006 0.00058388710021973
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.0005 0.00052309036254883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
18 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '26'
19 0.0015 0.0015041828155518
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.0006 0.0005640983581543
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.0006 0.00056910514831543
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.0004 0.00035500526428223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
23 0.0002 0.00019097328186035
SELECT * FROM categorygroups WHERE id = '1'
24 0.0005 0.00052905082702637
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
25 0.0002 0.00020122528076172
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.0001 0.00013208389282227
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
27 0.0002 0.00018310546875
SELECT id FROM categories WHERE parent_id = '27'
28 0.0005 0.00048685073852539
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.00018692016601562
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.00019502639770508
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.00021004676818848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
32 0.0002 0.00019502639770508
SELECT * FROM categorygroups WHERE id = '1'
33 0.0005 0.00053596496582031
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
34 0.0002 0.00021600723266602
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.0001838207244873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
36 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '28'
37 0.0005 0.00052094459533691
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.00020098686218262
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.00023984909057617
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
41 0.0002 0.00018501281738281
SELECT * FROM categorygroups WHERE id = '1'
42 0.0003 0.00028800964355469
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.00021791458129883
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.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
45 0.0002 0.00018596649169922
SELECT id FROM categories WHERE parent_id = '29'
46 0.0003 0.00028705596923828
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.00018906593322754
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.0001990795135498
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.0001981258392334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
50 0.0002 0.00020408630371094
SELECT * FROM categorygroups WHERE id = '1'
51 0.0007 0.0006561279296875
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.00022983551025391
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.00021505355834961
SELECT id FROM categories WHERE parent_id = '30'
55 0.0161 0.016096115112305
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.0004 0.00036883354187012
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.000244140625
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.0003 0.00032615661621094
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
59 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
60 0.0005 0.00046420097351074
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
61 0.0002 0.00022602081298828
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.00019192695617676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
63 0.0002 0.00021815299987793
SELECT id FROM categories WHERE parent_id = '31'
64 0.0005 0.00048279762268066
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.0053 0.0052559375762939
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.0003 0.00031709671020508
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.00021696090698242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
68 0.0005 0.00048089027404785
SELECT * FROM categorygroups WHERE id = '1'
69 0.0004 0.00043821334838867
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.00023007392883301
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.00021195411682129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 32
72 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '32'
73 0.0005 0.00047111511230469
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.00020694732666016
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.00021505355834961
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
76 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
77 0.0003 0.00025510787963867
SELECT * FROM categorygroups WHERE id = '1'
78 0.0005 0.00046706199645996
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 33
79 0.0002 0.00022101402282715
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.00018715858459473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 33
81 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '33'
82 0.0004 0.0003969669342041
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (33)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00021600723266602
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.00027108192443848
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (33)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
85 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '33'
86 0.0002 0.00019693374633789
SELECT * FROM categorygroups WHERE id = '1'
87 0.0004 0.00037813186645508
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.00016689300537109
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.00019192695617676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
90 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '34'
91 0.0004 0.00040602684020996
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.00020599365234375
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.0002138614654541
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.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
95 0.0002 0.00019693374633789
SELECT * FROM categorygroups WHERE id = '1'
96 0.0008 0.00080013275146484
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
97 0.0005 0.00047588348388672
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
98 0.0003 0.00030279159545898
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.0006 0.00055885314941406
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
100 0.0005 0.00045299530029297
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
101 0.0534 0.053410053253174
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)
102 0.0127 0.012724161148071
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
103 0.0010 0.0010151863098145
SELECT * FROM countryredirects WHERE countrycode = 'US'
104 0.0003 0.00026893615722656
SELECT * FROM countryredirects WHERE id <> 1
105 0.0005 0.00046992301940918
SELECT * FROM products WHERE pagename = 'zah-300ml-3d-animal-cup-morning-mug-coffee-teacup-cute-birthday'
106 0.0011 0.0011498928070068
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1472
107 0.0002 0.00022292137145996
SELECT * FROM manufacturers WHERE id = '0'
108 0.0002 0.00024580955505371
SELECT category_id FROM products_categories WHERE product_id = '1472'
109 0.0002 0.00023102760314941
SELECT * FROM categories WHERE id = '30'
110 0.0006 0.00058484077453613
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.0003 0.00026893615722656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
112 0.0002 0.00021886825561523
SELECT id FROM categories WHERE parent_id = '30'
113 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 
114 0.0057 0.0056998729705811
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.0004 0.00037312507629395
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.0004 0.00041508674621582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
117 0.0010 0.0010440349578857
SELECT * FROM productimages WHERE product_id = '1472' ORDER BY sortorder ASC
118 0.0008 0.00075316429138184
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1472' AND p.id = pi.product_id ORDER BY pi.sortorder
119 0.0007 0.00072407722473145
SELECT * FROM product_image_select WHERE product_id = '1472'
120 0.0004 0.00036096572875977
SELECT * FROM productcustomimages WHERE product_id = '1472'
121 0.0004 0.00036311149597168
SELECT * FROM productfeeds WHERE product_id = '1472' ORDER BY item_date DESC
122 0.0007 0.00065088272094727
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1472' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
123 0.0006 0.00061297416687012
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1472' AND t.hidden = 0 AND display_product = 1
124 0.0004 0.00040888786315918
SELECT * FROM productamazoncontent WHERE product_id = '1472'
125 0.0007 0.00068306922912598
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 = '1472'
                GROUP BY o.product_id
126 0.0008 0.00078582763671875
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     = '1472'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0005 0.0004880428314209
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1472
128 0.0005 0.00052285194396973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1472' AND a.name = n.originalname
129 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '1472' AND merchantid = 'A3P5ROKL5A1OLE'
130 0.0002 0.00023818016052246
SELECT * FROM productoffers
                WHERE product_id = '1472' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = 1472
                ORDER BY price ASC LIMIT 1
132 0.0002 0.00023317337036133
SELECT value FROM productattributes
                WHERE product_id = '1472'
                AND name = 'ListPriceAmount'
133 0.0005 0.00047397613525391
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 = '1472'
                GROUP BY o.product_id
134 0.0004 0.00041604042053223
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     = '1472'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 0.0011 0.0010759830474854
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1472
136 0.0003 0.00033116340637207
SELECT value FROM productattributes WHERE product_id = '1472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0006 0.0005800724029541
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1472'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
138 0.0005 0.00047492980957031
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.00033783912658691
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.0008 0.00076794624328613
SELECT * FROM ebay_locale_details WHERE cur_code = 'GBP' 
141 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
142 0.0010 0.0010199546813965
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=ZaH+300ml+3D+Animal+Cup+Morning+Mug+Coffee+Teacup+Cute+Birthday+Christmas+Gift+for+Men+Women+Girls+Boys&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.50499320030212', '48cee6c01147ed5f50c93824afcb49f7', 'https://store-uk.welovebears.club/zah-300ml-3d-animal-cup-morning-mug-coffee-teacup-cute-birthday/'
143 0.0003 0.00032496452331543
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.0124 0.012400150299072
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=ZaH+300ml+3D&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.41795110702515', '48cee6c01147ed5f50c93824afcb49f7', 'https://store-uk.welovebears.club/zah-300ml-3d-animal-cup-morning-mug-coffee-teacup-cute-birthday/'
145 0.0119 0.011851072311401
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.0006 0.00056791305541992
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=ZaH+300ml&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.45066499710083', '48cee6c01147ed5f50c93824afcb49f7', 'https://store-uk.welovebears.club/zah-300ml-3d-animal-cup-morning-mug-coffee-teacup-cute-birthday/'
147 0.0037 0.0036959648132324
SELECT *, MATCH (description, title) AGAINST ('birthday christmas gift' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('birthday christmas gift' IN BOOLEAN MODE) AND 1472 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
148 0.0005 0.00051689147949219
SELECT *, MATCH (description, title) AGAINST ('birthday christmas gift' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('birthday christmas gift' IN BOOLEAN MODE) AND 1472 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
149 0.0004 0.00039291381835938
SELECT *, MATCH (description, title) AGAINST ('birthday christmas gift' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('birthday christmas gift' IN BOOLEAN MODE) AND 1472 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
150 0.0005 0.00050091743469238
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
151 0.0003 0.00031590461730957
SELECT * FROM product_image_select WHERE product_id = '751'
152 0.0003 0.00026106834411621
SELECT * FROM productcustomimages WHERE product_id = '751'
153 0.0006 0.00061798095703125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
154 0.0003 0.00032997131347656
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
155 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0005 0.00047397613525391
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0032 0.0031900405883789
SELECT *, MATCH (description, title) AGAINST ('morning mug coffee' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('morning mug coffee' IN BOOLEAN MODE) AND 1472 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
158 0.0004 0.00044393539428711
SELECT *, MATCH (description, title) AGAINST ('morning mug coffee' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('morning mug coffee' IN BOOLEAN MODE) AND 1472 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
159 0.0004 0.0003972053527832
SELECT *, MATCH (description, title) AGAINST ('morning mug coffee' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('morning mug coffee' IN BOOLEAN MODE) AND 1472 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
160 0.0003 0.00034499168395996
SELECT * FROM productimages WHERE product_id = '1470' ORDER BY sortorder ASC
161 0.0005 0.00051498413085938
SELECT * FROM product_image_select WHERE product_id = '1470'
162 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '1470'
163 0.0008 0.00076103210449219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1470' AND a.name = n.originalname
164 0.0002 0.00024008750915527
SELECT * FROM productoffers WHERE product_id = '1470' AND merchantid = 'A3P5ROKL5A1OLE'
165 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = '1470' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0003 0.00031399726867676
SELECT value FROM productattributes WHERE product_id = '1470' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '1471' ORDER BY sortorder ASC
168 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '1471'
169 0.0002 0.00019502639770508
SELECT * FROM productcustomimages WHERE product_id = '1471'
170 0.0008 0.00082898139953613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1471' AND a.name = n.originalname
171 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '1471' AND merchantid = 'A3P5ROKL5A1OLE'
172 0.0003 0.00026321411132812
SELECT * FROM productoffers
                WHERE product_id = '1471' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00032782554626465
SELECT value FROM productattributes WHERE product_id = '1471' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0003 0.00028586387634277
SELECT id,asin FROM products WHERE parent_id = 1472
175 0.0003 0.00026988983154297
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1602
176 0.0003 0.00027203559875488
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1602
177 0.0002 0.00024890899658203
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1509
178 0.0003 0.00027084350585938
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1509
179 0.0003 0.00026798248291016
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1477
180 0.0003 0.00027918815612793
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1477
181 0.0003 0.00025010108947754
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1478
182 0.0003 0.00027704238891602
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1478
183 0.0003 0.00025606155395508
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1479
184 0.0003 0.00025820732116699
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1479
185 0.0002 0.00023794174194336
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1480
186 0.0003 0.0002598762512207
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1480
187 0.0004 0.0003659725189209
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1482
188 0.0002 0.00024294853210449
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1482
189 0.0002 0.00022792816162109
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1483
190 0.0002 0.00024795532226562
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1483
191 0.0002 0.00022387504577637
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1485
192 0.0002 0.00023412704467773
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1485
193 0.0002 0.00022101402282715
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1486
194 0.0003 0.00026392936706543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1486
195 0.0002 0.00023102760314941
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1551
196 0.0003 0.00027894973754883
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1551
197 0.0002 0.00023889541625977
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1530
198 0.0003 0.00026297569274902
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1530
199 0.0003 0.00025296211242676
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1581
200 0.0003 0.00025200843811035
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1581
201 0.0002 0.00024104118347168
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1580
202 0.0003 0.00026988983154297
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1580
203 0.0008 0.00082802772521973
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1472' ORDER BY timestamp DESC
204 0.0044 0.0044350624084473
SELECT category_id FROM products_categories WHERE product_id = '1472'
205 0.0004 0.00040698051452637
SELECT * FROM categories WHERE id = '30'
206 0.0010 0.0010368824005127
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
207 0.0002 0.00024986267089844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
208 0.0003 0.00029993057250977
SELECT id FROM categories WHERE parent_id = '30'
209 0.0012 0.0012009143829346
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 
210 0.0004 0.00042104721069336
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 
211 0.0004 0.00043296813964844
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
212 0.0003 0.0002739429473877
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
213 0.0014 0.0014140605926514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1472' AND a.name = n.originalname
214 0.0004 0.00040817260742188
SELECT * FROM productoffers WHERE product_id = '1472' AND merchantid = 'A3P5ROKL5A1OLE'
215 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '1472' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0003 0.00032615661621094
SELECT * FROM productoffers
                WHERE product_id = 1472
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00038599967956543
SELECT value FROM productattributes
                WHERE product_id = '1472'
                AND name = 'ListPriceAmount'
218 0.0004 0.00044512748718262
SELECT * FROM products WHERE id = '1472'
219 0.0009 0.00094294548034668
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 = '1472'
                GROUP BY o.product_id
220 0.0007 0.0007328987121582
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     = '1472'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
221 0.0009 0.00089192390441895
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1472
222 0.0005 0.00048208236694336
SELECT value FROM productattributes WHERE product_id = '1472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0011 0.0010979175567627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1472' AND a.name = n.originalname
224 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '1472' AND merchantid = 'A3P5ROKL5A1OLE'
225 0.0004 0.00039196014404297
SELECT * FROM productoffers
                WHERE product_id = '1472' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00035309791564941
SELECT * FROM productoffers
                WHERE product_id = 1472
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00039100646972656
SELECT value FROM productattributes
                WHERE product_id = '1472'
                AND name = 'ListPriceAmount'
228 0.0004 0.00043177604675293
SELECT DISTINCT (name) FROM productoptions
229 0.0006 0.00057315826416016
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 1472))
230 0.0004 0.0003969669342041
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 1472
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
231 0.0005 0.00052905082702637
SELECT * FROM translationsfilter
232 0.0002 0.00023794174194336
SELECT category_id FROM products_categories WHERE product_id = '1472' AND prod_type = 'amz'
233 0.0002 0.00021100044250488
SELECT parent_id FROM categories WHERE id = '30'
234 0.0002 0.00022482872009277
SELECT * FROM categories WHERE id = '30'
235 0.0006 0.00057005882263184
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
236 0.0002 0.00019717216491699
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
237 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '30'
238 0.0006 0.00057291984558105
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 
239 0.0002 0.0002140998840332
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 
240 0.0002 0.00024199485778809
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
241 0.0003 0.00026106834411621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
242 0.0012 0.0011768341064453
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
243 0.0010 0.001039981842041
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
244 0.0004 0.00036311149597168
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
245 0.0003 0.00033402442932129
SELECT * FROM pages WHERE id = 42
246 0.0003 0.00027894973754883
SELECT * FROM pages WHERE id = 55
247 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = 45
248 0.0002 0.00022315979003906
SELECT * FROM pages WHERE id = 51
249 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = 42
250 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = 37
251 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = 44
252 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = 53
253 0.0008 0.00078320503234863
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
254 0.0003 0.00029706954956055
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:1596980477;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'
255 0.0003 0.00025820732116699
SELECT * FROM products WHERE id = 739
256 0.0002 0.00023794174194336
SELECT * FROM products WHERE id = 745
257 0.0002 0.00023698806762695
SELECT * FROM products WHERE id = 751
258 0.0002 0.00023698806762695
SELECT * FROM products WHERE id = 755
259 0.0002 0.00023293495178223
SELECT * FROM products WHERE id = 769
260 0.0002 0.00023388862609863
SELECT * FROM products WHERE id = 1229
261 0.0003 0.00031089782714844
SELECT * FROM products WHERE id = '739'
262 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '739' ORDER BY sortorder ASC
263 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '739'
264 0.0002 0.00019383430480957
SELECT * FROM productcustomimages WHERE product_id = '739'
265 0.0006 0.00063300132751465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '739' AND a.name = n.originalname
266 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '739' AND merchantid = 'A3P5ROKL5A1OLE'
267 0.0003 0.00026988983154297
SELECT * FROM productoffers
                WHERE product_id = '739' AND price > 0
                ORDER BY price ASC LIMIT 1
268 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0002 0.00023984909057617
SELECT * FROM products WHERE id = '745'
270 0.0003 0.00028300285339355
SELECT * FROM productimages WHERE product_id = '745' ORDER BY sortorder ASC
271 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '745'
272 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '745'
273 0.0006 0.0005800724029541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '745' AND a.name = n.originalname
274 0.0002 0.0002448558807373
SELECT * FROM productoffers WHERE product_id = '745' AND merchantid = 'A3P5ROKL5A1OLE'
275 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '745' AND price > 0
                ORDER BY price ASC LIMIT 1
276 0.0003 0.00027799606323242
SELECT value FROM productattributes WHERE product_id = '745' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
277 0.0003 0.00025510787963867
SELECT * FROM products WHERE id = '751'
278 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '751' ORDER BY sortorder ASC
279 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '751'
280 0.0002 0.00019502639770508
SELECT * FROM productcustomimages WHERE product_id = '751'
281 0.0003 0.00032877922058105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '751' AND a.name = n.originalname
282 0.0002 0.0002288818359375
SELECT * FROM productoffers WHERE product_id = '751' AND merchantid = 'A3P5ROKL5A1OLE'
283 0.0002 0.00024890899658203
SELECT * FROM productoffers
                WHERE product_id = '751' AND price > 0
                ORDER BY price ASC LIMIT 1
284 0.0003 0.00028204917907715
SELECT value FROM productattributes WHERE product_id = '751' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0002 0.00024604797363281
SELECT * FROM products WHERE id = '755'
286 0.0003 0.00025701522827148
SELECT * FROM productimages WHERE product_id = '755' ORDER BY sortorder ASC
287 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '755'
288 0.0002 0.00019598007202148
SELECT * FROM productcustomimages WHERE product_id = '755'
289 0.0007 0.00066208839416504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '755' AND a.name = n.originalname
290 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '755' AND merchantid = 'A3P5ROKL5A1OLE'
291 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '755' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0003 0.00028109550476074
SELECT value FROM productattributes WHERE product_id = '755' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0002 0.00020003318786621
SELECT * FROM products WHERE id = '769'
294 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '769' ORDER BY sortorder ASC
295 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '769'
296 0.0002 0.00020408630371094
SELECT * FROM productcustomimages WHERE product_id = '769'
297 0.0005 0.00046706199645996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '769' AND a.name = n.originalname
298 0.0007 0.0006561279296875
SELECT * FROM productoffers WHERE product_id = '769' AND merchantid = 'A3P5ROKL5A1OLE'
299 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '769' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0003 0.00026798248291016
SELECT value FROM productattributes WHERE product_id = '769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0002 0.00024700164794922
SELECT * FROM products WHERE id = '1229'
302 0.0003 0.00032186508178711
SELECT * FROM productimages WHERE product_id = '1229' ORDER BY sortorder ASC
303 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '1229'
304 0.0002 0.00019478797912598
SELECT * FROM productcustomimages WHERE product_id = '1229'
305 0.0006 0.00059008598327637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1229' AND a.name = n.originalname
306 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '1229' AND merchantid = 'A3P5ROKL5A1OLE'
307 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '1229' AND price > 0
                ORDER BY price ASC LIMIT 1
308 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '1229' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0010 0.0010371208190918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
310 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
311 0.0014 0.0014059543609619
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
312 0.0008 0.00077509880065918
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
313 0.0003 0.00031709671020508
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
314 0.0003 0.00033712387084961
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
315 0.0003 0.00028681755065918
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
316 0.0005 0.00046491622924805
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'