(default) 20 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`13132
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`.`full_name` LIKE 'N%' AND `User`.`admin_active` = 1 AND `User`.`active` = 1 331
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 (40, 34, 47) 000
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 (40, 34, 47) 000
9SELECT `Link`.`id`, `Link`.`user_id`, `Link`.`title`, `Link`.`url`, `Link`.`modified`, `Link`.`created` FROM `links` AS `Link` WHERE `Link`.`user_id` IN (40, 34, 47) 000
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 (40, 34, 47) 220
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 (32, 24, 19) 110
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 (32, 24, 19) 000
16SELECT `Link`.`id`, `Link`.`user_id`, `Link`.`title`, `Link`.`url`, `Link`.`modified`, `Link`.`created` FROM `links` AS `Link` WHERE `Link`.`user_id` IN (32, 24, 19) 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 (32, 24, 19) 110
18SELECT `Blip`.`id`, `Blip`.`description`, `Blip`.`created`, `Blip`.`updated` FROM `blips` AS `Blip` WHERE 1 = 1 110
19SELECT `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
20SELECT `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