0

Thés du Hammam

Price: €15,45
Product prices and availability are accurate as of 2022-06-12 20:17:27 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
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.3560678958893 251 1.0871 0


No Amazon API Requests Made.


App Debug - Total Time 1.3560678958893 seconds

Number Time From Start Name Description
1 0.25744795799255 Initialise Initialise FSB Function
2 0.26396989822388 App Controller Start Start of the App controller (called before the controller of every page)
3 0.29549789428711 Start of getCategoryListByGroup Function Before first category groups query
4 0.29693484306335 After initial query Before first category groups query
5 0.29693579673767 Get Category List for Group Before the call to getCategoryList function
6 0.29693794250488 Start of GetCategoryList function Start of the function
7 0.29693984985352 Before getting categories Query to get specific category list
8 0.29842591285706 After getting categories Query to get specific category list
9 0.29842686653137 Before getting category custom Before call to function getCategoryCustom
10 0.32701992988586 After getting category custom After call to function getCategoryCustom
11 0.32702279090881 Before getting category custom Before call to function getCategoryCustom
12 0.3409628868103 After getting category custom After call to function getCategoryCustom
13 0.34096479415894 Before getting category custom Before call to function getCategoryCustom
14 0.34773778915405 After getting category custom After call to function getCategoryCustom
15 0.34773898124695 Before getting category custom Before call to function getCategoryCustom
16 0.35230493545532 After getting category custom After call to function getCategoryCustom
17 0.35230898857117 Before getting category custom Before call to function getCategoryCustom
18 0.3568549156189 After getting category custom After call to function getCategoryCustom
19 0.35685586929321 Before getting category custom Before call to function getCategoryCustom
20 0.36214900016785 After getting category custom After call to function getCategoryCustom
21 0.36214995384216 End of GetCategoryList function End of the function
22 0.36215496063232 Get Category List for Group Before the call to getCategoryList function
23 0.36215591430664 Start of GetCategoryList function Start of the function
24 0.36215782165527 Before getting categories Query to get specific category list
25 0.36269092559814 End of getCategoryListByGroup Function Before return()
26 1.1874868869781 App Controller End End of the App controller (called before the controller of every page)
27 1.1880958080292 Product Start Start of the product info controller
28 1.1897909641266 Cache file not found Starting get product details
29 1.2174627780914 Related products Start getting related products if enabled
30 1.2174639701843 Related Products Start Before the related products are found
31 1.2174639701843 Related Products Keywords Before the related product keywords are found
32 1.2174668312073 Create Keyword List Function Start of function
33 1.2175269126892 Create Keyword List Function After looping provided content - 6 keywords found
34 1.2176399230957 Create Keyword List Function After looping initial keyword list - 5 keywords remaining
35 1.2176439762115 Create Keyword List Function After reducing keyword list
36 1.2176468372345 Create Keyword List Function After selecting by scoring keywords
37 1.2176489830017 Create Keyword List Function After final loop of keywords
38 1.2176489830017 Related Products Keywords After the related product keywords are found
39 1.252525806427 Related Products End After the related products are found
40 1.2688779830933 Product End End of the product info controller (Product Info)
41 1.2708158493042 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.27263879776 Before Get Options Before the call to getOptions in the tpl class
43 1.3285698890686 After Get Options After the call to getOptions in the tpl class
44 1.3286678791046 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3286879062653 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.3373618125916 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3373639583588 Product Info: Before Template Display Before the template is displayed
48 1.3560519218445 Product Info: After Template Display After the template is displayed
49 1.3560588359833 Finalizing debug Before the debug is output to the page.
50 1.356066942215 End of App This is the end of the app logging, final timestamp


Query Debug - 251 Database Queries. Total time 1.0871 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022239685058594
SELECT parameter, value FROM parameters
2 0.0071 0.007112979888916
SELECT * FROM `bad_bots`
3 0.0004 0.00040698051452637
SET time_zone = 'Europe/London'
4 0.0029 0.0028669834136963
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0030 0.0029661655426025
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.222.135.39\";}'
6 0.0029 0.002871036529541
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746474548'
7 0.0034 0.0033838748931885
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00054192543029785
UPDATE autorun SET lastrun = '2025-05-05 19:49:09' WHERE id = '15'
9 0.0007 0.00068378448486328
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0024 0.0024220943450928
SELECT id FROM pages WHERE pagename = 'thes-du-hammam' LIMIT 1
11 0.0028 0.0028362274169922
SELECT id FROM products WHERE pagename = 'thes-du-hammam' AND hidden = 0 LIMIT 1
12 0.0030 0.0030288696289062
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0276 0.027557134628296
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00058484077453613
SELECT * FROM pages WHERE pagename = 'thes-du-hammam'
15 0.0014 0.0014281272888184
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0015 0.0014669895172119
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0070 0.0070171356201172
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.001777172088623
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.0014 0.0014400482177734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00051689147949219
SELECT id FROM categories WHERE parent_id = '26'
21 0.0090 0.0090048313140869
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.0040 0.0039618015289307
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.0026 0.0026068687438965
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0017 0.0017030239105225
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00044608116149902
SELECT * FROM categorygroups WHERE id = '1'
26 0.0050 0.0049610137939453
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.00056290626525879
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.0004119873046875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00046896934509277
SELECT id FROM categories WHERE parent_id = '27'
30 0.0051 0.0051488876342773
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.0005800724029541
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.0007 0.00069689750671387
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.00051212310791016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00050783157348633
SELECT * FROM categorygroups WHERE id = '1'
35 0.0018 0.0017518997192383
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.0006 0.00055289268493652
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.00045490264892578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00041484832763672
SELECT id FROM categories WHERE parent_id = '28'
39 0.0015 0.0015480518341064
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.0005 0.00052809715270996
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.0005 0.00054216384887695
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.0005 0.00048589706420898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00043988227844238
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00060892105102539
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.00049090385437012
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.0004 0.00041699409484863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00046110153198242
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00064492225646973
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.0005 0.00048279762268066
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.0005 0.00049400329589844
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0005 0.00050806999206543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00039982795715332
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00058507919311523
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.0004 0.00044584274291992
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00041699409484863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00043201446533203
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00067710876464844
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.0005 0.00046396255493164
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.0005 0.00054717063903809
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0005 0.00048303604125977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00046205520629883
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00059914588928223
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.00056290626525879
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.00060486793518066
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0006 0.00060606002807617
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00083112716674805
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.0006 0.00055408477783203
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.0006 0.00055789947509766
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.0005 0.00045204162597656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.0005040168762207
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00052905082702637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0033 0.0033280849456787
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0015 0.0015408992767334
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00049996376037598
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.0011 0.0011179447174072
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0014 0.0013699531555176
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00077486038208008
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8113 0.81125092506409
SELECT * FROM ipgeocountries WHERE INET_ATON('18.222.135.39') >= INET_ATON(ip_start) AND INET_ATON('18.222.135.39') <= INET_ATON(ip_end)
79 0.0021 0.0020551681518555
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0013 0.0013010501861572
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00065708160400391
SELECT * FROM products WHERE pagename = 'thes-du-hammam'
82 0.0005 0.00047516822814941
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3579
83 0.0005 0.00050520896911621
SELECT * FROM manufacturers WHERE id = '639'
84 0.0011 0.0010550022125244
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85 0.0013 0.0013439655303955
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
86 0.0020 0.0019969940185547
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.0004 0.00039815902709961
SELECT * FROM productimages WHERE product_id = '3579' ORDER BY sortorder ASC
88 0.0009 0.00085997581481934
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
89 0.0008 0.00081706047058105
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.0004 0.00038290023803711
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
91 0.0004 0.00037813186645508
SELECT category_id FROM products_categories WHERE product_id = '3579'
92 0.0003 0.00032186508178711
SELECT * FROM productimages WHERE product_id = '3579' ORDER BY sortorder ASC
93 0.0007 0.00065302848815918
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3579' AND p.id = pi.product_id ORDER BY pi.sortorder
94 0.0015 0.0015349388122559
SELECT * FROM product_image_select WHERE product_id = '3579'
95 0.0011 0.0010719299316406
SELECT * FROM productcustomimages WHERE product_id = '3579'
96 0.0010 0.0010459423065186
SELECT * FROM productfeeds WHERE product_id = '3579' ORDER BY item_date DESC
97 0.0021 0.0020720958709717
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3579' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
98 0.0021 0.002108097076416
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3579' AND t.hidden = 0 AND display_product = 1
99 0.0015 0.0015320777893066
SELECT * FROM productamazoncontent WHERE product_id = '3579'
100 0.0014 0.0014479160308838
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3579'
                GROUP BY o.product_id
101 0.0021 0.002126932144165
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3579'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
102 0.0005 0.0005030632019043
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3579
103 0.0008 0.00077700614929199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3579' AND a.name = n.originalname
104 0.0004 0.00039005279541016
SELECT * FROM productoffers WHERE product_id = '3579' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '3579' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0003 0.00033116340637207
SELECT * FROM productoffers
                WHERE product_id = 3579
                ORDER BY price ASC LIMIT 1
107 0.0004 0.00036406517028809
SELECT value FROM productattributes
                WHERE product_id = '3579'
                AND name = 'ListPriceAmount'
108 0.0004 0.00044012069702148
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3579'
                GROUP BY o.product_id
109 0.0006 0.0006110668182373
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3579'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
110 0.0004 0.00038504600524902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3579
111 0.0005 0.00049495697021484
SELECT value FROM productattributes WHERE product_id = '3579' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0006 0.0005500316619873
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3579'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
113 0.0005 0.00052213668823242
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.0109 0.010892868041992
SELECT *, MATCH (description, title) AGAINST ('thés du hammam' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thés du hammam' IN BOOLEAN MODE) AND 3579 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0009 0.00087499618530273
SELECT *, MATCH (description, title) AGAINST ('thés du hammam' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thés du hammam' IN BOOLEAN MODE) AND 3579 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0006 0.00057411193847656
SELECT *, MATCH (description, title) AGAINST ('thés du hammam' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thés du hammam' IN BOOLEAN MODE) AND 3579 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0006 0.00056004524230957
SELECT * FROM productimages WHERE product_id = '957' ORDER BY sortorder ASC
118 0.0006 0.0005948543548584
SELECT * FROM product_image_select WHERE product_id = '957'
119 0.0004 0.00037312507629395
SELECT * FROM productcustomimages WHERE product_id = '957'
120 0.0010 0.00097298622131348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '957' AND a.name = n.originalname
121 0.0005 0.00046014785766602
SELECT * FROM productoffers WHERE product_id = '957' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0004 0.00042891502380371
SELECT * FROM productoffers
                WHERE product_id = '957' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '957' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0005 0.00045394897460938
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
125 0.0006 0.00058317184448242
SELECT * FROM product_image_select WHERE product_id = '780'
126 0.0004 0.00039410591125488
SELECT * FROM productcustomimages WHERE product_id = '780'
127 0.0008 0.00079989433288574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
128 0.0004 0.00041413307189941
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0004 0.00038909912109375
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0005 0.00052809715270996
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
132 0.0006 0.00058889389038086
SELECT * FROM product_image_select WHERE product_id = '4919'
133 0.0004 0.00040292739868164
SELECT * FROM productcustomimages WHERE product_id = '4919'
134 0.0011 0.0011301040649414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
135 0.0005 0.00046491622924805
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00038886070251465
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0005 0.00050711631774902
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00051188468933105
SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
139 0.0006 0.0005650520324707
SELECT * FROM product_image_select WHERE product_id = '998'
140 0.0004 0.00036001205444336
SELECT * FROM productcustomimages WHERE product_id = '998'
141 0.0009 0.00087499618530273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
142 0.0005 0.00047087669372559
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00035810470581055
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0004 0.00043082237243652
SELECT * FROM productimages WHERE product_id = '929' ORDER BY sortorder ASC
146 0.0006 0.0005640983581543
SELECT * FROM product_image_select WHERE product_id = '929'
147 0.0004 0.00035715103149414
SELECT * FROM productcustomimages WHERE product_id = '929'
148 0.0007 0.00069189071655273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '929' AND a.name = n.originalname
149 0.0004 0.00041389465332031
SELECT * FROM productoffers WHERE product_id = '929' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '929' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '929' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.00045204162597656
SELECT * FROM productimages WHERE product_id = '1007' ORDER BY sortorder ASC
153 0.0006 0.00060200691223145
SELECT * FROM product_image_select WHERE product_id = '1007'
154 0.0004 0.0004417896270752
SELECT * FROM productcustomimages WHERE product_id = '1007'
155 0.0010 0.0010471343994141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1007' AND a.name = n.originalname
156 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '1007' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0004 0.0003819465637207
SELECT * FROM productoffers
                WHERE product_id = '1007' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '1007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00047492980957031
SELECT id,asin FROM products WHERE parent_id = 3579
160 0.0005 0.00046682357788086
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4732
161 0.0005 0.00053596496582031
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4732
162 0.0004 0.00036716461181641
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4733
163 0.0005 0.00046801567077637
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4733
164 0.0019 0.0018959045410156
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3579' ORDER BY timestamp DESC
165 0.0004 0.00041890144348145
SELECT category_id FROM products_categories WHERE product_id = '3579'
166 0.0009 0.00086498260498047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3579' AND a.name = n.originalname
167 0.0006 0.00058603286743164
SELECT * FROM productoffers WHERE product_id = '3579' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0004 0.00041484832763672
SELECT * FROM productoffers
                WHERE product_id = '3579' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0005 0.00045084953308105
SELECT * FROM productoffers
                WHERE product_id = 3579
                ORDER BY price ASC LIMIT 1
170 0.0004 0.00043702125549316
SELECT value FROM productattributes
                WHERE product_id = '3579'
                AND name = 'ListPriceAmount'
171 0.0006 0.00057005882263184
SELECT * FROM products WHERE id = '3579'
172 0.0005 0.00051999092102051
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3579'
                GROUP BY o.product_id
173 0.0007 0.00067806243896484
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3579'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0005 0.00049996376037598
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3579
175 0.0006 0.00060319900512695
SELECT value FROM productattributes WHERE product_id = '3579' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0007 0.00071597099304199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3579' AND a.name = n.originalname
177 0.0004 0.00044608116149902
SELECT * FROM productoffers WHERE product_id = '3579' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '3579' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0003 0.00030303001403809
SELECT * FROM productoffers
                WHERE product_id = 3579
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00052809715270996
SELECT value FROM productattributes
                WHERE product_id = '3579'
                AND name = 'ListPriceAmount'
181 0.0005 0.00051593780517578
SELECT DISTINCT (name) FROM productoptions
182 0.0006 0.00058794021606445
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3579))
183 0.0004 0.00040817260742188
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 3579
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
184 0.0015 0.0015089511871338
SELECT * FROM translationsfilter
185 0.0005 0.0004889965057373
SELECT category_id FROM products_categories WHERE product_id = '3579' AND prod_type = 'amz'
186 0.0014 0.0014278888702393
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
187 0.0014 0.0013878345489502
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
188 0.0004 0.0003969669342041
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
189 0.0134 0.013442039489746
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.0020501613616943
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.00060796737670898
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.00059390068054199
SELECT * FROM products WHERE id = 1626
193 0.0004 0.00037312507629395
SELECT * FROM products WHERE id = 4041
194 0.0004 0.00043010711669922
SELECT * FROM products WHERE id = 4312
195 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = 777
196 0.0005 0.00047087669372559
SELECT * FROM products WHERE id = 3881
197 0.0004 0.00043702125549316
SELECT * FROM products WHERE id = 4213
198 0.0004 0.00042319297790527
SELECT * FROM products WHERE id = '1626'
199 0.0005 0.00053191184997559
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
200 0.0007 0.00070405006408691
SELECT * FROM product_image_select WHERE product_id = '1626'
201 0.0005 0.00046706199645996
SELECT * FROM productcustomimages WHERE product_id = '1626'
202 0.0011 0.0010669231414795
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.00055503845214844
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0005 0.00051689147949219
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0006 0.00056004524230957
SELECT * FROM products WHERE id = '4041'
207 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
208 0.0007 0.00070500373840332
SELECT * FROM product_image_select WHERE product_id = '4041'
209 0.0004 0.00043392181396484
SELECT * FROM productcustomimages WHERE product_id = '4041'
210 0.0015 0.0014579296112061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
211 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0004 0.00041484832763672
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0005 0.00048494338989258
SELECT * FROM products WHERE id = '4312'
215 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
216 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '4312'
217 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '4312'
218 0.0011 0.0011119842529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
219 0.0005 0.00045394897460938
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0004 0.00041007995605469
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0005 0.00054502487182617
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0005 0.00049114227294922
SELECT * FROM products WHERE id = '777'
223 0.0005 0.00048112869262695
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
224 0.0006 0.00064802169799805
SELECT * FROM product_image_select WHERE product_id = '777'
225 0.0004 0.00043392181396484
SELECT * FROM productcustomimages WHERE product_id = '777'
226 0.0012 0.001162052154541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
227 0.0005 0.00051021575927734
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0005 0.00048303604125977
SELECT * FROM products WHERE id = '3881'
231 0.0005 0.00047516822814941
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
232 0.0007 0.00067496299743652
SELECT * FROM product_image_select WHERE product_id = '3881'
233 0.0005 0.00046706199645996
SELECT * FROM productcustomimages WHERE product_id = '3881'
234 0.0011 0.0011060237884521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
235 0.0005 0.0004570484161377
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0005 0.00047492980957031
SELECT * FROM products WHERE id = '4213'
239 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
240 0.0006 0.00055408477783203
SELECT * FROM product_image_select WHERE product_id = '4213'
241 0.0004 0.00037002563476562
SELECT * FROM productcustomimages WHERE product_id = '4213'
242 0.0011 0.0010800361633301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
243 0.0004 0.00043606758117676
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0003 0.00034284591674805
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0021 0.0021240711212158
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
247 0.0008 0.0008080005645752
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
248 0.0025 0.002547025680542
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
249 0.0020 0.0020020008087158
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0006 0.00061392784118652
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
251 0.0007 0.00067400932312012
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'