Sachets de thé rooibos originales (80) - Paquet de 6

Sachets de thé rooibos originales (80) - Paquet de 6
Sachets de thé rooibos originales (80) - Paquet 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 2021-09-19 09:30:34 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.75879788398743 235 0.1289 0


No Amazon API Requests Made.

Total time 0.75879788398743 seconds

Number Time From Start Name Description
1 0.56068301200867 Initialise Initialise FSB Function
2 0.56273603439331 App Controller Start Start of the App controller (called before the controller of every page)
3 0.56665706634521 Start of getCategoryListByGroup Function Before first category groups query
4 0.56691193580627 After initial query Before first category groups query
5 0.56691384315491 Get Category List for Group Before the call to getCategoryList function
6 0.56691694259644 Start of GetCategoryList function Start of the function
7 0.56692004203796 Before getting categories Query to get specific category list
8 0.56734895706177 After getting categories Query to get specific category list
9 0.5673508644104 Before getting category custom Before call to function getCategoryCustom
10 0.59007787704468 After getting category custom After call to function getCategoryCustom
11 0.59008097648621 Before getting category custom Before call to function getCategoryCustom
12 0.59163999557495 After getting category custom After call to function getCategoryCustom
13 0.59164190292358 Before getting category custom Before call to function getCategoryCustom
14 0.59641599655151 After getting category custom After call to function getCategoryCustom
15 0.59641790390015 Before getting category custom Before call to function getCategoryCustom
16 0.59860706329346 After getting category custom After call to function getCategoryCustom
17 0.59860897064209 Before getting category custom Before call to function getCategoryCustom
18 0.60089683532715 After getting category custom After call to function getCategoryCustom
19 0.60089993476868 Before getting category custom Before call to function getCategoryCustom
20 0.60384202003479 After getting category custom After call to function getCategoryCustom
21 0.60384488105774 End of GetCategoryList function End of the function
22 0.60385298728943 End of getCategoryListByGroup Function Before return()
23 0.60883188247681 App Controller End End of the App controller (called before the controller of every page)
24 0.60960292816162 Product Start Start of the product info controller
25 0.61527490615845 Cache file not found Starting get product details
26 0.6441638469696 Related products Start getting related products if enabled
27 0.64416599273682 Related Products Start Before the related products are found
28 0.64416790008545 Related Products Keywords Before the related product keywords are found
29 0.64417195320129 Create Keyword List Function Start of function
30 0.64420700073242 Create Keyword List Function After looping provided content - 23 keywords found
31 0.64508700370789 Create Keyword List Function After looping initial keyword list - 19 keywords remaining
32 0.64509391784668 Create Keyword List Function After reducing keyword list
33 0.64513993263245 Create Keyword List Function After selecting by scoring keywords
34 0.64514303207397 Create Keyword List Function After final loop of keywords
35 0.64514589309692 Related Products Keywords After the related product keywords are found
36 0.66162800788879 Related Products End After the related products are found
37 0.66826486587524 Product End End of the product info controller (Product Info)
38 0.66979789733887 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.67022204399109 Before Get Options Before the call to getOptions in the tpl class
40 0.69824004173279 After Get Options After the call to getOptions in the tpl class
41 0.69831895828247 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.69834589958191 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.71850204467773 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.718505859375 Product Info: Before Template Display Before the template is displayed
45 0.75877285003662 Product Info: After Template Display After the template is displayed
46 0.75878500938416 Finalizing debug Before the debug is output to the page.
47 0.75879693031311 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1289 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00045204162597656
SELECT parameter, value FROM parameters
2 0.0009 0.00090193748474121
SELECT * FROM `bad_bots`
3 0.0008 0.00083208084106445
SET time_zone = 'Europe/London'
4 0.0002 0.00021004676818848
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0013 0.0012600421905518
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.212.116\";}'
6 0.0008 0.00083613395690918
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632135093'
7 0.0005 0.00048494338989258
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00025606155395508
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00037097930908203
SELECT id FROM pages WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6' LIMIT 1
10 0.0006 0.00063014030456543
SELECT id FROM products WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6' AND hidden = 0 LIMIT 1
11 0.0020 0.0019500255584717
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.0010409355163574
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0005 0.00051307678222656
SELECT * FROM pages WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6'
14 0.0002 0.00024199485778809
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00040912628173828
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0120 0.011960983276367
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.00033092498779297
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.00029397010803223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '26'
20 0.0090 0.0090467929840088
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.00022292137145996
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.00017809867858887
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00018000602722168
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0002 0.00016403198242188
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.00017690658569336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0001 0.00014901161193848
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0002 0.0001530647277832
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.00015687942504883
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.00015115737915039
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00016188621520996
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0018348693847656
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.0002 0.00020217895507812
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.00016403198242188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00015807151794434
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015919208526611
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0002 0.00020813941955566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0002 0.0001828670501709
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.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00017118453979492
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0002 0.00017309188842773
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.00015807151794434
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00015401840209961
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00049591064453125
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.00016498565673828
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.00016498565673828
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00015902519226074
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.000457763671875
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.00016498565673828
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.00016903877258301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00016689300537109
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00055503845214844
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.00019001960754395
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.00016188621520996
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.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00015997886657715
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00080990791320801
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.00017309188842773
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.00019383430480957
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.0008 0.00076794624328613
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.00016999244689941
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.00020003318786621
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.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00025796890258789
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00025701522827148
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00030803680419922
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.00017404556274414
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00053501129150391
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00059986114501953
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00030088424682617
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.212.116') >= INET_ATON(ip_start) AND INET_ATON('3.236.212.116') <= INET_ATON(ip_end)
77 0.0002 0.00020122528076172
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00019001960754395
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00056004524230957
SELECT * FROM products WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-6'
80 0.0014 0.0013689994812012
UPDATE products SET viewcount = viewcount + 1 WHERE id = 918
81 0.0004 0.00041794776916504
SELECT * FROM manufacturers WHERE id = '639'
82 0.0013 0.0013480186462402
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
83 0.0002 0.00024008750915527
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
84 0.0016 0.0015661716461182
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
85 0.0030 0.0030059814453125
SELECT * FROM productimages WHERE product_id = '4500' ORDER BY sortorder ASC
86 0.0004 0.00040912628173828
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
87 0.0014 0.0014438629150391
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0005 0.00047492980957031
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
89 0.0002 0.00019598007202148
SELECT category_id FROM products_categories WHERE product_id = '918'
90 0.0015 0.0014970302581787
SELECT * FROM categories WHERE id = '27'
91 0.0049 0.0049331188201904
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.00022387504577637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '27'
94 0.0048 0.0047740936279297
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.0006 0.00056004524230957
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.00021100044250488
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.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '918' ORDER BY sortorder ASC
99 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '918'
100 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '918'
101 0.0002 0.00018000602722168
SELECT * FROM productfeeds WHERE product_id = '918' ORDER BY item_date DESC
102 0.0017 0.0016679763793945
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0002 0.00019693374633789
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '918' AND t.hidden = 0 AND display_product = 1
104 0.0002 0.00022292137145996
SELECT * FROM productamazoncontent WHERE product_id = '918'
105 0.0011 0.0011398792266846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname
106 0.0004 0.00044703483581543
SELECT * FROM productoffers WHERE product_id = '918' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00052809715270996
SELECT * FROM productoffers
                WHERE product_id = '918' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = 918
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00057101249694824
SELECT value FROM productattributes
                WHERE product_id = '918'
                AND name = 'ListPriceAmount'
110 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '918' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.0002129077911377
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.0084 0.0083649158477783
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 918 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0005 0.00046396255493164
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 918 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00045394897460938
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 918 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
116 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '878'
117 0.0002 0.00024294853210449
SELECT * FROM productcustomimages WHERE product_id = '878'
118 0.0002 0.00023508071899414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
119 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00031495094299316
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
123 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '862'
124 0.0002 0.00018310546875
SELECT * FROM productcustomimages WHERE product_id = '862'
125 0.0008 0.00075101852416992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
126 0.0004 0.00038790702819824
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0009 0.0009307861328125
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0004 0.00043606758117676
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
130 0.0003 0.00025701522827148
SELECT * FROM product_image_select WHERE product_id = '858'
131 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '858'
132 0.0002 0.0001990795135498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
133 0.0002 0.00021815299987793
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.00036978721618652
SELECT id,asin FROM products WHERE parent_id = 918
137 0.0002 0.00018310546875
SELECT category_id FROM products_categories WHERE product_id = '918'
138 0.0002 0.00023078918457031
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00017595291137695
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.0002 0.00019001960754395
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00017094612121582
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.0002 0.00021696090698242
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.0002 0.0001990795135498
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.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00017595291137695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname
147 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '918' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = '918' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00019979476928711
SELECT * FROM productoffers
                WHERE product_id = 918
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00017499923706055
SELECT value FROM productattributes
                WHERE product_id = '918'
                AND name = 'ListPriceAmount'
151 0.0004 0.00038599967956543
SELECT * FROM products WHERE id = '918'
152 0.0002 0.00019717216491699
SELECT value FROM productattributes WHERE product_id = '918' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00020289421081543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '918' AND a.name = n.originalname
154 0.0002 0.00023889541625977
SELECT * FROM productoffers WHERE product_id = '918' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '918' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00021481513977051
SELECT * FROM productoffers
                WHERE product_id = 918
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00022101402282715
SELECT value FROM productattributes
                WHERE product_id = '918'
                AND name = 'ListPriceAmount'
158 0.0002 0.00017499923706055
SELECT category_id FROM products_categories WHERE product_id = '918' AND prod_type = 'amz'
159 0.0002 0.00017094612121582
SELECT parent_id FROM categories WHERE id = '27'
160 0.0002 0.00017690658569336
SELECT * FROM categories WHERE id = '27'
161 0.0001 0.00014591217041016
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.0002 0.00016498565673828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0001 0.00014495849609375
SELECT id FROM categories WHERE parent_id = '27'
164 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 
165 0.0001 0.00014996528625488
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.0002 0.00016498565673828
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0008 0.00080585479736328
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00018191337585449
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00018095970153809
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0004 0.00037693977355957
SELECT * FROM pages WHERE id = 38
172 0.0044 0.0043621063232422
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.0004 0.00042605400085449
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:1632135094;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:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
174 0.0006 0.00059795379638672
SELECT * FROM products WHERE id = 790
175 0.0005 0.00046706199645996
SELECT * FROM products WHERE id = 788
176 0.0004 0.00044584274291992
SELECT * FROM products WHERE id = 787
177 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = 1287
178 0.0006 0.00061488151550293
SELECT * FROM products WHERE id = 779
179 0.0006 0.00061202049255371
SELECT * FROM products WHERE id = 777
180 0.0007 0.00066208839416504
SELECT * FROM products WHERE id = '790'
181 0.0005 0.00047397613525391
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00020384788513184
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.00020408630371094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00030708312988281
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.00040888786315918
SELECT * FROM products WHERE id = '788'
189 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0003 0.00025701522827148
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.00017714500427246
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0002 0.00019383430480957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00023293495178223
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0004 0.00042605400085449
SELECT * FROM products WHERE id = '787'
197 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.00019693374633789
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00017905235290527
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0002 0.00019097328186035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.0001988410949707
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0005 0.00048589706420898
SELECT * FROM products WHERE id = '1287'
205 0.0004 0.00039911270141602
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0002 0.00019598007202148
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0002 0.0001981258392334
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0021 0.0021250247955322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0002 0.00024604797363281
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0004 0.00041484832763672
SELECT * FROM products WHERE id = '779'
213 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
214 0.0002 0.00017690658569336
SELECT * FROM product_image_select WHERE product_id = '779'
215 0.0002 0.00018692016601562
SELECT * FROM productcustomimages WHERE product_id = '779'
216 0.0002 0.00017905235290527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
217 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0002 0.00020122528076172
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = '777'
221 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0002 0.00018501281738281
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0002 0.00020003318786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0002 0.00020217895507812
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00032711029052734
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0009 0.00094914436340332
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0006 0.00063586235046387
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0005 0.00047588348388672
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00050902366638184
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00044012069702148
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0004 0.0003809928894043
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0002 0.00018906593322754
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'