SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597313 LIMIT 1 [ RunTime:0.001935s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597313 [ RunTime:0.003171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833950,987679,482138,534420,1002331,259192,484918,661032,317764,256401,628068,727291,78330,453938,460322,915187,970984,1000703,874601,486906,616248,355738,628042,339566,235862,880692,1035781,413826,575615,310185,286592,350559,196238,613292,465813,6717,767191,970486,394606,61993,781177,872379,588172,941389,141212,291264,857406,536576,715871,693820,425234,852108,489274,984987,1007344,22105,457538,1042040,324882,637011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]