Numi Tisane Bio & Fairtrade au Curcuma, Rooibos, Cannelle et Vanille Amber Sun- 6 cartons DE 12 filtres chacun

Numi Tisane Bio & Fairtrade au Curcuma, Rooibos, Cannelle et Vanille Amber Sun- 6 cartons DE 12 filtres chacun
Numi Tisane Bio & Fairtrade au Curcuma, Rooibos, Cannelle et Vanille Amber Sun- 6 cartons DE 12 filtres chacun (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-21 01:07:44 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.87583684921265 252 0.1811 0


No Amazon API Requests Made.

Total time 0.87583684921265 seconds

Number Time From Start Name Description
1 0.65962982177734 Initialise Initialise FSB Function
2 0.66211700439453 App Controller Start Start of the App controller (called before the controller of every page)
3 0.66544985771179 Start of getCategoryListByGroup Function Before first category groups query
4 0.66569781303406 After initial query Before first category groups query
5 0.66569995880127 Get Category List for Group Before the call to getCategoryList function
6 0.66570401191711 Start of GetCategoryList function Start of the function
7 0.66570782661438 Before getting categories Query to get specific category list
8 0.66709184646606 After getting categories Query to get specific category list
9 0.66709399223328 Before getting category custom Before call to function getCategoryCustom
10 0.69068694114685 After getting category custom After call to function getCategoryCustom
11 0.6906909942627 Before getting category custom Before call to function getCategoryCustom
12 0.70517683029175 After getting category custom After call to function getCategoryCustom
13 0.70517992973328 Before getting category custom Before call to function getCategoryCustom
14 0.71015501022339 After getting category custom After call to function getCategoryCustom
15 0.71015787124634 Before getting category custom Before call to function getCategoryCustom
16 0.71274900436401 After getting category custom After call to function getCategoryCustom
17 0.71275091171265 Before getting category custom Before call to function getCategoryCustom
18 0.71530795097351 After getting category custom After call to function getCategoryCustom
19 0.71530985832214 Before getting category custom Before call to function getCategoryCustom
20 0.71780180931091 After getting category custom After call to function getCategoryCustom
21 0.71780395507812 End of GetCategoryList function End of the function
22 0.71781086921692 End of getCategoryListByGroup Function Before return()
23 0.7222728729248 App Controller End End of the App controller (called before the controller of every page)
24 0.72285795211792 Product Start Start of the product info controller
25 0.72451496124268 Cache file not found Starting get product details
26 0.75730681419373 Related products Start getting related products if enabled
27 0.75730895996094 Related Products Start Before the related products are found
28 0.75730991363525 Related Products Keywords Before the related product keywords are found
29 0.75731492042542 Create Keyword List Function Start of function
30 0.75742697715759 Create Keyword List Function After looping provided content - 51 keywords found
31 0.75947380065918 Create Keyword List Function After looping initial keyword list - 46 keywords remaining
32 0.7594850063324 Create Keyword List Function After reducing keyword list
33 0.75975584983826 Create Keyword List Function After selecting by scoring keywords
34 0.75976085662842 Create Keyword List Function After final loop of keywords
35 0.75976300239563 Related Products Keywords After the related product keywords are found
36 0.80758285522461 Related Products End After the related products are found
37 0.81735682487488 Product End End of the product info controller (Product Info)
38 0.81823182106018 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.81868100166321 Before Get Options Before the call to getOptions in the tpl class
40 0.84596681594849 After Get Options After the call to getOptions in the tpl class
41 0.84608697891235 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.84611797332764 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.85741281509399 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.85741686820984 Product Info: Before Template Display Before the template is displayed
45 0.87581086158752 Product Info: After Template Display After the template is displayed
46 0.87582302093506 Finalizing debug Before the debug is output to the page.
47 0.87583494186401 End of App This is the end of the app logging, final timestamp


Query Debug - 252 Database Queries. Total time 0.1811 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00050902366638184
SELECT parameter, value FROM parameters
2 0.0012 0.0011508464813232
SELECT * FROM `bad_bots`
3 0.0004 0.00039410591125488
SET time_zone = 'Europe/London'
4 0.0003 0.00025320053100586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0024 0.0023839473724365
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.192.25.113\";}'
6 0.0013 0.001276969909668
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653696980'
7 0.0010 0.0010161399841309
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00025796890258789
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00064992904663086
SELECT id FROM pages WHERE pagename = 'numi-tisane-bio-fairtrade-au-curcuma-rooibos-cannelle-et-vanille' LIMIT 1
10 0.0009 0.00089287757873535
SELECT id FROM products WHERE pagename = 'numi-tisane-bio-fairtrade-au-curcuma-rooibos-cannelle-et-vanille' AND hidden = 0 LIMIT 1
11 0.0014 0.0014159679412842
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00084495544433594
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00063705444335938
SELECT * FROM pages WHERE pagename = 'numi-tisane-bio-fairtrade-au-curcuma-rooibos-cannelle-et-vanille'
14 0.0002 0.00023484230041504
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0014 0.0013608932495117
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0088 0.0087730884552002
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0004 0.00044393539428711
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0002 0.00019693374633789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '26'
20 0.0127 0.01274299621582
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.00023078918457031
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.00025105476379395
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.00028300285339355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00027585029602051
SELECT * FROM categorygroups WHERE id = '1'
25 0.0080 0.0079951286315918
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.00022506713867188
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.00018405914306641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00018310546875
SELECT id FROM categories WHERE parent_id = '27'
29 0.0050 0.0049669742584229
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.00023102760314941
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.00018787384033203
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.00020718574523926
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00019693374633789
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0017731189727783
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.00020408630371094
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.00021195411682129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0017650127410889
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.00018501281738281
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.00017404556274414
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.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.0001838207244873
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00058698654174805
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.00018191337585449
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.00019001960754395
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00017714500427246
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00056886672973633
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.0001828670501709
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.00018811225891113
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.00018787384033203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00022578239440918
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00058579444885254
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.00018692016601562
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.00018501281738281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00017094612121582
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00054502487182617
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.00023102760314941
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.00017499923706055
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00018310546875
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00057792663574219
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.00020194053649902
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.00016617774963379
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017285346984863
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00055098533630371
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.00019097328186035
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.00018405914306641
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00017786026000977
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00019598007202148
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00024008750915527
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00019311904907227
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.00018787384033203
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00045204162597656
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00051212310791016
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00020313262939453
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.0002 0.00019097328186035
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00019288063049316
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.00048995018005371
SELECT * FROM products WHERE pagename = 'numi-tisane-bio-fairtrade-au-curcuma-rooibos-cannelle-et-vanille'
80 0.0005 0.0004580020904541
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2245
81 0.0005 0.0005490779876709
SELECT * FROM manufacturers WHERE id = '436'
82 0.0005 0.00053596496582031
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '436'
83 0.0005 0.00047802925109863
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '436' LIMIT 1
84 0.0011 0.0011110305786133
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '436' ORDER BY RAND() LIMIT 1
85 0.0017 0.0017290115356445
SELECT * FROM productimages WHERE product_id = '2245' ORDER BY sortorder ASC
86 0.0002 0.00024199485778809
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '436'
87 0.0006 0.00060415267944336
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '436'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.00029206275939941
SELECT * FROM manufacturerimages WHERE manufacturer_id = '436'
89 0.0004 0.00038814544677734
SELECT category_id FROM products_categories WHERE product_id = '2245'
90 0.0005 0.00050187110900879
SELECT * FROM categories WHERE id = '27'
91 0.0050 0.0050220489501953
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.00026607513427734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '27'
94 0.0049 0.0049088001251221
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.00021505355834961
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.0001990795135498
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
97 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '2245' ORDER BY sortorder ASC
99 0.0005 0.00046110153198242
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2245' AND p.id = pi.product_id ORDER BY pi.sortorder
100 0.0006 0.00055909156799316
SELECT * FROM product_image_select WHERE product_id = '2245'
101 0.0005 0.00045418739318848
SELECT * FROM productcustomimages WHERE product_id = '2245'
102 0.0004 0.00040602684020996
SELECT * FROM productfeeds WHERE product_id = '2245' ORDER BY item_date DESC
103 0.0022 0.002161979675293
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2245' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0018 0.0017678737640381
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2245' AND t.hidden = 0 AND display_product = 1
105 0.0008 0.00080394744873047
SELECT * FROM productamazoncontent WHERE product_id = '2245'
106 0.0007 0.00067591667175293
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 = '2245'
                GROUP BY o.product_id
107 0.0006 0.00063800811767578
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     = '2245'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
108 0.0004 0.00039386749267578
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2245
109 0.0018 0.0017640590667725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2245' AND a.name = n.originalname
110 0.0005 0.00054502487182617
SELECT * FROM productoffers WHERE product_id = '2245' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = '2245' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0005 0.00048017501831055
SELECT * FROM productoffers
                WHERE product_id = 2245
                ORDER BY price ASC LIMIT 1
113 0.0005 0.00046420097351074
SELECT value FROM productattributes
                WHERE product_id = '2245'
                AND name = 'ListPriceAmount'
114 0.0004 0.0003960132598877
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 = '2245'
                GROUP BY o.product_id
115 0.0004 0.00039291381835938
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     = '2245'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
116 0.0003 0.00026988983154297
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2245
117 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '2245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0005 0.00047588348388672
SELECT * FROM products WHERE parent_id = '2245'
119 0.0002 0.00023102760314941
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
120 0.0087 0.0086860656738281
SELECT *, MATCH (description, title) AGAINST ('bio andamp fairtrade' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bio andamp fairtrade' IN BOOLEAN MODE) AND 2245 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
121 0.0009 0.00089406967163086
SELECT *, MATCH (description, title) AGAINST ('bio andamp fairtrade' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bio andamp fairtrade' IN BOOLEAN MODE) AND 2245 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
122 0.0008 0.00081086158752441
SELECT *, MATCH (description, title) AGAINST ('bio andamp fairtrade' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bio andamp fairtrade' IN BOOLEAN MODE) AND 2245 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
123 0.0087 0.0087199211120605
SELECT *, MATCH (description, title) AGAINST ('amber sun6 cartons' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('amber sun6 cartons' IN BOOLEAN MODE) AND 2245 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
124 0.0007 0.00069904327392578
SELECT *, MATCH (description, title) AGAINST ('amber sun6 cartons' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('amber sun6 cartons' IN BOOLEAN MODE) AND 2245 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
125 0.0005 0.00052881240844727
SELECT *, MATCH (description, title) AGAINST ('amber sun6 cartons' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('amber sun6 cartons' IN BOOLEAN MODE) AND 2245 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
126 0.0091 0.0091137886047363
SELECT *, MATCH (description, title) AGAINST ('curcuma rooibos cannelle' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('curcuma rooibos cannelle' IN BOOLEAN MODE) AND 2245 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
127 0.0006 0.0005800724029541
SELECT *, MATCH (description, title) AGAINST ('curcuma rooibos cannelle' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('curcuma rooibos cannelle' IN BOOLEAN MODE) AND 2245 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
128 0.0004 0.0004420280456543
SELECT *, MATCH (description, title) AGAINST ('curcuma rooibos cannelle' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('curcuma rooibos cannelle' IN BOOLEAN MODE) AND 2245 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
129 0.0026 0.0025770664215088
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
130 0.0003 0.0003349781036377
SELECT * FROM product_image_select WHERE product_id = '858'
131 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '858'
132 0.0011 0.0010650157928467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
133 0.0006 0.00056195259094238
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00043988227844238
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0005 0.00046491622924805
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0014 0.0013940334320068
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
137 0.0004 0.00036001205444336
SELECT * FROM product_image_select WHERE product_id = '878'
138 0.0003 0.00031495094299316
SELECT * FROM productcustomimages WHERE product_id = '878'
139 0.0013 0.0012788772583008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
140 0.0004 0.00040102005004883
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0005 0.00049304962158203
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0012 0.0011889934539795
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
144 0.0006 0.00058317184448242
SELECT * FROM product_image_select WHERE product_id = '862'
145 0.0004 0.00039815902709961
SELECT * FROM productcustomimages WHERE product_id = '862'
146 0.0015 0.0014638900756836
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
147 0.0009 0.0009310245513916
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0006 0.00061392784118652
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0008 0.00082206726074219
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0005 0.00050806999206543
SELECT id,asin FROM products WHERE parent_id = 2245
151 0.0002 0.00023221969604492
SELECT category_id FROM products_categories WHERE product_id = '2245'
152 0.0003 0.00026297569274902
SELECT * FROM categories WHERE id = '27'
153 0.0002 0.00021100044250488
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
154 0.0003 0.00030112266540527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
155 0.0002 0.00023317337036133
SELECT id FROM categories WHERE parent_id = '27'
156 0.0004 0.00038790702819824
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 
157 0.0002 0.00022792816162109
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 
158 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
159 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
160 0.0002 0.00023388862609863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2245' AND a.name = n.originalname
161 0.0003 0.00028610229492188
SELECT * FROM productoffers WHERE product_id = '2245' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '2245' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = 2245
                ORDER BY price ASC LIMIT 1
164 0.0002 0.00018882751464844
SELECT value FROM productattributes
                WHERE product_id = '2245'
                AND name = 'ListPriceAmount'
165 0.0006 0.00063204765319824
SELECT * FROM products WHERE id = '2245'
166 0.0002 0.00023603439331055
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 = '2245'
                GROUP BY o.product_id
167 0.0003 0.00025510787963867
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     = '2245'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
168 0.0002 0.00021481513977051
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2245
169 0.0002 0.00022411346435547
SELECT value FROM productattributes WHERE product_id = '2245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0002 0.00024580955505371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2245' AND a.name = n.originalname
171 0.0002 0.00022411346435547
SELECT * FROM productoffers WHERE product_id = '2245' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0003 0.00030112266540527
SELECT * FROM productoffers
                WHERE product_id = '2245' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = 2245
                ORDER BY price ASC LIMIT 1
174 0.0004 0.00037097930908203
SELECT value FROM productattributes
                WHERE product_id = '2245'
                AND name = 'ListPriceAmount'
175 0.0005 0.0004570484161377
SELECT category_id FROM products_categories WHERE product_id = '2245' AND prod_type = 'amz'
176 0.0004 0.00039410591125488
SELECT parent_id FROM categories WHERE id = '27'
177 0.0002 0.0002129077911377
SELECT * FROM categories WHERE id = '27'
178 0.0002 0.00017714500427246
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
179 0.0002 0.00019717216491699
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
180 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '27'
181 0.0003 0.00027203559875488
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 
182 0.0002 0.00019407272338867
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 
183 0.0002 0.00018191337585449
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
184 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0003 0.00026202201843262
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
186 0.0002 0.00019097328186035
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0002 0.00018501281738281
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0003 0.00025606155395508
SELECT * FROM pages WHERE id = 38
189 0.0056 0.0055701732635498
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
190 0.0005 0.00050806999206543
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:1653696981;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'
191 0.0005 0.00053501129150391
SELECT * FROM products WHERE id = 788
192 0.0005 0.00053501129150391
SELECT * FROM products WHERE id = 787
193 0.0007 0.0006561279296875
SELECT * FROM products WHERE id = 1287
194 0.0005 0.00049805641174316
SELECT * FROM products WHERE id = 780
195 0.0005 0.0005040168762207
SELECT * FROM products WHERE id = 777
196 0.0005 0.00047802925109863
SELECT * FROM products WHERE id = 776
197 0.0005 0.00051999092102051
SELECT * FROM products WHERE id = '788'
198 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
199 0.0002 0.00024890899658203
SELECT * FROM product_image_select WHERE product_id = '788'
200 0.0002 0.00018095970153809
SELECT * FROM productcustomimages WHERE product_id = '788'
201 0.0002 0.00020384788513184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
202 0.0003 0.00030183792114258
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0004 0.0004417896270752
SELECT * FROM products WHERE id = '787'
206 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
207 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '787'
208 0.0002 0.00018000602722168
SELECT * FROM productcustomimages WHERE product_id = '787'
209 0.0002 0.00018501281738281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
210 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0003 0.00033783912658691
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00022220611572266
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0005 0.0004570484161377
SELECT * FROM products WHERE id = '1287'
214 0.0004 0.00041079521179199
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
215 0.0002 0.00019407272338867
SELECT * FROM product_image_select WHERE product_id = '1287'
216 0.0002 0.00024104118347168
SELECT * FROM productcustomimages WHERE product_id = '1287'
217 0.0002 0.00023317337036133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
218 0.0003 0.00026488304138184
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0003 0.00027918815612793
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0004 0.00042510032653809
SELECT * FROM products WHERE id = '780'
222 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
223 0.0003 0.00031208992004395
SELECT * FROM product_image_select WHERE product_id = '780'
224 0.0002 0.00019407272338867
SELECT * FROM productcustomimages WHERE product_id = '780'
225 0.0002 0.00022506713867188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
226 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0002 0.00023722648620605
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = '777'
230 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
231 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '777'
232 0.0002 0.00023794174194336
SELECT * FROM productcustomimages WHERE product_id = '777'
233 0.0003 0.00027799606323242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
234 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0003 0.00027108192443848
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00031399726867676
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0005 0.00049018859863281
SELECT * FROM products WHERE id = '776'
238 0.0004 0.00043201446533203
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
239 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '776'
240 0.0002 0.0001828670501709
SELECT * FROM productcustomimages WHERE product_id = '776'
241 0.0003 0.0002741813659668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
242 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00025486946105957
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0003 0.00028681755065918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
246 0.0004 0.00039315223693848
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
247 0.0005 0.00050592422485352
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
248 0.0004 0.00039386749267578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
249 0.0005 0.00046396255493164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
250 0.0004 0.00041294097900391
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
251 0.0005 0.00047612190246582
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
252 0.0002 0.00020718574523926
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'