0

Uncle Lee's Imperial Organic Vanilla Rooibos (1x18 Tea Bags)

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-24 06:27:29 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4710850715637 256 1.0742 0


No Amazon API Requests Made.


App Debug - Total Time 1.4710850715637 seconds

Number Time From Start Name Description
1 0.3739001750946 Initialise Initialise FSB Function
2 0.3849630355835 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42801117897034 Start of getCategoryListByGroup Function Before first category groups query
4 0.42971706390381 After initial query Before first category groups query
5 0.42971801757812 Get Category List for Group Before the call to getCategoryList function
6 0.42972016334534 Start of GetCategoryList function Start of the function
7 0.42972207069397 Before getting categories Query to get specific category list
8 0.43124604225159 After getting categories Query to get specific category list
9 0.4312469959259 Before getting category custom Before call to function getCategoryCustom
10 0.45079708099365 After getting category custom After call to function getCategoryCustom
11 0.45079922676086 Before getting category custom Before call to function getCategoryCustom
12 0.46097421646118 After getting category custom After call to function getCategoryCustom
13 0.4609751701355 Before getting category custom Before call to function getCategoryCustom
14 0.46735501289368 After getting category custom After call to function getCategoryCustom
15 0.46735620498657 Before getting category custom Before call to function getCategoryCustom
16 0.47143316268921 After getting category custom After call to function getCategoryCustom
17 0.47143411636353 Before getting category custom Before call to function getCategoryCustom
18 0.4756920337677 After getting category custom After call to function getCategoryCustom
19 0.4756920337677 Before getting category custom Before call to function getCategoryCustom
20 0.48067307472229 After getting category custom After call to function getCategoryCustom
21 0.48067402839661 End of GetCategoryList function End of the function
22 0.48067808151245 Get Category List for Group Before the call to getCategoryList function
23 0.48067903518677 Start of GetCategoryList function Start of the function
24 0.48068022727966 Before getting categories Query to get specific category list
25 0.48112010955811 End of getCategoryListByGroup Function Before return()
26 1.2706642150879 App Controller End End of the App controller (called before the controller of every page)
27 1.2711520195007 Product Start Start of the product info controller
28 1.2726712226868 Cache file not found Starting get product details
29 1.308666229248 Related products Start getting related products if enabled
30 1.3086671829224 Related Products Start Before the related products are found
31 1.3086671829224 Related Products Keywords Before the related product keywords are found
32 1.3086700439453 Create Keyword List Function Start of function
33 1.3086891174316 Create Keyword List Function After looping provided content - 24 keywords found
34 1.3091061115265 Create Keyword List Function After looping initial keyword list - 23 keywords remaining
35 1.3091111183167 Create Keyword List Function After reducing keyword list
36 1.3091361522675 Create Keyword List Function After selecting by scoring keywords
37 1.3091380596161 Create Keyword List Function After final loop of keywords
38 1.3091390132904 Related Products Keywords After the related product keywords are found
39 1.3410642147064 Related Products End After the related products are found
40 1.3686871528625 Product End End of the product info controller (Product Info)
41 1.3705220222473 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3720400333405 Before Get Options Before the call to getOptions in the tpl class
43 1.4284780025482 After Get Options After the call to getOptions in the tpl class
44 1.428551197052 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.428572177887 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4367451667786 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4367470741272 Product Info: Before Template Display Before the template is displayed
48 1.4710690975189 Product Info: After Template Display After the template is displayed
49 1.4710772037506 Finalizing debug Before the debug is output to the page.
50 1.4710841178894 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 1.0742 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022070407867432
SELECT parameter, value FROM parameters
2 0.0095 0.0095291137695312
SELECT * FROM `bad_bots`
3 0.0004 0.00042104721069336
SET time_zone = 'Europe/London'
4 0.0033 0.0033020973205566
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0031 0.003119945526123
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.191.37.17\";}'
6 0.0030 0.0030090808868408
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746110036'
7 0.0039 0.003856897354126
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0021 0.0021309852600098
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0050 0.0049519538879395
SELECT id FROM pages WHERE pagename = 'uncle-lees-imperial-organic-vanilla-rooibos-1x18-tea-bags' LIMIT 1
10 0.0033 0.003324031829834
SELECT id FROM products WHERE pagename = 'uncle-lees-imperial-organic-vanilla-rooibos-1x18-tea-bags' AND hidden = 0 LIMIT 1
11 0.0037 0.0037291049957275
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0384 0.038406848907471
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00062203407287598
SELECT * FROM pages WHERE pagename = 'uncle-lees-imperial-organic-vanilla-rooibos-1x18-tea-bags'
14 0.0017 0.0017008781433105
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0015 0.001514196395874
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0063 0.0063371658325195
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.0015 0.0015439987182617
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.0011 0.0011489391326904
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '26'
20 0.0054 0.0054318904876709
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.0014 0.0014219284057617
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.0015 0.001450777053833
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.0013 0.0012960433959961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00043606758117676
SELECT * FROM categorygroups WHERE id = '1'
25 0.0035 0.0034770965576172
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.00046110153198242
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.00042414665222168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00040698051452637
SELECT id FROM categories WHERE parent_id = '27'
29 0.0036 0.0035669803619385
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.00045394897460938
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.0005030632019043
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.00045990943908691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00039196014404297
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0013630390167236
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.0004420280456543
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.0008 0.00080394744873047
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00041604042053223
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015130043029785
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.0005 0.00047516822814941
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.00049996376037598
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0005 0.00046586990356445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00037598609924316
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00052285194396973
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.0004 0.00041985511779785
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.0003809928894043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00038409233093262
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00069808959960938
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.00044417381286621
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.0004 0.00044608116149902
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.00040888786315918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00035190582275391
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00049805641174316
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.00040912628173828
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.0004 0.00036501884460449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00036191940307617
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.0006260871887207
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.0005 0.00046110153198242
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.0006 0.00057101249694824
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.0005 0.00050997734069824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00043892860412598
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00073385238647461
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.00052285194396973
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.00043296813964844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00051307678222656
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00088191032409668
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.0005 0.00050187110900879
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.00057101249694824
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.00043106079101562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00037312507629395
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00043702125549316
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0025 0.0025448799133301
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0013 0.0013470649719238
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00050902366638184
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.0010 0.0010349750518799
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010669231414795
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00081491470336914
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7776 0.7776141166687
SELECT * FROM ipgeocountries WHERE INET_ATON('18.191.37.17') >= INET_ATON(ip_start) AND INET_ATON('18.191.37.17') <= INET_ATON(ip_end)
78 0.0020 0.0019519329071045
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0012 0.0012099742889404
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00059914588928223
SELECT * FROM products WHERE pagename = 'uncle-lees-imperial-organic-vanilla-rooibos-1x18-tea-bags'
81 0.0004 0.00044012069702148
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1539
82 0.0005 0.00049114227294922
SELECT * FROM manufacturers WHERE id = '381'
83 0.0004 0.00044107437133789
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '381'
84 0.0012 0.0011720657348633
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '381' LIMIT 1
85 0.0065 0.0064671039581299
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '381' ORDER BY RAND() LIMIT 1
86 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '1539' ORDER BY sortorder ASC
87 0.0004 0.00044703483581543
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '381'
88 0.0006 0.00057697296142578
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '381'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0005 0.0004580020904541
SELECT * FROM manufacturerimages WHERE manufacturer_id = '381'
90 0.0004 0.00043392181396484
SELECT category_id FROM products_categories WHERE product_id = '1539'
91 0.0005 0.00049209594726562
SELECT * FROM categories WHERE id = '27'
92 0.0036 0.0036158561706543
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.0005490779876709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00039291381835938
SELECT id FROM categories WHERE parent_id = '27'
95 0.0036 0.003572940826416
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.00053215026855469
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.00051093101501465
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.0005 0.00045299530029297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.0004889965057373
SELECT * FROM productimages WHERE product_id = '1539' ORDER BY sortorder ASC
100 0.0014 0.0013880729675293
SELECT * FROM product_image_select WHERE product_id = '1539'
101 0.0012 0.0011730194091797
SELECT * FROM productcustomimages WHERE product_id = '1539'
102 0.0011 0.0011019706726074
SELECT * FROM productfeeds WHERE product_id = '1539' ORDER BY item_date DESC
103 0.0023 0.0022780895233154
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1539' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0021 0.0020740032196045
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1539' AND t.hidden = 0 AND display_product = 1
105 0.0012 0.0012211799621582
SELECT * FROM productamazoncontent WHERE product_id = '1539'
106 0.0014 0.0013887882232666
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1539' AND a.name = n.originalname
107 0.0014 0.0013508796691895
SELECT * FROM productoffers WHERE product_id = '1539' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.0003819465637207
SELECT * FROM productoffers
                WHERE product_id = '1539' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00035214424133301
SELECT * FROM productoffers
                WHERE product_id = 1539
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00047111511230469
SELECT value FROM productattributes
                WHERE product_id = '1539'
                AND name = 'ListPriceAmount'
111 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '1539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.00049996376037598
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
113 0.0092 0.0092339515686035
SELECT *, MATCH (description, title) AGAINST ('imperial organic vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('imperial organic vanilla' IN BOOLEAN MODE) AND 1539 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0007 0.00068998336791992
SELECT *, MATCH (description, title) AGAINST ('imperial organic vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('imperial organic vanilla' IN BOOLEAN MODE) AND 1539 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0006 0.0006110668182373
SELECT *, MATCH (description, title) AGAINST ('imperial organic vanilla' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('imperial organic vanilla' IN BOOLEAN MODE) AND 1539 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0005 0.00048589706420898
SELECT * FROM productimages WHERE product_id = '966' ORDER BY sortorder ASC
117 0.0007 0.00066494941711426
SELECT * FROM product_image_select WHERE product_id = '966'
118 0.0004 0.00039005279541016
SELECT * FROM productcustomimages WHERE product_id = '966'
119 0.0008 0.00080204010009766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname
120 0.0005 0.00050711631774902
SELECT * FROM productoffers WHERE product_id = '966' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '966' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '966' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0004 0.00039815902709961
SELECT * FROM productimages WHERE product_id = '2417' ORDER BY sortorder ASC
124 0.0006 0.00060701370239258
SELECT * FROM product_image_select WHERE product_id = '2417'
125 0.0004 0.00036311149597168
SELECT * FROM productcustomimages WHERE product_id = '2417'
126 0.0008 0.00078701972961426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2417' AND a.name = n.originalname
127 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '2417' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '2417' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00035715103149414
SELECT value FROM productattributes WHERE product_id = '2417' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0004 0.00042510032653809
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC
131 0.0005 0.00052189826965332
SELECT * FROM product_image_select WHERE product_id = '1089'
132 0.0007 0.00066900253295898
SELECT * FROM productcustomimages WHERE product_id = '1089'
133 0.0009 0.00086379051208496
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname
134 0.0004 0.00043010711669922
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00052404403686523
SELECT * FROM productoffers
                WHERE product_id = '1089' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '1089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00049304962158203
SELECT * FROM productimages WHERE product_id = '941' ORDER BY sortorder ASC
138 0.0005 0.00054693222045898
SELECT * FROM product_image_select WHERE product_id = '941'
139 0.0003 0.00034093856811523
SELECT * FROM productcustomimages WHERE product_id = '941'
140 0.0010 0.0010411739349365
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
141 0.0004 0.00042891502380371
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0004 0.00037980079650879
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0004 0.00040507316589355
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
145 0.0005 0.00051689147949219
SELECT * FROM product_image_select WHERE product_id = '938'
146 0.0003 0.00031685829162598
SELECT * FROM productcustomimages WHERE product_id = '938'
147 0.0007 0.00065898895263672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
148 0.0004 0.0004429817199707
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0004 0.00036096572875977
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0003 0.00034308433532715
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0004 0.00044798851013184
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
152 0.0005 0.00051498413085938
SELECT * FROM product_image_select WHERE product_id = '890'
153 0.0003 0.00031900405883789
SELECT * FROM productcustomimages WHERE product_id = '890'
154 0.0009 0.00088810920715332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
155 0.0004 0.00041317939758301
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0005 0.00046277046203613
SELECT id,asin FROM products WHERE parent_id = 1539
159 0.0015 0.001478910446167
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1539' ORDER BY timestamp DESC
160 0.0004 0.00044989585876465
SELECT category_id FROM products_categories WHERE product_id = '1539'
161 0.0005 0.0004889965057373
SELECT * FROM categories WHERE id = '27'
162 0.0034 0.0034439563751221
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
163 0.0004 0.0003969669342041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
164 0.0003 0.00030684471130371
SELECT id FROM categories WHERE parent_id = '27'
165 0.0034 0.0033750534057617
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 
166 0.0004 0.00043582916259766
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 
167 0.0005 0.00045895576477051
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
168 0.0004 0.00043582916259766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
169 0.0010 0.0010018348693848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1539' AND a.name = n.originalname
170 0.0005 0.00049686431884766
SELECT * FROM productoffers WHERE product_id = '1539' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0004 0.00035285949707031
SELECT * FROM productoffers
                WHERE product_id = '1539' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = 1539
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00034904479980469
SELECT value FROM productattributes
                WHERE product_id = '1539'
                AND name = 'ListPriceAmount'
174 0.0005 0.00049209594726562
SELECT * FROM products WHERE id = '1539'
175 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '1539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0009 0.00088310241699219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1539' AND a.name = n.originalname
177 0.0003 0.00032305717468262
SELECT * FROM productoffers WHERE product_id = '1539' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '1539' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0003 0.0003359317779541
SELECT * FROM productoffers
                WHERE product_id = 1539
                ORDER BY price ASC LIMIT 1
180 0.0003 0.00034999847412109
SELECT value FROM productattributes
                WHERE product_id = '1539'
                AND name = 'ListPriceAmount'
181 0.0004 0.00041294097900391
SELECT category_id FROM products_categories WHERE product_id = '1539' AND prod_type = 'amz'
182 0.0004 0.00037193298339844
SELECT parent_id FROM categories WHERE id = '27'
183 0.0003 0.00030612945556641
SELECT * FROM categories WHERE id = '27'
184 0.0035 0.0034520626068115
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
185 0.0004 0.00035881996154785
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186 0.0003 0.00029706954956055
SELECT id FROM categories WHERE parent_id = '27'
187 0.0035 0.0034511089324951
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 
188 0.0005 0.00046801567077637
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 
189 0.0005 0.0004889965057373
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
190 0.0004 0.0004267692565918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
191 0.0014 0.0013570785522461
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
192 0.0011 0.0011379718780518
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
193 0.0003 0.00034022331237793
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0121 0.012109994888306
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
195 0.0013 0.0013480186462402
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
196 0.0005 0.00049400329589844
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
197 0.0005 0.00050187110900879
SELECT * FROM products WHERE id = 1626
198 0.0004 0.00035595893859863
SELECT * FROM products WHERE id = 4041
199 0.0004 0.00035715103149414
SELECT * FROM products WHERE id = 4312
200 0.0003 0.00033688545227051
SELECT * FROM products WHERE id = 777
201 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = 3881
202 0.0003 0.00034093856811523
SELECT * FROM products WHERE id = 4213
203 0.0003 0.00032806396484375
SELECT * FROM products WHERE id = '1626'
204 0.0004 0.00040102005004883
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
205 0.0006 0.00059413909912109
SELECT * FROM product_image_select WHERE product_id = '1626'
206 0.0004 0.00036811828613281
SELECT * FROM productcustomimages WHERE product_id = '1626'
207 0.0008 0.00076103210449219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
208 0.0004 0.00043797492980957
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0004 0.00036478042602539
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0005 0.00046110153198242
SELECT * FROM products WHERE id = '4041'
212 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
213 0.0005 0.00053715705871582
SELECT * FROM product_image_select WHERE product_id = '4041'
214 0.0003 0.00034499168395996
SELECT * FROM productcustomimages WHERE product_id = '4041'
215 0.0011 0.0011119842529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
216 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0004 0.00036287307739258
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0004 0.00038981437683105
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = '4312'
220 0.0004 0.0004279613494873
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
221 0.0006 0.00060486793518066
SELECT * FROM product_image_select WHERE product_id = '4312'
222 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '4312'
223 0.0010 0.0010089874267578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
224 0.0004 0.00040388107299805
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0004 0.00044989585876465
SELECT * FROM products WHERE id = '777'
228 0.0005 0.00051403045654297
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
229 0.0007 0.00070095062255859
SELECT * FROM product_image_select WHERE product_id = '777'
230 0.0005 0.00047206878662109
SELECT * FROM productcustomimages WHERE product_id = '777'
231 0.0012 0.0012199878692627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
232 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0005 0.00054597854614258
SELECT * FROM products WHERE id = '3881'
236 0.0007 0.00066089630126953
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
237 0.0006 0.00059294700622559
SELECT * FROM product_image_select WHERE product_id = '3881'
238 0.0004 0.00039482116699219
SELECT * FROM productcustomimages WHERE product_id = '3881'
239 0.0012 0.0011899471282959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
240 0.0006 0.00055503845214844
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0005 0.00052595138549805
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0006 0.00058293342590332
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0007 0.00068283081054688
SELECT * FROM products WHERE id = '4213'
244 0.0006 0.00060296058654785
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
245 0.0007 0.00070405006408691
SELECT * FROM product_image_select WHERE product_id = '4213'
246 0.0006 0.00059700012207031
SELECT * FROM productcustomimages WHERE product_id = '4213'
247 0.0015 0.0015449523925781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
248 0.0006 0.00060200691223145
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0005 0.00049519538879395
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0008 0.00082492828369141
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0020 0.002007007598877
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
252 0.0012 0.0011699199676514
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
253 0.0032 0.0032119750976562
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
254 0.0021 0.0020768642425537
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0025 0.002504825592041
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0013 0.001295804977417
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'