SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195415 LIMIT 1 [ RunTime:0.003213s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195415 [ RunTime:0.011592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449376,42359,928455,857478,390089,46983,711706,409190,514148,712319,861009,321243,441503,943222,896893,306835,199640,616024,872844,147513,277905,462474,313350,721590,806435,988564,541733,271637,721951,118712,997464,594456,303616,507585,212351,41353,376466,825766,977924,970315,580104,555971,626619,932706,1023990,639929,136405,768331,713436,944449,362291,41793,1039577,864940,308987,441689,593712,499795,478169,848692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005257s ]