SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491810 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491810 [ RunTime:0.002441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239122,880915,102655,431440,394789,527778,253542,74595,266285,938444,795697,515436,865365,889914,495870,269205,42764,420670,550786,655056,592408,106040,69553,1042378,183431,622185,402942,288885,30997,577669,331431,541178,774178,202265,134454,521592,514861,557427,479102,906484,364228,453835,69155,414468,361698,961684,892532,90819,756186,112161,343425,247049,62469,193461,149006,902006,283943,857342,420171,553920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002240s ]