SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549827 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549827 [ RunTime:0.002293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279800,578055,714826,888280,490499,553977,822563,465664,288585,760813,410254,829107,900122,680210,170821,766038,961717,746872,1039943,630801,561679,668876,912497,572928,53034,517081,561335,6062,23377,531749,828587,125036,119845,132513,612061,348887,312805,378757,7388,494601,324784,700728,664871,964999,19366,954934,533051,926932,15614,94744,351574,648635,389658,443860,468646,600438,860546,182031,806659,165730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]