[2022-08-13T16:00:25+08:00][sql] CONNECT:[ UseTime:0.017039s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:25+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000715s ] [2022-08-13T16:00:25+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000612s ] [2022-08-13T16:00:26+08:00][sql] CONNECT:[ UseTime:0.017633s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:26+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001015s ] [2022-08-13T16:00:26+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000658s ] [2022-08-13T16:00:26+08:00][sql] CONNECT:[ UseTime:0.001097s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:26+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000863s ] [2022-08-13T16:00:26+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('8',family) ) [ RunTime:0.000530s ] [2022-08-13T16:00:26+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000965s ] [2022-08-13T16:00:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` IN (8,184,185,186,189,190,191,192,195,196,197,198,200,203,207,208,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,235,236,237,238,239,240,241,242,243,244,245,246,250,251,252,253,254,255,257,258,448,449,450,451,507,514,515,521,527,535,536,537,544,545,193,660,664) [ RunTime:0.000832s ] [2022-08-13T16:00:26+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` IN (8,184,185,186,189,190,191,192,195,196,197,198,200,203,207,208,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,235,236,237,238,239,240,241,242,243,244,245,246,250,251,252,253,254,255,257,258,448,449,450,451,507,514,515,521,527,535,536,537,544,545,193,660,664) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000998s ] [2022-08-13T16:00:26+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` IN (450,212,208,198,239,257,238,200,242,250,544,545,217,253) [ RunTime:0.000566s ] [2022-08-13T16:00:45+08:00][sql] CONNECT:[ UseTime:0.010685s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:45+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000901s ] [2022-08-13T16:00:45+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' [ RunTime:0.000437s ] [2022-08-13T16:00:45+08:00][sql] CONNECT:[ UseTime:0.013736s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:45+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000759s ] [2022-08-13T16:00:45+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' [ RunTime:0.000478s ] [2022-08-13T16:00:45+08:00][sql] CONNECT:[ UseTime:0.018233s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:45+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000991s ] [2022-08-13T16:00:45+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' AND `title` LIKE '%t%' [ RunTime:0.000518s ] [2022-08-13T16:00:45+08:00][sql] CONNECT:[ UseTime:0.021351s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:45+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000810s ] [2022-08-13T16:00:45+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' AND `title` LIKE '%t%' AND `title` LIKE '%a%' [ RunTime:0.000493s ] [2022-08-13T16:00:46+08:00][sql] CONNECT:[ UseTime:0.016774s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:46+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000927s ] [2022-08-13T16:00:46+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' AND `title` LIKE '%t%' [ RunTime:0.000507s ] [2022-08-13T16:00:46+08:00][sql] CONNECT:[ UseTime:0.014146s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:46+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000875s ] [2022-08-13T16:00:46+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' [ RunTime:0.000461s ] [2022-08-13T16:00:46+08:00][sql] CONNECT:[ UseTime:0.015845s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:46+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000906s ] [2022-08-13T16:00:46+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' [ RunTime:0.000442s ] [2022-08-13T16:00:46+08:00][sql] CONNECT:[ UseTime:0.016477s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:46+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000921s ] [2022-08-13T16:00:46+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000604s ] [2022-08-13T16:00:47+08:00][sql] CONNECT:[ UseTime:0.016465s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000781s ] [2022-08-13T16:00:47+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' [ RunTime:0.000447s ] [2022-08-13T16:00:47+08:00][sql] CONNECT:[ UseTime:0.016408s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000698s ] [2022-08-13T16:00:47+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' [ RunTime:0.000462s ] [2022-08-13T16:00:47+08:00][sql] CONNECT:[ UseTime:0.015761s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000711s ] [2022-08-13T16:00:47+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' AND `title` LIKE '%\'%' AND `title` LIKE '%t%' [ RunTime:0.000499s ] [2022-08-13T16:00:47+08:00][sql] CONNECT:[ UseTime:0.019620s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000917s ] [2022-08-13T16:00:47+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%q%' AND `title` LIKE '%i%' AND `title` LIKE '%\'%' AND `title` LIKE '%t%' AND `title` LIKE '%a%' [ RunTime:0.000461s ] [2022-08-13T16:00:47+08:00][sql] CONNECT:[ UseTime:0.000931s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000850s ] [2022-08-13T16:00:47+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%其%' AND `title` LIKE '%他%' [ RunTime:0.000442s ] [2022-08-13T16:00:48+08:00][sql] CONNECT:[ UseTime:0.013874s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:48+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001013s ] [2022-08-13T16:00:48+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%其%' AND `title` LIKE '%他%' AND `title` LIKE '%b%' [ RunTime:0.000517s ] [2022-08-13T16:00:48+08:00][sql] CONNECT:[ UseTime:0.016635s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:48+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000969s ] [2022-08-13T16:00:48+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%其%' AND `title` LIKE '%他%' AND `title` LIKE '%b%' AND `title` LIKE '%u%' [ RunTime:0.000511s ] [2022-08-13T16:00:49+08:00][sql] CONNECT:[ UseTime:0.015129s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:49+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000851s ] [2022-08-13T16:00:49+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%其%' AND `title` LIKE '%他%' AND `title` LIKE '%b%' AND `title` LIKE '%u%' AND `title` LIKE '%\'%' AND `title` LIKE '%p%' [ RunTime:0.000490s ] [2022-08-13T16:00:49+08:00][sql] CONNECT:[ UseTime:0.000857s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:49+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000724s ] [2022-08-13T16:00:49+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%其%' AND `title` LIKE '%他%' AND `title` LIKE '%b%' AND `title` LIKE '%u%' AND `title` LIKE '%\'%' AND `title` LIKE '%p%' AND `title` LIKE '%i%' [ RunTime:0.000501s ] [2022-08-13T16:00:49+08:00][sql] CONNECT:[ UseTime:0.000849s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:49+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000805s ] [2022-08-13T16:00:49+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%其%' AND `title` LIKE '%他%' AND `title` LIKE '%b%' AND `title` LIKE '%u%' AND `title` LIKE '%\'%' AND `title` LIKE '%p%' AND `title` LIKE '%i%' AND `title` LIKE '%n%' [ RunTime:0.000530s ] [2022-08-13T16:00:50+08:00][sql] CONNECT:[ UseTime:0.018454s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:50+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000761s ] [2022-08-13T16:00:50+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%其%' AND `title` LIKE '%他%' AND `title` LIKE '%部%' AND `title` LIKE '%品%' [ RunTime:0.000495s ] [2022-08-13T16:00:53+08:00][sql] CONNECT:[ UseTime:0.013147s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:53+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000754s ] [2022-08-13T16:00:53+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000616s ] [2022-08-13T16:00:53+08:00][sql] INSERT INTO `raw_sort` SET `title` = '其他部品' , `order` = 0 , `remark` = '' , `parent_id` = 548 , `create_time` = '2022-08-13 16:00:53.359300' , `update_time` = '2022-08-13 16:00:53.359323' [ RunTime:0.000373s ] [2022-08-13T16:00:53+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 548 LIMIT 1 [ RunTime:0.000261s ] [2022-08-13T16:00:53+08:00][sql] UPDATE `raw_sort` SET `family` = ',548,665' , `update_time` = '2022-08-13 16:00:53.360559' WHERE `id` = 665 [ RunTime:0.000248s ] [2022-08-13T16:00:53+08:00][sql] CONNECT:[ UseTime:0.011401s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:53+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000703s ] [2022-08-13T16:00:53+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000573s ] [2022-08-13T16:00:59+08:00][sql] CONNECT:[ UseTime:0.023529s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:00:59+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000739s ] [2022-08-13T16:00:59+08:00][sql] UPDATE `raw_sort` SET `status` = 1 WHERE `id` = 665 [ RunTime:0.000306s ] [2022-08-13T16:01:00+08:00][sql] CONNECT:[ UseTime:0.010323s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:00+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000738s ] [2022-08-13T16:01:00+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 665 LIMIT 1 [ RunTime:0.000288s ] [2022-08-13T16:01:01+08:00][sql] CONNECT:[ UseTime:0.010967s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:01+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000679s ] [2022-08-13T16:01:01+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000539s ] [2022-08-13T16:01:06+08:00][sql] CONNECT:[ UseTime:0.017527s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:06+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000781s ] [2022-08-13T16:01:06+08:00][sql] UPDATE `raw_sort` SET `id` = 665 , `parent_id` = 548 , `title` = '其他部品' , `remark` = '消防梯配件' WHERE `id` = 665 [ RunTime:0.000437s ] [2022-08-13T16:01:06+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 548 LIMIT 1 [ RunTime:0.000283s ] [2022-08-13T16:01:06+08:00][sql] UPDATE `raw_sort` SET `family` = ',548,665' , `update_time` = '2022-08-13 16:01:06.570463' WHERE `id` = 665 [ RunTime:0.000301s ] [2022-08-13T16:01:06+08:00][sql] CONNECT:[ UseTime:0.018682s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:06+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000777s ] [2022-08-13T16:01:06+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 665 LIMIT 1 [ RunTime:0.000364s ] [2022-08-13T16:01:06+08:00][sql] CONNECT:[ UseTime:0.017403s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:06+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000682s ] [2022-08-13T16:01:06+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000580s ] [2022-08-13T16:01:10+08:00][sql] CONNECT:[ UseTime:0.019390s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:10+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000726s ] [2022-08-13T16:01:10+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('548',family) ) [ RunTime:0.000406s ] [2022-08-13T16:01:10+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000692s ] [2022-08-13T16:01:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` IN (548,567,568,569,570,571,572,651,652,653,654,663,665) [ RunTime:0.000683s ] [2022-08-13T16:01:10+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` IN (548,567,568,569,570,571,572,651,652,653,654,663,665) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000804s ] [2022-08-13T16:01:10+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` IN (567,568,569,570,571,572,651,652,653,654) [ RunTime:0.000377s ] [2022-08-13T16:01:39+08:00][sql] CONNECT:[ UseTime:0.014209s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:39+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000701s ] [2022-08-13T16:01:39+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('548',family) ) [ RunTime:0.000428s ] [2022-08-13T16:01:39+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000740s ] [2022-08-13T16:01:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` IN (548,567,568,569,570,571,572,651,652,653,654,663,665) [ RunTime:0.000629s ] [2022-08-13T16:01:39+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` IN (548,567,568,569,570,571,572,651,652,653,654,663,665) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000786s ] [2022-08-13T16:01:39+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` IN (567,568,569,570,571,572,651,652,653,654) [ RunTime:0.000370s ] [2022-08-13T16:01:44+08:00][sql] CONNECT:[ UseTime:0.010378s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000783s ] [2022-08-13T16:01:44+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('8',family) ) [ RunTime:0.000512s ] [2022-08-13T16:01:44+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000801s ] [2022-08-13T16:01:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` IN (8,184,185,186,189,190,191,192,195,196,197,198,200,203,207,208,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,235,236,237,238,239,240,241,242,243,244,245,246,250,251,252,253,254,255,257,258,448,449,450,451,507,514,515,521,527,535,536,537,544,545,193,660,664) [ RunTime:0.000858s ] [2022-08-13T16:01:44+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` IN (8,184,185,186,189,190,191,192,195,196,197,198,200,203,207,208,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,235,236,237,238,239,240,241,242,243,244,245,246,250,251,252,253,254,255,257,258,448,449,450,451,507,514,515,521,527,535,536,537,544,545,193,660,664) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.001101s ] [2022-08-13T16:01:44+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` IN (450,212,208,198,239,257,238,200,242,250,544,545,217,253) [ RunTime:0.000397s ] [2022-08-13T16:01:44+08:00][sql] CONNECT:[ UseTime:0.015682s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000711s ] [2022-08-13T16:01:44+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000693s ] [2022-08-13T16:01:47+08:00][sql] CONNECT:[ UseTime:0.017880s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000760s ] [2022-08-13T16:01:47+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('548',family) ) [ RunTime:0.000444s ] [2022-08-13T16:01:47+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000721s ] [2022-08-13T16:01:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` IN (548,567,568,569,570,571,572,651,652,653,654,663,665) [ RunTime:0.000660s ] [2022-08-13T16:01:47+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` IN (548,567,568,569,570,571,572,651,652,653,654,663,665) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000846s ] [2022-08-13T16:01:47+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` IN (567,568,569,570,571,572,651,652,653,654) [ RunTime:0.000353s ] [2022-08-13T16:01:48+08:00][sql] CONNECT:[ UseTime:0.015843s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:48+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000784s ] [2022-08-13T16:01:48+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('665',family) ) [ RunTime:0.000473s ] [2022-08-13T16:01:48+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000833s ] [2022-08-13T16:01:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` = 665 [ RunTime:0.000583s ] [2022-08-13T16:01:48+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` = 665 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000632s ] [2022-08-13T16:01:50+08:00][sql] CONNECT:[ UseTime:0.015642s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:50+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000703s ] [2022-08-13T16:01:50+08:00][sql] SELECT * FROM `raw_sort` WHERE `parent_id` = 665 LIMIT 1 [ RunTime:0.000410s ] [2022-08-13T16:01:50+08:00][sql] CONNECT:[ UseTime:0.025814s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:50+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000727s ] [2022-08-13T16:01:50+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 665 LIMIT 1 [ RunTime:0.000284s ] [2022-08-13T16:01:50+08:00][sql] CONNECT:[ UseTime:0.028052s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:50+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000757s ] [2022-08-13T16:01:50+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('665',family) ) [ RunTime:0.000423s ] [2022-08-13T16:01:50+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000707s ] [2022-08-13T16:01:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` = 665 [ RunTime:0.000576s ] [2022-08-13T16:01:50+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` = 665 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000562s ] [2022-08-13T16:01:51+08:00][sql] CONNECT:[ UseTime:0.012740s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:51+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000744s ] [2022-08-13T16:01:51+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('665',family) ) [ RunTime:0.000443s ] [2022-08-13T16:01:51+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000753s ] [2022-08-13T16:01:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` = 665 AND `type` LIKE '%其它部件%' [ RunTime:0.000659s ] [2022-08-13T16:01:51+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` = 665 AND `type` LIKE '%其它部件%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000598s ] [2022-08-13T16:01:53+08:00][sql] CONNECT:[ UseTime:0.015541s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:53+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000736s ] [2022-08-13T16:01:53+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('665',family) ) [ RunTime:0.000447s ] [2022-08-13T16:01:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000755s ] [2022-08-13T16:01:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` = 665 AND `type` LIKE '%其它部件%' AND `specs` LIKE '%-%' [ RunTime:0.000613s ] [2022-08-13T16:01:53+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` = 665 AND `type` LIKE '%其它部件%' AND `specs` LIKE '%-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000599s ] [2022-08-13T16:01:59+08:00][sql] CONNECT:[ UseTime:0.029352s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:01:59+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000751s ] [2022-08-13T16:01:59+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('665',family) ) [ RunTime:0.000435s ] [2022-08-13T16:01:59+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000727s ] [2022-08-13T16:01:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` = 665 AND `type` LIKE '%其它部件%' AND `specs` LIKE '%-%' [ RunTime:0.000630s ] [2022-08-13T16:01:59+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` = 665 AND `type` LIKE '%其它部件%' AND `specs` LIKE '%-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000582s ] [2022-08-13T16:02:01+08:00][sql] CONNECT:[ UseTime:0.017108s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:02:01+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000727s ] [2022-08-13T16:02:01+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` = 665 AND `type` = '其它部件' AND `specs` = '-' [ RunTime:0.000680s ] [2022-08-13T16:02:01+08:00][sql] INSERT INTO `raw` SET `raw_sort` = 665 , `name` = '其他部品' , `type` = '其它部件' , `specs` = '-' , `unit` = '-' , `remark` = '' , `create_time` = '2022-08-13 16:02:01.014906' , `update_time` = '2022-08-13 16:02:01.014931' [ RunTime:0.000241s ] [2022-08-13T16:02:01+08:00][sql] CONNECT:[ UseTime:0.020104s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2022-08-13T16:02:01+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000737s ] [2022-08-13T16:02:01+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('665',family) ) [ RunTime:0.000409s ] [2022-08-13T16:02:01+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.007211s ] [2022-08-13T16:02:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` = 665 [ RunTime:0.000585s ] [2022-08-13T16:02:01+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` = 665 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000555s ] [2022-08-13T16:02:01+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 665 [ RunTime:0.000295s ]