0

Teapigs Thé Rooibos 50 par paquet

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-25 14:00:54 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.

Product Features

Rouge brousse Sans caféine Quelle est la particularité de cette thé? Un riche mélange de nutriments Se il vous plaît me garder frais et sec jusqu'à ce que je en ai fini puis essayer de me recycler. Louise Le thé Taster, Teapigs, 1 The Old Station de pompage, pompe Alley, Brentford, Londres, TW8 0 Boîte

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.6560471057892 256 0.8915 0


No Amazon API Requests Made.


App Debug - Total Time 1.6560471057892 seconds

Number Time From Start Name Description
1 0.70443296432495 Initialise Initialise FSB Function
2 0.70925498008728 App Controller Start Start of the App controller (called before the controller of every page)
3 0.75959396362305 Start of getCategoryListByGroup Function Before first category groups query
4 0.76129007339478 After initial query Before first category groups query
5 0.76129198074341 Get Category List for Group Before the call to getCategoryList function
6 0.76129603385925 Start of GetCategoryList function Start of the function
7 0.7613000869751 Before getting categories Query to get specific category list
8 0.7630021572113 After getting categories Query to get specific category list
9 0.76300311088562 Before getting category custom Before call to function getCategoryCustom
10 0.7865309715271 After getting category custom After call to function getCategoryCustom
11 0.78653407096863 Before getting category custom Before call to function getCategoryCustom
12 0.79749917984009 After getting category custom After call to function getCategoryCustom
13 0.79750204086304 Before getting category custom Before call to function getCategoryCustom
14 0.80391001701355 After getting category custom After call to function getCategoryCustom
15 0.80391216278076 Before getting category custom Before call to function getCategoryCustom
16 0.80842208862305 After getting category custom After call to function getCategoryCustom
17 0.80842399597168 Before getting category custom Before call to function getCategoryCustom
18 0.81261110305786 After getting category custom After call to function getCategoryCustom
19 0.81261301040649 Before getting category custom Before call to function getCategoryCustom
20 0.81696510314941 After getting category custom After call to function getCategoryCustom
21 0.81696796417236 End of GetCategoryList function End of the function
22 0.81697511672974 Get Category List for Group Before the call to getCategoryList function
23 0.81697797775269 Start of GetCategoryList function Start of the function
24 0.81698107719421 Before getting categories Query to get specific category list
25 0.81748199462891 End of getCategoryListByGroup Function Before return()
26 1.3795201778412 App Controller End End of the App controller (called before the controller of every page)
27 1.3805720806122 Product Start Start of the product info controller
28 1.4053161144257 Cache file not found Starting get product details
29 1.4468331336975 Related products Start getting related products if enabled
30 1.4468350410461 Related Products Start Before the related products are found
31 1.4468369483948 Related Products Keywords Before the related product keywords are found
32 1.4468441009521 Create Keyword List Function Start of function
33 1.4469699859619 Create Keyword List Function After looping provided content - 15 keywords found
34 1.4479901790619 Create Keyword List Function After looping initial keyword list - 13 keywords remaining
35 1.4479990005493 Create Keyword List Function After reducing keyword list
36 1.4480431079865 Create Keyword List Function After selecting by scoring keywords
37 1.4480490684509 Create Keyword List Function After final loop of keywords
38 1.4480521678925 Related Products Keywords After the related product keywords are found
39 1.4936590194702 Related Products End After the related products are found
40 1.5365850925446 Product End End of the product info controller (Product Info)
41 1.5393979549408 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.541424036026 Before Get Options Before the call to getOptions in the tpl class
43 1.6160819530487 After Get Options After the call to getOptions in the tpl class
44 1.6162550449371 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.6162891387939 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6277101039886 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6277141571045 Product Info: Before Template Display Before the template is displayed
48 1.6560211181641 Product Info: After Template Display After the template is displayed
49 1.6560339927673 Finalizing debug Before the debug is output to the page.
50 1.6560461521149 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 0.8915 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0027 0.0026769638061523
SELECT parameter, value FROM parameters
2 0.0041 0.0041029453277588
SELECT * FROM `bad_bots`
3 0.0004 0.00035810470581055
SET time_zone = 'Europe/London'
4 0.0018 0.0018401145935059
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0022480487823486
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"44.200.122.214\";}'
6 0.0019 0.0018911361694336
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1728669335'
7 0.0018 0.0018479824066162
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00048685073852539
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0015 0.0015060901641846
SELECT id FROM pages WHERE pagename = 'teapigs-the-rooibos-50-par-paquet' LIMIT 1
10 0.0018 0.0018470287322998
SELECT id FROM products WHERE pagename = 'teapigs-the-rooibos-50-par-paquet' AND hidden = 0 LIMIT 1
11 0.0022 0.0021779537200928
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0469 0.046912908554077
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00063204765319824
SELECT * FROM pages WHERE pagename = 'teapigs-the-rooibos-50-par-paquet'
14 0.0017 0.0016849040985107
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0017 0.0016829967498779
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0071 0.0071070194244385
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.0038 0.0038208961486816
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.0013 0.0013179779052734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00048017501831055
SELECT id FROM categories WHERE parent_id = '26'
20 0.0056 0.0056490898132324
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.0016 0.0016031265258789
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.0016 0.0015599727630615
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.0015 0.0014801025390625
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00039100646972656
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037720203399658
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.0004580020904541
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.0003511905670166
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00040197372436523
SELECT id FROM categories WHERE parent_id = '27'
29 0.0040 0.0040099620819092
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.0005 0.00051403045654297
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.00049018859863281
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.00046205520629883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00040888786315918
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.001521110534668
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.00047993659973145
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.0004 0.0003809928894043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00040411949157715
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016200542449951
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.0005 0.00045204162597656
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.00057601928710938
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.0004 0.00042414665222168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00046896934509277
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00061392784118652
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.00052285194396973
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.00039887428283691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00038409233093262
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00070405006408691
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.00046610832214355
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.0005 0.0005040168762207
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.0004 0.00044798851013184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00039386749267578
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00055599212646484
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.0004 0.00042510032653809
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.0003 0.00034594535827637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00037217140197754
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00064492225646973
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.0004 0.00043106079101562
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.00049090385437012
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.00047183036804199
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00036787986755371
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00054693222045898
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.0004 0.00044012069702148
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.00038599967956543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00039792060852051
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.0007171630859375
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.00049710273742676
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.0005 0.00046515464782715
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.0005 0.00047206878662109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00035595893859863
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00049114227294922
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0027 0.0027270317077637
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0015 0.0014679431915283
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00055313110351562
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.0011 0.0010859966278076
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0011560916900635
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010168552398682
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5483 0.54825806617737
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.122.214') >= INET_ATON(ip_start) AND INET_ATON('44.200.122.214') <= INET_ATON(ip_end)
78 0.0023 0.002324104309082
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0014088153839111
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00083398818969727
SELECT * FROM products WHERE pagename = 'teapigs-the-rooibos-50-par-paquet'
81 0.0005 0.00048089027404785
UPDATE products SET viewcount = viewcount + 1 WHERE id = 914
82 0.0009 0.000885009765625
SELECT * FROM manufacturers WHERE id = '246'
83 0.0008 0.00075197219848633
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '246'
84 0.0028 0.0027928352355957
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '246' LIMIT 1
85 0.0033 0.0033090114593506
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '246' ORDER BY RAND() LIMIT 1
86 0.0006 0.00061392784118652
SELECT * FROM productimages WHERE product_id = '1042' ORDER BY sortorder ASC
87 0.0007 0.00065302848815918
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '246'
88 0.0008 0.00076484680175781
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '246'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0007 0.00072503089904785
SELECT * FROM manufacturerimages WHERE manufacturer_id = '246'
90 0.0006 0.00059294700622559
SELECT category_id FROM products_categories WHERE product_id = '914'
91 0.0006 0.00057601928710938
SELECT * FROM categories WHERE id = '27'
92 0.0054 0.0053811073303223
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.0006 0.00064706802368164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00041389465332031
SELECT id FROM categories WHERE parent_id = '27'
95 0.0046 0.0045969486236572
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.00057482719421387
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.00055408477783203
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.00050806999206543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00049304962158203
SELECT * FROM productimages WHERE product_id = '914' ORDER BY sortorder ASC
100 0.0019 0.0018579959869385
SELECT * FROM product_image_select WHERE product_id = '914'
101 0.0012 0.0012280941009521
SELECT * FROM productcustomimages WHERE product_id = '914'
102 0.0012 0.0012049674987793
SELECT * FROM productfeeds WHERE product_id = '914' ORDER BY item_date DESC
103 0.0023 0.002316951751709
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '914' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0024 0.0023939609527588
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '914' AND t.hidden = 0 AND display_product = 1
105 0.0016 0.0015718936920166
SELECT * FROM productamazoncontent WHERE product_id = '914'
106 0.0011 0.0011429786682129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '914' AND a.name = n.originalname
107 0.0016 0.0016419887542725
SELECT * FROM productoffers WHERE product_id = '914' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '914' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = 914
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00053000450134277
SELECT value FROM productattributes
                WHERE product_id = '914'
                AND name = 'ListPriceAmount'
111 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.00052118301391602
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
113 0.0112 0.011154174804688
SELECT *, MATCH (description, title) AGAINST ('teapigs thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('teapigs thé rooibos' IN BOOLEAN MODE) AND 914 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0010 0.0010018348693848
SELECT *, MATCH (description, title) AGAINST ('teapigs thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('teapigs thé rooibos' IN BOOLEAN MODE) AND 914 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0008 0.00081515312194824
SELECT *, MATCH (description, title) AGAINST ('teapigs thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('teapigs thé rooibos' IN BOOLEAN MODE) AND 914 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0008 0.00081300735473633
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
117 0.0007 0.00072002410888672
SELECT * FROM product_image_select WHERE product_id = '862'
118 0.0004 0.00042605400085449
SELECT * FROM productcustomimages WHERE product_id = '862'
119 0.0012 0.0012288093566895
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
120 0.0005 0.00053501129150391
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0005 0.00050878524780273
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0006 0.00064206123352051
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
124 0.0008 0.00078582763671875
SELECT * FROM product_image_select WHERE product_id = '890'
125 0.0005 0.00052809715270996
SELECT * FROM productcustomimages WHERE product_id = '890'
126 0.0016 0.0015900135040283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
127 0.0007 0.00068902969360352
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0007 0.00072717666625977
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0006 0.00061607360839844
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0008 0.00078296661376953
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
131 0.0009 0.00091314315795898
SELECT * FROM product_image_select WHERE product_id = '865'
132 0.0005 0.00053596496582031
SELECT * FROM productcustomimages WHERE product_id = '865'
133 0.0012 0.0012359619140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
134 0.0007 0.00067520141601562
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0006 0.00057005882263184
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0006 0.00061392784118652
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0006 0.0006098747253418
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
138 0.0007 0.00070691108703613
SELECT * FROM product_image_select WHERE product_id = '878'
139 0.0005 0.00050997734069824
SELECT * FROM productcustomimages WHERE product_id = '878'
140 0.0015 0.0014760494232178
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
141 0.0006 0.00057220458984375
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0006 0.00056600570678711
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0005 0.00054287910461426
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0008 0.00077080726623535
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
145 0.0008 0.00081920623779297
SELECT * FROM product_image_select WHERE product_id = '858'
146 0.0005 0.00053286552429199
SELECT * FROM productcustomimages WHERE product_id = '858'
147 0.0016 0.0015981197357178
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
148 0.0006 0.00059318542480469
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0006 0.00062108039855957
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0005 0.00054216384887695
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0007 0.00069689750671387
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
152 0.0008 0.00079107284545898
SELECT * FROM product_image_select WHERE product_id = '869'
153 0.0006 0.00056600570678711
SELECT * FROM productcustomimages WHERE product_id = '869'
154 0.0013 0.0013148784637451
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
155 0.0006 0.00061392784118652
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0005 0.00053691864013672
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0005 0.00052094459533691
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0007 0.00067591667175293
SELECT id,asin FROM products WHERE parent_id = 914
159 0.0025 0.0024569034576416
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '914' ORDER BY timestamp DESC
160 0.0005 0.00054502487182617
SELECT category_id FROM products_categories WHERE product_id = '914'
161 0.0005 0.00052905082702637
SELECT * FROM categories WHERE id = '27'
162 0.0058 0.0057790279388428
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
163 0.0006 0.00063204765319824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
164 0.0004 0.00040197372436523
SELECT id FROM categories WHERE parent_id = '27'
165 0.0059 0.0058820247650146
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 
166 0.0008 0.00080490112304688
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 
167 0.0007 0.00073885917663574
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
168 0.0007 0.00066590309143066
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
169 0.0011 0.0011029243469238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '914' AND a.name = n.originalname
170 0.0007 0.00072503089904785
SELECT * FROM productoffers WHERE product_id = '914' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0005 0.00051379203796387
SELECT * FROM productoffers
                WHERE product_id = '914' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = 914
                ORDER BY price ASC LIMIT 1
173 0.0005 0.0005488395690918
SELECT value FROM productattributes
                WHERE product_id = '914'
                AND name = 'ListPriceAmount'
174 0.0009 0.00088810920715332
SELECT * FROM products WHERE id = '914'
175 0.0005 0.00054001808166504
SELECT value FROM productattributes WHERE product_id = '914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0009 0.00087809562683105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '914' AND a.name = n.originalname
177 0.0005 0.0004580020904541
SELECT * FROM productoffers WHERE product_id = '914' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0006 0.0005948543548584
SELECT * FROM productoffers
                WHERE product_id = '914' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0005 0.00052380561828613
SELECT * FROM productoffers
                WHERE product_id = 914
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00049591064453125
SELECT value FROM productattributes
                WHERE product_id = '914'
                AND name = 'ListPriceAmount'
181 0.0006 0.00055289268493652
SELECT category_id FROM products_categories WHERE product_id = '914' AND prod_type = 'amz'
182 0.0006 0.00057291984558105
SELECT parent_id FROM categories WHERE id = '27'
183 0.0004 0.0004420280456543
SELECT * FROM categories WHERE id = '27'
184 0.0059 0.0059468746185303
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
185 0.0007 0.00065994262695312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186 0.0005 0.00053310394287109
SELECT id FROM categories WHERE parent_id = '27'
187 0.0052 0.0052111148834229
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 
188 0.0006 0.00063586235046387
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 
189 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
190 0.0005 0.00049495697021484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
191 0.0021 0.002126932144165
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
192 0.0015 0.0015079975128174
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
193 0.0004 0.00042295455932617
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0184 0.018401861190796
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
195 0.0022 0.0022130012512207
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
196 0.0006 0.00056600570678711
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
197 0.0006 0.00062918663024902
SELECT * FROM products WHERE id = 1626
198 0.0006 0.00064992904663086
SELECT * FROM products WHERE id = 4041
199 0.0007 0.00068306922912598
SELECT * FROM products WHERE id = 4312
200 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = 777
201 0.0006 0.00060391426086426
SELECT * FROM products WHERE id = 3881
202 0.0006 0.00056004524230957
SELECT * FROM products WHERE id = 4213
203 0.0006 0.0005800724029541
SELECT * FROM products WHERE id = '1626'
204 0.0006 0.0005638599395752
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
205 0.0008 0.00083708763122559
SELECT * FROM product_image_select WHERE product_id = '1626'
206 0.0005 0.00045084953308105
SELECT * FROM productcustomimages WHERE product_id = '1626'
207 0.0010 0.0010368824005127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
208 0.0006 0.0005650520324707
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0007 0.00069212913513184
SELECT * FROM products WHERE id = '4041'
212 0.0005 0.00052404403686523
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
213 0.0008 0.00077199935913086
SELECT * FROM product_image_select WHERE product_id = '4041'
214 0.0013 0.0012929439544678
SELECT * FROM productcustomimages WHERE product_id = '4041'
215 0.0014 0.0013799667358398
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
216 0.0006 0.00061202049255371
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0006 0.00060415267944336
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0007 0.00067496299743652
SELECT * FROM products WHERE id = '4312'
220 0.0006 0.00055503845214844
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
221 0.0008 0.00084280967712402
SELECT * FROM product_image_select WHERE product_id = '4312'
222 0.0005 0.00047993659973145
SELECT * FROM productcustomimages WHERE product_id = '4312'
223 0.0016 0.0016200542449951
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
224 0.0006 0.00063896179199219
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0006 0.00062894821166992
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0005 0.00051784515380859
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0007 0.00065302848815918
SELECT * FROM products WHERE id = '777'
228 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
229 0.0007 0.00074911117553711
SELECT * FROM product_image_select WHERE product_id = '777'
230 0.0005 0.0004889965057373
SELECT * FROM productcustomimages WHERE product_id = '777'
231 0.0015 0.0014519691467285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
232 0.0006 0.00063705444335938
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0007 0.00066089630126953
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0006 0.00057816505432129
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0007 0.00072503089904785
SELECT * FROM products WHERE id = '3881'
236 0.0010 0.0010221004486084
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
237 0.0008 0.00078201293945312
SELECT * FROM product_image_select WHERE product_id = '3881'
238 0.0005 0.00051498413085938
SELECT * FROM productcustomimages WHERE product_id = '3881'
239 0.0018 0.0017910003662109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
240 0.0006 0.00064802169799805
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0005 0.00046586990356445
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0005 0.00049710273742676
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0007 0.00074291229248047
SELECT * FROM products WHERE id = '4213'
244 0.0009 0.00093317031860352
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
245 0.0007 0.00068092346191406
SELECT * FROM product_image_select WHERE product_id = '4213'
246 0.0005 0.00049495697021484
SELECT * FROM productcustomimages WHERE product_id = '4213'
247 0.0017 0.001680850982666
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
248 0.0009 0.00086116790771484
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0005 0.00053191184997559
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0007 0.00067782402038574
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0029 0.0028929710388184
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
252 0.0011 0.0011060237884521
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
253 0.0038 0.003809928894043
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
254 0.0026 0.0026330947875977
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0009 0.00087094306945801
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0010 0.0010170936584473
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'