0

Teapigs Rooibos Creme Caramel 15 par paquet

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-09 09:03:53 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

? Quelle est la particularité de ce thé succulent, ce thé a tout - rooibos est naturellement sans ca Tenez-moi au frais et au sec jusqu'à ce que je en ai fini puis essayer de me recycler. Louise est le dégustateur de thé, Teapigs, 1 The Old Station de pompage, pompe Alley, Brentford, Lo Boîte

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.6481511592865 266 0.9472 0


No Amazon API Requests Made.


App Debug - Total Time 1.6481511592865 seconds

Number Time From Start Name Description
1 0.65137004852295 Initialise Initialise FSB Function
2 0.66755294799805 App Controller Start Start of the App controller (called before the controller of every page)
3 0.71096205711365 Start of getCategoryListByGroup Function Before first category groups query
4 0.71293616294861 After initial query Before first category groups query
5 0.71293807029724 Get Category List for Group Before the call to getCategoryList function
6 0.71294212341309 Start of GetCategoryList function Start of the function
7 0.71294593811035 Before getting categories Query to get specific category list
8 0.7148449420929 After getting categories Query to get specific category list
9 0.71484708786011 Before getting category custom Before call to function getCategoryCustom
10 0.74167013168335 After getting category custom After call to function getCategoryCustom
11 0.74167394638062 Before getting category custom Before call to function getCategoryCustom
12 0.75815200805664 After getting category custom After call to function getCategoryCustom
13 0.75815510749817 Before getting category custom Before call to function getCategoryCustom
14 0.76593494415283 After getting category custom After call to function getCategoryCustom
15 0.76593708992004 Before getting category custom Before call to function getCategoryCustom
16 0.77196502685547 After getting category custom After call to function getCategoryCustom
17 0.7719669342041 Before getting category custom Before call to function getCategoryCustom
18 0.77806901931763 After getting category custom After call to function getCategoryCustom
19 0.77807116508484 Before getting category custom Before call to function getCategoryCustom
20 0.7839469909668 After getting category custom After call to function getCategoryCustom
21 0.78395009040833 End of GetCategoryList function End of the function
22 0.7839560508728 Get Category List for Group Before the call to getCategoryList function
23 0.78395915031433 Start of GetCategoryList function Start of the function
24 0.78396201133728 Before getting categories Query to get specific category list
25 0.78457093238831 End of getCategoryListByGroup Function Before return()
26 1.3717470169067 App Controller End End of the App controller (called before the controller of every page)
27 1.3724880218506 Product Start Start of the product info controller
28 1.3833110332489 Cache file not found Starting get product details
29 1.4445300102234 Related products Start getting related products if enabled
30 1.4445331096649 Related Products Start Before the related products are found
31 1.4445340633392 Related Products Keywords Before the related product keywords are found
32 1.4445390701294 Create Keyword List Function Start of function
33 1.4445700645447 Create Keyword List Function After looping provided content - 18 keywords found
34 1.4452979564667 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
35 1.4453060626984 Create Keyword List Function After reducing keyword list
36 1.445338010788 Create Keyword List Function After selecting by scoring keywords
37 1.4453411102295 Create Keyword List Function After final loop of keywords
38 1.4453430175781 Related Products Keywords After the related product keywords are found
39 1.4814400672913 Related Products End After the related products are found
40 1.5150229930878 Product End End of the product info controller (Product Info)
41 1.5209021568298 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.5314030647278 Before Get Options Before the call to getOptions in the tpl class
43 1.6021611690521 After Get Options After the call to getOptions in the tpl class
44 1.6022729873657 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.6023080348969 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6141951084137 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6142001152039 Product Info: Before Template Display Before the template is displayed
48 1.6481111049652 Product Info: After Template Display After the template is displayed
49 1.6481280326843 Finalizing debug Before the debug is output to the page.
50 1.6481499671936 End of App This is the end of the app logging, final timestamp


Query Debug - 266 Database Queries. Total time 0.9472 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0014 0.0013968944549561
SELECT parameter, value FROM parameters
2 0.0047 0.0047469139099121
SELECT * FROM `bad_bots`
3 0.0003 0.00029802322387695
SET time_zone = 'Europe/London'
4 0.0018 0.0017848014831543
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.001716136932373
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.191.181.143\";}'
6 0.0016 0.0016090869903564
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722092371'
7 0.0047 0.0047202110290527
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.00099301338195801
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0031 0.0030980110168457
SELECT id FROM pages WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet' LIMIT 1
10 0.0112 0.011157035827637
SELECT id FROM products WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet' AND hidden = 0 LIMIT 1
11 0.0056 0.005579948425293
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0363 0.036325931549072
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0010 0.00095796585083008
SELECT * FROM pages WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet'
14 0.0020 0.0019609928131104
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0019 0.0018789768218994
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0080 0.0079748630523682
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.0026 0.0025510787963867
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.0016 0.0016078948974609
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00049185752868652
SELECT id FROM categories WHERE parent_id = '26'
20 0.0073 0.0073199272155762
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.0021 0.0020668506622314
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.0022 0.0022258758544922
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.0020 0.0019650459289551
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00048398971557617
SELECT * FROM categorygroups WHERE id = '1'
25 0.0058 0.0057649612426758
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.0008 0.0007789134979248
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0005 0.00053787231445312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0006 0.00061607360839844
SELECT id FROM categories WHERE parent_id = '27'
29 0.0063 0.0063319206237793
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0008 0.00082302093505859
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.00059795379638672
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00043797492980957
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0018899440765381
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.00055789947509766
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.00044083595275879
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00046515464782715
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.0020418167114258
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.0007 0.00070810317993164
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.00063300132751465
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.00052499771118164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00042605400085449
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.0008389949798584
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.00054192543029785
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.0006 0.00055813789367676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.0006411075592041
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00086498260498047
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.0006 0.00061297416687012
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.0007 0.00066804885864258
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.0006 0.00062298774719238
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00059390068054199
SELECT * FROM categorygroups WHERE id = '1'
52 0.0009 0.00089192390441895
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.00064587593078613
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.00047206878662109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0006 0.00057196617126465
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00092196464538574
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.0006251335144043
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.00072693824768066
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0006 0.00055193901062012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00060200691223145
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.0008699893951416
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.0006 0.00059986114501953
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.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.0005180835723877
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00087308883666992
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.00060200691223145
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.00065398216247559
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.0007 0.0006561279296875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00051784515380859
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00059700012207031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0036 0.0035851001739502
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0018 0.0017919540405273
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00063300132751465
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.0016 0.0015740394592285
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.001244068145752
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0012331008911133
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5707 0.57069087028503
SELECT * FROM ipgeocountries WHERE INET_ATON('18.191.181.143') >= INET_ATON(ip_start) AND INET_ATON('18.191.181.143') <= INET_ATON(ip_end)
78 0.0026 0.0025589466094971
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0018 0.0018198490142822
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00088906288146973
SELECT * FROM products WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet'
81 0.0005 0.00049209594726562
UPDATE products SET viewcount = viewcount + 1 WHERE id = 915
82 0.0017 0.0016880035400391
SELECT * FROM manufacturers WHERE id = '246'
83 0.0008 0.00075817108154297
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '246'
84 0.0020 0.0020210742950439
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '246' LIMIT 1
85 0.0021 0.0021328926086426
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '246' ORDER BY RAND() LIMIT 1
86 0.0005 0.00052285194396973
SELECT * FROM productimages WHERE product_id = '1042' ORDER BY sortorder ASC
87 0.0006 0.00059103965759277
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '246'
88 0.0007 0.0006868839263916
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '246'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0016 0.0015621185302734
SELECT * FROM manufacturerimages WHERE manufacturer_id = '246'
90 0.0015 0.0015370845794678
SELECT category_id FROM products_categories WHERE product_id = '915'
91 0.0013 0.0013420581817627
SELECT * FROM categories WHERE id = '27'
92 0.0060 0.0060319900512695
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.0007 0.00068306922912598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00040602684020996
SELECT id FROM categories WHERE parent_id = '27'
95 0.0058 0.0058460235595703
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.0008 0.00077700614929199
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.0008 0.00075006484985352
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.0007 0.00065708160400391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00072288513183594
SELECT * FROM productimages WHERE product_id = '915' ORDER BY sortorder ASC
100 0.0021 0.0021350383758545
SELECT * FROM product_image_select WHERE product_id = '915'
101 0.0020 0.001971960067749
SELECT * FROM productcustomimages WHERE product_id = '915'
102 0.0015 0.0015189647674561
SELECT * FROM productfeeds WHERE product_id = '915' ORDER BY item_date DESC
103 0.0030 0.0030229091644287
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '915' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0030 0.0029819011688232
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '915' AND t.hidden = 0 AND display_product = 1
105 0.0005 0.00052595138549805
SELECT * FROM tags WHERE id = '15'
106 0.0013 0.0012609958648682
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0010 0.0010218620300293
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0010 0.00095415115356445
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' 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.0008 0.00075984001159668
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
110 0.0005 0.00046205520629883
SELECT * FROM tags WHERE id = '81'
111 0.0030 0.0030457973480225
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
112 0.0026 0.0026090145111084
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
113 0.0026 0.0025651454925537
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
114 0.0006 0.00055193901062012
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
115 0.0018 0.0017819404602051
SELECT * FROM productamazoncontent WHERE product_id = '915'
116 0.0009 0.00086808204650879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '915' AND a.name = n.originalname
117 0.0016 0.0015618801116943
SELECT * FROM productoffers WHERE product_id = '915' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = '915' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0003 0.0003361701965332
SELECT * FROM productoffers
                WHERE product_id = 915
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00052404403686523
SELECT value FROM productattributes
                WHERE product_id = '915'
                AND name = 'ListPriceAmount'
121 0.0004 0.00040817260742188
SELECT value FROM productattributes WHERE product_id = '915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.00051498413085938
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
123 0.0097 0.0097270011901855
SELECT *, MATCH (description, title) AGAINST ('teapigs rooibos creme' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('teapigs rooibos creme' IN BOOLEAN MODE) AND 915 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
124 0.0007 0.00071191787719727
SELECT *, MATCH (description, title) AGAINST ('teapigs rooibos creme' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('teapigs rooibos creme' IN BOOLEAN MODE) AND 915 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
125 0.0005 0.00054311752319336
SELECT *, MATCH (description, title) AGAINST ('teapigs rooibos creme' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('teapigs rooibos creme' IN BOOLEAN MODE) AND 915 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
126 0.0006 0.00060892105102539
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
127 0.0006 0.00058412551879883
SELECT * FROM product_image_select WHERE product_id = '858'
128 0.0004 0.00039386749267578
SELECT * FROM productcustomimages WHERE product_id = '858'
129 0.0011 0.0010809898376465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
130 0.0005 0.00052690505981445
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0005 0.0005338191986084
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
134 0.0006 0.00056576728820801
SELECT * FROM product_image_select WHERE product_id = '869'
135 0.0004 0.00037503242492676
SELECT * FROM productcustomimages WHERE product_id = '869'
136 0.0010 0.00095081329345703
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
137 0.0005 0.00047516822814941
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.00040912628173828
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0005 0.00054287910461426
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0005 0.00047802925109863
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
141 0.0006 0.00055599212646484
SELECT * FROM product_image_select WHERE product_id = '878'
142 0.0004 0.0003669261932373
SELECT * FROM productcustomimages WHERE product_id = '878'
143 0.0010 0.00098299980163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
144 0.0005 0.00052785873413086
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00041604042053223
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0005 0.00050783157348633
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
148 0.0007 0.00066614151000977
SELECT * FROM product_image_select WHERE product_id = '862'
149 0.0004 0.00041103363037109
SELECT * FROM productcustomimages WHERE product_id = '862'
150 0.0010 0.00095701217651367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
151 0.0006 0.00055503845214844
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00041913986206055
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00048303604125977
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
155 0.0006 0.00058984756469727
SELECT * FROM product_image_select WHERE product_id = '890'
156 0.0006 0.00056099891662598
SELECT * FROM productcustomimages WHERE product_id = '890'
157 0.0011 0.0010650157928467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
158 0.0005 0.00053191184997559
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.00053286552429199
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00048089027404785
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.00056600570678711
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
162 0.0006 0.00058794021606445
SELECT * FROM product_image_select WHERE product_id = '865'
163 0.0006 0.00058698654174805
SELECT * FROM productcustomimages WHERE product_id = '865'
164 0.0008 0.00076913833618164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
165 0.0005 0.00052905082702637
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0005 0.00050902366638184
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0006 0.00057196617126465
SELECT id,asin FROM products WHERE parent_id = 915
169 0.0017 0.0017220973968506
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '915' ORDER BY timestamp DESC
170 0.0009 0.00085902214050293
SELECT category_id FROM products_categories WHERE product_id = '915'
171 0.0005 0.00048303604125977
SELECT * FROM categories WHERE id = '27'
172 0.0042 0.0042409896850586
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
173 0.0005 0.0005340576171875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
174 0.0004 0.00036787986755371
SELECT id FROM categories WHERE parent_id = '27'
175 0.0039 0.0038590431213379
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 
176 0.0006 0.0005500316619873
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 
177 0.0006 0.00059199333190918
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
178 0.0004 0.00044918060302734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
179 0.0009 0.00085210800170898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '915' AND a.name = n.originalname
180 0.0006 0.00060892105102539
SELECT * FROM productoffers WHERE product_id = '915' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0005 0.00051617622375488
SELECT * FROM productoffers
                WHERE product_id = '915' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0005 0.0004570484161377
SELECT * FROM productoffers
                WHERE product_id = 915
                ORDER BY price ASC LIMIT 1
183 0.0004 0.00041890144348145
SELECT value FROM productattributes
                WHERE product_id = '915'
                AND name = 'ListPriceAmount'
184 0.0007 0.00069403648376465
SELECT * FROM products WHERE id = '915'
185 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0008 0.00076079368591309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '915' AND a.name = n.originalname
187 0.0004 0.00039386749267578
SELECT * FROM productoffers WHERE product_id = '915' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0003 0.00034880638122559
SELECT * FROM productoffers
                WHERE product_id = '915' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = 915
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00036311149597168
SELECT value FROM productattributes
                WHERE product_id = '915'
                AND name = 'ListPriceAmount'
191 0.0004 0.0004429817199707
SELECT category_id FROM products_categories WHERE product_id = '915' AND prod_type = 'amz'
192 0.0004 0.00044822692871094
SELECT parent_id FROM categories WHERE id = '27'
193 0.0004 0.00042605400085449
SELECT * FROM categories WHERE id = '27'
194 0.0038 0.0038390159606934
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
195 0.0005 0.0005180835723877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
196 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '27'
197 0.0035 0.0034828186035156
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 
198 0.0005 0.00052809715270996
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 
199 0.0014 0.0014281272888184
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
200 0.0013 0.0013308525085449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
201 0.0052 0.0051889419555664
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
202 0.0099 0.0098707675933838
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
203 0.0005 0.00051593780517578
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
204 0.0186 0.018613815307617
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
205 0.0020 0.0020451545715332
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
206 0.0006 0.00056219100952148
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
207 0.0006 0.00061321258544922
SELECT * FROM products WHERE id = 1626
208 0.0004 0.00044918060302734
SELECT * FROM products WHERE id = 4041
209 0.0005 0.00045013427734375
SELECT * FROM products WHERE id = 4312
210 0.0004 0.00043702125549316
SELECT * FROM products WHERE id = 777
211 0.0005 0.00052499771118164
SELECT * FROM products WHERE id = 3881
212 0.0004 0.00044107437133789
SELECT * FROM products WHERE id = 4213
213 0.0004 0.00042819976806641
SELECT * FROM products WHERE id = '1626'
214 0.0005 0.0004570484161377
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
215 0.0007 0.00068998336791992
SELECT * FROM product_image_select WHERE product_id = '1626'
216 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '1626'
217 0.0009 0.00094294548034668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
218 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00046014785766602
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00061798095703125
SELECT * FROM products WHERE id = '4041'
222 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
223 0.0007 0.00069808959960938
SELECT * FROM product_image_select WHERE product_id = '4041'
224 0.0004 0.00041007995605469
SELECT * FROM productcustomimages WHERE product_id = '4041'
225 0.0016 0.0015671253204346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
226 0.0006 0.00057005882263184
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0007 0.0007021427154541
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00051403045654297
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = '4312'
230 0.0006 0.00057005882263184
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
231 0.0007 0.00066590309143066
SELECT * FROM product_image_select WHERE product_id = '4312'
232 0.0005 0.0005190372467041
SELECT * FROM productcustomimages WHERE product_id = '4312'
233 0.0013 0.0012798309326172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
234 0.0005 0.00053596496582031
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0006 0.0005950927734375
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = '777'
238 0.0006 0.00055098533630371
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
239 0.0007 0.00073504447937012
SELECT * FROM product_image_select WHERE product_id = '777'
240 0.0004 0.00043487548828125
SELECT * FROM productcustomimages WHERE product_id = '777'
241 0.0014 0.0014197826385498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
242 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.00049686431884766
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0006 0.00061917304992676
SELECT * FROM products WHERE id = '3881'
246 0.0007 0.00068116188049316
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
247 0.0007 0.00071597099304199
SELECT * FROM product_image_select WHERE product_id = '3881'
248 0.0005 0.00047993659973145
SELECT * FROM productcustomimages WHERE product_id = '3881'
249 0.0016 0.001629114151001
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
250 0.0007 0.00066399574279785
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0007 0.00070786476135254
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0006 0.00063085556030273
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0009 0.00088906288146973
SELECT * FROM products WHERE id = '4213'
254 0.0009 0.00092887878417969
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
255 0.0009 0.00094699859619141
SELECT * FROM product_image_select WHERE product_id = '4213'
256 0.0005 0.00053095817565918
SELECT * FROM productcustomimages WHERE product_id = '4213'
257 0.0019 0.0019021034240723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
258 0.0006 0.00063419342041016
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0005 0.00052905082702637
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0006 0.00064396858215332
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0029 0.0029101371765137
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
262 0.0009 0.00088119506835938
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
263 0.0037 0.0036661624908447
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
264 0.0026 0.0025970935821533
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
265 0.0006 0.00064301490783691
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0007 0.00071001052856445
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'