[2024-03-04T16:55:07+08:00][sql] CONNECT:[ UseTime:0.002685s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:07+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001451s ] [2024-03-04T16:55:07+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000778s ] [2024-03-04T16:55:09+08:00][sql] CONNECT:[ UseTime:0.015629s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:09+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001164s ] [2024-03-04T16:55:09+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000748s ] [2024-03-04T16:55:10+08:00][sql] CONNECT:[ UseTime:0.013606s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:10+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001255s ] [2024-03-04T16:55:10+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('8',family) ) [ RunTime:0.000683s ] [2024-03-04T16:55:10+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001508s ] [2024-03-04T16:55:10+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) [ RunTime:0.001827s ] [2024-03-04T16:55:10+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002395s ] [2024-03-04T16:55:10+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.000586s ] [2024-03-04T16:55:19+08:00][sql] CONNECT:[ UseTime:0.008537s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:19+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001546s ] [2024-03-04T16:55:19+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003851s ] [2024-03-04T16:55:20+08:00][sql] CONNECT:[ UseTime:0.015335s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:20+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001494s ] [2024-03-04T16:55:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000232s ] [2024-03-04T16:55:20+08:00][sql] SELECT * FROM `product` ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.505233s ] [2024-03-04T16:55:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001235s ] [2024-03-04T16:55:20+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000401s ] [2024-03-04T16:55:22+08:00][sql] CONNECT:[ UseTime:0.005024s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:22+08:00][sql] SHOW FULL COLUMNS FROM `certs` [ RunTime:0.001421s ] [2024-03-04T16:55:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `certs` [ RunTime:0.000215s ] [2024-03-04T16:55:22+08:00][sql] SELECT * FROM `certs` ORDER BY `id` ASC LIMIT 0,15 [ RunTime:0.000179s ] [2024-03-04T16:55:22+08:00][sql] CONNECT:[ UseTime:0.007464s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001347s ] [2024-03-04T16:55:22+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003449s ] [2024-03-04T16:55:23+08:00][sql] CONNECT:[ UseTime:0.008271s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001438s ] [2024-03-04T16:55:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000252s ] [2024-03-04T16:55:23+08:00][sql] SELECT * FROM `product` ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.187741s ] [2024-03-04T16:55:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001271s ] [2024-03-04T16:55:23+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000409s ] [2024-03-04T16:55:24+08:00][sql] CONNECT:[ UseTime:0.003743s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001182s ] [2024-03-04T16:55:24+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003574s ] [2024-03-04T16:55:25+08:00][sql] CONNECT:[ UseTime:0.011648s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:25+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001339s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000204s ] [2024-03-04T16:55:25+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000387s ] [2024-03-04T16:55:25+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001454s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000615s ] [2024-03-04T16:55:25+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001489s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000213s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000182s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000584s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000199s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000560s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000153s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000490s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000185s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000150s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000816s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000195s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000139s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000561s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000149s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000167s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000487s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000170s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000477s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000137s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000488s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.057999s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 AND `status` = 0 [ RunTime:0.010976s ] [2024-03-04T16:55:25+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000675s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000214s ] [2024-03-04T16:55:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000170s ] [2024-03-04T16:55:53+08:00][sql] CONNECT:[ UseTime:0.000860s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:53+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001328s ] [2024-03-04T16:55:53+08:00][sql] SELECT * FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000694s ] [2024-03-04T16:55:53+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001295s ] [2024-03-04T16:55:53+08:00][sql] SELECT * FROM `product` WHERE `id` = 9 [ RunTime:0.001436s ] [2024-03-04T16:55:53+08:00][sql] CONNECT:[ UseTime:0.015433s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:55:53+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001330s ] [2024-03-04T16:55:53+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.009663s ] [2024-03-04T16:55:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001286s ] [2024-03-04T16:55:53+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (109,827) [ RunTime:0.000367s ] [2024-03-04T16:56:01+08:00][sql] CONNECT:[ UseTime:0.008275s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:01+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001335s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000263s ] [2024-03-04T16:56:01+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000400s ] [2024-03-04T16:56:01+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001115s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000653s ] [2024-03-04T16:56:01+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001016s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000229s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000196s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000626s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000213s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000231s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000561s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000200s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000181s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000545s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000193s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000188s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000554s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000194s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000204s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000564s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000222s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000193s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000601s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000180s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000162s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000563s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000170s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000520s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.009536s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 AND `status` = 0 [ RunTime:0.011152s ] [2024-03-04T16:56:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000702s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000201s ] [2024-03-04T16:56:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000173s ] [2024-03-04T16:56:03+08:00][sql] CONNECT:[ UseTime:0.008037s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:03+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001382s ] [2024-03-04T16:56:03+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003990s ] [2024-03-04T16:56:04+08:00][sql] CONNECT:[ UseTime:0.000873s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:04+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001235s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000202s ] [2024-03-04T16:56:04+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000328s ] [2024-03-04T16:56:04+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001013s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000634s ] [2024-03-04T16:56:04+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000937s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000190s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000170s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000549s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000168s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000159s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000521s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000188s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000155s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000533s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000184s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000511s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000170s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000148s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000508s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000151s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000140s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000520s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000155s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000519s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000213s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000171s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000508s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.009696s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 AND `status` = 0 [ RunTime:0.011011s ] [2024-03-04T16:56:04+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000663s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000224s ] [2024-03-04T16:56:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:56:06+08:00][sql] CONNECT:[ UseTime:0.015650s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:06+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001241s ] [2024-03-04T16:56:06+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000832s ] [2024-03-04T16:56:07+08:00][sql] CONNECT:[ UseTime:0.012301s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:07+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001225s ] [2024-03-04T16:56:07+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('8',family) ) [ RunTime:0.000579s ] [2024-03-04T16:56:07+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001036s ] [2024-03-04T16:56:07+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) [ RunTime:0.001747s ] [2024-03-04T16:56:07+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002323s ] [2024-03-04T16:56:07+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.000435s ] [2024-03-04T16:56:21+08:00][sql] CONNECT:[ UseTime:0.010611s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:21+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001280s ] [2024-03-04T16:56:21+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('1',family) ) [ RunTime:0.000581s ] [2024-03-04T16:56:21+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000959s ] [2024-03-04T16:56:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (1,2,3,4,5,7,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,163,164,165,166,167,168,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,187,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,217,218,219,220,221,222,223,224,225,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,287,288,289,290,291,292,293,294,295,296,297,298,299,300,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,389,390,391,392,393,394,395,396,400,401,402,403,404,408,409,410,411,412,413,415,416,417,418,419,420,421,422,423,424,425,426,427,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,475,476,477,478,479,481,482,483,484,485,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,506,507,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,555,556,557,559,560,562,563,564,566,567,568,570,572,573,574,576,578,580,581,582,583,585,587,588,589,590,591,592,593,594,595,596,598,599,600,601,602,605,606,607,608,609,610,612,613,614,615,616,619,622,626,627,628,629,630,631,633,634,635,636,637,639,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,662,663,664,665,666,667,668,669,670,671,672,673,674,677,678,679,680,683,685,686,702,925,926,927,928,929,930,931,932,933,934,935,937,938,942,943,946) [ RunTime:1.357410s ] [2024-03-04T16:56:21+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (1,2,3,4,5,7,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,163,164,165,166,167,168,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,187,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,217,218,219,220,221,222,223,224,225,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,287,288,289,290,291,292,293,294,295,296,297,298,299,300,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,389,390,391,392,393,394,395,396,400,401,402,403,404,408,409,410,411,412,413,415,416,417,418,419,420,421,422,423,424,425,426,427,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,475,476,477,478,479,481,482,483,484,485,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,506,507,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,555,556,557,559,560,562,563,564,566,567,568,570,572,573,574,576,578,580,581,582,583,585,587,588,589,590,591,592,593,594,595,596,598,599,600,601,602,605,606,607,608,609,610,612,613,614,615,616,619,622,626,627,628,629,630,631,633,634,635,636,637,639,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,662,663,664,665,666,667,668,669,670,671,672,673,674,677,678,679,680,683,685,686,702,925,926,927,928,929,930,931,932,933,934,935,937,938,942,943,946) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.258181s ] [2024-03-04T16:56:21+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000572s ] [2024-03-04T16:56:22+08:00][sql] CONNECT:[ UseTime:0.016301s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001458s ] [2024-03-04T16:56:22+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('10',family) ) [ RunTime:0.000865s ] [2024-03-04T16:56:22+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001565s ] [2024-03-04T16:56:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (10,33,34,48,49,50,51,52,53,54,55,57,58,60,61,62,81,139,333,334,336,337,340,341,342,343,344,345,346,347,348,349,362,364,365,366,380,384,387,391,394,427,437,438,439,440,444,445,447,448,459,460,462,475,477,484,485,487,506,509,515,549,564,567,568,576,578,619,629,635,654,671,683,685,937,938) [ RunTime:0.014259s ] [2024-03-04T16:56:22+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (10,33,34,48,49,50,51,52,53,54,55,57,58,60,61,62,81,139,333,334,336,337,340,341,342,343,344,345,346,347,348,349,362,364,365,366,380,384,387,391,394,427,437,438,439,440,444,445,447,448,459,460,462,475,477,484,485,487,506,509,515,549,564,567,568,576,578,619,629,635,654,671,683,685,937,938) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.046660s ] [2024-03-04T16:56:22+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,334,380,333,55,384,387,391,362,394,343,345,348,340,346) [ RunTime:0.000492s ] [2024-03-04T16:56:23+08:00][sql] CONNECT:[ UseTime:0.001129s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000768s ] [2024-03-04T16:56:23+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('2',family) ) [ RunTime:0.000596s ] [2024-03-04T16:56:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001123s ] [2024-03-04T16:56:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (2,10,11,12,14,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,139,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,372,379,380,384,387,389,391,394,425,427,437,438,439,440,444,445,447,448,451,459,460,462,475,477,484,485,487,506,509,514,515,516,518,533,549,562,563,564,567,568,573,576,578,601,619,629,635,654,667,671,683,685,686,937,938) [ RunTime:0.038462s ] [2024-03-04T16:56:23+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (2,10,11,12,14,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,139,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,372,379,380,384,387,389,391,394,425,427,437,438,439,440,444,445,447,448,451,459,460,462,475,477,484,485,487,506,509,514,515,516,518,533,549,562,563,564,567,568,573,576,578,601,619,629,635,654,667,671,683,685,686,937,938) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.242298s ] [2024-03-04T16:56:23+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000494s ] [2024-03-04T16:56:23+08:00][sql] CONNECT:[ UseTime:0.014289s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000753s ] [2024-03-04T16:56:23+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('33',family) ) [ RunTime:0.000513s ] [2024-03-04T16:56:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000525s ] [2024-03-04T16:56:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (33,34,48,52,62,334,380,506,629) [ RunTime:0.001696s ] [2024-03-04T16:56:23+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (33,34,48,52,62,334,380,506,629) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.005836s ] [2024-03-04T16:56:23+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (334,380,52) [ RunTime:0.000316s ] [2024-03-04T16:56:24+08:00][sql] CONNECT:[ UseTime:0.000847s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001259s ] [2024-03-04T16:56:24+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('34',family) ) [ RunTime:0.000543s ] [2024-03-04T16:56:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001044s ] [2024-03-04T16:56:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 34 [ RunTime:0.000358s ] [2024-03-04T16:56:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 34 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000423s ] [2024-03-04T16:56:24+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 34 [ RunTime:0.000280s ] [2024-03-04T16:56:30+08:00][sql] CONNECT:[ UseTime:0.007736s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001304s ] [2024-03-04T16:56:30+08:00][sql] SELECT * FROM `product` WHERE `id` = 468663 LIMIT 1 [ RunTime:0.000405s ] [2024-03-04T16:56:30+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000631s ] [2024-03-04T16:56:30+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 34 [ RunTime:0.000328s ] [2024-03-04T16:56:31+08:00][sql] CONNECT:[ UseTime:0.003831s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000685s ] [2024-03-04T16:56:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('34',family) ) [ RunTime:0.000518s ] [2024-03-04T16:56:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000530s ] [2024-03-04T16:56:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 34 AND `type` LIKE '%JTY-LZ-ZM991%' [ RunTime:0.000403s ] [2024-03-04T16:56:31+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 34 AND `type` LIKE '%JTY-LZ-ZM991%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.000416s ] [2024-03-04T16:56:31+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 34 [ RunTime:0.000255s ] [2024-03-04T16:56:32+08:00][sql] CONNECT:[ UseTime:0.001331s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:32+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000663s ] [2024-03-04T16:56:32+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000728s ] [2024-03-04T16:56:32+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001336s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (1,2,3,4,5,7,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,163,164,165,166,167,168,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,187,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,217,218,219,220,221,222,223,224,225,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,287,288,289,290,291,292,293,294,295,296,297,298,299,300,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,389,390,391,392,393,394,395,396,400,401,402,403,404,408,409,410,411,412,413,415,416,417,418,419,420,421,422,423,424,425,426,427,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,475,476,477,478,479,481,482,483,484,485,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,506,507,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,555,556,557,559,560,562,563,564,566,567,568,570,572,573,574,576,578,580,581,582,583,585,587,588,589,590,591,592,593,594,595,596,598,599,600,601,602,605,606,607,608,609,610,612,613,614,615,616,619,622,626,627,628,629,630,631,633,634,635,636,637,639,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,662,663,664,665,666,667,668,669,670,671,672,673,674,677,678,679,680,683,685,686,702,925,926,927,928,929,930,931,932,933,934,935,937,938,942,943,946) [ RunTime:0.233978s ] [2024-03-04T16:56:32+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (1,2,3,4,5,7,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,163,164,165,166,167,168,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,187,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,217,218,219,220,221,222,223,224,225,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,287,288,289,290,291,292,293,294,295,296,297,298,299,300,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,389,390,391,392,393,394,395,396,400,401,402,403,404,408,409,410,411,412,413,415,416,417,418,419,420,421,422,423,424,425,426,427,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,475,476,477,478,479,481,482,483,484,485,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,506,507,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,555,556,557,559,560,562,563,564,566,567,568,570,572,573,574,576,578,580,581,582,583,585,587,588,589,590,591,592,593,594,595,596,598,599,600,601,602,605,606,607,608,609,610,612,613,614,615,616,619,622,626,627,628,629,630,631,633,634,635,636,637,639,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,662,663,664,665,666,667,668,669,670,671,672,673,674,677,678,679,680,683,685,686,702,925,926,927,928,929,930,931,932,933,934,935,937,938,942,943,946) LIMIT 0,10 [ RunTime:0.061851s ] [2024-03-04T16:56:32+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001262s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 248191 LIMIT 1 [ RunTime:0.000643s ] [2024-03-04T16:56:32+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000896s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000195s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000164s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 252916 LIMIT 1 [ RunTime:0.000549s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000168s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 254172 LIMIT 1 [ RunTime:0.000528s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000170s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000146s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256867 LIMIT 1 [ RunTime:0.000569s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000163s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000163s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256891 LIMIT 1 [ RunTime:0.000531s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000162s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000153s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257200 LIMIT 1 [ RunTime:0.000524s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000162s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257201 LIMIT 1 [ RunTime:0.000522s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000155s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000169s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257220 LIMIT 1 [ RunTime:0.000516s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000160s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257221 LIMIT 1 [ RunTime:0.000501s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000139s ] [2024-03-04T16:56:32+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257222 LIMIT 1 [ RunTime:0.000524s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-04T16:56:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000157s ] [2024-03-04T16:56:34+08:00][sql] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:34+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001197s ] [2024-03-04T16:56:34+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('34',family) ) [ RunTime:0.000550s ] [2024-03-04T16:56:34+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000496s ] [2024-03-04T16:56:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 34 [ RunTime:0.000365s ] [2024-03-04T16:56:34+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 34 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.000399s ] [2024-03-04T16:56:34+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 34 [ RunTime:0.000226s ] [2024-03-04T16:56:37+08:00][sql] CONNECT:[ UseTime:0.015603s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:37+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001359s ] [2024-03-04T16:56:37+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000794s ] [2024-03-04T16:56:37+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001026s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (3,15,16,17,56,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,395,403,408,421,424,442,443,453,454,455,458,461,466,467,472,476,479,488,489,498,531,605,606,608,610,612,613,614,622,633,634,636,646,647,673,702,946) [ RunTime:0.177307s ] [2024-03-04T16:56:37+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (3,15,16,17,56,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,395,403,408,421,424,442,443,453,454,455,458,461,466,467,472,476,479,488,489,498,531,605,606,608,610,612,613,614,622,633,634,636,646,647,673,702,946) LIMIT 0,10 [ RunTime:0.015883s ] [2024-03-04T16:56:37+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000699s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 22390 LIMIT 1 [ RunTime:0.000656s ] [2024-03-04T16:56:37+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001043s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000185s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000191s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 22391 LIMIT 1 [ RunTime:0.000574s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000198s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000153s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 60830 LIMIT 1 [ RunTime:0.000603s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000174s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000170s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 81098 LIMIT 1 [ RunTime:0.000559s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000200s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000167s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 97175 LIMIT 1 [ RunTime:0.000710s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000208s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 97179 LIMIT 1 [ RunTime:0.000538s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 97180 LIMIT 1 [ RunTime:0.000536s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000192s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000159s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 116529 LIMIT 1 [ RunTime:0.000567s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000160s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 117196 LIMIT 1 [ RunTime:0.000649s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000165s ] [2024-03-04T16:56:37+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 117197 LIMIT 1 [ RunTime:0.000528s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000160s ] [2024-03-04T16:56:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:56:40+08:00][sql] CONNECT:[ UseTime:0.002277s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:40+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001227s ] [2024-03-04T16:56:40+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000762s ] [2024-03-04T16:56:40+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001317s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (17,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,421,424,453,454,455,458,461,466,467,476,488,489,605,606,608,612,613,614,622) [ RunTime:0.009542s ] [2024-03-04T16:56:40+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (17,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,421,424,453,454,455,458,461,466,467,476,488,489,605,606,608,612,613,614,622) LIMIT 0,10 [ RunTime:0.006810s ] [2024-03-04T16:56:40+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001129s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15422 LIMIT 1 [ RunTime:0.000651s ] [2024-03-04T16:56:40+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000516s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000191s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000208s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30441 LIMIT 1 [ RunTime:0.000548s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000173s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000151s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 31687 LIMIT 1 [ RunTime:0.000551s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000176s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000178s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 48805 LIMIT 1 [ RunTime:0.000523s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000160s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 55123 LIMIT 1 [ RunTime:0.000555s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000159s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000184s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59699 LIMIT 1 [ RunTime:0.000530s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000190s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000178s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59712 LIMIT 1 [ RunTime:0.000530s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000169s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000165s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59797 LIMIT 1 [ RunTime:0.000518s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000175s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 68734 LIMIT 1 [ RunTime:0.000528s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000169s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000158s ] [2024-03-04T16:56:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 71302 LIMIT 1 [ RunTime:0.000566s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000158s ] [2024-03-04T16:56:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000157s ] [2024-03-04T16:56:42+08:00][sql] CONNECT:[ UseTime:0.011283s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:42+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001237s ] [2024-03-04T16:56:42+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000763s ] [2024-03-04T16:56:42+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000868s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) [ RunTime:0.004221s ] [2024-03-04T16:56:42+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) LIMIT 0,10 [ RunTime:0.002769s ] [2024-03-04T16:56:42+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000607s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15422 LIMIT 1 [ RunTime:0.000618s ] [2024-03-04T16:56:42+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000497s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000180s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000161s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30441 LIMIT 1 [ RunTime:0.000557s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000175s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 31687 LIMIT 1 [ RunTime:0.000602s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000149s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000166s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 48805 LIMIT 1 [ RunTime:0.000538s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000141s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 55123 LIMIT 1 [ RunTime:0.000608s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000172s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000202s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59699 LIMIT 1 [ RunTime:0.000538s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59712 LIMIT 1 [ RunTime:0.000546s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000162s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000140s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59797 LIMIT 1 [ RunTime:0.000552s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000148s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 68734 LIMIT 1 [ RunTime:0.000521s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000162s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000142s ] [2024-03-04T16:56:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 71302 LIMIT 1 [ RunTime:0.000564s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000198s ] [2024-03-04T16:56:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000267s ] [2024-03-04T16:56:45+08:00][sql] CONNECT:[ UseTime:0.010704s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:45+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000745s ] [2024-03-04T16:56:45+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000771s ] [2024-03-04T16:56:45+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001381s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 376 [ RunTime:0.000617s ] [2024-03-04T16:56:45+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 376 LIMIT 0,10 [ RunTime:0.000454s ] [2024-03-04T16:56:45+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001032s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 480 LIMIT 1 [ RunTime:0.000588s ] [2024-03-04T16:56:45+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000935s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6702 [ RunTime:0.009582s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6702 AND `status` = 0 [ RunTime:0.011068s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 631 LIMIT 1 [ RunTime:0.000650s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000198s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000177s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 632 LIMIT 1 [ RunTime:0.000561s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000200s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000155s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 850 LIMIT 1 [ RunTime:0.000396s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 4491 [ RunTime:0.009500s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 4491 AND `status` = 0 [ RunTime:0.010956s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1239 LIMIT 1 [ RunTime:0.000702s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000182s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000181s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1824 LIMIT 1 [ RunTime:0.000361s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2350 [ RunTime:0.009650s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2350 AND `status` = 0 [ RunTime:0.011856s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2563 LIMIT 1 [ RunTime:0.000733s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000307s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000294s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7259 LIMIT 1 [ RunTime:0.000797s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000255s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000213s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9069 LIMIT 1 [ RunTime:0.000790s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000233s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000211s ] [2024-03-04T16:56:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9161 LIMIT 1 [ RunTime:0.000822s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000211s ] [2024-03-04T16:56:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000237s ] [2024-03-04T16:56:47+08:00][sql] CONNECT:[ UseTime:0.001042s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:47+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001320s ] [2024-03-04T16:56:47+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000800s ] [2024-03-04T16:56:47+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000897s ] [2024-03-04T16:56:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 34 [ RunTime:0.000414s ] [2024-03-04T16:56:47+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 34 LIMIT 0,10 [ RunTime:0.000419s ] [2024-03-04T16:56:47+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000533s ] [2024-03-04T16:56:47+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 468663 LIMIT 1 [ RunTime:0.000639s ] [2024-03-04T16:56:47+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000521s ] [2024-03-04T16:56:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000240s ] [2024-03-04T16:56:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-04T16:56:47+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 483219 LIMIT 1 [ RunTime:0.000602s ] [2024-03-04T16:56:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000230s ] [2024-03-04T16:56:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000169s ] [2024-03-04T16:56:47+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 483220 LIMIT 1 [ RunTime:0.000557s ] [2024-03-04T16:56:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000159s ] [2024-03-04T16:56:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000192s ] [2024-03-04T16:56:51+08:00][sql] CONNECT:[ UseTime:0.012718s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:51+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001222s ] [2024-03-04T16:56:51+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000753s ] [2024-03-04T16:56:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001406s ] [2024-03-04T16:56:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 48 [ RunTime:0.000522s ] [2024-03-04T16:56:51+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 48 LIMIT 0,10 [ RunTime:0.000565s ] [2024-03-04T16:56:51+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000993s ] [2024-03-04T16:56:51+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 194239 LIMIT 1 [ RunTime:0.000561s ] [2024-03-04T16:56:51+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000921s ] [2024-03-04T16:56:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6185 [ RunTime:0.009797s ] [2024-03-04T16:56:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6185 AND `status` = 0 [ RunTime:0.011241s ] [2024-03-04T16:56:51+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 461846 LIMIT 1 [ RunTime:0.000606s ] [2024-03-04T16:56:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6186 [ RunTime:0.009759s ] [2024-03-04T16:56:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6186 AND `status` = 0 [ RunTime:0.011184s ] [2024-03-04T16:56:53+08:00][sql] CONNECT:[ UseTime:0.014556s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:53+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001174s ] [2024-03-04T16:56:53+08:00][sql] SELECT * FROM `bom` WHERE `product` = 461846 LIMIT 1 [ RunTime:0.000667s ] [2024-03-04T16:56:53+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001045s ] [2024-03-04T16:56:53+08:00][sql] SELECT * FROM `product` WHERE `id` = 461846 [ RunTime:0.000321s ] [2024-03-04T16:56:54+08:00][sql] CONNECT:[ UseTime:0.013161s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:54+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001172s ] [2024-03-04T16:56:54+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 6186 [ RunTime:0.009497s ] [2024-03-04T16:56:57+08:00][sql] CONNECT:[ UseTime:0.012967s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:57+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000764s ] [2024-03-04T16:56:57+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000807s ] [2024-03-04T16:56:57+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000841s ] [2024-03-04T16:56:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 48 [ RunTime:0.000574s ] [2024-03-04T16:56:57+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 48 LIMIT 0,10 [ RunTime:0.000529s ] [2024-03-04T16:56:57+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001113s ] [2024-03-04T16:56:57+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 194239 LIMIT 1 [ RunTime:0.000627s ] [2024-03-04T16:56:57+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000926s ] [2024-03-04T16:56:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6185 [ RunTime:0.009757s ] [2024-03-04T16:56:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6185 AND `status` = 0 [ RunTime:0.011072s ] [2024-03-04T16:56:57+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 461846 LIMIT 1 [ RunTime:0.000579s ] [2024-03-04T16:56:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6186 [ RunTime:0.009381s ] [2024-03-04T16:56:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6186 AND `status` = 0 [ RunTime:0.010874s ] [2024-03-04T16:56:58+08:00][sql] CONNECT:[ UseTime:0.005042s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:58+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001187s ] [2024-03-04T16:56:58+08:00][sql] SELECT * FROM `bom` WHERE `product` = 194239 LIMIT 1 [ RunTime:0.000647s ] [2024-03-04T16:56:58+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000579s ] [2024-03-04T16:56:58+08:00][sql] SELECT * FROM `product` WHERE `id` = 194239 [ RunTime:0.000315s ] [2024-03-04T16:56:58+08:00][sql] CONNECT:[ UseTime:0.002856s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:56:58+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001161s ] [2024-03-04T16:56:58+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 6185 [ RunTime:0.009291s ] [2024-03-04T16:57:01+08:00][sql] CONNECT:[ UseTime:0.004069s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:01+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000676s ] [2024-03-04T16:57:01+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000741s ] [2024-03-04T16:57:01+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000807s ] [2024-03-04T16:57:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 48 [ RunTime:0.000682s ] [2024-03-04T16:57:01+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 48 LIMIT 0,10 [ RunTime:0.000468s ] [2024-03-04T16:57:01+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001058s ] [2024-03-04T16:57:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 194239 LIMIT 1 [ RunTime:0.000561s ] [2024-03-04T16:57:01+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000918s ] [2024-03-04T16:57:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6185 [ RunTime:0.009674s ] [2024-03-04T16:57:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6185 AND `status` = 0 [ RunTime:0.011176s ] [2024-03-04T16:57:01+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 461846 LIMIT 1 [ RunTime:0.000598s ] [2024-03-04T16:57:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6186 [ RunTime:0.009331s ] [2024-03-04T16:57:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6186 AND `status` = 0 [ RunTime:0.010887s ] [2024-03-04T16:57:02+08:00][sql] CONNECT:[ UseTime:0.004083s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:02+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000735s ] [2024-03-04T16:57:02+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000779s ] [2024-03-04T16:57:02+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000825s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 52 [ RunTime:0.000370s ] [2024-03-04T16:57:02+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 52 LIMIT 0,10 [ RunTime:0.000481s ] [2024-03-04T16:57:02+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001071s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 14761 LIMIT 1 [ RunTime:0.000649s ] [2024-03-04T16:57:02+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001002s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000191s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000164s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 21121 LIMIT 1 [ RunTime:0.000553s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000140s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 69000 LIMIT 1 [ RunTime:0.000536s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000146s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000180s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 69338 LIMIT 1 [ RunTime:0.000515s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000185s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000146s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 77357 LIMIT 1 [ RunTime:0.000493s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000194s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000139s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 78357 LIMIT 1 [ RunTime:0.000524s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000151s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000169s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 101889 LIMIT 1 [ RunTime:0.000519s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000148s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000145s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 104883 LIMIT 1 [ RunTime:0.000506s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000180s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000137s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 141674 LIMIT 1 [ RunTime:0.000550s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000146s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000259s ] [2024-03-04T16:57:02+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 185931 LIMIT 1 [ RunTime:0.000591s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000166s ] [2024-03-04T16:57:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000150s ] [2024-03-04T16:57:06+08:00][sql] CONNECT:[ UseTime:0.008613s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:06+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000671s ] [2024-03-04T16:57:06+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000730s ] [2024-03-04T16:57:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000859s ] [2024-03-04T16:57:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 629 [ RunTime:0.000353s ] [2024-03-04T16:57:06+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 629 LIMIT 0,10 [ RunTime:0.000327s ] [2024-03-04T16:57:06+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000972s ] [2024-03-04T16:57:06+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 463672 LIMIT 1 [ RunTime:0.000599s ] [2024-03-04T16:57:06+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000932s ] [2024-03-04T16:57:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000186s ] [2024-03-04T16:57:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000165s ] [2024-03-04T16:57:06+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 463689 LIMIT 1 [ RunTime:0.000556s ] [2024-03-04T16:57:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000209s ] [2024-03-04T16:57:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000162s ] [2024-03-04T16:57:09+08:00][sql] CONNECT:[ UseTime:0.014878s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000702s ] [2024-03-04T16:57:09+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000741s ] [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000767s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 506 [ RunTime:0.000390s ] [2024-03-04T16:57:09+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 506 LIMIT 0,10 [ RunTime:0.000431s ] [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000518s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 108400 LIMIT 1 [ RunTime:0.000610s ] [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000494s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000189s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000166s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 119659 LIMIT 1 [ RunTime:0.000567s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 126547 LIMIT 1 [ RunTime:0.000574s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000159s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 126698 LIMIT 1 [ RunTime:0.000554s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000146s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 181439 LIMIT 1 [ RunTime:0.000568s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000182s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 195944 LIMIT 1 [ RunTime:0.000556s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000188s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257628 LIMIT 1 [ RunTime:0.000539s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000160s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 460177 LIMIT 1 [ RunTime:0.000569s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000174s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000158s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 461206 LIMIT 1 [ RunTime:0.000543s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000148s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 461240 LIMIT 1 [ RunTime:0.000559s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000157s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000157s ] [2024-03-04T16:57:09+08:00][sql] CONNECT:[ UseTime:0.000947s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000707s ] [2024-03-04T16:57:09+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000732s ] [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000825s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 380 [ RunTime:0.000544s ] [2024-03-04T16:57:09+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 380 LIMIT 0,10 [ RunTime:0.000446s ] [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000511s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 652 LIMIT 1 [ RunTime:0.000562s ] [2024-03-04T16:57:09+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000556s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000213s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000177s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1103 LIMIT 1 [ RunTime:0.000434s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 4637 [ RunTime:0.009560s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 4637 AND `status` = 0 [ RunTime:0.011086s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9467 LIMIT 1 [ RunTime:0.000662s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000177s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000201s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9688 LIMIT 1 [ RunTime:0.000537s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000171s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000146s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10841 LIMIT 1 [ RunTime:0.000506s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 12108 LIMIT 1 [ RunTime:0.000515s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000149s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 29178 LIMIT 1 [ RunTime:0.000519s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000186s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000141s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 29699 LIMIT 1 [ RunTime:0.000527s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000177s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 35938 LIMIT 1 [ RunTime:0.000525s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000146s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000147s ] [2024-03-04T16:57:09+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 35986 LIMIT 1 [ RunTime:0.000554s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000183s ] [2024-03-04T16:57:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:57:18+08:00][sql] CONNECT:[ UseTime:0.006134s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:18+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000838s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000253s ] [2024-03-04T16:57:18+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000475s ] [2024-03-04T16:57:18+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000648s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000654s ] [2024-03-04T16:57:18+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000574s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000240s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000205s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000622s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000208s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000195s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000642s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000203s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000237s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000595s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000189s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000217s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000588s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000223s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000189s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000600s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000224s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000189s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000630s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000185s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000245s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000574s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000186s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000231s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000583s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.009846s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 AND `status` = 0 [ RunTime:0.011481s ] [2024-03-04T16:57:18+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000706s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000255s ] [2024-03-04T16:57:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000234s ] [2024-03-04T16:57:18+08:00][sql] CONNECT:[ UseTime:0.008449s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:18+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000755s ] [2024-03-04T16:57:18+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003595s ] [2024-03-04T16:57:24+08:00][sql] CONNECT:[ UseTime:0.007647s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000692s ] [2024-03-04T16:57:24+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000749s ] [2024-03-04T16:57:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000816s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 90 [ RunTime:0.012423s ] [2024-03-04T16:57:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 90 LIMIT 0,10 [ RunTime:0.000507s ] [2024-03-04T16:57:24+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000654s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 297 LIMIT 1 [ RunTime:0.000372s ] [2024-03-04T16:57:24+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000519s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2101 [ RunTime:0.009285s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2101 AND `status` = 0 [ RunTime:0.010651s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 298 LIMIT 1 [ RunTime:0.000373s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2422 [ RunTime:0.009143s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2422 AND `status` = 0 [ RunTime:0.010589s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 633 LIMIT 1 [ RunTime:0.000581s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6403 [ RunTime:0.009188s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6403 AND `status` = 0 [ RunTime:0.010626s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1072 LIMIT 1 [ RunTime:0.000430s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2752 [ RunTime:0.009126s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2752 AND `status` = 0 [ RunTime:0.010677s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1073 LIMIT 1 [ RunTime:0.000414s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2362 [ RunTime:0.009141s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2362 AND `status` = 0 [ RunTime:0.010641s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1074 LIMIT 1 [ RunTime:0.000491s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 4609 [ RunTime:0.009175s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 4609 AND `status` = 0 [ RunTime:0.011509s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1860 LIMIT 1 [ RunTime:0.000586s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6308 [ RunTime:0.009404s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6308 AND `status` = 0 [ RunTime:0.010996s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1861 LIMIT 1 [ RunTime:0.000419s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 3313 [ RunTime:0.009489s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 3313 AND `status` = 0 [ RunTime:0.011161s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1862 LIMIT 1 [ RunTime:0.000637s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7245 [ RunTime:0.009698s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7245 AND `status` = 0 [ RunTime:0.011125s ] [2024-03-04T16:57:24+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1863 LIMIT 1 [ RunTime:0.000632s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000179s ] [2024-03-04T16:57:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000171s ] [2024-03-04T16:57:29+08:00][sql] CONNECT:[ UseTime:0.008132s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:29+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000714s ] [2024-03-04T16:57:29+08:00][sql] SELECT * FROM `bom` WHERE `product` = 297 LIMIT 1 [ RunTime:0.000391s ] [2024-03-04T16:57:29+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000603s ] [2024-03-04T16:57:29+08:00][sql] SELECT * FROM `product` WHERE `id` = 297 [ RunTime:0.000309s ] [2024-03-04T16:57:29+08:00][sql] CONNECT:[ UseTime:0.008124s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:29+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000675s ] [2024-03-04T16:57:29+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 2101 [ RunTime:0.009121s ] [2024-03-04T16:57:29+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001191s ] [2024-03-04T16:57:29+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (37,38,41,42,43,44,45,164,575,542,613,585,281,292,3675,250,1370,169,168,3773,3774,172,46,3775,47) [ RunTime:0.000510s ] [2024-03-04T16:57:40+08:00][sql] CONNECT:[ UseTime:0.004477s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:40+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001144s ] [2024-03-04T16:57:40+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000717s ] [2024-03-04T16:57:40+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000836s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (1,2,3,4,5,7,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,163,164,165,166,167,168,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,187,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,217,218,219,220,221,222,223,224,225,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,287,288,289,290,291,292,293,294,295,296,297,298,299,300,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,389,390,391,392,393,394,395,396,400,401,402,403,404,408,409,410,411,412,413,415,416,417,418,419,420,421,422,423,424,425,426,427,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,475,476,477,478,479,481,482,483,484,485,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,506,507,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,555,556,557,559,560,562,563,564,566,567,568,570,572,573,574,576,578,580,581,582,583,585,587,588,589,590,591,592,593,594,595,596,598,599,600,601,602,605,606,607,608,609,610,612,613,614,615,616,619,622,626,627,628,629,630,631,633,634,635,636,637,639,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,662,663,664,665,666,667,668,669,670,671,672,673,674,677,678,679,680,683,685,686,702,925,926,927,928,929,930,931,932,933,934,935,937,938,942,943,946) [ RunTime:0.223299s ] [2024-03-04T16:57:40+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (1,2,3,4,5,7,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,42,43,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,70,71,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,163,164,165,166,167,168,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,187,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,217,218,219,220,221,222,223,224,225,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,287,288,289,290,291,292,293,294,295,296,297,298,299,300,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,333,334,336,337,339,340,341,342,343,344,345,346,347,348,349,362,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,389,390,391,392,393,394,395,396,400,401,402,403,404,408,409,410,411,412,413,415,416,417,418,419,420,421,422,423,424,425,426,427,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,475,476,477,478,479,481,482,483,484,485,487,488,489,490,491,492,493,495,496,497,498,499,500,501,502,503,504,506,507,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,555,556,557,559,560,562,563,564,566,567,568,570,572,573,574,576,578,580,581,582,583,585,587,588,589,590,591,592,593,594,595,596,598,599,600,601,602,605,606,607,608,609,610,612,613,614,615,616,619,622,626,627,628,629,630,631,633,634,635,636,637,639,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,662,663,664,665,666,667,668,669,670,671,672,673,674,677,678,679,680,683,685,686,702,925,926,927,928,929,930,931,932,933,934,935,937,938,942,943,946) LIMIT 0,10 [ RunTime:0.062140s ] [2024-03-04T16:57:40+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000747s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 248191 LIMIT 1 [ RunTime:0.000614s ] [2024-03-04T16:57:40+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001078s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000230s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000159s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 252916 LIMIT 1 [ RunTime:0.000586s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000158s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000186s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 254172 LIMIT 1 [ RunTime:0.000530s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000205s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000150s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256867 LIMIT 1 [ RunTime:0.000537s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000140s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256891 LIMIT 1 [ RunTime:0.000538s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000155s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257200 LIMIT 1 [ RunTime:0.000529s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000184s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257201 LIMIT 1 [ RunTime:0.000568s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000194s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257220 LIMIT 1 [ RunTime:0.000602s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000190s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000145s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257221 LIMIT 1 [ RunTime:0.000517s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000170s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000145s ] [2024-03-04T16:57:40+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257222 LIMIT 1 [ RunTime:0.000543s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000155s ] [2024-03-04T16:57:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000183s ] [2024-03-04T16:57:41+08:00][sql] CONNECT:[ UseTime:0.011152s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:41+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000762s ] [2024-03-04T16:57:41+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000731s ] [2024-03-04T16:57:41+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000840s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (3,15,16,17,56,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,395,403,408,421,424,442,443,453,454,455,458,461,466,467,472,476,479,488,489,498,531,605,606,608,610,612,613,614,622,633,634,636,646,647,673,702,946) [ RunTime:0.169915s ] [2024-03-04T16:57:41+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (3,15,16,17,56,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,395,403,408,421,424,442,443,453,454,455,458,461,466,467,472,476,479,488,489,498,531,605,606,608,610,612,613,614,622,633,634,636,646,647,673,702,946) LIMIT 0,10 [ RunTime:0.015441s ] [2024-03-04T16:57:41+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001183s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 22390 LIMIT 1 [ RunTime:0.000627s ] [2024-03-04T16:57:41+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000684s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000252s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000257s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 22391 LIMIT 1 [ RunTime:0.000617s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000213s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000211s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 60830 LIMIT 1 [ RunTime:0.000587s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000240s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 81098 LIMIT 1 [ RunTime:0.000738s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000169s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 97175 LIMIT 1 [ RunTime:0.000559s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000194s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 97179 LIMIT 1 [ RunTime:0.000545s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000194s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 97180 LIMIT 1 [ RunTime:0.000520s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000150s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000138s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 116529 LIMIT 1 [ RunTime:0.000554s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000153s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000204s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 117196 LIMIT 1 [ RunTime:0.000535s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000193s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000151s ] [2024-03-04T16:57:41+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 117197 LIMIT 1 [ RunTime:0.000509s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000166s ] [2024-03-04T16:57:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2024-03-04T16:57:42+08:00][sql] CONNECT:[ UseTime:0.003545s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:42+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000670s ] [2024-03-04T16:57:42+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000719s ] [2024-03-04T16:57:42+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000811s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (17,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,421,424,453,454,455,458,461,466,467,476,488,489,605,606,608,612,613,614,622) [ RunTime:0.009023s ] [2024-03-04T16:57:42+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (17,140,141,142,143,144,146,147,148,149,150,151,152,153,154,155,156,157,158,159,375,376,377,392,421,424,453,454,455,458,461,466,467,476,488,489,605,606,608,612,613,614,622) LIMIT 0,10 [ RunTime:0.006452s ] [2024-03-04T16:57:42+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000610s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15422 LIMIT 1 [ RunTime:0.000577s ] [2024-03-04T16:57:42+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000538s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000182s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000173s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30441 LIMIT 1 [ RunTime:0.000540s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000194s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 31687 LIMIT 1 [ RunTime:0.000566s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000158s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000202s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 48805 LIMIT 1 [ RunTime:0.000532s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000183s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000147s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 55123 LIMIT 1 [ RunTime:0.000501s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000160s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000137s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59699 LIMIT 1 [ RunTime:0.000502s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000147s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000173s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59712 LIMIT 1 [ RunTime:0.000503s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000182s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000140s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59797 LIMIT 1 [ RunTime:0.000490s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000181s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000137s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 68734 LIMIT 1 [ RunTime:0.000501s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000145s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000153s ] [2024-03-04T16:57:42+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 71302 LIMIT 1 [ RunTime:0.000486s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000144s ] [2024-03-04T16:57:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000153s ] [2024-03-04T16:57:45+08:00][sql] CONNECT:[ UseTime:0.008633s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:45+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000695s ] [2024-03-04T16:57:45+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000736s ] [2024-03-04T16:57:45+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000795s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) [ RunTime:0.004401s ] [2024-03-04T16:57:45+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) LIMIT 0,10 [ RunTime:0.002876s ] [2024-03-04T16:57:45+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000591s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15422 LIMIT 1 [ RunTime:0.000602s ] [2024-03-04T16:57:45+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001025s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000198s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000172s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30441 LIMIT 1 [ RunTime:0.000554s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000170s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000164s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 31687 LIMIT 1 [ RunTime:0.000524s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000176s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 48805 LIMIT 1 [ RunTime:0.000511s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000138s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 55123 LIMIT 1 [ RunTime:0.000525s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000154s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59699 LIMIT 1 [ RunTime:0.000517s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000159s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59712 LIMIT 1 [ RunTime:0.000513s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000157s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000138s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 59797 LIMIT 1 [ RunTime:0.000507s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000157s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 68734 LIMIT 1 [ RunTime:0.000511s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000147s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:57:45+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 71302 LIMIT 1 [ RunTime:0.000506s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000169s ] [2024-03-04T16:57:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2024-03-04T16:57:55+08:00][sql] CONNECT:[ UseTime:0.008512s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:55+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000701s ] [2024-03-04T16:57:55+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000742s ] [2024-03-04T16:57:55+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000861s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) [ RunTime:0.004405s ] [2024-03-04T16:57:55+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) LIMIT 10,10 [ RunTime:0.002928s ] [2024-03-04T16:57:55+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001132s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 97122 LIMIT 1 [ RunTime:0.000668s ] [2024-03-04T16:57:55+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000546s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000215s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000153s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 102826 LIMIT 1 [ RunTime:0.000574s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000169s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 128996 LIMIT 1 [ RunTime:0.000538s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000206s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000155s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 130810 LIMIT 1 [ RunTime:0.000557s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000172s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 144445 LIMIT 1 [ RunTime:0.000581s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000204s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000146s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 146840 LIMIT 1 [ RunTime:0.000543s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000157s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000184s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 156616 LIMIT 1 [ RunTime:0.000558s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000185s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000178s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 163201 LIMIT 1 [ RunTime:0.000681s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000178s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000188s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 170373 LIMIT 1 [ RunTime:0.000537s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000207s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000170s ] [2024-03-04T16:57:55+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 172124 LIMIT 1 [ RunTime:0.000589s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000172s ] [2024-03-04T16:57:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:57:58+08:00][sql] CONNECT:[ UseTime:0.015697s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:58+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000714s ] [2024-03-04T16:57:58+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000752s ] [2024-03-04T16:57:58+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000813s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%N%' OR `type` LIKE '%N%' ) [ RunTime:0.017707s ] [2024-03-04T16:57:58+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%N%' OR `type` LIKE '%N%' ) LIMIT 10,10 [ RunTime:0.004808s ] [2024-03-04T16:57:58+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000588s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 138975 LIMIT 1 [ RunTime:0.000608s ] [2024-03-04T16:57:58+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000523s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000176s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000174s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 139177 LIMIT 1 [ RunTime:0.000525s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000183s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 175181 LIMIT 1 [ RunTime:0.000730s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000216s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000218s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 175494 LIMIT 1 [ RunTime:0.000566s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 179464 LIMIT 1 [ RunTime:0.000519s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000159s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000166s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 179465 LIMIT 1 [ RunTime:0.000509s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000151s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000148s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 180253 LIMIT 1 [ RunTime:0.000512s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000322s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000186s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 182878 LIMIT 1 [ RunTime:0.000537s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000172s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 183320 LIMIT 1 [ RunTime:0.000500s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:57:58+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 185187 LIMIT 1 [ RunTime:0.000511s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000146s ] [2024-03-04T16:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000154s ] [2024-03-04T16:57:59+08:00][sql] CONNECT:[ UseTime:0.015894s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000671s ] [2024-03-04T16:57:59+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000706s ] [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000647s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NS%' OR `type` LIKE '%NS%' ) [ RunTime:0.016972s ] [2024-03-04T16:57:59+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NS%' OR `type` LIKE '%NS%' ) LIMIT 10,10 [ RunTime:0.005047s ] [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000526s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9069 LIMIT 1 [ RunTime:0.000590s ] [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000481s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000175s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000157s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9161 LIMIT 1 [ RunTime:0.000533s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000154s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000138s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 12760 LIMIT 1 [ RunTime:0.000500s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000148s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000194s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15423 LIMIT 1 [ RunTime:0.000482s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15467 LIMIT 1 [ RunTime:0.000497s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000158s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000137s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15797 LIMIT 1 [ RunTime:0.000484s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000149s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000172s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15799 LIMIT 1 [ RunTime:0.000490s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000147s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000142s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15800 LIMIT 1 [ RunTime:0.000491s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000246s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000140s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15801 LIMIT 1 [ RunTime:0.000546s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000147s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000150s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 17862 LIMIT 1 [ RunTime:0.000494s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000146s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000150s ] [2024-03-04T16:57:59+08:00][sql] CONNECT:[ UseTime:0.000883s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000696s ] [2024-03-04T16:57:59+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000729s ] [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000775s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NSF%' OR `type` LIKE '%NSF%' ) [ RunTime:0.019132s ] [2024-03-04T16:57:59+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NSF%' OR `type` LIKE '%NSF%' ) LIMIT 10,10 [ RunTime:0.005235s ] [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000619s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 12760 LIMIT 1 [ RunTime:0.000637s ] [2024-03-04T16:57:59+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000559s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000188s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000172s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15423 LIMIT 1 [ RunTime:0.000566s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000141s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15467 LIMIT 1 [ RunTime:0.000536s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000147s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15797 LIMIT 1 [ RunTime:0.000526s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000147s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15799 LIMIT 1 [ RunTime:0.000524s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000321s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000148s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15800 LIMIT 1 [ RunTime:0.000526s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000157s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000138s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15801 LIMIT 1 [ RunTime:0.000586s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000150s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 17862 LIMIT 1 [ RunTime:0.000543s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000148s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000147s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 18196 LIMIT 1 [ RunTime:0.000512s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000159s ] [2024-03-04T16:57:59+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 18425 LIMIT 1 [ RunTime:0.000504s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000150s ] [2024-03-04T16:57:59+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000179s ] [2024-03-04T16:58:16+08:00][sql] CONNECT:[ UseTime:0.008920s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000730s ] [2024-03-04T16:58:16+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000703s ] [2024-03-04T16:58:16+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000795s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NSF%' OR `type` LIKE '%NSF%' ) [ RunTime:0.017425s ] [2024-03-04T16:58:16+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NSF%' OR `type` LIKE '%NSF%' ) LIMIT 20,10 [ RunTime:0.005293s ] [2024-03-04T16:58:16+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000631s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 18426 LIMIT 1 [ RunTime:0.000609s ] [2024-03-04T16:58:16+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000478s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000177s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000161s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 18649 LIMIT 1 [ RunTime:0.000603s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000195s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000198s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 19377 LIMIT 1 [ RunTime:0.000573s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000181s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 20047 LIMIT 1 [ RunTime:0.000572s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000166s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000201s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 20048 LIMIT 1 [ RunTime:0.000539s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000255s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000151s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 21061 LIMIT 1 [ RunTime:0.000607s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000194s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 22524 LIMIT 1 [ RunTime:0.000548s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000193s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000139s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 24333 LIMIT 1 [ RunTime:0.000591s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000168s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 26392 LIMIT 1 [ RunTime:0.000510s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000176s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000170s ] [2024-03-04T16:58:16+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 26393 LIMIT 1 [ RunTime:0.000549s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-04T16:58:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000163s ] [2024-03-04T16:58:24+08:00][sql] CONNECT:[ UseTime:0.011951s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:24+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000665s ] [2024-03-04T16:58:24+08:00][sql] INSERT INTO `bom` SET `product` = 21061 , `create_time` = '2024-03-04 16:58:24.657209' , `update_time` = '2024-03-04 16:58:24.657236' [ RunTime:0.000279s ] [2024-03-04T16:58:24+08:00][sql] CONNECT:[ UseTime:0.006596s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:24+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000728s ] [2024-03-04T16:58:24+08:00][sql] SELECT * FROM `bom` WHERE `product` = 7269 LIMIT 1 [ RunTime:0.000700s ] [2024-03-04T16:58:24+08:00][error] [8]未定义数组索引: id[D:\php\WWW\admin\runtime\ams\temp\f60cad909580615475bf4f350acabc50.php:15] [2024-03-04T16:58:30+08:00][sql] CONNECT:[ UseTime:0.012482s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:30+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000746s ] [2024-03-04T16:58:30+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000799s ] [2024-03-04T16:58:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000907s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NSF%' OR `type` LIKE '%NSF%' ) [ RunTime:0.018535s ] [2024-03-04T16:58:30+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (140,146,147,148,149,375,376,377,392,421,424,461,605,606,612,613,614,622) AND ( `name` LIKE '%NSF%' OR `type` LIKE '%NSF%' ) LIMIT 20,10 [ RunTime:0.005336s ] [2024-03-04T16:58:30+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000643s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 18426 LIMIT 1 [ RunTime:0.000660s ] [2024-03-04T16:58:30+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000536s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000196s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000188s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 18649 LIMIT 1 [ RunTime:0.000567s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000154s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000150s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 19377 LIMIT 1 [ RunTime:0.000526s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000206s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000219s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 20047 LIMIT 1 [ RunTime:0.000539s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000150s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000151s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 20048 LIMIT 1 [ RunTime:0.000504s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000203s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000141s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 21061 LIMIT 1 [ RunTime:0.000523s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7269 [ RunTime:0.009420s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7269 AND `status` = 0 [ RunTime:0.011134s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 22524 LIMIT 1 [ RunTime:0.000647s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000217s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 24333 LIMIT 1 [ RunTime:0.000550s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000153s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000162s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 26392 LIMIT 1 [ RunTime:0.000540s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000169s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000145s ] [2024-03-04T16:58:30+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 26393 LIMIT 1 [ RunTime:0.000520s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000154s ] [2024-03-04T16:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000137s ] [2024-03-04T16:58:40+08:00][sql] CONNECT:[ UseTime:0.015391s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:40+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000668s ] [2024-03-04T16:58:40+08:00][sql] SELECT * FROM `bom` WHERE `product` = 21061 LIMIT 1 [ RunTime:0.000692s ] [2024-03-04T16:58:40+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000560s ] [2024-03-04T16:58:40+08:00][sql] SELECT * FROM `product` WHERE `id` = 21061 [ RunTime:0.000313s ] [2024-03-04T16:58:42+08:00][sql] CONNECT:[ UseTime:0.000923s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:42+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000715s ] [2024-03-04T16:58:42+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 7269 [ RunTime:0.009684s ] [2024-03-04T16:58:47+08:00][sql] CONNECT:[ UseTime:0.013122s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000663s ] [2024-03-04T16:58:47+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000909s ] [2024-03-04T16:58:47+08:00][sql] CONNECT:[ UseTime:0.000766s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-04T16:58:47+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000686s ] [2024-03-04T16:58:47+08:00][sql] SELECT * FROM `raw` ORDER BY `id` ASC [ RunTime:0.014664s ] [2024-03-04T16:58:47+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001021s ] [2024-03-04T16:58:47+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` IN (144,122,450,212,428,415,140,139,52,443,342,137,133,141,134,398,459,460,351,208,82,396,417,416,354,355,461,291,25,198,127,67,270,170,57,77,262,59,395,169,399,271,388,393,397,375,373,462,436,433,412,414,390,295,84,369,463,464,465,466,467,468,469,470,302,90,234,42,91,437,136,341,349,344,386,402,434,378,273,35,239,257,238,435,161,160,200,339,105,20,22,345,26,280,18,17,471,4,13,389,432,410,418,406,380,379,420,407,419,408,409,85,10,6,53,313,300,301,171,86,352,365,356,19,242,543,123,250,477,544,545,546,513,439,512,79,510,509,217,253,364,367,80,560,561,276,556,563,564,557,558,559,532,565,549,550,551,567,568,569,570,571,572,476,574,575,577,576,3,586,1,511,547,120,76,535,566,252,251,33,34,587,588,589,590,591,499,381,486,377,394,600,438,592,603,595,611,598,613,612,485,614,593,615,489,427,616,430,617,403,73,37,431,384,121,606,605,604,421,599,441,95,382,383,413,501,451,491,189,106,490,482,488,132,487,484,483,493,492,495,494,562,455,56,619,620,621,623,622,625,626,624,627,628,629,630,631,632,633,634,637,636,638,639,640,641,642,643,265,277,478,267,502,197,78,371,103,385,75,602,215,442,15,601,14,184,597,12,422,584,353,541,240,255,151,220,223,225,520,222,297,644,646,647,648,649,650,596,392,290,497,207,66,651,652,653,654,376,176,655,294,656,657,659,507,531,660,661,662,99,665,440,110,666,667,668,670,669,671,672,673,481,594,429,506,125,674,675,676,677,678,679,16,8,663,681,533,582,530,529,528,527,524,534,526,525,683,452,685,686,687,690,691,692,693,694,695,696,698,699,700,609,701,702,703,475,704,705,706,192,9,720,721,722,723,724,726,727,728,729,730,725,731,732,733,734,735,736,737,738,739,740,742,743,744,745,746,760,748,749,750,751,752,761,753,762,763,754,765,764,269,755,766,756,757,767,768,759,769,758,771,770,772,773,774,775,776,777,778,779,780,781,782,783,786,784,785,787,788,789,791,790,792,794,793,795,796,802,797,798,799,800,808,801,803,804,805,806,807,2,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,7,831,832,833,741,834,835,836,837,838,839,840,841,842,843,844,193,845,846,847,848,849,850,851,852,853,857,854,855,856,858,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,886,885,893,889,888,892,890,891,60,36,894,179,896,897,898,899,900,901,903,904,905,145,906,907,908,909,146,910,278,911,150,912,914,916,915,917,919,921,922,920,923,924,925,926,929,928,927,931,930,932,933,934,935,936,937,939,940,941,942,918,943,944,945,946,947,949,950,951,954,955,697,956,957,958,959,960) [ RunTime:0.003339s ] [2024-03-04T16:58:47+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000810s ] [2024-03-04T16:58:47+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 7269 [ RunTime:0.009006s ]