SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5068 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5068 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691247,113630,1012162,802383,288013,714524,941491,492446,979243,42632,414468,495482,479913,150149,730902,294876,308979,627191,154633,93613,728463,16243,760533,425314,620438,367972,702067,474156,714607,282477,960606,109842,849357,629523,146238,553005,561386,576519,799013,322016,492948,566689,512823,25346,203392,401339,1020250,847900,945237,681759,75249,9757,598229,296340,414453,719693,965583,483294,613425,586614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001723s ]