SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39440 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39440 [ RunTime:0.004042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727149,639489,601650,328933,436651,1032944,389998,158834,814607,420501,36485,96217,959362,147977,413418,340571,608111,247897,662444,452111,59022,541796,639767,181621,132964,411585,16321,954705,231742,751478,821166,24078,304843,758939,970406,885215,89455,870757,799474,147656,918642,536803,306095,246922,120262,605189,687899,93007,492921,952642,256802,844156,633587,955245,544373,233086,96219,92296,441440,867905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]