[2023-07-02T17:16:07+08:00][sql] CONNECT:[ UseTime:0.000952s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-07-02T17:16:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000930s ] [2023-07-02T17:16:07+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003958s ] [2023-07-02T17:16:07+08:00][sql] CONNECT:[ UseTime:0.002638s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-07-02T17:16:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.028329s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `status` = 1 [ RunTime:0.103553s ] [2023-07-02T17:16:07+08:00][sql] SELECT * FROM `product` WHERE `status` = 1 LIMIT 0,10 [ RunTime:0.000515s ] [2023-07-02T17:16:07+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.006788s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000963s ] [2023-07-02T17:16:07+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.027009s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000283s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000294s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000819s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000227s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000210s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000869s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000223s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000193s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000788s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000240s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000194s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000807s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000218s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000193s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000699s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000189s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000169s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000531s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000169s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000158s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000491s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000149s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000138s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000515s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000216s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000275s ] [2023-07-02T17:16:07+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000607s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000158s ] [2023-07-02T17:16:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2023-07-02T17:16:15+08:00][sql] CONNECT:[ UseTime:0.015210s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-07-02T17:16:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.001062s ] [2023-07-02T17:16:15+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.001202s ] [2023-07-02T17:16:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001234s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `status` = 1 AND `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) [ RunTime:0.756149s ] [2023-07-02T17:16:15+08:00][sql] SELECT * FROM `product` WHERE `status` = 1 AND `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) LIMIT 0,10 [ RunTime:0.062675s ] [2023-07-02T17:16:15+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001158s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 248191 LIMIT 1 [ RunTime:0.000805s ] [2023-07-02T17:16:15+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000955s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000225s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000200s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 252916 LIMIT 1 [ RunTime:0.000610s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000251s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000204s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 254172 LIMIT 1 [ RunTime:0.000823s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000235s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000207s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256867 LIMIT 1 [ RunTime:0.000839s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000216s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000206s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256891 LIMIT 1 [ RunTime:0.000931s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000190s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000167s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257200 LIMIT 1 [ RunTime:0.000588s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000180s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000170s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257201 LIMIT 1 [ RunTime:0.000531s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000159s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257220 LIMIT 1 [ RunTime:0.000511s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000154s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000203s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257221 LIMIT 1 [ RunTime:0.000692s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000169s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000159s ] [2023-07-02T17:16:15+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257222 LIMIT 1 [ RunTime:0.000554s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000164s ] [2023-07-02T17:16:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000154s ] [2023-07-02T17:16:17+08:00][sql] CONNECT:[ UseTime:0.000874s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-07-02T17:16:17+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000667s ] [2023-07-02T17:16:17+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000692s ] [2023-07-02T17:16:17+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001188s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `status` = 1 AND `product_sort` IN (5,28,29,30,31,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,378,390,404,409,423,456,482,495,496,497,499,503,510,511,512,520,528,534,535,536,574,587,588,594,599,641,677,678) [ RunTime:0.014906s ] [2023-07-02T17:16:17+08:00][sql] SELECT * FROM `product` WHERE `status` = 1 AND `product_sort` IN (5,28,29,30,31,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,378,390,404,409,423,456,482,495,496,497,499,503,510,511,512,520,528,534,535,536,574,587,588,594,599,641,677,678) LIMIT 0,10 [ RunTime:0.007425s ] [2023-07-02T17:16:17+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000984s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3129 LIMIT 1 [ RunTime:0.000682s ] [2023-07-02T17:16:17+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000774s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000190s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000217s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4139 LIMIT 1 [ RunTime:0.000558s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000194s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000148s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 14890 LIMIT 1 [ RunTime:0.000585s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000193s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 14891 LIMIT 1 [ RunTime:0.000598s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000197s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000144s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 16789 LIMIT 1 [ RunTime:0.000587s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000270s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 16790 LIMIT 1 [ RunTime:0.000554s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000192s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000156s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30555 LIMIT 1 [ RunTime:0.000566s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000167s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000173s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30556 LIMIT 1 [ RunTime:0.000527s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000154s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000151s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30557 LIMIT 1 [ RunTime:0.000548s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000148s ] [2023-07-02T17:16:17+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 30558 LIMIT 1 [ RunTime:0.000573s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000148s ] [2023-07-02T17:16:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000183s ] [2023-07-02T17:16:23+08:00][sql] CONNECT:[ UseTime:0.013400s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2023-07-02T17:16:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000881s ] [2023-07-02T17:16:23+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000807s ] [2023-07-02T17:16:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001277s ] [2023-07-02T17:16:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `status` = 1 AND `product_sort` IN (793,794,795,796,939,940,941) [ RunTime:0.001223s ] [2023-07-02T17:16:23+08:00][sql] SELECT * FROM `product` WHERE `status` = 1 AND `product_sort` IN (793,794,795,796,939,940,941) LIMIT 0,10 [ RunTime:0.001105s ] [2023-07-02T17:16:23+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000958s ] [2023-07-02T17:16:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 488116 LIMIT 1 [ RunTime:0.000931s ] [2023-07-02T17:16:23+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000997s ] [2023-07-02T17:16:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6661 [ RunTime:0.011311s ] [2023-07-02T17:16:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6661 AND `status` = 0 [ RunTime:0.010286s ] [2023-07-02T17:16:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 488117 LIMIT 1 [ RunTime:0.000619s ] [2023-07-02T17:16:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6662 [ RunTime:0.008805s ] [2023-07-02T17:16:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6662 AND `status` = 0 [ RunTime:0.010264s ]