SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028531 LIMIT 1 [ RunTime:0.001129s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028531 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191432,436928,810486,586303,224145,931985,972614,530581,315810,506651,862327,738580,313707,587569,183834,875809,782103,12287,725073,419072,609237,213963,358924,390208,159703,1002323,831057,51351,80864,945878,90091,607101,870285,466409,414141,151410,268144,1024489,701948,158271,752221,610533,122794,134857,704736,421381,34581,991145,48648,28807,585611,187498,948106,699006,19401,432213,1010760,287494,735013,995285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]