SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391983 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391983 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238054,678156,157346,612837,658045,795281,78247,705116,38477,225257,949024,139689,944869,111559,247592,993726,666989,222811,625925,958523,898943,188185,550084,31149,714812,217632,51877,640730,480471,484975,431135,892820,801861,168144,860446,698921,306978,852207,483472,653073,584904,467160,679511,463560,630167,837950,792659,137503,221805,527914,726780,743428,896831,380558,382538,614474,148710,753268,319167,730457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001010s ]