0

Max Benjamin Diffuseur de Parfum Rooibos 100 ml

Price: €30,00
Product prices and availability are accurate as of 2022-06-26 03:37:23 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.

Product Features

Décorative bougies parfumées et diffuseurs de parfums de haute qualité - Réalisation artisanale Fabriqué à la main en Irlande Collection 2017

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.4480950832367 251 0.9461 0


No Amazon API Requests Made.


App Debug - Total Time 1.4480950832367 seconds

Number Time From Start Name Description
1 0.43437814712524 Initialise Initialise FSB Function
2 0.44419813156128 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4833071231842 Start of getCategoryListByGroup Function Before first category groups query
4 0.48565316200256 After initial query Before first category groups query
5 0.48565602302551 Get Category List for Group Before the call to getCategoryList function
6 0.48566603660583 Start of GetCategoryList function Start of the function
7 0.48567199707031 Before getting categories Query to get specific category list
8 0.48765921592712 After getting categories Query to get specific category list
9 0.48766207695007 Before getting category custom Before call to function getCategoryCustom
10 0.51312518119812 After getting category custom After call to function getCategoryCustom
11 0.51312899589539 Before getting category custom Before call to function getCategoryCustom
12 0.52918004989624 After getting category custom After call to function getCategoryCustom
13 0.5291850566864 Before getting category custom Before call to function getCategoryCustom
14 0.5412540435791 After getting category custom After call to function getCategoryCustom
15 0.54125809669495 Before getting category custom Before call to function getCategoryCustom
16 0.55544805526733 After getting category custom After call to function getCategoryCustom
17 0.55545115470886 Before getting category custom Before call to function getCategoryCustom
18 0.56241106987 After getting category custom After call to function getCategoryCustom
19 0.56241512298584 Before getting category custom Before call to function getCategoryCustom
20 0.56941199302673 After getting category custom After call to function getCategoryCustom
21 0.56941604614258 End of GetCategoryList function End of the function
22 0.56942701339722 Get Category List for Group Before the call to getCategoryList function
23 0.56943011283875 Start of GetCategoryList function Start of the function
24 0.56943416595459 Before getting categories Query to get specific category list
25 0.57010817527771 End of getCategoryListByGroup Function Before return()
26 1.1294031143188 App Controller End End of the App controller (called before the controller of every page)
27 1.1296942234039 Product Start Start of the product info controller
28 1.1579082012177 Cache file not found Starting get product details
29 1.2105491161346 Related products Start getting related products if enabled
30 1.2105510234833 Related Products Start Before the related products are found
31 1.2105522155762 Related Products Keywords Before the related product keywords are found
32 1.2105560302734 Create Keyword List Function Start of function
33 1.2106420993805 Create Keyword List Function After looping provided content - 18 keywords found
34 1.2115640640259 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
35 1.2115750312805 Create Keyword List Function After reducing keyword list
36 1.211629152298 Create Keyword List Function After selecting by scoring keywords
37 1.2116351127625 Create Keyword List Function After final loop of keywords
38 1.2116370201111 Related Products Keywords After the related product keywords are found
39 1.2510900497437 Related Products End After the related products are found
40 1.3052961826324 Product End End of the product info controller (Product Info)
41 1.3099501132965 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3150482177734 Before Get Options Before the call to getOptions in the tpl class
43 1.3913810253143 After Get Options After the call to getOptions in the tpl class
44 1.3915531635284 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3915801048279 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4234440326691 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4234511852264 Product Info: Before Template Display Before the template is displayed
48 1.4480760097504 Product Info: After Template Display After the template is displayed
49 1.4480822086334 Finalizing debug Before the debug is output to the page.
50 1.4480941295624 End of App This is the end of the app logging, final timestamp


Query Debug - 251 Database Queries. Total time 0.9461 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0024 0.0024468898773193
SELECT parameter, value FROM parameters
2 0.0079 0.0078659057617188
SELECT * FROM `bad_bots`
3 0.0005 0.00046300888061523
SET time_zone = 'Europe/London'
4 0.0036 0.0036039352416992
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0035 0.003464937210083
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.81\";}'
6 0.0034 0.0033798217773438
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739318557'
7 0.0043 0.0042879581451416
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00077915191650391
UPDATE autorun SET lastrun = '2025-02-12 00:02:37' WHERE id = '16'
9 0.0011 0.0010619163513184
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0035 0.0034890174865723
SELECT id FROM pages WHERE pagename = 'max-benjamin-diffuseur-de-parfum-rooibos-100ml' LIMIT 1
11 0.0046 0.0046250820159912
SELECT id FROM products WHERE pagename = 'max-benjamin-diffuseur-de-parfum-rooibos-100ml' AND hidden = 0 LIMIT 1
12 0.0044 0.0044240951538086
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0333 0.033277988433838
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0008 0.00080299377441406
SELECT * FROM pages WHERE pagename = 'max-benjamin-diffuseur-de-parfum-rooibos-100ml'
15 0.0023 0.0023269653320312
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0020 0.0019500255584717
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0090 0.0090470314025879
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.0020 0.0020279884338379
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.0015 0.001478910446167
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.0005490779876709
SELECT id FROM categories WHERE parent_id = '26'
21 0.0057 0.0057249069213867
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.0028 0.0027570724487305
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.0016059875488281
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.0016 0.0015809535980225
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00046014785766602
SELECT * FROM categorygroups WHERE id = '1'
26 0.0037 0.0036590099334717
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0005 0.00052690505981445
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.0021 0.002068042755127
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0033 0.0033469200134277
SELECT id FROM categories WHERE parent_id = '27'
30 0.0039 0.00394606590271
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.00063800811767578
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.00064921379089355
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.0006 0.00055694580078125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00049114227294922
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0016410350799561
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.0011 0.0010719299316406
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.0007 0.00073695182800293
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0008 0.00080084800720215
SELECT id FROM categories WHERE parent_id = '28'
39 0.0040 0.0039849281311035
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0010 0.0010170936584473
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.0011 0.0010600090026855
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.0009 0.00091981887817383
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0007 0.0007011890411377
SELECT * FROM categorygroups WHERE id = '1'
44 0.0011 0.0010929107666016
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.0008 0.0008080005645752
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.0007 0.00069022178649902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0008 0.00081300735473633
SELECT id FROM categories WHERE parent_id = '29'
48 0.0076 0.0075638294219971
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.0008 0.00079512596130371
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.0009 0.00085210800170898
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.0007 0.00072598457336426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0007 0.00068211555480957
SELECT * FROM categorygroups WHERE id = '1'
53 0.0011 0.001060962677002
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.0007 0.00074195861816406
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.0006 0.00063991546630859
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0007 0.0007331371307373
SELECT id FROM categories WHERE parent_id = '30'
57 0.0012 0.0011930465698242
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0006 0.00063896179199219
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.0007 0.00065398216247559
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.0006 0.00057601928710938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0006 0.00061511993408203
SELECT * FROM categorygroups WHERE id = '1'
62 0.0009 0.00088000297546387
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.0006 0.0006248950958252
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.0006 0.00056910514831543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00053000450134277
SELECT id FROM categories WHERE parent_id = '31'
66 0.0009 0.00093483924865723
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.0007 0.00065302848815918
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.0008 0.00077605247497559
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.0013 0.0012989044189453
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00057792663574219
SELECT * FROM categorygroups WHERE id = '1'
71 0.0007 0.00065803527832031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0036 0.0036489963531494
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0019 0.0018830299377441
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.00070786476135254
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.0015 0.0015349388122559
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0033 0.0032918453216553
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0023 0.0023009777069092
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5406 0.54060983657837
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.0023 0.002284049987793
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0013 0.0013251304626465
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00076889991760254
SELECT * FROM products WHERE pagename = 'max-benjamin-diffuseur-de-parfum-rooibos-100ml'
82 0.0005 0.00045585632324219
UPDATE products SET viewcount = viewcount + 1 WHERE id = 988
83 0.0010 0.00098395347595215
SELECT * FROM manufacturers WHERE id = '178'
84 0.0007 0.00071406364440918
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '178'
85 0.0026 0.0026109218597412
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '178' LIMIT 1
86 0.0029 0.0028541088104248
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '178' ORDER BY RAND() LIMIT 1
87 0.0013 0.0012929439544678
SELECT * FROM productimages WHERE product_id = '988' ORDER BY sortorder ASC
88 0.0008 0.00076508522033691
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '178'
89 0.0008 0.00084590911865234
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '178'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0010 0.0010218620300293
SELECT * FROM manufacturerimages WHERE manufacturer_id = '178'
91 0.0008 0.00081396102905273
SELECT category_id FROM products_categories WHERE product_id = '988'
92 0.0010 0.00095105171203613
SELECT * FROM categories WHERE id = '27'
93 0.0075 0.0074999332427979
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
94 0.0008 0.00075483322143555
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0006 0.0006248950958252
SELECT id FROM categories WHERE parent_id = '27'
96 0.0070 0.0070309638977051
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
97 0.0008 0.00078701972961426
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.0008 0.00084805488586426
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.0011 0.0011270046234131
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0016 0.0016169548034668
SELECT * FROM productimages WHERE product_id = '988' ORDER BY sortorder ASC
101 0.0025 0.002528190612793
SELECT * FROM product_image_select WHERE product_id = '988'
102 0.0016 0.0015671253204346
SELECT * FROM productcustomimages WHERE product_id = '988'
103 0.0016 0.0015749931335449
SELECT * FROM productfeeds WHERE product_id = '988' ORDER BY item_date DESC
104 0.0037 0.0036671161651611
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '988' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0030 0.0030298233032227
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '988' AND t.hidden = 0 AND display_product = 1
106 0.0017 0.0017349720001221
SELECT * FROM productamazoncontent WHERE product_id = '988'
107 0.0012 0.0011601448059082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '988' AND a.name = n.originalname
108 0.0016 0.001629114151001
SELECT * FROM productoffers WHERE product_id = '988' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0005 0.00051307678222656
SELECT * FROM productoffers
                WHERE product_id = '988' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0006 0.00058889389038086
SELECT value FROM productattributes WHERE product_id = '988' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0006 0.00057387351989746
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
112 0.0107 0.0106520652771
SELECT *, MATCH (description, title) AGAINST ('parfum rooibos 100ml' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('parfum rooibos 100ml' IN BOOLEAN MODE) AND 988 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
113 0.0009 0.0009310245513916
SELECT *, MATCH (description, title) AGAINST ('parfum rooibos 100ml' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('parfum rooibos 100ml' IN BOOLEAN MODE) AND 988 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0007 0.00066208839416504
SELECT *, MATCH (description, title) AGAINST ('parfum rooibos 100ml' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('parfum rooibos 100ml' IN BOOLEAN MODE) AND 988 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.0007171630859375
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
116 0.0007 0.0006871223449707
SELECT * FROM product_image_select WHERE product_id = '862'
117 0.0005 0.00047707557678223
SELECT * FROM productcustomimages WHERE product_id = '862'
118 0.0013 0.0012550354003906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
119 0.0005 0.00053095817565918
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0006 0.00055098533630371
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
123 0.0006 0.00061607360839844
SELECT * FROM product_image_select WHERE product_id = '890'
124 0.0004 0.00042390823364258
SELECT * FROM productcustomimages WHERE product_id = '890'
125 0.0011 0.0010731220245361
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
126 0.0006 0.0005638599395752
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00048303604125977
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
130 0.0007 0.00068211555480957
SELECT * FROM product_image_select WHERE product_id = '878'
131 0.0004 0.00042390823364258
SELECT * FROM productcustomimages WHERE product_id = '878'
132 0.0010 0.0010309219360352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
133 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00044393539428711
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00041985511779785
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0006 0.00060081481933594
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
137 0.0006 0.00057888031005859
SELECT * FROM product_image_select WHERE product_id = '869'
138 0.0004 0.00043511390686035
SELECT * FROM productcustomimages WHERE product_id = '869'
139 0.0015 0.00154709815979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
140 0.0005 0.00050592422485352
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0006 0.00059890747070312
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
144 0.0006 0.00062012672424316
SELECT * FROM product_image_select WHERE product_id = '858'
145 0.0004 0.00041508674621582
SELECT * FROM productcustomimages WHERE product_id = '858'
146 0.0011 0.0011019706726074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
147 0.0005 0.00053000450134277
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0005 0.00049209594726562
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
151 0.0006 0.00060892105102539
SELECT * FROM product_image_select WHERE product_id = '865'
152 0.0007 0.00068402290344238
SELECT * FROM productcustomimages WHERE product_id = '865'
153 0.0008 0.00080394744873047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
154 0.0007 0.00067305564880371
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0005 0.00050997734069824
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0007 0.00067496299743652
SELECT id,asin FROM products WHERE parent_id = 988
158 0.0040 0.0039961338043213
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '988' ORDER BY timestamp DESC
159 0.0022 0.0021929740905762
SELECT category_id FROM products_categories WHERE product_id = '988'
160 0.0020 0.0019838809967041
SELECT * FROM categories WHERE id = '27'
161 0.0128 0.012844085693359
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
162 0.0010 0.0010058879852295
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0006 0.00060796737670898
SELECT id FROM categories WHERE parent_id = '27'
164 0.0071 0.0070779323577881
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 
165 0.0010 0.0010240077972412
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 
166 0.0010 0.00099587440490723
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
167 0.0008 0.00082898139953613
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0012 0.0011980533599854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '988' AND a.name = n.originalname
169 0.0007 0.00065517425537109
SELECT * FROM productoffers WHERE product_id = '988' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0005 0.00052905082702637
SELECT * FROM productoffers
                WHERE product_id = '988' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0007 0.00071501731872559
SELECT * FROM products WHERE id = '988'
172 0.0006 0.00061392784118652
SELECT value FROM productattributes WHERE product_id = '988' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0008 0.00082612037658691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '988' AND a.name = n.originalname
174 0.0005 0.00046205520629883
SELECT * FROM productoffers WHERE product_id = '988' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0005 0.00050902366638184
SELECT * FROM productoffers
                WHERE product_id = '988' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0006 0.00055789947509766
SELECT category_id FROM products_categories WHERE product_id = '988' AND prod_type = 'amz'
177 0.0006 0.00056004524230957
SELECT parent_id FROM categories WHERE id = '27'
178 0.0004 0.00043106079101562
SELECT * FROM categories WHERE id = '27'
179 0.0049 0.0049059391021729
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
180 0.0006 0.00062704086303711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
181 0.0004 0.00040197372436523
SELECT id FROM categories WHERE parent_id = '27'
182 0.0044 0.0044100284576416
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 
183 0.0008 0.00078678131103516
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 
184 0.0007 0.00069403648376465
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
185 0.0013 0.0013010501861572
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
186 0.0043 0.0042929649353027
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
187 0.0042 0.0041530132293701
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
188 0.0008 0.00079107284545898
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
189 0.0281 0.028116941452026
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
190 0.0021 0.0021018981933594
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
191 0.0006 0.00064802169799805
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
192 0.0006 0.0006251335144043
SELECT * FROM products WHERE id = 1626
193 0.0005 0.00050687789916992
SELECT * FROM products WHERE id = 4041
194 0.0005 0.00049805641174316
SELECT * FROM products WHERE id = 4312
195 0.0004 0.00044894218444824
SELECT * FROM products WHERE id = 777
196 0.0004 0.00042986869812012
SELECT * FROM products WHERE id = 3881
197 0.0004 0.00043892860412598
SELECT * FROM products WHERE id = 4213
198 0.0004 0.00043892860412598
SELECT * FROM products WHERE id = '1626'
199 0.0005 0.00052690505981445
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
200 0.0006 0.00064611434936523
SELECT * FROM product_image_select WHERE product_id = '1626'
201 0.0005 0.00051498413085938
SELECT * FROM productcustomimages WHERE product_id = '1626'
202 0.0010 0.00096511840820312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
203 0.0006 0.00056099891662598
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0005 0.00052595138549805
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0005 0.00048708915710449
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0006 0.00061798095703125
SELECT * FROM products WHERE id = '4041'
207 0.0005 0.00054383277893066
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
208 0.0007 0.00071001052856445
SELECT * FROM product_image_select WHERE product_id = '4041'
209 0.0005 0.00046110153198242
SELECT * FROM productcustomimages WHERE product_id = '4041'
210 0.0012 0.0012259483337402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
211 0.0006 0.00055694580078125
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0005 0.0004570484161377
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0007 0.0006871223449707
SELECT * FROM products WHERE id = '4312'
215 0.0005 0.00053501129150391
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
216 0.0007 0.00073599815368652
SELECT * FROM product_image_select WHERE product_id = '4312'
217 0.0004 0.00044894218444824
SELECT * FROM productcustomimages WHERE product_id = '4312'
218 0.0012 0.0011868476867676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
219 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0005 0.00047588348388672
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00044608116149902
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0006 0.00059795379638672
SELECT * FROM products WHERE id = '777'
223 0.0005 0.00051593780517578
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
224 0.0007 0.00065398216247559
SELECT * FROM product_image_select WHERE product_id = '777'
225 0.0004 0.0004279613494873
SELECT * FROM productcustomimages WHERE product_id = '777'
226 0.0012 0.0011699199676514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
227 0.0006 0.00056695938110352
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0005 0.0005030632019043
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0007 0.00065803527832031
SELECT * FROM products WHERE id = '3881'
231 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
232 0.0006 0.00064587593078613
SELECT * FROM product_image_select WHERE product_id = '3881'
233 0.0004 0.00043892860412598
SELECT * FROM productcustomimages WHERE product_id = '3881'
234 0.0013 0.0013442039489746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
235 0.0006 0.00057578086853027
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0005 0.00047683715820312
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0005 0.00052905082702637
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0007 0.00071001052856445
SELECT * FROM products WHERE id = '4213'
239 0.0006 0.00062298774719238
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
240 0.0007 0.00071310997009277
SELECT * FROM product_image_select WHERE product_id = '4213'
241 0.0004 0.00043606758117676
SELECT * FROM productcustomimages WHERE product_id = '4213'
242 0.0014 0.00142502784729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
243 0.0007 0.00069904327392578
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0006 0.00061607360839844
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0006 0.0006108283996582
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0023 0.0023269653320312
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
247 0.0009 0.00090193748474121
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
248 0.0031 0.00313401222229
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
249 0.0020 0.0019869804382324
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0006 0.00063180923461914
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
251 0.0018 0.0017740726470947
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'