SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97940 LIMIT 1 [ RunTime:0.004304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97940 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28059,214622,803252,478382,1006705,27077,275193,507560,69925,588506,684722,1004579,242187,550543,1025913,827019,933266,476076,989296,105638,856305,441028,339060,1021453,733413,43574,278448,226507,10612,1043549,911692,304430,398432,595817,920441,246923,143297,179795,1045405,40786,46270,699454,127114,491826,502867,55551,804153,23093,1025618,423137,945461,566226,478202,968752,183564,589171,270576,613924,840515,652921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001873s ]