SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012821 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012821 [ RunTime:0.003418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741393,606712,233359,511636,343436,274996,17813,168028,807364,555460,61748,391130,522895,779503,288275,1647,977407,194841,641055,797465,980505,1011391,634665,555221,860999,633498,970234,623082,998203,264199,106453,412007,396946,234550,19066,769085,928901,992376,563587,300694,777202,837048,427979,49347,11786,338922,776698,264568,495538,558458,1022893,726312,809525,96349,439815,87458,996608,209508,514863,306773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]