0

Sachets de thé rooibos originales (80) - Paquet de 2

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-24 17:42:33 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.

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.3585629463196 257 0.9858 0


No Amazon API Requests Made.


App Debug - Total Time 1.3585629463196 seconds

Number Time From Start Name Description
1 0.30938291549683 Initialise Initialise FSB Function
2 0.32071185112 App Controller Start Start of the App controller (called before the controller of every page)
3 0.36041593551636 Start of getCategoryListByGroup Function Before first category groups query
4 0.36232089996338 After initial query Before first category groups query
5 0.3623218536377 Get Category List for Group Before the call to getCategoryList function
6 0.36232900619507 Start of GetCategoryList function Start of the function
7 0.3623309135437 Before getting categories Query to get specific category list
8 0.3640148639679 After getting categories Query to get specific category list
9 0.36401700973511 Before getting category custom Before call to function getCategoryCustom
10 0.38571691513062 After getting category custom After call to function getCategoryCustom
11 0.38571882247925 Before getting category custom Before call to function getCategoryCustom
12 0.39741778373718 After getting category custom After call to function getCategoryCustom
13 0.39741897583008 Before getting category custom Before call to function getCategoryCustom
14 0.40461683273315 After getting category custom After call to function getCategoryCustom
15 0.40461897850037 Before getting category custom Before call to function getCategoryCustom
16 0.41446995735168 After getting category custom After call to function getCategoryCustom
17 0.41447186470032 Before getting category custom Before call to function getCategoryCustom
18 0.42593598365784 After getting category custom After call to function getCategoryCustom
19 0.42593789100647 Before getting category custom Before call to function getCategoryCustom
20 0.43611478805542 After getting category custom After call to function getCategoryCustom
21 0.43611693382263 End of GetCategoryList function End of the function
22 0.43612098693848 Get Category List for Group Before the call to getCategoryList function
23 0.43612289428711 Start of GetCategoryList function Start of the function
24 0.43612480163574 Before getting categories Query to get specific category list
25 0.43770599365234 End of getCategoryListByGroup Function Before return()
26 1.0432407855988 App Controller End End of the App controller (called before the controller of every page)
27 1.0435538291931 Product Start Start of the product info controller
28 1.0789368152618 Cache file not found Starting get product details
29 1.1415348052979 Related products Start getting related products if enabled
30 1.1415369510651 Related Products Start Before the related products are found
31 1.1415379047394 Related Products Keywords Before the related product keywords are found
32 1.1415419578552 Create Keyword List Function Start of function
33 1.141637802124 Create Keyword List Function After looping provided content - 23 keywords found
34 1.1425290107727 Create Keyword List Function After looping initial keyword list - 19 keywords remaining
35 1.1425387859344 Create Keyword List Function After reducing keyword list
36 1.1425838470459 Create Keyword List Function After selecting by scoring keywords
37 1.1425869464874 Create Keyword List Function After final loop of keywords
38 1.1425888538361 Related Products Keywords After the related product keywords are found
39 1.1834189891815 Related Products End After the related products are found
40 1.2163248062134 Product End End of the product info controller (Product Info)
41 1.2183787822723 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.220235824585 Before Get Options Before the call to getOptions in the tpl class
43 1.3083548545837 After Get Options After the call to getOptions in the tpl class
44 1.3085908889771 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3086268901825 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.319091796875 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3190989494324 Product Info: Before Template Display Before the template is displayed
48 1.3585410118103 Product Info: After Template Display After the template is displayed
49 1.3585469722748 Finalizing debug Before the debug is output to the page.
50 1.3585619926453 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 0.9858 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0027 0.0027470588684082
SELECT parameter, value FROM parameters
2 0.0084 0.00844407081604
SELECT * FROM `bad_bots`
3 0.0006 0.00057816505432129
SET time_zone = 'Europe/London'
4 0.0036 0.0036449432373047
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0042 0.0041530132293701
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.81\";}'
6 0.0055 0.0055069923400879
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739318977'
7 0.0044 0.0044369697570801
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00077080726623535
UPDATE autorun SET lastrun = '2025-02-12 00:09:37' WHERE id = '17'
9 0.0009 0.00094795227050781
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0035 0.0034539699554443
SELECT id FROM pages WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-2' LIMIT 1
11 0.0064 0.0064060688018799
SELECT id FROM products WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-2' AND hidden = 0 LIMIT 1
12 0.0066 0.0065879821777344
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0319 0.031877040863037
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0008 0.00079107284545898
SELECT * FROM pages WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-2'
15 0.0019 0.0018949508666992
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0017 0.0016670227050781
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0068 0.0068149566650391
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.0018 0.0017588138580322
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.0013 0.0012991428375244
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00050091743469238
SELECT id FROM categories WHERE parent_id = '26'
21 0.0059 0.0058999061584473
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.0017 0.0017309188842773
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.0016 0.0015509128570557
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.0015 0.0014550685882568
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00059103965759277
SELECT * FROM categorygroups WHERE id = '1'
26 0.0038 0.0037999153137207
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.0006 0.00060296058654785
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.0005 0.00050091743469238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.0005180835723877
SELECT id FROM categories WHERE parent_id = '27'
30 0.0039 0.003896951675415
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.0006 0.00060415267944336
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.00063395500183105
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.0005338191986084
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00052618980407715
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.001600980758667
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.00054287910461426
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.0004880428314209
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00047087669372559
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0017178058624268
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.0006 0.00058507919311523
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.0006 0.00062298774719238
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.0006 0.00058913230895996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00050020217895508
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00064396858215332
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.00054693222045898
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.0010 0.001046895980835
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0009 0.0009150505065918
SELECT id FROM categories WHERE parent_id = '29'
48 0.0020 0.0019540786743164
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.0012 0.0012099742889404
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.0011 0.0011458396911621
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.0011 0.0010581016540527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0012 0.0012478828430176
SELECT * FROM categorygroups WHERE id = '1'
53 0.0015 0.0014691352844238
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.0010 0.00097298622131348
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.0008 0.00080394744873047
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0009 0.00087308883666992
SELECT id FROM categories WHERE parent_id = '30'
57 0.0016 0.0016331672668457
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.0010 0.0010449886322021
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.0025 0.0025339126586914
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.0011 0.0010640621185303
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0010 0.00098896026611328
SELECT * FROM categorygroups WHERE id = '1'
62 0.0018 0.0018060207366943
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.0011 0.001121997833252
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.0007 0.0007328987121582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0009 0.00092196464538574
SELECT id FROM categories WHERE parent_id = '31'
66 0.0015 0.0015039443969727
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.0010 0.0009770393371582
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.0010 0.001046895980835
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.0012 0.0012130737304688
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0008 0.00077104568481445
SELECT * FROM categorygroups WHERE id = '1'
71 0.0016 0.0015718936920166
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0060 0.0060200691223145
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0032 0.0031881332397461
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0010 0.00095009803771973
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.0018 0.001755952835083
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0015 0.001533031463623
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0015 0.0014958381652832
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5850 0.58496189117432
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.81') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.81') <= INET_ATON(ip_end)
79 0.0025 0.0025439262390137
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0015 0.0015079975128174
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00082492828369141
SELECT * FROM products WHERE pagename = 'sachets-de-the-rooibos-originales-80-paquet-de-2'
82 0.0005 0.00052404403686523
UPDATE products SET viewcount = viewcount + 1 WHERE id = 919
83 0.0012 0.0011570453643799
SELECT * FROM manufacturers WHERE id = '639'
84 0.0025 0.0025348663330078
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85 0.0030 0.0030198097229004
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
86 0.0039 0.0038981437683105
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
87 0.0008 0.0007789134979248
SELECT * FROM productimages WHERE product_id = '1768' ORDER BY sortorder ASC
88 0.0018 0.0017778873443604
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
89 0.0016 0.0016269683837891
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0008 0.00079512596130371
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
91 0.0006 0.00055408477783203
SELECT category_id FROM products_categories WHERE product_id = '919'
92 0.0007 0.00065898895263672
SELECT * FROM categories WHERE id = '27'
93 0.0056 0.0056009292602539
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.0009 0.00085687637329102
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0006 0.00055885314941406
SELECT id FROM categories WHERE parent_id = '27'
96 0.0046 0.0045650005340576
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.0007 0.00067901611328125
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.00064301490783691
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.0012 0.0012049674987793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0012 0.0011551380157471
SELECT * FROM productimages WHERE product_id = '919' ORDER BY sortorder ASC
101 0.0052 0.0051910877227783
SELECT * FROM product_image_select WHERE product_id = '919'
102 0.0030 0.0030310153961182
SELECT * FROM productcustomimages WHERE product_id = '919'
103 0.0035 0.0035190582275391
SELECT * FROM productfeeds WHERE product_id = '919' ORDER BY item_date DESC
104 0.0052 0.0052280426025391
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '919' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0045 0.0044939517974854
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '919' AND t.hidden = 0 AND display_product = 1
106 0.0020 0.001986026763916
SELECT * FROM productamazoncontent WHERE product_id = '919'
107 0.0014 0.0013859272003174
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '919' AND a.name = n.originalname
108 0.0019 0.0018689632415771
SELECT * FROM productoffers WHERE product_id = '919' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0006 0.00061392784118652
SELECT * FROM productoffers
                WHERE product_id = '919' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00044798851013184
SELECT * FROM productoffers
                WHERE product_id = 919
                ORDER BY price ASC LIMIT 1
111 0.0006 0.00061297416687012
SELECT value FROM productattributes
                WHERE product_id = '919'
                AND name = 'ListPriceAmount'
112 0.0007 0.00074100494384766
SELECT value FROM productattributes WHERE product_id = '919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0006 0.00064206123352051
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.0116 0.011631965637207
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 919 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00072693824768066
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 919 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0006 0.00060391426086426
SELECT *, MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé rooibos originales' IN BOOLEAN MODE) AND 919 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0011 0.0010879039764404
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
118 0.0007 0.00067305564880371
SELECT * FROM product_image_select WHERE product_id = '865'
119 0.0005 0.00049686431884766
SELECT * FROM productcustomimages WHERE product_id = '865'
120 0.0009 0.0008549690246582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
121 0.0006 0.00057506561279297
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0005 0.00047492980957031
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0006 0.00064706802368164
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
125 0.0007 0.00069403648376465
SELECT * FROM product_image_select WHERE product_id = '869'
126 0.0005 0.00046610832214355
SELECT * FROM productcustomimages WHERE product_id = '869'
127 0.0009 0.00093793869018555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
128 0.0005 0.00054383277893066
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0006 0.00058102607727051
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
132 0.0007 0.00068497657775879
SELECT * FROM product_image_select WHERE product_id = '890'
133 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '890'
134 0.0010 0.0010480880737305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
135 0.0005 0.00052618980407715
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00044584274291992
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0005 0.00052690505981445
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0006 0.0006401538848877
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
139 0.0008 0.00079202651977539
SELECT * FROM product_image_select WHERE product_id = '862'
140 0.0005 0.00049686431884766
SELECT * FROM productcustomimages WHERE product_id = '862'
141 0.0009 0.00093507766723633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
142 0.0006 0.00058412551879883
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00050902366638184
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00049614906311035
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0005 0.00049281120300293
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
146 0.0006 0.00061488151550293
SELECT * FROM product_image_select WHERE product_id = '878'
147 0.0005 0.00045490264892578
SELECT * FROM productcustomimages WHERE product_id = '878'
148 0.0010 0.00099086761474609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
149 0.0005 0.00054597854614258
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0005 0.00047802925109863
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0005 0.00053000450134277
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0006 0.00063705444335938
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
153 0.0006 0.00063896179199219
SELECT * FROM product_image_select WHERE product_id = '858'
154 0.0005 0.00050902366638184
SELECT * FROM productcustomimages WHERE product_id = '858'
155 0.0011 0.0011200904846191
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
156 0.0006 0.00055193901062012
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.00046110153198242
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00053596496582031
SELECT id,asin FROM products WHERE parent_id = 919
160 0.0017 0.0016729831695557
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '919' ORDER BY timestamp DESC
161 0.0005 0.00052595138549805
SELECT category_id FROM products_categories WHERE product_id = '919'
162 0.0005 0.00053882598876953
SELECT * FROM categories WHERE id = '27'
163 0.0038 0.0037980079650879
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
164 0.0005 0.00051307678222656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0004 0.00038814544677734
SELECT id FROM categories WHERE parent_id = '27'
166 0.0036 0.0036430358886719
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 
167 0.0006 0.00057196617126465
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 
168 0.0006 0.00058317184448242
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
169 0.0006 0.00058293342590332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
170 0.0009 0.00092506408691406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '919' AND a.name = n.originalname
171 0.0007 0.00071096420288086
SELECT * FROM productoffers WHERE product_id = '919' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0008 0.00077605247497559
SELECT * FROM productoffers
                WHERE product_id = '919' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = 919
                ORDER BY price ASC LIMIT 1
174 0.0005 0.00048279762268066
SELECT value FROM productattributes
                WHERE product_id = '919'
                AND name = 'ListPriceAmount'
175 0.0006 0.000640869140625
SELECT * FROM products WHERE id = '919'
176 0.0005 0.0005040168762207
SELECT value FROM productattributes WHERE product_id = '919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0010 0.0010190010070801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '919' AND a.name = n.originalname
178 0.0005 0.00047612190246582
SELECT * FROM productoffers WHERE product_id = '919' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.00044989585876465
SELECT * FROM productoffers
                WHERE product_id = '919' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = 919
                ORDER BY price ASC LIMIT 1
181 0.0005 0.00046706199645996
SELECT value FROM productattributes
                WHERE product_id = '919'
                AND name = 'ListPriceAmount'
182 0.0005 0.00052618980407715
SELECT category_id FROM products_categories WHERE product_id = '919' AND prod_type = 'amz'
183 0.0005 0.00052094459533691
SELECT parent_id FROM categories WHERE id = '27'
184 0.0004 0.00043797492980957
SELECT * FROM categories WHERE id = '27'
185 0.0038 0.0037729740142822
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
186 0.0006 0.00059008598327637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
187 0.0004 0.00044107437133789
SELECT id FROM categories WHERE parent_id = '27'
188 0.0037 0.0036840438842773
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 
189 0.0006 0.00061202049255371
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 
190 0.0006 0.00057315826416016
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
191 0.0005 0.00050687789916992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
192 0.0017 0.0017311573028564
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0012 0.0012099742889404
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0005 0.00050687789916992
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0146 0.014561176300049
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
196 0.0019 0.0018739700317383
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
197 0.0007 0.00065398216247559
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
198 0.0007 0.00068306922912598
SELECT * FROM products WHERE id = 1626
199 0.0005 0.00054788589477539
SELECT * FROM products WHERE id = 4041
200 0.0005 0.00049805641174316
SELECT * FROM products WHERE id = 4312
201 0.0005 0.00046181678771973
SELECT * FROM products WHERE id = 777
202 0.0005 0.00046420097351074
SELECT * FROM products WHERE id = 3881
203 0.0005 0.00050902366638184
SELECT * FROM products WHERE id = 4213
204 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = '1626'
205 0.0007 0.00065493583679199
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0007 0.00071406364440918
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0005 0.0005028247833252
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0010 0.0010221004486084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0006 0.00057411193847656
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.0004429817199707
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0006 0.00062108039855957
SELECT * FROM products WHERE id = '4041'
213 0.0005 0.00047087669372559
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0007 0.00066399574279785
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0005 0.00045895576477051
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0012 0.0012030601501465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0006 0.0006248950958252
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00051307678222656
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0007 0.0006868839263916
SELECT * FROM products WHERE id = '4312'
221 0.0005 0.00051212310791016
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0007 0.00072693824768066
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0005 0.00054121017456055
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0012 0.0011610984802246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
225 0.0006 0.00064897537231445
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0006 0.0005650520324707
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0005 0.00054407119750977
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0006 0.00063991546630859
SELECT * FROM products WHERE id = '777'
229 0.0006 0.0005640983581543
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0016 0.0015938282012939
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0009 0.00092411041259766
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0030 0.0029799938201904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
233 0.0011 0.00111985206604
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0008 0.00080680847167969
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0008 0.00076103210449219
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0011 0.0011348724365234
SELECT * FROM products WHERE id = '3881'
237 0.0010 0.00097084045410156
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
238 0.0012 0.001244068145752
SELECT * FROM product_image_select WHERE product_id = '3881'
239 0.0006 0.00064992904663086
SELECT * FROM productcustomimages WHERE product_id = '3881'
240 0.0024 0.0024070739746094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
241 0.0008 0.00083303451538086
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0007 0.0007169246673584
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0006 0.00064301490783691
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0009 0.00090813636779785
SELECT * FROM products WHERE id = '4213'
245 0.0009 0.00087404251098633
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
246 0.0021 0.0021481513977051
SELECT * FROM product_image_select WHERE product_id = '4213'
247 0.0010 0.00098490715026855
SELECT * FROM productcustomimages WHERE product_id = '4213'
248 0.0040 0.0040328502655029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
249 0.0013 0.0013220310211182
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0010 0.00099492073059082
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0013 0.0013229846954346
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0053 0.0053451061248779
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0014 0.0014281272888184
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0069 0.0068678855895996
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0040 0.0040459632873535
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0011 0.0010721683502197
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0017 0.0017459392547607
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'