[ DB ] CONNECT:[ UseTime:0.000147s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `jie_category` [ RunTime:0.000718s ]
[ SQL ] SELECT * FROM `jie_category` WHERE `catdir` = 'product_category' LIMIT 1 [ RunTime:0.000438s ]
[ SQL ] SHOW COLUMNS FROM `jie_product` [ RunTime:0.000760s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_new` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.001214s ]
[ SQL ] SELECT * FROM `jie_product` WHERE `status` = 1 AND `is_popular` = 1 ORDER BY `listorder` ASC,`id` DESC LIMIT 3 [ RunTime:0.000899s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 0 AND (FIND_IN_SET('3', isshow)) ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000650s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND (FIND_IN_SET('1', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000535s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( id = 1216 AND `parentid` = 11 ) ORDER BY `listorder` LIMIT 1 [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1216 ) ORDER BY `listorder` ASC [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( id = 1217 AND `parentid` = 11 ) ORDER BY `listorder` LIMIT 1 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1217 ) ORDER BY `listorder` ASC [ RunTime:0.000520s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( id= 1218 AND `parentid` = 11 ) ORDER BY `listorder` LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1218 ) ORDER BY `listorder` ASC [ RunTime:0.000475s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( id = 1219 AND `parentid` = 11 ) ORDER BY `listorder` LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1219 ) ORDER BY `listorder` ASC [ RunTime:0.000561s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 296 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000601s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 294 ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 295 ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000535s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 297 ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000527s ]
[ DB ] CONNECT:[ UseTime:0.000109s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT `id` FROM `jie_category` WHERE `parentid` = 1217 AND `status` = 1 LIMIT 1 [ RunTime:0.000386s ]
[ DB ] CONNECT:[ UseTime:0.000087s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 1230 LIMIT 1 [ RunTime:0.000292s ]
[ DB ] CONNECT:[ UseTime:0.000070s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT `id` FROM `jie_category` WHERE `parentid` = 1230 AND `status` = 1 LIMIT 1 [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( (id= 1216 or id =1217) AND `parentid` = 11 ) ORDER BY `listorder` ASC [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1216 ) ORDER BY `listorder` ASC [ RunTime:0.000551s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1220 ) ORDER BY `listorder` ASC [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1221 ) ORDER BY `listorder` ASC [ RunTime:0.000464s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1222 ) ORDER BY `listorder` ASC [ RunTime:0.000475s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1223 ) ORDER BY `listorder` ASC [ RunTime:0.000480s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1224 ) ORDER BY `listorder` ASC [ RunTime:0.000450s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1225 ) ORDER BY `listorder` ASC [ RunTime:0.000501s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1226 ) ORDER BY `listorder` ASC [ RunTime:0.000467s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1228 ) ORDER BY `listorder` ASC [ RunTime:0.000562s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1229 ) ORDER BY `listorder` ASC [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1217 ) ORDER BY `listorder` ASC [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1230 ) ORDER BY `listorder` ASC [ RunTime:0.000470s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1231 ) ORDER BY `listorder` ASC [ RunTime:0.000542s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1233 ) ORDER BY `listorder` ASC [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1234 ) ORDER BY `listorder` ASC [ RunTime:0.000461s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1235 ) ORDER BY `listorder` ASC [ RunTime:0.000527s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1236 ) ORDER BY `listorder` ASC [ RunTime:0.000503s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1237 ) ORDER BY `listorder` ASC [ RunTime:0.000538s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1238 ) ORDER BY `listorder` ASC [ RunTime:0.000508s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1239 ) ORDER BY `listorder` ASC [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1240 ) ORDER BY `listorder` ASC [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1241 ) ORDER BY `listorder` ASC [ RunTime:0.000463s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1244 ) ORDER BY `listorder` ASC [ RunTime:0.000498s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1245 ) ORDER BY `listorder` ASC [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1246 ) ORDER BY `listorder` ASC [ RunTime:0.000461s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1247 ) ORDER BY `listorder` ASC [ RunTime:0.000449s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1248 ) ORDER BY `listorder` ASC [ RunTime:0.000447s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 1249 ) ORDER BY `listorder` ASC [ RunTime:0.000458s ]
[ SQL ] SHOW COLUMNS FROM `jie_screen` [ RunTime:0.000579s ]
[ 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(1230, catid) ) AND `type` = 2 AND `input` IN (2,3) AND `status` = 1 ORDER BY `listorder` ASC,`name` ASC,`id` ASC [ RunTime:0.003537s ]
[ SQL ] SELECT DISTINCT COUNT(*) AS tp_count FROM `jie_product` WHERE `catid` = 1230 AND `status` = 1 [ RunTime:0.000945s ]
[ SQL ] SELECT DISTINCT * FROM `jie_product` WHERE `catid` = 1230 AND `status` = 1 ORDER BY `flag` DESC,`listorder` ASC,`inputtime` DESC LIMIT 0,8 [ RunTime:0.001024s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 0 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000547s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 32 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000514s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 2 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 63 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000518s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 64 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000597s ]
[ SQL ] SHOW COLUMNS FROM `jie_links` [ RunTime:0.000568s ]
[ SQL ] SELECT * FROM `jie_links` WHERE ( status=1 ) ORDER BY `listorder` ASC LIMIT 6 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 57 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000619s ]
[ 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` = 60 LIMIT 1 [ RunTime:0.000295s ]
[ DB ] CONNECT:[ UseTime:0.000082s ] mysql:host=127.0.0.1;port=3306;dbname=zkteco_cn;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000312s ]
You have added a new product to the inquiry form, check it now >
