pmp更新任务里一个备注的过程

syant

query result

argument

show create table `mysql`.`general_log`

show full fields from `mysql`.`general_log`

root@127.0.0.1 on wjun1981

SET NAMES UTF8

SET @@sql_mode= ''

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='common' AND `key`='flow'

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='custom' AND `key`='productProject'

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='common' AND `key`='flow'

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='custom' AND `key`='productProject'

SELECT * FROM `zt_userview` wHeRe account = 'syant'

SELECT * FROM `zt_config` wHeRe 1 = 1 AND owner IN ('system') AND module IN ('common') AND section IN ('xuanxuan')

SELECT * FROM `zt_config` wHeRe owner IN ('system','syant') oRdEr bY `id`

SELECT * FROM `zt_lang` oRdEr bY `lang`,`id`

SELECT * FROM `zt_action` wHeRe `id` = '365'

UPDATE `zt_action` SET `comment` = 'XXXXXXX' wHeRe id = '365'

root@127.0.0.1 on wjun1981

SET NAMES UTF8

SET @@sql_mode= ''

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='common' AND `key`='flow'

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='custom' AND `key`='productProject'

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='common' AND `key`='flow'

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='custom' AND `key`='productProject'

SELECT * FROM `zt_userview` wHeRe account = 'syant'

SELECT * FROM `zt_config` wHeRe 1 = 1 AND owner IN ('system') AND module IN ('common') AND section IN ('xuanxuan')

SELECT * FROM `zt_config` wHeRe owner IN ('system','syant') oRdEr bY `id`

SELECT * FROM `zt_lang` oRdEr bY `lang`,`id`

SELECT t1.*, t2.id AS storyID, t2.title AS storyTitle, t2.version AS latestStoryVersion, t2.status AS storyStatus, t3.realname AS assignedToRealName FROM `zt_task` AS t1 LEFT JOIN `zt_story` AS t2 ON t1.story = t2.id LEFT JOIN `zt_user` AS t3 ON t1.assignedTo = t3.account wHeRe t1.id = '18'

SELECT * FROM `zt_task` wHeRe parent = '18' AND deleted = '0'

SELECT * FROM `zt_team` wHeRe root = '18' AND type = 'task' oRdEr bY `order`

SELECT * FROM `zt_file` wHeRe objectType = 'task' AND objectID = '18' AND extra != 'editor'

SELECT id, title FROM `zt_case` wHeRe story = '10' AND storyVersion = '1' AND deleted = '0'

SELECT * FROM `zt_story` wHeRe `id` = '10'

SELECT title,spec,verify FROM `zt_storyspec` wHeRe story = '10' AND version = '1'

SELECT t1.project, t2.name, t2.status FROM `zt_projectstory` AS t1 LEFT JOIN `zt_project` AS t2 ON t1.project = t2.id wHeRe t1.story = '10' oRdEr bY t1.`order` DESC

SELECT id, name, assignedTo, project, status, consumed, `left` FROM `zt_task` wHeRe story = '10' AND deleted = '0' oRdEr bY `id` DESC

SELECT * FROM `zt_storystage` wHeRe story = '10'

SELECT * FROM `zt_file` wHeRe objectType = 'story' AND objectID = '10' AND extra != 'editor'

UPDATE `zt_action` SET `read` = '1' wHeRe objectType = 'task' AND objectID = '18' AND `read` = '0'

SELECT * FROM `zt_project` wHeRe `id` = '5'

SELECT SUM(estimate) AS totalEstimate, SUM(consumed) AS totalConsumed, SUM(`left`) AS totalLeft FROM `zt_task` wHeRe project = '5' AND status != 'cancel' AND deleted = '0' AND parent < '1'

SELECT SUM(`left`) AS totalLeft FROM `zt_task` wHeRe project = '5' AND status = 'closed' AND deleted = '0' AND parent < '1'

SELECT sum(days * hours) AS totalHours FROM `zt_team` wHeRe root = '5' AND type = 'project'

SELECT *, IF(INSTR(" done,closed", status) < 2, 0, 1) AS isDone FROM `zt_project` wHeRe iscat = '0' AND deleted = '0' AND id IN ('1','2','3','4','5') oRdEr bY `isDone`,`status`,`order` desc

SELECT commiter, account, realname FROM `zt_user` wHeRe commiter != ''

SELECT * FROM `zt_action` wHeRe objectType = 'task' AND objectID = '18' oRdEr bY `date`,`id`

SELECT * FROM `zt_history` wHeRe action IN ('360','362','363','365') oRdEr bY `id`

SELECT account, realname, deleted FROM `zt_user` wHeRe 1 AND deleted = '0' oRdEr bY `account`

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='common' AND `key`='flow'

SELECT value FROM`zt_config`WHERE `owner`='system' AND `module`='custom' AND `key`='productProject'

SELECT * FROM `zt_cron` oRdEr bY `lastTime` desc lImiT 1