0

Alter Eco Thé Blanc Rooibos Nature Bio et Équitable 20 infusettes parent

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

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
3.0681130886078 247 0.9618 0


No Amazon API Requests Made.


App Debug - Total Time 3.0681130886078 seconds

Number Time From Start Name Description
1 2.0223209857941 Initialise Initialise FSB Function
2 2.0332369804382 App Controller Start Start of the App controller (called before the controller of every page)
3 2.0739560127258 Start of getCategoryListByGroup Function Before first category groups query
4 2.0754399299622 After initial query Before first category groups query
5 2.075443983078 Get Category List for Group Before the call to getCategoryList function
6 2.0754499435425 Start of GetCategoryList function Start of the function
7 2.0754580497742 Before getting categories Query to get specific category list
8 2.0771441459656 After getting categories Query to get specific category list
9 2.0771479606628 Before getting category custom Before call to function getCategoryCustom
10 2.0984389781952 After getting category custom After call to function getCategoryCustom
11 2.0984461307526 Before getting category custom Before call to function getCategoryCustom
12 2.1130850315094 After getting category custom After call to function getCategoryCustom
13 2.1130909919739 Before getting category custom Before call to function getCategoryCustom
14 2.1206829547882 After getting category custom After call to function getCategoryCustom
15 2.1206891536713 Before getting category custom Before call to function getCategoryCustom
16 2.1267931461334 After getting category custom After call to function getCategoryCustom
17 2.1267991065979 Before getting category custom Before call to function getCategoryCustom
18 2.1325089931488 After getting category custom After call to function getCategoryCustom
19 2.1325149536133 Before getting category custom Before call to function getCategoryCustom
20 2.1388700008392 After getting category custom After call to function getCategoryCustom
21 2.1388750076294 End of GetCategoryList function End of the function
22 2.138885974884 Get Category List for Group Before the call to getCategoryList function
23 2.1388900279999 Start of GetCategoryList function Start of the function
24 2.1388940811157 Before getting categories Query to get specific category list
25 2.139662027359 End of getCategoryListByGroup Function Before return()
26 2.7718660831451 App Controller End End of the App controller (called before the controller of every page)
27 2.7728841304779 Product Start Start of the product info controller
28 2.7983291149139 Cache file not found Starting get product details
29 2.8429119586945 Related products Start getting related products if enabled
30 2.8429141044617 Related Products Start Before the related products are found
31 2.842915058136 Related Products Keywords Before the related product keywords are found
32 2.8429200649261 Create Keyword List Function Start of function
33 2.8430960178375 Create Keyword List Function After looping provided content - 33 keywords found
34 2.8446700572968 Create Keyword List Function After looping initial keyword list - 29 keywords remaining
35 2.8446829319 Create Keyword List Function After reducing keyword list
36 2.8448030948639 Create Keyword List Function After selecting by scoring keywords
37 2.8448081016541 Create Keyword List Function After final loop of keywords
38 2.8448100090027 Related Products Keywords After the related product keywords are found
39 2.8922071456909 Related Products End After the related products are found
40 2.9020380973816 Product End End of the product info controller (Product Info)
41 2.9072849750519 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.9111559391022 Before Get Options Before the call to getOptions in the tpl class
43 2.9997019767761 After Get Options After the call to getOptions in the tpl class
44 2.9999439716339 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.9999959468842 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 3.0207481384277 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 3.0207569599152 Product Info: Before Template Display Before the template is displayed
48 3.0680620670319 Product Info: After Template Display After the template is displayed
49 3.0680849552155 Finalizing debug Before the debug is output to the page.
50 3.0681109428406 End of App This is the end of the app logging, final timestamp


Query Debug - 247 Database Queries. Total time 0.9618 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0027 0.002655029296875
SELECT parameter, value FROM parameters
2 0.0076 0.0075910091400146
SELECT * FROM `bad_bots`
3 0.0005 0.00048589706420898
SET time_zone = 'Europe/London'
4 0.0033 0.0032820701599121
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0045 0.0044770240783691
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:10:\"3.12.36.65\";}'
6 0.0031 0.0030519962310791
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1729229957'
7 0.0039 0.003864049911499
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.0007929801940918
UPDATE autorun SET lastrun = '2024-10-18 05:39:18' WHERE id = '15'
9 0.0010 0.00098299980163574
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0038 0.0037899017333984
SELECT id FROM pages WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512' LIMIT 1
11 0.0051 0.0051090717315674
SELECT id FROM products WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512' AND hidden = 0 LIMIT 1
12 0.0059 0.0058760643005371
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0332 0.03317403793335
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00067496299743652
SELECT * FROM pages WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512'
15 0.0014 0.0014488697052002
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0016 0.0016298294067383
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0064 0.0064020156860352
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0018 0.0018150806427002
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0012 0.0012338161468506
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.0005190372467041
SELECT id FROM categories WHERE parent_id = '26'
21 0.0057 0.0057201385498047
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0016 0.0016269683837891
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0015 0.0015230178833008
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0016 0.0015649795532227
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00049400329589844
SELECT * FROM categorygroups WHERE id = '1'
26 0.0038 0.0038199424743652
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0006 0.00061798095703125
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00052213668823242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00049996376037598
SELECT id FROM categories WHERE parent_id = '27'
30 0.0049 0.0049118995666504
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0013 0.0012907981872559
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0008 0.00083398818969727
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0007 0.00072598457336426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0012 0.0011868476867676
SELECT * FROM categorygroups WHERE id = '1'
35 0.0020 0.0019600391387939
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0006 0.0006110668182373
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00042104721069336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00045108795166016
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0017061233520508
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0006 0.00058484077453613
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0006 0.00064396858215332
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0005 0.00053501129150391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00048017501831055
SELECT * FROM categorygroups WHERE id = '1'
44 0.0008 0.00078678131103516
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0005 0.00051379203796387
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00041699409484863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00051784515380859
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00077295303344727
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0011 0.0011169910430908
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0007 0.00073814392089844
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0005 0.00049996376037598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00049114227294922
SELECT * FROM categorygroups WHERE id = '1'
53 0.0007 0.00072598457336426
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0006 0.00057601928710938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0005 0.00046491622924805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0006 0.00057601928710938
SELECT id FROM categories WHERE parent_id = '30'
57 0.0008 0.00079202651977539
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0006 0.00060081481933594
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0007 0.00069904327392578
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0005 0.00054597854614258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0006 0.00056004524230957
SELECT * FROM categorygroups WHERE id = '1'
62 0.0009 0.00088310241699219
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0007 0.00065398216247559
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0005 0.0004889965057373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0006 0.00061488151550293
SELECT id FROM categories WHERE parent_id = '31'
66 0.0010 0.0010240077972412
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0006 0.00062203407287598
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0007 0.0007319450378418
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0006 0.00059700012207031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00057291984558105
SELECT * FROM categorygroups WHERE id = '1'
71 0.0007 0.00074887275695801
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0045 0.0045371055603027
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0051 0.0050539970397949
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0009 0.00088405609130859
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0019 0.0018560886383057
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0013 0.0012698173522949
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0012 0.0011529922485352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.6109 0.6108660697937
SELECT * FROM ipgeocountries WHERE INET_ATON('3.12.36.65') >= INET_ATON(ip_start) AND INET_ATON('3.12.36.65') <= INET_ATON(ip_end)
79 0.0022 0.0022220611572266
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.0013539791107178
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00071501731872559
SELECT * FROM products WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512'
82 0.0005 0.00047397613525391
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4006
83 0.0008 0.00079107284545898
SELECT * FROM manufacturers WHERE id = '639'
84 0.0019 0.001943826675415
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85 0.0036 0.0036239624023438
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
86 0.0052 0.0052089691162109
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
87 0.0010 0.00098490715026855
SELECT * FROM productimages WHERE product_id = '1022' ORDER BY sortorder ASC
88 0.0015 0.0014760494232178
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
89 0.0019 0.0018517971038818
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0007 0.00067400932312012
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
91 0.0007 0.00068998336791992
SELECT category_id FROM products_categories WHERE product_id = '4006'
92 0.0007 0.00068783760070801
SELECT * FROM productimages WHERE product_id = '4006' ORDER BY sortorder ASC
93 0.0031 0.0030858516693115
SELECT * FROM product_image_select WHERE product_id = '4006'
94 0.0019 0.0018939971923828
SELECT * FROM productcustomimages WHERE product_id = '4006'
95 0.0017 0.0016741752624512
SELECT * FROM productfeeds WHERE product_id = '4006' ORDER BY item_date DESC
96 0.0029 0.0029220581054688
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
97 0.0029 0.0028679370880127
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4006' AND t.hidden = 0 AND display_product = 1
98 0.0004 0.00043177604675293
SELECT * FROM tags WHERE id = '62'
99 0.0022 0.0022189617156982
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
100 0.0019 0.0018670558929443
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
101 0.0016 0.0015928745269775
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '62' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
102 0.0008 0.0008089542388916
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
103 0.0018 0.001755952835083
SELECT * FROM productamazoncontent WHERE product_id = '4006'
104 0.0009 0.00088906288146973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
105 0.0014 0.0013699531555176
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
106 0.0004 0.00040411949157715
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0003 0.00034379959106445
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
108 0.0005 0.00050497055053711
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
109 0.0005 0.00053095817565918
SELECT value FROM productattributes WHERE product_id = '4006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00053095817565918
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.0100 0.009958028793335
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AND 4006 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0008 0.00084686279296875
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AND 4006 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0008 0.00077295303344727
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AND 4006 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0005 0.00053691864013672
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
115 0.0006 0.00060701370239258
SELECT * FROM product_image_select WHERE product_id = '878'
116 0.0004 0.00043296813964844
SELECT * FROM productcustomimages WHERE product_id = '878'
117 0.0012 0.0012121200561523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
118 0.0021 0.0021011829376221
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00050592422485352
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0006 0.00061607360839844
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
122 0.0006 0.00064778327941895
SELECT * FROM product_image_select WHERE product_id = '858'
123 0.0004 0.0004270076751709
SELECT * FROM productcustomimages WHERE product_id = '858'
124 0.0010 0.0010190010070801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
125 0.0007 0.00069594383239746
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00040483474731445
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0007 0.0006868839263916
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
129 0.0007 0.00066900253295898
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
130 0.0006 0.00063991546630859
SELECT * FROM product_image_select WHERE product_id = '822'
131 0.0004 0.00041913986206055
SELECT * FROM productcustomimages WHERE product_id = '822'
132 0.0005 0.00054717063903809
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
133 0.0026 0.002593994140625
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
134 0.0006 0.00056719779968262
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
135 0.0010 0.00099301338195801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
136 0.0005 0.00052785873413086
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0006 0.00063586235046387
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0005 0.00047707557678223
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
139 0.0005 0.00047087669372559
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
140 0.0005 0.00049400329589844
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
141 0.0007 0.00074005126953125
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
142 0.0004 0.00043892860412598
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
143 0.0006 0.00059819221496582
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0006 0.00062203407287598
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
145 0.0006 0.00060009956359863
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
146 0.0006 0.00062084197998047
SELECT * FROM product_image_select WHERE product_id = '862'
147 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '862'
148 0.0010 0.00098395347595215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
149 0.0005 0.00051307678222656
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
153 0.0006 0.00059700012207031
SELECT * FROM product_image_select WHERE product_id = '4952'
154 0.0004 0.00039815902709961
SELECT * FROM productcustomimages WHERE product_id = '4952'
155 0.0008 0.0007939338684082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
156 0.0005 0.00050806999206543
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0006 0.00055813789367676
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00052714347839355
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
160 0.0006 0.00063395500183105
SELECT * FROM product_image_select WHERE product_id = '4947'
161 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '4947'
162 0.0008 0.00081896781921387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
163 0.0005 0.0005030632019043
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0004 0.00043106079101562
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0004 0.00043702125549316
SELECT id,asin FROM products WHERE parent_id = 4006
167 0.0017 0.0016860961914062
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4006' ORDER BY timestamp DESC
168 0.0005 0.00047397613525391
SELECT category_id FROM products_categories WHERE product_id = '4006'
169 0.0009 0.0008699893951416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
170 0.0005 0.00049614906311035
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0004 0.00041007995605469
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.00037097930908203
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00040006637573242
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
174 0.0007 0.00070905685424805
SELECT * FROM products WHERE id = '4006'
175 0.0004 0.00041913986206055
SELECT value FROM productattributes WHERE product_id = '4006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0006 0.00060391426086426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
177 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00035691261291504
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00039219856262207
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
181 0.0011 0.0010650157928467
SELECT category_id FROM products_categories WHERE product_id = '4006' AND prod_type = 'amz'
182 0.0045 0.0044679641723633
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
183 0.0031 0.0031459331512451
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
184 0.0006 0.00059795379638672
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
185 0.0262 0.026237964630127
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
186 0.0023 0.0022988319396973
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
187 0.0010 0.0009620189666748
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
188 0.0008 0.00081706047058105
SELECT * FROM products WHERE id = 1626
189 0.0008 0.00081706047058105
SELECT * FROM products WHERE id = 4041
190 0.0009 0.0009009838104248
SELECT * FROM products WHERE id = 4312
191 0.0007 0.00067996978759766
SELECT * FROM products WHERE id = 777
192 0.0007 0.00068497657775879
SELECT * FROM products WHERE id = 3881
193 0.0008 0.00077390670776367
SELECT * FROM products WHERE id = 4213
194 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = '1626'
195 0.0007 0.00067591667175293
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
196 0.0009 0.00092101097106934
SELECT * FROM product_image_select WHERE product_id = '1626'
197 0.0005 0.00054812431335449
SELECT * FROM productcustomimages WHERE product_id = '1626'
198 0.0013 0.0013082027435303
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
199 0.0007 0.00066685676574707
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0006 0.00057888031005859
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0006 0.00060510635375977
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0007 0.00073409080505371
SELECT * FROM products WHERE id = '4041'
203 0.0009 0.000946044921875
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
204 0.0008 0.00076484680175781
SELECT * FROM product_image_select WHERE product_id = '4041'
205 0.0006 0.00063991546630859
SELECT * FROM productcustomimages WHERE product_id = '4041'
206 0.0013 0.0012590885162354
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
207 0.0006 0.00056004524230957
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0005 0.0004878044128418
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0007 0.00066804885864258
SELECT * FROM products WHERE id = '4312'
211 0.0005 0.00053286552429199
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
212 0.0009 0.00086593627929688
SELECT * FROM product_image_select WHERE product_id = '4312'
213 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '4312'
214 0.0012 0.0011579990386963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
215 0.0006 0.00059795379638672
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0005 0.00047683715820312
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0006 0.0005950927734375
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0007 0.00069093704223633
SELECT * FROM products WHERE id = '777'
219 0.0005 0.00053501129150391
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
220 0.0007 0.00065994262695312
SELECT * FROM product_image_select WHERE product_id = '777'
221 0.0005 0.00046992301940918
SELECT * FROM productcustomimages WHERE product_id = '777'
222 0.0011 0.0011460781097412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
223 0.0006 0.00055980682373047
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0005 0.00048995018005371
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0007 0.00066018104553223
SELECT * FROM products WHERE id = '3881'
227 0.0008 0.00080204010009766
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
228 0.0008 0.00080704689025879
SELECT * FROM product_image_select WHERE product_id = '3881'
229 0.0005 0.00052309036254883
SELECT * FROM productcustomimages WHERE product_id = '3881'
230 0.0014 0.0014448165893555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
231 0.0007 0.00065302848815918
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0005 0.00050902366638184
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0007 0.00069808959960938
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0008 0.00080513954162598
SELECT * FROM products WHERE id = '4213'
235 0.0010 0.00098586082458496
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
236 0.0008 0.00081801414489746
SELECT * FROM product_image_select WHERE product_id = '4213'
237 0.0005 0.00054192543029785
SELECT * FROM productcustomimages WHERE product_id = '4213'
238 0.0024 0.0023880004882812
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
239 0.0007 0.00069499015808105
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0007 0.0006561279296875
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0006 0.000640869140625
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0037 0.0036649703979492
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
243 0.0010 0.00098991394042969
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
244 0.0039 0.0038900375366211
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
245 0.0037 0.0037350654602051
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
246 0.0014 0.0013840198516846
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
247 0.0012 0.0012238025665283
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'