0

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

Price: €15,75
Product prices and availability are accurate as of 2021-07-20 03:31:31 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.
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.

Manufacturer Description

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

Product Features

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

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
1.6876401901245 264 0.8597 0


No Amazon API Requests Made.


App Debug - Total Time 1.6876401901245 seconds

Number Time From Start Name Description
1 0.52668309211731 Initialise Initialise FSB Function
2 0.54352498054504 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58530497550964 Start of getCategoryListByGroup Function Before first category groups query
4 0.58806800842285 After initial query Before first category groups query
5 0.58806896209717 Get Category List for Group Before the call to getCategoryList function
6 0.58807301521301 Start of GetCategoryList function Start of the function
7 0.58807611465454 Before getting categories Query to get specific category list
8 0.59061312675476 After getting categories Query to get specific category list
9 0.59061503410339 Before getting category custom Before call to function getCategoryCustom
10 0.61837005615234 After getting category custom After call to function getCategoryCustom
11 0.61837196350098 Before getting category custom Before call to function getCategoryCustom
12 0.63871002197266 After getting category custom After call to function getCategoryCustom
13 0.63871312141418 Before getting category custom Before call to function getCategoryCustom
14 0.64686918258667 After getting category custom After call to function getCategoryCustom
15 0.6468710899353 Before getting category custom Before call to function getCategoryCustom
16 0.65241718292236 After getting category custom After call to function getCategoryCustom
17 0.652419090271 Before getting category custom Before call to function getCategoryCustom
18 0.66005802154541 After getting category custom After call to function getCategoryCustom
19 0.66006016731262 Before getting category custom Before call to function getCategoryCustom
20 0.67219519615173 After getting category custom After call to function getCategoryCustom
21 0.67219710350037 End of GetCategoryList function End of the function
22 0.67220401763916 Get Category List for Group Before the call to getCategoryList function
23 0.67220616340637 Start of GetCategoryList function Start of the function
24 0.67220902442932 Before getting categories Query to get specific category list
25 0.67343616485596 End of getCategoryListByGroup Function Before return()
26 1.1399760246277 App Controller End End of the App controller (called before the controller of every page)
27 1.140771150589 Product Start Start of the product info controller
28 1.1682250499725 Cache file not found Starting get product details
29 1.2128779888153 Related products Start getting related products if enabled
30 1.2128801345825 Related Products Start Before the related products are found
31 1.2128810882568 Related Products Keywords Before the related product keywords are found
32 1.212886095047 Create Keyword List Function Start of function
33 1.2129850387573 Create Keyword List Function After looping provided content - 21 keywords found
34 1.2138681411743 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 1.2138760089874 Create Keyword List Function After reducing keyword list
36 1.2139229774475 Create Keyword List Function After selecting by scoring keywords
37 1.2139270305634 Create Keyword List Function After final loop of keywords
38 1.2139291763306 Related Products Keywords After the related product keywords are found
39 1.2677011489868 Related Products End After the related products are found
40 1.3096261024475 Product End End of the product info controller (Product Info)
41 1.3125779628754 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3148021697998 Before Get Options Before the call to getOptions in the tpl class
43 1.3951761722565 After Get Options After the call to getOptions in the tpl class
44 1.3953771591187 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3954191207886 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6006050109863 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6006109714508 Product Info: Before Template Display Before the template is displayed
48 1.6876091957092 Product Info: After Template Display After the template is displayed
49 1.6876261234283 Finalizing debug Before the debug is output to the page.
50 1.6876389980316 End of App This is the end of the app logging, final timestamp


Query Debug - 264 Database Queries. Total time 0.8597 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0024 0.0024139881134033
SELECT parameter, value FROM parameters
2 0.0088 0.0087571144104004
SELECT * FROM `bad_bots`
3 0.0006 0.00058889389038086
SET time_zone = 'Europe/London'
4 0.0012 0.0011730194091797
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0076 0.0075759887695312
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.143.221.115\";}'
6 0.0048 0.0047721862792969
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738806660'
7 0.0038 0.0038058757781982
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.0009770393371582
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0035 0.0034749507904053
SELECT id FROM pages WHERE pagename = 'dammann-frres-the-rooibos-cederberg-24-sachets-individuels' LIMIT 1
10 0.0117 0.011685132980347
SELECT id FROM products WHERE pagename = 'dammann-frres-the-rooibos-cederberg-24-sachets-individuels' AND hidden = 0 LIMIT 1
11 0.0049 0.0049111843109131
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0354 0.03535008430481
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0010 0.0010480880737305
SELECT * FROM pages WHERE pagename = 'dammann-frres-the-rooibos-cederberg-24-sachets-individuels'
14 0.0028 0.0027508735656738
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0025 0.0025181770324707
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0075 0.0075221061706543
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.0019 0.0019330978393555
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.0017 0.0016748905181885
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.0005791187286377
SELECT id FROM categories WHERE parent_id = '26'
20 0.0060 0.0060129165649414
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.0033 0.0033090114593506
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.0029 0.0029158592224121
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.0029 0.0029020309448242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0008 0.00080204010009766
SELECT * FROM categorygroups WHERE id = '1'
25 0.0092 0.0091500282287598
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.0007 0.00069689750671387
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.0005 0.00054407119750977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00054001808166504
SELECT id FROM categories WHERE parent_id = '27'
29 0.0064 0.0063860416412354
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.00083494186401367
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.0008 0.00083303451538086
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.0007 0.00069808959960938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00053215026855469
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.002007007598877
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.0006 0.00064897537231445
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.0006 0.00057411193847656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.0005190372467041
SELECT id FROM categories WHERE parent_id = '28'
38 0.0021 0.0020530223846436
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.0005 0.00054192543029785
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.0006 0.00061702728271484
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.0005 0.0005488395690918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0006 0.0005640983581543
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00069880485534668
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.0005 0.00047898292541504
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.0005 0.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00050115585327148
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00076508522033691
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.0007 0.00065207481384277
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.0008 0.00082206726074219
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.0005 0.00054216384887695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00051307678222656
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00057387351989746
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0004 0.00044584274291992
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.0005 0.00049090385437012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0020 0.0019569396972656
SELECT id FROM categories WHERE parent_id = '30'
56 0.0012 0.0011579990386963
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.0007 0.00073003768920898
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.0007 0.00065898895263672
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.0006 0.00059199333190918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0010 0.00095510482788086
SELECT * FROM categorygroups WHERE id = '1'
61 0.0013 0.0013289451599121
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.0009 0.00089097023010254
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.0009 0.00092005729675293
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.00064492225646973
SELECT id FROM categories WHERE parent_id = '31'
65 0.0014 0.0014309883117676
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.0022 0.002249002456665
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.0021 0.0020549297332764
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.0013 0.001317024230957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0012 0.0011961460113525
SELECT * FROM categorygroups WHERE id = '1'
70 0.0012 0.001215934753418
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0095 0.0095260143280029
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0050 0.0049610137939453
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0011 0.0010719299316406
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.0021 0.0020689964294434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0022 0.0022130012512207
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0016 0.0015690326690674
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4397 0.43966317176819
SELECT * FROM ipgeocountries WHERE INET_ATON('3.143.221.115') >= INET_ATON(ip_start) AND INET_ATON('3.143.221.115') <= INET_ATON(ip_end)
78 0.0021 0.0021059513092041
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0013580322265625
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00065803527832031
SELECT * FROM products WHERE pagename = 'dammann-frres-the-rooibos-cederberg-24-sachets-individuels'
81 0.0005 0.00053191184997559
UPDATE products SET viewcount = viewcount + 1 WHERE id = 979
82 0.0008 0.00081896781921387
SELECT * FROM manufacturers WHERE id = '177'
83 0.0006 0.00060606002807617
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
84 0.0022 0.0021829605102539
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '177' LIMIT 1
85 0.0025 0.0024549961090088
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
86 0.0005 0.00052189826965332
SELECT * FROM productimages WHERE product_id = '975' ORDER BY sortorder ASC
87 0.0006 0.00061798095703125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
88 0.0006 0.00058293342590332
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 
89 0.0005 0.00053596496582031
SELECT * FROM manufacturerimages WHERE manufacturer_id = '177'
90 0.0011 0.0011050701141357
SELECT category_id FROM products_categories WHERE product_id = '979'
91 0.0011 0.0010700225830078
SELECT * FROM categories WHERE id = '27'
92 0.0068 0.0068061351776123
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0030 0.0029878616333008
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '27'
95 0.0042 0.0041990280151367
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0007 0.00065088272094727
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0006 0.00057387351989746
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0005 0.00049495697021484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00051999092102051
SELECT * FROM productimages WHERE product_id = '979' ORDER BY sortorder ASC
100 0.0017 0.001723051071167
SELECT * FROM product_image_select WHERE product_id = '979'
101 0.0013 0.00130295753479
SELECT * FROM productcustomimages WHERE product_id = '979'
102 0.0012 0.0012180805206299
SELECT * FROM productfeeds WHERE product_id = '979' ORDER BY item_date DESC
103 0.0029 0.0028929710388184
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '979' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0025 0.0024750232696533
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '979' AND t.hidden = 0 AND display_product = 1
105 0.0016 0.0016260147094727
SELECT * FROM productamazoncontent WHERE product_id = '979'
106 0.0011 0.0010898113250732
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '979' AND a.name = n.originalname
107 0.0014 0.0014278888702393
SELECT * FROM productoffers WHERE product_id = '979' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0016 0.0015790462493896
SELECT * FROM productoffers
                WHERE product_id = '979' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00037407875061035
SELECT * FROM productoffers
                WHERE product_id = 979
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00049614906311035
SELECT value FROM productattributes
                WHERE product_id = '979'
                AND name = 'ListPriceAmount'
111 0.0005 0.0005040168762207
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
112 0.0095 0.0094799995422363
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 979 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
113 0.0009 0.00094485282897949
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 979 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0008 0.00075817108154297
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 979 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0005 0.00050115585327148
SELECT * FROM productimages WHERE product_id = '1727' ORDER BY sortorder ASC
116 0.0008 0.00076389312744141
SELECT * FROM product_image_select WHERE product_id = '1727'
117 0.0004 0.00044083595275879
SELECT * FROM productcustomimages WHERE product_id = '1727'
118 0.0009 0.00092411041259766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1727' AND a.name = n.originalname
119 0.0006 0.00057792663574219
SELECT * FROM productoffers WHERE product_id = '1727' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00052285194396973
SELECT * FROM productoffers
                WHERE product_id = '1727' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.0004889965057373
SELECT value FROM productattributes WHERE product_id = '1727' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0009 0.00094318389892578
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
123 0.0011 0.0010819435119629
SELECT * FROM product_image_select WHERE product_id = '878'
124 0.0007 0.00066804885864258
SELECT * FROM productcustomimages WHERE product_id = '878'
125 0.0019 0.0019490718841553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
126 0.0009 0.00090193748474121
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0006 0.0006248950958252
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0006 0.00061202049255371
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0009 0.00093817710876465
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
130 0.0010 0.00099611282348633
SELECT * FROM product_image_select WHERE product_id = '858'
131 0.0006 0.00060105323791504
SELECT * FROM productcustomimages WHERE product_id = '858'
132 0.0018 0.0017721652984619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
133 0.0009 0.0008699893951416
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0007 0.00073099136352539
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0007 0.00066518783569336
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0008 0.00078582763671875
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
137 0.0008 0.00080704689025879
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
138 0.0008 0.00083303451538086
SELECT * FROM product_image_select WHERE product_id = '822'
139 0.0006 0.00055098533630371
SELECT * FROM productcustomimages WHERE product_id = '822'
140 0.0007 0.0006561279296875
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
141 0.0033 0.0033321380615234
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
142 0.0006 0.0006411075592041
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
143 0.0013 0.0012691020965576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
144 0.0005 0.00045180320739746
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0005 0.00047397613525391
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00049495697021484
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
148 0.0005 0.00052404403686523
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
149 0.0008 0.00076913833618164
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
150 0.0005 0.00050783157348633
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
151 0.0007 0.00066995620727539
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0008 0.0008089542388916
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
153 0.0007 0.00071406364440918
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
154 0.0007 0.0007479190826416
SELECT * FROM product_image_select WHERE product_id = '857'
155 0.0005 0.00050997734069824
SELECT * FROM productcustomimages WHERE product_id = '857'
156 0.0013 0.0013411045074463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
157 0.0006 0.00058484077453613
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0005 0.00049710273742676
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0006 0.00058603286743164
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
161 0.0007 0.00066304206848145
SELECT * FROM product_image_select WHERE product_id = '764'
162 0.0004 0.00043201446533203
SELECT * FROM productcustomimages WHERE product_id = '764'
163 0.0013 0.0012989044189453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
164 0.0006 0.00060796737670898
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0005 0.0005028247833252
SELECT id,asin FROM products WHERE parent_id = 979
168 0.0019 0.0019471645355225
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '979' ORDER BY timestamp DESC
169 0.0005 0.00049614906311035
SELECT category_id FROM products_categories WHERE product_id = '979'
170 0.0005 0.00048708915710449
SELECT * FROM categories WHERE id = '27'
171 0.0055 0.0054950714111328
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
172 0.0006 0.00057697296142578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
173 0.0004 0.00044918060302734
SELECT id FROM categories WHERE parent_id = '27'
174 0.0060 0.0059850215911865
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 
175 0.0007 0.00072789192199707
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 
176 0.0007 0.00070595741271973
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
177 0.0007 0.00066113471984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
178 0.0014 0.0014388561248779
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '979' AND a.name = n.originalname
179 0.0006 0.00061893463134766
SELECT * FROM productoffers WHERE product_id = '979' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0005 0.00048613548278809
SELECT * FROM productoffers
                WHERE product_id = '979' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = 979
                ORDER BY price ASC LIMIT 1
182 0.0005 0.0004730224609375
SELECT value FROM productattributes
                WHERE product_id = '979'
                AND name = 'ListPriceAmount'
183 0.0009 0.00087213516235352
SELECT * FROM products WHERE id = '979'
184 0.0012 0.0012011528015137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '979' AND a.name = n.originalname
185 0.0005 0.00046086311340332
SELECT * FROM productoffers WHERE product_id = '979' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0007 0.00065898895263672
SELECT * FROM productoffers
                WHERE product_id = '979' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0007 0.00067687034606934
SELECT * FROM productoffers
                WHERE product_id = 979
                ORDER BY price ASC LIMIT 1
188 0.0005 0.00047707557678223
SELECT value FROM productattributes
                WHERE product_id = '979'
                AND name = 'ListPriceAmount'
189 0.0007 0.00072002410888672
SELECT category_id FROM products_categories WHERE product_id = '979' AND prod_type = 'amz'
190 0.0005 0.00049304962158203
SELECT parent_id FROM categories WHERE id = '27'
191 0.0005 0.00046896934509277
SELECT * FROM categories WHERE id = '27'
192 0.0057 0.0056889057159424
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
193 0.0005 0.00053882598876953
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
194 0.0004 0.00042295455932617
SELECT id FROM categories WHERE parent_id = '27'
195 0.0051 0.005126953125
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 
196 0.0006 0.00063300132751465
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 
197 0.0006 0.00063681602478027
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
198 0.0006 0.0005800724029541
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
199 0.0021 0.0021040439605713
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
200 0.0017 0.0016648769378662
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
201 0.0004 0.00041484832763672
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
202 0.0257 0.025653839111328
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
203 0.0023 0.002310037612915
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
204 0.0006 0.00062704086303711
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
205 0.0006 0.000640869140625
SELECT * FROM products WHERE id = 1626
206 0.0006 0.00063991546630859
SELECT * FROM products WHERE id = 4041
207 0.0006 0.00064992904663086
SELECT * FROM products WHERE id = 4312
208 0.0006 0.00062894821166992
SELECT * FROM products WHERE id = 777
209 0.0006 0.00060296058654785
SELECT * FROM products WHERE id = 3881
210 0.0006 0.00059890747070312
SELECT * FROM products WHERE id = 4213
211 0.0006 0.00057315826416016
SELECT * FROM products WHERE id = '1626'
212 0.0005 0.00052380561828613
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
213 0.0007 0.00069618225097656
SELECT * FROM product_image_select WHERE product_id = '1626'
214 0.0005 0.0004880428314209
SELECT * FROM productcustomimages WHERE product_id = '1626'
215 0.0010 0.0010108947753906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
216 0.0006 0.00055909156799316
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0005 0.0005030632019043
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0006 0.00055503845214844
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0009 0.00088095664978027
SELECT * FROM products WHERE id = '4041'
220 0.0006 0.00060510635375977
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
221 0.0007 0.0007171630859375
SELECT * FROM product_image_select WHERE product_id = '4041'
222 0.0007 0.00072407722473145
SELECT * FROM productcustomimages WHERE product_id = '4041'
223 0.0015 0.0015490055084229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
224 0.0006 0.00062894821166992
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0005 0.00051403045654297
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0007 0.00073409080505371
SELECT * FROM products WHERE id = '4312'
228 0.0005 0.00053596496582031
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
229 0.0007 0.00070905685424805
SELECT * FROM product_image_select WHERE product_id = '4312'
230 0.0005 0.00054502487182617
SELECT * FROM productcustomimages WHERE product_id = '4312'
231 0.0014 0.0013968944549561
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
232 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0006 0.00062298774719238
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0005 0.00052094459533691
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0007 0.00070714950561523
SELECT * FROM products WHERE id = '777'
236 0.0006 0.00056886672973633
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
237 0.0007 0.00068116188049316
SELECT * FROM product_image_select WHERE product_id = '777'
238 0.0005 0.00047111511230469
SELECT * FROM productcustomimages WHERE product_id = '777'
239 0.0014 0.0013980865478516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
240 0.0006 0.00060200691223145
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0005 0.00050187110900879
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0005 0.00051307678222656
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0007 0.00071597099304199
SELECT * FROM products WHERE id = '3881'
244 0.0009 0.00085783004760742
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
245 0.0007 0.00069308280944824
SELECT * FROM product_image_select WHERE product_id = '3881'
246 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '3881'
247 0.0015 0.0015139579772949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
248 0.0006 0.00057816505432129
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0005 0.00048279762268066
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0005 0.00049018859863281
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0007 0.00071978569030762
SELECT * FROM products WHERE id = '4213'
252 0.0008 0.00081896781921387
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
253 0.0007 0.00070309638977051
SELECT * FROM product_image_select WHERE product_id = '4213'
254 0.0005 0.00046992301940918
SELECT * FROM productcustomimages WHERE product_id = '4213'
255 0.0016 0.0016360282897949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
256 0.0006 0.00057315826416016
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0005 0.00052404403686523
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0027 0.0027368068695068
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
260 0.0010 0.00096392631530762
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
261 0.0038 0.0038321018218994
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
262 0.0026 0.0025830268859863
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
263 0.0008 0.00084209442138672
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
264 0.0014 0.0013840198516846
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'