SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406016 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406016 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758780,284094,548047,357102,791948,328255,149861,813981,20766,236483,500975,7545,713350,418248,746019,556578,433849,691915,52647,112888,398990,757286,1010173,397619,894641,537449,775997,604523,593632,93492,397119,78126,962041,879890,16788,548932,786569,637827,410896,382164,929578,811806,389535,21267,689611,207146,533083,307087,154488,138918,633593,91052,880392,192414,151862,979905,1002207,832112,320662,438967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001449s ]