Løv Organic - Rooibos Vert Ananas-Menthe - Recharge 100 g

Løv Organic - Rooibos Vert Ananas-Menthe - Recharge 100 g
Løv Organic - Rooibos Vert Ananas-Menthe - Recharge 100 g (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-07-19 22:01:14 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.57914590835571 251 0.1341 0


No Amazon API Requests Made.

Total time 0.57914590835571 seconds

Number Time From Start Name Description
1 0.39411282539368 Initialise Initialise FSB Function
2 0.39603590965271 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39903998374939 Start of getCategoryListByGroup Function Before first category groups query
4 0.39937090873718 After initial query Before first category groups query
5 0.39937400817871 Get Category List for Group Before the call to getCategoryList function
6 0.39937782287598 Start of GetCategoryList function Start of the function
7 0.39938187599182 Before getting categories Query to get specific category list
8 0.39987087249756 After getting categories Query to get specific category list
9 0.39987277984619 Before getting category custom Before call to function getCategoryCustom
10 0.41794681549072 After getting category custom After call to function getCategoryCustom
11 0.41795182228088 Before getting category custom Before call to function getCategoryCustom
12 0.42790985107422 After getting category custom After call to function getCategoryCustom
13 0.42791485786438 Before getting category custom Before call to function getCategoryCustom
14 0.43386387825012 After getting category custom After call to function getCategoryCustom
15 0.43386888504028 Before getting category custom Before call to function getCategoryCustom
16 0.43628597259521 After getting category custom After call to function getCategoryCustom
17 0.43628978729248 Before getting category custom Before call to function getCategoryCustom
18 0.438640832901 After getting category custom After call to function getCategoryCustom
19 0.43864488601685 Before getting category custom Before call to function getCategoryCustom
20 0.4410719871521 After getting category custom After call to function getCategoryCustom
21 0.44107580184937 End of GetCategoryList function End of the function
22 0.44108700752258 End of getCategoryListByGroup Function Before return()
23 0.44835877418518 App Controller End End of the App controller (called before the controller of every page)
24 0.44906687736511 Product Start Start of the product info controller
25 0.45180583000183 Cache file not found Starting get product details
26 0.48470592498779 Related products Start getting related products if enabled
27 0.48470878601074 Related Products Start Before the related products are found
28 0.48471093177795 Related Products Keywords Before the related product keywords are found
29 0.48471689224243 Create Keyword List Function Start of function
30 0.48476386070251 Create Keyword List Function After looping provided content - 21 keywords found
31 0.48561882972717 Create Keyword List Function After looping initial keyword list - 18 keywords remaining
32 0.48563098907471 Create Keyword List Function After reducing keyword list
33 0.48566579818726 Create Keyword List Function After selecting by scoring keywords
34 0.4856698513031 Create Keyword List Function After final loop of keywords
35 0.48567199707031 Related Products Keywords After the related product keywords are found
36 0.50091099739075 Related Products End After the related products are found
37 0.509840965271 Product End End of the product info controller (Product Info)
38 0.51086592674255 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.51136183738708 Before Get Options Before the call to getOptions in the tpl class
40 0.5379478931427 After Get Options After the call to getOptions in the tpl class
41 0.53804492950439 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.53807878494263 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.55327987670898 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.55329179763794 Product Info: Before Template Display Before the template is displayed
45 0.57909393310547 Product Info: After Template Display After the template is displayed
46 0.57912182807922 Finalizing debug Before the debug is output to the page.
47 0.57914400100708 End of App This is the end of the app logging, final timestamp


Query Debug - 251 Database Queries. Total time 0.1341 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00044107437133789
SELECT parameter, value FROM parameters
2 0.0009 0.00088191032409668
SELECT * FROM `bad_bots`
3 0.0003 0.00032997131347656
SET time_zone = 'Europe/London'
4 0.0003 0.00026679039001465
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0017719268798828
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.110.106\";}'
6 0.0012 0.0012378692626953
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627542060'
7 0.0004 0.00041103363037109
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00029706954956055
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00045418739318848
SELECT id FROM pages WHERE pagename = 'lv-organic-rooibos-vert-ananas-menthe-recharge-100-g' LIMIT 1
10 0.0005 0.00054383277893066
SELECT id FROM products WHERE pagename = 'lv-organic-rooibos-vert-ananas-menthe-recharge-100-g' AND hidden = 0 LIMIT 1
11 0.0011 0.0010550022125244
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00079798698425293
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.0007178783416748
SELECT * FROM pages WHERE pagename = 'lv-organic-rooibos-vert-ananas-menthe-recharge-100-g'
14 0.0003 0.00031590461730957
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00046300888061523
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0089 0.0089428424835205
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.0002 0.00020194053649902
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.0004 0.00036811828613281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00023388862609863
SELECT id FROM categories WHERE parent_id = '26'
20 0.0072 0.0071649551391602
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.0004 0.00037884712219238
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.00022506713867188
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00018501281738281
SELECT * FROM categorygroups WHERE id = '1'
25 0.0042 0.0042221546173096
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.00020503997802734
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.00018906593322754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00017905235290527
SELECT id FROM categories WHERE parent_id = '27'
29 0.0042 0.0042262077331543
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.00019598007202148
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.00017690658569336
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.00016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00022697448730469
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014619827270508
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.00019192695617676
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.00016188621520996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.0001680850982666
SELECT id FROM categories WHERE parent_id = '28'
38 0.0030 0.0030090808868408
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.00024104118347168
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.00020003318786621
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.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00018191337585449
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.0004880428314209
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.00018095970153809
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.00016903877258301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.0005030632019043
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.00020098686218262
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.00018906593322754
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00016999244689941
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00046014785766602
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.00017404556274414
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.00020480155944824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00018000602722168
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00047492980957031
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.00018906593322754
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.00017786026000977
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00016903877258301
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00049901008605957
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.00017380714416504
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.00016379356384277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00015401840209961
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00049400329589844
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.00016307830810547
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.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00029993057250977
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00038814544677734
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.0003049373626709
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00024914741516113
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.00022101402282715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0004 0.00039911270141602
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00053501129150391
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00030803680419922
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.110.106') >= INET_ATON(ip_start) AND INET_ATON('3.236.110.106') <= INET_ATON(ip_end)
77 0.0002 0.00019192695617676
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00019598007202148
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.0005650520324707
SELECT * FROM products WHERE pagename = 'lv-organic-rooibos-vert-ananas-menthe-recharge-100-g'
80 0.0008 0.00083494186401367
UPDATE products SET viewcount = viewcount + 1 WHERE id = 930
81 0.0003 0.00028705596923828
SELECT * FROM manufacturers WHERE id = '249'
82 0.0005 0.00054502487182617
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '249'
83 0.0002 0.00021004676818848
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '249' LIMIT 1
84 0.0016 0.0016360282897949
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '249' ORDER BY RAND() LIMIT 1
85 0.0003 0.00026082992553711
SELECT * FROM productimages WHERE product_id = '969' ORDER BY sortorder ASC
86 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '249'
87 0.0007 0.00066113471984863
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '249'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.00026488304138184
SELECT * FROM manufacturerimages WHERE manufacturer_id = '249'
89 0.0003 0.00031208992004395
SELECT category_id FROM products_categories WHERE product_id = '930'
90 0.0002 0.00022101402282715
SELECT * FROM categories WHERE id = '27'
91 0.0057 0.00571608543396
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.0002748966217041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '27'
94 0.0042 0.0042219161987305
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
95 0.0002 0.00019192695617676
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.00030016899108887
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.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0012 0.0011749267578125
SELECT * FROM productimages WHERE product_id = '930' ORDER BY sortorder ASC
99 0.0004 0.00040102005004883
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '930' AND p.id = pi.product_id ORDER BY pi.sortorder
100 0.0003 0.0003049373626709
SELECT * FROM product_image_select WHERE product_id = '930'
101 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '930'
102 0.0002 0.00024294853210449
SELECT * FROM productfeeds WHERE product_id = '930' ORDER BY item_date DESC
103 0.0015 0.0015130043029785
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '930' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0007 0.00072908401489258
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '930' AND t.hidden = 0 AND display_product = 1
105 0.0002 0.0001978874206543
SELECT * FROM tags WHERE id = '1'
106 0.0016 0.0015769004821777
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0017 0.0017139911651611
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0016 0.0016119480133057
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
110 0.0005 0.00052118301391602
SELECT * FROM productamazoncontent WHERE product_id = '930'
111 0.0005 0.00047397613525391
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '930'
                GROUP BY o.product_id
112 0.0004 0.00038909912109375
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '930'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
113 0.0003 0.00031614303588867
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 930
114 0.0011 0.0010759830474854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '930' AND a.name = n.originalname
115 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '930' AND merchantid = 'A1X6FK5RDHNB96'
116 0.0003 0.00034213066101074
SELECT * FROM productoffers
                WHERE product_id = '930' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = 930
                ORDER BY price ASC LIMIT 1
118 0.0003 0.00031208992004395
SELECT value FROM productattributes
                WHERE product_id = '930'
                AND name = 'ListPriceAmount'
119 0.0003 0.00029993057250977
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '930'
                GROUP BY o.product_id
120 0.0002 0.00022315979003906
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '930'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
121 0.0002 0.00019192695617676
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 930
122 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0004 0.00036001205444336
SELECT * FROM products WHERE parent_id = '930'
124 0.0002 0.00019097328186035
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
125 0.0075 0.0075161457061768
SELECT *, MATCH (description, title) AGAINST ('vert ananas-menthe recharge' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vert ananas-menthe recharge' IN BOOLEAN MODE) AND 930 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
126 0.0006 0.00058197975158691
SELECT *, MATCH (description, title) AGAINST ('vert ananas-menthe recharge' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vert ananas-menthe recharge' IN BOOLEAN MODE) AND 930 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
127 0.0007 0.0006709098815918
SELECT *, MATCH (description, title) AGAINST ('vert ananas-menthe recharge' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vert ananas-menthe recharge' IN BOOLEAN MODE) AND 930 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
128 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '1264' ORDER BY sortorder ASC
129 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '1264'
130 0.0002 0.00018596649169922
SELECT * FROM productcustomimages WHERE product_id = '1264'
131 0.0003 0.00025582313537598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname
132 0.0003 0.0003349781036377
SELECT * FROM productoffers WHERE product_id = '1264' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '1264' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '1264' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '1243' ORDER BY sortorder ASC
136 0.0002 0.00017809867858887
SELECT * FROM product_image_select WHERE product_id = '1243'
137 0.0002 0.0001978874206543
SELECT * FROM productcustomimages WHERE product_id = '1243'
138 0.0003 0.00031089782714844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1243' AND a.name = n.originalname
139 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '1243' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00040316581726074
SELECT * FROM productoffers
                WHERE product_id = '1243' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0002 0.00019717216491699
SELECT value FROM productattributes WHERE product_id = '1243' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0003 0.00028491020202637
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
143 0.0002 0.00019097328186035
SELECT * FROM product_image_select WHERE product_id = '1160'
144 0.0003 0.00032806396484375
SELECT * FROM productcustomimages WHERE product_id = '1160'
145 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
146 0.0003 0.00033283233642578
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00037407875061035
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0003 0.0002598762512207
SELECT id,asin FROM products WHERE parent_id = 930
150 0.0002 0.0001978874206543
SELECT category_id FROM products_categories WHERE product_id = '930'
151 0.0002 0.00020194053649902
SELECT * FROM categories WHERE id = '27'
152 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
153 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
154 0.0002 0.00016498565673828
SELECT id FROM categories WHERE parent_id = '27'
155 0.0003 0.00027894973754883
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 
156 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 (27)
				  AND p.disabled = 0 
157 0.0002 0.00016689300537109
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
158 0.0002 0.00019478797912598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
159 0.0002 0.00017499923706055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '930' AND a.name = n.originalname
160 0.0003 0.00028800964355469
SELECT * FROM productoffers WHERE product_id = '930' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '930' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = 930
                ORDER BY price ASC LIMIT 1
163 0.0002 0.00017976760864258
SELECT value FROM productattributes
                WHERE product_id = '930'
                AND name = 'ListPriceAmount'
164 0.0005 0.00050497055053711
SELECT * FROM products WHERE id = '930'
165 0.0003 0.00025701522827148
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '930'
                GROUP BY o.product_id
166 0.0002 0.00018692016601562
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '930'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
167 0.0002 0.00017690658569336
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 930
168 0.0002 0.00017499923706055
SELECT value FROM productattributes WHERE product_id = '930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0002 0.0001828670501709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '930' AND a.name = n.originalname
170 0.0006 0.0006098747253418
SELECT * FROM productoffers WHERE product_id = '930' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0010 0.00097489356994629
SELECT * FROM productoffers
                WHERE product_id = '930' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = 930
                ORDER BY price ASC LIMIT 1
173 0.0002 0.00017309188842773
SELECT value FROM productattributes
                WHERE product_id = '930'
                AND name = 'ListPriceAmount'
174 0.0003 0.00029706954956055
SELECT category_id FROM products_categories WHERE product_id = '930' AND prod_type = 'amz'
175 0.0002 0.00019598007202148
SELECT parent_id FROM categories WHERE id = '27'
176 0.0002 0.00021696090698242
SELECT * FROM categories WHERE id = '27'
177 0.0002 0.00016593933105469
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
178 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
179 0.0002 0.0001828670501709
SELECT id FROM categories WHERE parent_id = '27'
180 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 
181 0.0002 0.00020408630371094
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 
182 0.0002 0.00020599365234375
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
183 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
184 0.0003 0.00025606155395508
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
185 0.0002 0.00021910667419434
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
186 0.0002 0.00019598007202148
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
187 0.0002 0.00023984909057617
SELECT * FROM pages WHERE id = 38
188 0.0034 0.0034210681915283
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
189 0.0004 0.00038599967956543
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:1627542061;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:10:\"808|amazon\";i:4;s:10:\"810|amazon\";i:5;s:11:\"4947|amazon\";}}' WHERE id = '160'
190 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = 790
191 0.0006 0.00059103965759277
SELECT * FROM products WHERE id = 788
192 0.0006 0.00058102607727051
SELECT * FROM products WHERE id = 787
193 0.0006 0.00059008598327637
SELECT * FROM products WHERE id = 808
194 0.0006 0.00062298774719238
SELECT * FROM products WHERE id = 810
195 0.0006 0.00058102607727051
SELECT * FROM products WHERE id = 4947
196 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = '790'
197 0.0004 0.0004420280456543
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
198 0.0002 0.00024986267089844
SELECT * FROM product_image_select WHERE product_id = '790'
199 0.0002 0.0002140998840332
SELECT * FROM productcustomimages WHERE product_id = '790'
200 0.0003 0.00028514862060547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
201 0.0003 0.00034904479980469
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.00038480758666992
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00029397010803223
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00041508674621582
SELECT * FROM products WHERE id = '788'
205 0.0002 0.0002439022064209
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
206 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '788'
207 0.0002 0.00019001960754395
SELECT * FROM productcustomimages WHERE product_id = '788'
208 0.0002 0.00019693374633789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
209 0.0003 0.00030088424682617
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.0002291202545166
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0004 0.00037002563476562
SELECT * FROM products WHERE id = '787'
213 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
214 0.0002 0.00017595291137695
SELECT * FROM product_image_select WHERE product_id = '787'
215 0.0002 0.00017499923706055
SELECT * FROM productcustomimages WHERE product_id = '787'
216 0.0002 0.00017285346984863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
217 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00020480155944824
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = '808'
221 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
222 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '808'
223 0.0002 0.00018119812011719
SELECT * FROM productcustomimages WHERE product_id = '808'
224 0.0002 0.00023889541625977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
225 0.0003 0.00029706954956055
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0005 0.0005340576171875
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00029993057250977
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00043916702270508
SELECT * FROM products WHERE id = '810'
229 0.0004 0.00039505958557129
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
230 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '810'
231 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '810'
232 0.0002 0.00024318695068359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
233 0.0003 0.00030684471130371
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0004 0.00036096572875977
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00031399726867676
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '4947'
237 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
238 0.0002 0.00020623207092285
SELECT * FROM product_image_select WHERE product_id = '4947'
239 0.0002 0.00018811225891113
SELECT * FROM productcustomimages WHERE product_id = '4947'
240 0.0002 0.00019001960754395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
241 0.0003 0.00030088424682617
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0003 0.00034785270690918
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0002 0.00023913383483887
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0003 0.00028491020202637
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
245 0.0004 0.0004270076751709
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
246 0.0007 0.00070095062255859
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
247 0.0004 0.00043988227844238
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
248 0.0004 0.0004420280456543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
249 0.0004 0.00039100646972656
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
250 0.0004 0.00042486190795898
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
251 0.0003 0.0003049373626709
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'