Business Mentality : Case Studies

Case Studies

Food production company

Contact was initially made with the Managing Director (MD) of this food production company, which employs approximately 70 people, through a business network.

Housing Association

This Business Mentality case study looks at how support from management contributes to employee wellbeing and productivity

<< previous

next >>

(default) 17 queries took 129 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ace8a9841c328b2b00b74c94321c6d8c'	1	1	7
2	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ace8a9841c328b2b00b74c94321c6d8c'	1		1
3	SELECT COUNT(*) AS `count` FROM `case_studies` AS `CaseStudy` WHERE `publish` = 1	1	1	20
4	SELECT `CaseStudy`.`id`, `CaseStudy`.`title`, `CaseStudy`.`short`, `CaseStudy`.`long`, `CaseStudy`.`image`, `CaseStudy`.`publish`, `CaseStudy`.`created`, `CaseStudy`.`modified` FROM `case_studies` AS `CaseStudy` WHERE `publish` = 1 ORDER BY `CaseStudy`.`created` DESC LIMIT 10	2	2	4
5	DESCRIBE `intros`	6	6	23
6	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'	1	1	1
7	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:3:{s:9:\"userAgent\";s:32:\"19548f45ccc2ca43afe09de0defe33eb\";s:4:\"time\";i:1283944166;s:7:\"timeout\";i:10;}Message\|a:1:{s:5:\"flash\";a:3:{s:7:\"message\";s:18:\"Invalid CaseStudy.\";s:6:\"layout\";s:7:\"default\";s:6:\"params\";a:0:{}}}', 1283944166, '6390183cd5de9ef32940dd8a0c002fb6')	1		1
8	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '6390183cd5de9ef32940dd8a0c002fb6'	1	1	0
9	SELECT `Intro`.`id`, `Intro`.`intro`, `Intro`.`title`, `Intro`.`page`, `Intro`.`created`, `Intro`.`modified` FROM `intros` AS `Intro` WHERE `Intro`.`page` = 'case_studies' LIMIT 1	1	1	1
10	DESCRIBE `columns`	10	10	30
11	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'	1	1	2
12	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"19548f45ccc2ca43afe09de0defe33eb\";s:4:\"time\";i:1283944166;s:7:\"timeout\";i:10;}Message\|a:1:{s:5:\"flash\";a:3:{s:7:\"message\";s:18:\"Invalid CaseStudy.\";s:6:\"layout\";s:7:\"default\";s:6:\"params\";a:0:{}}}', `expires` = 1283944166 WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'	0		1
13	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '6390183cd5de9ef32940dd8a0c002fb6'	1	1	1
14	SELECT `Column`.`id`, `Column`.`header`, `Column`.`title`, `Column`.`text`, `Column`.`link`, `Column`.`image`, `Column`.`page`, `Column`.`order`, `Column`.`created`, `Column`.`modified` FROM `columns` AS `Column` WHERE `page` = 'case_studies' ORDER BY `order` ASC	0	0	1
15	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'	1	1	4
16	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"19548f45ccc2ca43afe09de0defe33eb\";s:4:\"time\";i:1283944166;s:7:\"timeout\";i:10;}Message\|a:1:{s:5:\"flash\";a:3:{s:7:\"message\";s:18:\"Invalid CaseStudy.\";s:6:\"layout\";s:7:\"default\";s:6:\"params\";a:0:{}}}', `expires` = 1283944166 WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'	0		1
17	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283942966	51		31

(default) 17 queries took 129 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ace8a9841c328b2b00b74c94321c6d8c'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ace8a9841c328b2b00b74c94321c6d8c'

SELECT COUNT(*) AS `count` FROM `case_studies` AS `CaseStudy` WHERE `publish` = 1

SELECT `CaseStudy`.`id`, `CaseStudy`.`title`, `CaseStudy`.`short`, `CaseStudy`.`long`, `CaseStudy`.`image`, `CaseStudy`.`publish`, `CaseStudy`.`created`, `CaseStudy`.`modified` FROM `case_studies` AS `CaseStudy` WHERE `publish` = 1 ORDER BY `CaseStudy`.`created` DESC LIMIT 10

DESCRIBE `intros`

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'

INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:3:{s:9:\"userAgent\";s:32:\"19548f45ccc2ca43afe09de0defe33eb\";s:4:\"time\";i:1283944166;s:7:\"timeout\";i:10;}Message|a:1:{s:5:\"flash\";a:3:{s:7:\"message\";s:18:\"Invalid CaseStudy.\";s:6:\"layout\";s:7:\"default\";s:6:\"params\";a:0:{}}}', 1283944166, '6390183cd5de9ef32940dd8a0c002fb6')

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '6390183cd5de9ef32940dd8a0c002fb6'

SELECT `Intro`.`id`, `Intro`.`intro`, `Intro`.`title`, `Intro`.`page`, `Intro`.`created`, `Intro`.`modified` FROM `intros` AS `Intro` WHERE `Intro`.`page` = 'case_studies' LIMIT 1

DESCRIBE `columns`

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"19548f45ccc2ca43afe09de0defe33eb\";s:4:\"time\";i:1283944166;s:7:\"timeout\";i:10;}Message|a:1:{s:5:\"flash\";a:3:{s:7:\"message\";s:18:\"Invalid CaseStudy.\";s:6:\"layout\";s:7:\"default\";s:6:\"params\";a:0:{}}}', `expires` = 1283944166 WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '6390183cd5de9ef32940dd8a0c002fb6'

SELECT `Column`.`id`, `Column`.`header`, `Column`.`title`, `Column`.`text`, `Column`.`link`, `Column`.`image`, `Column`.`page`, `Column`.`order`, `Column`.`created`, `Column`.`modified` FROM `columns` AS `Column` WHERE `page` = 'case_studies' ORDER BY `order` ASC

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '6390183cd5de9ef32940dd8a0c002fb6'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283942966