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
1.5056610107422 255 1.0665 0


No Amazon API Requests Made.


App Debug - Total Time 1.5056610107422 seconds

Number Time From Start Name Description
1 0.38512396812439 Initialise Initialise FSB Function
2 0.39209389686584 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42594790458679 Start of getCategoryListByGroup Function Before first category groups query
4 0.42747282981873 After initial query Before first category groups query
5 0.42747402191162 Get Category List for Group Before the call to getCategoryList function
6 0.42747688293457 Start of GetCategoryList function Start of the function
7 0.4274799823761 Before getting categories Query to get specific category list
8 0.42888498306274 After getting categories Query to get specific category list
9 0.42888689041138 Before getting category custom Before call to function getCategoryCustom
10 0.45276284217834 After getting category custom After call to function getCategoryCustom
11 0.45276594161987 Before getting category custom Before call to function getCategoryCustom
12 0.46330904960632 After getting category custom After call to function getCategoryCustom
13 0.46331286430359 Before getting category custom Before call to function getCategoryCustom
14 0.46918296813965 After getting category custom After call to function getCategoryCustom
15 0.46918702125549 Before getting category custom Before call to function getCategoryCustom
16 0.47346687316895 After getting category custom After call to function getCategoryCustom
17 0.47346997261047 Before getting category custom Before call to function getCategoryCustom
18 0.47775101661682 After getting category custom After call to function getCategoryCustom
19 0.47775387763977 Before getting category custom Before call to function getCategoryCustom
20 0.48187685012817 After getting category custom After call to function getCategoryCustom
21 0.48187899589539 End of GetCategoryList function End of the function
22 0.4818868637085 Get Category List for Group Before the call to getCategoryList function
23 0.48188900947571 Start of GetCategoryList function Start of the function
24 0.48188996315002 Before getting categories Query to get specific category list
25 0.48240089416504 End of getCategoryListByGroup Function Before return()
26 1.2480199337006 App Controller End End of the App controller (called before the controller of every page)
27 1.2487318515778 Product Start Start of the product info controller
28 1.2758729457855 Cache file not found Starting get product details
29 1.322830915451 Related products Start getting related products if enabled
30 1.3228318691254 Related Products Start Before the related products are found
31 1.3228330612183 Related Products Keywords Before the related product keywords are found
32 1.32284283638 Create Keyword List Function Start of function
33 1.3228640556335 Create Keyword List Function After looping provided content - 12 keywords found
34 1.3231840133667 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
35 1.3231899738312 Create Keyword List Function After reducing keyword list
36 1.3232028484344 Create Keyword List Function After selecting by scoring keywords
37 1.323205947876 Create Keyword List Function After final loop of keywords
38 1.3232069015503 Related Products Keywords After the related product keywords are found
39 1.3600158691406 Related Products End After the related products are found
40 1.3882670402527 Product End End of the product info controller (Product Info)
41 1.3903608322144 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3969948291779 Before Get Options Before the call to getOptions in the tpl class
43 1.4632668495178 After Get Options After the call to getOptions in the tpl class
44 1.4633798599243 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.463408946991 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4774639606476 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4774670600891 Product Info: Before Template Display Before the template is displayed
48 1.5056359767914 Product Info: After Template Display After the template is displayed
49 1.505646944046 Finalizing debug Before the debug is output to the page.
50 1.5056600570679 End of App This is the end of the app logging, final timestamp


Query Debug - 255 Database Queries. Total time 1.0665 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0017 0.0016801357269287
SELECT parameter, value FROM parameters
2 0.0091 0.0091140270233154
SELECT * FROM `bad_bots`
3 0.0005 0.0004727840423584
SET time_zone = 'Europe/London'
4 0.0023 0.0022640228271484
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0038 0.0038049221038818
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.216.93.197\";}'
6 0.0035 0.0034699440002441
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743648753'
7 0.0028 0.0028438568115234
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00069689750671387
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0028 0.0027589797973633
SELECT id FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' LIMIT 1
10 0.0030 0.0030159950256348
SELECT id FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' AND hidden = 0 LIMIT 1
11 0.0035 0.0035121440887451
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0293 0.029301881790161
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00057792663574219
SELECT * FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
14 0.0015 0.0015130043029785
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0014 0.0013830661773682
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0072 0.0071561336517334
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.0023 0.0023260116577148
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.0017 0.0017127990722656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00059103965759277
SELECT id FROM categories WHERE parent_id = '26'
20 0.0067 0.0067119598388672
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.0017 0.0016920566558838
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.0015661716461182
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.0015 0.0015139579772949
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00045990943908691
SELECT * FROM categorygroups WHERE id = '1'
25 0.0036 0.0035619735717773
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.00050902366638184
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.00041103363037109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00041389465332031
SELECT id FROM categories WHERE parent_id = '27'
29 0.0036 0.0036129951477051
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.0005650520324707
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.00051283836364746
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.00046014785766602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00039005279541016
SELECT * FROM categorygroups WHERE id = '1'
34 0.0013 0.0013349056243896
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.00045108795166016
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.00034689903259277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00037097930908203
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0014619827270508
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.00048398971557617
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.0005 0.00049495697021484
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.0004429817199707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00038909912109375
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.0005640983581543
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.00048112869262695
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.00038409233093262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00039100646972656
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00062894821166992
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.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 (29)
				  AND p.disabled = 0 
49 0.0005 0.00048398971557617
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.0004279613494873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00037002563476562
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00056099891662598
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.0004878044128418
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.00042915344238281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00043010711669922
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00064492225646973
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.00043106079101562
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.00045609474182129
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.00041604042053223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00033998489379883
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00054001808166504
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.0004 0.00040197372436523
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.00035905838012695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00034999847412109
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00064301490783691
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.00048303604125977
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.0004 0.00043821334838867
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.0004 0.0004119873046875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043201446533203
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.0005030632019043
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0026 0.0026190280914307
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0014 0.0013530254364014
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00050091743469238
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.0011 0.0010731220245361
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011069774627686
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0009 0.00090503692626953
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7529 0.75290894508362
SELECT * FROM ipgeocountries WHERE INET_ATON('18.216.93.197') >= INET_ATON(ip_start) AND INET_ATON('18.216.93.197') <= INET_ATON(ip_end)
78 0.0021 0.0021378993988037
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012640953063965
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00060486793518066
SELECT * FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
81 0.0005 0.00046086311340332
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4814
82 0.0010 0.00098586082458496
SELECT * FROM manufacturers WHERE id = '177'
83 0.0008 0.00076889991760254
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
84 0.0029 0.0028660297393799
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '177' LIMIT 1
85 0.0013 0.0012519359588623
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.00058102607727051
SELECT * FROM productimages WHERE product_id = '977' ORDER BY sortorder ASC
87 0.0007 0.00073480606079102
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
88 0.0007 0.0007319450378418
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.0004 0.00041794776916504
SELECT * FROM manufacturerimages WHERE manufacturer_id = '177'
90 0.0006 0.00064706802368164
SELECT category_id FROM products_categories WHERE product_id = '4814'
91 0.0007 0.0006709098815918
SELECT * FROM categories WHERE id = '27'
92 0.0072 0.0072250366210938
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.00061297416687012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00042390823364258
SELECT id FROM categories WHERE parent_id = '27'
95 0.0058 0.0057649612426758
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.00060510635375977
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.00065112113952637
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.0006 0.00055193901062012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.0005488395690918
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
100 0.0021 0.0020599365234375
SELECT * FROM product_image_select WHERE product_id = '4814'
101 0.0015 0.0015010833740234
SELECT * FROM productcustomimages WHERE product_id = '4814'
102 0.0013 0.0012609958648682
SELECT * FROM productfeeds WHERE product_id = '4814' ORDER BY item_date DESC
103 0.0021 0.0021450519561768
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.0024 0.002392053604126
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.0004 0.00036787986755371
SELECT * FROM tags WHERE id = '1'
106 0.0016 0.0015947818756104
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.0013959407806396
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.0014 0.0013689994812012
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.00058507919311523
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
110 0.0013 0.0012829303741455
SELECT * FROM productamazoncontent WHERE product_id = '4814'
111 0.0013 0.0012640953063965
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
112 0.0016 0.0015521049499512
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00049710273742676
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0005 0.00049805641174316
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.0105 0.010501861572266
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.0006 0.00058794021606445
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.0005500316619873
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.0004 0.00044393539428711
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
120 0.0006 0.00056910514831543
SELECT * FROM product_image_select WHERE product_id = '865'
121 0.0004 0.00037217140197754
SELECT * FROM productcustomimages WHERE product_id = '865'
122 0.0008 0.00082612037658691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
123 0.0004 0.00043988227844238
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0004 0.00038719177246094
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0006 0.00058889389038086
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
127 0.0005 0.00054097175598145
SELECT * FROM product_image_select WHERE product_id = '862'
128 0.0004 0.00036811828613281
SELECT * FROM productcustomimages WHERE product_id = '862'
129 0.0009 0.00086212158203125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
130 0.0005 0.00046014785766602
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0005 0.00051307678222656
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0006 0.00058698654174805
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0008 0.00082087516784668
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
134 0.0008 0.00082898139953613
SELECT * FROM product_image_select WHERE product_id = '890'
135 0.0005 0.00052499771118164
SELECT * FROM productcustomimages WHERE product_id = '890'
136 0.0018 0.0018057823181152
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
137 0.0006 0.00064420700073242
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0005 0.00050592422485352
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0006 0.00061392784118652
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0005 0.0004889965057373
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
141 0.0005 0.00054097175598145
SELECT * FROM product_image_select WHERE product_id = '869'
142 0.0003 0.00034189224243164
SELECT * FROM productcustomimages WHERE product_id = '869'
143 0.0008 0.00084495544433594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
144 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0005 0.00045609474182129
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
148 0.0005 0.00054502487182617
SELECT * FROM product_image_select WHERE product_id = '878'
149 0.0003 0.00034284591674805
SELECT * FROM productcustomimages WHERE product_id = '878'
150 0.0009 0.00088310241699219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
151 0.0004 0.00044393539428711
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00038981437683105
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00049495697021484
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
155 0.0006 0.00055599212646484
SELECT * FROM product_image_select WHERE product_id = '858'
156 0.0004 0.00036287307739258
SELECT * FROM productcustomimages WHERE product_id = '858'
157 0.0009 0.00094914436340332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
158 0.0004 0.00043892860412598
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00038909912109375
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0007 0.00068807601928711
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.00061511993408203
SELECT id,asin FROM products WHERE parent_id = 4814
162 0.0020 0.0020380020141602
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4814' ORDER BY timestamp DESC
163 0.0004 0.00043606758117676
SELECT category_id FROM products_categories WHERE product_id = '4814'
164 0.0007 0.0006709098815918
SELECT * FROM categories WHERE id = '27'
165 0.0038 0.0037839412689209
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.00040316581726074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0003 0.00029706954956055
SELECT id FROM categories WHERE parent_id = '27'
168 0.0038 0.0038399696350098
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.00048303604125977
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.00051188468933105
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.00042486190795898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0009 0.00093507766723633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
173 0.0005 0.00046920776367188
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00037097930908203
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = '4814'
176 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0008 0.00078082084655762
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.00032305717468262
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00050187110900879
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00040292739868164
SELECT category_id FROM products_categories WHERE product_id = '4814' AND prod_type = 'amz'
181 0.0004 0.00038790702819824
SELECT parent_id FROM categories WHERE id = '27'
182 0.0003 0.0003361701965332
SELECT * FROM categories WHERE id = '27'
183 0.0034 0.003399133682251
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.00038409233093262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
185 0.0003 0.00030899047851562
SELECT id FROM categories WHERE parent_id = '27'
186 0.0034 0.0033881664276123
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.00049495697021484
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.00050091743469238
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.00044488906860352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
190 0.0016 0.001582145690918
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
191 0.0058 0.0058000087738037
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
192 0.0008 0.00077199935913086
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
193 0.0256 0.025640964508057
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.0022 0.0022289752960205
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.00057601928710938
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.0007 0.00067687034606934
SELECT * FROM products WHERE id = 1626
197 0.0004 0.0004417896270752
SELECT * FROM products WHERE id = 4041
198 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = 4312
199 0.0003 0.00033092498779297
SELECT * FROM products WHERE id = 777
200 0.0003 0.0003361701965332
SELECT * FROM products WHERE id = 3881
201 0.0003 0.00034785270690918
SELECT * FROM products WHERE id = 4213
202 0.0004 0.00035905838012695
SELECT * FROM products WHERE id = '1626'
203 0.0004 0.0004420280456543
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
204 0.0006 0.00055599212646484
SELECT * FROM product_image_select WHERE product_id = '1626'
205 0.0004 0.00035786628723145
SELECT * FROM productcustomimages WHERE product_id = '1626'
206 0.0008 0.00081896781921387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
207 0.0005 0.00045895576477051
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0004 0.00038909912109375
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0004 0.00042009353637695
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0005 0.00050687789916992
SELECT * FROM products WHERE id = '4041'
211 0.0004 0.00043511390686035
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
212 0.0006 0.00059914588928223
SELECT * FROM product_image_select WHERE product_id = '4041'
213 0.0004 0.00035715103149414
SELECT * FROM productcustomimages WHERE product_id = '4041'
214 0.0011 0.0011248588562012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
215 0.0005 0.00049614906311035
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0004 0.00041007995605469
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0005 0.00050902366638184
SELECT * FROM products WHERE id = '4312'
219 0.0005 0.00045490264892578
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
220 0.0006 0.0005948543548584
SELECT * FROM product_image_select WHERE product_id = '4312'
221 0.0004 0.00044584274291992
SELECT * FROM productcustomimages WHERE product_id = '4312'
222 0.0010 0.0010390281677246
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.00045299530029297
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00047612190246582
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0005 0.00050210952758789
SELECT * FROM products WHERE id = '777'
227 0.0005 0.00047802925109863
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0007 0.00068402290344238
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0004 0.00040507316589355
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0010 0.0010371208190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0006 0.00055098533630371
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0006 0.00055789947509766
SELECT * FROM products WHERE id = '3881'
235 0.0007 0.00070500373840332
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
236 0.0006 0.00061392784118652
SELECT * FROM product_image_select WHERE product_id = '3881'
237 0.0004 0.00037384033203125
SELECT * FROM productcustomimages WHERE product_id = '3881'
238 0.0010 0.00099706649780273
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.00043892860412598
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0004 0.00039410591125488
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0005 0.0004889965057373
SELECT * FROM products WHERE id = '4213'
243 0.0005 0.00046992301940918
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
244 0.0005 0.00054478645324707
SELECT * FROM product_image_select WHERE product_id = '4213'
245 0.0004 0.0003659725189209
SELECT * FROM productcustomimages WHERE product_id = '4213'
246 0.0010 0.0010321140289307
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.00042915344238281
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0004 0.00044512748718262
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0020 0.0020411014556885
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
251 0.0006 0.00061798095703125
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
252 0.0023 0.0022799968719482
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
253 0.0016 0.001629114151001
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
254 0.0005 0.00050616264343262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0008 0.000762939453125
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'