SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027028 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027028 [ RunTime:0.002392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181664,475095,854198,381952,19255,1028456,222070,567611,513529,726590,156348,568767,555782,915824,892984,330484,966429,266581,1045160,473680,829481,390344,824300,285470,115861,346687,501120,809102,1034798,882356,300673,751704,357786,841999,399749,1034603,644042,142971,72239,763254,677060,683429,181645,650846,677999,386149,577538,296246,73303,273745,906035,1028197,541537,944740,402296,583477,99668,284529,1015390,719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]