Infusion "Zero Stress" Mélisse Fruits rouge

Infusion "Zero Stress" Mélisse Fruits rouge
Infusion "Zero Stress" Mélisse Fruits rouge Infusion "Zero Stress" Mélisse Fruits rouge Infusion "Zero Stress" Mélisse Fruits rouge (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-22 07:07: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

Rooibos, citronnelle, feuilles de mélisse, morceaux de fruits rouges, jasmin Boite métal de 55g
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.82063508033752 235 0.1247 0


No Amazon API Requests Made.

Total time 0.82063508033752 seconds

Number Time From Start Name Description
1 0.6551661491394 Initialise Initialise FSB Function
2 0.65766501426697 App Controller Start Start of the App controller (called before the controller of every page)
3 0.66115212440491 Start of getCategoryListByGroup Function Before first category groups query
4 0.66157913208008 After initial query Before first category groups query
5 0.66158199310303 Get Category List for Group Before the call to getCategoryList function
6 0.66158699989319 Start of GetCategoryList function Start of the function
7 0.66159200668335 Before getting categories Query to get specific category list
8 0.6619770526886 After getting categories Query to get specific category list
9 0.66197896003723 Before getting category custom Before call to function getCategoryCustom
10 0.66502594947815 After getting category custom After call to function getCategoryCustom
11 0.66502904891968 Before getting category custom Before call to function getCategoryCustom
12 0.66792416572571 After getting category custom After call to function getCategoryCustom
13 0.66792702674866 Before getting category custom Before call to function getCategoryCustom
14 0.67049312591553 After getting category custom After call to function getCategoryCustom
15 0.67049598693848 Before getting category custom Before call to function getCategoryCustom
16 0.67308616638184 After getting category custom After call to function getCategoryCustom
17 0.67308902740479 Before getting category custom Before call to function getCategoryCustom
18 0.67563009262085 After getting category custom After call to function getCategoryCustom
19 0.67563414573669 Before getting category custom Before call to function getCategoryCustom
20 0.67843413352966 After getting category custom After call to function getCategoryCustom
21 0.67843794822693 End of GetCategoryList function End of the function
22 0.67844915390015 End of getCategoryListByGroup Function Before return()
23 0.68465495109558 App Controller End End of the App controller (called before the controller of every page)
24 0.68530917167664 Product Start Start of the product info controller
25 0.68801116943359 Cache file not found Starting get product details
26 0.71873617172241 Related products Start getting related products if enabled
27 0.71873903274536 Related Products Start Before the related products are found
28 0.71874117851257 Related Products Keywords Before the related product keywords are found
29 0.71874904632568 Create Keyword List Function Start of function
30 0.71879410743713 Create Keyword List Function After looping provided content - 15 keywords found
31 0.7198691368103 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
32 0.71987915039062 Create Keyword List Function After reducing keyword list
33 0.71992516517639 Create Keyword List Function After selecting by scoring keywords
34 0.71993017196655 Create Keyword List Function After final loop of keywords
35 0.71993398666382 Related Products Keywords After the related product keywords are found
36 0.74061512947083 Related Products End After the related products are found
37 0.75123405456543 Product End End of the product info controller (Product Info)
38 0.75220012664795 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.75287199020386 Before Get Options Before the call to getOptions in the tpl class
40 0.78514409065247 After Get Options After the call to getOptions in the tpl class
41 0.78525304794312 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.78528904914856 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.79880905151367 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.79881596565247 Product Info: Before Template Display Before the template is displayed
45 0.82060217857361 Product Info: After Template Display After the template is displayed
46 0.82061910629272 Finalizing debug Before the debug is output to the page.
47 0.82063412666321 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1247 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00070500373840332
SELECT parameter, value FROM parameters
2 0.0012 0.0012362003326416
SELECT * FROM `bad_bots`
3 0.0004 0.00043606758117676
SET time_zone = 'Europe/London'
4 0.0003 0.00029301643371582
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0020380020141602
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0013 0.0013229846954346
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653302510'
7 0.0006 0.00056600570678711
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00040888786315918
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00066208839416504
SELECT id FROM pages WHERE pagename = 'infusion-zero-stress-melisse-fruits-rouge' LIMIT 1
10 0.0007 0.00074005126953125
SELECT id FROM products WHERE pagename = 'infusion-zero-stress-melisse-fruits-rouge' AND hidden = 0 LIMIT 1
11 0.0014 0.0013551712036133
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.00095701217651367
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00055599212646484
SELECT * FROM pages WHERE pagename = 'infusion-zero-stress-melisse-fruits-rouge'
14 0.0004 0.00040912628173828
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00035595893859863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00032401084899902
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.00034093856811523
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.00032496452331543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00032901763916016
SELECT id FROM categories WHERE parent_id = '26'
20 0.0003 0.00028800964355469
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0003 0.00033688545227051
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.00032496452331543
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.0003 0.00032901763916016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00028109550476074
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00030899047851562
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.00030899047851562
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00031185150146484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00031208992004395
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00033020973205566
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.0003209114074707
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.0003 0.00030207633972168
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.00026679039001465
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00025701522827148
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.00025701522827148
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.0003 0.0002591609954834
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '28'
38 0.0003 0.00028586387634277
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.00032615661621094
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.00029087066650391
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.00025796890258789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00026106834411621
SELECT * FROM categorygroups WHERE id = '1'
43 0.0003 0.00026583671569824
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.00024700164794922
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.00025296211242676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '29'
47 0.0003 0.00032305717468262
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.00029802322387695
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.0003 0.00026702880859375
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.0003 0.00026202201843262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00026392936706543
SELECT * FROM categorygroups WHERE id = '1'
52 0.0002 0.00024890899658203
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.00025296211242676
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.00024986267089844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00028085708618164
SELECT id FROM categories WHERE parent_id = '30'
56 0.0003 0.0002899169921875
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.0003 0.00031614303588867
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.0003 0.00025796890258789
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.0003 0.00026178359985352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00024604797363281
SELECT * FROM categorygroups WHERE id = '1'
61 0.0002 0.00024008750915527
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.00032496452331543
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.00030303001403809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00030016899108887
SELECT id FROM categories WHERE parent_id = '31'
65 0.0003 0.00030517578125
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.0003 0.00031495094299316
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0003 0.00026893615722656
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.0003 0.00028204917907715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.0003209114074707
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00032496452331543
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00030994415283203
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00031685829162598
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.00029182434082031
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0008 0.00076723098754883
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00056719779968262
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00028514862060547
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.0004 0.00038504600524902
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00028491020202637
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00073599815368652
SELECT * FROM products WHERE pagename = 'infusion-zero-stress-melisse-fruits-rouge'
80 0.0013 0.0012807846069336
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1162
81 0.0005 0.00054812431335449
SELECT * FROM manufacturers WHERE id = '270'
82 0.0009 0.00090980529785156
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '270'
83 0.0004 0.00043201446533203
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '270' LIMIT 1
84 0.0011 0.0011060237884521
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '270' ORDER BY RAND() LIMIT 1
85 0.0018 0.0017821788787842
SELECT * FROM productimages WHERE product_id = '1162' ORDER BY sortorder ASC
86 0.0003 0.00029993057250977
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '270'
87 0.0008 0.00078105926513672
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '270'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00040507316589355
SELECT * FROM manufacturerimages WHERE manufacturer_id = '270'
89 0.0004 0.00043988227844238
SELECT category_id FROM products_categories WHERE product_id = '1162'
90 0.0003 0.0002892017364502
SELECT * FROM categories WHERE id = '27'
91 0.0068 0.0067939758300781
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.00029301643371582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0003 0.00028181076049805
SELECT id FROM categories WHERE parent_id = '27'
94 0.0062 0.0061910152435303
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.0003 0.00026321411132812
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.0003 0.00025606155395508
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.0003 0.00033998489379883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0004 0.00037479400634766
SELECT * FROM productimages WHERE product_id = '1162' ORDER BY sortorder ASC
99 0.0004 0.00040102005004883
SELECT * FROM product_image_select WHERE product_id = '1162'
100 0.0004 0.00044393539428711
SELECT * FROM productcustomimages WHERE product_id = '1162'
101 0.0005 0.00049591064453125
SELECT * FROM productfeeds WHERE product_id = '1162' ORDER BY item_date DESC
102 0.0017 0.0017149448394775
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1162' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0006 0.00060892105102539
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1162' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00044107437133789
SELECT * FROM productamazoncontent WHERE product_id = '1162'
105 0.0013 0.0013480186462402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1162' AND a.name = n.originalname
106 0.0005 0.00046420097351074
SELECT * FROM productoffers WHERE product_id = '1162' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00044608116149902
SELECT * FROM productoffers
                WHERE product_id = '1162' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00041604042053223
SELECT * FROM productoffers
                WHERE product_id = 1162
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00041699409484863
SELECT value FROM productattributes
                WHERE product_id = '1162'
                AND name = 'ListPriceAmount'
110 0.0006 0.0005950927734375
SELECT value FROM productattributes WHERE product_id = '1162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00027203559875488
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.0086 0.0086209774017334
SELECT *, MATCH (description, title) AGAINST ('infusion andquotzero stressandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('infusion andquotzero stressandquot' IN BOOLEAN MODE) AND 1162 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00062704086303711
SELECT *, MATCH (description, title) AGAINST ('infusion andquotzero stressandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('infusion andquotzero stressandquot' IN BOOLEAN MODE) AND 1162 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0007 0.00065112113952637
SELECT *, MATCH (description, title) AGAINST ('infusion andquotzero stressandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('infusion andquotzero stressandquot' IN BOOLEAN MODE) AND 1162 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0004 0.00039982795715332
SELECT * FROM productimages WHERE product_id = '1251' ORDER BY sortorder ASC
116 0.0004 0.00036120414733887
SELECT * FROM product_image_select WHERE product_id = '1251'
117 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '1251'
118 0.0010 0.0010049343109131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1251' AND a.name = n.originalname
119 0.0006 0.0005650520324707
SELECT * FROM productoffers WHERE product_id = '1251' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0006 0.00062799453735352
SELECT * FROM productoffers
                WHERE product_id = '1251' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '1251' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00034618377685547
SELECT * FROM productimages WHERE product_id = '1159' ORDER BY sortorder ASC
123 0.0003 0.00032496452331543
SELECT * FROM product_image_select WHERE product_id = '1159'
124 0.0003 0.00028491020202637
SELECT * FROM productcustomimages WHERE product_id = '1159'
125 0.0011 0.0010519027709961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1159' AND a.name = n.originalname
126 0.0005 0.00049304962158203
SELECT * FROM productoffers WHERE product_id = '1159' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.00049018859863281
SELECT * FROM productoffers
                WHERE product_id = '1159' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.00046610832214355
SELECT value FROM productattributes WHERE product_id = '1159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00027084350585938
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
130 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '878'
131 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '878'
132 0.0004 0.00040197372436523
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.00047397613525391
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0006 0.00057888031005859
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0006 0.00055599212646484
SELECT id,asin FROM products WHERE parent_id = 1162
137 0.0003 0.00031900405883789
SELECT category_id FROM products_categories WHERE product_id = '1162'
138 0.0004 0.00044488906860352
SELECT * FROM categories WHERE id = '27'
139 0.0003 0.00031113624572754
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.00025796890258789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '27'
142 0.0003 0.00029611587524414
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.0002748966217041
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.0003 0.0002591609954834
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.00024509429931641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0003 0.00030303001403809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1162' AND a.name = n.originalname
147 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '1162' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0004 0.00036287307739258
SELECT * FROM productoffers
                WHERE product_id = '1162' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00026988983154297
SELECT * FROM productoffers
                WHERE product_id = 1162
                ORDER BY price ASC LIMIT 1
150 0.0003 0.0002739429473877
SELECT value FROM productattributes
                WHERE product_id = '1162'
                AND name = 'ListPriceAmount'
151 0.0006 0.00056004524230957
SELECT * FROM products WHERE id = '1162'
152 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '1162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0003 0.00028586387634277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1162' AND a.name = n.originalname
154 0.0003 0.0003058910369873
SELECT * FROM productoffers WHERE product_id = '1162' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0003 0.00030088424682617
SELECT * FROM productoffers
                WHERE product_id = '1162' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0003 0.0003199577331543
SELECT * FROM productoffers
                WHERE product_id = 1162
                ORDER BY price ASC LIMIT 1
157 0.0003 0.00028300285339355
SELECT value FROM productattributes
                WHERE product_id = '1162'
                AND name = 'ListPriceAmount'
158 0.0005 0.00049591064453125
SELECT category_id FROM products_categories WHERE product_id = '1162' AND prod_type = 'amz'
159 0.0003 0.00030207633972168
SELECT parent_id FROM categories WHERE id = '27'
160 0.0003 0.00031781196594238
SELECT * FROM categories WHERE id = '27'
161 0.0003 0.00025510787963867
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.0003 0.00025701522827148
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.00031089782714844
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.00031399726867676
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.0003 0.00026512145996094
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.0003 0.00032901763916016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0004 0.00036787986755371
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0003 0.00033402442932129
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0003 0.00025796890258789
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0004 0.00035691261291504
SELECT * FROM pages WHERE id = 38
172 0.0059 0.005925178527832
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.00051212310791016
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:1653302510;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.0005 0.00046706199645996
SELECT * FROM products WHERE id = 788
175 0.0006 0.00061511993408203
SELECT * FROM products WHERE id = 787
176 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = 1287
177 0.0005 0.0004880428314209
SELECT * FROM products WHERE id = 780
178 0.0004 0.00044822692871094
SELECT * FROM products WHERE id = 777
179 0.0005 0.00053286552429199
SELECT * FROM products WHERE id = 776
180 0.0006 0.00059294700622559
SELECT * FROM products WHERE id = '788'
181 0.0004 0.00041103363037109
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
182 0.0003 0.00027704238891602
SELECT * FROM product_image_select WHERE product_id = '788'
183 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '788'
184 0.0003 0.0002751350402832
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.00026512145996094
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.0002591609954834
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.00051188468933105
SELECT * FROM products WHERE id = '787'
189 0.0003 0.00029420852661133
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
190 0.0003 0.00025486946105957
SELECT * FROM product_image_select WHERE product_id = '787'
191 0.0003 0.0003359317779541
SELECT * FROM productcustomimages WHERE product_id = '787'
192 0.0003 0.00030398368835449
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.00027990341186523
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00030899047851562
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00054287910461426
SELECT * FROM products WHERE id = '1287'
197 0.0004 0.00042295455932617
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
198 0.0003 0.00030684471130371
SELECT * FROM product_image_select WHERE product_id = '1287'
199 0.0003 0.00033807754516602
SELECT * FROM productcustomimages WHERE product_id = '1287'
200 0.0003 0.00031590461730957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
201 0.0003 0.00029993057250977
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.00037097930908203
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00032305717468262
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0005 0.00052094459533691
SELECT * FROM products WHERE id = '780'
205 0.0003 0.00030708312988281
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
206 0.0003 0.00026416778564453
SELECT * FROM product_image_select WHERE product_id = '780'
207 0.0004 0.00041079521179199
SELECT * FROM productcustomimages WHERE product_id = '780'
208 0.0003 0.00034880638122559
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.00037097930908203
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00028681755065918
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00033116340637207
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.0005340576171875
SELECT * FROM products WHERE id = '777'
213 0.0003 0.00032591819763184
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
214 0.0003 0.00026512145996094
SELECT * FROM product_image_select WHERE product_id = '777'
215 0.0004 0.00041294097900391
SELECT * FROM productcustomimages WHERE product_id = '777'
216 0.0004 0.00037097930908203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
217 0.0004 0.00037813186645508
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00026488304138184
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = '776'
221 0.0003 0.00034880638122559
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
222 0.0003 0.00025105476379395
SELECT * FROM product_image_select WHERE product_id = '776'
223 0.0003 0.00026917457580566
SELECT * FROM productcustomimages WHERE product_id = '776'
224 0.0003 0.00034499168395996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
225 0.0004 0.00037908554077148
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.0003201961517334
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00025510787963867
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.0004 0.00040221214294434
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0009 0.00091910362243652
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0005 0.00047111511230469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0004 0.00044512748718262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0006 0.00063204765319824
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0005 0.0004727840423584
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0005 0.00046706199645996
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'