Désir de Vrai Rooibos Nature Afrique du Sud N° 11 100 g - Lot de 6

Désir de Vrai Rooibos Nature Afrique du Sud N° 11 100 g - Lot de 6
Désir de Vrai Rooibos Nature Afrique du Sud N° 11 100 g - Lot de 6 Désir de Vrai Rooibos Nature Afrique du Sud N° 11 100 g - Lot de 6 Désir de Vrai Rooibos Nature Afrique du Sud N° 11 100 g - Lot de 6 Désir de Vrai Rooibos Nature Afrique du Sud N° 11 100 g - Lot de 6 Désir de Vrai Rooibos Nature Afrique du Sud N° 11 100 g - Lot de 6 (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2022-05-26 04:00:49 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.

Caractéristiques du Produit

Réputé pour ses vertus digestes Délicat et Rond Infusion 95°C, 5 min Thé en vrac
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.8727388381958 245 0.1414 0


No Amazon API Requests Made.

Total time 0.8727388381958 seconds

Number Time From Start Name Description
1 0.64688587188721 Initialise Initialise FSB Function
2 0.6493878364563 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65295600891113 Start of getCategoryListByGroup Function Before first category groups query
4 0.65345501899719 After initial query Before first category groups query
5 0.65345788002014 Get Category List for Group Before the call to getCategoryList function
6 0.65346097946167 Start of GetCategoryList function Start of the function
7 0.65346384048462 Before getting categories Query to get specific category list
8 0.6540470123291 After getting categories Query to get specific category list
9 0.65404891967773 Before getting category custom Before call to function getCategoryCustom
10 0.67232298851013 After getting category custom After call to function getCategoryCustom
11 0.67232584953308 Before getting category custom Before call to function getCategoryCustom
12 0.68359684944153 After getting category custom After call to function getCategoryCustom
13 0.68359994888306 Before getting category custom Before call to function getCategoryCustom
14 0.68992400169373 After getting category custom After call to function getCategoryCustom
15 0.68992590904236 Before getting category custom Before call to function getCategoryCustom
16 0.69391703605652 After getting category custom After call to function getCategoryCustom
17 0.69391894340515 Before getting category custom Before call to function getCategoryCustom
18 0.69658994674683 After getting category custom After call to function getCategoryCustom
19 0.69659304618835 Before getting category custom Before call to function getCategoryCustom
20 0.69983983039856 After getting category custom After call to function getCategoryCustom
21 0.69984197616577 End of GetCategoryList function End of the function
22 0.69984698295593 End of getCategoryListByGroup Function Before return()
23 0.70492386817932 App Controller End End of the App controller (called before the controller of every page)
24 0.70548295974731 Product Start Start of the product info controller
25 0.70739698410034 Cache file not found Starting get product details
26 0.73163890838623 Related products Start getting related products if enabled
27 0.73164105415344 Related Products Start Before the related products are found
28 0.73164200782776 Related Products Keywords Before the related product keywords are found
29 0.7316460609436 Create Keyword List Function Start of function
30 0.73168897628784 Create Keyword List Function After looping provided content - 41 keywords found
31 0.73306798934937 Create Keyword List Function After looping initial keyword list - 29 keywords remaining
32 0.73307800292969 Create Keyword List Function After reducing keyword list
33 0.73320603370667 Create Keyword List Function After selecting by scoring keywords
34 0.73320984840393 Create Keyword List Function After final loop of keywords
35 0.73321199417114 Related Products Keywords After the related product keywords are found
36 0.75349903106689 Related Products End After the related products are found
37 0.76055788993835 Product End End of the product info controller (Product Info)
38 0.76140689849854 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.76182889938354 Before Get Options Before the call to getOptions in the tpl class
40 0.79174184799194 After Get Options After the call to getOptions in the tpl class
41 0.79182004928589 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.79184699058533 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.81971001625061 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.81971502304077 Product Info: Before Template Display Before the template is displayed
45 0.87270784378052 Product Info: After Template Display After the template is displayed
46 0.8727240562439 Finalizing debug Before the debug is output to the page.
47 0.87273788452148 End of App This is the end of the app logging, final timestamp


Query Debug - 245 Database Queries. Total time 0.1414 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.0004580020904541
SELECT parameter, value FROM parameters
2 0.0011 0.0010809898376465
SELECT * FROM `bad_bots`
3 0.0006 0.00059795379638672
SET time_zone = 'Europe/London'
4 0.0004 0.0003509521484375
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0024 0.0024178028106689
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0015 0.0014500617980957
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653725126'
7 0.0005 0.0005180835723877
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00042200088500977
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00065803527832031
SELECT id FROM pages WHERE pagename = 'desir-de-vrai-rooibos-nature-afrique-du-sud-n-11-100-g-lot-de-6' LIMIT 1
10 0.0008 0.00075006484985352
SELECT id FROM products WHERE pagename = 'desir-de-vrai-rooibos-nature-afrique-du-sud-n-11-100-g-lot-de-6' AND hidden = 0 LIMIT 1
11 0.0015 0.0015349388122559
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00081586837768555
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0008 0.00080704689025879
SELECT * FROM pages WHERE pagename = 'desir-de-vrai-rooibos-nature-afrique-du-sud-n-11-100-g-lot-de-6'
14 0.0005 0.00048303604125977
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00054788589477539
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0095 0.009533166885376
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.0003 0.00034189224243164
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.0003 0.00032615661621094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00035691261291504
SELECT id FROM categories WHERE parent_id = '26'
20 0.0067 0.0067110061645508
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.0003 0.00026392936706543
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.00020408630371094
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.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.0001978874206543
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0043890476226807
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.0003 0.00033307075500488
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.0003 0.00026798248291016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0043230056762695
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.0004 0.00044512748718262
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0005 0.00054597854614258
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.0003 0.00034785270690918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00029683113098145
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016379356384277
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.0004 0.00044703483581543
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.0005 0.00049614906311035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00044488906860352
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.00180983543396
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0005 0.00048398971557617
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.0003 0.00026202201843262
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0004 0.00039315223693848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00021886825561523
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00086283683776855
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.0004 0.00044417381286621
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00035500526428223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00044393539428711
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00078010559082031
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.0003 0.00033402442932129
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.00023698806762695
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.00021004676818848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00019979476928711
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00057387351989746
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.00022196769714355
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.0001981258392334
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00059700012207031
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.00022006034851074
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.00018191337585449
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.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00019097328186035
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00075006484985352
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.0002138614654541
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.00023007392883301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00019097328186035
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00065088272094727
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.0004 0.00036787986755371
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.0003 0.00029706954956055
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.0002439022064209
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00021004676818848
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.0002291202545166
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.0002739429473877
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00037813186645508
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.0002129077911377
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00052618980407715
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00065016746520996
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.0002751350402832
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.247.88') >= INET_ATON(ip_start) AND INET_ATON('34.231.247.88') <= INET_ATON(ip_end)
77 0.0003 0.00026798248291016
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00029206275939941
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00067400932312012
SELECT * FROM products WHERE pagename = 'desir-de-vrai-rooibos-nature-afrique-du-sud-n-11-100-g-lot-de-6'
80 0.0006 0.00064492225646973
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1254
81 0.0006 0.00060105323791504
SELECT * FROM manufacturers WHERE id = '278'
82 0.0006 0.0005640983581543
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '278'
83 0.0004 0.00037312507629395
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '278' LIMIT 1
84 0.0008 0.00076389312744141
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '278' ORDER BY RAND() LIMIT 1
85 0.0014 0.00136399269104
SELECT * FROM productimages WHERE product_id = '1143' ORDER BY sortorder ASC
86 0.0003 0.00032401084899902
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '278'
87 0.0005 0.0005490779876709
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '278'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00043797492980957
SELECT * FROM manufacturerimages WHERE manufacturer_id = '278'
89 0.0005 0.00048708915710449
SELECT category_id FROM products_categories WHERE product_id = '1254'
90 0.0003 0.00031208992004395
SELECT * FROM categories WHERE id = '27'
91 0.0046 0.0045719146728516
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.0002 0.00023293495178223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00041317939758301
SELECT id FROM categories WHERE parent_id = '27'
94 0.0044 0.0043590068817139
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.0002 0.00022006034851074
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.0002291202545166
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.00020885467529297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0010 0.00095391273498535
SELECT * FROM productimages WHERE product_id = '1254' ORDER BY sortorder ASC
99 0.0005 0.0004878044128418
SELECT * FROM product_image_select WHERE product_id = '1254'
100 0.0003 0.0002741813659668
SELECT * FROM productcustomimages WHERE product_id = '1254'
101 0.0003 0.00026488304138184
SELECT * FROM productfeeds WHERE product_id = '1254' ORDER BY item_date DESC
102 0.0013 0.0012929439544678
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1254' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00053691864013672
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1254' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00037312507629395
SELECT * FROM productamazoncontent WHERE product_id = '1254'
105 0.0012 0.001162052154541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1254' AND a.name = n.originalname
106 0.0004 0.00037479400634766
SELECT * FROM productoffers WHERE product_id = '1254' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00036716461181641
SELECT * FROM productoffers
                WHERE product_id = '1254' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = 1254
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00043296813964844
SELECT value FROM productattributes
                WHERE product_id = '1254'
                AND name = 'ListPriceAmount'
110 0.0005 0.00045204162597656
SELECT value FROM productattributes WHERE product_id = '1254' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.00023412704467773
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
112 0.0081 0.008087158203125
SELECT *, MATCH (description, title) AGAINST ('rooibos nature afrique' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos nature afrique' IN BOOLEAN MODE) AND 1254 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00058794021606445
SELECT *, MATCH (description, title) AGAINST ('rooibos nature afrique' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos nature afrique' IN BOOLEAN MODE) AND 1254 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00051712989807129
SELECT *, MATCH (description, title) AGAINST ('rooibos nature afrique' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos nature afrique' IN BOOLEAN MODE) AND 1254 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
116 0.0008 0.00076818466186523
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
117 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '822'
118 0.0002 0.00019407272338867
SELECT * FROM productcustomimages WHERE product_id = '822'
119 0.0008 0.00077319145202637
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
120 0.0007 0.00070285797119141
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
121 0.0005 0.00046110153198242
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
122 0.0002 0.00021910667419434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
123 0.0004 0.0003659725189209
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0004 0.00041317939758301
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00038886070251465
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
126 0.0002 0.00019001960754395
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
127 0.0002 0.00023603439331055
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
128 0.0002 0.00023412704467773
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
129 0.0002 0.00016999244689941
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
130 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0007 0.00072193145751953
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
132 0.0004 0.00037217140197754
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
133 0.0003 0.00033116340637207
SELECT * FROM product_image_select WHERE product_id = '858'
134 0.0002 0.00020217895507812
SELECT * FROM productcustomimages WHERE product_id = '858'
135 0.0003 0.00032901763916016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
136 0.0004 0.00039196014404297
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0004 0.00044608116149902
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0002 0.0001988410949707
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
140 0.0002 0.00018596649169922
SELECT * FROM product_image_select WHERE product_id = '878'
141 0.0002 0.00019288063049316
SELECT * FROM productcustomimages WHERE product_id = '878'
142 0.0002 0.00022196769714355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
143 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0002 0.00020980834960938
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0003 0.00027704238891602
SELECT id,asin FROM products WHERE parent_id = 1254
147 0.0002 0.00017714500427246
SELECT category_id FROM products_categories WHERE product_id = '1254'
148 0.0002 0.00021100044250488
SELECT * FROM categories WHERE id = '27'
149 0.0002 0.00017905235290527
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
150 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
151 0.0002 0.00017189979553223
SELECT id FROM categories WHERE parent_id = '27'
152 0.0002 0.00019407272338867
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 
153 0.0002 0.00017309188842773
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 
154 0.0002 0.00017285346984863
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
155 0.0002 0.00020599365234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
156 0.0002 0.00020503997802734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1254' AND a.name = n.originalname
157 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '1254' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '1254' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0002 0.00020122528076172
SELECT * FROM productoffers
                WHERE product_id = 1254
                ORDER BY price ASC LIMIT 1
160 0.0002 0.00018095970153809
SELECT value FROM productattributes
                WHERE product_id = '1254'
                AND name = 'ListPriceAmount'
161 0.0005 0.00053000450134277
SELECT * FROM products WHERE id = '1254'
162 0.0002 0.00019001960754395
SELECT value FROM productattributes WHERE product_id = '1254' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0002 0.00020694732666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1254' AND a.name = n.originalname
164 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '1254' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '1254' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = 1254
                ORDER BY price ASC LIMIT 1
167 0.0002 0.0001978874206543
SELECT value FROM productattributes
                WHERE product_id = '1254'
                AND name = 'ListPriceAmount'
168 0.0003 0.00030899047851562
SELECT category_id FROM products_categories WHERE product_id = '1254' AND prod_type = 'amz'
169 0.0002 0.00018405914306641
SELECT parent_id FROM categories WHERE id = '27'
170 0.0002 0.00021100044250488
SELECT * FROM categories WHERE id = '27'
171 0.0002 0.00020217895507812
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
172 0.0002 0.00019598007202148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
173 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '27'
174 0.0002 0.00018405914306641
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 
175 0.0002 0.00017809867858887
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 
176 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
177 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
178 0.0003 0.00029397010803223
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
179 0.0002 0.00017595291137695
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
180 0.0002 0.00018095970153809
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
181 0.0003 0.00025200843811035
SELECT * FROM pages WHERE id = 38
182 0.0039 0.0039050579071045
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
183 0.0005 0.0004580020904541
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:1653725127;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
184 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = 788
185 0.0006 0.0005640983581543
SELECT * FROM products WHERE id = 787
186 0.0007 0.00074505805969238
SELECT * FROM products WHERE id = 1287
187 0.0007 0.00067305564880371
SELECT * FROM products WHERE id = 780
188 0.0005 0.00051784515380859
SELECT * FROM products WHERE id = 777
189 0.0005 0.00048685073852539
SELECT * FROM products WHERE id = 776
190 0.0005 0.00052499771118164
SELECT * FROM products WHERE id = '788'
191 0.0003 0.00027918815612793
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
192 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '788'
193 0.0002 0.00024104118347168
SELECT * FROM productcustomimages WHERE product_id = '788'
194 0.0003 0.00029301643371582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
195 0.0004 0.00039196014404297
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0005 0.00051784515380859
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0002 0.00022697448730469
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0005 0.00048303604125977
SELECT * FROM products WHERE id = '787'
199 0.0002 0.00024676322937012
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
200 0.0005 0.00045609474182129
SELECT * FROM product_image_select WHERE product_id = '787'
201 0.0002 0.00024294853210449
SELECT * FROM productcustomimages WHERE product_id = '787'
202 0.0002 0.00024795532226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
203 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0002 0.00023698806762695
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0005 0.00047111511230469
SELECT * FROM products WHERE id = '1287'
207 0.0005 0.00046992301940918
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
208 0.0002 0.00024294853210449
SELECT * FROM product_image_select WHERE product_id = '1287'
209 0.0002 0.00020003318786621
SELECT * FROM productcustomimages WHERE product_id = '1287'
210 0.0003 0.00029516220092773
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
211 0.0004 0.00041913986206055
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0002 0.00022101402282715
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0005 0.00045609474182129
SELECT * FROM products WHERE id = '780'
215 0.0003 0.00027084350585938
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
216 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '780'
217 0.0002 0.00022792816162109
SELECT * FROM productcustomimages WHERE product_id = '780'
218 0.0002 0.00020003318786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
219 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00019598007202148
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0004 0.00041317939758301
SELECT * FROM products WHERE id = '777'
223 0.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
224 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '777'
225 0.0002 0.00020503997802734
SELECT * FROM productcustomimages WHERE product_id = '777'
226 0.0004 0.00035500526428223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
227 0.0005 0.00048708915710449
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0004 0.00039315223693848
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0003 0.0003211498260498
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0005 0.00048708915710449
SELECT * FROM products WHERE id = '776'
231 0.0004 0.00042986869812012
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
232 0.0004 0.00038790702819824
SELECT * FROM product_image_select WHERE product_id = '776'
233 0.0004 0.0003819465637207
SELECT * FROM productcustomimages WHERE product_id = '776'
234 0.0003 0.00032210350036621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
235 0.0004 0.00036907196044922
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0002 0.00023198127746582
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0004 0.00039196014404297
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
239 0.0005 0.00045394897460938
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
240 0.0010 0.00098085403442383
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
241 0.0005 0.00048518180847168
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
242 0.0005 0.00046300888061523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
243 0.0006 0.00056695938110352
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
244 0.0005 0.00046610832214355
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
245 0.0004 0.00038313865661621
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'