SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534957 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534957 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705337,557079,964495,509480,69589,75857,893520,879532,315689,715885,316511,618218,905873,10573,54981,100994,630432,1042489,177586,627494,416629,667330,915925,810555,1005725,56160,916529,267759,956623,376022,448090,162583,263992,985668,476011,733474,18358,174800,835941,335720,98808,348750,704815,852172,753312,326030,660094,491784,104550,324507,392592,50605,1037067,986640,697607,1029200,182597,809302,175865,657094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]