SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013102 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013102 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540110,952666,898427,1000569,734127,328587,665239,455174,471415,843647,460481,935558,401741,318556,753326,653348,231620,591100,142891,387710,653167,53302,811071,941438,400953,321952,526527,468600,239230,1013564,758115,514300,988043,151743,131907,838421,307821,889562,332603,98466,443587,845867,417689,885024,3356,397454,236175,40030,817969,60237,894924,1030668,185336,642742,986940,85087,481192,764091,263255,638518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]