SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 912003 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 912003 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308185,51809,493286,799588,440593,937505,220438,712838,682754,234757,709007,116567,1012990,481158,151878,524806,591946,795788,754441,151542,291207,203897,957553,485146,139052,188949,334614,669373,553726,70010,573917,690018,644545,934427,29051,274041,332964,860617,12677,469511,179119,1035013,318324,256009,261096,773618,1001683,561275,543304,763977,811967,896053,91284,617205,1019938,624336,62362,43397,234726,184073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 912003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 912003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]