SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489083 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489083 [ RunTime:0.003637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268356,116578,1012488,147717,346572,359523,137077,502314,931139,957887,792011,207424,683506,1039190,40869,157663,667189,776550,442328,335344,36645,821598,92437,1044816,642812,202155,278203,211668,166990,269015,1022982,810341,495,758304,50691,618992,235581,714506,544676,852860,145315,718648,154129,899960,716428,472366,893289,466700,362007,630604,352511,207201,523779,352235,361950,831118,373399,387519,1064,538224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]