0

Dragonfly Rooibos Vanilla Tea 40 per pack

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-09 01:24:17 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.

Product Features

Conserver dans un endroit frais et sec Pays d'origine: Afrique du Sud. Rooibos

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.7783939838409 262 0.9550 0


No Amazon API Requests Made.


App Debug - Total Time 1.7783939838409 seconds

Number Time From Start Name Description
1 0.7366349697113 Initialise Initialise FSB Function
2 0.74162197113037 App Controller Start Start of the App controller (called before the controller of every page)
3 0.76875400543213 Start of getCategoryListByGroup Function Before first category groups query
4 0.77059483528137 After initial query Before first category groups query
5 0.7705979347229 Get Category List for Group Before the call to getCategoryList function
6 0.77060198783875 Start of GetCategoryList function Start of the function
7 0.77060699462891 Before getting categories Query to get specific category list
8 0.7725830078125 After getting categories Query to get specific category list
9 0.77258586883545 Before getting category custom Before call to function getCategoryCustom
10 0.79479289054871 After getting category custom After call to function getCategoryCustom
11 0.79479694366455 Before getting category custom Before call to function getCategoryCustom
12 0.80774784088135 After getting category custom After call to function getCategoryCustom
13 0.80775284767151 Before getting category custom Before call to function getCategoryCustom
14 0.81436085700989 After getting category custom After call to function getCategoryCustom
15 0.81436586380005 Before getting category custom Before call to function getCategoryCustom
16 0.8191339969635 After getting category custom After call to function getCategoryCustom
17 0.81913781166077 Before getting category custom Before call to function getCategoryCustom
18 0.82387900352478 After getting category custom After call to function getCategoryCustom
19 0.82388281822205 Before getting category custom Before call to function getCategoryCustom
20 0.8286988735199 After getting category custom After call to function getCategoryCustom
21 0.82870292663574 End of GetCategoryList function End of the function
22 0.82871389389038 Get Category List for Group Before the call to getCategoryList function
23 0.82871580123901 Start of GetCategoryList function Start of the function
24 0.82871985435486 Before getting categories Query to get specific category list
25 0.82929587364197 End of getCategoryListByGroup Function Before return()
26 1.4650309085846 App Controller End End of the App controller (called before the controller of every page)
27 1.4658968448639 Product Start Start of the product info controller
28 1.4841117858887 Cache file not found Starting get product details
29 1.5384910106659 Related products Start getting related products if enabled
30 1.5384938716888 Related Products Start Before the related products are found
31 1.5384948253632 Related Products Keywords Before the related product keywords are found
32 1.5385029315948 Create Keyword List Function Start of function
33 1.5386488437653 Create Keyword List Function After looping provided content - 18 keywords found
34 1.5397918224335 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
35 1.5398018360138 Create Keyword List Function After reducing keyword list
36 1.5398819446564 Create Keyword List Function After selecting by scoring keywords
37 1.5398879051208 Create Keyword List Function After final loop of keywords
38 1.5398898124695 Related Products Keywords After the related product keywords are found
39 1.5927948951721 Related Products End After the related products are found
40 1.6306707859039 Product End End of the product info controller (Product Info)
41 1.633143901825 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.6347699165344 Before Get Options Before the call to getOptions in the tpl class
43 1.7007868289948 After Get Options After the call to getOptions in the tpl class
44 1.700954914093 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.7009899616241 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.7126078605652 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.7126128673553 Product Info: Before Template Display Before the template is displayed
48 1.7783498764038 Product Info: After Template Display After the template is displayed
49 1.7783718109131 Finalizing debug Before the debug is output to the page.
50 1.7783918380737 End of App This is the end of the app logging, final timestamp


Query Debug - 262 Database Queries. Total time 0.9550 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.0026302337646484
SELECT parameter, value FROM parameters
2 0.0065 0.0064628124237061
SELECT * FROM `bad_bots`
3 0.0005 0.000518798828125
SET time_zone = 'Europe/London'
4 0.0026 0.0025742053985596
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0030 0.0030410289764404
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.224.44.207\";}'
6 0.0029 0.0028719902038574
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734855071'
7 0.0019 0.0018620491027832
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.00098705291748047
UPDATE autorun SET lastrun = '2024-12-22 08:11:12' WHERE id = '13'
9 0.0006 0.00059604644775391
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0016 0.0015869140625
SELECT id FROM pages WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack' LIMIT 1
11 0.0018 0.0018491744995117
SELECT id FROM products WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack' AND hidden = 0 LIMIT 1
12 0.0023 0.0022530555725098
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0234 0.02342700958252
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00063610076904297
SELECT * FROM pages WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack'
15 0.0018 0.0018250942230225
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0020 0.0019500255584717
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0064 0.0064239501953125
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
18 0.0025 0.0024969577789307
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0016 0.0015890598297119
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00051116943359375
SELECT id FROM categories WHERE parent_id = '26'
21 0.0059 0.0058650970458984
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 
22 0.0017 0.0016829967498779
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 
23 0.0015 0.0014510154724121
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
24 0.0015 0.0014638900756836
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.0005190372467041
SELECT * FROM categorygroups WHERE id = '1'
26 0.0051 0.0051159858703613
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
27 0.0006 0.0005791187286377
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00054287910461426
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00052809715270996
SELECT id FROM categories WHERE parent_id = '27'
30 0.0040 0.0039639472961426
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 
31 0.0006 0.00056099891662598
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 
32 0.0005 0.00054788589477539
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
33 0.0005 0.00048494338989258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00045299530029297
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0014200210571289
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
36 0.0006 0.00058102607727051
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.0004270076751709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00045990943908691
SELECT id FROM categories WHERE parent_id = '28'
39 0.0015 0.0015120506286621
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 
40 0.0005 0.00049591064453125
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 
41 0.0005 0.00052809715270996
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
42 0.0005 0.00045609474182129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0006 0.00057792663574219
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00068497657775879
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
45 0.0005 0.00048494338989258
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00042390823364258
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00066208839416504
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 
49 0.0005 0.00047802925109863
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 
50 0.0005 0.00054287910461426
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
51 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00046300888061523
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00064706802368164
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
54 0.0005 0.00046300888061523
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00042295455932617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00044107437133789
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.0006859302520752
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 
58 0.0005 0.00048398971557617
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 
59 0.0005 0.00052499771118164
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
60 0.0005 0.00049304962158203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00043201446533203
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00060105323791504
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
63 0.0005 0.00050115585327148
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00040507316589355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00045895576477051
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.000701904296875
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 
67 0.0005 0.00053596496582031
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 
68 0.0005 0.00051093101501465
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
69 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00048112869262695
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.0005500316619873
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0028 0.0027880668640137
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0015 0.0014629364013672
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00057005882263184
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
75 0.0012 0.0012331008911133
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0012 0.0011568069458008
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0012 0.0011768341064453
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.6163 0.61632585525513
SELECT * FROM ipgeocountries WHERE INET_ATON('18.224.44.207') >= INET_ATON(ip_start) AND INET_ATON('18.224.44.207') <= INET_ATON(ip_end)
79 0.0050 0.0049581527709961
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0038 0.0037899017333984
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0016 0.0015609264373779
SELECT * FROM products WHERE pagename = 'dragonfly-rooibos-vanilla-tea-40-per-pack'
82 0.0007 0.00074195861816406
UPDATE products SET viewcount = viewcount + 1 WHERE id = 901
83 0.0011 0.0011169910430908
SELECT * FROM manufacturers WHERE id = '243'
84 0.0011 0.0010881423950195
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
85 0.0032 0.0032010078430176
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
86 0.0040 0.0040020942687988
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '243' ORDER BY RAND() LIMIT 1
87 0.0007 0.00073599815368652
SELECT * FROM productimages WHERE product_id = '900' ORDER BY sortorder ASC
88 0.0010 0.0010440349578857
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
89 0.0011 0.0011169910430908
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '243'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0008 0.00080704689025879
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
91 0.0007 0.00068211555480957
SELECT category_id FROM products_categories WHERE product_id = '901'
92 0.0007 0.00071501731872559
SELECT * FROM categories WHERE id = '27'
93 0.0080 0.0079901218414307
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
94 0.0007 0.00070095062255859
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '27'
96 0.0057 0.0056719779968262
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 
97 0.0009 0.00088906288146973
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 
98 0.0007 0.00070786476135254
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
99 0.0006 0.00059294700622559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0007 0.00068807601928711
SELECT * FROM productimages WHERE product_id = '901' ORDER BY sortorder ASC
101 0.0021 0.00205397605896
SELECT * FROM product_image_select WHERE product_id = '901'
102 0.0013 0.001338005065918
SELECT * FROM productcustomimages WHERE product_id = '901'
103 0.0013 0.0013041496276855
SELECT * FROM productfeeds WHERE product_id = '901' ORDER BY item_date DESC
104 0.0027 0.0027470588684082
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '901' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0029 0.0029139518737793
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '901' AND t.hidden = 0 AND display_product = 1
106 0.0005 0.00045514106750488
SELECT * FROM tags WHERE id = '15'
107 0.0011 0.0011041164398193
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0009 0.00091099739074707
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0009 0.00088286399841309
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110 0.0007 0.00067281723022461
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
111 0.0018 0.001751184463501
SELECT * FROM productamazoncontent WHERE product_id = '901'
112 0.0009 0.00093412399291992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '901' AND a.name = n.originalname
113 0.0015 0.00152587890625
SELECT * FROM productoffers WHERE product_id = '901' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0005 0.00052905082702637
SELECT * FROM productoffers
                WHERE product_id = '901' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0004 0.00039386749267578
SELECT * FROM productoffers
                WHERE product_id = 901
                ORDER BY price ASC LIMIT 1
116 0.0006 0.00057387351989746
SELECT value FROM productattributes
                WHERE product_id = '901'
                AND name = 'ListPriceAmount'
117 0.0005 0.00051093101501465
SELECT value FROM productattributes WHERE product_id = '901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0006 0.00055098533630371
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
119 0.0096 0.0096249580383301
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 901 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
120 0.0009 0.00090813636779785
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 901 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0008 0.00081801414489746
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 901 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
122 0.0005 0.00052189826965332
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
123 0.0007 0.00070905685424805
SELECT * FROM product_image_select WHERE product_id = '4954'
124 0.0005 0.00052285194396973
SELECT * FROM productcustomimages WHERE product_id = '4954'
125 0.0010 0.00098013877868652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
126 0.0005 0.00052213668823242
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00044584274291992
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.00047898292541504
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0009 0.00085306167602539
SELECT * FROM productimages WHERE product_id = '1251' ORDER BY sortorder ASC
130 0.0007 0.00066089630126953
SELECT * FROM product_image_select WHERE product_id = '1251'
131 0.0005 0.00054001808166504
SELECT * FROM productcustomimages WHERE product_id = '1251'
132 0.0056 0.005640983581543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1251' AND a.name = n.originalname
133 0.0012 0.0011930465698242
SELECT * FROM productoffers WHERE product_id = '1251' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0045 0.0045490264892578
SELECT * FROM productoffers
                WHERE product_id = '1251' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0007 0.00072908401489258
SELECT value FROM productattributes WHERE product_id = '1251' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0008 0.00077581405639648
SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
137 0.0010 0.0009768009185791
SELECT * FROM product_image_select WHERE product_id = '2290'
138 0.0007 0.00066804885864258
SELECT * FROM productcustomimages WHERE product_id = '2290'
139 0.0017 0.0017330646514893
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
140 0.0007 0.0007169246673584
SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0006 0.00057697296142578
SELECT * FROM productoffers
                WHERE product_id = '2290' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0006 0.00061798095703125
SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0007 0.0006859302520752
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
144 0.0008 0.00084614753723145
SELECT * FROM product_image_select WHERE product_id = '938'
145 0.0005 0.00051093101501465
SELECT * FROM productcustomimages WHERE product_id = '938'
146 0.0010 0.0010261535644531
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
147 0.0006 0.00063800811767578
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0006 0.0005948543548584
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0006 0.00055193901062012
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0008 0.00078988075256348
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
151 0.0011 0.0010669231414795
SELECT * FROM product_image_select WHERE product_id = '858'
152 0.0006 0.00062894821166992
SELECT * FROM productcustomimages WHERE product_id = '858'
153 0.0015 0.0015320777893066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
154 0.0006 0.00059294700622559
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0006 0.00056290626525879
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0006 0.0006110668182373
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
158 0.0008 0.00075101852416992
SELECT * FROM product_image_select WHERE product_id = '2521'
159 0.0005 0.00048303604125977
SELECT * FROM productcustomimages WHERE product_id = '2521'
160 0.0010 0.0009918212890625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
161 0.0007 0.00066804885864258
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0005 0.00054192543029785
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0007 0.00071287155151367
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0006 0.00058102607727051
SELECT id,asin FROM products WHERE parent_id = 901
165 0.0018 0.0018479824066162
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '901' ORDER BY timestamp DESC
166 0.0005 0.00054001808166504
SELECT category_id FROM products_categories WHERE product_id = '901'
167 0.0006 0.00060200691223145
SELECT * FROM categories WHERE id = '27'
168 0.0050 0.00496506690979
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
169 0.0005 0.00050878524780273
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
170 0.0005 0.00045013427734375
SELECT id FROM categories WHERE parent_id = '27'
171 0.0048 0.0047562122344971
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 
172 0.0006 0.00055480003356934
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 
173 0.0007 0.00065493583679199
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
174 0.0005 0.00054407119750977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
175 0.0009 0.00085997581481934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '901' AND a.name = n.originalname
176 0.0005 0.00050020217895508
SELECT * FROM productoffers WHERE product_id = '901' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0007 0.000701904296875
SELECT * FROM productoffers
                WHERE product_id = '901' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00036382675170898
SELECT * FROM productoffers
                WHERE product_id = 901
                ORDER BY price ASC LIMIT 1
179 0.0006 0.00063800811767578
SELECT value FROM productattributes
                WHERE product_id = '901'
                AND name = 'ListPriceAmount'
180 0.0008 0.0008089542388916
SELECT * FROM products WHERE id = '901'
181 0.0007 0.00065922737121582
SELECT value FROM productattributes WHERE product_id = '901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0011 0.0010659694671631
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '901' AND a.name = n.originalname
183 0.0004 0.00043606758117676
SELECT * FROM productoffers WHERE product_id = '901' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '901' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00039815902709961
SELECT * FROM productoffers
                WHERE product_id = 901
                ORDER BY price ASC LIMIT 1
186 0.0005 0.00048995018005371
SELECT value FROM productattributes
                WHERE product_id = '901'
                AND name = 'ListPriceAmount'
187 0.0005 0.00053977966308594
SELECT category_id FROM products_categories WHERE product_id = '901' AND prod_type = 'amz'
188 0.0006 0.00060820579528809
SELECT parent_id FROM categories WHERE id = '27'
189 0.0004 0.00042986869812012
SELECT * FROM categories WHERE id = '27'
190 0.0055 0.0055458545684814
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
191 0.0005 0.00048303604125977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
192 0.0004 0.00040006637573242
SELECT id FROM categories WHERE parent_id = '27'
193 0.0044 0.0043778419494629
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 
194 0.0005 0.00053000450134277
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 
195 0.0005 0.00054287910461426
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
196 0.0005 0.00047516822814941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
197 0.0017 0.0016589164733887
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
198 0.0012 0.0011639595031738
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
199 0.0003 0.00033998489379883
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
200 0.0149 0.014918088912964
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
201 0.0024 0.0023989677429199
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
202 0.0006 0.00062012672424316
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
203 0.0007 0.00071477890014648
SELECT * FROM products WHERE id = 1626
204 0.0006 0.00062894821166992
SELECT * FROM products WHERE id = 4041
205 0.0006 0.00060009956359863
SELECT * FROM products WHERE id = 4312
206 0.0006 0.00061488151550293
SELECT * FROM products WHERE id = 777
207 0.0006 0.00061702728271484
SELECT * FROM products WHERE id = 3881
208 0.0006 0.00061392784118652
SELECT * FROM products WHERE id = 4213
209 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = '1626'
210 0.0006 0.00062990188598633
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
211 0.0008 0.00078892707824707
SELECT * FROM product_image_select WHERE product_id = '1626'
212 0.0005 0.00050497055053711
SELECT * FROM productcustomimages WHERE product_id = '1626'
213 0.0011 0.0011091232299805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
214 0.0007 0.00066494941711426
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0006 0.00055909156799316
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0006 0.0005640983581543
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0007 0.00072097778320312
SELECT * FROM products WHERE id = '4041'
218 0.0005 0.00050711631774902
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
219 0.0006 0.00064301490783691
SELECT * FROM product_image_select WHERE product_id = '4041'
220 0.0005 0.00053811073303223
SELECT * FROM productcustomimages WHERE product_id = '4041'
221 0.0013 0.0013010501861572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
222 0.0006 0.0006101131439209
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0005 0.00046777725219727
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0005 0.00053691864013672
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0007 0.00068092346191406
SELECT * FROM products WHERE id = '4312'
226 0.0006 0.00055599212646484
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
227 0.0007 0.00069499015808105
SELECT * FROM product_image_select WHERE product_id = '4312'
228 0.0004 0.0004417896270752
SELECT * FROM productcustomimages WHERE product_id = '4312'
229 0.0011 0.0011348724365234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
230 0.0006 0.00062704086303711
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0005 0.00051617622375488
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0005 0.00046682357788086
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0007 0.00068211555480957
SELECT * FROM products WHERE id = '777'
234 0.0005 0.0005490779876709
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
235 0.0006 0.00064206123352051
SELECT * FROM product_image_select WHERE product_id = '777'
236 0.0004 0.00043797492980957
SELECT * FROM productcustomimages WHERE product_id = '777'
237 0.0011 0.001143217086792
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
238 0.0006 0.00055694580078125
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
239 0.0005 0.00045585632324219
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
240 0.0006 0.00055408477783203
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0007 0.00071096420288086
SELECT * FROM products WHERE id = '3881'
242 0.0007 0.00072383880615234
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
243 0.0007 0.00067996978759766
SELECT * FROM product_image_select WHERE product_id = '3881'
244 0.0005 0.00047683715820312
SELECT * FROM productcustomimages WHERE product_id = '3881'
245 0.0012 0.0012071132659912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
246 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
247 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
248 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
249 0.0006 0.00064182281494141
SELECT * FROM products WHERE id = '4213'
250 0.0008 0.00075101852416992
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
251 0.0007 0.00065898895263672
SELECT * FROM product_image_select WHERE product_id = '4213'
252 0.0005 0.0004730224609375
SELECT * FROM productcustomimages WHERE product_id = '4213'
253 0.0015 0.0014610290527344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
254 0.0005 0.0005180835723877
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0004 0.00044894218444824
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0005 0.00049591064453125
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257 0.0024 0.0023841857910156
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
258 0.0009 0.00094103813171387
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
259 0.0030 0.0029728412628174
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
260 0.0021 0.0021119117736816
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0008 0.00076889991760254
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
262 0.0009 0.00094294548034668
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'