0

Rooibos Pukka & Honeybush Sachets De Fairtrade 20 Par Paquet

Price: Click Button for Price
Product prices and availability are accurate as of 2022-04-07 05:40:10 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

Rooibos Pukka & Honeybush Sachets De Fairtrade 20 Par Paquet Quantité: 1

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
2.6167778968811 266 0.9279 0


No Amazon API Requests Made.


App Debug - Total Time 2.6167778968811 seconds

Number Time From Start Name Description
1 1.6170258522034 Initialise Initialise FSB Function
2 1.6260929107666 App Controller Start Start of the App controller (called before the controller of every page)
3 1.666268825531 Start of getCategoryListByGroup Function Before first category groups query
4 1.6681199073792 After initial query Before first category groups query
5 1.6681208610535 Get Category List for Group Before the call to getCategoryList function
6 1.668123960495 Start of GetCategoryList function Start of the function
7 1.6681268215179 Before getting categories Query to get specific category list
8 1.6698968410492 After getting categories Query to get specific category list
9 1.6698989868164 Before getting category custom Before call to function getCategoryCustom
10 1.6929309368134 After getting category custom After call to function getCategoryCustom
11 1.6929359436035 Before getting category custom Before call to function getCategoryCustom
12 1.7070429325104 After getting category custom After call to function getCategoryCustom
13 1.7070469856262 Before getting category custom Before call to function getCategoryCustom
14 1.7151789665222 After getting category custom After call to function getCategoryCustom
15 1.7151818275452 Before getting category custom Before call to function getCategoryCustom
16 1.7205350399017 After getting category custom After call to function getCategoryCustom
17 1.7205379009247 Before getting category custom Before call to function getCategoryCustom
18 1.7255749702454 After getting category custom After call to function getCategoryCustom
19 1.7255778312683 Before getting category custom Before call to function getCategoryCustom
20 1.7307980060577 After getting category custom After call to function getCategoryCustom
21 1.7307999134064 End of GetCategoryList function End of the function
22 1.7308068275452 Get Category List for Group Before the call to getCategoryList function
23 1.7308089733124 Start of GetCategoryList function Start of the function
24 1.7308118343353 Before getting categories Query to get specific category list
25 1.7314100265503 End of getCategoryListByGroup Function Before return()
26 2.2623488903046 App Controller End End of the App controller (called before the controller of every page)
27 2.2626309394836 Product Start Start of the product info controller
28 2.2974309921265 Cache file not found Starting get product details
29 2.3481798171997 Related products Start getting related products if enabled
30 2.3481819629669 Related Products Start Before the related products are found
31 2.3481829166412 Related Products Keywords Before the related product keywords are found
32 2.3481869697571 Create Keyword List Function Start of function
33 2.3482909202576 Create Keyword List Function After looping provided content - 27 keywords found
34 2.34947681427 Create Keyword List Function After looping initial keyword list - 24 keywords remaining
35 2.349485874176 Create Keyword List Function After reducing keyword list
36 2.3495569229126 Create Keyword List Function After selecting by scoring keywords
37 2.3495609760284 Create Keyword List Function After final loop of keywords
38 2.3495619297028 Related Products Keywords After the related product keywords are found
39 2.432196855545 Related Products End After the related products are found
40 2.473541021347 Product End End of the product info controller (Product Info)
41 2.4757769107819 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.4775748252869 Before Get Options Before the call to getOptions in the tpl class
43 2.5530059337616 After Get Options After the call to getOptions in the tpl class
44 2.5532059669495 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.5532310009003 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.5790858268738 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.5790920257568 Product Info: Before Template Display Before the template is displayed
48 2.6167528629303 Product Info: After Template Display After the template is displayed
49 2.6167600154877 Finalizing debug Before the debug is output to the page.
50 2.6167759895325 End of App This is the end of the app logging, final timestamp


Query Debug - 266 Database Queries. Total time 0.9279 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.0025851726531982
SELECT parameter, value FROM parameters
2 0.0082 0.008213996887207
SELECT * FROM `bad_bots`
3 0.0006 0.0005638599395752
SET time_zone = 'Europe/London'
4 0.0030 0.0029678344726562
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0045 0.004457950592041
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.174\";}'
6 0.0159 0.015882015228271
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738871817'
7 0.0036 0.0036051273345947
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.00097012519836426
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0036 0.003572940826416
SELECT id FROM pages WHERE pagename = 'rooibos-pukka-honeybush-sachets-de-fairtrade-20-par-paquet' LIMIT 1
10 0.0041 0.0041019916534424
SELECT id FROM products WHERE pagename = 'rooibos-pukka-honeybush-sachets-de-fairtrade-20-par-paquet' AND hidden = 0 LIMIT 1
11 0.0041 0.0041429996490479
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0349 0.034893989562988
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00063300132751465
SELECT * FROM pages WHERE pagename = 'rooibos-pukka-honeybush-sachets-de-fairtrade-20-par-paquet'
14 0.0018 0.0018398761749268
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0018 0.0017528533935547
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0066 0.0066380500793457
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.0020 0.001986026763916
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.0014 0.001410961151123
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00060200691223145
SELECT id FROM categories WHERE parent_id = '26'
20 0.0065 0.0065340995788574
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.0019 0.0019228458404541
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.0016 0.0016319751739502
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.0017 0.0017271041870117
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00042891502380371
SELECT * FROM categorygroups WHERE id = '1'
25 0.0045 0.0045459270477295
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.0006 0.00058603286743164
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.00043082237243652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00048398971557617
SELECT id FROM categories WHERE parent_id = '27'
29 0.0058 0.005824089050293
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.00059294700622559
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.0006 0.00057792663574219
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.0005 0.00049304962158203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00043511390686035
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.00201416015625
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.00051593780517578
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.0003819465637207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.0004580020904541
SELECT id FROM categories WHERE parent_id = '28'
38 0.0025 0.0024819374084473
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.00050497055053711
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.00057196617126465
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.0006 0.00059080123901367
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.0004880428314209
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00061702728271484
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.00059199333190918
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.0004 0.00041103363037109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00054287910461426
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.0007929801940918
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.00046706199645996
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.0007011890411377
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.00062012672424316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00048685073852539
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00075101852416992
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.00051188468933105
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.00041007995605469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00042915344238281
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.0008080005645752
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.0005338191986084
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.0005 0.00049996376037598
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.0005 0.00050806999206543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00045204162597656
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00070691108703613
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.0005 0.00050616264343262
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.0004 0.00043892860412598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00048613548278809
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00084304809570312
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.0006 0.00055193901062012
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.00058698654174805
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.0006 0.00056290626525879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.0004420280456543
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00058698654174805
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0044 0.0043709278106689
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0022 0.0022380352020264
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00065994262695312
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.0013 0.0012969970703125
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011088848114014
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010740756988525
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5119 0.51185202598572
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.174') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.174') <= INET_ATON(ip_end)
78 0.0021 0.0020968914031982
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0015 0.0015091896057129
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.0006718635559082
SELECT * FROM products WHERE pagename = 'rooibos-pukka-honeybush-sachets-de-fairtrade-20-par-paquet'
81 0.0004 0.00040221214294434
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1421
82 0.0009 0.00092506408691406
SELECT * FROM manufacturers WHERE id = '332'
83 0.0018 0.0017611980438232
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '332'
84 0.0032 0.0032038688659668
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '332' LIMIT 1
85 0.0052 0.0051579475402832
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '332' ORDER BY RAND() LIMIT 1
86 0.0009 0.00091195106506348
SELECT * FROM productimages WHERE product_id = '1419' ORDER BY sortorder ASC
87 0.0008 0.00080394744873047
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '332'
88 0.0008 0.00081086158752441
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '332'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0010 0.0010387897491455
SELECT * FROM manufacturerimages WHERE manufacturer_id = '332'
90 0.0014 0.0014441013336182
SELECT category_id FROM products_categories WHERE product_id = '1421'
91 0.0008 0.00080108642578125
SELECT * FROM categories WHERE id = '27'
92 0.0080 0.0079941749572754
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.00060820579528809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0005 0.0004730224609375
SELECT id FROM categories WHERE parent_id = '27'
95 0.0055 0.0055408477783203
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.0007 0.00065207481384277
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.00058889389038086
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.00054407119750977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00057888031005859
SELECT * FROM productimages WHERE product_id = '1421' ORDER BY sortorder ASC
100 0.0018 0.0018200874328613
SELECT * FROM product_image_select WHERE product_id = '1421'
101 0.0012 0.0012109279632568
SELECT * FROM productcustomimages WHERE product_id = '1421'
102 0.0022 0.0022101402282715
SELECT * FROM productfeeds WHERE product_id = '1421' ORDER BY item_date DESC
103 0.0025 0.0025269985198975
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1421' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0025 0.0025351047515869
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1421' AND t.hidden = 0 AND display_product = 1
105 0.0012 0.0011889934539795
SELECT * FROM productamazoncontent WHERE product_id = '1421'
106 0.0011 0.0011448860168457
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1421' AND a.name = n.originalname
107 0.0013 0.0013229846954346
SELECT * FROM productoffers WHERE product_id = '1421' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '1421' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00035881996154785
SELECT * FROM productoffers
                WHERE product_id = 1421
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00047588348388672
SELECT value FROM productattributes
                WHERE product_id = '1421'
                AND name = 'ListPriceAmount'
111 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '1421' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0006 0.0005948543548584
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
113 0.0241 0.024089813232422
SELECT *, MATCH (description, title) AGAINST ('andamp honeybush sachets' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('andamp honeybush sachets' IN BOOLEAN MODE) AND 1421 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0010 0.0009610652923584
SELECT *, MATCH (description, title) AGAINST ('andamp honeybush sachets' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('andamp honeybush sachets' IN BOOLEAN MODE) AND 1421 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0015 0.0015041828155518
SELECT *, MATCH (description, title) AGAINST ('andamp honeybush sachets' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('andamp honeybush sachets' IN BOOLEAN MODE) AND 1421 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0011 0.0011270046234131
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
117 0.0010 0.00096607208251953
SELECT * FROM product_image_select WHERE product_id = '858'
118 0.0006 0.00055599212646484
SELECT * FROM productcustomimages WHERE product_id = '858'
119 0.0014 0.0013618469238281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
120 0.0005 0.00048494338989258
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0007 0.00072288513183594
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0006 0.0005650520324707
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0007 0.00068497657775879
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
124 0.0009 0.00088596343994141
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
125 0.0010 0.00095200538635254
SELECT * FROM product_image_select WHERE product_id = '822'
126 0.0005 0.00047588348388672
SELECT * FROM productcustomimages WHERE product_id = '822'
127 0.0007 0.00067591667175293
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
128 0.0029 0.002871036529541
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
129 0.0008 0.00078392028808594
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
130 0.0010 0.00097298622131348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
131 0.0004 0.00040292739868164
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0005 0.00049304962158203
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00044798851013184
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
135 0.0005 0.00048494338989258
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 = '822'
                GROUP BY o.product_id
136 0.0007 0.0006871223449707
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
137 0.0005 0.00048995018005371
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
138 0.0006 0.00059103965759277
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0008 0.00079894065856934
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
140 0.0005 0.0005490779876709
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
141 0.0007 0.00068783760070801
SELECT * FROM product_image_select WHERE product_id = '878'
142 0.0004 0.00044417381286621
SELECT * FROM productcustomimages WHERE product_id = '878'
143 0.0012 0.0011920928955078
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
144 0.0007 0.00066614151000977
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0005 0.00050806999206543
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0006 0.00055289268493652
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0005 0.0004889965057373
SELECT * FROM productimages WHERE product_id = '1727' ORDER BY sortorder ASC
148 0.0007 0.00065016746520996
SELECT * FROM product_image_select WHERE product_id = '1727'
149 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '1727'
150 0.0008 0.00075411796569824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1727' AND a.name = n.originalname
151 0.0006 0.00055217742919922
SELECT * FROM productoffers WHERE product_id = '1727' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00048995018005371
SELECT * FROM productoffers
                WHERE product_id = '1727' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '1727' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00053501129150391
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
155 0.0007 0.00071215629577637
SELECT * FROM product_image_select WHERE product_id = '764'
156 0.0006 0.00056195259094238
SELECT * FROM productcustomimages WHERE product_id = '764'
157 0.0010 0.0009770393371582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
158 0.0014 0.0013737678527832
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0009 0.00094795227050781
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0012 0.0012109279632568
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0021 0.0021178722381592
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
162 0.0027 0.0026719570159912
SELECT * FROM product_image_select WHERE product_id = '857'
163 0.0010 0.0010061264038086
SELECT * FROM productcustomimages WHERE product_id = '857'
164 0.0029 0.0028650760650635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
165 0.0021 0.0020828247070312
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0077 0.0077278614044189
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0024 0.002392053604126
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0007 0.00065207481384277
SELECT id,asin FROM products WHERE parent_id = 1421
169 0.0020 0.0019888877868652
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1421' ORDER BY timestamp DESC
170 0.0006 0.00056982040405273
SELECT category_id FROM products_categories WHERE product_id = '1421'
171 0.0006 0.00056695938110352
SELECT * FROM categories WHERE id = '27'
172 0.0058 0.0058178901672363
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.0005 0.00051188468933105
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
174 0.0008 0.00078701972961426
SELECT id FROM categories WHERE parent_id = '27'
175 0.0086 0.0085911750793457
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.0007 0.00065803527832031
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.0006 0.00058794021606445
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.0005 0.00053620338439941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
179 0.0011 0.0010941028594971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1421' AND a.name = n.originalname
180 0.0005 0.00054001808166504
SELECT * FROM productoffers WHERE product_id = '1421' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '1421' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00036811828613281
SELECT * FROM productoffers
                WHERE product_id = 1421
                ORDER BY price ASC LIMIT 1
183 0.0004 0.00041913986206055
SELECT value FROM productattributes
                WHERE product_id = '1421'
                AND name = 'ListPriceAmount'
184 0.0007 0.00068902969360352
SELECT * FROM products WHERE id = '1421'
185 0.0005 0.00047588348388672
SELECT value FROM productattributes WHERE product_id = '1421' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0011 0.001072883605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1421' AND a.name = n.originalname
187 0.0004 0.00043606758117676
SELECT * FROM productoffers WHERE product_id = '1421' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = '1421' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = 1421
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00041389465332031
SELECT value FROM productattributes
                WHERE product_id = '1421'
                AND name = 'ListPriceAmount'
191 0.0005 0.00048089027404785
SELECT category_id FROM products_categories WHERE product_id = '1421' AND prod_type = 'amz'
192 0.0005 0.00049591064453125
SELECT parent_id FROM categories WHERE id = '27'
193 0.0005 0.00053095817565918
SELECT * FROM categories WHERE id = '27'
194 0.0042 0.0042078495025635
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
195 0.0005 0.00046181678771973
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
196 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '27'
197 0.0045 0.0045139789581299
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 
198 0.0006 0.00059103965759277
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 
199 0.0005 0.00054216384887695
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
200 0.0006 0.00060510635375977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
201 0.0019 0.0018730163574219
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
202 0.0012 0.0012290477752686
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
203 0.0004 0.00044608116149902
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
204 0.0174 0.017374992370605
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
205 0.0027 0.0027251243591309
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
206 0.0006 0.00062298774719238
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
207 0.0006 0.00062084197998047
SELECT * FROM products WHERE id = 1626
208 0.0008 0.00075411796569824
SELECT * FROM products WHERE id = 4041
209 0.0007 0.00065898895263672
SELECT * FROM products WHERE id = 4312
210 0.0006 0.0006260871887207
SELECT * FROM products WHERE id = 777
211 0.0007 0.00068283081054688
SELECT * FROM products WHERE id = 3881
212 0.0006 0.00064897537231445
SELECT * FROM products WHERE id = 4213
213 0.0006 0.00059390068054199
SELECT * FROM products WHERE id = '1626'
214 0.0005 0.00047993659973145
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
215 0.0006 0.00064396858215332
SELECT * FROM product_image_select WHERE product_id = '1626'
216 0.0005 0.00054597854614258
SELECT * FROM productcustomimages WHERE product_id = '1626'
217 0.0009 0.00092911720275879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
218 0.0006 0.00057291984558105
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0005 0.00047516822814941
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00054407119750977
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00061297416687012
SELECT * FROM products WHERE id = '4041'
222 0.0005 0.0005040168762207
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
223 0.0007 0.00069904327392578
SELECT * FROM product_image_select WHERE product_id = '4041'
224 0.0006 0.00059390068054199
SELECT * FROM productcustomimages WHERE product_id = '4041'
225 0.0030 0.0029730796813965
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
226 0.0007 0.00066900253295898
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0006 0.00057005882263184
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0012 0.0011940002441406
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0008 0.0008089542388916
SELECT * FROM products WHERE id = '4312'
230 0.0006 0.00058817863464355
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
231 0.0012 0.0011510848999023
SELECT * FROM product_image_select WHERE product_id = '4312'
232 0.0010 0.00098395347595215
SELECT * FROM productcustomimages WHERE product_id = '4312'
233 0.0038 0.0038390159606934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
234 0.0008 0.00081300735473633
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0005 0.00048208236694336
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0007 0.0006868839263916
SELECT * FROM products WHERE id = '777'
238 0.0007 0.00071096420288086
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
239 0.0010 0.00097990036010742
SELECT * FROM product_image_select WHERE product_id = '777'
240 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '777'
241 0.0013 0.0012600421905518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
242 0.0006 0.00060796737670898
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0006 0.00057506561279297
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.00054097175598145
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0008 0.00075197219848633
SELECT * FROM products WHERE id = '3881'
246 0.0008 0.00084209442138672
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
247 0.0007 0.0007328987121582
SELECT * FROM product_image_select WHERE product_id = '3881'
248 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '3881'
249 0.0016 0.0015609264373779
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
250 0.0006 0.00055909156799316
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0005 0.00046706199645996
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0005 0.00047779083251953
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0007 0.00069999694824219
SELECT * FROM products WHERE id = '4213'
254 0.0009 0.00089097023010254
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
255 0.0007 0.00069904327392578
SELECT * FROM product_image_select WHERE product_id = '4213'
256 0.0005 0.00049281120300293
SELECT * FROM productcustomimages WHERE product_id = '4213'
257 0.0014 0.0014498233795166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
258 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0005 0.00049185752868652
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0009 0.00094699859619141
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0023 0.0023159980773926
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
262 0.0008 0.00076413154602051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
263 0.0028 0.0027608871459961
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
264 0.0020 0.0019791126251221
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
265 0.0008 0.000762939453125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0012 0.0012261867523193
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'