SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001777s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195501 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195501 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515273,594567,541471,410704,212510,398731,443295,14695,779244,495464,369653,147531,827560,133475,762866,863961,898632,554751,976084,130519,891337,300903,289753,983436,59402,805314,467163,920701,304627,466309,461823,67432,157077,297507,490140,777224,536813,900122,996837,827134,700382,519587,406836,316135,177463,815719,625258,362924,91254,68445,552306,33303,399377,602859,322191,183941,914408,525199,293415,370060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001233s ]