Dammann Frères - Thé Rooibos VANILLE - 24 sachets individuels

Dammann Frères - Thé Rooibos VANILLE - 24 sachets individuels
Dammann Frères - Thé Rooibos VANILLE - 24 sachets individuels Dammann Frères - Thé Rooibos VANILLE - 24 sachets individuels (cliquez sur les images pour élargir)
€19,95
Le prix et la disponibilité du produit sont corrects en date du 2021-10-23 17:32:08 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 - Thé Rooibos VANILLE - 24 sachets individuels
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.71197319030762 239 0.1315 0


No Amazon API Requests Made.

Total time 0.71197319030762 seconds

Number Time From Start Name Description
1 0.53619813919067 Initialise Initialise FSB Function
2 0.53906416893005 App Controller Start Start of the App controller (called before the controller of every page)
3 0.5422420501709 Start of getCategoryListByGroup Function Before first category groups query
4 0.54251503944397 After initial query Before first category groups query
5 0.54251718521118 Get Category List for Group Before the call to getCategoryList function
6 0.54252004623413 Start of GetCategoryList function Start of the function
7 0.54252219200134 Before getting categories Query to get specific category list
8 0.54295110702515 After getting categories Query to get specific category list
9 0.54295206069946 Before getting category custom Before call to function getCategoryCustom
10 0.54476714134216 After getting category custom After call to function getCategoryCustom
11 0.54477000236511 Before getting category custom Before call to function getCategoryCustom
12 0.55919718742371 After getting category custom After call to function getCategoryCustom
13 0.55919909477234 Before getting category custom Before call to function getCategoryCustom
14 0.56407809257507 After getting category custom After call to function getCategoryCustom
15 0.56407999992371 Before getting category custom Before call to function getCategoryCustom
16 0.56715416908264 After getting category custom After call to function getCategoryCustom
17 0.56715607643127 Before getting category custom Before call to function getCategoryCustom
18 0.57088613510132 After getting category custom After call to function getCategoryCustom
19 0.57089018821716 Before getting category custom Before call to function getCategoryCustom
20 0.57350301742554 After getting category custom After call to function getCategoryCustom
21 0.57350611686707 End of GetCategoryList function End of the function
22 0.57351016998291 End of getCategoryListByGroup Function Before return()
23 0.57772016525269 App Controller End End of the App controller (called before the controller of every page)
24 0.57794117927551 Product Start Start of the product info controller
25 0.59223198890686 Cache file not found Starting get product details
26 0.62076616287231 Related products Start getting related products if enabled
27 0.62076807022095 Related Products Start Before the related products are found
28 0.62076902389526 Related Products Keywords Before the related product keywords are found
29 0.62077212333679 Create Keyword List Function Start of function
30 0.62081003189087 Create Keyword List Function After looping provided content - 21 keywords found
31 0.62164616584778 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
32 0.62165307998657 Create Keyword List Function After reducing keyword list
33 0.62169599533081 Create Keyword List Function After selecting by scoring keywords
34 0.62169909477234 Create Keyword List Function After final loop of keywords
35 0.62170100212097 Related Products Keywords After the related product keywords are found
36 0.64560914039612 Related Products End After the related products are found
37 0.65187501907349 Product End End of the product info controller (Product Info)
38 0.65234208106995 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.65273308753967 Before Get Options Before the call to getOptions in the tpl class
40 0.68079710006714 After Get Options After the call to getOptions in the tpl class
41 0.68086409568787 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.68088316917419 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.69290399551392 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.69290804862976 Product Info: Before Template Display Before the template is displayed
45 0.71195816993713 Product Info: After Template Display After the template is displayed
46 0.7119619846344 Finalizing debug Before the debug is output to the page.
47 0.71197199821472 End of App This is the end of the app logging, final timestamp


Query Debug - 239 Database Queries. Total time 0.1315 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00036883354187012
SELECT parameter, value FROM parameters
2 0.0009 0.00090694427490234
SELECT * FROM `bad_bots`
3 0.0003 0.00034904479980469
SET time_zone = 'Europe/London'
4 0.0002 0.0001981258392334
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0017540454864502
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:10:\"3.80.3.192\";}'
6 0.0009 0.0009310245513916
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1635204491'
7 0.0004 0.00038504600524902
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00024580955505371
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0012 0.0012221336364746
SELECT id FROM pages WHERE pagename = 'dammann-frres-the-rooibos-vanille-24-sachets-individuels' LIMIT 1
10 0.0010 0.00095200538635254
SELECT id FROM products WHERE pagename = 'dammann-frres-the-rooibos-vanille-24-sachets-individuels' AND hidden = 0 LIMIT 1
11 0.0014 0.0013909339904785
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.0008242130279541
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00057387351989746
SELECT * FROM pages WHERE pagename = 'dammann-frres-the-rooibos-vanille-24-sachets-individuels'
14 0.0003 0.00026082992553711
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00041007995605469
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00017189979553223
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.0002 0.00018215179443359
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.0002 0.00015401840209961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00022602081298828
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.00019001960754395
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.0002 0.00018692016601562
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.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00019717216491699
SELECT * FROM categorygroups WHERE id = '1'
25 0.0061 0.0061159133911133
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.0006 0.00055694580078125
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.0002 0.00020790100097656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '27'
29 0.0059 0.0058791637420654
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0008 0.00083398818969727
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.0002 0.00017595291137695
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.0001530647277832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00021195411682129
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0019397735595703
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.0002 0.00016903877258301
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.0002 0.00015902519226074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0001 0.00014686584472656
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0016651153564453
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.0002 0.00017786026000977
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.00015997886657715
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.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00017309188842773
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00059890747070312
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.0002 0.00021600723266602
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.0002 0.00020503997802734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00015020370483398
SELECT id FROM categories WHERE parent_id = '29'
47 0.0011 0.0010819435119629
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.0003 0.00025701522827148
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.0002 0.0001528263092041
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.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00015902519226074
SELECT * FROM categorygroups WHERE id = '1'
52 0.0013 0.0013420581817627
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.0002 0.00017309188842773
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.0002 0.00016593933105469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00016188621520996
SELECT id FROM categories WHERE parent_id = '30'
56 0.0010 0.0010001659393311
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.0002 0.00022602081298828
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.0002 0.00017595291137695
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.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00018596649169922
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.0005500316619873
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.0002 0.00019192695617676
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.0002 0.00017690658569336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017118453979492
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00068521499633789
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.0002 0.00020503997802734
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.0002 0.00019407272338867
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.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00020790100097656
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.0002291202545166
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00026297569274902
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.00018215179443359
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00057291984558105
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00059700012207031
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00020694732666016
SELECT * FROM ipgeocountries WHERE INET_ATON('3.80.3.192') >= INET_ATON(ip_start) AND INET_ATON('3.80.3.192') <= INET_ATON(ip_end)
77 0.0002 0.0001680850982666
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00017285346984863
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0008 0.00079679489135742
SELECT * FROM products WHERE pagename = 'dammann-frres-the-rooibos-vanille-24-sachets-individuels'
80 0.0033 0.003277063369751
UPDATE products SET viewcount = viewcount + 1 WHERE id = 977
81 0.0004 0.00036096572875977
SELECT * FROM manufacturers WHERE id = '177'
82 0.0008 0.00084185600280762
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
83 0.0005 0.00048208236694336
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '177' LIMIT 1
84 0.0010 0.0010080337524414
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.0003 0.00027179718017578
SELECT * FROM productimages WHERE product_id = '979' ORDER BY sortorder ASC
86 0.0002 0.00020503997802734
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
87 0.0008 0.00078201293945312
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.00045394897460938
SELECT * FROM manufacturerimages WHERE manufacturer_id = '177'
89 0.0004 0.00036287307739258
SELECT category_id FROM products_categories WHERE product_id = '977'
90 0.0008 0.00081586837768555
SELECT * FROM categories WHERE id = '27'
91 0.0063 0.0063028335571289
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.0009 0.00088691711425781
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00020718574523926
SELECT id FROM categories WHERE parent_id = '27'
94 0.0048 0.0047829151153564
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.0006 0.00057506561279297
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
96 0.0002 0.0002439022064209
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '977' ORDER BY sortorder ASC
99 0.0002 0.0001680850982666
SELECT * FROM product_image_select WHERE product_id = '977'
100 0.0002 0.00019001960754395
SELECT * FROM productcustomimages WHERE product_id = '977'
101 0.0004 0.00041985511779785
SELECT * FROM productfeeds WHERE product_id = '977' ORDER BY item_date DESC
102 0.0026 0.0026071071624756
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '977' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00054788589477539
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '977' AND t.hidden = 0 AND display_product = 1
104 0.0013 0.0013132095336914
SELECT * FROM productamazoncontent WHERE product_id = '977'
105 0.0018 0.0018091201782227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '977' AND a.name = n.originalname
106 0.0005 0.00053715705871582
SELECT * FROM productoffers WHERE product_id = '977' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0007 0.0006709098815918
SELECT * FROM productoffers
                WHERE product_id = '977' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '977' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0003 0.00025796890258789
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
110 0.0087 0.0086698532104492
SELECT *, MATCH (description, title) AGAINST ('24 sachets individuels' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('24 sachets individuels' IN BOOLEAN MODE) AND 977 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
111 0.0009 0.00093197822570801
SELECT *, MATCH (description, title) AGAINST ('24 sachets individuels' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('24 sachets individuels' IN BOOLEAN MODE) AND 977 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
112 0.0007 0.00065708160400391
SELECT *, MATCH (description, title) AGAINST ('24 sachets individuels' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('24 sachets individuels' IN BOOLEAN MODE) AND 977 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0003 0.00025391578674316
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
114 0.0002 0.00019478797912598
SELECT * FROM product_image_select WHERE product_id = '878'
115 0.0002 0.00017690658569336
SELECT * FROM productcustomimages WHERE product_id = '878'
116 0.0003 0.00025200843811035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
117 0.0002 0.00023198127746582
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0003 0.00033020973205566
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
121 0.0014 0.0013830661773682
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
122 0.0007 0.00073409080505371
SELECT * FROM product_image_select WHERE product_id = '822'
123 0.0003 0.00031805038452148
SELECT * FROM productcustomimages WHERE product_id = '822'
124 0.0009 0.00088310241699219
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 = '822'
                GROUP BY o.product_id
125 0.0009 0.00090789794921875
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
126 0.0006 0.00057792663574219
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
127 0.0003 0.00030303001403809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
128 0.0005 0.00052595138549805
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0008 0.00084114074707031
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0006 0.000640869140625
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
131 0.0002 0.00022101402282715
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
132 0.0002 0.00024318695068359
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 = '822'
                GROUP BY o.product_id
133 0.0002 0.0002288818359375
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
134 0.0002 0.00017499923706055
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
135 0.0002 0.00017499923706055
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0010 0.00097298622131348
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
137 0.0004 0.00044417381286621
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
138 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '764'
139 0.0002 0.00017905235290527
SELECT * FROM productcustomimages WHERE product_id = '764'
140 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
141 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0003 0.0003199577331543
SELECT id,asin FROM products WHERE parent_id = 977
145 0.0002 0.00018310546875
SELECT category_id FROM products_categories WHERE product_id = '977'
146 0.0002 0.00020122528076172
SELECT * FROM categories WHERE id = '27'
147 0.0002 0.00018811225891113
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
148 0.0002 0.00022292137145996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
149 0.0002 0.00015497207641602
SELECT id FROM categories WHERE parent_id = '27'
150 0.0002 0.00017595291137695
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 
151 0.0002 0.00016689300537109
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 
152 0.0002 0.00015592575073242
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
153 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
154 0.0002 0.00023198127746582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '977' AND a.name = n.originalname
155 0.0002 0.00021505355834961
SELECT * FROM productoffers WHERE product_id = '977' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '977' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '977'
158 0.0002 0.00015807151794434
SELECT value FROM productattributes WHERE product_id = '977' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0002 0.00017213821411133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '977' AND a.name = n.originalname
160 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '977' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '977' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0004 0.00036096572875977
SELECT category_id FROM products_categories WHERE product_id = '977' AND prod_type = 'amz'
163 0.0002 0.00017404556274414
SELECT parent_id FROM categories WHERE id = '27'
164 0.0003 0.00027894973754883
SELECT * FROM categories WHERE id = '27'
165 0.0001 0.00014686584472656
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
166 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0001 0.00014710426330566
SELECT id FROM categories WHERE parent_id = '27'
168 0.0002 0.0002129077911377
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 
169 0.0002 0.00017404556274414
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 
170 0.0002 0.00015401840209961
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
171 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0002 0.00022506713867188
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
173 0.0001 0.00014495849609375
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
174 0.0002 0.00018191337585449
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
175 0.0003 0.00031590461730957
SELECT * FROM pages WHERE id = 38
176 0.0047 0.0047059059143066
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
177 0.0010 0.00095701217651367
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:1635204491;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:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
178 0.0005 0.00045180320739746
SELECT * FROM products WHERE id = 790
179 0.0006 0.0006098747253418
SELECT * FROM products WHERE id = 788
180 0.0005 0.00053286552429199
SELECT * FROM products WHERE id = 787
181 0.0006 0.0005950927734375
SELECT * FROM products WHERE id = 1287
182 0.0014 0.0013799667358398
SELECT * FROM products WHERE id = 780
183 0.0006 0.00056791305541992
SELECT * FROM products WHERE id = 779
184 0.0011 0.0011451244354248
SELECT * FROM products WHERE id = '790'
185 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
186 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '790'
187 0.0002 0.00016999244689941
SELECT * FROM productcustomimages WHERE product_id = '790'
188 0.0002 0.00017809867858887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
189 0.0002 0.00017309188842773
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0008 0.00081801414489746
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0004 0.00043106079101562
SELECT * FROM products WHERE id = '788'
193 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
194 0.0002 0.00016283988952637
SELECT * FROM product_image_select WHERE product_id = '788'
195 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '788'
196 0.0002 0.00016212463378906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
197 0.0002 0.00016593933105469
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0002 0.00018692016601562
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0005 0.00047683715820312
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0004 0.00039386749267578
SELECT * FROM products WHERE id = '787'
201 0.0002 0.00016617774963379
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
202 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '787'
203 0.0002 0.00016498565673828
SELECT * FROM productcustomimages WHERE product_id = '787'
204 0.0002 0.00015807151794434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
205 0.0002 0.00016999244689941
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0002 0.00018405914306641
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0006 0.00063490867614746
SELECT * FROM products WHERE id = '1287'
209 0.0004 0.00038909912109375
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
210 0.0002 0.0001838207244873
SELECT * FROM product_image_select WHERE product_id = '1287'
211 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '1287'
212 0.0002 0.00019598007202148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
213 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0002 0.00018715858459473
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0002 0.00022292137145996
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0004 0.00039887428283691
SELECT * FROM products WHERE id = '780'
217 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
218 0.0002 0.00017285346984863
SELECT * FROM product_image_select WHERE product_id = '780'
219 0.0002 0.00015592575073242
SELECT * FROM productcustomimages WHERE product_id = '780'
220 0.0002 0.00020813941955566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
221 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0002 0.00018310546875
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0002 0.00023508071899414
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0004 0.00039410591125488
SELECT * FROM products WHERE id = '779'
225 0.0002 0.00017499923706055
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
226 0.0002 0.00017714500427246
SELECT * FROM product_image_select WHERE product_id = '779'
227 0.0002 0.00016593933105469
SELECT * FROM productcustomimages WHERE product_id = '779'
228 0.0002 0.00017309188842773
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
229 0.0002 0.00021481513977051
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0009 0.00094199180603027
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0003 0.00026679039001465
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
233 0.0004 0.00037384033203125
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
234 0.0005 0.00051403045654297
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
235 0.0004 0.00037407875061035
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
236 0.0004 0.00037622451782227
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0004 0.00044798851013184
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
238 0.0005 0.00046110153198242
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0004 0.00035500526428223
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'