SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38281 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38281 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247518,619022,362159,197857,873105,304416,1038046,293012,714217,802722,337983,492215,112192,885551,349648,815441,554706,412497,895356,130725,348231,457241,379754,561501,650886,183027,864823,454342,450986,248890,302319,472019,983279,723959,327161,440023,140106,317700,294748,440594,194162,794703,113758,19996,640785,92405,327814,1003756,562614,1046332,140579,487320,138600,840481,226390,1020516,234009,377464,426248,797724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]