0

Dammann Frères - Rooibos l'Oriental-100gr boite

Price: €25,99
Product prices and availability are accurate as of 2022-06-22 00:43:11 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.
Availability: In Stock
En stock.
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

Dammann Frères - Rooibos l'Oriental -100gr boite

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.4179389476776 255 1.7282 0


No Amazon API Requests Made.


App Debug - Total Time 2.4179389476776 seconds

Number Time From Start Name Description
1 0.38869595527649 Initialise Initialise FSB Function
2 0.3937509059906 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42537999153137 Start of getCategoryListByGroup Function Before first category groups query
4 0.42740893363953 After initial query Before first category groups query
5 0.42740988731384 Get Category List for Group Before the call to getCategoryList function
6 0.42741203308105 Start of GetCategoryList function Start of the function
7 0.42741298675537 Before getting categories Query to get specific category list
8 0.42890501022339 After getting categories Query to get specific category list
9 0.42890596389771 Before getting category custom Before call to function getCategoryCustom
10 0.45279502868652 After getting category custom After call to function getCategoryCustom
11 0.45279788970947 Before getting category custom Before call to function getCategoryCustom
12 0.4640040397644 After getting category custom After call to function getCategoryCustom
13 0.46400499343872 Before getting category custom Before call to function getCategoryCustom
14 0.46955895423889 After getting category custom After call to function getCategoryCustom
15 0.46956086158752 Before getting category custom Before call to function getCategoryCustom
16 0.47345685958862 After getting category custom After call to function getCategoryCustom
17 0.47345900535583 Before getting category custom Before call to function getCategoryCustom
18 0.47725796699524 After getting category custom After call to function getCategoryCustom
19 0.47725987434387 Before getting category custom Before call to function getCategoryCustom
20 0.48179888725281 After getting category custom After call to function getCategoryCustom
21 0.48180103302002 End of GetCategoryList function End of the function
22 0.48180603981018 Get Category List for Group Before the call to getCategoryList function
23 0.4818069934845 Start of GetCategoryList function Start of the function
24 0.48180794715881 Before getting categories Query to get specific category list
25 0.48224687576294 End of getCategoryListByGroup Function Before return()
26 1.9239740371704 App Controller End End of the App controller (called before the controller of every page)
27 1.9244730472565 Product Start Start of the product info controller
28 1.9587879180908 Cache file not found Starting get product details
29 2.0089409351349 Related products Start getting related products if enabled
30 2.0089418888092 Related Products Start Before the related products are found
31 2.0089418888092 Related Products Keywords Before the related product keywords are found
32 2.008945941925 Create Keyword List Function Start of function
33 2.0090198516846 Create Keyword List Function After looping provided content - 12 keywords found
34 2.0093059539795 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
35 2.0093100070953 Create Keyword List Function After reducing keyword list
36 2.0093200206757 Create Keyword List Function After selecting by scoring keywords
37 2.0093228816986 Create Keyword List Function After final loop of keywords
38 2.0093240737915 Related Products Keywords After the related product keywords are found
39 2.0410170555115 Related Products End After the related products are found
40 2.0689878463745 Product End End of the product info controller (Product Info)
41 2.0712549686432 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.0729510784149 Before Get Options Before the call to getOptions in the tpl class
43 2.1430978775024 After Get Options After the call to getOptions in the tpl class
44 2.1432058811188 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.1432280540466 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.3894190788269 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.3894228935242 Product Info: Before Template Display Before the template is displayed
48 2.4179210662842 Product Info: After Template Display After the template is displayed
49 2.4179298877716 Finalizing debug Before the debug is output to the page.
50 2.4179379940033 End of App This is the end of the app logging, final timestamp


Query Debug - 255 Database Queries. Total time 1.7282 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.0025768280029297
SELECT parameter, value FROM parameters
2 0.0031 0.0030961036682129
SELECT * FROM `bad_bots`
3 0.0004 0.0003509521484375
SET time_zone = 'Europe/London'
4 0.0020 0.0019710063934326
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019280910491943
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.134.81.178\";}'
6 0.0015 0.0015139579772949
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746021258'
7 0.0017 0.0017459392547607
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00048208236694336
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0017 0.0016880035400391
SELECT id FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' LIMIT 1
10 0.0023 0.0022690296173096
SELECT id FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' AND hidden = 0 LIMIT 1
11 0.0026 0.0025548934936523
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0280 0.0279541015625
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00061607360839844
SELECT * FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
14 0.0020 0.0020239353179932
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0015 0.0014829635620117
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0081 0.008112907409668
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.0018 0.0018401145935059
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.0013 0.0012738704681396
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00043702125549316
SELECT id FROM categories WHERE parent_id = '26'
20 0.0066 0.006558895111084
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.0020 0.0020251274108887
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.0019 0.0018570423126221
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.0013 0.0013442039489746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00037503242492676
SELECT * FROM categorygroups WHERE id = '1'
25 0.0046 0.0045809745788574
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00047588348388672
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.00037980079650879
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00037598609924316
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0037047863006592
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0004 0.00044107437133789
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0005 0.00045585632324219
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.0004 0.00042104721069336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00033116340637207
SELECT * FROM categorygroups WHERE id = '1'
34 0.0013 0.0013411045074463
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0004 0.00041699409484863
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.0003 0.00032806396484375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00035595893859863
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0014519691467285
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.00045490264892578
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.0004 0.00044894218444824
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.0004 0.00039100646972656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00032997131347656
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00053191184997559
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.0004 0.00038814544677734
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00031113624572754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00036311149597168
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00061416625976562
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.00045108795166016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0004 0.00042891502380371
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.0004 0.00040102005004883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00036406517028809
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00049400329589844
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.0004 0.00038909912109375
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.0003 0.00032186508178711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00035619735717773
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00060510635375977
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.0004 0.00041484832763672
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.0004 0.0004279613494873
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.0004 0.00039005279541016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00034904479980469
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00065183639526367
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.00048613548278809
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.0003669261932373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00042819976806641
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00077104568481445
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.0005 0.0004880428314209
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0005 0.00047707557678223
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.00046300888061523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00034999847412109
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00043106079101562
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0029 0.002924919128418
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0015 0.0014610290527344
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00056004524230957
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.0012331008911133
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011129379272461
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00077199935913086
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 1.4281 1.4281449317932
SELECT * FROM ipgeocountries WHERE INET_ATON('3.134.81.178') >= INET_ATON(ip_start) AND INET_ATON('3.134.81.178') <= INET_ATON(ip_end)
78 0.0027 0.0026979446411133
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012691020965576
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00057601928710938
SELECT * FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
81 0.0004 0.00039005279541016
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4814
82 0.0010 0.0010428428649902
SELECT * FROM manufacturers WHERE id = '177'
83 0.0008 0.00084185600280762
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
84 0.0033 0.0032758712768555
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '177' LIMIT 1
85 0.0035 0.0034549236297607
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '177' ORDER BY RAND() LIMIT 1
86 0.0006 0.00063800811767578
SELECT * FROM productimages WHERE product_id = '975' ORDER BY sortorder ASC
87 0.0007 0.00066494941711426
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
88 0.0007 0.00070786476135254
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '177'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0007 0.00070500373840332
SELECT * FROM manufacturerimages WHERE manufacturer_id = '177'
90 0.0007 0.00066208839416504
SELECT category_id FROM products_categories WHERE product_id = '4814'
91 0.0007 0.00067996978759766
SELECT * FROM categories WHERE id = '27'
92 0.0078 0.007814884185791
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.0005 0.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0005 0.00046706199645996
SELECT id FROM categories WHERE parent_id = '27'
95 0.0058 0.005774974822998
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.0006 0.00064611434936523
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.0007 0.00068211555480957
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.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00046205520629883
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
100 0.0018 0.0018401145935059
SELECT * FROM product_image_select WHERE product_id = '4814'
101 0.0013 0.001338005065918
SELECT * FROM productcustomimages WHERE product_id = '4814'
102 0.0013 0.001276969909668
SELECT * FROM productfeeds WHERE product_id = '4814' ORDER BY item_date DESC
103 0.0026 0.0026230812072754
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0025 0.0024728775024414
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4814' AND t.hidden = 0 AND display_product = 1
105 0.0003 0.00031590461730957
SELECT * FROM tags WHERE id = '1'
106 0.0015 0.0015370845794678
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0014 0.0014438629150391
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0013 0.0013449192047119
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0006 0.00060200691223145
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
110 0.0015 0.0014760494232178
SELECT * FROM productamazoncontent WHERE product_id = '4814'
111 0.0010 0.00099277496337891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
112 0.0015 0.0014970302581787
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00051379203796387
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0005 0.00049090385437012
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
116 0.0097 0.0097129344940186
SELECT *, MATCH (description, title) AGAINST ('frÃres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('frÃres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
117 0.0007 0.00065994262695312
SELECT *, MATCH (description, title) AGAINST ('frÃres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('frÃres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
118 0.0006 0.00060510635375977
SELECT *, MATCH (description, title) AGAINST ('frÃres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('frÃres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0005 0.0005490779876709
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
120 0.0007 0.00067400932312012
SELECT * FROM product_image_select WHERE product_id = '862'
121 0.0004 0.00044894218444824
SELECT * FROM productcustomimages WHERE product_id = '862'
122 0.0010 0.00095391273498535
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
123 0.0005 0.00049090385437012
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0004 0.0004119873046875
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
127 0.0006 0.00055909156799316
SELECT * FROM product_image_select WHERE product_id = '878'
128 0.0004 0.0003511905670166
SELECT * FROM productcustomimages WHERE product_id = '878'
129 0.0009 0.00092911720275879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
130 0.0004 0.00042915344238281
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0004 0.00039315223693848
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00036382675170898
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0005 0.00049805641174316
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
134 0.0005 0.00049901008605957
SELECT * FROM product_image_select WHERE product_id = '858'
135 0.0003 0.0003049373626709
SELECT * FROM productcustomimages WHERE product_id = '858'
136 0.0009 0.00092196464538574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
137 0.0004 0.00039196014404297
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.0003821849822998
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0004 0.00035786628723145
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0004 0.00043892860412598
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
141 0.0005 0.000518798828125
SELECT * FROM product_image_select WHERE product_id = '890'
142 0.0003 0.00030994415283203
SELECT * FROM productcustomimages WHERE product_id = '890'
143 0.0009 0.00090909004211426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
144 0.0004 0.00043201446533203
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0003 0.00034117698669434
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00035285949707031
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0004 0.00040316581726074
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
148 0.0005 0.0005340576171875
SELECT * FROM product_image_select WHERE product_id = '865'
149 0.0004 0.00036287307739258
SELECT * FROM productcustomimages WHERE product_id = '865'
150 0.0006 0.00064587593078613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
151 0.0004 0.00040102005004883
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00036001205444336
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00046706199645996
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
155 0.0005 0.00049519538879395
SELECT * FROM product_image_select WHERE product_id = '869'
156 0.0003 0.00032901763916016
SELECT * FROM productcustomimages WHERE product_id = '869'
157 0.0008 0.00076699256896973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
158 0.0004 0.0003960132598877
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0004 0.00039505958557129
SELECT id,asin FROM products WHERE parent_id = 4814
162 0.0018 0.0017600059509277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4814' ORDER BY timestamp DESC
163 0.0004 0.00038886070251465
SELECT category_id FROM products_categories WHERE product_id = '4814'
164 0.0004 0.00039005279541016
SELECT * FROM categories WHERE id = '27'
165 0.0035 0.0035400390625
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
166 0.0004 0.00036406517028809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0004 0.00038409233093262
SELECT id FROM categories WHERE parent_id = '27'
168 0.0036 0.0036020278930664
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 
169 0.0005 0.0004880428314209
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 
170 0.0005 0.00048494338989258
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
171 0.0004 0.00041604042053223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0010 0.00097799301147461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
173 0.0004 0.00044012069702148
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.0003669261932373
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00051617622375488
SELECT * FROM products WHERE id = '4814'
176 0.0005 0.00047588348388672
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0010 0.00095891952514648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
178 0.0003 0.00033712387084961
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0011 0.0010879039764404
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00050997734069824
SELECT category_id FROM products_categories WHERE product_id = '4814' AND prod_type = 'amz'
181 0.0004 0.00041818618774414
SELECT parent_id FROM categories WHERE id = '27'
182 0.0003 0.00030088424682617
SELECT * FROM categories WHERE id = '27'
183 0.0038 0.0037670135498047
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
184 0.0004 0.00038480758666992
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
185 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '27'
186 0.0034 0.0033650398254395
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 
187 0.0005 0.00046515464782715
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 
188 0.0005 0.00052905082702637
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
189 0.0004 0.00041890144348145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
190 0.0018 0.0017969608306885
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
191 0.0013 0.0013129711151123
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
192 0.0003 0.00033903121948242
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
193 0.0144 0.014422178268433
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
194 0.0023 0.0022561550140381
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
195 0.0006 0.00064897537231445
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
196 0.0013 0.0012760162353516
SELECT * FROM products WHERE id = 1626
197 0.0008 0.00075888633728027
SELECT * FROM products WHERE id = 4041
198 0.0006 0.00063705444335938
SELECT * FROM products WHERE id = 4312
199 0.0008 0.00078296661376953
SELECT * FROM products WHERE id = 777
200 0.0007 0.00073480606079102
SELECT * FROM products WHERE id = 3881
201 0.0008 0.00082588195800781
SELECT * FROM products WHERE id = 4213
202 0.0006 0.0006098747253418
SELECT * FROM products WHERE id = '1626'
203 0.0010 0.0010459423065186
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
204 0.0014 0.0014019012451172
SELECT * FROM product_image_select WHERE product_id = '1626'
205 0.0009 0.00088381767272949
SELECT * FROM productcustomimages WHERE product_id = '1626'
206 0.0020 0.0019669532775879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
207 0.0010 0.0009911060333252
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0007 0.00072908401489258
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0008 0.00082302093505859
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0010 0.001032829284668
SELECT * FROM products WHERE id = '4041'
211 0.0010 0.00095391273498535
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
212 0.0014 0.0014419555664062
SELECT * FROM product_image_select WHERE product_id = '4041'
213 0.0007 0.00068402290344238
SELECT * FROM productcustomimages WHERE product_id = '4041'
214 0.0033 0.0032589435577393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
215 0.0012 0.0011501312255859
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0006 0.00063705444335938
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0010 0.0010428428649902
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0010 0.00098204612731934
SELECT * FROM products WHERE id = '4312'
219 0.0006 0.00064516067504883
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
220 0.0009 0.00085806846618652
SELECT * FROM product_image_select WHERE product_id = '4312'
221 0.0005 0.00050210952758789
SELECT * FROM productcustomimages WHERE product_id = '4312'
222 0.0014 0.0014059543609619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
223 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00047707557678223
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0006 0.00057697296142578
SELECT * FROM products WHERE id = '777'
227 0.0005 0.00052809715270996
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0007 0.00072717666625977
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0015 0.0014779567718506
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0005 0.00052595138549805
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0005 0.00047993659973145
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0006 0.00059390068054199
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0006 0.0006101131439209
SELECT * FROM products WHERE id = '3881'
235 0.0007 0.00065708160400391
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
236 0.0006 0.00062203407287598
SELECT * FROM product_image_select WHERE product_id = '3881'
237 0.0004 0.00035381317138672
SELECT * FROM productcustomimages WHERE product_id = '3881'
238 0.0011 0.0010659694671631
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
239 0.0004 0.00040602684020996
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0004 0.00035309791564941
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0004 0.00041723251342773
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0005 0.00050806999206543
SELECT * FROM products WHERE id = '4213'
243 0.0005 0.00047087669372559
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
244 0.0005 0.00053596496582031
SELECT * FROM product_image_select WHERE product_id = '4213'
245 0.0003 0.00034499168395996
SELECT * FROM productcustomimages WHERE product_id = '4213'
246 0.0011 0.0010659694671631
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
247 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0021 0.0020520687103271
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
251 0.0007 0.00071096420288086
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
252 0.0024 0.0023951530456543
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
253 0.0018 0.0018091201782227
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
254 0.0006 0.00056791305541992
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0013 0.0012547969818115
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'