SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987541 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987541 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502194,389496,287562,48671,63411,646473,598431,878785,848104,685216,334848,308760,4556,862170,74597,597986,131049,609765,100361,939225,347812,331330,935384,208852,1034966,170673,690099,106995,335915,745474,320986,313148,807159,972220,120862,971160,1024874,1004121,823406,57510,981095,967110,605579,153343,461391,731759,551408,460868,980149,393401,1046061,479631,820533,160842,802375,420172,499583,882296,4402,761287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]