[rt-devel] Performance concerns
Byron Ellacott
bje at apnic.net
Tue May 8 02:25:33 EDT 2001
On 08 May 2001 02:04:11 -0400, Jesse wrote:
> I suspect that the mail gateway software either lopped off your attachment or
> would reject it based on message size. Wanna put it somewhere online
> that people can reference by URL? (Or bounce it to me and I can do that)
uh, I, uh, forgot to attach it *blushes*
--
bje
-------------- next part --------------
010508 15:21:41 20 Query SELECT * FROM Users WHERE Name = 'RT_System'
20 Query SELECT * FROM Users WHERE Name = 'Nobody'
20 Query SELECT * FROM Users WHERE Name = 'RT_System'
20 Query SELECT * FROM Users WHERE Name = 'Nobody'
20 Query SELECT * FROM Users WHERE Name = 'bje'
20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT main.* FROM Queues main WHERE ((main.Disabled = '0')) ORDER BY main.id ASC
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '1' AND Type = 'Cc' AND Owner = '12'
010508 15:21:42 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '1' AND Type = 'AdminCc' AND Owner = '12'
010508 15:21:43 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE ((RightScope = 'System')) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE (((((RightScope = 'System')) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE ((((RightScope = 'System')) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'Cc' AND Owner = '12'
010508 15:21:44 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'AdminCc' AND Owner = '12'
010508 15:21:45 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'CreateTicket')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'CreateTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'CreateTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:21:46 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:21:48 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'CreateTicket')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'CreateTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'CreateTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '4' AND Type = 'Cc' AND Owner = '12'
010508 15:21:49 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '4' AND Type = 'AdminCc' AND Owner = '12'
010508 15:21:50 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 4))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 4))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 4))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE ((RightScope = 'System')) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE (((((RightScope = 'System')) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE ((((RightScope = 'System')) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '5' AND Type = 'Cc' AND Owner = '12'
010508 15:21:51 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '5' AND Type = 'AdminCc' AND Owner = '12'
010508 15:21:52 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 5))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 5))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 5))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '6' AND Type = 'Cc' AND Owner = '12'
010508 15:21:53 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '6' AND Type = 'AdminCc' AND Owner = '12'
010508 15:21:54 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 6))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 6))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 6))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT main.* FROM Tickets main WHERE ((main.Status = 'open') OR (main.Status = 'new')) AND ((main.Owner = '12')) ORDER BY main.id ASC
010508 15:21:56 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37165' AND Type = 'Requestor' AND Owner = '12'
010508 15:21:57 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37165' AND Type = 'Cc' AND Owner = '12'
010508 15:21:58 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37165' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:00 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'ShowTicket')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'ShowTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'ShowTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:01 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:02 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37180' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:03 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37180' AND Type = 'Cc' AND Owner = '12'
010508 15:22:04 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37180' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:05 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:06 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:07 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37273' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:09 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37273' AND Type = 'Cc' AND Owner = '12'
010508 15:22:10 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37273' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:11 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:12 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:13 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37430' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:14 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37430' AND Type = 'Cc' AND Owner = '12'
010508 15:22:16 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '37430' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:17 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'ShowTicket')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'ShowTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'ShowTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:18 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:19 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '48414' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:20 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '48414' AND Type = 'Cc' AND Owner = '12'
010508 15:22:21 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '48414' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:23 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:24 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:25 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '54523' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:26 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '54523' AND Type = 'Cc' AND Owner = '12'
010508 15:22:27 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '54523' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:28 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:29 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:30 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '56003' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:31 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '56003' AND Type = 'Cc' AND Owner = '12'
010508 15:22:33 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '56003' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:34 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:35 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:36 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '56077' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:37 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '56077' AND Type = 'Cc' AND Owner = '12'
010508 15:22:38 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '56077' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:40 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:41 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:42 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '58953' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:43 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '58953' AND Type = 'Cc' AND Owner = '12'
010508 15:22:44 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '58953' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:45 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:46 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:47 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 3))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '61256' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:48 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '61256' AND Type = 'Cc' AND Owner = '12'
010508 15:22:50 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '61256' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:52 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:22:53 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '64470' AND Type = 'Requestor' AND Owner = '12'
010508 15:22:56 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '64470' AND Type = 'Cc' AND Owner = '12'
010508 15:22:58 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '64470' AND Type = 'AdminCc' AND Owner = '12'
010508 15:22:59 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:23:00 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:01 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '78262' AND Type = 'Requestor' AND Owner = '12'
010508 15:23:02 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '78262' AND Type = 'Cc' AND Owner = '12'
010508 15:23:03 20 Query SELECT * FROM Watchers WHERE Scope = 'Ticket' AND Value = '78262' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:05 20 Query SELECT * FROM Users WHERE id = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:23:06 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:07 20 Query SELECT main.* FROM Tickets main, Watchers Watchers_0, Users Users_1 WHERE ((main.Status = 'open') OR (main.Status = 'new')) AND ((Users_1.EmailAddress = 'nobody at staff.apnic.net')) AND ((Watchers_0.Scope = 'Ticket')) AND ((Watchers_0.Type = 'Requestor')) AND Watchers_0.Owner = Users_1.id AND main.id = Watchers_0.Value ORDER BY main.id ASC
010508 15:23:14 20 Query SELECT main.* FROM Queues main WHERE ((main.Disabled = '0')) ORDER BY main.id ASC
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '1' AND Type = 'Cc' AND Owner = '12'
010508 15:23:15 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '1' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:16 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'Cc' AND Owner = '12'
010508 15:23:17 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:18 20 Query SELECT COUNT(ACL.id) FROM ACL, Groups WHERE (((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue')) AND (((Groups.Name = 'Everyone') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)) OR ((Groups.Name = 'Owner') AND
(PrincipalType = 'Group') AND
(Groups.Id = PrincipalId)))
20 Query SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE ((((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) AND (GroupMembers.UserId = 12))))
20 Query SELECT COUNT(ACL.id) FROM ACL WHERE (((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'SeeQueue'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0))) AND (((PrincipalType = 'User') AND (PrincipalId = 12)))
20 Query SELECT * FROM Queues WHERE id = '2'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'Cc' AND Owner = '12'
010508 15:23:19 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:20 20 Query SELECT main.* FROM Tickets main WHERE ((main.Status = 'open')) AND ((main.Queue = '2')) ORDER BY main.id ASC
010508 15:23:21 20 Query SELECT * FROM Queues WHERE id = '2'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'Cc' AND Owner = '12'
010508 15:23:22 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '2' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:23 20 Query SELECT main.* FROM Tickets main WHERE ((main.Status = 'new')) AND ((main.Queue = '2')) ORDER BY main.id ASC
010508 15:23:25 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:23:26 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:27 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:23:28 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:29 20 Query SELECT main.* FROM Tickets main WHERE ((main.Status = 'open')) AND ((main.Queue = '3')) ORDER BY main.id ASC
010508 15:23:30 20 Query SELECT * FROM Queues WHERE id = '3'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'Cc' AND Owner = '12'
010508 15:23:31 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '3' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:32 20 Query SELECT main.* FROM Tickets main WHERE ((main.Status = 'new')) AND ((main.Queue = '3')) ORDER BY main.id ASC
010508 15:23:34 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '4' AND Type = 'Cc' AND Owner = '12'
010508 15:23:35 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '4' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:36 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '5' AND Type = 'Cc' AND Owner = '12'
010508 15:23:37 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '5' AND Type = 'AdminCc' AND Owner = '12'
010508 15:23:38 20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '6' AND Type = 'Cc' AND Owner = '12'
20 Query SELECT * FROM Watchers WHERE Scope = 'Queue' AND Value = '6' AND Type = 'AdminCc' AND Owner = '12'
More information about the Rt-devel
mailing list