SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268340 LIMIT 1 [ RunTime:0.000938s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268340 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320128,954508,191777,79309,51027,1035618,906354,659902,767918,214876,943233,809943,306539,718067,931203,677665,834797,678786,580917,387661,914845,609404,142424,485621,644467,590209,753584,283161,11733,654495,146890,825525,120859,293141,419872,261036,99301,98835,313571,988552,788884,811050,762169,143771,454108,591152,777416,919569,988930,965601,383639,274584,447018,329590,974729,1030156,683813,808057,720010,178956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]