SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34901 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34901 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036244,968363,884926,720081,759717,485946,468269,680743,427909,454408,49729,725963,645974,880636,560476,134788,780647,373406,700051,465267,24350,33140,954317,82394,229824,807684,180918,58903,583154,277863,510797,668672,98552,766223,869392,396006,743345,757332,461181,902804,918775,663342,993603,593194,743169,31175,272987,175657,839036,825231,927063,77078,1032352,267007,758325,344308,60307,635694,878971,929782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]