[2024-03-11T11:01:06+08:00][sql] CONNECT:[ UseTime:0.009368s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-03-11T11:01:06+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000835s ]
[2024-03-11T11:01:06+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.004161s ]
[2024-03-11T11:01:06+08:00][sql] CONNECT:[ UseTime:0.008802s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-03-11T11:01:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001808s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000217s ]
[2024-03-11T11:01:06+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.019178s ]
[2024-03-11T11:01:06+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.021854s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 1 LIMIT 1 [ RunTime:0.018142s ]
[2024-03-11T11:01:06+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.023022s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7274 [ RunTime:0.070512s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7274  AND `status` = 0 [ RunTime:0.011697s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 2 LIMIT 1 [ RunTime:0.000774s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7275 [ RunTime:0.010276s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7275  AND `status` = 0 [ RunTime:0.011737s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 3 LIMIT 1 [ RunTime:0.000988s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000242s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000169s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 4 LIMIT 1 [ RunTime:0.000639s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000160s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000191s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 5 LIMIT 1 [ RunTime:0.000576s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000204s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000149s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 6 LIMIT 1 [ RunTime:0.000596s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000156s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000193s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 7 LIMIT 1 [ RunTime:0.000577s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000183s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000152s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 8 LIMIT 1 [ RunTime:0.000621s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000156s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000184s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 9 LIMIT 1 [ RunTime:0.000562s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7073 [ RunTime:0.009932s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7073  AND `status` = 0 [ RunTime:0.012122s ]
[2024-03-11T11:01:06+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 10 LIMIT 1 [ RunTime:0.000768s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000267s ]
[2024-03-11T11:01:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000195s ]
[2024-03-11T14:35:22+08:00][sql] CONNECT:[ UseTime:0.005256s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-03-11T14:35:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001213s ]
[2024-03-11T14:35:22+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003698s ]
[2024-03-11T14:35:22+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001402s ]
[2024-03-11T15:38:19+08:00][sql] CONNECT:[ UseTime:0.000917s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-03-11T15:38:19+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001171s ]
[2024-03-11T15:38:19+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000839s ]
[2024-03-11T15:43:15+08:00][sql] CONNECT:[ UseTime:0.013332s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-03-11T15:43:15+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001159s ]
[2024-03-11T15:43:15+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%冷%'  AND `title` LIKE '%轧%'  AND `title` LIKE '%热%'  AND `title` LIKE '%镀%'  AND `title` LIKE '%锌%'  AND `title` LIKE '%钢%'  AND `title` LIKE '%板%' [ RunTime:0.000588s ]
[2024-03-11T15:43:15+08:00][sql] CONNECT:[ UseTime:0.006699s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-03-11T15:43:15+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001186s ]
[2024-03-11T15:43:15+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000766s ]
[2024-03-11T15:43:15+08:00][sql] INSERT INTO `raw_sort` SET `title` = '冷轧热镀锌钢板' , `order` = 0 , `remark` = '' , `parent_id` = 8 , `create_time` = '2024-03-11 15:43:15.879689' , `update_time` = '2024-03-11 15:43:15.879711' [ RunTime:0.000335s ]
[2024-03-11T15:43:15+08:00][sql] SELECT `family` FROM `raw_sort` WHERE  `id` = 8 LIMIT 1 [ RunTime:0.000244s ]
[2024-03-11T15:43:15+08:00][sql] UPDATE `raw_sort`  SET `family` = '8,961' , `update_time` = '2024-03-11 15:43:15.881016'  WHERE  `id` = 961 [ RunTime:0.000216s ]
[2024-03-11T15:43:16+08:00][sql] CONNECT:[ UseTime:0.004011s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-03-11T15:43:16+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001200s ]
[2024-03-11T15:43:16+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000785s ]