SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480961 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480961 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469525,952726,426983,983688,685730,1007113,244567,73169,152067,975668,194435,59604,168849,488073,579964,173876,262484,421505,750534,811768,929492,207750,868258,516222,29361,584924,520681,935231,415026,518139,762811,530107,561943,331332,587399,1035143,376455,259536,883679,58099,259246,46096,168818,288455,979812,423183,805420,765109,219493,164064,125037,348734,298210,729301,467983,841934,281576,553349,300718,1032056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]