SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 661985 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 661985 [ RunTime:0.003631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045043,915757,141344,1018262,449237,679134,939491,481107,130092,259883,1030384,777879,432879,171252,975062,485294,284978,227619,322215,904250,484578,176290,69999,535294,603222,169854,945421,290730,672773,1010928,61271,197043,193893,53527,262336,173424,995877,326128,985363,431746,465815,685544,223487,651770,660258,466254,929377,531751,53995,75378,212240,234835,189434,542528,1033526,224845,839136,694002,1035985,1042931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 661985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 661985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001207s ]