SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 208 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 208 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388496,522120,128133,153521,872328,587645,308960,409425,220884,322100,1032924,610884,19148,303399,798522,741347,823780,408452,892079,441102,171688,1012075,906547,515893,100706,722998,44385,373864,913311,965209,750667,157313,662859,1027664,189270,886671,445301,710867,330995,1041046,513151,575376,423464,375111,621067,1034904,938086,233953,367556,1043984,123093,183024,257310,83979,132443,235466,921431,335416,554148,154107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000749s ]