SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025848 LIMIT 1 [ RunTime:0.004619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025848 [ RunTime:0.003039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374462,364687,75151,789746,311408,618862,357655,629544,677106,269090,149826,1034522,14058,96279,304827,808063,238245,455955,131349,1012550,324140,128770,985975,490428,404513,430145,698964,152449,662830,366215,79148,943190,35193,922145,344320,923411,171990,451280,227135,764386,118253,183291,73126,993364,512474,372737,1044812,509187,964023,663631,537361,492155,609140,85006,596420,476135,579000,752207,832025,567265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]