[2024-10-15T10:35:28+08:00][sql] CONNECT:[ UseTime:0.000996s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:35:28+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000679s ]
[2024-10-15T10:35:28+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000843s ]
[2024-10-15T10:35:29+08:00][sql] CONNECT:[ UseTime:0.008921s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:35:29+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001199s ]
[2024-10-15T10:35:29+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('8',family) ) [ RunTime:0.000640s ]
[2024-10-15T10:35:29+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001226s ]
[2024-10-15T10:35:29+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,1022) [ RunTime:0.002089s ]
[2024-10-15T10:35:29+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,1022) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002688s ]
[2024-10-15T10:35:29+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.000556s ]
[2024-10-15T10:35:32+08:00][sql] CONNECT:[ UseTime:0.000898s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:35:32+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001264s ]
[2024-10-15T10:35:32+08:00][sql] SELECT * FROM `raw_sort` WHERE  `parent_id` = 8 LIMIT 1 [ RunTime:0.000329s ]
[2024-10-15T10:35:42+08:00][sql] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:35:42+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001144s ]
[2024-10-15T10:35:42+08:00][sql] SELECT * FROM `raw_sort` WHERE  `parent_id` = 8 LIMIT 1 [ RunTime:0.000400s ]
[2024-10-15T10:35:54+08:00][sql] CONNECT:[ UseTime:0.007216s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:35:54+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000731s ]
[2024-10-15T10:35:54+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('4',family) ) [ RunTime:0.000573s ]
[2024-10-15T10:35:54+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000974s ]
[2024-10-15T10:35:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE  `raw_sort` IN (4,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,71,72,73,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,153,154,155,156,490,493,497,516,517,518,519,520,522,524,526,528,529,530,531,532,533,541,546,549,550,551,552,555,556,557,558,559,560,561,565,592,600,614,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,636,637,638,639,640,641,642,643,193,661,671,675,681,682,683,685,687,689,690,691,692,693,695,696,894,897,898,900,903,904,905,906,909,910,911,913,944,945,946,947,948,951,971,973,990,998,1007) [ RunTime:0.001781s ]
[2024-10-15T10:35:54+08:00][sql] SELECT * FROM `raw` WHERE  `raw_sort` IN (4,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,71,72,73,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,153,154,155,156,490,493,497,516,517,518,519,520,522,524,526,528,529,530,531,532,533,541,546,549,550,551,552,555,556,557,558,559,560,561,565,592,600,614,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,636,637,638,639,640,641,642,643,193,661,671,675,681,682,683,685,687,689,690,691,692,693,695,696,894,897,898,900,903,904,905,906,909,910,911,913,944,945,946,947,948,951,971,973,990,998,1007) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002156s ]
[2024-10-15T10:35:54+08:00][sql] SELECT * FROM `raw_sort` WHERE  `id` IN (144,122,140,139,137,133,141,134,82,127,67,57,77,59,84,90,91,136) [ RunTime:0.000446s ]
[2024-10-15T10:35:56+08:00][sql] CONNECT:[ UseTime:0.008014s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:35:56+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001209s ]
[2024-10-15T10:35:56+08:00][sql] SELECT * FROM `raw_sort` WHERE  `parent_id` = 4 LIMIT 1 [ RunTime:0.000351s ]
[2024-10-15T10:36:06+08:00][sql] CONNECT:[ UseTime:0.000871s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:36:06+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000719s ]
[2024-10-15T10:36:06+08:00][sql] SELECT * FROM `raw_sort` WHERE  `parent_id` = 4 LIMIT 1 [ RunTime:0.000345s ]
[2024-10-15T10:36:10+08:00][sql] CONNECT:[ UseTime:0.009326s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:36:10+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001208s ]
[2024-10-15T10:36:10+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('4',family) ) [ RunTime:0.000595s ]
[2024-10-15T10:36:10+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000533s ]
[2024-10-15T10:36:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE  `raw_sort` IN (4,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,71,72,73,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,153,154,155,156,490,493,497,516,517,518,519,520,522,524,526,528,529,530,531,532,533,541,546,549,550,551,552,555,556,557,558,559,560,561,565,592,600,614,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,636,637,638,639,640,641,642,643,193,661,671,675,681,682,683,685,687,689,690,691,692,693,695,696,894,897,898,900,903,904,905,906,909,910,911,913,944,945,946,947,948,951,971,973,990,998,1007) [ RunTime:0.001701s ]
[2024-10-15T10:36:10+08:00][sql] SELECT * FROM `raw` WHERE  `raw_sort` IN (4,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,71,72,73,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,153,154,155,156,490,493,497,516,517,518,519,520,522,524,526,528,529,530,531,532,533,541,546,549,550,551,552,555,556,557,558,559,560,561,565,592,600,614,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,636,637,638,639,640,641,642,643,193,661,671,675,681,682,683,685,687,689,690,691,692,693,695,696,894,897,898,900,903,904,905,906,909,910,911,913,944,945,946,947,948,951,971,973,990,998,1007) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002073s ]
[2024-10-15T10:36:10+08:00][sql] SELECT * FROM `raw_sort` WHERE  `id` IN (144,122,140,139,137,133,141,134,82,127,67,57,77,59,84,90,91,136) [ RunTime:0.000424s ]
[2024-10-15T10:36:23+08:00][sql] CONNECT:[ UseTime:0.002972s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:36:23+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001221s ]
[2024-10-15T10:36:23+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('143',family) ) [ RunTime:0.000581s ]
[2024-10-15T10:36:23+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000567s ]
[2024-10-15T10:36:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE  `raw_sort` IN (143,549,550,551,894) [ RunTime:0.001209s ]
[2024-10-15T10:36:23+08:00][sql] SELECT * FROM `raw` WHERE  `raw_sort` IN (143,549,550,551,894) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.001287s ]
[2024-10-15T10:36:23+08:00][sql] SELECT * FROM `raw_sort` WHERE  `id` IN (549,550,551,894,143) [ RunTime:0.000354s ]
[2024-10-15T10:36:25+08:00][sql] CONNECT:[ UseTime:0.009833s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:36:25+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000713s ]
[2024-10-15T10:36:25+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('143',family) ) [ RunTime:0.000530s ]
[2024-10-15T10:36:25+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000543s ]
[2024-10-15T10:36:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE  `raw_sort` IN (143,549,550,551,894) [ RunTime:0.001114s ]
[2024-10-15T10:36:25+08:00][sql] SELECT * FROM `raw` WHERE  `raw_sort` IN (143,549,550,551,894) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.001203s ]
[2024-10-15T10:36:25+08:00][sql] SELECT * FROM `raw_sort` WHERE  `id` IN (549,550,551,894,143) [ RunTime:0.000305s ]
[2024-10-15T10:36:29+08:00][sql] CONNECT:[ UseTime:0.009237s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:36:29+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000669s ]
[2024-10-15T10:36:29+08:00][sql] SELECT * FROM `raw_sort` WHERE  `parent_id` = 143 LIMIT 1 [ RunTime:0.000382s ]
[2024-10-15T10:36:47+08:00][sql] CONNECT:[ UseTime:0.013315s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:36:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000704s ]
[2024-10-15T10:36:47+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000882s ]
[2024-10-15T10:37:09+08:00][sql] CONNECT:[ UseTime:0.010274s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:37:09+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000695s ]
[2024-10-15T10:37:09+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%二%'  AND `title` LIKE '%氧%'  AND `title` LIKE '%化%'  AND `title` LIKE '%碳%' [ RunTime:0.000602s ]
[2024-10-15T10:37:12+08:00][sql] CONNECT:[ UseTime:0.001629s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:37:12+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000702s ]
[2024-10-15T10:37: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 '%火%'  AND `title` LIKE '%器%' [ RunTime:0.000608s ]
[2024-10-15T10:37:13+08:00][sql] CONNECT:[ UseTime:0.012807s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:37:13+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001263s ]
[2024-10-15T10:37:13+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 '%器%'  AND `title` LIKE '%阀%'  AND `title` LIKE '%门%' [ RunTime:0.000673s ]
[2024-10-15T10:37:16+08:00][sql] CONNECT:[ UseTime:0.005906s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:37:16+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000709s ]
[2024-10-15T10:37:16+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000817s ]
[2024-10-15T10:37:16+08:00][sql] INSERT INTO `raw_sort` SET `title` = '二氧化碳灭火器阀门' , `order` = 0 , `remark` = '' , `parent_id` = 4 , `create_time` = '2024-10-15 10:37:16.578538' , `update_time` = '2024-10-15 10:37:16.578560' [ RunTime:0.000376s ]
[2024-10-15T10:37:16+08:00][sql] SELECT `family` FROM `raw_sort` WHERE  `id` = 4 LIMIT 1 [ RunTime:0.000220s ]
[2024-10-15T10:37:16+08:00][sql] UPDATE `raw_sort`  SET `family` = '4,1033' , `update_time` = '2024-10-15 10:37:16.579783'  WHERE  `id` = 1033 [ RunTime:0.000212s ]
[2024-10-15T10:37:17+08:00][sql] CONNECT:[ UseTime:0.008174s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:37:17+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000710s ]
[2024-10-15T10:37:17+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000861s ]
[2024-10-15T10:37:23+08:00][sql] CONNECT:[ UseTime:0.000809s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:37:23+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000715s ]
[2024-10-15T10:37:23+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000824s ]
[2024-10-15T10:38:26+08:00][sql] CONNECT:[ UseTime:0.013302s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:38:26+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000718s ]
[2024-10-15T10:38:26+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000857s ]
[2024-10-15T10:38:58+08:00][sql] CONNECT:[ UseTime:0.002302s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:38:58+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000688s ]
[2024-10-15T10:38:58+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%二%'  AND `title` LIKE '%氧%'  AND `title` LIKE '%化%'  AND `title` LIKE '%碳%' [ RunTime:0.000609s ]
[2024-10-15T10:39:10+08:00][sql] CONNECT:[ UseTime:0.004076s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:39:10+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000745s ]
[2024-10-15T10:39:10+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%二%'  AND `title` LIKE '%氧%'  AND `title` LIKE '%化%'  AND `title` LIKE '%碳%'  AND `title` LIKE '%喷%' [ RunTime:0.000685s ]
[2024-10-15T10:39:17+08:00][sql] CONNECT:[ UseTime:0.014404s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:39:17+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000727s ]
[2024-10-15T10:39:17+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.001062s ]
[2024-10-15T10:39:28+08:00][sql] CONNECT:[ UseTime:0.011895s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:39:28+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000784s ]
[2024-10-15T10:39: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 '%火%'  AND `title` LIKE '%器%'  AND `title` LIKE '%喷%'  AND `title` LIKE '%筒%' [ RunTime:0.000684s ]
[2024-10-15T10:39:31+08:00][sql] CONNECT:[ UseTime:0.015233s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:39:31+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000733s ]
[2024-10-15T10:39:31+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000822s ]
[2024-10-15T10:39:31+08:00][sql] INSERT INTO `raw_sort` SET `title` = '二氧化碳灭火器喷筒' , `order` = 0 , `remark` = '' , `parent_id` = 6 , `create_time` = '2024-10-15 10:39:31.534008' , `update_time` = '2024-10-15 10:39:31.534039' [ RunTime:0.000371s ]
[2024-10-15T10:39:31+08:00][sql] SELECT `family` FROM `raw_sort` WHERE  `id` = 6 LIMIT 1 [ RunTime:0.000242s ]
[2024-10-15T10:39:31+08:00][sql] UPDATE `raw_sort`  SET `family` = '6,1034' , `update_time` = '2024-10-15 10:39:31.535281'  WHERE  `id` = 1034 [ RunTime:0.000234s ]
[2024-10-15T10:39:32+08:00][sql] CONNECT:[ UseTime:0.005990s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:39:32+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000679s ]
[2024-10-15T10:39:32+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000841s ]
[2024-10-15T10:39:37+08:00][sql] CONNECT:[ UseTime:0.011140s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:39:37+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000757s ]
[2024-10-15T10:39:37+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000875s ]
[2024-10-15T10:52:17+08:00][sql] CONNECT:[ UseTime:0.000882s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:17+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000689s ]
[2024-10-15T10:52:17+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000879s ]
[2024-10-15T10:52:18+08:00][sql] CONNECT:[ UseTime:0.009506s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:18+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000717s ]
[2024-10-15T10:52:18+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('8',family) ) [ RunTime:0.000591s ]
[2024-10-15T10:52:18+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000555s ]
[2024-10-15T10:52:18+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,1022) [ RunTime:0.002014s ]
[2024-10-15T10:52:18+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,1022) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002707s ]
[2024-10-15T10:52:18+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.000417s ]
[2024-10-15T10:52:30+08:00][sql] CONNECT:[ UseTime:0.000851s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:30+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000701s ]
[2024-10-15T10:52:30+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('2',family) ) [ RunTime:0.000545s ]
[2024-10-15T10:52:30+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000994s ]
[2024-10-15T10:52:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE  `raw_sort` IN (2,26,452,454,476) [ RunTime:0.001179s ]
[2024-10-15T10:52:30+08:00][sql] SELECT * FROM `raw` WHERE  `raw_sort` IN (2,26,452,454,476) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.001238s ]
[2024-10-15T10:52:30+08:00][sql] SELECT * FROM `raw_sort` WHERE  `id` IN (26,476,452,2) [ RunTime:0.000311s ]
[2024-10-15T10:52:31+08:00][sql] CONNECT:[ UseTime:0.006945s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:31+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000694s ]
[2024-10-15T10:52:31+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('452',family) ) [ RunTime:0.000557s ]
[2024-10-15T10:52:31+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000920s ]
[2024-10-15T10:52:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE  `raw_sort` IN (26,452,454) [ RunTime:0.001195s ]
[2024-10-15T10:52:31+08:00][sql] SELECT * FROM `raw` WHERE  `raw_sort` IN (26,452,454) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.001187s ]
[2024-10-15T10:52:31+08:00][sql] SELECT * FROM `raw_sort` WHERE  `id` IN (26,452) [ RunTime:0.000272s ]
[2024-10-15T10:52:36+08:00][sql] CONNECT:[ UseTime:0.014538s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:36+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000676s ]
[2024-10-15T10:52:36+08:00][sql] SELECT * FROM `raw_sort` WHERE  `parent_id` = 452 LIMIT 1 [ RunTime:0.000306s ]
[2024-10-15T10:52:45+08:00][sql] CONNECT:[ UseTime:0.008324s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:45+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000714s ]
[2024-10-15T10:52:45+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000889s ]
[2024-10-15T10:52:51+08:00][sql] CONNECT:[ UseTime:0.000803s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:51+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000698s ]
[2024-10-15T10:52:51+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%C%' [ RunTime:0.000588s ]
[2024-10-15T10:52:55+08:00][sql] CONNECT:[ UseTime:0.012345s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:55+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000743s ]
[2024-10-15T10:52:55+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%C%'  AND `title` LIKE '%O%' [ RunTime:0.000630s ]
[2024-10-15T10:52:56+08:00][sql] CONNECT:[ UseTime:0.000883s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:52:56+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000872s ]
[2024-10-15T10:52:56+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%C%'  AND `title` LIKE '%O%'  AND `title` LIKE '%2%' [ RunTime:0.000773s ]
[2024-10-15T10:53:00+08:00][sql] CONNECT:[ UseTime:0.009243s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:53:00+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000719s ]
[2024-10-15T10:53:00+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%C%'  AND `title` LIKE '%O%'  AND `title` LIKE '%2%'  AND `title` LIKE '%带%' [ RunTime:0.000623s ]
[2024-10-15T10:53:02+08:00][sql] CONNECT:[ UseTime:0.012216s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:53:02+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000694s ]
[2024-10-15T10:53:02+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%C%'  AND `title` LIKE '%O%'  AND `title` LIKE '%2%'  AND `title` LIKE '%带%'  AND `title` LIKE '%木%'  AND `title` LIKE '%柄%' [ RunTime:0.000630s ]
[2024-10-15T10:53:06+08:00][sql] CONNECT:[ UseTime:0.011145s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:53:06+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000716s ]
[2024-10-15T10:53:06+08:00][sql] SELECT * FROM `raw_sort` WHERE  `title` LIKE '%C%'  AND `title` LIKE '%O%'  AND `title` LIKE '%2%'  AND `title` LIKE '%带%'  AND `title` LIKE '%木%'  AND `title` LIKE '%柄%'  AND `title` LIKE '%喷%'  AND `title` LIKE '%枪%' [ RunTime:0.000629s ]
[2024-10-15T10:53:08+08:00][sql] CONNECT:[ UseTime:0.000778s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:53:08+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000685s ]
[2024-10-15T10:53:08+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000796s ]
[2024-10-15T10:53:08+08:00][sql] INSERT INTO `raw_sort` SET `title` = 'CO2带木柄喷枪' , `order` = 0 , `remark` = '' , `parent_id` = 2 , `create_time` = '2024-10-15 10:53:08.969528' , `update_time` = '2024-10-15 10:53:08.969552' [ RunTime:0.000478s ]
[2024-10-15T10:53:08+08:00][sql] SELECT `family` FROM `raw_sort` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000249s ]
[2024-10-15T10:53:08+08:00][sql] UPDATE `raw_sort`  SET `family` = '2,1035' , `update_time` = '2024-10-15 10:53:08.970938'  WHERE  `id` = 1035 [ RunTime:0.000224s ]
[2024-10-15T10:53:09+08:00][sql] CONNECT:[ UseTime:0.000852s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T10:53:09+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000703s ]
[2024-10-15T10:53:09+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000852s ]
[2024-10-15T18:00:54+08:00][sql] CONNECT:[ UseTime:0.015115s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-10-15T18:00:54+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001239s ]
[2024-10-15T18:00:54+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003709s ]
[2024-10-15T18:00:54+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001568s ]