SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001958s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201158 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201158 [ RunTime:0.002134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748819,858054,841046,198159,248661,717235,375273,266492,728339,1038607,338011,423222,334510,442822,784146,49151,867656,864542,193483,976026,113670,147463,698545,887220,912218,888154,951585,654741,69759,373069,622021,887190,895755,653299,104911,1028074,730408,978755,226970,652487,239474,727517,246041,719029,420944,991238,152013,559430,70054,587904,358763,455248,1040357,736631,179192,803792,271224,450079,408359,456930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]