0

Dragonfly Rooibos Breakfast Tea 40 per pack

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

Conserver dans un endroit frais et sec. Pays d'origine: Afrique du Sud. Petit-déjeuner anglais

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.2263150215149 261 0.7887 0


No Amazon API Requests Made.


App Debug - Total Time 1.2263150215149 seconds

Number Time From Start Name Description
1 0.40895390510559 Initialise Initialise FSB Function
2 0.41589593887329 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45565295219421 Start of getCategoryListByGroup Function Before first category groups query
4 0.45734405517578 After initial query Before first category groups query
5 0.45734596252441 Get Category List for Group Before the call to getCategoryList function
6 0.45734906196594 Start of GetCategoryList function Start of the function
7 0.4573540687561 Before getting categories Query to get specific category list
8 0.45802688598633 After getting categories Query to get specific category list
9 0.45802903175354 Before getting category custom Before call to function getCategoryCustom
10 0.47327709197998 After getting category custom After call to function getCategoryCustom
11 0.47328090667725 Before getting category custom Before call to function getCategoryCustom
12 0.4845130443573 After getting category custom After call to function getCategoryCustom
13 0.48451590538025 Before getting category custom Before call to function getCategoryCustom
14 0.49218201637268 After getting category custom After call to function getCategoryCustom
15 0.49218797683716 Before getting category custom Before call to function getCategoryCustom
16 0.4976749420166 After getting category custom After call to function getCategoryCustom
17 0.49767994880676 Before getting category custom Before call to function getCategoryCustom
18 0.50341010093689 After getting category custom After call to function getCategoryCustom
19 0.50341510772705 Before getting category custom Before call to function getCategoryCustom
20 0.50896191596985 After getting category custom After call to function getCategoryCustom
21 0.50896692276001 End of GetCategoryList function End of the function
22 0.50897789001465 Get Category List for Group Before the call to getCategoryList function
23 0.50898098945618 Start of GetCategoryList function Start of the function
24 0.50898504257202 Before getting categories Query to get specific category list
25 0.50955891609192 End of getCategoryListByGroup Function Before return()
26 0.95574998855591 App Controller End End of the App controller (called before the controller of every page)
27 0.95642900466919 Product Start Start of the product info controller
28 0.95830893516541 Cache file not found Starting get product details
29 0.99396800994873 Related products Start getting related products if enabled
30 0.99397110939026 Related Products Start Before the related products are found
31 0.99397301673889 Related Products Keywords Before the related product keywords are found
32 0.99397993087769 Create Keyword List Function Start of function
33 0.99411106109619 Create Keyword List Function After looping provided content - 18 keywords found
34 0.99518799781799 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
35 0.99519801139832 Create Keyword List Function After reducing keyword list
36 0.99526190757751 Create Keyword List Function After selecting by scoring keywords
37 0.99526810646057 Create Keyword List Function After final loop of keywords
38 0.99527096748352 Related Products Keywords After the related product keywords are found
39 1.0570390224457 Related Products End After the related products are found
40 1.0941250324249 Product End End of the product info controller (Product Info)
41 1.0966939926147 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.0993750095367 Before Get Options Before the call to getOptions in the tpl class
43 1.1883749961853 After Get Options After the call to getOptions in the tpl class
44 1.1886138916016 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.1886610984802 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.1943900585175 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.1943950653076 Product Info: Before Template Display Before the template is displayed
48 1.2262830734253 Product Info: After Template Display After the template is displayed
49 1.2262980937958 Finalizing debug Before the debug is output to the page.
50 1.2263140678406 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 0.7887 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0020 0.0020210742950439
SELECT parameter, value FROM parameters
2 0.0084 0.0083858966827393
SELECT * FROM `bad_bots`
3 0.0004 0.00040888786315918
SET time_zone = 'Europe/London'
4 0.0010 0.0010080337524414
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0037 0.0037219524383545
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.191.181.118\";}'
6 0.0033 0.0033190250396729
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738749195'
7 0.0042 0.0041968822479248
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010969638824463
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0040 0.0040090084075928
SELECT id FROM pages WHERE pagename = 'dragonfly-rooibos-breakfast-tea-40-per-pack' LIMIT 1
10 0.0012 0.0011541843414307
SELECT id FROM products WHERE pagename = 'dragonfly-rooibos-breakfast-tea-40-per-pack' AND hidden = 0 LIMIT 1
11 0.0057 0.0057389736175537
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0323 0.032340049743652
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0009 0.00092291831970215
SELECT * FROM pages WHERE pagename = 'dragonfly-rooibos-breakfast-tea-40-per-pack'
14 0.0017 0.0016758441925049
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00065207481384277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0058 0.0058300495147705
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.0006 0.00057387351989746
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.0005 0.00046992301940918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00046610832214355
SELECT id FROM categories WHERE parent_id = '26'
20 0.0055 0.0055341720581055
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0006 0.00059103965759277
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.0006 0.00058507919311523
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.0006 0.00057697296142578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00045108795166016
SELECT * FROM categorygroups WHERE id = '1'
25 0.0037 0.0036990642547607
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.00056099891662598
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.0004 0.0004420280456543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00045108795166016
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.003741979598999
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.00058722496032715
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.00061392784118652
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0006 0.00056314468383789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00044608116149902
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.001723051071167
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.00064706802368164
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.0005 0.0004889965057373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.00057101249694824
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0016670227050781
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.0006 0.00062704086303711
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.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 (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0006 0.00059700012207031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00051593780517578
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.0007479190826416
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.0006 0.00060701370239258
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.0005 0.00052690505981445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00047612190246582
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00077104568481445
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.00053310394287109
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.0006 0.00061988830566406
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.00057482719421387
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00046801567077637
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00071597099304199
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.0005 0.00054097175598145
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.0006 0.0005650520324707
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00046801567077637
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00078892707824707
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.0005500316619873
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.00068998336791992
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.00072789192199707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00052809715270996
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.0007779598236084
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.0005 0.00053691864013672
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.00046491622924805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00046801567077637
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00094413757324219
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.00057101249694824
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.00057387351989746
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.0005 0.00052618980407715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00052309036254883
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00055694580078125
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0035 0.0035321712493896
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0018 0.0018329620361328
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00064492225646973
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.0014 0.0013608932495117
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.0013148784637451
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0011448860168457
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4308 0.43075203895569
SELECT * FROM ipgeocountries WHERE INET_ATON('18.191.181.118') >= INET_ATON(ip_start) AND INET_ATON('18.191.181.118') <= INET_ATON(ip_end)
78 0.0025 0.0024511814117432
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0013830661773682
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00075817108154297
SELECT * FROM products WHERE pagename = 'dragonfly-rooibos-breakfast-tea-40-per-pack'
81 0.0004 0.00044012069702148
UPDATE products SET viewcount = viewcount + 1 WHERE id = 900
82 0.0005 0.00050902366638184
SELECT * FROM manufacturers WHERE id = '243'
83 0.0006 0.00056791305541992
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
84 0.0015 0.0014688968658447
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
85 0.0008 0.0008399486541748
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '243' ORDER BY RAND() LIMIT 1
86 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '1448' ORDER BY sortorder ASC
87 0.0006 0.00058317184448242
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
88 0.0006 0.00057792663574219
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '243'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00036787986755371
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
90 0.0005 0.00045895576477051
SELECT category_id FROM products_categories WHERE product_id = '900'
91 0.0005 0.00054812431335449
SELECT * FROM categories WHERE id = '27'
92 0.0034 0.0034279823303223
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0005 0.00050902366638184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00037193298339844
SELECT id FROM categories WHERE parent_id = '27'
95 0.0035 0.0035140514373779
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0006 0.00061917304992676
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.0007 0.0007479190826416
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0006 0.00055789947509766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00053095817565918
SELECT * FROM productimages WHERE product_id = '900' ORDER BY sortorder ASC
100 0.0006 0.00061893463134766
SELECT * FROM product_image_select WHERE product_id = '900'
101 0.0005 0.00049591064453125
SELECT * FROM productcustomimages WHERE product_id = '900'
102 0.0016 0.00160813331604
SELECT * FROM productfeeds WHERE product_id = '900' ORDER BY item_date DESC
103 0.0009 0.00086402893066406
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '900' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0030 0.0030281543731689
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '900' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00044393539428711
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.0010 0.0010170936584473
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.00099515914916992
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.0014 0.0013749599456787
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
110 0.0021 0.0021259784698486
SELECT * FROM productamazoncontent WHERE product_id = '900'
111 0.0013 0.0012698173522949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '900' AND a.name = n.originalname
112 0.0006 0.00062894821166992
SELECT * FROM productoffers WHERE product_id = '900' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = '900' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00041294097900391
SELECT * FROM productoffers
                WHERE product_id = 900
                ORDER BY price ASC LIMIT 1
115 0.0005 0.00046706199645996
SELECT value FROM productattributes
                WHERE product_id = '900'
                AND name = 'ListPriceAmount'
116 0.0005 0.00048494338989258
SELECT value FROM productattributes WHERE product_id = '900' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0006 0.00060796737670898
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
118 0.0095 0.0094799995422363
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 900 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0009 0.00094008445739746
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 900 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0015 0.0015058517456055
SELECT *, MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('40 per pack' IN BOOLEAN MODE) AND 900 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0013 0.0012860298156738
SELECT * FROM productimages WHERE product_id = '1251' ORDER BY sortorder ASC
122 0.0013 0.0013091564178467
SELECT * FROM product_image_select WHERE product_id = '1251'
123 0.0010 0.0010249614715576
SELECT * FROM productcustomimages WHERE product_id = '1251'
124 0.0030 0.002971887588501
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1251' AND a.name = n.originalname
125 0.0009 0.00092506408691406
SELECT * FROM productoffers WHERE product_id = '1251' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0007 0.00066995620727539
SELECT * FROM productoffers
                WHERE product_id = '1251' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0007 0.00072503089904785
SELECT value FROM productattributes WHERE product_id = '1251' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0009 0.00085806846618652
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
129 0.0012 0.0011880397796631
SELECT * FROM product_image_select WHERE product_id = '938'
130 0.0007 0.00067496299743652
SELECT * FROM productcustomimages WHERE product_id = '938'
131 0.0016 0.0016450881958008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
132 0.0009 0.0009300708770752
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0008 0.00079512596130371
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0008 0.00075101852416992
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0021 0.0021309852600098
SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
136 0.0038 0.0038199424743652
SELECT * FROM product_image_select WHERE product_id = '2290'
137 0.0008 0.00078892707824707
SELECT * FROM productcustomimages WHERE product_id = '2290'
138 0.0016 0.0016119480133057
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
139 0.0008 0.00080394744873047
SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0006 0.00057387351989746
SELECT * FROM productoffers
                WHERE product_id = '2290' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0007 0.0007481575012207
SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0008 0.00075411796569824
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
143 0.0012 0.0011930465698242
SELECT * FROM product_image_select WHERE product_id = '2521'
144 0.0006 0.00064492225646973
SELECT * FROM productcustomimages WHERE product_id = '2521'
145 0.0016 0.0015530586242676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
146 0.0009 0.00094985961914062
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0009 0.00092816352844238
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0007 0.00073099136352539
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0010 0.0010061264038086
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
150 0.0011 0.0010910034179688
SELECT * FROM product_image_select WHERE product_id = '858'
151 0.0008 0.00077104568481445
SELECT * FROM productcustomimages WHERE product_id = '858'
152 0.0027 0.0026729106903076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
153 0.0010 0.0010180473327637
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0007 0.00072479248046875
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0009 0.0009310245513916
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0010 0.0010128021240234
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
157 0.0011 0.0011241436004639
SELECT * FROM product_image_select WHERE product_id = '4954'
158 0.0007 0.00074100494384766
SELECT * FROM productcustomimages WHERE product_id = '4954'
159 0.0016 0.0016160011291504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
160 0.0007 0.00074195861816406
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0007 0.00068116188049316
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00064396858215332
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0007 0.00073981285095215
SELECT id,asin FROM products WHERE parent_id = 900
164 0.0026 0.0025508403778076
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '900' ORDER BY timestamp DESC
165 0.0007 0.00071001052856445
SELECT category_id FROM products_categories WHERE product_id = '900'
166 0.0006 0.00063610076904297
SELECT * FROM categories WHERE id = '27'
167 0.0054 0.0054149627685547
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
168 0.0006 0.0005791187286377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0004 0.00044012069702148
SELECT id FROM categories WHERE parent_id = '27'
170 0.0047 0.0047471523284912
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
171 0.0007 0.00069212913513184
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
172 0.0008 0.00078511238098145
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
173 0.0007 0.00066089630126953
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0011 0.001133918762207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '900' AND a.name = n.originalname
175 0.0006 0.0005950927734375
SELECT * FROM productoffers WHERE product_id = '900' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = '900' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = 900
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00041699409484863
SELECT value FROM productattributes
                WHERE product_id = '900'
                AND name = 'ListPriceAmount'
179 0.0006 0.00061488151550293
SELECT * FROM products WHERE id = '900'
180 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '900' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0007 0.00066995620727539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '900' AND a.name = n.originalname
182 0.0004 0.00039505958557129
SELECT * FROM productoffers WHERE product_id = '900' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '900' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00037908554077148
SELECT * FROM productoffers
                WHERE product_id = 900
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00041818618774414
SELECT value FROM productattributes
                WHERE product_id = '900'
                AND name = 'ListPriceAmount'
186 0.0005 0.0005490779876709
SELECT category_id FROM products_categories WHERE product_id = '900' AND prod_type = 'amz'
187 0.0005 0.00045299530029297
SELECT parent_id FROM categories WHERE id = '27'
188 0.0004 0.00036811828613281
SELECT * FROM categories WHERE id = '27'
189 0.0040 0.0039668083190918
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
190 0.0005 0.0005490779876709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '27'
192 0.0037 0.0037498474121094
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
193 0.0007 0.00072097778320312
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
194 0.0007 0.00070095062255859
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
195 0.0006 0.00059294700622559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0020 0.0019919872283936
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0015 0.001492977142334
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0010 0.0010459423065186
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0184 0.018395900726318
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
200 0.0067 0.0067410469055176
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
201 0.0008 0.00078296661376953
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
202 0.0010 0.00095486640930176
SELECT * FROM products WHERE id = 1626
203 0.0006 0.00058603286743164
SELECT * FROM products WHERE id = 4041
204 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = 4312
205 0.0013 0.0012779235839844
SELECT * FROM products WHERE id = 777
206 0.0010 0.00097918510437012
SELECT * FROM products WHERE id = 3881
207 0.0007 0.00073695182800293
SELECT * FROM products WHERE id = 4213
208 0.0007 0.00071382522583008
SELECT * FROM products WHERE id = '1626'
209 0.0011 0.0010929107666016
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0014 0.0013890266418457
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0007 0.00073790550231934
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0018 0.0017580986022949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0009 0.00091195106506348
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0008 0.00080180168151855
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0008 0.00083494186401367
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0010 0.00097179412841797
SELECT * FROM products WHERE id = '4041'
217 0.0009 0.00085687637329102
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0012 0.0012199878692627
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0007 0.00067615509033203
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0022 0.0021560192108154
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0008 0.00079798698425293
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0007 0.00073599815368652
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0007 0.00068402290344238
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0010 0.0010011196136475
SELECT * FROM products WHERE id = '4312'
225 0.0009 0.00085282325744629
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0011 0.001060962677002
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0007 0.00066089630126953
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0019 0.0018930435180664
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0008 0.00081801414489746
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0006 0.00061988830566406
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0007 0.00067996978759766
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0008 0.00082898139953613
SELECT * FROM products WHERE id = '777'
233 0.0008 0.00080299377441406
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0011 0.0010740756988525
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0007 0.00072908401489258
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0019 0.0019071102142334
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0008 0.00078105926513672
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0006 0.00062704086303711
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0006 0.00061893463134766
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0008 0.00082898139953613
SELECT * FROM products WHERE id = '3881'
241 0.0008 0.00076007843017578
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0009 0.00087809562683105
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0005 0.0005190372467041
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0018 0.0018270015716553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0008 0.00082302093505859
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0007 0.00066781044006348
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0007 0.00065398216247559
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0009 0.00086283683776855
SELECT * FROM products WHERE id = '4213'
249 0.0007 0.00073599815368652
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0009 0.00086212158203125
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0005 0.00054502487182617
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0016 0.0015978813171387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0006 0.0006411075592041
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0007 0.00069904327392578
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0006 0.0005950927734375
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0029 0.0029129981994629
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0009 0.0008690357208252
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0032 0.003242015838623
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0022 0.0021710395812988
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0007 0.00071310997009277
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0008 0.00079894065856934
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'