SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601978 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601978 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475673,298561,22352,80368,466762,497650,749322,661525,859791,722091,529477,347570,836023,917562,893037,704181,328589,464035,614259,400089,659526,479719,234768,801740,416503,339668,1027479,461625,509388,742762,919688,395816,344348,746060,389791,216354,300252,247342,820981,107889,868218,239090,287201,1002799,541475,82226,679072,513564,666760,728786,1047894,691244,966162,950142,28735,751188,633868,10093,606838,511248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]