HUISCO
2020-09-01 12:39
reporter
~0064334
Last edited: 2020-09-01 15:08
|
/usr/libexec/mysqld, Version: 10.3.17-MariaDB-log (MariaDB Server). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 200901 19:36:32
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.001950 Lock_time: 0.000120 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
use bugtracker;
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000489 Lock_time: 0.000319 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000499 Lock_time: 0.000308 Rows_sent: 1 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000685 Lock_time: 0.000074 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000305 Lock_time: 0.000176 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000269 Lock_time: 0.000200 Rows_sent: 0 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000388 Lock_time: 0.000213 Rows_sent: 2 Rows_examined: 6
# Rows_affected: 0 Bytes_sent: 473
SET timestamp=1598978192;
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent
FROM mantis_project_mantis p
LEFT JOIN mantis_project_hierarchy_mantis ph
ON ph.child_id = p.id
WHERE p.enabled = '1'
ORDER BY p.name;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000280 Lock_time: 0.000185 Rows_sent: 8 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 1181
SET timestamp=1598978192;
SELECT * FROM mantis_project_version_mantis WHERE project_id IN (1,0);
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000995 Lock_time: 0.000410 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 1069
SET timestamp=1598978192;
SELECT m.*, c.*, c.id AS context_id FROM mantis_mantis_Announce_message_mantis AS m
JOIN mantis_mantis_Announce_context_mantis AS c ON c.message_id=m.id
LEFT JOIN mantis_mantis_Announce_dismissed_mantis as d ON d.context_id=c.id and d.user_id=4
WHERE (d.timestamp IS NULL or d.timestamp < m.timestamp)
AND c.location = 'header' AND (
(c.project_id = 0 AND c.access <= 90)
OR (c.project_id = 1 AND c.access <= 90) ) ORDER BY m.timestamp DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000166 Lock_time: 0.000051 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 238
SET timestamp=1598978192;
SELECT DISTINCT p.id, p.name, ph.parent_id
FROM mantis_project_mantis p
LEFT JOIN mantis_project_hierarchy_mantis ph
ON ph.child_id = p.id
WHERE p.enabled = '1' AND
ph.parent_id IS NOT NULL
ORDER BY p.name;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000351 Lock_time: 0.000193 Rows_sent: 5 Rows_examined: 31
# Rows_affected: 0 Bytes_sent: 615
SET timestamp=1598978192;
SELECT c.*, p.name AS project_name FROM mantis_category_mantis c
LEFT JOIN mantis_project_mantis p
ON c.project_id=p.id
WHERE project_id IN ( 1, 0 ) ORDER BY c.name;
# User@Host: root[root] @ localhost []
# Thread_id: 8 Schema: bugtracker QC_hit: No
# Query_time: 0.000394 Lock_time: 0.000297 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1598978192;
SELECT CFP.project_id, CF.id FROM mantis_custom_field_mantis CF JOIN mantis_custom_field_project_mantis CFP ON CFP.field_id = CF.id WHERE CFP.project_id IN (1) ORDER BY sequence ASC, name ASC;
# User@Host: root[root] @ localhost []
# Thread_id: 9 Schema: bugtracker QC_hit: No
# Query_time: 0.001117 Lock_time: 0.000194 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 9 Schema: bugtracker QC_hit: No
# Query_time: 0.000268 Lock_time: 0.000081 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 9 Schema: bugtracker QC_hit: No
# Query_time: 0.000192 Lock_time: 0.000044 Rows_sent: 1 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 9 Schema: bugtracker QC_hit: No
# Query_time: 0.000812 Lock_time: 0.000105 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 9 Schema: bugtracker QC_hit: No
# Query_time: 0.000250 Lock_time: 0.000039 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 9 Schema: bugtracker QC_hit: No
# Query_time: 0.000088 Lock_time: 0.000033 Rows_sent: 0 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 10 Schema: bugtracker QC_hit: No
# Query_time: 0.000626 Lock_time: 0.000079 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 10 Schema: bugtracker QC_hit: No
# Query_time: 0.000126 Lock_time: 0.000035 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 10 Schema: bugtracker QC_hit: No
# Query_time: 0.000117 Lock_time: 0.000027 Rows_sent: 1 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 10 Schema: bugtracker QC_hit: No
# Query_time: 0.000529 Lock_time: 0.000045 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 10 Schema: bugtracker QC_hit: No
# Query_time: 0.000153 Lock_time: 0.000021 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 10 Schema: bugtracker QC_hit: No
# Query_time: 0.000081 Lock_time: 0.000030 Rows_sent: 0 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 11 Schema: bugtracker QC_hit: No
# Query_time: 0.000527 Lock_time: 0.000050 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 11 Schema: bugtracker QC_hit: No
# Query_time: 0.000124 Lock_time: 0.000032 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 11 Schema: bugtracker QC_hit: No
# Query_time: 0.000114 Lock_time: 0.000028 Rows_sent: 1 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 11 Schema: bugtracker QC_hit: No
# Query_time: 0.000509 Lock_time: 0.000049 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 11 Schema: bugtracker QC_hit: No
# Query_time: 0.000146 Lock_time: 0.000021 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 11 Schema: bugtracker QC_hit: No
# Query_time: 0.000083 Lock_time: 0.000033 Rows_sent: 0 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 12 Schema: bugtracker QC_hit: No
# Query_time: 0.000543 Lock_time: 0.000063 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 12 Schema: bugtracker QC_hit: No
# Query_time: 0.000140 Lock_time: 0.000041 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 12 Schema: bugtracker QC_hit: No
# Query_time: 0.000122 Lock_time: 0.000030 Rows_sent: 1 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 12 Schema: bugtracker QC_hit: No
# Query_time: 0.000504 Lock_time: 0.000053 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 12 Schema: bugtracker QC_hit: No
# Query_time: 0.000165 Lock_time: 0.000025 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 12 Schema: bugtracker QC_hit: No
# Query_time: 0.000086 Lock_time: 0.000032 Rows_sent: 0 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 13 Schema: bugtracker QC_hit: No
# Query_time: 0.000567 Lock_time: 0.000064 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 13 Schema: bugtracker QC_hit: No
# Query_time: 0.000135 Lock_time: 0.000035 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978192;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 13 Schema: bugtracker QC_hit: No
# Query_time: 0.000143 Lock_time: 0.000046 Rows_sent: 1 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3537
SET timestamp=1598978192;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 13 Schema: bugtracker QC_hit: No
# Query_time: 0.000478 Lock_time: 0.000051 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978192;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 13 Schema: bugtracker QC_hit: No
# Query_time: 0.000153 Lock_time: 0.000022 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978192;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 13 Schema: bugtracker QC_hit: No
# Query_time: 0.000085 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1598978192;
DELETE FROM mantis_tokens_mantis WHERE 1598978192 > expiry;
# Time: 200901 19:36:37
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.001050 Lock_time: 0.000123 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978197;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000304 Lock_time: 0.000086 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978197;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000282 Lock_time: 0.000049 Rows_sent: 1 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3537
SET timestamp=1598978197;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000895 Lock_time: 0.000098 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978197;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000287 Lock_time: 0.000045 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978197;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000087 Lock_time: 0.000033 Rows_sent: 0 Rows_examined: 16
# Rows_affected: 0 Bytes_sent: 11
SET timestamp=1598978197;
DELETE FROM mantis_tokens_mantis WHERE 1598978197 > expiry;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000155 Lock_time: 0.000044 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1598978197;
SELECT CFP.project_id, CF.id FROM mantis_custom_field_mantis CF JOIN mantis_custom_field_project_mantis CFP ON CFP.field_id = CF.id WHERE CFP.project_id IN (1) ORDER BY sequence ASC, name ASC;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000139 Lock_time: 0.000031 Rows_sent: 6 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3951
SET timestamp=1598978197;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (7,8,14,15,21,31) AND project_id = 0;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000104 Lock_time: 0.000026 Rows_sent: 0 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 3455
SET timestamp=1598978197;
SELECT * FROM mantis_user_pref_mantis WHERE user_id IN (4,7,8,14,15,21,31) AND project_id = 1;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.001423 Lock_time: 0.000571 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 503
SET timestamp=1598978197;
SELECT f.name, f.type, f.access_level_r, f.default_value, s.value, s.text
FROM mantis_custom_field_project_mantis p
INNER JOIN mantis_custom_field_mantis f ON f.id = p.field_id
LEFT JOIN mantis_custom_field_string_mantis s
ON s.field_id = p.field_id AND s.bug_id = 2066
WHERE p.project_id = 1
ORDER BY p.sequence ASC, f.name ASC;
# User@Host: root[root] @ localhost []
# Thread_id: 14 Schema: bugtracker QC_hit: No
# Query_time: 0.000078 Lock_time: 0.000022 Rows_sent: 9 Rows_examined: 9
# Rows_affected: 0 Bytes_sent: 203
SET timestamp=1598978197;
SELECT email_id FROM mantis_email_mantis ORDER BY email_id ASC;
# Time: 200901 19:37:01
# User@Host: root[root] @ localhost []
# Thread_id: 15 Schema: bugtracker QC_hit: No
# Query_time: 0.000649 Lock_time: 0.000089 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978221;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 15 Schema: bugtracker QC_hit: No
# Query_time: 0.000171 Lock_time: 0.000050 Rows_sent: 16 Rows_examined: 32
# Rows_affected: 0 Bytes_sent: 652
SET timestamp=1598978221;
SELECT basename, priority, protected FROM mantis_plugin_mantis WHERE enabled='1' ORDER BY priority DESC;
# User@Host: root[root] @ localhost []
# Thread_id: 15 Schema: bugtracker QC_hit: No
# Query_time: 0.000536 Lock_time: 0.000062 Rows_sent: 44 Rows_examined: 44
# Rows_affected: 0 Bytes_sent: 1725
SET timestamp=1598978221;
SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema();
# User@Host: root[root] @ localhost []
# Thread_id: 15 Schema: bugtracker QC_hit: No
# Query_time: 0.000194 Lock_time: 0.000028 Rows_sent: 73 Rows_examined: 73
# Rows_affected: 0 Bytes_sent: 9769
SET timestamp=1598978221;
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_mantis; |