SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429380 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429380 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669563,835333,251755,244581,825496,720537,216627,897669,383823,733165,692026,702055,189195,998797,83006,553834,823526,786184,6004,818173,240145,599224,575082,1004068,985660,311038,845695,313907,690405,909145,551467,412551,513719,532082,312786,870508,272225,337680,419152,442891,621185,288811,258743,736978,229772,507750,1023043,920284,527363,356981,7556,267746,580900,464890,460460,660522,453958,45296,473826,202829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]