0

Alter Eco Thé Blanc Rooibos Nature Bio et Équitable 20 infusettes parent

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-25 22:45:50 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
2.7238070964813 242 1.0318 0


No Amazon API Requests Made.


App Debug - Total Time 2.7238070964813 seconds

Number Time From Start Name Description
1 1.6763961315155 Initialise Initialise FSB Function
2 1.6849930286407 App Controller Start Start of the App controller (called before the controller of every page)
3 1.7125270366669 Start of getCategoryListByGroup Function Before first category groups query
4 1.7141160964966 After initial query Before first category groups query
5 1.7141170501709 Get Category List for Group Before the call to getCategoryList function
6 1.7141189575195 Start of GetCategoryList function Start of the function
7 1.7141201496124 Before getting categories Query to get specific category list
8 1.7156381607056 After getting categories Query to get specific category list
9 1.7156381607056 Before getting category custom Before call to function getCategoryCustom
10 1.7425510883331 After getting category custom After call to function getCategoryCustom
11 1.7425539493561 Before getting category custom Before call to function getCategoryCustom
12 1.7537219524384 After getting category custom After call to function getCategoryCustom
13 1.7537250518799 Before getting category custom Before call to function getCategoryCustom
14 1.7631869316101 After getting category custom After call to function getCategoryCustom
15 1.7631890773773 Before getting category custom Before call to function getCategoryCustom
16 1.768296957016 After getting category custom After call to function getCategoryCustom
17 1.7682991027832 Before getting category custom Before call to function getCategoryCustom
18 1.7726430892944 After getting category custom After call to function getCategoryCustom
19 1.7726449966431 Before getting category custom Before call to function getCategoryCustom
20 1.7782111167908 After getting category custom After call to function getCategoryCustom
21 1.7782130241394 End of GetCategoryList function End of the function
22 1.7782180309296 Get Category List for Group Before the call to getCategoryList function
23 1.7782189846039 Start of GetCategoryList function Start of the function
24 1.7782199382782 Before getting categories Query to get specific category list
25 1.7788100242615 End of getCategoryListByGroup Function Before return()
26 2.5514900684357 App Controller End End of the App controller (called before the controller of every page)
27 2.5521430969238 Product Start Start of the product info controller
28 2.5540180206299 Cache file not found Starting get product details
29 2.5802409648895 Related products Start getting related products if enabled
30 2.5802421569824 Related Products Start Before the related products are found
31 2.5802421569824 Related Products Keywords Before the related product keywords are found
32 2.5802509784698 Create Keyword List Function Start of function
33 2.5803289413452 Create Keyword List Function After looping provided content - 33 keywords found
34 2.5809020996094 Create Keyword List Function After looping initial keyword list - 29 keywords remaining
35 2.5809071063995 Create Keyword List Function After reducing keyword list
36 2.5809531211853 Create Keyword List Function After selecting by scoring keywords
37 2.5809559822083 Create Keyword List Function After final loop of keywords
38 2.5809569358826 Related Products Keywords After the related product keywords are found
39 2.6360750198364 Related Products End After the related products are found
40 2.6449711322784 Product End End of the product info controller (Product Info)
41 2.6470980644226 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.6488420963287 Before Get Options Before the call to getOptions in the tpl class
43 2.6985609531403 After Get Options After the call to getOptions in the tpl class
44 2.6986701488495 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.6986899375916 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.7075481414795 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.7075510025024 Product Info: Before Template Display Before the template is displayed
48 2.7237899303436 Product Info: After Template Display After the template is displayed
49 2.7237980365753 Finalizing debug Before the debug is output to the page.
50 2.723806142807 End of App This is the end of the app logging, final timestamp


Query Debug - 242 Database Queries. Total time 1.0318 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0021510124206543
SELECT parameter, value FROM parameters
2 0.0044 0.0044319629669189
SELECT * FROM `bad_bots`
3 0.0003 0.00031781196594238
SET time_zone = 'Europe/London'
4 0.0018 0.0018010139465332
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0025 0.0024909973144531
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.218.8.36\";}'
6 0.0026 0.0025720596313477
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746505766'
7 0.0039 0.0039021968841553
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047588348388672
UPDATE autorun SET lastrun = '2025-05-06 04:29:26' WHERE id = '16'
9 0.0008 0.00078415870666504
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0032 0.0031919479370117
SELECT id FROM pages WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512' LIMIT 1
11 0.0041 0.0041289329528809
SELECT id FROM products WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512' AND hidden = 0 LIMIT 1
12 0.0024 0.0023767948150635
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0242 0.024150133132935
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00060701370239258
SELECT * FROM pages WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512'
15 0.0016 0.0015840530395508
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0015 0.0015079975128174
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0066 0.0066421031951904
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.0020 0.0020380020141602
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.0014 0.0014429092407227
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '26'
21 0.0106 0.010648012161255
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.0019 0.0019011497497559
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.0018 0.0017881393432617
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.0015 0.0015270709991455
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00039482116699219
SELECT * FROM categorygroups WHERE id = '1'
26 0.0039 0.0039079189300537
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.0006 0.00055909156799316
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.0004 0.00039792060852051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00051689147949219
SELECT id FROM categories WHERE parent_id = '27'
30 0.0038 0.0037791728973389
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.0005 0.00049185752868652
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.0005 0.00054287910461426
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.0005 0.00048494338989258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00043988227844238
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0015990734100342
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.00057792663574219
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.0006 0.00060081481933594
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0021 0.0021448135375977
SELECT id FROM categories WHERE parent_id = '28'
39 0.0025 0.0024700164794922
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.00062179565429688
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.0005 0.00051498413085938
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.0005 0.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00040507316589355
SELECT * FROM categorygroups WHERE id = '1'
44 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 = 29
45 0.0005 0.00046205520629883
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.0004 0.00039196014404297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0006 0.00061607360839844
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.0006859302520752
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.0007 0.00073099136352539
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.0006 0.00060105323791504
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.0005040168762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00046014785766602
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.0006110668182373
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.00041818618774414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.0003960132598877
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00068783760070801
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.00045514106750488
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.00047397613525391
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.0004 0.00043201446533203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.0003819465637207
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00060319900512695
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.00045108795166016
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.00051999092102051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00039196014404297
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00070810317993164
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.0008 0.00082802772521973
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.0008 0.00075793266296387
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.0007 0.00071191787719727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00055408477783203
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00058484077453613
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0031 0.0031168460845947
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0017 0.0016729831695557
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00053715705871582
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.0012 0.001209020614624
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0012 0.0011520385742188
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00084209442138672
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7581 0.75808596611023
SELECT * FROM ipgeocountries WHERE INET_ATON('18.218.8.36') >= INET_ATON(ip_start) AND INET_ATON('18.218.8.36') <= INET_ATON(ip_end)
79 0.0030 0.0029690265655518
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0015 0.0015490055084229
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00072908401489258
SELECT * FROM products WHERE pagename = 'alter-eco-the-blanc-rooibos-nature-bio-et-Equitable-20-infusettes-255854512'
82 0.0005 0.0005040168762207
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4006
83 0.0007 0.00069117546081543
SELECT * FROM manufacturers WHERE id = '639'
84 0.0014 0.0014209747314453
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85 0.0019 0.0018670558929443
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
86 0.0029 0.0028860569000244
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
87 0.0005 0.00050497055053711
SELECT * FROM productimages WHERE product_id = '1948' ORDER BY sortorder ASC
88 0.0009 0.00089097023010254
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
89 0.0010 0.00096511840820312
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0006 0.00058102607727051
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
91 0.0005 0.00047612190246582
SELECT category_id FROM products_categories WHERE product_id = '4006'
92 0.0004 0.00041484832763672
SELECT * FROM productimages WHERE product_id = '4006' ORDER BY sortorder ASC
93 0.0019 0.0018680095672607
SELECT * FROM product_image_select WHERE product_id = '4006'
94 0.0012 0.0012459754943848
SELECT * FROM productcustomimages WHERE product_id = '4006'
95 0.0012 0.0011601448059082
SELECT * FROM productfeeds WHERE product_id = '4006' ORDER BY item_date DESC
96 0.0024 0.0024430751800537
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
97 0.0026 0.0026149749755859
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4006' AND t.hidden = 0 AND display_product = 1
98 0.0013 0.001338005065918
SELECT * FROM productamazoncontent WHERE product_id = '4006'
99 0.0008 0.00078201293945312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
100 0.0014 0.0013518333435059
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0004 0.00043106079101562
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0004 0.00041294097900391
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
103 0.0005 0.0005340576171875
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
104 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '4006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
105 0.0006 0.00057601928710938
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
106 0.0097 0.0096530914306641
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AND 4006 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
107 0.0005 0.00054812431335449
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AND 4006 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
108 0.0005 0.00053977966308594
SELECT *, MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('blanc rooibos nature' IN BOOLEAN MODE) AND 4006 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
109 0.0006 0.00055599212646484
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
110 0.0005 0.00052404403686523
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
111 0.0008 0.00080704689025879
SELECT * FROM product_image_select WHERE product_id = '822'
112 0.0004 0.00037717819213867
SELECT * FROM productcustomimages WHERE product_id = '822'
113 0.0006 0.0005800724029541
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
114 0.0029 0.0029220581054688
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
115 0.0005 0.00048398971557617
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
116 0.0009 0.00093603134155273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
117 0.0004 0.00040388107299805
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0004 0.0003809928894043
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00049710273742676
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
121 0.0006 0.00056791305541992
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
122 0.0008 0.00079107284545898
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
123 0.0004 0.00041294097900391
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
124 0.0005 0.0005340576171875
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0008 0.00077986717224121
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
126 0.0005 0.0005338191986084
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
127 0.0006 0.00060606002807617
SELECT * FROM product_image_select WHERE product_id = '878'
128 0.0004 0.00037097930908203
SELECT * FROM productcustomimages WHERE product_id = '878'
129 0.0031 0.0031368732452393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
130 0.0010 0.0010170936584473
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0007 0.00069499015808105
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0009 0.00087785720825195
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0010 0.00099086761474609
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
134 0.0016 0.0015690326690674
SELECT * FROM product_image_select WHERE product_id = '4952'
135 0.0008 0.00081801414489746
SELECT * FROM productcustomimages WHERE product_id = '4952'
136 0.0020 0.0019938945770264
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
137 0.0010 0.00098705291748047
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0008 0.00078415870666504
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0008 0.00083398818969727
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0011 0.0010831356048584
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
141 0.0011 0.0010638236999512
SELECT * FROM product_image_select WHERE product_id = '862'
142 0.0006 0.00058388710021973
SELECT * FROM productcustomimages WHERE product_id = '862'
143 0.0017 0.0017180442810059
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
144 0.0007 0.0006558895111084
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0005 0.00049185752868652
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0006 0.0005950927734375
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0008 0.00079989433288574
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
148 0.0009 0.00089406967163086
SELECT * FROM product_image_select WHERE product_id = '858'
149 0.0005 0.00047898292541504
SELECT * FROM productcustomimages WHERE product_id = '858'
150 0.0018 0.0017988681793213
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
151 0.0007 0.00065708160400391
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0005 0.00054311752319336
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0006 0.00057315826416016
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
155 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '4947'
156 0.0005 0.00047898292541504
SELECT * FROM productcustomimages WHERE product_id = '4947'
157 0.0011 0.0010819435119629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
158 0.0006 0.00055313110351562
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00048398971557617
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00050616264343262
SELECT id,asin FROM products WHERE parent_id = 4006
162 0.0018 0.0017910003662109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4006' ORDER BY timestamp DESC
163 0.0005 0.00054502487182617
SELECT category_id FROM products_categories WHERE product_id = '4006'
164 0.0010 0.00096392631530762
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
165 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00031304359436035
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
168 0.0003 0.0003361701965332
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
169 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = '4006'
170 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '4006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0007 0.00067019462585449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
172 0.0004 0.00035786628723145
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
173 0.0003 0.00034379959106445
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0003 0.00031518936157227
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
175 0.0004 0.00035309791564941
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
176 0.0004 0.00040698051452637
SELECT category_id FROM products_categories WHERE product_id = '4006' AND prod_type = 'amz'
177 0.0015 0.0015411376953125
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
178 0.0013 0.0013420581817627
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
179 0.0003 0.0003359317779541
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
180 0.0132 0.013159036636353
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
181 0.0015 0.001488208770752
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
182 0.0005 0.00051212310791016
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
183 0.0005 0.00045013427734375
SELECT * FROM products WHERE id = 1626
184 0.0003 0.00031495094299316
SELECT * FROM products WHERE id = 4041
185 0.0003 0.00033688545227051
SELECT * FROM products WHERE id = 4312
186 0.0003 0.00033116340637207
SELECT * FROM products WHERE id = 777
187 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = 3881
188 0.0003 0.00031495094299316
SELECT * FROM products WHERE id = 4213
189 0.0003 0.0003211498260498
SELECT * FROM products WHERE id = '1626'
190 0.0005 0.00045084953308105
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
191 0.0005 0.00053811073303223
SELECT * FROM product_image_select WHERE product_id = '1626'
192 0.0003 0.00033807754516602
SELECT * FROM productcustomimages WHERE product_id = '1626'
193 0.0008 0.00075387954711914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
194 0.0004 0.00042510032653809
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0004 0.00037002563476562
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0005 0.00045204162597656
SELECT * FROM products WHERE id = '4041'
198 0.0004 0.00039505958557129
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
199 0.0006 0.00058507919311523
SELECT * FROM product_image_select WHERE product_id = '4041'
200 0.0004 0.00036096572875977
SELECT * FROM productcustomimages WHERE product_id = '4041'
201 0.0010 0.00098609924316406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
202 0.0004 0.00042009353637695
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0004 0.00036787986755371
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0005 0.00045180320739746
SELECT * FROM products WHERE id = '4312'
206 0.0004 0.00040602684020996
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
207 0.0005 0.0005490779876709
SELECT * FROM product_image_select WHERE product_id = '4312'
208 0.0004 0.00036907196044922
SELECT * FROM productcustomimages WHERE product_id = '4312'
209 0.0010 0.00095391273498535
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
210 0.0004 0.00042891502380371
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0004 0.00039911270141602
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0004 0.00042486190795898
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '777'
214 0.0005 0.00052309036254883
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
215 0.0006 0.00057601928710938
SELECT * FROM product_image_select WHERE product_id = '777'
216 0.0004 0.00038695335388184
SELECT * FROM productcustomimages WHERE product_id = '777'
217 0.0010 0.00098299980163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
218 0.0004 0.00043797492980957
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00037407875061035
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0005 0.00051116943359375
SELECT * FROM products WHERE id = '3881'
222 0.0005 0.00047111511230469
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
223 0.0006 0.00055503845214844
SELECT * FROM product_image_select WHERE product_id = '3881'
224 0.0004 0.0003669261932373
SELECT * FROM productcustomimages WHERE product_id = '3881'
225 0.0011 0.0010600090026855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
226 0.0004 0.00044989585876465
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00048613548278809
SELECT * FROM products WHERE id = '4213'
230 0.0005 0.0004570484161377
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
231 0.0005 0.00054478645324707
SELECT * FROM product_image_select WHERE product_id = '4213'
232 0.0003 0.00033783912658691
SELECT * FROM productcustomimages WHERE product_id = '4213'
233 0.0011 0.0011398792266846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
234 0.0005 0.0004580020904541
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00040483474731445
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0017 0.0017240047454834
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
238 0.0007 0.00067400932312012
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
239 0.0022 0.0022199153900146
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
240 0.0015 0.0014550685882568
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
241 0.0005 0.0004580020904541
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
242 0.0005 0.00052714347839355
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'