Created
March 14, 2009 03:40
-
-
Save twinge/78917 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Group Load (0.8ms) SELECT `groups`.* FROM `groups` INNER JOIN `group_involvements` ON `groups`.id = `group_involvements`.group_id WHERE ((`group_involvements`.person_id = 50000)) | |
Group Columns (3.2ms) SHOW FIELDS FROM `groups` | |
GroupType Columns (3.3ms) SHOW FIELDS FROM `group_types` | |
SQL (0.5ms) SELECT count(*) AS count_all FROM `ministries` INNER JOIN `ministry_involvements` ON `ministries`.id = `ministry_involvements`.ministry_id WHERE ((`ministry_involvements`.person_id = 50000) AND ((`ministry_involvements`.`end_date` IS NULL))) | |
Ministry Load (32.9ms) SELECT `ministries`.* FROM `ministries` INNER JOIN `ministry_involvements` ON `ministries`.id = `ministry_involvements`.ministry_id WHERE ((`ministry_involvements`.person_id = 50000) AND ((`ministry_involvements`.`end_date` IS NULL))) ORDER BY ministries.name | |
MinistryInvolvement Load (0.4ms) SELECT * FROM `ministry_involvements` WHERE (`ministry_involvements`.person_id = 50000 AND (`ministry_involvements`.`end_date` IS NULL)) | |
MinistryInvolvement Columns (2.1ms) SHOW FIELDS FROM `ministry_involvements` | |
CampusInvolvement Columns (2.7ms) SHOW FIELDS FROM `campus_involvements` | |
SQL (0.4ms) SELECT count(*) AS count_all FROM `campus_involvements` WHERE (`campus_involvements`.person_id = 50000 AND (`campus_involvements`.`end_date` IS NULL)) | |
SQL (0.4ms) SELECT count(*) AS count_all FROM `groups` INNER JOIN `group_involvements` ON `groups`.id = `group_involvements`.group_id WHERE ((`group_involvements`.person_id = 50000) AND ((level = 'interested'))) | |
SchoolYear Columns (3.3ms) SHOW FIELDS FROM `school_years` | |
MinistryInvolvement Load (0.5ms) SELECT * FROM `ministry_involvements` WHERE (`ministry_involvements`.`id` IN (1,2,3,4,5,7,10,18,22,48,61,65)) | |
StaffRole Columns (2.9ms) SHOW FIELDS FROM `ministry_roles` | |
StaffRole Load (0.5ms) SELECT * FROM `ministry_roles` WHERE (`ministry_roles`.ministry_id = 1) AND ( (`ministry_roles`.`type` = 'StaffRole' ) ) ORDER BY position | |
Person Load (2.6ms) SELECT `people`.* FROM `people` INNER JOIN `ministry_involvements` ON ministry_involvements.person_id = people.id WHERE (ministry_role_id IN (71) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment