session目录未找到
zdoo/tmp/log/目录下日志文件如下：
<?php
die();
?>
20191017 09:08:48: /zdoo/www/sys/index.php?m=user&f=login
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','guest') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','guest') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
20191017 09:08:49: /zdoo/www/sys/index.php?m=user&f=login
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','guest') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','guest') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_user` WHERE deleted = '0' AND account = 'admin'
SELECT * FROM `sys_user` WHERE deleted = '0' AND account = 'admin'
UPDATE `sys_user` SET `id` = '1',`dept` = '0',`account` = 'admin',`password` = '9308ee8ab65246072ade8b1e8ee3475c',`realname` = 'admin',`role` = '',`nickname` = '',`admin` = 'super',`avatar` = '',`birthday` = '0000-00-00',`gender` = 'u',`email` = '',`skype` = '',`qq` = '',`weixin` = '',`yahoo` = '',`gtalk` = '',`wangwang` = '',`site` = '',`mobile` = '',`phone` = '',`address` = '',`zipcode` = '',`visits` = '7',`ip` = '222.209.35.57',`last` = '2019-10-17 09:08:49',`ping` = '2019-10-17 09:08:49',`fails` = '0',`join` = '2019-10-08 17:40:30',`locked` = '0000-00-00 00:00:00',`deleted` = '0',`clientStatus` = 'offline',`clientLang` = 'zh-cn' WHERE account = 'admin'
SELECT * FROM `oa_attend` WHERE account = 'admin' AND `date` = '2019-10-17'
SELECT * FROM `oa_attend` WHERE account = 'admin' AND `date` = '2019-10-17'
SELECT t2.* FROM `sys_usergroup` AS t1 LEFT JOIN `sys_group` AS t2 ON t1.group = t2.id WHERE t1.account = 'admin'
SELECT t2.* FROM `sys_usergroup` AS t1 LEFT JOIN `sys_group` AS t2 ON t1.group = t2.id WHERE t1.account = 'admin'
SELECT module, method FROM `sys_usergroup` AS t1 LEFT JOIN `sys_grouppriv` AS t2 ON t1.group = t2.group WHERE t1.account = 'admin'
INSERT INTO `sys_action` SET `objectType` = 'user',`objectID` = '1',`customer` = '0',`contact` = '0',`actor` = 'admin',`action` = 'login',`date` = '2019-10-17 09:08:49',`comment` = '',`extra` = ''
20191017 09:08:49: /zdoo/www/sys/index.php?m=user&f=login
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
20191017 09:08:49: /zdoo/www/sys/index.php?m=index&f=index
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_entry` WHERE 1 ORDER BY `order`,`id`
SELECT * FROM `sys_entry` WHERE 1 ORDER BY `order`,`id`
SELECT distinct t1.id, t1.name, t1.order, t2.platform FROM `sys_category` AS t1 LEFT JOIN `sys_entry` AS t2 ON t1.id=t2.category WHERE t1.type = 'entry' AND t2.visible = '1' AND t2.category != '0' ORDER BY t1.`order`
SELECT distinct t1.id, t1.name, t1.order, t2.platform FROM `sys_category` AS t1 LEFT JOIN `sys_entry` AS t2 ON t1.id=t2.category WHERE t1.type = 'entry' AND t2.visible = '1' AND t2.category != '0' ORDER BY t1.`order`
SELECT * FROM `sys_block` WHERE account = 'admin' AND app = 'sys' AND hidden = '0' ORDER BY `order`
SELECT * FROM `sys_block` WHERE account = 'admin' AND app = 'sys' AND hidden = '0' ORDER BY `order`
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
UPDATE `oa_attend` SET `status` = 'both' WHERE id = '3'
SELECT * FROM `oa_attend` WHERE date = '2019-10-17' AND account = 'admin'
SELECT * FROM `oa_attend` WHERE date = '2019-10-17' AND account = 'admin'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
UPDATE `oa_attend` SET `status` = 'both' WHERE id = '3'
SELECT * FROM `oa_attend` WHERE date = '2019-10-16' AND account = 'admin'
SELECT * FROM `oa_attend` WHERE date = '2019-10-16' AND account = 'admin'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `sys_cron` ORDER BY `lastTime` desc LIMIT 1
SELECT * FROM `sys_cron` ORDER BY `lastTime` desc LIMIT 1
20191017 09:08:49: /zdoo/www/sys/index.php?m=misc&f=ping&t=html¬ice=
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
UPDATE `sys_user` SET `ping` = '2019-10-17 09:08:49' WHERE account = 'admin'
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT * FROM `sys_action` WHERE `read` = '0' AND reader LIKE '%,admin,%' ORDER BY `id` desc
SELECT * FROM `sys_action` WHERE `read` = '0' AND reader LIKE '%,admin,%' ORDER BY `id` desc
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-17' AND `date` <= '2019-10-17' AND status NOT IN ('done','closed') ORDER BY `date`,`status`,`begin`
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-17' AND `date` <= '2019-10-17' AND status NOT IN ('done','closed') ORDER BY `date`,`status`,`begin`
SELECT * FROM `sys_entry` WHERE zentao = '1'
SELECT * FROM `sys_entry` WHERE zentao = '1'
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salesgroup`
SELECT * FROM `crm_salesgroup`
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=1
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '1' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '1' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
UPDATE `oa_attend` SET `status` = 'both' WHERE id = '3'
SELECT * FROM `oa_attend` WHERE account = 'admin' AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`
SELECT * FROM `oa_attend` WHERE account = 'admin' AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT t1.*, t2.realname, t2.dept FROM `oa_leave` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status IN ('pass') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_leave` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status IN ('pass') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_leave` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status IN ('pass') ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_lieu` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_lieu` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_lieu` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type = 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type = 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type = 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type != 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type != 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type != 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'trip' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'trip' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'egreess' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'egreess' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`,`status`,`begin`
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`,`status`,`begin`
SELECT * FROM `sys_entry` WHERE zentao = '1'
SELECT * FROM `sys_entry` WHERE zentao = '1'
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=2
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=3
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '3' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '3' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_article` WHERE type = 'announce' ORDER BY `createdDate` desc LIMIT 15
SELECT * FROM `sys_article` WHERE type = 'announce' ORDER BY `createdDate` desc LIMIT 15
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=4
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '4' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '4' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `crm_contract` WHERE deleted = '0' AND returnedBy = 'admin' ORDER BY `id` desc LIMIT 15
SELECT * FROM `crm_contract` WHERE deleted = '0' AND returnedBy = 'admin' ORDER BY `id` desc LIMIT 15
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=5
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '5' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '5' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT id, name FROM `sys_product` WHERE deleted = '0' ORDER BY `order` desc
SELECT id, name FROM `sys_product` WHERE deleted = '0' ORDER BY `order` desc
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salesgroup`
SELECT * FROM `crm_salesgroup`
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salesgroup`
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT * FROM `crm_order` WHERE deleted = '0' AND customer IN ('') AND createdBy = 'admin' ORDER BY `id` desc LIMIT 15
SELECT * FROM `crm_order` WHERE deleted = '0' AND customer IN ('') AND createdBy = 'admin' ORDER BY `id` desc LIMIT 15
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=6
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '6' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '6' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `cash_depositor` WHERE type != 'cash' AND status = 'normal'
SELECT * FROM `cash_depositor` WHERE type != 'cash' AND status = 'normal'
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=7
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '7' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '7' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_article` WHERE type = 'blog' ORDER BY `createdDate` desc LIMIT 15
SELECT * FROM `sys_article` WHERE type = 'blog' ORDER BY `createdDate` desc LIMIT 15
SELECT t2.id, t2.name, t2.alias, t1.id AS article FROM `sys_relation` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.category = t2.id WHERE t2.type = ''
SELECT t2.id, t2.name, t2.alias, t1.id AS article FROM `sys_relation` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.category = t2.id WHERE t2.type = ''
SELECT id FROM `sys_article` WHERE id IN ('') ORDER BY `id` desc
SELECT id FROM `sys_article` WHERE id IN ('') ORDER BY `id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
20191017 09:08:49: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=8
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '8' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '8' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `team_thread` ORDER BY `createdDate` desc LIMIT 15
SELECT * FROM `team_thread` ORDER BY `createdDate` desc LIMIT 15
SELECT account, realname FROM `sys_user` WHERE account IN ('')
SELECT account, realname FROM `sys_user` WHERE account IN ('')
SELECT id FROM `team_thread` WHERE id IN ('') ORDER BY `repliedDate` desc
SELECT id FROM `team_thread` WHERE id IN ('') ORDER BY `repliedDate` desc
20191017 09:08:49: /zdoo/www/sys/index.php?m=block&f=printBlock&index=2
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_action` WHERE 1 AND objectType NOT IN ('attend','refund','leave','overtime','trip','egress','action','usercontact') AND date > '20191017' AND date < '2019-10-18' ORDER BY `date` desc
SELECT * FROM `sys_action` WHERE 1 AND objectType NOT IN ('attend','refund','leave','overtime','trip','egress','action','usercontact') AND date > '20191017' AND date < '2019-10-18' ORDER BY `date` desc
SELECT id, account AS name FROM `sys_user` WHERE id IN ('1')
SELECT id, account AS name FROM `sys_user` WHERE id IN ('1')
SELECT id FROM `sys_action` WHERE id IN ('11','10','9') ORDER BY `date` desc
SELECT id FROM `sys_action` WHERE id IN ('11','10','9') ORDER BY `date` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
20191017 09:08:52: /zdoo/www/sys/index.php?m=index&f=index
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_entry` WHERE 1 ORDER BY `order`,`id`
SELECT * FROM `sys_entry` WHERE 1 ORDER BY `order`,`id`
SELECT distinct t1.id, t1.name, t1.order, t2.platform FROM `sys_category` AS t1 LEFT JOIN `sys_entry` AS t2 ON t1.id=t2.category WHERE t1.type = 'entry' AND t2.visible = '1' AND t2.category != '0' ORDER BY t1.`order`
SELECT distinct t1.id, t1.name, t1.order, t2.platform FROM `sys_category` AS t1 LEFT JOIN `sys_entry` AS t2 ON t1.id=t2.category WHERE t1.type = 'entry' AND t2.visible = '1' AND t2.category != '0' ORDER BY t1.`order`
SELECT * FROM `sys_block` WHERE account = 'admin' AND app = 'sys' AND hidden = '0' ORDER BY `order`
SELECT * FROM `sys_block` WHERE account = 'admin' AND app = 'sys' AND hidden = '0' ORDER BY `order`
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
UPDATE `oa_attend` SET `status` = 'both' WHERE id = '3'
SELECT * FROM `oa_attend` WHERE date = '2019-10-17' AND account = 'admin'
SELECT * FROM `oa_attend` WHERE date = '2019-10-17' AND account = 'admin'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
UPDATE `oa_attend` SET `status` = 'both' WHERE id = '3'
SELECT * FROM `oa_attend` WHERE date = '2019-10-16' AND account = 'admin'
SELECT * FROM `oa_attend` WHERE date = '2019-10-16' AND account = 'admin'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `sys_cron` ORDER BY `lastTime` desc LIMIT 1
SELECT * FROM `sys_cron` ORDER BY `lastTime` desc LIMIT 1
20191017 09:08:53: /zdoo/www/sys/index.php?m=misc&f=ping&t=html¬ice=
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
UPDATE `sys_user` SET `ping` = '2019-10-17 09:08:53' WHERE account = 'admin'
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT * FROM `sys_action` WHERE `read` = '0' AND reader LIKE '%,admin,%' ORDER BY `id` desc
SELECT * FROM `sys_action` WHERE `read` = '0' AND reader LIKE '%,admin,%' ORDER BY `id` desc
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-17' AND `date` <= '2019-10-17' AND status NOT IN ('done','closed') ORDER BY `date`,`status`,`begin`
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-17' AND `date` <= '2019-10-17' AND status NOT IN ('done','closed') ORDER BY `date`,`status`,`begin`
SELECT * FROM `sys_entry` WHERE zentao = '1'
SELECT * FROM `sys_entry` WHERE zentao = '1'
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salesgroup`
SELECT * FROM `crm_salesgroup`
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=1
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '1' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '1' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_attend` WHERE status = '' AND date < '2019-10-17' OR date = '2019-10-17'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
UPDATE `oa_attend` SET `status` = 'both' WHERE id = '3'
SELECT * FROM `oa_attend` WHERE account = 'admin' AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`
SELECT * FROM `oa_attend` WHERE account = 'admin' AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT * FROM `oa_holiday` WHERE 1 AND ( year = '2019' OR begin LIKE '2019-%' OR end LIKE '2019-%') AND type = 'holiday'
SELECT t1.*, t2.realname, t2.dept FROM `oa_leave` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status IN ('pass') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_leave` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status IN ('pass') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_leave` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status IN ('pass') ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_lieu` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_lieu` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_lieu` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type = 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type = 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type = 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type != 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type != 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_overtime` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE t1.type != 'compensate' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') AND t1.status = 'pass' ORDER BY t2.`dept`,t1.`id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT t1.account, t2.moderators FROM `sys_user` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.dept=t2.id WHERE t1.deleted = '0' AND t2.type = 'dept'
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'trip' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'trip' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'egreess' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT t1.*, t2.realname, t2.dept FROM `oa_trip` AS t1 LEFT JOIN `sys_user` AS t2 ON t1.createdBy=t2.account WHERE 1 AND t1.type = 'egreess' AND ( t1.begin LIKE '2019-10-%' OR t1.end LIKE '2019-10-%') ORDER BY t2.`dept`,t1.`id` desc
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`,`status`,`begin`
SELECT * FROM `oa_todo` WHERE 1=1 AND ( account = 'admin' OR assignedTo = 'admin' OR finishedBy = 'admin') AND `date` >= '2019-10-14' AND `date` <= '2019-10-20' ORDER BY `date`,`status`,`begin`
SELECT * FROM `sys_entry` WHERE zentao = '1'
SELECT * FROM `sys_entry` WHERE zentao = '1'
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=2
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=3
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '3' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '3' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_entry` WHERE code = 'oa'
SELECT * FROM `sys_article` WHERE type = 'announce' ORDER BY `createdDate` desc LIMIT 15
SELECT * FROM `sys_article` WHERE type = 'announce' ORDER BY `createdDate` desc LIMIT 15
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=5
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '5' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '5' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT id, name FROM `sys_product` WHERE deleted = '0' ORDER BY `order` desc
SELECT id, name FROM `sys_product` WHERE deleted = '0' ORDER BY `order` desc
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salesgroup`
SELECT * FROM `crm_salesgroup`
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT * FROM `crm_salespriv` WHERE account = 'admin'
SELECT * FROM `crm_salesgroup`
SELECT id FROM `crm_customer` WHERE deleted = '0'
SELECT customer FROM `crm_order` WHERE assignedTo IN ('admin')
SELECT * FROM `crm_order` WHERE deleted = '0' AND customer IN ('') AND createdBy = 'admin' ORDER BY `id` desc LIMIT 15
SELECT * FROM `crm_order` WHERE deleted = '0' AND customer IN ('') AND createdBy = 'admin' ORDER BY `id` desc LIMIT 15
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=6
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '6' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '6' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `sys_entry` WHERE code = 'cash'
SELECT * FROM `cash_depositor` WHERE type != 'cash' AND status = 'normal'
SELECT * FROM `cash_depositor` WHERE type != 'cash' AND status = 'normal'
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=7
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '7' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '7' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_article` WHERE type = 'blog' ORDER BY `createdDate` desc LIMIT 15
SELECT * FROM `sys_article` WHERE type = 'blog' ORDER BY `createdDate` desc LIMIT 15
SELECT t2.id, t2.name, t2.alias, t1.id AS article FROM `sys_relation` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.category = t2.id WHERE t2.type = ''
SELECT t2.id, t2.name, t2.alias, t1.id AS article FROM `sys_relation` AS t1 LEFT JOIN `sys_category` AS t2 ON t1.category = t2.id WHERE t2.type = ''
SELECT id FROM `sys_article` WHERE id IN ('') ORDER BY `id` desc
SELECT id FROM `sys_article` WHERE id IN ('') ORDER BY `id` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=4
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '4' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '4' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `sys_entry` WHERE code = 'crm'
SELECT * FROM `crm_contract` WHERE deleted = '0' AND returnedBy = 'admin' ORDER BY `id` desc LIMIT 15
SELECT * FROM `crm_contract` WHERE deleted = '0' AND returnedBy = 'admin' ORDER BY `id` desc LIMIT 15
20191017 09:08:53: /zdoo/www/sys/index.php?m=entry&f=printBlock&index=8
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '8' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '8' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `sys_entry` WHERE code = 'team'
SELECT * FROM `team_thread` ORDER BY `createdDate` desc LIMIT 15
SELECT * FROM `team_thread` ORDER BY `createdDate` desc LIMIT 15
SELECT account, realname FROM `sys_user` WHERE account IN ('')
SELECT account, realname FROM `sys_user` WHERE account IN ('')
SELECT id FROM `team_thread` WHERE id IN ('') ORDER BY `repliedDate` desc
SELECT id FROM `team_thread` WHERE id IN ('') ORDER BY `repliedDate` desc
20191017 09:08:53: /zdoo/www/sys/index.php?m=block&f=printBlock&index=2
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_entry` WHERE code = 'sys'
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_config` WHERE owner IN ('s y s t e m','admin') ORDER BY `id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_lang` ORDER BY `app`,`lang`,`id`
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_block` WHERE `order` = '2' AND account = 'admin' AND app = 'sys'
SELECT * FROM `sys_action` WHERE 1 AND objectType NOT IN ('attend','refund','leave','overtime','trip','egress','action','usercontact') AND date > '20191017' AND date < '2019-10-18' ORDER BY `date` desc
SELECT * FROM `sys_action` WHERE 1 AND objectType NOT IN ('attend','refund','leave','overtime','trip','egress','action','usercontact') AND date > '20191017' AND date < '2019-10-18' ORDER BY `date` desc
SELECT id, account AS name FROM `sys_user` WHERE id IN ('1')
SELECT id, account AS name FROM `sys_user` WHERE id IN ('1')
SELECT id FROM `sys_action` WHERE id IN ('11','10','9') ORDER BY `date` desc
SELECT id FROM `sys_action` WHERE id IN ('11','10','9') ORDER BY `date` desc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
SELECT account, realname FROM `sys_user` WHERE 1 ORDER BY `id` asc
另外，
我试过
蝉知7.7可以正常切换到中文
