Officeshots.org: Test ODF compatibility: Galleries

( ! ) Strict standards: Non-static method Debugger::invoke() should not be called statically, assuming $this from incompatible context in /home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php on line 574
Call Stack
#	Time	Memory	Function	Location
1	0.0005	249440	{main}( )	../index.php:0
2	0.0008	258432	include( '/home/sander/projects/officeshots/trunk/server/www/cake/bootstrap.php' )	../index.php:81
3	0.0115	1095240	Configure::getInstance( )	../bootstrap.php:43
4	0.0115	1095744	Configure->__loadBootstrap( )	../configure.php:137
5	0.0120	1130808	include( '/home/sander/projects/officeshots/trunk/server/www/app/config/core.php' )	../configure.php:648
6	0.0120	1131664	Configure->write( )	../core.php:41
7	0.0134	1257752	require( '/home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php' )	../configure.php:299

( ! ) Strict standards: Non-static method Debugger::invoke() should not be called statically, assuming $this from incompatible context in /home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php on line 574

Call Stack

Time

Memory

Function

Location

0.0005

249440

{main}( )

../index.php:0

0.0008

258432

include( '/home/sander/projects/officeshots/trunk/server/www/cake/bootstrap.php' )

../index.php:81

0.0115

1095240

Configure::getInstance( )

../bootstrap.php:43

0.0115

1095744

Configure->__loadBootstrap( )

../configure.php:137

0.0120

1130808

include( '/home/sander/projects/officeshots/trunk/server/www/app/config/core.php' )

../configure.php:648

0.0120

1131664

Configure->write( )

../core.php:41

0.0134

1257752

require( '/home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php' )

../configure.php:299

( ! ) Strict standards: Non-static method Debugger::getInstance() should not be called statically, assuming $this from incompatible context in /home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php on line 574
Call Stack
#	Time	Memory	Function	Location
1	0.0005	249440	{main}( )	../index.php:0
2	0.0008	258432	include( '/home/sander/projects/officeshots/trunk/server/www/cake/bootstrap.php' )	../index.php:81
3	0.0115	1095240	Configure::getInstance( )	../bootstrap.php:43
4	0.0115	1095744	Configure->__loadBootstrap( )	../configure.php:137
5	0.0120	1130808	include( '/home/sander/projects/officeshots/trunk/server/www/app/config/core.php' )	../configure.php:648
6	0.0120	1131664	Configure->write( )	../core.php:41
7	0.0134	1257752	require( '/home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php' )	../configure.php:299

( ! ) Strict standards: Non-static method Debugger::getInstance() should not be called statically, assuming $this from incompatible context in /home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php on line 574

Call Stack

Time

Memory

Function

Location

0.0005

249440

{main}( )

../index.php:0

0.0008

258432

include( '/home/sander/projects/officeshots/trunk/server/www/cake/bootstrap.php' )

../index.php:81

0.0115

1095240

Configure::getInstance( )

../bootstrap.php:43

0.0115

1095744

Configure->__loadBootstrap( )

../configure.php:137

0.0120

1130808

include( '/home/sander/projects/officeshots/trunk/server/www/app/config/core.php' )

../configure.php:648

0.0120

1131664

Configure->write( )

../core.php:41

0.0134

1257752

require( '/home/sander/projects/officeshots/trunk/server/www/cake/libs/debugger.php' )

../configure.php:299

Gallery

Page 1 of 1, showing 1 records out of 1 total, starting on record 1, ending on 1

Name	Documents	Owner
Shah & Kesan	7	Sander Marechal

<< previous

next >>

New Gallery

(default) 29 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `galleries`	12	12	1
2	DESCRIBE `groups`	7	7	1
3	DESCRIBE `permissions`	5	5	0
4	DESCRIBE `users`	7	7	1
5	DESCRIBE `factories`	9	9	1
6	DESCRIBE `operatingsystems`	7	7	0
7	DESCRIBE `platforms`	5	5	0
8	DESCRIBE `jobs`	13	13	1
9	DESCRIBE `requests`	20	20	1
10	DESCRIBE `validators`	7	7	1
11	DESCRIBE `results`	13	13	1
12	DESCRIBE `formats`	4	4	0
13	DESCRIBE `mimetypes`	6	6	0
14	DESCRIBE `doctypes`	4	4	0
15	DESCRIBE `applications`	5	5	0
16	DESCRIBE `workers`	8	8	0
17	DESCRIBE `doctypes_workers`	3	3	0
18	DESCRIBE `formats_workers`	3	3	0
19	DESCRIBE `applications_doctypes`	3	3	0
20	DESCRIBE `galleries_requests`	3	3	0
21	DESCRIBE `groups_users`	3	3	0
22	DESCRIBE `testsuites`	7	7	1
23	SELECT COUNT(*) AS `count` FROM `galleries` AS `Gallery` LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) WHERE `Gallery`.`parent_id` IS NULL	1	1	0
24	SELECT `Gallery`.`name`, `Gallery`.`slug`, `Gallery`.`user_id`, `Gallery`.`group_id`, `Gallery`.`description`, `Gallery`.`description_html`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`id`, `Gallery`.`parent_id`, `Gallery`.`lft`, `Gallery`.`rght`, `Group`.`id`, `Group`.`name`, `Group`.`request_limit`, `Group`.`default_memberlist`, `Group`.`created`, `Group`.`modified`, `Group`.`default`, `User`.`id`, `User`.`name`, `User`.`email_address`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `Testsuite`.`id`, `Testsuite`.`name`, `Testsuite`.`source`, `Testsuite`.`root`, `Testsuite`.`gallery_id`, `Testsuite`.`created`, `Testsuite`.`modified` FROM `galleries` AS `Gallery` LEFT JOIN `groups` AS `Group` ON (`Gallery`.`group_id` = `Group`.`id`) LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) LEFT JOIN `testsuites` AS `Testsuite` ON (`Testsuite`.`gallery_id` = `Gallery`.`id`) WHERE `Gallery`.`parent_id` IS NULL LIMIT 20	1	1	0
25	SELECT `Request`.`id`, `Request`.`user_id`, `Request`.`ip_address`, `Request`.`filename`, `Request`.`path`, `Request`.`page_start`, `Request`.`page_end`, `Request`.`priority`, `Request`.`own_factory`, `Request`.`state`, `Request`.`state_info`, `Request`.`job_count`, `Request`.`result_count`, `Request`.`expire`, `Request`.`created`, `Request`.`modified`, `Request`.`mimetype_id`, `Request`.`description`, `Request`.`description_html`, `Request`.`root`, `GalleriesRequest`.`id`, `GalleriesRequest`.`gallery_id`, `GalleriesRequest`.`request_id` FROM `requests` AS `Request` JOIN `galleries_requests` AS `GalleriesRequest` ON (`GalleriesRequest`.`gallery_id` = 2 AND `GalleriesRequest`.`request_id` = `Request`.`id`) WHERE 1 = 1	7	7	0
26	SELECT COUNT(*) AS `count` FROM `galleries_requests` AS `GalleriesRequest` WHERE `gallery_id` = 2	1	1	0
27	SELECT `Gallery`.`name`, `Gallery`.`slug`, `Gallery`.`user_id`, `Gallery`.`group_id`, `Gallery`.`description`, `Gallery`.`description_html`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`id`, `Gallery`.`parent_id`, `Gallery`.`lft`, `Gallery`.`rght`, `Group`.`id`, `Group`.`name`, `Group`.`request_limit`, `Group`.`default_memberlist`, `Group`.`created`, `Group`.`modified`, `Group`.`default`, `User`.`id`, `User`.`name`, `User`.`email_address`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `Testsuite`.`id`, `Testsuite`.`name`, `Testsuite`.`source`, `Testsuite`.`root`, `Testsuite`.`gallery_id`, `Testsuite`.`created`, `Testsuite`.`modified` FROM `galleries` AS `Gallery` LEFT JOIN `groups` AS `Group` ON (`Gallery`.`group_id` = `Group`.`id`) LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) LEFT JOIN `testsuites` AS `Testsuite` ON (`Testsuite`.`gallery_id` = `Gallery`.`id`) WHERE `Gallery`.`id` = 2 LIMIT 1	1	1	0
28	SELECT `Request`.`id`, `Request`.`user_id`, `Request`.`ip_address`, `Request`.`filename`, `Request`.`path`, `Request`.`page_start`, `Request`.`page_end`, `Request`.`priority`, `Request`.`own_factory`, `Request`.`state`, `Request`.`state_info`, `Request`.`job_count`, `Request`.`result_count`, `Request`.`expire`, `Request`.`created`, `Request`.`modified`, `Request`.`mimetype_id`, `Request`.`description`, `Request`.`description_html`, `Request`.`root`, `GalleriesRequest`.`id`, `GalleriesRequest`.`gallery_id`, `GalleriesRequest`.`request_id` FROM `requests` AS `Request` JOIN `galleries_requests` AS `GalleriesRequest` ON (`GalleriesRequest`.`gallery_id` = 2 AND `GalleriesRequest`.`request_id` = `Request`.`id`) WHERE 1 = 1	7	7	0
29	SELECT COUNT(*) as `count` FROM `requests` AS `Request` LEFT JOIN `galleries_requests` AS `GalleriesRequest` ON `Request`.`id` = `GalleriesRequest`.`request_id` LEFT JOIN `galleries` AS `Gallery` ON `GalleriesRequest`.`gallery_id` = `Gallery`.`id` WHERE `Gallery`.`lft` > 1 AND `Gallery`.`rght` < 2	1	1	0

(default) 29 queries took 9 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `galleries`

DESCRIBE `groups`

DESCRIBE `permissions`

DESCRIBE `users`

DESCRIBE `factories`

DESCRIBE `operatingsystems`

DESCRIBE `platforms`

DESCRIBE `jobs`

DESCRIBE `requests`

DESCRIBE `validators`

DESCRIBE `results`

DESCRIBE `formats`

DESCRIBE `mimetypes`

DESCRIBE `doctypes`

DESCRIBE `applications`

DESCRIBE `workers`

DESCRIBE `doctypes_workers`

DESCRIBE `formats_workers`

DESCRIBE `applications_doctypes`

DESCRIBE `galleries_requests`

DESCRIBE `groups_users`

DESCRIBE `testsuites`

SELECT COUNT(*) AS `count` FROM `galleries` AS `Gallery` LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) WHERE `Gallery`.`parent_id` IS NULL

SELECT `Gallery`.`name`, `Gallery`.`slug`, `Gallery`.`user_id`, `Gallery`.`group_id`, `Gallery`.`description`, `Gallery`.`description_html`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`id`, `Gallery`.`parent_id`, `Gallery`.`lft`, `Gallery`.`rght`, `Group`.`id`, `Group`.`name`, `Group`.`request_limit`, `Group`.`default_memberlist`, `Group`.`created`, `Group`.`modified`, `Group`.`default`, `User`.`id`, `User`.`name`, `User`.`email_address`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified`, `Testsuite`.`id`, `Testsuite`.`name`, `Testsuite`.`source`, `Testsuite`.`root`, `Testsuite`.`gallery_id`, `Testsuite`.`created`, `Testsuite`.`modified` FROM `galleries` AS `Gallery` LEFT JOIN `groups` AS `Group` ON (`Gallery`.`group_id` = `Group`.`id`) LEFT JOIN `users` AS `User` ON (`Gallery`.`user_id` = `User`.`id`) LEFT JOIN `testsuites` AS `Testsuite` ON (`Testsuite`.`gallery_id` = `Gallery`.`id`) WHERE `Gallery`.`parent_id` IS NULL LIMIT 20

SELECT `Request`.`id`, `Request`.`user_id`, `Request`.`ip_address`, `Request`.`filename`, `Request`.`path`, `Request`.`page_start`, `Request`.`page_end`, `Request`.`priority`, `Request`.`own_factory`, `Request`.`state`, `Request`.`state_info`, `Request`.`job_count`, `Request`.`result_count`, `Request`.`expire`, `Request`.`created`, `Request`.`modified`, `Request`.`mimetype_id`, `Request`.`description`, `Request`.`description_html`, `Request`.`root`, `GalleriesRequest`.`id`, `GalleriesRequest`.`gallery_id`, `GalleriesRequest`.`request_id` FROM `requests` AS `Request` JOIN `galleries_requests` AS `GalleriesRequest` ON (`GalleriesRequest`.`gallery_id` = 2 AND `GalleriesRequest`.`request_id` = `Request`.`id`) WHERE 1 = 1

SELECT COUNT(*) AS `count` FROM `galleries_requests` AS `GalleriesRequest` WHERE `gallery_id` = 2

SELECT COUNT(*) as `count` FROM `requests` AS `Request` LEFT JOIN `galleries_requests` AS `GalleriesRequest` ON `Request`.`id` = `GalleriesRequest`.`request_id` LEFT JOIN `galleries` AS `Gallery` ON `GalleriesRequest`.`gallery_id` = `Gallery`.`id` WHERE `Gallery`.`lft` > 1 AND `Gallery`.`rght` < 2