• Micro Micro 2008

Uploader: tomlecar
Uploader: tomlecar
Uploader: tomlecar
(default) 6 queries took 43 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `galleries`552
2DESCRIBE `albums`10102
3SELECT 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` = 85 AND `published` = 1 118
4SELECT `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` = 85 AND `published` = 1 ORDER BY `Gallery`.`id` DESC LIMIT 353331
5SELECT `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` = 85 ORDER BY `Album`.`lft` ASC 000
6SELECT `Album`.`name` FROM `albums` AS `Album` WHERE `id` = 85 LIMIT 1110
(phpbb3) 4 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `phpbb_users`76762
2SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 491 111
3SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 491 110
4SELECT `Member`.`username` FROM `phpbb_users` AS `Member` WHERE `Member`.`user_id` = 491 110