SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135991 LIMIT 1 [ RunTime:0.002829s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135991 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403782,351433,204680,241464,973635,948688,643461,48124,375860,218391,280836,140284,628366,1042000,221313,877459,438394,1047795,600303,612699,795907,1032733,433672,989759,734897,315705,442424,1041537,759594,890087,12026,676401,426819,392834,121580,1041074,272508,433021,663667,746207,670883,717098,247109,333000,372981,251320,371411,980920,786248,255623,419800,912585,555579,1023427,749956,1013495,419446,43770,844356,564892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002219s ]