SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51012 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51012 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536602,425810,941035,820860,410817,720879,607716,963344,424249,747196,135879,868410,392990,409865,378695,62251,804543,307716,380256,762539,9226,111788,110549,474132,935496,73940,651729,486936,254036,468810,479254,730985,73689,236109,530194,702931,889745,1009511,101509,783218,652152,551502,926483,560978,628703,831998,991352,744789,289395,790547,284405,313716,232898,538206,623709,278688,375562,859609,341541,384717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]