SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201406 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201406 [ RunTime:0.002443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189981,648160,552587,381608,223529,317142,940505,798023,718175,964236,898902,149301,592824,596130,777699,218774,11208,943275,348226,700983,998390,848459,278680,841165,288162,242529,104769,226708,1024587,105973,451161,327057,653110,801569,342728,936082,321970,772136,391331,840675,312058,1039617,465552,527370,811049,341607,936775,202445,591673,134235,834310,201945,150475,775726,153479,64325,5401,994498,289788,534127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]