[2024-03-16T14:09:09+08:00][sql] CONNECT:[ UseTime:0.007296s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:09:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000821s ] [2024-03-16T14:09:09+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.005081s ] [2024-03-16T14:09:09+08:00][sql] CONNECT:[ UseTime:0.000996s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:09:09+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000737s ] [2024-03-16T14:09:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000250s ] [2024-03-16T14:09:09+08:00][sql] SELECT * FROM `product` ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.439627s ] [2024-03-16T14:09:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000747s ] [2024-03-16T14:09:09+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000374s ] [2024-03-16T14:09:12+08:00][sql] CONNECT:[ UseTime:0.011308s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:09:12+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000680s ] [2024-03-16T14:09:12+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('1',family) ) [ RunTime:0.000654s ] [2024-03-16T14:09:12+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000606s ] [2024-03-16T14:09:12+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.149354s ] [2024-03-16T14:09:12+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.260011s ] [2024-03-16T14:09:12+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000536s ] [2024-03-16T14:09:13+08:00][sql] CONNECT:[ UseTime:0.010925s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:09:13+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000750s ] [2024-03-16T14:09:13+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('2',family) ) [ RunTime:0.000564s ] [2024-03-16T14:09:13+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000531s ] [2024-03-16T14:09:13+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.038864s ] [2024-03-16T14:09:13+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.241503s ] [2024-03-16T14:09:13+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000460s ] [2024-03-16T14:09:15+08:00][sql] CONNECT:[ UseTime:0.006943s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:09:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000700s ] [2024-03-16T14:09:15+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('12',family) ) [ RunTime:0.000536s ] [2024-03-16T14:09:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000563s ] [2024-03-16T14:09:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (12,63,64,65,66,67,69,70,71,73,367,368,369,370,372,379,533) [ RunTime:0.012214s ] [2024-03-16T14:09:15+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (12,63,64,65,66,67,69,70,71,73,367,368,369,370,372,379,533) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.099840s ] [2024-03-16T14:09:15+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (367,63,69,65,368,369) [ RunTime:0.000441s ] [2024-03-16T14:09:42+08:00][sql] CONNECT:[ UseTime:0.001401s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:09:42+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000688s ] [2024-03-16T14:09:42+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000508s ] [2024-03-16T14:09:42+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000513s ] [2024-03-16T14:09:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 [ RunTime:0.001604s ] [2024-03-16T14:09:42+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.014461s ] [2024-03-16T14:09:42+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000285s ] [2024-03-16T14:09:51+08:00][sql] CONNECT:[ UseTime:0.009471s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:09:51+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000706s ] [2024-03-16T14:09:51+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000529s ] [2024-03-16T14:09:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000543s ] [2024-03-16T14:09:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 [ RunTime:0.001636s ] [2024-03-16T14:09:51+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.014659s ] [2024-03-16T14:09:51+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000318s ] [2024-03-16T14:10:02+08:00][sql] CONNECT:[ UseTime:0.005331s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:02+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000729s ] [2024-03-16T14:10:02+08:00][sql] SELECT * FROM `product_sort` WHERE `parent_id` = 63 LIMIT 1 [ RunTime:0.000466s ] [2024-03-16T14:10:02+08:00][sql] CONNECT:[ UseTime:0.005478s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:02+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000690s ] [2024-03-16T14:10:02+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 LIMIT 1 [ RunTime:0.000301s ] [2024-03-16T14:10:02+08:00][sql] CONNECT:[ UseTime:0.002752s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:02+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000745s ] [2024-03-16T14:10:02+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000528s ] [2024-03-16T14:10:02+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000557s ] [2024-03-16T14:10:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 [ RunTime:0.001640s ] [2024-03-16T14:10:02+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014422s ] [2024-03-16T14:10:02+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000392s ] [2024-03-16T14:10:48+08:00][sql] CONNECT:[ UseTime:0.006271s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:48+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000725s ] [2024-03-16T14:10:48+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000532s ] [2024-03-16T14:10:48+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000565s ] [2024-03-16T14:10:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%y%' [ RunTime:0.013674s ] [2024-03-16T14:10:48+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%y%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014421s ] [2024-03-16T14:10:48+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000332s ] [2024-03-16T14:10:48+08:00][sql] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:48+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000686s ] [2024-03-16T14:10:48+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000517s ] [2024-03-16T14:10:48+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000523s ] [2024-03-16T14:10:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 [ RunTime:0.001606s ] [2024-03-16T14:10:48+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013893s ] [2024-03-16T14:10:48+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000322s ] [2024-03-16T14:10:49+08:00][sql] CONNECT:[ UseTime:0.008457s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:49+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000720s ] [2024-03-16T14:10:49+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000532s ] [2024-03-16T14:10:49+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000539s ] [2024-03-16T14:10:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%Y%' [ RunTime:0.013594s ] [2024-03-16T14:10:49+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%Y%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013718s ] [2024-03-16T14:10:49+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000301s ] [2024-03-16T14:10:50+08:00][sql] CONNECT:[ UseTime:0.012843s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:50+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000706s ] [2024-03-16T14:10:50+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000509s ] [2024-03-16T14:10:50+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000522s ] [2024-03-16T14:10:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF%' [ RunTime:0.013605s ] [2024-03-16T14:10:50+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014268s ] [2024-03-16T14:10:50+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000312s ] [2024-03-16T14:10:51+08:00][sql] CONNECT:[ UseTime:0.015769s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:10:51+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000755s ] [2024-03-16T14:10:51+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000523s ] [2024-03-16T14:10:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000554s ] [2024-03-16T14:10:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-%' [ RunTime:0.013387s ] [2024-03-16T14:10:51+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014015s ] [2024-03-16T14:10:51+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000332s ] [2024-03-16T14:11:20+08:00][sql] CONNECT:[ UseTime:0.000877s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000704s ] [2024-03-16T14:11:20+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000495s ] [2024-03-16T14:11:20+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000516s ] [2024-03-16T14:11:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-B%' [ RunTime:0.012883s ] [2024-03-16T14:11:20+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013517s ] [2024-03-16T14:11:20+08:00][sql] CONNECT:[ UseTime:0.015605s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000726s ] [2024-03-16T14:11:20+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000498s ] [2024-03-16T14:11:20+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000542s ] [2024-03-16T14:11:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BL%' [ RunTime:0.012968s ] [2024-03-16T14:11:20+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BL%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013452s ] [2024-03-16T14:11:24+08:00][sql] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000687s ] [2024-03-16T14:11:24+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000531s ] [2024-03-16T14:11:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000509s ] [2024-03-16T14:11:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJ%' [ RunTime:0.013093s ] [2024-03-16T14:11:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJ%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013629s ] [2024-03-16T14:11:24+08:00][sql] CONNECT:[ UseTime:0.002380s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000691s ] [2024-03-16T14:11:24+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000542s ] [2024-03-16T14:11:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000541s ] [2024-03-16T14:11:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJC%' [ RunTime:0.013534s ] [2024-03-16T14:11:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJC%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013686s ] [2024-03-16T14:11:28+08:00][sql] CONNECT:[ UseTime:0.008517s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:28+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000700s ] [2024-03-16T14:11:28+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000515s ] [2024-03-16T14:11:28+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000514s ] [2024-03-16T14:11:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJC-%' [ RunTime:0.013034s ] [2024-03-16T14:11:28+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJC-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013632s ] [2024-03-16T14:11:30+08:00][sql] CONNECT:[ UseTime:0.007632s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:30+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000713s ] [2024-03-16T14:11:30+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000523s ] [2024-03-16T14:11:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000557s ] [2024-03-16T14:11:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJC%' [ RunTime:0.014101s ] [2024-03-16T14:11:30+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJC%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014555s ] [2024-03-16T14:11:30+08:00][sql] CONNECT:[ UseTime:0.010437s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:30+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000708s ] [2024-03-16T14:11:30+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000529s ] [2024-03-16T14:11:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000544s ] [2024-03-16T14:11:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJ%' [ RunTime:0.013831s ] [2024-03-16T14:11:30+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BLJ%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014308s ] [2024-03-16T14:11:31+08:00][sql] CONNECT:[ UseTime:0.002802s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000709s ] [2024-03-16T14:11:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000512s ] [2024-03-16T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000521s ] [2024-03-16T14:11:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BL%' [ RunTime:0.013641s ] [2024-03-16T14:11:31+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BL%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014289s ] [2024-03-16T14:11:31+08:00][sql] CONNECT:[ UseTime:0.012580s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000672s ] [2024-03-16T14:11:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000519s ] [2024-03-16T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000515s ] [2024-03-16T14:11:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-B%' [ RunTime:0.013175s ] [2024-03-16T14:11:31+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013684s ] [2024-03-16T14:11:31+08:00][sql] CONNECT:[ UseTime:0.014754s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000704s ] [2024-03-16T14:11:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000529s ] [2024-03-16T14:11:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000517s ] [2024-03-16T14:11:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-%' [ RunTime:0.013450s ] [2024-03-16T14:11:31+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013983s ] [2024-03-16T14:11:31+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000299s ] [2024-03-16T14:11:36+08:00][sql] CONNECT:[ UseTime:0.016073s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:36+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000723s ] [2024-03-16T14:11:36+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000546s ] [2024-03-16T14:11:36+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000554s ] [2024-03-16T14:11:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-B%' [ RunTime:0.013684s ] [2024-03-16T14:11:36+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.014271s ] [2024-03-16T14:11:37+08:00][sql] CONNECT:[ UseTime:0.013619s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:37+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000701s ] [2024-03-16T14:11:37+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000508s ] [2024-03-16T14:11:37+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000509s ] [2024-03-16T14:11:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BL%' [ RunTime:0.013176s ] [2024-03-16T14:11:37+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 AND `type` LIKE '%YF-BL%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013660s ] [2024-03-16T14:11:40+08:00][sql] CONNECT:[ UseTime:0.011079s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:11:40+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000714s ] [2024-03-16T14:11:40+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('63',family) ) [ RunTime:0.000546s ] [2024-03-16T14:11:40+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000512s ] [2024-03-16T14:11:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 63 [ RunTime:0.001588s ] [2024-03-16T14:11:40+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 63 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.014015s ] [2024-03-16T14:11:40+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 63 [ RunTime:0.000301s ] [2024-03-16T14:12:15+08:00][sql] CONNECT:[ UseTime:0.008507s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000701s ] [2024-03-16T14:12:15+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000521s ] [2024-03-16T14:12:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000567s ] [2024-03-16T14:12:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002474s ] [2024-03-16T14:12:15+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023732s ] [2024-03-16T14:12:15+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000388s ] [2024-03-16T14:12:49+08:00][sql] CONNECT:[ UseTime:0.002964s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:49+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000715s ] [2024-03-16T14:12:49+08:00][sql] SELECT * FROM `product_sort` WHERE `parent_id` = 368 LIMIT 1 [ RunTime:0.000469s ] [2024-03-16T14:12:49+08:00][sql] CONNECT:[ UseTime:0.004910s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:49+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000687s ] [2024-03-16T14:12:49+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 LIMIT 1 [ RunTime:0.000285s ] [2024-03-16T14:12:49+08:00][sql] CONNECT:[ UseTime:0.000862s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:49+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000710s ] [2024-03-16T14:12:49+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000526s ] [2024-03-16T14:12:49+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000522s ] [2024-03-16T14:12:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002434s ] [2024-03-16T14:12:49+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022666s ] [2024-03-16T14:12:49+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000355s ] [2024-03-16T14:12:51+08:00][sql] CONNECT:[ UseTime:0.000834s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:51+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000662s ] [2024-03-16T14:12:51+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000516s ] [2024-03-16T14:12:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000515s ] [2024-03-16T14:12:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%y%' [ RunTime:0.021390s ] [2024-03-16T14:12:51+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%y%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022664s ] [2024-03-16T14:12:51+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000340s ] [2024-03-16T14:12:52+08:00][sql] CONNECT:[ UseTime:0.011992s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:52+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000699s ] [2024-03-16T14:12:52+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000519s ] [2024-03-16T14:12:52+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000523s ] [2024-03-16T14:12:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002458s ] [2024-03-16T14:12:52+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023274s ] [2024-03-16T14:12:52+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000375s ] [2024-03-16T14:12:53+08:00][sql] CONNECT:[ UseTime:0.008614s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:53+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000670s ] [2024-03-16T14:12:53+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000490s ] [2024-03-16T14:12:53+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000497s ] [2024-03-16T14:12:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%Y%' [ RunTime:0.020866s ] [2024-03-16T14:12:53+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%Y%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021831s ] [2024-03-16T14:12:53+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000321s ] [2024-03-16T14:12:54+08:00][sql] CONNECT:[ UseTime:0.006539s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:54+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000678s ] [2024-03-16T14:12:54+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000495s ] [2024-03-16T14:12:54+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000500s ] [2024-03-16T14:12:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF%' [ RunTime:0.020900s ] [2024-03-16T14:12:54+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021952s ] [2024-03-16T14:12:54+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000353s ] [2024-03-16T14:12:56+08:00][sql] CONNECT:[ UseTime:0.013830s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:56+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000691s ] [2024-03-16T14:12:56+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000505s ] [2024-03-16T14:12:56+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000530s ] [2024-03-16T14:12:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-%' [ RunTime:0.021407s ] [2024-03-16T14:12:56+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022244s ] [2024-03-16T14:12:56+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000344s ] [2024-03-16T14:12:57+08:00][sql] CONNECT:[ UseTime:0.010960s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:57+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000700s ] [2024-03-16T14:12:57+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000511s ] [2024-03-16T14:12:57+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000544s ] [2024-03-16T14:12:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-B%' [ RunTime:0.021658s ] [2024-03-16T14:12:57+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022689s ] [2024-03-16T14:12:57+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000345s ] [2024-03-16T14:12:58+08:00][sql] CONNECT:[ UseTime:0.013428s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:12:58+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000750s ] [2024-03-16T14:12:58+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000534s ] [2024-03-16T14:12:58+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000551s ] [2024-03-16T14:12:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BL%' [ RunTime:0.022217s ] [2024-03-16T14:12:58+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BL%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023258s ] [2024-03-16T14:12:58+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000374s ] [2024-03-16T14:13:01+08:00][sql] CONNECT:[ UseTime:0.008082s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:01+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000696s ] [2024-03-16T14:13:01+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000533s ] [2024-03-16T14:13:01+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000565s ] [2024-03-16T14:13:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJ%' [ RunTime:0.021452s ] [2024-03-16T14:13:01+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJ%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022569s ] [2024-03-16T14:13:01+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000343s ] [2024-03-16T14:13:01+08:00][sql] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:01+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000718s ] [2024-03-16T14:13:01+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000524s ] [2024-03-16T14:13:01+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000538s ] [2024-03-16T14:13:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC%' [ RunTime:0.021606s ] [2024-03-16T14:13:01+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022705s ] [2024-03-16T14:13:01+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000344s ] [2024-03-16T14:13:02+08:00][sql] CONNECT:[ UseTime:0.000842s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:02+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000725s ] [2024-03-16T14:13:02+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000630s ] [2024-03-16T14:13:02+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000586s ] [2024-03-16T14:13:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-%' [ RunTime:0.023442s ] [2024-03-16T14:13:02+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022625s ] [2024-03-16T14:13:02+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000367s ] [2024-03-16T14:13:04+08:00][sql] CONNECT:[ UseTime:0.012348s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:04+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000708s ] [2024-03-16T14:13:04+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000520s ] [2024-03-16T14:13:04+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000524s ] [2024-03-16T14:13:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1%' [ RunTime:0.021976s ] [2024-03-16T14:13:04+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022998s ] [2024-03-16T14:13:04+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000300s ] [2024-03-16T14:13:05+08:00][sql] CONNECT:[ UseTime:0.011115s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000668s ] [2024-03-16T14:13:05+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000484s ] [2024-03-16T14:13:05+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000501s ] [2024-03-16T14:13:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1L%' [ RunTime:0.020694s ] [2024-03-16T14:13:05+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1L%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021535s ] [2024-03-16T14:13:05+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000309s ] [2024-03-16T14:13:07+08:00][sql] CONNECT:[ UseTime:0.015586s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000714s ] [2024-03-16T14:13:07+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000514s ] [2024-03-16T14:13:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000540s ] [2024-03-16T14:13:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LR%' [ RunTime:0.021291s ] [2024-03-16T14:13:07+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LR%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021819s ] [2024-03-16T14:13:07+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000326s ] [2024-03-16T14:13:09+08:00][sql] CONNECT:[ UseTime:0.000935s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000673s ] [2024-03-16T14:13:09+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000507s ] [2024-03-16T14:13:09+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000512s ] [2024-03-16T14:13:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LRO%' [ RunTime:0.021072s ] [2024-03-16T14:13:09+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LRO%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022066s ] [2024-03-16T14:13:09+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000335s ] [2024-03-16T14:13:09+08:00][sql] CONNECT:[ UseTime:0.003135s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000741s ] [2024-03-16T14:13:09+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000533s ] [2024-03-16T14:13:09+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000536s ] [2024-03-16T14:13:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE%' [ RunTime:0.022447s ] [2024-03-16T14:13:09+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.024471s ] [2024-03-16T14:13:09+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000358s ] [2024-03-16T14:13:10+08:00][sql] CONNECT:[ UseTime:0.005617s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:10+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000713s ] [2024-03-16T14:13:10+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000537s ] [2024-03-16T14:13:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000523s ] [2024-03-16T14:13:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE %' [ RunTime:0.022425s ] [2024-03-16T14:13:10+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE %' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023459s ] [2024-03-16T14:13:10+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000365s ] [2024-03-16T14:13:14+08:00][sql] CONNECT:[ UseTime:0.014899s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:14+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000696s ] [2024-03-16T14:13:14+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000527s ] [2024-03-16T14:13:14+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000519s ] [2024-03-16T14:13:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I%' [ RunTime:0.021767s ] [2024-03-16T14:13:14+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022944s ] [2024-03-16T14:13:14+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000367s ] [2024-03-16T14:13:15+08:00][sql] CONNECT:[ UseTime:0.004010s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000750s ] [2024-03-16T14:13:15+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000532s ] [2024-03-16T14:13:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000541s ] [2024-03-16T14:13:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I %' [ RunTime:0.022214s ] [2024-03-16T14:13:15+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I %' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023303s ] [2024-03-16T14:13:17+08:00][sql] CONNECT:[ UseTime:0.005895s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:17+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000703s ] [2024-03-16T14:13:17+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000514s ] [2024-03-16T14:13:17+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000502s ] [2024-03-16T14:13:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1%' [ RunTime:0.021439s ] [2024-03-16T14:13:17+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021996s ] [2024-03-16T14:13:18+08:00][sql] CONNECT:[ UseTime:0.010020s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:18+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000726s ] [2024-03-16T14:13:18+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000540s ] [2024-03-16T14:13:18+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000544s ] [2024-03-16T14:13:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W%' [ RunTime:0.022254s ] [2024-03-16T14:13:18+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023429s ] [2024-03-16T14:13:24+08:00][sql] CONNECT:[ UseTime:0.012142s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000707s ] [2024-03-16T14:13:24+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000514s ] [2024-03-16T14:13:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000528s ] [2024-03-16T14:13:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-%' [ RunTime:0.021519s ] [2024-03-16T14:13:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022384s ] [2024-03-16T14:13:26+08:00][sql] CONNECT:[ UseTime:0.005928s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:26+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000686s ] [2024-03-16T14:13:26+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000505s ] [2024-03-16T14:13:26+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000501s ] [2024-03-16T14:13:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S%' [ RunTime:0.020598s ] [2024-03-16T14:13:26+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021962s ] [2024-03-16T14:13:28+08:00][sql] CONNECT:[ UseTime:0.000836s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:28+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000701s ] [2024-03-16T14:13:28+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000511s ] [2024-03-16T14:13:28+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000534s ] [2024-03-16T14:13:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-SO%' [ RunTime:0.021532s ] [2024-03-16T14:13:28+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-SO%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022347s ] [2024-03-16T14:13:29+08:00][sql] CONNECT:[ UseTime:0.003238s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:29+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000741s ] [2024-03-16T14:13:29+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000551s ] [2024-03-16T14:13:29+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000577s ] [2024-03-16T14:13:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-SO=%' [ RunTime:0.021954s ] [2024-03-16T14:13:29+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-SO=%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022955s ] [2024-03-16T14:13:30+08:00][sql] CONNECT:[ UseTime:0.015250s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:30+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000678s ] [2024-03-16T14:13:30+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000512s ] [2024-03-16T14:13:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000508s ] [2024-03-16T14:13:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-SO%' [ RunTime:0.021301s ] [2024-03-16T14:13:30+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-SO%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022107s ] [2024-03-16T14:13:31+08:00][sql] CONNECT:[ UseTime:0.000844s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000694s ] [2024-03-16T14:13:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000497s ] [2024-03-16T14:13:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000500s ] [2024-03-16T14:13:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S%' [ RunTime:0.020849s ] [2024-03-16T14:13:31+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021695s ] [2024-03-16T14:13:31+08:00][sql] CONNECT:[ UseTime:0.000826s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000693s ] [2024-03-16T14:13:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000489s ] [2024-03-16T14:13:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000526s ] [2024-03-16T14:13:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S0%' [ RunTime:0.021479s ] [2024-03-16T14:13:31+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S0%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022311s ] [2024-03-16T14:13:32+08:00][sql] CONNECT:[ UseTime:0.011362s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:32+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000722s ] [2024-03-16T14:13:32+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000516s ] [2024-03-16T14:13:32+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000544s ] [2024-03-16T14:13:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.021495s ] [2024-03-16T14:13:32+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022219s ] [2024-03-16T14:13:41+08:00][sql] CONNECT:[ UseTime:0.006919s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:41+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000675s ] [2024-03-16T14:13:41+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000498s ] [2024-03-16T14:13:41+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000504s ] [2024-03-16T14:13:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.020832s ] [2024-03-16T14:13:41+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021576s ] [2024-03-16T14:13:41+08:00][sql] CONNECT:[ UseTime:0.009703s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:41+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000731s ] [2024-03-16T14:13:41+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000540s ] [2024-03-16T14:13:41+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000551s ] [2024-03-16T14:13:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.022285s ] [2024-03-16T14:13:41+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023205s ] [2024-03-16T14:13:43+08:00][sql] CONNECT:[ UseTime:0.012477s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:43+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000750s ] [2024-03-16T14:13:43+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000537s ] [2024-03-16T14:13:43+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000539s ] [2024-03-16T14:13:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.021402s ] [2024-03-16T14:13:43+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022465s ] [2024-03-16T14:13:43+08:00][sql] CONNECT:[ UseTime:0.013169s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:43+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000703s ] [2024-03-16T14:13:43+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000517s ] [2024-03-16T14:13:43+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000525s ] [2024-03-16T14:13:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.021288s ] [2024-03-16T14:13:43+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021950s ] [2024-03-16T14:13:44+08:00][sql] CONNECT:[ UseTime:0.001236s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:44+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000698s ] [2024-03-16T14:13:44+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000526s ] [2024-03-16T14:13:44+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000524s ] [2024-03-16T14:13:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.021596s ] [2024-03-16T14:13:44+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022523s ] [2024-03-16T14:13:44+08:00][sql] CONNECT:[ UseTime:0.014927s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:44+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000728s ] [2024-03-16T14:13:44+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000509s ] [2024-03-16T14:13:44+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000513s ] [2024-03-16T14:13:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.021516s ] [2024-03-16T14:13:44+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022378s ] [2024-03-16T14:13:45+08:00][sql] CONNECT:[ UseTime:0.006453s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:45+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000728s ] [2024-03-16T14:13:45+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000529s ] [2024-03-16T14:13:45+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000548s ] [2024-03-16T14:13:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.022347s ] [2024-03-16T14:13:45+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023319s ] [2024-03-16T14:13:45+08:00][sql] CONNECT:[ UseTime:0.001114s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:45+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000939s ] [2024-03-16T14:13:45+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000641s ] [2024-03-16T14:13:45+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000611s ] [2024-03-16T14:13:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.023320s ] [2024-03-16T14:13:45+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022436s ] [2024-03-16T14:13:47+08:00][sql] CONNECT:[ UseTime:0.012773s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:47+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000718s ] [2024-03-16T14:13:47+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000505s ] [2024-03-16T14:13:47+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000517s ] [2024-03-16T14:13:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.021400s ] [2024-03-16T14:13:47+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022216s ] [2024-03-16T14:13:47+08:00][sql] CONNECT:[ UseTime:0.015065s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:47+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000744s ] [2024-03-16T14:13:47+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000536s ] [2024-03-16T14:13:47+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000552s ] [2024-03-16T14:13:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.022240s ] [2024-03-16T14:13:47+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023188s ] [2024-03-16T14:13:47+08:00][sql] CONNECT:[ UseTime:0.002960s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:47+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000713s ] [2024-03-16T14:13:47+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000514s ] [2024-03-16T14:13:47+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000538s ] [2024-03-16T14:13:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.022130s ] [2024-03-16T14:13:47+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022840s ] [2024-03-16T14:13:49+08:00][sql] CONNECT:[ UseTime:0.010719s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:49+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000669s ] [2024-03-16T14:13:49+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` = 'YF-BLJC-1LROE I 1W-S04' AND `specs` = '' [ RunTime:0.019213s ] [2024-03-16T14:13:49+08:00][sql] INSERT INTO `product` SET `product_sort` = 368 , `name` = '集中电源集中控制型消防应急标志灯具' , `type` = 'YF-BLJC-1LROE I 1W-S04' , `specs` = '' , `unit` = '个' , `status` = 1 , `remark` = '' , `create_time` = '2024-03-16 14:13:49.526758' , `update_time` = '2024-03-16 14:13:49.526785' [ RunTime:0.020091s ] [2024-03-16T14:13:49+08:00][sql] CONNECT:[ UseTime:0.004607s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:13:49+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000668s ] [2024-03-16T14:13:49+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000523s ] [2024-03-16T14:13:49+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000525s ] [2024-03-16T14:13:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002425s ] [2024-03-16T14:13:49+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.022750s ] [2024-03-16T14:13:49+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000327s ] [2024-03-16T14:14:03+08:00][sql] CONNECT:[ UseTime:0.010919s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:03+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000742s ] [2024-03-16T14:14:03+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000572s ] [2024-03-16T14:14:03+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000565s ] [2024-03-16T14:14:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%y%' OR `specs` LIKE '%y%' OR `name` LIKE '%y%' ) [ RunTime:0.023434s ] [2024-03-16T14:14:03+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%y%' OR `specs` LIKE '%y%' OR `name` LIKE '%y%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.025039s ] [2024-03-16T14:14:03+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000384s ] [2024-03-16T14:14:04+08:00][sql] CONNECT:[ UseTime:0.006256s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:04+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000701s ] [2024-03-16T14:14:04+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000528s ] [2024-03-16T14:14:04+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000547s ] [2024-03-16T14:14:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002491s ] [2024-03-16T14:14:04+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023402s ] [2024-03-16T14:14:04+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000383s ] [2024-03-16T14:14:05+08:00][sql] CONNECT:[ UseTime:0.013413s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:05+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000714s ] [2024-03-16T14:14:05+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000526s ] [2024-03-16T14:14:05+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000523s ] [2024-03-16T14:14:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%Y%' OR `specs` LIKE '%Y%' OR `name` LIKE '%Y%' ) [ RunTime:0.022662s ] [2024-03-16T14:14:05+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%Y%' OR `specs` LIKE '%Y%' OR `name` LIKE '%Y%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.024398s ] [2024-03-16T14:14:05+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000383s ] [2024-03-16T14:14:05+08:00][sql] CONNECT:[ UseTime:0.006222s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:05+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000711s ] [2024-03-16T14:14:05+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000531s ] [2024-03-16T14:14:05+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000556s ] [2024-03-16T14:14:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF%' OR `specs` LIKE '%YF%' OR `name` LIKE '%YF%' ) [ RunTime:0.022951s ] [2024-03-16T14:14:05+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF%' OR `specs` LIKE '%YF%' OR `name` LIKE '%YF%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.024349s ] [2024-03-16T14:14:05+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000380s ] [2024-03-16T14:14:07+08:00][sql] CONNECT:[ UseTime:0.008102s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000729s ] [2024-03-16T14:14:07+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000528s ] [2024-03-16T14:14:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000526s ] [2024-03-16T14:14:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-%' OR `specs` LIKE '%YF-%' OR `name` LIKE '%YF-%' ) [ RunTime:0.022541s ] [2024-03-16T14:14:07+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-%' OR `specs` LIKE '%YF-%' OR `name` LIKE '%YF-%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023564s ] [2024-03-16T14:14:07+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000369s ] [2024-03-16T14:14:08+08:00][sql] CONNECT:[ UseTime:0.000818s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:08+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000667s ] [2024-03-16T14:14:08+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000518s ] [2024-03-16T14:14:08+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000517s ] [2024-03-16T14:14:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-B%' OR `specs` LIKE '%YF-B%' OR `name` LIKE '%YF-B%' ) [ RunTime:0.022423s ] [2024-03-16T14:14:08+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-B%' OR `specs` LIKE '%YF-B%' OR `name` LIKE '%YF-B%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023394s ] [2024-03-16T14:14:08+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000350s ] [2024-03-16T14:14:09+08:00][sql] CONNECT:[ UseTime:0.000845s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000691s ] [2024-03-16T14:14:09+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000501s ] [2024-03-16T14:14:09+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000540s ] [2024-03-16T14:14:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BL%' OR `specs` LIKE '%YF-BL%' OR `name` LIKE '%YF-BL%' ) [ RunTime:0.022442s ] [2024-03-16T14:14:09+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BL%' OR `specs` LIKE '%YF-BL%' OR `name` LIKE '%YF-BL%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023392s ] [2024-03-16T14:14:09+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000337s ] [2024-03-16T14:14:10+08:00][sql] CONNECT:[ UseTime:0.012251s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:10+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000687s ] [2024-03-16T14:14:10+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000517s ] [2024-03-16T14:14:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000515s ] [2024-03-16T14:14:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BLJ%' OR `specs` LIKE '%YF-BLJ%' OR `name` LIKE '%YF-BLJ%' ) [ RunTime:0.022162s ] [2024-03-16T14:14:10+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BLJ%' OR `specs` LIKE '%YF-BLJ%' OR `name` LIKE '%YF-BLJ%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023440s ] [2024-03-16T14:14:10+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000372s ] [2024-03-16T14:14:11+08:00][sql] CONNECT:[ UseTime:0.000832s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:11+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000766s ] [2024-03-16T14:14:11+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000522s ] [2024-03-16T14:14:11+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000529s ] [2024-03-16T14:14:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BLJC%' OR `specs` LIKE '%YF-BLJC%' OR `name` LIKE '%YF-BLJC%' ) [ RunTime:0.022652s ] [2024-03-16T14:14:11+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BLJC%' OR `specs` LIKE '%YF-BLJC%' OR `name` LIKE '%YF-BLJC%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023587s ] [2024-03-16T14:14:11+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000348s ] [2024-03-16T14:14:16+08:00][sql] CONNECT:[ UseTime:0.005495s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:16+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000673s ] [2024-03-16T14:14:16+08:00][sql] SELECT * FROM `product` WHERE `id` = 488381 LIMIT 1 [ RunTime:0.000318s ] [2024-03-16T14:14:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000573s ] [2024-03-16T14:14:16+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000248s ] [2024-03-16T14:14:16+08:00][sql] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000673s ] [2024-03-16T14:14:16+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000506s ] [2024-03-16T14:14:16+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000520s ] [2024-03-16T14:14:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' [ RunTime:0.021289s ] [2024-03-16T14:14:16+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-1LROE I 1W-S04%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022169s ] [2024-03-16T14:14:16+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000401s ] [2024-03-16T14:14:20+08:00][sql] CONNECT:[ UseTime:0.009180s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000672s ] [2024-03-16T14:14:20+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000500s ] [2024-03-16T14:14:20+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000495s ] [2024-03-16T14:14:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BLJC%' OR `specs` LIKE '%YF-BLJC%' OR `name` LIKE '%YF-BLJC%' ) [ RunTime:0.022183s ] [2024-03-16T14:14:20+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND ( `type` LIKE '%YF-BLJC%' OR `specs` LIKE '%YF-BLJC%' OR `name` LIKE '%YF-BLJC%' ) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023550s ] [2024-03-16T14:14:20+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000302s ] [2024-03-16T14:14:43+08:00][sql] CONNECT:[ UseTime:0.005931s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:43+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001506s ] [2024-03-16T14:14:43+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000796s ] [2024-03-16T14:14:44+08:00][sql] CONNECT:[ UseTime:0.000769s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001090s ] [2024-03-16T14:14:44+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('8',family) ) [ RunTime:0.000545s ] [2024-03-16T14:14:44+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.017871s ] [2024-03-16T14:14:44+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) [ RunTime:0.034449s ] [2024-03-16T14:14:44+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002461s ] [2024-03-16T14:14:44+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.000551s ] [2024-03-16T14:14:44+08:00][sql] CONNECT:[ UseTime:0.001684s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:44+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001417s ] [2024-03-16T14:14:44+08:00][sql] SELECT * FROM `raw_sort` [ RunTime:0.000923s ] [2024-03-16T14:14:48+08:00][sql] CONNECT:[ UseTime:0.005507s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:48+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001150s ] [2024-03-16T14:14:48+08:00][sql] SELECT * FROM `raw` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000317s ] [2024-03-16T14:14:48+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000969s ] [2024-03-16T14:14:48+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 450 [ RunTime:0.000249s ] [2024-03-16T14:14:48+08:00][sql] CONNECT:[ UseTime:0.001036s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:48+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001137s ] [2024-03-16T14:14:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `raw` WHERE `type` LIKE '% 0.9mm%' AND `specs` LIKE '%2000*1000%' [ RunTime:0.001401s ] [2024-03-16T14:14:48+08:00][sql] SELECT * FROM `raw` WHERE `type` LIKE '% 0.9mm%' AND `specs` LIKE '%2000*1000%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.001408s ] [2024-03-16T14:14:48+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.000953s ] [2024-03-16T14:14:48+08:00][sql] SELECT * FROM `raw_sort` WHERE `id` = 450 [ RunTime:0.000251s ] [2024-03-16T14:14:50+08:00][sql] CONNECT:[ UseTime:0.010680s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:50+08:00][sql] SHOW FULL COLUMNS FROM `raw_sort` [ RunTime:0.001320s ] [2024-03-16T14:14:50+08:00][sql] SELECT `id` FROM `raw_sort` WHERE ( find_in_set('8',family) ) [ RunTime:0.000545s ] [2024-03-16T14:14:50+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001019s ] [2024-03-16T14:14:50+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) [ RunTime:0.001722s ] [2024-03-16T14:14:50+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.002373s ] [2024-03-16T14:14:50+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.000448s ] [2024-03-16T14:14:54+08:00][sql] CONNECT:[ UseTime:0.012503s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:54+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000783s ] [2024-03-16T14:14:54+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003829s ] [2024-03-16T14:14:54+08:00][sql] CONNECT:[ UseTime:0.008367s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:14:54+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000909s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000283s ] [2024-03-16T14:14:54+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000491s ] [2024-03-16T14:14:54+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001722s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.001052s ] [2024-03-16T14:14:54+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001624s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7274 [ RunTime:0.048316s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7274 AND `status` = 0 [ RunTime:0.011552s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000690s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7275 [ RunTime:0.009695s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7275 AND `status` = 0 [ RunTime:0.011306s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000654s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000173s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000163s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000553s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000146s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000559s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000204s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000540s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000197s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000163s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000531s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000639s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000531s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.009694s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 AND `status` = 0 [ RunTime:0.011373s ] [2024-03-16T14:14:54+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000655s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000222s ] [2024-03-16T14:14:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000157s ] [2024-03-16T14:18:36+08:00][sql] CONNECT:[ UseTime:0.004755s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:18:36+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000756s ] [2024-03-16T14:18:36+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003643s ] [2024-03-16T14:18:36+08:00][sql] CONNECT:[ UseTime:0.009462s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:18:36+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000714s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000236s ] [2024-03-16T14:18:36+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000425s ] [2024-03-16T14:18:36+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001027s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000607s ] [2024-03-16T14:18:36+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000975s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7274 [ RunTime:0.009140s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7274 AND `status` = 0 [ RunTime:0.010716s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000632s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7275 [ RunTime:0.009428s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7275 AND `status` = 0 [ RunTime:0.011142s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000668s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000216s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000200s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000578s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000190s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000190s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000561s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000464s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000184s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000558s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000189s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000190s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000556s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000496s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000185s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000533s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000187s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000182s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000527s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.008957s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 AND `status` = 0 [ RunTime:0.011340s ] [2024-03-16T14:18:36+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000576s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000201s ] [2024-03-16T14:18:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000148s ] [2024-03-16T14:18:50+08:00][sql] CONNECT:[ UseTime:0.012358s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:18:50+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000681s ] [2024-03-16T14:18:50+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003396s ] [2024-03-16T14:18:50+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000831s ] [2024-03-16T14:18:55+08:00][sql] CONNECT:[ UseTime:0.011238s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:18:55+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000780s ] [2024-03-16T14:18:55+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.003828s ] [2024-03-16T14:18:55+08:00][sql] CONNECT:[ UseTime:0.010459s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:18:55+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000873s ] [2024-03-16T14:18:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000236s ] [2024-03-16T14:18:55+08:00][sql] SELECT * FROM `product` ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.226865s ] [2024-03-16T14:18:55+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000783s ] [2024-03-16T14:18:55+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000474s ] [2024-03-16T14:18:58+08:00][sql] CONNECT:[ UseTime:0.002431s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:18:58+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000725s ] [2024-03-16T14:18:58+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('1',family) ) [ RunTime:0.000578s ] [2024-03-16T14:18:58+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000538s ] [2024-03-16T14:18:58+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.224189s ] [2024-03-16T14:18:58+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.265219s ] [2024-03-16T14:18:58+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000528s ] [2024-03-16T14:19:00+08:00][sql] CONNECT:[ UseTime:0.008992s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:00+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000726s ] [2024-03-16T14:19:00+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('3',family) ) [ RunTime:0.000557s ] [2024-03-16T14:19:00+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000512s ] [2024-03-16T14:19:00+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.178398s ] [2024-03-16T14:19:00+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.183767s ] [2024-03-16T14:19:00+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (135,90,132) [ RunTime:0.000426s ] [2024-03-16T14:19:00+08:00][sql] CONNECT:[ UseTime:0.008481s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:00+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000743s ] [2024-03-16T14:19:00+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('3',family) ) [ RunTime:0.000545s ] [2024-03-16T14:19:00+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000563s ] [2024-03-16T14:19:00+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.168385s ] [2024-03-16T14:19:00+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.176332s ] [2024-03-16T14:19:00+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (135,90,132) [ RunTime:0.000413s ] [2024-03-16T14:19:01+08:00][sql] CONNECT:[ UseTime:0.009526s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:01+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000671s ] [2024-03-16T14:19:01+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('3',family) ) [ RunTime:0.000535s ] [2024-03-16T14:19:01+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000514s ] [2024-03-16T14:19:01+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.170874s ] [2024-03-16T14:19:01+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.179253s ] [2024-03-16T14:19:01+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (135,90,132) [ RunTime:0.000428s ] [2024-03-16T14:19:03+08:00][sql] CONNECT:[ UseTime:0.007252s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:03+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000735s ] [2024-03-16T14:19:03+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('3',family) ) [ RunTime:0.000540s ] [2024-03-16T14:19:03+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000544s ] [2024-03-16T14:19:03+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.173214s ] [2024-03-16T14:19:03+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) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.181240s ] [2024-03-16T14:19:03+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (135,90,132) [ RunTime:0.000446s ] [2024-03-16T14:19:05+08:00][sql] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:05+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000642s ] [2024-03-16T14:19:05+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('2',family) ) [ RunTime:0.000490s ] [2024-03-16T14:19:05+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000541s ] [2024-03-16T14:19:05+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.036151s ] [2024-03-16T14:19:05+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.228620s ] [2024-03-16T14:19:05+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (54,49,367,63,69,65,368,369) [ RunTime:0.000422s ] [2024-03-16T14:19:08+08:00][sql] CONNECT:[ UseTime:0.015931s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:08+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000694s ] [2024-03-16T14:19:08+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('12',family) ) [ RunTime:0.000524s ] [2024-03-16T14:19:08+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000510s ] [2024-03-16T14:19:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` IN (12,63,64,65,66,67,69,70,71,73,367,368,369,370,372,379,533) [ RunTime:0.011837s ] [2024-03-16T14:19:08+08:00][sql] SELECT * FROM `product` WHERE `product_sort` IN (12,63,64,65,66,67,69,70,71,73,367,368,369,370,372,379,533) ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.095910s ] [2024-03-16T14:19:08+08:00][sql] SELECT * FROM `product_sort` WHERE `id` IN (367,63,69,65,368,369) [ RunTime:0.000423s ] [2024-03-16T14:19:54+08:00][sql] CONNECT:[ UseTime:0.001238s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:54+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000715s ] [2024-03-16T14:19:54+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000536s ] [2024-03-16T14:19:54+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000547s ] [2024-03-16T14:19:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002482s ] [2024-03-16T14:19:54+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.023499s ] [2024-03-16T14:19:54+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000358s ] [2024-03-16T14:19:56+08:00][sql] CONNECT:[ UseTime:0.003614s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:56+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000726s ] [2024-03-16T14:19:56+08:00][sql] SELECT * FROM `product_sort` WHERE `parent_id` = 368 LIMIT 1 [ RunTime:0.000438s ] [2024-03-16T14:19:56+08:00][sql] CONNECT:[ UseTime:0.015590s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:56+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000688s ] [2024-03-16T14:19:56+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 LIMIT 1 [ RunTime:0.000283s ] [2024-03-16T14:19:57+08:00][sql] CONNECT:[ UseTime:0.007102s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:19:57+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000713s ] [2024-03-16T14:19:57+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000540s ] [2024-03-16T14:19:57+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000512s ] [2024-03-16T14:19:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002533s ] [2024-03-16T14:19:57+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023765s ] [2024-03-16T14:19:57+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000341s ] [2024-03-16T14:20:11+08:00][sql] CONNECT:[ UseTime:0.006939s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:11+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000717s ] [2024-03-16T14:20:11+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000499s ] [2024-03-16T14:20:11+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000500s ] [2024-03-16T14:20:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%Y%' [ RunTime:0.020603s ] [2024-03-16T14:20:11+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%Y%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021631s ] [2024-03-16T14:20:11+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000319s ] [2024-03-16T14:20:12+08:00][sql] CONNECT:[ UseTime:0.000895s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:12+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000676s ] [2024-03-16T14:20:12+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000505s ] [2024-03-16T14:20:12+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000506s ] [2024-03-16T14:20:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF%' [ RunTime:0.020868s ] [2024-03-16T14:20:12+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021862s ] [2024-03-16T14:20:12+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000315s ] [2024-03-16T14:20:14+08:00][sql] CONNECT:[ UseTime:0.015569s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:14+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000673s ] [2024-03-16T14:20:14+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000497s ] [2024-03-16T14:20:14+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000496s ] [2024-03-16T14:20:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-%' [ RunTime:0.020674s ] [2024-03-16T14:20:14+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021706s ] [2024-03-16T14:20:14+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000324s ] [2024-03-16T14:20:15+08:00][sql] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000747s ] [2024-03-16T14:20:15+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000548s ] [2024-03-16T14:20:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000560s ] [2024-03-16T14:20:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-B%' [ RunTime:0.022285s ] [2024-03-16T14:20:15+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023833s ] [2024-03-16T14:20:15+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000401s ] [2024-03-16T14:20:15+08:00][sql] CONNECT:[ UseTime:0.014650s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000663s ] [2024-03-16T14:20:15+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000495s ] [2024-03-16T14:20:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000495s ] [2024-03-16T14:20:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BL%' [ RunTime:0.020810s ] [2024-03-16T14:20:15+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BL%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021930s ] [2024-03-16T14:20:15+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000354s ] [2024-03-16T14:20:16+08:00][sql] CONNECT:[ UseTime:0.012908s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000851s ] [2024-03-16T14:20:16+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000602s ] [2024-03-16T14:20:16+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000612s ] [2024-03-16T14:20:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJ%' [ RunTime:0.021461s ] [2024-03-16T14:20:16+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJ%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023687s ] [2024-03-16T14:20:16+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000392s ] [2024-03-16T14:20:16+08:00][sql] CONNECT:[ UseTime:0.007723s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:16+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000733s ] [2024-03-16T14:20:16+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000539s ] [2024-03-16T14:20:16+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000565s ] [2024-03-16T14:20:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC%' [ RunTime:0.021944s ] [2024-03-16T14:20:16+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023033s ] [2024-03-16T14:20:16+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000354s ] [2024-03-16T14:20:18+08:00][sql] CONNECT:[ UseTime:0.012227s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:18+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000689s ] [2024-03-16T14:20:18+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000507s ] [2024-03-16T14:20:18+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000522s ] [2024-03-16T14:20:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-%' [ RunTime:0.021042s ] [2024-03-16T14:20:18+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022132s ] [2024-03-16T14:20:18+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000339s ] [2024-03-16T14:20:19+08:00][sql] CONNECT:[ UseTime:0.002125s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:19+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000722s ] [2024-03-16T14:20:19+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000529s ] [2024-03-16T14:20:19+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000532s ] [2024-03-16T14:20:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2%' [ RunTime:0.021321s ] [2024-03-16T14:20:19+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022318s ] [2024-03-16T14:20:19+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000319s ] [2024-03-16T14:20:20+08:00][sql] CONNECT:[ UseTime:0.005108s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000685s ] [2024-03-16T14:20:20+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000523s ] [2024-03-16T14:20:20+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000557s ] [2024-03-16T14:20:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2L%' [ RunTime:0.021327s ] [2024-03-16T14:20:20+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2L%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022250s ] [2024-03-16T14:20:20+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000314s ] [2024-03-16T14:20:22+08:00][sql] CONNECT:[ UseTime:0.000928s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000677s ] [2024-03-16T14:20:22+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000498s ] [2024-03-16T14:20:22+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000491s ] [2024-03-16T14:20:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LR%' [ RunTime:0.021010s ] [2024-03-16T14:20:22+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LR%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021820s ] [2024-03-16T14:20:22+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000357s ] [2024-03-16T14:20:22+08:00][sql] CONNECT:[ UseTime:0.004505s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000703s ] [2024-03-16T14:20:22+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000487s ] [2024-03-16T14:20:22+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000499s ] [2024-03-16T14:20:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LRO%' [ RunTime:0.020755s ] [2024-03-16T14:20:22+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LRO%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021636s ] [2024-03-16T14:20:22+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000344s ] [2024-03-16T14:20:22+08:00][sql] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:22+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000735s ] [2024-03-16T14:20:22+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000542s ] [2024-03-16T14:20:22+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000538s ] [2024-03-16T14:20:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE%' [ RunTime:0.022322s ] [2024-03-16T14:20:22+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023413s ] [2024-03-16T14:20:22+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000310s ] [2024-03-16T14:20:24+08:00][sql] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000686s ] [2024-03-16T14:20:24+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000539s ] [2024-03-16T14:20:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000534s ] [2024-03-16T14:20:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE %' [ RunTime:0.021364s ] [2024-03-16T14:20:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE %' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022356s ] [2024-03-16T14:20:24+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000332s ] [2024-03-16T14:20:24+08:00][sql] CONNECT:[ UseTime:0.012338s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000699s ] [2024-03-16T14:20:24+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000533s ] [2024-03-16T14:20:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000555s ] [2024-03-16T14:20:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I%' [ RunTime:0.021478s ] [2024-03-16T14:20:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021932s ] [2024-03-16T14:20:24+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000391s ] [2024-03-16T14:20:25+08:00][sql] CONNECT:[ UseTime:0.003346s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:25+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000741s ] [2024-03-16T14:20:25+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000535s ] [2024-03-16T14:20:25+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000541s ] [2024-03-16T14:20:25+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I %' [ RunTime:0.022593s ] [2024-03-16T14:20:25+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I %' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023484s ] [2024-03-16T14:20:27+08:00][sql] CONNECT:[ UseTime:0.007868s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:27+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000707s ] [2024-03-16T14:20:27+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000545s ] [2024-03-16T14:20:27+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000517s ] [2024-03-16T14:20:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1%' [ RunTime:0.021184s ] [2024-03-16T14:20:27+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021978s ] [2024-03-16T14:20:27+08:00][sql] CONNECT:[ UseTime:0.012225s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:27+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000699s ] [2024-03-16T14:20:27+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000527s ] [2024-03-16T14:20:27+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000516s ] [2024-03-16T14:20:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W%' [ RunTime:0.021825s ] [2024-03-16T14:20:27+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022870s ] [2024-03-16T14:20:29+08:00][sql] CONNECT:[ UseTime:0.006774s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:29+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000744s ] [2024-03-16T14:20:29+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000543s ] [2024-03-16T14:20:29+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000552s ] [2024-03-16T14:20:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-%' [ RunTime:0.022385s ] [2024-03-16T14:20:29+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023343s ] [2024-03-16T14:20:30+08:00][sql] CONNECT:[ UseTime:0.006473s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:30+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000703s ] [2024-03-16T14:20:30+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000521s ] [2024-03-16T14:20:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000507s ] [2024-03-16T14:20:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S%' [ RunTime:0.021141s ] [2024-03-16T14:20:30+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022021s ] [2024-03-16T14:20:31+08:00][sql] CONNECT:[ UseTime:0.001240s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:31+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000695s ] [2024-03-16T14:20:31+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000492s ] [2024-03-16T14:20:31+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000507s ] [2024-03-16T14:20:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S0%' [ RunTime:0.020777s ] [2024-03-16T14:20:31+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S0%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021529s ] [2024-03-16T14:20:32+08:00][sql] CONNECT:[ UseTime:0.007634s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:32+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000723s ] [2024-03-16T14:20:32+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000540s ] [2024-03-16T14:20:32+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000549s ] [2024-03-16T14:20:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S01%' [ RunTime:0.021937s ] [2024-03-16T14:20:32+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S01%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023022s ] [2024-03-16T14:20:36+08:00][sql] CONNECT:[ UseTime:0.013762s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:36+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000655s ] [2024-03-16T14:20:36+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000490s ] [2024-03-16T14:20:36+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000495s ] [2024-03-16T14:20:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S01%' [ RunTime:0.020749s ] [2024-03-16T14:20:36+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S01%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021602s ] [2024-03-16T14:20:37+08:00][sql] CONNECT:[ UseTime:0.000907s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:37+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000737s ] [2024-03-16T14:20:37+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` = 'YF-BLJC-2LROE I 1W-S01' AND `specs` = '' [ RunTime:0.000511s ] [2024-03-16T14:20:37+08:00][sql] INSERT INTO `product` SET `product_sort` = 368 , `name` = '集中电源集中控制型消防应急标志灯具' , `type` = 'YF-BLJC-2LROE I 1W-S01' , `specs` = '' , `unit` = '个' , `status` = 1 , `remark` = '' , `create_time` = '2024-03-16 14:20:37.202480' , `update_time` = '2024-03-16 14:20:37.202505' [ RunTime:0.000902s ] [2024-03-16T14:20:37+08:00][sql] CONNECT:[ UseTime:0.011692s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:20:37+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000743s ] [2024-03-16T14:20:37+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000572s ] [2024-03-16T14:20:37+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000593s ] [2024-03-16T14:20:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002525s ] [2024-03-16T14:20:37+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.022510s ] [2024-03-16T14:20:37+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000334s ] [2024-03-16T14:22:50+08:00][sql] CONNECT:[ UseTime:0.006540s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:22:50+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000679s ] [2024-03-16T14:22:50+08:00][sql] SELECT * FROM `product_sort` WHERE `parent_id` = 368 LIMIT 1 [ RunTime:0.000506s ] [2024-03-16T14:22:51+08:00][sql] CONNECT:[ UseTime:0.001217s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:22:51+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000715s ] [2024-03-16T14:22:51+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 LIMIT 1 [ RunTime:0.000299s ] [2024-03-16T14:22:51+08:00][sql] CONNECT:[ UseTime:0.013967s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:22:51+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000690s ] [2024-03-16T14:22:51+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000516s ] [2024-03-16T14:22:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000553s ] [2024-03-16T14:22:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002459s ] [2024-03-16T14:22:51+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022693s ] [2024-03-16T14:22:51+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000357s ] [2024-03-16T14:23:03+08:00][sql] CONNECT:[ UseTime:0.001257s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:03+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000732s ] [2024-03-16T14:23:03+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000564s ] [2024-03-16T14:23:03+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000585s ] [2024-03-16T14:23:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%Y%' [ RunTime:0.022561s ] [2024-03-16T14:23:03+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%Y%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.024020s ] [2024-03-16T14:23:03+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000399s ] [2024-03-16T14:23:04+08:00][sql] CONNECT:[ UseTime:0.006995s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:04+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000698s ] [2024-03-16T14:23:04+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000525s ] [2024-03-16T14:23:04+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000528s ] [2024-03-16T14:23:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF%' [ RunTime:0.021257s ] [2024-03-16T14:23:04+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022476s ] [2024-03-16T14:23:04+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000348s ] [2024-03-16T14:23:06+08:00][sql] CONNECT:[ UseTime:0.009497s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:06+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000674s ] [2024-03-16T14:23:06+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000486s ] [2024-03-16T14:23:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000542s ] [2024-03-16T14:23:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-%' [ RunTime:0.020909s ] [2024-03-16T14:23:06+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021795s ] [2024-03-16T14:23:06+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000338s ] [2024-03-16T14:23:07+08:00][sql] CONNECT:[ UseTime:0.005524s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000723s ] [2024-03-16T14:23:07+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000549s ] [2024-03-16T14:23:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000551s ] [2024-03-16T14:23:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-B%' [ RunTime:0.022439s ] [2024-03-16T14:23:07+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023533s ] [2024-03-16T14:23:07+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000319s ] [2024-03-16T14:23:07+08:00][sql] CONNECT:[ UseTime:0.002221s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000703s ] [2024-03-16T14:23:07+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000511s ] [2024-03-16T14:23:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000528s ] [2024-03-16T14:23:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BL%' [ RunTime:0.021217s ] [2024-03-16T14:23:07+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BL%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022148s ] [2024-03-16T14:23:07+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000332s ] [2024-03-16T14:23:11+08:00][sql] CONNECT:[ UseTime:0.015557s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:11+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000722s ] [2024-03-16T14:23:11+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000568s ] [2024-03-16T14:23:11+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000553s ] [2024-03-16T14:23:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S01%' [ RunTime:0.021850s ] [2024-03-16T14:23:11+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S01%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023080s ] [2024-03-16T14:23:11+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000403s ] [2024-03-16T14:23:13+08:00][sql] CONNECT:[ UseTime:0.009509s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:13+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000688s ] [2024-03-16T14:23:13+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000533s ] [2024-03-16T14:23:13+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000528s ] [2024-03-16T14:23:13+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S0%' [ RunTime:0.020982s ] [2024-03-16T14:23:13+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S0%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.021907s ] [2024-03-16T14:23:13+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000343s ] [2024-03-16T14:23:14+08:00][sql] CONNECT:[ UseTime:0.012426s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:14+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000809s ] [2024-03-16T14:23:14+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000566s ] [2024-03-16T14:23:14+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000579s ] [2024-03-16T14:23:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S03%' [ RunTime:0.022431s ] [2024-03-16T14:23:14+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S03%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023585s ] [2024-03-16T14:23:27+08:00][sql] CONNECT:[ UseTime:0.008017s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:27+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000720s ] [2024-03-16T14:23:27+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000527s ] [2024-03-16T14:23:27+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000526s ] [2024-03-16T14:23:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S03%' [ RunTime:0.021234s ] [2024-03-16T14:23:27+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE I 1W-S03%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022380s ] [2024-03-16T14:23:28+08:00][sql] CONNECT:[ UseTime:0.005730s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:28+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000708s ] [2024-03-16T14:23:28+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` = 'YF-BLJC-2LROE I 1W-S03' AND `specs` = '' [ RunTime:0.000534s ] [2024-03-16T14:23:28+08:00][sql] INSERT INTO `product` SET `product_sort` = 368 , `name` = '集中电源集中控制型消防应急标志灯具' , `type` = 'YF-BLJC-2LROE I 1W-S03' , `specs` = '' , `unit` = '个' , `status` = 1 , `remark` = '' , `create_time` = '2024-03-16 14:23:28.288855' , `update_time` = '2024-03-16 14:23:28.288880' [ RunTime:0.000913s ] [2024-03-16T14:23:28+08:00][sql] CONNECT:[ UseTime:0.013180s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:23:28+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000686s ] [2024-03-16T14:23:28+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000538s ] [2024-03-16T14:23:28+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000519s ] [2024-03-16T14:23:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002347s ] [2024-03-16T14:23:28+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.021984s ] [2024-03-16T14:23:28+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000324s ] [2024-03-16T14:24:57+08:00][sql] CONNECT:[ UseTime:0.007175s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:24:57+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000694s ] [2024-03-16T14:24:57+08:00][sql] SELECT * FROM `product_sort` WHERE `parent_id` = 368 LIMIT 1 [ RunTime:0.000463s ] [2024-03-16T14:24:57+08:00][sql] CONNECT:[ UseTime:0.005457s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:24:57+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000708s ] [2024-03-16T14:24:57+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 LIMIT 1 [ RunTime:0.000291s ] [2024-03-16T14:24:57+08:00][sql] CONNECT:[ UseTime:0.015269s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:24:57+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000703s ] [2024-03-16T14:24:57+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000518s ] [2024-03-16T14:24:57+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000529s ] [2024-03-16T14:24:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002447s ] [2024-03-16T14:24:57+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022461s ] [2024-03-16T14:24:57+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000336s ] [2024-03-16T14:25:06+08:00][sql] CONNECT:[ UseTime:0.001107s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:25:06+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000685s ] [2024-03-16T14:25:06+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000505s ] [2024-03-16T14:25:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000525s ] [2024-03-16T14:25:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROEII1W-JS5%' [ RunTime:0.021324s ] [2024-03-16T14:25:06+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROEII1W-JS5%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022156s ] [2024-03-16T14:25:06+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000308s ] [2024-03-16T14:25:07+08:00][sql] CONNECT:[ UseTime:0.000906s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:25:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000686s ] [2024-03-16T14:25:07+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000517s ] [2024-03-16T14:25:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000520s ] [2024-03-16T14:25:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE II1W-JS5%' [ RunTime:0.021415s ] [2024-03-16T14:25:07+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE II1W-JS5%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022384s ] [2024-03-16T14:25:08+08:00][sql] CONNECT:[ UseTime:0.009673s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:25:08+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000701s ] [2024-03-16T14:25:08+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000547s ] [2024-03-16T14:25:08+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000546s ] [2024-03-16T14:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE II 1W-JS5%' [ RunTime:0.021406s ] [2024-03-16T14:25:08+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE II 1W-JS5%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.022423s ] [2024-03-16T14:25:12+08:00][sql] CONNECT:[ UseTime:0.012034s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:25:12+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000719s ] [2024-03-16T14:25:12+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000535s ] [2024-03-16T14:25:12+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000543s ] [2024-03-16T14:25:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE II 1W-JS5%' [ RunTime:0.022047s ] [2024-03-16T14:25:12+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` LIKE '%YF-BLJC-2LROE II 1W-JS5%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.023161s ] [2024-03-16T14:25:14+08:00][sql] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:25:14+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000678s ] [2024-03-16T14:25:14+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 AND `type` = 'YF-BLJC-2LROE II 1W-JS5' AND `specs` = '' [ RunTime:0.000509s ] [2024-03-16T14:25:14+08:00][sql] INSERT INTO `product` SET `product_sort` = 368 , `name` = '集中电源集中控制型消防应急标志灯具' , `type` = 'YF-BLJC-2LROE II 1W-JS5' , `specs` = '' , `unit` = '个' , `status` = 1 , `remark` = '' , `create_time` = '2024-03-16 14:25:14.762911' , `update_time` = '2024-03-16 14:25:14.762937' [ RunTime:0.000890s ] [2024-03-16T14:25:15+08:00][sql] CONNECT:[ UseTime:0.011614s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:25:15+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000754s ] [2024-03-16T14:25:15+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('368',family) ) [ RunTime:0.000545s ] [2024-03-16T14:25:15+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000590s ] [2024-03-16T14:25:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002544s ] [2024-03-16T14:25:15+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.024064s ] [2024-03-16T14:25:15+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 368 [ RunTime:0.000357s ] [2024-03-16T14:27:35+08:00][sql] CONNECT:[ UseTime:0.011820s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:35+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000688s ] [2024-03-16T14:27:35+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000552s ] [2024-03-16T14:27:35+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000524s ] [2024-03-16T14:27:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 [ RunTime:0.001413s ] [2024-03-16T14:27:35+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.013119s ] [2024-03-16T14:27:35+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000331s ] [2024-03-16T14:27:40+08:00][sql] CONNECT:[ UseTime:0.002991s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:40+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000736s ] [2024-03-16T14:27:40+08:00][sql] SELECT * FROM `product_sort` WHERE `parent_id` = 367 LIMIT 1 [ RunTime:0.000486s ] [2024-03-16T14:27:40+08:00][sql] CONNECT:[ UseTime:0.000929s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:40+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000743s ] [2024-03-16T14:27:40+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 LIMIT 1 [ RunTime:0.000322s ] [2024-03-16T14:27:40+08:00][sql] CONNECT:[ UseTime:0.007044s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:40+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000692s ] [2024-03-16T14:27:40+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000504s ] [2024-03-16T14:27:40+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000517s ] [2024-03-16T14:27:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 [ RunTime:0.001406s ] [2024-03-16T14:27:40+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012625s ] [2024-03-16T14:27:40+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000336s ] [2024-03-16T14:27:43+08:00][sql] CONNECT:[ UseTime:0.007568s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:43+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000721s ] [2024-03-16T14:27:43+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000540s ] [2024-03-16T14:27:43+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000556s ] [2024-03-16T14:27:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%Y%' [ RunTime:0.012182s ] [2024-03-16T14:27:43+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%Y%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012875s ] [2024-03-16T14:27:43+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000452s ] [2024-03-16T14:27:43+08:00][sql] CONNECT:[ UseTime:0.003594s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:43+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000730s ] [2024-03-16T14:27:43+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000534s ] [2024-03-16T14:27:43+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000525s ] [2024-03-16T14:27:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF%' [ RunTime:0.011929s ] [2024-03-16T14:27:43+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012593s ] [2024-03-16T14:27:43+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000346s ] [2024-03-16T14:27:45+08:00][sql] CONNECT:[ UseTime:0.007243s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:45+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000730s ] [2024-03-16T14:27:45+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000543s ] [2024-03-16T14:27:45+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000546s ] [2024-03-16T14:27:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-%' [ RunTime:0.012515s ] [2024-03-16T14:27:45+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013094s ] [2024-03-16T14:27:45+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000361s ] [2024-03-16T14:27:46+08:00][sql] CONNECT:[ UseTime:0.004069s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:46+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000675s ] [2024-03-16T14:27:46+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000535s ] [2024-03-16T14:27:46+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000552s ] [2024-03-16T14:27:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-B%' [ RunTime:0.012037s ] [2024-03-16T14:27:46+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012520s ] [2024-03-16T14:27:46+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000299s ] [2024-03-16T14:27:46+08:00][sql] CONNECT:[ UseTime:0.004821s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:46+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000742s ] [2024-03-16T14:27:46+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000541s ] [2024-03-16T14:27:46+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000522s ] [2024-03-16T14:27:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BL%' [ RunTime:0.012295s ] [2024-03-16T14:27:46+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BL%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012407s ] [2024-03-16T14:27:46+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000297s ] [2024-03-16T14:27:47+08:00][sql] CONNECT:[ UseTime:0.010956s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:47+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000684s ] [2024-03-16T14:27:47+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000513s ] [2024-03-16T14:27:47+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000526s ] [2024-03-16T14:27:47+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZ%' [ RunTime:0.012289s ] [2024-03-16T14:27:47+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZ%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012755s ] [2024-03-16T14:27:47+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000266s ] [2024-03-16T14:27:48+08:00][sql] CONNECT:[ UseTime:0.009863s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:48+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000725s ] [2024-03-16T14:27:48+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000547s ] [2024-03-16T14:27:48+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000537s ] [2024-03-16T14:27:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZE%' [ RunTime:0.012625s ] [2024-03-16T14:27:48+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZE%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013058s ] [2024-03-16T14:27:48+08:00][sql] CONNECT:[ UseTime:0.000902s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:48+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000665s ] [2024-03-16T14:27:48+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000489s ] [2024-03-16T14:27:48+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000491s ] [2024-03-16T14:27:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZ%' [ RunTime:0.011544s ] [2024-03-16T14:27:48+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZ%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012184s ] [2024-03-16T14:27:48+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000277s ] [2024-03-16T14:27:49+08:00][sql] CONNECT:[ UseTime:0.014642s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:49+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000702s ] [2024-03-16T14:27:49+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000530s ] [2024-03-16T14:27:49+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000489s ] [2024-03-16T14:27:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD%' [ RunTime:0.011627s ] [2024-03-16T14:27:49+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012518s ] [2024-03-16T14:27:49+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000302s ] [2024-03-16T14:27:51+08:00][sql] CONNECT:[ UseTime:0.003765s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:51+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000670s ] [2024-03-16T14:27:51+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000490s ] [2024-03-16T14:27:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000492s ] [2024-03-16T14:27:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-%' [ RunTime:0.011512s ] [2024-03-16T14:27:51+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012099s ] [2024-03-16T14:27:51+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000320s ] [2024-03-16T14:27:52+08:00][sql] CONNECT:[ UseTime:0.015792s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:52+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000716s ] [2024-03-16T14:27:52+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000543s ] [2024-03-16T14:27:52+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000512s ] [2024-03-16T14:27:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1%' [ RunTime:0.012229s ] [2024-03-16T14:27:52+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012434s ] [2024-03-16T14:27:52+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000308s ] [2024-03-16T14:27:53+08:00][sql] CONNECT:[ UseTime:0.015218s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:53+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000707s ] [2024-03-16T14:27:53+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000616s ] [2024-03-16T14:27:53+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000555s ] [2024-03-16T14:27:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1L%' [ RunTime:0.012008s ] [2024-03-16T14:27:53+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1L%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012541s ] [2024-03-16T14:27:53+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000317s ] [2024-03-16T14:27:55+08:00][sql] CONNECT:[ UseTime:0.005209s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:55+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000706s ] [2024-03-16T14:27:55+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000487s ] [2024-03-16T14:27:55+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000487s ] [2024-03-16T14:27:55+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LT%' [ RunTime:0.011562s ] [2024-03-16T14:27:55+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LT%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012231s ] [2024-03-16T14:27:56+08:00][sql] CONNECT:[ UseTime:0.004257s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:56+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000670s ] [2024-03-16T14:27:56+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000490s ] [2024-03-16T14:27:56+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000552s ] [2024-03-16T14:27:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1L%' [ RunTime:0.011697s ] [2024-03-16T14:27:56+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1L%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013229s ] [2024-03-16T14:27:56+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000307s ] [2024-03-16T14:27:56+08:00][sql] CONNECT:[ UseTime:0.012220s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:56+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000689s ] [2024-03-16T14:27:56+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000500s ] [2024-03-16T14:27:56+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000512s ] [2024-03-16T14:27:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LR%' [ RunTime:0.012063s ] [2024-03-16T14:27:56+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LR%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012655s ] [2024-03-16T14:27:56+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000369s ] [2024-03-16T14:27:56+08:00][sql] CONNECT:[ UseTime:0.001357s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:56+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000731s ] [2024-03-16T14:27:56+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000478s ] [2024-03-16T14:27:56+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000546s ] [2024-03-16T14:27:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LRO%' [ RunTime:0.012499s ] [2024-03-16T14:27:56+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LRO%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013039s ] [2024-03-16T14:27:56+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000347s ] [2024-03-16T14:27:57+08:00][sql] CONNECT:[ UseTime:0.012251s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:57+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000713s ] [2024-03-16T14:27:57+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000547s ] [2024-03-16T14:27:57+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000543s ] [2024-03-16T14:27:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE%' [ RunTime:0.012161s ] [2024-03-16T14:27:57+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013307s ] [2024-03-16T14:27:57+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000344s ] [2024-03-16T14:27:58+08:00][sql] CONNECT:[ UseTime:0.010479s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:27:58+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000721s ] [2024-03-16T14:27:58+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000517s ] [2024-03-16T14:27:58+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000509s ] [2024-03-16T14:27:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE %' [ RunTime:0.012067s ] [2024-03-16T14:27:58+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE %' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012318s ] [2024-03-16T14:28:00+08:00][sql] CONNECT:[ UseTime:0.011360s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:00+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000752s ] [2024-03-16T14:28:00+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000529s ] [2024-03-16T14:28:00+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000580s ] [2024-03-16T14:28:00+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I%' [ RunTime:0.012499s ] [2024-03-16T14:28:00+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013011s ] [2024-03-16T14:28:02+08:00][sql] CONNECT:[ UseTime:0.010775s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:02+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000762s ] [2024-03-16T14:28:02+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000532s ] [2024-03-16T14:28:02+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000547s ] [2024-03-16T14:28:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I %' [ RunTime:0.012089s ] [2024-03-16T14:28:02+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I %' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012527s ] [2024-03-16T14:28:03+08:00][sql] CONNECT:[ UseTime:0.003606s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:03+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000704s ] [2024-03-16T14:28:03+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000517s ] [2024-03-16T14:28:03+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000532s ] [2024-03-16T14:28:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2%' [ RunTime:0.012359s ] [2024-03-16T14:28:03+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012883s ] [2024-03-16T14:28:05+08:00][sql] CONNECT:[ UseTime:0.005433s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:05+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000703s ] [2024-03-16T14:28:05+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000523s ] [2024-03-16T14:28:05+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000531s ] [2024-03-16T14:28:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W%' [ RunTime:0.011743s ] [2024-03-16T14:28:05+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012280s ] [2024-03-16T14:28:07+08:00][sql] CONNECT:[ UseTime:0.000912s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:07+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000684s ] [2024-03-16T14:28:07+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000481s ] [2024-03-16T14:28:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000505s ] [2024-03-16T14:28:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-%' [ RunTime:0.011745s ] [2024-03-16T14:28:07+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012271s ] [2024-03-16T14:28:08+08:00][sql] CONNECT:[ UseTime:0.009652s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:08+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000705s ] [2024-03-16T14:28:08+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000533s ] [2024-03-16T14:28:08+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000547s ] [2024-03-16T14:28:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B%' [ RunTime:0.012282s ] [2024-03-16T14:28:08+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012528s ] [2024-03-16T14:28:09+08:00][sql] CONNECT:[ UseTime:0.001912s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:09+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000724s ] [2024-03-16T14:28:09+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000539s ] [2024-03-16T14:28:09+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000552s ] [2024-03-16T14:28:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B0%' [ RunTime:0.012508s ] [2024-03-16T14:28:09+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B0%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013010s ] [2024-03-16T14:28:10+08:00][sql] CONNECT:[ UseTime:0.011875s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000725s ] [2024-03-16T14:28:10+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000540s ] [2024-03-16T14:28:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000542s ] [2024-03-16T14:28:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B02%' [ RunTime:0.012283s ] [2024-03-16T14:28:10+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B02%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012701s ] [2024-03-16T14:28:14+08:00][sql] CONNECT:[ UseTime:0.002830s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:14+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000702s ] [2024-03-16T14:28:14+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` = 'YF-BLZD-1LROE I 2W-B02' AND `specs` = '' [ RunTime:0.000574s ] [2024-03-16T14:28:14+08:00][sql] INSERT INTO `product` SET `product_sort` = 367 , `name` = '消防应急标志灯具' , `type` = 'YF-BLZD-1LROE I 2W-B02' , `specs` = '' , `unit` = '' , `status` = 1 , `remark` = '' , `create_time` = '2024-03-16 14:28:14.102849' , `update_time` = '2024-03-16 14:28:14.102875' [ RunTime:0.001130s ] [2024-03-16T14:28:14+08:00][sql] CONNECT:[ UseTime:0.012669s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:28:14+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000742s ] [2024-03-16T14:28:14+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000541s ] [2024-03-16T14:28:14+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000543s ] [2024-03-16T14:28:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 [ RunTime:0.001473s ] [2024-03-16T14:28:14+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.013500s ] [2024-03-16T14:28:14+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000339s ] [2024-03-16T14:30:20+08:00][sql] CONNECT:[ UseTime:0.012447s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:30:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000735s ] [2024-03-16T14:30:20+08:00][sql] SELECT * FROM `product_sort` WHERE `parent_id` = 367 LIMIT 1 [ RunTime:0.000462s ] [2024-03-16T14:30:20+08:00][sql] CONNECT:[ UseTime:0.002903s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:30:20+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000718s ] [2024-03-16T14:30:20+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 LIMIT 1 [ RunTime:0.000295s ] [2024-03-16T14:30:21+08:00][sql] CONNECT:[ UseTime:0.000845s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:30:21+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000675s ] [2024-03-16T14:30:21+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000502s ] [2024-03-16T14:30:21+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000516s ] [2024-03-16T14:30:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 [ RunTime:0.001403s ] [2024-03-16T14:30:21+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012667s ] [2024-03-16T14:30:21+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000321s ] [2024-03-16T14:30:24+08:00][sql] CONNECT:[ UseTime:0.009558s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:30:24+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000698s ] [2024-03-16T14:30:24+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000494s ] [2024-03-16T14:30:24+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000510s ] [2024-03-16T14:30:24+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B01%' [ RunTime:0.011755s ] [2024-03-16T14:30:24+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B01%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.012258s ] [2024-03-16T14:30:30+08:00][sql] CONNECT:[ UseTime:0.012928s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:30:30+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000715s ] [2024-03-16T14:30:30+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000519s ] [2024-03-16T14:30:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000522s ] [2024-03-16T14:30:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B01%' [ RunTime:0.011706s ] [2024-03-16T14:30:30+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` LIKE '%YF-BLZD-1LROE I 2W-B01%' ORDER BY `id`,`type`,`specs` DESC LIMIT 0,10 [ RunTime:0.013071s ] [2024-03-16T14:30:37+08:00][sql] CONNECT:[ UseTime:0.001343s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:30:37+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000740s ] [2024-03-16T14:30:37+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 AND `type` = 'YF-BLZD-1LROE I 2W-B01' AND `specs` = '' [ RunTime:0.000521s ] [2024-03-16T14:30:37+08:00][sql] INSERT INTO `product` SET `product_sort` = 367 , `name` = '消防应急标志灯具' , `type` = 'YF-BLZD-1LROE I 2W-B01' , `specs` = '' , `unit` = '个' , `status` = 1 , `remark` = '' , `create_time` = '2024-03-16 14:30:37.289242' , `update_time` = '2024-03-16 14:30:37.289266' [ RunTime:0.000501s ] [2024-03-16T14:30:37+08:00][sql] CONNECT:[ UseTime:0.001634s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T14:30:37+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000717s ] [2024-03-16T14:30:37+08:00][sql] SELECT `id` FROM `product_sort` WHERE ( find_in_set('367',family) ) [ RunTime:0.000531s ] [2024-03-16T14:30:37+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000533s ] [2024-03-16T14:30:37+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 367 [ RunTime:0.001451s ] [2024-03-16T14:30:37+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 367 ORDER BY `id`,`type`,`specs` DESC LIMIT 0,50 [ RunTime:0.013244s ] [2024-03-16T14:30:37+08:00][sql] SELECT * FROM `product_sort` WHERE `id` = 367 [ RunTime:0.000322s ] [2024-03-16T20:13:12+08:00][sql] CONNECT:[ UseTime:0.012122s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T20:13:12+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000947s ] [2024-03-16T20:13:12+08:00][sql] SELECT * FROM `product_sort` ORDER BY `order` ASC [ RunTime:0.004443s ] [2024-03-16T20:13:12+08:00][sql] CONNECT:[ UseTime:0.001710s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T20:13:12+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000697s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` [ RunTime:0.000225s ] [2024-03-16T20:13:12+08:00][sql] SELECT * FROM `product` LIMIT 0,10 [ RunTime:0.000410s ] [2024-03-16T20:13:12+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000873s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000942s ] [2024-03-16T20:13:12+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000984s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7274 [ RunTime:0.018716s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7274 AND `status` = 0 [ RunTime:0.021901s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000965s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7275 [ RunTime:0.018791s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7275 AND `status` = 0 [ RunTime:0.017770s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000635s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000201s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000169s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 4 LIMIT 1 [ RunTime:0.000528s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000156s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 5 LIMIT 1 [ RunTime:0.000527s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000158s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000158s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 6 LIMIT 1 [ RunTime:0.000515s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000175s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000149s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 7 LIMIT 1 [ RunTime:0.000506s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000152s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000138s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 8 LIMIT 1 [ RunTime:0.000510s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000147s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000164s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 9 LIMIT 1 [ RunTime:0.000492s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 [ RunTime:0.009317s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 7073 AND `status` = 0 [ RunTime:0.010828s ] [2024-03-16T20:13:12+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 10 LIMIT 1 [ RunTime:0.000612s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000196s ] [2024-03-16T20:13:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-16T20:13:23+08:00][sql] CONNECT:[ UseTime:0.005897s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T20:13:23+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000696s ] [2024-03-16T20:13:23+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000827s ] [2024-03-16T20:13:23+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000822s ] [2024-03-16T20:13:23+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.232499s ] [2024-03-16T20:13:23+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.059203s ] [2024-03-16T20:13:23+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000773s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 248191 LIMIT 1 [ RunTime:0.000610s ] [2024-03-16T20:13:23+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000521s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000202s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000158s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 252916 LIMIT 1 [ RunTime:0.000573s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000154s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000152s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 254172 LIMIT 1 [ RunTime:0.000547s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000143s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256867 LIMIT 1 [ RunTime:0.001421s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000194s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000163s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 256891 LIMIT 1 [ RunTime:0.000539s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000165s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000176s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257200 LIMIT 1 [ RunTime:0.000515s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000171s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000155s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257201 LIMIT 1 [ RunTime:0.000509s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000164s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000141s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257220 LIMIT 1 [ RunTime:0.000532s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000158s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000159s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257221 LIMIT 1 [ RunTime:0.000524s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000162s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000150s ] [2024-03-16T20:13:23+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 257222 LIMIT 1 [ RunTime:0.000517s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000161s ] [2024-03-16T20:13:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000145s ] [2024-03-16T20:13:39+08:00][sql] CONNECT:[ UseTime:0.008243s ] mysql:host=127.0.0.1;port=3306;dbname=ams;charset=utf8 [2024-03-16T20:13:39+08:00][sql] SHOW FULL COLUMNS FROM `product_sort` [ RunTime:0.000726s ] [2024-03-16T20:13:39+08:00][sql] SELECT * FROM `product_sort` [ RunTime:0.000745s ] [2024-03-16T20:13:39+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000820s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `product` WHERE `product_sort` = 368 [ RunTime:0.002535s ] [2024-03-16T20:13:39+08:00][sql] SELECT * FROM `product` WHERE `product_sort` = 368 LIMIT 0,10 [ RunTime:0.000627s ] [2024-03-16T20:13:39+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000538s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 488144 LIMIT 1 [ RunTime:0.000701s ] [2024-03-16T20:13:39+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000527s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000224s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000155s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 488143 LIMIT 1 [ RunTime:0.000620s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6695 [ RunTime:0.009626s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 6695 AND `status` = 0 [ RunTime:0.011057s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 488141 LIMIT 1 [ RunTime:0.000655s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000188s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000160s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 15 LIMIT 1 [ RunTime:0.000355s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2650 [ RunTime:0.009290s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2650 AND `status` = 0 [ RunTime:0.010860s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 16 LIMIT 1 [ RunTime:0.000442s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2651 [ RunTime:0.009282s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2651 AND `status` = 0 [ RunTime:0.010811s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 17 LIMIT 1 [ RunTime:0.000396s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2652 [ RunTime:0.009263s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2652 AND `status` = 0 [ RunTime:0.010796s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 18 LIMIT 1 [ RunTime:0.000408s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2653 [ RunTime:0.009317s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2653 AND `status` = 0 [ RunTime:0.010754s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 19 LIMIT 1 [ RunTime:0.000400s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2654 [ RunTime:0.009507s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2654 AND `status` = 0 [ RunTime:0.011141s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 20 LIMIT 1 [ RunTime:0.000466s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2655 [ RunTime:0.009523s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` = 2655 AND `status` = 0 [ RunTime:0.011143s ] [2024-03-16T20:13:39+08:00][sql] SELECT `id` FROM `bom` WHERE `product` = 21 LIMIT 1 [ RunTime:0.000761s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL [ RunTime:0.000176s ] [2024-03-16T20:13:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `bom_info` WHERE `bom` IS NULL AND `status` = 0 [ RunTime:0.000168s ]