SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417063 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417063 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718884,153381,955520,531362,919304,125128,613879,450979,836342,1019229,1028008,556622,359724,60185,617786,885375,302791,931638,5877,398181,224001,731675,753085,815685,388041,149852,234532,912503,1002683,157263,142261,539524,1010647,243723,168771,978238,890478,233918,885826,169690,538726,260366,417342,523592,948493,445078,1034236,817346,115697,594356,869281,1033648,1032244,966939,662266,1038813,777206,519329,900291,841916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]