0

Thé "Tomatino" - Rooibos bio, tomate, carotte

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-23 13:59:57 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.

Product Features

Rooibos bio d Afrique du Sud, naturellement sans caféine avec tomate et carotte Récompensé 1er Prix ** Great Taste 2014 à Londres. Boite de 20 sachets

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.7976219654083 261 1.0739 0


No Amazon API Requests Made.


App Debug - Total Time 1.7976219654083 seconds

Number Time From Start Name Description
1 0.60549712181091 Initialise Initialise FSB Function
2 0.6162269115448 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65227913856506 Start of getCategoryListByGroup Function Before first category groups query
4 0.65282106399536 After initial query Before first category groups query
5 0.65282511711121 Get Category List for Group Before the call to getCategoryList function
6 0.65283012390137 Start of GetCategoryList function Start of the function
7 0.65283393859863 Before getting categories Query to get specific category list
8 0.65349102020264 After getting categories Query to get specific category list
9 0.65349411964417 Before getting category custom Before call to function getCategoryCustom
10 0.66989612579346 After getting category custom After call to function getCategoryCustom
11 0.66990208625793 Before getting category custom Before call to function getCategoryCustom
12 0.69748306274414 After getting category custom After call to function getCategoryCustom
13 0.69748711585999 Before getting category custom Before call to function getCategoryCustom
14 0.70549702644348 After getting category custom After call to function getCategoryCustom
15 0.70550298690796 Before getting category custom Before call to function getCategoryCustom
16 0.7199969291687 After getting category custom After call to function getCategoryCustom
17 0.72000312805176 Before getting category custom Before call to function getCategoryCustom
18 0.72569513320923 After getting category custom After call to function getCategoryCustom
19 0.72570109367371 Before getting category custom Before call to function getCategoryCustom
20 0.73193311691284 After getting category custom After call to function getCategoryCustom
21 0.73193907737732 End of GetCategoryList function End of the function
22 0.73195004463196 Get Category List for Group Before the call to getCategoryList function
23 0.7319540977478 Start of GetCategoryList function Start of the function
24 0.73195791244507 Before getting categories Query to get specific category list
25 0.73255300521851 End of getCategoryListByGroup Function Before return()
26 1.3552329540253 App Controller End End of the App controller (called before the controller of every page)
27 1.3561780452728 Product Start Start of the product info controller
28 1.3680379390717 Cache file not found Starting get product details
29 1.4390621185303 Related products Start getting related products if enabled
30 1.4390649795532 Related Products Start Before the related products are found
31 1.4390680789948 Related Products Keywords Before the related product keywords are found
32 1.4390749931335 Create Keyword List Function Start of function
33 1.4391150474548 Create Keyword List Function After looping provided content - 15 keywords found
34 1.4400949478149 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.4401049613953 Create Keyword List Function After reducing keyword list
36 1.4401459693909 Create Keyword List Function After selecting by scoring keywords
37 1.4401531219482 Create Keyword List Function After final loop of keywords
38 1.4401559829712 Related Products Keywords After the related product keywords are found
39 1.5084199905396 Related Products End After the related products are found
40 1.5852489471436 Product End End of the product info controller (Product Info)
41 1.5890760421753 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.5919930934906 Before Get Options Before the call to getOptions in the tpl class
43 1.6905870437622 After Get Options After the call to getOptions in the tpl class
44 1.6907749176025 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.69082903862 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.7127330303192 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.7127430438995 Product Info: Before Template Display Before the template is displayed
48 1.7975680828094 Product Info: After Template Display After the template is displayed
49 1.7975950241089 Finalizing debug Before the debug is output to the page.
50 1.7976191043854 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 1.0739 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0017 0.0016679763793945
SELECT parameter, value FROM parameters
2 0.0054 0.0054261684417725
SELECT * FROM `bad_bots`
3 0.0005 0.00045204162597656
SET time_zone = 'Europe/London'
4 0.0007 0.00074410438537598
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0007 0.00073695182800293
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"98.82.120.188\";}'
6 0.0005 0.00051593780517578
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1725938104'
7 0.0080 0.0080480575561523
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0015 0.001507043838501
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0061 0.0061171054840088
SELECT id FROM pages WHERE pagename = 'the-tomatino-rooibos-bio-tomate-carotte' LIMIT 1
10 0.0020 0.0020341873168945
SELECT id FROM products WHERE pagename = 'the-tomatino-rooibos-bio-tomate-carotte' AND hidden = 0 LIMIT 1
11 0.0074 0.0074310302734375
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0274 0.027370929718018
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00046706199645996
SELECT * FROM pages WHERE pagename = 'the-tomatino-rooibos-bio-tomate-carotte'
14 0.0005 0.00052404403686523
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.0006260871887207
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0056 0.0056281089782715
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.0009 0.00087809562683105
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.0004 0.00042986869812012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00049400329589844
SELECT id FROM categories WHERE parent_id = '26'
20 0.0061 0.0061378479003906
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.00057506561279297
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.0005 0.00054693222045898
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.00047397613525391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0010 0.0010330677032471
SELECT * FROM categorygroups WHERE id = '1'
25 0.0072 0.0072059631347656
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.0119 0.011940956115723
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.0006 0.00060796737670898
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00049495697021484
SELECT id FROM categories WHERE parent_id = '27'
29 0.0047 0.0047390460968018
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.0007 0.00068497657775879
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.00064921379089355
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.0006 0.00056695938110352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00047802925109863
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.001896858215332
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.00055694580078125
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.00043702125549316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.0004730224609375
SELECT id FROM categories WHERE parent_id = '28'
38 0.0021 0.0021300315856934
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.0008 0.00082206726074219
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.00057816505432129
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.00049686431884766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00042390823364258
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00087904930114746
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.0012 0.001209020614624
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.00041699409484863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0050 0.0050399303436279
SELECT id FROM categories WHERE parent_id = '29'
47 0.0016 0.0016379356384277
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.0008 0.00084209442138672
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.0009 0.0009458065032959
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.0028 0.0027909278869629
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00051307678222656
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00075387954711914
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.0006 0.0005650520324707
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.00045609474182129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00049614906311035
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00087809562683105
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.0006 0.0006110668182373
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.00071501731872559
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.00054192543029785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00048017501831055
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00061798095703125
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.0007 0.00068211555480957
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.0005 0.00045609474182129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.00059080123901367
SELECT id FROM categories WHERE parent_id = '31'
65 0.0013 0.0012979507446289
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.0006 0.00063514709472656
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.0007 0.00071096420288086
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.0006 0.00056910514831543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00048494338989258
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00057506561279297
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0019 0.0019378662109375
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0011 0.0010888576507568
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00072598457336426
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.0005 0.00050497055053711
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0016 0.0015659332275391
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0016 0.0015511512756348
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.6080 0.60796785354614
SELECT * FROM ipgeocountries WHERE INET_ATON('98.82.120.188') >= INET_ATON(ip_start) AND INET_ATON('98.82.120.188') <= INET_ATON(ip_end)
78 0.0028 0.002810001373291
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0017 0.0016660690307617
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.0007789134979248
SELECT * FROM products WHERE pagename = 'the-tomatino-rooibos-bio-tomate-carotte'
81 0.0005 0.00047397613525391
UPDATE products SET viewcount = viewcount + 1 WHERE id = 947
82 0.0008 0.00076484680175781
SELECT * FROM manufacturers WHERE id = '253'
83 0.0006 0.00056815147399902
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '253'
84 0.0019 0.001945972442627
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '253' LIMIT 1
85 0.0027 0.0026919841766357
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '253' ORDER BY RAND() LIMIT 1
86 0.0006 0.0005638599395752
SELECT * FROM productimages WHERE product_id = '1062' ORDER BY sortorder ASC
87 0.0005 0.00049686431884766
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '253'
88 0.0005 0.00053906440734863
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '253'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0005 0.00049304962158203
SELECT * FROM manufacturerimages WHERE manufacturer_id = '253'
90 0.0005 0.00050878524780273
SELECT category_id FROM products_categories WHERE product_id = '947'
91 0.0006 0.00062298774719238
SELECT * FROM categories WHERE id = '27'
92 0.0044 0.0043559074401855
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.00051212310791016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '27'
95 0.0040 0.0040469169616699
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.00064802169799805
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.0010 0.0010480880737305
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.0006 0.00055122375488281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0010 0.00096797943115234
SELECT * FROM productimages WHERE product_id = '947' ORDER BY sortorder ASC
100 0.0026 0.002636194229126
SELECT * FROM product_image_select WHERE product_id = '947'
101 0.0017 0.0016520023345947
SELECT * FROM productcustomimages WHERE product_id = '947'
102 0.0017 0.0016920566558838
SELECT * FROM productfeeds WHERE product_id = '947' ORDER BY item_date DESC
103 0.0041 0.0041389465332031
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '947' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0046 0.0045759677886963
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '947' AND t.hidden = 0 AND display_product = 1
105 0.0017 0.0017352104187012
SELECT * FROM tags WHERE id = '117'
106 0.0018 0.0017540454864502
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '117'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0033 0.0033259391784668
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '117'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0017 0.0017421245574951
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '117' 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.00066494941711426
SELECT * FROM productimages WHERE product_id = '1917' ORDER BY sortorder ASC
110 0.0035 0.0034999847412109
SELECT * FROM productamazoncontent WHERE product_id = '947'
111 0.0035 0.0034999847412109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '947' AND a.name = n.originalname
112 0.0105 0.010456085205078
SELECT * FROM productoffers WHERE product_id = '947' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0027 0.002662181854248
SELECT * FROM productoffers
                WHERE product_id = '947' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0011 0.0010569095611572
SELECT * FROM productoffers
                WHERE product_id = 947
                ORDER BY price ASC LIMIT 1
115 0.0008 0.00081086158752441
SELECT value FROM productattributes
                WHERE product_id = '947'
                AND name = 'ListPriceAmount'
116 0.0011 0.0011179447174072
SELECT value FROM productattributes WHERE product_id = '947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0009 0.00089192390441895
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.0164 0.016397953033447
SELECT *, MATCH (description, title) AGAINST ('thé andquottomatinoandquot rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé andquottomatinoandquot rooibos' IN BOOLEAN MODE) AND 947 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0011 0.0011181831359863
SELECT *, MATCH (description, title) AGAINST ('thé andquottomatinoandquot rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé andquottomatinoandquot rooibos' IN BOOLEAN MODE) AND 947 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0008 0.00084996223449707
SELECT *, MATCH (description, title) AGAINST ('thé andquottomatinoandquot rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé andquottomatinoandquot rooibos' IN BOOLEAN MODE) AND 947 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0009 0.00090909004211426
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
122 0.0010 0.00095486640930176
SELECT * FROM product_image_select WHERE product_id = '862'
123 0.0006 0.00056195259094238
SELECT * FROM productcustomimages WHERE product_id = '862'
124 0.0015 0.0015490055084229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
125 0.0012 0.0012259483337402
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0006 0.00062203407287598
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0007 0.00071406364440918
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0007 0.00067806243896484
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
129 0.0008 0.00075411796569824
SELECT * FROM product_image_select WHERE product_id = '878'
130 0.0006 0.00055789947509766
SELECT * FROM productcustomimages WHERE product_id = '878'
131 0.0016 0.0016458034515381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
132 0.0007 0.00069403648376465
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0006 0.00057196617126465
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0006 0.00055193901062012
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0008 0.00075578689575195
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
136 0.0012 0.0011739730834961
SELECT * FROM product_image_select WHERE product_id = '890'
137 0.0006 0.00058102607727051
SELECT * FROM productcustomimages WHERE product_id = '890'
138 0.0017 0.0016679763793945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
139 0.0009 0.00086498260498047
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0006 0.0005791187286377
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0009 0.0008549690246582
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0008 0.00075292587280273
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
143 0.0009 0.00092601776123047
SELECT * FROM product_image_select WHERE product_id = '869'
144 0.0006 0.00056099891662598
SELECT * FROM productcustomimages WHERE product_id = '869'
145 0.0011 0.0011470317840576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
146 0.0007 0.00072193145751953
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0007 0.00066018104553223
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0011 0.0010831356048584
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0045 0.0044639110565186
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
150 0.0012 0.0011720657348633
SELECT * FROM product_image_select WHERE product_id = '858'
151 0.0015 0.0014779567718506
SELECT * FROM productcustomimages WHERE product_id = '858'
152 0.0016 0.0016269683837891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
153 0.0011 0.001093864440918
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0006 0.00060200691223145
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0006 0.00062799453735352
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0007 0.00072503089904785
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
157 0.0018 0.0018019676208496
SELECT * FROM product_image_select WHERE product_id = '865'
158 0.0008 0.00076699256896973
SELECT * FROM productcustomimages WHERE product_id = '865'
159 0.0011 0.0011348724365234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
160 0.0022 0.0021529197692871
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0006 0.00064611434936523
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0046 0.0046272277832031
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0009 0.00091409683227539
SELECT id,asin FROM products WHERE parent_id = 947
164 0.0081 0.0080850124359131
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '947' ORDER BY timestamp DESC
165 0.0019 0.0019400119781494
SELECT category_id FROM products_categories WHERE product_id = '947'
166 0.0010 0.00098299980163574
SELECT * FROM categories WHERE id = '27'
167 0.0067 0.0066549777984619
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.0009 0.00093817710876465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0006 0.0005950927734375
SELECT id FROM categories WHERE parent_id = '27'
170 0.0101 0.01006293296814
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.0020 0.002018928527832
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.0022 0.0022308826446533
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.0018 0.0017900466918945
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0025 0.002457857131958
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '947' AND a.name = n.originalname
175 0.0016 0.0015561580657959
SELECT * FROM productoffers WHERE product_id = '947' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0015 0.0015361309051514
SELECT * FROM productoffers
                WHERE product_id = '947' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0010 0.0010190010070801
SELECT * FROM productoffers
                WHERE product_id = 947
                ORDER BY price ASC LIMIT 1
178 0.0016 0.0015578269958496
SELECT value FROM productattributes
                WHERE product_id = '947'
                AND name = 'ListPriceAmount'
179 0.0023 0.0023448467254639
SELECT * FROM products WHERE id = '947'
180 0.0010 0.00095605850219727
SELECT value FROM productattributes WHERE product_id = '947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0027 0.0027120113372803
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '947' AND a.name = n.originalname
182 0.0011 0.0010528564453125
SELECT * FROM productoffers WHERE product_id = '947' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0012 0.0011751651763916
SELECT * FROM productoffers
                WHERE product_id = '947' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0006 0.00063705444335938
SELECT * FROM productoffers
                WHERE product_id = 947
                ORDER BY price ASC LIMIT 1
185 0.0007 0.00073695182800293
SELECT value FROM productattributes
                WHERE product_id = '947'
                AND name = 'ListPriceAmount'
186 0.0010 0.00095391273498535
SELECT category_id FROM products_categories WHERE product_id = '947' AND prod_type = 'amz'
187 0.0008 0.00078511238098145
SELECT parent_id FROM categories WHERE id = '27'
188 0.0008 0.00078296661376953
SELECT * FROM categories WHERE id = '27'
189 0.0075 0.0075440406799316
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.0009 0.00090193748474121
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0008 0.00080394744873047
SELECT id FROM categories WHERE parent_id = '27'
192 0.0072 0.0071640014648438
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.0010 0.0010371208190918
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.0010 0.00098609924316406
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.0007 0.00066614151000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0030 0.0029609203338623
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0023 0.0023398399353027
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.0004429817199707
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0223 0.02229118347168
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.0072 0.0072338581085205
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.0011 0.0011248588562012
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.0007 0.00072813034057617
SELECT * FROM products WHERE id = 1626
203 0.0006 0.0006258487701416
SELECT * FROM products WHERE id = 4041
204 0.0012 0.0011940002441406
SELECT * FROM products WHERE id = 4312
205 0.0006 0.00062394142150879
SELECT * FROM products WHERE id = 777
206 0.0006 0.00056791305541992
SELECT * FROM products WHERE id = 3881
207 0.0027 0.002730131149292
SELECT * FROM products WHERE id = 4213
208 0.0006 0.00057005882263184
SELECT * FROM products WHERE id = '1626'
209 0.0011 0.0010631084442139
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0008 0.00082707405090332
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0010 0.00096988677978516
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0013 0.0012800693511963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0008 0.00078797340393066
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0006 0.00058603286743164
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0008 0.00081086158752441
SELECT * FROM products WHERE id = '4041'
217 0.0009 0.00086712837219238
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0013 0.0013320446014404
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0006 0.00064396858215332
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0023 0.0022790431976318
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0008 0.00078892707824707
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0006 0.00058317184448242
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0006 0.00057697296142578
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0013 0.001288890838623
SELECT * FROM products WHERE id = '4312'
225 0.0006 0.00064206123352051
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0008 0.00078916549682617
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0007 0.00068187713623047
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0018 0.001755952835083
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0015 0.0014679431915283
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0005 0.00053095817565918
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.0004889965057373
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0007 0.00072693824768066
SELECT * FROM products WHERE id = '777'
233 0.0005 0.0005190372467041
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0008 0.00077199935913086
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0005 0.00049686431884766
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0024 0.0024101734161377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0008 0.00079894065856934
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0006 0.00057888031005859
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0005 0.0005028247833252
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0011 0.0010700225830078
SELECT * FROM products WHERE id = '3881'
241 0.0008 0.00084495544433594
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0008 0.00075197219848633
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0005 0.00053501129150391
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0016 0.0016288757324219
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.00064492225646973
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0016 0.0015690326690674
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0006 0.00057101249694824
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0007 0.00072097778320312
SELECT * FROM products WHERE id = '4213'
249 0.0008 0.00084996223449707
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0007 0.00071215629577637
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0016 0.0016419887542725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0011 0.0011420249938965
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0005 0.00052094459533691
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0007 0.00065898895263672
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0029 0.0029489994049072
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0013 0.001323938369751
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0051 0.0050849914550781
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0029 0.0028610229492188
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0012 0.001227855682373
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0010 0.0010390281677246
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'