SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 728811 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 728811 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421167,290647,695492,105924,576193,730229,96311,150537,964722,595019,784005,966953,648850,498161,152017,1026577,181361,115550,802643,197376,954101,676938,749835,449782,89501,766992,186548,420366,903273,32720,381137,702484,1016031,770578,194857,880075,237249,53847,984776,954925,414514,541586,660036,213323,782626,995079,500947,95470,109098,291812,240721,702831,258697,595639,971914,801268,971423,112602,203864,833474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 728811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 728811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]