SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496023 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496023 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200122,149422,940064,1038734,274271,633866,830120,1004221,788220,865103,10715,844455,435059,334576,433976,323531,323779,982391,297838,66275,657231,426241,479867,804579,276767,374146,78932,238440,945842,956327,269445,304166,502233,500530,469606,510756,727969,333936,415100,1025472,156912,136040,311782,485592,66936,65186,561992,157510,908705,1770,306361,623169,147435,318804,506797,439712,517436,767949,462112,666956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]