0

Yogi Tea ROOIBOS 17 FILTRES BIO

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-24 06:19:58 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.

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.3568849563599 261 0.7993 0


No Amazon API Requests Made.


App Debug - Total Time 1.3568849563599 seconds

Number Time From Start Name Description
1 0.52481293678284 Initialise Initialise FSB Function
2 0.52828311920166 App Controller Start Start of the App controller (called before the controller of every page)
3 0.56942415237427 Start of getCategoryListByGroup Function Before first category groups query
4 0.569983959198 After initial query Before first category groups query
5 0.56998705863953 Get Category List for Group Before the call to getCategoryList function
6 0.56999206542969 Start of GetCategoryList function Start of the function
7 0.56999707221985 Before getting categories Query to get specific category list
8 0.57077097892761 After getting categories Query to get specific category list
9 0.57077312469482 Before getting category custom Before call to function getCategoryCustom
10 0.58691215515137 After getting category custom After call to function getCategoryCustom
11 0.58691692352295 Before getting category custom Before call to function getCategoryCustom
12 0.59810209274292 After getting category custom After call to function getCategoryCustom
13 0.59810709953308 Before getting category custom Before call to function getCategoryCustom
14 0.6049120426178 After getting category custom After call to function getCategoryCustom
15 0.60491704940796 Before getting category custom Before call to function getCategoryCustom
16 0.60977292060852 After getting category custom After call to function getCategoryCustom
17 0.60977792739868 Before getting category custom Before call to function getCategoryCustom
18 0.61482715606689 After getting category custom After call to function getCategoryCustom
19 0.61483097076416 Before getting category custom Before call to function getCategoryCustom
20 0.61946797370911 After getting category custom After call to function getCategoryCustom
21 0.61947202682495 End of GetCategoryList function End of the function
22 0.61948013305664 Get Category List for Group Before the call to getCategoryList function
23 0.61948299407959 Start of GetCategoryList function Start of the function
24 0.61948609352112 Before getting categories Query to get specific category list
25 0.62003302574158 End of getCategoryListByGroup Function Before return()
26 1.1664581298828 App Controller End End of the App controller (called before the controller of every page)
27 1.1671390533447 Product Start Start of the product info controller
28 1.168918132782 Cache file not found Starting get product details
29 1.1986410617828 Related products Start getting related products if enabled
30 1.1986429691315 Related Products Start Before the related products are found
31 1.1986439228058 Related Products Keywords Before the related product keywords are found
32 1.1986489295959 Create Keyword List Function Start of function
33 1.1987421512604 Create Keyword List Function After looping provided content - 15 keywords found
34 1.1993110179901 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
35 1.1993169784546 Create Keyword List Function After reducing keyword list
36 1.199343919754 Create Keyword List Function After selecting by scoring keywords
37 1.1993479728699 Create Keyword List Function After final loop of keywords
38 1.1993501186371 Related Products Keywords After the related product keywords are found
39 1.2350831031799 Related Products End After the related products are found
40 1.2638080120087 Product End End of the product info controller (Product Info)
41 1.2650940418243 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.2660040855408 Before Get Options Before the call to getOptions in the tpl class
43 1.324893951416 After Get Options After the call to getOptions in the tpl class
44 1.3250579833984 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.3250920772552 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.3362829685211 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3362879753113 Product Info: Before Template Display Before the template is displayed
48 1.3568570613861 Product Info: After Template Display After the template is displayed
49 1.3568699359894 Finalizing debug Before the debug is output to the page.
50 1.3568840026855 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.7993 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.0020751953125
SELECT parameter, value FROM parameters
2 0.0050 0.0050458908081055
SELECT * FROM `bad_bots`
3 0.0004 0.00043296813964844
SET time_zone = 'Europe/London'
4 0.0008 0.00081992149353027
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0012 0.001201868057251
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.118.207.183\";}'
6 0.0009 0.0009300708770752
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722055848'
7 0.0012 0.0011851787567139
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00062179565429688
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00091814994812012
SELECT id FROM pages WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio' LIMIT 1
10 0.0012 0.0011630058288574
SELECT id FROM products WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio' AND hidden = 0 LIMIT 1
11 0.0038 0.0038378238677979
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0362 0.03619384765625
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00045895576477051
SELECT * FROM pages WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio'
14 0.0005 0.00054001808166504
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00074982643127441
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0061 0.0061309337615967
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.0008 0.00082898139953613
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.0005 0.00052189826965332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00053095817565918
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.0058550834655762
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.0006 0.000579833984375
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.0006 0.00060486793518066
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.0005 0.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00045204162597656
SELECT * FROM categorygroups WHERE id = '1'
25 0.0034 0.0034470558166504
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.0005950927734375
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.00047683715820312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00048303604125977
SELECT id FROM categories WHERE parent_id = '27'
29 0.0039 0.0038521289825439
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.0006 0.00056314468383789
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.0006 0.00060510635375977
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.0005 0.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00047492980957031
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014300346374512
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.0005638599395752
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00040698051452637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.0004878044128418
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0016880035400391
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.0005490779876709
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.00059700012207031
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.00049209594726562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00041890144348145
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00060892105102539
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.00049400329589844
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00040912628173828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00041913986206055
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00071907043457031
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.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 (29)
				  AND p.disabled = 0 
49 0.0005 0.0005488395690918
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.00049018859863281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00046610832214355
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00061702728271484
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.0005 0.00048398971557617
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00044989585876465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00044894218444824
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00081801414489746
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.0005 0.00054097175598145
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.0006 0.00063085556030273
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.0005 0.00049400329589844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00042390823364258
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00058984756469727
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.0005 0.00045394897460938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00038886070251465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00040602684020996
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00066304206848145
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.0005 0.00054383277893066
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.0005 0.00053691864013672
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.0005 0.00052309036254883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043392181396484
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00053596496582031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0017 0.0017359256744385
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00061798095703125
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00058603286743164
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.0004 0.00042200088500977
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0011591911315918
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0021 0.00205397605896
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5361 0.53614616394043
SELECT * FROM ipgeocountries WHERE INET_ATON('18.118.207.183') >= INET_ATON(ip_start) AND INET_ATON('18.118.207.183') <= INET_ATON(ip_end)
78 0.0011 0.0011389255523682
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.0004730224609375
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.0006251335144043
SELECT * FROM products WHERE pagename = 'yogi-tea-rooibos-17-filtres-bio'
81 0.0004 0.00041413307189941
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3168
82 0.0006 0.00061392784118652
SELECT * FROM manufacturers WHERE id = '226'
83 0.0005 0.00053286552429199
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '226'
84 0.0005 0.00051212310791016
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '226' LIMIT 1
85 0.0007 0.00068998336791992
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '226' ORDER BY RAND() LIMIT 1
86 0.0004 0.00041913986206055
SELECT * FROM productimages WHERE product_id = '1023' ORDER BY sortorder ASC
87 0.0005 0.00047492980957031
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '226'
88 0.0004 0.00044608116149902
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '226'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00031900405883789
SELECT * FROM manufacturerimages WHERE manufacturer_id = '226'
90 0.0005 0.00045895576477051
SELECT category_id FROM products_categories WHERE product_id = '3168'
91 0.0005 0.00049114227294922
SELECT * FROM categories WHERE id = '27'
92 0.0037 0.0036590099334717
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.0005 0.00052094459533691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00032711029052734
SELECT id FROM categories WHERE parent_id = '27'
95 0.0038 0.0037620067596436
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.0006 0.00060796737670898
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.00063610076904297
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.00049114227294922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00050115585327148
SELECT * FROM productimages WHERE product_id = '3168' ORDER BY sortorder ASC
100 0.0006 0.00063800811767578
SELECT * FROM product_image_select WHERE product_id = '3168'
101 0.0006 0.00056910514831543
SELECT * FROM productcustomimages WHERE product_id = '3168'
102 0.0004 0.00042581558227539
SELECT * FROM productfeeds WHERE product_id = '3168' ORDER BY item_date DESC
103 0.0008 0.00079798698425293
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0007 0.00071001052856445
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3168' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00044608116149902
SELECT * FROM tags WHERE id = '58'
106 0.0020 0.0020458698272705
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0017 0.0016791820526123
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0017 0.0016720294952393
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0007 0.0006871223449707
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
110 0.0006 0.00055098533630371
SELECT * FROM productamazoncontent WHERE product_id = '3168'
111 0.0008 0.00080108642578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
112 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00036907196044922
SELECT * FROM productoffers
                WHERE product_id = '3168' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = 3168
                ORDER BY price ASC LIMIT 1
115 0.0004 0.00036215782165527
SELECT value FROM productattributes
                WHERE product_id = '3168'
                AND name = 'ListPriceAmount'
116 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '3168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0005 0.00050783157348633
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
118 0.0097 0.0096580982208252
SELECT *, MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AND 3168 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0008 0.00079512596130371
SELECT *, MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AND 3168 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0007 0.00067901611328125
SELECT *, MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos 17 filtres' IN BOOLEAN MODE) AND 3168 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0006 0.00060296058654785
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
122 0.0006 0.00060105323791504
SELECT * FROM product_image_select WHERE product_id = '858'
123 0.0005 0.00045108795166016
SELECT * FROM productcustomimages WHERE product_id = '858'
124 0.0011 0.0011110305786133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
125 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00046491622924805
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0005 0.00048589706420898
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
129 0.0006 0.00060200691223145
SELECT * FROM product_image_select WHERE product_id = '865'
130 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '865'
131 0.0008 0.0007789134979248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
132 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00041913986206055
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
136 0.0006 0.00055885314941406
SELECT * FROM product_image_select WHERE product_id = '878'
137 0.0004 0.00043082237243652
SELECT * FROM productcustomimages WHERE product_id = '878'
138 0.0010 0.0010170936584473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
139 0.0005 0.00054192543029785
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00047492980957031
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0006 0.00056695938110352
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
143 0.0006 0.00057888031005859
SELECT * FROM product_image_select WHERE product_id = '862'
144 0.0004 0.00039386749267578
SELECT * FROM productcustomimages WHERE product_id = '862'
145 0.0009 0.0009009838104248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
146 0.0005 0.00049805641174316
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0005 0.00051999092102051
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0005 0.00049781799316406
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
150 0.0006 0.0005791187286377
SELECT * FROM product_image_select WHERE product_id = '890'
151 0.0004 0.00040912628173828
SELECT * FROM productcustomimages WHERE product_id = '890'
152 0.0010 0.001021146774292
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
153 0.0005 0.00049185752868652
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00043201446533203
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00057220458984375
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
157 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '869'
158 0.0004 0.00041604042053223
SELECT * FROM productcustomimages WHERE product_id = '869'
159 0.0009 0.00088810920715332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
160 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0005 0.00047779083251953
SELECT id,asin FROM products WHERE parent_id = 3168
164 0.0005 0.00049400329589844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3168' ORDER BY timestamp DESC
165 0.0005 0.00047492980957031
SELECT category_id FROM products_categories WHERE product_id = '3168'
166 0.0005 0.00049400329589844
SELECT * FROM categories WHERE id = '27'
167 0.0035 0.0034980773925781
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
168 0.0005 0.00045585632324219
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0003 0.00031900405883789
SELECT id FROM categories WHERE parent_id = '27'
170 0.0035 0.003464937210083
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 
171 0.0006 0.00057196617126465
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 
172 0.0006 0.00057697296142578
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
173 0.0005 0.0005030632019043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0008 0.00083208084106445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
175 0.0005 0.0005030632019043
SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '3168' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00035381317138672
SELECT * FROM productoffers
                WHERE product_id = 3168
                ORDER BY price ASC LIMIT 1
178 0.0005 0.00049591064453125
SELECT value FROM productattributes
                WHERE product_id = '3168'
                AND name = 'ListPriceAmount'
179 0.0006 0.00058794021606445
SELECT * FROM products WHERE id = '3168'
180 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '3168' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0006 0.0006258487701416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3168' AND a.name = n.originalname
182 0.0004 0.00038599967956543
SELECT * FROM productoffers WHERE product_id = '3168' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '3168' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00037884712219238
SELECT * FROM productoffers
                WHERE product_id = 3168
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00039792060852051
SELECT value FROM productattributes
                WHERE product_id = '3168'
                AND name = 'ListPriceAmount'
186 0.0005 0.00048303604125977
SELECT category_id FROM products_categories WHERE product_id = '3168' AND prod_type = 'amz'
187 0.0005 0.00052809715270996
SELECT parent_id FROM categories WHERE id = '27'
188 0.0004 0.00037407875061035
SELECT * FROM categories WHERE id = '27'
189 0.0036 0.0035769939422607
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
190 0.0005 0.00047183036804199
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0004 0.00035405158996582
SELECT id FROM categories WHERE parent_id = '27'
192 0.0036 0.0035979747772217
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 
193 0.0005 0.00053501129150391
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 
194 0.0006 0.00060296058654785
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
195 0.0005 0.00046801567077637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0007 0.00066804885864258
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0005 0.00046491622924805
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.00035190582275391
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0147 0.014724969863892
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
200 0.0007 0.0007328987121582
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
201 0.0006 0.00060105323791504
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
202 0.0006 0.00058579444885254
SELECT * FROM products WHERE id = 1626
203 0.0006 0.00057888031005859
SELECT * FROM products WHERE id = 4041
204 0.0006 0.00057291984558105
SELECT * FROM products WHERE id = 4312
205 0.0005 0.00054097175598145
SELECT * FROM products WHERE id = 777
206 0.0006 0.0005640983581543
SELECT * FROM products WHERE id = 3881
207 0.0005 0.00054812431335449
SELECT * FROM products WHERE id = 4213
208 0.0006 0.00057816505432129
SELECT * FROM products WHERE id = '1626'
209 0.0005 0.00053596496582031
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0006 0.00059294700622559
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0004 0.00040197372436523
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0008 0.00084114074707031
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00043201446533203
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0006 0.00058794021606445
SELECT * FROM products WHERE id = '4041'
217 0.0005 0.00046610832214355
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0006 0.00058388710021973
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0004 0.00038409233093262
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0011 0.0011301040649414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0005 0.00050806999206543
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.00046610832214355
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.0005028247833252
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0010 0.00098013877868652
SELECT * FROM products WHERE id = '4312'
225 0.0006 0.0005500316619873
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0005 0.00047016143798828
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0012 0.0011940002441406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0004 0.00041818618774414
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0006 0.00062203407287598
SELECT * FROM products WHERE id = '777'
233 0.0005 0.0005190372467041
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0006 0.00060796737670898
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0004 0.00040698051452637
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0010 0.0010459423065186
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0005 0.00053691864013672
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0007 0.00065112113952637
SELECT * FROM products WHERE id = '3881'
241 0.0008 0.00075387954711914
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0007 0.00066089630126953
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0004 0.00041794776916504
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0014 0.0013530254364014
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0006 0.00055885314941406
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0005 0.00047588348388672
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0006 0.00061297416687012
SELECT * FROM products WHERE id = '4213'
249 0.0010 0.00095105171203613
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0007 0.00067400932312012
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0005 0.00045895576477051
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0016 0.0016281604766846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0006 0.00062108039855957
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0006 0.0005638599395752
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0006 0.00061702728271484
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0011 0.0010948181152344
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0009 0.0009150505065918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0020 0.0019550323486328
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0010 0.0010449886322021
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0009 0.00085902214050293
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0008 0.00080299377441406
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'