Dammann Frères - Rooibos l'Oriental-100gr boite

Dammann Frères - Rooibos l'Oriental-100gr boite
Dammann Frères - Rooibos l'Oriental-100gr boite (cliquez sur les images pour élargir)
€25,99
Le prix et la disponibilité du produit sont corrects en date du 2022-05-28 17:15:02 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

Dammann Frères - Rooibos l'Oriental -100gr boite
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.70688700675964 234 0.1583 0


No Amazon API Requests Made.

Total time 0.70688700675964 seconds

Number Time From Start Name Description
1 0.51003694534302 Initialise Initialise FSB Function
2 0.51254796981812 App Controller Start Start of the App controller (called before the controller of every page)
3 0.51549887657166 Start of getCategoryListByGroup Function Before first category groups query
4 0.51578688621521 After initial query Before first category groups query
5 0.51578807830811 Get Category List for Group Before the call to getCategoryList function
6 0.51579189300537 Start of GetCategoryList function Start of the function
7 0.51579403877258 Before getting categories Query to get specific category list
8 0.51612687110901 After getting categories Query to get specific category list
9 0.51612901687622 Before getting category custom Before call to function getCategoryCustom
10 0.5413019657135 After getting category custom After call to function getCategoryCustom
11 0.54130506515503 Before getting category custom Before call to function getCategoryCustom
12 0.55234289169312 After getting category custom After call to function getCategoryCustom
13 0.55234503746033 Before getting category custom Before call to function getCategoryCustom
14 0.55840086936951 After getting category custom After call to function getCategoryCustom
15 0.55840396881104 Before getting category custom Before call to function getCategoryCustom
16 0.56297206878662 After getting category custom After call to function getCategoryCustom
17 0.56297397613525 Before getting category custom Before call to function getCategoryCustom
18 0.56709098815918 After getting category custom After call to function getCategoryCustom
19 0.56709289550781 Before getting category custom Before call to function getCategoryCustom
20 0.57121706008911 After getting category custom After call to function getCategoryCustom
21 0.57121896743774 End of GetCategoryList function End of the function
22 0.57122397422791 End of getCategoryListByGroup Function Before return()
23 0.57651495933533 App Controller End End of the App controller (called before the controller of every page)
24 0.57676196098328 Product Start Start of the product info controller
25 0.57894706726074 Cache file not found Starting get product details
26 0.61260795593262 Related products Start getting related products if enabled
27 0.61261010169983 Related Products Start Before the related products are found
28 0.61261105537415 Related Products Keywords Before the related product keywords are found
29 0.61261487007141 Create Keyword List Function Start of function
30 0.61263704299927 Create Keyword List Function After looping provided content - 12 keywords found
31 0.61314797401428 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
32 0.61315393447876 Create Keyword List Function After reducing keyword list
33 0.61317110061646 Create Keyword List Function After selecting by scoring keywords
34 0.61317300796509 Create Keyword List Function After final loop of keywords
35 0.61317491531372 Related Products Keywords After the related product keywords are found
36 0.63040494918823 Related Products End After the related products are found
37 0.63845801353455 Product End End of the product info controller (Product Info)
38 0.63912987709045 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.63973093032837 Before Get Options Before the call to getOptions in the tpl class
40 0.67157292366028 After Get Options After the call to getOptions in the tpl class
41 0.6716480255127 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.67166996002197 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.68484497070312 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.6848509311676 Product Info: Before Template Display Before the template is displayed
45 0.70686602592468 Product Info: After Template Display After the template is displayed
46 0.70687103271484 Finalizing debug Before the debug is output to the page.
47 0.70688605308533 End of App This is the end of the app logging, final timestamp


Query Debug - 234 Database Queries. Total time 0.1583 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00080299377441406
SELECT parameter, value FROM parameters
2 0.0011 0.0010688304901123
SELECT * FROM `bad_bots`
3 0.0005 0.00045585632324219
SET time_zone = 'Europe/London'
4 0.0004 0.00043797492980957
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0017859935760498
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.244.12\";}'
6 0.0014 0.0014481544494629
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653816383'
7 0.0006 0.00058984756469727
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00030612945556641
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00066781044006348
SELECT id FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' LIMIT 1
10 0.0009 0.00087213516235352
SELECT id FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' AND hidden = 0 LIMIT 1
11 0.0013 0.0012519359588623
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00070595741271973
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00059199333190918
SELECT * FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
14 0.0003 0.0002748966217041
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00031304359436035
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0099 0.009922981262207
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0004 0.00044488906860352
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0003 0.00032806396484375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00044012069702148
SELECT id FROM categories WHERE parent_id = '26'
20 0.0130 0.012954950332642
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0002 0.00024914741516113
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0003 0.00027298927307129
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0002 0.00021004676818848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00022006034851074
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0043120384216309
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00048089027404785
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00044083595275879
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.0003211498260498
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0043489933013916
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0003 0.0002748966217041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0003 0.00025486946105957
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0002 0.00021696090698242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.0002589225769043
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017461776733398
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.00034904479980469
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00044703483581543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00030207633972168
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.0020279884338379
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0004 0.00038599967956543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0002 0.00022506713867188
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0002 0.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00024700164794922
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00064206123352051
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0004 0.00042200088500977
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00043702125549316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00045418739318848
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00088191032409668
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0004 0.0003669261932373
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0005 0.00047397613525391
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.0003199577331543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00044798851013184
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00059199333190918
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0004 0.0004429817199707
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00041890144348145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00025606155395508
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00066804885864258
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0004 0.00044918060302734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0004 0.00044012069702148
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0004 0.00035500526428223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00034689903259277
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00078487396240234
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0004 0.0003509521484375
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00037002563476562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.0004279613494873
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00081181526184082
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0003 0.00029993057250977
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00029897689819336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00025820732116699
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00025510787963867
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00040793418884277
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00040912628173828
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
73 0.0002 0.00024986267089844
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0007 0.00066494941711426
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00053095817565918
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.0002739429473877
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.244.12') >= INET_ATON(ip_start) AND INET_ATON('34.231.244.12') <= INET_ATON(ip_end)
77 0.0003 0.00030112266540527
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00025820732116699
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00056791305541992
SELECT * FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
80 0.0008 0.00077605247497559
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4814
81 0.0006 0.00064802169799805
SELECT * FROM manufacturers WHERE id = '177'
82 0.0007 0.00071001052856445
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
83 0.0006 0.0005638599395752
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '177' LIMIT 1
84 0.0010 0.00099301338195801
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '177' ORDER BY RAND() LIMIT 1
85 0.0019 0.0018730163574219
SELECT * FROM productimages WHERE product_id = '975' ORDER BY sortorder ASC
86 0.0003 0.00033187866210938
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
87 0.0006 0.00060892105102539
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '177'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0005 0.00053691864013672
SELECT * FROM manufacturerimages WHERE manufacturer_id = '177'
89 0.0004 0.00043010711669922
SELECT category_id FROM products_categories WHERE product_id = '4814'
90 0.0003 0.00030088424682617
SELECT * FROM categories WHERE id = '27'
91 0.0053 0.0052828788757324
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
92 0.0005 0.00049185752868652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00042009353637695
SELECT id FROM categories WHERE parent_id = '27'
94 0.0049 0.0049090385437012
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 
95 0.0003 0.00034594535827637
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 
96 0.0003 0.00025105476379395
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
97 0.0002 0.00021791458129883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0011 0.0010709762573242
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
99 0.0006 0.00058794021606445
SELECT * FROM product_image_select WHERE product_id = '4814'
100 0.0006 0.00057411193847656
SELECT * FROM productcustomimages WHERE product_id = '4814'
101 0.0005 0.00054192543029785
SELECT * FROM productfeeds WHERE product_id = '4814' ORDER BY item_date DESC
102 0.0006 0.00058388710021973
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0009 0.00086593627929688
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4814' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00036501884460449
SELECT * FROM tags WHERE id = '1'
105 0.0017 0.001708984375
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0017 0.0016860961914062
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0018 0.001823902130127
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
108 0.0005 0.00046014785766602
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
109 0.0006 0.0005650520324707
SELECT * FROM productamazoncontent WHERE product_id = '4814'
110 0.0010 0.0010089874267578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
111 0.0006 0.00058889389038086
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0005 0.00053191184997559
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0005 0.00050187110900879
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
115 0.0080 0.0080409049987793
SELECT *, MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
116 0.0005 0.00052118301391602
SELECT *, MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
117 0.0005 0.00050210952758789
SELECT *, MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
118 0.0003 0.00031113624572754
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
119 0.0004 0.00038480758666992
SELECT * FROM product_image_select WHERE product_id = '862'
120 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '862'
121 0.0004 0.00040698051452637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
122 0.0004 0.00041079521179199
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0005 0.0005340576171875
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0002 0.00021886825561523
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0003 0.00030016899108887
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
126 0.0002 0.00024294853210449
SELECT * FROM product_image_select WHERE product_id = '858'
127 0.0002 0.0002439022064209
SELECT * FROM productcustomimages WHERE product_id = '858'
128 0.0003 0.00029516220092773
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
129 0.0004 0.00040507316589355
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0005 0.00048995018005371
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00025105476379395
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
133 0.0003 0.00025606155395508
SELECT * FROM product_image_select WHERE product_id = '878'
134 0.0002 0.00023508071899414
SELECT * FROM productcustomimages WHERE product_id = '878'
135 0.0004 0.00039911270141602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
136 0.0005 0.00048112869262695
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0006 0.00060105323791504
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0004 0.0003509521484375
SELECT id,asin FROM products WHERE parent_id = 4814
140 0.0003 0.0002601146697998
SELECT category_id FROM products_categories WHERE product_id = '4814'
141 0.0003 0.00029706954956055
SELECT * FROM categories WHERE id = '27'
142 0.0003 0.00027203559875488
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
143 0.0002 0.0002288818359375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
144 0.0002 0.0002281665802002
SELECT id FROM categories WHERE parent_id = '27'
145 0.0002 0.00023007392883301
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 
146 0.0002 0.00021696090698242
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 
147 0.0002 0.00022292137145996
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
148 0.0002 0.00020480155944824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
149 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
150 0.0003 0.00025200843811035
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00049209594726562
SELECT * FROM products WHERE id = '4814'
153 0.0002 0.00024104118347168
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0003 0.00026988983154297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
155 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00029683113098145
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00043511390686035
SELECT category_id FROM products_categories WHERE product_id = '4814' AND prod_type = 'amz'
158 0.0003 0.00028395652770996
SELECT parent_id FROM categories WHERE id = '27'
159 0.0003 0.0003058910369873
SELECT * FROM categories WHERE id = '27'
160 0.0003 0.00026583671569824
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
161 0.0003 0.00026202201843262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
162 0.0002 0.00024294853210449
SELECT id FROM categories WHERE parent_id = '27'
163 0.0003 0.00025820732116699
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 
164 0.0002 0.00023412704467773
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 
165 0.0002 0.00023412704467773
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
166 0.0003 0.00026893615722656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
167 0.0003 0.00033688545227051
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
168 0.0003 0.00029897689819336
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
169 0.0002 0.00023293495178223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
170 0.0003 0.00028300285339355
SELECT * FROM pages WHERE id = 38
171 0.0049 0.0048830509185791
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
172 0.0006 0.00061607360839844
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:1653816384;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
173 0.0005 0.00045895576477051
SELECT * FROM products WHERE id = 788
174 0.0005 0.00051116943359375
SELECT * FROM products WHERE id = 787
175 0.0006 0.00057196617126465
SELECT * FROM products WHERE id = 1287
176 0.0005 0.00047016143798828
SELECT * FROM products WHERE id = 780
177 0.0005 0.00052905082702637
SELECT * FROM products WHERE id = 777
178 0.0005 0.00045013427734375
SELECT * FROM products WHERE id = 776
179 0.0005 0.00047111511230469
SELECT * FROM products WHERE id = '788'
180 0.0003 0.00028896331787109
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
181 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '788'
182 0.0002 0.00022602081298828
SELECT * FROM productcustomimages WHERE product_id = '788'
183 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
184 0.0004 0.00041484832763672
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0005 0.00046610832214355
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0002 0.00022602081298828
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0005 0.00045490264892578
SELECT * FROM products WHERE id = '787'
188 0.0003 0.00031781196594238
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
189 0.0003 0.00030684471130371
SELECT * FROM product_image_select WHERE product_id = '787'
190 0.0002 0.00021815299987793
SELECT * FROM productcustomimages WHERE product_id = '787'
191 0.0003 0.00027608871459961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
192 0.0004 0.00040102005004883
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0005 0.00049996376037598
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0002 0.00022196769714355
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0005 0.00046086311340332
SELECT * FROM products WHERE id = '1287'
196 0.0003 0.00032615661621094
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
197 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '1287'
198 0.0002 0.00021505355834961
SELECT * FROM productcustomimages WHERE product_id = '1287'
199 0.0003 0.00025391578674316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
200 0.0004 0.00038003921508789
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0005 0.00052905082702637
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00026392936706543
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0006 0.00055813789367676
SELECT * FROM products WHERE id = '780'
204 0.0004 0.00040006637573242
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
205 0.0004 0.0004119873046875
SELECT * FROM product_image_select WHERE product_id = '780'
206 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '780'
207 0.0004 0.00037884712219238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
208 0.0006 0.00061392784118652
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0006 0.00064611434936523
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0002 0.00024795532226562
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0005 0.00052618980407715
SELECT * FROM products WHERE id = '777'
212 0.0003 0.00031518936157227
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
213 0.0004 0.00041413307189941
SELECT * FROM product_image_select WHERE product_id = '777'
214 0.0003 0.00033998489379883
SELECT * FROM productcustomimages WHERE product_id = '777'
215 0.0003 0.00030303001403809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
216 0.0005 0.00054097175598145
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0006 0.00063300132751465
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0006 0.0005650520324707
SELECT * FROM products WHERE id = '776'
220 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
221 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '776'
222 0.0002 0.00023603439331055
SELECT * FROM productcustomimages WHERE product_id = '776'
223 0.0003 0.00033903121948242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
224 0.0005 0.00046086311340332
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0006 0.0006248950958252
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0003 0.00025606155395508
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0004 0.00040793418884277
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
228 0.0003 0.00031590461730957
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
229 0.0006 0.00061297416687012
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
230 0.0004 0.00036287307739258
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
231 0.0003 0.00033807754516602
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00048398971557617
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
233 0.0004 0.00039005279541016
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0003 0.00032210350036621
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'