0

Tick Tock - Organic Rooibos Loose Leaf Tea - 100g

Price: €47,26
Product prices and availability are accurate as of 2021-07-20 01:53:13 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.
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.

Manufacturer Description

Tick Tock‘s organic loose leaf rooibos tea has deep colour and full taste. Our loose leaf rooibos tea is organically grown and well known for it's natural health benefits. In addition, Tick Tock rooibos tea is naturally caffeine free and low in tannin. Tick Tock is still harvested by hand and cured in the traditional way, as it was when Grandfather Benjamin Ginsberg founded Rooibos over 100 years ago. The process takes place in the crisp air of the Cedarberg Mountains of South Africa's Cape. It requires great skill to know when the cure is at its peak; one sign is that it begins to give off a deliciously sweet aroma that attracts wild bees.

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.2479541301727 261 0.8584 0


No Amazon API Requests Made.


App Debug - Total Time 1.2479541301727 seconds

Number Time From Start Name Description
1 0.32272005081177 Initialise Initialise FSB Function
2 0.33213114738464 App Controller Start Start of the App controller (called before the controller of every page)
3 0.36987400054932 Start of getCategoryListByGroup Function Before first category groups query
4 0.37137007713318 After initial query Before first category groups query
5 0.37137222290039 Get Category List for Group Before the call to getCategoryList function
6 0.37137603759766 Start of GetCategoryList function Start of the function
7 0.37137913703918 Before getting categories Query to get specific category list
8 0.37299799919128 After getting categories Query to get specific category list
9 0.3730001449585 Before getting category custom Before call to function getCategoryCustom
10 0.39503622055054 After getting category custom After call to function getCategoryCustom
11 0.3950400352478 Before getting category custom Before call to function getCategoryCustom
12 0.40662407875061 After getting category custom After call to function getCategoryCustom
13 0.40662813186646 Before getting category custom Before call to function getCategoryCustom
14 0.41365313529968 After getting category custom After call to function getCategoryCustom
15 0.41365599632263 Before getting category custom Before call to function getCategoryCustom
16 0.41857719421387 After getting category custom After call to function getCategoryCustom
17 0.41858100891113 Before getting category custom Before call to function getCategoryCustom
18 0.42360806465149 After getting category custom After call to function getCategoryCustom
19 0.42361116409302 Before getting category custom Before call to function getCategoryCustom
20 0.42864608764648 After getting category custom After call to function getCategoryCustom
21 0.42864918708801 End of GetCategoryList function End of the function
22 0.42865705490112 Get Category List for Group Before the call to getCategoryList function
23 0.42865920066833 Start of GetCategoryList function Start of the function
24 0.42866206169128 Before getting categories Query to get specific category list
25 0.42921805381775 End of getCategoryListByGroup Function Before return()
26 0.93877816200256 App Controller End End of the App controller (called before the controller of every page)
27 0.93909311294556 Product Start Start of the product info controller
28 0.9760901927948 Cache file not found Starting get product details
29 1.034548997879 Related products Start getting related products if enabled
30 1.0345501899719 Related Products Start Before the related products are found
31 1.0345511436462 Related Products Keywords Before the related product keywords are found
32 1.0345551967621 Create Keyword List Function Start of function
33 1.0346481800079 Create Keyword List Function After looping provided content - 21 keywords found
34 1.0356161594391 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 1.0356240272522 Create Keyword List Function After reducing keyword list
36 1.0356621742249 Create Keyword List Function After selecting by scoring keywords
37 1.0356650352478 Create Keyword List Function After final loop of keywords
38 1.035667181015 Related Products Keywords After the related product keywords are found
39 1.0750000476837 Related Products End After the related products are found
40 1.1121711730957 Product End End of the product info controller (Product Info)
41 1.1144330501556 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.1164591312408 Before Get Options Before the call to getOptions in the tpl class
43 1.1899621486664 After Get Options After the call to getOptions in the tpl class
44 1.1900842189789 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.1901051998138 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.2027251720428 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.2027289867401 Product Info: Before Template Display Before the template is displayed
48 1.2479400634766 Product Info: After Template Display After the template is displayed
49 1.2479431629181 Finalizing debug Before the debug is output to the page.
50 1.2479531764984 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.8584 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.002331018447876
SELECT parameter, value FROM parameters
2 0.0059 0.0059010982513428
SELECT * FROM `bad_bots`
3 0.0005 0.00053691864013672
SET time_zone = 'Europe/London'
4 0.0023 0.0023109912872314
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0036 0.0036499500274658
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.174\";}'
6 0.0037 0.0037209987640381
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738871613'
7 0.0044 0.0043830871582031
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.00098896026611328
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0035 0.0035371780395508
SELECT id FROM pages WHERE pagename = 'tick-tock-organic-rooibos-loose-leaf-tea-100g' LIMIT 1
10 0.0044 0.0043809413909912
SELECT id FROM products WHERE pagename = 'tick-tock-organic-rooibos-loose-leaf-tea-100g' AND hidden = 0 LIMIT 1
11 0.0055 0.0054771900177002
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0310 0.031003952026367
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00065183639526367
SELECT * FROM pages WHERE pagename = 'tick-tock-organic-rooibos-loose-leaf-tea-100g'
14 0.0015 0.0014829635620117
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0016 0.0015921592712402
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0065 0.006540060043335
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
17 0.0019 0.0018570423126221
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0012 0.0012378692626953
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00046896934509277
SELECT id FROM categories WHERE parent_id = '26'
20 0.0064 0.0064229965209961
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 
21 0.0017 0.0017449855804443
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 
22 0.0017 0.001737117767334
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
23 0.0014 0.00136399269104
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00046801567077637
SELECT * FROM categorygroups WHERE id = '1'
25 0.0039 0.0038578510284424
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
26 0.0005 0.00053691864013672
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00043296813964844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00044894218444824
SELECT id FROM categories WHERE parent_id = '27'
29 0.0039 0.0038609504699707
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 
30 0.0006 0.00056910514831543
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 
31 0.0007 0.00066399574279785
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
32 0.0006 0.00061988830566406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00045299530029297
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016491413116455
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
35 0.0005 0.00051212310791016
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0005 0.00046682357788086
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00046110153198242
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015659332275391
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 
39 0.0006 0.00060296058654785
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 
40 0.0006 0.00055193901062012
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
41 0.0006 0.00060009956359863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.0005040168762207
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00063610076904297
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
44 0.0005 0.00051784515380859
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00043010711669922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00044918060302734
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00072288513183594
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 
48 0.0005 0.00054693222045898
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 
49 0.0006 0.00057315826416016
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
50 0.0005 0.00048995018005371
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00044798851013184
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00072002410888672
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
53 0.0005 0.00052618980407715
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0005 0.00048303604125977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00048708915710449
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00072598457336426
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 
57 0.0005 0.00050497055053711
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 
58 0.0005 0.00054383277893066
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
59 0.0005 0.00049901008605957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.0004279613494873
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00062894821166992
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
62 0.0005 0.00051498413085938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0005 0.00046491622924805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00052285194396973
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.0007328987121582
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 
66 0.0005 0.0005040168762207
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 
67 0.0006 0.00055313110351562
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
68 0.0006 0.00058388710021973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043201446533203
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00054383277893066
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0032 0.003154993057251
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0021 0.0021460056304932
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.0008089542388916
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
74 0.0013 0.001295804977417
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0012428760528564
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010299682617188
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4940 0.49398684501648
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.174') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.174') <= INET_ATON(ip_end)
78 0.0027 0.0026509761810303
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0015 0.0015180110931396
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00066709518432617
SELECT * FROM products WHERE pagename = 'tick-tock-organic-rooibos-loose-leaf-tea-100g'
81 0.0005 0.00054097175598145
UPDATE products SET viewcount = viewcount + 1 WHERE id = 967
82 0.0011 0.0010890960693359
SELECT * FROM manufacturers WHERE id = '168'
83 0.0010 0.0010290145874023
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '168'
84 0.0032 0.0032169818878174
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '168' LIMIT 1
85 0.0040 0.0040340423583984
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '168' ORDER BY RAND() LIMIT 1
86 0.0009 0.00088405609130859
SELECT * FROM productimages WHERE product_id = '3646' ORDER BY sortorder ASC
87 0.0009 0.00094008445739746
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '168'
88 0.0010 0.00095105171203613
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '168'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0008 0.00084209442138672
SELECT * FROM manufacturerimages WHERE manufacturer_id = '168'
90 0.0009 0.00087189674377441
SELECT category_id FROM products_categories WHERE product_id = '967'
91 0.0009 0.00091409683227539
SELECT * FROM categories WHERE id = '27'
92 0.0085 0.0084800720214844
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
93 0.0007 0.00074410438537598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0005 0.00051593780517578
SELECT id FROM categories WHERE parent_id = '27'
95 0.0064 0.0063879489898682
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 
96 0.0007 0.00072908401489258
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 
97 0.0008 0.00076889991760254
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
98 0.0007 0.0006711483001709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.000640869140625
SELECT * FROM productimages WHERE product_id = '967' ORDER BY sortorder ASC
100 0.0025 0.0024809837341309
SELECT * FROM product_image_select WHERE product_id = '967'
101 0.0015 0.0014698505401611
SELECT * FROM productcustomimages WHERE product_id = '967'
102 0.0014 0.0013649463653564
SELECT * FROM productfeeds WHERE product_id = '967' ORDER BY item_date DESC
103 0.0027 0.0027389526367188
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '967' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0026 0.0025961399078369
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '967' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00043892860412598
SELECT * FROM tags WHERE id = '1'
106 0.0019 0.001856803894043
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0014 0.0014119148254395
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0014 0.0014100074768066
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0007 0.00067305564880371
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
110 0.0017 0.0016889572143555
SELECT * FROM productamazoncontent WHERE product_id = '967'
111 0.0012 0.001183032989502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '967' AND a.name = n.originalname
112 0.0022 0.0021710395812988
SELECT * FROM productoffers WHERE product_id = '967' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '967' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00043916702270508
SELECT * FROM productoffers
                WHERE product_id = 967
                ORDER BY price ASC LIMIT 1
115 0.0006 0.00056290626525879
SELECT value FROM productattributes
                WHERE product_id = '967'
                AND name = 'ListPriceAmount'
116 0.0005 0.00051784515380859
SELECT value FROM productattributes WHERE product_id = '967' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0006 0.0005950927734375
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
118 0.0095 0.0095319747924805
SELECT *, MATCH (description, title) AGAINST ('organic rooibos loose' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('organic rooibos loose' IN BOOLEAN MODE) AND 967 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0009 0.00085997581481934
SELECT *, MATCH (description, title) AGAINST ('organic rooibos loose' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('organic rooibos loose' IN BOOLEAN MODE) AND 967 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0008 0.00078296661376953
SELECT *, MATCH (description, title) AGAINST ('organic rooibos loose' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('organic rooibos loose' IN BOOLEAN MODE) AND 967 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0008 0.00081610679626465
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
122 0.0007 0.00067710876464844
SELECT * FROM product_image_select WHERE product_id = '862'
123 0.0004 0.0004429817199707
SELECT * FROM productcustomimages WHERE product_id = '862'
124 0.0011 0.0010969638824463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
125 0.0006 0.00056195259094238
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00047492980957031
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00046014785766602
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0006 0.00061416625976562
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
129 0.0007 0.00066494941711426
SELECT * FROM product_image_select WHERE product_id = '869'
130 0.0004 0.00042986869812012
SELECT * FROM productcustomimages WHERE product_id = '869'
131 0.0009 0.00089597702026367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
132 0.0006 0.00057697296142578
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00049304962158203
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00045204162597656
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00059103965759277
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
136 0.0007 0.00065302848815918
SELECT * FROM product_image_select WHERE product_id = '890'
137 0.0005 0.00049901008605957
SELECT * FROM productcustomimages WHERE product_id = '890'
138 0.0011 0.0011060237884521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
139 0.0005 0.00051999092102051
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00052690505981445
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00052309036254883
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0006 0.00063180923461914
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0004 0.00044488906860352
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0011 0.001060962677002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0006 0.00056004524230957
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0005 0.00051116943359375
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00052094459533691
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0007 0.00073599815368652
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
150 0.0007 0.00071001052856445
SELECT * FROM product_image_select WHERE product_id = '858'
151 0.0006 0.00061392784118652
SELECT * FROM productcustomimages WHERE product_id = '858'
152 0.0016 0.0016491413116455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
153 0.0006 0.0005948543548584
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00050902366638184
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
157 0.0007 0.00073599815368652
SELECT * FROM product_image_select WHERE product_id = '865'
158 0.0005 0.00052690505981445
SELECT * FROM productcustomimages WHERE product_id = '865'
159 0.0010 0.00095796585083008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
160 0.0006 0.00058388710021973
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00056791305541992
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0006 0.00055694580078125
SELECT id,asin FROM products WHERE parent_id = 967
164 0.0019 0.0018930435180664
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '967' ORDER BY timestamp DESC
165 0.0007 0.00070691108703613
SELECT category_id FROM products_categories WHERE product_id = '967'
166 0.0006 0.00062704086303711
SELECT * FROM categories WHERE id = '27'
167 0.0052 0.0051560401916504
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
168 0.0006 0.00057888031005859
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0005 0.00045490264892578
SELECT id FROM categories WHERE parent_id = '27'
170 0.0042 0.0042228698730469
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 
171 0.0007 0.0007169246673584
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 
172 0.0007 0.00071501731872559
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
173 0.0006 0.00056695938110352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0013 0.0013320446014404
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '967' AND a.name = n.originalname
175 0.0006 0.0006251335144043
SELECT * FROM productoffers WHERE product_id = '967' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '967' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = 967
                ORDER BY price ASC LIMIT 1
178 0.0005 0.00050592422485352
SELECT value FROM productattributes
                WHERE product_id = '967'
                AND name = 'ListPriceAmount'
179 0.0009 0.00085806846618652
SELECT * FROM products WHERE id = '967'
180 0.0006 0.0005791187286377
SELECT value FROM productattributes WHERE product_id = '967' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0011 0.0010769367218018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '967' AND a.name = n.originalname
182 0.0005 0.00045514106750488
SELECT * FROM productoffers WHERE product_id = '967' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00044393539428711
SELECT * FROM productoffers
                WHERE product_id = '967' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00039815902709961
SELECT * FROM productoffers
                WHERE product_id = 967
                ORDER BY price ASC LIMIT 1
185 0.0005 0.00048494338989258
SELECT value FROM productattributes
                WHERE product_id = '967'
                AND name = 'ListPriceAmount'
186 0.0005 0.00053691864013672
SELECT category_id FROM products_categories WHERE product_id = '967' AND prod_type = 'amz'
187 0.0005 0.0005040168762207
SELECT parent_id FROM categories WHERE id = '27'
188 0.0004 0.00043916702270508
SELECT * FROM categories WHERE id = '27'
189 0.0039 0.0038580894470215
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.0006 0.00062203407287598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0008 0.00082111358642578
SELECT id FROM categories WHERE parent_id = '27'
192 0.0042 0.0042350292205811
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.0007 0.00065088272094727
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.0007 0.00069808959960938
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.00059103965759277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0020 0.0019600391387939
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0015 0.0015199184417725
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.00041794776916504
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0126 0.012617111206055
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.0017 0.0016930103302002
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.00060009956359863
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.00060391426086426
SELECT * FROM products WHERE id = 1626
203 0.0006 0.0006248950958252
SELECT * FROM products WHERE id = 4041
204 0.0007 0.00072002410888672
SELECT * FROM products WHERE id = 4312
205 0.0007 0.00071406364440918
SELECT * FROM products WHERE id = 777
206 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = 3881
207 0.0008 0.0008392333984375
SELECT * FROM products WHERE id = 4213
208 0.0006 0.00059103965759277
SELECT * FROM products WHERE id = '1626'
209 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0007 0.0006561279296875
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0005 0.00052309036254883
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0009 0.00088715553283691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0006 0.00060200691223145
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0006 0.00059890747070312
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0006 0.00061893463134766
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0006 0.00064897537231445
SELECT * FROM products WHERE id = '4041'
217 0.0007 0.00074005126953125
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0008 0.00081515312194824
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0005 0.0005190372467041
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0014 0.001446008682251
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.00060391426086426
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.0005040168762207
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0008 0.00075817108154297
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0007 0.00066995620727539
SELECT * FROM products WHERE id = '4312'
225 0.0006 0.00056195259094238
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0007 0.00073599815368652
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0005 0.00051307678222656
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0014 0.0013978481292725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0006 0.00060391426086426
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0007 0.0006721019744873
SELECT * FROM products WHERE id = '777'
233 0.0007 0.00072717666625977
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0008 0.0007939338684082
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0009 0.00088977813720703
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0014 0.0014040470123291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0006 0.00062108039855957
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.00050592422485352
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0006 0.00060296058654785
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0007 0.00067281723022461
SELECT * FROM products WHERE id = '3881'
241 0.0007 0.00071096420288086
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0008 0.00075006484985352
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0005 0.00049018859863281
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0015 0.0015280246734619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0008 0.00075912475585938
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0005 0.00053906440734863
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0006 0.00061178207397461
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0008 0.00080108642578125
SELECT * FROM products WHERE id = '4213'
249 0.0008 0.00076794624328613
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0009 0.00089907646179199
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0006 0.00058603286743164
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0017 0.0017080307006836
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0007 0.00069212913513184
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0006 0.00058102607727051
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0006 0.0006108283996582
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0028 0.0028319358825684
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0010 0.0010240077972412
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0065 0.0064671039581299
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0047 0.0047330856323242
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0016 0.0015501976013184
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0141 0.014100790023804
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'