SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001995s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201431 LIMIT 1 [ RunTime:0.003309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201431 [ RunTime:0.005046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72538,373780,878487,593274,756986,677065,793981,382515,276936,979516,608827,18083,200737,630962,306718,96855,776320,210224,460491,445023,165703,792646,11557,186976,921138,724923,801656,732623,933807,535666,720330,788927,623477,58430,852117,315703,17075,935189,713981,953713,790923,957002,336123,751944,542752,369426,616065,714325,1015416,280576,326033,572836,796988,192996,114826,268735,40686,479564,428874,612976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]