SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50774 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50774 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139753,258659,186438,654092,154840,402811,689507,889894,402218,350910,933774,810162,462229,437459,164526,247280,550924,560880,146799,568588,799329,226767,50015,301981,489947,354294,350030,29702,477965,943887,898181,273783,981832,457951,862428,573292,219458,607015,350481,938162,176890,828575,37611,770156,321167,837206,349816,330367,6504,249334,573126,1031213,544817,197258,266804,801687,951569,728313,790261,830608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]