How We Use Cookies

A cookie is a small piece of text sent to your browser by a website you visit. It helps the website to remember information about your visit like your preferred language, the contents of your basket and other settings. That can make your next visit easier and the site more useful to you. Cookies play an important role. Without them, using the web would be a much more frustrating experience.

We use cookies for many purposes to help our website improve and to make your experience better. We use them, for example, to count how many visitors we receive to a page. Our privacy policy explains how we protect your privacy in our use of cookies and other information.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.483270168304 152 0.0281 0


No Amazon API Requests Made.

Total time 0.483270168304 seconds

Number Time From Start Name Description
1 0.0536530017853 Initialise Initialise FSB Function
2 0.0546221733093 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0588600635529 Start of getCategoryListByGroup Function Before first category groups query
4 0.059011220932 After initial query Before first category groups query
5 0.0590131282806 Get Category List for Group Before the call to getCategoryList function
6 0.0590162277222 Start of GetCategoryList function Start of the function
7 0.0590200424194 Before getting categories Query to get specific category list
8 0.0592520236969 After getting categories Query to get specific category list
9 0.0592541694641 Before getting category custom Before call to function getCategoryCustom
10 0.0604581832886 After getting category custom After call to function getCategoryCustom
11 0.0604600906372 Before getting category custom Before call to function getCategoryCustom
12 0.0615651607513 After getting category custom After call to function getCategoryCustom
13 0.0615680217743 Before getting category custom Before call to function getCategoryCustom
14 0.062429189682 After getting category custom After call to function getCategoryCustom
15 0.0624310970306 Before getting category custom Before call to function getCategoryCustom
16 0.06316614151 After getting category custom After call to function getCategoryCustom
17 0.0631670951843 End of GetCategoryList function End of the function
18 0.063175201416 End of getCategoryListByGroup Function Before return()
19 0.0648121833801 App Controller End End of the App controller (called before the controller of every page)
20 0.0732932090759 App_after Controller Start Start of the App_after controller (called after the controller of every page)
21 0.0733671188354 Before Get Options Before the call to getOptions in the tpl class
22 0.0920341014862 After Get Options After the call to getOptions in the tpl class
23 0.0920851230621 App_after Controller End End of the App_after controller (called after the controller of every page)
24 0.483251094818 Finalizing debug Before the debug is output to the page.
25 0.483268022537 End of App This is the end of the app logging, final timestamp


Query Debug - 152 Database Queries. Total time 0.0281 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000371932983398
SELECT parameter, value FROM parameters
2 0.0002 0.000185966491699
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000174045562744
SET time_zone = 'Europe/London'
4 0.0003 0.000279903411865
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000198841094971
UPDATE autorun SET lastrun = '2017-07-20 20:47:59' WHERE id = '10'
6 0.0002 0.000150918960571
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0002 0.000190019607544
SELECT id FROM pages WHERE pagename = 'cookie-consent' LIMIT 1
8 0.0002 0.0001540184021
SELECT * FROM pages WHERE id = 43
9 0.0004 0.000360012054443
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
10 0.0030 0.00300788879395
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
11 0.0002 0.00021505355835
SELECT * FROM pages WHERE pagename = 'cookie-consent'
12 0.0001 0.000135183334351
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0002 0.00020694732666
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
14 0.0003 0.000267028808594
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
15 0.0001 0.000141859054565
SELECT id FROM categories WHERE parent_id = '67'
16 0.0002 0.000233888626099
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
17 0.0001 0.000148057937622
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
18 0.0002 0.000154972076416
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
19 0.0001 0.000140905380249
SELECT * FROM categorygroups WHERE id = '10'
20 0.0002 0.000242948532104
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
21 0.0002 0.000150918960571
SELECT id FROM categories WHERE parent_id = '68'
22 0.0002 0.000201940536499
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
23 0.0001 0.000128030776978
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
24 0.0002 0.0001540184021
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
25 0.0001 0.000118017196655
SELECT * FROM categorygroups WHERE id = '10'
26 0.0002 0.000175952911377
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
27 0.0001 0.000104904174805
SELECT id FROM categories WHERE parent_id = '69'
28 0.0002 0.000185966491699
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
29 0.0001 0.000111103057861
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
30 0.0001 0.000114917755127
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
31 0.0001 0.000102043151855
SELECT * FROM categorygroups WHERE id = '10'
32 0.0001 0.000142812728882
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
33 0.0001 0.000102043151855
SELECT id FROM categories WHERE parent_id = '70'
34 0.0002 0.000154972076416
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
35 0.0001 0.000112056732178
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
36 0.0001 8.89301300049E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
37 0.0001 7.70092010498E-5
SELECT * FROM categorygroups WHERE id = '10'
38 0.0002 0.000174045562744
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
39 0.0001 0.000130176544189
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
40 0.0001 8.20159912109E-5
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
41 0.0001 9.91821289062E-5
SELECT * FROM pages WHERE id = '37'
42 0.0001 8.70227813721E-5
SELECT * FROM pages WHERE id = '4'
43 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = '34'
44 0.0001 8.10623168945E-5
SELECT * FROM pages WHERE id = '3'
45 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = '24'
46 0.0001 7.9870223999E-5
SELECT * FROM pages WHERE id = '5'
47 0.0001 8.58306884766E-5
SELECT * FROM pages WHERE id = '38'
48 0.0001 8.6784362793E-5
SELECT * FROM pages WHERE id = '39'
49 0.0002 0.000159978866577
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
50 0.0002 0.000229835510254
SELECT * FROM pages WHERE pagename = 'cookie-consent'
51 0.0002 0.000198125839233
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
52 0.0002 0.000188112258911
SELECT * FROM pages WHERE id = 2
53 0.0002 0.000186920166016
SELECT * FROM pages WHERE id = 38
54 0.0002 0.000186204910278
SELECT * FROM pages WHERE id = 39
55 0.0002 0.000186920166016
SELECT * FROM pages WHERE id = 6
56 0.0002 0.000191926956177
SELECT * FROM pages WHERE id = 7
57 0.0002 0.000184059143066
SELECT * FROM pages WHERE id = 32
58 0.0002 0.000159025192261
SELECT * FROM pages WHERE id = 2
59 0.0001 0.000128984451294
SELECT * FROM pages WHERE id = 28
60 0.0001 0.000128984451294
SELECT * FROM pages WHERE id = 13
61 0.0001 0.000133991241455
SELECT * FROM pages WHERE id = 24
62 0.0002 0.000205993652344
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
63 0.0002 0.000154972076416
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
64 0.0001 0.000118017196655
SELECT * FROM product_image_select WHERE product_id = '53141'
65 0.0001 0.000113010406494
SELECT * FROM productcustomimages WHERE product_id = '53141'
66 0.0006 0.000608205795288
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
67 0.0002 0.00015115737915
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
68 0.0002 0.000156879425049
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
69 0.0002 0.000216007232666
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
70 0.0001 0.000116109848022
UPDATE products SET price = '44900' WHERE id = '53141'
71 0.0001 0.00012993812561
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
72 0.0001 0.000105857849121
SELECT * FROM product_image_select WHERE product_id = '53155'
73 0.0001 9.70363616943E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
74 0.0005 0.000510931015015
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
75 0.0001 0.000134944915771
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
76 0.0001 0.000142097473145
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
77 0.0002 0.000196218490601
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
78 0.0001 0.000108957290649
UPDATE products SET price = '1595' WHERE id = '53155'
79 0.0001 0.000126123428345
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
80 0.0001 0.000111103057861
SELECT * FROM product_image_select WHERE product_id = '53159'
81 0.0001 9.79900360107E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
82 0.0005 0.000530958175659
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
83 0.0001 0.000133991241455
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
84 0.0001 0.000143051147461
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
85 0.0002 0.000208854675293
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
86 0.0001 0.000108957290649
UPDATE products SET price = '1146' WHERE id = '53159'
87 0.0001 0.000133037567139
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
88 0.0001 0.000102996826172
SELECT * FROM product_image_select WHERE product_id = '53160'
89 0.0001 7.39097595215E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
90 0.0004 0.000381946563721
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
91 0.0001 0.0001220703125
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
92 0.0001 0.000113964080811
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
93 0.0002 0.000152111053467
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
94 0.0001 8.17775726318E-5
UPDATE products SET price = '471' WHERE id = '53160'
95 0.0001 9.98973846436E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
96 0.0001 7.60555267334E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
97 0.0001 7.41481781006E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
98 0.0006 0.000570774078369
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
99 0.0001 0.000108957290649
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
100 0.0001 0.000112056732178
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
101 0.0002 0.000179052352905
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0001 8.29696655273E-5
UPDATE products SET price = '1510' WHERE id = '53162'
103 0.0001 0.000105142593384
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
104 0.0001 7.70092010498E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
105 0.0001 7.10487365723E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
106 0.0005 0.000459909439087
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
107 0.0001 0.000113010406494
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
108 0.0001 0.000112056732178
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
109 0.0001 0.000144958496094
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0001 8.20159912109E-5
UPDATE products SET price = '3395' WHERE id = '53167'
111 0.0001 9.89437103271E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
112 0.0001 7.58171081543E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
113 0.0001 7.10487365723E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
114 0.0004 0.000447988510132
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
115 0.0001 0.000113010406494
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
116 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
117 0.0001 9.60826873779E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
118 0.0001 0.000111818313599
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
119 0.0001 8.17775726318E-5
UPDATE products SET price = '6995' WHERE id = '53186'
120 0.0001 0.000103950500488
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
121 0.0001 7.79628753662E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
122 0.0001 6.98566436768E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
123 0.0005 0.000542879104614
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
124 0.0001 0.000102996826172
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
125 0.0001 0.000111103057861
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
126 0.0002 0.000169992446899
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0001 8.29696655273E-5
UPDATE products SET price = '1998' WHERE id = '53187'
128 0.0001 9.70363616943E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
129 0.0001 7.29560852051E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
130 0.0001 7.00950622559E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
131 0.0004 0.000447988510132
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
132 0.0001 0.000116109848022
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
133 0.0001 0.000112056732178
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
134 0.0002 0.00015115737915
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0001 7.91549682617E-5
UPDATE products SET price = '2854' WHERE id = '53188'
136 0.0001 9.51290130615E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
137 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
138 0.0001 6.69956207275E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
139 0.0005 0.000472784042358
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
140 0.0001 0.000115871429443
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
141 0.0001 0.000109195709229
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
142 0.0002 0.000164031982422
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0001 8.08238983154E-5
UPDATE products SET price = '3597' WHERE id = '53196'
144 0.0002 0.000185012817383
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
145 0.0002 0.000169038772583
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
146 0.0004 0.000406980514526
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
147 0.0002 0.000154972076416
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
148 0.0001 0.000144004821777
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
149 0.0004 0.000407934188843
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
150 0.0003 0.000348091125488
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
151 0.0002 0.000231027603149
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
152 0.0004 0.000379085540771
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'