Faith | Pomegranate/Rooibos Bath Gel | 6 x 400ML

Faith | Pomegranate/Rooibos Bath Gel | 6 x 400ML
Faith | Pomegranate/Rooibos Bath Gel | 6 x 400ML Faith | Pomegranate/Rooibos Bath Gel | 6 x 400ML (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-09-09 21:53:46 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.

Caractéristiques du Produit

Pomegranate/Rooibos Bath Gel Vegan known BarCodes?: 708002400971 
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.96891593933105 247 0.1609 0


No Amazon API Requests Made.

Total time 0.96891593933105 seconds

Number Time From Start Name Description
1 0.75245714187622 Initialise Initialise FSB Function
2 0.75452303886414 App Controller Start Start of the App controller (called before the controller of every page)
3 0.75701498985291 Start of getCategoryListByGroup Function Before first category groups query
4 0.75723099708557 After initial query Before first category groups query
5 0.75723314285278 Get Category List for Group Before the call to getCategoryList function
6 0.75723695755005 Start of GetCategoryList function Start of the function
7 0.75724005699158 Before getting categories Query to get specific category list
8 0.75753903388977 After getting categories Query to get specific category list
9 0.7575409412384 Before getting category custom Before call to function getCategoryCustom
10 0.77419590950012 After getting category custom After call to function getCategoryCustom
11 0.77419900894165 Before getting category custom Before call to function getCategoryCustom
12 0.78527593612671 After getting category custom After call to function getCategoryCustom
13 0.78527903556824 Before getting category custom Before call to function getCategoryCustom
14 0.79056096076965 After getting category custom After call to function getCategoryCustom
15 0.79056310653687 Before getting category custom Before call to function getCategoryCustom
16 0.7936110496521 After getting category custom After call to function getCategoryCustom
17 0.79361295700073 Before getting category custom Before call to function getCategoryCustom
18 0.79650497436523 After getting category custom After call to function getCategoryCustom
19 0.79650712013245 Before getting category custom Before call to function getCategoryCustom
20 0.79967308044434 After getting category custom After call to function getCategoryCustom
21 0.79967594146729 End of GetCategoryList function End of the function
22 0.79967999458313 End of getCategoryListByGroup Function Before return()
23 0.80460214614868 App Controller End End of the App controller (called before the controller of every page)
24 0.80528211593628 Product Start Start of the product info controller
25 0.82364296913147 Cache file not found Starting get product details
26 0.85230207443237 Related products Start getting related products if enabled
27 0.85230398178101 Related Products Start Before the related products are found
28 0.85230612754822 Related Products Keywords Before the related product keywords are found
29 0.85230994224548 Create Keyword List Function Start of function
30 0.85238313674927 Create Keyword List Function After looping provided content - 18 keywords found
31 0.85300993919373 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
32 0.85301613807678 Create Keyword List Function After reducing keyword list
33 0.85305094718933 Create Keyword List Function After selecting by scoring keywords
34 0.85305404663086 Create Keyword List Function After final loop of keywords
35 0.85305595397949 Related Products Keywords After the related product keywords are found
36 0.90175199508667 Related Products End After the related products are found
37 0.90896606445312 Product End End of the product info controller (Product Info)
38 0.90982103347778 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.9102931022644 Before Get Options Before the call to getOptions in the tpl class
40 0.9359290599823 After Get Options After the call to getOptions in the tpl class
41 0.93603301048279 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.93606209754944 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.94837999343872 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.94838404655457 Product Info: Before Template Display Before the template is displayed
45 0.96888899803162 Product Info: After Template Display After the template is displayed
46 0.96890211105347 Finalizing debug Before the debug is output to the page.
47 0.96891403198242 End of App This is the end of the app logging, final timestamp


Query Debug - 247 Database Queries. Total time 0.1609 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00075912475585938
SELECT parameter, value FROM parameters
2 0.0008 0.00077199935913086
SELECT * FROM `bad_bots`
3 0.0003 0.00026893615722656
SET time_zone = 'Europe/London'
4 0.0002 0.00024080276489258
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0015730857849121
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.227.235.216\";}'
6 0.0010 0.0010440349578857
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632223534'
7 0.0004 0.0004119873046875
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00058317184448242
UPDATE autorun SET lastrun = '2021-09-21 11:25:35' WHERE id = '16'
9 0.0003 0.00026297569274902
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0005 0.00047802925109863
SELECT id FROM pages WHERE pagename = 'faith-pomegranaterooibos-bath-gel-6-x-400ml' LIMIT 1
11 0.0006 0.00055503845214844
SELECT id FROM products WHERE pagename = 'faith-pomegranaterooibos-bath-gel-6-x-400ml' AND hidden = 0 LIMIT 1
12 0.0009 0.00091218948364258
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0007 0.00067996978759766
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0003 0.00034785270690918
SELECT * FROM pages WHERE pagename = 'faith-pomegranaterooibos-bath-gel-6-x-400ml'
15 0.0002 0.00020503997802734
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0003 0.00027894973754883
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0078 0.0077519416809082
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.0002 0.00024509429931641
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.0002 0.00019502639770508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.00017714500427246
SELECT id FROM categories WHERE parent_id = '26'
21 0.0072 0.0072400569915771
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.0003 0.00029397010803223
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.0002 0.00021505355834961
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.0002 0.00019478797912598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0002 0.00021004676818848
SELECT * FROM categorygroups WHERE id = '1'
26 0.0044 0.0044472217559814
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.0003 0.00033283233642578
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.0003 0.00025391578674316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '27'
30 0.0046 0.0046401023864746
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.0004 0.00040793418884277
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.0002 0.00023293495178223
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.0002 0.00021696090698242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00021195411682129
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.001615047454834
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.0003 0.00028204917907715
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.0002 0.00020289421081543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '28'
39 0.0020 0.0020129680633545
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.0002 0.00023317337036133
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.0002 0.00020503997802734
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.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.0002129077911377
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00062108039855957
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.0003 0.00026488304138184
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.0003 0.00028705596923828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00066423416137695
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.0003 0.00027203559875488
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.0002 0.00021910667419434
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.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00020194053649902
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00055694580078125
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.0002 0.00022101402282715
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.0002 0.00022101402282715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00060200691223145
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.0003 0.00027012825012207
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.0002 0.00023198127746582
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.0002 0.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00026082992553711
SELECT * FROM categorygroups WHERE id = '1'
62 0.0008 0.00081014633178711
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.0003 0.00026702880859375
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.0002 0.00023889541625977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00022315979003906
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00066113471984863
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.0002 0.00023102760314941
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.0002 0.00020790100097656
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.0002 0.00019621849060059
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.00022196769714355
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.00023102760314941
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0003 0.00026297569274902
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0002 0.00024199485778809
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.0002 0.00021719932556152
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0005 0.00054311752319336
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00047898292541504
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0003 0.00027894973754883
SELECT * FROM ipgeocountries WHERE INET_ATON('3.227.235.216') >= INET_ATON(ip_start) AND INET_ATON('3.227.235.216') <= INET_ATON(ip_end)
78 0.0002 0.00021910667419434
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0002 0.0002439022064209
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.0007472038269043
SELECT * FROM products WHERE pagename = 'faith-pomegranaterooibos-bath-gel-6-x-400ml'
81 0.0010 0.0010499954223633
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3058
82 0.0008 0.00081801414489746
SELECT * FROM manufacturers WHERE id = '235'
83 0.0007 0.0007469654083252
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '235'
84 0.0004 0.00038504600524902
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '235' LIMIT 1
85 0.0011 0.0011200904846191
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '235' ORDER BY RAND() LIMIT 1
86 0.0019 0.001856803894043
SELECT * FROM productimages WHERE product_id = '897' ORDER BY sortorder ASC
87 0.0003 0.0002748966217041
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '235'
88 0.0006 0.00060701370239258
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '235'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0006 0.00056219100952148
SELECT * FROM manufacturerimages WHERE manufacturer_id = '235'
90 0.0006 0.00055193901062012
SELECT category_id FROM products_categories WHERE product_id = '3058'
91 0.0004 0.00038313865661621
SELECT * FROM categories WHERE id = '27'
92 0.0063 0.0063478946685791
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.0004 0.00041103363037109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '27'
95 0.0046 0.0046019554138184
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.0003 0.00028800964355469
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.0002 0.00023102760314941
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.0002 0.00019693374633789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0014 0.0014340877532959
SELECT * FROM productimages WHERE product_id = '3058' ORDER BY sortorder ASC
100 0.0005 0.00048208236694336
SELECT * FROM product_image_select WHERE product_id = '3058'
101 0.0005 0.00045609474182129
SELECT * FROM productcustomimages WHERE product_id = '3058'
102 0.0004 0.00038290023803711
SELECT * FROM productfeeds WHERE product_id = '3058' ORDER BY item_date DESC
103 0.0007 0.00067591667175293
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3058' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0006 0.00061607360839844
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3058' AND t.hidden = 0 AND display_product = 1
105 0.0005 0.0005030632019043
SELECT * FROM productamazoncontent WHERE product_id = '3058'
106 0.0009 0.00090885162353516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3058' AND a.name = n.originalname
107 0.0006 0.00060582160949707
SELECT * FROM productoffers WHERE product_id = '3058' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00049495697021484
SELECT * FROM productoffers
                WHERE product_id = '3058' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00049614906311035
SELECT * FROM productoffers
                WHERE product_id = 3058
                ORDER BY price ASC LIMIT 1
110 0.0006 0.00055408477783203
SELECT value FROM productattributes
                WHERE product_id = '3058'
                AND name = 'ListPriceAmount'
111 0.0006 0.00061893463134766
SELECT value FROM productattributes WHERE product_id = '3058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0002 0.00020980834960938
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
113 0.0080 0.007997989654541
SELECT *, MATCH (description, title) AGAINST ('6 x 400ml' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('6 x 400ml' IN BOOLEAN MODE) AND 3058 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
114 0.0007 0.00070905685424805
SELECT *, MATCH (description, title) AGAINST ('6 x 400ml' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('6 x 400ml' IN BOOLEAN MODE) AND 3058 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0007 0.00071001052856445
SELECT *, MATCH (description, title) AGAINST ('6 x 400ml' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('6 x 400ml' IN BOOLEAN MODE) AND 3058 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
116 0.0004 0.00039410591125488
SELECT * FROM productimages WHERE product_id = '3773' ORDER BY sortorder ASC
117 0.0003 0.00026106834411621
SELECT * FROM product_image_select WHERE product_id = '3773'
118 0.0002 0.00020599365234375
SELECT * FROM productcustomimages WHERE product_id = '3773'
119 0.0010 0.00098705291748047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3773' AND a.name = n.originalname
120 0.0005 0.00046801567077637
SELECT * FROM productoffers WHERE product_id = '3773' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0006 0.00057101249694824
SELECT * FROM productoffers
                WHERE product_id = '3773' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '3773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0079 0.0079429149627686
SELECT *, MATCH (description, title) AGAINST ('faith pomegranaterooibos bath' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('faith pomegranaterooibos bath' IN BOOLEAN MODE) AND 3058 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
124 0.0007 0.00065898895263672
SELECT *, MATCH (description, title) AGAINST ('faith pomegranaterooibos bath' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('faith pomegranaterooibos bath' IN BOOLEAN MODE) AND 3058 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
125 0.0005 0.00047898292541504
SELECT *, MATCH (description, title) AGAINST ('faith pomegranaterooibos bath' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('faith pomegranaterooibos bath' IN BOOLEAN MODE) AND 3058 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
126 0.0017 0.0017330646514893
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3058') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
127 0.0122 0.012215137481689
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz'  AND p.id <> '3058' ORDER BY RAND()
128 0.0007 0.00067400932312012
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '3058' ORDER BY RAND()
129 0.0004 0.00039792060852051
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '3058' ORDER BY RAND()
130 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '1461' ORDER BY sortorder ASC
131 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '1461'
132 0.0002 0.00020408630371094
SELECT * FROM productcustomimages WHERE product_id = '1461'
133 0.0010 0.00098204612731934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1461' AND a.name = n.originalname
134 0.0007 0.00068497657775879
SELECT * FROM productoffers WHERE product_id = '1461' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0006 0.00061178207397461
SELECT * FROM productoffers
                WHERE product_id = '1461' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00039887428283691
SELECT * FROM productoffers
                WHERE product_id = 1461
                ORDER BY price ASC LIMIT 1
137 0.0003 0.00032186508178711
SELECT value FROM productattributes
                WHERE product_id = '1461'
                AND name = 'ListPriceAmount'
138 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '1461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0002 0.00021219253540039
SELECT * FROM productimages WHERE product_id = '1594' ORDER BY sortorder ASC
140 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '1594'
141 0.0002 0.00018692016601562
SELECT * FROM productcustomimages WHERE product_id = '1594'
142 0.0021 0.0021488666534424
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1594' AND a.name = n.originalname
143 0.0004 0.00043988227844238
SELECT * FROM productoffers WHERE product_id = '1594' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '1594' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0004 0.00039887428283691
SELECT * FROM productoffers
                WHERE product_id = 1594
                ORDER BY price ASC LIMIT 1
146 0.0005 0.00046682357788086
SELECT value FROM productattributes
                WHERE product_id = '1594'
                AND name = 'ListPriceAmount'
147 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '1594' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0004 0.00039887428283691
SELECT id,asin FROM products WHERE parent_id = 3058
149 0.0002 0.00020003318786621
SELECT category_id FROM products_categories WHERE product_id = '3058'
150 0.0002 0.00023198127746582
SELECT * FROM categories WHERE id = '27'
151 0.0002 0.00017714500427246
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
152 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
153 0.0002 0.00017714500427246
SELECT id FROM categories WHERE parent_id = '27'
154 0.0002 0.00017499923706055
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 
155 0.0002 0.00016999244689941
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 
156 0.0002 0.00017404556274414
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
157 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
158 0.0002 0.00018501281738281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3058' AND a.name = n.originalname
159 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '3058' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '3058' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = 3058
                ORDER BY price ASC LIMIT 1
162 0.0002 0.0001680850982666
SELECT value FROM productattributes
                WHERE product_id = '3058'
                AND name = 'ListPriceAmount'
163 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '3058'
164 0.0002 0.00021696090698242
SELECT value FROM productattributes WHERE product_id = '3058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0002 0.00020003318786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3058' AND a.name = n.originalname
166 0.0002 0.00022292137145996
SELECT * FROM productoffers WHERE product_id = '3058' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '3058' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0002 0.00024104118347168
SELECT * FROM productoffers
                WHERE product_id = 3058
                ORDER BY price ASC LIMIT 1
169 0.0002 0.00018405914306641
SELECT value FROM productattributes
                WHERE product_id = '3058'
                AND name = 'ListPriceAmount'
170 0.0003 0.00030398368835449
SELECT category_id FROM products_categories WHERE product_id = '3058' AND prod_type = 'amz'
171 0.0002 0.00018715858459473
SELECT parent_id FROM categories WHERE id = '27'
172 0.0002 0.00022387504577637
SELECT * FROM categories WHERE id = '27'
173 0.0002 0.00017499923706055
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
174 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
175 0.0002 0.00017881393432617
SELECT id FROM categories WHERE parent_id = '27'
176 0.0002 0.00018692016601562
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 
177 0.0002 0.00017094612121582
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 
178 0.0002 0.00023102760314941
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
179 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
180 0.0003 0.00026488304138184
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
181 0.0002 0.00019288063049316
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
182 0.0002 0.00018692016601562
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
183 0.0003 0.00030016899108887
SELECT * FROM pages WHERE id = 38
184 0.0042 0.0041849613189697
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
185 0.0004 0.00039196014404297
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1632223535;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
186 0.0004 0.00043320655822754
SELECT * FROM products WHERE id = 790
187 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = 788
188 0.0004 0.00042200088500977
SELECT * FROM products WHERE id = 787
189 0.0004 0.0004270076751709
SELECT * FROM products WHERE id = 1287
190 0.0004 0.00041794776916504
SELECT * FROM products WHERE id = 779
191 0.0004 0.00041103363037109
SELECT * FROM products WHERE id = 777
192 0.0004 0.00038981437683105
SELECT * FROM products WHERE id = '790'
193 0.0003 0.00032591819763184
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
194 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '790'
195 0.0002 0.00020289421081543
SELECT * FROM productcustomimages WHERE product_id = '790'
196 0.0003 0.00031304359436035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
197 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0002 0.00018095970153809
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0004 0.00039887428283691
SELECT * FROM products WHERE id = '788'
201 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
202 0.0002 0.00019598007202148
SELECT * FROM product_image_select WHERE product_id = '788'
203 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '788'
204 0.0002 0.00022101402282715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
205 0.0002 0.00021100044250488
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0002 0.00020098686218262
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0004 0.00038504600524902
SELECT * FROM products WHERE id = '787'
209 0.0002 0.00020718574523926
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
210 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '787'
211 0.0002 0.0002138614654541
SELECT * FROM productcustomimages WHERE product_id = '787'
212 0.0004 0.00038003921508789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
213 0.0002 0.00022077560424805
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0003 0.00032901763916016
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0005 0.00046706199645996
SELECT * FROM products WHERE id = '1287'
217 0.0003 0.0002901554107666
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
218 0.0003 0.00025582313537598
SELECT * FROM product_image_select WHERE product_id = '1287'
219 0.0002 0.00022411346435547
SELECT * FROM productcustomimages WHERE product_id = '1287'
220 0.0003 0.00025820732116699
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
221 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0002 0.00021100044250488
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.00052189826965332
SELECT * FROM products WHERE id = '779'
225 0.0004 0.0003669261932373
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
226 0.0005 0.00052404403686523
SELECT * FROM product_image_select WHERE product_id = '779'
227 0.0004 0.00041389465332031
SELECT * FROM productcustomimages WHERE product_id = '779'
228 0.0004 0.0004429817199707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
229 0.0003 0.00028204917907715
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0002 0.0001990795135498
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0004 0.00040507316589355
SELECT * FROM products WHERE id = '777'
233 0.0002 0.00022387504577637
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0002 0.00022387504577637
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0003 0.00032711029052734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0003 0.00025320053100586
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0002 0.00021100044250488
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0003 0.00030612945556641
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
241 0.0004 0.00044488906860352
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
242 0.0006 0.00063395500183105
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
243 0.0003 0.00029587745666504
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
244 0.0002 0.00024199485778809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
245 0.0007 0.00066995620727539
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
246 0.0004 0.00043988227844238
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
247 0.0005 0.00048112869262695
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'