SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464407 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464407 [ RunTime:0.003611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993742,496878,89644,1007191,929780,684034,677045,1027631,952382,750311,544111,934604,1014800,702651,689088,98736,45953,449791,407810,332422,843421,751117,1025470,309650,2435,466912,183623,966624,686672,641074,191037,884143,685306,633808,920993,577056,858051,880607,1018408,8324,397111,60440,87294,165872,222560,700248,977326,297583,592600,805382,357201,226884,727081,92892,7848,376846,119106,321982,182990,203258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]