SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020805 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020805 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703202,644726,846560,491483,448104,825068,851195,674544,858475,973974,700685,962841,560190,85241,624325,683076,907404,660111,1046684,361162,867989,558114,587960,422454,478075,96796,401088,303322,1004372,962745,167117,652465,137573,708866,642455,509422,372551,951660,141355,183160,996530,572830,213686,521913,373295,1044721,303797,859121,27264,654246,1006948,108377,573513,540135,605953,300856,467405,668252,599661,117519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]