SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44685 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44685 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609419,794045,477495,207482,974361,150793,847122,528831,985999,574227,684347,303901,829621,13562,4034,778767,891971,1000346,202977,401046,950362,741803,314316,145442,756012,200016,460227,210989,569602,242307,358961,543291,703276,317434,209922,585385,443446,271993,853865,867971,972235,465443,448740,369725,525664,440144,583526,639879,290770,446788,7946,897796,1042131,922188,72051,864383,475596,324651,782414,653885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]