SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301540 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301540 [ RunTime:0.003572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263427,862335,702007,200696,375408,288741,946741,792956,583341,218661,199704,149451,181512,1046965,17627,731798,1012586,291236,895311,987203,194480,695013,603661,359220,1040982,449971,639796,414594,193728,742661,307661,113973,993987,839178,790456,552659,976474,530188,201672,681290,830780,532267,624077,591635,962903,872375,498411,675867,748310,931938,100197,824914,967817,817914,889591,882136,1024504,700271,376900,364071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]