SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51641 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51641 [ RunTime:0.003286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515849,751507,822781,51144,294165,407194,412062,794690,800408,637272,839523,499457,827980,387607,316850,544981,821056,58431,418318,326494,890576,29959,136481,518563,908239,128491,996474,232800,26589,614157,926268,186075,443212,458069,450118,764410,859675,60649,661767,646409,718301,584405,47344,194865,669436,900000,124733,759347,909007,197735,52780,288789,389223,865505,255251,759499,850192,167943,706455,32740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]