SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343028 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343028 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104874,479383,997344,925308,873117,692997,946676,634262,1036804,976672,883186,1003941,129480,730513,351013,679532,15433,69412,407815,722067,8276,971981,472458,305790,651807,552530,675335,3451,305267,128163,246723,120724,744247,943686,508191,966682,507026,711684,644397,402297,513151,962530,496777,661350,128571,883765,794696,815563,341487,988241,184722,110937,413523,912570,271271,1003703,11150,55304,15859,391158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]