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.4560129642487 260 1.0568 0


No Amazon API Requests Made.


App Debug - Total Time 1.4560129642487 seconds

Number Time From Start Name Description
1 0.36570811271667 Initialise Initialise FSB Function
2 0.36754512786865 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40621209144592 Start of getCategoryListByGroup Function Before first category groups query
4 0.40685391426086 After initial query Before first category groups query
5 0.40685510635376 Get Category List for Group Before the call to getCategoryList function
6 0.40685701370239 Start of GetCategoryList function Start of the function
7 0.40685892105103 Before getting categories Query to get specific category list
8 0.4075779914856 After getting categories Query to get specific category list
9 0.40757894515991 Before getting category custom Before call to function getCategoryCustom
10 0.42743611335754 After getting category custom After call to function getCategoryCustom
11 0.42743706703186 Before getting category custom Before call to function getCategoryCustom
12 0.4406750202179 After getting category custom After call to function getCategoryCustom
13 0.44067692756653 Before getting category custom Before call to function getCategoryCustom
14 0.44935011863708 After getting category custom After call to function getCategoryCustom
15 0.4493510723114 Before getting category custom Before call to function getCategoryCustom
16 0.45679807662964 After getting category custom After call to function getCategoryCustom
17 0.45679903030396 Before getting category custom Before call to function getCategoryCustom
18 0.46446013450623 After getting category custom After call to function getCategoryCustom
19 0.46446108818054 Before getting category custom Before call to function getCategoryCustom
20 0.47080206871033 After getting category custom After call to function getCategoryCustom
21 0.47080397605896 End of GetCategoryList function End of the function
22 0.4708080291748 Get Category List for Group Before the call to getCategoryList function
23 0.47080898284912 Start of GetCategoryList function Start of the function
24 0.47081112861633 Before getting categories Query to get specific category list
25 0.47267007827759 End of getCategoryListByGroup Function Before return()
26 1.2498660087585 App Controller End End of the App controller (called before the controller of every page)
27 1.250216960907 Product Start Start of the product info controller
28 1.2882680892944 Cache file not found Starting get product details
29 1.3243141174316 Related products Start getting related products if enabled
30 1.324315071106 Related Products Start Before the related products are found
31 1.3243160247803 Related Products Keywords Before the related product keywords are found
32 1.3243191242218 Create Keyword List Function Start of function
33 1.3243999481201 Create Keyword List Function After looping provided content - 27 keywords found
34 1.3247849941254 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 1.3247890472412 Create Keyword List Function After reducing keyword list
36 1.3248150348663 Create Keyword List Function After selecting by scoring keywords
37 1.324816942215 Create Keyword List Function After final loop of keywords
38 1.3248181343079 Related Products Keywords After the related product keywords are found
39 1.3731009960175 Related Products End After the related products are found
40 1.4007239341736 Product End End of the product info controller (Product Info)
41 1.4014830589294 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4022390842438 Before Get Options Before the call to getOptions in the tpl class
43 1.446044921875 After Get Options After the call to getOptions in the tpl class
44 1.4461119174957 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4461319446564 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.448853969574 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4488561153412 Product Info: Before Template Display Before the template is displayed
48 1.4559991359711 Product Info: After Template Display After the template is displayed
49 1.4560060501099 Finalizing debug Before the debug is output to the page.
50 1.4560129642487 End of App This is the end of the app logging, final timestamp


Query Debug - 260 Database Queries. Total time 1.0568 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0011 0.0011248588562012
SELECT parameter, value FROM parameters
2 0.0025 0.002547025680542
SELECT * FROM `bad_bots`
3 0.0003 0.00031399726867676
SET time_zone = 'Europe/London'
4 0.0006 0.00059700012207031
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0006 0.00064396858215332
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.145.179.11\";}'
6 0.0006 0.0006401538848877
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745060375'
7 0.0008 0.0007939338684082
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00040388107299805
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.0005190372467041
SELECT id FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio' LIMIT 1
10 0.0006 0.00061178207397461
SELECT id FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio' AND hidden = 0 LIMIT 1
11 0.0016 0.001594066619873
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0363 0.036280155181885
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00052595138549805
SELECT * FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio'
14 0.0006 0.00063896179199219
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00070881843566895
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0082 0.0081908702850342
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.0007 0.00070095062255859
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.0005 0.0004580020904541
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00043201446533203
SELECT id FROM categories WHERE parent_id = '26'
20 0.0077 0.0077381134033203
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.0006 0.00062203407287598
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.0006 0.00060796737670898
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.0006 0.00057196617126465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00048708915710449
SELECT * FROM categorygroups WHERE id = '1'
25 0.0047 0.0046589374542236
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.0004889965057373
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00041007995605469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0006 0.00058412551879883
SELECT id FROM categories WHERE parent_id = '27'
29 0.0048 0.0048489570617676
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.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 
31 0.0006 0.00056099891662598
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.0006 0.00055313110351562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00046300888061523
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.001816987991333
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.0006 0.00059294700622559
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.00044703483581543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00044989585876465
SELECT id FROM categories WHERE parent_id = '28'
38 0.0022 0.0022180080413818
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.0009 0.0009009838104248
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.0009 0.0009150505065918
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.0007 0.00070810317993164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0006 0.00060701370239258
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00089287757873535
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.0007 0.00065302848815918
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.0005 0.00053000450134277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00053787231445312
SELECT id FROM categories WHERE parent_id = '29'
47 0.0013 0.0012500286102295
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.0009 0.00092983245849609
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.0009 0.00091981887817383
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.0009 0.00092101097106934
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0008 0.0007929801940918
SELECT * FROM categorygroups WHERE id = '1'
52 0.0011 0.0011379718780518
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.0009 0.00089597702026367
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.0007 0.00068402290344238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0007 0.00068497657775879
SELECT id FROM categories WHERE parent_id = '30'
56 0.0014 0.0013589859008789
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.0009 0.00093984603881836
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.0008 0.00076580047607422
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.0007 0.00065183639526367
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00050520896911621
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.00087809562683105
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.0007 0.00065016746520996
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.0005 0.0005490779876709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00053000450134277
SELECT id FROM categories WHERE parent_id = '31'
65 0.0011 0.0010528564453125
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.0007 0.00067710876464844
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.0007 0.00071907043457031
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.0007 0.00066900253295898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0006 0.00058794021606445
SELECT * FROM categorygroups WHERE id = '1'
70 0.0019 0.001856803894043
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0050 0.00496506690979
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0007 0.000701904296875
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00059294700622559
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.0006 0.00058293342590332
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0014 0.0014050006866455
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010349750518799
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7659 0.7658679485321
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.179.11') >= INET_ATON(ip_start) AND INET_ATON('3.145.179.11') <= INET_ATON(ip_end)
78 0.0010 0.00095295906066895
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.0004279613494873
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00056195259094238
SELECT * FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio'
81 0.0126 0.012551069259644
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1109
82 0.0011 0.0011050701141357
SELECT * FROM manufacturers WHERE id = '183'
83 0.0009 0.00090384483337402
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
84 0.0009 0.0008690357208252
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '183' LIMIT 1
85 0.0014 0.0013561248779297
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.0007 0.00074195861816406
SELECT * FROM productimages WHERE product_id = '906' ORDER BY sortorder ASC
87 0.0009 0.0009307861328125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
88 0.0009 0.00086808204650879
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.0005 0.00046801567077637
SELECT * FROM manufacturerimages WHERE manufacturer_id = '183'
90 0.0010 0.0010440349578857
SELECT category_id FROM products_categories WHERE product_id = '1109'
91 0.0008 0.00080299377441406
SELECT * FROM categories WHERE id = '27'
92 0.0099 0.0098998546600342
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.00068283081054688
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00042080879211426
SELECT id FROM categories WHERE parent_id = '27'
95 0.0062 0.0061800479888916
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.0007 0.00068879127502441
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.00067996978759766
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0006 0.00060391426086426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00058412551879883
SELECT * FROM productimages WHERE product_id = '1109' ORDER BY sortorder ASC
100 0.0008 0.00080084800720215
SELECT * FROM product_image_select WHERE product_id = '1109'
101 0.0004 0.00041794776916504
SELECT * FROM productcustomimages WHERE product_id = '1109'
102 0.0004 0.00039792060852051
SELECT * FROM productfeeds WHERE product_id = '1109' ORDER BY item_date DESC
103 0.0007 0.00072288513183594
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
104 0.0007 0.00065112113952637
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
105 0.0005 0.0004580020904541
SELECT * FROM productamazoncontent WHERE product_id = '1109'
106 0.0008 0.00078201293945312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
107 0.0005 0.00054311752319336
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00034594535827637
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00038695335388184
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
111 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '1109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0006 0.00055599212646484
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.0097 0.0096549987792969
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
114 0.0006 0.0005800724029541
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
115 0.0005 0.00049495697021484
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
116 0.0004 0.00043201446533203
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
117 0.0006 0.00058913230895996
SELECT * FROM product_image_select WHERE product_id = '1093'
118 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '1093'
119 0.0008 0.00081896781921387
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.00046396255493164
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0005 0.00047612190246582
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
124 0.0005 0.00054097175598145
SELECT * FROM product_image_select WHERE product_id = '4905'
125 0.0004 0.00044989585876465
SELECT * FROM productcustomimages WHERE product_id = '4905'
126 0.0010 0.0010387897491455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
127 0.0005 0.00050091743469238
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0004 0.0004279613494873
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0004 0.00042605400085449
SELECT * FROM productimages WHERE product_id = '1278' ORDER BY sortorder ASC
131 0.0005 0.00052094459533691
SELECT * FROM product_image_select WHERE product_id = '1278'
132 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '1278'
133 0.0007 0.00066590309143066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1278' AND a.name = n.originalname
134 0.0004 0.00042915344238281
SELECT * FROM productoffers WHERE product_id = '1278' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0004 0.0003809928894043
SELECT * FROM productoffers
                WHERE product_id = '1278' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '1278' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0009 0.00092101097106934
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
138 0.0120 0.012009859085083
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()
139 0.0007 0.00066304206848145
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()
140 0.0005 0.00054788589477539
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()
141 0.0005 0.00047087669372559
SELECT * FROM productimages WHERE product_id = '994' ORDER BY sortorder ASC
142 0.0007 0.00067305564880371
SELECT * FROM product_image_select WHERE product_id = '994'
143 0.0004 0.00036978721618652
SELECT * FROM productcustomimages WHERE product_id = '994'
144 0.0009 0.00085997581481934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname
145 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '994' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '994' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '994' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0006 0.00060296058654785
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
149 0.0006 0.00064802169799805
SELECT * FROM product_image_select WHERE product_id = '890'
150 0.0004 0.00036311149597168
SELECT * FROM productcustomimages WHERE product_id = '890'
151 0.0011 0.0010719299316406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
152 0.0005 0.00046300888061523
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0005 0.00047087669372559
SELECT * FROM productimages WHERE product_id = '1200' ORDER BY sortorder ASC
156 0.0006 0.0006101131439209
SELECT * FROM product_image_select WHERE product_id = '1200'
157 0.0004 0.00043201446533203
SELECT * FROM productcustomimages WHERE product_id = '1200'
158 0.0008 0.00081300735473633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1200' AND a.name = n.originalname
159 0.0005 0.00046896934509277
SELECT * FROM productoffers WHERE product_id = '1200' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '1200' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00049614906311035
SELECT value FROM productattributes WHERE product_id = '1200' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0005 0.00046300888061523
SELECT id,asin FROM products WHERE parent_id = 1109
163 0.0004 0.00037693977355957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1109' ORDER BY timestamp DESC
164 0.0004 0.00038790702819824
SELECT category_id FROM products_categories WHERE product_id = '1109'
165 0.0004 0.00037503242492676
SELECT * FROM categories WHERE id = '27'
166 0.0040 0.0039548873901367
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
167 0.0005 0.00049304962158203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0003 0.0003049373626709
SELECT id FROM categories WHERE parent_id = '27'
169 0.0040 0.003993034362793
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 
170 0.0005 0.00046515464782715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
171 0.0005 0.00048112869262695
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
172 0.0004 0.00041913986206055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0007 0.00072693824768066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
174 0.0004 0.00041890144348145
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0004 0.00037884712219238
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
177 0.0003 0.00033783912658691
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
178 0.0005 0.0004570484161377
SELECT * FROM products WHERE id = '1109'
179 0.0004 0.00042915344238281
SELECT value FROM productattributes WHERE product_id = '1109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0006 0.0006098747253418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
181 0.0003 0.00034403800964355
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0003 0.0003201961517334
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0003 0.00027990341186523
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00036001205444336
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
185 0.0004 0.00037288665771484
SELECT category_id FROM products_categories WHERE product_id = '1109' AND prod_type = 'amz'
186 0.0004 0.00036787986755371
SELECT parent_id FROM categories WHERE id = '27'
187 0.0003 0.00028085708618164
SELECT * FROM categories WHERE id = '27'
188 0.0039 0.0038888454437256
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
189 0.0004 0.00037908554077148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190 0.0003 0.00029420852661133
SELECT id FROM categories WHERE parent_id = '27'
191 0.0037 0.003741979598999
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 
192 0.0004 0.00043988227844238
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 
193 0.0005 0.00046706199645996
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
194 0.0004 0.00041389465332031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195 0.0004 0.00042605400085449
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
196 0.0004 0.00040602684020996
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
197 0.0003 0.00031304359436035
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
198 0.0127 0.012691020965576
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
199 0.0005 0.00050902366638184
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
200 0.0005 0.00047183036804199
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
201 0.0005 0.0004889965057373
SELECT * FROM products WHERE id = 1626
202 0.0004 0.00038480758666992
SELECT * FROM products WHERE id = 4041
203 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = 4312
204 0.0003 0.00031113624572754
SELECT * FROM products WHERE id = 777
205 0.0004 0.00039005279541016
SELECT * FROM products WHERE id = 3881
206 0.0004 0.0003969669342041
SELECT * FROM products WHERE id = 4213
207 0.0004 0.00036001205444336
SELECT * FROM products WHERE id = '1626'
208 0.0004 0.00039887428283691
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
209 0.0005 0.00053596496582031
SELECT * FROM product_image_select WHERE product_id = '1626'
210 0.0003 0.00033092498779297
SELECT * FROM productcustomimages WHERE product_id = '1626'
211 0.0007 0.00072598457336426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
212 0.0004 0.0003969669342041
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0003 0.00034713745117188
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0004 0.00044488906860352
SELECT * FROM products WHERE id = '4041'
216 0.0004 0.0003960132598877
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
217 0.0005 0.00054597854614258
SELECT * FROM product_image_select WHERE product_id = '4041'
218 0.0003 0.00031089782714844
SELECT * FROM productcustomimages WHERE product_id = '4041'
219 0.0010 0.0010371208190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
220 0.0004 0.0004119873046875
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0003 0.00034713745117188
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = '4312'
224 0.0004 0.0003969669342041
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
225 0.0005 0.00050997734069824
SELECT * FROM product_image_select WHERE product_id = '4312'
226 0.0003 0.00031805038452148
SELECT * FROM productcustomimages WHERE product_id = '4312'
227 0.0009 0.00090885162353516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
228 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0004 0.00035214424133301
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0004 0.00044918060302734
SELECT * FROM products WHERE id = '777'
232 0.0004 0.00041103363037109
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0005 0.00052809715270996
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0004 0.00035619735717773
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0009 0.00093698501586914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0004 0.00040388107299805
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0004 0.00036907196044922
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0005 0.00046515464782715
SELECT * FROM products WHERE id = '3881'
240 0.0006 0.00059890747070312
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
241 0.0006 0.00056195259094238
SELECT * FROM product_image_select WHERE product_id = '3881'
242 0.0003 0.00034189224243164
SELECT * FROM productcustomimages WHERE product_id = '3881'
243 0.0010 0.0010271072387695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
244 0.0004 0.00042390823364258
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0004 0.00035881996154785
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0004 0.00043010711669922
SELECT * FROM products WHERE id = '4213'
248 0.0005 0.00046300888061523
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
249 0.0005 0.00052499771118164
SELECT * FROM product_image_select WHERE product_id = '4213'
250 0.0003 0.0003359317779541
SELECT * FROM productcustomimages WHERE product_id = '4213'
251 0.0010 0.0010221004486084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
252 0.0004 0.00041604042053223
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0007 0.00074505805969238
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
256 0.0006 0.00064992904663086
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
257 0.0013 0.0012619495391846
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
258 0.0006 0.00056719779968262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0005 0.0004730224609375
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0005 0.00050902366638184
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'