SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548021 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548021 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617910,328723,504511,972346,96908,348215,975667,601014,1036115,133676,996075,484800,141167,965486,313296,946916,438090,727563,637024,604403,1019738,203752,751192,1003948,681561,936873,887859,41418,519840,474588,432719,276484,311440,272249,714346,366729,294227,71703,925437,183430,989277,736674,45823,873328,600222,285683,49650,608337,1014875,1048701,994430,726252,216737,108383,702982,474991,586373,147514,610896,297899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]