SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423918 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423918 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322271,18121,634228,283140,952633,603106,341312,79365,1014642,414247,421730,715933,107378,616394,842898,515559,398729,994050,994024,970005,888698,240111,310858,995615,904798,893232,59055,57340,380440,495941,86054,17431,861944,181069,1018899,345129,685878,184748,1021457,594686,553506,1048847,162929,466384,986628,524762,586522,462127,176618,79440,18098,95145,150790,937444,31466,209960,308314,358690,392517,834604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]