[ DB ] CONNECT:[ UseTime:0.000213s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `jie_category` [ RunTime:0.001014s ]
[ SQL ] SELECT * FROM `jie_category` WHERE `catdir` = 'xiaoyuanv8800' LIMIT 1 [ RunTime:0.000443s ]
[ DB ] CONNECT:[ UseTime:0.000123s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 1239 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SHOW COLUMNS FROM `jie_product` [ RunTime:0.000878s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_new` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.001270s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_popular` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.001002s ]
[ DB ] CONNECT:[ UseTime:0.000124s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT `id` FROM `jie_category` WHERE `parentid` = 1239 AND `status` = 1 LIMIT 1 [ RunTime:0.000496s ]
[ SQL ] SHOW COLUMNS FROM `jie_screen` [ RunTime:0.000592s ]
[ 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(1239, catid) ) AND `type` = 2 AND `input` IN (2,3) AND `status` = 1 ORDER BY `listorder` ASC,`name` ASC,`id` ASC [ RunTime:0.003558s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `jie_product` WHERE `catid` = 1239 AND `status` = 1 [ RunTime:0.000812s ]
[ SQL ] SELECT DISTINCT * FROM `jie_product` WHERE `catid` = 1239 AND `status` = 1 ORDER BY `flag` DESC,`listorder` ASC,`inputtime` DESC LIMIT 0,8 [ RunTime:0.001319s ]
[ SQL ] SHOW COLUMNS FROM `jie_links` [ RunTime:0.000558s ]
[ SQL ] SELECT * FROM `jie_links` WHERE ( status=1 ) ORDER BY `listorder` ASC LIMIT 6 [ RunTime:0.000285s ]