SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456541 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456541 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484602,230474,659752,566877,524093,37465,753421,60299,755466,534590,59205,904838,665472,412130,1038963,54858,857886,419970,766032,611065,922840,29209,810313,529203,98914,314437,835971,990488,437760,925966,815768,284135,496898,5940,986236,242217,144850,161629,4767,538538,92827,126748,34891,649219,189378,259453,79237,437187,475446,787669,803324,819707,173216,789425,398882,919466,235949,591015,462198,317583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]