SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403668 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403668 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732786,880231,731970,561146,489690,879754,214703,963804,347107,331404,1033595,694034,890288,348529,334694,768543,534059,141551,797194,933383,643732,53860,54053,172566,525033,896696,842460,566978,153516,656591,217705,687229,184295,742761,188135,589057,1033299,172295,1013411,94328,98027,130128,995918,732215,698095,252428,897652,66677,1020656,265336,549414,222189,1007821,680863,683886,777804,746572,509275,132144,759724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001436s ]