SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685728 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685728 [ RunTime:0.003269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258185,380694,140502,316470,412801,892007,113479,791909,879422,207412,629453,847857,488114,968591,621897,144034,77677,281914,154303,285678,640111,867041,952414,944687,58507,1041809,449157,405405,112334,20434,444960,336143,960966,1024368,561742,466118,177306,450013,270612,1047924,877525,1037441,422069,363942,1031154,391422,477220,423331,45342,369335,44834,719446,403795,881807,480130,338951,778883,520646,11526,737561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]