The Portable Generator Shop Newsletter

Sign up to our amazing newsletter below and receive the latest tips, promotions, special offers and more!


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.119888067245 151 0.0247 0


No Amazon API Requests Made.

Total time 0.119888067245 seconds

Number Time From Start Name Description
1 0.0523691177368 Initialise Initialise FSB Function
2 0.0533661842346 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0574851036072 Start of getCategoryListByGroup Function Before first category groups query
4 0.0576369762421 After initial query Before first category groups query
5 0.0576391220093 Get Category List for Group Before the call to getCategoryList function
6 0.0576419830322 Start of GetCategoryList function Start of the function
7 0.0576481819153 Before getting categories Query to get specific category list
8 0.0578770637512 After getting categories Query to get specific category list
9 0.0578789710999 Before getting category custom Before call to function getCategoryCustom
10 0.0590071678162 After getting category custom After call to function getCategoryCustom
11 0.0590090751648 Before getting category custom Before call to function getCategoryCustom
12 0.0599241256714 After getting category custom After call to function getCategoryCustom
13 0.05992603302 Before getting category custom Before call to function getCategoryCustom
14 0.060779094696 After getting category custom After call to function getCategoryCustom
15 0.0607800483704 Before getting category custom Before call to function getCategoryCustom
16 0.0614039897919 After getting category custom After call to function getCategoryCustom
17 0.0614061355591 End of GetCategoryList function End of the function
18 0.0614140033722 End of getCategoryListByGroup Function Before return()
19 0.0630259513855 App Controller End End of the App controller (called before the controller of every page)
20 0.0646669864655 App_after Controller Start Start of the App_after controller (called after the controller of every page)
21 0.0647320747375 Before Get Options Before the call to getOptions in the tpl class
22 0.0810830593109 After Get Options After the call to getOptions in the tpl class
23 0.0811309814453 App_after Controller End End of the App_after controller (called after the controller of every page)
24 0.119873046875 Finalizing debug Before the debug is output to the page.
25 0.119887113571 End of App This is the end of the app logging, final timestamp


Query Debug - 151 Database Queries. Total time 0.0247 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000351905822754
SELECT parameter, value FROM parameters
2 0.0002 0.000175952911377
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000165939331055
SET time_zone = 'Europe/London'
4 0.0003 0.000274896621704
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000175952911377
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0002 0.00019907951355
SELECT id FROM pages WHERE pagename = 'newsletter' LIMIT 1
7 0.0002 0.000159025192261
SELECT * FROM pages WHERE id = 5
8 0.0004 0.000352144241333
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
9 0.0029 0.00293588638306
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
10 0.0002 0.00019907951355
SELECT * FROM pages WHERE pagename = 'newsletter'
11 0.0001 0.000135898590088
SELECT * FROM categorygroups ORDER BY sortorder ASC
12 0.0002 0.000205039978027
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
13 0.0003 0.00026798248291
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.0001380443573
SELECT id FROM categories WHERE parent_id = '67'
15 0.0002 0.000234127044678
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.0001 0.000146150588989
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.0001 0.000120878219604
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
18 0.0001 0.000125885009766
SELECT * FROM categorygroups WHERE id = '10'
19 0.0002 0.000159025192261
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 0.000127792358398
SELECT id FROM categories WHERE parent_id = '68'
21 0.0002 0.000211954116821
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 0.000133037567139
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 0.000121116638184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
24 0.0001 0.000103950500488
SELECT * FROM categorygroups WHERE id = '10'
25 0.0002 0.000179052352905
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 0.000105142593384
SELECT id FROM categories WHERE parent_id = '69'
27 0.0002 0.000187158584595
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 0.000110864639282
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 0.000113964080811
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
30 0.0001 0.000101089477539
SELECT * FROM categorygroups WHERE id = '10'
31 0.0001 0.000113964080811
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 7.70092010498E-5
SELECT id FROM categories WHERE parent_id = '70'
33 0.0001 0.000132083892822
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 8.20159912109E-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 8.60691070557E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
36 0.0001 7.60555267334E-5
SELECT * FROM categorygroups WHERE id = '10'
37 0.0002 0.000166893005371
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
38 0.0001 0.000123023986816
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
39 0.0001 8.17775726318E-5
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
40 0.0001 9.60826873779E-5
SELECT * FROM pages WHERE id = '37'
41 0.0001 9.10758972168E-5
SELECT * FROM pages WHERE id = '4'
42 0.0001 8.29696655273E-5
SELECT * FROM pages WHERE id = '34'
43 0.0001 8.39233398438E-5
SELECT * FROM pages WHERE id = '3'
44 0.0001 8.10623168945E-5
SELECT * FROM pages WHERE id = '24'
45 0.0001 8.10623168945E-5
SELECT * FROM pages WHERE id = '5'
46 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = '38'
47 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = '39'
48 0.0002 0.000154972076416
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
49 0.0001 0.000103950500488
SELECT * FROM pages WHERE pagename = 'newsletter'
50 0.0001 9.60826873779E-5
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
51 0.0001 8.70227813721E-5
SELECT * FROM pages WHERE id = 2
52 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = 38
53 0.0001 8.60691070557E-5
SELECT * FROM pages WHERE id = 39
54 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = 6
55 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = 7
56 0.0001 7.67707824707E-5
SELECT * FROM pages WHERE id = 32
57 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = 2
58 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = 28
59 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = 13
60 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = 24
61 0.0002 0.000174999237061
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
62 0.0001 0.000103950500488
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
63 0.0001 7.00950622559E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
64 0.0001 6.5803527832E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
65 0.0005 0.000512838363647
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
66 0.0001 0.000102996826172
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
67 0.0001 0.000108003616333
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
68 0.0002 0.000166177749634
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
69 0.0001 8.08238983154E-5
UPDATE products SET price = '44900' WHERE id = '53141'
70 0.0001 9.58442687988E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
71 0.0001 7.00950622559E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
72 0.0001 6.50882720947E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
73 0.0004 0.000448942184448
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
74 0.0001 9.89437103271E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
75 0.0001 0.000104904174805
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
76 0.0002 0.0001540184021
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
77 0.0001 7.58171081543E-5
UPDATE products SET price = '1595' WHERE id = '53155'
78 0.0001 9.10758972168E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
79 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
80 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
81 0.0005 0.000469923019409
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
82 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
83 0.0001 0.000104904174805
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
84 0.0002 0.000166893005371
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
85 0.0001 7.60555267334E-5
UPDATE products SET price = '998' WHERE id = '53159'
86 0.0001 0.000102996826172
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
87 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
88 0.0001 6.48498535156E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
89 0.0003 0.000336885452271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
90 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
91 0.0001 0.000104904174805
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
92 0.0001 0.000144958496094
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
93 0.0001 7.70092010498E-5
UPDATE products SET price = '471' WHERE id = '53160'
94 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
95 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
96 0.0001 6.48498535156E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
97 0.0005 0.000535011291504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
98 0.0001 0.000102996826172
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
99 0.0001 0.000104904174805
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
100 0.0002 0.000162839889526
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0001 7.60555267334E-5
UPDATE products SET price = '1510' WHERE id = '53162'
102 0.0001 9.70363616943E-5
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
103 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
104 0.0001 6.50882720947E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
105 0.0005 0.000485897064209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
106 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
107 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
108 0.0001 0.000132083892822
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0001 7.5101852417E-5
UPDATE products SET price = '3395' WHERE id = '53167'
110 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
111 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
112 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
113 0.0004 0.00042200088501
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
114 0.0001 0.000119209289551
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
115 0.0001 0.000107049942017
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
116 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
117 0.0001 0.000131130218506
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
118 0.0001 7.60555267334E-5
UPDATE products SET price = '6995' WHERE id = '53186'
119 0.0001 0.000121116638184
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
120 0.0001 8.01086425781E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
121 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
122 0.0005 0.000526905059814
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
123 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
124 0.0002 0.000160932540894
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
125 0.0002 0.000170946121216
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0001 8.60691070557E-5
UPDATE products SET price = '1998' WHERE id = '53187'
127 0.0001 0.000102996826172
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
128 0.0001 9.32216644287E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
129 0.0001 8.98838043213E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
130 0.0004 0.000427961349487
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
131 0.0001 0.000109910964966
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
132 0.0001 0.000114917755127
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
133 0.0001 0.000144004821777
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0001 0.00010085105896
UPDATE products SET price = '2854' WHERE id = '53188'
135 0.0001 8.79764556885E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
136 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
137 0.0001 7.9870223999E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
138 0.0005 0.000472068786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
139 0.0001 0.000120162963867
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
140 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
141 0.0002 0.0001540184021
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0001 0.0001060962677
UPDATE products SET price = '3597' WHERE id = '53196'
143 0.0002 0.000195980072021
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
144 0.0002 0.000170946121216
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
145 0.0004 0.000391960144043
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
146 0.0002 0.000159025192261
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
147 0.0002 0.00016188621521
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
148 0.0003 0.000326871871948
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
149 0.0002 0.000226974487305
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
150 0.0002 0.000224113464355
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
151 0.0002 0.000244855880737
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'