Brands

Hello!

See all the brands we stock below, and click to view the products from each brand. We are proud to stock only the finest products from the finest manufacturers.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.22519493103 154 0.0274 0


No Amazon API Requests Made.

Total time 0.22519493103 seconds

Number Time From Start Name Description
1 0.0477180480957 Initialise Initialise FSB Function
2 0.0486538410187 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0526509284973 Start of getCategoryListByGroup Function Before first category groups query
4 0.0527620315552 After initial query Before first category groups query
5 0.0527639389038 Get Category List for Group Before the call to getCategoryList function
6 0.0527670383453 Start of GetCategoryList function Start of the function
7 0.0527720451355 Before getting categories Query to get specific category list
8 0.0529580116272 After getting categories Query to get specific category list
9 0.0529599189758 Before getting category custom Before call to function getCategoryCustom
10 0.0541379451752 After getting category custom After call to function getCategoryCustom
11 0.0541398525238 Before getting category custom Before call to function getCategoryCustom
12 0.0549578666687 After getting category custom After call to function getCategoryCustom
13 0.0549600124359 Before getting category custom Before call to function getCategoryCustom
14 0.0557389259338 After getting category custom After call to function getCategoryCustom
15 0.055741071701 Before getting category custom Before call to function getCategoryCustom
16 0.0565738677979 After getting category custom After call to function getCategoryCustom
17 0.0565760135651 End of GetCategoryList function End of the function
18 0.0565848350525 End of getCategoryListByGroup Function Before return()
19 0.0585470199585 App Controller End End of the App controller (called before the controller of every page)
20 0.0611319541931 App_after Controller Start Start of the App_after controller (called after the controller of every page)
21 0.0611970424652 Before Get Options Before the call to getOptions in the tpl class
22 0.0793929100037 After Get Options After the call to getOptions in the tpl class
23 0.0794429779053 App_after Controller End End of the App_after controller (called after the controller of every page)
24 0.22517490387 Finalizing debug Before the debug is output to the page.
25 0.225193977356 End of App This is the end of the app logging, final timestamp


Query Debug - 154 Database Queries. Total time 0.0274 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.0003821849823
SELECT parameter, value FROM parameters
2 0.0001 0.000149011611938
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0001 0.000142097473145
SET time_zone = 'Europe/London'
4 0.0003 0.000313997268677
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0001 0.000146865844727
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0002 0.0001540184021
SELECT id FROM pages WHERE pagename = 'brands' LIMIT 1
7 0.0002 0.000171899795532
SELECT * FROM pages WHERE id = 17
8 0.0003 0.000340223312378
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
9 0.0029 0.0028669834137
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
10 0.0002 0.000185966491699
SELECT * FROM pages WHERE pagename = 'brands'
11 0.0001 9.70363616943E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
12 0.0002 0.000152111053467
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
13 0.0002 0.00023889541626
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 = 67
14 0.0001 0.000142097473145
SELECT id FROM categories WHERE parent_id = '67'
15 0.0002 0.000220060348511
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
16 0.0002 0.000150918960571
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (67)
				  AND p.disabled = 0 AND offers > 0
17 0.0002 0.000155925750732
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
18 0.0001 0.00012993812561
SELECT * FROM categorygroups WHERE id = '10'
19 0.0002 0.000204086303711
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 = 68
20 0.0001 8.6784362793E-5
SELECT id FROM categories WHERE parent_id = '68'
21 0.0002 0.000164031982422
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
22 0.0001 9.20295715332E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (68)
				  AND p.disabled = 0 AND offers > 0
23 0.0001 9.98973846436E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
24 0.0001 8.70227813721E-5
SELECT * FROM categorygroups WHERE id = '10'
25 0.0002 0.000159978866577
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 = 69
26 0.0001 8.58306884766E-5
SELECT id FROM categories WHERE parent_id = '69'
27 0.0002 0.000169992446899
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
28 0.0001 9.29832458496E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 AND offers > 0
29 0.0001 9.89437103271E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
30 0.0001 8.48770141602E-5
SELECT * FROM categorygroups WHERE id = '10'
31 0.0002 0.000158071517944
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 = 70
32 0.0001 0.000104904174805
SELECT id FROM categories WHERE parent_id = '70'
33 0.0002 0.0001540184021
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (70)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
34 0.0001 9.29832458496E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 AND offers > 0
35 0.0001 9.98973846436E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
36 0.0001 8.70227813721E-5
SELECT * FROM categorygroups WHERE id = '10'
37 0.0002 0.000207901000977
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
38 0.0001 0.000138998031616
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
39 0.0001 9.70363616943E-5
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
40 0.0001 0.000111818313599
SELECT * FROM pages WHERE id = '37'
41 0.0001 9.58442687988E-5
SELECT * FROM pages WHERE id = '4'
42 0.0001 0.000121831893921
SELECT * FROM pages WHERE id = '34'
43 0.0001 0.000105857849121
SELECT * FROM pages WHERE id = '3'
44 0.0001 0.000108957290649
SELECT * FROM pages WHERE id = '24'
45 0.0001 0.000120878219604
SELECT * FROM pages WHERE id = '5'
46 0.0001 0.000113964080811
SELECT * FROM pages WHERE id = '38'
47 0.0001 0.000108003616333
SELECT * FROM pages WHERE id = '39'
48 0.0002 0.000169992446899
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
49 0.0001 0.000128984451294
SELECT * FROM pages WHERE pagename = 'brands'
50 0.0002 0.000239133834839
SELECT COUNT(DISTINCT(m.id)) as `manufacturercount`
                    FROM manufacturers m, products p
                    WHERE   m.id = p.manufacturer_id
                    AND     m.display_allmanufacturers = 1
                    AND     p.enabled   = 1
                    AND     p.hidden    = 0
                    AND     p.parent_id = 0
                    AND     p.offers    > 0
51 0.0004 0.000417947769165
SELECT  m.*, COUNT(p.id) as productcount
            FROM    manufacturers m, products p
            WHERE   p.manufacturer_id = m.id
              AND   m.display_allmanufacturers = 1
              AND   p.enabled   = 1
              AND   p.hidden    = 0
              AND   p.parent_id = 0
              AND   p.offers    > 0
            GROUP BY m.id
            ORDER BY name ASC
            LIMIT 0, 12
52 0.0002 0.000178098678589
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
53 0.0001 0.000109910964966
SELECT * FROM pages WHERE id = 2
54 0.0001 9.98973846436E-5
SELECT * FROM pages WHERE id = 38
55 0.0001 0.000123023986816
SELECT * FROM pages WHERE id = 39
56 0.0001 0.000118970870972
SELECT * FROM pages WHERE id = 6
57 0.0001 0.000107049942017
SELECT * FROM pages WHERE id = 7
58 0.0001 0.000137090682983
SELECT * FROM pages WHERE id = 32
59 0.0001 0.000108003616333
SELECT * FROM pages WHERE id = 2
60 0.0001 0.000108003616333
SELECT * FROM pages WHERE id = 28
61 0.0001 0.000121831893921
SELECT * FROM pages WHERE id = 13
62 0.0001 0.000108003616333
SELECT * FROM pages WHERE id = 24
63 0.0002 0.000198125839233
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
64 0.0001 0.000123023986816
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
65 0.0001 8.39233398438E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
66 0.0001 7.91549682617E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
67 0.0005 0.000517129898071
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
68 0.0001 0.000118017196655
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
69 0.0001 0.000120162963867
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
70 0.0002 0.000180006027222
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
71 0.0001 0.000118970870972
UPDATE products SET price = '44900' WHERE id = '53141'
72 0.0001 0.000108003616333
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
73 0.0001 8.08238983154E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
74 0.0001 7.91549682617E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
75 0.0005 0.000519990921021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
76 0.0001 0.000113010406494
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
77 0.0001 0.000117063522339
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
78 0.0002 0.000166893005371
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
79 0.0001 9.08374786377E-5
UPDATE products SET price = '1595' WHERE id = '53155'
80 0.0001 0.000102043151855
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
81 0.0001 8.20159912109E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
82 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
83 0.0005 0.000471115112305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
84 0.0001 0.000112056732178
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
85 0.0001 0.000118970870972
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
86 0.0002 0.000180959701538
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
87 0.0001 8.6784362793E-5
UPDATE products SET price = '998' WHERE id = '53159'
88 0.0001 0.000108957290649
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
89 0.0001 9.48905944824E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
90 0.0001 9.10758972168E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
91 0.0004 0.000379800796509
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
92 0.0001 0.000111103057861
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
93 0.0001 0.000120878219604
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
94 0.0002 0.0001540184021
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
95 0.0001 8.70227813721E-5
UPDATE products SET price = '471' WHERE id = '53160'
96 0.0001 0.000104188919067
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
97 0.0001 9.48905944824E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
98 0.0001 9.3936920166E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
99 0.0005 0.000542163848877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
100 0.0001 0.000113010406494
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
101 0.0001 0.000118017196655
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
102 0.0002 0.000179052352905
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0001 8.70227813721E-5
UPDATE products SET price = '1510' WHERE id = '53162'
104 0.0001 0.000112056732178
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
105 0.0001 8.29696655273E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
106 0.0001 7.82012939453E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
107 0.0004 0.000440835952759
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
108 0.0001 0.000116109848022
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
109 0.0001 0.000119209289551
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
110 0.0001 0.000148057937622
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0001 8.70227813721E-5
UPDATE products SET price = '3395' WHERE id = '53167'
112 0.0001 0.000102996826172
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
113 0.0001 8.41617584229E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
114 0.0001 9.01222229004E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
115 0.0004 0.000442028045654
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
116 0.0001 0.000134944915771
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
117 0.0001 0.000133991241455
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
118 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
119 0.0001 0.000118970870972
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
120 0.0001 9.08374786377E-5
UPDATE products SET price = '6995' WHERE id = '53186'
121 0.0001 0.000109910964966
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
122 0.0001 0.000108003616333
SELECT * FROM product_image_select WHERE product_id = '53187'
123 0.0001 7.79628753662E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
124 0.0005 0.000530004501343
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
125 0.0001 0.000140905380249
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
126 0.0001 0.000115871429443
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
127 0.0002 0.000174045562744
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0001 8.79764556885E-5
UPDATE products SET price = '1998' WHERE id = '53187'
129 0.0001 0.000104904174805
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
130 0.0001 8.10623168945E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
131 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
132 0.0005 0.000450134277344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
133 0.0001 0.000113010406494
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
134 0.0001 0.00011682510376
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
135 0.0002 0.000162124633789
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0001 8.70227813721E-5
UPDATE products SET price = '2854' WHERE id = '53188'
137 0.0001 0.000105857849121
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
138 0.0001 8.08238983154E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
139 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
140 0.0005 0.00049614906311
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
141 0.0001 0.000111103057861
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
142 0.0002 0.000202178955078
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
143 0.0002 0.00016713142395
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0001 8.70227813721E-5
UPDATE products SET price = '3597' WHERE id = '53196'
145 0.0002 0.000185012817383
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
146 0.0002 0.000164985656738
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
147 0.0004 0.000423192977905
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
148 0.0002 0.00019097328186
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
149 0.0002 0.000198841094971
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
150 0.0004 0.000350952148438
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'ICON_RSS_FEED'
151 0.0004 0.000360012054443
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
152 0.0003 0.000275850296021
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
153 0.0002 0.000247001647949
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
154 0.0003 0.000289916992188
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'