SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505548 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505548 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804869,831591,927032,246572,345029,870330,568261,408495,183191,618705,871041,558138,797019,727366,129808,105518,5187,290707,117231,339150,118797,810960,121153,241383,158195,641808,544067,235135,317388,773596,118609,592421,862555,809726,200486,47048,868034,545683,586480,986156,612841,127593,606421,280195,505642,374694,774474,181354,169289,90770,736448,560625,924461,208581,576770,520024,264771,792783,1025860,68467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]