SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531704 LIMIT 1 [ RunTime:0.003301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531704 [ RunTime:0.005488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655142,726425,405471,758647,406971,128536,832545,592940,1015877,736005,141273,450177,588486,345822,463946,386664,381205,915962,463550,994471,423331,35488,1009649,408931,730196,361753,881223,15829,801001,337891,561418,1044614,21712,891300,900578,170991,447380,92225,675650,664798,1034149,267183,87786,8315,586489,515728,7510,247348,786124,721949,585419,248863,536232,529686,1001710,743390,914289,183306,390617,425216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001939s ]