SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198036 LIMIT 1 [ RunTime:0.001072s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198036 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010085,286741,720765,7495,801271,259663,87717,359061,52374,2315,169846,565565,916994,20402,826262,225609,129095,961130,272781,531798,710093,877070,575193,443949,367970,952264,15941,1009684,512877,305384,468677,170966,339105,872126,437015,506100,476422,930746,840389,276282,939958,454533,234204,362237,865698,482326,641173,850915,994018,337000,426574,660261,443016,307345,733084,396212,402559,858727,191023,138056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]