0

La Route Des Comptoirs - Rooïbos Tropical Lot De 2 - BIO

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-18 00:07:41 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

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.628839969635 267 1.1682 0


No Amazon API Requests Made.


App Debug - Total Time 1.628839969635 seconds

Number Time From Start Name Description
1 0.25348091125488 Initialise Initialise FSB Function
2 0.25704789161682 App Controller Start Start of the App controller (called before the controller of every page)
3 0.28634405136108 Start of getCategoryListByGroup Function Before first category groups query
4 0.2874128818512 After initial query Before first category groups query
5 0.2874128818512 Get Category List for Group Before the call to getCategoryList function
6 0.28741598129272 Start of GetCategoryList function Start of the function
7 0.28741693496704 Before getting categories Query to get specific category list
8 0.28847098350525 After getting categories Query to get specific category list
9 0.28847098350525 Before getting category custom Before call to function getCategoryCustom
10 0.30745887756348 After getting category custom After call to function getCategoryCustom
11 0.30746006965637 Before getting category custom Before call to function getCategoryCustom
12 0.31817007064819 After getting category custom After call to function getCategoryCustom
13 0.31817197799683 Before getting category custom Before call to function getCategoryCustom
14 0.3240978717804 After getting category custom After call to function getCategoryCustom
15 0.32410001754761 Before getting category custom Before call to function getCategoryCustom
16 0.32786989212036 After getting category custom After call to function getCategoryCustom
17 0.32787108421326 Before getting category custom Before call to function getCategoryCustom
18 0.33168196678162 After getting category custom After call to function getCategoryCustom
19 0.33168292045593 Before getting category custom Before call to function getCategoryCustom
20 0.33539891242981 After getting category custom After call to function getCategoryCustom
21 0.33540010452271 End of GetCategoryList function End of the function
22 0.33540487289429 Get Category List for Group Before the call to getCategoryList function
23 0.3354070186615 Start of GetCategoryList function Start of the function
24 0.33540797233582 Before getting categories Query to get specific category list
25 0.33583498001099 End of getCategoryListByGroup Function Before return()
26 1.2789349555969 App Controller End End of the App controller (called before the controller of every page)
27 1.2794959545135 Product Start Start of the product info controller
28 1.2812869548798 Cache file not found Starting get product details
29 1.3024070262909 Related products Start getting related products if enabled
30 1.3024070262909 Related Products Start Before the related products are found
31 1.3024079799652 Related Products Keywords Before the related product keywords are found
32 1.3024110794067 Create Keyword List Function Start of function
33 1.3024919033051 Create Keyword List Function After looping provided content - 27 keywords found
34 1.3028938770294 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 1.3028979301453 Create Keyword List Function After reducing keyword list
36 1.3029239177704 Create Keyword List Function After selecting by scoring keywords
37 1.3029270172119 Create Keyword List Function After final loop of keywords
38 1.3029270172119 Related Products Keywords After the related product keywords are found
39 1.3419630527496 Related Products End After the related products are found
40 1.371640920639 Product End End of the product info controller (Product Info)
41 1.3733389377594 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3744471073151 Before Get Options Before the call to getOptions in the tpl class
43 1.4201819896698 After Get Options After the call to getOptions in the tpl class
44 1.4202990531921 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4203219413757 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.501128911972 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5011320114136 Product Info: Before Template Display Before the template is displayed
48 1.6288199424744 Product Info: After Template Display After the template is displayed
49 1.6288299560547 Finalizing debug Before the debug is output to the page.
50 1.628839969635 End of App This is the end of the app logging, final timestamp


Query Debug - 267 Database Queries. Total time 1.1682 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.0012068748474121
SELECT parameter, value FROM parameters
2 0.0031 0.0031068325042725
SELECT * FROM `bad_bots`
3 0.0003 0.00029897689819336
SET time_zone = 'Europe/London'
4 0.0010 0.0010499954223633
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0013 0.0012960433959961
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.149\";}'
6 0.0010 0.00097799301147461
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751466721'
7 0.0019 0.0018520355224609
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00040102005004883
UPDATE autorun SET lastrun = '2025-07-02 14:32:01' WHERE id = '13'
9 0.0004 0.00043296813964844
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0013 0.0012581348419189
SELECT id FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio' LIMIT 1
11 0.0013 0.0012729167938232
SELECT id FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio' AND hidden = 0 LIMIT 1
12 0.0018 0.0017750263214111
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0265 0.026518821716309
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00059604644775391
SELECT * FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio'
15 0.0011 0.0010650157928467
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0010 0.0010411739349365
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0068 0.0068449974060059
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0015 0.0015020370483398
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0010 0.00097894668579102
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00039505958557129
SELECT id FROM categories WHERE parent_id = '26'
21 0.0053 0.0053031444549561
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0013 0.0012850761413574
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0012 0.0011680126190186
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0011 0.001101016998291
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00032186508178711
SELECT * FROM categorygroups WHERE id = '1'
26 0.0038 0.0037970542907715
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0005 0.00046491622924805
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00036287307739258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00035285949707031
SELECT id FROM categories WHERE parent_id = '27'
30 0.0040 0.0039858818054199
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0005 0.00048184394836426
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0005 0.00046396255493164
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0004 0.00041794776916504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00035309791564941
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0013570785522461
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0004 0.00037503242492676
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00032687187194824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0017430782318115
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0004 0.00040507316589355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0004 0.00043201446533203
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0004 0.00039196014404297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00049710273742676
SELECT * FROM categorygroups WHERE id = '1'
44 0.0004 0.00044608116149902
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0004 0.00038003921508789
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0003 0.00034999847412109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00037312507629395
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00064587593078613
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0004 0.0004429817199707
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0004 0.0003960132598877
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0004 0.00038790702819824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.0003049373626709
SELECT * FROM categorygroups WHERE id = '1'
53 0.0004 0.00044703483581543
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0004 0.00040102005004883
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00031208992004395
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00036001205444336
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00058507919311523
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0005 0.00048494338989258
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0005 0.00046205520629883
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0004 0.00036406517028809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00034904479980469
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.00048708915710449
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.00033402442932129
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0003 0.00032782554626465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00036287307739258
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00062704086303711
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0004 0.00037717819213867
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0004 0.00042009353637695
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0004 0.00038790702819824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00034594535827637
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00042104721069336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0028 0.0028119087219238
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0014 0.0013771057128906
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00045895576477051
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0009 0.00093388557434082
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0013 0.0013160705566406
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0007 0.0006718635559082
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.9315 0.93146800994873
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.149') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.149') <= INET_ATON(ip_end)
79 0.0017 0.0016820430755615
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0008 0.00081706047058105
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0005 0.00046801567077637
SELECT * FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio'
82 0.0003 0.00029516220092773
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1109
83 0.0004 0.00039410591125488
SELECT * FROM manufacturers WHERE id = '183'
84 0.0004 0.00040602684020996
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
85 0.0009 0.00093889236450195
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '183' LIMIT 1
86 0.0009 0.00094699859619141
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
87 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '1099' ORDER BY sortorder ASC
88 0.0003 0.00029897689819336
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
89 0.0003 0.00030279159545898
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 
90 0.0003 0.00026488304138184
SELECT * FROM manufacturerimages WHERE manufacturer_id = '183'
91 0.0003 0.00030517578125
SELECT category_id FROM products_categories WHERE product_id = '1109'
92 0.0003 0.00031900405883789
SELECT * FROM categories WHERE id = '27'
93 0.0032 0.0031509399414062
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
94 0.0003 0.00029993057250977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '27'
96 0.0031 0.0031211376190186
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
97 0.0004 0.00039005279541016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
98 0.0004 0.00037002563476562
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
99 0.0003 0.00033092498779297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0003 0.00034904479980469
SELECT * FROM productimages WHERE product_id = '1109' ORDER BY sortorder ASC
101 0.0011 0.001054048538208
SELECT * FROM product_image_select WHERE product_id = '1109'
102 0.0006 0.00060915946960449
SELECT * FROM productcustomimages WHERE product_id = '1109'
103 0.0006 0.00062894821166992
SELECT * FROM productfeeds WHERE product_id = '1109' ORDER BY item_date DESC
104 0.0011 0.0011289119720459
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0010 0.0010409355163574
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1109' AND t.hidden = 0 AND display_product = 1
106 0.0008 0.00084996223449707
SELECT * FROM productamazoncontent WHERE product_id = '1109'
107 0.0006 0.00063514709472656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
108 0.0007 0.00070309638977051
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0003 0.00026512145996094
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
111 0.0003 0.00033998489379883
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
112 0.0003 0.00029206275939941
SELECT value FROM productattributes WHERE product_id = '1109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0003 0.00033020973205566
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
114 0.0063 0.0063290596008301
SELECT *, MATCH (description, title) AGAINST ('comptoirs rooÃbos tropical' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('comptoirs rooÃbos tropical' IN BOOLEAN MODE) AND 1109 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0005 0.00048708915710449
SELECT *, MATCH (description, title) AGAINST ('comptoirs rooÃbos tropical' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('comptoirs rooÃbos tropical' IN BOOLEAN MODE) AND 1109 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0004 0.00038790702819824
SELECT *, MATCH (description, title) AGAINST ('comptoirs rooÃbos tropical' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('comptoirs rooÃbos tropical' IN BOOLEAN MODE) AND 1109 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0004 0.00035500526428223
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
118 0.0005 0.00050902366638184
SELECT * FROM product_image_select WHERE product_id = '4905'
119 0.0003 0.00031089782714844
SELECT * FROM productcustomimages WHERE product_id = '4905'
120 0.0009 0.00094294548034668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
121 0.0004 0.00037217140197754
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0003 0.00028395652770996
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0003 0.00028109550476074
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0003 0.00032711029052734
SELECT * FROM productimages WHERE product_id = '1278' ORDER BY sortorder ASC
125 0.0005 0.0005340576171875
SELECT * FROM product_image_select WHERE product_id = '1278'
126 0.0003 0.00034117698669434
SELECT * FROM productcustomimages WHERE product_id = '1278'
127 0.0007 0.00070381164550781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1278' AND a.name = n.originalname
128 0.0004 0.00036811828613281
SELECT * FROM productoffers WHERE product_id = '1278' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0003 0.00034093856811523
SELECT * FROM productoffers
                WHERE product_id = '1278' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0003 0.00029897689819336
SELECT value FROM productattributes WHERE product_id = '1278' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0003 0.00034308433532715
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
132 0.0005 0.00051093101501465
SELECT * FROM product_image_select WHERE product_id = '1093'
133 0.0003 0.00029397010803223
SELECT * FROM productcustomimages WHERE product_id = '1093'
134 0.0006 0.00055789947509766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
135 0.0004 0.00037312507629395
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0003 0.00031399726867676
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0003 0.00029397010803223
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0007 0.0007021427154541
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1109') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
139 0.0088 0.0088379383087158
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 <> '1109' ORDER BY RAND()
140 0.0006 0.00056195259094238
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 <> '1109' ORDER BY RAND()
141 0.0004 0.00041294097900391
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 <> '1109' ORDER BY RAND()
142 0.0004 0.0003960132598877
SELECT * FROM productimages WHERE product_id = '1068' ORDER BY sortorder ASC
143 0.0006 0.00059294700622559
SELECT * FROM product_image_select WHERE product_id = '1068'
144 0.0004 0.00038313865661621
SELECT * FROM productcustomimages WHERE product_id = '1068'
145 0.0008 0.00075507164001465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1068' AND a.name = n.originalname
146 0.0004 0.00037884712219238
SELECT * FROM productoffers WHERE product_id = '1068' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0003 0.00030183792114258
SELECT * FROM productoffers
                WHERE product_id = '1068' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0003 0.00028610229492188
SELECT * FROM productoffers
                WHERE product_id = 1068
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00029802322387695
SELECT value FROM productattributes
                WHERE product_id = '1068'
                AND name = 'ListPriceAmount'
150 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '1068' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0004 0.00036096572875977
SELECT * FROM productimages WHERE product_id = '4259' ORDER BY sortorder ASC
152 0.0006 0.00064706802368164
SELECT * FROM product_image_select WHERE product_id = '4259'
153 0.0004 0.00036787986755371
SELECT * FROM productcustomimages WHERE product_id = '4259'
154 0.0008 0.00083804130554199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4259' AND a.name = n.originalname
155 0.0004 0.00035214424133301
SELECT * FROM productoffers WHERE product_id = '4259' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00027298927307129
SELECT * FROM productoffers
                WHERE product_id = '4259' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0003 0.00027084350585938
SELECT * FROM productoffers
                WHERE product_id = 4259
                ORDER BY price ASC LIMIT 1
158 0.0003 0.00030684471130371
SELECT value FROM productattributes
                WHERE product_id = '4259'
                AND name = 'ListPriceAmount'
159 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '4259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0004 0.0003960132598877
SELECT * FROM productimages WHERE product_id = '2379' ORDER BY sortorder ASC
161 0.0006 0.0005650520324707
SELECT * FROM product_image_select WHERE product_id = '2379'
162 0.0003 0.00031399726867676
SELECT * FROM productcustomimages WHERE product_id = '2379'
163 0.0007 0.00066995620727539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2379' AND a.name = n.originalname
164 0.0004 0.00040388107299805
SELECT * FROM productoffers WHERE product_id = '2379' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '2379' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = 2379
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00029897689819336
SELECT value FROM productattributes
                WHERE product_id = '2379'
                AND name = 'ListPriceAmount'
168 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '2379' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0004 0.00036501884460449
SELECT id,asin FROM products WHERE parent_id = 1109
170 0.0012 0.0011661052703857
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1109' ORDER BY timestamp DESC
171 0.0004 0.00037598609924316
SELECT category_id FROM products_categories WHERE product_id = '1109'
172 0.0004 0.00037598609924316
SELECT * FROM categories WHERE id = '27'
173 0.0047 0.0046701431274414
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
174 0.0004 0.00035619735717773
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
175 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '27'
176 0.0044 0.0043659210205078
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 
177 0.0005 0.00045204162597656
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 
178 0.0004 0.00043892860412598
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
179 0.0004 0.0003669261932373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
180 0.0008 0.00075697898864746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
181 0.0004 0.00036883354187012
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0003 0.0003349781036377
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0002 0.000244140625
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
184 0.0003 0.00026702880859375
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
185 0.0004 0.00039911270141602
SELECT * FROM products WHERE id = '1109'
186 0.0003 0.00031304359436035
SELECT value FROM productattributes WHERE product_id = '1109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0006 0.00060391426086426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
188 0.0003 0.00030303001403809
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0003 0.00031399726867676
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
191 0.0003 0.00026106834411621
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
192 0.0003 0.00034880638122559
SELECT category_id FROM products_categories WHERE product_id = '1109' AND prod_type = 'amz'
193 0.0003 0.00031089782714844
SELECT parent_id FROM categories WHERE id = '27'
194 0.0002 0.00024104118347168
SELECT * FROM categories WHERE id = '27'
195 0.0045 0.0044980049133301
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
196 0.0003 0.00032901763916016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
197 0.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '27'
198 0.0046 0.004551887512207
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 
199 0.0004 0.00042295455932617
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 
200 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
201 0.0004 0.00037693977355957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
202 0.0012 0.0012199878692627
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
203 0.0008 0.0007781982421875
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
204 0.0003 0.00028896331787109
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
205 0.0174 0.017360210418701
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
206 0.0013 0.0012509822845459
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
207 0.0004 0.00043892860412598
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
208 0.0004 0.00042009353637695
SELECT * FROM products WHERE id = 1626
209 0.0003 0.00030207633972168
SELECT * FROM products WHERE id = 4041
210 0.0003 0.00029587745666504
SELECT * FROM products WHERE id = 4312
211 0.0003 0.0002739429473877
SELECT * FROM products WHERE id = 777
212 0.0003 0.00034689903259277
SELECT * FROM products WHERE id = 3881
213 0.0003 0.00028014183044434
SELECT * FROM products WHERE id = 4213
214 0.0003 0.00028610229492188
SELECT * FROM products WHERE id = '1626'
215 0.0003 0.00034093856811523
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
216 0.0006 0.00060486793518066
SELECT * FROM product_image_select WHERE product_id = '1626'
217 0.0004 0.0003819465637207
SELECT * FROM productcustomimages WHERE product_id = '1626'
218 0.0008 0.00075507164001465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
219 0.0004 0.00036501884460449
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00031185150146484
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = '4041'
223 0.0004 0.00035500526428223
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
224 0.0006 0.00055909156799316
SELECT * FROM product_image_select WHERE product_id = '4041'
225 0.0003 0.00030016899108887
SELECT * FROM productcustomimages WHERE product_id = '4041'
226 0.0009 0.00094509124755859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
227 0.0004 0.00035881996154785
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0003 0.00029182434082031
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0003 0.00033283233642578
SELECT * FROM products WHERE id = '4312'
231 0.0003 0.00031089782714844
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
232 0.0005 0.00045514106750488
SELECT * FROM product_image_select WHERE product_id = '4312'
233 0.0003 0.00028896331787109
SELECT * FROM productcustomimages WHERE product_id = '4312'
234 0.0007 0.0006718635559082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
235 0.0004 0.00035214424133301
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0003 0.00032210350036621
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0004 0.00035715103149414
SELECT * FROM products WHERE id = '777'
239 0.0003 0.00033903121948242
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
240 0.0005 0.00046396255493164
SELECT * FROM product_image_select WHERE product_id = '777'
241 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '777'
242 0.0007 0.00065779685974121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
243 0.0003 0.0003209114074707
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00028109550476074
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0003 0.00033688545227051
SELECT * FROM products WHERE id = '3881'
247 0.0003 0.00034689903259277
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
248 0.0005 0.00045609474182129
SELECT * FROM product_image_select WHERE product_id = '3881'
249 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '3881'
250 0.0007 0.0007171630859375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
251 0.0003 0.00033807754516602
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0003 0.00033307075500488
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0003 0.00027179718017578
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0003 0.00034093856811523
SELECT * FROM products WHERE id = '4213'
255 0.0004 0.00035214424133301
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
256 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '4213'
257 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '4213'
258 0.0007 0.00070905685424805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
259 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0012 0.0011610984802246
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
263 0.0005 0.00049209594726562
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
264 0.0015 0.0015339851379395
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
265 0.0009 0.00085902214050293
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0004 0.00035905838012695
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
267 0.0006 0.00062799453735352
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'