SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493011 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493011 [ RunTime:0.002679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544385,296790,86794,535531,632150,649144,956406,511860,492009,131450,928749,603899,364374,298571,235712,270260,888597,349220,1019615,633470,569759,591221,1034267,957729,573959,824541,849380,683455,600146,809276,443093,153452,965037,933241,1032359,566198,158427,592707,214901,898136,297398,751769,53407,849376,336892,816501,272740,418901,882495,140848,301221,681055,893308,628444,114502,572754,706865,590916,870017,804559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002026s ]