0

La Route Des Comptoirs - Rooïbos Vent D'Été Lot De 2 - BIO

Price: €13,35
Product prices and availability are accurate as of 2021-07-21 16:03:55 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.

Manufacturer Description

Des petits morceaux de mangue parsemés sur un rooïbos parfumé à la mangue libèrent une saveur douce, sucrée et tendre. Un mélange ensoleillé à apprécier à tout heure. Garanti sans théine.

Product Features

Rooïbos aromatisé Lot de 2 x 100g

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.3898150920868 268 0.7936 0


No Amazon API Requests Made.


App Debug - Total Time 1.3898150920868 seconds

Number Time From Start Name Description
1 0.37728500366211 Initialise Initialise FSB Function
2 0.38283491134644 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40942788124084 Start of getCategoryListByGroup Function Before first category groups query
4 0.41107201576233 After initial query Before first category groups query
5 0.41107392311096 Get Category List for Group Before the call to getCategoryList function
6 0.41107702255249 Start of GetCategoryList function Start of the function
7 0.41108107566833 Before getting categories Query to get specific category list
8 0.41263890266418 After getting categories Query to get specific category list
9 0.41264009475708 Before getting category custom Before call to function getCategoryCustom
10 0.4336040019989 After getting category custom After call to function getCategoryCustom
11 0.43360900878906 Before getting category custom Before call to function getCategoryCustom
12 0.44494104385376 After getting category custom After call to function getCategoryCustom
13 0.4449450969696 Before getting category custom Before call to function getCategoryCustom
14 0.45154690742493 After getting category custom After call to function getCategoryCustom
15 0.45155191421509 Before getting category custom Before call to function getCategoryCustom
16 0.45648598670959 After getting category custom After call to function getCategoryCustom
17 0.45649003982544 Before getting category custom Before call to function getCategoryCustom
18 0.46236205101013 After getting category custom After call to function getCategoryCustom
19 0.46236610412598 Before getting category custom Before call to function getCategoryCustom
20 0.46717810630798 After getting category custom After call to function getCategoryCustom
21 0.46718192100525 End of GetCategoryList function End of the function
22 0.46719002723694 Get Category List for Group Before the call to getCategoryList function
23 0.46719193458557 Start of GetCategoryList function Start of the function
24 0.4671950340271 Before getting categories Query to get specific category list
25 0.46771192550659 End of getCategoryListByGroup Function Before return()
26 0.9107449054718 App Controller End End of the App controller (called before the controller of every page)
27 0.91162490844727 Product Start Start of the product info controller
28 1.034924030304 Cache file not found Starting get product details
29 1.0810599327087 Related products Start getting related products if enabled
30 1.081062078476 Related Products Start Before the related products are found
31 1.0810630321503 Related Products Keywords Before the related product keywords are found
32 1.0810680389404 Create Keyword List Function Start of function
33 1.0811779499054 Create Keyword List Function After looping provided content - 30 keywords found
34 1.0824160575867 Create Keyword List Function After looping initial keyword list - 23 keywords remaining
35 1.0824279785156 Create Keyword List Function After reducing keyword list
36 1.0825099945068 Create Keyword List Function After selecting by scoring keywords
37 1.0825140476227 Create Keyword List Function After final loop of keywords
38 1.0825169086456 Related Products Keywords After the related product keywords are found
39 1.141154050827 Related Products End After the related products are found
40 1.2009279727936 Product End End of the product info controller (Product Info)
41 1.2028799057007 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.20680809021 Before Get Options Before the call to getOptions in the tpl class
43 1.2929699420929 After Get Options After the call to getOptions in the tpl class
44 1.2931170463562 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.2931520938873 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.3475549221039 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3475630283356 Product Info: Before Template Display Before the template is displayed
48 1.3897590637207 Product Info: After Template Display After the template is displayed
49 1.3897850513458 Finalizing debug Before the debug is output to the page.
50 1.3898129463196 End of App This is the end of the app logging, final timestamp


Query Debug - 268 Database Queries. Total time 0.7936 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0030 0.0029580593109131
SELECT parameter, value FROM parameters
2 0.0060 0.0060379505157471
SELECT * FROM `bad_bots`
3 0.0006 0.00060009956359863
SET time_zone = 'Europe/London'
4 0.0012 0.001209020614624
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0025 0.0024597644805908
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.141.19.58\";}'
6 0.0021 0.0020780563354492
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738735642'
7 0.0028 0.0028491020202637
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00072693824768066
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0029 0.0028948783874512
SELECT id FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-vent-dEte-lot-de-2-bio' LIMIT 1
10 0.0009 0.00090289115905762
SELECT id FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-vent-dEte-lot-de-2-bio' AND hidden = 0 LIMIT 1
11 0.0020 0.0019631385803223
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0235 0.023476839065552
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00049304962158203
SELECT * FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-vent-dEte-lot-de-2-bio'
14 0.0016 0.0016300678253174
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0015 0.0015339851379395
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0057 0.0056610107421875
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0021 0.0020580291748047
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.0013699531555176
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00048708915710449
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.0058529376983643
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.0018 0.0017762184143066
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.0017 0.0016520023345947
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.0014 0.0013861656188965
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00050115585327148
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037989616394043
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.0007 0.00065183639526367
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.0005 0.00048995018005371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0037221908569336
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.00055098533630371
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.0005340576171875
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.00053882598876953
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.0004429817199707
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014829635620117
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.000518798828125
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.00042009353637695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00043892860412598
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015199184417725
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.00050783157348633
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.00057411193847656
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0005 0.00049901008605957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00048494338989258
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00058913230895996
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.00048303604125977
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.00040507316589355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00040698051452637
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00078988075256348
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0006 0.00059604644775391
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.0005490779876709
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.0005 0.00049090385437012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.0004880428314209
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00072598457336426
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.0006 0.0006098747253418
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.0005 0.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0006 0.00055313110351562
SELECT id FROM categories WHERE parent_id = '30'
56 0.0012 0.0012040138244629
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0006 0.00055098533630371
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.00051403045654297
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.00054693222045898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00053811073303223
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00063896179199219
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.00047397613525391
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.00039505958557129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.0004580020904541
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00071907043457031
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.00049400329589844
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.00052285194396973
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.00056600570678711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043106079101562
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00050711631774902
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0030 0.0029821395874023
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0007 0.00069499015808105
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00059199333190918
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.0004 0.00044918060302734
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011420249938965
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010950565338135
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4300 0.4299910068512
SELECT * FROM ipgeocountries WHERE INET_ATON('3.141.19.58') >= INET_ATON(ip_start) AND INET_ATON('3.141.19.58') <= INET_ATON(ip_end)
78 0.0021 0.0020530223846436
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0013461112976074
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00088095664978027
SELECT * FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-vent-dEte-lot-de-2-bio'
81 0.0004 0.00043010711669922
UPDATE products SET viewcount = viewcount + 1 WHERE id = 906
82 0.0012 0.0012350082397461
SELECT * FROM manufacturers WHERE id = '183'
83 0.0011 0.0011429786682129
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
84 0.0037 0.0037200450897217
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '183' LIMIT 1
85 0.0036 0.0035707950592041
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '183' ORDER BY RAND() LIMIT 1
86 0.0008 0.00084209442138672
SELECT * FROM productimages WHERE product_id = '906' ORDER BY sortorder ASC
87 0.0010 0.00095200538635254
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
88 0.0010 0.0010230541229248
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '183'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0010 0.0010080337524414
SELECT * FROM manufacturerimages WHERE manufacturer_id = '183'
90 0.0008 0.00078201293945312
SELECT category_id FROM products_categories WHERE product_id = '906'
91 0.0008 0.00076603889465332
SELECT * FROM categories WHERE id = '27'
92 0.0060 0.0059740543365479
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.0007 0.00070095062255859
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0005 0.00048995018005371
SELECT id FROM categories WHERE parent_id = '27'
95 0.0059 0.0059440135955811
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.00064206123352051
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.00065493583679199
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0005 0.0005180835723877
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00051307678222656
SELECT * FROM productimages WHERE product_id = '906' ORDER BY sortorder ASC
100 0.0018 0.0018270015716553
SELECT * FROM product_image_select WHERE product_id = '906'
101 0.0015 0.0015308856964111
SELECT * FROM productcustomimages WHERE product_id = '906'
102 0.0013 0.0013449192047119
SELECT * FROM productfeeds WHERE product_id = '906' ORDER BY item_date DESC
103 0.0022 0.0022239685058594
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '906' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0016 0.0016369819641113
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '906' AND t.hidden = 0 AND display_product = 1
105 0.0012 0.0012481212615967
SELECT * FROM productamazoncontent WHERE product_id = '906'
106 0.0011 0.0010919570922852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '906' AND a.name = n.originalname
107 0.0013 0.0013341903686523
SELECT * FROM productoffers WHERE product_id = '906' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00044107437133789
SELECT * FROM productoffers
                WHERE product_id = '906' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = 906
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00054407119750977
SELECT value FROM productattributes
                WHERE product_id = '906'
                AND name = 'ListPriceAmount'
111 0.0005 0.00047397613525391
SELECT value FROM productattributes WHERE product_id = '906' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.0005040168762207
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.0092 0.0092270374298096
SELECT *, MATCH (description, title) AGAINST ('comptoirs rooÃbos vent' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('comptoirs rooÃbos vent' IN BOOLEAN MODE) AND 906 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0009 0.0009150505065918
SELECT *, MATCH (description, title) AGAINST ('comptoirs rooÃbos vent' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('comptoirs rooÃbos vent' IN BOOLEAN MODE) AND 906 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0008 0.00077295303344727
SELECT *, MATCH (description, title) AGAINST ('comptoirs rooÃbos vent' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('comptoirs rooÃbos vent' IN BOOLEAN MODE) AND 906 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0005 0.00054311752319336
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
117 0.0006 0.00060415267944336
SELECT * FROM product_image_select WHERE product_id = '1093'
118 0.0004 0.00041508674621582
SELECT * FROM productcustomimages WHERE product_id = '1093'
119 0.0008 0.00083708763122559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
120 0.0005 0.00050115585327148
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0005 0.00046610832214355
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
124 0.0006 0.0005800724029541
SELECT * FROM product_image_select WHERE product_id = '4905'
125 0.0004 0.00039100646972656
SELECT * FROM productcustomimages WHERE product_id = '4905'
126 0.0012 0.0012199878692627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
127 0.0006 0.0006260871887207
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0005 0.00054407119750977
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0014 0.0013718605041504
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '906') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
131 0.0114 0.011366128921509
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz'  AND p.id <> '906' ORDER BY RAND()
132 0.0009 0.00085306167602539
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '906' ORDER BY RAND()
133 0.0005 0.00053787231445312
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '906' ORDER BY RAND()
134 0.0005 0.00049519538879395
SELECT * FROM productimages WHERE product_id = '940' ORDER BY sortorder ASC
135 0.0006 0.0006110668182373
SELECT * FROM product_image_select WHERE product_id = '940'
136 0.0005 0.00050711631774902
SELECT * FROM productcustomimages WHERE product_id = '940'
137 0.0010 0.0009760856628418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '940' AND a.name = n.originalname
138 0.0005 0.00054788589477539
SELECT * FROM productoffers WHERE product_id = '940' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0004 0.00043678283691406
SELECT * FROM productoffers
                WHERE product_id = '940' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = 940
                ORDER BY price ASC LIMIT 1
141 0.0004 0.00043988227844238
SELECT value FROM productattributes
                WHERE product_id = '940'
                AND name = 'ListPriceAmount'
142 0.0006 0.00055122375488281
SELECT value FROM productattributes WHERE product_id = '940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0006 0.0005640983581543
SELECT * FROM productimages WHERE product_id = '1270' ORDER BY sortorder ASC
144 0.0007 0.00066590309143066
SELECT * FROM product_image_select WHERE product_id = '1270'
145 0.0004 0.00044393539428711
SELECT * FROM productcustomimages WHERE product_id = '1270'
146 0.0013 0.0013060569763184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1270' AND a.name = n.originalname
147 0.0005 0.00054407119750977
SELECT * FROM productoffers WHERE product_id = '1270' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '1270' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0004 0.00041294097900391
SELECT * FROM productoffers
                WHERE product_id = 1270
                ORDER BY price ASC LIMIT 1
150 0.0005 0.00045204162597656
SELECT value FROM productattributes
                WHERE product_id = '1270'
                AND name = 'ListPriceAmount'
151 0.0005 0.00051498413085938
SELECT value FROM productattributes WHERE product_id = '1270' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0006 0.00055289268493652
SELECT * FROM productimages WHERE product_id = '2235' ORDER BY sortorder ASC
153 0.0008 0.00084805488586426
SELECT * FROM product_image_select WHERE product_id = '2235'
154 0.0005 0.00048494338989258
SELECT * FROM productcustomimages WHERE product_id = '2235'
155 0.0010 0.00096797943115234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2235' AND a.name = n.originalname
156 0.0006 0.00056600570678711
SELECT * FROM productoffers WHERE product_id = '2235' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.00048112869262695
SELECT * FROM productoffers
                WHERE product_id = '2235' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = 2235
                ORDER BY price ASC LIMIT 1
159 0.0004 0.00043678283691406
SELECT value FROM productattributes
                WHERE product_id = '2235'
                AND name = 'ListPriceAmount'
160 0.0005 0.00053596496582031
SELECT value FROM productattributes WHERE product_id = '2235' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00054407119750977
SELECT * FROM productimages WHERE product_id = '859' ORDER BY sortorder ASC
162 0.0007 0.00073099136352539
SELECT * FROM product_image_select WHERE product_id = '859'
163 0.0005 0.00047206878662109
SELECT * FROM productcustomimages WHERE product_id = '859'
164 0.0012 0.0011749267578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '859' AND a.name = n.originalname
165 0.0006 0.00059795379638672
SELECT * FROM productoffers WHERE product_id = '859' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0005 0.00046682357788086
SELECT * FROM productoffers
                WHERE product_id = '859' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0004 0.00041294097900391
SELECT * FROM productoffers
                WHERE product_id = 859
                ORDER BY price ASC LIMIT 1
168 0.0005 0.00053811073303223
SELECT value FROM productattributes
                WHERE product_id = '859'
                AND name = 'ListPriceAmount'
169 0.0006 0.00058102607727051
SELECT value FROM productattributes WHERE product_id = '859' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0007 0.00074410438537598
SELECT id,asin FROM products WHERE parent_id = 906
171 0.0040 0.0040490627288818
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '906' ORDER BY timestamp DESC
172 0.0018 0.0017719268798828
SELECT category_id FROM products_categories WHERE product_id = '906'
173 0.0020 0.0020411014556885
SELECT * FROM categories WHERE id = '27'
174 0.0110 0.010979175567627
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
175 0.0007 0.00071096420288086
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
176 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '27'
177 0.0062 0.0062329769134521
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 
178 0.0008 0.00082206726074219
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 
179 0.0008 0.0007631778717041
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
180 0.0006 0.00058817863464355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
181 0.0014 0.0013890266418457
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '906' AND a.name = n.originalname
182 0.0006 0.00055408477783203
SELECT * FROM productoffers WHERE product_id = '906' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0005 0.00054621696472168
SELECT * FROM productoffers
                WHERE product_id = '906' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0006 0.00057888031005859
SELECT * FROM productoffers
                WHERE product_id = 906
                ORDER BY price ASC LIMIT 1
185 0.0007 0.00066685676574707
SELECT value FROM productattributes
                WHERE product_id = '906'
                AND name = 'ListPriceAmount'
186 0.0010 0.00097084045410156
SELECT * FROM products WHERE id = '906'
187 0.0006 0.00057291984558105
SELECT value FROM productattributes WHERE product_id = '906' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0012 0.0012259483337402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '906' AND a.name = n.originalname
189 0.0004 0.00043511390686035
SELECT * FROM productoffers WHERE product_id = '906' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '906' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0005 0.00046682357788086
SELECT * FROM productoffers
                WHERE product_id = 906
                ORDER BY price ASC LIMIT 1
192 0.0006 0.00055813789367676
SELECT value FROM productattributes
                WHERE product_id = '906'
                AND name = 'ListPriceAmount'
193 0.0008 0.00079703330993652
SELECT category_id FROM products_categories WHERE product_id = '906' AND prod_type = 'amz'
194 0.0005 0.00053811073303223
SELECT parent_id FROM categories WHERE id = '27'
195 0.0005 0.00047087669372559
SELECT * FROM categories WHERE id = '27'
196 0.0051 0.0050539970397949
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
197 0.0006 0.00056099891662598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
198 0.0005 0.00049591064453125
SELECT id FROM categories WHERE parent_id = '27'
199 0.0051 0.0051059722900391
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 
200 0.0030 0.0030319690704346
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 
201 0.0029 0.0029139518737793
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
202 0.0017 0.0016889572143555
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
203 0.0010 0.00096797943115234
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
204 0.0031 0.003140926361084
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
205 0.0006 0.00061511993408203
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
206 0.0275 0.027509927749634
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
207 0.0028 0.0027670860290527
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
208 0.0009 0.00093698501586914
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
209 0.0008 0.00083708763122559
SELECT * FROM products WHERE id = 1626
210 0.0007 0.00071501731872559
SELECT * FROM products WHERE id = 4041
211 0.0008 0.00082111358642578
SELECT * FROM products WHERE id = 4312
212 0.0009 0.00085711479187012
SELECT * FROM products WHERE id = 777
213 0.0008 0.00081896781921387
SELECT * FROM products WHERE id = 3881
214 0.0011 0.001147985458374
SELECT * FROM products WHERE id = 4213
215 0.0009 0.00088191032409668
SELECT * FROM products WHERE id = '1626'
216 0.0012 0.0012478828430176
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
217 0.0010 0.0010368824005127
SELECT * FROM product_image_select WHERE product_id = '1626'
218 0.0006 0.00059199333190918
SELECT * FROM productcustomimages WHERE product_id = '1626'
219 0.0019 0.0018751621246338
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
220 0.0008 0.00076699256896973
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0010 0.0010268688201904
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0006 0.0006248950958252
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0008 0.00081014633178711
SELECT * FROM products WHERE id = '4041'
224 0.0006 0.00056600570678711
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
225 0.0007 0.00073790550231934
SELECT * FROM product_image_select WHERE product_id = '4041'
226 0.0005 0.00050997734069824
SELECT * FROM productcustomimages WHERE product_id = '4041'
227 0.0016 0.0015969276428223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
228 0.0007 0.00066494941711426
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0006 0.00056004524230957
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0006 0.0006411075592041
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0014 0.0014081001281738
SELECT * FROM products WHERE id = '4312'
232 0.0007 0.00071907043457031
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
233 0.0007 0.00071001052856445
SELECT * FROM product_image_select WHERE product_id = '4312'
234 0.0005 0.00050711631774902
SELECT * FROM productcustomimages WHERE product_id = '4312'
235 0.0016 0.0015959739685059
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
236 0.0006 0.00062203407287598
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0008 0.00076580047607422
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0005 0.00052213668823242
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0006 0.0006411075592041
SELECT * FROM products WHERE id = '777'
240 0.0006 0.00055480003356934
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
241 0.0007 0.00066709518432617
SELECT * FROM product_image_select WHERE product_id = '777'
242 0.0007 0.00065398216247559
SELECT * FROM productcustomimages WHERE product_id = '777'
243 0.0014 0.0014069080352783
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
244 0.0006 0.00055098533630371
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0006 0.00057291984558105
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0005 0.00049185752868652
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0007 0.00067400932312012
SELECT * FROM products WHERE id = '3881'
248 0.0007 0.00074982643127441
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
249 0.0006 0.00059986114501953
SELECT * FROM product_image_select WHERE product_id = '3881'
250 0.0004 0.00044822692871094
SELECT * FROM productcustomimages WHERE product_id = '3881'
251 0.0018 0.0017549991607666
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
252 0.0006 0.00055789947509766
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0006 0.00058388710021973
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0008 0.00075888633728027
SELECT * FROM products WHERE id = '4213'
256 0.0009 0.00091695785522461
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
257 0.0007 0.00074505805969238
SELECT * FROM product_image_select WHERE product_id = '4213'
258 0.0005 0.00053095817565918
SELECT * FROM productcustomimages WHERE product_id = '4213'
259 0.0027 0.0027408599853516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
260 0.0006 0.00064587593078613
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0006 0.00057101249694824
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0007 0.00065183639526367
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0012 0.0012059211730957
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
264 0.0012 0.0011758804321289
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
265 0.0023 0.0023429393768311
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
266 0.0009 0.00091886520385742
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
267 0.0007 0.00073003768920898
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
268 0.0010 0.00099778175354004
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'