SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809821 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809821 [ RunTime:0.003537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443719,1011646,115458,144011,209796,450217,413667,912752,106182,650288,452594,704347,745256,346793,280580,261744,371742,846575,259368,1023138,568253,870944,234328,938122,724358,330856,358352,608794,191650,212695,881819,804308,605677,914097,887384,586051,7310,70457,684256,722038,814075,1022761,692616,505820,536360,993339,55729,408124,109402,820907,806332,269784,506191,946960,662780,148516,567887,15538,103130,523754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001402s ]