[2023-07-03T18:51:18+08:00][sql] CONNECT:[ UseTime:0.011146s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:18+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000976s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000349s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000306s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2023-07-03T18:51:18+08:00][sql] CONNECT:[ UseTime:0.010637s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:18+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.007467s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000439s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000209s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000171s ] [2023-07-03T18:51:18+08:00][sql] CONNECT:[ UseTime:0.010778s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:51:18+08:00][sql] SHOW FULL COLUMNS FROM `user_menu` [ RunTime:0.000763s ] [2023-07-03T18:51:18+08:00][sql] SELECT * FROM `user_menu` WHERE `is_nav` = 1 ORDER BY `order`,`id` ASC [ RunTime:0.000542s ] [2023-07-03T18:51:18+08:00][sql] CONNECT:[ UseTime:0.010369s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:18+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000950s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000313s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000294s ] [2023-07-03T18:51:18+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2023-07-03T18:51:18+08:00][sql] CONNECT:[ UseTime:0.010238s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:51:18+08:00][sql] SHOW FULL COLUMNS FROM `update` [ RunTime:0.000616s ] [2023-07-03T18:51:18+08:00][sql] SELECT * FROM `update` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000238s ] [2023-07-03T18:51:18+08:00][sql] SHOW FULL COLUMNS FROM `user_menu` [ RunTime:0.000624s ] [2023-07-03T18:51:18+08:00][sql] SELECT * FROM `user_menu` WHERE `is_nav` = 1 ORDER BY `order`,`id` ASC [ RunTime:0.000497s ] [2023-07-03T18:51:23+08:00][sql] CONNECT:[ UseTime:0.010304s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:23+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000923s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000326s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2023-07-03T18:51:23+08:00][sql] CONNECT:[ UseTime:0.010104s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:23+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000725s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000317s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000187s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000216s ] [2023-07-03T18:51:23+08:00][sql] CONNECT:[ UseTime:0.010093s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:51:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000741s ] [2023-07-03T18:51:23+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000893s ] [2023-07-03T18:51:23+08:00][sql] CONNECT:[ UseTime:0.001564s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:23+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000646s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000276s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000180s ] [2023-07-03T18:51:23+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000239s ] [2023-07-03T18:51:23+08:00][sql] CONNECT:[ UseTime:0.010346s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:51:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000655s ] [2023-07-03T18:51:23+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000708s ] [2023-07-03T18:51:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000907s ] [2023-07-03T18:51:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 90 LIMIT 1 [ RunTime:0.000309s ] [2023-07-03T18:51:23+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 90 ORDER BY `id` ASC LIMIT 0,20 [ RunTime:0.000328s ] [2023-07-03T18:51:23+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001106s ] [2023-07-03T18:51:23+08:00][sql] SELECT * FROM `bom` WHERE `product` IN (1,2,3,4,5,6,7,8,9,10,11,12) [ RunTime:0.000389s ] [2023-07-03T18:51:23+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.001081s ] [2023-07-03T18:51:29+08:00][sql] CONNECT:[ UseTime:0.011075s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000860s ] [2023-07-03T18:51:29+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000296s ] [2023-07-03T18:51:29+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000218s ] [2023-07-03T18:51:29+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000174s ] [2023-07-03T18:51:29+08:00][sql] CONNECT:[ UseTime:0.010573s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:51:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000834s ] [2023-07-03T18:51:29+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000309s ] [2023-07-03T18:51:29+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000205s ] [2023-07-03T18:51:29+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000221s ] [2023-07-03T18:51:29+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000730s ] [2023-07-03T18:51:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000179s ] [2023-07-03T18:51:29+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000294s ] [2023-07-03T18:53:10+08:00][sql] CONNECT:[ UseTime:0.010307s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000938s ] [2023-07-03T18:53:10+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000382s ] [2023-07-03T18:53:10+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000210s ] [2023-07-03T18:53:10+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000177s ] [2023-07-03T18:53:10+08:00][sql] CONNECT:[ UseTime:0.010686s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:53:10+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000648s ] [2023-07-03T18:53:10+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000242s ] [2023-07-03T18:53:10+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000816s ] [2023-07-03T18:53:10+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000406s ] [2023-07-03T18:53:11+08:00][sql] CONNECT:[ UseTime:0.010747s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000771s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000469s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000312s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000328s ] [2023-07-03T18:53:11+08:00][sql] CONNECT:[ UseTime:0.010419s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000623s ] [2023-07-03T18:53:11+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000828s ] [2023-07-03T18:53:11+08:00][sql] CONNECT:[ UseTime:0.011128s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000882s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000381s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000256s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000301s ] [2023-07-03T18:53:11+08:00][sql] CONNECT:[ UseTime:0.010724s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000849s ] [2023-07-03T18:53:11+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000929s ] [2023-07-03T18:53:11+08:00][sql] CONNECT:[ UseTime:0.010802s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000665s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000425s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000320s ] [2023-07-03T18:53:11+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000253s ] [2023-07-03T18:53:11+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000220s ] [2023-07-03T18:53:11+08:00][sql] CONNECT:[ UseTime:0.010129s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.007498s ] [2023-07-03T18:53:11+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000970s ] [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000939s ] [2023-07-03T18:53:11+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.108238s ] [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001142s ] [2023-07-03T18:53:11+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000362s ] [2023-07-03T18:53:11+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000983s ] [2023-07-03T18:53:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) LIMIT 1 [ RunTime:0.000672s ] [2023-07-03T18:53:11+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.001092s ] [2023-07-03T18:53:18+08:00][sql] CONNECT:[ UseTime:0.010192s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:18+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000716s ] [2023-07-03T18:53:18+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000300s ] [2023-07-03T18:53:18+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000189s ] [2023-07-03T18:53:18+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2023-07-03T18:53:18+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000232s ] [2023-07-03T18:53:18+08:00][sql] CONNECT:[ UseTime:0.009989s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:53:18+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000845s ] [2023-07-03T18:53:18+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000929s ] [2023-07-03T18:53:18+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000868s ] [2023-07-03T18:53:18+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.098700s ] [2023-07-03T18:53:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000918s ] [2023-07-03T18:53:18+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000288s ] [2023-07-03T18:53:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000827s ] [2023-07-03T18:53:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%cb-16%' OR `type` LIKE '%cb-16%' OR `specs` LIKE '%cb-16%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) LIMIT 1 [ RunTime:0.000762s ] [2023-07-03T18:53:18+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%cb-16%' OR `type` LIKE '%cb-16%' OR `specs` LIKE '%cb-16%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000712s ] [2023-07-03T18:53:20+08:00][sql] CONNECT:[ UseTime:0.010144s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000876s ] [2023-07-03T18:53:20+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000268s ] [2023-07-03T18:53:20+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2023-07-03T18:53:20+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000160s ] [2023-07-03T18:53:20+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000192s ] [2023-07-03T18:53:20+08:00][sql] CONNECT:[ UseTime:0.010324s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000657s ] [2023-07-03T18:53:20+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000758s ] [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000629s ] [2023-07-03T18:53:20+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.098412s ] [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000952s ] [2023-07-03T18:53:20+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000298s ] [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000591s ] [2023-07-03T18:53:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%cb-1%' OR `type` LIKE '%cb-1%' OR `specs` LIKE '%cb-1%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) LIMIT 1 [ RunTime:0.000682s ] [2023-07-03T18:53:20+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%cb-1%' OR `type` LIKE '%cb-1%' OR `specs` LIKE '%cb-1%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000663s ] [2023-07-03T18:53:20+08:00][sql] CONNECT:[ UseTime:0.010821s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000703s ] [2023-07-03T18:53:20+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000279s ] [2023-07-03T18:53:20+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000186s ] [2023-07-03T18:53:20+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000166s ] [2023-07-03T18:53:20+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000233s ] [2023-07-03T18:53:20+08:00][sql] CONNECT:[ UseTime:0.010798s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000666s ] [2023-07-03T18:53:20+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000753s ] [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000759s ] [2023-07-03T18:53:20+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.105554s ] [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001014s ] [2023-07-03T18:53:20+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000275s ] [2023-07-03T18:53:20+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000622s ] [2023-07-03T18:53:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%cb-%' OR `type` LIKE '%cb-%' OR `specs` LIKE '%cb-%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) LIMIT 1 [ RunTime:0.000674s ] [2023-07-03T18:53:20+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%cb-%' OR `type` LIKE '%cb-%' OR `specs` LIKE '%cb-%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000814s ] [2023-07-03T18:53:40+08:00][sql] CONNECT:[ UseTime:0.010412s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:40+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000728s ] [2023-07-03T18:53:40+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000281s ] [2023-07-03T18:53:40+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000268s ] [2023-07-03T18:53:40+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000211s ] [2023-07-03T18:53:40+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000582s ] [2023-07-03T18:53:40+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 141 , `name` = '防火插销' , `type` = 'CB-WX2' , `specs` = '-' , `unit` = '个' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 167 , `create_time` = '2023-07-03 18:53:40.394704' , `update_time` = '2023-07-03 18:53:40.394717' [ RunTime:0.000249s ] [2023-07-03T18:53:40+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000281s ] [2023-07-03T18:53:40+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000196s ] [2023-07-03T18:53:40+08:00][sql] UPDATE `raw` SET `number` = 'R00010' , `update_time` = '2023-07-03 18:53:40.397200' WHERE `id` = 10 [ RunTime:0.000198s ] [2023-07-03T18:53:40+08:00][sql] CONNECT:[ UseTime:0.000935s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:40+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000820s ] [2023-07-03T18:53:40+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000280s ] [2023-07-03T18:53:40+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000190s ] [2023-07-03T18:53:40+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000229s ] [2023-07-03T18:53:41+08:00][sql] CONNECT:[ UseTime:0.010459s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:53:41+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000684s ] [2023-07-03T18:53:41+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000321s ] [2023-07-03T18:53:41+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000271s ] [2023-07-03T18:53:41+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000181s ] [2023-07-03T18:53:41+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.006923s ] [2023-07-03T18:53:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000227s ] [2023-07-03T18:53:41+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000291s ] [2023-07-03T18:55:58+08:00][sql] CONNECT:[ UseTime:0.011275s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:55:58+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000945s ] [2023-07-03T18:55:58+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000331s ] [2023-07-03T18:55:58+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000221s ] [2023-07-03T18:55:58+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000167s ] [2023-07-03T18:55:58+08:00][sql] CONNECT:[ UseTime:0.010907s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:55:58+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000819s ] [2023-07-03T18:55:58+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000310s ] [2023-07-03T18:55:58+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000759s ] [2023-07-03T18:55:58+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000287s ] [2023-07-03T18:55:58+08:00][sql] CONNECT:[ UseTime:0.010039s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:55:58+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000933s ] [2023-07-03T18:55:58+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000347s ] [2023-07-03T18:55:58+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000359s ] [2023-07-03T18:55:58+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000252s ] [2023-07-03T18:55:58+08:00][sql] CONNECT:[ UseTime:0.011055s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:55:58+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000927s ] [2023-07-03T18:55:58+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000831s ] [2023-07-03T18:55:59+08:00][sql] CONNECT:[ UseTime:0.000840s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:55:59+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000706s ] [2023-07-03T18:55:59+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000326s ] [2023-07-03T18:55:59+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000266s ] [2023-07-03T18:55:59+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000213s ] [2023-07-03T18:55:59+08:00][sql] CONNECT:[ UseTime:0.010198s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:55:59+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000920s ] [2023-07-03T18:55:59+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000869s ] [2023-07-03T18:55:59+08:00][sql] CONNECT:[ UseTime:0.010410s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:55:59+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000863s ] [2023-07-03T18:55:59+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000428s ] [2023-07-03T18:55:59+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000244s ] [2023-07-03T18:55:59+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000211s ] [2023-07-03T18:55:59+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000246s ] [2023-07-03T18:55:59+08:00][sql] CONNECT:[ UseTime:0.011094s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:55:59+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000793s ] [2023-07-03T18:55:59+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000842s ] [2023-07-03T18:55:59+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001053s ] [2023-07-03T18:55:59+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.101508s ] [2023-07-03T18:55:59+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000889s ] [2023-07-03T18:55:59+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000283s ] [2023-07-03T18:55:59+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000572s ] [2023-07-03T18:55:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) LIMIT 1 [ RunTime:0.000513s ] [2023-07-03T18:55:59+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000661s ] [2023-07-03T18:56:21+08:00][sql] CONNECT:[ UseTime:0.010272s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:21+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000802s ] [2023-07-03T18:56:21+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000435s ] [2023-07-03T18:56:21+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000233s ] [2023-07-03T18:56:21+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000177s ] [2023-07-03T18:56:21+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000204s ] [2023-07-03T18:56:21+08:00][sql] CONNECT:[ UseTime:0.010441s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:56:21+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000626s ] [2023-07-03T18:56:21+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000886s ] [2023-07-03T18:56:21+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000638s ] [2023-07-03T18:56:21+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.106521s ] [2023-07-03T18:56:21+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001187s ] [2023-07-03T18:56:21+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000372s ] [2023-07-03T18:56:21+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000720s ] [2023-07-03T18:56:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%玻璃%' OR `type` LIKE '%玻璃%' OR `specs` LIKE '%玻璃%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) LIMIT 1 [ RunTime:0.000841s ] [2023-07-03T18:56:21+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%玻璃%' OR `type` LIKE '%玻璃%' OR `specs` LIKE '%玻璃%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000818s ] [2023-07-03T18:56:28+08:00][sql] CONNECT:[ UseTime:0.010899s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:28+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000949s ] [2023-07-03T18:56:28+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000397s ] [2023-07-03T18:56:28+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000193s ] [2023-07-03T18:56:28+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000177s ] [2023-07-03T18:56:28+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000697s ] [2023-07-03T18:56:28+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 443 , `name` = '隔热型防火玻璃' , `type` = 'FFB-32-A1.50' , `specs` = '-' , `unit` = '块' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 40 , `create_time` = '2023-07-03 18:56:28.987636' , `update_time` = '2023-07-03 18:56:28.987650' [ RunTime:0.000240s ] [2023-07-03T18:56:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000252s ] [2023-07-03T18:56:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000222s ] [2023-07-03T18:56:28+08:00][sql] UPDATE `raw` SET `number` = 'R00010' , `update_time` = '2023-07-03 18:56:28.990060' WHERE `id` = 10 [ RunTime:0.000269s ] [2023-07-03T18:56:29+08:00][sql] CONNECT:[ UseTime:0.010248s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000722s ] [2023-07-03T18:56:29+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000290s ] [2023-07-03T18:56:29+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000189s ] [2023-07-03T18:56:29+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000203s ] [2023-07-03T18:56:29+08:00][sql] CONNECT:[ UseTime:0.000913s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000663s ] [2023-07-03T18:56:29+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000354s ] [2023-07-03T18:56:29+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000185s ] [2023-07-03T18:56:29+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000184s ] [2023-07-03T18:56:29+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.006158s ] [2023-07-03T18:56:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000204s ] [2023-07-03T18:56:29+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000293s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.010497s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000730s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000268s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000203s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000173s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.011035s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000634s ] [2023-07-03T18:56:53+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000277s ] [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000608s ] [2023-07-03T18:56:53+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000256s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.001025s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001038s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000376s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000270s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000294s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.000834s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000677s ] [2023-07-03T18:56:53+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000622s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.000877s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000700s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000296s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000227s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000211s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.010765s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000919s ] [2023-07-03T18:56:53+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000734s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.009957s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000793s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000343s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000332s ] [2023-07-03T18:56:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000223s ] [2023-07-03T18:56:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000255s ] [2023-07-03T18:56:53+08:00][sql] CONNECT:[ UseTime:0.010406s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000618s ] [2023-07-03T18:56:53+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000762s ] [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000653s ] [2023-07-03T18:56:53+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.102877s ] [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001061s ] [2023-07-03T18:56:53+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000346s ] [2023-07-03T18:56:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000635s ] [2023-07-03T18:56:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40) LIMIT 1 [ RunTime:0.000586s ] [2023-07-03T18:56:53+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000667s ] [2023-07-03T18:56:56+08:00][sql] CONNECT:[ UseTime:0.010565s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:56:56+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000726s ] [2023-07-03T18:56:56+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000277s ] [2023-07-03T18:56:56+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000191s ] [2023-07-03T18:56:56+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000287s ] [2023-07-03T18:56:56+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000242s ] [2023-07-03T18:56:56+08:00][sql] CONNECT:[ UseTime:0.010352s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:56:56+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000723s ] [2023-07-03T18:56:56+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000815s ] [2023-07-03T18:56:56+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000733s ] [2023-07-03T18:56:56+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.105970s ] [2023-07-03T18:56:56+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001007s ] [2023-07-03T18:56:56+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000261s ] [2023-07-03T18:56:56+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000600s ] [2023-07-03T18:56:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40) LIMIT 1 [ RunTime:0.000582s ] [2023-07-03T18:56:56+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40) ORDER BY `name`,`type`,`specs` DESC LIMIT 10,10 [ RunTime:0.000681s ] [2023-07-03T18:57:10+08:00][sql] CONNECT:[ UseTime:0.010700s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000702s ] [2023-07-03T18:57:10+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000260s ] [2023-07-03T18:57:10+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000199s ] [2023-07-03T18:57:10+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000274s ] [2023-07-03T18:57:10+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000810s ] [2023-07-03T18:57:10+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 52 , `name` = '防火膨胀密封件' , `type` = 'FPJ-A-15*2' , `specs` = '0.5*3' , `unit` = '米' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 262 , `create_time` = '2023-07-03 18:57:10.831079' , `update_time` = '2023-07-03 18:57:10.831093' [ RunTime:0.000267s ] [2023-07-03T18:57:10+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000374s ] [2023-07-03T18:57:10+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000192s ] [2023-07-03T18:57:10+08:00][sql] UPDATE `raw` SET `number` = 'R00011' , `update_time` = '2023-07-03 18:57:10.833822' WHERE `id` = 11 [ RunTime:0.000282s ] [2023-07-03T18:57:11+08:00][sql] CONNECT:[ UseTime:0.010708s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:11+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000756s ] [2023-07-03T18:57:11+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000442s ] [2023-07-03T18:57:11+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000224s ] [2023-07-03T18:57:11+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000285s ] [2023-07-03T18:57:11+08:00][sql] CONNECT:[ UseTime:0.010293s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:11+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000757s ] [2023-07-03T18:57:11+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000307s ] [2023-07-03T18:57:11+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000230s ] [2023-07-03T18:57:11+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000176s ] [2023-07-03T18:57:11+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.007471s ] [2023-07-03T18:57:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000200s ] [2023-07-03T18:57:11+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000351s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.011324s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000688s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000323s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000199s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000171s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.011060s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000595s ] [2023-07-03T18:57:32+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000237s ] [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000687s ] [2023-07-03T18:57:32+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000345s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.010757s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000751s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000346s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000232s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000216s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.010901s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000660s ] [2023-07-03T18:57:32+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000726s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.010920s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000639s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000386s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000369s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000281s ] [2023-07-03T18:57:32+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000304s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.011286s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000809s ] [2023-07-03T18:57:32+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000878s ] [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000751s ] [2023-07-03T18:57:32+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.104955s ] [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000708s ] [2023-07-03T18:57:32+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000324s ] [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000622s ] [2023-07-03T18:57:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) LIMIT 1 [ RunTime:0.000695s ] [2023-07-03T18:57:32+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000812s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.000939s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000876s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000418s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000318s ] [2023-07-03T18:57:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000247s ] [2023-07-03T18:57:32+08:00][sql] CONNECT:[ UseTime:0.011281s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:57:32+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000824s ] [2023-07-03T18:57:32+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000893s ] [2023-07-03T18:57:36+08:00][sql] CONNECT:[ UseTime:0.010476s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:36+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000746s ] [2023-07-03T18:57:36+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000308s ] [2023-07-03T18:57:36+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000196s ] [2023-07-03T18:57:36+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000184s ] [2023-07-03T18:57:36+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000222s ] [2023-07-03T18:57:36+08:00][sql] CONNECT:[ UseTime:0.011122s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:57:36+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000806s ] [2023-07-03T18:57:36+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000884s ] [2023-07-03T18:57:36+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000862s ] [2023-07-03T18:57:36+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.111837s ] [2023-07-03T18:57:36+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000925s ] [2023-07-03T18:57:36+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000380s ] [2023-07-03T18:57:36+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000585s ] [2023-07-03T18:57:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) LIMIT 1 [ RunTime:0.000499s ] [2023-07-03T18:57:36+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) ORDER BY `name`,`type`,`specs` DESC LIMIT 10,10 [ RunTime:0.000777s ] [2023-07-03T18:57:45+08:00][sql] CONNECT:[ UseTime:0.010508s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:45+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000810s ] [2023-07-03T18:57:45+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000338s ] [2023-07-03T18:57:45+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2023-07-03T18:57:45+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000181s ] [2023-07-03T18:57:45+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000255s ] [2023-07-03T18:57:45+08:00][sql] CONNECT:[ UseTime:0.011115s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:57:45+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000814s ] [2023-07-03T18:57:45+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000929s ] [2023-07-03T18:57:45+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000702s ] [2023-07-03T18:57:45+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.108216s ] [2023-07-03T18:57:45+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001093s ] [2023-07-03T18:57:45+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000295s ] [2023-07-03T18:57:45+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000623s ] [2023-07-03T18:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) LIMIT 1 [ RunTime:0.000527s ] [2023-07-03T18:57:45+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) ORDER BY `name`,`type`,`specs` DESC LIMIT 20,10 [ RunTime:0.000821s ] [2023-07-03T18:57:48+08:00][sql] CONNECT:[ UseTime:0.010109s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:48+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000744s ] [2023-07-03T18:57:48+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000319s ] [2023-07-03T18:57:48+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000261s ] [2023-07-03T18:57:48+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000181s ] [2023-07-03T18:57:48+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000197s ] [2023-07-03T18:57:48+08:00][sql] CONNECT:[ UseTime:0.010426s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:57:48+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001027s ] [2023-07-03T18:57:48+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000980s ] [2023-07-03T18:57:48+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000905s ] [2023-07-03T18:57:48+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.105850s ] [2023-07-03T18:57:48+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000996s ] [2023-07-03T18:57:48+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000286s ] [2023-07-03T18:57:48+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000762s ] [2023-07-03T18:57:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) LIMIT 1 [ RunTime:0.000449s ] [2023-07-03T18:57:48+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262) ORDER BY `name`,`type`,`specs` DESC LIMIT 10,10 [ RunTime:0.000736s ] [2023-07-03T18:57:55+08:00][sql] CONNECT:[ UseTime:0.010914s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:55+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000797s ] [2023-07-03T18:57:55+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000255s ] [2023-07-03T18:57:55+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000195s ] [2023-07-03T18:57:55+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000175s ] [2023-07-03T18:57:55+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000552s ] [2023-07-03T18:57:55+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 137 , `name` = '防火铰链（合页）' , `type` = '5时' , `specs` = '-' , `unit` = '个' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 43 , `create_time` = '2023-07-03 18:57:55.620755' , `update_time` = '2023-07-03 18:57:55.620768' [ RunTime:0.000233s ] [2023-07-03T18:57:55+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000246s ] [2023-07-03T18:57:55+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000222s ] [2023-07-03T18:57:55+08:00][sql] UPDATE `raw` SET `number` = 'R00012' , `update_time` = '2023-07-03 18:57:55.623473' WHERE `id` = 12 [ RunTime:0.000198s ] [2023-07-03T18:57:56+08:00][sql] CONNECT:[ UseTime:0.010587s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:56+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000685s ] [2023-07-03T18:57:56+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000267s ] [2023-07-03T18:57:56+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000190s ] [2023-07-03T18:57:56+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000257s ] [2023-07-03T18:57:56+08:00][sql] CONNECT:[ UseTime:0.010999s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:57:56+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000863s ] [2023-07-03T18:57:56+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000327s ] [2023-07-03T18:57:56+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000216s ] [2023-07-03T18:57:56+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000171s ] [2023-07-03T18:57:56+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000595s ] [2023-07-03T18:57:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000221s ] [2023-07-03T18:57:56+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000219s ] [2023-07-03T18:58:13+08:00][sql] CONNECT:[ UseTime:0.010554s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000719s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000377s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000196s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000171s ] [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.010060s ] [2023-07-03T18:58:13+08:00][sql] SELECT * FROM `raw` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000320s ] [2023-07-03T18:58:13+08:00][sql] CONNECT:[ UseTime:0.011267s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000854s ] [2023-07-03T18:58:13+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 137 LIMIT 1 [ RunTime:0.000302s ] [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000601s ] [2023-07-03T18:58:13+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000309s ] [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000727s ] [2023-07-03T18:58:13+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000264s ] [2023-07-03T18:58:13+08:00][sql] CONNECT:[ UseTime:0.010329s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000633s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000265s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000294s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000594s ] [2023-07-03T18:58:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%5时%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000314s ] [2023-07-03T18:58:13+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%5时%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000228s ] [2023-07-03T18:58:13+08:00][sql] CONNECT:[ UseTime:0.011310s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000732s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000273s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2023-07-03T18:58:13+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000219s ] [2023-07-03T18:58:13+08:00][sql] CONNECT:[ UseTime:0.010494s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:58:13+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000658s ] [2023-07-03T18:58:13+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000567s ] [2023-07-03T18:58:19+08:00][sql] CONNECT:[ UseTime:0.011023s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:19+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000700s ] [2023-07-03T18:58:19+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000301s ] [2023-07-03T18:58:19+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000239s ] [2023-07-03T18:58:19+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000214s ] [2023-07-03T18:58:19+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000628s ] [2023-07-03T18:58:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%5时%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000249s ] [2023-07-03T18:58:19+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%5时%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000373s ] [2023-07-03T18:58:27+08:00][sql] CONNECT:[ UseTime:0.010808s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:27+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000895s ] [2023-07-03T18:58:27+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000405s ] [2023-07-03T18:58:27+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000244s ] [2023-07-03T18:58:27+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000178s ] [2023-07-03T18:58:27+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000882s ] [2023-07-03T18:58:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%5时%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000377s ] [2023-07-03T18:58:27+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%5时%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000322s ] [2023-07-03T18:58:29+08:00][sql] CONNECT:[ UseTime:0.010423s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000756s ] [2023-07-03T18:58:29+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000287s ] [2023-07-03T18:58:29+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000208s ] [2023-07-03T18:58:29+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000302s ] [2023-07-03T18:58:29+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000716s ] [2023-07-03T18:58:29+08:00][sql] SELECT * FROM `raw` WHERE `id` <> 12 AND `name` = '防火铰链（合页）' AND `type` = '4吋' AND `specs` = '-' [ RunTime:0.000325s ] [2023-07-03T18:58:29+08:00][sql] UPDATE `raw` SET `number` = 'R00012' , `raw_sort` = 137 , `type` = '4吋' , `specs` = '-' , `unit` = '个' , `nickname` = '' , `price` = '0.00' , `remark` = '' , `name` = '防火铰链（合页）' , `update_time` = '2023-07-03 18:58:29.367942' WHERE `id` = 12 [ RunTime:0.000263s ] [2023-07-03T18:58:29+08:00][sql] CONNECT:[ UseTime:0.010817s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000822s ] [2023-07-03T18:58:29+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000366s ] [2023-07-03T18:58:29+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2023-07-03T18:58:29+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000191s ] [2023-07-03T18:58:29+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000604s ] [2023-07-03T18:58:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000219s ] [2023-07-03T18:58:29+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000232s ] [2023-07-03T18:58:46+08:00][sql] CONNECT:[ UseTime:0.010645s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000756s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000333s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000174s ] [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000658s ] [2023-07-03T18:58:46+08:00][sql] SELECT * FROM `raw` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000323s ] [2023-07-03T18:58:46+08:00][sql] CONNECT:[ UseTime:0.011004s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000921s ] [2023-07-03T18:58:46+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 137 LIMIT 1 [ RunTime:0.000380s ] [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000590s ] [2023-07-03T18:58:46+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000236s ] [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.001010s ] [2023-07-03T18:58:46+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000454s ] [2023-07-03T18:58:46+08:00][sql] CONNECT:[ UseTime:0.000749s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000595s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000257s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000185s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000189s ] [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000601s ] [2023-07-03T18:58:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000348s ] [2023-07-03T18:58:46+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000255s ] [2023-07-03T18:58:46+08:00][sql] CONNECT:[ UseTime:0.009769s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001000s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000361s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000321s ] [2023-07-03T18:58:46+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000338s ] [2023-07-03T18:58:46+08:00][sql] CONNECT:[ UseTime:0.010120s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:58:46+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000622s ] [2023-07-03T18:58:46+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000731s ] [2023-07-03T18:58:49+08:00][sql] CONNECT:[ UseTime:0.000897s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:49+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000759s ] [2023-07-03T18:58:49+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000304s ] [2023-07-03T18:58:49+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000236s ] [2023-07-03T18:58:49+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000176s ] [2023-07-03T18:58:49+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000870s ] [2023-07-03T18:58:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000318s ] [2023-07-03T18:58:49+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000411s ] [2023-07-03T18:58:49+08:00][sql] CONNECT:[ UseTime:0.010442s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:49+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000857s ] [2023-07-03T18:58:49+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000344s ] [2023-07-03T18:58:49+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000317s ] [2023-07-03T18:58:49+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000277s ] [2023-07-03T18:58:49+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000771s ] [2023-07-03T18:58:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000315s ] [2023-07-03T18:58:49+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000244s ] [2023-07-03T18:58:51+08:00][sql] CONNECT:[ UseTime:0.010726s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000914s ] [2023-07-03T18:58:51+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000311s ] [2023-07-03T18:58:51+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000184s ] [2023-07-03T18:58:51+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000178s ] [2023-07-03T18:58:51+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000573s ] [2023-07-03T18:58:51+08:00][sql] SELECT * FROM `raw` WHERE `id` <> 12 AND `name` = '防火铰链（合页）' AND `type` = '4.5吋' AND `specs` = '-' [ RunTime:0.000301s ] [2023-07-03T18:58:51+08:00][sql] UPDATE `raw` SET `number` = 'R00012' , `raw_sort` = 137 , `type` = '4.5吋' , `specs` = '-' , `unit` = '个' , `nickname` = '' , `price` = '0.00' , `remark` = '' , `name` = '防火铰链（合页）' , `update_time` = '2023-07-03 18:58:51.706895' WHERE `id` = 12 [ RunTime:0.000333s ] [2023-07-03T18:58:51+08:00][sql] CONNECT:[ UseTime:0.010711s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:58:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000657s ] [2023-07-03T18:58:51+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000287s ] [2023-07-03T18:58:51+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000179s ] [2023-07-03T18:58:51+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000247s ] [2023-07-03T18:58:51+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000541s ] [2023-07-03T18:58:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000161s ] [2023-07-03T18:58:51+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000315s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.011048s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000753s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000584s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000342s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000195s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.011196s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000960s ] [2023-07-03T18:59:12+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000291s ] [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000654s ] [2023-07-03T18:59:12+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000275s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.001125s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000847s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000409s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000258s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000358s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.010681s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000763s ] [2023-07-03T18:59:12+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000820s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.000800s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000732s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000432s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000458s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000344s ] [2023-07-03T18:59:12+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000498s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.010685s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000832s ] [2023-07-03T18:59:12+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000951s ] [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000859s ] [2023-07-03T18:59:12+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.102921s ] [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000737s ] [2023-07-03T18:59:12+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000342s ] [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000578s ] [2023-07-03T18:59:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43) LIMIT 1 [ RunTime:0.000562s ] [2023-07-03T18:59:12+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000796s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.010742s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000858s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000359s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000324s ] [2023-07-03T18:59:12+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000331s ] [2023-07-03T18:59:12+08:00][sql] CONNECT:[ UseTime:0.010555s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:12+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000705s ] [2023-07-03T18:59:12+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000739s ] [2023-07-03T18:59:15+08:00][sql] CONNECT:[ UseTime:0.010397s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:15+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000761s ] [2023-07-03T18:59:15+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000282s ] [2023-07-03T18:59:15+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000192s ] [2023-07-03T18:59:15+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000168s ] [2023-07-03T18:59:15+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000195s ] [2023-07-03T18:59:15+08:00][sql] CONNECT:[ UseTime:0.000706s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000538s ] [2023-07-03T18:59:15+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000929s ] [2023-07-03T18:59:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000707s ] [2023-07-03T18:59:15+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.100679s ] [2023-07-03T18:59:15+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000868s ] [2023-07-03T18:59:15+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000309s ] [2023-07-03T18:59:15+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000578s ] [2023-07-03T18:59:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43) LIMIT 1 [ RunTime:0.000479s ] [2023-07-03T18:59:15+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43) ORDER BY `name`,`type`,`specs` DESC LIMIT 10,10 [ RunTime:0.000709s ] [2023-07-03T18:59:18+08:00][sql] CONNECT:[ UseTime:0.011038s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:18+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001033s ] [2023-07-03T18:59:18+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000488s ] [2023-07-03T18:59:18+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000415s ] [2023-07-03T18:59:18+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000258s ] [2023-07-03T18:59:18+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000275s ] [2023-07-03T18:59:18+08:00][sql] CONNECT:[ UseTime:0.010451s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:18+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000828s ] [2023-07-03T18:59:18+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.001016s ] [2023-07-03T18:59:18+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001030s ] [2023-07-03T18:59:18+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.112311s ] [2023-07-03T18:59:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000829s ] [2023-07-03T18:59:18+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000313s ] [2023-07-03T18:59:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000793s ] [2023-07-03T18:59:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43) LIMIT 1 [ RunTime:0.000666s ] [2023-07-03T18:59:18+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43) ORDER BY `name`,`type`,`specs` DESC LIMIT 20,10 [ RunTime:0.000909s ] [2023-07-03T18:59:43+08:00][sql] CONNECT:[ UseTime:0.000900s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:43+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000711s ] [2023-07-03T18:59:43+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000273s ] [2023-07-03T18:59:43+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2023-07-03T18:59:43+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000286s ] [2023-07-03T18:59:43+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000639s ] [2023-07-03T18:59:43+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 133 , `name` = '防火锁' , `type` = 'CB-SIA' , `specs` = '-' , `unit` = '把' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 44 , `create_time` = '2023-07-03 18:59:43.789665' , `update_time` = '2023-07-03 18:59:43.789678' [ RunTime:0.000222s ] [2023-07-03T18:59:43+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000252s ] [2023-07-03T18:59:43+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000194s ] [2023-07-03T18:59:43+08:00][sql] UPDATE `raw` SET `number` = 'R00013' , `update_time` = '2023-07-03 18:59:43.792349' WHERE `id` = 13 [ RunTime:0.000206s ] [2023-07-03T18:59:44+08:00][sql] CONNECT:[ UseTime:0.010665s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:44+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000824s ] [2023-07-03T18:59:44+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000339s ] [2023-07-03T18:59:44+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000270s ] [2023-07-03T18:59:44+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000181s ] [2023-07-03T18:59:44+08:00][sql] CONNECT:[ UseTime:0.001197s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:44+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000938s ] [2023-07-03T18:59:44+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000304s ] [2023-07-03T18:59:44+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000259s ] [2023-07-03T18:59:44+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000191s ] [2023-07-03T18:59:44+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000681s ] [2023-07-03T18:59:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000271s ] [2023-07-03T18:59:44+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000243s ] [2023-07-03T18:59:48+08:00][sql] CONNECT:[ UseTime:0.010627s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000710s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000295s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000241s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000200s ] [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000753s ] [2023-07-03T18:59:48+08:00][sql] SELECT * FROM `raw` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000270s ] [2023-07-03T18:59:48+08:00][sql] CONNECT:[ UseTime:0.000789s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000740s ] [2023-07-03T18:59:48+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000255s ] [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000707s ] [2023-07-03T18:59:48+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000245s ] [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000714s ] [2023-07-03T18:59:48+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000323s ] [2023-07-03T18:59:48+08:00][sql] CONNECT:[ UseTime:0.010600s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000799s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000334s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000401s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000237s ] [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000657s ] [2023-07-03T18:59:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%CB-SIA%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000500s ] [2023-07-03T18:59:48+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%CB-SIA%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000316s ] [2023-07-03T18:59:48+08:00][sql] CONNECT:[ UseTime:0.001170s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000860s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000320s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000320s ] [2023-07-03T18:59:48+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000370s ] [2023-07-03T18:59:48+08:00][sql] CONNECT:[ UseTime:0.010648s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T18:59:48+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000977s ] [2023-07-03T18:59:48+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.001035s ] [2023-07-03T18:59:51+08:00][sql] CONNECT:[ UseTime:0.010506s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000682s ] [2023-07-03T18:59:51+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000274s ] [2023-07-03T18:59:51+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000193s ] [2023-07-03T18:59:51+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000204s ] [2023-07-03T18:59:51+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000657s ] [2023-07-03T18:59:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%CB-SIA%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000341s ] [2023-07-03T18:59:51+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%CB-SIA%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000242s ] [2023-07-03T18:59:53+08:00][sql] CONNECT:[ UseTime:0.010485s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000707s ] [2023-07-03T18:59:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000289s ] [2023-07-03T18:59:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000189s ] [2023-07-03T18:59:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000284s ] [2023-07-03T18:59:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000589s ] [2023-07-03T18:59:53+08:00][sql] SELECT * FROM `raw` WHERE `id` <> 13 AND `name` = '防火锁' AND `type` = 'CB-SIC' AND `specs` = '-' [ RunTime:0.000306s ] [2023-07-03T18:59:53+08:00][sql] UPDATE `raw` SET `number` = 'R00013' , `raw_sort` = 133 , `type` = 'CB-SIC' , `specs` = '-' , `unit` = '把' , `nickname` = '' , `price` = '0.00' , `remark` = '' , `name` = '防火锁' , `update_time` = '2023-07-03 18:59:53.496728' WHERE `id` = 13 [ RunTime:0.000258s ] [2023-07-03T18:59:53+08:00][sql] CONNECT:[ UseTime:0.010509s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T18:59:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000701s ] [2023-07-03T18:59:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000278s ] [2023-07-03T18:59:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000201s ] [2023-07-03T18:59:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000198s ] [2023-07-03T18:59:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000743s ] [2023-07-03T18:59:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000176s ] [2023-07-03T18:59:53+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000227s ] [2023-07-03T19:00:22+08:00][sql] CONNECT:[ UseTime:0.011337s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:22+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000765s ] [2023-07-03T19:00:22+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000331s ] [2023-07-03T19:00:22+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000258s ] [2023-07-03T19:00:22+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000173s ] [2023-07-03T19:00:22+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000772s ] [2023-07-03T19:00:22+08:00][sql] SELECT * FROM `raw` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000307s ] [2023-07-03T19:00:22+08:00][sql] CONNECT:[ UseTime:0.010671s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:00:22+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000806s ] [2023-07-03T19:00:22+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 137 LIMIT 1 [ RunTime:0.000405s ] [2023-07-03T19:00:22+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000498s ] [2023-07-03T19:00:22+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000307s ] [2023-07-03T19:00:22+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000562s ] [2023-07-03T19:00:22+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000277s ] [2023-07-03T19:00:23+08:00][sql] CONNECT:[ UseTime:0.010871s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:23+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000820s ] [2023-07-03T19:00:23+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000419s ] [2023-07-03T19:00:23+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000371s ] [2023-07-03T19:00:23+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000333s ] [2023-07-03T19:00:23+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000848s ] [2023-07-03T19:00:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000562s ] [2023-07-03T19:00:23+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000304s ] [2023-07-03T19:00:23+08:00][sql] CONNECT:[ UseTime:0.010688s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:23+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000904s ] [2023-07-03T19:00:23+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000321s ] [2023-07-03T19:00:23+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000186s ] [2023-07-03T19:00:23+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000228s ] [2023-07-03T19:00:23+08:00][sql] CONNECT:[ UseTime:0.010507s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:00:23+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001202s ] [2023-07-03T19:00:23+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000926s ] [2023-07-03T19:00:25+08:00][sql] CONNECT:[ UseTime:0.000887s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:25+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000746s ] [2023-07-03T19:00:25+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000272s ] [2023-07-03T19:00:25+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000242s ] [2023-07-03T19:00:25+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000202s ] [2023-07-03T19:00:25+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000617s ] [2023-07-03T19:00:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000262s ] [2023-07-03T19:00:25+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000237s ] [2023-07-03T19:00:27+08:00][sql] CONNECT:[ UseTime:0.010996s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:27+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000809s ] [2023-07-03T19:00:27+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000272s ] [2023-07-03T19:00:27+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000196s ] [2023-07-03T19:00:27+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000200s ] [2023-07-03T19:00:27+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000636s ] [2023-07-03T19:00:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000277s ] [2023-07-03T19:00:27+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000264s ] [2023-07-03T19:00:27+08:00][sql] CONNECT:[ UseTime:0.000877s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:27+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000703s ] [2023-07-03T19:00:27+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000274s ] [2023-07-03T19:00:27+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000213s ] [2023-07-03T19:00:27+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000261s ] [2023-07-03T19:00:27+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000558s ] [2023-07-03T19:00:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000265s ] [2023-07-03T19:00:27+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000221s ] [2023-07-03T19:00:35+08:00][sql] CONNECT:[ UseTime:0.010249s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:35+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000716s ] [2023-07-03T19:00:35+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000298s ] [2023-07-03T19:00:35+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000192s ] [2023-07-03T19:00:35+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000181s ] [2023-07-03T19:00:35+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000599s ] [2023-07-03T19:00:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000277s ] [2023-07-03T19:00:35+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000249s ] [2023-07-03T19:00:39+08:00][sql] CONNECT:[ UseTime:0.010943s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:39+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000965s ] [2023-07-03T19:00:39+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000393s ] [2023-07-03T19:00:39+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000285s ] [2023-07-03T19:00:39+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000227s ] [2023-07-03T19:00:39+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000677s ] [2023-07-03T19:00:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000310s ] [2023-07-03T19:00:39+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000328s ] [2023-07-03T19:00:42+08:00][sql] CONNECT:[ UseTime:0.010850s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:00:42+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000804s ] [2023-07-03T19:00:42+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000336s ] [2023-07-03T19:00:42+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000214s ] [2023-07-03T19:00:42+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000281s ] [2023-07-03T19:00:42+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000840s ] [2023-07-03T19:00:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000370s ] [2023-07-03T19:00:42+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000314s ] [2023-07-03T19:01:50+08:00][sql] CONNECT:[ UseTime:0.010898s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:01:50+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000916s ] [2023-07-03T19:01:50+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000393s ] [2023-07-03T19:01:50+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000207s ] [2023-07-03T19:01:50+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000232s ] [2023-07-03T19:01:50+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.009584s ] [2023-07-03T19:01:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000421s ] [2023-07-03T19:01:50+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000337s ] [2023-07-03T19:01:54+08:00][sql] CONNECT:[ UseTime:0.010645s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:01:54+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000758s ] [2023-07-03T19:01:54+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000680s ] [2023-07-03T19:01:54+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000226s ] [2023-07-03T19:01:54+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000197s ] [2023-07-03T19:01:54+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000686s ] [2023-07-03T19:01:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000266s ] [2023-07-03T19:01:54+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%4.5吋%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000271s ] [2023-07-03T19:03:44+08:00][sql] CONNECT:[ UseTime:0.010912s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:03:44+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000771s ] [2023-07-03T19:03:44+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000300s ] [2023-07-03T19:03:44+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000182s ] [2023-07-03T19:03:44+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000290s ] [2023-07-03T19:03:44+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000612s ] [2023-07-03T19:03:44+08:00][sql] SELECT * FROM `raw` WHERE `id` <> 12 AND `name` = '防火铰链（合页）' AND `type` = '4.5吋（∅14）' AND `specs` = '-' [ RunTime:0.000337s ] [2023-07-03T19:03:44+08:00][sql] UPDATE `raw` SET `number` = 'R00012' , `raw_sort` = 137 , `type` = '4.5吋（∅14）' , `specs` = '-' , `unit` = '个' , `nickname` = '' , `price` = '0.00' , `remark` = '' , `name` = '防火铰链（合页）' , `update_time` = '2023-07-03 19:03:44.714576' WHERE `id` = 12 [ RunTime:0.000353s ] [2023-07-03T19:03:44+08:00][sql] CONNECT:[ UseTime:0.010282s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:03:44+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000720s ] [2023-07-03T19:03:44+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000275s ] [2023-07-03T19:03:44+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000185s ] [2023-07-03T19:03:44+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000166s ] [2023-07-03T19:03:44+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000528s ] [2023-07-03T19:03:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000173s ] [2023-07-03T19:03:44+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000212s ] [2023-07-03T19:04:13+08:00][sql] CONNECT:[ UseTime:0.010776s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:13+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000727s ] [2023-07-03T19:04:13+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000306s ] [2023-07-03T19:04:13+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000235s ] [2023-07-03T19:04:13+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000203s ] [2023-07-03T19:04:13+08:00][sql] CONNECT:[ UseTime:0.010808s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:13+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000836s ] [2023-07-03T19:04:13+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000437s ] [2023-07-03T19:04:13+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000792s ] [2023-07-03T19:04:13+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000364s ] [2023-07-03T19:04:14+08:00][sql] CONNECT:[ UseTime:0.000832s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000769s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000519s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000301s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000257s ] [2023-07-03T19:04:14+08:00][sql] CONNECT:[ UseTime:0.000697s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000595s ] [2023-07-03T19:04:14+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000665s ] [2023-07-03T19:04:14+08:00][sql] CONNECT:[ UseTime:0.000918s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001047s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000417s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000281s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000201s ] [2023-07-03T19:04:14+08:00][sql] CONNECT:[ UseTime:0.010919s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000876s ] [2023-07-03T19:04:14+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000797s ] [2023-07-03T19:04:14+08:00][sql] CONNECT:[ UseTime:0.009681s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000759s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000268s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000610s ] [2023-07-03T19:04:14+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000295s ] [2023-07-03T19:04:14+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000228s ] [2023-07-03T19:04:14+08:00][sql] CONNECT:[ UseTime:0.010747s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000658s ] [2023-07-03T19:04:14+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000923s ] [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000805s ] [2023-07-03T19:04:14+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.109498s ] [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000771s ] [2023-07-03T19:04:14+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000248s ] [2023-07-03T19:04:14+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000536s ] [2023-07-03T19:04:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) LIMIT 1 [ RunTime:0.000438s ] [2023-07-03T19:04:14+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000632s ] [2023-07-03T19:04:18+08:00][sql] CONNECT:[ UseTime:0.001092s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:18+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000785s ] [2023-07-03T19:04:18+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000343s ] [2023-07-03T19:04:18+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000347s ] [2023-07-03T19:04:18+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000299s ] [2023-07-03T19:04:18+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000259s ] [2023-07-03T19:04:18+08:00][sql] CONNECT:[ UseTime:0.011526s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:18+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000706s ] [2023-07-03T19:04:18+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000759s ] [2023-07-03T19:04:18+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000821s ] [2023-07-03T19:04:18+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.129427s ] [2023-07-03T19:04:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000876s ] [2023-07-03T19:04:18+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000254s ] [2023-07-03T19:04:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000579s ] [2023-07-03T19:04:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) LIMIT 1 [ RunTime:0.000471s ] [2023-07-03T19:04:18+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) ORDER BY `name`,`type`,`specs` DESC LIMIT 10,10 [ RunTime:0.000834s ] [2023-07-03T19:04:21+08:00][sql] CONNECT:[ UseTime:0.010236s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:21+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000707s ] [2023-07-03T19:04:21+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000400s ] [2023-07-03T19:04:21+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000199s ] [2023-07-03T19:04:21+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000177s ] [2023-07-03T19:04:21+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000214s ] [2023-07-03T19:04:21+08:00][sql] CONNECT:[ UseTime:0.010523s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:21+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000647s ] [2023-07-03T19:04:21+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000756s ] [2023-07-03T19:04:21+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000700s ] [2023-07-03T19:04:21+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.099418s ] [2023-07-03T19:04:21+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000844s ] [2023-07-03T19:04:21+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000265s ] [2023-07-03T19:04:21+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000608s ] [2023-07-03T19:04:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) LIMIT 1 [ RunTime:0.000491s ] [2023-07-03T19:04:21+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) ORDER BY `name`,`type`,`specs` DESC LIMIT 20,10 [ RunTime:0.000813s ] [2023-07-03T19:04:23+08:00][sql] CONNECT:[ UseTime:0.010270s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:23+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000904s ] [2023-07-03T19:04:23+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000281s ] [2023-07-03T19:04:23+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000306s ] [2023-07-03T19:04:23+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000168s ] [2023-07-03T19:04:23+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000216s ] [2023-07-03T19:04:23+08:00][sql] CONNECT:[ UseTime:0.010648s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000644s ] [2023-07-03T19:04:23+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000736s ] [2023-07-03T19:04:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000777s ] [2023-07-03T19:04:23+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.099018s ] [2023-07-03T19:04:23+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000788s ] [2023-07-03T19:04:23+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000312s ] [2023-07-03T19:04:23+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000569s ] [2023-07-03T19:04:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) LIMIT 1 [ RunTime:0.000433s ] [2023-07-03T19:04:23+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44) ORDER BY `name`,`type`,`specs` DESC LIMIT 30,10 [ RunTime:0.000740s ] [2023-07-03T19:04:31+08:00][sql] CONNECT:[ UseTime:0.000863s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:31+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000721s ] [2023-07-03T19:04:31+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000257s ] [2023-07-03T19:04:31+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000368s ] [2023-07-03T19:04:31+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000277s ] [2023-07-03T19:04:31+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000613s ] [2023-07-03T19:04:31+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 134 , `name` = '防火顺序器' , `type` = 'CB-WSI' , `specs` = '-' , `unit` = '个' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 166 , `create_time` = '2023-07-03 19:04:31.889502' , `update_time` = '2023-07-03 19:04:31.889515' [ RunTime:0.000252s ] [2023-07-03T19:04:31+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000277s ] [2023-07-03T19:04:31+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000212s ] [2023-07-03T19:04:31+08:00][sql] UPDATE `raw` SET `number` = 'R00014' , `update_time` = '2023-07-03 19:04:31.892066' WHERE `id` = 14 [ RunTime:0.000232s ] [2023-07-03T19:04:32+08:00][sql] CONNECT:[ UseTime:0.010766s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000686s ] [2023-07-03T19:04:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000278s ] [2023-07-03T19:04:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000192s ] [2023-07-03T19:04:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000169s ] [2023-07-03T19:04:32+08:00][sql] CONNECT:[ UseTime:0.010598s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000846s ] [2023-07-03T19:04:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000307s ] [2023-07-03T19:04:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000287s ] [2023-07-03T19:04:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000190s ] [2023-07-03T19:04:32+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000594s ] [2023-07-03T19:04:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000171s ] [2023-07-03T19:04:32+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000247s ] [2023-07-03T19:04:35+08:00][sql] CONNECT:[ UseTime:0.010435s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000729s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000277s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000195s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000281s ] [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000647s ] [2023-07-03T19:04:35+08:00][sql] SELECT * FROM `raw` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000273s ] [2023-07-03T19:04:35+08:00][sql] CONNECT:[ UseTime:0.010630s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000815s ] [2023-07-03T19:04:35+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 134 LIMIT 1 [ RunTime:0.000330s ] [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000704s ] [2023-07-03T19:04:35+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000248s ] [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000592s ] [2023-07-03T19:04:35+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000255s ] [2023-07-03T19:04:35+08:00][sql] CONNECT:[ UseTime:0.001193s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000692s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000324s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000227s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000218s ] [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000869s ] [2023-07-03T19:04:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%CB-WSI%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000322s ] [2023-07-03T19:04:35+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%CB-WSI%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000372s ] [2023-07-03T19:04:35+08:00][sql] CONNECT:[ UseTime:0.000658s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000847s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000454s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000590s ] [2023-07-03T19:04:35+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000270s ] [2023-07-03T19:04:35+08:00][sql] CONNECT:[ UseTime:0.011133s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:04:35+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000694s ] [2023-07-03T19:04:35+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000638s ] [2023-07-03T19:04:38+08:00][sql] CONNECT:[ UseTime:0.010892s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:38+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000826s ] [2023-07-03T19:04:38+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000375s ] [2023-07-03T19:04:38+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000230s ] [2023-07-03T19:04:38+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000169s ] [2023-07-03T19:04:38+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000596s ] [2023-07-03T19:04:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%CB-WSI%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000263s ] [2023-07-03T19:04:38+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%CB-WSI%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000267s ] [2023-07-03T19:04:38+08:00][sql] CONNECT:[ UseTime:0.010742s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:38+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000779s ] [2023-07-03T19:04:38+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000266s ] [2023-07-03T19:04:38+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000199s ] [2023-07-03T19:04:38+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000211s ] [2023-07-03T19:04:38+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000650s ] [2023-07-03T19:04:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%CB-WSI%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000236s ] [2023-07-03T19:04:38+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%CB-WSI%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000234s ] [2023-07-03T19:04:40+08:00][sql] CONNECT:[ UseTime:0.011387s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:40+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000838s ] [2023-07-03T19:04:40+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000439s ] [2023-07-03T19:04:40+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000265s ] [2023-07-03T19:04:40+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000242s ] [2023-07-03T19:04:40+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000644s ] [2023-07-03T19:04:40+08:00][sql] SELECT * FROM `raw` WHERE `id` <> 14 AND `name` = '防火顺序器' AND `type` = 'CB-15' AND `specs` = '-' [ RunTime:0.000347s ] [2023-07-03T19:04:40+08:00][sql] UPDATE `raw` SET `number` = 'R00014' , `raw_sort` = 134 , `type` = 'CB-15' , `specs` = '-' , `unit` = '个' , `nickname` = '' , `price` = '0.00' , `remark` = '' , `name` = '防火顺序器' , `update_time` = '2023-07-03 19:04:40.570460' WHERE `id` = 14 [ RunTime:0.000306s ] [2023-07-03T19:04:40+08:00][sql] CONNECT:[ UseTime:0.011226s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:04:40+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000751s ] [2023-07-03T19:04:40+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000280s ] [2023-07-03T19:04:40+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000204s ] [2023-07-03T19:04:40+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000281s ] [2023-07-03T19:04:40+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000713s ] [2023-07-03T19:04:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000266s ] [2023-07-03T19:04:40+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000254s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.011025s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000771s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000278s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000190s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.009922s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000624s ] [2023-07-03T19:05:38+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000238s ] [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000635s ] [2023-07-03T19:05:38+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000241s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.001017s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001033s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000365s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000695s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000266s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.010061s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000675s ] [2023-07-03T19:05:38+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000763s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.010906s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000635s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000298s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000266s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000262s ] [2023-07-03T19:05:38+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000278s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000598s ] [2023-07-03T19:05:38+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.001026s ] [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000682s ] [2023-07-03T19:05:38+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.100322s ] [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000804s ] [2023-07-03T19:05:38+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000354s ] [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000566s ] [2023-07-03T19:05:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166) LIMIT 1 [ RunTime:0.000482s ] [2023-07-03T19:05:38+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000696s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.010703s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000843s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000353s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000331s ] [2023-07-03T19:05:38+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000327s ] [2023-07-03T19:05:38+08:00][sql] CONNECT:[ UseTime:0.010693s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:05:38+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000682s ] [2023-07-03T19:05:38+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000798s ] [2023-07-03T19:05:41+08:00][sql] CONNECT:[ UseTime:0.001039s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:41+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000733s ] [2023-07-03T19:05:41+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000310s ] [2023-07-03T19:05:41+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000248s ] [2023-07-03T19:05:41+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000235s ] [2023-07-03T19:05:41+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000324s ] [2023-07-03T19:05:41+08:00][sql] CONNECT:[ UseTime:0.010820s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:05:41+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000805s ] [2023-07-03T19:05:41+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000808s ] [2023-07-03T19:05:41+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000772s ] [2023-07-03T19:05:41+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.103689s ] [2023-07-03T19:05:41+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000784s ] [2023-07-03T19:05:41+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000261s ] [2023-07-03T19:05:41+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000508s ] [2023-07-03T19:05:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%玻璃%' OR `type` LIKE '%玻璃%' OR `specs` LIKE '%玻璃%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166) LIMIT 1 [ RunTime:0.000632s ] [2023-07-03T19:05:41+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND ( `name` LIKE '%玻璃%' OR `type` LIKE '%玻璃%' OR `specs` LIKE '%玻璃%' ) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000746s ] [2023-07-03T19:05:49+08:00][sql] CONNECT:[ UseTime:0.010114s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:49+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000735s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000326s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000331s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000234s ] [2023-07-03T19:05:49+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000791s ] [2023-07-03T19:05:49+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 443 , `name` = '隔热型防火玻璃' , `type` = 'FFB-26-A1.00' , `specs` = '-' , `unit` = '块' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 45 , `create_time` = '2023-07-03 19:05:49.316805' , `update_time` = '2023-07-03 19:05:49.316818' [ RunTime:0.000314s ] [2023-07-03T19:05:49+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000316s ] [2023-07-03T19:05:49+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000297s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `raw` SET `number` = 'R00015' , `update_time` = '2023-07-03 19:05:49.319670' WHERE `id` = 15 [ RunTime:0.000241s ] [2023-07-03T19:05:49+08:00][sql] CONNECT:[ UseTime:0.010000s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:49+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000688s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000277s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000230s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000164s ] [2023-07-03T19:05:49+08:00][sql] CONNECT:[ UseTime:0.010347s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:49+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000772s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000268s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000179s ] [2023-07-03T19:05:49+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000187s ] [2023-07-03T19:05:49+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000560s ] [2023-07-03T19:05:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000299s ] [2023-07-03T19:05:49+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000233s ] [2023-07-03T19:05:53+08:00][sql] CONNECT:[ UseTime:0.010666s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000694s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000285s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000184s ] [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000618s ] [2023-07-03T19:05:53+08:00][sql] SELECT * FROM `raw` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000356s ] [2023-07-03T19:05:53+08:00][sql] CONNECT:[ UseTime:0.010655s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000673s ] [2023-07-03T19:05:53+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 443 LIMIT 1 [ RunTime:0.000286s ] [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000654s ] [2023-07-03T19:05:53+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000204s ] [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000627s ] [2023-07-03T19:05:53+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000245s ] [2023-07-03T19:05:53+08:00][sql] CONNECT:[ UseTime:0.010452s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000639s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000302s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000229s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000226s ] [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000586s ] [2023-07-03T19:05:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%FFB-26-A1.00%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000277s ] [2023-07-03T19:05:53+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%FFB-26-A1.00%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000271s ] [2023-07-03T19:05:53+08:00][sql] CONNECT:[ UseTime:0.000933s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000831s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000475s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000252s ] [2023-07-03T19:05:53+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000365s ] [2023-07-03T19:05:53+08:00][sql] CONNECT:[ UseTime:0.010540s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:05:53+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000663s ] [2023-07-03T19:05:53+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000585s ] [2023-07-03T19:05:57+08:00][sql] CONNECT:[ UseTime:0.011021s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:57+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000707s ] [2023-07-03T19:05:57+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000267s ] [2023-07-03T19:05:57+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000274s ] [2023-07-03T19:05:57+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000165s ] [2023-07-03T19:05:57+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000648s ] [2023-07-03T19:05:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%FFB-26-A1.00%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000278s ] [2023-07-03T19:05:57+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%FFB-26-A1.00%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000244s ] [2023-07-03T19:05:59+08:00][sql] CONNECT:[ UseTime:0.010684s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:59+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000708s ] [2023-07-03T19:05:59+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000320s ] [2023-07-03T19:05:59+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000297s ] [2023-07-03T19:05:59+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000302s ] [2023-07-03T19:05:59+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000731s ] [2023-07-03T19:05:59+08:00][sql] SELECT * FROM `raw` WHERE `id` <> 15 AND `name` = '隔热型防火玻璃' AND `type` = 'FFB-25-A1.00' AND `specs` = '-' [ RunTime:0.000461s ] [2023-07-03T19:05:59+08:00][sql] UPDATE `raw` SET `number` = 'R00015' , `raw_sort` = 443 , `type` = 'FFB-25-A1.00' , `specs` = '-' , `unit` = '块' , `nickname` = '' , `price` = '0.00' , `remark` = '' , `name` = '隔热型防火玻璃' , `update_time` = '2023-07-03 19:05:59.159535' WHERE `id` = 15 [ RunTime:0.000284s ] [2023-07-03T19:05:59+08:00][sql] CONNECT:[ UseTime:0.010150s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:05:59+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000700s ] [2023-07-03T19:05:59+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000278s ] [2023-07-03T19:05:59+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000189s ] [2023-07-03T19:05:59+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000268s ] [2023-07-03T19:05:59+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000585s ] [2023-07-03T19:05:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000173s ] [2023-07-03T19:05:59+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000233s ] [2023-07-03T19:06:12+08:00][sql] CONNECT:[ UseTime:0.000948s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:12+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000697s ] [2023-07-03T19:06:12+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000281s ] [2023-07-03T19:06:12+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000247s ] [2023-07-03T19:06:12+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000284s ] [2023-07-03T19:06:12+08:00][sql] CONNECT:[ UseTime:0.010829s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:12+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000625s ] [2023-07-03T19:06:12+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000248s ] [2023-07-03T19:06:12+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.000747s ] [2023-07-03T19:06:12+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000269s ] [2023-07-03T19:06:13+08:00][sql] CONNECT:[ UseTime:0.000940s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000970s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000290s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000235s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000328s ] [2023-07-03T19:06:13+08:00][sql] CONNECT:[ UseTime:0.010563s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000735s ] [2023-07-03T19:06:13+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000733s ] [2023-07-03T19:06:13+08:00][sql] CONNECT:[ UseTime:0.000826s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000812s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000466s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000343s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000271s ] [2023-07-03T19:06:13+08:00][sql] CONNECT:[ UseTime:0.011138s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000887s ] [2023-07-03T19:06:13+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.001060s ] [2023-07-03T19:06:13+08:00][sql] CONNECT:[ UseTime:0.010606s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000984s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000413s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000235s ] [2023-07-03T19:06:13+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000210s ] [2023-07-03T19:06:13+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000307s ] [2023-07-03T19:06:13+08:00][sql] CONNECT:[ UseTime:0.000939s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000603s ] [2023-07-03T19:06:13+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000926s ] [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000694s ] [2023-07-03T19:06:13+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.112074s ] [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000841s ] [2023-07-03T19:06:13+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000272s ] [2023-07-03T19:06:13+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000610s ] [2023-07-03T19:06:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166,45) LIMIT 1 [ RunTime:0.000652s ] [2023-07-03T19:06:13+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166,45) ORDER BY `name`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000800s ] [2023-07-03T19:06:16+08:00][sql] CONNECT:[ UseTime:0.000968s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:16+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000713s ] [2023-07-03T19:06:16+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000273s ] [2023-07-03T19:06:16+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000220s ] [2023-07-03T19:06:16+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000323s ] [2023-07-03T19:06:16+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000235s ] [2023-07-03T19:06:16+08:00][sql] CONNECT:[ UseTime:0.011048s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000654s ] [2023-07-03T19:06:16+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000730s ] [2023-07-03T19:06:16+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000709s ] [2023-07-03T19:06:16+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.100248s ] [2023-07-03T19:06:16+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000840s ] [2023-07-03T19:06:16+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000347s ] [2023-07-03T19:06:16+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000639s ] [2023-07-03T19:06:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166,45) LIMIT 1 [ RunTime:0.000520s ] [2023-07-03T19:06:16+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166,45) ORDER BY `name`,`type`,`specs` DESC LIMIT 30,10 [ RunTime:0.000757s ] [2023-07-03T19:06:18+08:00][sql] CONNECT:[ UseTime:0.010679s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:18+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000694s ] [2023-07-03T19:06:18+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000331s ] [2023-07-03T19:06:18+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000206s ] [2023-07-03T19:06:18+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000198s ] [2023-07-03T19:06:18+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'product_sort' LIMIT 1 [ RunTime:0.000227s ] [2023-07-03T19:06:18+08:00][sql] CONNECT:[ UseTime:0.011144s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:18+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000993s ] [2023-07-03T19:06:18+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000936s ] [2023-07-03T19:06:18+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001001s ] [2023-07-03T19:06:18+08:00][sql] SELECT `raw` FROM `product` `a` INNER JOIN `bom` `b` ON `a`.`id`=`b`.`product` LEFT JOIN `bom_info` `c` ON `b`.`id`=`c`.`bom` WHERE `b`.`status` = '2' AND `c`.`status` = '1' AND `product_sort` = 90 [ RunTime:0.106693s ] [2023-07-03T19:06:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000763s ] [2023-07-03T19:06:18+08:00][sql] SELECT `sys` FROM `raw` WHERE `sys` <> 0 [ RunTime:0.000264s ] [2023-07-03T19:06:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000854s ] [2023-07-03T19:06:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166,45) LIMIT 1 [ RunTime:0.000499s ] [2023-07-03T19:06:18+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,40,41,42,44,38,43,45,39,46,47,48,166,170,168,169,172,173,175,176,178,180,171,174,167,248,249,250,251,253,254,261,264,252,262,265,255,256,263,259,260,164,280,281,282,293,64,292,575,542,613,301,585,591,582,584,702,703) AND `id` NOT IN (180,703,178,613,41,37,38,584,250,40,262,43,44,166,45) ORDER BY `name`,`type`,`specs` DESC LIMIT 20,10 [ RunTime:0.000782s ] [2023-07-03T19:06:23+08:00][sql] CONNECT:[ UseTime:0.010099s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:23+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000703s ] [2023-07-03T19:06:23+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000314s ] [2023-07-03T19:06:23+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000194s ] [2023-07-03T19:06:23+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000292s ] [2023-07-03T19:06:23+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000686s ] [2023-07-03T19:06:23+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 133 , `name` = '防火锁' , `type` = 'CB-S17' , `specs` = '-' , `unit` = '把' , `price` = '' , `status` = 1 , `remark` = '' , `sys` = 292 , `create_time` = '2023-07-03 19:06:23.950719' , `update_time` = '2023-07-03 19:06:23.950732' [ RunTime:0.000271s ] [2023-07-03T19:06:23+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_pre' LIMIT 1 [ RunTime:0.000241s ] [2023-07-03T19:06:23+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'r_n' LIMIT 1 [ RunTime:0.000240s ] [2023-07-03T19:06:23+08:00][sql] UPDATE `raw` SET `number` = 'R00016' , `update_time` = '2023-07-03 19:06:23.953284' WHERE `id` = 16 [ RunTime:0.000241s ] [2023-07-03T19:06:24+08:00][sql] CONNECT:[ UseTime:0.011065s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:24+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000874s ] [2023-07-03T19:06:24+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000305s ] [2023-07-03T19:06:24+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000306s ] [2023-07-03T19:06:24+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000175s ] [2023-07-03T19:06:24+08:00][sql] CONNECT:[ UseTime:0.010714s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:24+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000789s ] [2023-07-03T19:06:24+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000281s ] [2023-07-03T19:06:24+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000185s ] [2023-07-03T19:06:24+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000258s ] [2023-07-03T19:06:24+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000881s ] [2023-07-03T19:06:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000185s ] [2023-07-03T19:06:24+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000231s ] [2023-07-03T19:06:27+08:00][sql] CONNECT:[ UseTime:0.011106s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000822s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000358s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000211s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000209s ] [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000653s ] [2023-07-03T19:06:27+08:00][sql] SELECT * FROM `raw` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000321s ] [2023-07-03T19:06:27+08:00][sql] CONNECT:[ UseTime:0.010483s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000751s ] [2023-07-03T19:06:27+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 133 LIMIT 1 [ RunTime:0.000353s ] [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `model` [ RunTime:0.000638s ] [2023-07-03T19:06:27+08:00][sql] SELECT `id` FROM `model` WHERE `title` = 'raw' LIMIT 1 [ RunTime:0.000231s ] [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `vp` [ RunTime:0.001016s ] [2023-07-03T19:06:27+08:00][sql] SELECT * FROM `vp` WHERE `model` = 15 LIMIT 1 [ RunTime:0.000470s ] [2023-07-03T19:06:27+08:00][sql] CONNECT:[ UseTime:0.000797s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001083s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000428s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000268s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000177s ] [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000595s ] [2023-07-03T19:06:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%CB-S17%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000336s ] [2023-07-03T19:06:27+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%CB-S17%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000268s ] [2023-07-03T19:06:27+08:00][sql] CONNECT:[ UseTime:0.010600s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000593s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000241s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000195s ] [2023-07-03T19:06:27+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000211s ] [2023-07-03T19:06:27+08:00][sql] CONNECT:[ UseTime:0.011274s ] mysql:host=127.0.0.1;dbname=ams;charset=utf8 [2023-07-03T19:06:27+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000605s ] [2023-07-03T19:06:27+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000558s ] [2023-07-03T19:06:31+08:00][sql] CONNECT:[ UseTime:0.010350s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:31+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000760s ] [2023-07-03T19:06:31+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000306s ] [2023-07-03T19:06:31+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000206s ] [2023-07-03T19:06:31+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000184s ] [2023-07-03T19:06:31+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000670s ] [2023-07-03T19:06:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '%CB-S17%' AND `specs` LIKE '%-%' LIMIT 1 [ RunTime:0.000272s ] [2023-07-03T19:06:31+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '%CB-S17%' AND `specs` LIKE '%-%' LIMIT 0,10 [ RunTime:0.000293s ] [2023-07-03T19:06:32+08:00][sql] CONNECT:[ UseTime:0.010572s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000890s ] [2023-07-03T19:06:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000441s ] [2023-07-03T19:06:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000272s ] [2023-07-03T19:06:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000251s ] [2023-07-03T19:06:32+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000800s ] [2023-07-03T19:06:32+08:00][sql] SELECT * FROM `raw` WHERE `id` <> 16 AND `name` = '防火锁' AND `type` = 'CB-S18' AND `specs` = '-' [ RunTime:0.000383s ] [2023-07-03T19:06:32+08:00][sql] UPDATE `raw` SET `number` = 'R00016' , `raw_sort` = 133 , `type` = 'CB-S18' , `specs` = '-' , `unit` = '把' , `nickname` = '' , `price` = '0.00' , `remark` = '' , `name` = '防火锁' , `update_time` = '2023-07-03 19:06:32.300377' WHERE `id` = 16 [ RunTime:0.000416s ] [2023-07-03T19:06:32+08:00][sql] CONNECT:[ UseTime:0.000931s ] mysql:host=127.0.0.1;port=3306;dbname=jiacheng;charset=utf8 [2023-07-03T19:06:32+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000691s ] [2023-07-03T19:06:32+08:00][sql] UPDATE `set` SET `value` = 'jiacheng' WHERE `field` = 'database' [ RunTime:0.000308s ] [2023-07-03T19:06:32+08:00][sql] UPDATE `set` SET `value` = '长春市佳城门业有限公司' WHERE `field` = 'title' [ RunTime:0.000211s ] [2023-07-03T19:06:32+08:00][sql] UPDATE `set` SET `value` = '90' WHERE `field` = 'product_sort' [ RunTime:0.000188s ] [2023-07-03T19:06:32+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000595s ] [2023-07-03T19:06:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` LIMIT 1 [ RunTime:0.000168s ] [2023-07-03T19:06:32+08:00][sql] SELECT * FROM `raw` LIMIT 0,20 [ RunTime:0.000238s ]