SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50501 LIMIT 1 [ RunTime:0.001773s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50501 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764087,311221,159006,199996,885574,23836,1006821,807895,448295,68018,428051,646146,532832,499204,585397,18003,1018557,401752,962289,271107,720893,991419,1040751,419073,154773,976777,395990,465689,617555,683432,560753,524695,213656,171524,748129,684472,1029398,450975,300343,343296,465540,751852,507251,261299,591172,780109,623328,79636,383238,282116,438694,507757,479610,583814,522661,81117,503562,830620,455096,113309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.034373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001437s ]