SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38051 LIMIT 1 [ RunTime:0.001009s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38051 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338762,268513,684639,432162,375504,502615,675760,773136,18538,1035383,720363,919159,836834,267283,833218,619159,529139,103957,21857,504816,445548,390385,105838,636837,288442,150524,553176,1002536,792015,16912,273988,714982,44066,557391,921779,587157,747114,193101,196346,213356,744263,538821,673023,218870,445121,52388,1013995,683721,142754,840349,912246,968558,904465,447150,539111,739323,159608,198284,436113,841306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]