Rooibos AFRICAN DREAM BIO 100g

Rooibos AFRICAN DREAM BIO 100g
Rooibos AFRICAN DREAM BIO 100g (cliquez sur les images pour élargir)
€5,90
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-19 21:30:15 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.

Description du Fabricant

Rooibos bio fruité aux notes dominantes de fruits rouges, avec pétales de souci bio.
Temps d'infusion : 5 mn
Température de l'eau : 95°C
Moment de la journée : L'après-midi, Le soir.

Caractéristiques du Produit

Rooibos délicatement fruité
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
1.7496600151062 236 0.1190 0


No Amazon API Requests Made.

Total time 1.7496600151062 seconds

Number Time From Start Name Description
1 1.596174955368 Initialise Initialise FSB Function
2 1.5984959602356 App Controller Start Start of the App controller (called before the controller of every page)
3 1.6016240119934 Start of getCategoryListByGroup Function Before first category groups query
4 1.6018509864807 After initial query Before first category groups query
5 1.6018531322479 Get Category List for Group Before the call to getCategoryList function
6 1.6018559932709 Start of GetCategoryList function Start of the function
7 1.6018600463867 Before getting categories Query to get specific category list
8 1.6022369861603 After getting categories Query to get specific category list
9 1.6022391319275 Before getting category custom Before call to function getCategoryCustom
10 1.6184129714966 After getting category custom After call to function getCategoryCustom
11 1.6184151172638 Before getting category custom Before call to function getCategoryCustom
12 1.6284041404724 After getting category custom After call to function getCategoryCustom
13 1.6284070014954 Before getting category custom Before call to function getCategoryCustom
14 1.6329650878906 After getting category custom After call to function getCategoryCustom
15 1.6329669952393 Before getting category custom Before call to function getCategoryCustom
16 1.6353290081024 After getting category custom After call to function getCategoryCustom
17 1.6353311538696 Before getting category custom Before call to function getCategoryCustom
18 1.6376459598541 After getting category custom After call to function getCategoryCustom
19 1.6376490592957 Before getting category custom Before call to function getCategoryCustom
20 1.6391460895538 After getting category custom After call to function getCategoryCustom
21 1.6391489505768 End of GetCategoryList function End of the function
22 1.6391530036926 End of getCategoryListByGroup Function Before return()
23 1.6435470581055 App Controller End End of the App controller (called before the controller of every page)
24 1.6441130638123 Product Start Start of the product info controller
25 1.6461110115051 Cache file not found Starting get product details
26 1.6704051494598 Related products Start getting related products if enabled
27 1.6704070568085 Related Products Start Before the related products are found
28 1.6704080104828 Related Products Keywords Before the related product keywords are found
29 1.6704120635986 Create Keyword List Function Start of function
30 1.6704840660095 Create Keyword List Function After looping provided content - 12 keywords found
31 1.6709830760956 Create Keyword List Function After looping initial keyword list - 11 keywords remaining
32 1.6709890365601 Create Keyword List Function After reducing keyword list
33 1.6710059642792 Create Keyword List Function After selecting by scoring keywords
34 1.671010017395 Create Keyword List Function After final loop of keywords
35 1.6710121631622 Related Products Keywords After the related product keywords are found
36 1.6871600151062 Related Products End After the related products are found
37 1.6933381557465 Product End End of the product info controller (Product Info)
38 1.6941950321198 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.6945900917053 Before Get Options Before the call to getOptions in the tpl class
40 1.7191820144653 After Get Options After the call to getOptions in the tpl class
41 1.7193040847778 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.7193319797516 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.7311580181122 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.731162071228 Product Info: Before Template Display Before the template is displayed
45 1.7496359348297 Product Info: After Template Display After the template is displayed
46 1.7496471405029 Finalizing debug Before the debug is output to the page.
47 1.7496590614319 End of App This is the end of the app logging, final timestamp


Query Debug - 236 Database Queries. Total time 0.1190 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00037908554077148
SELECT parameter, value FROM parameters
2 0.0009 0.00093889236450195
SELECT * FROM `bad_bots`
3 0.0004 0.00036811828613281
SET time_zone = 'Europe/London'
4 0.0002 0.00018596649169922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0015671253204346
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.236.232.99\";}'
6 0.0010 0.00096797943115234
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1634883699'
7 0.0004 0.00041508674621582
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00081992149353027
UPDATE autorun SET lastrun = '2021-10-22 06:21:40' WHERE id = '13'
9 0.0003 0.00025296211242676
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0006 0.00060701370239258
SELECT id FROM pages WHERE pagename = 'rooibos-african-dream-bio-100g' LIMIT 1
11 0.0008 0.00079107284545898
SELECT id FROM products WHERE pagename = 'rooibos-african-dream-bio-100g' AND hidden = 0 LIMIT 1
12 0.0014 0.0014128684997559
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0008 0.00076484680175781
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0004 0.00040102005004883
SELECT * FROM pages WHERE pagename = 'rooibos-african-dream-bio-100g'
15 0.0002 0.0002138614654541
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.00035810470581055
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0075 0.0075139999389648
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.0002 0.00023007392883301
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.0002 0.00016307830810547
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.00017690658569336
SELECT id FROM categories WHERE parent_id = '26'
21 0.0072 0.0071558952331543
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.0003 0.00031399726867676
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.0002 0.00015997886657715
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.0002 0.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0002 0.00016403198242188
SELECT * FROM categorygroups WHERE id = '1'
26 0.0042 0.0041670799255371
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.0002 0.00020503997802734
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.0002 0.00015902519226074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0001 0.00014996528625488
SELECT id FROM categories WHERE parent_id = '27'
30 0.0044 0.0044479370117188
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.0003 0.00026512145996094
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.0002 0.00015592575073242
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.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00015902519226074
SELECT * FROM categorygroups WHERE id = '1'
35 0.0017 0.0017039775848389
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.0002 0.00020384788513184
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.0002 0.0001680850982666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00015902519226074
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0015990734100342
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.0002 0.00017094612121582
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.0002 0.0001518726348877
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.0001 0.00014996528625488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00015592575073242
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.00049996376037598
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.0002 0.00020003318786621
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.0002 0.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00056815147399902
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.0002 0.00018000602722168
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.0002 0.00015521049499512
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.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00015783309936523
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00051498413085938
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.0002 0.00017499923706055
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.0002 0.00016403198242188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0001 0.00014996528625488
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00050997734069824
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.0002 0.00018596649169922
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.0002 0.0001838207244873
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.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00016880035400391
SELECT * FROM categorygroups WHERE id = '1'
62 0.0001 0.00014996528625488
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.0001 0.00014710426330566
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.0001 0.00014591217041016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00016498565673828
SELECT id FROM categories WHERE parent_id = '31'
66 0.0002 0.00016188621520996
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.0002 0.00015902519226074
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.0002 0.00015902519226074
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.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0001 0.00014996528625488
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.0001828670501709
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0002 0.00023007392883301
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0002 0.00022101402282715
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.0002 0.00017690658569336
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0006 0.00057101249694824
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00053596496582031
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0002 0.00019216537475586
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.232.99') >= INET_ATON(ip_start) AND INET_ATON('3.236.232.99') <= INET_ATON(ip_end)
78 0.0002 0.00018095970153809
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0002 0.00016188621520996
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00050806999206543
SELECT * FROM products WHERE pagename = 'rooibos-african-dream-bio-100g'
81 0.0008 0.00083494186401367
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1407
82 0.0005 0.00053977966308594
SELECT * FROM manufacturers WHERE id = '230'
83 0.0006 0.00061798095703125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '230'
84 0.0004 0.00043201446533203
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '230' LIMIT 1
85 0.0008 0.0008389949798584
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '230' ORDER BY RAND() LIMIT 1
86 0.0016 0.001643180847168
SELECT * FROM productimages WHERE product_id = '1407' ORDER BY sortorder ASC
87 0.0002 0.00019311904907227
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '230'
88 0.0006 0.00063800811767578
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '230'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00031399726867676
SELECT * FROM manufacturerimages WHERE manufacturer_id = '230'
90 0.0004 0.0003821849822998
SELECT category_id FROM products_categories WHERE product_id = '1407'
91 0.0002 0.00023889541625977
SELECT * FROM categories WHERE id = '27'
92 0.0045 0.0044541358947754
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.0002 0.00023579597473145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0001 0.00014781951904297
SELECT id FROM categories WHERE parent_id = '27'
95 0.0044 0.0043821334838867
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.0002 0.00021910667419434
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.0002 0.00015616416931152
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.0001 0.00014901161193848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0002 0.00016403198242188
SELECT * FROM productimages WHERE product_id = '1407' ORDER BY sortorder ASC
100 0.0006 0.00056695938110352
SELECT * FROM product_image_select WHERE product_id = '1407'
101 0.0005 0.0005180835723877
SELECT * FROM productcustomimages WHERE product_id = '1407'
102 0.0004 0.00040698051452637
SELECT * FROM productfeeds WHERE product_id = '1407' ORDER BY item_date DESC
103 0.0010 0.00098109245300293
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1407' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0012 0.0011839866638184
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1407' AND t.hidden = 0 AND display_product = 1
105 0.0009 0.00086617469787598
SELECT * FROM productamazoncontent WHERE product_id = '1407'
106 0.0010 0.0010039806365967
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1407' AND a.name = n.originalname
107 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '1407' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00043296813964844
SELECT * FROM productoffers
                WHERE product_id = '1407' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00036001205444336
SELECT * FROM productoffers
                WHERE product_id = 1407
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00049400329589844
SELECT value FROM productattributes
                WHERE product_id = '1407'
                AND name = 'ListPriceAmount'
111 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '1407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0002 0.00017809867858887
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.0084 0.0083560943603516
SELECT *, MATCH (description, title) AGAINST ('rooibos african dream' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos african dream' IN BOOLEAN MODE) AND 1407 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
114 0.0007 0.00071001052856445
SELECT *, MATCH (description, title) AGAINST ('rooibos african dream' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos african dream' IN BOOLEAN MODE) AND 1407 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0006 0.00059318542480469
SELECT *, MATCH (description, title) AGAINST ('rooibos african dream' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos african dream' IN BOOLEAN MODE) AND 1407 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
116 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
117 0.0003 0.00026488304138184
SELECT * FROM product_image_select WHERE product_id = '862'
118 0.0002 0.00019693374633789
SELECT * FROM productcustomimages WHERE product_id = '862'
119 0.0002 0.00022697448730469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
120 0.0003 0.00032782554626465
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0005 0.00050091743469238
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0003 0.00027799606323242
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
124 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '858'
125 0.0002 0.0001671314239502
SELECT * FROM productcustomimages WHERE product_id = '858'
126 0.0002 0.0002448558807373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
127 0.0003 0.00032901763916016
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0003 0.00028300285339355
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0002 0.00017619132995605
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
131 0.0002 0.0001680850982666
SELECT * FROM product_image_select WHERE product_id = '878'
132 0.0002 0.00016498565673828
SELECT * FROM productcustomimages WHERE product_id = '878'
133 0.0002 0.00023007392883301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
134 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00054192543029785
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0002 0.00018095970153809
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0003 0.00029611587524414
SELECT id,asin FROM products WHERE parent_id = 1407
138 0.0002 0.00016880035400391
SELECT category_id FROM products_categories WHERE product_id = '1407'
139 0.0002 0.00019311904907227
SELECT * FROM categories WHERE id = '27'
140 0.0002 0.0001530647277832
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
141 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
142 0.0001 0.00014495849609375
SELECT id FROM categories WHERE parent_id = '27'
143 0.0001 0.00014805793762207
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 
144 0.0002 0.00015997886657715
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 
145 0.0002 0.0001521110534668
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
146 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
147 0.0002 0.00015902519226074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1407' AND a.name = n.originalname
148 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '1407' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0002 0.00016593933105469
SELECT * FROM productoffers
                WHERE product_id = '1407' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00016403198242188
SELECT * FROM productoffers
                WHERE product_id = 1407
                ORDER BY price ASC LIMIT 1
151 0.0002 0.00016880035400391
SELECT value FROM productattributes
                WHERE product_id = '1407'
                AND name = 'ListPriceAmount'
152 0.0004 0.00037384033203125
SELECT * FROM products WHERE id = '1407'
153 0.0002 0.00015592575073242
SELECT value FROM productattributes WHERE product_id = '1407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0002 0.00017404556274414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1407' AND a.name = n.originalname
155 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '1407' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0002 0.00018000602722168
SELECT * FROM productoffers
                WHERE product_id = '1407' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = 1407
                ORDER BY price ASC LIMIT 1
158 0.0002 0.00018596649169922
SELECT value FROM productattributes
                WHERE product_id = '1407'
                AND name = 'ListPriceAmount'
159 0.0003 0.0002899169921875
SELECT category_id FROM products_categories WHERE product_id = '1407' AND prod_type = 'amz'
160 0.0002 0.00015592575073242
SELECT parent_id FROM categories WHERE id = '27'
161 0.0002 0.00017786026000977
SELECT * FROM categories WHERE id = '27'
162 0.0002 0.00020694732666016
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.0002 0.00017714500427246
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
164 0.0002 0.00016117095947266
SELECT id FROM categories WHERE parent_id = '27'
165 0.0001 0.00014805793762207
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.0001 0.00014591217041016
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.0001 0.00014805793762207
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.0002 0.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
169 0.0002 0.00024890899658203
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
170 0.0002 0.00015902519226074
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
171 0.0002 0.00015783309936523
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
172 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = 38
173 0.0050 0.0049741268157959
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
174 0.0006 0.00055599212646484
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:1634883700;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:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
175 0.0005 0.00054597854614258
SELECT * FROM products WHERE id = 790
176 0.0005 0.00049304962158203
SELECT * FROM products WHERE id = 788
177 0.0004 0.00041413307189941
SELECT * FROM products WHERE id = 787
178 0.0005 0.00049614906311035
SELECT * FROM products WHERE id = 1287
179 0.0005 0.00049614906311035
SELECT * FROM products WHERE id = 780
180 0.0005 0.0005040168762207
SELECT * FROM products WHERE id = 779
181 0.0005 0.00046610832214355
SELECT * FROM products WHERE id = '790'
182 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
183 0.0002 0.00018596649169922
SELECT * FROM product_image_select WHERE product_id = '790'
184 0.0002 0.00018095970153809
SELECT * FROM productcustomimages WHERE product_id = '790'
185 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
186 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0004 0.00035476684570312
SELECT * FROM products WHERE id = '788'
190 0.0004 0.00038695335388184
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
191 0.0002 0.00018215179443359
SELECT * FROM product_image_select WHERE product_id = '788'
192 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '788'
193 0.0002 0.00020503997802734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
194 0.0002 0.00017285346984863
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0002 0.00017786026000977
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00023293495178223
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = '787'
198 0.0002 0.0001678466796875
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
199 0.0002 0.00017380714416504
SELECT * FROM product_image_select WHERE product_id = '787'
200 0.0002 0.00019407272338867
SELECT * FROM productcustomimages WHERE product_id = '787'
201 0.0002 0.00017714500427246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
202 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0002 0.00018811225891113
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00023913383483887
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0004 0.00037980079650879
SELECT * FROM products WHERE id = '1287'
206 0.0004 0.00039505958557129
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
207 0.0002 0.00016593933105469
SELECT * FROM product_image_select WHERE product_id = '1287'
208 0.0002 0.00018000602722168
SELECT * FROM productcustomimages WHERE product_id = '1287'
209 0.0002 0.0002291202545166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
210 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00020003318786621
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '780'
214 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
215 0.0002 0.00017309188842773
SELECT * FROM product_image_select WHERE product_id = '780'
216 0.0002 0.00016212463378906
SELECT * FROM productcustomimages WHERE product_id = '780'
217 0.0002 0.00018000602722168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
218 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0002 0.00023698806762695
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0004 0.0004119873046875
SELECT * FROM products WHERE id = '779'
222 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
223 0.0002 0.00017905235290527
SELECT * FROM product_image_select WHERE product_id = '779'
224 0.0002 0.00016283988952637
SELECT * FROM productcustomimages WHERE product_id = '779'
225 0.0002 0.00020289421081543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
226 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0002 0.00016999244689941
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0002 0.00020098686218262
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0003 0.00025701522827148
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
230 0.0004 0.00036096572875977
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
231 0.0007 0.0006561279296875
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
232 0.0004 0.00040888786315918
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00037097930908203
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
234 0.0003 0.00032711029052734
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0004 0.00039911270141602
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
236 0.0005 0.00049901008605957
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'