SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336009 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336009 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226023,342145,876216,163043,985741,990536,100991,583616,182286,249402,137085,112390,394314,861163,848356,677855,872394,578590,778903,610816,77264,549868,112541,448545,266465,782200,183431,1028579,90810,72870,816331,13784,392147,798351,719100,990836,666696,381659,724244,974669,380869,147206,1000011,857983,850088,210486,245733,378413,916127,265737,895748,858429,91172,409825,212162,232223,614245,846311,131651,828224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002444s ]