SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305091 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305091 [ RunTime:0.004442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013863,144576,199529,412550,29713,41973,202911,225145,665115,67256,886154,61203,101528,489807,265862,45513,160914,915610,932382,662371,699858,679909,204005,314480,320981,662352,382400,674937,694592,638624,718535,465873,184707,808935,857504,89252,730663,1035568,394683,292867,669802,885898,29892,108387,867118,1002294,35298,881339,195038,437362,46681,408973,296478,72294,687635,767589,774261,372703,210388,365776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]