0

English Tea Shop Rooibos - 1 x 20 Tea Bags

Price: €4,20
Product prices and availability are accurate as of 2022-06-25 05:50:28 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.

Product Features

Produits de l'agriculture biologique.

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.5076279640198 260 1.0324 0


No Amazon API Requests Made.


App Debug - Total Time 1.5076279640198 seconds

Number Time From Start Name Description
1 0.33502078056335 Initialise Initialise FSB Function
2 0.33801579475403 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38112783432007 Start of getCategoryListByGroup Function Before first category groups query
4 0.38174390792847 After initial query Before first category groups query
5 0.38174390792847 Get Category List for Group Before the call to getCategoryList function
6 0.3817458152771 Start of GetCategoryList function Start of the function
7 0.38174700737 Before getting categories Query to get specific category list
8 0.38242697715759 After getting categories Query to get specific category list
9 0.38242793083191 Before getting category custom Before call to function getCategoryCustom
10 0.40086078643799 After getting category custom After call to function getCategoryCustom
11 0.40086197853088 Before getting category custom Before call to function getCategoryCustom
12 0.41181397438049 After getting category custom After call to function getCategoryCustom
13 0.41182279586792 Before getting category custom Before call to function getCategoryCustom
14 0.42607688903809 After getting category custom After call to function getCategoryCustom
15 0.42607998847961 Before getting category custom Before call to function getCategoryCustom
16 0.43307685852051 After getting category custom After call to function getCategoryCustom
17 0.43307781219482 Before getting category custom Before call to function getCategoryCustom
18 0.43922090530396 After getting category custom After call to function getCategoryCustom
19 0.43922281265259 Before getting category custom Before call to function getCategoryCustom
20 0.44491291046143 After getting category custom After call to function getCategoryCustom
21 0.44491600990295 End of GetCategoryList function End of the function
22 0.44492077827454 Get Category List for Group Before the call to getCategoryList function
23 0.44492292404175 Start of GetCategoryList function Start of the function
24 0.44492483139038 Before getting categories Query to get specific category list
25 0.44552993774414 End of getCategoryListByGroup Function Before return()
26 1.1581490039825 App Controller End End of the App controller (called before the controller of every page)
27 1.1587059497833 Product Start Start of the product info controller
28 1.192608833313 Cache file not found Starting get product details
29 1.2289659976959 Related products Start getting related products if enabled
30 1.2289669513702 Related Products Start Before the related products are found
31 1.2289679050446 Related Products Keywords Before the related product keywords are found
32 1.2289719581604 Create Keyword List Function Start of function
33 1.2290709018707 Create Keyword List Function After looping provided content - 23 keywords found
34 1.2295379638672 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
35 1.2295429706573 Create Keyword List Function After reducing keyword list
36 1.2295808792114 Create Keyword List Function After selecting by scoring keywords
37 1.229583978653 Create Keyword List Function After final loop of keywords
38 1.2295849323273 Related Products Keywords After the related product keywords are found
39 1.291729927063 Related Products End After the related products are found
40 1.3307919502258 Product End End of the product info controller (Product Info)
41 1.3316829204559 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.332662820816 Before Get Options Before the call to getOptions in the tpl class
43 1.3933827877045 After Get Options After the call to getOptions in the tpl class
44 1.393495798111 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3935158252716 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4191579818726 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4191608428955 Product Info: Before Template Display Before the template is displayed
48 1.507602930069 Product Info: After Template Display After the template is displayed
49 1.5076148509979 Finalizing debug Before the debug is output to the page.
50 1.5076279640198 End of App This is the end of the app logging, final timestamp


Query Debug - 260 Database Queries. Total time 1.0324 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0018 0.0017790794372559
SELECT parameter, value FROM parameters
2 0.0057 0.0056521892547607
SELECT * FROM `bad_bots`
3 0.0005 0.00046014785766602
SET time_zone = 'Europe/London'
4 0.0011 0.0010871887207031
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0011389255523682
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.16.215.60\";}'
6 0.0010 0.0010190010070801
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743561352'
7 0.0015 0.0015199184417725
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00075817108154297
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00094294548034668
SELECT id FROM pages WHERE pagename = 'english-tea-shop-rooibos-1-x-20-tea-bags' LIMIT 1
10 0.0011 0.0010709762573242
SELECT id FROM products WHERE pagename = 'english-tea-shop-rooibos-1-x-20-tea-bags' AND hidden = 0 LIMIT 1
11 0.0033 0.0032761096954346
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0389 0.038901805877686
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00055193901062012
SELECT * FROM pages WHERE pagename = 'english-tea-shop-rooibos-1-x-20-tea-bags'
14 0.0006 0.0006110668182373
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.0006709098815918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0071 0.0070531368255615
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.0006 0.00061297416687012
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.0005 0.00050902366638184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.0005028247833252
SELECT id FROM categories WHERE parent_id = '26'
20 0.0074 0.0074241161346436
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.0007 0.00065302848815918
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.0006 0.00063204765319824
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.0005 0.00051999092102051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00048279762268066
SELECT * FROM categorygroups WHERE id = '1'
25 0.0039 0.0039160251617432
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.00049281120300293
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.00036811828613281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '27'
29 0.0036 0.0036110877990723
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.00055313110351562
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.0005 0.00054812431335449
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.0005 0.00049591064453125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00049901008605957
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0015900135040283
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.0012 0.001230001449585
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.0008 0.0008091926574707
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0012 0.0012490749359131
SELECT id FROM categories WHERE parent_id = '28'
38 0.0055 0.005486011505127
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.0010 0.0010449886322021
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.0011 0.0010528564453125
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.0009 0.00093293190002441
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0008 0.0007779598236084
SELECT * FROM categorygroups WHERE id = '1'
43 0.0013 0.0013120174407959
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.0007 0.00070810317993164
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.0005 0.00050783157348633
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.00056290626525879
SELECT id FROM categories WHERE parent_id = '29'
47 0.0011 0.001072883605957
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.0008 0.00075697898864746
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.0007 0.00074410438537598
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.0006 0.00064206123352051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00062203407287598
SELECT * FROM categorygroups WHERE id = '1'
52 0.0009 0.00089383125305176
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.0007 0.00073099136352539
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.00051784515380859
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0006 0.00056314468383789
SELECT id FROM categories WHERE parent_id = '30'
56 0.0011 0.001068115234375
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.0007 0.00070786476135254
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.0006 0.00058889389038086
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.0006 0.00056815147399902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00043892860412598
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00071096420288086
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.00051712989807129
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.0004 0.00041913986206055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.0004420280456543
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00086498260498047
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.0006 0.00057005882263184
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.00057506561279297
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.0010 0.0010190010070801
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00049281120300293
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00059700012207031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0019 0.0019040107727051
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0007 0.00068998336791992
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00064206123352051
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.0005 0.00045299530029297
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0014 0.0014359951019287
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010359287261963
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7040 0.70404291152954
SELECT * FROM ipgeocountries WHERE INET_ATON('3.16.215.60') >= INET_ATON(ip_start) AND INET_ATON('3.16.215.60') <= INET_ATON(ip_end)
78 0.0010 0.0010340213775635
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00046801567077637
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00060009956359863
SELECT * FROM products WHERE pagename = 'english-tea-shop-rooibos-1-x-20-tea-bags'
81 0.0004 0.00039911270141602
UPDATE products SET viewcount = viewcount + 1 WHERE id = 862
82 0.0011 0.0010581016540527
SELECT * FROM manufacturers WHERE id = '170'
83 0.0010 0.00097012519836426
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '170'
84 0.0029 0.0029189586639404
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '170' LIMIT 1
85 0.0013 0.0013329982757568
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '170' ORDER BY RAND() LIMIT 1
86 0.0008 0.00078511238098145
SELECT * FROM productimages WHERE product_id = '941' ORDER BY sortorder ASC
87 0.0007 0.00065088272094727
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '170'
88 0.0007 0.00069308280944824
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '170'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.0004119873046875
SELECT * FROM manufacturerimages WHERE manufacturer_id = '170'
90 0.0007 0.00069713592529297
SELECT category_id FROM products_categories WHERE product_id = '862'
91 0.0007 0.00066804885864258
SELECT * FROM categories WHERE id = '27'
92 0.0073 0.0072770118713379
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.00068211555480957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.0004279613494873
SELECT id FROM categories WHERE parent_id = '27'
95 0.0050 0.0049550533294678
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.0006 0.0006110668182373
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.0006 0.00060296058654785
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.0005 0.00049710273742676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00060892105102539
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
100 0.0006 0.00063085556030273
SELECT * FROM product_image_select WHERE product_id = '862'
101 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '862'
102 0.0017 0.0017120838165283
SELECT * FROM productfeeds WHERE product_id = '862' ORDER BY item_date DESC
103 0.0008 0.00080609321594238
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0024 0.0024118423461914
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '862' AND t.hidden = 0 AND display_product = 1
105 0.0013 0.0013020038604736
SELECT * FROM productamazoncontent WHERE product_id = '862'
106 0.0010 0.00095701217651367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
107 0.0004 0.00041913986206055
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00040507316589355
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00046396255493164
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
111 0.0127 0.012662887573242
SELECT *, MATCH (description, title) AGAINST ('20 tea bags' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('20 tea bags' IN BOOLEAN MODE) AND 862 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0008 0.00076103210449219
SELECT *, MATCH (description, title) AGAINST ('20 tea bags' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('20 tea bags' IN BOOLEAN MODE) AND 862 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0007 0.00065112113952637
SELECT *, MATCH (description, title) AGAINST ('20 tea bags' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('20 tea bags' IN BOOLEAN MODE) AND 862 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0006 0.00060510635375977
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
115 0.0007 0.00068807601928711
SELECT * FROM product_image_select WHERE product_id = '862'
116 0.0004 0.00038290023803711
SELECT * FROM productcustomimages WHERE product_id = '862'
117 0.0013 0.0013229846954346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
118 0.0005 0.0004889965057373
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0004 0.00043416023254395
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0005 0.00048089027404785
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
122 0.0007 0.00066304206848145
SELECT * FROM product_image_select WHERE product_id = '938'
123 0.0004 0.0003662109375
SELECT * FROM productcustomimages WHERE product_id = '938'
124 0.0009 0.00089478492736816
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
125 0.0005 0.00052595138549805
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0165 0.016463041305542
SELECT *, MATCH (description, title) AGAINST ('tea shop rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('tea shop rooibos' IN BOOLEAN MODE) AND 862 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 5
129 0.0007 0.00071597099304199
SELECT *, MATCH (description, title) AGAINST ('tea shop rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('tea shop rooibos' IN BOOLEAN MODE) AND 862 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 5
130 0.0006 0.00056600570678711
SELECT *, MATCH (description, title) AGAINST ('tea shop rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('tea shop rooibos' IN BOOLEAN MODE) AND 862 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 5
131 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
132 0.0007 0.00066089630126953
SELECT * FROM product_image_select WHERE product_id = '858'
133 0.0004 0.00041794776916504
SELECT * FROM productcustomimages WHERE product_id = '858'
134 0.0015 0.00154709815979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
135 0.0005 0.00050783157348633
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00043201446533203
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0005 0.00053596496582031
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0006 0.00058102607727051
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
139 0.0007 0.00065898895263672
SELECT * FROM product_image_select WHERE product_id = '869'
140 0.0004 0.00036716461181641
SELECT * FROM productcustomimages WHERE product_id = '869'
141 0.0012 0.0011601448059082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
142 0.0005 0.00052785873413086
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00041985511779785
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00041985511779785
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
146 0.0006 0.00064706802368164
SELECT * FROM product_image_select WHERE product_id = '878'
147 0.0004 0.00038385391235352
SELECT * FROM productcustomimages WHERE product_id = '878'
148 0.0014 0.0014140605926514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
149 0.0005 0.00047707557678223
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00042486190795898
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
153 0.0007 0.00066900253295898
SELECT * FROM product_image_select WHERE product_id = '865'
154 0.0004 0.00038981437683105
SELECT * FROM productcustomimages WHERE product_id = '865'
155 0.0009 0.00086402893066406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
156 0.0006 0.00055885314941406
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0005 0.00048089027404785
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00051498413085938
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
160 0.0007 0.00066900253295898
SELECT * FROM product_image_select WHERE product_id = '4814'
161 0.0004 0.00043106079101562
SELECT * FROM productcustomimages WHERE product_id = '4814'
162 0.0014 0.0013501644134521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
163 0.0005 0.00054407119750977
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00054192543029785
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0005 0.00048995018005371
SELECT id,asin FROM products WHERE parent_id = 862
167 0.0005 0.00048613548278809
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
168 0.0005 0.00049495697021484
SELECT category_id FROM products_categories WHERE product_id = '862'
169 0.0005 0.00050616264343262
SELECT * FROM categories WHERE id = '27'
170 0.0055 0.00553297996521
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
171 0.0005 0.00050115585327148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0003 0.00033783912658691
SELECT id FROM categories WHERE parent_id = '27'
173 0.0057 0.0057110786437988
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 
174 0.0006 0.00061321258544922
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 
175 0.0006 0.00062203407287598
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
176 0.0005 0.00048089027404785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0015 0.0014569759368896
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
178 0.0005 0.00051689147949219
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.0005490779876709
SELECT * FROM products WHERE id = '862'
181 0.0005 0.00049614906311035
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0011 0.0010581016540527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
183 0.0004 0.00040006637573242
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00040388107299805
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0006 0.00061607360839844
SELECT category_id FROM products_categories WHERE product_id = '862' AND prod_type = 'amz'
186 0.0007 0.00066399574279785
SELECT parent_id FROM categories WHERE id = '27'
187 0.0004 0.0004119873046875
SELECT * FROM categories WHERE id = '27'
188 0.0073 0.0073280334472656
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
189 0.0007 0.00072121620178223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190 0.0004 0.00040507316589355
SELECT id FROM categories WHERE parent_id = '27'
191 0.0057 0.0056700706481934
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 
192 0.0007 0.00071597099304199
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 
193 0.0007 0.00067400932312012
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
194 0.0006 0.00060892105102539
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195 0.0006 0.0005640983581543
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
196 0.0006 0.00055098533630371
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
197 0.0004 0.00037884712219238
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
198 0.0186 0.018604040145874
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
199 0.0008 0.00079703330993652
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
200 0.0006 0.00063300132751465
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
201 0.0006 0.00063300132751465
SELECT * FROM products WHERE id = 1626
202 0.0006 0.00056886672973633
SELECT * FROM products WHERE id = 4041
203 0.0005 0.00051212310791016
SELECT * FROM products WHERE id = 4312
204 0.0005 0.00049495697021484
SELECT * FROM products WHERE id = 777
205 0.0005 0.0005040168762207
SELECT * FROM products WHERE id = 3881
206 0.0004 0.00043296813964844
SELECT * FROM products WHERE id = 4213
207 0.0005 0.0004570484161377
SELECT * FROM products WHERE id = '1626'
208 0.0006 0.00055313110351562
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
209 0.0007 0.00074005126953125
SELECT * FROM product_image_select WHERE product_id = '1626'
210 0.0004 0.00044894218444824
SELECT * FROM productcustomimages WHERE product_id = '1626'
211 0.0010 0.0010161399841309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
212 0.0005 0.0005488395690918
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0006 0.00060796737670898
SELECT * FROM products WHERE id = '4041'
216 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
217 0.0007 0.00074005126953125
SELECT * FROM product_image_select WHERE product_id = '4041'
218 0.0005 0.00046610832214355
SELECT * FROM productcustomimages WHERE product_id = '4041'
219 0.0017 0.0016970634460449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
220 0.0006 0.00056195259094238
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0006 0.00057792663574219
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = '4312'
224 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
225 0.0008 0.00076007843017578
SELECT * FROM product_image_select WHERE product_id = '4312'
226 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '4312'
227 0.0015 0.0014669895172119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
228 0.0006 0.00056099891662598
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0004 0.00042080879211426
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0005 0.00049495697021484
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0006 0.00059795379638672
SELECT * FROM products WHERE id = '777'
232 0.0005 0.00050115585327148
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0007 0.00068187713623047
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0005 0.00045108795166016
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0015 0.0015389919281006
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0005 0.00047612190246582
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0006 0.00061202049255371
SELECT * FROM products WHERE id = '3881'
240 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
241 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '3881'
242 0.0004 0.00040197372436523
SELECT * FROM productcustomimages WHERE product_id = '3881'
243 0.0015 0.0015449523925781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
244 0.0005 0.0004880428314209
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0004 0.00040721893310547
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0006 0.00060510635375977
SELECT * FROM products WHERE id = '4213'
248 0.0005 0.0005490779876709
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
249 0.0006 0.00064396858215332
SELECT * FROM product_image_select WHERE product_id = '4213'
250 0.0004 0.00044012069702148
SELECT * FROM productcustomimages WHERE product_id = '4213'
251 0.0017 0.0016629695892334
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
252 0.0006 0.00057005882263184
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0005 0.00049304962158203
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0009 0.00094699859619141
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
256 0.0007 0.00072407722473145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
257 0.0018 0.0018389225006104
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
258 0.0007 0.00072407722473145
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0006 0.00060582160949707
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0006 0.00064992904663086
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'