SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401039 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401039 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78914,427780,844409,908493,633563,854160,983803,870601,235481,271579,186736,397558,696375,200950,495142,932399,267944,912458,828994,3922,409185,158454,162530,753839,29510,802549,726336,859424,852879,788977,351686,134683,997389,243093,795626,446290,419172,97029,186432,90820,226956,23726,390083,958637,843807,872486,569564,805196,983738,817903,59135,414599,662250,113935,21962,770172,112915,578475,674783,610247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]