[ DB ] CONNECT:[ UseTime:0.000172s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `jie_category` [ RunTime:0.000708s ]
[ SQL ] SELECT * FROM `jie_category` WHERE `catdir` = 'E-ZKEcoPro' LIMIT 1 [ RunTime:0.000386s ]
[ DB ] CONNECT:[ UseTime:0.000094s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 1234 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SHOW COLUMNS FROM `jie_product` [ RunTime:0.000699s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_new` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.001185s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_popular` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.000916s ]
[ DB ] CONNECT:[ UseTime:0.000092s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT `id` FROM `jie_category` WHERE `parentid` = 1234 AND `status` = 1 LIMIT 1 [ RunTime:0.000415s ]
[ SQL ] SHOW COLUMNS FROM `jie_screen` [ RunTime:0.000527s ]
[ SQL ] SELECT * FROM `jie_screen` WHERE ( FIND_IN_SET(0, catid) OR FIND_IN_SET(11, catid) OR FIND_IN_SET(1217, catid) OR FIND_IN_SET(1234, catid) ) AND `type` = 2 AND `input` IN (2,3) AND `status` = 1 ORDER BY `listorder` ASC,`name` ASC,`id` ASC [ RunTime:0.003468s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `jie_product` WHERE `catid` = 1234 AND `status` = 1 [ RunTime:0.000887s ]
[ SQL ] SELECT DISTINCT * FROM `jie_product` WHERE `catid` = 1234 AND `status` = 1 ORDER BY `flag` DESC,`listorder` ASC,`inputtime` DESC LIMIT 0,8 [ RunTime:0.001019s ]
[ SQL ] SHOW COLUMNS FROM `jie_links` [ RunTime:0.000547s ]
[ SQL ] SELECT * FROM `jie_links` WHERE ( status=1 ) ORDER BY `listorder` ASC LIMIT 6 [ RunTime:0.000292s ]