SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54406 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54406 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387720,381107,985715,513132,556670,549565,855723,816091,203448,715031,289972,163488,123120,77707,249431,911857,43786,934661,704820,991797,283984,957182,307642,834923,107827,1028823,698200,687264,200396,29900,783129,55859,500606,997698,758350,602169,537787,391477,608169,199234,407135,149103,179891,852572,969420,981971,571527,629587,825494,30612,485728,711446,744677,448816,463091,845612,591976,605215,167643,254999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]