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.1183829307556 267 0.1838 0


No Amazon API Requests Made.

Total time 1.1183829307556 seconds

Number Time From Start Name Description
1 0.67243695259094 Initialise Initialise FSB Function
2 0.67479991912842 App Controller Start Start of the App controller (called before the controller of every page)
3 0.67804098129272 Start of getCategoryListByGroup Function Before first category groups query
4 0.67842197418213 After initial query Before first category groups query
5 0.67842411994934 Get Category List for Group Before the call to getCategoryList function
6 0.67842698097229 Start of GetCategoryList function Start of the function
7 0.67843008041382 Before getting categories Query to get specific category list
8 0.67882108688354 After getting categories Query to get specific category list
9 0.67882513999939 Before getting category custom Before call to function getCategoryCustom
10 0.69866704940796 After getting category custom After call to function getCategoryCustom
11 0.6986711025238 Before getting category custom Before call to function getCategoryCustom
12 0.71014308929443 After getting category custom After call to function getCategoryCustom
13 0.71014499664307 Before getting category custom Before call to function getCategoryCustom
14 0.71600604057312 After getting category custom After call to function getCategoryCustom
15 0.71600914001465 Before getting category custom Before call to function getCategoryCustom
16 0.7189929485321 After getting category custom After call to function getCategoryCustom
17 0.71899509429932 Before getting category custom Before call to function getCategoryCustom
18 0.72182202339172 After getting category custom After call to function getCategoryCustom
19 0.72182393074036 Before getting category custom Before call to function getCategoryCustom
20 0.72506999969482 After getting category custom After call to function getCategoryCustom
21 0.72507214546204 End of GetCategoryList function End of the function
22 0.72507905960083 End of getCategoryListByGroup Function Before return()
23 0.73424911499023 App Controller End End of the App controller (called before the controller of every page)
24 0.86843609809875 App_after Controller Start Start of the App_after controller (called after the controller of every page)
25 0.86931991577148 Before Get Options Before the call to getOptions in the tpl class
26 0.90416812896729 After Get Options After the call to getOptions in the tpl class
27 0.90437698364258 App_after Controller End End of the App_after controller (called after the controller of every page)
28 1.118369102478 Finalizing debug Before the debug is output to the page.
29 1.1183819770813 End of App This is the end of the app logging, final timestamp


Query Debug - 267 Database Queries. Total time 0.1838 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00062394142150879
SELECT parameter, value FROM parameters
2 0.0011 0.0010731220245361
SELECT * FROM `bad_bots`
3 0.0006 0.0005791187286377
SET time_zone = 'Europe/London'
4 0.0004 0.00042510032653809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0019562244415283
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.238.180.255\";}'
6 0.0015 0.0014569759368896
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653093895'
7 0.0006 0.00061392784118652
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00083708763122559
UPDATE autorun SET lastrun = '2022-05-21 00:44:55' WHERE id = '13'
9 0.0005 0.00052404403686523
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0007 0.00074410438537598
SELECT id FROM pages WHERE pagename = 'special-offers' LIMIT 1
11 0.0006 0.00060892105102539
SELECT * FROM pages WHERE id = 45
12 0.0014 0.001356840133667
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0008 0.00081300735473633
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0006 0.00062298774719238
SELECT * FROM pages WHERE pagename = 'special-offers'
15 0.0004 0.00037097930908203
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.00037193298339844
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0111 0.011090040206909
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
18 0.0003 0.00025701522827148
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0002 0.00021004676818848
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00026988983154297
SELECT id FROM categories WHERE parent_id = '26'
21 0.0065 0.0065369606018066
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 
22 0.0004 0.00043392181396484
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 
23 0.0003 0.00028014183044434
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
24 0.0003 0.00025010108947754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.0003819465637207
SELECT * FROM categorygroups WHERE id = '1'
26 0.0044 0.004410982131958
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
27 0.0002 0.00024199485778809
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00039982795715332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00040292739868164
SELECT id FROM categories WHERE parent_id = '27'
30 0.0045 0.0044670104980469
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 
31 0.0004 0.00040698051452637
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 
32 0.0004 0.00039005279541016
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
33 0.0004 0.0003809928894043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.0002448558807373
SELECT * FROM categorygroups WHERE id = '1'
35 0.0017 0.0016829967498779
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
36 0.0004 0.00040197372436523
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00040507316589355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.00029897689819336
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0017390251159668
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 
40 0.0004 0.00043010711669922
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 
41 0.0003 0.00026488304138184
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
42 0.0003 0.00027608871459961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00024604797363281
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00069808959960938
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
45 0.0002 0.00022602081298828
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.0005640983581543
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 
49 0.0003 0.00030803680419922
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 
50 0.0002 0.00022602081298828
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
51 0.0002 0.00022006034851074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00021886825561523
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00051116943359375
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
54 0.0002 0.00022196769714355
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00025200843811035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00054311752319336
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 
58 0.0003 0.00025796890258789
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 
59 0.0003 0.00027179718017578
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
60 0.0002 0.00020599365234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00025486946105957
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00056600570678711
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.00029802322387695
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0002 0.00021815299987793
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00023484230041504
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00060009956359863
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 
67 0.0004 0.00035500526428223
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 
68 0.0003 0.00034213066101074
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
69 0.0003 0.00030994415283203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.00023102760314941
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00033283233642578
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0004 0.00036001205444336
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00034904479980469
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.0002 0.00023698806762695
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0006 0.00057482719421387
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00051689147949219
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0004 0.00040316581726074
SELECT * FROM ipgeocountries WHERE INET_ATON('3.238.180.255') >= INET_ATON(ip_start) AND INET_ATON('3.238.180.255') <= INET_ATON(ip_end)
78 0.0005 0.00045895576477051
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00049591064453125
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00060582160949707
SELECT * FROM pages WHERE pagename = 'special-offers'
81 0.0011 0.0010690689086914
SELECT * FROM cachefiles WHERE identifier = '705d81a1389da579897872b0125a53ad'
82 0.0008 0.00082612037658691
DELETE FROM cachefiles WHERE identifier = '705d81a1389da579897872b0125a53ad'
83 0.0115 0.011531114578247
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
84 0.0004 0.00044989585876465
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
85 0.0004 0.00044822692871094
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
86 0.0004 0.00044798851013184
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
87 0.0005 0.00046086311340332
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
88 0.0004 0.00044012069702148
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
89 0.0015 0.0015099048614502
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
90 0.0006 0.00064587593078613
SELECT id FROM custom_products
		WHERE hide = 0
		AND ((discountper > 0 AND price > 0) OR specialoffer = 1)
		ORDER BY discountper DESC LIMIT 20
91 0.0006 0.00061297416687012
SELECT id,listingtype FROM ebay_products
		WHERE hide = 0
		AND discountper > 0
		ORDER BY discountper DESC LIMIT 20
92 0.0025 0.0024988651275635
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
93 0.0004 0.00037217140197754
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
94 0.0002 0.00024890899658203
SELECT * FROM product_image_select WHERE product_id = '4933'
95 0.0003 0.00028109550476074
SELECT * FROM productcustomimages WHERE product_id = '4933'
96 0.0011 0.0010850429534912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
97 0.0005 0.00045490264892578
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.00051999092102051
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0006 0.00061392784118652
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0004 0.00039315223693848
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
101 0.0004 0.00041794776916504
SELECT * FROM product_image_select WHERE product_id = '4953'
102 0.0003 0.00034403800964355
SELECT * FROM productcustomimages WHERE product_id = '4953'
103 0.0010 0.00098609924316406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
104 0.0005 0.00045084953308105
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0005 0.00053501129150391
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0005 0.00053596496582031
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0004 0.00041604042053223
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
108 0.0003 0.00031518936157227
SELECT * FROM product_image_select WHERE product_id = '1061'
109 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '1061'
110 0.0010 0.00095510482788086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
111 0.0004 0.00042009353637695
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0006 0.0006101131439209
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0006 0.00062298774719238
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
115 0.0004 0.00035786628723145
SELECT * FROM product_image_select WHERE product_id = '4954'
116 0.0004 0.00036191940307617
SELECT * FROM productcustomimages WHERE product_id = '4954'
117 0.0010 0.00098109245300293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
118 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00049996376037598
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0006 0.00056195259094238
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0003 0.00025510787963867
SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
122 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '4948'
123 0.0003 0.00025606155395508
SELECT * FROM productcustomimages WHERE product_id = '4948'
124 0.0010 0.00095915794372559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
125 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00047206878662109
SELECT * FROM productoffers
                WHERE product_id = '4948' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00054311752319336
SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0014 0.0013689994812012
SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
129 0.0006 0.00059986114501953
SELECT * FROM product_image_select WHERE product_id = '2698'
130 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '2698'
131 0.0010 0.001007080078125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2698' AND a.name = n.originalname
132 0.0006 0.00059103965759277
SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0006 0.00060105323791504
SELECT * FROM productoffers
                WHERE product_id = '2698' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0006 0.00057387351989746
SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0011 0.0010578632354736
SELECT * FROM productimages WHERE product_id = '1279' ORDER BY sortorder ASC
136 0.0005 0.00049901008605957
SELECT * FROM product_image_select WHERE product_id = '1279'
137 0.0004 0.00041007995605469
SELECT * FROM productcustomimages WHERE product_id = '1279'
138 0.0013 0.0012891292572021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1279' AND a.name = n.originalname
139 0.0005 0.0005190372467041
SELECT * FROM productoffers WHERE product_id = '1279' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0006 0.00055718421936035
SELECT * FROM productoffers
                WHERE product_id = '1279' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '1279' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0004 0.00037407875061035
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0003 0.0003211498260498
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0005 0.00047612190246582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0005 0.00052595138549805
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0006 0.00058293342590332
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0005 0.00048398971557617
SELECT * FROM productimages WHERE product_id = '2746' ORDER BY sortorder ASC
150 0.0004 0.00039100646972656
SELECT * FROM product_image_select WHERE product_id = '2746'
151 0.0004 0.00038886070251465
SELECT * FROM productcustomimages WHERE product_id = '2746'
152 0.0011 0.0011420249938965
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2746' AND a.name = n.originalname
153 0.0005 0.00052809715270996
SELECT * FROM productoffers WHERE product_id = '2746' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0007 0.00068116188049316
SELECT * FROM productoffers
                WHERE product_id = '2746' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0006 0.00060391426086426
SELECT value FROM productattributes WHERE product_id = '2746' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0012 0.0011999607086182
SELECT * FROM productimages WHERE product_id = '1070' ORDER BY sortorder ASC
157 0.0005 0.00054407119750977
SELECT * FROM product_image_select WHERE product_id = '1070'
158 0.0004 0.00042104721069336
SELECT * FROM productcustomimages WHERE product_id = '1070'
159 0.0012 0.0011889934539795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1070' AND a.name = n.originalname
160 0.0006 0.00057792663574219
SELECT * FROM productoffers WHERE product_id = '1070' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0006 0.000640869140625
SELECT * FROM productoffers
                WHERE product_id = '1070' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00061702728271484
SELECT value FROM productattributes WHERE product_id = '1070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0004 0.00035309791564941
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
164 0.0005 0.00045895576477051
SELECT * FROM product_image_select WHERE product_id = '923'
165 0.0005 0.00051212310791016
SELECT * FROM productcustomimages WHERE product_id = '923'
166 0.0012 0.0011742115020752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
167 0.0006 0.00056004524230957
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0007 0.00073385238647461
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0007 0.00066208839416504
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0004 0.00039482116699219
SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
171 0.0005 0.00046777725219727
SELECT * FROM product_image_select WHERE product_id = '1290'
172 0.0002 0.0002281665802002
SELECT * FROM productcustomimages WHERE product_id = '1290'
173 0.0014 0.0013589859008789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
174 0.0006 0.00059080123901367
SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0008 0.00076007843017578
SELECT * FROM productoffers
                WHERE product_id = '1290' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0006 0.00063705444335938
SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0005 0.00051784515380859
SELECT * FROM productimages WHERE product_id = '1285' ORDER BY sortorder ASC
178 0.0005 0.00050783157348633
SELECT * FROM product_image_select WHERE product_id = '1285'
179 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '1285'
180 0.0012 0.0012359619140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1285' AND a.name = n.originalname
181 0.0006 0.00057196617126465
SELECT * FROM productoffers WHERE product_id = '1285' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0007 0.00070405006408691
SELECT * FROM productoffers
                WHERE product_id = '1285' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0007 0.00067019462585449
SELECT value FROM productattributes WHERE product_id = '1285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0005 0.00045895576477051
SELECT * FROM productimages WHERE product_id = '4084' ORDER BY sortorder ASC
185 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '4084'
186 0.0005 0.00045514106750488
SELECT * FROM productcustomimages WHERE product_id = '4084'
187 0.0018 0.001798152923584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4084' AND a.name = n.originalname
188 0.0007 0.0007481575012207
SELECT * FROM productoffers WHERE product_id = '4084' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0007 0.00072789192199707
SELECT * FROM productoffers
                WHERE product_id = '4084' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0006 0.00058293342590332
SELECT value FROM productattributes WHERE product_id = '4084' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0005 0.00051498413085938
SELECT * FROM productimages WHERE product_id = '4921' ORDER BY sortorder ASC
192 0.0005 0.00046992301940918
SELECT * FROM product_image_select WHERE product_id = '4921'
193 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '4921'
194 0.0016 0.0015850067138672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4921' AND a.name = n.originalname
195 0.0007 0.00067996978759766
SELECT * FROM productoffers WHERE product_id = '4921' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0007 0.00069785118103027
SELECT * FROM productoffers
                WHERE product_id = '4921' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0008 0.00079202651977539
SELECT value FROM productattributes WHERE product_id = '4921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0005 0.00054097175598145
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
199 0.0004 0.00043821334838867
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
200 0.0004 0.00037908554077148
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
201 0.0004 0.0004119873046875
SELECT * FROM pages WHERE id = 38
202 0.0046 0.0045959949493408
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
203 0.0007 0.0007469654083252
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:1653093896;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
204 0.0007 0.00070786476135254
SELECT * FROM products WHERE id = 788
205 0.0007 0.00074005126953125
SELECT * FROM products WHERE id = 787
206 0.0007 0.00068807601928711
SELECT * FROM products WHERE id = 1287
207 0.0006 0.00059700012207031
SELECT * FROM products WHERE id = 780
208 0.0007 0.00069808959960938
SELECT * FROM products WHERE id = 777
209 0.0006 0.0006101131439209
SELECT * FROM products WHERE id = 776
210 0.0005 0.0004880428314209
SELECT * FROM products WHERE id = '788'
211 0.0003 0.0003058910369873
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
212 0.0003 0.00028204917907715
SELECT * FROM product_image_select WHERE product_id = '788'
213 0.0003 0.00028395652770996
SELECT * FROM productcustomimages WHERE product_id = '788'
214 0.0003 0.00034904479980469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
215 0.0005 0.00050210952758789
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0006 0.00060915946960449
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0003 0.00029206275939941
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0005 0.00050806999206543
SELECT * FROM products WHERE id = '787'
219 0.0003 0.00033712387084961
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
220 0.0003 0.00034093856811523
SELECT * FROM product_image_select WHERE product_id = '787'
221 0.0003 0.00029206275939941
SELECT * FROM productcustomimages WHERE product_id = '787'
222 0.0003 0.00030112266540527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
223 0.0004 0.00043010711669922
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00054502487182617
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0003 0.0003359317779541
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0007 0.00072002410888672
SELECT * FROM products WHERE id = '1287'
227 0.0003 0.00034523010253906
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
228 0.0003 0.00027608871459961
SELECT * FROM product_image_select WHERE product_id = '1287'
229 0.0003 0.0002591609954834
SELECT * FROM productcustomimages WHERE product_id = '1287'
230 0.0003 0.00033807754516602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
231 0.0005 0.00046777725219727
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0003 0.00032210350036621
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0006 0.00056910514831543
SELECT * FROM products WHERE id = '780'
235 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
236 0.0004 0.00035905838012695
SELECT * FROM product_image_select WHERE product_id = '780'
237 0.0003 0.00025510787963867
SELECT * FROM productcustomimages WHERE product_id = '780'
238 0.0004 0.00037884712219238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
239 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0005 0.00046110153198242
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0003 0.00026702880859375
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = '777'
243 0.0002 0.00024700164794922
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
244 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '777'
245 0.0002 0.00023102760314941
SELECT * FROM productcustomimages WHERE product_id = '777'
246 0.0003 0.00031590461730957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
247 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0005 0.00054287910461426
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0002 0.0002288818359375
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '776'
251 0.0004 0.00038385391235352
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
252 0.0003 0.00027990341186523
SELECT * FROM product_image_select WHERE product_id = '776'
253 0.0004 0.0003509521484375
SELECT * FROM productcustomimages WHERE product_id = '776'
254 0.0004 0.00040388107299805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
255 0.0005 0.00047492980957031
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0007 0.00069117546081543
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0003 0.00026082992553711
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0004 0.00043201446533203
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
259 0.0006 0.00055098533630371
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
260 0.0013 0.0013048648834229
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
261 0.0011 0.0011348724365234
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
262 0.0004 0.00037407875061035
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
263 0.0005 0.00050592422485352
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'ICON_RSS_FEED'
264 0.0006 0.00060510635375977
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
265 0.0005 0.00054121017456055
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
266 0.0004 0.00040006637573242
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
267 0.0005 0.00047421455383301
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'