EEK-A-Mouse
Albums:
New Album
New Album
Main Album
Main Album
(default) 14 queries took 248 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `photo_albums`551
2DESCRIBE `photos`771
3SELECT COUNT(*) AS `count` FROM `photo_albums` AS `PhotoAlbum` WHERE 1 = 1 110
4SELECT COUNT(*) AS `count` FROM `photo_albums` AS `PhotoAlbum` WHERE 1 = 1 110
5SELECT COUNT(*) AS `count` FROM `photo_albums` AS `PhotoAlbum` WHERE 1 = 1 110
6SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`caption`, `PhotoAlbum`.`modified`, `PhotoAlbum`.`created` FROM `photo_albums` AS `PhotoAlbum` WHERE 1 = 1 ORDER BY `PhotoAlbum`.`created` DESC LIMIT 422124
7SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`photo_album_id`, `Photo`.`created`, `Photo`.`modified` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` IN (3, 1) ORDER BY `Photo`.`created` ASC 66122
8SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`caption`, `PhotoAlbum`.`modified`, `PhotoAlbum`.`created` FROM `photo_albums` AS `PhotoAlbum` WHERE 1 = 1 ORDER BY `PhotoAlbum`.`created` DESC LIMIT 1110
9SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`photo_album_id`, `Photo`.`created`, `Photo`.`modified` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` = (3) ORDER BY `Photo`.`created` ASC 110
10SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`photo_album_id`, `Photo`.`created`, `Photo`.`modified`, `PhotoAlbum`.`id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`caption`, `PhotoAlbum`.`modified`, `PhotoAlbum`.`created` FROM `photos` AS `Photo` LEFT JOIN `photo_albums` AS `PhotoAlbum` ON (`Photo`.`photo_album_id` = `PhotoAlbum`.`id`) WHERE `Photo`.`photo_album_id` = 3 110
11SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Breakfast' ORDER BY `MenuSection`.`display_order` ASC 330
12SELECT `MenuSection`.`name` FROM `menu_sections` AS `MenuSection` WHERE `MenuSection`.`type` = 'Lunch / Dinner' ORDER BY `MenuSection`.`display_order` ASC 330
13SELECT `Setting`.`value` FROM `settings` AS `Setting` WHERE `name` = 'hours' 110
14SELECT COUNT(*) AS `count` FROM `event_comments` AS `EventComment` LEFT JOIN `events` AS `Event` ON (`EventComment`.`event_id` = `Event`.`id`) WHERE `EventComment`.`approved` = 0 110