SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028828 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028828 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302669,763354,195119,874537,525754,153007,710446,117121,1037130,869295,972002,734936,815389,253246,556371,425454,967536,493044,550735,673248,6198,833967,4741,758037,573096,109406,531816,404412,727653,551668,305671,216894,295116,313955,383631,123303,35554,591497,413216,954647,82494,27957,402096,53468,3268,424699,926721,12001,702406,670435,552489,181976,45262,1007618,983426,944607,480056,816843,554225,833173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]