0

Thés de la Pagode rooibos Vanille Amande Edition prestige 100gr

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

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

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5266859531403 256 1.1234 0


No Amazon API Requests Made.


App Debug - Total Time 1.5266859531403 seconds

Number Time From Start Name Description
1 0.37183904647827 Initialise Initialise FSB Function
2 0.37848901748657 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40823316574097 Start of getCategoryListByGroup Function Before first category groups query
4 0.41000413894653 After initial query Before first category groups query
5 0.41000604629517 Get Category List for Group Before the call to getCategoryList function
6 0.4100079536438 Start of GetCategoryList function Start of the function
7 0.41001009941101 Before getting categories Query to get specific category list
8 0.41180300712585 After getting categories Query to get specific category list
9 0.41180396080017 Before getting category custom Before call to function getCategoryCustom
10 0.43924808502197 After getting category custom After call to function getCategoryCustom
11 0.43925213813782 Before getting category custom Before call to function getCategoryCustom
12 0.45422601699829 After getting category custom After call to function getCategoryCustom
13 0.45423007011414 Before getting category custom Before call to function getCategoryCustom
14 0.46286296844482 After getting category custom After call to function getCategoryCustom
15 0.46286511421204 Before getting category custom Before call to function getCategoryCustom
16 0.4678909778595 After getting category custom After call to function getCategoryCustom
17 0.4678909778595 Before getting category custom Before call to function getCategoryCustom
18 0.47231316566467 After getting category custom After call to function getCategoryCustom
19 0.47231316566467 Before getting category custom Before call to function getCategoryCustom
20 0.47734904289246 After getting category custom After call to function getCategoryCustom
21 0.47735118865967 End of GetCategoryList function End of the function
22 0.47735810279846 Get Category List for Group Before the call to getCategoryList function
23 0.47736001014709 Start of GetCategoryList function Start of the function
24 0.47736096382141 Before getting categories Query to get specific category list
25 0.47850108146667 End of getCategoryListByGroup Function Before return()
26 1.1969130039215 App Controller End End of the App controller (called before the controller of every page)
27 1.1974120140076 Product Start Start of the product info controller
28 1.2240569591522 Cache file not found Starting get product details
29 1.2970590591431 Related products Start getting related products if enabled
30 1.2970600128174 Related Products Start Before the related products are found
31 1.2970609664917 Related Products Keywords Before the related product keywords are found
32 1.2970640659332 Create Keyword List Function Start of function
33 1.2970850467682 Create Keyword List Function After looping provided content - 27 keywords found
34 1.2975420951843 Create Keyword List Function After looping initial keyword list - 25 keywords remaining
35 1.2975480556488 Create Keyword List Function After reducing keyword list
36 1.2975840568542 Create Keyword List Function After selecting by scoring keywords
37 1.2975859642029 Create Keyword List Function After final loop of keywords
38 1.2975871562958 Related Products Keywords After the related product keywords are found
39 1.3359479904175 Related Products End After the related products are found
40 1.3865160942078 Product End End of the product info controller (Product Info)
41 1.3909749984741 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3931159973145 Before Get Options Before the call to getOptions in the tpl class
43 1.5026321411133 After Get Options After the call to getOptions in the tpl class
44 1.5027160644531 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5027379989624 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5111770629883 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5111801624298 Product Info: Before Template Display Before the template is displayed
48 1.5266690254211 Product Info: After Template Display After the template is displayed
49 1.5266771316528 Finalizing debug Before the debug is output to the page.
50 1.5266849994659 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 1.1234 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.0012400150299072
SELECT parameter, value FROM parameters
2 0.0082 0.008188009262085
SELECT * FROM `bad_bots`
3 0.0005 0.00046396255493164
SET time_zone = 'Europe/London'
4 0.0027 0.002734899520874
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0032 0.0032370090484619
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.80\";}'
6 0.0030 0.0029950141906738
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1742306873'
7 0.0045 0.0044870376586914
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0017 0.0017440319061279
UPDATE autorun SET lastrun = '2025-03-18 14:07:53' WHERE id = '16'
9 0.0008 0.00081110000610352
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0025 0.0025339126586914
SELECT id FROM pages WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr' LIMIT 1
11 0.0026 0.0026450157165527
SELECT id FROM products WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr' AND hidden = 0 LIMIT 1
12 0.0031 0.0030529499053955
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0257 0.02566385269165
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00072693824768066
SELECT * FROM pages WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr'
15 0.0018 0.0017609596252441
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0018 0.0017769336700439
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0076 0.0076069831848145
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
18 0.0023 0.0022861957550049
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0016 0.0015528202056885
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.0005040168762207
SELECT id FROM categories WHERE parent_id = '26'
21 0.0071 0.0071310997009277
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 
22 0.0027 0.0026860237121582
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 
23 0.0026 0.0026051998138428
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
24 0.0024 0.0023889541625977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00055217742919922
SELECT * FROM categorygroups WHERE id = '1'
26 0.0048 0.0047640800476074
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
27 0.0007 0.00065803527832031
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00045394897460938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00054407119750977
SELECT id FROM categories WHERE parent_id = '27'
30 0.0057 0.0057179927825928
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 
31 0.0007 0.00071096420288086
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 
32 0.0007 0.00074410438537598
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
33 0.0007 0.00069904327392578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0006 0.00058984756469727
SELECT * FROM categorygroups WHERE id = '1'
35 0.0024 0.0023939609527588
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
36 0.0006 0.00064516067504883
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0005 0.00047993659973145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00053501129150391
SELECT id FROM categories WHERE parent_id = '28'
39 0.0018 0.0018289089202881
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 
40 0.0006 0.00055098533630371
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 
41 0.0009 0.00085783004760742
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
42 0.0008 0.00080108642578125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.0004889965057373
SELECT * FROM categorygroups WHERE id = '1'
44 0.0009 0.0009009838104248
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
45 0.0005 0.00049781799316406
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00048279762268066
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00078392028808594
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 
49 0.0005 0.00047421455383301
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 
50 0.0005 0.0004880428314209
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
51 0.0005 0.0005190372467041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00038695335388184
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00055885314941406
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
54 0.0004 0.00044894218444824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00038313865661621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.0004279613494873
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00069499015808105
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 
58 0.0005 0.00045299530029297
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 
59 0.0005 0.00045394897460938
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
60 0.0005 0.00053811073303223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.0004420280456543
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00067400932312012
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
63 0.0005 0.00054192543029785
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0005 0.00046014785766602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.0004420280456543
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00071811676025391
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 
67 0.0006 0.00059008598327637
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 
68 0.0006 0.00060606002807617
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
69 0.0005 0.00052309036254883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.0004119873046875
SELECT * FROM categorygroups WHERE id = '1'
71 0.0011 0.0011320114135742
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0091 0.0091328620910645
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0047 0.0047299861907959
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0011 0.0010998249053955
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
75 0.0022 0.0021729469299316
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0022 0.0021710395812988
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0016 0.0015699863433838
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.6916 0.69161200523376
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.80') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.80') <= INET_ATON(ip_end)
79 0.0027 0.0027139186859131
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.0013861656188965
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00075602531433105
SELECT * FROM products WHERE pagename = 'thes-de-la-pagode-rooibos-vanille-amande-edition-prestige-100gr'
82 0.0005 0.00045180320739746
UPDATE products SET viewcount = viewcount + 1 WHERE id = 998
83 0.0010 0.0010201930999756
SELECT * FROM manufacturers WHERE id = '258'
84 0.0007 0.00070810317993164
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '258'
85 0.0027 0.0026521682739258
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '258' LIMIT 1
86 0.0037 0.0037081241607666
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '258' ORDER BY RAND() LIMIT 1
87 0.0009 0.00092411041259766
SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
88 0.0011 0.001060962677002
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '258'
89 0.0009 0.0008690357208252
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '258'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0008 0.00076889991760254
SELECT * FROM manufacturerimages WHERE manufacturer_id = '258'
91 0.0008 0.00083708763122559
SELECT category_id FROM products_categories WHERE product_id = '998'
92 0.0015 0.0015430450439453
SELECT * FROM categories WHERE id = '27'
93 0.0119 0.011925935745239
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
94 0.0011 0.0010581016540527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0005 0.00046610832214355
SELECT id FROM categories WHERE parent_id = '27'
96 0.0073 0.007296085357666
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 
97 0.0008 0.00078988075256348
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 
98 0.0009 0.00089311599731445
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
99 0.0007 0.00069189071655273
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0008 0.00079107284545898
SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
101 0.0022 0.0022258758544922
SELECT * FROM product_image_select WHERE product_id = '998'
102 0.0019 0.0019218921661377
SELECT * FROM productcustomimages WHERE product_id = '998'
103 0.0015 0.0014879703521729
SELECT * FROM productfeeds WHERE product_id = '998' ORDER BY item_date DESC
104 0.0062 0.0061759948730469
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0057 0.0056679248809814
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '998' AND t.hidden = 0 AND display_product = 1
106 0.0005 0.00052690505981445
SELECT * FROM tags WHERE id = '1'
107 0.0032 0.0031790733337402
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0031 0.0030639171600342
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0027 0.0026588439941406
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110 0.0008 0.00076889991760254
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
111 0.0019 0.0018811225891113
SELECT * FROM productamazoncontent WHERE product_id = '998'
112 0.0014 0.0014398097991943
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
113 0.0018 0.001823902130127
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0005 0.00047588348388672
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0006 0.00061488151550293
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0006 0.00058197975158691
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
117 0.0122 0.012194871902466
SELECT *, MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AND 998 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
118 0.0006 0.00058913230895996
SELECT *, MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AND 998 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0005 0.00050902366638184
SELECT *, MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('pagode rooibos vanille' IN BOOLEAN MODE) AND 998 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0006 0.00062894821166992
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
121 0.0006 0.00058817863464355
SELECT * FROM product_image_select WHERE product_id = '862'
122 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '862'
123 0.0009 0.00092601776123047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
124 0.0004 0.00042581558227539
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
128 0.0006 0.00057888031005859
SELECT * FROM product_image_select WHERE product_id = '890'
129 0.0004 0.00043892860412598
SELECT * FROM productcustomimages WHERE product_id = '890'
130 0.0010 0.00096392631530762
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
131 0.0005 0.00045895576477051
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0005 0.00046014785766602
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0005 0.00051093101501465
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
135 0.0006 0.00055909156799316
SELECT * FROM product_image_select WHERE product_id = '858'
136 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '858'
137 0.0010 0.0010411739349365
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
138 0.0005 0.00049519538879395
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0004 0.00044107437133789
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
142 0.0006 0.0006101131439209
SELECT * FROM product_image_select WHERE product_id = '878'
143 0.0004 0.00043106079101562
SELECT * FROM productcustomimages WHERE product_id = '878'
144 0.0012 0.0011789798736572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
145 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0004 0.00040411949157715
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0005 0.00052404403686523
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
149 0.0007 0.00069594383239746
SELECT * FROM product_image_select WHERE product_id = '4814'
150 0.0005 0.00047898292541504
SELECT * FROM productcustomimages WHERE product_id = '4814'
151 0.0015 0.0014770030975342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
152 0.0007 0.00071096420288086
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0005 0.0005030632019043
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
156 0.0007 0.00070500373840332
SELECT * FROM product_image_select WHERE product_id = '865'
157 0.0004 0.00043392181396484
SELECT * FROM productcustomimages WHERE product_id = '865'
158 0.0009 0.00088787078857422
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
159 0.0005 0.00053501129150391
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0005 0.00053906440734863
SELECT id,asin FROM products WHERE parent_id = 998
163 0.0019 0.0019001960754395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '998' ORDER BY timestamp DESC
164 0.0005 0.00050187110900879
SELECT category_id FROM products_categories WHERE product_id = '998'
165 0.0005 0.00051999092102051
SELECT * FROM categories WHERE id = '27'
166 0.0053 0.0053210258483887
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
167 0.0005 0.00051712989807129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0005 0.00047206878662109
SELECT id FROM categories WHERE parent_id = '27'
169 0.0059 0.0058529376983643
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 
170 0.0007 0.00072097778320312
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 
171 0.0006 0.00063204765319824
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
172 0.0005 0.00053906440734863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0016 0.0015830993652344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
174 0.0005 0.00053119659423828
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0006 0.00056314468383789
SELECT * FROM products WHERE id = '998'
177 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0013 0.0012719631195068
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
179 0.0005 0.0005180835723877
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0014 0.0014100074768066
SELECT category_id FROM products_categories WHERE product_id = '998' AND prod_type = 'amz'
182 0.0007 0.00072407722473145
SELECT parent_id FROM categories WHERE id = '27'
183 0.0006 0.00061798095703125
SELECT * FROM categories WHERE id = '27'
184 0.0105 0.010522842407227
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
185 0.0009 0.00091004371643066
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186 0.0006 0.00063896179199219
SELECT id FROM categories WHERE parent_id = '27'
187 0.0096 0.0095529556274414
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 
188 0.0008 0.00083708763122559
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 
189 0.0008 0.0008080005645752
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
190 0.0008 0.00084304809570312
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
191 0.0039 0.0039350986480713
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
192 0.0016 0.0016489028930664
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
193 0.0004 0.00044488906860352
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0340 0.034004926681519
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
195 0.0050 0.0049560070037842
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
196 0.0011 0.0010919570922852
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
197 0.0011 0.0010659694671631
SELECT * FROM products WHERE id = 1626
198 0.0020 0.0019779205322266
SELECT * FROM products WHERE id = 4041
199 0.0012 0.001162052154541
SELECT * FROM products WHERE id = 4312
200 0.0016 0.0015549659729004
SELECT * FROM products WHERE id = 777
201 0.0009 0.00088191032409668
SELECT * FROM products WHERE id = 3881
202 0.0007 0.00067996978759766
SELECT * FROM products WHERE id = 4213
203 0.0008 0.00080013275146484
SELECT * FROM products WHERE id = '1626'
204 0.0008 0.00079512596130371
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
205 0.0012 0.0012311935424805
SELECT * FROM product_image_select WHERE product_id = '1626'
206 0.0007 0.00069594383239746
SELECT * FROM productcustomimages WHERE product_id = '1626'
207 0.0026 0.0026140213012695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
208 0.0010 0.0009620189666748
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0006 0.00061202049255371
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0008 0.00079202651977539
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0010 0.00096011161804199
SELECT * FROM products WHERE id = '4041'
212 0.0007 0.00073909759521484
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
213 0.0009 0.00094795227050781
SELECT * FROM product_image_select WHERE product_id = '4041'
214 0.0006 0.00057721138000488
SELECT * FROM productcustomimages WHERE product_id = '4041'
215 0.0022 0.0022361278533936
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
216 0.0007 0.00072097778320312
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0006 0.00057387351989746
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0007 0.00069212913513184
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0008 0.00075387954711914
SELECT * FROM products WHERE id = '4312'
220 0.0009 0.00086688995361328
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
221 0.0010 0.0010240077972412
SELECT * FROM product_image_select WHERE product_id = '4312'
222 0.0005 0.00053095817565918
SELECT * FROM productcustomimages WHERE product_id = '4312'
223 0.0017 0.001723051071167
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
224 0.0008 0.00076508522033691
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0011 0.0010600090026855
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0011 0.0011060237884521
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0012 0.001237154006958
SELECT * FROM products WHERE id = '777'
228 0.0010 0.00098419189453125
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
229 0.0015 0.0014910697937012
SELECT * FROM product_image_select WHERE product_id = '777'
230 0.0008 0.00078105926513672
SELECT * FROM productcustomimages WHERE product_id = '777'
231 0.0028 0.0027661323547363
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
232 0.0009 0.00091886520385742
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0008 0.00081300735473633
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0008 0.00080299377441406
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0010 0.0010161399841309
SELECT * FROM products WHERE id = '3881'
236 0.0010 0.00095486640930176
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
237 0.0012 0.0012140274047852
SELECT * FROM product_image_select WHERE product_id = '3881'
238 0.0009 0.00092101097106934
SELECT * FROM productcustomimages WHERE product_id = '3881'
239 0.0025 0.0025079250335693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
240 0.0007 0.00071120262145996
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0006 0.00063800811767578
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0007 0.00072288513183594
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0008 0.00081419944763184
SELECT * FROM products WHERE id = '4213'
244 0.0008 0.0007941722869873
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
245 0.0011 0.0010881423950195
SELECT * FROM product_image_select WHERE product_id = '4213'
246 0.0007 0.00073385238647461
SELECT * FROM productcustomimages WHERE product_id = '4213'
247 0.0023 0.0022580623626709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
248 0.0007 0.00072193145751953
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0006 0.00063395500183105
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0008 0.00078892707824707
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0028 0.0028069019317627
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
252 0.0011 0.0010790824890137
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
253 0.0038 0.0037710666656494
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
254 0.0021 0.0020601749420166
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0006 0.0006411075592041
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0008 0.00077199935913086
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'