SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019456 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019456 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918212,514849,344049,313507,70207,1014247,220228,660241,855795,566079,998192,234135,118752,123181,323933,813260,451624,281298,181940,496201,405281,266271,849111,620499,941460,140733,288176,814894,745525,696566,415104,615890,590650,343312,633846,979484,20899,182995,996989,419574,59632,84861,97833,415056,744233,928448,565041,820749,134669,987229,139499,890704,748332,1027566,969238,730491,607923,159743,799638,536947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]