• Fall Updates

    November 17th, 2009
    PRS Clinic:  November 18, 2009-- Donevan Arena (Program Room) 6:00pm - 10:00 pm.. To reserve...
** Show SQL Log
29 queries took 43 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `settings`332
2SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `settings` AS `Setting` WHERE 1 = 1 220
3DESCRIBE `news`11113
4DESCRIBE `events`14143
5DESCRIBE `groups`552
6DESCRIBE `events_groups`332
7DESCRIBE `users`10102
8DESCRIBE `accesses`662
9SELECT `User`.`id`, `User`.`active`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`updated` FROM `users` AS `User` WHERE `User`.`email` IS NULL AND `User`.`password` IS NULL AND `User`.`id` IS NULL AND `User`.`active` = 1 LIMIT 1000
10SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`id` IS NULL LIMIT 1000
11SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified` FROM `groups` AS `Group` WHERE `Group`.`linkage` = 'GENERALPUBLIC' LIMIT 1110
12SELECT `Access`.`id`, `Access`.`group_id`, `Access`.`controller`, `Access`.`action`, `Access`.`date_created`, `Access`.`date_modified` FROM `accesses` AS `Access` WHERE `Access`.`group_id` IN (3) 29291
13SELECT `News`.`id`, `News`.`title`, `News`.`slug`, `News`.`image`, `News`.`content`, `News`.`date`, `News`.`active`, `News`.`homepage_slot`, `News`.`created`, `News`.`modified`, `News`.`updated` FROM `news` AS `News` WHERE `homepage_slot` IN (1, 2, 3) ORDER BY `homepage_slot` ASC 331
14DESCRIBE `banners`772
15DESCRIBE `banner_images`992
16SELECT `Banner`.`id`, `Banner`.`name`, `Banner`.`slug`, `Banner`.`type`, `Banner`.`updated`, `Banner`.`created`, `Banner`.`modified` FROM `banners` AS `Banner` WHERE `Banner`.`slug` = 'pic-of-the-week' LIMIT 1110
17SELECT `BannerImage`.`id`, `BannerImage`.`banner_id`, `BannerImage`.`image`, `BannerImage`.`caption`, `BannerImage`.`url`, `BannerImage`.`active`, `BannerImage`.`created`, `BannerImage`.`updated`, `BannerImage`.`modified` FROM `banner_images` AS `BannerImage` WHERE `BannerImage`.`active` = 1 AND `BannerImage`.`banner_id` = 2 ORDER BY RAND() DESC LIMIT 1111
18DESCRIBE `navigations`10102
19DESCRIBE `navigation_sections`21213
20DESCRIBE `groups_navigations`332
21DESCRIBE `pages`12123
22DESCRIBE `page_histories`10102
23DESCRIBE `groups_pages`332
24SELECT `NavigationSection`.`id`, `NavigationSection`.`name`, `NavigationSection`.`linkage`, `NavigationSection`.`style`, `NavigationSection`.`font-family`, `NavigationSection`.`image`, `NavigationSection`.`image_hover`, `NavigationSection`.`image_active`, `NavigationSection`.`font-color`, `NavigationSection`.`font-color_hover`, `NavigationSection`.`font-color_active`, `NavigationSection`.`center`, `NavigationSection`.`xcoord`, `NavigationSection`.`ycoord`, `NavigationSection`.`font-size`, `NavigationSection`.`vertical`, `NavigationSection`.`seperator`, `NavigationSection`.`upper_case`, `NavigationSection`.`dropdown`, `NavigationSection`.`date_created`, `NavigationSection`.`date_modified` FROM `navigation_sections` AS `NavigationSection` WHERE `linkage` = 'bottom' LIMIT 1111
25SELECT `Navigation`.`id`, `Navigation`.`label`, `Navigation`.`navigation_section_id`, `Navigation`.`url`, `Navigation`.`lft`, `Navigation`.`rght`, `Navigation`.`parent_id`, `Navigation`.`created`, `Navigation`.`modified`, `Navigation`.`updated` FROM `navigations` AS `Navigation` WHERE `Navigation`.`navigation_section_id` = 2 ORDER BY `Navigation`.`lft` ASC 10101
26SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsNavigation`.`id`, `GroupsNavigation`.`navigation_id`, `GroupsNavigation`.`group_id` FROM `groups` AS `Group` JOIN `groups_navigations` AS `GroupsNavigation` ON (`GroupsNavigation`.`navigation_id` IN (4, 5, 6, 7, 8, 9, 11, 12, 13, 10) AND `GroupsNavigation`.`group_id` = `Group`.`id`) 30301
27SELECT `NavigationSection`.`id`, `NavigationSection`.`name`, `NavigationSection`.`linkage`, `NavigationSection`.`style`, `NavigationSection`.`font-family`, `NavigationSection`.`image`, `NavigationSection`.`image_hover`, `NavigationSection`.`image_active`, `NavigationSection`.`font-color`, `NavigationSection`.`font-color_hover`, `NavigationSection`.`font-color_active`, `NavigationSection`.`center`, `NavigationSection`.`xcoord`, `NavigationSection`.`ycoord`, `NavigationSection`.`font-size`, `NavigationSection`.`vertical`, `NavigationSection`.`seperator`, `NavigationSection`.`upper_case`, `NavigationSection`.`dropdown`, `NavigationSection`.`date_created`, `NavigationSection`.`date_modified` FROM `navigation_sections` AS `NavigationSection` WHERE `linkage` = 'privacy' LIMIT 1111
28SELECT `Navigation`.`id`, `Navigation`.`label`, `Navigation`.`navigation_section_id`, `Navigation`.`url`, `Navigation`.`lft`, `Navigation`.`rght`, `Navigation`.`parent_id`, `Navigation`.`created`, `Navigation`.`modified`, `Navigation`.`updated` FROM `navigations` AS `Navigation` WHERE `Navigation`.`navigation_section_id` = 3 ORDER BY `Navigation`.`lft` ASC 221
29SELECT `Group`.`id`, `Group`.`name`, `Group`.`linkage`, `Group`.`date_created`, `Group`.`date_modified`, `GroupsNavigation`.`id`, `GroupsNavigation`.`navigation_id`, `GroupsNavigation`.`group_id` FROM `groups` AS `Group` JOIN `groups_navigations` AS `GroupsNavigation` ON (`GroupsNavigation`.`navigation_id` IN (15, 14) AND `GroupsNavigation`.`group_id` = `Group`.`id`) 661