0

Lipton Coffret Découverte Assortiment de 5 Thés Noirs, Label Rainforest Alliance 50 Sachets parent

Price: €4,02
Product prices and availability are accurate as of 2022-06-25 22:45:05 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.41525602340698 257 0.1931 0


No Amazon API Requests Made.


App Debug - Total Time 0.41525602340698 seconds

Number Time From Start Name Description
1 0.21587300300598 Initialise Initialise FSB Function
2 0.21756505966187 App Controller Start Start of the App controller (called before the controller of every page)
3 0.26943421363831 Start of getCategoryListByGroup Function Before first category groups query
4 0.26976013183594 After initial query Before first category groups query
5 0.26976108551025 Get Category List for Group Before the call to getCategoryList function
6 0.26976299285889 Start of GetCategoryList function Start of the function
7 0.26976418495178 Before getting categories Query to get specific category list
8 0.27012419700623 After getting categories Query to get specific category list
9 0.27012419700623 Before getting category custom Before call to function getCategoryCustom
10 0.28169918060303 After getting category custom After call to function getCategoryCustom
11 0.28170108795166 Before getting category custom Before call to function getCategoryCustom
12 0.29004621505737 After getting category custom After call to function getCategoryCustom
13 0.29004716873169 Before getting category custom Before call to function getCategoryCustom
14 0.29375505447388 After getting category custom After call to function getCategoryCustom
15 0.29375600814819 Before getting category custom Before call to function getCategoryCustom
16 0.29606914520264 After getting category custom After call to function getCategoryCustom
17 0.29607009887695 Before getting category custom Before call to function getCategoryCustom
18 0.29827809333801 After getting category custom After call to function getCategoryCustom
19 0.29827809333801 Before getting category custom Before call to function getCategoryCustom
20 0.30045604705811 After getting category custom After call to function getCategoryCustom
21 0.30045700073242 End of GetCategoryList function End of the function
22 0.30046105384827 Get Category List for Group Before the call to getCategoryList function
23 0.30046200752258 Start of GetCategoryList function Start of the function
24 0.30046319961548 Before getting categories Query to get specific category list
25 0.3007230758667 End of getCategoryListByGroup Function Before return()
26 0.30597615242004 App Controller End End of the App controller (called before the controller of every page)
27 0.30627512931824 Product Start Start of the product info controller
28 0.30751419067383 Cache file not found Starting get product details
29 0.32362699508667 Related products Start getting related products if enabled
30 0.32362818717957 Related Products Start Before the related products are found
31 0.32362914085388 Related Products Keywords Before the related product keywords are found
32 0.32363319396973 Create Keyword List Function Start of function
33 0.32366704940796 Create Keyword List Function After looping provided content - 39 keywords found
34 0.32460999488831 Create Keyword List Function After looping initial keyword list - 35 keywords remaining
35 0.32461619377136 Create Keyword List Function After reducing keyword list
36 0.32470607757568 Create Keyword List Function After selecting by scoring keywords
37 0.3247082233429 Create Keyword List Function After final loop of keywords
38 0.32471013069153 Related Products Keywords After the related product keywords are found
39 0.35216808319092 Related Products End After the related products are found
40 0.36433815956116 Product End End of the product info controller (Product Info)
41 0.36497402191162 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 0.36565613746643 Before Get Options Before the call to getOptions in the tpl class
43 0.4050931930542 After Get Options After the call to getOptions in the tpl class
44 0.40517020225525 App_after Controller End End of the App_after controller (called after the controller of every page)
45 0.405189037323 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 0.40788817405701 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 0.40789008140564 Product Info: Before Template Display Before the template is displayed
48 0.41523599624634 Product Info: After Template Display After the template is displayed
49 0.41524600982666 Finalizing debug Before the debug is output to the page.
50 0.41525602340698 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 0.1931 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0013 0.0013189315795898
SELECT parameter, value FROM parameters
2 0.0042 0.0042099952697754
SELECT * FROM `bad_bots`
3 0.0004 0.0003509521484375
SET time_zone = 'Europe/London'
4 0.0011 0.0011069774627686
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0006 0.00060391426086426
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.99\";}'
6 0.0005 0.00049805641174316
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1757966075'
7 0.0007 0.00066900253295898
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00036311149597168
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00051784515380859
SELECT id FROM pages WHERE pagename = 'lipton-coffret-decouverte-assortiment-de-5-thes-noirs-label' LIMIT 1
10 0.0006 0.00058507919311523
SELECT id FROM products WHERE pagename = 'lipton-coffret-decouverte-assortiment-de-5-thes-noirs-label' AND hidden = 0 LIMIT 1
11 0.0022 0.0022308826446533
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0490 0.049037933349609
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0003 0.00031614303588867
SELECT * FROM pages WHERE pagename = 'lipton-coffret-decouverte-assortiment-de-5-thes-noirs-label'
14 0.0003 0.0003209114074707
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.0003509521484375
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0046 0.0046310424804688
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.00036001205444336
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.00026607513427734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '26'
20 0.0050 0.0049729347229004
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.0003 0.00029611587524414
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.00028419494628906
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.0003 0.00029301643371582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00020813941955566
SELECT * FROM categorygroups WHERE id = '1'
25 0.0031 0.003087043762207
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.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 = 27
27 0.0002 0.00018882751464844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0036799907684326
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.0002 0.00023794174194336
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.00021696090698242
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.00022983551025391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00021100044250488
SELECT * FROM categorygroups WHERE id = '1'
34 0.0010 0.00099492073059082
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.00022602081298828
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.00020408630371094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '28'
38 0.0012 0.0011661052703857
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.00022292137145996
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.0002138614654541
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.00023293495178223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00021815299987793
SELECT * FROM categorygroups WHERE id = '1'
43 0.0003 0.00030517578125
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.00021910667419434
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.00019192695617676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00022077560424805
SELECT id FROM categories WHERE parent_id = '29'
47 0.0003 0.00034093856811523
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.00023794174194336
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.0003 0.00025606155395508
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.00026893615722656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00025081634521484
SELECT * FROM categorygroups WHERE id = '1'
52 0.0003 0.00034999847412109
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.0003 0.00026082992553711
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.00020384788513184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '30'
56 0.0003 0.00030708312988281
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.00020599365234375
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.00021791458129883
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.00023317337036133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00020408630371094
SELECT * FROM categorygroups WHERE id = '1'
61 0.0003 0.0003199577331543
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.00022006034851074
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.00019693374633789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00022315979003906
SELECT id FROM categories WHERE parent_id = '31'
65 0.0003 0.00034093856811523
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.00020885467529297
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.00022006034851074
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.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00020408630371094
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00025701522827148
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0020 0.0020439624786377
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00055289268493652
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00032401084899902
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0003 0.00028014183044434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00085306167602539
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00051593780517578
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0005 0.00046515464782715
SELECT * FROM products WHERE pagename = 'lipton-coffret-decouverte-assortiment-de-5-thes-noirs-label'
78 0.0004 0.00038290023803711
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4500
79 0.0003 0.00025320053100586
SELECT * FROM manufacturers WHERE id = '639'
80 0.0012 0.0012350082397461
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
81 0.0003 0.0003361701965332
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
82 0.0009 0.000885009765625
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
83 0.0003 0.00031089782714844
SELECT * FROM productimages WHERE product_id = '4059' ORDER BY sortorder ASC
84 0.0007 0.0007469654083252
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85 0.0007 0.00074601173400879
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
86 0.0003 0.00027608871459961
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
87 0.0003 0.00027012825012207
SELECT category_id FROM products_categories WHERE product_id = '4500'
88 0.0003 0.00028491020202637
SELECT * FROM productimages WHERE product_id = '4500' ORDER BY sortorder ASC
89 0.0003 0.00033688545227051
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4500' AND p.id = pi.product_id ORDER BY pi.sortorder
90 0.0006 0.00055217742919922
SELECT * FROM product_image_select WHERE product_id = '4500'
91 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '4500'
92 0.0003 0.00031590461730957
SELECT * FROM productfeeds WHERE product_id = '4500' ORDER BY item_date DESC
93 0.0011 0.001086950302124
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4500' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
94 0.0011 0.001107931137085
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4500' AND t.hidden = 0 AND display_product = 1
95 0.0006 0.00056886672973633
SELECT * FROM productamazoncontent WHERE product_id = '4500'
96 0.0004 0.00041103363037109
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 = '4500'
                GROUP BY o.product_id
97 0.0014 0.0013859272003174
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     = '4500'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
98 0.0003 0.00033092498779297
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4500
99 0.0006 0.00056815147399902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4500' AND a.name = n.originalname
100 0.0003 0.00028014183044434
SELECT * FROM productoffers WHERE product_id = '4500' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0003 0.00029993057250977
SELECT * FROM productoffers
                WHERE product_id = '4500' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = 4500
                ORDER BY price ASC LIMIT 1
103 0.0003 0.00028181076049805
SELECT value FROM productattributes
                WHERE product_id = '4500'
                AND name = 'ListPriceAmount'
104 0.0003 0.00029683113098145
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 = '4500'
                GROUP BY o.product_id
105 0.0003 0.0003349781036377
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     = '4500'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
106 0.0003 0.00027894973754883
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4500
107 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '4500' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0005 0.0004880428314209
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4500'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
109 0.0003 0.00033688545227051
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.0079 0.0079469680786133
SELECT *, MATCH (description, title) AGAINST ('coffret découverte assortiment' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('coffret découverte assortiment' IN BOOLEAN MODE) AND 4500 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
111 0.0003 0.00032997131347656
SELECT *, MATCH (description, title) AGAINST ('coffret découverte assortiment' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('coffret découverte assortiment' IN BOOLEAN MODE) AND 4500 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
112 0.0003 0.00030303001403809
SELECT *, MATCH (description, title) AGAINST ('coffret découverte assortiment' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('coffret découverte assortiment' IN BOOLEAN MODE) AND 4500 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0003 0.00026583671569824
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
114 0.0005 0.00047588348388672
SELECT * FROM product_image_select WHERE product_id = '1093'
115 0.0002 0.00022506713867188
SELECT * FROM productcustomimages WHERE product_id = '1093'
116 0.0006 0.00058102607727051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
117 0.0003 0.00028085708618164
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0003 0.00033187866210938
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0004 0.0003972053527832
SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
121 0.0004 0.00042104721069336
SELECT * FROM product_image_select WHERE product_id = '1290'
122 0.0002 0.00020599365234375
SELECT * FROM productcustomimages WHERE product_id = '1290'
123 0.0008 0.00078701972961426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
124 0.0002 0.00024914741516113
SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '1290' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00028085708618164
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
128 0.0004 0.00041890144348145
SELECT * FROM product_image_select WHERE product_id = '4917'
129 0.0002 0.00020813941955566
SELECT * FROM productcustomimages WHERE product_id = '4917'
130 0.0008 0.00083017349243164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
131 0.0003 0.00026917457580566
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0003 0.00027990341186523
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
135 0.0004 0.00043582916259766
SELECT * FROM product_image_select WHERE product_id = '923'
136 0.0002 0.0002138614654541
SELECT * FROM productcustomimages WHERE product_id = '923'
137 0.0007 0.00066184997558594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
138 0.0002 0.00024080276489258
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0003 0.00029182434082031
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '1201' ORDER BY sortorder ASC
142 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '1201'
143 0.0002 0.00020503997802734
SELECT * FROM productcustomimages WHERE product_id = '1201'
144 0.0008 0.00079798698425293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1201' AND a.name = n.originalname
145 0.0003 0.00025510787963867
SELECT * FROM productoffers WHERE product_id = '1201' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '1201' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '1201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0003 0.00034093856811523
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
149 0.0006 0.00062704086303711
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
150 0.0005 0.00046396255493164
SELECT * FROM product_image_select WHERE product_id = '822'
151 0.0002 0.0002140998840332
SELECT * FROM productcustomimages WHERE product_id = '822'
152 0.0003 0.00030803680419922
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
153 0.0003 0.00032591819763184
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
154 0.0003 0.00027704238891602
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
155 0.0006 0.00058412551879883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
156 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
159 0.0003 0.00025820732116699
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
160 0.0003 0.00028705596923828
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
161 0.0003 0.00031900405883789
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
162 0.0003 0.00028395652770996
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
163 0.0003 0.00028014183044434
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0003 0.00034904479980469
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
165 0.0002 0.00023889541625977
SELECT id,asin FROM products WHERE parent_id = 4500
166 0.0003 0.00026392936706543
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4501
167 0.0005 0.0005030632019043
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4501
168 0.0004 0.00035381317138672
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4899
169 0.0003 0.00031280517578125
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4899
170 0.0003 0.00032687187194824
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4500' ORDER BY timestamp DESC
171 0.0002 0.00022387504577637
SELECT category_id FROM products_categories WHERE product_id = '4500'
172 0.0005 0.00049281120300293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4500' AND a.name = n.originalname
173 0.0003 0.00025105476379395
SELECT * FROM productoffers WHERE product_id = '4500' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0014 0.0014181137084961
SELECT * FROM productoffers
                WHERE product_id = '4500' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = 4500
                ORDER BY price ASC LIMIT 1
176 0.0003 0.00029921531677246
SELECT value FROM productattributes
                WHERE product_id = '4500'
                AND name = 'ListPriceAmount'
177 0.0003 0.00027608871459961
SELECT * FROM products WHERE id = '4500'
178 0.0003 0.00028204917907715
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 = '4500'
                GROUP BY o.product_id
179 0.0003 0.0003211498260498
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     = '4500'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
180 0.0004 0.00044894218444824
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4500
181 0.0007 0.00067996978759766
SELECT value FROM productattributes WHERE product_id = '4500' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0016 0.0015928745269775
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4500' AND a.name = n.originalname
183 0.0004 0.00037503242492676
SELECT * FROM productoffers WHERE product_id = '4500' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = '4500' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = 4500
                ORDER BY price ASC LIMIT 1
186 0.0003 0.0002591609954834
SELECT value FROM productattributes
                WHERE product_id = '4500'
                AND name = 'ListPriceAmount'
187 0.0003 0.00031518936157227
SELECT DISTINCT (name) FROM productoptions
188 0.0003 0.00028014183044434
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4500))
189 0.0005 0.00049781799316406
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 4500
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
190 0.0007 0.00074410438537598
SELECT * FROM translationsfilter
191 0.0003 0.00033307075500488
SELECT category_id FROM products_categories WHERE product_id = '4500' AND prod_type = 'amz'
192 0.0004 0.00035500526428223
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0004 0.00041079521179199
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0002 0.00023698806762695
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0168 0.016776084899902
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
196 0.0003 0.0003352165222168
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
197 0.0002 0.00023198127746582
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
198 0.0003 0.0002751350402832
SELECT * FROM products WHERE id = 1626
199 0.0002 0.00024700164794922
SELECT * FROM products WHERE id = 4041
200 0.0003 0.00026202201843262
SELECT * FROM products WHERE id = 4312
201 0.0003 0.00026702880859375
SELECT * FROM products WHERE id = 777
202 0.0002 0.000244140625
SELECT * FROM products WHERE id = 3881
203 0.0003 0.00025796890258789
SELECT * FROM products WHERE id = 4213
204 0.0003 0.00025200843811035
SELECT * FROM products WHERE id = '1626'
205 0.0002 0.0002288818359375
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0004 0.00042510032653809
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0004 0.00044584274291992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00026988983154297
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00028705596923828
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0003 0.00026082992553711
SELECT * FROM products WHERE id = '4041'
213 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0004 0.00039505958557129
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0002 0.00019311904907227
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0006 0.00059008598327637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.0002591609954834
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0002 0.00024509429931641
SELECT * FROM products WHERE id = '4312'
221 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0004 0.00038290023803711
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0002 0.00018787384033203
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0006 0.00056195259094238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
225 0.0002 0.00023818016052246
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00026297569274902
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00034284591674805
SELECT * FROM products WHERE id = '777'
229 0.0002 0.00023007392883301
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0004 0.0003669261932373
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0007 0.00068187713623047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
233 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0002 0.00024914741516113
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0004 0.00037884712219238
SELECT * FROM products WHERE id = '3881'
237 0.0003 0.00026583671569824
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
238 0.0004 0.00036883354187012
SELECT * FROM product_image_select WHERE product_id = '3881'
239 0.0003 0.00033903121948242
SELECT * FROM productcustomimages WHERE product_id = '3881'
240 0.0008 0.00079703330993652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
241 0.0002 0.00024795532226562
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0003 0.00025177001953125
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0003 0.00030994415283203
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0003 0.00025701522827148
SELECT * FROM products WHERE id = '4213'
245 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
246 0.0007 0.00067687034606934
SELECT * FROM product_image_select WHERE product_id = '4213'
247 0.0002 0.00020813941955566
SELECT * FROM productcustomimages WHERE product_id = '4213'
248 0.0018 0.0018379688262939
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
249 0.0003 0.00025010108947754
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0003 0.00025320053100586
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0003 0.00027608871459961
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0006 0.0005950927734375
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0005 0.00045895576477051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0012 0.0011558532714844
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0005 0.00045299530029297
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0003 0.00034093856811523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0007 0.00072216987609863
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'