SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414998 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414998 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008799,90084,179105,270911,1012624,48186,956759,385670,762553,163919,940160,414151,760399,699916,385081,989213,473130,863595,794755,653440,663977,882002,945411,912527,511857,304717,561728,293338,675004,667134,16754,800627,296954,838985,714359,529496,52165,261284,171772,806024,190114,909233,418654,698653,309106,526607,284105,264656,177279,389617,683044,73809,271071,576588,857912,861575,488686,948146,310483,673513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000904s ]