0

Yogi Tea - Bedtime Rooibos Vanilla - 30.6g

Price: €11,86
Product prices and availability are accurate as of 2022-06-25 17:11:59 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
En stock.
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.

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

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7599260807037 261 0.9279 0


No Amazon API Requests Made.


App Debug - Total Time 1.7599260807037 seconds

Number Time From Start Name Description
1 0.69433093070984 Initialise Initialise FSB Function
2 0.70639395713806 App Controller Start Start of the App controller (called before the controller of every page)
3 0.74643802642822 Start of getCategoryListByGroup Function Before first category groups query
4 0.74961590766907 After initial query Before first category groups query
5 0.74961709976196 Get Category List for Group Before the call to getCategoryList function
6 0.74961996078491 Start of GetCategoryList function Start of the function
7 0.74962306022644 Before getting categories Query to get specific category list
8 0.75170803070068 After getting categories Query to get specific category list
9 0.75170993804932 Before getting category custom Before call to function getCategoryCustom
10 0.77962803840637 After getting category custom After call to function getCategoryCustom
11 0.77963089942932 Before getting category custom Before call to function getCategoryCustom
12 0.79337501525879 After getting category custom After call to function getCategoryCustom
13 0.79337811470032 Before getting category custom Before call to function getCategoryCustom
14 0.80754089355469 After getting category custom After call to function getCategoryCustom
15 0.80754399299622 Before getting category custom Before call to function getCategoryCustom
16 0.81409597396851 After getting category custom After call to function getCategoryCustom
17 0.81410002708435 Before getting category custom Before call to function getCategoryCustom
18 0.81994199752808 After getting category custom After call to function getCategoryCustom
19 0.8199450969696 Before getting category custom Before call to function getCategoryCustom
20 0.82534003257751 After getting category custom After call to function getCategoryCustom
21 0.82534289360046 End of GetCategoryList function End of the function
22 0.82535004615784 Get Category List for Group Before the call to getCategoryList function
23 0.82535195350647 Start of GetCategoryList function Start of the function
24 0.82535409927368 Before getting categories Query to get specific category list
25 0.82591891288757 End of getCategoryListByGroup Function Before return()
26 1.4052810668945 App Controller End End of the App controller (called before the controller of every page)
27 1.4059510231018 Product Start Start of the product info controller
28 1.4410579204559 Cache file not found Starting get product details
29 1.4965310096741 Related products Start getting related products if enabled
30 1.4965329170227 Related Products Start Before the related products are found
31 1.4965350627899 Related Products Keywords Before the related product keywords are found
32 1.4965400695801 Create Keyword List Function Start of function
33 1.4966108798981 Create Keyword List Function After looping provided content - 15 keywords found
34 1.4972319602966 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.497239112854 Create Keyword List Function After reducing keyword list
36 1.4972629547119 Create Keyword List Function After selecting by scoring keywords
37 1.4972670078278 Create Keyword List Function After final loop of keywords
38 1.4972689151764 Related Products Keywords After the related product keywords are found
39 1.5359780788422 Related Products End After the related products are found
40 1.5673940181732 Product End End of the product info controller (Product Info)
41 1.5700058937073 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.5717780590057 Before Get Options Before the call to getOptions in the tpl class
43 1.6400389671326 After Get Options After the call to getOptions in the tpl class
44 1.640202999115 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.6402349472046 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.692507982254 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6925148963928 Product Info: Before Template Display Before the template is displayed
48 1.7598919868469 Product Info: After Template Display After the template is displayed
49 1.759908914566 Finalizing debug Before the debug is output to the page.
50 1.7599248886108 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.9279 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0022778511047363
SELECT parameter, value FROM parameters
2 0.0047 0.0046989917755127
SELECT * FROM `bad_bots`
3 0.0004 0.0004279613494873
SET time_zone = 'Europe/London'
4 0.0035 0.0034539699554443
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0048 0.0047919750213623
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.218.185.99\";}'
6 0.0040 0.003993034362793
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1733374039'
7 0.0051 0.0051281452178955
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00084209442138672
UPDATE autorun SET lastrun = '2024-12-05 04:47:19' WHERE id = '12'
9 0.0013 0.0012640953063965
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0050 0.0050249099731445
SELECT id FROM pages WHERE pagename = 'yogi-tea-bedtime-rooibos-vanilla-306g' LIMIT 1
11 0.0051 0.0050520896911621
SELECT id FROM products WHERE pagename = 'yogi-tea-bedtime-rooibos-vanilla-306g' AND hidden = 0 LIMIT 1
12 0.0046 0.0046160221099854
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0338 0.033799886703491
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0011 0.0010721683502197
SELECT * FROM pages WHERE pagename = 'yogi-tea-bedtime-rooibos-vanilla-306g'
15 0.0032 0.0031650066375732
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0021 0.0020651817321777
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0083 0.0083420276641846
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
18 0.0019 0.0019428730010986
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0016 0.0016140937805176
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00049304962158203
SELECT id FROM categories WHERE parent_id = '26'
21 0.0086 0.0085601806640625
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 
22 0.0029 0.0028951168060303
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 
23 0.0016 0.0016140937805176
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
24 0.0018 0.0017530918121338
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00057697296142578
SELECT * FROM categorygroups WHERE id = '1'
26 0.0052 0.0052130222320557
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
27 0.0007 0.00071001052856445
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00043892860412598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.0004580020904541
SELECT id FROM categories WHERE parent_id = '27'
30 0.0047 0.0046858787536621
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 
31 0.0006 0.00059700012207031
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 
32 0.0006 0.00058984756469727
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
33 0.0005 0.00049400329589844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00046610832214355
SELECT * FROM categorygroups WHERE id = '1'
35 0.0045 0.0044870376586914
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
36 0.0008 0.0008091926574707
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0007 0.00067400932312012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0007 0.00066494941711426
SELECT id FROM categories WHERE parent_id = '28'
39 0.0039 0.0039260387420654
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 
40 0.0008 0.00082206726074219
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 
41 0.0009 0.00092291831970215
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
42 0.0009 0.00090408325195312
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0009 0.00085711479187012
SELECT * FROM categorygroups WHERE id = '1'
44 0.0009 0.00085997581481934
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
45 0.0006 0.00062394142150879
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0006 0.00056004524230957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0006 0.00058078765869141
SELECT id FROM categories WHERE parent_id = '29'
48 0.0011 0.0011041164398193
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 
49 0.0007 0.00071907043457031
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 
50 0.0007 0.00070810317993164
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
51 0.0007 0.00068497657775879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0006 0.00061392784118652
SELECT * FROM categorygroups WHERE id = '1'
53 0.0008 0.0007941722869873
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
54 0.0007 0.00067400932312012
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0005 0.00052905082702637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0006 0.00055313110351562
SELECT id FROM categories WHERE parent_id = '30'
57 0.0010 0.00096583366394043
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 
58 0.0006 0.00055503845214844
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 
59 0.0006 0.0006108283996582
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
60 0.0006 0.00058603286743164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00048208236694336
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00068902969360352
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
63 0.0005 0.00051283836364746
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0005 0.00046801567077637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00047802925109863
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00083279609680176
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 
67 0.0007 0.00068092346191406
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 
68 0.0006 0.00058984756469727
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
69 0.0006 0.00057005882263184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00049090385437012
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00055408477783203
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0033 0.0032811164855957
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0019 0.0019140243530273
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.00066399574279785
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
75 0.0013 0.0012781620025635
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0014 0.0013918876647949
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0011 0.0010907649993896
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5639 0.56393098831177
SELECT * FROM ipgeocountries WHERE INET_ATON('18.218.185.99') >= INET_ATON(ip_start) AND INET_ATON('18.218.185.99') <= INET_ATON(ip_end)
79 0.0023 0.0023350715637207
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.001406192779541
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00078701972961426
SELECT * FROM products WHERE pagename = 'yogi-tea-bedtime-rooibos-vanilla-306g'
82 0.0007 0.00065398216247559
UPDATE products SET viewcount = viewcount + 1 WHERE id = 890
83 0.0011 0.001147985458374
SELECT * FROM manufacturers WHERE id = '226'
84 0.0011 0.0011250972747803
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '226'
85 0.0037 0.0036859512329102
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '226' LIMIT 1
86 0.0041 0.0040571689605713
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '226' ORDER BY RAND() LIMIT 1
87 0.0008 0.0007941722869873
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
88 0.0007 0.00068998336791992
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '226'
89 0.0007 0.00074291229248047
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '226'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0006 0.00062704086303711
SELECT * FROM manufacturerimages WHERE manufacturer_id = '226'
91 0.0007 0.00066494941711426
SELECT category_id FROM products_categories WHERE product_id = '890'
92 0.0008 0.00084304809570312
SELECT * FROM categories WHERE id = '27'
93 0.0071 0.0070610046386719
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
94 0.0006 0.00062203407287598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0004 0.00041985511779785
SELECT id FROM categories WHERE parent_id = '27'
96 0.0059 0.0059149265289307
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 
97 0.0007 0.00074100494384766
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 
98 0.0008 0.00083804130554199
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
99 0.0007 0.00071191787719727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0006 0.0006108283996582
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
101 0.0020 0.0020310878753662
SELECT * FROM product_image_select WHERE product_id = '890'
102 0.0016 0.0015769004821777
SELECT * FROM productcustomimages WHERE product_id = '890'
103 0.0014 0.0014228820800781
SELECT * FROM productfeeds WHERE product_id = '890' ORDER BY item_date DESC
104 0.0027 0.0027267932891846
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0026 0.0025660991668701
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '890' AND t.hidden = 0 AND display_product = 1
106 0.0005 0.00045204162597656
SELECT * FROM tags WHERE id = '500'
107 0.0008 0.00082302093505859
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '500'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0006 0.00061202049255371
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '500'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0006 0.00062203407287598
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '500' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110 0.0007 0.0006721019744873
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
111 0.0006 0.00057411193847656
SELECT * FROM tags WHERE id = '198'
112 0.0011 0.0011179447174072
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '198'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
113 0.0008 0.00078105926513672
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '198'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
114 0.0006 0.0006260871887207
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '198' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
115 0.0005 0.0005340576171875
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
116 0.0018 0.0017929077148438
SELECT * FROM productamazoncontent WHERE product_id = '890'
117 0.0012 0.0011930465698242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
118 0.0015 0.0015320777893066
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00051498413085938
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0006 0.00056910514831543
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0006 0.00059700012207031
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
122 0.0100 0.010047912597656
SELECT *, MATCH (description, title) AGAINST ('bedtime rooibos vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bedtime rooibos vanilla' IN BOOLEAN MODE) AND 890 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
123 0.0009 0.00086212158203125
SELECT *, MATCH (description, title) AGAINST ('bedtime rooibos vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bedtime rooibos vanilla' IN BOOLEAN MODE) AND 890 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
124 0.0008 0.00075793266296387
SELECT *, MATCH (description, title) AGAINST ('bedtime rooibos vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bedtime rooibos vanilla' IN BOOLEAN MODE) AND 890 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
125 0.0008 0.00078010559082031
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
126 0.0007 0.00065779685974121
SELECT * FROM product_image_select WHERE product_id = '862'
127 0.0005 0.00049209594726562
SELECT * FROM productcustomimages WHERE product_id = '862'
128 0.0010 0.0010490417480469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
129 0.0007 0.00067901611328125
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0006 0.00058603286743164
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0005 0.00054192543029785
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0006 0.00057506561279297
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
133 0.0007 0.00073814392089844
SELECT * FROM product_image_select WHERE product_id = '865'
134 0.0006 0.00055718421936035
SELECT * FROM productcustomimages WHERE product_id = '865'
135 0.0010 0.00098299980163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
136 0.0006 0.00059819221496582
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0005 0.00053215026855469
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0006 0.00057101249694824
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0006 0.00061202049255371
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
140 0.0006 0.00062012672424316
SELECT * FROM product_image_select WHERE product_id = '878'
141 0.0005 0.00047898292541504
SELECT * FROM productcustomimages WHERE product_id = '878'
142 0.0009 0.0009458065032959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
143 0.0005 0.00053095817565918
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0005 0.00048303604125977
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0005 0.00052618980407715
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0006 0.00063991546630859
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
147 0.0006 0.0006258487701416
SELECT * FROM product_image_select WHERE product_id = '869'
148 0.0004 0.00043797492980957
SELECT * FROM productcustomimages WHERE product_id = '869'
149 0.0009 0.00089406967163086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
150 0.0005 0.00053691864013672
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00051188468933105
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0005 0.00048995018005371
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
154 0.0006 0.00061702728271484
SELECT * FROM product_image_select WHERE product_id = '4814'
155 0.0004 0.00043416023254395
SELECT * FROM productcustomimages WHERE product_id = '4814'
156 0.0010 0.0009768009185791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
157 0.0005 0.00050806999206543
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0006 0.00063109397888184
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
161 0.0006 0.00061821937561035
SELECT * FROM product_image_select WHERE product_id = '858'
162 0.0006 0.00056004524230957
SELECT * FROM productcustomimages WHERE product_id = '858'
163 0.0010 0.0010108947753906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
164 0.0005 0.00052094459533691
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0005 0.0004880428314209
SELECT id,asin FROM products WHERE parent_id = 890
168 0.0026 0.0025570392608643
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '890' ORDER BY timestamp DESC
169 0.0006 0.00058388710021973
SELECT category_id FROM products_categories WHERE product_id = '890'
170 0.0005 0.00051999092102051
SELECT * FROM categories WHERE id = '27'
171 0.0037 0.0037169456481934
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
172 0.0005 0.00047016143798828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
173 0.0004 0.0003819465637207
SELECT id FROM categories WHERE parent_id = '27'
174 0.0036 0.0036029815673828
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 
175 0.0006 0.00061202049255371
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 
176 0.0006 0.0006110668182373
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
177 0.0005 0.00052499771118164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
178 0.0012 0.0012228488922119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
179 0.0005 0.00054502487182617
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0005 0.00051212310791016
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0007 0.00067305564880371
SELECT * FROM products WHERE id = '890'
182 0.0005 0.00049304962158203
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0009 0.00093483924865723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
184 0.0006 0.00055694580078125
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0005 0.00049614906311035
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0005 0.00052499771118164
SELECT category_id FROM products_categories WHERE product_id = '890' AND prod_type = 'amz'
187 0.0005 0.00050187110900879
SELECT parent_id FROM categories WHERE id = '27'
188 0.0004 0.00040507316589355
SELECT * FROM categories WHERE id = '27'
189 0.0037 0.0036900043487549
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
190 0.0005 0.00050115585327148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0004 0.00040102005004883
SELECT id FROM categories WHERE parent_id = '27'
192 0.0035 0.0035388469696045
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 
193 0.0006 0.00059914588928223
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 
194 0.0006 0.00063991546630859
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
195 0.0006 0.00064897537231445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0020 0.0020060539245605
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0014 0.0013539791107178
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0003 0.00034904479980469
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0133 0.013286113739014
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
200 0.0018 0.0017809867858887
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
201 0.0006 0.00061988830566406
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
202 0.0006 0.00061392784118652
SELECT * FROM products WHERE id = 1626
203 0.0006 0.00060701370239258
SELECT * FROM products WHERE id = 4041
204 0.0005 0.00050616264343262
SELECT * FROM products WHERE id = 4312
205 0.0004 0.00044989585876465
SELECT * FROM products WHERE id = 777
206 0.0005 0.00053191184997559
SELECT * FROM products WHERE id = 3881
207 0.0006 0.00060582160949707
SELECT * FROM products WHERE id = 4213
208 0.0007 0.0006709098815918
SELECT * FROM products WHERE id = '1626'
209 0.0005 0.00050997734069824
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0009 0.00091385841369629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0005 0.00054812431335449
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0006 0.00056600570678711
SELECT * FROM products WHERE id = '4041'
217 0.0005 0.00049304962158203
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0007 0.00066995620727539
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0004 0.00042295455932617
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0013 0.00130295753479
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0004 0.00042819976806641
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0006 0.00059795379638672
SELECT * FROM products WHERE id = '4312'
225 0.0005 0.00050902366638184
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0007 0.00067901611328125
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0011 0.0010929107666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0005 0.00054287910461426
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0006 0.00059986114501953
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0006 0.00060105323791504
SELECT * FROM products WHERE id = '777'
233 0.0007 0.00068211555480957
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0007 0.00066208839416504
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0005 0.00048494338989258
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0011 0.0010957717895508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0007 0.00065398216247559
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0007 0.00065088272094727
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0005 0.00047898292541504
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0006 0.00061678886413574
SELECT * FROM products WHERE id = '3881'
241 0.0007 0.00072002410888672
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0007 0.00072097778320312
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0012 0.0011649131774902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0005 0.00053119659423828
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0006 0.00055193901062012
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0007 0.00066590309143066
SELECT * FROM products WHERE id = '4213'
249 0.0006 0.00060510635375977
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0008 0.00078606605529785
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0005 0.00052499771118164
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0014 0.0014441013336182
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0010 0.0010020732879639
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0008 0.00084519386291504
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0012 0.001162052154541
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0055 0.0055310726165771
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0017 0.0017299652099609
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0040 0.0039539337158203
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0027 0.0027210712432861
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0010 0.00098395347595215
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0011 0.0010988712310791
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'