SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349616 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349616 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003339,201803,826873,543988,305642,964103,932639,682388,745754,388709,368784,144064,472493,421877,939804,442825,83220,603309,311080,98953,1041314,780599,355005,117619,845513,859530,322626,537957,691236,504787,931123,189076,311960,651167,58834,438258,806979,473331,407948,867216,744134,61236,400957,133124,89553,678237,462422,441022,591830,960567,153766,154997,777150,799925,236572,263301,315291,854922,237244,274558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002942s ]