SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514445 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514445 [ RunTime:0.001376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99772,160157,302936,623250,910552,100483,728774,568428,442661,542317,480100,1004091,656384,183245,524460,106092,669340,593024,554192,945429,265172,434982,905531,237501,471273,821707,71521,75390,248899,1017792,463376,1044458,375966,149333,500374,334887,13342,85263,281019,35778,980906,877901,185955,259045,157391,860024,1037869,703307,797131,171690,769973,841438,60236,814117,963183,152320,428239,823125,474420,882848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]