SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200850 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200850 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785402,438409,332381,256563,108067,396184,723197,643538,165752,1004311,974819,546300,569088,163208,763188,924661,447948,454814,963460,499275,592846,584102,710260,602273,173067,590048,454905,737441,329069,794901,116354,387786,383764,324017,413633,226308,928368,1028537,817975,794655,567892,403401,516148,245396,419831,950236,972437,152946,287725,728127,955059,831915,526813,422403,265027,81163,946871,241242,526394,878346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]