[2024-09-02T14:29:31+08:00][sql] CONNECT:[ UseTime:0.008778s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T14:29:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001170s ] [2024-09-02T14:29:31+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.022695s ] [2024-09-02T14:29:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001506s ] [2024-09-02T15:19:02+08:00][sql] CONNECT:[ UseTime:0.001929s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:02+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001114s ] [2024-09-02T15:19:02+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000891s ] [2024-09-02T15:19:03+08:00][sql] CONNECT:[ UseTime:0.006815s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:03+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001100s ] [2024-09-02T15:19:03+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('8',family) ) [ RunTime:0.000788s ] [2024-09-02T15:19:03+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000757s ] [2024-09-02T15:19:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `raw_sort` IN (8,731,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,660,664,730,694,715,720,721,723,724,725,726,728,729,732,733,734,735,736,737,738,739,740,742,743,744,745,746,748,749,750,751,752,755,756,757,758,759,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,788,790,791,792,793,794,795,796,797,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,833,834,835,836,837,838,839,840,841,842,843,844,845,850,851,852,854,855,856,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,895,896,901,902,914,915,916,917,918,929,961,966,968,999,1011,1012,1013,1014,1015,1016,1018,1019) [ RunTime:0.002014s ] [2024-09-02T15:19:03+08:00][sql] SELECT * FROM `raw` WHERE `raw_sort` IN (8,731,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,660,664,730,694,715,720,721,723,724,725,726,728,729,732,733,734,735,736,737,738,739,740,742,743,744,745,746,748,749,750,751,752,755,756,757,758,759,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,788,790,791,792,793,794,795,796,797,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,833,834,835,836,837,838,839,840,841,842,843,844,845,850,851,852,854,855,856,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,895,896,901,902,914,915,916,917,918,929,961,966,968,999,1011,1012,1013,1014,1015,1016,1018,1019) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002619s ] [2024-09-02T15:19:03+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.000600s ] [2024-09-02T15:19:07+08:00][sql] CONNECT:[ UseTime:0.006702s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000772s ] [2024-09-02T15:19:07+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003782s ] [2024-09-02T15:19:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001373s ] [2024-09-02T15:19:15+08:00][sql] CONNECT:[ UseTime:0.000912s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:15+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000695s ] [2024-09-02T15:19:15+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000858s ] [2024-09-02T15:19:27+08:00][sql] CONNECT:[ UseTime:0.011020s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:27+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001287s ] [2024-09-02T15:19:27+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%消%' AND `title` LIKE '%防%' [ RunTime:0.000686s ] [2024-09-02T15:19:34+08:00][sql] CONNECT:[ UseTime:0.011764s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:34+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001171s ] [2024-09-02T15:19:34+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%消%' AND `title` LIKE '%防%' AND `title` LIKE '%卷%' AND `title` LIKE '%帘%' [ RunTime:0.000637s ] [2024-09-02T15:19:38+08:00][sql] CONNECT:[ UseTime:0.008283s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:38+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000714s ] [2024-09-02T15:19:38+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%消%' AND `title` LIKE '%防%' AND `title` LIKE '%卷%' AND `title` LIKE '%帘%' AND `title` LIKE '%毯%' [ RunTime:0.000608s ] [2024-09-02T15:19:41+08:00][sql] CONNECT:[ UseTime:0.010012s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:41+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000728s ] [2024-09-02T15:19:41+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000834s ] [2024-09-02T15:19:41+08:00][sql] INSERT INTO `raw_sort` SET `title` = '消防卷帘毯' , `order` = 0 , `remark` = '' , `parent_id` = 351 , `create_time` = '2024-09-02 15:19:41.890926' , `update_time` = '2024-09-02 15:19:41.890948' [ RunTime:0.000343s ] [2024-09-02T15:19:41+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 351 LIMIT 1 [ RunTime:0.000227s ] [2024-09-02T15:19:41+08:00][sql] UPDATE `raw_sort` SET `family` = '12,351,1020' , `update_time` = '2024-09-02 15:19:41.892264' WHERE `id` = 1020 [ RunTime:0.000234s ] [2024-09-02T15:19:43+08:00][sql] CONNECT:[ UseTime:0.015266s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:19:43+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000745s ] [2024-09-02T15:19:43+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000871s ] [2024-09-02T15:20:32+08:00][sql] CONNECT:[ UseTime:0.000947s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:20:32+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001154s ] [2024-09-02T15:20:32+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%消%' AND `title` LIKE '%防%' AND `title` LIKE '%卷%' AND `title` LIKE '%帘%' AND `title` LIKE '%毯%' [ RunTime:0.000648s ] [2024-09-02T15:20:33+08:00][sql] CONNECT:[ UseTime:0.013910s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:20:33+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000720s ] [2024-09-02T15:20:33+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000796s ] [2024-09-02T15:20:40+08:00][sql] CONNECT:[ UseTime:0.006103s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:20:40+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000749s ] [2024-09-02T15:20:40+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%防%' AND `title` LIKE '%火%' [ RunTime:0.000634s ] [2024-09-02T15:20:41+08:00][sql] CONNECT:[ UseTime:0.000909s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:20:41+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001131s ] [2024-09-02T15:20:41+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%防%' AND `title` LIKE '%火%' AND `title` LIKE '%装%' AND `title` LIKE '%饰%' [ RunTime:0.000669s ] [2024-09-02T15:20:42+08:00][sql] CONNECT:[ UseTime:0.005022s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:20:42+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001141s ] [2024-09-02T15:20:42+08:00][sql] SELECT * FROM `raw_sort` WHERE `title` LIKE '%防%' AND `title` LIKE '%火%' AND `title` LIKE '%装%' AND `title` LIKE '%饰%' AND `title` LIKE '%布%' [ RunTime:0.000917s ] [2024-09-02T15:20:44+08:00][sql] CONNECT:[ UseTime:0.007695s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:20:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000729s ] [2024-09-02T15:20:44+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000907s ] [2024-09-02T15:20:44+08:00][sql] INSERT INTO `raw_sort` SET `title` = '防火装饰布' , `order` = 0 , `remark` = '' , `parent_id` = 12 , `create_time` = '2024-09-02 15:20:44.231457' , `update_time` = '2024-09-02 15:20:44.231480' [ RunTime:0.000373s ] [2024-09-02T15:20:44+08:00][sql] SELECT `family` FROM `raw_sort` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000251s ] [2024-09-02T15:20:44+08:00][sql] UPDATE `raw_sort` SET `family` = '12,1021' , `update_time` = '2024-09-02 15:20:44.232747' WHERE `id` = 1021 [ RunTime:0.000222s ] [2024-09-02T15:20:44+08:00][sql] CONNECT:[ UseTime:0.008194s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-09-02T15:20:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000714s ] [2024-09-02T15:20:44+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000868s ]