SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495813 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495813 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192772,8500,46354,742592,590961,173534,97192,472993,799752,1042483,161790,212217,477972,29937,545942,76837,810883,298016,292590,857474,890128,660260,806612,383345,135991,96859,10071,183605,792004,874238,837544,848072,237040,56178,523982,860611,859055,165347,478934,8143,216590,288920,1008923,110279,986818,968171,621229,500116,303488,824039,634479,837970,501723,46616,157298,618699,333582,154624,726986,555517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]