SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480730 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480730 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197876,497400,1012320,485675,389524,744214,36657,68495,646376,282305,899570,680891,874147,515735,69964,1044212,245231,235688,999230,527677,100409,949614,691327,92310,67724,936716,255676,734390,781573,603943,193851,294685,371450,153407,869432,753747,431356,964707,591659,712406,651386,944681,832774,506881,341856,539928,95716,1033210,707287,877593,761334,616446,788797,659727,966694,699720,873736,41350,705573,949362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]