[2024-09-04T14:20:26+08:00][sql] CONNECT:[ UseTime:0.013753s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:26+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000722s ] [2024-09-04T14:20:26+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003477s ] [2024-09-04T14:20:27+08:00][sql] CONNECT:[ UseTime:0.010048s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:27+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000711s ] [2024-09-04T14:20:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000205s ] [2024-09-04T14:20:27+08:00][sql] SELECT * FROM `product` ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.197119s ] [2024-09-04T14:20:27+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000745s ] [2024-09-04T14:20:27+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000413s ] [2024-09-04T14:20:30+08:00][sql] CONNECT:[ UseTime:0.006872s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:30+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001183s ] [2024-09-04T14:20:30+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000945s ] [2024-09-04T14:20:38+08:00][sql] CONNECT:[ UseTime:0.010488s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:38+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001192s ] [2024-09-04T14:20:38+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%吃%' [ RunTime:0.000604s ] [2024-09-04T14:20:39+08:00][sql] CONNECT:[ UseTime:0.015025s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:39+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001218s ] [2024-09-04T14:20:39+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000944s ] [2024-09-04T14:20:44+08:00][sql] CONNECT:[ UseTime:0.008111s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001154s ] [2024-09-04T14:20:44+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%控%' AND `title` LIKE '%制%' AND `title` LIKE '%箱%' AND `title` LIKE '%壳%' AND `title` LIKE '%体%' [ RunTime:0.000646s ] [2024-09-04T14:20:44+08:00][sql] CONNECT:[ UseTime:0.015120s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000749s ] [2024-09-04T14:20:44+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000847s ] [2024-09-04T14:20:44+08:00][sql] INSERT INTO `raw_sort` SET `title` = '控制箱壳体' , `order` = 0 , `remark` = '' , `parent_id` = 8 , `create_time` = '2024-09-04 14:20:44.902924' , `update_time` = '2024-09-04 14:20:44.902948' [ RunTime:0.000391s ] [2024-09-04T14:20:44+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000274s ] [2024-09-04T14:20:44+08:00][sql] UPDATE `raw_sort` SET `family` = '8,1022' , `update_time` = '2024-09-04 14:20:44.904278' WHERE `id` = 1022 [ RunTime:0.000220s ] [2024-09-04T14:20:45+08:00][sql] CONNECT:[ UseTime:0.004898s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:20:45+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001187s ] [2024-09-04T14:20:45+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000914s ] [2024-09-04T14:22:35+08:00][sql] CONNECT:[ UseTime:0.005539s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:22:35+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000902s ] [2024-09-04T14:22:35+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 '%关%' [ RunTime:0.000669s ] [2024-09-04T14:22:35+08:00][sql] CONNECT:[ UseTime:0.001047s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:22:35+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000689s ] [2024-09-04T14:22:35+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000882s ] [2024-09-04T14:22:35+08:00][sql] INSERT INTO `raw_sort` SET `title` = '控制保护开关' , `order` = 0 , `remark` = '' , `parent_id` = 13 , `create_time` = '2024-09-04 14:22:35.944657' , `update_time` = '2024-09-04 14:22:35.944680' [ RunTime:0.000384s ] [2024-09-04T14:22:35+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000241s ] [2024-09-04T14:22:35+08:00][sql] UPDATE `raw_sort` SET `family` = '13,1023' , `update_time` = '2024-09-04 14:22:35.945986' WHERE `id` = 1023 [ RunTime:0.000218s ] [2024-09-04T14:22:36+08:00][sql] CONNECT:[ UseTime:0.002645s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:22:36+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001184s ] [2024-09-04T14:22:36+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000884s ] [2024-09-04T14:24:33+08:00][sql] CONNECT:[ UseTime:0.014889s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:24:33+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000740s ] [2024-09-04T14:24:33+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 '%灯%' [ RunTime:0.000613s ] [2024-09-04T14:24:34+08:00][sql] CONNECT:[ UseTime:0.013852s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:24:34+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000755s ] [2024-09-04T14:24:34+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000882s ] [2024-09-04T14:24:34+08:00][sql] INSERT INTO `raw_sort` SET `title` = '按钮、指示灯' , `order` = 0 , `remark` = '' , `parent_id` = 13 , `create_time` = '2024-09-04 14:24:34.619633' , `update_time` = '2024-09-04 14:24:34.619657' [ RunTime:0.000370s ] [2024-09-04T14:24:34+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000279s ] [2024-09-04T14:24:34+08:00][sql] UPDATE `raw_sort` SET `family` = '13,1024' , `update_time` = '2024-09-04 14:24:34.620975' WHERE `id` = 1024 [ RunTime:0.000232s ] [2024-09-04T14:24:35+08:00][sql] CONNECT:[ UseTime:0.011363s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:24:35+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000705s ] [2024-09-04T14:24:35+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000890s ] [2024-09-04T14:26:11+08:00][sql] CONNECT:[ UseTime:0.016176s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:26:11+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000694s ] [2024-09-04T14:26:11+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%导%' AND `title` LIKE '%线%' AND `title` LIKE '%及%' AND `title` LIKE '%电%' AND `title` LIKE '%缆%' [ RunTime:0.000641s ] [2024-09-04T14:26:12+08:00][sql] CONNECT:[ UseTime:0.010256s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:26:12+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000725s ] [2024-09-04T14:26:12+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000792s ] [2024-09-04T14:26:12+08:00][sql] INSERT INTO `raw_sort` SET `title` = '导线及电缆' , `order` = 0 , `remark` = '' , `parent_id` = 13 , `create_time` = '2024-09-04 14:26:12.268294' , `update_time` = '2024-09-04 14:26:12.268324' [ RunTime:0.000347s ] [2024-09-04T14:26:12+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000254s ] [2024-09-04T14:26:12+08:00][sql] UPDATE `raw_sort` SET `family` = '13,1025' , `update_time` = '2024-09-04 14:26:12.269627' WHERE `id` = 1025 [ RunTime:0.000218s ] [2024-09-04T14:26:12+08:00][sql] CONNECT:[ UseTime:0.014240s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:26:12+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000779s ] [2024-09-04T14:26:12+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000883s ] [2024-09-04T14:27:12+08:00][sql] CONNECT:[ UseTime:0.007450s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:27:12+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000690s ] [2024-09-04T14:27:12+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 '%器%' [ RunTime:0.000642s ] [2024-09-04T14:27:13+08:00][sql] CONNECT:[ UseTime:0.012172s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:27:13+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000750s ] [2024-09-04T14:27:13+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000847s ] [2024-09-04T14:27:13+08:00][sql] INSERT INTO `raw_sort` SET `title` = '消防泵控制器' , `order` = 0 , `remark` = '' , `parent_id` = 13 , `create_time` = '2024-09-04 14:27:13.015482' , `update_time` = '2024-09-04 14:27:13.015514' [ RunTime:0.000371s ] [2024-09-04T14:27:13+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000257s ] [2024-09-04T14:27:13+08:00][sql] UPDATE `raw_sort` SET `family` = '13,1026' , `update_time` = '2024-09-04 14:27:13.016842' WHERE `id` = 1026 [ RunTime:0.000236s ] [2024-09-04T14:27:13+08:00][sql] CONNECT:[ UseTime:0.014123s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:27:13+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000786s ] [2024-09-04T14:27:13+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000921s ] [2024-09-04T14:27:20+08:00][sql] CONNECT:[ UseTime:0.010020s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:27:20+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000714s ] [2024-09-04T14:27:20+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%风%' AND `title` LIKE '%机%' AND `title` LIKE '%控%' AND `title` LIKE '%制%' AND `title` LIKE '%器%' [ RunTime:0.000679s ] [2024-09-04T14:27:20+08:00][sql] CONNECT:[ UseTime:0.006402s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:27:20+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000657s ] [2024-09-04T14:27:20+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000774s ] [2024-09-04T14:27:20+08:00][sql] INSERT INTO `raw_sort` SET `title` = '风机控制器' , `order` = 0 , `remark` = '' , `parent_id` = 13 , `create_time` = '2024-09-04 14:27:20.958098' , `update_time` = '2024-09-04 14:27:20.958122' [ RunTime:0.000349s ] [2024-09-04T14:27:20+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000245s ] [2024-09-04T14:27:20+08:00][sql] UPDATE `raw_sort` SET `family` = '13,1027' , `update_time` = '2024-09-04 14:27:20.959472' WHERE `id` = 1027 [ RunTime:0.000255s ] [2024-09-04T14:27:21+08:00][sql] CONNECT:[ UseTime:0.006763s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:27:21+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000734s ] [2024-09-04T14:27:21+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000900s ] [2024-09-04T14:27:28+08:00][sql] CONNECT:[ UseTime:0.016154s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-04T14:27:28+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000713s ] [2024-09-04T14:27:28+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 '%器%' [ RunTime:0.000671s ]