0

Dragonfly Rooibos Earl Grey Tea 40 per pack

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-10 00:26:59 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. Earl Grey

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.4799740314484 261 1.0704 0


No Amazon API Requests Made.


App Debug - Total Time 1.4799740314484 seconds

Number Time From Start Name Description
1 0.37603402137756 Initialise Initialise FSB Function
2 0.3802490234375 App Controller Start Start of the App controller (called before the controller of every page)
3 0.41328501701355 Start of getCategoryListByGroup Function Before first category groups query
4 0.41515111923218 After initial query Before first category groups query
5 0.41515207290649 Get Category List for Group Before the call to getCategoryList function
6 0.41515398025513 Start of GetCategoryList function Start of the function
7 0.41515588760376 Before getting categories Query to get specific category list
8 0.41717195510864 After getting categories Query to get specific category list
9 0.41717290878296 Before getting category custom Before call to function getCategoryCustom
10 0.44530200958252 After getting category custom After call to function getCategoryCustom
11 0.44530391693115 Before getting category custom Before call to function getCategoryCustom
12 0.45744299888611 After getting category custom After call to function getCategoryCustom
13 0.45744490623474 Before getting category custom Before call to function getCategoryCustom
14 0.46324300765991 After getting category custom After call to function getCategoryCustom
15 0.46324396133423 Before getting category custom Before call to function getCategoryCustom
16 0.46734690666199 After getting category custom After call to function getCategoryCustom
17 0.4673490524292 Before getting category custom Before call to function getCategoryCustom
18 0.47136497497559 After getting category custom After call to function getCategoryCustom
19 0.4713659286499 Before getting category custom Before call to function getCategoryCustom
20 0.47532510757446 After getting category custom After call to function getCategoryCustom
21 0.47532606124878 End of GetCategoryList function End of the function
22 0.47533106803894 Get Category List for Group Before the call to getCategoryList function
23 0.47533202171326 Start of GetCategoryList function Start of the function
24 0.47533297538757 Before getting categories Query to get specific category list
25 0.47576308250427 End of getCategoryListByGroup Function Before return()
26 1.2775499820709 App Controller End End of the App controller (called before the controller of every page)
27 1.2780721187592 Product Start Start of the product info controller
28 1.2820379734039 Cache file not found Starting get product details
29 1.3158769607544 Related products Start getting related products if enabled
30 1.3158779144287 Related Products Start Before the related products are found
31 1.3158779144287 Related Products Keywords Before the related product keywords are found
32 1.3158841133118 Create Keyword List Function Start of function
33 1.3159039020538 Create Keyword List Function After looping provided content - 21 keywords found
34 1.3162479400635 Create Keyword List Function After looping initial keyword list - 18 keywords remaining
35 1.3162529468536 Create Keyword List Function After reducing keyword list
36 1.3162770271301 Create Keyword List Function After selecting by scoring keywords
37 1.3162798881531 Create Keyword List Function After final loop of keywords
38 1.316281080246 Related Products Keywords After the related product keywords are found
39 1.3472731113434 Related Products End After the related products are found
40 1.3764801025391 Product End End of the product info controller (Product Info)
41 1.3783819675446 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.379998922348 Before Get Options Before the call to getOptions in the tpl class
43 1.4287130832672 After Get Options After the call to getOptions in the tpl class
44 1.4287838935852 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4288039207458 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4522390365601 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4522409439087 Product Info: Before Template Display Before the template is displayed
48 1.4799530506134 Product Info: After Template Display After the template is displayed
49 1.4799630641937 Finalizing debug Before the debug is output to the page.
50 1.4799740314484 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 1.0704 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0048 0.0047919750213623
SELECT parameter, value FROM parameters
2 0.0105 0.010501861572266
SELECT * FROM `bad_bots`
3 0.0006 0.00064206123352051
SET time_zone = 'Europe/London'
4 0.0036 0.0035648345947266
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0025 0.0024521350860596
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.117.87.50\";}'
6 0.0017 0.0017440319061279
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745065510'
7 0.0024 0.0024020671844482
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00039315223693848
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0016 0.0015699863433838
SELECT id FROM pages WHERE pagename = 'dragonfly-rooibos-earl-grey-tea-40-per-pack' LIMIT 1
10 0.0018 0.0017759799957275
SELECT id FROM products WHERE pagename = 'dragonfly-rooibos-earl-grey-tea-40-per-pack' AND hidden = 0 LIMIT 1
11 0.0022 0.0022380352020264
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0297 0.02972412109375
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00069689750671387
SELECT * FROM pages WHERE pagename = 'dragonfly-rooibos-earl-grey-tea-40-per-pack'
14 0.0019 0.0018560886383057
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0020 0.0020058155059814
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0093 0.0092809200286865
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.0025 0.0024700164794922
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.0015 0.0015239715576172
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00052380561828613
SELECT id FROM categories WHERE parent_id = '26'
20 0.0081 0.0080690383911133
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.0021028518676758
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.0020 0.0020029544830322
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.0015988349914551
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00049710273742676
SELECT * FROM categorygroups WHERE id = '1'
25 0.0042 0.0042479038238525
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.0005 0.0004889965057373
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.00044488906860352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00049281120300293
SELECT id FROM categories WHERE parent_id = '27'
29 0.0046 0.0046260356903076
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.0005 0.00050210952758789
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.0005 0.00049090385437012
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.0004 0.00044083595275879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00037002563476562
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014379024505615
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.00040602684020996
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.00036501884460449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00035285949707031
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015649795532227
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.0004 0.00043916702270508
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.0005 0.0004570484161377
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.0004 0.00038504600524902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00036382675170898
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00055503845214844
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.00047898292541504
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.0003 0.00032496452331543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00067591667175293
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.0004 0.00041103363037109
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.00046801567077637
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.0004 0.0003969669342041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.0003960132598877
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00056600570678711
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.0004 0.00041103363037109
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.0003 0.00034880638122559
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.0003809928894043
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00066304206848145
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.0004 0.00043296813964844
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.0004 0.00041484832763672
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.0004 0.00042581558227539
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00034213066101074
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00054097175598145
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.0004 0.00040602684020996
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.00036382675170898
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00035905838012695
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00066304206848145
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.0004 0.0004420280456543
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.0004 0.00042295455932617
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.0004 0.00040793418884277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00032711029052734
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00042605400085449
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0027 0.0026791095733643
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0015 0.0015158653259277
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00050210952758789
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.0013 0.0013461112976074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011208057403564
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0007 0.00074911117553711
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7883 0.78831696510315
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.87.50') >= INET_ATON(ip_start) AND INET_ATON('18.117.87.50') <= INET_ATON(ip_end)
78 0.0026 0.0025839805603027
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0015 0.0015270709991455
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00066304206848145
SELECT * FROM products WHERE pagename = 'dragonfly-rooibos-earl-grey-tea-40-per-pack'
81 0.0006 0.00057101249694824
UPDATE products SET viewcount = viewcount + 1 WHERE id = 903
82 0.0004 0.00044894218444824
SELECT * FROM manufacturers WHERE id = '243'
83 0.0005 0.00049591064453125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
84 0.0013 0.0012609958648682
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '243' LIMIT 1
85 0.0016 0.0015549659729004
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.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '1674' ORDER BY sortorder ASC
87 0.0004 0.00043511390686035
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '243'
88 0.0005 0.00050997734069824
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.00040984153747559
SELECT * FROM manufacturerimages WHERE manufacturer_id = '243'
90 0.0005 0.00047612190246582
SELECT category_id FROM products_categories WHERE product_id = '903'
91 0.0004 0.00038909912109375
SELECT * FROM categories WHERE id = '27'
92 0.0038 0.0038070678710938
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.0003 0.00034999847412109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.0003359317779541
SELECT id FROM categories WHERE parent_id = '27'
95 0.0042 0.0042169094085693
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.00045895576477051
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.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
98 0.0004 0.00038909912109375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0004 0.00040292739868164
SELECT * FROM productimages WHERE product_id = '903' ORDER BY sortorder ASC
100 0.0014 0.0014340877532959
SELECT * FROM product_image_select WHERE product_id = '903'
101 0.0011 0.0011420249938965
SELECT * FROM productcustomimages WHERE product_id = '903'
102 0.0011 0.0010719299316406
SELECT * FROM productfeeds WHERE product_id = '903' ORDER BY item_date DESC
103 0.0022 0.0021669864654541
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '903' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0021 0.0020909309387207
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '903' AND t.hidden = 0 AND display_product = 1
105 0.0003 0.00028419494628906
SELECT * FROM tags WHERE id = '15'
106 0.0012 0.001194953918457
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.0008 0.00077199935913086
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.0008 0.00082707405090332
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.0005 0.00047111511230469
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
110 0.0013 0.001276969909668
SELECT * FROM productamazoncontent WHERE product_id = '903'
111 0.0008 0.00076198577880859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '903' AND a.name = n.originalname
112 0.0012 0.0012381076812744
SELECT * FROM productoffers WHERE product_id = '903' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '903' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0003 0.00028800964355469
SELECT * FROM productoffers
                WHERE product_id = 903
                ORDER BY price ASC LIMIT 1
115 0.0005 0.00047898292541504
SELECT value FROM productattributes
                WHERE product_id = '903'
                AND name = 'ListPriceAmount'
116 0.0004 0.00040984153747559
SELECT value FROM productattributes WHERE product_id = '903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0004 0.00041699409484863
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.0097 0.0097119808197021
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 903 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119 0.0005 0.00052499771118164
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 903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
120 0.0005 0.00048995018005371
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 903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0004 0.00040507316589355
SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
122 0.0006 0.00056195259094238
SELECT * FROM product_image_select WHERE product_id = '2290'
123 0.0003 0.00032281875610352
SELECT * FROM productcustomimages WHERE product_id = '2290'
124 0.0009 0.00092387199401855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
125 0.0008 0.00080418586730957
SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = '2290' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0004 0.00037288665771484
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
129 0.0005 0.00054812431335449
SELECT * FROM product_image_select WHERE product_id = '938'
130 0.0003 0.00032496452331543
SELECT * FROM productcustomimages WHERE product_id = '938'
131 0.0008 0.00079798698425293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
132 0.0004 0.00044107437133789
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00033807754516602
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00049614906311035
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
136 0.0005 0.00047898292541504
SELECT * FROM product_image_select WHERE product_id = '858'
137 0.0003 0.00031590461730957
SELECT * FROM productcustomimages WHERE product_id = '858'
138 0.0010 0.00097322463989258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
139 0.0004 0.00042891502380371
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0003 0.0003349781036377
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0004 0.00042009353637695
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
143 0.0005 0.00049686431884766
SELECT * FROM product_image_select WHERE product_id = '2521'
144 0.0003 0.00031805038452148
SELECT * FROM productcustomimages WHERE product_id = '2521'
145 0.0008 0.00075793266296387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
146 0.0004 0.00039482116699219
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0003 0.00034594535827637
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00035405158996582
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0004 0.00040602684020996
SELECT * FROM productimages WHERE product_id = '1251' ORDER BY sortorder ASC
150 0.0005 0.00049901008605957
SELECT * FROM product_image_select WHERE product_id = '1251'
151 0.0003 0.00028896331787109
SELECT * FROM productcustomimages WHERE product_id = '1251'
152 0.0010 0.00097298622131348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1251' AND a.name = n.originalname
153 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '1251' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = '1251' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '1251' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0004 0.00042009353637695
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
157 0.0005 0.00050187110900879
SELECT * FROM product_image_select WHERE product_id = '4954'
158 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '4954'
159 0.0008 0.00080299377441406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
160 0.0004 0.00041317939758301
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0003 0.00034189224243164
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0004 0.00043320655822754
SELECT id,asin FROM products WHERE parent_id = 903
164 0.0018 0.0018489360809326
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '903' ORDER BY timestamp DESC
165 0.0007 0.00065994262695312
SELECT category_id FROM products_categories WHERE product_id = '903'
166 0.0004 0.00037384033203125
SELECT * FROM categories WHERE id = '27'
167 0.0045 0.0044779777526855
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.0007 0.0006859302520752
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169 0.0004 0.00042891502380371
SELECT id FROM categories WHERE parent_id = '27'
170 0.0037 0.0037250518798828
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.0005 0.00047206878662109
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.0005 0.00048112869262695
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.0005 0.00050210952758789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174 0.0008 0.00075602531433105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '903' AND a.name = n.originalname
175 0.0004 0.00043296813964844
SELECT * FROM productoffers WHERE product_id = '903' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0003 0.0003361701965332
SELECT * FROM productoffers
                WHERE product_id = '903' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = 903
                ORDER BY price ASC LIMIT 1
178 0.0003 0.0003199577331543
SELECT value FROM productattributes
                WHERE product_id = '903'
                AND name = 'ListPriceAmount'
179 0.0005 0.00046586990356445
SELECT * FROM products WHERE id = '903'
180 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0005 0.00053286552429199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '903' AND a.name = n.originalname
182 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '903' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0003 0.00028896331787109
SELECT * FROM productoffers
                WHERE product_id = '903' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = 903
                ORDER BY price ASC LIMIT 1
185 0.0003 0.00031495094299316
SELECT value FROM productattributes
                WHERE product_id = '903'
                AND name = 'ListPriceAmount'
186 0.0003 0.00034904479980469
SELECT category_id FROM products_categories WHERE product_id = '903' AND prod_type = 'amz'
187 0.0004 0.00036501884460449
SELECT parent_id FROM categories WHERE id = '27'
188 0.0003 0.00026893615722656
SELECT * FROM categories WHERE id = '27'
189 0.0036 0.0035991668701172
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.0004 0.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191 0.0003 0.00032210350036621
SELECT id FROM categories WHERE parent_id = '27'
192 0.0036 0.0035989284515381
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.0005 0.00049209594726562
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.0005 0.00046014785766602
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.0004 0.0004270076751709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196 0.0014 0.0014350414276123
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0013 0.0012950897216797
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0003 0.00028681755065918
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0128 0.012797832489014
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.0016 0.0016379356384277
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.0005 0.00047492980957031
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.0005 0.00047421455383301
SELECT * FROM products WHERE id = 1626
203 0.0004 0.00040793418884277
SELECT * FROM products WHERE id = 4041
204 0.0004 0.0003659725189209
SELECT * FROM products WHERE id = 4312
205 0.0004 0.00042009353637695
SELECT * FROM products WHERE id = 777
206 0.0004 0.00038313865661621
SELECT * FROM products WHERE id = 3881
207 0.0004 0.0003960132598877
SELECT * FROM products WHERE id = 4213
208 0.0003 0.00032401084899902
SELECT * FROM products WHERE id = '1626'
209 0.0005 0.00046682357788086
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0005 0.00050091743469238
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0003 0.00032496452331543
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0008 0.00078320503234863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0004 0.00040984153747559
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0003 0.0003209114074707
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0004 0.00040602684020996
SELECT * FROM products WHERE id = '4041'
217 0.0005 0.00047183036804199
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0005 0.00049805641174316
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0003 0.00032496452331543
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0010 0.0010240077972412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0003 0.00033283233642578
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0004 0.00044989585876465
SELECT * FROM products WHERE id = '4312'
225 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0005 0.00053191184997559
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0003 0.00032401084899902
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0010 0.00098395347595215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0004 0.00041508674621582
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0004 0.00036311149597168
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0004 0.00035786628723145
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0004 0.00042510032653809
SELECT * FROM products WHERE id = '777'
233 0.0004 0.00040698051452637
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0005 0.00054001808166504
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0003 0.00034189224243164
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0009 0.00093793869018555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0004 0.00043296813964844
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0005 0.00047421455383301
SELECT * FROM products WHERE id = '3881'
241 0.0004 0.00043916702270508
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0006 0.00059294700622559
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0003 0.00031518936157227
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0010 0.0010218620300293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0004 0.00042581558227539
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0005 0.00046491622924805
SELECT * FROM products WHERE id = '4213'
249 0.0004 0.0004420280456543
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0005 0.00050902366638184
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0003 0.00032997131347656
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0011 0.0011229515075684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0005 0.0005190372467041
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0003 0.00034093856811523
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0004 0.00035285949707031
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0017 0.0017220973968506
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0006 0.00060200691223145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0025 0.0024549961090088
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0016 0.0015878677368164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0005 0.00047707557678223
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0008 0.00075888633728027
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'