• Terza Categoria

Uploader: kak�saba

Uploader: Tommy_SamPa!!!

Pagina 2 di 9
<< Precedente 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 Successivo >>

(default) 8 queries took 69 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `galleries`	5	5	6
2	DESCRIBE `albums`	10	10	6
3	DESCRIBE `menus`	9	9	7
4	DESCRIBE `sponsors`	4	4	5
5	SELECT COUNT(*) AS `count` FROM `galleries` AS `Gallery` LEFT JOIN `albums` AS `Album` ON (`Gallery`.`album_id` = `Album`.`id`) LEFT JOIN `albums` AS `Album2` ON (`Gallery`.`album_id` = `Album2`.`id`) LEFT JOIN `albums` AS `Album3` ON (`Gallery`.`album_id` = `Album3`.`id`) WHERE `album_id` = 52 AND `published` = 1	1	1	3
6	SELECT `Gallery`.`id`, `Gallery`.`album_id`, `Gallery`.`user_id`, `Gallery`.`imgpath`, `Gallery`.`published`, `Album`.`id`, `Album`.`parent_id`, `Album`.`lft`, `Album`.`rght`, `Album`.`name`, `Album`.`url`, `Album`.`description`, `Album`.`gallery_count`, `Album`.`gallery_published_count`, `Album`.`gallery_nopublished_count`, `Album2`.`id`, `Album2`.`parent_id`, `Album2`.`lft`, `Album2`.`rght`, `Album2`.`name`, `Album2`.`url`, `Album2`.`description`, `Album2`.`gallery_count`, `Album2`.`gallery_published_count`, `Album2`.`gallery_nopublished_count`, `Album3`.`id`, `Album3`.`parent_id`, `Album3`.`lft`, `Album3`.`rght`, `Album3`.`name`, `Album3`.`url`, `Album3`.`description`, `Album3`.`gallery_count`, `Album3`.`gallery_published_count`, `Album3`.`gallery_nopublished_count` FROM `galleries` AS `Gallery` LEFT JOIN `albums` AS `Album` ON (`Gallery`.`album_id` = `Album`.`id`) LEFT JOIN `albums` AS `Album2` ON (`Gallery`.`album_id` = `Album2`.`id`) LEFT JOIN `albums` AS `Album3` ON (`Gallery`.`album_id` = `Album3`.`id`) WHERE `album_id` = 52 AND `published` = 1 ORDER BY `Gallery`.`id` DESC LIMIT 35, 35	35	35	33
7	SELECT `Album`.`id`, `Album`.`parent_id`, `Album`.`lft`, `Album`.`rght`, `Album`.`name`, `Album`.`url`, `Album`.`description`, `Album`.`gallery_count`, `Album`.`gallery_published_count`, `Album`.`gallery_nopublished_count` FROM `albums` AS `Album` WHERE `parent_id` = 52 ORDER BY `Album`.`lft` ASC	0	0	4
8	SELECT `Album`.`name` FROM `albums` AS `Album` WHERE `id` = 52 LIMIT 1	1	1	5

(default) 8 queries took 69 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `galleries`

DESCRIBE `albums`

DESCRIBE `menus`

DESCRIBE `sponsors`

SELECT COUNT(*) AS `count` FROM `galleries` AS `Gallery` LEFT JOIN `albums` AS `Album` ON (`Gallery`.`album_id` = `Album`.`id`) LEFT JOIN `albums` AS `Album2` ON (`Gallery`.`album_id` = `Album2`.`id`) LEFT JOIN `albums` AS `Album3` ON (`Gallery`.`album_id` = `Album3`.`id`) WHERE `album_id` = 52 AND `published` = 1

SELECT `Gallery`.`id`, `Gallery`.`album_id`, `Gallery`.`user_id`, `Gallery`.`imgpath`, `Gallery`.`published`, `Album`.`id`, `Album`.`parent_id`, `Album`.`lft`, `Album`.`rght`, `Album`.`name`, `Album`.`url`, `Album`.`description`, `Album`.`gallery_count`, `Album`.`gallery_published_count`, `Album`.`gallery_nopublished_count`, `Album2`.`id`, `Album2`.`parent_id`, `Album2`.`lft`, `Album2`.`rght`, `Album2`.`name`, `Album2`.`url`, `Album2`.`description`, `Album2`.`gallery_count`, `Album2`.`gallery_published_count`, `Album2`.`gallery_nopublished_count`, `Album3`.`id`, `Album3`.`parent_id`, `Album3`.`lft`, `Album3`.`rght`, `Album3`.`name`, `Album3`.`url`, `Album3`.`description`, `Album3`.`gallery_count`, `Album3`.`gallery_published_count`, `Album3`.`gallery_nopublished_count` FROM `galleries` AS `Gallery` LEFT JOIN `albums` AS `Album` ON (`Gallery`.`album_id` = `Album`.`id`) LEFT JOIN `albums` AS `Album2` ON (`Gallery`.`album_id` = `Album2`.`id`) LEFT JOIN `albums` AS `Album3` ON (`Gallery`.`album_id` = `Album3`.`id`) WHERE `album_id` = 52 AND `published` = 1 ORDER BY `Gallery`.`id` DESC LIMIT 35, 35

SELECT `Album`.`id`, `Album`.`parent_id`, `Album`.`lft`, `Album`.`rght`, `Album`.`name`, `Album`.`url`, `Album`.`description`, `Album`.`gallery_count`, `Album`.`gallery_published_count`, `Album`.`gallery_nopublished_count` FROM `albums` AS `Album` WHERE `parent_id` = 52 ORDER BY `Album`.`lft` ASC

SELECT `Album`.`name` FROM `albums` AS `Album` WHERE `id` = 52 LIMIT 1

(phpbb3) 36 queries took 130 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `phpbb_users`	76	76	7
2	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62	1	1	3
3	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62	1	1	4
4	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62	1	1	3
5	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62	1	1	3
6	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62	1	1	3
7	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62	1	1	4
8	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62	1	1	4
9	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
10	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
11	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
12	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
13	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
14	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
15	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
16	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
17	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
18	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
19	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	6
20	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
21	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
22	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
23	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
24	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
25	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
26	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
27	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
28	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
29	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
30	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3
31	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
32	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
33	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
34	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
35	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	4
36	SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55	1	1	3

(phpbb3) 36 queries took 130 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `phpbb_users`

SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 62

SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 55

Gruppo Sportivo San Paolo Sassari

• Terza Categoria