SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399182 LIMIT 1 [ RunTime:0.004596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399182 [ RunTime:0.003560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470840,491858,747638,275188,625710,553505,874056,716391,226349,212891,754377,631305,755647,100098,621742,829788,197291,449690,581786,389636,707192,653408,640804,374831,42905,998733,698534,847820,676229,115448,642047,811809,524308,956733,121666,110126,878193,320776,478057,830022,322707,791006,71310,433434,237741,1045879,1006419,90441,1001682,26937,660431,526267,86193,6859,349241,347845,789394,802387,230634,665890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]