Special Offers

Our prices are already low, but sometimes we go crazy and put some even lower! See below for our current special offers and check back regularly for the latest.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.227215051651 259 0.1326 0


No Amazon API Requests Made.

Total time 1.227215051651 seconds

Number Time From Start Name Description
1 1.0022041797638 Initialise Initialise FSB Function
2 1.0037221908569 App Controller Start Start of the App controller (called before the controller of every page)
3 1.0068011283875 Start of getCategoryListByGroup Function Before first category groups query
4 1.0071351528168 After initial query Before first category groups query
5 1.0071370601654 Get Category List for Group Before the call to getCategoryList function
6 1.0071411132812 Start of GetCategoryList function Start of the function
7 1.0071461200714 Before getting categories Query to get specific category list
8 1.007443189621 After getting categories Query to get specific category list
9 1.0074460506439 Before getting category custom Before call to function getCategoryCustom
10 1.0227971076965 After getting category custom After call to function getCategoryCustom
11 1.0228021144867 Before getting category custom Before call to function getCategoryCustom
12 1.0245971679688 After getting category custom After call to function getCategoryCustom
13 1.0246000289917 Before getting category custom Before call to function getCategoryCustom
14 1.0297951698303 After getting category custom After call to function getCategoryCustom
15 1.0297980308533 Before getting category custom Before call to function getCategoryCustom
16 1.0325191020966 After getting category custom After call to function getCategoryCustom
17 1.0325219631195 Before getting category custom Before call to function getCategoryCustom
18 1.0350351333618 After getting category custom After call to function getCategoryCustom
19 1.0350379943848 Before getting category custom Before call to function getCategoryCustom
20 1.0375351905823 After getting category custom After call to function getCategoryCustom
21 1.0375380516052 End of GetCategoryList function End of the function
22 1.0375471115112 End of getCategoryListByGroup Function Before return()
23 1.0419471263885 App Controller End End of the App controller (called before the controller of every page)
24 1.1326191425323 App_after Controller Start Start of the App_after controller (called after the controller of every page)
25 1.1330900192261 Before Get Options Before the call to getOptions in the tpl class
26 1.1513531208038 After Get Options After the call to getOptions in the tpl class
27 1.15163397789 App_after Controller End End of the App_after controller (called after the controller of every page)
28 1.2272000312805 Finalizing debug Before the debug is output to the page.
29 1.2272140979767 End of App This is the end of the app logging, final timestamp


Query Debug - 259 Database Queries. Total time 0.1326 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00046920776367188
SELECT parameter, value FROM parameters
2 0.0009 0.00088000297546387
SELECT * FROM `bad_bots`
3 0.0003 0.00028491020202637
SET time_zone = 'Europe/London'
4 0.0002 0.00020694732666016
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.002263069152832
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:10:\"3.80.3.192\";}'
6 0.0016 0.0015828609466553
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1635207893'
7 0.0007 0.00068497657775879
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00021195411682129
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00049090385437012
SELECT id FROM pages WHERE pagename = 'special-offers' LIMIT 1
10 0.0003 0.00030684471130371
SELECT * FROM pages WHERE id = 45
11 0.0009 0.00086498260498047
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00089001655578613
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00042009353637695
SELECT * FROM pages WHERE pagename = 'special-offers'
14 0.0003 0.00031805038452148
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00027012825012207
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0065 0.0065491199493408
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.0002 0.00021100044250488
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.0002 0.00017905235290527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '26'
20 0.0073 0.007317066192627
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.0002 0.00021100044250488
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.0002 0.00016999244689941
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.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00018501281738281
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00018715858459473
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.0002 0.00016999244689941
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.0002 0.00018715858459473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00020480155944824
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00018215179443359
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.0002 0.00019288063049316
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.0002 0.00016188621520996
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.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00017499923706055
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0017750263214111
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.0002 0.00021910667419434
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.0002 0.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00017404556274414
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.0019550323486328
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.0002 0.00019001960754395
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.0002 0.00017094612121582
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.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00019407272338867
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00070381164550781
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.0002 0.00018191337585449
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.0002 0.00016188621520996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00016307830810547
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00061202049255371
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.0002 0.00016093254089355
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.0003 0.00025510787963867
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.0002 0.00019311904907227
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00016689300537109
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00065994262695312
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.0002 0.00019598007202148
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.0002 0.00018310546875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00017976760864258
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00046205520629883
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.0002 0.00016212463378906
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.0002 0.00015902519226074
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.0002 0.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00017905235290527
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00051188468933105
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.0002 0.00016403198242188
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.0002 0.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00018620491027832
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00055599212646484
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.0002 0.00020384788513184
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.0002 0.00018596649169922
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.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00019216537475586
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00020480155944824
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00024914741516113
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00018119812011719
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
73 0.0002 0.00019097328186035
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0004 0.00042581558227539
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00048685073852539
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.0001988410949707
SELECT * FROM ipgeocountries WHERE INET_ATON('3.80.3.192') >= INET_ATON(ip_start) AND INET_ATON('3.80.3.192') <= INET_ATON(ip_end)
77 0.0002 0.0001671314239502
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00016498565673828
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0002 0.00022602081298828
SELECT * FROM pages WHERE pagename = 'special-offers'
80 0.0017 0.0016880035400391
SELECT * FROM cachefiles WHERE identifier = '705d81a1389da579897872b0125a53ad'
81 0.0006 0.00055408477783203
DELETE FROM cachefiles WHERE identifier = '705d81a1389da579897872b0125a53ad'
82 0.0097 0.0096700191497803
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0007 0.0007479190826416
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0004 0.00040006637573242
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0002 0.00015711784362793
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0002 0.00024604797363281
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00038409233093262
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0015 0.001539945602417
SELECT p.id,asin FROM products p, productoffers o
		WHERE p.id = o.product_id
		AND p.parent_id = 0
		AND p.enabled = 1
		AND p.hidden  = 0
		
		AND o.percentagesaved > 0
		AND o.price > 200
		AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price))
		AND 1 = 1
		ORDER BY p.salesrank DESC LIMIT 20
89 0.0004 0.00040888786315918
SELECT id FROM custom_products
		WHERE hide = 0
		AND ((discountper > 0 AND price > 0) OR specialoffer = 1)
		ORDER BY discountper DESC LIMIT 20
90 0.0004 0.00040483474731445
SELECT id,listingtype FROM ebay_products
		WHERE hide = 0
		AND discountper > 0
		ORDER BY discountper DESC LIMIT 20
91 0.0031 0.003058910369873
SELECT  p.*, o.price + o.amountsaved as originalprice FROM products p, productoffers o
		WHERE p.id = o.product_id
		AND p.parent_id = 0
		AND p.enabled = 1
		AND p.hidden = 0
		
		AND o.percentagesaved > 0
		AND o.price > 200
		AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price))
		AND 1 = 1
		ORDER BY salesrank ASC
		LIMIT 0, 18
92 0.0013 0.0012919902801514
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
93 0.0004 0.00036311149597168
SELECT * FROM product_image_select WHERE product_id = '4926'
94 0.0003 0.00033116340637207
SELECT * FROM productcustomimages WHERE product_id = '4926'
95 0.0012 0.0011579990386963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
96 0.0004 0.0003809928894043
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0004 0.00040483474731445
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99 0.0009 0.00089192390441895
SELECT * FROM productimages WHERE product_id = '4921' ORDER BY sortorder ASC
100 0.0003 0.00033712387084961
SELECT * FROM product_image_select WHERE product_id = '4921'
101 0.0003 0.00025296211242676
SELECT * FROM productcustomimages WHERE product_id = '4921'
102 0.0013 0.001338005065918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4921' AND a.name = n.originalname
103 0.0003 0.00032377243041992
SELECT * FROM productoffers WHERE product_id = '4921' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '4921' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '4921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
106 0.0009 0.0009150505065918
SELECT * FROM productimages WHERE product_id = '4945' ORDER BY sortorder ASC
107 0.0003 0.00026893615722656
SELECT * FROM product_image_select WHERE product_id = '4945'
108 0.0003 0.00028014183044434
SELECT * FROM productcustomimages WHERE product_id = '4945'
109 0.0009 0.00094294548034668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4945' AND a.name = n.originalname
110 0.0004 0.0003669261932373
SELECT * FROM productoffers WHERE product_id = '4945' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '4945' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '4945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0014 0.0013778209686279
SELECT * FROM productimages WHERE product_id = '4918' ORDER BY sortorder ASC
114 0.0003 0.00029897689819336
SELECT * FROM product_image_select WHERE product_id = '4918'
115 0.0003 0.00026392936706543
SELECT * FROM productcustomimages WHERE product_id = '4918'
116 0.0010 0.0010299682617188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4918' AND a.name = n.originalname
117 0.0003 0.00030207633972168
SELECT * FROM productoffers WHERE product_id = '4918' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '4918' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '4918' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0012 0.0011529922485352
SELECT * FROM productimages WHERE product_id = '1070' ORDER BY sortorder ASC
121 0.0003 0.00028300285339355
SELECT * FROM product_image_select WHERE product_id = '1070'
122 0.0002 0.00024700164794922
SELECT * FROM productcustomimages WHERE product_id = '1070'
123 0.0009 0.00090312957763672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1070' AND a.name = n.originalname
124 0.0004 0.00039100646972656
SELECT * FROM productoffers WHERE product_id = '1070' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0004 0.00040602684020996
SELECT * FROM productoffers
                WHERE product_id = '1070' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00034308433532715
SELECT value FROM productattributes WHERE product_id = '1070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0010 0.0010430812835693
SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
128 0.0003 0.00034213066101074
SELECT * FROM product_image_select WHERE product_id = '1418'
129 0.0002 0.000244140625
SELECT * FROM productcustomimages WHERE product_id = '1418'
130 0.0009 0.00090312957763672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
131 0.0004 0.00039100646972656
SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0003 0.0003359317779541
SELECT * FROM productoffers
                WHERE product_id = '1418' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0008 0.00076603889465332
SELECT * FROM productimages WHERE product_id = '4084' ORDER BY sortorder ASC
135 0.0003 0.00032711029052734
SELECT * FROM product_image_select WHERE product_id = '4084'
136 0.0003 0.00025296211242676
SELECT * FROM productcustomimages WHERE product_id = '4084'
137 0.0016 0.0016219615936279
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4084' AND a.name = n.originalname
138 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '4084' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '4084' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '4084' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0009 0.00087594985961914
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
142 0.0003 0.00032806396484375
SELECT * FROM product_image_select WHERE product_id = '4917'
143 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '4917'
144 0.0013 0.0012631416320801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
145 0.0003 0.00031089782714844
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0004 0.00039911270141602
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0011 0.0011000633239746
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
149 0.0003 0.00027108192443848
SELECT * FROM product_image_select WHERE product_id = '923'
150 0.0003 0.00028586387634277
SELECT * FROM productcustomimages WHERE product_id = '923'
151 0.0010 0.0010180473327637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
152 0.0003 0.00033402442932129
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00036215782165527
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0012 0.0012171268463135
SELECT * FROM productimages WHERE product_id = '1849' ORDER BY sortorder ASC
156 0.0003 0.00027298927307129
SELECT * FROM product_image_select WHERE product_id = '1849'
157 0.0002 0.00024509429931641
SELECT * FROM productcustomimages WHERE product_id = '1849'
158 0.0007 0.0006711483001709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1849' AND a.name = n.originalname
159 0.0003 0.0003359317779541
SELECT * FROM productoffers WHERE product_id = '1849' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '1849' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '1849' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0012 0.0011858940124512
SELECT * FROM productimages WHERE product_id = '2019' ORDER BY sortorder ASC
163 0.0003 0.00032186508178711
SELECT * FROM product_image_select WHERE product_id = '2019'
164 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '2019'
165 0.0006 0.0006251335144043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2019' AND a.name = n.originalname
166 0.0004 0.00035881996154785
SELECT * FROM productoffers WHERE product_id = '2019' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0004 0.00035190582275391
SELECT * FROM productoffers
                WHERE product_id = '2019' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '2019' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0010 0.0010149478912354
SELECT * FROM productimages WHERE product_id = '1120' ORDER BY sortorder ASC
170 0.0003 0.00030398368835449
SELECT * FROM product_image_select WHERE product_id = '1120'
171 0.0002 0.00023388862609863
SELECT * FROM productcustomimages WHERE product_id = '1120'
172 0.0009 0.00092887878417969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1120' AND a.name = n.originalname
173 0.0003 0.0003211498260498
SELECT * FROM productoffers WHERE product_id = '1120' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = '1120' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '1120' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0010 0.00098705291748047
SELECT * FROM productimages WHERE product_id = '1285' ORDER BY sortorder ASC
177 0.0004 0.0003509521484375
SELECT * FROM product_image_select WHERE product_id = '1285'
178 0.0003 0.00026917457580566
SELECT * FROM productcustomimages WHERE product_id = '1285'
179 0.0010 0.0010049343109131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1285' AND a.name = n.originalname
180 0.0003 0.00031089782714844
SELECT * FROM productoffers WHERE product_id = '1285' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00036811828613281
SELECT * FROM productoffers
                WHERE product_id = '1285' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '1285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0012 0.0012359619140625
SELECT * FROM productimages WHERE product_id = '1279' ORDER BY sortorder ASC
184 0.0003 0.00031590461730957
SELECT * FROM product_image_select WHERE product_id = '1279'
185 0.0003 0.00026798248291016
SELECT * FROM productcustomimages WHERE product_id = '1279'
186 0.0011 0.0011439323425293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1279' AND a.name = n.originalname
187 0.0003 0.00031185150146484
SELECT * FROM productoffers WHERE product_id = '1279' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '1279' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0004 0.00035214424133301
SELECT value FROM productattributes WHERE product_id = '1279' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0002 0.00022602081298828
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
191 0.0002 0.00017786026000977
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
192 0.0002 0.00018501281738281
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
193 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = 38
194 0.0002 0.00019001960754395
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
195 0.0004 0.00035285949707031
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1635207894;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
196 0.0003 0.00033998489379883
SELECT * FROM products WHERE id = 790
197 0.0004 0.00044107437133789
SELECT * FROM products WHERE id = 788
198 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = 787
199 0.0004 0.00039505958557129
SELECT * FROM products WHERE id = 1287
200 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = 780
201 0.0004 0.00038814544677734
SELECT * FROM products WHERE id = 779
202 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = '790'
203 0.0004 0.00037002563476562
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
204 0.0002 0.00017905235290527
SELECT * FROM product_image_select WHERE product_id = '790'
205 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '790'
206 0.0002 0.00017595291137695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
207 0.0002 0.00017094612121582
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0003 0.00030088424682617
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0003 0.00031590461730957
SELECT * FROM products WHERE id = '788'
211 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
212 0.0002 0.00015997886657715
SELECT * FROM product_image_select WHERE product_id = '788'
213 0.0002 0.00015807151794434
SELECT * FROM productcustomimages WHERE product_id = '788'
214 0.0002 0.0001671314239502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
215 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0002 0.0002288818359375
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0003 0.00025296211242676
SELECT * FROM products WHERE id = '787'
219 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
220 0.0002 0.00017309188842773
SELECT * FROM product_image_select WHERE product_id = '787'
221 0.0002 0.00017118453979492
SELECT * FROM productcustomimages WHERE product_id = '787'
222 0.0004 0.00036001205444336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
223 0.0003 0.00028395652770996
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0002 0.00018477439880371
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0002 0.00019478797912598
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0003 0.00027084350585938
SELECT * FROM products WHERE id = '1287'
227 0.0004 0.00041103363037109
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
228 0.0002 0.00015997886657715
SELECT * FROM product_image_select WHERE product_id = '1287'
229 0.0002 0.00018310546875
SELECT * FROM productcustomimages WHERE product_id = '1287'
230 0.0002 0.00018596649169922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
231 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0002 0.00019478797912598
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0003 0.0002589225769043
SELECT * FROM products WHERE id = '780'
235 0.0002 0.00016689300537109
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
236 0.0002 0.00017213821411133
SELECT * FROM product_image_select WHERE product_id = '780'
237 0.0002 0.00018620491027832
SELECT * FROM productcustomimages WHERE product_id = '780'
238 0.0002 0.00017285346984863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
239 0.0002 0.00016880035400391
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0002 0.00018596649169922
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00022482872009277
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0003 0.00027585029602051
SELECT * FROM products WHERE id = '779'
243 0.0002 0.0001838207244873
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
244 0.0002 0.00017189979553223
SELECT * FROM product_image_select WHERE product_id = '779'
245 0.0002 0.00016283988952637
SELECT * FROM productcustomimages WHERE product_id = '779'
246 0.0002 0.00016093254089355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
247 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0002 0.00019979476928711
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0003 0.00028395652770996
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
251 0.0004 0.00037288665771484
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
252 0.0007 0.00065898895263672
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
253 0.0004 0.00040221214294434
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
254 0.0004 0.00037193298339844
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
255 0.0008 0.00081801414489746
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'ICON_RSS_FEED'
256 0.0007 0.00068879127502441
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
257 0.0005 0.0004570484161377
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
258 0.0004 0.00041007995605469
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
259 0.0002 0.00021195411682129
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'