SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262681 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262681 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242436,44975,104050,422010,277772,995620,598373,102923,351266,664652,551700,695409,105478,520582,228741,146475,107003,782070,994116,502855,816637,385750,947832,875024,661999,475544,187634,740876,133528,871189,918273,507713,707729,178969,378457,605447,825713,990910,567944,96925,924205,882666,648036,1026033,978099,831541,878848,428529,310764,928535,221198,705822,411537,503318,595926,714391,896676,156083,877488,269155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]