|
Variable
|
Value
|
Type
|
|
1
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT id FROM mantis_user_table
WHERE cookie_string='08f2b770811c9287b114dc6a6bafa635304a3341a2f2ef289dcc786538d7fad6'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
authentication_api.php:582 auth_is_cookie_valid()
|
string
|
|
|
2
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT id FROM mantis_user_table
WHERE cookie_string='08f2b770811c9287b114dc6a6bafa635304a3341a2f2ef289dcc786538d7fad6'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
authentication_api.php:613 auth_get_current_user_id()
|
string
|
|
|
3
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_pref_table
WHERE user_id='9' AND project_id='0'
|
string
|
|
1
|
0.0005
|
string
|
|
2
|
user_pref_api.php:133 user_pref_cache_row()
|
string
|
|
|
4
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_project_table
WHERE id='1'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
project_api.php:66 project_cache_row()
|
string
|
|
|
5
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_table
WHERE id='9'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
user_api.php:60 user_cache_row()
|
string
|
|
|
6
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT project_id,
access_level FROM mantis_project_user_list_table
WHERE user_id='9'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
access_api.php:136 access_cache_matrix_user()
|
string
|
|
|
7
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT config_id, user_id, project_id,
type, value, access_reqd FROM mantis_config_table
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
config_api.php:96 config_get()
|
string
|
|
|
8
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_bug_table
WHERE id='197'
|
string
|
|
1
|
0.0005
|
string
|
|
2
|
bug_api.php:132 bug_cache_row()
|
string
|
|
|
9
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bt.* FROM mantis_bug_text_table bt,
mantis_bug_table b WHERE b.id='197'
AND b.bug_text_id = bt.id
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bug_api.php:202 bug_text_cache_row()
|
string
|
|
|
10
|
|
Variable
|
Value
|
Type
|
|
0
|
INSERT INTO mantis_bugnote_text_table
( note ) VALUES ( 'Test' )
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bugnote_api.php:130 bugnote_add()
|
string
|
|
|
11
|
|
Variable
|
Value
|
Type
|
|
0
|
INSERT INTO mantis_bugnote_table
(bug_id, reporter_id,
bugnote_text_id, view_state,
date_submitted, last_modified,
note_type, note_attr,
time_tracking ) VALUES ('197', '9','388',
'10', '2009-10-13 10:57:09','2009-10-13 10:57:09', '0', '', '0' )
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:155 bugnote_add()
|
string
|
|
|
12
|
|
Variable
|
Value
|
Type
|
|
0
|
UPDATE mantis_bug_table
SET last_updated= '2009-10-13 10:57:09' WHERE
id='197'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bug_api.php:1346 bug_update_date()
|
string
|
|
|
13
|
|
Variable
|
Value
|
Type
|
|
0
|
INSERT INTO mantis_bug_history_table
( user_id, bug_id, date_modified, type, old_value,
new_value, field_name
) VALUES ( '9', '197', '2009-10-13 10:57:09', '2', '0000388', '', '' )
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
history_api.php:74 history_log_event_special()
|
string
|
|
|
14
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_bug_table
WHERE id='197'
|
string
|
|
1
|
0.0005
|
string
|
|
2
|
bug_api.php:132 bug_cache_row()
|
string
|
|
|
15
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT DISTINCT user_id
FROM mantis_bug_monitor_table WHERE bug_id=197
|
string
|
|
1
|
0.0005
|
string
|
|
2
|
email_api.php:241 email_collect_recipients()
|
string
|
|
|
16
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT id FROM mantis_bugnote_table
WHERE bug_id='197' ORDER by last_modified DESC
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bugnote_api.php:275 bugnote_get_latest_id()
|
string
|
|
|
17
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT view_state
FROM mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
18
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT last_modified
FROM mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
19
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT DISTINCT reporter_id
FROM mantis_bugnote_table WHERE bug_id = 197
|
string
|
|
1
|
0.0005
|
string
|
|
2
|
email_api.php:262 email_collect_recipients()
|
string
|
|
|
20
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT id, username, realname,
access_level FROM mantis_user_table
WHERE enabled = 1 AND access_level >= 90
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
project_api.php:550 project_get_all_user_rows()
|
string
|
|
|
21
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT u.id, u.username, u.realname, l.access_level FROM mantis_project_user_list_table
l, mantis_user_table u WHERE l.user_id = u.id AND u.enabled = 1 AND l.project_id
= 1
|
string
|
|
1
|
0.0010
|
string
|
|
2
|
project_api.php:565 project_get_all_user_rows()
|
string
|
|
|
22
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_table
WHERE id='21'
|
string
|
|
1
|
0.0052
|
string
|
|
2
|
user_api.php:60 user_cache_row()
|
string
|
|
|
23
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_pref_table
WHERE user_id='21' AND project_id='0'
|
string
|
|
1
|
0.0005
|
string
|
|
2
|
user_pref_api.php:133 user_pref_cache_row()
|
string
|
|
|
24
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT view_state
FROM mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
25
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
26
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT project_id,
access_level FROM mantis_project_user_list_table
WHERE user_id='21'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
access_api.php:136 access_cache_matrix_user()
|
string
|
|
|
27
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_table
WHERE id='15'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
user_api.php:60 user_cache_row()
|
string
|
|
|
28
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_pref_table
WHERE user_id='15' AND project_id='0'
|
string
|
|
1
|
0.0005
|
string
|
|
2
|
user_pref_api.php:133 user_pref_cache_row()
|
string
|
|
|
29
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT view_state
FROM mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
30
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
31
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT project_id,
access_level FROM mantis_project_user_list_table
WHERE user_id='15'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
access_api.php:136 access_cache_matrix_user()
|
string
|
|
|
32
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_table
WHERE id='1'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
user_api.php:60 user_cache_row()
|
string
|
|
|
33
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_pref_table
WHERE user_id='1' AND project_id='0'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
user_pref_api.php:133 user_pref_cache_row()
|
string
|
|
|
34
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT view_state
FROM mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
35
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
36
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_user_pref_table
WHERE user_id='21' AND project_id='1'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
user_pref_api.php:133 user_pref_cache_row()
|
string
|
|
|
37
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT access_level
FROM mantis_project_user_list_table WHERE user_id='21' AND project_id='1'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
project_api.php:435 project_get_local_user_access_level()
|
string
|
|
|
38
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT f.name, f.type, f.access_level_r,
f.default_value, f.type,
s.value FROM mantis_custom_field_project_table
p INNER JOIN mantis_custom_field_table f ON p.field_id = f.id LEFT
JOIN mantis_custom_field_string_table s ON p.field_id=s.field_id AND
s.bug_id='197' WHERE p.project_id
= '1' ORDER BY p.sequence ASC, f.name ASC
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
custom_field_api.php:872 custom_field_get_all_linked_fields()
|
string
|
|
|
39
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT b.*, t.note
FROM mantis_bugnote_table b LEFT JOIN mantis_bugnote_text_table t ON b.bugnote_text_id
= t.id WHERE b.bug_id
= '197' ORDER BY b.id ASC
|
string
|
|
1
|
0.0006
|
string
|
|
2
|
bugnote_api.php:356 bugnote_get_all_bugnotes()
|
string
|
|
|
40
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_bug_history_table
WHERE bug_id='197' ORDER BY date_modified ASC,id
|
string
|
|
1
|
0.0007
|
string
|
|
2
|
history_api.php:137 history_get_raw_events_array()
|
string
|
|
|
41
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT id FROM mantis_custom_field_table
WHERE name = 'status'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
custom_field_api.php:625 custom_field_get_id_from_name()
|
string
|
|
|
42
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT id FROM mantis_custom_field_table
WHERE name = 'handler_id'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
custom_field_api.php:625 custom_field_get_id_from_name()
|
string
|
|
|
43
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT mantis_bug_relationship_table.id,
mantis_bug_relationship_table.relationship_type,
mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.destination_bug_id
= mantis_bug_table.id WHERE source_bug_id='197' ORDER BY relationship_type,
mantis_bug_relationship_table.id
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
relationship_api.php:292 relationship_get_all_src()
|
string
|
|
|
44
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT mantis_bug_relationship_table.id,
mantis_bug_relationship_table.relationship_type,
mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.source_bug_id
= mantis_bug_table.id WHERE destination_bug_id='197' ORDER BY relationship_type, mantis_bug_relationship_table.id
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
relationship_api.php:326 relationship_get_all_dest()
|
string
|
|
|
45
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT * FROM mantis_bug_table
WHERE id='193'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bug_api.php:132 bug_cache_row()
|
string
|
|
|
46
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bt.* FROM mantis_bug_text_table bt,
mantis_bug_table b WHERE b.id='193'
AND b.bug_text_id = bt.id
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bug_api.php:202 bug_text_cache_row()
|
string
|
|
|
47
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='366'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
48
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='381'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
49
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='382'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
50
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='383'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
51
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='384'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
52
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='387'
|
string
|
|
1
|
0.0004
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
53
|
|
Variable
|
Value
|
Type
|
|
0
|
SELECT bug_id FROM
mantis_bugnote_table WHERE id='388'
|
string
|
|
1
|
0.0003
|
string
|
|
2
|
bugnote_api.php:260 bugnote_get_field()
|
string
|
|
|
54
|
|
Variable
|
Value
|
Type
|
|
0
|
|
string
|
|
1
|
0.0008
|
string
|
|
2
|
email_queue_api.php:105
email_queue_add()
|
string
|
|