100224 10:30:01 88 Query SHOW TABLES 88 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 88 Query SELECT * FROM mantis_user_table WHERE username='administrator' 88 Quit 100224 10:30:02 89 Connect root@localhost on bugtracker 89 Init DB bugtracker 89 Query SET NAMES UTF8 89 Query SHOW TABLES 89 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 89 Query SHOW TABLES 89 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 89 Query SELECT * FROM mantis_user_table WHERE username='admin' 89 Query UPDATE mantis_user_table SET failed_login_count=failed_login_count+1 WHERE id='2' 89 Quit 90 Connect root@localhost on bugtracker 90 Init DB bugtracker 90 Query SET NAMES UTF8 90 Query SHOW TABLES 90 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 100224 10:30:03 90 Query SHOW TABLES 90 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 90 Query SELECT * FROM mantis_user_table WHERE username='administrator' 90 Quit 100224 10:30:04 91 Connect root@localhost on bugtracker 91 Init DB bugtracker 91 Query SET NAMES UTF8 91 Query SHOW TABLES 91 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 91 Query SHOW TABLES 91 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 91 Query SELECT * FROM mantis_user_table WHERE username='admin' 91 Query UPDATE mantis_user_table SET login_count=login_count+1 WHERE id='2' 91 Query UPDATE mantis_user_table SET failed_login_count=0 WHERE id='2' 91 Query UPDATE mantis_user_table SET lost_password_request_count=0 WHERE id='2' 91 Query SELECT * FROM mantis_user_table WHERE id='2' 91 Query DELETE FROM mantis_tokens_table WHERE 1267003804 > expiry 91 Query SELECT * FROM mantis_tokens_table WHERE type=4 AND owner=2 91 Query SELECT * FROM mantis_tokens_table WHERE type=4 AND owner=2 91 Query INSERT INTO mantis_tokens_table ( type, value, timestamp, expiry, owner ) VALUES ( 4, 1, 1267003804, 1267004104, 2 ) 91 Quit 92 Connect root@localhost on bugtracker 92 Init DB bugtracker 92 Query SET NAMES UTF8 92 Query SHOW TABLES 92 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 92 Query SELECT * FROM mantis_user_table WHERE cookie_string='88c05e29519cbbda0175ee29851b6a70834f6ce9e13601877089a714157205fd' 92 Query SELECT * FROM mantis_user_pref_table WHERE user_id=2 AND project_id=0 92 Query SHOW TABLES 92 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 92 Query DELETE FROM mantis_tokens_table WHERE 1267003804 > expiry 92 Query SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=2 92 Quit 93 Connect root@localhost on bugtracker 93 Init DB bugtracker 93 Query SET NAMES UTF8 93 Query SHOW TABLES 93 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 93 Query SELECT * FROM mantis_user_table WHERE cookie_string='88c05e29519cbbda0175ee29851b6a70834f6ce9e13601877089a714157205fd' 93 Query SELECT * FROM mantis_user_pref_table WHERE user_id=2 AND project_id=0 93 Query SHOW TABLES 93 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 93 Query DELETE FROM mantis_tokens_table WHERE 1267003804 > expiry 93 Query SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=2 93 Quit 94 Connect root@localhost on bugtracker 94 Init DB bugtracker 94 Query SET NAMES UTF8 94 Query SHOW TABLES 94 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 100224 10:30:05 94 Query SELECT * FROM mantis_user_table WHERE cookie_string='88c05e29519cbbda0175ee29851b6a70834f6ce9e13601877089a714157205fd' 94 Query SELECT * FROM mantis_user_pref_table WHERE user_id=2 AND project_id=0 94 Query SHOW TABLES 94 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 94 Query DELETE FROM mantis_tokens_table WHERE 1267003805 > expiry 94 Query SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=2 94 Query SELECT c.*, p.name AS project_name FROM mantis_category_table AS c LEFT JOIN mantis_project_table AS p ON c.project_id=p.id WHERE project_id=0 ORDER BY c.name 94 Query SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name 94 Query SELECT * FROM mantis_project_table WHERE id IN (4,5,3,1,9,6,8) 94 Query SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name 94 Query SELECT * FROM mantis_project_table WHERE id=2 94 Query SELECT * FROM mantis_tokens_table WHERE type=3 AND owner=2 94 Query SELECT * FROM mantis_bug_table WHERE id IN (570,569,568,567,566) 94 Query SELECT * FROM mantis_bug_table WHERE id=569 94 Query SELECT * FROM mantis_bug_table WHERE id=568 94 Query SELECT * FROM mantis_bug_table WHERE id=567 94 Query SELECT * FROM mantis_bug_table WHERE id=566 94 Query SELECT COUNT(*) FROM mantis_bug_table WHERE project_id IN (4,5,3,1,9,6,8,2) AND status<'80' AND handler_id=2 94 Query SELECT * FROM mantis_filters_table WHERE id=0 94 Query SELECT * FROM mantis_custom_field_table ORDER BY name ASC 94 Query SELECT DISTINCT cft.id FROM mantis_custom_field_table as cft, mantis_user_table ut, mantis_project_table pt, mantis_custom_field_project_table cfpt LEFT JOIN mantis_project_user_list_table pult on cfpt.project_id = pult.project_id and pult.user_id = 2 WHERE cft.id = cfpt.field_id AND cfpt.project_id = pt.id AND ut.id = 2 AND ( pt.view_state = 10 OR ( pt.view_state = 50 and pult.user_id = 2 ) OR ( pult.user_id is null and ut.access_level >= 90 ) ) 94 Query SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.handler_id=0 ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 80) ) 94 Query SELECT DISTINCT mantis_bug_table.*, mantis_bug_table.last_updated, mantis_bug_table.date_submitted FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.handler_id=0 ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 80) ) ORDER BY mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC LIMIT 0,10 94 Query SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM mantis_bugnote_table WHERE mantis_bugnote_table.bug_id in (571, 570, 562, 561, 519, 411, 445, 521, 487, 559) GROUP BY bug_id 94 Query SELECT c.*, p.name AS project_name FROM mantis_category_table AS c LEFT JOIN mantis_project_table AS p ON c.project_id=p.id WHERE c.id IN (27,25,6,3) 94 Query SELECT bug_id, COUNT(bug_id) AS attachments FROM mantis_bug_file_table GROUP BY bug_id 94 Query SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.reporter_id=2 ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 80) ) 94 Query SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.status=80 ) 94 Query SELECT DISTINCT mantis_bug_table.*, mantis_bug_table.last_updated, mantis_bug_table.date_submitted FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.status=80 ) ORDER BY mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC LIMIT 0,10 94 Query SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM mantis_bugnote_table WHERE mantis_bugnote_table.bug_id in (519, 411, 445, 521, 487, 512, 513, 515, 510, 470) GROUP BY bug_id 94 Query SELECT c.*, p.name AS project_name FROM mantis_category_table AS c LEFT JOIN mantis_project_table AS p ON c.project_id=p.id WHERE c.id IN (2) 94 Query SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id 94 Query SELECT DISTINCT mantis_bug_table.*, mantis_bug_table.last_updated, mantis_bug_table.date_submitted FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id ORDER BY mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC LIMIT 0,10 94 Query SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM mantis_bugnote_table WHERE mantis_bugnote_table.bug_id in (571, 570, 562, 561, 519, 411, 445, 521, 487, 559) GROUP BY bug_id 94 Query SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_project_table, mantis_bug_table LEFT JOIN mantis_bug_monitor_table user_monitor ON user_monitor.bug_id = mantis_bug_table.id WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 80) ) AND ( user_monitor.user_id=2 ) 94 Query UPDATE mantis_user_table SET last_visit= 1267003805 WHERE id=2 94 Quit 100224 10:30:06 95 Connect root@localhost on bugtracker 95 Init DB bugtracker 95 Query SET NAMES UTF8 95 Query SHOW TABLES 95 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 95 Query SELECT * FROM mantis_user_table WHERE cookie_string='88c05e29519cbbda0175ee29851b6a70834f6ce9e13601877089a714157205fd' 95 Query SELECT * FROM mantis_user_pref_table WHERE user_id=2 AND project_id=0 95 Query SHOW TABLES 95 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 95 Query DELETE FROM mantis_tokens_table WHERE 1267003806 > expiry 95 Query SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=2 95 Quit 96 Connect root@localhost on bugtracker 96 Init DB bugtracker 96 Query SET NAMES UTF8 96 Query SHOW TABLES 96 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 96 Query SHOW TABLES 96 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 96 Query SELECT * FROM mantis_user_table WHERE username='administrator' 96 Quit 100224 10:30:09 97 Connect root@localhost on bugtracker 97 Init DB bugtracker 97 Query SET NAMES UTF8 97 Query SHOW TABLES 97 Query SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 97 Query SHOW TABLES 97 Query SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 97 Query SELECT * FROM mantis_user_table WHERE username='admin' 100224 10:32:08 106 Connect root@localhost on bugtracker 106 Init DB bugtracker 106 Query SET NAMES UTF8