herbaria Rooibos Busch naturel 15 FB, 1er Pack (1 x 30 g Sachets) – Bio

herbaria Rooibos Busch naturel 15 FB, 1er Pack (1 x 30 g Sachets) – Bio
herbaria Rooibos Busch naturel 15 FB, 1er Pack (1 x 30 g Sachets) – Bio (cliquez sur les images pour élargir)
€9,99
Le prix et la disponibilité du produit sont corrects en date du 2021-08-02 00:09:20 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.86159586906433 229 0.1239 0


No Amazon API Requests Made.

Total time 0.86159586906433 seconds

Number Time From Start Name Description
1 0.70344495773315 Initialise Initialise FSB Function
2 0.70523285865784 App Controller Start Start of the App controller (called before the controller of every page)
3 0.70819187164307 Start of getCategoryListByGroup Function Before first category groups query
4 0.70856690406799 After initial query Before first category groups query
5 0.70856904983521 Get Category List for Group Before the call to getCategoryList function
6 0.70857191085815 Start of GetCategoryList function Start of the function
7 0.708575963974 Before getting categories Query to get specific category list
8 0.70903897285461 After getting categories Query to get specific category list
9 0.70904088020325 Before getting category custom Before call to function getCategoryCustom
10 0.7316620349884 After getting category custom After call to function getCategoryCustom
11 0.73166489601135 Before getting category custom Before call to function getCategoryCustom
12 0.74262309074402 After getting category custom After call to function getCategoryCustom
13 0.74262499809265 Before getting category custom Before call to function getCategoryCustom
14 0.74742388725281 After getting category custom After call to function getCategoryCustom
15 0.74742603302002 Before getting category custom Before call to function getCategoryCustom
16 0.74988198280334 After getting category custom After call to function getCategoryCustom
17 0.74988389015198 Before getting category custom Before call to function getCategoryCustom
18 0.75230598449707 After getting category custom After call to function getCategoryCustom
19 0.7523090839386 Before getting category custom Before call to function getCategoryCustom
20 0.75488591194153 After getting category custom After call to function getCategoryCustom
21 0.75488805770874 End of GetCategoryList function End of the function
22 0.7548930644989 End of getCategoryListByGroup Function Before return()
23 0.75963807106018 App Controller End End of the App controller (called before the controller of every page)
24 0.76022696495056 Product Start Start of the product info controller
25 0.76215100288391 Cache file not found Starting get product details
26 0.78248500823975 Related products Start getting related products if enabled
27 0.78248691558838 Related Products Start Before the related products are found
28 0.7824878692627 Related Products Keywords Before the related product keywords are found
29 0.78249287605286 Create Keyword List Function Start of function
30 0.78253388404846 Create Keyword List Function After looping provided content - 27 keywords found
31 0.78365802764893 Create Keyword List Function After looping initial keyword list - 24 keywords remaining
32 0.78367686271667 Create Keyword List Function After reducing keyword list
33 0.78375101089478 Create Keyword List Function After selecting by scoring keywords
34 0.78375506401062 Create Keyword List Function After final loop of keywords
35 0.78375697135925 Related Products Keywords After the related product keywords are found
36 0.79851794242859 Related Products End After the related products are found
37 0.80485701560974 Product End End of the product info controller (Product Info)
38 0.80572104454041 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.80614495277405 Before Get Options Before the call to getOptions in the tpl class
40 0.83155393600464 After Get Options After the call to getOptions in the tpl class
41 0.83162689208984 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.83165287971497 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.84288907051086 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.84289288520813 Product Info: Before Template Display Before the template is displayed
45 0.86156988143921 Product Info: After Template Display After the template is displayed
46 0.86158204078674 Finalizing debug Before the debug is output to the page.
47 0.86159491539001 End of App This is the end of the app logging, final timestamp


Query Debug - 229 Database Queries. Total time 0.1239 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00059890747070312
SELECT parameter, value FROM parameters
2 0.0012 0.0011520385742188
SELECT * FROM `bad_bots`
3 0.0004 0.00040793418884277
SET time_zone = 'Europe/London'
4 0.0005 0.00049304962158203
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0020148754119873
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.229.142.104\";}'
6 0.0013 0.0012719631195068
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627933594'
7 0.0004 0.00041985511779785
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00024008750915527
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0003 0.00027084350585938
SELECT id FROM pages WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio' LIMIT 1
10 0.0006 0.00058293342590332
SELECT id FROM products WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio' AND hidden = 0 LIMIT 1
11 0.0011 0.00111985206604
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00088191032409668
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00044417381286621
SELECT * FROM pages WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio'
14 0.0004 0.00035905838012695
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.0004432201385498
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0139 0.013870000839233
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.0002 0.00020790100097656
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.0002 0.0001981258392334
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00018620491027832
SELECT id FROM categories WHERE parent_id = '26'
20 0.0073 0.007282018661499
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.0002 0.00024199485778809
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.0002 0.00016999244689941
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.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00016283988952637
SELECT * FROM categorygroups WHERE id = '1'
25 0.0048 0.0048019886016846
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.0002 0.00018596649169922
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.0002 0.00016999244689941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00016283988952637
SELECT id FROM categories WHERE parent_id = '27'
29 0.0047 0.0047049522399902
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.0002 0.0002288818359375
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.0002 0.00020790100097656
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.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00018906593322754
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017330646514893
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.0003 0.0002589225769043
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.0002 0.00015807151794434
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00016903877258301
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0016839504241943
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.0002 0.00018095970153809
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.0002 0.0001680850982666
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.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00017094612121582
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00051212310791016
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.0002 0.00023794174194336
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.0002 0.00015902519226074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0001 0.00014686584472656
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00057101249694824
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.0002 0.00019598007202148
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.0002 0.00016403198242188
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.0002 0.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00020503997802734
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00049209594726562
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.0002 0.00022506713867188
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.0002 0.00017881393432617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00015711784362793
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00057005882263184
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.0002 0.00018692016601562
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.0002 0.00018310546875
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.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00015902519226074
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00053286552429199
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.0002 0.00023198127746582
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.0002 0.00016403198242188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00057315826416016
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.0003 0.00025010108947754
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.0002 0.00017595291137695
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.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00018501281738281
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00021696090698242
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00025510787963867
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00028300285339355
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
73 0.0002 0.00018906593322754
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00046610832214355
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00058197975158691
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00028085708618164
SELECT * FROM ipgeocountries WHERE INET_ATON('3.229.142.104') >= INET_ATON(ip_start) AND INET_ATON('3.229.142.104') <= INET_ATON(ip_end)
77 0.0003 0.00025510787963867
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00021100044250488
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00069499015808105
SELECT * FROM products WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio'
80 0.0005 0.00054597854614258
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2521
81 0.0003 0.00032997131347656
SELECT * FROM manufacturers WHERE id = '452'
82 0.0007 0.00069904327392578
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '452'
83 0.0004 0.0003972053527832
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '452' LIMIT 1
84 0.0008 0.00077700614929199
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '452' ORDER BY RAND() LIMIT 1
85 0.0004 0.00044393539428711
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
86 0.0003 0.00028681755065918
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '452'
87 0.0006 0.00059080123901367
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '452'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0002 0.00023388862609863
SELECT * FROM manufacturerimages WHERE manufacturer_id = '452'
89 0.0002 0.00024819374084473
SELECT category_id FROM products_categories WHERE product_id = '2521'
90 0.0002 0.00023603439331055
SELECT * FROM categories WHERE id = '27'
91 0.0047 0.0047078132629395
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
92 0.0003 0.00034499168395996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00018906593322754
SELECT id FROM categories WHERE parent_id = '27'
94 0.0051 0.0051240921020508
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 
95 0.0004 0.00036001205444336
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 
96 0.0002 0.0001988410949707
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
97 0.0002 0.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
99 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '2521'
100 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '2521'
101 0.0002 0.0001828670501709
SELECT * FROM productfeeds WHERE product_id = '2521' ORDER BY item_date DESC
102 0.0019 0.001939058303833
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0002 0.00019001960754395
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2521' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00044012069702148
SELECT * FROM productamazoncontent WHERE product_id = '2521'
105 0.0002 0.00020003318786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
106 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0002 0.00023102760314941
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0002 0.00019097328186035
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
110 0.0084 0.0083959102630615
SELECT *, MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AND 2521 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
111 0.0004 0.00041699409484863
SELECT *, MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AND 2521 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
112 0.0004 0.00042510032653809
SELECT *, MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AND 2521 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '937' ORDER BY sortorder ASC
114 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '937'
115 0.0002 0.00019001960754395
SELECT * FROM productcustomimages WHERE product_id = '937'
116 0.0002 0.00021982192993164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '937' AND a.name = n.originalname
117 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '937' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0002 0.0002439022064209
SELECT * FROM productoffers
                WHERE product_id = '937' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0003 0.00029706954956055
SELECT * FROM productimages WHERE product_id = '941' ORDER BY sortorder ASC
121 0.0002 0.00019407272338867
SELECT * FROM product_image_select WHERE product_id = '941'
122 0.0002 0.00019311904907227
SELECT * FROM productcustomimages WHERE product_id = '941'
123 0.0002 0.00022196769714355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
124 0.0002 0.00022006034851074
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00033402442932129
SELECT value FROM productattributes WHERE product_id = '941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00026512145996094
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
128 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '862'
129 0.0002 0.00022697448730469
SELECT * FROM productcustomimages WHERE product_id = '862'
130 0.0002 0.000244140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
131 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0004 0.00042414665222168
SELECT id,asin FROM products WHERE parent_id = 2521
135 0.0002 0.00019502639770508
SELECT category_id FROM products_categories WHERE product_id = '2521'
136 0.0002 0.00024294853210449
SELECT * FROM categories WHERE id = '27'
137 0.0002 0.00018095970153809
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
138 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
139 0.0002 0.00016903877258301
SELECT id FROM categories WHERE parent_id = '27'
140 0.0002 0.00017499923706055
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 
141 0.0002 0.00017690658569336
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 
142 0.0002 0.00020790100097656
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
143 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
144 0.0002 0.00017404556274414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
145 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0002 0.00018477439880371
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00046801567077637
SELECT * FROM products WHERE id = '2521'
148 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0002 0.0001988410949707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
150 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0002 0.00024604797363281
SELECT category_id FROM products_categories WHERE product_id = '2521' AND prod_type = 'amz'
153 0.0002 0.00017309188842773
SELECT parent_id FROM categories WHERE id = '27'
154 0.0002 0.00018787384033203
SELECT * FROM categories WHERE id = '27'
155 0.0002 0.00015997886657715
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
156 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
157 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '27'
158 0.0002 0.00019001960754395
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 
159 0.0002 0.00019001960754395
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 
160 0.0002 0.00019216537475586
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
161 0.0002 0.00021481513977051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
162 0.0003 0.00027680397033691
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
163 0.0002 0.00018405914306641
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
164 0.0002 0.00018191337585449
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
165 0.0002 0.00022387504577637
SELECT * FROM pages WHERE id = 38
166 0.0040 0.0039501190185547
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
167 0.0005 0.00045108795166016
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1627933594;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
168 0.0006 0.00056910514831543
SELECT * FROM products WHERE id = 790
169 0.0004 0.00040078163146973
SELECT * FROM products WHERE id = 788
170 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = 787
171 0.0007 0.00072503089904785
SELECT * FROM products WHERE id = 1287
172 0.0006 0.00055694580078125
SELECT * FROM products WHERE id = 777
173 0.0010 0.0010349750518799
SELECT * FROM products WHERE id = 776
174 0.0005 0.00052213668823242
SELECT * FROM products WHERE id = '790'
175 0.0004 0.00044512748718262
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
176 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '790'
177 0.0002 0.00018000602722168
SELECT * FROM productcustomimages WHERE product_id = '790'
178 0.0002 0.00022697448730469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
179 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0003 0.00030517578125
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = '788'
183 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
184 0.0003 0.00025391578674316
SELECT * FROM product_image_select WHERE product_id = '788'
185 0.0002 0.00016403198242188
SELECT * FROM productcustomimages WHERE product_id = '788'
186 0.0002 0.00021100044250488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
187 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0002 0.0002288818359375
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0004 0.00038504600524902
SELECT * FROM products WHERE id = '787'
191 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
192 0.0002 0.00018906593322754
SELECT * FROM product_image_select WHERE product_id = '787'
193 0.0002 0.00017309188842773
SELECT * FROM productcustomimages WHERE product_id = '787'
194 0.0002 0.00021791458129883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
195 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0002 0.00023818016052246
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0002 0.00020003318786621
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0005 0.00046300888061523
SELECT * FROM products WHERE id = '1287'
199 0.0004 0.00042390823364258
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
200 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '1287'
201 0.0002 0.00019717216491699
SELECT * FROM productcustomimages WHERE product_id = '1287'
202 0.0002 0.00021600723266602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
203 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0002 0.0001838207244873
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0005 0.00046706199645996
SELECT * FROM products WHERE id = '777'
207 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
208 0.0002 0.00017309188842773
SELECT * FROM product_image_select WHERE product_id = '777'
209 0.0002 0.00016689300537109
SELECT * FROM productcustomimages WHERE product_id = '777'
210 0.0002 0.0002140998840332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
211 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0003 0.00032782554626465
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0004 0.00040078163146973
SELECT * FROM products WHERE id = '776'
215 0.0004 0.00041794776916504
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
216 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '776'
217 0.0002 0.00017690658569336
SELECT * FROM productcustomimages WHERE product_id = '776'
218 0.0002 0.00019979476928711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
219 0.0002 0.00022792816162109
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0002 0.00018787384033203
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00021886825561523
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0003 0.00027704238891602
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
223 0.0003 0.0002739429473877
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
224 0.0006 0.00058293342590332
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
225 0.0005 0.00045990943908691
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
226 0.0004 0.00044512748718262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
227 0.0003 0.00033712387084961
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
228 0.0004 0.00036907196044922
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
229 0.0003 0.00027108192443848
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'