Naturela Thé Rooibos Vanille n° 106 Bio

Naturela Thé Rooibos Vanille n° 106 Bio
Naturela Thé Rooibos Vanille n° 106 Bio Naturela Thé Rooibos Vanille n° 106 Bio (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 et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour 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.83531808853149 235 0.1667 0


No Amazon API Requests Made.

Total time 0.83531808853149 seconds

Number Time From Start Name Description
1 0.64330911636353 Initialise Initialise FSB Function
2 0.6454291343689 App Controller Start Start of the App controller (called before the controller of every page)
3 0.64921712875366 Start of getCategoryListByGroup Function Before first category groups query
4 0.64955806732178 After initial query Before first category groups query
5 0.64955997467041 Get Category List for Group Before the call to getCategoryList function
6 0.64956498146057 Start of GetCategoryList function Start of the function
7 0.64956998825073 Before getting categories Query to get specific category list
8 0.65009903907776 After getting categories Query to get specific category list
9 0.65010094642639 Before getting category custom Before call to function getCategoryCustom
10 0.66772603988647 After getting category custom After call to function getCategoryCustom
11 0.66773009300232 Before getting category custom Before call to function getCategoryCustom
12 0.67871308326721 After getting category custom After call to function getCategoryCustom
13 0.67871713638306 Before getting category custom Before call to function getCategoryCustom
14 0.68415808677673 After getting category custom After call to function getCategoryCustom
15 0.68416094779968 Before getting category custom Before call to function getCategoryCustom
16 0.68712401390076 After getting category custom After call to function getCategoryCustom
17 0.68712711334229 Before getting category custom Before call to function getCategoryCustom
18 0.69011902809143 After getting category custom After call to function getCategoryCustom
19 0.69012093544006 Before getting category custom Before call to function getCategoryCustom
20 0.69307613372803 After getting category custom After call to function getCategoryCustom
21 0.69307899475098 End of GetCategoryList function End of the function
22 0.69308710098267 End of getCategoryListByGroup Function Before return()
23 0.69868397712708 App Controller End End of the App controller (called before the controller of every page)
24 0.69929313659668 Product Start Start of the product info controller
25 0.70127511024475 Cache file not found Starting get product details
26 0.73044300079346 Related products Start getting related products if enabled
27 0.73044490814209 Related Products Start Before the related products are found
28 0.7304470539093 Related Products Keywords Before the related product keywords are found
29 0.73045301437378 Create Keyword List Function Start of function
30 0.7304859161377 Create Keyword List Function After looping provided content - 18 keywords found
31 0.73117399215698 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
32 0.73118209838867 Create Keyword List Function After reducing keyword list
33 0.73121309280396 Create Keyword List Function After selecting by scoring keywords
34 0.73121690750122 Create Keyword List Function After final loop of keywords
35 0.73121905326843 Related Products Keywords After the related product keywords are found
36 0.75922012329102 Related Products End After the related products are found
37 0.77295398712158 Product End End of the product info controller (Product Info)
38 0.77380800247192 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.77472591400146 Before Get Options Before the call to getOptions in the tpl class
40 0.81347703933716 After Get Options After the call to getOptions in the tpl class
41 0.81357312202454 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.81360697746277 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.82090401649475 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.82090902328491 Product Info: Before Template Display Before the template is displayed
45 0.83528900146484 Product Info: After Template Display After the template is displayed
46 0.83530402183533 Finalizing debug Before the debug is output to the page.
47 0.83531713485718 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1667 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00057816505432129
SELECT parameter, value FROM parameters
2 0.0009 0.00089097023010254
SELECT * FROM `bad_bots`
3 0.0005 0.00046205520629883
SET time_zone = 'Europe/London'
4 0.0003 0.00026488304138184
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0016059875488281
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0009 0.00093913078308105
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653727164'
7 0.0005 0.00046491622924805
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00036001205444336
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00054502487182617
SELECT id FROM pages WHERE pagename = 'naturela-the-rooibos-vanille-n-106-bio' LIMIT 1
10 0.0007 0.00072097778320312
SELECT id FROM products WHERE pagename = 'naturela-the-rooibos-vanille-n-106-bio' AND hidden = 0 LIMIT 1
11 0.0013 0.001255989074707
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0012 0.0012171268463135
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00065898895263672
SELECT * FROM pages WHERE pagename = 'naturela-the-rooibos-vanille-n-106-bio'
14 0.0003 0.00032687187194824
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00049996376037598
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0087 0.0087039470672607
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.0004 0.00035595893859863
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.00022482872009277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '26'
20 0.0069 0.0069069862365723
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.00024604797363281
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.0003 0.00031399726867676
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.0002448558807373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00021910667419434
SELECT * FROM categorygroups WHERE id = '1'
25 0.0045 0.00453782081604
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.00026392936706543
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.00022196769714355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00020980834960938
SELECT id FROM categories WHERE parent_id = '27'
29 0.0044 0.004429817199707
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0005 0.00046801567077637
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.00024509429931641
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.00023198127746582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00021195411682129
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016951560974121
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.00031805038452148
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.00024008750915527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016109943389893
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.0004 0.00039505958557129
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.0004 0.00041604042053223
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.00023889541625977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00021100044250488
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.0005338191986084
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.0003 0.00033283233642578
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.00022196769714355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00020217895507812
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00065398216247559
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.00023603439331055
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.00024104118347168
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.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00020909309387207
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.0005180835723877
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.0003 0.00032687187194824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00029706954956055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00059103965759277
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.00023388862609863
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.00023603439331055
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.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00024008750915527
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.0005950927734375
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.0003 0.00026202201843262
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.0003 0.00025606155395508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00061202049255371
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.0002 0.00023603439331055
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.00024795532226562
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.00022006034851074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00022602081298828
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00025200843811035
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00030183792114258
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00039291381835938
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.0003 0.00030398368835449
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00050783157348633
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0014 0.0013670921325684
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0006 0.0005650520324707
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.00027298927307129
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00027704238891602
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00074887275695801
SELECT * FROM products WHERE pagename = 'naturela-the-rooibos-vanille-n-106-bio'
80 0.0007 0.00065803527832031
UPDATE products SET viewcount = viewcount + 1 WHERE id = 884
81 0.0007 0.00072479248046875
SELECT * FROM manufacturers WHERE id = '236'
82 0.0007 0.00074982643127441
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '236'
83 0.0005 0.00053906440734863
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '236' LIMIT 1
84 0.0008 0.00075793266296387
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '236' ORDER BY RAND() LIMIT 1
85 0.0014 0.0014359951019287
SELECT * FROM productimages WHERE product_id = '884' ORDER BY sortorder ASC
86 0.0004 0.00036096572875977
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '236'
87 0.0006 0.00064587593078613
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '236'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00040006637573242
SELECT * FROM manufacturerimages WHERE manufacturer_id = '236'
89 0.0005 0.00048518180847168
SELECT category_id FROM products_categories WHERE product_id = '884'
90 0.0005 0.00052499771118164
SELECT * FROM categories WHERE id = '27'
91 0.0062 0.0061898231506348
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.00029778480529785
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '27'
94 0.0043 0.0043420791625977
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.00040698051452637
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.0004 0.00044512748718262
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.0004 0.00040006637573242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0004 0.00043010711669922
SELECT * FROM productimages WHERE product_id = '884' ORDER BY sortorder ASC
99 0.0007 0.00069093704223633
SELECT * FROM product_image_select WHERE product_id = '884'
100 0.0006 0.00061798095703125
SELECT * FROM productcustomimages WHERE product_id = '884'
101 0.0005 0.00047993659973145
SELECT * FROM productfeeds WHERE product_id = '884' ORDER BY item_date DESC
102 0.0017 0.0016601085662842
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '884' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0006 0.00058412551879883
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '884' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00041699409484863
SELECT * FROM productamazoncontent WHERE product_id = '884'
105 0.0012 0.0011510848999023
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '884' AND a.name = n.originalname
106 0.0004 0.00041413307189941
SELECT * FROM productoffers WHERE product_id = '884' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00047683715820312
SELECT * FROM productoffers
                WHERE product_id = '884' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0007 0.0007472038269043
SELECT * FROM productoffers
                WHERE product_id = 884
                ORDER BY price ASC LIMIT 1
109 0.0008 0.00078201293945312
SELECT value FROM productattributes
                WHERE product_id = '884'
                AND name = 'ListPriceAmount'
110 0.0006 0.00062894821166992
SELECT value FROM productattributes WHERE product_id = '884' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0004 0.00040602684020996
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.0083 0.0082800388336182
SELECT *, MATCH (description, title) AGAINST ('naturela thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('naturela thé rooibos' IN BOOLEAN MODE) AND 884 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0010 0.00096917152404785
SELECT *, MATCH (description, title) AGAINST ('naturela thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('naturela thé rooibos' IN BOOLEAN MODE) AND 884 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0009 0.00085306167602539
SELECT *, MATCH (description, title) AGAINST ('naturela thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('naturela thé rooibos' IN BOOLEAN MODE) AND 884 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0006 0.00062894821166992
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
116 0.0003 0.00031805038452148
SELECT * FROM product_image_select WHERE product_id = '858'
117 0.0004 0.00042605400085449
SELECT * FROM productcustomimages WHERE product_id = '858'
118 0.0013 0.0012609958648682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
119 0.0007 0.0006718635559082
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0007 0.0007328987121582
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0007 0.00065708160400391
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00031304359436035
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
123 0.0006 0.0006098747253418
SELECT * FROM product_image_select WHERE product_id = '862'
124 0.0006 0.00057101249694824
SELECT * FROM productcustomimages WHERE product_id = '862'
125 0.0019 0.0018579959869385
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
126 0.0012 0.0012128353118896
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0008 0.0008389949798584
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0011 0.0010771751403809
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00051403045654297
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
130 0.0005 0.00046896934509277
SELECT * FROM product_image_select WHERE product_id = '878'
131 0.0005 0.00045490264892578
SELECT * FROM productcustomimages WHERE product_id = '878'
132 0.0024 0.002357006072998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
133 0.0005 0.00050687789916992
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0007 0.00065207481384277
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0009 0.00089311599731445
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0007 0.0007328987121582
SELECT id,asin FROM products WHERE parent_id = 884
137 0.0004 0.00039291381835938
SELECT category_id FROM products_categories WHERE product_id = '884'
138 0.0004 0.00037097930908203
SELECT * FROM categories WHERE id = '27'
139 0.0004 0.00041604042053223
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
140 0.0004 0.00040292739868164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0004 0.00040197372436523
SELECT id FROM categories WHERE parent_id = '27'
142 0.0003 0.00025701522827148
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 
143 0.0003 0.00032305717468262
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 
144 0.0004 0.0003960132598877
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
145 0.0004 0.00041699409484863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0005 0.0004880428314209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '884' AND a.name = n.originalname
147 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '884' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0004 0.0003819465637207
SELECT * FROM productoffers
                WHERE product_id = '884' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0004 0.00035595893859863
SELECT * FROM productoffers
                WHERE product_id = 884
                ORDER BY price ASC LIMIT 1
150 0.0004 0.00037002563476562
SELECT value FROM productattributes
                WHERE product_id = '884'
                AND name = 'ListPriceAmount'
151 0.0007 0.00073099136352539
SELECT * FROM products WHERE id = '884'
152 0.0003 0.00034308433532715
SELECT value FROM productattributes WHERE product_id = '884' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0004 0.0003972053527832
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '884' AND a.name = n.originalname
154 0.0005 0.0005347728729248
SELECT * FROM productoffers WHERE product_id = '884' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '884' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = 884
                ORDER BY price ASC LIMIT 1
157 0.0003 0.0003199577331543
SELECT value FROM productattributes
                WHERE product_id = '884'
                AND name = 'ListPriceAmount'
158 0.0006 0.00061702728271484
SELECT category_id FROM products_categories WHERE product_id = '884' AND prod_type = 'amz'
159 0.0004 0.00040602684020996
SELECT parent_id FROM categories WHERE id = '27'
160 0.0003 0.00031805038452148
SELECT * FROM categories WHERE id = '27'
161 0.0004 0.00037789344787598
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
162 0.0004 0.00039005279541016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0004 0.00038909912109375
SELECT id FROM categories WHERE parent_id = '27'
164 0.0003 0.00032997131347656
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 
165 0.0004 0.00038313865661621
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 
166 0.0004 0.00043392181396484
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
167 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0004 0.00040698051452637
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0004 0.0003969669342041
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0004 0.00043606758117676
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0004 0.0003969669342041
SELECT * FROM pages WHERE id = 38
172 0.0066 0.0065901279449463
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
173 0.0007 0.00065994262695312
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:1653727165;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'
174 0.0010 0.00098013877868652
SELECT * FROM products WHERE id = 788
175 0.0007 0.00068116188049316
SELECT * FROM products WHERE id = 787
176 0.0011 0.0011179447174072
SELECT * FROM products WHERE id = 1287
177 0.0007 0.00066304206848145
SELECT * FROM products WHERE id = 780
178 0.0006 0.00064301490783691
SELECT * FROM products WHERE id = 777
179 0.0008 0.0007779598236084
SELECT * FROM products WHERE id = 776
180 0.0007 0.00071501731872559
SELECT * FROM products WHERE id = '788'
181 0.0004 0.00037097930908203
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
182 0.0004 0.00043487548828125
SELECT * FROM product_image_select WHERE product_id = '788'
183 0.0004 0.00039386749267578
SELECT * FROM productcustomimages WHERE product_id = '788'
184 0.0004 0.00044989585876465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
185 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0004 0.00037717819213867
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0007 0.0007321834564209
SELECT * FROM products WHERE id = '787'
189 0.0006 0.0005640983581543
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
190 0.0003 0.0003359317779541
SELECT * FROM product_image_select WHERE product_id = '787'
191 0.0004 0.00035309791564941
SELECT * FROM productcustomimages WHERE product_id = '787'
192 0.0004 0.00041604042053223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
193 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00027894973754883
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0006 0.00062298774719238
SELECT * FROM products WHERE id = '1287'
197 0.0006 0.0006101131439209
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
198 0.0003 0.00030303001403809
SELECT * FROM product_image_select WHERE product_id = '1287'
199 0.0003 0.00034713745117188
SELECT * FROM productcustomimages WHERE product_id = '1287'
200 0.0004 0.00044703483581543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
201 0.0004 0.00038599967956543
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.00038909912109375
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0008 0.00078201293945312
SELECT * FROM products WHERE id = '780'
205 0.0004 0.00043702125549316
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
206 0.0003 0.00030398368835449
SELECT * FROM product_image_select WHERE product_id = '780'
207 0.0003 0.00028491020202637
SELECT * FROM productcustomimages WHERE product_id = '780'
208 0.0003 0.00031614303588867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
209 0.0004 0.00035691261291504
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00040984153747559
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.00054097175598145
SELECT * FROM products WHERE id = '777'
213 0.0004 0.00042891502380371
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
214 0.0003 0.00033211708068848
SELECT * FROM product_image_select WHERE product_id = '777'
215 0.0002 0.00024509429931641
SELECT * FROM productcustomimages WHERE product_id = '777'
216 0.0005 0.00049304962158203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
217 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00047397613525391
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0011 0.001147985458374
SELECT * FROM products WHERE id = '776'
221 0.0005 0.00052189826965332
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
222 0.0004 0.00035810470581055
SELECT * FROM product_image_select WHERE product_id = '776'
223 0.0004 0.00038909912109375
SELECT * FROM productcustomimages WHERE product_id = '776'
224 0.0005 0.00046205520629883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
225 0.0005 0.00045394897460938
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00038504600524902
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0006 0.00057220458984375
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0008 0.00082302093505859
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0005 0.00049591064453125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00050091743469238
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0005 0.00053787231445312
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0006 0.00056600570678711
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0005 0.00045299530029297
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'