Coffret Rooibos Saveurs d'un Soir - La Route des Comptoirs

Coffret Rooibos Saveurs d'un Soir - La Route des Comptoirs
Coffret Rooibos Saveurs d'un Soir - La Route des Comptoirs Coffret Rooibos Saveurs d'un Soir - La Route des Comptoirs Coffret Rooibos Saveurs d'un Soir - La Route des Comptoirs (cliquez sur les images pour élargir)
€12,80
Le prix et la disponibilité du produit sont corrects en date du 2022-05-21 00:49:49 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

Ce coffret original de 48 infusettes se compose de 4 variétés de rooïbos bio, infusions savoureuses bio et SANS théine. Infusion SERENITE : Rooïbos d'Afrique du sud, cardamome, fenouil, badiane, tilleul. Rooïbos RÊVES D'UN SOIR : Rooïbos, tilleul, verveine. Rooïbos AGRUMES : Rooïbos, huiles essentielles certifiées d'orange, de citron, de citron-vert, de bergamote et de pamplemousse. Rooïbos NATURE : Rooïbos.
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.93013596534729 249 0.1552 0


No Amazon API Requests Made.

Total time 0.93013596534729 seconds

Number Time From Start Name Description
1 0.68765091896057 Initialise Initialise FSB Function
2 0.69523596763611 App Controller Start Start of the App controller (called before the controller of every page)
3 0.69871497154236 Start of getCategoryListByGroup Function Before first category groups query
4 0.69910001754761 After initial query Before first category groups query
5 0.69910192489624 Get Category List for Group Before the call to getCategoryList function
6 0.69910597801208 Start of GetCategoryList function Start of the function
7 0.69911003112793 Before getting categories Query to get specific category list
8 0.69967412948608 After getting categories Query to get specific category list
9 0.69967603683472 Before getting category custom Before call to function getCategoryCustom
10 0.71992206573486 After getting category custom After call to function getCategoryCustom
11 0.71992492675781 Before getting category custom Before call to function getCategoryCustom
12 0.73044800758362 After getting category custom After call to function getCategoryCustom
13 0.73045110702515 Before getting category custom Before call to function getCategoryCustom
14 0.73557209968567 After getting category custom After call to function getCategoryCustom
15 0.73557710647583 Before getting category custom Before call to function getCategoryCustom
16 0.73870992660522 After getting category custom After call to function getCategoryCustom
17 0.73871302604675 Before getting category custom Before call to function getCategoryCustom
18 0.74123597145081 After getting category custom After call to function getCategoryCustom
19 0.74123811721802 Before getting category custom Before call to function getCategoryCustom
20 0.74416899681091 After getting category custom After call to function getCategoryCustom
21 0.74417090415955 End of GetCategoryList function End of the function
22 0.7441771030426 End of getCategoryListByGroup Function Before return()
23 0.76149797439575 App Controller End End of the App controller (called before the controller of every page)
24 0.76233196258545 Product Start Start of the product info controller
25 0.7649519443512 Cache file not found Starting get product details
26 0.78776001930237 Related products Start getting related products if enabled
27 0.787761926651 Related Products Start Before the related products are found
28 0.7877631187439 Related Products Keywords Before the related product keywords are found
29 0.78776812553406 Create Keyword List Function Start of function
30 0.78784012794495 Create Keyword List Function After looping provided content - 24 keywords found
31 0.78880190849304 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
32 0.78881001472473 Create Keyword List Function After reducing keyword list
33 0.78887104988098 Create Keyword List Function After selecting by scoring keywords
34 0.78887605667114 Create Keyword List Function After final loop of keywords
35 0.78887796401978 Related Products Keywords After the related product keywords are found
36 0.82541298866272 Related Products End After the related products are found
37 0.83383703231812 Product End End of the product info controller (Product Info)
38 0.83532691001892 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.83593702316284 Before Get Options Before the call to getOptions in the tpl class
40 0.86834597587585 After Get Options After the call to getOptions in the tpl class
41 0.86849594116211 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.86852598190308 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.89480400085449 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.89480900764465 Product Info: Before Template Display Before the template is displayed
45 0.93010902404785 Product Info: After Template Display After the template is displayed
46 0.93012309074402 Finalizing debug Before the debug is output to the page.
47 0.93013501167297 End of App This is the end of the app logging, final timestamp


Query Debug - 249 Database Queries. Total time 0.1552 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00073790550231934
SELECT parameter, value FROM parameters
2 0.0014 0.0013790130615234
SELECT * FROM `bad_bots`
3 0.0005 0.00052380561828613
SET time_zone = 'Europe/London'
4 0.0005 0.00046110153198242
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0021781921386719
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0013 0.0012528896331787
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653308336'
7 0.0006 0.00060319900512695
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.0003659725189209
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00050091743469238
SELECT id FROM pages WHERE pagename = 'coffret-rooibos-saveurs-dun-soir-la-route-des-comptoirs' LIMIT 1
10 0.0007 0.00074601173400879
SELECT id FROM products WHERE pagename = 'coffret-rooibos-saveurs-dun-soir-la-route-des-comptoirs' AND hidden = 0 LIMIT 1
11 0.0012 0.0011739730834961
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00080490112304688
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00061178207397461
SELECT * FROM pages WHERE pagename = 'coffret-rooibos-saveurs-dun-soir-la-route-des-comptoirs'
14 0.0004 0.00037193298339844
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00054311752319336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0109 0.010875940322876
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.0003 0.0002601146697998
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.00026702880859375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00023102760314941
SELECT id FROM categories WHERE parent_id = '26'
20 0.0072 0.0071828365325928
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.0004 0.00041580200195312
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.0004 0.00037002563476562
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.00023913383483887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00022697448730469
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0043540000915527
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.0003 0.00026893615722656
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.00022411346435547
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '27'
29 0.0042 0.0042200088500977
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.00031709671020508
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.00029301643371582
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.00023293495178223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00025296211242676
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0015859603881836
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.00022101402282715
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.00022602081298828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00022983551025391
SELECT id FROM categories WHERE parent_id = '28'
38 0.0019 0.0018539428710938
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.00024914741516113
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.00022482872009277
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.00020599365234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00021505355834961
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00082302093505859
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.00023889541625977
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.00023102760314941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00067996978759766
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.0002 0.00021100044250488
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.00020885467529297
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.00020313262939453
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.0001978874206543
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00047612190246582
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.00021219253540039
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.00019311904907227
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00053596496582031
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.00019288063049316
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.00018620491027832
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.00022387504577637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00020694732666016
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00063109397888184
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.0003 0.00025105476379395
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.00021886825561523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00065207481384277
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.00022411346435547
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.00020503997802734
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.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00023484230041504
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00031900405883789
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0009 0.00094795227050781
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00026607513427734
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.0003 0.0002739429473877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0007 0.00065398216247559
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00046515464782715
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00028204917907715
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.247.88') >= INET_ATON(ip_start) AND INET_ATON('34.231.247.88') <= INET_ATON(ip_end)
77 0.0002 0.00022697448730469
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00024914741516113
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.00050997734069824
SELECT * FROM products WHERE pagename = 'coffret-rooibos-saveurs-dun-soir-la-route-des-comptoirs'
80 0.0009 0.00091791152954102
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1093
81 0.0003 0.00034999847412109
SELECT * FROM manufacturers WHERE id = '183'
82 0.0008 0.00077295303344727
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
83 0.0003 0.00033283233642578
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '183' LIMIT 1
84 0.0009 0.00088596343994141
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '183' ORDER BY RAND() LIMIT 1
85 0.0014 0.0013871192932129
SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
86 0.0003 0.00032210350036621
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
87 0.0006 0.00059700012207031
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '183'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0002 0.00024008750915527
SELECT * FROM manufacturerimages WHERE manufacturer_id = '183'
89 0.0004 0.00036406517028809
SELECT category_id FROM products_categories WHERE product_id = '1093'
90 0.0003 0.00026893615722656
SELECT * FROM categories WHERE id = '27'
91 0.0047 0.0046820640563965
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.0002 0.00023889541625977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '27'
94 0.0044 0.0044260025024414
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.00031805038452148
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.00023508071899414
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.00020408630371094
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00023889541625977
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
99 0.0003 0.00026488304138184
SELECT * FROM product_image_select WHERE product_id = '1093'
100 0.0002 0.00021195411682129
SELECT * FROM productcustomimages WHERE product_id = '1093'
101 0.0003 0.00031089782714844
SELECT * FROM productfeeds WHERE product_id = '1093' ORDER BY item_date DESC
102 0.0015 0.0014870166778564
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0004 0.00042295455932617
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1093' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00038599967956543
SELECT * FROM productamazoncontent WHERE product_id = '1093'
105 0.0014 0.0014338493347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
106 0.0004 0.00036883354187012
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0002 0.00023698806762695
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.0080 0.0080149173736572
SELECT *, MATCH (description, title) AGAINST ('route des comptoirs' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('route des comptoirs' IN BOOLEAN MODE) AND 1093 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
111 0.0006 0.00056004524230957
SELECT *, MATCH (description, title) AGAINST ('route des comptoirs' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('route des comptoirs' IN BOOLEAN MODE) AND 1093 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
112 0.0005 0.00046300888061523
SELECT *, MATCH (description, title) AGAINST ('route des comptoirs' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('route des comptoirs' IN BOOLEAN MODE) AND 1093 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
114 0.0003 0.00026512145996094
SELECT * FROM product_image_select WHERE product_id = '4905'
115 0.0002 0.00024509429931641
SELECT * FROM productcustomimages WHERE product_id = '4905'
116 0.0010 0.0010001659393311
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
117 0.0004 0.00037813186645508
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0004 0.00041484832763672
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0005 0.00051403045654297
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0002 0.00024008750915527
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
121 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '1093'
122 0.0002 0.00022602081298828
SELECT * FROM productcustomimages WHERE product_id = '1093'
123 0.0003 0.00027680397033691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
124 0.0003 0.00025200843811035
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0003 0.00028705596923828
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0090 0.008976936340332
SELECT *, MATCH (description, title) AGAINST ('coffret rooibos saveurs' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('coffret rooibos saveurs' IN BOOLEAN MODE) AND 1093 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
128 0.0005 0.00047111511230469
SELECT *, MATCH (description, title) AGAINST ('coffret rooibos saveurs' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('coffret rooibos saveurs' IN BOOLEAN MODE) AND 1093 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
129 0.0004 0.00041890144348145
SELECT *, MATCH (description, title) AGAINST ('coffret rooibos saveurs' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('coffret rooibos saveurs' IN BOOLEAN MODE) AND 1093 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
130 0.0006 0.00062799453735352
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
131 0.0003 0.0002601146697998
SELECT * FROM product_image_select WHERE product_id = '878'
132 0.0002 0.00024580955505371
SELECT * FROM productcustomimages WHERE product_id = '878'
133 0.0003 0.00029087066650391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
134 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0006 0.0005791187286377
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0004 0.00035691261291504
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
138 0.0012 0.0011699199676514
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
139 0.0003 0.00027990341186523
SELECT * FROM product_image_select WHERE product_id = '822'
140 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '822'
141 0.0010 0.001021146774292
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
142 0.0011 0.001068115234375
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
143 0.0007 0.00067400932312012
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
144 0.0003 0.00033402442932129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
145 0.0006 0.00055503845214844
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0006 0.00057411193847656
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
148 0.0002 0.00023078918457031
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
149 0.0002 0.00023198127746582
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
150 0.0002 0.00024604797363281
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
151 0.0002 0.0002291202545166
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
152 0.0002 0.00022292137145996
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0006 0.00063109397888184
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
154 0.0003 0.00034785270690918
SELECT id,asin FROM products WHERE parent_id = 1093
155 0.0003 0.00033903121948242
SELECT category_id FROM products_categories WHERE product_id = '1093'
156 0.0004 0.00038886070251465
SELECT * FROM categories WHERE id = '27'
157 0.0002 0.00020885467529297
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
158 0.0002 0.0002131462097168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
159 0.0002 0.00021982192993164
SELECT id FROM categories WHERE parent_id = '27'
160 0.0002 0.00022792816162109
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 
161 0.0002 0.00022983551025391
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 
162 0.0003 0.00026488304138184
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
163 0.0002 0.00023293495178223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
164 0.0004 0.00042510032653809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
165 0.0004 0.00041294097900391
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0004 0.0004270076751709
SELECT * FROM products WHERE id = '1093'
168 0.0003 0.00026679039001465
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0003 0.00034117698669434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
170 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.0003819465637207
SELECT category_id FROM products_categories WHERE product_id = '1093' AND prod_type = 'amz'
173 0.0002 0.00023889541625977
SELECT parent_id FROM categories WHERE id = '27'
174 0.0003 0.00033998489379883
SELECT * FROM categories WHERE id = '27'
175 0.0003 0.00026106834411621
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
176 0.0002 0.00022196769714355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
177 0.0002 0.00021719932556152
SELECT id FROM categories WHERE parent_id = '27'
178 0.0002 0.00024890899658203
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 
179 0.0002 0.00022506713867188
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 
180 0.0002 0.00022411346435547
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
181 0.0002 0.0002140998840332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
182 0.0003 0.00034499168395996
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
183 0.0003 0.00026512145996094
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
184 0.0003 0.00026392936706543
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
185 0.0003 0.0002899169921875
SELECT * FROM pages WHERE id = 38
186 0.0048 0.004824161529541
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
187 0.0007 0.00071597099304199
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:1653308337;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'
188 0.0005 0.00046491622924805
SELECT * FROM products WHERE id = 788
189 0.0005 0.0005180835723877
SELECT * FROM products WHERE id = 787
190 0.0005 0.00048184394836426
SELECT * FROM products WHERE id = 1287
191 0.0005 0.0004730224609375
SELECT * FROM products WHERE id = 780
192 0.0005 0.00047898292541504
SELECT * FROM products WHERE id = 777
193 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = 776
194 0.0005 0.00049090385437012
SELECT * FROM products WHERE id = '788'
195 0.0003 0.00033998489379883
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
196 0.0002 0.00023913383483887
SELECT * FROM product_image_select WHERE product_id = '788'
197 0.0002 0.00023603439331055
SELECT * FROM productcustomimages WHERE product_id = '788'
198 0.0003 0.00028491020202637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
199 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0004 0.0004420280456543
SELECT * FROM products WHERE id = '787'
203 0.0003 0.00030183792114258
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
204 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '787'
205 0.0002 0.00021696090698242
SELECT * FROM productcustomimages WHERE product_id = '787'
206 0.0002 0.00023198127746582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
207 0.0002 0.00023698806762695
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0003 0.00025320053100586
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '1287'
211 0.0003 0.0003201961517334
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
212 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '1287'
213 0.0005 0.00049018859863281
SELECT * FROM productcustomimages WHERE product_id = '1287'
214 0.0003 0.00030016899108887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
215 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0007 0.00065803527832031
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0008 0.00081610679626465
SELECT * FROM products WHERE id = '780'
219 0.0003 0.00026583671569824
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
220 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '780'
221 0.0002 0.00024008750915527
SELECT * FROM productcustomimages WHERE product_id = '780'
222 0.0003 0.00027894973754883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
223 0.0003 0.00026798248291016
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0002 0.00020694732666016
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0005 0.00045609474182129
SELECT * FROM products WHERE id = '777'
227 0.0003 0.00032806396484375
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0002 0.00023293495178223
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0003 0.00026297569274902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0002 0.00024509429931641
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0003 0.00026607513427734
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0005 0.000518798828125
SELECT * FROM products WHERE id = '776'
235 0.0003 0.00031185150146484
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
236 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '776'
237 0.0002 0.00023293495178223
SELECT * FROM productcustomimages WHERE product_id = '776'
238 0.0003 0.0002748966217041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
239 0.0002 0.00024223327636719
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00021004676818848
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0010 0.00095605850219727
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
243 0.0003 0.00028204917907715
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
244 0.0006 0.00058794021606445
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
245 0.0003 0.00032305717468262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
246 0.0003 0.0003359317779541
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
247 0.0009 0.0009160041809082
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
248 0.0005 0.00045204162597656
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
249 0.0003 0.00028896331787109
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'