[2023-08-12T09:58:22+08:00][sql] CONNECT:[ UseTime:0.004889s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T09:58:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001141s ] [2023-08-12T09:58:22+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003871s ] [2023-08-12T09:58:23+08:00][sql] CONNECT:[ UseTime:0.002976s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001220s ] [2023-08-12T09:58:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000250s ] [2023-08-12T09:58:23+08:00][sql] SELECT * FROM `product` ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.179414s ] [2023-08-12T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000848s ] [2023-08-12T09:58:23+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000426s ] [2023-08-12T09:58:32+08:00][sql] CONNECT:[ UseTime:0.002705s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T09:58:32+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000855s ] [2023-08-12T09:58:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE ( `type` LIKE '%消防电气控制装置(%' OR `specs` LIKE '%消防电气控制装置(%' OR `name` LIKE '%消防电气控制装置(%' ) [ RunTime:0.223759s ] [2023-08-12T09:58:32+08:00][sql] SELECT * FROM `product` WHERE ( `type` LIKE '%消防电气控制装置(%' OR `specs` LIKE '%消防电气控制装置(%' OR `name` LIKE '%消防电气控制装置(%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.226817s ] [2023-08-12T09:58:32+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000860s ] [2023-08-12T09:58:32+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (42,389,46) [ RunTime:0.000338s ] [2023-08-12T09:58:33+08:00][sql] CONNECT:[ UseTime:0.010257s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T09:58:33+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000673s ] [2023-08-12T09:58:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE ( `type` LIKE '%消防电气控制装置%' OR `specs` LIKE '%消防电气控制装置%' OR `name` LIKE '%消防电气控制装置%' ) [ RunTime:0.222276s ] [2023-08-12T09:58:33+08:00][sql] SELECT * FROM `product` WHERE ( `type` LIKE '%消防电气控制装置%' OR `specs` LIKE '%消防电气控制装置%' OR `name` LIKE '%消防电气控制装置%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.225652s ] [2023-08-12T09:58:33+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000730s ] [2023-08-12T09:58:33+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (42,389,46,43) [ RunTime:0.000341s ] [2023-08-12T17:46:08+08:00][sql] CONNECT:[ UseTime:0.012586s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T17:46:08+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000726s ] [2023-08-12T17:46:08+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000778s ] [2023-08-12T17:46:54+08:00][sql] CONNECT:[ UseTime:0.004550s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T17:46:54+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000925s ] [2023-08-12T17:46:54+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%爆%' AND `title` LIKE '%破%' [ RunTime:0.000545s ] [2023-08-12T17:46:57+08:00][sql] CONNECT:[ UseTime:0.012717s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T17:46:57+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000691s ] [2023-08-12T17:46:57+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%爆%' AND `title` LIKE '%破%' AND `title` LIKE '%阀%' [ RunTime:0.000581s ] [2023-08-12T17:47:00+08:00][sql] CONNECT:[ UseTime:0.009035s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T17:47:00+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000873s ] [2023-08-12T17:47:00+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000739s ] [2023-08-12T17:47:00+08:00][sql] INSERT INTO `raw_sort` SET `title` = '爆破阀' , `order` = 0 , `remark` = '' , `parent_id` = 143 , `create_time` = '2023-08-12 17:47:00.583219' , `update_time` = '2023-08-12 17:47:00.583240' [ RunTime:0.000358s ] [2023-08-12T17:47:00+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 143 LIMIT 1 [ RunTime:0.000229s ] [2023-08-12T17:47:00+08:00][sql] UPDATE `raw_sort` SET `family` = '4,143,894' , `update_time` = '2023-08-12 17:47:00.584447' WHERE `id` = 894 [ RunTime:0.000238s ] [2023-08-12T17:47:01+08:00][sql] CONNECT:[ UseTime:0.006887s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-08-12T17:47:01+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.006411s ] [2023-08-12T17:47:01+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000801s ]