Floraison Rooibos D'Échauffement 30G

Floraison Rooibos D'Échauffement 30G
Floraison Rooibos D'Échauffement 30G (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 21:31:42 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

Floraison Rooibos D'Échauffement 30G Quantité: 1
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6067287921906 235 0.1410 0


No Amazon API Requests Made.

Total time 1.6067287921906 seconds

Number Time From Start Name Description
1 1.2022778987885 Initialise Initialise FSB Function
2 1.2048439979553 App Controller Start Start of the App controller (called before the controller of every page)
3 1.2089829444885 Start of getCategoryListByGroup Function Before first category groups query
4 1.2093019485474 After initial query Before first category groups query
5 1.209303855896 Get Category List for Group Before the call to getCategoryList function
6 1.2093088626862 Start of GetCategoryList function Start of the function
7 1.2093138694763 Before getting categories Query to get specific category list
8 1.2098529338837 After getting categories Query to get specific category list
9 1.2098557949066 Before getting category custom Before call to function getCategoryCustom
10 1.2123939990997 After getting category custom After call to function getCategoryCustom
11 1.212397813797 Before getting category custom Before call to function getCategoryCustom
12 1.2253198623657 After getting category custom After call to function getCategoryCustom
13 1.2253239154816 Before getting category custom Before call to function getCategoryCustom
14 1.2338118553162 After getting category custom After call to function getCategoryCustom
15 1.2338168621063 Before getting category custom Before call to function getCategoryCustom
16 1.2374188899994 After getting category custom After call to function getCategoryCustom
17 1.2374219894409 Before getting category custom Before call to function getCategoryCustom
18 1.2403409481049 After getting category custom After call to function getCategoryCustom
19 1.2403438091278 Before getting category custom Before call to function getCategoryCustom
20 1.2430658340454 After getting category custom After call to function getCategoryCustom
21 1.2430689334869 End of GetCategoryList function End of the function
22 1.2430779933929 End of getCategoryListByGroup Function Before return()
23 1.2484328746796 App Controller End End of the App controller (called before the controller of every page)
24 1.2490749359131 Product Start Start of the product info controller
25 1.2855010032654 Cache file not found Starting get product details
26 1.3112778663635 Related products Start getting related products if enabled
27 1.3112797737122 Related Products Start Before the related products are found
28 1.3112819194794 Related Products Keywords Before the related product keywords are found
29 1.3112897872925 Create Keyword List Function Start of function
30 1.311331987381 Create Keyword List Function After looping provided content - 9 keywords found
31 1.3119008541107 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
32 1.3119099140167 Create Keyword List Function After reducing keyword list
33 1.3119308948517 Create Keyword List Function After selecting by scoring keywords
34 1.3119359016418 Create Keyword List Function After final loop of keywords
35 1.3119390010834 Related Products Keywords After the related product keywords are found
36 1.3312788009644 Related Products End After the related products are found
37 1.3413939476013 Product End End of the product info controller (Product Info)
38 1.3425297737122 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.3433268070221 Before Get Options Before the call to getOptions in the tpl class
40 1.3764619827271 After Get Options After the call to getOptions in the tpl class
41 1.37655377388 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.3765878677368 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.3933968544006 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.3934037685394 Product Info: Before Template Display Before the template is displayed
45 1.606673002243 Product Info: After Template Display After the template is displayed
46 1.6067018508911 Finalizing debug Before the debug is output to the page.
47 1.6067268848419 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1410 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00057101249694824
SELECT parameter, value FROM parameters
2 0.0013 0.0012819766998291
SELECT * FROM `bad_bots`
3 0.0006 0.0006098747253418
SET time_zone = 'Europe/London'
4 0.0004 0.00037622451782227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0020480155944824
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.192.25.113\";}'
6 0.0014 0.0013880729675293
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653702357'
7 0.0005 0.00049591064453125
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00038290023803711
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00058794021606445
SELECT id FROM pages WHERE pagename = 'floraison-rooibos-dEchauffement-30g' LIMIT 1
10 0.0007 0.00065302848815918
SELECT id FROM products WHERE pagename = 'floraison-rooibos-dEchauffement-30g' AND hidden = 0 LIMIT 1
11 0.0014 0.0014400482177734
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0011 0.0011200904846191
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00070500373840332
SELECT * FROM pages WHERE pagename = 'floraison-rooibos-dEchauffement-30g'
14 0.0003 0.00030112266540527
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00051188468933105
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0004 0.00038003921508789
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.00033402442932129
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.00026583671569824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00022220611572266
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.00023698806762695
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.00024700164794922
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.00022697448730469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00022387504577637
SELECT * FROM categorygroups WHERE id = '1'
25 0.0058 0.0057780742645264
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.00030803680419922
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.00020003318786621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '27'
29 0.0049 0.0048701763153076
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.0003 0.00032210350036621
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.0004 0.00042486190795898
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.00029397010803223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00033903121948242
SELECT * FROM categorygroups WHERE id = '1'
34 0.0024 0.0024218559265137
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.00038981437683105
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.0002291202545166
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '28'
38 0.0036 0.0035901069641113
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.0003 0.00032806396484375
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.00034308433532715
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.0003 0.00033283233642578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00050711631774902
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00085687637329102
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.00026583671569824
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.0003 0.00027704238891602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00089907646179199
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.00026512145996094
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.00022697448730469
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.00021696090698242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00023508071899414
SELECT * FROM categorygroups WHERE id = '1'
52 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 = 30
53 0.0003 0.00029492378234863
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.00020599365234375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00054693222045898
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.00021100044250488
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.00018787384033203
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.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00023198127746582
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00051999092102051
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.00020599365234375
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.00020384788513184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017499923706055
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00060200691223145
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.00024890899658203
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.00021100044250488
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.00023508071899414
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.00023794174194336
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00029397010803223
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.0002751350402832
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.00023698806762695
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00054216384887695
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00068902969360352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00042891502380371
SELECT * FROM ipgeocountries WHERE INET_ATON('44.192.25.113') >= INET_ATON(ip_start) AND INET_ATON('44.192.25.113') <= INET_ATON(ip_end)
77 0.0003 0.00028586387634277
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00025010108947754
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0009 0.00088596343994141
SELECT * FROM products WHERE pagename = 'floraison-rooibos-dEchauffement-30g'
80 0.0011 0.0011301040649414
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1447
81 0.0006 0.00059413909912109
SELECT * FROM manufacturers WHERE id = '334'
82 0.0008 0.00079989433288574
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '334'
83 0.0004 0.00040292739868164
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '334' LIMIT 1
84 0.0007 0.00067496299743652
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '334' ORDER BY RAND() LIMIT 1
85 0.0016 0.001600980758667
SELECT * FROM productimages WHERE product_id = '1439' ORDER BY sortorder ASC
86 0.0002 0.00024509429931641
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '334'
87 0.0006 0.00063800811767578
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '334'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.00034499168395996
SELECT * FROM manufacturerimages WHERE manufacturer_id = '334'
89 0.0004 0.00039815902709961
SELECT category_id FROM products_categories WHERE product_id = '1447'
90 0.0003 0.00028705596923828
SELECT * FROM categories WHERE id = '27'
91 0.0044 0.0043988227844238
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.00024509429931641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '27'
94 0.0046 0.0046138763427734
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.00036787986755371
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.00024700164794922
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.0002439022064209
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0012 0.0011780261993408
SELECT * FROM productimages WHERE product_id = '1447' ORDER BY sortorder ASC
99 0.0004 0.00037789344787598
SELECT * FROM product_image_select WHERE product_id = '1447'
100 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '1447'
101 0.0004 0.00040411949157715
SELECT * FROM productfeeds WHERE product_id = '1447' ORDER BY item_date DESC
102 0.0014 0.0014228820800781
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1447' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00046992301940918
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1447' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00040507316589355
SELECT * FROM productamazoncontent WHERE product_id = '1447'
105 0.0012 0.0012428760528564
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1447' AND a.name = n.originalname
106 0.0004 0.00043296813964844
SELECT * FROM productoffers WHERE product_id = '1447' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.0004279613494873
SELECT * FROM productoffers
                WHERE product_id = '1447' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = 1447
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00041699409484863
SELECT value FROM productattributes
                WHERE product_id = '1447'
                AND name = 'ListPriceAmount'
110 0.0006 0.00056219100952148
SELECT value FROM productattributes WHERE product_id = '1447' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00029301643371582
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.0090 0.0089960098266602
SELECT *, MATCH (description, title) AGAINST ('floraison rooibos dchauffement' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('floraison rooibos dchauffement' IN BOOLEAN MODE) AND 1447 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0009 0.0009150505065918
SELECT *, MATCH (description, title) AGAINST ('floraison rooibos dchauffement' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('floraison rooibos dchauffement' IN BOOLEAN MODE) AND 1447 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0009 0.00090408325195312
SELECT *, MATCH (description, title) AGAINST ('floraison rooibos dchauffement' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('floraison rooibos dchauffement' IN BOOLEAN MODE) AND 1447 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0005 0.0004570484161377
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
116 0.0003 0.00029301643371582
SELECT * FROM product_image_select WHERE product_id = '858'
117 0.0002 0.00022315979003906
SELECT * FROM productcustomimages WHERE product_id = '858'
118 0.0004 0.00039005279541016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
119 0.0005 0.00054597854614258
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0007 0.00066280364990234
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.0002589225769043
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00025796890258789
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
123 0.0003 0.00026893615722656
SELECT * FROM product_image_select WHERE product_id = '878'
124 0.0003 0.00028705596923828
SELECT * FROM productcustomimages WHERE product_id = '878'
125 0.0003 0.00027108192443848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
126 0.0004 0.00038313865661621
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.00045013427734375
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00034999847412109
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
130 0.0003 0.00025105476379395
SELECT * FROM product_image_select WHERE product_id = '862'
131 0.0003 0.0002598762512207
SELECT * FROM productcustomimages WHERE product_id = '862'
132 0.0003 0.00029897689819336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
133 0.0004 0.00043702125549316
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0002 0.0002291202545166
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.00037002563476562
SELECT id,asin FROM products WHERE parent_id = 1447
137 0.0002 0.00023484230041504
SELECT category_id FROM products_categories WHERE product_id = '1447'
138 0.0003 0.00027918815612793
SELECT * FROM categories WHERE id = '27'
139 0.0003 0.00027203559875488
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.0003 0.00030899047851562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00023698806762695
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.0002140998840332
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.00023078918457031
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.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1447' AND a.name = n.originalname
147 0.0002 0.00024604797363281
SELECT * FROM productoffers WHERE product_id = '1447' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0003 0.00026392936706543
SELECT * FROM productoffers
                WHERE product_id = '1447' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = 1447
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00024604797363281
SELECT value FROM productattributes
                WHERE product_id = '1447'
                AND name = 'ListPriceAmount'
151 0.0007 0.00074195861816406
SELECT * FROM products WHERE id = '1447'
152 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '1447' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0003 0.00028300285339355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1447' AND a.name = n.originalname
154 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '1447' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = '1447' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = 1447
                ORDER BY price ASC LIMIT 1
157 0.0004 0.0003809928894043
SELECT value FROM productattributes
                WHERE product_id = '1447'
                AND name = 'ListPriceAmount'
158 0.0005 0.00048995018005371
SELECT category_id FROM products_categories WHERE product_id = '1447' AND prod_type = 'amz'
159 0.0003 0.00034189224243164
SELECT parent_id FROM categories WHERE id = '27'
160 0.0003 0.0003349781036377
SELECT * FROM categories WHERE id = '27'
161 0.0003 0.00031685829162598
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.00022411346435547
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '27'
164 0.0003 0.00034189224243164
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.0003 0.00028586387634277
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.00021600723266602
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.000244140625
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0005 0.00046300888061523
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0004 0.00038409233093262
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0003 0.00031614303588867
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0004 0.00043296813964844
SELECT * FROM pages WHERE id = 38
172 0.0071 0.0071151256561279
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.0005 0.00051307678222656
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:1653702358;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.0006 0.0005638599395752
SELECT * FROM products WHERE id = 788
175 0.0006 0.00059294700622559
SELECT * FROM products WHERE id = 787
176 0.0006 0.00057220458984375
SELECT * FROM products WHERE id = 1287
177 0.0006 0.00061798095703125
SELECT * FROM products WHERE id = 780
178 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = 777
179 0.0005 0.00052905082702637
SELECT * FROM products WHERE id = 776
180 0.0007 0.00070691108703613
SELECT * FROM products WHERE id = '788'
181 0.0004 0.00035619735717773
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
182 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '788'
183 0.0002 0.00023794174194336
SELECT * FROM productcustomimages WHERE product_id = '788'
184 0.0003 0.00029802322387695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
185 0.0002 0.00022697448730469
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.00021481513977051
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.0004889965057373
SELECT * FROM products WHERE id = '787'
189 0.0003 0.00028300285339355
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
190 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '787'
191 0.0002 0.00021719932556152
SELECT * FROM productcustomimages WHERE product_id = '787'
192 0.0004 0.00037813186645508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
193 0.0003 0.00034594535827637
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = '1287'
197 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
198 0.0003 0.0002739429473877
SELECT * FROM product_image_select WHERE product_id = '1287'
199 0.0003 0.00027203559875488
SELECT * FROM productcustomimages WHERE product_id = '1287'
200 0.0004 0.00038695335388184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
201 0.0002 0.00024104118347168
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0006 0.00062203407287598
SELECT * FROM products WHERE id = '780'
205 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
206 0.0003 0.00026106834411621
SELECT * FROM product_image_select WHERE product_id = '780'
207 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '780'
208 0.0003 0.00025606155395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
209 0.0003 0.00032210350036621
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.0003509521484375
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00027799606323242
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0006 0.00064897537231445
SELECT * FROM products WHERE id = '777'
213 0.0003 0.00025582313537598
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
214 0.0003 0.00026607513427734
SELECT * FROM product_image_select WHERE product_id = '777'
215 0.0003 0.00025486946105957
SELECT * FROM productcustomimages WHERE product_id = '777'
216 0.0003 0.00031399726867676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
217 0.0003 0.00029993057250977
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00032615661621094
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0005 0.00051617622375488
SELECT * FROM products WHERE id = '776'
221 0.0005 0.00046896934509277
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
222 0.0003 0.00031590461730957
SELECT * FROM product_image_select WHERE product_id = '776'
223 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '776'
224 0.0003 0.00026702880859375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
225 0.0003 0.00027894973754883
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.00023698806762695
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00035309791564941
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0004 0.00044703483581543
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0008 0.00077700614929199
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0004 0.00044989585876465
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00046992301940918
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0065 0.0064740180969238
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0005 0.00051784515380859
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0005 0.00052404403686523
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'