SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380808 LIMIT 1 [ RunTime:0.001509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380808 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533438,462804,328098,815807,425342,46999,946587,378493,147411,506629,283660,969967,483286,133932,383648,93816,654889,493846,571918,697243,537482,27112,800921,882632,626669,35461,710580,636260,238461,812015,101492,456083,457580,970767,396648,893428,435849,443742,418760,1043171,600264,889111,118132,905962,289592,543282,353559,858619,1002315,159214,42725,1047078,812487,1046663,323355,434875,476011,668730,545926,506451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]