[2024-12-05T10:28:16+08:00][sql] CONNECT:[ UseTime:0.000845s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:28:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000825s ]
[2024-12-05T10:28:16+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.004243s ]
[2024-12-05T10:28:16+08:00][sql] CONNECT:[ UseTime:0.000941s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:28:16+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001606s ]
[2024-12-05T10:28:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000378s ]
[2024-12-05T10:28:16+08:00][sql] SELECT * FROM `product` ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.204601s ]
[2024-12-05T10:28:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001364s ]
[2024-12-05T10:28:16+08:00][sql] SELECT * FROM `product_sort` WHERE  `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000491s ]
[2024-12-05T10:28:31+08:00][sql] CONNECT:[ UseTime:0.000958s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:28:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001367s ]
[2024-12-05T10:28:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE  ( find_in_set('82',family) ) [ RunTime:0.000723s ]
[2024-12-05T10:28:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001055s ]
[2024-12-05T10:28:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE  `product_sort` IN (82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,126,127,472,498) [ RunTime:0.038174s ]
[2024-12-05T10:28:31+08:00][sql] SELECT * FROM `product` WHERE  `product_sort` IN (82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,100,101,102,126,127,472,498) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.314911s ]
[2024-12-05T10:28:31+08:00][sql] SELECT * FROM `product_sort` WHERE  `id` = 90 [ RunTime:0.000367s ]
[2024-12-05T10:28:35+08:00][sql] CONNECT:[ UseTime:0.010484s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:28:35+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001316s ]
[2024-12-05T10:28:35+08:00][sql] SELECT `id` FROM `product_sort` WHERE  ( find_in_set('90',family) ) [ RunTime:0.000560s ]
[2024-12-05T10:28:35+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001005s ]
[2024-12-05T10:28:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE  `product_sort` = 90 [ RunTime:0.013070s ]
[2024-12-05T10:28:35+08:00][sql] SELECT * FROM `product` WHERE  `product_sort` = 90 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.160083s ]
[2024-12-05T10:28:35+08:00][sql] SELECT * FROM `product_sort` WHERE  `id` = 90 [ RunTime:0.000397s ]
[2024-12-05T10:29:33+08:00][sql] CONNECT:[ UseTime:0.000808s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:29:33+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001256s ]
[2024-12-05T10:29:33+08:00][sql] SELECT `id` FROM `product_sort` WHERE  ( find_in_set('90',family) ) [ RunTime:0.000557s ]
[2024-12-05T10:29:33+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001037s ]
[2024-12-05T10:29:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE  `product_sort` = 90 [ RunTime:0.014809s ]
[2024-12-05T10:29:33+08:00][sql] SELECT * FROM `product` WHERE  `product_sort` = 90 ORDER BY `id`,`type`,`specs` DESC LIMIT 50,50 [ RunTime:0.167040s ]
[2024-12-05T10:29:33+08:00][sql] SELECT * FROM `product_sort` WHERE  `id` = 90 [ RunTime:0.000426s ]
[2024-12-05T10:35:32+08:00][sql] CONNECT:[ UseTime:0.000924s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:35:32+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001492s ]
[2024-12-05T10:35:32+08:00][sql] SELECT `id` FROM `raw_sort` WHERE  ( find_in_set('8',family) ) [ RunTime:0.000719s ]
[2024-12-05T10:35:32+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.021660s ]
[2024-12-05T10:35:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE  `raw_sort` IN (8,731,184,185,186,189,190,191,192,195,196,197,198,200,203,207,208,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,235,236,237,238,239,240,241,242,243,244,245,246,250,251,252,253,254,255,257,258,448,449,450,451,507,514,515,521,527,535,536,537,544,545,660,664,730,694,715,720,721,723,724,725,726,728,729,732,733,734,735,736,737,738,739,740,742,743,744,745,746,748,749,750,751,752,755,756,757,758,759,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,788,790,791,792,793,794,795,796,797,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,833,834,835,836,837,838,839,840,841,842,843,844,845,850,851,852,854,855,856,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,895,896,901,902,914,915,916,917,918,929,961,966,968,999,1011,1012,1013,1014,1015,1016,1018,1019,1022,1036,1039,1040) [ RunTime:0.049426s ]
[2024-12-05T10:35:32+08:00][sql] SELECT * FROM `raw` WHERE  `raw_sort` IN (8,731,184,185,186,189,190,191,192,195,196,197,198,200,203,207,208,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,235,236,237,238,239,240,241,242,243,244,245,246,250,251,252,253,254,255,257,258,448,449,450,451,507,514,515,521,527,535,536,537,544,545,660,664,730,694,715,720,721,723,724,725,726,728,729,732,733,734,735,736,737,738,739,740,742,743,744,745,746,748,749,750,751,752,755,756,757,758,759,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,788,790,791,792,793,794,795,796,797,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,833,834,835,836,837,838,839,840,841,842,843,844,845,850,851,852,854,855,856,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,895,896,901,902,914,915,916,917,918,929,961,966,968,999,1011,1012,1013,1014,1015,1016,1018,1019,1022,1036,1039,1040) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002972s ]
[2024-12-05T10:35:32+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.000708s ]
[2024-12-05T10:35:32+08:00][sql] CONNECT:[ UseTime:0.011134s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:35:32+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001442s ]
[2024-12-05T10:35:32+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.001157s ]
[2024-12-05T10:35:41+08:00][sql] CONNECT:[ UseTime:0.001004s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:35:41+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000835s ]
[2024-12-05T10:35:41+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.004014s ]
[2024-12-05T10:35:41+08:00][sql] CONNECT:[ UseTime:0.010723s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T10:35:41+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001445s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000274s ]
[2024-12-05T10:35:41+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000534s ]
[2024-12-05T10:35:41+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001637s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 1 LIMIT 1 [ RunTime:0.001092s ]
[2024-12-05T10:35:41+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.003996s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7274 [ RunTime:0.072861s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7274  AND `status` = 0 [ RunTime:0.013378s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 2 LIMIT 1 [ RunTime:0.000687s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7275 [ RunTime:0.011064s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7275  AND `status` = 0 [ RunTime:0.013306s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 3 LIMIT 1 [ RunTime:0.000739s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000191s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000177s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 4 LIMIT 1 [ RunTime:0.000561s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000204s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000149s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 5 LIMIT 1 [ RunTime:0.000562s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000153s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000166s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 6 LIMIT 1 [ RunTime:0.000574s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000177s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000160s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 7 LIMIT 1 [ RunTime:0.000537s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000180s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000152s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 8 LIMIT 1 [ RunTime:0.000582s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000156s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000182s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 9 LIMIT 1 [ RunTime:0.000582s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7073 [ RunTime:0.011195s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` = 7073  AND `status` = 0 [ RunTime:0.013111s ]
[2024-12-05T10:35:41+08:00][sql] SELECT `id` FROM `bom` WHERE  `product` = 10 LIMIT 1 [ RunTime:0.000665s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL [ RunTime:0.000187s ]
[2024-12-05T10:35:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE  `bom` IS NULL  AND `status` = 0 [ RunTime:0.000185s ]
[2024-12-05T12:40:22+08:00][sql] CONNECT:[ UseTime:0.000882s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8
[2024-12-05T12:40:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001258s ]
[2024-12-05T12:40:22+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003684s ]
[2024-12-05T12:40:22+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001546s ]