0

JARDINS DE GAÏA - Bonne espérance (Gingembre) Sachet de 100 g - Rooibos parfumé

Price: €8,11
Product prices and availability are accurate as of 2022-06-26 14:09:22 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.

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.5720970630646 261 1.1435 0


No Amazon API Requests Made.


App Debug - Total Time 1.5720970630646 seconds

Number Time From Start Name Description
1 0.3937201499939 Initialise Initialise FSB Function
2 0.40160608291626 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43721199035645 Start of getCategoryListByGroup Function Before first category groups query
4 0.43906807899475 After initial query Before first category groups query
5 0.43906998634338 Get Category List for Group Before the call to getCategoryList function
6 0.4390721321106 Start of GetCategoryList function Start of the function
7 0.43907403945923 Before getting categories Query to get specific category list
8 0.4404821395874 After getting categories Query to get specific category list
9 0.44048309326172 Before getting category custom Before call to function getCategoryCustom
10 0.46990704536438 After getting category custom After call to function getCategoryCustom
11 0.46991014480591 Before getting category custom Before call to function getCategoryCustom
12 0.48279714584351 After getting category custom After call to function getCategoryCustom
13 0.48279905319214 Before getting category custom Before call to function getCategoryCustom
14 0.49159502983093 After getting category custom After call to function getCategoryCustom
15 0.49159598350525 Before getting category custom Before call to function getCategoryCustom
16 0.49786996841431 After getting category custom After call to function getCategoryCustom
17 0.49787092208862 Before getting category custom Before call to function getCategoryCustom
18 0.50313401222229 After getting category custom After call to function getCategoryCustom
19 0.50313496589661 Before getting category custom Before call to function getCategoryCustom
20 0.51182699203491 After getting category custom After call to function getCategoryCustom
21 0.51183009147644 End of GetCategoryList function End of the function
22 0.51183700561523 Get Category List for Group Before the call to getCategoryList function
23 0.51183915138245 Start of GetCategoryList function Start of the function
24 0.51184010505676 Before getting categories Query to get specific category list
25 0.51284098625183 End of getCategoryListByGroup Function Before return()
26 1.3038611412048 App Controller End End of the App controller (called before the controller of every page)
27 1.3044099807739 Product Start Start of the product info controller
28 1.312716960907 Cache file not found Starting get product details
29 1.3630139827728 Related products Start getting related products if enabled
30 1.3630139827728 Related Products Start Before the related products are found
31 1.3630149364471 Related Products Keywords Before the related product keywords are found
32 1.3630199432373 Create Keyword List Function Start of function
33 1.3630840778351 Create Keyword List Function After looping provided content - 32 keywords found
34 1.363657951355 Create Keyword List Function After looping initial keyword list - 29 keywords remaining
35 1.363664150238 Create Keyword List Function After reducing keyword list
36 1.3637099266052 Create Keyword List Function After selecting by scoring keywords
37 1.3637130260468 Create Keyword List Function After final loop of keywords
38 1.3637130260468 Related Products Keywords After the related product keywords are found
39 1.4116349220276 Related Products End After the related products are found
40 1.4637050628662 Product End End of the product info controller (Product Info)
41 1.4667830467224 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4689829349518 Before Get Options Before the call to getOptions in the tpl class
43 1.5269200801849 After Get Options After the call to getOptions in the tpl class
44 1.5270581245422 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5270791053772 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5545020103455 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5545060634613 Product Info: Before Template Display Before the template is displayed
48 1.5720789432526 Product Info: After Template Display After the template is displayed
49 1.5720880031586 Finalizing debug Before the debug is output to the page.
50 1.5720970630646 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 1.1435 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0016 0.0016281604766846
SELECT parameter, value FROM parameters
2 0.0074 0.0073609352111816
SELECT * FROM `bad_bots`
3 0.0003 0.00034999847412109
SET time_zone = 'Europe/London'
4 0.0022 0.002202033996582
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0027 0.0027360916137695
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.135.196.46\";}'
6 0.0031 0.0030591487884521
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1741861769'
7 0.0045 0.0044901371002197
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0031 0.003075122833252
UPDATE autorun SET lastrun = '2025-03-13 10:29:29' WHERE id = '8'
9 0.0009 0.00089716911315918
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0033 0.0033190250396729
SELECT id FROM pages WHERE pagename = 'jardins-de-gaa-bonne-esperance-gingembre-sachet-de-100-g-rooibos' LIMIT 1
11 0.0031 0.0030829906463623
SELECT id FROM products WHERE pagename = 'jardins-de-gaa-bonne-esperance-gingembre-sachet-de-100-g-rooibos' AND hidden = 0 LIMIT 1
12 0.0070 0.0070080757141113
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0275 0.027513027191162
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.0006251335144043
SELECT * FROM pages WHERE pagename = 'jardins-de-gaa-bonne-esperance-gingembre-sachet-de-100-g-rooibos'
15 0.0018 0.001845121383667
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0014 0.0013890266418457
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0091 0.0090658664703369
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.0031 0.00307297706604
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.0022 0.0022308826446533
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00043511390686035
SELECT id FROM categories WHERE parent_id = '26'
21 0.0078 0.0077669620513916
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.0018 0.0017812252044678
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.0028 0.0027568340301514
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.0017 0.0017099380493164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00049495697021484
SELECT * FROM categorygroups WHERE id = '1'
26 0.0041 0.0040619373321533
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.00046420097351074
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.00036883354187012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00042986869812012
SELECT id FROM categories WHERE parent_id = '27'
30 0.0053 0.0053141117095947
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.0007 0.00069499015808105
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.0006 0.00064587593078613
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.0005 0.00046110153198242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00038409233093262
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0015761852264404
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.0005 0.00046014785766602
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.0005 0.00054097175598145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00044679641723633
SELECT id FROM categories WHERE parent_id = '28'
39 0.0028 0.0028290748596191
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.0010 0.00096011161804199
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.0007 0.00071406364440918
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.0007 0.00072288513183594
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00051498413085938
SELECT * FROM categorygroups WHERE id = '1'
44 0.0008 0.00078701972961426
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.0005 0.00048494338989258
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.0005 0.00053882598876953
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00045299530029297
SELECT id FROM categories WHERE parent_id = '29'
48 0.0017 0.0016589164733887
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.0007 0.00066590309143066
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.0006 0.00060701370239258
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.0005 0.00053215026855469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00051999092102051
SELECT * FROM categorygroups WHERE id = '1'
53 0.0008 0.00084996223449707
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.0006 0.00061893463134766
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.0004 0.00041723251342773
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00043702125549316
SELECT id FROM categories WHERE parent_id = '30'
57 0.0009 0.00088000297546387
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.0006 0.00057697296142578
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.0006 0.00062108039855957
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.0005 0.00047993659973145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00036096572875977
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00066685676574707
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.0004 0.00041389465332031
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.0004 0.00035476684570312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00037097930908203
SELECT id FROM categories WHERE parent_id = '31'
66 0.0024 0.0023670196533203
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.0012 0.001237154006958
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.0013 0.0013079643249512
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.0010 0.00096392631530762
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0009 0.00094294548034668
SELECT * FROM categorygroups WHERE id = '1'
71 0.0010 0.00099301338195801
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0081 0.008065938949585
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0047 0.0047318935394287
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0010 0.0010378360748291
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.0031 0.0030670166015625
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0024 0.0023810863494873
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0015 0.0015459060668945
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7651 0.76509213447571
SELECT * FROM ipgeocountries WHERE INET_ATON('3.135.196.46') >= INET_ATON(ip_start) AND INET_ATON('3.135.196.46') <= INET_ATON(ip_end)
79 0.0022 0.0021579265594482
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0013 0.0013411045074463
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00060606002807617
SELECT * FROM products WHERE pagename = 'jardins-de-gaa-bonne-esperance-gingembre-sachet-de-100-g-rooibos'
82 0.0004 0.00042605400085449
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1095
83 0.0006 0.00064492225646973
SELECT * FROM manufacturers WHERE id = '261'
84 0.0005 0.00054311752319336
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
85 0.0020 0.0019910335540771
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
86 0.0021 0.0021069049835205
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '261' ORDER BY RAND() LIMIT 1
87 0.0005 0.00054097175598145
SELECT * FROM productimages WHERE product_id = '1253' ORDER BY sortorder ASC
88 0.0005 0.00052499771118164
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
89 0.0006 0.00057697296142578
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '261'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0005 0.0004580020904541
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
91 0.0006 0.0005800724029541
SELECT category_id FROM products_categories WHERE product_id = '1095'
92 0.0014 0.0013558864593506
SELECT * FROM categories WHERE id = '27'
93 0.0137 0.013689994812012
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.0008 0.00078392028808594
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0006 0.00055503845214844
SELECT id FROM categories WHERE parent_id = '27'
96 0.0078 0.0077512264251709
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.0008 0.00075292587280273
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.0006 0.00063705444335938
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.0005 0.00051712989807129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0007 0.00066590309143066
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
101 0.0020 0.0019629001617432
SELECT * FROM product_image_select WHERE product_id = '1095'
102 0.0014 0.0013949871063232
SELECT * FROM productcustomimages WHERE product_id = '1095'
103 0.0013 0.0013279914855957
SELECT * FROM productfeeds WHERE product_id = '1095' ORDER BY item_date DESC
104 0.0030 0.0030460357666016
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0022 0.0021789073944092
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1095' AND t.hidden = 0 AND display_product = 1
106 0.0014 0.0013768672943115
SELECT * FROM productamazoncontent WHERE product_id = '1095'
107 0.0011 0.0010647773742676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
108 0.0013 0.0013198852539062
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00051498413085938
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0006 0.00058102607727051
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
112 0.0101 0.010123014450073
SELECT *, MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AND 1095 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
113 0.0006 0.00062704086303711
SELECT *, MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AND 1095 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0005 0.00049686431884766
SELECT *, MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AND 1095 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0004 0.00041890144348145
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
116 0.0005 0.00054812431335449
SELECT * FROM product_image_select WHERE product_id = '1095'
117 0.0003 0.00034499168395996
SELECT * FROM productcustomimages WHERE product_id = '1095'
118 0.0010 0.00098395347595215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
119 0.0005 0.00045919418334961
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00037288665771484
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.0003669261932373
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
123 0.0005 0.00053596496582031
SELECT * FROM product_image_select WHERE product_id = '1246'
124 0.0004 0.00037717819213867
SELECT * FROM productcustomimages WHERE product_id = '1246'
125 0.0008 0.00078296661376953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
126 0.0005 0.00047016143798828
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00045919418334961
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
130 0.0005 0.00053501129150391
SELECT * FROM product_image_select WHERE product_id = '1204'
131 0.0004 0.0003809928894043
SELECT * FROM productcustomimages WHERE product_id = '1204'
132 0.0007 0.0006859302520752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
133 0.0005 0.00045990943908691
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00038814544677734
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.0004279613494873
SELECT * FROM productimages WHERE product_id = '4678' ORDER BY sortorder ASC
137 0.0006 0.00058817863464355
SELECT * FROM product_image_select WHERE product_id = '4678'
138 0.0004 0.00037908554077148
SELECT * FROM productcustomimages WHERE product_id = '4678'
139 0.0011 0.0010719299316406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4678' AND a.name = n.originalname
140 0.0005 0.00047111511230469
SELECT * FROM productoffers WHERE product_id = '4678' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '4678' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '4678' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0093 0.0093159675598145
SELECT *, MATCH (description, title) AGAINST ('g rooibos parfumé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('g rooibos parfumé' IN BOOLEAN MODE) AND 1095 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
144 0.0006 0.00063204765319824
SELECT *, MATCH (description, title) AGAINST ('g rooibos parfumé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('g rooibos parfumé' IN BOOLEAN MODE) AND 1095 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
145 0.0005 0.0005040168762207
SELECT *, MATCH (description, title) AGAINST ('g rooibos parfumé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('g rooibos parfumé' IN BOOLEAN MODE) AND 1095 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
146 0.0004 0.00042295455932617
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
147 0.0006 0.00060510635375977
SELECT * FROM product_image_select WHERE product_id = '878'
148 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '878'
149 0.0011 0.0010569095611572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
150 0.0004 0.00042390823364258
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00054097175598145
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0006 0.00060415267944336
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
154 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '858'
155 0.0004 0.00037884712219238
SELECT * FROM productcustomimages WHERE product_id = '858'
156 0.0010 0.00098896026611328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
157 0.0004 0.00042486190795898
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0005 0.00052404403686523
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
161 0.0006 0.00061583518981934
SELECT * FROM product_image_select WHERE product_id = '862'
162 0.0004 0.0003819465637207
SELECT * FROM productcustomimages WHERE product_id = '862'
163 0.0009 0.00092196464538574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
164 0.0005 0.00045013427734375
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0005 0.00051307678222656
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0005 0.0004880428314209
SELECT id,asin FROM products WHERE parent_id = 1095
168 0.0017 0.0017359256744385
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1095' ORDER BY timestamp DESC
169 0.0008 0.0007939338684082
SELECT category_id FROM products_categories WHERE product_id = '1095'
170 0.0009 0.00089001655578613
SELECT * FROM categories WHERE id = '27'
171 0.0042 0.0041971206665039
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
172 0.0024 0.0024058818817139
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
173 0.0023 0.0023269653320312
SELECT id FROM categories WHERE parent_id = '27'
174 0.0130 0.013025999069214
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 
175 0.0009 0.00088691711425781
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 
176 0.0008 0.00076985359191895
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
177 0.0007 0.00070786476135254
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
178 0.0016 0.001554012298584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
179 0.0008 0.00076603889465332
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0006 0.00059604644775391
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0007 0.00066709518432617
SELECT * FROM products WHERE id = '1095'
182 0.0007 0.0006868839263916
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0015 0.0015430450439453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
184 0.0005 0.00054597854614258
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0006 0.00062894821166992
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0006 0.00063705444335938
SELECT category_id FROM products_categories WHERE product_id = '1095' AND prod_type = 'amz'
187 0.0007 0.0006871223449707
SELECT parent_id FROM categories WHERE id = '27'
188 0.0005 0.00052881240844727
SELECT * FROM categories WHERE id = '27'
189 0.0057 0.0057339668273926
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
190 0.0006 0.00061798095703125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0004 0.00041699409484863
SELECT id FROM categories WHERE parent_id = '27'
192 0.0055 0.0055170059204102
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 
193 0.0007 0.00067687034606934
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 
194 0.0007 0.00072097778320312
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
195 0.0006 0.00057411193847656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0025 0.0025019645690918
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0017 0.001737117767334
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.00040507316589355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0161 0.016112804412842
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
200 0.0022 0.0021522045135498
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
201 0.0005 0.00054287910461426
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
202 0.0005 0.00052905082702637
SELECT * FROM products WHERE id = 1626
203 0.0005 0.00046586990356445
SELECT * FROM products WHERE id = 4041
204 0.0004 0.00042104721069336
SELECT * FROM products WHERE id = 4312
205 0.0004 0.00044608116149902
SELECT * FROM products WHERE id = 777
206 0.0005 0.00053191184997559
SELECT * FROM products WHERE id = 3881
207 0.0004 0.00040602684020996
SELECT * FROM products WHERE id = 4213
208 0.0004 0.00035500526428223
SELECT * FROM products WHERE id = '1626'
209 0.0005 0.00050091743469238
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0006 0.00060606002807617
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0004 0.0003960132598877
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0009 0.00085902214050293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0005 0.00048017501831055
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00039887428283691
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0005 0.0004889965057373
SELECT * FROM products WHERE id = '4041'
217 0.0004 0.00042319297790527
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0004 0.00038003921508789
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0011 0.0011091232299805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0005 0.0004727840423584
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.00045084953308105
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.00050091743469238
SELECT * FROM products WHERE id = '4312'
225 0.0005 0.00046205520629883
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0006 0.00058197975158691
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0004 0.00038480758666992
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0011 0.0010771751403809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0005 0.00046896934509277
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0006 0.00064396858215332
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0006 0.00057792663574219
SELECT * FROM products WHERE id = '777'
233 0.0005 0.0005190372467041
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0005 0.00050997734069824
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0011 0.0011348724365234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0005 0.00052213668823242
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0005 0.00054717063903809
SELECT * FROM products WHERE id = '3881'
241 0.0005 0.00053215026855469
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0004 0.00038313865661621
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0011 0.001115083694458
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0006 0.00056982040405273
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00039196014404297
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0005 0.0005488395690918
SELECT * FROM products WHERE id = '4213'
249 0.0005 0.0005490779876709
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0006 0.00056314468383789
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0004 0.0004119873046875
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0013 0.0013449192047119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0004 0.00037193298339844
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0021 0.002065896987915
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0007 0.00071477890014648
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0022 0.0022029876708984
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0019 0.0019321441650391
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0005 0.00046801567077637
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0015 0.001460075378418
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'