SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408871 LIMIT 1 [ RunTime:0.006043s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408871 [ RunTime:0.007066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335639,44373,437401,465843,759017,645417,11009,884030,47275,724664,110149,955184,159419,425612,521031,192007,521904,285075,999108,744994,350532,581623,80981,202867,306456,336468,151071,163126,986966,881807,902731,787586,380821,215143,1012327,945172,148683,680675,872925,556102,32708,111185,424064,81135,851351,145952,33461,865384,960351,537258,77746,711155,629684,344806,105178,1034515,1016983,1009255,62839,788392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]