[ 2024-02-07T11:22:07+08:00 ] 63.221.140.231 /xmt/index.php INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000019s ] INFO: [ app_init ] --END-- [ RunTime:0.001826s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001973s ] INFO: [ app_begin ] --END-- [ RunTime:0.002030s ] NOTIC: [8] Undefined index: id D:\code\xmt\vis\Apps\Home\Controller\CommonController.class.php 第 20 行. [ 2024-02-07T11:22:08+08:00 ] 63.221.140.231 /xmt/index.php/Login/login.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000270s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000360s ] INFO: [ app_begin ] --END-- [ RunTime:0.000393s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000043s ] INFO: [ template_filter ] --END-- [ RunTime:0.000117s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.373428s ] INFO: [ view_parse ] --END-- [ RunTime:0.373489s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.024859s ] INFO: [ view_filter ] --END-- [ RunTime:0.024907s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.020180s ] INFO: [ app_end ] --END-- [ RunTime:0.020225s ] [ 2024-02-07T11:22:20+08:00 ] 61.132.54.35 /xmt/index.php/Login/login.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.001229s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001341s ] INFO: [ app_begin ] --END-- [ RunTime:0.001398s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000036s ] INFO: [ template_filter ] --END-- [ RunTime:0.000080s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.017581s ] INFO: [ view_parse ] --END-- [ RunTime:0.017667s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.001282s ] INFO: [ view_filter ] --END-- [ RunTime:0.001321s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001143s ] INFO: [ app_end ] --END-- [ RunTime:0.001175s ] [ 2024-02-07T12:41:55+08:00 ] 61.132.54.35 /xmt/index.php INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000019s ] INFO: [ app_init ] --END-- [ RunTime:0.041523s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.002005s ] INFO: [ app_begin ] --END-- [ RunTime:0.002064s ] NOTIC: [8] Undefined index: id D:\code\xmt\vis\Apps\Home\Controller\CommonController.class.php 第 20 行. [ 2024-02-07T12:41:56+08:00 ] 61.132.54.35 /xmt/index.php/Login/login.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000265s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000395s ] INFO: [ app_begin ] --END-- [ RunTime:0.000431s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000036s ] INFO: [ template_filter ] --END-- [ RunTime:0.000085s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.172009s ] INFO: [ view_parse ] --END-- [ RunTime:0.172056s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.001597s ] INFO: [ view_filter ] --END-- [ RunTime:0.001632s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001750s ] INFO: [ app_end ] --END-- [ RunTime:0.001785s ] [ 2024-02-07T12:42:04+08:00 ] 61.132.54.35 /xmt/index.php/Login/checkLogin.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000269s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000339s ] INFO: [ app_begin ] --END-- [ RunTime:0.000370s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.026086s ] SQL: SELECT * FROM `xmt_user` WHERE `name` = 'admin' AND `pwd` = 'e10adc3949ba59abbe56e057f20f883e' AND `del` = 0 AND `sts` = 0 LIMIT 1 [ RunTime:0.010297s ] [ 2024-02-07T12:42:04+08:00 ] 61.132.54.35 /xmt/index.php/Index/index.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000315s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000435s ] INFO: [ app_begin ] --END-- [ RunTime:0.000469s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.010972s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` IN ('1','2') AND `del` = 0 [ RunTime:0.006235s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005316s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.002411s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 0 AND `del` = 0 AND `id` IN ('1','111','1','112','1','113','1','116','2','201','2','205','2','208','2','209','3','302','3','303','3','304','3','305','3','308','3','309','4','401','4','402','4','403','4','404','4','405','4','406','4','407','4','408','4','410','4','411','5','501','5','502','5','503','5','504','5','506','5','507','5','509','6','601','6','602','6','604','6','605','6','606','6','607','7','701','7','702','8','801','8','802','8','805','9','901','9','902','9','903','10','1001','10','1002','10','1003','10','1004','10','1006','1','111','11111','1','112','11112','1','113','11113','1','112','11211','1','112','11212','1','112','11213','1','112','11215','1','113','11311','1','113','11312','1','113','11313','1','113','11314','1','116','11601','1','116','11602','1','116','11603','2','201','20101','2','201','20102','2','201','20103','2','201','20104','2','201','20105','2','205','20501','2','205','20502','2','205','20503','2','208','20801','2','208','20802','2','208','20803','2','208','20804','2','209','20901','2','209','20902','2','209','20903','3','302','30201','3','302','30202','3','302','30203','3','303','30302','3','308','30801','3','308','30802','3','308','30803','4','401','40101','4','401','40102','4','401','40103','4','401','40104','4','402','40201','4','402','40202','4','402','40203','4','403','40300','4','403','40304','4','404','40414','4','405','40514','4','406','40601','4','407','40701','4','407','40702','4','407','40703','4','408','40801','4','408','40802','4','408','40803','5','501','50101','5','501','50102','5','501','50103','5','501','50104','5','502','50201','5','502','50202','5','502','50203','5','502','50204','5','508','50801','6','601','60101','6','601','60102','6','601','60103','6','601','60104','6','602','60201','6','602','60202','6','602','60203','6','604','60401','6','604','60402','6','604','60403','6','605','60501','6','605','60502','6','605','60503','7','701','70101','7','701','70102','7','701','70103','7','702','70201','7','702','70202','7','702','70203','8','805','80514','10','1001','100102','10','1001','100104','10','1001','100107','10','1001','100108','10','1003','100301','10','1003','100302','10','1004','100401','10','1004','100402','10','1006','100601','') ORDER BY `sort` [ RunTime:0.007724s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 AND `id` IN ('1','111','1','112','1','113','1','116','2','201','2','205','2','208','2','209','3','302','3','303','3','304','3','305','3','308','3','309','4','401','4','402','4','403','4','404','4','405','4','406','4','407','4','408','4','410','4','411','5','501','5','502','5','503','5','504','5','506','5','507','5','509','6','601','6','602','6','604','6','605','6','606','6','607','7','701','7','702','8','801','8','802','8','805','9','901','9','902','9','903','10','1001','10','1002','10','1003','10','1004','10','1006','1','111','11111','1','112','11112','1','113','11113','1','112','11211','1','112','11212','1','112','11213','1','112','11215','1','113','11311','1','113','11312','1','113','11313','1','113','11314','1','116','11601','1','116','11602','1','116','11603','2','201','20101','2','201','20102','2','201','20103','2','201','20104','2','201','20105','2','205','20501','2','205','20502','2','205','20503','2','208','20801','2','208','20802','2','208','20803','2','208','20804','2','209','20901','2','209','20902','2','209','20903','3','302','30201','3','302','30202','3','302','30203','3','303','30302','3','308','30801','3','308','30802','3','308','30803','4','401','40101','4','401','40102','4','401','40103','4','401','40104','4','402','40201','4','402','40202','4','402','40203','4','403','40300','4','403','40304','4','404','40414','4','405','40514','4','406','40601','4','407','40701','4','407','40702','4','407','40703','4','408','40801','4','408','40802','4','408','40803','5','501','50101','5','501','50102','5','501','50103','5','501','50104','5','502','50201','5','502','50202','5','502','50203','5','502','50204','5','508','50801','6','601','60101','6','601','60102','6','601','60103','6','601','60104','6','602','60201','6','602','60202','6','602','60203','6','604','60401','6','604','60402','6','604','60403','6','605','60501','6','605','60502','6','605','60503','7','701','70101','7','701','70102','7','701','70103','7','702','70201','7','702','70202','7','702','70203','8','805','80514','10','1001','100102','10','1001','100104','10','1001','100107','10','1001','100108','10','1003','100301','10','1003','100302','10','1004','100401','10','1004','100402','10','1006','100601','') ORDER BY `sort` [ RunTime:0.001002s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000128s ] INFO: [ template_filter ] --END-- [ RunTime:0.000168s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.194016s ] INFO: [ view_parse ] --END-- [ RunTime:0.194068s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000343s ] INFO: [ view_filter ] --END-- [ RunTime:0.000371s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000532s ] INFO: [ app_end ] --END-- [ RunTime:0.000567s ] [ 2024-02-07T12:42:15+08:00 ] 61.132.54.35 /xmt/index.php/Index/searchLJMXgrid.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000288s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000378s ] INFO: [ app_begin ] --END-- [ RunTime:0.000411s ] SQL: SHOW COLUMNS FROM `xmt_flow_td` [ RunTime:0.007436s ] SQL: SELECT SUM(weight) AS tp_sum FROM `xmt_flow_td` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.016771s ] SQL: SELECT b.dvalue cname, sum(a.weight) AS weight_sum, CONCAT((sum(a.weight) / 12966396)*100,"%") AS weight_zb FROM xmt_flow_td a LEFT JOIN xmt_dict b ON b.dtype="TDTYPE" and a.cno = b.dno AND b.del = 0 WHERE a.del = 0 GROUP BY a.cno [ RunTime:0.125345s ] [ 2024-02-07T12:42:16+08:00 ] 61.132.54.35 /xmt/index.php/Index/getChartPie1?_=1707280932254 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000012s ] INFO: [ app_init ] --END-- [ RunTime:0.000332s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000513s ] INFO: [ app_begin ] --END-- [ RunTime:0.000545s ] SQL: SHOW COLUMNS FROM `xmt_flow_td` [ RunTime:0.041681s ] SQL: SELECT SUM(weight) AS tp_sum FROM `xmt_flow_td` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.005561s ] SQL: SELECT v.name dvalue, sum(a.weight) AS weight_sum, CONCAT( ( sum(a.weight) / 12966396 ) * 100, "%" ) AS weight_zb FROM xmt_flow_td a left join xmt_village v on a.vno = v.no and v.del = 0 LEFT JOIN xmt_category b ON a.cno = b.cno and b.del=0 AND b.del = 0 WHERE a.del = 0 and a.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) GROUP BY a.vno [ RunTime:0.164362s ] [ 2024-02-07T12:42:16+08:00 ] 61.132.54.35 /xmt/index.php/Index/getCount?_=1707280932253 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.000350s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000566s ] INFO: [ app_begin ] --END-- [ RunTime:0.000614s ] SQL: SHOW COLUMNS FROM `xmt_pdt` [ RunTime:0.006888s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_pdt` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.000337s ] SQL: SHOW COLUMNS FROM `xmt_village_user` [ RunTime:0.005689s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_village_user` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.001028s ] SQL: SHOW COLUMNS FROM `xmt_flow_td` [ RunTime:0.006166s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_flow_td` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.004687s ] SQL: SELECT SUM(weight) AS tp_sum FROM `xmt_flow_td` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.005260s ] SQL: SHOW COLUMNS FROM `xmt_yy` [ RunTime:0.009189s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_yy` WHERE ( del=0 and tksts=0 ) LIMIT 1 [ RunTime:0.000244s ] [ 2024-02-07T12:42:39+08:00 ] 61.132.54.35 /xmt/index.php/user/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000281s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000358s ] INFO: [ app_begin ] --END-- [ RunTime:0.000392s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005889s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001280s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005248s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.001435s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '112' and del=0 ) ORDER BY sort [ RunTime:0.000468s ] SQL: SHOW COLUMNS FROM `xmt_province` [ RunTime:0.007540s ] SQL: SELECT `sn`,`name` FROM `xmt_province` WHERE `del` = 0 ORDER BY `id` asc [ RunTime:0.004319s ] SQL: SHOW COLUMNS FROM `xmt_role` [ RunTime:0.009186s ] SQL: SELECT `name`,`rno` FROM `xmt_role` WHERE `del` = 0 ORDER BY id [ RunTime:0.005169s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000125s ] INFO: [ template_filter ] --END-- [ RunTime:0.000166s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.147800s ] INFO: [ view_parse ] --END-- [ RunTime:0.147851s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.001761s ] INFO: [ view_filter ] --END-- [ RunTime:0.001806s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000590s ] INFO: [ app_end ] --END-- [ RunTime:0.000640s ] [ 2024-02-07T12:42:40+08:00 ] 61.132.54.35 /xmt/index.php/User/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000012s ] INFO: [ app_init ] --END-- [ RunTime:0.000277s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000364s ] INFO: [ app_begin ] --END-- [ RunTime:0.000399s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.006084s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006002s ] SQL: SHOW COLUMNS FROM `xmt_role` [ RunTime:0.005525s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_user user LEFT JOIN xmt_village village ON user.sno = village.no and village.del=0 LEFT JOIN xmt_role role ON role.rno = user.rno and role.del=0 LEFT JOIN xmt_user user2 ON user.updater = user2.uno and user2.del=0 WHERE ( user.del=0 ) LIMIT 1 [ RunTime:0.004893s ] SQL: SELECT user.id AS id,user.name AS name,user.pwd AS pwd,user.rno AS rno,user.openid AS openid,user.tel AS tel,user.uno AS uno,user.tx AS tx,user.cno AS cno,user.nc AS nc,user.spno AS spno,user.del AS del,user.creater AS creater,user.ctime AS ctime,user.updater AS updater,user.utime AS utime,user.user_name AS user_name,user.sno AS sno,user.sts AS sts,village.name AS vname,role.name AS rname,user2.name AS updater_name FROM xmt_user user LEFT JOIN xmt_village village ON user.sno = village.no and village.del=0 LEFT JOIN xmt_role role ON role.rno = user.rno and role.del=0 LEFT JOIN xmt_user user2 ON user.updater = user2.uno and user2.del=0 WHERE ( user.del=0 ) ORDER BY user.utime Desc LIMIT 0,10 [ RunTime:0.003729s ] [ 2024-02-07T12:42:52+08:00 ] 61.132.54.35 /xmt/index.php/dictionary/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000296s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000373s ] INFO: [ app_begin ] --END-- [ RunTime:0.000404s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.006311s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001338s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005436s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000572s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '111' and del=0 ) ORDER BY sort [ RunTime:0.000498s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000066s ] INFO: [ template_filter ] --END-- [ RunTime:0.000115s ] NOTIC: [8] Undefined variable: role D:\code\xmt\#runtime\Cache\Home\e39de1c7dd215b7c497ae70b3cf10b04.php 第 32 行. INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.391030s ] INFO: [ view_parse ] --END-- [ RunTime:0.391079s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000336s ] INFO: [ view_filter ] --END-- [ RunTime:0.000364s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000524s ] INFO: [ app_end ] --END-- [ RunTime:0.000554s ] [ 2024-02-07T12:42:53+08:00 ] 61.132.54.35 /xmt/index.php/Dictionary/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000369s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001171s ] INFO: [ app_begin ] --END-- [ RunTime:0.001207s ] SQL: SHOW COLUMNS FROM `xmt_dict` [ RunTime:0.006788s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_dict` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.000292s ] SQL: SELECT * FROM `xmt_dict` WHERE ( del=0 ) ORDER BY dtype, dvalue LIMIT 0,15 [ RunTime:0.001062s ] [ 2024-02-07T12:42:57+08:00 ] 61.132.54.35 /xmt/index.php/AppVersion/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000265s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000345s ] INFO: [ app_begin ] --END-- [ RunTime:0.000376s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.006947s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001258s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005697s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000543s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '116' and del=0 ) ORDER BY sort [ RunTime:0.000368s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000051s ] INFO: [ template_filter ] --END-- [ RunTime:0.000094s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.092329s ] INFO: [ view_parse ] --END-- [ RunTime:0.092389s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.001284s ] INFO: [ view_filter ] --END-- [ RunTime:0.001344s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.327081s ] INFO: [ app_end ] --END-- [ RunTime:0.327713s ] [ 2024-02-07T12:42:57+08:00 ] 61.132.54.35 /xmt/index.php/AppVersion/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000269s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000357s ] INFO: [ app_begin ] --END-- [ RunTime:0.000434s ] SQL: SHOW COLUMNS FROM `xmt_app_version` [ RunTime:0.007777s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_app_version` WHERE ( 1=1 ) LIMIT 1 [ RunTime:0.000287s ] SQL: SELECT * FROM `xmt_app_version` WHERE ( 1=1 ) ORDER BY version desc LIMIT 0,10 [ RunTime:0.000983s ] [ 2024-02-07T12:43:01+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000346s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000433s ] INFO: [ app_begin ] --END-- [ RunTime:0.000468s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005824s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001317s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005536s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000675s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '903' and del=0 ) ORDER BY sort [ RunTime:0.000442s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000261s ] INFO: [ template_filter ] --END-- [ RunTime:0.000333s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.079326s ] INFO: [ view_parse ] --END-- [ RunTime:0.079386s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000218s ] INFO: [ view_filter ] --END-- [ RunTime:0.000241s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000435s ] INFO: [ app_end ] --END-- [ RunTime:0.000463s ] [ 2024-02-07T12:43:02+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000278s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000383s ] INFO: [ app_begin ] --END-- [ RunTime:0.000417s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) group by a.xhno [ RunTime:0.929589s ] [ 2024-02-07T12:43:02+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/equipTreeSearch?vname=&_=1707280980189 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000302s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000554s ] INFO: [ app_begin ] --END-- [ RunTime:0.000598s ] SQL: SHOW COLUMNS FROM `xmt_v_equip_tree` [ RunTime:0.007419s ] SQL: SELECT * FROM `xmt_v_equip_tree` WHERE ( 1=1 and no in (select bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.043215s ] [ 2024-02-07T12:43:03+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/getChart?no=&vtype=&_=1707280980190 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000283s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000348s ] INFO: [ app_begin ] --END-- [ RunTime:0.000378s ] SQL: select xhname imei from xmt_pdt_xh where del = 0 [ RunTime:0.000258s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) group by a.xhno [ RunTime:0.971143s ] [ 2024-02-07T12:43:14+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000274s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000369s ] INFO: [ app_begin ] --END-- [ RunTime:0.000403s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and v.city = "1002" group by a.xhno [ RunTime:0.686405s ] [ 2024-02-07T12:43:15+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/getChart?no=1002&vtype=2&_=1707280980191 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000258s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000366s ] INFO: [ app_begin ] --END-- [ RunTime:0.000397s ] SQL: select xhname imei from xmt_pdt_xh where del = 0 [ RunTime:0.000235s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and v.city = "1002" group by a.xhno [ RunTime:0.982592s ] [ 2024-02-07T12:43:39+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000280s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000358s ] INFO: [ app_begin ] --END-- [ RunTime:0.000385s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and v.area = "100208" group by a.xhno [ RunTime:0.950769s ] [ 2024-02-07T12:43:40+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/getChart?no=100208&vtype=3&_=1707280980192 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000007s ] INFO: [ app_init ] --END-- [ RunTime:0.000265s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000360s ] INFO: [ app_begin ] --END-- [ RunTime:0.000388s ] SQL: select xhname imei from xmt_pdt_xh where del = 0 [ RunTime:0.000234s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and v.area = "100208" group by a.xhno [ RunTime:0.980513s ] [ 2024-02-07T12:43:47+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000012s ] INFO: [ app_init ] --END-- [ RunTime:0.000351s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000463s ] INFO: [ app_begin ] --END-- [ RunTime:0.000500s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and v.city = "1002" group by a.xhno [ RunTime:0.934227s ] [ 2024-02-07T12:43:48+08:00 ] 61.132.54.35 /xmt/index.php/EquipFaultRate/getChart?no=1002&vtype=2&_=1707280980193 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000289s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000369s ] INFO: [ app_begin ] --END-- [ RunTime:0.000397s ] SQL: select xhname imei from xmt_pdt_xh where del = 0 [ RunTime:0.000263s ] SQL: select a.xhno,a.xhname,count(a.xhno) amount,ifnull(d.pdtxh,0) pdtxh,ifnull(d.wxamount,0) wxamount,ifnull(round(d.wxamount/count(a.xhno)*100,2),0) rate from xmt_pdt_xh a left join xmt_pdt b on a.xhno = b.pdtxh left join xmt_village v on b.vno = v.no and v.del=0 left join (select e.pdtxh,count(1) wxamount from xmt_repair_log c left join xmt_pdt e on c.eqno = e.imei and e.del=0 group by e.pdtxh) d on a.xhno = d.pdtxh where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and v.city = "1002" group by a.xhno [ RunTime:1.035836s ] [ 2024-02-07T12:43:50+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000300s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000378s ] INFO: [ app_begin ] --END-- [ RunTime:0.000413s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.009856s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001302s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005758s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000681s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '902' and del=0 ) ORDER BY sort [ RunTime:0.000434s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. SQL: SHOW COLUMNS FROM `xmt_province` [ RunTime:0.005844s ] SQL: SELECT `sn`,`name` FROM `xmt_province` WHERE `del` = 0 ORDER BY `id` asc [ RunTime:0.000270s ] SQL: SHOW COLUMNS FROM `xmt_dict` [ RunTime:0.005560s ] SQL: SELECT `dno`,`dvalue` FROM `xmt_dict` WHERE `del` = 0 AND `dtype` = 'TDTYPE' ORDER BY `id` asc [ RunTime:0.000331s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000107s ] INFO: [ template_filter ] --END-- [ RunTime:0.000165s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.102465s ] INFO: [ view_parse ] --END-- [ RunTime:0.102518s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000254s ] INFO: [ view_filter ] --END-- [ RunTime:0.000344s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000527s ] INFO: [ app_end ] --END-- [ RunTime:0.000557s ] [ 2024-02-07T12:43:51+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000283s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000369s ] INFO: [ app_begin ] --END-- [ RunTime:0.000426s ] SQL: SELECT b.`name` as vno, c.dvalue AS cno, count(a.vno) AS cnt, SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END) AS cnt1, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.no and b.del = 0 LEFT JOIN xmt_dict c ON a.cno = c.dno and c.dtype='TDTYPE' and c.del=0 WHERE a.del=0 and a.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) GROUP BY b.no,a.cno ORDER BY rate DESC [ RunTime:0.702083s ] [ 2024-02-07T12:43:51+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/villageTreeSearch?vname=&_=1707281029227 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000282s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000375s ] INFO: [ app_begin ] --END-- [ RunTime:0.000408s ] SQL: SHOW COLUMNS FROM `xmt_v_equip_tree` [ RunTime:0.018195s ] SQL: SELECT * FROM `xmt_v_equip_tree` WHERE ( 1=1 and no in (select bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.056780s ] [ 2024-02-07T12:43:51+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/getChart?begtime=&endtime=&category=&_=1707281029228 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000259s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000337s ] INFO: [ app_begin ] --END-- [ RunTime:0.000364s ] NOTIC: [8] Undefined variable: condition1 D:\code\xmt\vis\Apps\Home\Service\DeliveryRateService.class.php 第 111 行. SQL: SELECT b.no imei, b.`name` FROM xmt_data_resource a left join xmt_pdt pdt on a.imei = pdt.imei and pdt.del=0 LEFT JOIN xmt_village b ON pdt.vno = b.`no` WHERE b.del = 0 and a.uno='US00000000000001' GROUP BY b.no [ RunTime:0.003902s ] NOTIC: [8] Undefined variable: condition1 D:\code\xmt\vis\Apps\Home\Service\DeliveryRateService.class.php 第 123 行. SQL: SELECT b.ppno as vno, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.`no` WHERE a.del=0 GROUP BY b.ppno ORDER BY rate DESC [ RunTime:0.054229s ] [ 2024-02-07T12:43:53+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/getChart?begtime=&endtime=&category=&no=1002&vtype=2&_=1707281029229 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000369s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000404s ] INFO: [ app_begin ] --END-- [ RunTime:0.000434s ] SQL: SELECT b.no imei, b.`name` FROM xmt_data_resource a left join xmt_pdt pdt on a.imei = pdt.imei and pdt.del=0 LEFT JOIN xmt_village b ON pdt.vno = b.`no` WHERE b.del = 0 and a.uno='US00000000000001' and b.city = "1002" GROUP BY b.no [ RunTime:0.002237s ] SQL: SELECT b.ppno as vno, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.`no` WHERE a.del=0 and b.city = "1002" GROUP BY b.ppno ORDER BY rate DESC [ RunTime:0.052792s ] [ 2024-02-07T12:43:54+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000454s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000360s ] INFO: [ app_begin ] --END-- [ RunTime:0.000389s ] SQL: SELECT b.`name` as vno, c.dvalue AS cno, count(a.vno) AS cnt, SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END) AS cnt1, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.no and b.del = 0 LEFT JOIN xmt_dict c ON a.cno = c.dno and c.dtype='TDTYPE' and c.del=0 WHERE a.del=0 and a.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and b.city = "1002" GROUP BY b.no,a.cno ORDER BY rate DESC [ RunTime:0.605683s ] [ 2024-02-07T12:44:00+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/getChart?begtime=&endtime=&category=&no=10&vtype=1&_=1707281029230 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000018s ] INFO: [ app_init ] --END-- [ RunTime:0.000424s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000439s ] INFO: [ app_begin ] --END-- [ RunTime:0.000494s ] SQL: SELECT b.no imei, b.`name` FROM xmt_data_resource a left join xmt_pdt pdt on a.imei = pdt.imei and pdt.del=0 LEFT JOIN xmt_village b ON pdt.vno = b.`no` WHERE b.del = 0 and a.uno='US00000000000001' and b.pvc = "10" GROUP BY b.no [ RunTime:0.003094s ] SQL: SELECT b.ppno as vno, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.`no` WHERE a.del=0 and b.pvc = "10" GROUP BY b.ppno ORDER BY rate DESC [ RunTime:0.068490s ] [ 2024-02-07T12:44:00+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000527s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000374s ] INFO: [ app_begin ] --END-- [ RunTime:0.000416s ] SQL: SELECT b.`name` as vno, c.dvalue AS cno, count(a.vno) AS cnt, SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END) AS cnt1, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.no and b.del = 0 LEFT JOIN xmt_dict c ON a.cno = c.dno and c.dtype='TDTYPE' and c.del=0 WHERE a.del=0 and a.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and b.pvc = "10" GROUP BY b.no,a.cno ORDER BY rate DESC [ RunTime:0.202178s ] [ 2024-02-07T12:44:03+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/getChart?begtime=&endtime=&category=&no=1002080001&vtype=4&_=1707281029231 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000294s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000391s ] INFO: [ app_begin ] --END-- [ RunTime:0.000427s ] SQL: SELECT b.no imei, b.`name` FROM xmt_data_resource a left join xmt_pdt pdt on a.imei = pdt.imei and pdt.del=0 LEFT JOIN xmt_village b ON pdt.vno = b.`no` WHERE b.del = 0 and a.uno='US00000000000001' and b.street = "1002080001" GROUP BY b.no [ RunTime:0.002003s ] SQL: SELECT b.ppno as vno, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.`no` WHERE a.del=0 and b.street = "1002080001" GROUP BY b.ppno ORDER BY rate DESC [ RunTime:0.050705s ] [ 2024-02-07T12:44:03+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000479s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000513s ] INFO: [ app_begin ] --END-- [ RunTime:0.000561s ] SQL: SELECT b.`name` as vno, c.dvalue AS cno, count(a.vno) AS cnt, SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END) AS cnt1, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.no and b.del = 0 LEFT JOIN xmt_dict c ON a.cno = c.dno and c.dtype='TDTYPE' and c.del=0 WHERE a.del=0 and a.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and b.street = "1002080001" GROUP BY b.no,a.cno ORDER BY rate DESC [ RunTime:0.167092s ] [ 2024-02-07T12:44:04+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/getChart?begtime=&endtime=&category=&no=1002080009&vtype=4&_=1707281029232 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000303s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000383s ] INFO: [ app_begin ] --END-- [ RunTime:0.000416s ] SQL: SELECT b.no imei, b.`name` FROM xmt_data_resource a left join xmt_pdt pdt on a.imei = pdt.imei and pdt.del=0 LEFT JOIN xmt_village b ON pdt.vno = b.`no` WHERE b.del = 0 and a.uno='US00000000000001' and b.street = "1002080009" GROUP BY b.no [ RunTime:0.001948s ] SQL: SELECT b.ppno as vno, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.`no` WHERE a.del=0 and b.street = "1002080009" GROUP BY b.ppno ORDER BY rate DESC [ RunTime:0.045040s ] [ 2024-02-07T12:44:05+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000313s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000390s ] INFO: [ app_begin ] --END-- [ RunTime:0.000419s ] SQL: SELECT b.`name` as vno, c.dvalue AS cno, count(a.vno) AS cnt, SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END) AS cnt1, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.no and b.del = 0 LEFT JOIN xmt_dict c ON a.cno = c.dno and c.dtype='TDTYPE' and c.del=0 WHERE a.del=0 and a.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and b.street = "1002080009" GROUP BY b.no,a.cno ORDER BY rate DESC [ RunTime:0.509610s ] [ 2024-02-07T12:44:07+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/getChart?begtime=&endtime=&category=&no=1002&vtype=2&_=1707281029233 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000365s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000379s ] INFO: [ app_begin ] --END-- [ RunTime:0.000412s ] SQL: SELECT b.no imei, b.`name` FROM xmt_data_resource a left join xmt_pdt pdt on a.imei = pdt.imei and pdt.del=0 LEFT JOIN xmt_village b ON pdt.vno = b.`no` WHERE b.del = 0 and a.uno='US00000000000001' and b.city = "1002" GROUP BY b.no [ RunTime:0.002156s ] SQL: SELECT b.ppno as vno, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.`no` WHERE a.del=0 and b.city = "1002" GROUP BY b.ppno ORDER BY rate DESC [ RunTime:0.288754s ] [ 2024-02-07T12:44:07+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000353s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000362s ] INFO: [ app_begin ] --END-- [ RunTime:0.000394s ] SQL: SELECT b.`name` as vno, c.dvalue AS cno, count(a.vno) AS cnt, SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END) AS cnt1, round((SUM(CASE a.ljflsts WHEN 1 THEN 1 ELSE 0 END))/(count(a.ljflsts))*100,2) AS rate FROM xmt_flow_td a LEFT JOIN xmt_village b ON a.vno=b.no and b.del = 0 LEFT JOIN xmt_dict c ON a.cno = c.dno and c.dtype='TDTYPE' and c.del=0 WHERE a.del=0 and a.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and b.city = "1002" GROUP BY b.no,a.cno ORDER BY rate DESC [ RunTime:0.201050s ] [ 2024-02-07T12:44:25+08:00 ] 61.132.54.35 /xmt/index.php/PointFlow/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000015s ] INFO: [ app_init ] --END-- [ RunTime:0.000380s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000375s ] INFO: [ app_begin ] --END-- [ RunTime:0.000412s ] SQL: SHOW COLUMNS FROM `xmt_role` [ RunTime:0.006512s ] SQL: SELECT `ishide` FROM `xmt_role` WHERE ( rno="RE00000000000001" ) LIMIT 1 [ RunTime:0.000266s ] SQL: SHOW COLUMNS FROM `xmt_province` [ RunTime:0.004825s ] SQL: SELECT `sn`,`name` FROM `xmt_province` WHERE `del` = 0 ORDER BY `id` asc [ RunTime:0.000335s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000111s ] INFO: [ template_filter ] --END-- [ RunTime:0.000162s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.319114s ] INFO: [ view_parse ] --END-- [ RunTime:0.319179s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000490s ] INFO: [ view_filter ] --END-- [ RunTime:0.000531s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000726s ] INFO: [ app_end ] --END-- [ RunTime:0.000775s ] [ 2024-02-07T12:44:25+08:00 ] 61.132.54.35 /xmt/index.php/PointFlow/equipTreeSearch?vname=&_=1707281064227 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000012s ] INFO: [ app_init ] --END-- [ RunTime:0.000459s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000491s ] INFO: [ app_begin ] --END-- [ RunTime:0.000532s ] SQL: SHOW COLUMNS FROM `xmt_v_equip_tree` [ RunTime:0.007153s ] SQL: SELECT * FROM `xmt_v_equip_tree` WHERE ( 1=1 and no in (select bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.097625s ] [ 2024-02-07T12:44:25+08:00 ] 61.132.54.35 /xmt/index.php/PointFlow/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000292s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000716s ] INFO: [ app_begin ] --END-- [ RunTime:0.000760s ] [ 2024-02-07T12:44:28+08:00 ] 61.132.54.35 /xmt/index.php/PointFlow/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000260s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000413s ] INFO: [ app_begin ] --END-- [ RunTime:0.000446s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) LIMIT 1 [ RunTime:0.050055s ] ERR: 1449:The user specified as a definer ('root'@'%') does not exist [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) LIMIT 1 SQL: SELECT v_jf.uuid AS uuid,v_jf.gno AS gno,v_jf.vno AS vno,v_jf.imei AS imei,v_jf.uno AS uno,v_jf.point AS point,v_jf.bpoint AS bpoint,v_jf.apoint AS apoint,v_jf.num AS num,v_jf.creater AS creater,v_jf.ctime AS ctime,village.name AS vname,village.pvc AS pvc,village.city AS city,village.area AS area,pdt.pdtno AS pdtno,user.user_name AS user_name FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) ORDER BY v_jf.ctime desc LIMIT 0,15 [ RunTime:0.000311s ] ERR: 1449:The user specified as a definer ('root'@'%') does not exist [ SQL语句 ] : SELECT v_jf.uuid AS uuid,v_jf.gno AS gno,v_jf.vno AS vno,v_jf.imei AS imei,v_jf.uno AS uno,v_jf.point AS point,v_jf.bpoint AS bpoint,v_jf.apoint AS apoint,v_jf.num AS num,v_jf.creater AS creater,v_jf.ctime AS ctime,village.name AS vname,village.pvc AS pvc,village.city AS city,village.area AS area,pdt.pdtno AS pdtno,user.user_name AS user_name FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) ORDER BY v_jf.ctime desc LIMIT 0,15 [ 2024-02-07T12:44:31+08:00 ] 61.132.54.35 /xmt/index.php/PointFlow/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000261s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000354s ] INFO: [ app_begin ] --END-- [ RunTime:0.000384s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.pvc = "10" ) LIMIT 1 [ RunTime:0.000267s ] ERR: 1449:The user specified as a definer ('root'@'%') does not exist [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.pvc = "10" ) LIMIT 1 SQL: SELECT v_jf.uuid AS uuid,v_jf.gno AS gno,v_jf.vno AS vno,v_jf.imei AS imei,v_jf.uno AS uno,v_jf.point AS point,v_jf.bpoint AS bpoint,v_jf.apoint AS apoint,v_jf.num AS num,v_jf.creater AS creater,v_jf.ctime AS ctime,village.name AS vname,village.pvc AS pvc,village.city AS city,village.area AS area,pdt.pdtno AS pdtno,user.user_name AS user_name FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.pvc = "10" ) ORDER BY v_jf.ctime desc LIMIT 0,15 [ RunTime:0.000205s ] ERR: 1449:The user specified as a definer ('root'@'%') does not exist [ SQL语句 ] : SELECT v_jf.uuid AS uuid,v_jf.gno AS gno,v_jf.vno AS vno,v_jf.imei AS imei,v_jf.uno AS uno,v_jf.point AS point,v_jf.bpoint AS bpoint,v_jf.apoint AS apoint,v_jf.num AS num,v_jf.creater AS creater,v_jf.ctime AS ctime,village.name AS vname,village.pvc AS pvc,village.city AS city,village.area AS area,pdt.pdtno AS pdtno,user.user_name AS user_name FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.pvc = "10" ) ORDER BY v_jf.ctime desc LIMIT 0,15 [ 2024-02-07T12:44:32+08:00 ] 61.132.54.35 /xmt/index.php/PointFlow/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000303s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000366s ] INFO: [ app_begin ] --END-- [ RunTime:0.000398s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) LIMIT 1 [ RunTime:0.000282s ] ERR: 1449:The user specified as a definer ('root'@'%') does not exist [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) LIMIT 1 SQL: SELECT v_jf.uuid AS uuid,v_jf.gno AS gno,v_jf.vno AS vno,v_jf.imei AS imei,v_jf.uno AS uno,v_jf.point AS point,v_jf.bpoint AS bpoint,v_jf.apoint AS apoint,v_jf.num AS num,v_jf.creater AS creater,v_jf.ctime AS ctime,village.name AS vname,village.pvc AS pvc,village.city AS city,village.area AS area,pdt.pdtno AS pdtno,user.user_name AS user_name FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) ORDER BY v_jf.ctime desc LIMIT 0,15 [ RunTime:0.000205s ] ERR: 1449:The user specified as a definer ('root'@'%') does not exist [ SQL语句 ] : SELECT v_jf.uuid AS uuid,v_jf.gno AS gno,v_jf.vno AS vno,v_jf.imei AS imei,v_jf.uno AS uno,v_jf.point AS point,v_jf.bpoint AS bpoint,v_jf.apoint AS apoint,v_jf.num AS num,v_jf.creater AS creater,v_jf.ctime AS ctime,village.name AS vname,village.pvc AS pvc,village.city AS city,village.area AS area,pdt.pdtno AS pdtno,user.user_name AS user_name FROM xmt_v_jf v_jf LEFT JOIN xmt_village village ON village.no = v_jf.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = v_jf.imei and pdt.del=0 LEFT JOIN xmt_user user ON user.uno = v_jf.uno and user.del=0 LEFT JOIN xmt_village_user village_user ON village_user.uno = v_jf.uno and village_user.del = 0 WHERE ( 1=1 and village.city = "1002" ) ORDER BY v_jf.ctime desc LIMIT 0,15 [ 2024-02-07T12:44:35+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryFlow/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000287s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000353s ] INFO: [ app_begin ] --END-- [ RunTime:0.000386s ] SQL: SHOW COLUMNS FROM `xmt_role` [ RunTime:0.006220s ] SQL: SELECT `ishide` FROM `xmt_role` WHERE ( rno="RE00000000000001" ) LIMIT 1 [ RunTime:0.000246s ] SQL: SHOW COLUMNS FROM `xmt_province` [ RunTime:0.005738s ] SQL: SELECT `sn`,`name` FROM `xmt_province` WHERE `del` = 0 ORDER BY `id` asc [ RunTime:0.000353s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000084s ] INFO: [ template_filter ] --END-- [ RunTime:0.000128s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.125734s ] INFO: [ view_parse ] --END-- [ RunTime:0.125784s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000208s ] INFO: [ view_filter ] --END-- [ RunTime:0.000229s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000408s ] INFO: [ app_end ] --END-- [ RunTime:0.000435s ] [ 2024-02-07T12:44:36+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryFlow/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000310s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000337s ] INFO: [ app_begin ] --END-- [ RunTime:0.000368s ] [ 2024-02-07T12:44:36+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryFlow/equipTreeSearch?vname=&_=1707281074507 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000007s ] INFO: [ app_init ] --END-- [ RunTime:0.000262s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000522s ] INFO: [ app_begin ] --END-- [ RunTime:0.000559s ] SQL: SHOW COLUMNS FROM `xmt_v_equip_tree` [ RunTime:0.006429s ] SQL: SELECT * FROM `xmt_v_equip_tree` WHERE ( 1=1 and no in (select bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.050203s ] [ 2024-02-07T12:44:44+08:00 ] 61.132.54.35 /xmt/index.php/DeliveryFlow/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000259s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000351s ] INFO: [ app_begin ] --END-- [ RunTime:0.000383s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_flow_td td LEFT JOIN xmt_village village ON village.no = td.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = td.imei and pdt.del=0 LEFT JOIN xmt_user user1 ON user1.uno = td.qyuno and user1.del=0 LEFT JOIN xmt_user user ON user.uno = td.uno and user.del=0 LEFT JOIN xmt_fault_reason fault_reason ON fault_reason.rsno = td.resno and fault_reason.del=0 LEFT JOIN xmt_category category ON category.cno = td.cno and td.vno = category.vno and category.del=0 LEFT JOIN xmt_dict dict ON dict.dno = category.cno WHERE ( 1=1 and village.city = "1002" ) LIMIT 1 [ RunTime:2.425447s ] SQL: SELECT td.uuid AS uuid,td.imei AS imei,td.uno AS uno,td.vno AS vno,td.colno AS colno,td.cno AS cno,td.weight AS weight,td.aweight AS aweight,td.bweight AS bweight,td.cbhgt AS cbhgt,td.qyuno AS qyuno,td.ljflsts AS ljflsts,td.resno AS resno,td.resdetail AS resdetail,td.point AS point,td.apoint AS apoint,td.bpoint AS bpoint,td.ctime AS ctime,td.updater AS updater,td.creater AS creater,td.utime AS utime,village.name AS vname,village.pvc AS pvc,village.city AS city,village.area AS area,pdt.pdtno AS pdtno,user1.user_name AS qyname,user.user_name AS user_name,fault_reason.rsname AS rsname,dict.dvalue AS dvalue FROM xmt_flow_td td LEFT JOIN xmt_village village ON village.no = td.vno and village.del=0 LEFT JOIN xmt_pdt pdt ON pdt.imei = td.imei and pdt.del=0 LEFT JOIN xmt_user user1 ON user1.uno = td.qyuno and user1.del=0 LEFT JOIN xmt_user user ON user.uno = td.uno and user.del=0 LEFT JOIN xmt_fault_reason fault_reason ON fault_reason.rsno = td.resno and fault_reason.del=0 LEFT JOIN xmt_category category ON category.cno = td.cno and td.vno = category.vno and category.del=0 LEFT JOIN xmt_dict dict ON dict.dno = category.cno WHERE ( 1=1 and village.city = "1002" ) ORDER BY td.ctime desc LIMIT 0,15 [ RunTime:4.178834s ] [ 2024-02-07T12:45:22+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000018s ] INFO: [ app_init ] --END-- [ RunTime:0.010017s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001050s ] INFO: [ app_begin ] --END-- [ RunTime:0.001104s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005862s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001216s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005181s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000596s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '502' and del=0 ) ORDER BY sort [ RunTime:0.000434s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000092s ] INFO: [ template_filter ] --END-- [ RunTime:0.000137s ] NOTIC: [8] Undefined variable: SCAN_ADDR D:\code\xmt\#runtime\Cache\Home\d5cbb509b9cc36a817754eadc958ab73.php 第 550 行. INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.229342s ] INFO: [ view_parse ] --END-- [ RunTime:0.229384s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000819s ] INFO: [ view_filter ] --END-- [ RunTime:0.000867s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001010s ] INFO: [ app_end ] --END-- [ RunTime:0.001046s ] [ 2024-02-07T12:45:23+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000327s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000370s ] INFO: [ app_begin ] --END-- [ RunTime:0.000403s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.008529s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="" ) LIMIT 1 [ RunTime:0.002348s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and 1=2 group by a.uno [ RunTime:0.000884s ] [ 2024-02-07T12:45:23+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/villageTreeAllSearch?vname=&_=1707281121364 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000283s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000423s ] INFO: [ app_begin ] --END-- [ RunTime:0.000470s ] SQL: SHOW COLUMNS FROM `xmt_v_village_tree` [ RunTime:0.006361s ] SQL: SELECT * FROM `xmt_v_village_tree` WHERE ( 1=1 and ppno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.006855s ] [ 2024-02-07T12:45:34+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000359s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000671s ] INFO: [ app_begin ] --END-- [ RunTime:0.000725s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.007430s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000051" ) LIMIT 1 [ RunTime:0.000313s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno1 like "%VI00000051%" group by a.uno [ RunTime:0.002437s ] [ 2024-02-07T12:45:39+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000359s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000421s ] INFO: [ app_begin ] --END-- [ RunTime:0.000451s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.007397s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000051" ) LIMIT 1 [ RunTime:0.000366s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno1 like "%VI00000051%" group by a.uno [ RunTime:0.002518s ] [ 2024-02-07T12:45:42+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000269s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000352s ] INFO: [ app_begin ] --END-- [ RunTime:0.000382s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.005859s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000050" ) LIMIT 1 [ RunTime:0.000326s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno1 like "%VI00000050%" group by a.uno [ RunTime:0.002392s ] [ 2024-02-07T12:45:43+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000259s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000354s ] INFO: [ app_begin ] --END-- [ RunTime:0.000384s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.005835s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000053" ) LIMIT 1 [ RunTime:0.000367s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno2 like "%VI00000053%" group by a.uno [ RunTime:0.002396s ] [ 2024-02-07T12:45:43+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000265s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000366s ] INFO: [ app_begin ] --END-- [ RunTime:0.000396s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006235s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000028" ) LIMIT 1 [ RunTime:0.004154s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno like "%VI00000028%" group by a.uno [ RunTime:0.003132s ] [ 2024-02-07T12:45:45+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000262s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000353s ] INFO: [ app_begin ] --END-- [ RunTime:0.000383s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.007029s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000152" ) LIMIT 1 [ RunTime:0.000295s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000152%" group by a.uno [ RunTime:0.005805s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000152%" group by a.uno limit 0,10 [ RunTime:0.002392s ] [ 2024-02-07T12:45:51+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000281s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000380s ] INFO: [ app_begin ] --END-- [ RunTime:0.000416s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006579s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000055" ) LIMIT 1 [ RunTime:0.000314s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno like "%VI00000055%" group by a.uno [ RunTime:0.002868s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno like "%VI00000055%" group by a.uno limit 0,10 [ RunTime:0.002645s ] [ 2024-02-07T12:45:54+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000270s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000343s ] INFO: [ app_begin ] --END-- [ RunTime:0.000372s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006960s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000156" ) LIMIT 1 [ RunTime:0.000370s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000156%" group by a.uno [ RunTime:0.002560s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000156%" group by a.uno limit 0,10 [ RunTime:0.002543s ] [ 2024-02-07T12:45:57+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000262s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000349s ] INFO: [ app_begin ] --END-- [ RunTime:0.000380s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006332s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000169" ) LIMIT 1 [ RunTime:0.000278s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000169%" group by a.uno [ RunTime:0.002331s ] [ 2024-02-07T12:45:58+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000363s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000360s ] INFO: [ app_begin ] --END-- [ RunTime:0.000390s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.005990s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000172" ) LIMIT 1 [ RunTime:0.000370s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000172%" group by a.uno [ RunTime:0.002434s ] [ 2024-02-07T12:46:00+08:00 ] 61.132.54.35 /xmt/index.php/VillageUser/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000264s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000340s ] INFO: [ app_begin ] --END-- [ RunTime:0.000371s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006415s ] SQL: SELECT `type` FROM `xmt_village` WHERE ( no="VI00000196" ) LIMIT 1 [ RunTime:0.000329s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000196%" group by a.uno [ RunTime:0.002648s ] SQL: SELECT a.id, a.`name`, a.uno, a.cardno, a.bankno, a.street, a.tel, a.idno, a.address, a.cname, a.age, a.wxopenid, a.xcxopenid, a.utime, b.`name` AS updater_name, c.`name` AS vname, a.point, a.vno3 AS vno, sum(dh.point) AS spoint FROM xmt_village_user a LEFT JOIN xmt_user b ON a.updater = b.uno LEFT JOIN xmt_village c ON a.vno3 = c.no LEFT JOIN xmt_flow_dh dh ON dh.uno = a.uno WHERE a.del=0 and a.vno3 like "%VI00000196%" group by a.uno limit 0,10 [ RunTime:0.002667s ] [ 2024-02-07T12:46:06+08:00 ] 61.132.54.35 /xmt/index.php/CommunityEquipment/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000271s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000338s ] INFO: [ app_begin ] --END-- [ RunTime:0.000370s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005986s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001193s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005142s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000610s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '506' and del=0 ) ORDER BY sort [ RunTime:0.000497s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. SQL: select b.no,b.name from xmt_village b where b.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) [ RunTime:0.001854s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000080s ] INFO: [ template_filter ] --END-- [ RunTime:0.000126s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.077446s ] INFO: [ view_parse ] --END-- [ RunTime:0.077496s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000213s ] INFO: [ view_filter ] --END-- [ RunTime:0.000236s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000469s ] INFO: [ app_end ] --END-- [ RunTime:0.000498s ] [ 2024-02-07T12:46:08+08:00 ] 61.132.54.35 /xmt/index.php/CommunityEquipment/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000319s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000427s ] INFO: [ app_begin ] --END-- [ RunTime:0.000460s ] SQL: select count(1) as a FROM (SELECT a.id, a.imei, c.xhname AS pdtxh, a.pdtcno, b.`name` AS vname, a.ests, a.sts, a.utime, d.`name` AS updater_name FROM xmt_pdt a LEFT JOIN xmt_village b ON a.vno = b.`no` LEFT JOIN xmt_pdt_xh c ON a.pdtxh = c.xhno LEFT JOIN xmt_user d ON a.updater = d.uno WHERE a.del=0 and a.vno in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) zz [ RunTime:0.854614s ] SQL: SELECT a.id, a.imei, c.xhname as pdtxh, a.pdtcno, b.`name` as vname, a.ests, a.sts, a.utime, d.`name`AS updater_name FROM xmt_pdt a LEFT JOIN xmt_village b ON a.vno = b.`no` LEFT JOIN xmt_pdt_xh c ON a.pdtxh = c.xhno LEFT JOIN xmt_user d ON a.updater=d.uno WHERE a.del=0 and a.vno in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) limit 0,10 [ RunTime:0.929481s ] [ 2024-02-07T12:46:08+08:00 ] 61.132.54.35 /xmt/index.php/CommunityEquipment/villageTreeSearch?vname=&_=1707281165272 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000261s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000355s ] INFO: [ app_begin ] --END-- [ RunTime:0.000385s ] SQL: SHOW COLUMNS FROM `xmt_v_equip_tree` [ RunTime:0.006345s ] SQL: SELECT * FROM `xmt_v_equip_tree` WHERE ( 1=1 and no in (select bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.043315s ] [ 2024-02-07T12:46:14+08:00 ] 61.132.54.35 /xmt/index.php/CommunityEquipment/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000287s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000415s ] INFO: [ app_begin ] --END-- [ RunTime:0.000447s ] SQL: select count(1) as a FROM (SELECT a.id, a.imei, c.xhname AS pdtxh, a.pdtcno, b.`name` AS vname, a.ests, a.sts, a.utime, d.`name` AS updater_name FROM xmt_pdt a LEFT JOIN xmt_village b ON a.vno = b.`no` LEFT JOIN xmt_pdt_xh c ON a.pdtxh = c.xhno LEFT JOIN xmt_user d ON a.updater = d.uno WHERE a.del=0 and a.vno in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and b.city = "1002" ) zz [ RunTime:0.628498s ] SQL: SELECT a.id, a.imei, c.xhname as pdtxh, a.pdtcno, b.`name` as vname, a.ests, a.sts, a.utime, d.`name`AS updater_name FROM xmt_pdt a LEFT JOIN xmt_village b ON a.vno = b.`no` LEFT JOIN xmt_pdt_xh c ON a.pdtxh = c.xhno LEFT JOIN xmt_user d ON a.updater=d.uno WHERE a.del=0 and a.vno in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and b.city = "1002" limit 0,10 [ RunTime:0.948755s ] [ 2024-02-07T12:49:07+08:00 ] 61.132.54.35 /xmt/index.php/UnitDelivery/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000015s ] INFO: [ app_init ] --END-- [ RunTime:0.002348s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001103s ] INFO: [ app_begin ] --END-- [ RunTime:0.001157s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.006229s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001213s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005466s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000526s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '503' and del=0 ) ORDER BY sort [ RunTime:0.000344s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. SQL: SHOW COLUMNS FROM `xmt_equip` [ RunTime:0.010558s ] ERR: 1146:Table 'xmt.xmt_equip' doesn't exist [ SQL语句 ] : SHOW COLUMNS FROM `xmt_equip` SQL: SELECT `imei`,`equip_name` FROM `xmt_equip` WHERE `del` = 0 ORDER BY `id` asc [ RunTime:0.000315s ] ERR: 1146:Table 'xmt.xmt_equip' doesn't exist [ SQL语句 ] : SELECT `imei`,`equip_name` FROM `xmt_equip` WHERE `del` = 0 ORDER BY `id` asc SQL: SHOW COLUMNS FROM `xmt_dict` [ RunTime:0.005040s ] SQL: SELECT `dno`,`dvalue` FROM `xmt_dict` WHERE `del` = 0 AND `dtype` = 'TDTYPE' ORDER BY `id` asc [ RunTime:0.000297s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.004689s ] SQL: SELECT `uno`,`user_name` FROM `xmt_user` WHERE `del` = 0 AND `rno` = 'RE00000019' ORDER BY `id` asc [ RunTime:0.000221s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000104s ] INFO: [ template_filter ] --END-- [ RunTime:0.000144s ] NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cno D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. NOTIC: [8] Undefined index: cname D:\code\xmt\#runtime\Cache\Home\b40e393c17f5fe99b1c4f75a6a93e5ca.php 第 126 行. INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.676934s ] INFO: [ view_parse ] --END-- [ RunTime:0.677027s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000927s ] INFO: [ view_filter ] --END-- [ RunTime:0.000975s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001009s ] INFO: [ app_end ] --END-- [ RunTime:0.001041s ] [ 2024-02-07T12:49:07+08:00 ] 61.132.54.35 /xmt/index.php/UnitDelivery/getAreaSn?_=1707281346130 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000314s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000342s ] INFO: [ app_begin ] --END-- [ RunTime:0.000373s ] SQL: SHOW COLUMNS FROM `xmt_village_user` [ RunTime:0.006119s ] SQL: SELECT `area` FROM `xmt_village_user` WHERE `uno` = 'US00000000000001' LIMIT 1 [ RunTime:0.001090s ] [ 2024-02-07T12:49:45+08:00 ] 61.132.54.35 /xmt/index.php/UnitDelivery/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000338s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000460s ] INFO: [ app_begin ] --END-- [ RunTime:0.000491s ] SQL: select a.uno uno, d.name village, a.name user, count(b.weight) dtime, sum(b.weight) totalweight, ROUND(SUM(b.weight)/COUNT(b.weight),2) avgweight, FROM_UNIXTIME(MAX(b.ctime)) recent, SUM(CASE WHEN b.cno LIKE '01%' THEN b.weight ELSE 0 END) AS recycle, SUM(CASE WHEN b.cno LIKE '02%' THEN b.weight ELSE 0 END) AS unrecycle, c.weight recweight, a.utime from xmt_village_user a left join xmt_village d on a.vno=d.no and d.type=1 left join xmt_flow_td b on a.uno = b.uno left join (select uno,weight,max(ctime) from xmt_flow_td group by uno) c on a.uno = c.uno where a.del=0 and b.del=0 group by a.uno order by sum(b.weight) desc [ RunTime:17.863073s ] [ 2024-02-07T12:49:45+08:00 ] 61.132.54.35 /xmt/index.php/UnitDelivery/villageTreeAllSearch?vname=&_=1707281346131 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000271s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000412s ] INFO: [ app_begin ] --END-- [ RunTime:0.000442s ] [ 2024-02-07T12:49:46+08:00 ] 61.132.54.35 /xmt/index.php/GiftStock/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.000355s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000468s ] INFO: [ app_begin ] --END-- [ RunTime:0.000508s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.006622s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.002040s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005897s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000664s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '403' and del=0 ) ORDER BY sort [ RunTime:0.000412s ] SQL: SHOW COLUMNS FROM `xmt_province` [ RunTime:0.006513s ] SQL: SELECT `sn`,`name` FROM `xmt_province` WHERE `del` = 0 ORDER BY `id` asc [ RunTime:0.000307s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000071s ] INFO: [ template_filter ] --END-- [ RunTime:0.000114s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.722218s ] INFO: [ view_parse ] --END-- [ RunTime:0.722275s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000335s ] INFO: [ view_filter ] --END-- [ RunTime:0.000360s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000508s ] INFO: [ app_end ] --END-- [ RunTime:0.000538s ] [ 2024-02-07T12:49:46+08:00 ] 61.132.54.35 /xmt/index.php/GiftStock/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000286s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000417s ] INFO: [ app_begin ] --END-- [ RunTime:0.000448s ] [ 2024-02-07T12:49:46+08:00 ] 61.132.54.35 /xmt/index.php/GiftStock/equipTreeSearch?vname=&_=1707281385018 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000313s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000369s ] INFO: [ app_begin ] --END-- [ RunTime:0.000411s ] SQL: SHOW COLUMNS FROM `xmt_v_equip_tree` [ RunTime:0.008131s ] SQL: SELECT * FROM `xmt_v_equip_tree` WHERE ( 1=1 and no in (select bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.046185s ] [ 2024-02-07T12:50:23+08:00 ] 61.132.54.35 /xmt/index.php/GiftStock/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000277s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000353s ] INFO: [ app_begin ] --END-- [ RunTime:0.000384s ] NOTIC: [8] Undefined variable: where D:\code\xmt\vis\Apps\Home\Service\GiftStockService.class.php 第 47 行. SQL: SHOW COLUMNS FROM `xmt_equip_product_stock` [ RunTime:0.063181s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_equip_product_stock equip_product_stock LEFT JOIN xmt_product product ON product.gno = equip_product_stock.gno and product.del=0 LEFT JOIN xmt_pdt equip ON equip.imei = equip_product_stock.imei and equip.del=0 LEFT JOIN xmt_village village ON village.no = equip.vno and village.del=0 LEFT JOIN xmt_user user ON user.uno = equip_product_stock.creater and user.del=0 LIMIT 1 [ RunTime:0.039193s ] [ 2024-02-07T12:50:37+08:00 ] 61.132.54.35 /xmt/index.php/UnitDelivery/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000287s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000395s ] INFO: [ app_begin ] --END-- [ RunTime:0.000428s ] SQL: select a.uno uno, d.name village, a.name user, count(b.weight) dtime, sum(b.weight) totalweight, ROUND(SUM(b.weight)/COUNT(b.weight),2) avgweight, FROM_UNIXTIME(MAX(b.ctime)) recent, SUM(CASE WHEN b.cno LIKE '01%' THEN b.weight ELSE 0 END) AS recycle, SUM(CASE WHEN b.cno LIKE '02%' THEN b.weight ELSE 0 END) AS unrecycle, c.weight recweight, a.utime from xmt_village_user a left join xmt_village d on a.vno=d.no and d.type=1 left join xmt_flow_td b on a.uno = b.uno left join (select uno,weight,max(ctime) from xmt_flow_td group by uno) c on a.uno = c.uno where a.del=0 and b.del=0 and b.ctime >= "1704084628" and b.ctime <= "1707281433" group by a.uno order by sum(b.weight) desc [ RunTime:0.072576s ] [ 2024-02-07T12:50:43+08:00 ] 61.132.54.35 /xmt/index.php/GiftInfo/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.000344s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000440s ] INFO: [ app_begin ] --END-- [ RunTime:0.000485s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005623s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001165s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.006099s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000682s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '402' and del=0 ) ORDER BY sort [ RunTime:0.000364s ] SQL: SHOW COLUMNS FROM `xmt_provider` [ RunTime:0.008980s ] SQL: SELECT * FROM `xmt_provider` WHERE `del` = 0 [ RunTime:0.002781s ] SQL: SHOW COLUMNS FROM `xmt_dict` [ RunTime:0.005229s ] SQL: SELECT * FROM `xmt_dict` WHERE `dtype` = 'UNIT' AND `del` = 0 [ RunTime:0.000369s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000107s ] INFO: [ template_filter ] --END-- [ RunTime:0.000149s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.136253s ] INFO: [ view_parse ] --END-- [ RunTime:0.136308s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000307s ] INFO: [ view_filter ] --END-- [ RunTime:0.000333s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000501s ] INFO: [ app_end ] --END-- [ RunTime:0.000529s ] [ 2024-02-07T12:50:43+08:00 ] 61.132.54.35 /xmt/index.php/GiftInfo/getGoodsTypeTree?_=1707281442227 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000288s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000370s ] INFO: [ app_begin ] --END-- [ RunTime:0.000404s ] SQL: SHOW COLUMNS FROM `xmt_product_clc` [ RunTime:0.033106s ] SQL: SELECT `gtno`,`pgtno`,`gtname` FROM `xmt_product_clc` WHERE `del` = 0 [ RunTime:0.000399s ] [ 2024-02-07T12:50:44+08:00 ] 61.132.54.35 /xmt/index.php/GiftInfo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000253s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000380s ] INFO: [ app_begin ] --END-- [ RunTime:0.000410s ] SQL: SHOW COLUMNS FROM `xmt_product` [ RunTime:0.526295s ] SQL: SHOW COLUMNS FROM `xmt_product_clc` [ RunTime:0.007732s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.006963s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_product product LEFT JOIN xmt_product_clc product_clc ON product.gtno = product_clc.gtno and product.del=0 LEFT JOIN xmt_user user ON product.updater = user.uno WHERE ( product.del=0 ) LIMIT 1 [ RunTime:0.000469s ] SQL: SELECT product.id AS id,product.gno AS gno,product.gname AS gname,product.gtno AS gtno,product.barcode AS barcode,product.spno AS spno,product.unit AS unit,product.gimg AS gimg,product.gimg2 AS gimg2,product.del AS del,product.creater AS creater,product.ctime AS ctime,product.updater AS updater,product.utime AS utime,product.gdpoint AS gdpoint,product.gdesc AS gdesc,product.gnum AS gnum,product.productid AS productid,product_clc.gtname AS gtname,user.name AS updater_name FROM xmt_product product LEFT JOIN xmt_product_clc product_clc ON product.gtno = product_clc.gtno and product.del=0 LEFT JOIN xmt_user user ON product.updater = user.uno WHERE ( product.del=0 ) ORDER BY product.id desc LIMIT 0,10 [ RunTime:0.000859s ] [ 2024-02-07T12:51:00+08:00 ] 61.132.54.35 /xmt/index.php/Garbage/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000269s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000358s ] INFO: [ app_begin ] --END-- [ RunTime:0.000395s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005610s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001256s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005917s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000612s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '408' and del=0 ) ORDER BY sort [ RunTime:0.000488s ] SQL: SHOW COLUMNS FROM `xmt_provider` [ RunTime:0.004899s ] SQL: SELECT * FROM `xmt_provider` WHERE `del` = 0 [ RunTime:0.000219s ] SQL: SHOW COLUMNS FROM `xmt_dict` [ RunTime:0.004411s ] SQL: SELECT * FROM `xmt_dict` WHERE `dtype` = 'UNIT' AND `del` = 0 [ RunTime:0.000258s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000090s ] INFO: [ template_filter ] --END-- [ RunTime:0.000131s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.086717s ] INFO: [ view_parse ] --END-- [ RunTime:0.086766s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000221s ] INFO: [ view_filter ] --END-- [ RunTime:0.000244s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000440s ] INFO: [ app_end ] --END-- [ RunTime:0.000470s ] [ 2024-02-07T12:51:01+08:00 ] 61.132.54.35 /xmt/index.php/Garbage/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000268s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000344s ] INFO: [ app_begin ] --END-- [ RunTime:0.000382s ] SQL: SHOW COLUMNS FROM `xmt_garbage` [ RunTime:0.011163s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.401512s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_garbage garbage LEFT JOIN xmt_user user ON garbage.updater = user.uno WHERE ( garbage.del=0 ) LIMIT 1 [ RunTime:0.005124s ] [ 2024-02-07T12:51:05+08:00 ] 61.132.54.35 /xmt/index.php/imageVideo/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000267s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000405s ] INFO: [ app_begin ] --END-- [ RunTime:0.000456s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005828s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001255s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.007619s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000562s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '407' and del=0 ) ORDER BY sort [ RunTime:0.000355s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000073s ] INFO: [ template_filter ] --END-- [ RunTime:0.000116s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.124829s ] INFO: [ view_parse ] --END-- [ RunTime:0.124880s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000220s ] INFO: [ view_filter ] --END-- [ RunTime:0.000245s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000449s ] INFO: [ app_end ] --END-- [ RunTime:0.000478s ] [ 2024-02-07T12:51:05+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000290s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000413s ] INFO: [ app_begin ] --END-- [ RunTime:0.000448s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.009477s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) LIMIT 1 [ RunTime:0.001178s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) order by i.id desc limit 0,10 [ RunTime:0.001771s ] [ 2024-02-07T12:51:15+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.000336s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000713s ] INFO: [ app_begin ] --END-- [ RunTime:0.000880s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.008073s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and i.type = "1" ) LIMIT 1 [ RunTime:0.000272s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and i.type = "1" ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and i.type = "1" order by i.id desc limit 0,10 [ RunTime:0.000753s ] [ 2024-02-07T12:52:08+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000259s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000400s ] INFO: [ app_begin ] --END-- [ RunTime:0.000430s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.018952s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and i.type = "1" and p.imei like "%3B0036000A50484D50303920%" ) LIMIT 1 [ RunTime:0.000216s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and i.type = "1" and p.imei like "%3B0036000A50484D50303920%" ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and i.type = "1" and p.imei like "%3B0036000A50484D50303920%" order by i.id desc limit 0,10 [ RunTime:0.000711s ] [ 2024-02-07T12:52:14+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000306s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000368s ] INFO: [ app_begin ] --END-- [ RunTime:0.000398s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.006406s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%3B0036000A50484D50303920%" ) LIMIT 1 [ RunTime:0.000157s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%3B0036000A50484D50303920%" ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%3B0036000A50484D50303920%" order by i.id desc limit 0,10 [ RunTime:0.000846s ] [ 2024-02-07T12:52:27+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000317s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000580s ] INFO: [ app_begin ] --END-- [ RunTime:0.000638s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.006079s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%2F0044000550484D50303920%" ) LIMIT 1 [ RunTime:0.000166s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%2F0044000550484D50303920%" ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%2F0044000550484D50303920%" order by i.id desc limit 0,10 [ RunTime:0.000670s ] [ 2024-02-07T12:52:32+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000266s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000363s ] INFO: [ app_begin ] --END-- [ RunTime:0.000395s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.005146s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) LIMIT 1 [ RunTime:0.000181s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) order by i.id desc limit 0,10 [ RunTime:0.000523s ] [ 2024-02-07T12:52:34+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000263s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000346s ] INFO: [ app_begin ] --END-- [ RunTime:0.000377s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.008301s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) LIMIT 1 [ RunTime:0.000166s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) order by i.id desc limit 0,10 [ RunTime:0.000629s ] [ 2024-02-07T12:52:40+08:00 ] 61.132.54.35 /xmt/index.php/PointLog/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000300s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000352s ] INFO: [ app_begin ] --END-- [ RunTime:0.000388s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005836s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001240s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005473s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000585s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '411' and del=0 ) ORDER BY sort [ RunTime:0.000386s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000041s ] INFO: [ template_filter ] --END-- [ RunTime:0.000087s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.829672s ] INFO: [ view_parse ] --END-- [ RunTime:0.829719s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000752s ] INFO: [ view_filter ] --END-- [ RunTime:0.000788s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000907s ] INFO: [ app_end ] --END-- [ RunTime:0.000939s ] [ 2024-02-07T12:52:40+08:00 ] 61.132.54.35 /xmt/index.php/PointLog/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000261s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000360s ] INFO: [ app_begin ] --END-- [ RunTime:0.000390s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_point_log point_log LEFT JOIN xmt_product product ON point_log.gno = product.gno LEFT JOIN xmt_village_user village_user ON point_log.uno = village_user.uno WHERE ( point_log.del=0 ) LIMIT 1 [ RunTime:0.029566s ] SQL: SELECT point_log.id AS id,point_log.gno AS gno,point_log.postno AS postno,point_log.uno AS uno,point_log.point AS point,point_log.bpoint AS bpoint,point_log.apoint AS apoint,point_log.ctime AS ctime,point_log.utime AS utime,point_log.type AS type,point_log.del AS del,product.gname AS gname,village_user.name AS name FROM xmt_point_log point_log LEFT JOIN xmt_product product ON point_log.gno = product.gno LEFT JOIN xmt_village_user village_user ON point_log.uno = village_user.uno WHERE ( point_log.del=0 ) ORDER BY point_log.id desc LIMIT 0,10 [ RunTime:0.008376s ] [ 2024-02-07T12:52:46+08:00 ] 61.132.54.35 /xmt/index.php/ProductPOrder/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000336s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000399s ] INFO: [ app_begin ] --END-- [ RunTime:0.000434s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005596s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001291s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005476s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000601s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '410' and del=0 ) ORDER BY sort [ RunTime:0.000346s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000045s ] INFO: [ template_filter ] --END-- [ RunTime:0.000089s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.079092s ] INFO: [ view_parse ] --END-- [ RunTime:0.079144s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000301s ] INFO: [ view_filter ] --END-- [ RunTime:0.000327s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000485s ] INFO: [ app_end ] --END-- [ RunTime:0.000512s ] [ 2024-02-07T12:52:46+08:00 ] 61.132.54.35 /xmt/index.php/ProductPOrder/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000265s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000355s ] INFO: [ app_begin ] --END-- [ RunTime:0.000388s ] SQL: SHOW COLUMNS FROM `xmt_cart` [ RunTime:0.011811s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_cart` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.002952s ] SQL: SELECT * FROM `xmt_cart` WHERE ( del=0 ) ORDER BY id desc LIMIT 0,10 [ RunTime:0.001074s ] [ 2024-02-07T12:54:01+08:00 ] 61.132.54.35 /xmt/index.php/RepairRec/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000381s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000436s ] INFO: [ app_begin ] --END-- [ RunTime:0.000471s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.009615s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001149s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.004951s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000529s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '305' and del=0 ) ORDER BY sort [ RunTime:0.000365s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000102s ] INFO: [ template_filter ] --END-- [ RunTime:0.000145s ] NOTIC: [8] Undefined variable: providerList D:\code\xmt\#runtime\Cache\Home\a93d46b0cb4482654c3892d9bff25b14.php 第 59 行. INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.136150s ] INFO: [ view_parse ] --END-- [ RunTime:0.136191s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000262s ] INFO: [ view_filter ] --END-- [ RunTime:0.000288s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000564s ] INFO: [ app_end ] --END-- [ RunTime:0.000595s ] [ 2024-02-07T12:54:02+08:00 ] 61.132.54.35 /xmt/index.php/RepairRec/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000299s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000399s ] INFO: [ app_begin ] --END-- [ RunTime:0.000438s ] SQL: SHOW COLUMNS FROM `xmt_repair_log` [ RunTime:0.020646s ] SQL: SHOW COLUMNS FROM `xmt_fault_item` [ RunTime:0.043425s ] SQL: SHOW COLUMNS FROM `xmt_fault_reason` [ RunTime:0.027476s ] SQL: SHOW COLUMNS FROM `xmt_pdt` [ RunTime:0.025173s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006101s ] SQL: SHOW COLUMNS FROM `xmt_province` [ RunTime:0.004914s ] SQL: SHOW COLUMNS FROM `xmt_city` [ RunTime:0.005622s ] SQL: SHOW COLUMNS FROM `xmt_area` [ RunTime:0.007020s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.004648s ] SQL: SHOW COLUMNS FROM `xmt_repair_task` [ RunTime:0.008496s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_repair_log repair_log LEFT JOIN xmt_fault_item fault_item ON repair_log.itno = fault_item.itno and fault_item.del=0 and repair_log.del=0 LEFT JOIN xmt_fault_reason fault_reason ON repair_log.rsno = fault_reason.rsno and fault_reason.del=0 LEFT JOIN xmt_pdt pdt ON repair_log.eqno = pdt.imei and pdt.del=0 LEFT JOIN xmt_village village ON village.no = pdt.vno and village.del=0 LEFT JOIN xmt_province province ON village.pvc = province.sn and province.del=0 LEFT JOIN xmt_city city ON village.city = city.sn and city.del=0 LEFT JOIN xmt_area area ON village.area = area.sn and area.del=0 LEFT JOIN xmt_user user ON repair_log.updater = user.uno and user.del=0 LEFT JOIN xmt_repair_task repair_task ON repair_log.rpno = repair_task.rpno and repair_task.del=0 WHERE ( repair_log.del=0 ) LIMIT 1 [ RunTime:0.004541s ] SQL: SELECT repair_log.id AS id,repair_log.rpno AS rpno,repair_log.itno AS itno,repair_log.rsno AS rsno,repair_log.eqtype AS eqtype,repair_log.eqno AS eqno,repair_log.remark AS remark,repair_log.rpuser AS rpuser,repair_log.rptel AS rptel,repair_log.del AS del,repair_log.creater AS creater,repair_log.ctime AS ctime,repair_log.updater AS updater,repair_log.utime AS utime,fault_item.itname AS itname,fault_reason.rsname AS rsname,pdt.imei AS imei,village.name AS vname,province.name AS pname,city.name AS cname,area.name AS aname,user.name AS name,repair_task.tksts AS tksts FROM xmt_repair_log repair_log LEFT JOIN xmt_fault_item fault_item ON repair_log.itno = fault_item.itno and fault_item.del=0 and repair_log.del=0 LEFT JOIN xmt_fault_reason fault_reason ON repair_log.rsno = fault_reason.rsno and fault_reason.del=0 LEFT JOIN xmt_pdt pdt ON repair_log.eqno = pdt.imei and pdt.del=0 LEFT JOIN xmt_village village ON village.no = pdt.vno and village.del=0 LEFT JOIN xmt_province province ON village.pvc = province.sn and province.del=0 LEFT JOIN xmt_city city ON village.city = city.sn and city.del=0 LEFT JOIN xmt_area area ON village.area = area.sn and area.del=0 LEFT JOIN xmt_user user ON repair_log.updater = user.uno and user.del=0 LEFT JOIN xmt_repair_task repair_task ON repair_log.rpno = repair_task.rpno and repair_task.del=0 WHERE ( repair_log.del=0 ) ORDER BY repair_log.rpno desc LIMIT 0,10 [ RunTime:0.001213s ] [ 2024-02-07T12:54:02+08:00 ] 61.132.54.35 /xmt/index.php/RepairRec/searchDFBPrice.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.000344s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000487s ] INFO: [ app_begin ] --END-- [ RunTime:0.000547s ] [ 2024-02-07T12:54:05+08:00 ] 61.132.54.35 /xmt/index.php/FaultReason/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000274s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000345s ] INFO: [ app_begin ] --END-- [ RunTime:0.000376s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.006143s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001635s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.006779s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000695s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '308' and del=0 ) ORDER BY sort [ RunTime:0.000488s ] SQL: SHOW COLUMNS FROM `xmt_fault_item` [ RunTime:0.005684s ] SQL: SELECT * FROM `xmt_fault_item` WHERE `del` = 0 [ RunTime:0.000224s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000055s ] INFO: [ template_filter ] --END-- [ RunTime:0.000094s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.443975s ] INFO: [ view_parse ] --END-- [ RunTime:0.444046s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000458s ] INFO: [ view_filter ] --END-- [ RunTime:0.000485s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001047s ] INFO: [ app_end ] --END-- [ RunTime:0.001111s ] [ 2024-02-07T12:54:05+08:00 ] 61.132.54.35 /xmt/index.php/FaultReason/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000267s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000351s ] INFO: [ app_begin ] --END-- [ RunTime:0.000379s ] SQL: SHOW COLUMNS FROM `xmt_fault_reason` [ RunTime:0.006922s ] SQL: SHOW COLUMNS FROM `xmt_fault_item` [ RunTime:0.005899s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.005860s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_fault_reason fault_reason LEFT JOIN xmt_fault_item fault_item ON fault_reason.itno = fault_item.itno and fault_item.del=0 and fault_reason.del=0 JOIN xmt_user user ON fault_reason.updater = user.uno and user.del=0 WHERE ( fault_reason.del=0 ) LIMIT 1 [ RunTime:0.000518s ] SQL: SELECT fault_reason.id AS id,fault_reason.rsno AS rsno,fault_reason.recs AS recs,fault_reason.rsname AS rsname,fault_reason.del AS del,fault_reason.creater AS creater,fault_reason.ctime AS ctime,fault_reason.updater AS updater,fault_reason.utime AS utime,fault_item.itname AS itname,user.name AS name FROM xmt_fault_reason fault_reason LEFT JOIN xmt_fault_item fault_item ON fault_reason.itno = fault_item.itno and fault_item.del=0 and fault_reason.del=0 JOIN xmt_user user ON fault_reason.updater = user.uno and user.del=0 WHERE ( fault_reason.del=0 ) ORDER BY fault_reason.rsno ASC LIMIT 0,10 [ RunTime:0.000642s ] [ 2024-02-07T12:54:12+08:00 ] 61.132.54.35 /xmt/index.php/FaultTypeRate/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000012s ] INFO: [ app_init ] --END-- [ RunTime:0.000293s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000369s ] INFO: [ app_begin ] --END-- [ RunTime:0.000400s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.007828s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001283s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005390s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000660s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '309' and del=0 ) ORDER BY sort [ RunTime:0.000372s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000068s ] INFO: [ template_filter ] --END-- [ RunTime:0.000120s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.107376s ] INFO: [ view_parse ] --END-- [ RunTime:0.107425s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000237s ] INFO: [ view_filter ] --END-- [ RunTime:0.000262s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000425s ] INFO: [ app_end ] --END-- [ RunTime:0.000454s ] [ 2024-02-07T12:54:12+08:00 ] 61.132.54.35 /xmt/index.php/FaultTypeRate/equipTreeSearch?vname=&_=1707281651209 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000276s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000351s ] INFO: [ app_begin ] --END-- [ RunTime:0.000380s ] SQL: SHOW COLUMNS FROM `xmt_v_equip_tree` [ RunTime:0.006426s ] SQL: SELECT * FROM `xmt_v_equip_tree` WHERE ( 1=1 and no in (select bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) ) [ RunTime:0.044459s ] [ 2024-02-07T12:54:13+08:00 ] 61.132.54.35 /xmt/index.php/FaultTypeRate/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000305s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000449s ] INFO: [ app_begin ] --END-- [ RunTime:0.000481s ] SQL: SELECT a.itno, a.itname, count(b.rpno) AS num FROM xmt_fault_item a LEFT JOIN xmt_repair_log b on a.itno = b.itno AND b.del=0 LEFT JOIN xmt_village_user c on c.uno = b.creater AND c.del=0 LEFT JOIN xmt_village v ON v.`no` = c.vno where a.del=0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) GROUP BY a.itno [ RunTime:0.038235s ] [ 2024-02-07T12:54:13+08:00 ] 61.132.54.35 /xmt/index.php/FaultTypeRate/getChart INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000330s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000409s ] INFO: [ app_begin ] --END-- [ RunTime:0.000440s ] SQL: SELECT count(b.rpno) AS value, a.itname name FROM xmt_fault_item a LEFT JOIN xmt_repair_log b on a.itno = b.itno AND b.del=0 LEFT JOIN xmt_village_user c on c.uno = b.creater AND c.del=0 LEFT JOIN xmt_village v ON v.`no` = c.vno where a.del=0 and b.del = 0 and v.no in(select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) GROUP BY a.itno [ RunTime:0.040372s ] [ 2024-02-07T12:54:52+08:00 ] 61.132.54.35 /xmt/index.php/PdtInfo/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000273s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000375s ] INFO: [ app_begin ] --END-- [ RunTime:0.000416s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005758s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001238s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005268s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000577s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '201' and del=0 ) ORDER BY sort [ RunTime:0.000502s ] SQL: SHOW COLUMNS FROM `xmt_pdt_xh` [ RunTime:0.007403s ] SQL: SELECT * FROM `xmt_pdt_xh` WHERE `del` = 0 [ RunTime:0.000921s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.005338s ] SQL: SELECT * FROM `xmt_village` WHERE `del` = 0 [ RunTime:0.001632s ] SQL: SELECT category.cno, dict.dvalue FROM xmt_category category LEFT JOIN xmt_dict dict ON dict.dtype = 'TDTYPE' AND dict.dno=category.cno WHERE category.del =0 GROUP BY cno [ RunTime:0.000704s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000122s ] INFO: [ template_filter ] --END-- [ RunTime:0.000161s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.157951s ] INFO: [ view_parse ] --END-- [ RunTime:0.158001s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000330s ] INFO: [ view_filter ] --END-- [ RunTime:0.000358s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000498s ] INFO: [ app_end ] --END-- [ RunTime:0.000528s ] [ 2024-02-07T12:54:53+08:00 ] 61.132.54.35 /xmt/index.php/PdtInfo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000257s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000339s ] INFO: [ app_begin ] --END-- [ RunTime:0.000368s ] SQL: SHOW COLUMNS FROM `xmt_pdt` [ RunTime:0.006084s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.005693s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.005690s ] SQL: SHOW COLUMNS FROM `xmt_pdt_xh` [ RunTime:0.004649s ] SQL: SHOW COLUMNS FROM `xmt_city_weather` [ RunTime:0.007202s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_pdt pdt LEFT JOIN xmt_user user ON pdt.updater = user.uno and user.del=0 LEFT JOIN xmt_village village ON pdt.vno = village.no and village.del=0 LEFT JOIN xmt_pdt_xh pdt_xh ON pdt.pdtxh = pdt_xh.xhno and pdt_xh.del=0 and pdt.del=0 LEFT JOIN xmt_city_weather city_weather ON city_weather.cityId = pdt.weatherLocal WHERE ( pdt.del=0 ) LIMIT 1 [ RunTime:0.600420s ] SQL: SELECT pdt.id AS id,pdt.imei AS imei,pdt.deviceId AS deviceId,pdt.pdtxh AS pdtxh,pdt.pdtcno AS pdtcno,pdt.mcreate AS mcreate,pdt.screate AS screate,pdt.ncreate AS ncreate,pdt.vno AS vno,pdt.ests AS ests,pdt.sts AS sts,pdt.ip AS ip,pdt.port AS port,pdt.weatherLocal AS weatherLocal,pdt.col1 AS col1,pdt.col2 AS col2,pdt.col3 AS col3,pdt.col4 AS col4,pdt.col5 AS col5,pdt.col6 AS col6,pdt.col7 AS col7,pdt.col8 AS col8,pdt.del AS del,pdt.creater AS creater,pdt.ctime AS ctime,pdt.updater AS updater,pdt.utime AS utime,user.name AS name,village.name AS vname,pdt_xh.xhname AS xhname,city_weather.cityName AS weatherLocalName FROM xmt_pdt pdt LEFT JOIN xmt_user user ON pdt.updater = user.uno and user.del=0 LEFT JOIN xmt_village village ON pdt.vno = village.no and village.del=0 LEFT JOIN xmt_pdt_xh pdt_xh ON pdt.pdtxh = pdt_xh.xhno and pdt_xh.del=0 and pdt.del=0 LEFT JOIN xmt_city_weather city_weather ON city_weather.cityId = pdt.weatherLocal WHERE ( pdt.del=0 ) ORDER BY pdt.id ASC LIMIT 0,10 [ RunTime:0.289151s ] [ 2024-02-07T12:55:03+08:00 ] 61.132.54.35 /xmt/index.php/EquipWsd/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000271s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000351s ] INFO: [ app_begin ] --END-- [ RunTime:0.000382s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005578s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001157s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.004942s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000514s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '1002' and del=0 ) ORDER BY sort [ RunTime:0.000391s ] NOTIC: [2] Invalid argument supplied for foreach() D:\code\xmt\vis\Apps\Home\Service\CommonService.class.php 第 39 行. INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000058s ] INFO: [ template_filter ] --END-- [ RunTime:0.000096s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.470962s ] INFO: [ view_parse ] --END-- [ RunTime:0.471082s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000318s ] INFO: [ view_filter ] --END-- [ RunTime:0.000372s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000802s ] INFO: [ app_end ] --END-- [ RunTime:0.000852s ] [ 2024-02-07T12:55:07+08:00 ] 61.132.54.35 /xmt/index.php/EquipWsd/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000382s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000510s ] INFO: [ app_begin ] --END-- [ RunTime:0.000551s ] SQL: SHOW COLUMNS FROM `xmt_equip_wsd` [ RunTime:0.029829s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_equip_wsd` WHERE ( del = 0 ) LIMIT 1 [ RunTime:2.022274s ] SQL: SELECT * FROM `xmt_equip_wsd` WHERE ( del = 0 ) ORDER BY time desc LIMIT 0,10 [ RunTime:2.198070s ] [ 2024-02-07T12:55:19+08:00 ] 61.132.54.35 /xmt/index.php/ImageVideo/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000312s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000450s ] INFO: [ app_begin ] --END-- [ RunTime:0.000488s ] SQL: SHOW COLUMNS FROM `xmt_im` [ RunTime:0.005284s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%1E003E000A50484D50303920%" ) LIMIT 1 [ RunTime:0.000168s ] ERR: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa ' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM `xmt_im` WHERE ( where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%1E003E000A50484D50303920%" ) LIMIT 1 SQL: select i.* from xmt_im i left join xmt_pdt p on i.imei = p.imei and p.del = 0 where i.del=0 and p.vno in (select distinct bbb.vno from xmt_data_resource aaa left join xmt_pdt bbb on aaa.imei = bbb.imei where aaa.uno = 'US00000000000001' and bbb.del = 0) and p.imei like "%1E003E000A50484D50303920%" order by i.id desc limit 0,10 [ RunTime:0.000575s ] [ 2024-02-07T12:55:57+08:00 ] 61.132.54.35 /xmt/index.php/TradeError/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000016s ] INFO: [ app_init ] --END-- [ RunTime:0.002375s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000823s ] INFO: [ app_begin ] --END-- [ RunTime:0.000875s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.006740s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001310s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005441s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000600s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '1006' and del=0 ) ORDER BY sort [ RunTime:0.000388s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000049s ] INFO: [ template_filter ] --END-- [ RunTime:0.000093s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.229970s ] INFO: [ view_parse ] --END-- [ RunTime:0.230021s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000829s ] INFO: [ view_filter ] --END-- [ RunTime:0.000876s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000894s ] INFO: [ app_end ] --END-- [ RunTime:0.000924s ] [ 2024-02-07T12:55:58+08:00 ] 61.132.54.35 /xmt/index.php/TradeError/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000269s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000404s ] INFO: [ app_begin ] --END-- [ RunTime:0.000435s ] SQL: select FROM_UNIXTIME(w.time) time,w.id,w.imei,w.gno,w.gname,w.price,w.num,w.del, w.pay_amn,w.col,w.trade_no,w.pay_way,w.status,w.average_current, w.peak_current,w.type from xmt_trade_error w where 1=1 and w.imei in (select imei from xmt_data_resource where uno ='US00000000000001') [ RunTime:0.023706s ] SQL: select FROM_UNIXTIME(w.time) time,w.id,w.imei,w.gno,w.gname,w.price,w.num,w.del, w.pay_amn,w.col,w.trade_no,w.pay_way,w.status,w.average_current, w.peak_current,w.type from xmt_trade_error w where 1=1 and w.imei in (select imei from xmt_data_resource where uno ='US00000000000001') order by w.del asc,w.time desc limit 0,10 [ RunTime:0.001316s ] [ 2024-02-07T12:59:16+08:00 ] 61.132.54.35 /xmt/index.php/NewsDetail/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.001359s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000884s ] INFO: [ app_begin ] --END-- [ RunTime:0.000929s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.008151s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001205s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005018s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000575s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '702' and del=0 ) ORDER BY sort [ RunTime:0.000408s ] SQL: SHOW COLUMNS FROM `xmt_new_clc` [ RunTime:0.008478s ] SQL: SELECT * FROM `xmt_new_clc` WHERE `del` = 0 [ RunTime:0.001166s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000114s ] INFO: [ template_filter ] --END-- [ RunTime:0.000162s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.265792s ] INFO: [ view_parse ] --END-- [ RunTime:0.265847s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000923s ] INFO: [ view_filter ] --END-- [ RunTime:0.000962s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.002261s ] INFO: [ app_end ] --END-- [ RunTime:0.002317s ] [ 2024-02-07T12:59:16+08:00 ] 61.132.54.35 /xmt/index.php/NewsDetail/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000320s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000447s ] INFO: [ app_begin ] --END-- [ RunTime:0.000480s ] SQL: SHOW COLUMNS FROM `xmt_new_detail` [ RunTime:0.007604s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.005242s ] SQL: SHOW COLUMNS FROM `xmt_new_clc` [ RunTime:0.004754s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_new_detail new_detail LEFT JOIN xmt_user user ON new_detail.updater = user.uno and user.del=0 LEFT JOIN xmt_new_clc new_clc ON new_detail.cno = new_clc.nno and new_clc.del=0 and new_detail.del=0 WHERE ( new_detail.del=0 ) LIMIT 1 [ RunTime:0.001725s ] NOTIC: [8] Undefined variable: order D:\code\xmt\vis\Apps\Home\Service\NewsDetailService.class.php 第 39 行. SQL: SELECT new_detail.id AS id,new_detail.ndname AS ndname,new_detail.cno AS cno,new_detail.txt AS txt,new_detail.imgsrc AS imgsrc,new_detail.del AS del,new_detail.creater AS creater,new_detail.ctime AS ctime,new_detail.updater AS updater,new_detail.utime AS utime,user.name AS name,new_clc.nname AS nname FROM xmt_new_detail new_detail LEFT JOIN xmt_user user ON new_detail.updater = user.uno and user.del=0 LEFT JOIN xmt_new_clc new_clc ON new_detail.cno = new_clc.nno and new_clc.del=0 and new_detail.del=0 WHERE ( new_detail.del=0 ) LIMIT 0,10 [ RunTime:0.000444s ] [ 2024-02-07T12:59:33+08:00 ] 61.132.54.35 /xmt/index.php/NewsType/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.000350s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000480s ] INFO: [ app_begin ] --END-- [ RunTime:0.000516s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005639s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001234s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.007595s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000581s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '701' and del=0 ) ORDER BY sort [ RunTime:0.000406s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000055s ] INFO: [ template_filter ] --END-- [ RunTime:0.000098s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.077266s ] INFO: [ view_parse ] --END-- [ RunTime:0.077315s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000313s ] INFO: [ view_filter ] --END-- [ RunTime:0.000339s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000500s ] INFO: [ app_end ] --END-- [ RunTime:0.000528s ] [ 2024-02-07T12:59:33+08:00 ] 61.132.54.35 /xmt/index.php/NewsType/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000010s ] INFO: [ app_init ] --END-- [ RunTime:0.000375s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000461s ] INFO: [ app_begin ] --END-- [ RunTime:0.000493s ] SQL: SHOW COLUMNS FROM `xmt_new_clc` [ RunTime:0.005773s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.005495s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_new_clc new_clc LEFT JOIN xmt_user user ON new_clc.updater = user.uno and user.del=0 and new_clc.del=0 WHERE ( new_clc.del=0 ) LIMIT 1 [ RunTime:0.000374s ] SQL: SELECT new_clc.id AS id,new_clc.nname AS nname,new_clc.nno AS nno,new_clc.del AS del,new_clc.creater AS creater,new_clc.ctime AS ctime,new_clc.updater AS updater,new_clc.utime AS utime,user.name AS name FROM xmt_new_clc new_clc LEFT JOIN xmt_user user ON new_clc.updater = user.uno and user.del=0 and new_clc.del=0 WHERE ( new_clc.del=0 ) ORDER BY new_clc.id ASC LIMIT 0,10 [ RunTime:0.000957s ] [ 2024-02-07T13:00:58+08:00 ] 61.132.54.35 /xmt/index.php/user/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000016s ] INFO: [ app_init ] --END-- [ RunTime:0.001372s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000914s ] INFO: [ app_begin ] --END-- [ RunTime:0.000962s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005480s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001249s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.004898s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000521s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '112' and del=0 ) ORDER BY sort [ RunTime:0.000347s ] SQL: SHOW COLUMNS FROM `xmt_province` [ RunTime:0.004236s ] SQL: SELECT `sn`,`name` FROM `xmt_province` WHERE `del` = 0 ORDER BY `id` asc [ RunTime:0.000240s ] SQL: SHOW COLUMNS FROM `xmt_role` [ RunTime:0.004256s ] SQL: SELECT `name`,`rno` FROM `xmt_role` WHERE `del` = 0 ORDER BY id [ RunTime:0.000221s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000161s ] INFO: [ template_filter ] --END-- [ RunTime:0.000204s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.116255s ] INFO: [ view_parse ] --END-- [ RunTime:0.116302s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000702s ] INFO: [ view_filter ] --END-- [ RunTime:0.000736s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000802s ] INFO: [ app_end ] --END-- [ RunTime:0.000835s ] [ 2024-02-07T13:00:59+08:00 ] 61.132.54.35 /xmt/index.php/User/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000012s ] INFO: [ app_init ] --END-- [ RunTime:0.000527s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000382s ] INFO: [ app_begin ] --END-- [ RunTime:0.000418s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.007303s ] SQL: SHOW COLUMNS FROM `xmt_village` [ RunTime:0.006734s ] SQL: SHOW COLUMNS FROM `xmt_role` [ RunTime:0.006190s ] SQL: SELECT COUNT(*) AS tp_count FROM xmt_user user LEFT JOIN xmt_village village ON user.sno = village.no and village.del=0 LEFT JOIN xmt_role role ON role.rno = user.rno and role.del=0 LEFT JOIN xmt_user user2 ON user.updater = user2.uno and user2.del=0 WHERE ( user.del=0 ) LIMIT 1 [ RunTime:0.000731s ] SQL: SELECT user.id AS id,user.name AS name,user.pwd AS pwd,user.rno AS rno,user.openid AS openid,user.tel AS tel,user.uno AS uno,user.tx AS tx,user.cno AS cno,user.nc AS nc,user.spno AS spno,user.del AS del,user.creater AS creater,user.ctime AS ctime,user.updater AS updater,user.utime AS utime,user.user_name AS user_name,user.sno AS sno,user.sts AS sts,village.name AS vname,role.name AS rname,user2.name AS updater_name FROM xmt_user user LEFT JOIN xmt_village village ON user.sno = village.no and village.del=0 LEFT JOIN xmt_role role ON role.rno = user.rno and role.del=0 LEFT JOIN xmt_user user2 ON user.updater = user2.uno and user2.del=0 WHERE ( user.del=0 ) ORDER BY user.utime Desc LIMIT 0,10 [ RunTime:0.001241s ] [ 2024-02-07T13:01:07+08:00 ] 61.132.54.35 /xmt/index.php/role/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000259s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000442s ] INFO: [ app_begin ] --END-- [ RunTime:0.000493s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.005987s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001293s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005590s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000614s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '113' and del=0 ) ORDER BY sort [ RunTime:0.000352s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000071s ] INFO: [ template_filter ] --END-- [ RunTime:0.000111s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.086207s ] INFO: [ view_parse ] --END-- [ RunTime:0.086265s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000235s ] INFO: [ view_filter ] --END-- [ RunTime:0.000259s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000410s ] INFO: [ app_end ] --END-- [ RunTime:0.000437s ] [ 2024-02-07T13:01:07+08:00 ] 61.132.54.35 /xmt/index.php/Role/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000284s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000376s ] INFO: [ app_begin ] --END-- [ RunTime:0.000414s ] SQL: SHOW COLUMNS FROM `xmt_role` [ RunTime:0.005899s ] SQL: SELECT COUNT(*) AS tp_count FROM `xmt_role` WHERE ( del=0 ) LIMIT 1 [ RunTime:0.000264s ] SQL: SELECT * FROM `xmt_role` WHERE ( del=0 ) ORDER BY id desc LIMIT 0,15 [ RunTime:0.000229s ] [ 2024-02-07T13:01:35+08:00 ] 61.132.54.35 /xmt/index.php/CleanPlan/index.html?appid= INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000019s ] INFO: [ app_init ] --END-- [ RunTime:0.001584s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000913s ] INFO: [ app_begin ] --END-- [ RunTime:0.000961s ] SQL: SHOW COLUMNS FROM `xmt_role_resource` [ RunTime:0.006336s ] SQL: SELECT * FROM `xmt_role_resource` WHERE `rno` = 'RE00000000000001' [ RunTime:0.001406s ] SQL: SHOW COLUMNS FROM `xmt_resource` [ RunTime:0.005288s ] SQL: SELECT * FROM `xmt_resource` WHERE `restype` = 1 AND `del` = 0 [ RunTime:0.000605s ] SQL: SELECT * FROM `xmt_resource` WHERE ( pid = '605' and del=0 ) ORDER BY sort [ RunTime:0.000388s ] SQL: SHOW COLUMNS FROM `xmt_dict` [ RunTime:0.005198s ] SQL: SELECT `dno`,`dvalue` FROM `xmt_dict` WHERE `del` = 0 AND `dtype` = 'CARTYPE' ORDER BY `dno` asc [ RunTime:0.000315s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000087s ] INFO: [ template_filter ] --END-- [ RunTime:0.000128s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.119954s ] INFO: [ view_parse ] --END-- [ RunTime:0.120005s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000908s ] INFO: [ view_filter ] --END-- [ RunTime:0.000938s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001022s ] INFO: [ app_end ] --END-- [ RunTime:0.001069s ] [ 2024-02-07T13:01:36+08:00 ] 61.132.54.35 /xmt/index.php/CleanPlan/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000015s ] INFO: [ app_init ] --END-- [ RunTime:0.000497s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000596s ] INFO: [ app_begin ] --END-- [ RunTime:0.000640s ] SQL: SELECT a.id, a.planno, a.qyno1, b.qyname AS qyname, c.user_name AS qyyg, a.qyway, a.qygs, a.qysj, f.dvalue AS qycar, a.qycarno, a.utime, d.`name` AS updater_name, e.`name` AS vname FROM xmt_qy_plan a LEFT JOIN xmt_qys b ON a.qyno1 = b.qyno LEFT JOIN xmt_user c ON a.qyno2 = c.uno LEFT JOIN xmt_user d ON a.updater = d.uno LEFT JOIN xmt_village e ON a.vno = e.no LEFT JOIN xmt_dict f ON a.qycar = f.dno and f.dtype='CARTYPE' and f.del=0 WHERE a.del=0 ORDER BY a.qysj [ RunTime:0.048785s ] [ 2024-02-07T13:01:36+08:00 ] 61.132.54.35 /xmt/index.php/CleanPlan/getAreaSn?_=1707282094221 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000326s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000523s ] INFO: [ app_begin ] --END-- [ RunTime:0.000570s ] SQL: SHOW COLUMNS FROM `xmt_village_user` [ RunTime:0.006204s ] SQL: SELECT `area` FROM `xmt_village_user` WHERE `uno` = 'US00000000000001' LIMIT 1 [ RunTime:0.001146s ] [ 2024-02-07T13:01:36+08:00 ] 61.132.54.35 /xmt/index.php/CleanPlan/qysTreeSearch?qyname=&_=1707282094222 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000259s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000346s ] INFO: [ app_begin ] --END-- [ RunTime:0.000374s ] SQL: SHOW COLUMNS FROM `xmt_qys` [ RunTime:0.006037s ] SQL: SELECT * FROM `xmt_qys` WHERE ( del=0 ) [ RunTime:0.000347s ] [ 2024-02-07T13:01:41+08:00 ] 61.132.54.35 /xmt/index.php/CleanPlan/search.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000013s ] INFO: [ app_init ] --END-- [ RunTime:0.000340s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000408s ] INFO: [ app_begin ] --END-- [ RunTime:0.000446s ] SQL: SHOW COLUMNS FROM `xmt_qys` [ RunTime:0.006781s ] SQL: SELECT `type` FROM `xmt_qys` WHERE ( qyno='PC00000084' ) LIMIT 1 [ RunTime:0.000247s ] SQL: SELECT a.id, a.planno, a.qyno1, b.qyname AS qyname, c.user_name AS qyyg, a.qyway, a.qygs, a.qysj, f.dvalue AS qycar, a.qycarno, a.utime, d.`name` AS updater_name, e.`name` AS vname FROM xmt_qy_plan a LEFT JOIN xmt_qys b ON a.qyno1 = b.qyno LEFT JOIN xmt_user c ON a.qyno2 = c.uno LEFT JOIN xmt_user d ON a.updater = d.uno LEFT JOIN xmt_village e ON a.vno = e.no LEFT JOIN xmt_dict f ON a.qycar = f.dno and f.dtype='CARTYPE' and f.del=0 WHERE a.del=0 and a.qyno1 like "%PC00000084%" ORDER BY a.qysj [ RunTime:0.000499s ] [ 2024-02-07T13:01:41+08:00 ] 61.132.54.35 /xmt/index.php/CleanPlan/getVillage?qyno=PC00000084&_=1707282094223 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000313s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000419s ] INFO: [ app_begin ] --END-- [ RunTime:0.000450s ] SQL: SELECT b.`no`, b.`name` FROM xmt_qy_range a LEFT JOIN xmt_village b ON a.vno = b.`no` WHERE a.del = 0 and a.qyno1 ="PC00000084" [ RunTime:0.018723s ] [ 2024-02-07T13:01:41+08:00 ] 61.132.54.35 /xmt/index.php/CleanPlan/getqyyg?qyno=PC00000084&_=1707282094224 INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ] INFO: [ app_init ] --END-- [ RunTime:0.000326s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000558s ] INFO: [ app_begin ] --END-- [ RunTime:0.000593s ] SQL: SHOW COLUMNS FROM `xmt_user` [ RunTime:0.005986s ] SQL: SELECT `uno`,`user_name` FROM `xmt_user` WHERE `del` = 0 AND `rno` = 'RE00000019' AND `qyno` = 'PC00000084' ORDER BY `id` asc [ RunTime:0.000312s ] [ 2024-02-07T13:01:58+08:00 ] 61.132.54.35 /xmt/index.php/Login/logout.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000008s ] INFO: [ app_init ] --END-- [ RunTime:0.000263s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000346s ] INFO: [ app_begin ] --END-- [ RunTime:0.000378s ] [ 2024-02-07T13:01:58+08:00 ] 61.132.54.35 /xmt/index.php/Login/login.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000009s ] INFO: [ app_init ] --END-- [ RunTime:0.000263s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000360s ] INFO: [ app_begin ] --END-- [ RunTime:0.000395s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000033s ] INFO: [ template_filter ] --END-- [ RunTime:0.000065s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.007878s ] INFO: [ view_parse ] --END-- [ RunTime:0.007911s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000276s ] INFO: [ view_filter ] --END-- [ RunTime:0.000299s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000443s ] INFO: [ app_end ] --END-- [ RunTime:0.000468s ] [ 2024-02-07T15:55:10+08:00 ] 144.76.88.54 /xmt/index.php/Login/login.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000023s ] INFO: [ app_init ] --END-- [ RunTime:0.004899s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.521481s ] INFO: [ app_begin ] --END-- [ RunTime:0.521598s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000036s ] INFO: [ template_filter ] --END-- [ RunTime:0.000087s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.202296s ] INFO: [ view_parse ] --END-- [ RunTime:0.202366s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.003288s ] INFO: [ view_filter ] --END-- [ RunTime:0.003324s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001935s ] INFO: [ app_end ] --END-- [ RunTime:0.001964s ] [ 2024-02-07T19:45:34+08:00 ] 207.46.13.141 /xmt/index.php/Login/login.html INFO: [ app_init ] --START-- INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000023s ] INFO: [ app_init ] --END-- [ RunTime:0.024696s ] INFO: [ app_begin ] --START-- INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.047987s ] INFO: [ app_begin ] --END-- [ RunTime:0.048060s ] INFO: [ view_parse ] --START-- INFO: [ template_filter ] --START-- INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000036s ] INFO: [ template_filter ] --END-- [ RunTime:0.000088s ] INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.843062s ] INFO: [ view_parse ] --END-- [ RunTime:0.843126s ] INFO: [ view_filter ] --START-- INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.023308s ] INFO: [ view_filter ] --END-- [ RunTime:0.023364s ] INFO: [ app_end ] --START-- INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.022860s ] INFO: [ app_end ] --END-- [ RunTime:0.022956s ]