0

Løv Organic - Rooibos Rose - Recharge 100 g

Price: Click Button for Price
Product prices and availability are accurate as of 2021-07-19 23:13:52 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4558529853821 267 0.9363 0


No Amazon API Requests Made.


App Debug - Total Time 1.4558529853821 seconds

Number Time From Start Name Description
1 0.46112084388733 Initialise Initialise FSB Function
2 0.47041487693787 App Controller Start Start of the App controller (called before the controller of every page)
3 0.5057270526886 Start of getCategoryListByGroup Function Before first category groups query
4 0.50732803344727 After initial query Before first category groups query
5 0.5073299407959 Get Category List for Group Before the call to getCategoryList function
6 0.50733304023743 Start of GetCategoryList function Start of the function
7 0.50733685493469 Before getting categories Query to get specific category list
8 0.50942492485046 After getting categories Query to get specific category list
9 0.50942707061768 Before getting category custom Before call to function getCategoryCustom
10 0.53646206855774 After getting category custom After call to function getCategoryCustom
11 0.5364670753479 Before getting category custom Before call to function getCategoryCustom
12 0.55866503715515 After getting category custom After call to function getCategoryCustom
13 0.55866885185242 Before getting category custom Before call to function getCategoryCustom
14 0.56608986854553 After getting category custom After call to function getCategoryCustom
15 0.56609201431274 Before getting category custom Before call to function getCategoryCustom
16 0.57200002670288 After getting category custom After call to function getCategoryCustom
17 0.57200193405151 Before getting category custom Before call to function getCategoryCustom
18 0.57747507095337 After getting category custom After call to function getCategoryCustom
19 0.57747793197632 Before getting category custom Before call to function getCategoryCustom
20 0.5830180644989 After getting category custom After call to function getCategoryCustom
21 0.58302187919617 End of GetCategoryList function End of the function
22 0.58302903175354 Get Category List for Group Before the call to getCategoryList function
23 0.58303093910217 Start of GetCategoryList function Start of the function
24 0.5830340385437 Before getting categories Query to get specific category list
25 0.58358883857727 End of getCategoryListByGroup Function Before return()
26 1.1640019416809 App Controller End End of the App controller (called before the controller of every page)
27 1.1647419929504 Product Start Start of the product info controller
28 1.1686990261078 Cache file not found Starting get product details
29 1.2160289287567 Related products Start getting related products if enabled
30 1.2160310745239 Related Products Start Before the related products are found
31 1.2160329818726 Related Products Keywords Before the related product keywords are found
32 1.2160408496857 Create Keyword List Function Start of function
33 1.2161719799042 Create Keyword List Function After looping provided content - 18 keywords found
34 1.2172639369965 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
35 1.2172739505768 Create Keyword List Function After reducing keyword list
36 1.2173268795013 Create Keyword List Function After selecting by scoring keywords
37 1.2173318862915 Create Keyword List Function After final loop of keywords
38 1.217334985733 Related Products Keywords After the related product keywords are found
39 1.2605049610138 Related Products End After the related products are found
40 1.3050239086151 Product End End of the product info controller (Product Info)
41 1.3079450130463 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.31001496315 Before Get Options Before the call to getOptions in the tpl class
43 1.3917088508606 After Get Options After the call to getOptions in the tpl class
44 1.3918788433075 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3919160366058 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4052679538727 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4052760601044 Product Info: Before Template Display Before the template is displayed
48 1.4558148384094 Product Info: After Template Display After the template is displayed
49 1.4558310508728 Finalizing debug Before the debug is output to the page.
50 1.4558520317078 End of App This is the end of the app logging, final timestamp


Query Debug - 267 Database Queries. Total time 0.9363 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0021510124206543
SELECT parameter, value FROM parameters
2 0.0039 0.0039019584655762
SELECT * FROM `bad_bots`
3 0.0004 0.0003809928894043
SET time_zone = 'Europe/London'
4 0.0021 0.0020918846130371
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0017468929290771
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6 0.0022 0.002202033996582
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739263167'
7 0.0036 0.0035581588745117
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00087785720825195
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0035 0.0034761428833008
SELECT id FROM pages WHERE pagename = 'lv-organic-rooibos-rose-recharge-100-g' LIMIT 1
10 0.0042 0.0042181015014648
SELECT id FROM products WHERE pagename = 'lv-organic-rooibos-rose-recharge-100-g' AND hidden = 0 LIMIT 1
11 0.0043 0.0042798519134521
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0298 0.029770135879517
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00062990188598633
SELECT * FROM pages WHERE pagename = 'lv-organic-rooibos-rose-recharge-100-g'
14 0.0016 0.0015881061553955
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0021 0.0020689964294434
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0067 0.0066750049591064
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.0021 0.002086877822876
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.0015 0.0014588832855225
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00053000450134277
SELECT id FROM categories WHERE parent_id = '26'
20 0.0058 0.0057718753814697
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.0021 0.0020570755004883
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.0046 0.0045990943908691
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.0032 0.003183126449585
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00052690505981445
SELECT * FROM categorygroups WHERE id = '1'
25 0.0086 0.0085952281951904
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.0025 0.0024938583374023
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.0021 0.0020909309387207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00054597854614258
SELECT id FROM categories WHERE parent_id = '27'
29 0.0047 0.0047321319580078
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.0006 0.00064706802368164
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.0019 0.0018818378448486
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.0006 0.00058817863464355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00049495697021484
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0018751621246338
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.0005 0.00053906440734863
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.00042891502380371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00045299530029297
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017070770263672
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.0006 0.00060510635375977
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.00055289268493652
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.0005 0.00050187110900879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0007 0.00065898895263672
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00075292587280273
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.0006 0.00057601928710938
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.0005 0.00048398971557617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.00057697296142578
SELECT id FROM categories WHERE parent_id = '29'
47 0.0010 0.0010049343109131
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.0006 0.00062894821166992
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.0007 0.00067400932312012
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.0006 0.00062203407287598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.0005040168762207
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00062894821166992
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.00046396255493164
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.0004 0.00043392181396484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '30'
56 0.0012 0.0012240409851074
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.0006 0.00055980682373047
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.0006 0.00059413909912109
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.0006 0.00055813789367676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00047087669372559
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00072216987609863
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.0006 0.00060582160949707
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.0005 0.00052094459533691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00045919418334961
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00073981285095215
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.0008 0.00078892707824707
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.0006 0.00056600570678711
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.0005 0.00052905082702637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00048017501831055
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00053906440734863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0027 0.0026822090148926
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0015 0.0014588832855225
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00058889389038086
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
74 0.0012 0.0012290477752686
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011498928070068
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010881423950195
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5662 0.56622004508972
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.85') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.85') <= INET_ATON(ip_end)
78 0.0021 0.0021400451660156
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0013189315795898
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0023 0.002345085144043
SELECT * FROM products WHERE pagename = 'lv-organic-rooibos-rose-recharge-100-g'
81 0.0009 0.0008540153503418
UPDATE products SET viewcount = viewcount + 1 WHERE id = 969
82 0.0006 0.00063419342041016
SELECT * FROM manufacturers WHERE id = '249'
83 0.0006 0.00063014030456543
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '249'
84 0.0015 0.0015261173248291
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '249' LIMIT 1
85 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
86 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '949' ORDER BY sortorder ASC
87 0.0005 0.00048494338989258
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '249'
88 0.0005 0.00048494338989258
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 
89 0.0005 0.00046181678771973
SELECT * FROM manufacturerimages WHERE manufacturer_id = '249'
90 0.0004 0.00042104721069336
SELECT category_id FROM products_categories WHERE product_id = '969'
91 0.0005 0.00047087669372559
SELECT * FROM categories WHERE id = '27'
92 0.0036 0.0035769939422607
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
93 0.0006 0.0005950927734375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00035715103149414
SELECT id FROM categories WHERE parent_id = '27'
95 0.0036 0.003587007522583
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 
96 0.0008 0.00076103210449219
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 
97 0.0006 0.00062322616577148
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
98 0.0005 0.00054788589477539
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00056290626525879
SELECT * FROM productimages WHERE product_id = '969' ORDER BY sortorder ASC
100 0.0006 0.0005650520324707
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '969' AND p.id = pi.product_id ORDER BY pi.sortorder
101 0.0017 0.0017368793487549
SELECT * FROM product_image_select WHERE product_id = '969'
102 0.0013 0.001288890838623
SELECT * FROM productcustomimages WHERE product_id = '969'
103 0.0012 0.0011780261993408
SELECT * FROM productfeeds WHERE product_id = '969' ORDER BY item_date DESC
104 0.0024 0.0023701190948486
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '969' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0023 0.002295970916748
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '969' AND t.hidden = 0 AND display_product = 1
106 0.0016 0.0016310214996338
SELECT * FROM productamazoncontent WHERE product_id = '969'
107 0.0027 0.0027289390563965
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 = '969'
                GROUP BY o.product_id
108 0.0034 0.0033750534057617
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     = '969'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0014 0.0014450550079346
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 969
110 0.0017 0.0017280578613281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '969' AND a.name = n.originalname
111 0.0017 0.0016629695892334
SELECT * FROM productoffers WHERE product_id = '969' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0011 0.0011088848114014
SELECT * FROM productoffers
                WHERE product_id = '969' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0017 0.0016829967498779
SELECT * FROM productoffers
                WHERE product_id = 969
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00044989585876465
SELECT value FROM productattributes
                WHERE product_id = '969'
                AND name = 'ListPriceAmount'
115 0.0004 0.00043702125549316
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 = '969'
                GROUP BY o.product_id
116 0.0008 0.0007789134979248
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     = '969'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
117 0.0004 0.00043702125549316
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 969
118 0.0007 0.00068283081054688
SELECT value FROM productattributes WHERE product_id = '969' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0005 0.0004878044128418
SELECT * FROM products WHERE parent_id = '969'
120 0.0006 0.0006110668182373
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
121 0.0130 0.012959957122803
SELECT *, MATCH (description, title) AGAINST ('rooibos rose recharge' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos rose recharge' IN BOOLEAN MODE) AND 969 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
122 0.0009 0.00091195106506348
SELECT *, MATCH (description, title) AGAINST ('rooibos rose recharge' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos rose recharge' IN BOOLEAN MODE) AND 969 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
123 0.0009 0.00087404251098633
SELECT *, MATCH (description, title) AGAINST ('rooibos rose recharge' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos rose recharge' IN BOOLEAN MODE) AND 969 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
124 0.0005 0.00052499771118164
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
125 0.0007 0.00067710876464844
SELECT * FROM product_image_select WHERE product_id = '865'
126 0.0004 0.00042414665222168
SELECT * FROM productcustomimages WHERE product_id = '865'
127 0.0009 0.0008540153503418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
128 0.0005 0.00051093101501465
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0006 0.00055289268493652
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0005 0.00047898292541504
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0007 0.00068402290344238
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
132 0.0006 0.00057291984558105
SELECT * FROM product_image_select WHERE product_id = '858'
133 0.0004 0.0003960132598877
SELECT * FROM productcustomimages WHERE product_id = '858'
134 0.0025 0.0024850368499756
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
135 0.0005 0.00050902366638184
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00052809715270996
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
139 0.0006 0.00055384635925293
SELECT * FROM product_image_select WHERE product_id = '890'
140 0.0004 0.0003809928894043
SELECT * FROM productcustomimages WHERE product_id = '890'
141 0.0010 0.0010049343109131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
142 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00041007995605469
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00057816505432129
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
146 0.0006 0.0005638599395752
SELECT * FROM product_image_select WHERE product_id = '869'
147 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '869'
148 0.0009 0.0009160041809082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
149 0.0007 0.00066113471984863
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0005 0.00049805641174316
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0005 0.00045990943908691
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.00046086311340332
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
153 0.0007 0.00069999694824219
SELECT * FROM product_image_select WHERE product_id = '878'
154 0.0005 0.00051403045654297
SELECT * FROM productcustomimages WHERE product_id = '878'
155 0.0010 0.00099802017211914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
156 0.0005 0.00052595138549805
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.00049304962158203
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0007 0.00068092346191406
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0007 0.00073695182800293
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
160 0.0007 0.00065898895263672
SELECT * FROM product_image_select WHERE product_id = '862'
161 0.0007 0.00069808959960938
SELECT * FROM productcustomimages WHERE product_id = '862'
162 0.0013 0.0012738704681396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
163 0.0006 0.00056886672973633
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0005 0.00048685073852539
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00050783157348633
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0007 0.00067996978759766
SELECT id,asin FROM products WHERE parent_id = 969
167 0.0022 0.0021741390228271
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '969' ORDER BY timestamp DESC
168 0.0006 0.00058698654174805
SELECT category_id FROM products_categories WHERE product_id = '969'
169 0.0007 0.0006561279296875
SELECT * FROM categories WHERE id = '27'
170 0.0056 0.0056338310241699
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
171 0.0007 0.00067496299743652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0005 0.0004580020904541
SELECT id FROM categories WHERE parent_id = '27'
173 0.0052 0.0052480697631836
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 
174 0.0007 0.00065898895263672
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 
175 0.0007 0.00066781044006348
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
176 0.0006 0.0006251335144043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0010 0.0010321140289307
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '969' AND a.name = n.originalname
178 0.0006 0.00064611434936523
SELECT * FROM productoffers WHERE product_id = '969' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00046205520629883
SELECT * FROM productoffers
                WHERE product_id = '969' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00040388107299805
SELECT * FROM productoffers
                WHERE product_id = 969
                ORDER BY price ASC LIMIT 1
181 0.0005 0.00050687789916992
SELECT value FROM productattributes
                WHERE product_id = '969'
                AND name = 'ListPriceAmount'
182 0.0009 0.00085806846618652
SELECT * FROM products WHERE id = '969'
183 0.0005 0.0005190372467041
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 = '969'
                GROUP BY o.product_id
184 0.0007 0.0007178783416748
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     = '969'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
185 0.0005 0.00046801567077637
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 969
186 0.0008 0.00076794624328613
SELECT value FROM productattributes WHERE product_id = '969' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0011 0.0010578632354736
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '969' AND a.name = n.originalname
188 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '969' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '969' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = 969
                ORDER BY price ASC LIMIT 1
191 0.0006 0.0005800724029541
SELECT value FROM productattributes
                WHERE product_id = '969'
                AND name = 'ListPriceAmount'
192 0.0006 0.00059604644775391
SELECT category_id FROM products_categories WHERE product_id = '969' AND prod_type = 'amz'
193 0.0005 0.00049805641174316
SELECT parent_id FROM categories WHERE id = '27'
194 0.0005 0.00046682357788086
SELECT * FROM categories WHERE id = '27'
195 0.0055 0.005497932434082
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
196 0.0006 0.00059199333190918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
197 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '27'
198 0.0063 0.0062618255615234
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 
199 0.0008 0.00077414512634277
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 
200 0.0007 0.00071310997009277
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
201 0.0006 0.00064396858215332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
202 0.0022 0.0022399425506592
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
203 0.0016 0.0015518665313721
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
204 0.0004 0.00041890144348145
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
205 0.0153 0.015252113342285
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
206 0.0022 0.0022130012512207
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
207 0.0007 0.00066184997558594
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
208 0.0006 0.00063204765319824
SELECT * FROM products WHERE id = 1626
209 0.0009 0.00088906288146973
SELECT * FROM products WHERE id = 4041
210 0.0008 0.00081706047058105
SELECT * FROM products WHERE id = 4312
211 0.0008 0.00076699256896973
SELECT * FROM products WHERE id = 777
212 0.0008 0.00075602531433105
SELECT * FROM products WHERE id = 3881
213 0.0007 0.00073885917663574
SELECT * FROM products WHERE id = 4213
214 0.0008 0.00075006484985352
SELECT * FROM products WHERE id = '1626'
215 0.0009 0.000946044921875
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
216 0.0017 0.0017368793487549
SELECT * FROM product_image_select WHERE product_id = '1626'
217 0.0009 0.00085806846618652
SELECT * FROM productcustomimages WHERE product_id = '1626'
218 0.0026 0.0025920867919922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
219 0.0011 0.0011441707611084
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0009 0.00088715553283691
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0012 0.0012040138244629
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0013 0.0013008117675781
SELECT * FROM products WHERE id = '4041'
223 0.0007 0.00069499015808105
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
224 0.0010 0.001014232635498
SELECT * FROM product_image_select WHERE product_id = '4041'
225 0.0006 0.00058293342590332
SELECT * FROM productcustomimages WHERE product_id = '4041'
226 0.0029 0.0029468536376953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
227 0.0009 0.00086808204650879
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0007 0.00066113471984863
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0008 0.00079607963562012
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0010 0.00096893310546875
SELECT * FROM products WHERE id = '4312'
231 0.0008 0.00078296661376953
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
232 0.0010 0.0010430812835693
SELECT * FROM product_image_select WHERE product_id = '4312'
233 0.0006 0.00056195259094238
SELECT * FROM productcustomimages WHERE product_id = '4312'
234 0.0021 0.002140998840332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
235 0.0008 0.00078392028808594
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0006 0.00064396858215332
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0008 0.00076508522033691
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0009 0.00087690353393555
SELECT * FROM products WHERE id = '777'
239 0.0007 0.00074386596679688
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
240 0.0015 0.0014500617980957
SELECT * FROM product_image_select WHERE product_id = '777'
241 0.0007 0.00065898895263672
SELECT * FROM productcustomimages WHERE product_id = '777'
242 0.0017 0.0017409324645996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
243 0.0006 0.0006401538848877
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0005 0.00054597854614258
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0005 0.00048995018005371
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0006 0.00064611434936523
SELECT * FROM products WHERE id = '3881'
247 0.0008 0.00076198577880859
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
248 0.0007 0.00066494941711426
SELECT * FROM product_image_select WHERE product_id = '3881'
249 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '3881'
250 0.0016 0.0016069412231445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
251 0.0008 0.00077009201049805
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0007 0.0006871223449707
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0006 0.00058889389038086
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0008 0.00075197219848633
SELECT * FROM products WHERE id = '4213'
255 0.0008 0.00076007843017578
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
256 0.0008 0.00079107284545898
SELECT * FROM product_image_select WHERE product_id = '4213'
257 0.0005 0.00051116943359375
SELECT * FROM productcustomimages WHERE product_id = '4213'
258 0.0016 0.0016260147094727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
259 0.0006 0.00062394142150879
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0005 0.00053691864013672
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0006 0.00057816505432129
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0024 0.0023880004882812
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
263 0.0011 0.0010511875152588
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
264 0.0032 0.0031759738922119
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
265 0.0026 0.0025870800018311
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0008 0.00081801414489746
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
267 0.0037 0.0037381649017334
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'