Heath & Heather | Organic Rooibos Tea | 2 x 20 bags (FR)

Heath & Heather | Organic Rooibos Tea | 2 x 20 bags (FR)
Heath & Heather | Organic Rooibos Tea | 2 x 20 bags (FR) (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-20 18:23:17 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

Organic Rooibos Tea Gluten Free Vegan Organic Known Barcodes: 5060123609547, 5060123609547
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.86182713508606 246 0.1775 0


No Amazon API Requests Made.

Total time 0.86182713508606 seconds

Number Time From Start Name Description
1 0.64839100837708 Initialise Initialise FSB Function
2 0.65127801895142 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65495610237122 Start of getCategoryListByGroup Function Before first category groups query
4 0.65544414520264 After initial query Before first category groups query
5 0.65544605255127 Get Category List for Group Before the call to getCategoryList function
6 0.6554491519928 Start of GetCategoryList function Start of the function
7 0.65545320510864 Before getting categories Query to get specific category list
8 0.6558690071106 After getting categories Query to get specific category list
9 0.65587115287781 Before getting category custom Before call to function getCategoryCustom
10 0.67824602127075 After getting category custom After call to function getCategoryCustom
11 0.67824912071228 Before getting category custom Before call to function getCategoryCustom
12 0.68257308006287 After getting category custom After call to function getCategoryCustom
13 0.68257522583008 Before getting category custom Before call to function getCategoryCustom
14 0.68722200393677 After getting category custom After call to function getCategoryCustom
15 0.68722414970398 Before getting category custom Before call to function getCategoryCustom
16 0.69289207458496 After getting category custom After call to function getCategoryCustom
17 0.69289517402649 Before getting category custom Before call to function getCategoryCustom
18 0.6993191242218 After getting category custom After call to function getCategoryCustom
19 0.69932103157043 Before getting category custom Before call to function getCategoryCustom
20 0.7044792175293 After getting category custom After call to function getCategoryCustom
21 0.70448112487793 End of GetCategoryList function End of the function
22 0.70448613166809 End of getCategoryListByGroup Function Before return()
23 0.71159505844116 App Controller End End of the App controller (called before the controller of every page)
24 0.71219205856323 Product Start Start of the product info controller
25 0.71538209915161 Cache file not found Starting get product details
26 0.75198721885681 Related products Start getting related products if enabled
27 0.75198912620544 Related Products Start Before the related products are found
28 0.75199007987976 Related Products Keywords Before the related product keywords are found
29 0.75199413299561 Create Keyword List Function Start of function
30 0.75207018852234 Create Keyword List Function After looping provided content - 30 keywords found
31 0.75311923027039 Create Keyword List Function After looping initial keyword list - 23 keywords remaining
32 0.7531270980835 Create Keyword List Function After reducing keyword list
33 0.75319218635559 Create Keyword List Function After selecting by scoring keywords
34 0.75319504737854 Create Keyword List Function After final loop of keywords
35 0.75319719314575 Related Products Keywords After the related product keywords are found
36 0.77760720252991 Related Products End After the related products are found
37 0.79179406166077 Product End End of the product info controller (Product Info)
38 0.79291105270386 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.79358601570129 Before Get Options Before the call to getOptions in the tpl class
40 0.8307101726532 After Get Options After the call to getOptions in the tpl class
41 0.83082008361816 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.8308482170105 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.84269309043884 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.84269714355469 Product Info: Before Template Display Before the template is displayed
45 0.86180305480957 Product Info: After Template Display After the template is displayed
46 0.86181402206421 Finalizing debug Before the debug is output to the page.
47 0.86182522773743 End of App This is the end of the app logging, final timestamp


Query Debug - 246 Database Queries. Total time 0.1775 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00072407722473145
SELECT parameter, value FROM parameters
2 0.0008 0.00084304809570312
SELECT * FROM `bad_bots`
3 0.0004 0.00039196014404297
SET time_zone = 'Europe/London'
4 0.0004 0.0003659725189209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0018081665039062
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0012 0.0012319087982178
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653304954'
7 0.0011 0.0010921955108643
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00044703483581543
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00085592269897461
SELECT id FROM pages WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr' LIMIT 1
10 0.0009 0.00089311599731445
SELECT id FROM products WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr' AND hidden = 0 LIMIT 1
11 0.0016 0.00164794921875
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00086092948913574
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00062918663024902
SELECT * FROM pages WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr'
14 0.0005 0.00047612190246582
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00039792060852051
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0114 0.011401891708374
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.0005 0.00046491622924805
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.00044989585876465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00036907196044922
SELECT id FROM categories WHERE parent_id = '26'
20 0.0071 0.0070919990539551
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.0005 0.00051999092102051
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.0005 0.00052213668823242
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.0009 0.00085282325744629
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00054693222045898
SELECT * FROM categorygroups WHERE id = '1'
25 0.0004 0.00040507316589355
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.0005 0.00051093101501465
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.0004 0.00044417381286621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00039219856262207
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00024986267089844
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.0004 0.00043392181396484
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.0005 0.00050210952758789
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.0008 0.00076603889465332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.0005040168762207
SELECT * FROM categorygroups WHERE id = '1'
34 0.0004 0.00044608116149902
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0004 0.00043392181396484
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.0004 0.00042104721069336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.0003819465637207
SELECT id FROM categories WHERE parent_id = '28'
38 0.0005 0.00052213668823242
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.0005 0.00049996376037598
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.0006 0.00058507919311523
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.0008 0.00082802772521973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00042390823364258
SELECT * FROM categorygroups WHERE id = '1'
43 0.0013 0.0012500286102295
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.0005 0.00048303604125977
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.00033402442932129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.0003199577331543
SELECT id FROM categories WHERE parent_id = '29'
47 0.0010 0.0010077953338623
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.0005 0.00046014785766602
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.0004 0.00041508674621582
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.0008 0.00078892707824707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00048708915710449
SELECT * FROM categorygroups WHERE id = '1'
52 0.0010 0.0010340213775635
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.0005 0.00053310394287109
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.0006 0.00061511993408203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0006 0.00056791305541992
SELECT id FROM categories WHERE parent_id = '30'
56 0.0011 0.0010950565338135
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.0005 0.00054502487182617
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.0007 0.00065398216247559
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.0007 0.00069403648376465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00054097175598145
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.00086402893066406
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.00027704238891602
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.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.0008690357208252
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.0004 0.00043606758117676
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.0005 0.00051999092102051
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.0009 0.00092792510986328
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0006 0.0006110668182373
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00044012069702148
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0005 0.00045680999755859
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0006 0.00056600570678711
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.0005 0.00051593780517578
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0008 0.00084590911865234
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.0006101131439209
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00043892860412598
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.0006 0.0005650520324707
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0005 0.00054407119750977
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0009 0.00085902214050293
SELECT * FROM products WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr'
80 0.0016 0.0016279220581055
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2518
81 0.0007 0.00066208839416504
SELECT * FROM manufacturers WHERE id = '294'
82 0.0009 0.00090384483337402
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
83 0.0005 0.00051307678222656
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '294' LIMIT 1
84 0.0014 0.0013749599456787
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '294' ORDER BY RAND() LIMIT 1
85 0.0022 0.0021638870239258
SELECT * FROM productimages WHERE product_id = '2519' ORDER BY sortorder ASC
86 0.0006 0.00061702728271484
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
87 0.0010 0.00099396705627441
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '294'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00039887428283691
SELECT * FROM manufacturerimages WHERE manufacturer_id = '294'
89 0.0007 0.00066685676574707
SELECT category_id FROM products_categories WHERE product_id = '2518'
90 0.0006 0.00056910514831543
SELECT * FROM categories WHERE id = '27'
91 0.0048 0.0047509670257568
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.0005 0.00053191184997559
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0005 0.00052618980407715
SELECT id FROM categories WHERE parent_id = '27'
94 0.0051 0.0051419734954834
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
95 0.0004 0.00044083595275879
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.0004 0.00043797492980957
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.00034904479980469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0011 0.0011308193206787
SELECT * FROM productimages WHERE product_id = '2518' ORDER BY sortorder ASC
99 0.0006 0.00063395500183105
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2518' AND p.id = pi.product_id ORDER BY pi.sortorder
100 0.0006 0.00064492225646973
SELECT * FROM product_image_select WHERE product_id = '2518'
101 0.0006 0.00058293342590332
SELECT * FROM productcustomimages WHERE product_id = '2518'
102 0.0006 0.0006098747253418
SELECT * FROM productfeeds WHERE product_id = '2518' ORDER BY item_date DESC
103 0.0009 0.00092411041259766
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0008 0.00075793266296387
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2518' AND t.hidden = 0 AND display_product = 1
105 0.0006 0.00059795379638672
SELECT * FROM productamazoncontent WHERE product_id = '2518'
106 0.0009 0.00086402893066406
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 = '2518'
                GROUP BY o.product_id
107 0.0007 0.00072622299194336
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     = '2518'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
108 0.0006 0.00064206123352051
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
109 0.0011 0.0010919570922852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
110 0.0006 0.00056004524230957
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0006 0.00062394142150879
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0006 0.00060796737670898
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
113 0.0007 0.0007171630859375
SELECT value FROM productattributes
                WHERE product_id = '2518'
                AND name = 'ListPriceAmount'
114 0.0005 0.00046491622924805
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 = '2518'
                GROUP BY o.product_id
115 0.0005 0.00048208236694336
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     = '2518'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
116 0.0004 0.00040292739868164
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
117 0.0006 0.00060486793518066
SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0007 0.00072693824768066
SELECT * FROM products WHERE parent_id = '2518'
119 0.0004 0.00039219856262207
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.0082 0.0082399845123291
SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
121 0.0009 0.00088596343994141
SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
122 0.0006 0.00064301490783691
SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
123 0.0004 0.00037193298339844
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
124 0.0004 0.00041007995605469
SELECT * FROM product_image_select WHERE product_id = '862'
125 0.0006 0.00058388710021973
SELECT * FROM productcustomimages WHERE product_id = '862'
126 0.0005 0.00051307678222656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
127 0.0006 0.00056791305541992
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0006 0.00059604644775391
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0003 0.0003359317779541
SELECT * FROM productimages WHERE product_id = '1513' ORDER BY sortorder ASC
131 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '1513'
132 0.0005 0.00050187110900879
SELECT * FROM productcustomimages WHERE product_id = '1513'
133 0.0006 0.00055789947509766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
134 0.0006 0.000640869140625
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0009 0.00090217590332031
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0015 0.0014798641204834
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
138 0.0005 0.00054097175598145
SELECT * FROM product_image_select WHERE product_id = '938'
139 0.0005 0.00053191184997559
SELECT * FROM productcustomimages WHERE product_id = '938'
140 0.0019 0.0018630027770996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
141 0.0007 0.00065994262695312
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0008 0.00077986717224121
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0008 0.00075316429138184
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0007 0.00066804885864258
SELECT id,asin FROM products WHERE parent_id = 2518
145 0.0004 0.00043296813964844
SELECT category_id FROM products_categories WHERE product_id = '2518'
146 0.0004 0.00043511390686035
SELECT * FROM categories WHERE id = '27'
147 0.0004 0.00037193298339844
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
148 0.0005 0.00050687789916992
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
149 0.0005 0.00053286552429199
SELECT id FROM categories WHERE parent_id = '27'
150 0.0004 0.00041794776916504
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 
151 0.0005 0.00047993659973145
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 
152 0.0005 0.00051307678222656
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
153 0.0003 0.00034689903259277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
154 0.0003 0.00026893615722656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
155 0.0005 0.00054597854614258
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00035595893859863
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
158 0.0003 0.00034904479980469
SELECT value FROM productattributes
                WHERE product_id = '2518'
                AND name = 'ListPriceAmount'
159 0.0005 0.00050091743469238
SELECT * FROM products WHERE id = '2518'
160 0.0004 0.00040102005004883
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 = '2518'
                GROUP BY o.product_id
161 0.0003 0.00033903121948242
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     = '2518'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
162 0.0002 0.00024700164794922
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
163 0.0002 0.00024795532226562
SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0003 0.00027585029602051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
165 0.0003 0.00026297569274902
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0003 0.00026988983154297
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
168 0.0002 0.00023889541625977
SELECT value FROM productattributes
                WHERE product_id = '2518'
                AND name = 'ListPriceAmount'
169 0.0005 0.00051784515380859
SELECT category_id FROM products_categories WHERE product_id = '2518' AND prod_type = 'amz'
170 0.0002 0.00024890899658203
SELECT parent_id FROM categories WHERE id = '27'
171 0.0005 0.00046586990356445
SELECT * FROM categories WHERE id = '27'
172 0.0003 0.00027990341186523
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
173 0.0004 0.00042009353637695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
174 0.0005 0.00049710273742676
SELECT id FROM categories WHERE parent_id = '27'
175 0.0004 0.00038599967956543
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 
176 0.0005 0.0004580020904541
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 
177 0.0004 0.00036191940307617
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
178 0.0003 0.00033211708068848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
179 0.0005 0.00053310394287109
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
180 0.0003 0.0002739429473877
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
181 0.0003 0.00032305717468262
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
182 0.0005 0.00046610832214355
SELECT * FROM pages WHERE id = 38
183 0.0046 0.0046069622039795
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
184 0.0007 0.00066304206848145
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:1653304955;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'
185 0.0007 0.00074100494384766
SELECT * FROM products WHERE id = 788
186 0.0007 0.00065994262695312
SELECT * FROM products WHERE id = 787
187 0.0007 0.00070500373840332
SELECT * FROM products WHERE id = 1287
188 0.0007 0.00065088272094727
SELECT * FROM products WHERE id = 780
189 0.0006 0.00058889389038086
SELECT * FROM products WHERE id = 777
190 0.0007 0.00067710876464844
SELECT * FROM products WHERE id = 776
191 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = '788'
192 0.0004 0.00043106079101562
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
193 0.0005 0.00046610832214355
SELECT * FROM product_image_select WHERE product_id = '788'
194 0.0004 0.00037503242492676
SELECT * FROM productcustomimages WHERE product_id = '788'
195 0.0004 0.00043988227844238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
196 0.0003 0.00028705596923828
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0005 0.00048613548278809
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0004 0.00040483474731445
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0007 0.00067615509033203
SELECT * FROM products WHERE id = '787'
200 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
201 0.0005 0.00046706199645996
SELECT * FROM product_image_select WHERE product_id = '787'
202 0.0005 0.00047612190246582
SELECT * FROM productcustomimages WHERE product_id = '787'
203 0.0005 0.0004580020904541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
204 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0005 0.00049400329589844
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0007 0.00072598457336426
SELECT * FROM products WHERE id = '1287'
208 0.0005 0.00049614906311035
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
209 0.0005 0.0004570484161377
SELECT * FROM product_image_select WHERE product_id = '1287'
210 0.0005 0.00049781799316406
SELECT * FROM productcustomimages WHERE product_id = '1287'
211 0.0005 0.00051999092102051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
212 0.0004 0.00044512748718262
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0005 0.00047993659973145
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0008 0.00076699256896973
SELECT * FROM products WHERE id = '780'
216 0.0004 0.00042510032653809
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
217 0.0004 0.00042200088500977
SELECT * FROM product_image_select WHERE product_id = '780'
218 0.0004 0.00041794776916504
SELECT * FROM productcustomimages WHERE product_id = '780'
219 0.0003 0.00030183792114258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
220 0.0003 0.00025796890258789
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0003 0.00026893615722656
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00024294853210449
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0006 0.00062799453735352
SELECT * FROM products WHERE id = '777'
224 0.0004 0.00043416023254395
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
225 0.0006 0.00055694580078125
SELECT * FROM product_image_select WHERE product_id = '777'
226 0.0005 0.00051283836364746
SELECT * FROM productcustomimages WHERE product_id = '777'
227 0.0004 0.0004270076751709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
228 0.0004 0.00042390823364258
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0005 0.00045180320739746
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0004 0.00036478042602539
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = '776'
232 0.0005 0.00049495697021484
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
233 0.0004 0.00043988227844238
SELECT * FROM product_image_select WHERE product_id = '776'
234 0.0004 0.00044989585876465
SELECT * FROM productcustomimages WHERE product_id = '776'
235 0.0004 0.00041794776916504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
236 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0004 0.00036001205444336
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0005 0.00045013427734375
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
240 0.0005 0.00046300888061523
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
241 0.0007 0.00066900253295898
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
242 0.0004 0.00039410591125488
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
243 0.0004 0.00036883354187012
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
244 0.0005 0.00048518180847168
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
245 0.0004 0.00043487548828125
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
246 0.0004 0.00039291381835938
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'