0
  1. My Store
  2. Tags
  3. Rooibos

Rooibos

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.778028011322 252 1.1175 0


No Amazon API Requests Made.


App Debug - Total Time 1.778028011322 seconds

Number Time From Start Name Description
1 0.46512389183044 Initialise Initialise FSB Function
2 0.48211598396301 App Controller Start Start of the App controller (called before the controller of every page)
3 0.5312180519104 Start of getCategoryListByGroup Function Before first category groups query
4 0.5328688621521 After initial query Before first category groups query
5 0.53287100791931 Get Category List for Group Before the call to getCategoryList function
6 0.53287386894226 Start of GetCategoryList function Start of the function
7 0.53287601470947 Before getting categories Query to get specific category list
8 0.53351902961731 After getting categories Query to get specific category list
9 0.53352093696594 Before getting category custom Before call to function getCategoryCustom
10 0.55132484436035 After getting category custom After call to function getCategoryCustom
11 0.55132699012756 Before getting category custom Before call to function getCategoryCustom
12 0.56149792671204 After getting category custom After call to function getCategoryCustom
13 0.56149888038635 Before getting category custom Before call to function getCategoryCustom
14 0.56720304489136 After getting category custom After call to function getCategoryCustom
15 0.56720399856567 Before getting category custom Before call to function getCategoryCustom
16 0.57132792472839 After getting category custom After call to function getCategoryCustom
17 0.57132887840271 Before getting category custom Before call to function getCategoryCustom
18 0.57636499404907 After getting category custom After call to function getCategoryCustom
19 0.57636594772339 Before getting category custom Before call to function getCategoryCustom
20 0.58080005645752 After getting category custom After call to function getCategoryCustom
21 0.58080101013184 End of GetCategoryList function End of the function
22 0.5808048248291 Get Category List for Group Before the call to getCategoryList function
23 0.580806016922 Start of GetCategoryList function Start of the function
24 0.58080697059631 Before getting categories Query to get specific category list
25 0.58139395713806 End of getCategoryListByGroup Function Before return()
26 1.4051349163055 App Controller End End of the App controller (called before the controller of every page)
27 1.5374820232391 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.5390689373016 Before Get Options Before the call to getOptions in the tpl class
29 1.5924429893494 After Get Options After the call to getOptions in the tpl class
30 1.5924868583679 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.7780139446259 Finalizing debug Before the debug is output to the page.
32 1.778028011322 End of App This is the end of the app logging, final timestamp


Query Debug - 252 Database Queries. Total time 1.1175 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0014638900756836 
SELECT parameter, value FROM parameters
2 0.0074 0.0073850154876709 
SELECT * FROM `bad_bots`
3 0.0023 0.0023071765899658 
SET time_zone = 'Europe/London'
4 0.0042 0.0042381286621094 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0040 0.0040240287780762 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.135.184.166\";}'
6 0.0026 0.0025608539581299 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747190011'
7 0.0020 0.0019848346710205 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00041580200195312 
UPDATE autorun SET lastrun = '2025-05-14 02:33:31' WHERE id = '17'
9 0.0005 0.00048398971557617 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0017 0.0017399787902832 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0021 0.0020918846130371 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0019 0.0019102096557617 
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0016 0.0015661716461182 
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0017 0.0017380714416504 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0018 0.0018141269683838 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0033 0.0033090114593506 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0016 0.0015659332275391 
SELECT id FROM tags WHERE pagename = 'rooibos' LIMIT 1
18 0.0027 0.0026569366455078 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0454 0.045382976531982 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0006 0.00063681602478027 
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0016 0.0016388893127441 
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0006 0.00062704086303711 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0072 0.0071790218353271 
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
24 0.0005 0.00048518180847168 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
25 0.0013 0.0012969970703125 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0004 0.00041890144348145 
SELECT id FROM categories WHERE parent_id = '26'
27 0.0054 0.0054399967193604 
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
28 0.0005 0.00054001808166504 
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
29 0.0005 0.00050115585327148 
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
30 0.0015 0.0014739036560059 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0004 0.00041294097900391 
SELECT * FROM categorygroups WHERE id = '1'
32 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
33 0.0004 0.00044989585876465 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
34 0.0004 0.00035405158996582 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0003 0.00034904479980469 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0037 0.0037388801574707 
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
37 0.0005 0.0004570484161377 
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
38 0.0005 0.00050783157348633 
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
39 0.0004 0.00041794776916504 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0004 0.00038886070251465 
SELECT * FROM categorygroups WHERE id = '1'
41 0.0014 0.0013968944549561 
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
42 0.0004 0.00043892860412598 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
43 0.0004 0.00035619735717773 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0004 0.00037097930908203 
SELECT id FROM categories WHERE parent_id = '28'
45 0.0014 0.0014410018920898 
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
46 0.0004 0.00042295455932617 
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
47 0.0005 0.00045108795166016 
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
48 0.0004 0.00042986869812012 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0004 0.00037193298339844 
SELECT * FROM categorygroups WHERE id = '1'
50 0.0006 0.00056099891662598 
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
51 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
52 0.0004 0.00035786628723145 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0004 0.00039315223693848 
SELECT id FROM categories WHERE parent_id = '29'
54 0.0007 0.00067806243896484 
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
55 0.0004 0.00042414665222168 
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
56 0.0005 0.00046992301940918 
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
57 0.0004 0.00043892860412598 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0004 0.00035977363586426 
SELECT * FROM categorygroups WHERE id = '1'
59 0.0010 0.0010190010070801 
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
60 0.0007 0.00070595741271973 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
61 0.0004 0.00043201446533203 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0004 0.00041294097900391 
SELECT id FROM categories WHERE parent_id = '30'
63 0.0007 0.00067615509033203 
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
64 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 (30)
				  AND p.disabled = 0
65 0.0005 0.00048398971557617 
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
66 0.0005 0.00045490264892578 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0004 0.00035881996154785 
SELECT * FROM categorygroups WHERE id = '1'
68 0.0006 0.00059604644775391 
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
69 0.0004 0.00044012069702148 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
70 0.0004 0.00037908554077148 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0004 0.00042915344238281 
SELECT id FROM categories WHERE parent_id = '31'
72 0.0007 0.00070500373840332 
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
73 0.0005 0.00046014785766602 
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
74 0.0005 0.00049591064453125 
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
75 0.0005 0.00048398971557617 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0004 0.0004270076751709 
SELECT * FROM categorygroups WHERE id = '1'
77 0.0006 0.00058293342590332 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0016 0.0015888214111328 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0017 0.0016679763793945 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0005 0.00049304962158203 
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
81 0.0011 0.0010859966278076 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0010 0.0010499954223633 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0008 0.00079011917114258 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.8120 0.81196904182434 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.135.184.166') >= INET_ATON(ip_start) AND INET_ATON('3.135.184.166') <= INET_ATON(ip_end)
85 0.0022 0.0021920204162598 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0013 0.001276969909668 
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0124 0.012374877929688 
SELECT * FROM tags WHERE pagename = 'rooibos'
88 0.0117 0.011712789535522 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0029 0.0028960704803467 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0024 0.0024449825286865 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0067 0.0067088603973389 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
92 0.0019 0.0019159317016602 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0005 0.00046682357788086 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0027 0.0027120113372803 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '1' AND hidden = 0 AND enabled = 1  AND 1 = 1
95 0.0039 0.0039339065551758 
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '1' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 180, 18
96 0.0016 0.0016069412231445 
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
97 0.0014 0.0014488697052002 
SELECT * FROM product_image_select WHERE product_id = '3588'
98 0.0012 0.0012180805206299 
SELECT * FROM productcustomimages WHERE product_id = '3588'
99 0.0019 0.0018610954284668 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
100 0.0015 0.0014760494232178 
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0004 0.00042414665222168 
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0006 0.00056695938110352 
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0005 0.00047206878662109 
SELECT * FROM productimages WHERE product_id = '3626' ORDER BY sortorder ASC
104 0.0006 0.00063800811767578 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3626' AND p.id = pi.product_id ORDER BY pi.sortorder
105 0.0006 0.00059795379638672 
SELECT * FROM product_image_select WHERE product_id = '3626'
106 0.0004 0.00035405158996582 
SELECT * FROM productcustomimages WHERE product_id = '3626'
107 0.0005 0.00053691864013672 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3626'
                GROUP BY o.product_id
108 0.0028 0.0027928352355957 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0005 0.000518798828125 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
110 0.0009 0.00091195106506348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3626' AND a.name = n.originalname
111 0.0004 0.00040006637573242 
SELECT * FROM productoffers WHERE product_id = '3626' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '3626' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0003 0.00032305717468262 
SELECT * FROM productoffers
                WHERE product_id = 3626
                ORDER BY price ASC LIMIT 1
114 0.0003 0.00031900405883789 
SELECT value FROM productattributes
                WHERE product_id = '3626'
                AND name = 'ListPriceAmount'
115 0.0005 0.00049781799316406 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3626'
                GROUP BY o.product_id
116 0.0007 0.00071501731872559 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
117 0.0004 0.00038599967956543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
118 0.0006 0.00055789947509766 
SELECT value FROM productattributes WHERE product_id = '3626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0006 0.00064992904663086 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3626'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
120 0.0005 0.00049400329589844 
SELECT * FROM productimages WHERE product_id = '3673' ORDER BY sortorder ASC
121 0.0006 0.00059199333190918 
SELECT * FROM product_image_select WHERE product_id = '3673'
122 0.0004 0.00040578842163086 
SELECT * FROM productcustomimages WHERE product_id = '3673'
123 0.0011 0.001060962677002 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3673' AND a.name = n.originalname
124 0.0005 0.00049710273742676 
SELECT * FROM productoffers WHERE product_id = '3673' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '3673' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00029683113098145 
SELECT * FROM productoffers
                WHERE product_id = 3673
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00045394897460938 
SELECT value FROM productattributes
                WHERE product_id = '3673'
                AND name = 'ListPriceAmount'
128 0.0004 0.00043392181396484 
SELECT value FROM productattributes WHERE product_id = '3673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00046801567077637 
SELECT * FROM productimages WHERE product_id = '3674' ORDER BY sortorder ASC
130 0.0006 0.00056004524230957 
SELECT * FROM product_image_select WHERE product_id = '3674'
131 0.0005 0.00046396255493164 
SELECT * FROM productcustomimages WHERE product_id = '3674'
132 0.0009 0.00092601776123047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3674' AND a.name = n.originalname
133 0.0005 0.00046300888061523 
SELECT * FROM productoffers WHERE product_id = '3674' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00037693977355957 
SELECT * FROM productoffers
                WHERE product_id = '3674' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00036883354187012 
SELECT * FROM productoffers
                WHERE product_id = 3674
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00035309791564941 
SELECT value FROM productattributes
                WHERE product_id = '3674'
                AND name = 'ListPriceAmount'
137 0.0004 0.00038695335388184 
SELECT value FROM productattributes WHERE product_id = '3674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00047898292541504 
SELECT * FROM productimages WHERE product_id = '3675' ORDER BY sortorder ASC
139 0.0006 0.00060582160949707 
SELECT * FROM product_image_select WHERE product_id = '3675'
140 0.0004 0.00035905838012695 
SELECT * FROM productcustomimages WHERE product_id = '3675'
141 0.0010 0.00098800659179688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3675' AND a.name = n.originalname
142 0.0005 0.00045013427734375 
SELECT * FROM productoffers WHERE product_id = '3675' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00044512748718262 
SELECT * FROM productoffers
                WHERE product_id = '3675' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0003 0.00031089782714844 
SELECT * FROM productoffers
                WHERE product_id = 3675
                ORDER BY price ASC LIMIT 1
145 0.0003 0.00034403800964355 
SELECT value FROM productattributes
                WHERE product_id = '3675'
                AND name = 'ListPriceAmount'
146 0.0004 0.00040888786315918 
SELECT value FROM productattributes WHERE product_id = '3675' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0004 0.0004429817199707 
SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
148 0.0005 0.00046110153198242 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
149 0.0006 0.00063300132751465 
SELECT * FROM product_image_select WHERE product_id = '4201'
150 0.0004 0.00038003921508789 
SELECT * FROM productcustomimages WHERE product_id = '4201'
151 0.0005 0.00053906440734863 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4201'
                GROUP BY o.product_id
152 0.0006 0.00058388710021973 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
153 0.0006 0.00056195259094238 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
154 0.0008 0.00084400177001953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
155 0.0003 0.00034689903259277 
SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '4201' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00042486190795898 
SELECT * FROM productoffers
                WHERE product_id = 4201
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00040102005004883 
SELECT value FROM productattributes
                WHERE product_id = '4201'
                AND name = 'ListPriceAmount'
159 0.0005 0.00049614906311035 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4201'
                GROUP BY o.product_id
160 0.0006 0.0006110668182373 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
161 0.0005 0.00047183036804199 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
162 0.0006 0.00061297416687012 
SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0004 0.0003972053527832 
SELECT * FROM products WHERE parent_id = '4201'
164 0.0005 0.00051116943359375 
SELECT * FROM productimages WHERE product_id = '4202' ORDER BY sortorder ASC
165 0.0006 0.00057506561279297 
SELECT * FROM product_image_select WHERE product_id = '4202'
166 0.0005 0.0004580020904541 
SELECT * FROM productcustomimages WHERE product_id = '4202'
167 0.0008 0.00079703330993652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4202' AND a.name = n.originalname
168 0.0005 0.00052881240844727 
SELECT * FROM productoffers WHERE product_id = '4202' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0004 0.0004279613494873 
SELECT * FROM productoffers
                WHERE product_id = '4202' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0005 0.00049805641174316 
SELECT value FROM productattributes WHERE product_id = '4202' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0005 0.00047111511230469 
SELECT * FROM productimages WHERE product_id = '4222' ORDER BY sortorder ASC
172 0.0006 0.00060391426086426 
SELECT * FROM product_image_select WHERE product_id = '4222'
173 0.0004 0.00039386749267578 
SELECT * FROM productcustomimages WHERE product_id = '4222'
174 0.0012 0.0012218952178955 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname
175 0.0005 0.00053191184997559 
SELECT * FROM productoffers WHERE product_id = '4222' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0004 0.00041913986206055 
SELECT * FROM productoffers
                WHERE product_id = '4222' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00044894218444824 
SELECT value FROM productattributes WHERE product_id = '4222' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0017 0.0016829967498779 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3588' ORDER BY timestamp DESC
179 0.0003 0.00029492378234863 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3626' ORDER BY timestamp DESC
180 0.0003 0.00030899047851562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3673' ORDER BY timestamp DESC
181 0.0003 0.0002751350402832 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3674' ORDER BY timestamp DESC
182 0.0003 0.00031089782714844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3675' ORDER BY timestamp DESC
183 0.0003 0.00032997131347656 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4201' ORDER BY timestamp DESC
184 0.0002 0.00023484230041504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4202' ORDER BY timestamp DESC
185 0.0003 0.00027990341186523 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4222' ORDER BY timestamp DESC
186 0.0015 0.001514196395874 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
187 0.0012 0.0011820793151855 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
188 0.0004 0.00035810470581055 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
189 0.0141 0.014066934585571 
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
190 0.0016 0.0016140937805176 
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
191 0.0005 0.00051498413085938 
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
192 0.0004 0.00044989585876465 
SELECT * FROM products WHERE id = 1626
193 0.0004 0.00036215782165527 
SELECT * FROM products WHERE id = 4041
194 0.0003 0.00032782554626465 
SELECT * FROM products WHERE id = 4312
195 0.0003 0.00031399726867676 
SELECT * FROM products WHERE id = 777
196 0.0004 0.00040197372436523 
SELECT * FROM products WHERE id = 3881
197 0.0004 0.00037813186645508 
SELECT * FROM products WHERE id = 4213
198 0.0003 0.00030803680419922 
SELECT * FROM products WHERE id = '1626'
199 0.0004 0.00042295455932617 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
200 0.0006 0.00059199333190918 
SELECT * FROM product_image_select WHERE product_id = '1626'
201 0.0004 0.00037097930908203 
SELECT * FROM productcustomimages WHERE product_id = '1626'
202 0.0008 0.00084495544433594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
203 0.0005 0.00049686431884766 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0004 0.00035500526428223 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0005 0.00053906440734863 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0005 0.00051403045654297 
SELECT * FROM products WHERE id = '4041'
207 0.0006 0.00063610076904297 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
208 0.0006 0.00057387351989746 
SELECT * FROM product_image_select WHERE product_id = '4041'
209 0.0003 0.00034904479980469 
SELECT * FROM productcustomimages WHERE product_id = '4041'
210 0.0012 0.0012099742889404 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
211 0.0004 0.00043606758117676 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0004 0.00040578842163086 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0004 0.00036787986755371 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0005 0.00053000450134277 
SELECT * FROM products WHERE id = '4312'
215 0.0004 0.00039505958557129 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
216 0.0007 0.00070285797119141 
SELECT * FROM product_image_select WHERE product_id = '4312'
217 0.0004 0.00037693977355957 
SELECT * FROM productcustomimages WHERE product_id = '4312'
218 0.0010 0.00097322463989258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
219 0.0005 0.00049304962158203 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00033402442932129 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00036883354187012 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0005 0.00054693222045898 
SELECT * FROM products WHERE id = '777'
223 0.0005 0.00046300888061523 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
224 0.0007 0.00066494941711426 
SELECT * FROM product_image_select WHERE product_id = '777'
225 0.0005 0.00049114227294922 
SELECT * FROM productcustomimages WHERE product_id = '777'
226 0.0012 0.0011579990386963 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
227 0.0005 0.00054407119750977 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0004 0.00037813186645508 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0004 0.00042510032653809 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0005 0.00054788589477539 
SELECT * FROM products WHERE id = '3881'
231 0.0005 0.00053596496582031 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
232 0.0005 0.00054693222045898 
SELECT * FROM product_image_select WHERE product_id = '3881'
233 0.0004 0.00035786628723145 
SELECT * FROM productcustomimages WHERE product_id = '3881'
234 0.0012 0.0012271404266357 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
235 0.0005 0.00048184394836426 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0005 0.00045895576477051 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0007 0.00070095062255859 
SELECT * FROM products WHERE id = '4213'
239 0.0005 0.00046014785766602 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
240 0.0006 0.00064587593078613 
SELECT * FROM product_image_select WHERE product_id = '4213'
241 0.0004 0.00041794776916504 
SELECT * FROM productcustomimages WHERE product_id = '4213'
242 0.0011 0.0011110305786133 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
243 0.0005 0.00045394897460938 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0005 0.00045013427734375 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0004 0.00037789344787598 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0020 0.0020270347595215 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
247 0.0006 0.000640869140625 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
248 0.0024 0.0023801326751709 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
249 0.0015 0.00154709815979 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0005 0.00048208236694336 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
251 0.0016 0.0016140937805176 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
252 0.0011 0.0011179447174072 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'