Skip to content

Instantly share code, notes, and snippets.

@twinge
Created March 14, 2009 03:40
Show Gist options
  • Save twinge/78917 to your computer and use it in GitHub Desktop.
Save twinge/78917 to your computer and use it in GitHub Desktop.
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