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
2.1770961284637 266 1.7648 0


No Amazon API Requests Made.


App Debug - Total Time 2.1770961284637 seconds

Number Time From Start Name Description
1 0.39102005958557 Initialise Initialise FSB Function
2 0.40385007858276 App Controller Start Start of the App controller (called before the controller of every page)
3 0.44518494606018 Start of getCategoryListByGroup Function Before first category groups query
4 0.44668507575989 After initial query Before first category groups query
5 0.4466860294342 Get Category List for Group Before the call to getCategoryList function
6 0.44668793678284 Start of GetCategoryList function Start of the function
7 0.44668912887573 Before getting categories Query to get specific category list
8 0.44801998138428 After getting categories Query to get specific category list
9 0.44801998138428 Before getting category custom Before call to function getCategoryCustom
10 0.47037696838379 After getting category custom After call to function getCategoryCustom
11 0.470379114151 Before getting category custom Before call to function getCategoryCustom
12 0.48400402069092 After getting category custom After call to function getCategoryCustom
13 0.48400497436523 Before getting category custom Before call to function getCategoryCustom
14 0.49072909355164 After getting category custom After call to function getCategoryCustom
15 0.49073100090027 Before getting category custom Before call to function getCategoryCustom
16 0.49516701698303 After getting category custom After call to function getCategoryCustom
17 0.49516797065735 Before getting category custom Before call to function getCategoryCustom
18 0.50119495391846 After getting category custom After call to function getCategoryCustom
19 0.50119590759277 Before getting category custom Before call to function getCategoryCustom
20 0.50702810287476 After getting category custom After call to function getCategoryCustom
21 0.50702905654907 End of GetCategoryList function End of the function
22 0.50703310966492 Get Category List for Group Before the call to getCategoryList function
23 0.50703501701355 Start of GetCategoryList function Start of the function
24 0.50703597068787 Before getting categories Query to get specific category list
25 0.50750994682312 End of getCategoryListByGroup Function Before return()
26 1.9199640750885 App Controller End End of the App controller (called before the controller of every page)
27 1.9205760955811 Product Start Start of the product info controller
28 1.9224050045013 Cache file not found Starting get product details
29 1.9881501197815 Related products Start getting related products if enabled
30 1.9881510734558 Related Products Start Before the related products are found
31 1.9881520271301 Related Products Keywords Before the related product keywords are found
32 1.9881601333618 Create Keyword List Function Start of function
33 1.9882340431213 Create Keyword List Function After looping provided content - 18 keywords found
34 1.9886131286621 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
35 1.9886181354523 Create Keyword List Function After reducing keyword list
36 1.9886350631714 Create Keyword List Function After selecting by scoring keywords
37 1.98863697052 Create Keyword List Function After final loop of keywords
38 1.9886379241943 Related Products Keywords After the related product keywords are found
39 2.0282139778137 Related Products End After the related products are found
40 2.0631520748138 Product End End of the product info controller (Product Info)
41 2.0651950836182 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.0679919719696 Before Get Options Before the call to getOptions in the tpl class
43 2.1391170024872 After Get Options After the call to getOptions in the tpl class
44 2.1392381191254 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.1392590999603 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.148225069046 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.1482269763947 Product Info: Before Template Display Before the template is displayed
48 2.1770799160004 Product Info: After Template Display After the template is displayed
49 2.1770880222321 Finalizing debug Before the debug is output to the page.
50 2.1770961284637 End of App This is the end of the app logging, final timestamp


Query Debug - 266 Database Queries. Total time 1.7648 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0020 0.0019900798797607
SELECT parameter, value FROM parameters
2 0.0094 0.0093510150909424
SELECT * FROM `bad_bots`
3 0.0005 0.00049710273742676
SET time_zone = 'Europe/London'
4 0.0033 0.0032951831817627
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0031 0.003061056137085
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.188.15.246\";}'
6 0.0033 0.0032579898834229
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746092361'
7 0.0050 0.0050220489501953
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0012 0.0012209415435791
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0053 0.0053329467773438
SELECT id FROM pages WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet' LIMIT 1
10 0.0057 0.0056769847869873
SELECT id FROM products WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet' AND hidden = 0 LIMIT 1
11 0.0054 0.005375862121582
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0327 0.032668113708496
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00057601928710938
SELECT * FROM pages WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet'
14 0.0015 0.0014960765838623
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0013 0.0013198852539062
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0067 0.0066878795623779
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.0019 0.0018899440765381
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.0012 0.0012321472167969
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00050497055053711
SELECT id FROM categories WHERE parent_id = '26'
20 0.0062 0.006152868270874
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.002140998840332
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.0017 0.001680850982666
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.0016 0.0015609264373779
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.0004570484161377
SELECT * FROM categorygroups WHERE id = '1'
25 0.0047 0.0047130584716797
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.00058698654174805
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.00046491622924805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00042390823364258
SELECT id FROM categories WHERE parent_id = '27'
29 0.0053 0.0052781105041504
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0006 0.00061678886413574
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.0007 0.00066399574279785
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.00047898292541504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00036406517028809
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0015339851379395
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.0004 0.00044012069702148
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.0003819465637207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00038385391235352
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0016958713531494
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.00066304206848145
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.00059819221496582
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.0006 0.0005638599395752
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.0004270076751709
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00059795379638672
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.00046396255493164
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00038385391235352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.0003960132598877
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00064301490783691
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.00047111511230469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00047993659973145
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.0007929801940918
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.00056695938110352
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.00052285194396973
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00048494338989258
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00073099136352539
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.00055694580078125
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.0008 0.00084400177001953
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.0007 0.00070905685424805
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0008 0.00078797340393066
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00079607963562012
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.0010 0.0010390281677246
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00037002563476562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00038909912109375
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00078606605529785
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.0009 0.00085091590881348
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.0006 0.00059700012207031
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0006 0.00055408477783203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.0004279613494873
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00047016143798828
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0028 0.0027649402618408
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0016 0.0015749931335449
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0012 0.001194953918457
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.0046 0.0045781135559082
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0030 0.0029659271240234
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0021 0.0021331310272217
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 1.3916 1.3915810585022
SELECT * FROM ipgeocountries WHERE INET_ATON('18.188.15.246') >= INET_ATON(ip_start) AND INET_ATON('18.188.15.246') <= INET_ATON(ip_end)
78 0.0027 0.0026979446411133
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0013787746429443
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.0006711483001709
SELECT * FROM products WHERE pagename = 'teapigs-rooibos-creme-caramel-15-par-paquet'
81 0.0006 0.00057816505432129
UPDATE products SET viewcount = viewcount + 1 WHERE id = 915
82 0.0011 0.0011229515075684
SELECT * FROM manufacturers WHERE id = '246'
83 0.0011 0.0011279582977295
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '246'
84 0.0032 0.0031609535217285
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '246' LIMIT 1
85 0.0033 0.0032880306243896
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.0007 0.00069904327392578
SELECT * FROM productimages WHERE product_id = '914' ORDER BY sortorder ASC
87 0.0005 0.00046086311340332
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '246'
88 0.0007 0.00069808959960938
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.0006 0.0006101131439209
SELECT * FROM manufacturerimages WHERE manufacturer_id = '246'
90 0.0008 0.00075697898864746
SELECT category_id FROM products_categories WHERE product_id = '915'
91 0.0005 0.00051188468933105
SELECT * FROM categories WHERE id = '27'
92 0.0038 0.0037798881530762
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.0004 0.00040793418884277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00033187866210938
SELECT id FROM categories WHERE parent_id = '27'
95 0.0035 0.0034990310668945
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.0005 0.00054097175598145
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0005 0.00048518180847168
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.0004 0.00042009353637695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00047183036804199
SELECT * FROM productimages WHERE product_id = '915' ORDER BY sortorder ASC
100 0.0018 0.0017538070678711
SELECT * FROM product_image_select WHERE product_id = '915'
101 0.0014 0.0013539791107178
SELECT * FROM productcustomimages WHERE product_id = '915'
102 0.0013 0.0012600421905518
SELECT * FROM productfeeds WHERE product_id = '915' ORDER BY item_date DESC
103 0.0024 0.0024130344390869
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.0022 0.0022130012512207
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.0004 0.00043010711669922
SELECT * FROM tags WHERE id = '15'
106 0.0011 0.00111985206604
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.0009 0.00088810920715332
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.0027 0.0026619434356689
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.0012 0.0012221336364746
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
110 0.0006 0.0005640983581543
SELECT * FROM tags WHERE id = '81'
111 0.0070 0.0069921016693115
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.0058 0.0057849884033203
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.0040 0.0039999485015869
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.0007 0.00071501731872559
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
115 0.0031 0.0030579566955566
SELECT * FROM productamazoncontent WHERE product_id = '915'
116 0.0019 0.0018630027770996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '915' AND a.name = n.originalname
117 0.0018 0.0018198490142822
SELECT * FROM productoffers WHERE product_id = '915' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0005 0.00054597854614258
SELECT * FROM productoffers
                WHERE product_id = '915' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0005 0.00047993659973145
SELECT * FROM productoffers
                WHERE product_id = 915
                ORDER BY price ASC LIMIT 1
120 0.0006 0.00062990188598633
SELECT value FROM productattributes
                WHERE product_id = '915'
                AND name = 'ListPriceAmount'
121 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0006 0.0006248950958252
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.0115 0.011520862579346
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.0006 0.00057792663574219
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.0007 0.00065112113952637
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.00058412551879883
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
127 0.0008 0.00082683563232422
SELECT * FROM product_image_select WHERE product_id = '878'
128 0.0006 0.00055193901062012
SELECT * FROM productcustomimages WHERE product_id = '878'
129 0.0013 0.0013420581817627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
130 0.0005 0.0005490779876709
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0005 0.00047779083251953
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0005 0.00053000450134277
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
134 0.0006 0.00058913230895996
SELECT * FROM product_image_select WHERE product_id = '890'
135 0.0004 0.00043606758117676
SELECT * FROM productcustomimages WHERE product_id = '890'
136 0.0010 0.0010480880737305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
137 0.0005 0.0004580020904541
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0004 0.00044989585876465
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0006 0.00058197975158691
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
141 0.0006 0.00064802169799805
SELECT * FROM product_image_select WHERE product_id = '858'
142 0.0004 0.00040221214294434
SELECT * FROM productcustomimages WHERE product_id = '858'
143 0.0013 0.0012691020965576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
144 0.0005 0.00046300888061523
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00038409233093262
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00044417381286621
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0006 0.0005650520324707
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
148 0.0006 0.0006110668182373
SELECT * FROM product_image_select WHERE product_id = '869'
149 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '869'
150 0.0011 0.0011019706726074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
151 0.0005 0.00054311752319336
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00048589706420898
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0005 0.00049209594726562
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0006 0.00055909156799316
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
155 0.0006 0.00062298774719238
SELECT * FROM product_image_select WHERE product_id = '862'
156 0.0004 0.00042510032653809
SELECT * FROM productcustomimages WHERE product_id = '862'
157 0.0010 0.0010440349578857
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
158 0.0006 0.00059199333190918
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.00049591064453125
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00050878524780273
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
162 0.0008 0.00076508522033691
SELECT * FROM product_image_select WHERE product_id = '865'
163 0.0005 0.00054407119750977
SELECT * FROM productcustomimages WHERE product_id = '865'
164 0.0011 0.001072883605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
165 0.0006 0.00059199333190918
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0005 0.00053000450134277
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0005 0.00049686431884766
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0005 0.00049996376037598
SELECT id,asin FROM products WHERE parent_id = 915
169 0.0020 0.0019729137420654
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '915' ORDER BY timestamp DESC
170 0.0006 0.00059199333190918
SELECT category_id FROM products_categories WHERE product_id = '915'
171 0.0005 0.00047397613525391
SELECT * FROM categories WHERE id = '27'
172 0.0055 0.0054810047149658
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.00045490264892578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
174 0.0004 0.00035285949707031
SELECT id FROM categories WHERE parent_id = '27'
175 0.0055 0.0054829120635986
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.0008 0.00077605247497559
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.00058102607727051
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.0006 0.00058794021606445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
179 0.0010 0.00098800659179688
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.00055193901062012
SELECT * FROM productoffers WHERE product_id = '915' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '915' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = 915
                ORDER BY price ASC LIMIT 1
183 0.0005 0.00046896934509277
SELECT value FROM productattributes
                WHERE product_id = '915'
                AND name = 'ListPriceAmount'
184 0.0006 0.00057697296142578
SELECT * FROM products WHERE id = '915'
185 0.0005 0.00053811073303223
SELECT value FROM productattributes WHERE product_id = '915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0008 0.00079894065856934
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.00043702125549316
SELECT * FROM productoffers WHERE product_id = '915' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00036907196044922
SELECT * FROM productoffers
                WHERE product_id = '915' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = 915
                ORDER BY price ASC LIMIT 1
190 0.0003 0.00034308433532715
SELECT value FROM productattributes
                WHERE product_id = '915'
                AND name = 'ListPriceAmount'
191 0.0005 0.00053310394287109
SELECT category_id FROM products_categories WHERE product_id = '915' AND prod_type = 'amz'
192 0.0005 0.00051212310791016
SELECT parent_id FROM categories WHERE id = '27'
193 0.0004 0.00036287307739258
SELECT * FROM categories WHERE id = '27'
194 0.0039 0.0038928985595703
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.00045990943908691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
196 0.0004 0.00036406517028809
SELECT id FROM categories WHERE parent_id = '27'
197 0.0035 0.00347900390625
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.0006 0.00057888031005859
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.0005 0.00046801567077637
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.0004 0.00043797492980957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
201 0.0016 0.0015571117401123
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
202 0.0024 0.0024011135101318
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
203 0.0004 0.00035500526428223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
204 0.0131 0.013097047805786
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.0016 0.0016210079193115
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.0005 0.0005030632019043
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.0005 0.00049281120300293
SELECT * FROM products WHERE id = 1626
208 0.0005 0.00051784515380859
SELECT * FROM products WHERE id = 4041
209 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = 4312
210 0.0004 0.00044679641723633
SELECT * FROM products WHERE id = 777
211 0.0005 0.00048995018005371
SELECT * FROM products WHERE id = 3881
212 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = 4213
213 0.0009 0.00094294548034668
SELECT * FROM products WHERE id = '1626'
214 0.0010 0.0010228157043457
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
215 0.0013 0.0013079643249512
SELECT * FROM product_image_select WHERE product_id = '1626'
216 0.0009 0.00088286399841309
SELECT * FROM productcustomimages WHERE product_id = '1626'
217 0.0019 0.0018510818481445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
218 0.0009 0.00091910362243652
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0007 0.00072002410888672
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0011 0.0010769367218018
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0010 0.0010359287261963
SELECT * FROM products WHERE id = '4041'
222 0.0011 0.0011050701141357
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
223 0.0014 0.0014448165893555
SELECT * FROM product_image_select WHERE product_id = '4041'
224 0.0007 0.0007178783416748
SELECT * FROM productcustomimages WHERE product_id = '4041'
225 0.0028 0.0027980804443359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
226 0.0009 0.00093507766723633
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0007 0.00068521499633789
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0007 0.00065493583679199
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0008 0.00077700614929199
SELECT * FROM products WHERE id = '4312'
230 0.0007 0.00070500373840332
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
231 0.0011 0.0011389255523682
SELECT * FROM product_image_select WHERE product_id = '4312'
232 0.0006 0.00061798095703125
SELECT * FROM productcustomimages WHERE product_id = '4312'
233 0.0026 0.0026140213012695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
234 0.0008 0.00076508522033691
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0006 0.00062298774719238
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0007 0.00066208839416504
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0008 0.0007939338684082
SELECT * FROM products WHERE id = '777'
238 0.0006 0.00060915946960449
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
239 0.0008 0.00081682205200195
SELECT * FROM product_image_select WHERE product_id = '777'
240 0.0005 0.00049304962158203
SELECT * FROM productcustomimages WHERE product_id = '777'
241 0.0015 0.0014960765838623
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.00059914588928223
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0006 0.00055408477783203
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0008 0.00079798698425293
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0007 0.00069284439086914
SELECT * FROM products WHERE id = '3881'
246 0.0008 0.00084304809570312
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
247 0.0008 0.00077080726623535
SELECT * FROM product_image_select WHERE product_id = '3881'
248 0.0005 0.00050497055053711
SELECT * FROM productcustomimages WHERE product_id = '3881'
249 0.0017 0.0017039775848389
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
250 0.0005 0.00052809715270996
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0005 0.00053620338439941
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0006 0.00057101249694824
SELECT * FROM products WHERE id = '4213'
254 0.0006 0.00063514709472656
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
255 0.0008 0.0008389949798584
SELECT * FROM product_image_select WHERE product_id = '4213'
256 0.0005 0.00045490264892578
SELECT * FROM productcustomimages WHERE product_id = '4213'
257 0.0014 0.0013678073883057
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
258 0.0005 0.00053000450134277
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0006 0.00058102607727051
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0023 0.0023059844970703
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
262 0.0007 0.00072693824768066
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
263 0.0026 0.0026431083679199
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
264 0.0019 0.0018570423126221
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
265 0.0005 0.00054001808166504
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0006 0.00064682960510254
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'