• Micro Blu 2010
Pagina 0 di 1
<< Precedente
Successivo >>
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | DESCRIBE `galleries` | 5 | 5 | 2 | |
2 | DESCRIBE `albums` | 10 | 10 | 3 | |
3 | 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` = 141 AND `published` = 1 | 1 | 1 | 8 | |
4 | 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` = 141 AND `published` = 1 ORDER BY `Gallery`.`id` DESC LIMIT 35 | 0 | 0 | 30 | |
5 | 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` = 141 ORDER BY `Album`.`lft` ASC | 0 | 0 | 0 | |
6 | SELECT `Album`.`name` FROM `albums` AS `Album` WHERE `id` = 141 LIMIT 1 | 1 | 1 | 0 |
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|