[ DB ] CONNECT:[ UseTime:0.000192s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `jie_category` [ RunTime:0.000758s ]
[ SQL ] SELECT * FROM `jie_category` WHERE `catdir` = 'zhichiyingjianfangan' LIMIT 1 [ RunTime:0.000483s ]
[ DB ] CONNECT:[ UseTime:0.000098s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 1231 LIMIT 1 [ RunTime:0.000351s ]
[ SQL ] SHOW COLUMNS FROM `jie_product` [ RunTime:0.000753s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_new` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.001382s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_popular` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.001000s ]
[ DB ] CONNECT:[ UseTime:0.000110s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT `id` FROM `jie_category` WHERE `parentid` = 1231 AND `status` = 1 LIMIT 1 [ RunTime:0.000471s ]
[ SQL ] SHOW COLUMNS FROM `jie_screen` [ RunTime:0.000576s ]
[ 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(1231, catid) ) AND `type` = 2 AND `input` IN (2,3) AND `status` = 1 ORDER BY `listorder` ASC,`name` ASC,`id` ASC [ RunTime:0.003514s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `jie_product` WHERE `catid` = 1231 AND `status` = 1 [ RunTime:0.000949s ]
[ SQL ] SELECT DISTINCT * FROM `jie_product` WHERE `catid` = 1231 AND `status` = 1 ORDER BY `flag` DESC,`listorder` ASC,`inputtime` DESC LIMIT 0,8 [ RunTime:0.001016s ]
[ SQL ] SHOW COLUMNS FROM `jie_links` [ RunTime:0.000540s ]
[ SQL ] SELECT * FROM `jie_links` WHERE ( status=1 ) ORDER BY `listorder` ASC LIMIT 6 [ RunTime:0.000284s ]