SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505329 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505329 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008479,574047,340041,995282,909826,653319,955781,286347,801498,89988,35467,821326,677211,705083,234277,140565,135346,180599,57039,414690,647229,462948,35918,815410,343129,821413,525146,882859,301200,945648,339861,993490,435082,1016707,861810,69896,565859,95052,406388,631406,816423,10649,922339,865867,646820,874703,557621,722957,508280,487236,367981,798828,619533,1018795,246256,1032789,719143,939585,142026,333781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]