[ 2018-09-13T09:34:56+08:00 ] 127.0.0.1 /
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000000s ]
INFO: [ app_init ] --END-- [ RunTime:0.001000s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.000000s ]
INFO: [ app_begin ] --END-- [ RunTime:0.000000s ]
SQL: SHOW COLUMNS FROM `jjrxt_jcpz` [ RunTime:0.0040s ]
SQL: SELECT * FROM `jjrxt_jcpz` WHERE `id` = 1 LIMIT 1   [ RunTime:0.0000s ]
SQL: SHOW COLUMNS FROM `jjrxt_role_user` [ RunTime:0.0040s ]
SQL: SELECT `role_id` FROM `jjrxt_role_user` WHERE `user_id` = '1' LIMIT 1   [ RunTime:0.0010s ]
SQL: select a.* from  
            (select * from jjrxt_menu where status=1 ) as a , 
            (select * from jjrxt_access where role_id = '1') as b where a.node_id=b.node_id  ORDER BY a.listorder ASC [ RunTime:0.0070s ]
SQL: SHOW COLUMNS FROM `jjrxt_menu` [ RunTime:0.0030s ]
SQL: SELECT * FROM `jjrxt_menu` WHERE `type` <> 2 AND `status` = 1  [ RunTime:0.0000s ]
SQL: SHOW COLUMNS FROM `jjrxt_menu` [ RunTime:0.0040s ]
SQL: SELECT * FROM `jjrxt_menu` WHERE `status` = 1 ORDER BY listorder asc  [ RunTime:0.0000s ]
NOTIC: [2] Missing argument 2 for Org\Util\Tree::get_tree_array(), called in D:\phpStudy\PHPTutorial\WWWXFMF\Application\Admin\Controller\IndexController.class.php on line 54 and defined D:\phpStudy\PHPTutorial\WWWXFMF\ThinkPHP\Library\Org\Util\Tree.class.php 第 148 行.
SQL: SHOW COLUMNS FROM `jjrxt_yonghu` [ RunTime:0.0050s ]
SQL: SELECT * FROM `jjrxt_yonghu` WHERE ( id=1 ) LIMIT 1   [ RunTime:0.0000s ]
INFO: [ view_parse ] --START--
INFO: [ template_filter ] --START--
INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000000s ]
INFO: [ template_filter ] --END-- [ RunTime:0.000000s ]
INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.013000s ]
INFO: [ view_parse ] --END-- [ RunTime:0.013000s ]
INFO: [ view_filter ] --START--
INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.000000s ]
INFO: Run Behavior\TokenBuildBehavior [ RunTime:0.001001s ]
INFO: [ view_filter ] --END-- [ RunTime:0.001001s ]
INFO: [ app_end ] --START--
INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000000s ]
INFO: [ app_end ] --END-- [ RunTime:0.000000s ]

[ 2018-09-13T09:34:57+08:00 ] 127.0.0.1 /index.php/index/welcome.html
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000000s ]
INFO: [ app_init ] --END-- [ RunTime:0.001000s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001000s ]
INFO: [ app_begin ] --END-- [ RunTime:0.001000s ]
SQL: SHOW COLUMNS FROM `jjrxt_jcpz` [ RunTime:0.0050s ]
SQL: SELECT * FROM `jjrxt_jcpz` WHERE `id` = 1 LIMIT 1   [ RunTime:0.0000s ]
SQL: SHOW COLUMNS FROM `jjrxt_yonghu` [ RunTime:0.0030s ]
SQL: SELECT `id`,`ygmingcheng`,`dianhua`,`touxiang`,`ygbianhao` FROM `jjrxt_yonghu` WHERE `id` = 1 LIMIT 1   [ RunTime:0.0000s ]
SQL: SHOW COLUMNS FROM `jjrxt_role` [ RunTime:0.0030s ]
SQL: SELECT `remark` FROM `jjrxt_role` WHERE `id` = null LIMIT 1   [ RunTime:0.0000s ]
SQL: SHOW COLUMNS FROM `jjrxt_yonghu` [ RunTime:0.0040s ]
SQL: SELECT `bumen` FROM `jjrxt_yonghu` WHERE `id` = 1 LIMIT 1   [ RunTime:0.0000s ]
SQL: SHOW COLUMNS FROM `jjrxt_bumen` [ RunTime:0.0040s ]
SQL: SELECT `bmming` FROM `jjrxt_bumen` WHERE `id` = 1 LIMIT 1   [ RunTime:0.0000s ]
SQL: SELECT * FROM `jjrxt_jcpz` WHERE ( gongsiid=10000 ) LIMIT 1   [ RunTime:0.0000s ]
SQL: SHOW COLUMNS FROM `jjrxt_kydaikan` [ RunTime:0.0030s ]
SQL: select id,khxingming,xqbianhao,a.count from jjrxt_keyuan b join (select count(*) as count,kyid,dkuid,dkshijian from jjrxt_kydaikan group by kyid) a on a.kyid=b.id where a.dkuid=1 and a.dkshijian>1536197697 and a.dkshijian<1536802497 order by a.count DESC limit 6 [ RunTime:0.0000s ]
SQL: SELECT distinct syky.lry AS llry,byky.lry AS nlry,
        syky.bm, syky.kysl AS lky
        , ifnull(byky.kysl, 0) AS nky
        , round((ifnull(byky.kysl, 0) - ifnull(syky.kysl,0)) / ifnull(syky.kysl,1) * 100, 2) AS tbzz
        FROM (
            SELECT month(FROM_UNIXTIME(ky.lurusj)) AS lry, yh.bumen AS bm
            , COUNT(*) AS kysl
            FROM jjrxt_keyuan ky, jjrxt_yonghu yh
            WHERE ky.weihurenid = yh.id
            AND FROM_UNIXTIME(ky.lurusj) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
            AND FROM_UNIXTIME(ky.lurusj) <= date_sub(curdate(), INTERVAL 1 MONTH)
            GROUP BY lry, yh.bumen
        ) syky
        LEFT JOIN (
            SELECT month(FROM_UNIXTIME(ky.lurusj)) AS lry, yh.bumen AS bm
            , COUNT(*) AS kysl
            FROM jjrxt_keyuan ky, jjrxt_yonghu yh
            WHERE ky.weihurenid = yh.id
            AND FROM_UNIXTIME(ky.lurusj) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
            GROUP BY lry, yh.bumen
        ) byky
        ON syky.bm = byky.bm
        union
        SELECT distinct syky.lry AS llry,byky.lry AS nlry,
        byky.bm, syky.kysl AS lky
        , ifnull(byky.kysl, 0) AS nky
        , round((ifnull(byky.kysl, 0) - ifnull(syky.kysl,0)) / ifnull(syky.kysl,1) * 100, 2) AS tbzz
        FROM (
            SELECT month(FROM_UNIXTIME(ky.lurusj)) AS lry, yh.bumen AS bm
            , COUNT(*) AS kysl
            FROM jjrxt_keyuan ky, jjrxt_yonghu yh
            WHERE ky.weihurenid = yh.id
            AND FROM_UNIXTIME(ky.lurusj) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
            AND FROM_UNIXTIME(ky.lurusj) <= date_sub(curdate(), INTERVAL 1 MONTH)
            GROUP BY lry, yh.bumen
        ) syky
        RIGHT JOIN (
            SELECT month(FROM_UNIXTIME(ky.lurusj)) AS lry, yh.bumen AS bm
            , COUNT(*) AS kysl
            FROM jjrxt_keyuan ky, jjrxt_yonghu yh
            WHERE ky.weihurenid = yh.id
            AND FROM_UNIXTIME(ky.lurusj) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
            GROUP BY lry, yh.bumen
        ) byky
        ON syky.bm = byky.bm
        ORDER BY nky DESC [ RunTime:0.0010s ]
SQL: SELECT sydk.bm,sydk.dkcs ldk,ifnull(bydk.dkcs,0) ndk, round((ifnull(bydk.dkcs,0)-ifnull(sydk.dkcs,0))/ifnull(sydk.dkcs,1)*100,2) tbzz
        FROM (
            SELECT month(FROM_UNIXTIME(kydk.dkshijian)) AS dksj, yh.bumen AS bm
            , COUNT(*) AS dkcs
            FROM jjrxt_kydaikan kydk, jjrxt_yonghu yh
            WHERE kydk.dkuid = yh.id
            AND FROM_UNIXTIME(kydk.dkshijian) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
            AND FROM_UNIXTIME(kydk.dkshijian) <= date_sub(curdate(), INTERVAL 1 MONTH)
            GROUP BY dksj, yh.bumen
        ) sydk
        LEFT JOIN (
            SELECT month(FROM_UNIXTIME(kydk.dkshijian)) AS dksj, yh.bumen AS bm
            , COUNT(*) AS dkcs
            FROM jjrxt_kydaikan kydk, jjrxt_yonghu yh
            WHERE kydk.dkuid = yh.id
            AND FROM_UNIXTIME(kydk.dkshijian) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
            GROUP BY dksj, yh.bumen
        ) bydk
        ON sydk.bm=bydk.bm 
        union
        SELECT sydk.bm,sydk.dkcs ldk,ifnull(bydk.dkcs,0) ndk, round((ifnull(bydk.dkcs,0)-ifnull(sydk.dkcs,0))/ifnull(sydk.dkcs,1)*100,2) tbzz
        FROM (
            SELECT month(FROM_UNIXTIME(kydk.dkshijian)) AS dksj, yh.bumen AS bm
            , COUNT(*) AS dkcs
            FROM jjrxt_kydaikan kydk, jjrxt_yonghu yh
            WHERE kydk.dkuid = yh.id
            AND FROM_UNIXTIME(kydk.dkshijian) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
            AND FROM_UNIXTIME(kydk.dkshijian) <= date_sub(curdate(), INTERVAL 1 MONTH)
            GROUP BY dksj, yh.bumen
        ) sydk
        RIGHT JOIN (
            SELECT month(FROM_UNIXTIME(kydk.dkshijian)) AS dksj, yh.bumen AS bm
            , COUNT(*) AS dkcs
            FROM jjrxt_kydaikan kydk, jjrxt_yonghu yh
            WHERE kydk.dkuid = yh.id
            AND FROM_UNIXTIME(kydk.dkshijian) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
            GROUP BY dksj, yh.bumen
        ) bydk
        ON sydk.bm=bydk.bm 
        ORDER BY ndk DESC [ RunTime:0.0010s ]
SQL: SELECT kyyhtj.bm, kyyhtj.uid, kyyhtj.ygmingcheng
        , ifnull(kyyhtj.lky, 0) AS lky
        , ifnull(kyyhtj.nky, 0) AS nky
        , round((ifnull(kyyhtj.nky, 0) - ifnull(kyyhtj.lky, 0)) / ifnull(kyyhtj.lky, 1) * 100, 2) AS kytbzj
        FROM (
            SELECT byky.bm, byky.uid, byky.ygmingcheng, syky.kysl AS lky, byky.kysl AS nky
            FROM (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id  AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
                GROUP BY yh.id, yh.bumen
            ) byky
            LEFT JOIN (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
                AND FROM_UNIXTIME(ky.lurusj) <= date_sub(curdate(), INTERVAL 1 MONTH)
                GROUP BY yh.id, yh.bumen
            ) syky
            ON byky.uid = syky.uid
            AND byky.bm = syky.bm
            UNION
            SELECT syky.bm, syky.uid, syky.ygmingcheng, syky.kysl AS lky, byky.kysl AS nky
            FROM (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
                GROUP BY yh.id, yh.bumen
            ) byky
            RIGHT JOIN (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
                AND FROM_UNIXTIME(ky.lurusj) <= date_sub(curdate(), INTERVAL 1 MONTH)
                GROUP BY yh.id, yh.bumen
            ) syky
            ON byky.uid = syky.uid
            AND byky.bm = syky.bm
        ) kyyhtj 
        UNION
        SELECT kyyhtj.bm, kyyhtj.uid, kyyhtj.ygmingcheng
        , ifnull(kyyhtj.lky, 0) AS lky
        , ifnull(kyyhtj.nky, 0) AS nky
        , round((ifnull(kyyhtj.nky, 0) - ifnull(kyyhtj.lky, 0)) / ifnull(kyyhtj.lky, 1) * 100, 2) AS kytbzj
        FROM (
            SELECT byky.bm, byky.uid, byky.ygmingcheng, syky.kysl AS lky, byky.kysl AS nky
            FROM (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
                GROUP BY yh.id, yh.bumen
            ) byky
            LEFT JOIN (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
                AND FROM_UNIXTIME(ky.lurusj) <= date_sub(curdate(), INTERVAL 1 MONTH)
                GROUP BY yh.id, yh.bumen
            ) syky
            ON byky.uid = syky.uid
            AND byky.bm = syky.bm
            UNION
            SELECT syky.bm, syky.uid, syky.ygmingcheng, syky.kysl AS lky, byky.kysl AS nky
            FROM (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(curdate(), INTERVAL -day(curdate()) + 1 DAY)
                GROUP BY yh.id, yh.bumen
            ) byky
            RIGHT JOIN (
                SELECT yh.bumen AS bm, yh.id AS uid, yh.ygmingcheng, COUNT(*) AS kysl
                FROM jjrxt_keyuan ky, jjrxt_yonghu yh
                WHERE ky.weihurenid = yh.id AND yh.bumen=1
                AND FROM_UNIXTIME(ky.lurusj) >= date_add(date_sub(curdate(), INTERVAL 1 MONTH), INTERVAL -day(curdate()) + 1 DAY)
                AND FROM_UNIXTIME(ky.lurusj) <= date_sub(curdate(), INTERVAL 1 MONTH)
                GROUP BY yh.id, yh.bumen
            ) syky
            ON byky.uid = syky.uid
            AND byky.bm = syky.bm
        ) kyyhtj order by kytbzj desc limit 6 [ RunTime:0.0020s ]
INFO: [ view_parse ] --START--
INFO: [ template_filter ] --START--
INFO: Run Behavior\ContentReplaceBehavior [ RunTime:0.000000s ]
INFO: [ template_filter ] --END-- [ RunTime:0.000000s ]
NOTIC: [8] Undefined index: bumen D:\phpStudy\PHPTutorial\WWWXFMF\Application\Runtime\Cache\Admin\69fa43b310489e974c292babf8eca7e7.php 第 208 行.
SQL: SELECT * FROM `jjrxt_bumen` WHERE `id` = null LIMIT 1   [ RunTime:0.0000s ]
INFO: Run Behavior\ParseTemplateBehavior [ RunTime:0.011000s ]
INFO: [ view_parse ] --END-- [ RunTime:0.011000s ]
INFO: [ view_filter ] --START--
INFO: Run Behavior\WriteHtmlCacheBehavior [ RunTime:0.001000s ]
INFO: Run Behavior\TokenBuildBehavior [ RunTime:0.001001s ]
INFO: [ view_filter ] --END-- [ RunTime:0.002001s ]
INFO: [ app_end ] --START--
INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.001000s ]
INFO: [ app_end ] --END-- [ RunTime:0.001000s ]

[ 2018-09-13T09:34:58+08:00 ] 127.0.0.1 /index.php/index/xiaoxi.html
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000000s ]
INFO: [ app_init ] --END-- [ RunTime:0.001000s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001000s ]
INFO: [ app_begin ] --END-- [ RunTime:0.001000s ]
SQL: SHOW COLUMNS FROM `jjrxt_jcpz` [ RunTime:0.0030s ]
SQL: SELECT * FROM `jjrxt_jcpz` WHERE `id` = 1 LIMIT 1   [ RunTime:0.0010s ]
SQL: select count(*) FROM jjrxt_kytixing where gongsiid=10000 and txuid=1 and txshijian<1536802498 and isyidu=0 [ RunTime:0.0000s ]
SQL: select count(*) FROM jjrxt_fjtixing where gongsiid=10000 and txuid=1 and txshijian<1536802498 and isyidu=0 [ RunTime:0.0000s ]
NOTIC: [8] Undefined variable: sh_count2 D:\phpStudy\PHPTutorial\WWWXFMF\Application\Admin\Controller\IndexController.class.php 第 89 行.
NOTIC: [8] Undefined variable: sh_count1 D:\phpStudy\PHPTutorial\WWWXFMF\Application\Admin\Controller\IndexController.class.php 第 89 行.
NOTIC: [8] Undefined variable: sh_count5 D:\phpStudy\PHPTutorial\WWWXFMF\Application\Admin\Controller\IndexController.class.php 第 89 行.

