(default) 21 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`13131
2DESCRIBE `events`881
3DESCRIBE `pgs`771
4DESCRIBE `links`661
5DESCRIBE `opportunities`771
6SELECT `User`.`id`, `User`.`email`, `User`.`phone`, `User`.`password`, `User`.`full_name`, `User`.`description`, `User`.`role`, `User`.`last_login`, `User`.`active`, `User`.`activation_code`, `User`.`admin_active`, `User`.`created`, `User`.`modified` FROM `users` AS `User` WHERE `User`.`admin_active` = 1 AND `User`.`active` = 1 32321
7SELECT `Event`.`id`, `Event`.`user_id`, `Event`.`title`, `Event`.`event_date`, `Event`.`description`, `Event`.`active`, `Event`.`created`, `Event`.`modified` FROM `events` AS `Event` WHERE `Event`.`user_id` IN (8, 40, 19, 20, 24, 21, 22, 25, 27, 28, 30, 31, 32, 33, 34, 35, 36, 37, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55) 14141
8SELECT `Pg`.`id`, `Pg`.`user_id`, `Pg`.`title`, `Pg`.`content`, `Pg`.`link`, `Pg`.`created`, `Pg`.`modified` FROM `pgs` AS `Pg` WHERE `Pg`.`user_id` IN (8, 40, 19, 20, 24, 21, 22, 25, 27, 28, 30, 31, 32, 33, 34, 35, 36, 37, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55) 220
9SELECT `Link`.`id`, `Link`.`user_id`, `Link`.`title`, `Link`.`url`, `Link`.`modified`, `Link`.`created` FROM `links` AS `Link` WHERE `Link`.`user_id` IN (8, 40, 19, 20, 24, 21, 22, 25, 27, 28, 30, 31, 32, 33, 34, 35, 36, 37, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55) 110
10SELECT `Opportunity`.`id`, `Opportunity`.`user_id`, `Opportunity`.`title`, `Opportunity`.`opportunity_date`, `Opportunity`.`description`, `Opportunity`.`created`, `Opportunity`.`modified` FROM `opportunities` AS `Opportunity` WHERE `Opportunity`.`user_id` IN (8, 40, 19, 20, 24, 21, 22, 25, 27, 28, 30, 31, 32, 33, 34, 35, 36, 37, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55) 12120
11SELECT `Event`.`title`, `Event`.`event_date`, `Event`.`id` FROM `events` AS `Event` LEFT JOIN `users` AS `User` ON (`Event`.`user_id` = `User`.`id`) WHERE `Event`.`event_date` >= '2010-03-09' AND `Event`.`active` = 1 ORDER BY `Event`.`event_date` ASC LIMIT 5440
12SELECT `Opportunity`.`title`, `Opportunity`.`opportunity_date`, `Opportunity`.`id` FROM `opportunities` AS `Opportunity` LEFT JOIN `users` AS `User` ON (`Opportunity`.`user_id` = `User`.`id`) WHERE `Opportunity`.`opportunity_date` >= '2010-03-09' ORDER BY `Opportunity`.`opportunity_date` ASC LIMIT 5110
13SELECT `User`.`full_name`, `User`.`id` FROM `users` AS `User` WHERE `User`.`admin_active` = 1 AND `User`.`active` = 1 ORDER BY rand() ASC LIMIT 3331
14SELECT `Event`.`id`, `Event`.`user_id`, `Event`.`title`, `Event`.`event_date`, `Event`.`description`, `Event`.`active`, `Event`.`created`, `Event`.`modified` FROM `events` AS `Event` WHERE `Event`.`user_id` IN (53, 43, 21) 000
15SELECT `Pg`.`id`, `Pg`.`user_id`, `Pg`.`title`, `Pg`.`content`, `Pg`.`link`, `Pg`.`created`, `Pg`.`modified` FROM `pgs` AS `Pg` WHERE `Pg`.`user_id` IN (53, 43, 21) 000
16SELECT `Link`.`id`, `Link`.`user_id`, `Link`.`title`, `Link`.`url`, `Link`.`modified`, `Link`.`created` FROM `links` AS `Link` WHERE `Link`.`user_id` IN (53, 43, 21) 000
17SELECT `Opportunity`.`id`, `Opportunity`.`user_id`, `Opportunity`.`title`, `Opportunity`.`opportunity_date`, `Opportunity`.`description`, `Opportunity`.`created`, `Opportunity`.`modified` FROM `opportunities` AS `Opportunity` WHERE `Opportunity`.`user_id` IN (53, 43, 21) 000
18DESCRIBE `blips`441
19SELECT `Blip`.`id`, `Blip`.`description`, `Blip`.`created`, `Blip`.`updated` FROM `blips` AS `Blip` WHERE 1 = 1 110
20SELECT `Pg`.`id`, `Pg`.`user_id`, `Pg`.`title`, `Pg`.`content`, `Pg`.`link`, `Pg`.`created`, `Pg`.`modified`, `User`.`id`, `User`.`email`, `User`.`phone`, `User`.`password`, `User`.`full_name`, `User`.`description`, `User`.`role`, `User`.`last_login`, `User`.`active`, `User`.`activation_code`, `User`.`admin_active`, `User`.`created`, `User`.`modified` FROM `pgs` AS `Pg` LEFT JOIN `users` AS `User` ON (`Pg`.`user_id` = `User`.`id`) WHERE 1 = 1 220
21SELECT `Link`.`id`, `Link`.`user_id`, `Link`.`title`, `Link`.`url`, `Link`.`modified`, `Link`.`created`, `User`.`id`, `User`.`email`, `User`.`phone`, `User`.`password`, `User`.`full_name`, `User`.`description`, `User`.`role`, `User`.`last_login`, `User`.`active`, `User`.`activation_code`, `User`.`admin_active`, `User`.`created`, `User`.`modified` FROM `links` AS `Link` LEFT JOIN `users` AS `User` ON (`Link`.`user_id` = `User`.`id`) WHERE 1 = 1 110