SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30120 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30120 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414725,341419,893987,14791,835816,1026166,102464,677100,589360,371711,126610,730917,406983,793721,503858,1000199,178367,758752,53776,510236,729431,880006,18179,24419,317872,707069,432143,308457,260313,931852,761593,429153,558347,839729,243746,539615,431660,223382,780367,270192,359330,1039553,425132,120470,942754,716697,43714,69767,860361,710619,974179,885638,885886,413567,189056,1014024,1003846,316450,908848,614719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]