SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001698s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047076 LIMIT 1 [ RunTime:0.000696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047076 [ RunTime:0.002605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993765,648336,398047,764225,284612,379135,254145,915562,342253,615016,524212,915451,344352,476873,501193,678122,197649,532645,222786,789401,943222,275988,223867,1018798,400913,87394,261108,310662,585995,359805,845188,762526,651161,239099,349463,653953,397017,754551,712538,444290,798702,999981,75427,1044185,756161,744848,767538,544500,44756,95206,320463,809660,462246,749659,841881,102505,885974,725621,563612,686724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001040s ]