SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806828 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806828 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158238,287352,406911,579332,809089,878477,734604,497706,445519,299756,395062,446018,807351,631635,617802,146697,33665,747350,803474,464368,324988,962563,501836,504068,272478,839870,121419,651615,894447,28865,303904,1041145,294129,560070,501296,791192,893000,833124,72079,520593,295745,367332,691607,23648,105309,902079,274231,443801,716386,236671,52897,430858,389592,371528,97538,967733,397738,146971,176622,312702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]