0

Special T - Rooibos Bourbon Vanilla - 10 Capsules Rooibos parfumé - 100% origine Nestlé - pour Special.T machinea the / thé / tea

Price: €16,00
Product prices and availability are accurate as of 2022-06-17 01:42:19 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.5407590866089 260 0.9472 0


No Amazon API Requests Made.


App Debug - Total Time 1.5407590866089 seconds

Number Time From Start Name Description
1 0.54748892784119 Initialise Initialise FSB Function
2 0.55827212333679 App Controller Start Start of the App controller (called before the controller of every page)
3 0.59565210342407 Start of getCategoryListByGroup Function Before first category groups query
4 0.59743499755859 After initial query Before first category groups query
5 0.59743690490723 Get Category List for Group Before the call to getCategoryList function
6 0.59744000434875 Start of GetCategoryList function Start of the function
7 0.5974440574646 Before getting categories Query to get specific category list
8 0.59913110733032 After getting categories Query to get specific category list
9 0.59913206100464 Before getting category custom Before call to function getCategoryCustom
10 0.65652799606323 After getting category custom After call to function getCategoryCustom
11 0.65653300285339 Before getting category custom Before call to function getCategoryCustom
12 0.67830610275269 After getting category custom After call to function getCategoryCustom
13 0.67830991744995 Before getting category custom Before call to function getCategoryCustom
14 0.68675994873047 After getting category custom After call to function getCategoryCustom
15 0.686763048172 Before getting category custom Before call to function getCategoryCustom
16 0.69301390647888 After getting category custom After call to function getCategoryCustom
17 0.69301700592041 Before getting category custom Before call to function getCategoryCustom
18 0.69953608512878 After getting category custom After call to function getCategoryCustom
19 0.69953799247742 Before getting category custom Before call to function getCategoryCustom
20 0.70564103126526 After getting category custom After call to function getCategoryCustom
21 0.70564603805542 End of GetCategoryList function End of the function
22 0.70565509796143 Get Category List for Group Before the call to getCategoryList function
23 0.70565891265869 Start of GetCategoryList function Start of the function
24 0.70566296577454 Before getting categories Query to get specific category list
25 0.70636296272278 End of getCategoryListByGroup Function Before return()
26 1.2687449455261 App Controller End End of the App controller (called before the controller of every page)
27 1.2696630954742 Product Start Start of the product info controller
28 1.2758390903473 Cache file not found Starting get product details
29 1.3211040496826 Related products Start getting related products if enabled
30 1.3211059570312 Related Products Start Before the related products are found
31 1.3211069107056 Related Products Keywords Before the related product keywords are found
32 1.3211119174957 Create Keyword List Function Start of function
33 1.3211600780487 Create Keyword List Function After looping provided content - 50 keywords found
34 1.3232219219208 Create Keyword List Function After looping initial keyword list - 45 keywords remaining
35 1.323233127594 Create Keyword List Function After reducing keyword list
36 1.3234930038452 Create Keyword List Function After selecting by scoring keywords
37 1.3234980106354 Create Keyword List Function After final loop of keywords
38 1.323499917984 Related Products Keywords After the related product keywords are found
39 1.3775749206543 Related Products End After the related products are found
40 1.4087810516357 Product End End of the product info controller (Product Info)
41 1.4115099906921 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4136140346527 Before Get Options Before the call to getOptions in the tpl class
43 1.4901039600372 After Get Options After the call to getOptions in the tpl class
44 1.4902319908142 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4902729988098 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5024380683899 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5024449825287 Product Info: Before Template Display Before the template is displayed
48 1.5407309532166 Product Info: After Template Display After the template is displayed
49 1.5407450199127 Finalizing debug Before the debug is output to the page.
50 1.5407581329346 End of App This is the end of the app logging, final timestamp


Query Debug - 260 Database Queries. Total time 0.9472 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0020 0.0020499229431152
SELECT parameter, value FROM parameters
2 0.0068 0.0068409442901611
SELECT * FROM `bad_bots`
3 0.0004 0.00038504600524902
SET time_zone = 'Europe/London'
4 0.0010 0.00098109245300293
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0040 0.0040180683135986
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.118.164.187\";}'
6 0.0038 0.0038299560546875
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722077688'
7 0.0043 0.0042870044708252
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00094485282897949
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0039 0.0038800239562988
SELECT id FROM pages WHERE pagename = 'special-t-rooibos-bourbon-vanilla-10-capsules-rooibos-parfume-100' LIMIT 1
10 0.0051 0.005098819732666
SELECT id FROM products WHERE pagename = 'special-t-rooibos-bourbon-vanilla-10-capsules-rooibos-parfume-100' AND hidden = 0 LIMIT 1
11 0.0048 0.0047740936279297
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0314 0.031393051147461
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0008 0.00076889991760254
SELECT * FROM pages WHERE pagename = 'special-t-rooibos-bourbon-vanilla-10-capsules-rooibos-parfume-100'
14 0.0018 0.00177001953125
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0017 0.0016670227050781
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0148 0.014822959899902
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.0052 0.0052268505096436
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.0052 0.0052280426025391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0013 0.0012938976287842
SELECT id FROM categories WHERE parent_id = '26'
20 0.0187 0.018678188323975
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.0031 0.003087043762207
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.0035 0.0034999847412109
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.0042 0.0042321681976318
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0011 0.0011169910430908
SELECT * FROM categorygroups WHERE id = '1'
25 0.0093 0.0093338489532471
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.0010 0.0010440349578857
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.0007 0.00066804885864258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0007 0.00071096420288086
SELECT id FROM categories WHERE parent_id = '27'
29 0.0064 0.006425142288208
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.0008 0.00079011917114258
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.0010 0.0010309219360352
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.0008 0.00075697898864746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0009 0.00088596343994141
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016250610351562
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.0007 0.00068783760070801
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.0008 0.00084304809570312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00052499771118164
SELECT id FROM categories WHERE parent_id = '28'
38 0.0022 0.0021719932556152
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.0007 0.00066184997558594
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.0007 0.00071501731872559
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.0006 0.00057697296142578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00054597854614258
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00091099739074707
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.0008 0.00077605247497559
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.0006 0.00057387351989746
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.00060606002807617
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00089192390441895
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0006 0.00057506561279297
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.0006 0.00064492225646973
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.0006 0.00058197975158691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.0005958080291748
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.0007469654083252
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0006 0.00062704086303711
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.0006 0.0006401538848877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00054478645324707
SELECT id FROM categories WHERE parent_id = '30'
56 0.0010 0.0009760856628418
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.00085806846618652
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.0007 0.00069308280944824
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.0008 0.00080204010009766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00053691864013672
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00083804130554199
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.0006 0.00063014030456543
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.00048494338989258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00052905082702637
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.0009148120880127
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.0006 0.00063705444335938
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.0008 0.00079607963562012
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0006 0.00059890747070312
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0006 0.00056910514831543
SELECT * FROM categorygroups WHERE id = '1'
70 0.0007 0.00068283081054688
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0033 0.0032541751861572
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0025 0.0024559497833252
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00075101852416992
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.0020 0.0019731521606445
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.0013000965118408
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0016 0.0015590190887451
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5447 0.5447371006012
SELECT * FROM ipgeocountries WHERE INET_ATON('18.118.164.187') >= INET_ATON(ip_start) AND INET_ATON('18.118.164.187') <= INET_ATON(ip_end)
78 0.0024 0.0024409294128418
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0013179779052734
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00077414512634277
SELECT * FROM products WHERE pagename = 'special-t-rooibos-bourbon-vanilla-10-capsules-rooibos-parfume-100'
81 0.0004 0.00044894218444824
UPDATE products SET viewcount = viewcount + 1 WHERE id = 966
82 0.0006 0.00057721138000488
SELECT * FROM manufacturers WHERE id = '639'
83 0.0010 0.00098109245300293
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
84 0.0015 0.0015430450439453
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
85 0.0022 0.00217604637146
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
86 0.0005 0.00052785873413086
SELECT * FROM productimages WHERE product_id = '2164' ORDER BY sortorder ASC
87 0.0009 0.00092697143554688
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
88 0.0011 0.0011029243469238
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 
89 0.0005 0.00050687789916992
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
90 0.0005 0.00048708915710449
SELECT category_id FROM products_categories WHERE product_id = '966'
91 0.0006 0.00060105323791504
SELECT * FROM categories WHERE id = '27'
92 0.0042 0.0042219161987305
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.0006 0.00064206123352051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00041079521179199
SELECT id FROM categories WHERE parent_id = '27'
95 0.0048 0.0048069953918457
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.0008 0.0008399486541748
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.0009 0.00093793869018555
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.0007 0.00073003768920898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00071310997009277
SELECT * FROM productimages WHERE product_id = '966' ORDER BY sortorder ASC
100 0.0035 0.0034880638122559
SELECT * FROM product_image_select WHERE product_id = '966'
101 0.0028 0.0027978420257568
SELECT * FROM productcustomimages WHERE product_id = '966'
102 0.0026 0.002593994140625
SELECT * FROM productfeeds WHERE product_id = '966' ORDER BY item_date DESC
103 0.0047 0.0046792030334473
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0027 0.0026600360870361
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '966' AND t.hidden = 0 AND display_product = 1
105 0.0014 0.0013980865478516
SELECT * FROM productamazoncontent WHERE product_id = '966'
106 0.0009 0.00093317031860352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname
107 0.0016 0.0015888214111328
SELECT * FROM productoffers WHERE product_id = '966' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0006 0.00061702728271484
SELECT * FROM productoffers
                WHERE product_id = '966' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00058794021606445
SELECT value FROM productattributes WHERE product_id = '966' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00052690505981445
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
111 0.0093 0.0093131065368652
SELECT *, MATCH (description, title) AGAINST ('parfumé 100 origine' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('parfumé 100 origine' IN BOOLEAN MODE) AND 966 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0007 0.00074386596679688
SELECT *, MATCH (description, title) AGAINST ('parfumé 100 origine' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('parfumé 100 origine' IN BOOLEAN MODE) AND 966 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0006 0.00064897537231445
SELECT *, MATCH (description, title) AGAINST ('parfumé 100 origine' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('parfumé 100 origine' IN BOOLEAN MODE) AND 966 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
115 0.0007 0.0006558895111084
SELECT * FROM product_image_select WHERE product_id = '1095'
116 0.0005 0.00045084953308105
SELECT * FROM productcustomimages WHERE product_id = '1095'
117 0.0010 0.00098896026611328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
118 0.0006 0.00056910514831543
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00050115585327148
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0005 0.0005340576171875
SELECT * FROM productimages WHERE product_id = '1199' ORDER BY sortorder ASC
122 0.0006 0.00060582160949707
SELECT * FROM product_image_select WHERE product_id = '1199'
123 0.0005 0.00047516822814941
SELECT * FROM productcustomimages WHERE product_id = '1199'
124 0.0010 0.00098991394042969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1199' AND a.name = n.originalname
125 0.0005 0.00053191184997559
SELECT * FROM productoffers WHERE product_id = '1199' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00046205520629883
SELECT * FROM productoffers
                WHERE product_id = '1199' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00048089027404785
SELECT value FROM productattributes WHERE product_id = '1199' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0005 0.00051093101501465
SELECT * FROM productimages WHERE product_id = '1435' ORDER BY sortorder ASC
129 0.0008 0.00083804130554199
SELECT * FROM product_image_select WHERE product_id = '1435'
130 0.0005 0.0004730224609375
SELECT * FROM productcustomimages WHERE product_id = '1435'
131 0.0011 0.0010650157928467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1435' AND a.name = n.originalname
132 0.0005 0.00051283836364746
SELECT * FROM productoffers WHERE product_id = '1435' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '1435' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '1435' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00053310394287109
SELECT * FROM productimages WHERE product_id = '1443' ORDER BY sortorder ASC
136 0.0007 0.00066399574279785
SELECT * FROM product_image_select WHERE product_id = '1443'
137 0.0005 0.00046801567077637
SELECT * FROM productcustomimages WHERE product_id = '1443'
138 0.0010 0.0010159015655518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1443' AND a.name = n.originalname
139 0.0006 0.00057411193847656
SELECT * FROM productoffers WHERE product_id = '1443' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '1443' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00049209594726562
SELECT value FROM productattributes WHERE product_id = '1443' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00051403045654297
SELECT * FROM productimages WHERE product_id = '966' ORDER BY sortorder ASC
143 0.0007 0.00069689750671387
SELECT * FROM product_image_select WHERE product_id = '966'
144 0.0005 0.0004727840423584
SELECT * FROM productcustomimages WHERE product_id = '966'
145 0.0009 0.00094795227050781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname
146 0.0006 0.00057888031005859
SELECT * FROM productoffers WHERE product_id = '966' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0005 0.0004880428314209
SELECT * FROM productoffers
                WHERE product_id = '966' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0006 0.00055599212646484
SELECT value FROM productattributes WHERE product_id = '966' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0007 0.00068306922912598
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
150 0.0008 0.00077605247497559
SELECT * FROM product_image_select WHERE product_id = '1246'
151 0.0005 0.00052905082702637
SELECT * FROM productcustomimages WHERE product_id = '1246'
152 0.0010 0.00095200538635254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
153 0.0006 0.00061988830566406
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0005 0.00054502487182617
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0006 0.00059199333190918
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0100 0.0099771022796631
SELECT *, MATCH (description, title) AGAINST ('pour specialt machinea' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('pour specialt machinea' IN BOOLEAN MODE) AND 966 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
157 0.0010 0.0010080337524414
SELECT *, MATCH (description, title) AGAINST ('pour specialt machinea' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('pour specialt machinea' IN BOOLEAN MODE) AND 966 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
158 0.0008 0.00078797340393066
SELECT *, MATCH (description, title) AGAINST ('pour specialt machinea' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('pour specialt machinea' IN BOOLEAN MODE) AND 966 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
159 0.0006 0.00059914588928223
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
160 0.0008 0.00075221061706543
SELECT * FROM product_image_select WHERE product_id = '788'
161 0.0005 0.00047898292541504
SELECT * FROM productcustomimages WHERE product_id = '788'
162 0.0010 0.0010418891906738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
163 0.0006 0.00062203407287598
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0005 0.00048518180847168
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0006 0.00055289268493652
SELECT id,asin FROM products WHERE parent_id = 966
167 0.0020 0.0019938945770264
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '966' ORDER BY timestamp DESC
168 0.0005 0.00053787231445312
SELECT category_id FROM products_categories WHERE product_id = '966'
169 0.0006 0.00063610076904297
SELECT * FROM categories WHERE id = '27'
170 0.0036 0.0035789012908936
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
171 0.0005 0.00051712989807129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0005 0.00049710273742676
SELECT id FROM categories WHERE parent_id = '27'
173 0.0036 0.0036070346832275
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 
174 0.0007 0.00073695182800293
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 
175 0.0008 0.00077295303344727
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
176 0.0006 0.00061392784118652
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0010 0.0010290145874023
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname
178 0.0006 0.00058794021606445
SELECT * FROM productoffers WHERE product_id = '966' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0006 0.00058817863464355
SELECT * FROM productoffers
                WHERE product_id = '966' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0007 0.00071406364440918
SELECT * FROM products WHERE id = '966'
181 0.0006 0.00055503845214844
SELECT value FROM productattributes WHERE product_id = '966' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0008 0.00082302093505859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname
183 0.0004 0.0004119873046875
SELECT * FROM productoffers WHERE product_id = '966' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00042009353637695
SELECT * FROM productoffers
                WHERE product_id = '966' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0006 0.00057101249694824
SELECT category_id FROM products_categories WHERE product_id = '966' AND prod_type = 'amz'
186 0.0005 0.00053882598876953
SELECT parent_id FROM categories WHERE id = '27'
187 0.0005 0.00048995018005371
SELECT * FROM categories WHERE id = '27'
188 0.0039 0.0039389133453369
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.0005 0.0004889965057373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190 0.0004 0.00037598609924316
SELECT id FROM categories WHERE parent_id = '27'
191 0.0035 0.0034940242767334
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.0006 0.0005650520324707
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.0006 0.00057506561279297
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.0005 0.00048995018005371
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195 0.0020 0.0019519329071045
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
196 0.0014 0.0013949871063232
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
197 0.0006 0.00062894821166992
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
198 0.0128 0.012768030166626
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.0020 0.0019590854644775
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.0006 0.00060486793518066
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.0006 0.00063300132751465
SELECT * FROM products WHERE id = 1626
202 0.0006 0.00060105323791504
SELECT * FROM products WHERE id = 4041
203 0.0006 0.00058507919311523
SELECT * FROM products WHERE id = 4312
204 0.0006 0.00057411193847656
SELECT * FROM products WHERE id = 777
205 0.0004 0.00042915344238281
SELECT * FROM products WHERE id = 3881
206 0.0004 0.00043010711669922
SELECT * FROM products WHERE id = 4213
207 0.0006 0.00062704086303711
SELECT * FROM products WHERE id = '1626'
208 0.0005 0.00052881240844727
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
209 0.0006 0.0006260871887207
SELECT * FROM product_image_select WHERE product_id = '1626'
210 0.0004 0.00042605400085449
SELECT * FROM productcustomimages WHERE product_id = '1626'
211 0.0009 0.00087308883666992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
212 0.0005 0.00050520896911621
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0005 0.00046491622924805
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0006 0.00063300132751465
SELECT * FROM products WHERE id = '4041'
216 0.0005 0.00048017501831055
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
217 0.0006 0.00060796737670898
SELECT * FROM product_image_select WHERE product_id = '4041'
218 0.0004 0.00041484832763672
SELECT * FROM productcustomimages WHERE product_id = '4041'
219 0.0011 0.0010509490966797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
220 0.0005 0.00047588348388672
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0006 0.00056314468383789
SELECT * FROM products WHERE id = '4312'
224 0.0005 0.00046086311340332
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
225 0.0006 0.00058293342590332
SELECT * FROM product_image_select WHERE product_id = '4312'
226 0.0004 0.00037789344787598
SELECT * FROM productcustomimages WHERE product_id = '4312'
227 0.0010 0.0010180473327637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
228 0.0005 0.0004878044128418
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0004 0.00044608116149902
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0006 0.00055384635925293
SELECT * FROM products WHERE id = '777'
232 0.0005 0.00046896934509277
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0011 0.0011270046234131
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0012 0.0012290477752686
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0018 0.0018489360809326
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0007 0.00067305564880371
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0006 0.00060796737670898
SELECT * FROM products WHERE id = '3881'
240 0.0007 0.00072216987609863
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
241 0.0007 0.00068092346191406
SELECT * FROM product_image_select WHERE product_id = '3881'
242 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '3881'
243 0.0016 0.0016200542449951
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
244 0.0006 0.00055217742919922
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0005 0.00054717063903809
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0006 0.00063705444335938
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0012 0.0011827945709229
SELECT * FROM products WHERE id = '4213'
248 0.0013 0.0012938976287842
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
249 0.0118 0.011795997619629
SELECT * FROM product_image_select WHERE product_id = '4213'
250 0.0039 0.0039339065551758
SELECT * FROM productcustomimages WHERE product_id = '4213'
251 0.0014 0.0013871192932129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
252 0.0006 0.00058317184448242
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0005 0.00048708915710449
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0022 0.0021710395812988
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
256 0.0007 0.00071811676025391
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
257 0.0027 0.0026619434356689
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
258 0.0017 0.0017480850219727
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0007 0.00066995620727539
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0013 0.0013458728790283
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'